[Smartupload-svn] [107] ユーザ更新Model作成

Back to archive index

svnno****@sourc***** svnno****@sourc*****
2012年 5月 30日 (水) 02:00:23 JST


Revision: 107
          http://sourceforge.jp/projects/smartupload/scm/svn/commits/107
Author:   hryksbt
Date:     2012-05-30 02:00:23 +0900 (Wed, 30 May 2012)
Log Message:
-----------
ユーザ更新Model作成

Modified Paths:
--------------
    trunk/Database/SmartEngineDB.sql
    trunk/Documents/DBテーブル定義(ユーザ管理DB).xlsx
    trunk/src/Engine/app/config/core.php

Added Paths:
-----------
    trunk/src/Engine/app/app_controller.php
    trunk/src/Engine/app/app_helper.php
    trunk/src/Engine/app/app_model.php
    trunk/src/Engine/app/models/user_modify.php
    trunk/src/Engine/app/tests/fixtures/user_modify_fixture.php
    trunk/src/Engine/app/views/pages/home.ctp

-------------- next part --------------
Modified: trunk/Database/SmartEngineDB.sql
===================================================================
--- trunk/Database/SmartEngineDB.sql	2012-05-07 05:55:37 UTC (rev 106)
+++ trunk/Database/SmartEngineDB.sql	2012-05-29 17:00:23 UTC (rev 107)
@@ -1,118 +1,151 @@
--- MySQL dump 10.13  Distrib 5.1.62, for apple-darwin10.3.0 (i386)
---
--- Host: localhost    Database: SmartEngineDB
--- ------------------------------------------------------
--- Server version	5.1.62
-
-/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8 */;
-/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
-/*!40103 SET TIME_ZONE='+00:00' */;
-/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
-/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
-/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `credit_campanies`
---
-
-DROP TABLE IF EXISTS `credit_campanies`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `credit_campanies` (
-  `id` int(11) NOT NULL,
-  `campany_name` varchar(64) NOT NULL,
-  `delete_flag` int(11) NOT NULL,
-  `regist_date` datetime NOT NULL,
-  `modify_date` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `credit_campanies`
---
-
-LOCK TABLES `credit_campanies` WRITE;
-/*!40000 ALTER TABLE `credit_campanies` DISABLE KEYS */;
-/*!40000 ALTER TABLE `credit_campanies` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `new_table`
---
-
-DROP TABLE IF EXISTS `new_table`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `new_table` (
-  `id` int(11) NOT NULL,
-  `country_name` varchar(64) NOT NULL,
-  `delete_flag` int(11) NOT NULL,
-  `regist_date` datetime NOT NULL,
-  `modify_date` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `new_table`
---
-
-LOCK TABLES `new_table` WRITE;
-/*!40000 ALTER TABLE `new_table` DISABLE KEYS */;
-/*!40000 ALTER TABLE `new_table` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `users`
---
-
-DROP TABLE IF EXISTS `users`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `users` (
-  `id` int(11) NOT NULL,
-  `account` varchar(64) NOT NULL,
-  `password` varchar(64) NOT NULL,
-  `name` varchar(64) NOT NULL,
-  `address` varchar(128) NOT NULL,
-  `campany` varchar(64) DEFAULT NULL,
-  `country_id` int(11) NOT NULL,
-  `mail_address` varchar(64) NOT NULL,
-  `delete_flag` int(11) NOT NULL,
-  `accounting_flag` int(11) NOT NULL,
-  `credit_number` int(11) DEFAULT NULL,
-  `credit_expire` datetime DEFAULT NULL,
-  `credit_campany_id` int(11) DEFAULT NULL,
-  `bank_id` int(11) DEFAULT NULL,
-  `bank_account_number` int(11) DEFAULT NULL,
-  `create_date` datetime NOT NULL,
-  `modify_date` datetime DEFAULT NULL,
-  `application_date` datetime NOT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `users`
---
-
-LOCK TABLES `users` WRITE;
-/*!40000 ALTER TABLE `users` DISABLE KEYS */;
-/*!40000 ALTER TABLE `users` ENABLE KEYS */;
-UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2012-05-07  0:13:25
+-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
+--
+-- Host: localhost    Database: SmartEngineDB
+-- ------------------------------------------------------
+-- Server version	5.5.16
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `credit_campanies`
+--
+
+DROP TABLE IF EXISTS `credit_campanies`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `credit_campanies` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `campany_name` varchar(64) NOT NULL,
+  `delete_flag` int(11) NOT NULL,
+  `regist_date` datetime NOT NULL,
+  `modify_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `credit_campanies`
+--
+
+LOCK TABLES `credit_campanies` WRITE;
+/*!40000 ALTER TABLE `credit_campanies` DISABLE KEYS */;
+/*!40000 ALTER TABLE `credit_campanies` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `nationalities`
+--
+
+DROP TABLE IF EXISTS `nationalities`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `nationalities` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `country_name` varchar(64) NOT NULL,
+  `delete_flag` int(11) NOT NULL,
+  `regist_date` datetime NOT NULL,
+  `modify_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `nationalities`
+--
+
+LOCK TABLES `nationalities` WRITE;
+/*!40000 ALTER TABLE `nationalities` DISABLE KEYS */;
+/*!40000 ALTER TABLE `nationalities` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `user_modifies`
+--
+
+DROP TABLE IF EXISTS `user_modifies`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_modifies` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `user_id` int(11) NOT NULL,
+  `password` varchar(64) DEFAULT NULL,
+  `name` varchar(64) DEFAULT NULL,
+  `address` varchar(256) DEFAULT NULL,
+  `country_id` int(11) DEFAULT NULL,
+  `mail_address` varchar(64) DEFAULT NULL,
+  `credit_number` int(11) DEFAULT NULL,
+  `credit_expire` datetime DEFAULT NULL,
+  `credit_id` int(11) DEFAULT NULL,
+  `URL` varchar(128) DEFAULT NULL,
+  `apprication_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `user_modifies`
+--
+
+LOCK TABLES `user_modifies` WRITE;
+/*!40000 ALTER TABLE `user_modifies` DISABLE KEYS */;
+/*!40000 ALTER TABLE `user_modifies` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS `users`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `users` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `account` varchar(64) NOT NULL,
+  `password` varchar(64) NOT NULL,
+  `name` varchar(64) NOT NULL,
+  `address` varchar(128) NOT NULL,
+  `campany` varchar(64) DEFAULT NULL,
+  `country_id` int(11) NOT NULL,
+  `mail_address` varchar(64) NOT NULL,
+  `delete_flag` int(11) NOT NULL,
+  `accounting_flag` int(11) NOT NULL,
+  `credit_number` int(11) DEFAULT NULL,
+  `credit_expire` datetime DEFAULT NULL,
+  `credit_campany_id` int(11) DEFAULT NULL,
+  `bank_id` int(11) DEFAULT NULL,
+  `bank_account_number` int(11) DEFAULT NULL,
+  `create_date` datetime NOT NULL,
+  `modify_date` datetime DEFAULT NULL,
+  `application_date` datetime NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `users`
+--
+
+LOCK TABLES `users` WRITE;
+/*!40000 ALTER TABLE `users` DISABLE KEYS */;
+/*!40000 ALTER TABLE `users` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2012-05-30  2:04:58

Modified: trunk/Documents/DB?\227?\131?\134?\227?\131?\188?\227?\131?\150?\227?\131?\171?\229?\174?\154?\231?\190?\169(?\227?\131?\166?\227?\131?\188?\227?\130?\182?\231?\174?\161?\231?\144?\134DB).xlsx
===================================================================
(Binary files differ)

Added: trunk/src/Engine/app/app_controller.php
===================================================================
--- trunk/src/Engine/app/app_controller.php	                        (rev 0)
+++ trunk/src/Engine/app/app_controller.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,34 @@
+<?php
+/**
+ * Application level Controller
+ *
+ * This file is application-wide controller file. You can put all
+ * application-wide controller-related methods here.
+ *
+ * PHP versions 4 and 5
+ *
+ * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
+ * Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ *
+ * Licensed under The MIT License
+ * Redistributions of files must retain the above copyright notice.
+ *
+ * @copyright     Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ * @link          http://cakephp.org CakePHP(tm) Project
+ * @package       cake
+ * @subpackage    cake.app
+ * @since         CakePHP(tm) v 0.2.9
+ * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
+ */
+
+/**
+ * Application Controller
+ *
+ * Add your application-wide methods in the class below, your controllers
+ * will inherit them.
+ *
+ * @package       cake
+ * @subpackage    cake.app
+ */
+class AppController extends Controller {
+}

Added: trunk/src/Engine/app/app_helper.php
===================================================================
--- trunk/src/Engine/app/app_helper.php	                        (rev 0)
+++ trunk/src/Engine/app/app_helper.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,36 @@
+<?php
+/**
+ * Application level View Helper
+ *
+ * This file is application-wide helper file. You can put all
+ * application-wide helper-related methods here.
+ *
+ * PHP versions 4 and 5
+ *
+ * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
+ * Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ *
+ * Licensed under The MIT License
+ * Redistributions of files must retain the above copyright notice.
+ *
+ * @copyright     Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ * @link          http://cakephp.org CakePHP(tm) Project
+ * @package       cake
+ * @subpackage    cake.cake
+ * @since         CakePHP(tm) v 0.2.9
+ * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
+ */
+App::import('Helper', 'Helper', false);
+
+/**
+ * This is a placeholder class.
+ * Create the same file in app/app_helper.php
+ *
+ * Add your application-wide methods in the class below, your helpers
+ * will inherit them.
+ *
+ * @package       cake
+ * @subpackage    cake.cake
+ */
+class AppHelper extends Helper {
+}

Added: trunk/src/Engine/app/app_model.php
===================================================================
--- trunk/src/Engine/app/app_model.php	                        (rev 0)
+++ trunk/src/Engine/app/app_model.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,34 @@
+<?php
+/**
+ * Application model for Cake.
+ *
+ * This file is application-wide model file. You can put all
+ * application-wide model-related methods here.
+ *
+ * PHP versions 4 and 5
+ *
+ * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
+ * Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ *
+ * Licensed under The MIT License
+ * Redistributions of files must retain the above copyright notice.
+ *
+ * @copyright     Copyright 2005-2012, Cake Software Foundation, Inc. (http://cakefoundation.org)
+ * @link          http://cakephp.org CakePHP(tm) Project
+ * @package       cake
+ * @subpackage    cake.app
+ * @since         CakePHP(tm) v 0.2.9
+ * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
+ */
+
+/**
+ * Application model for Cake.
+ *
+ * Add your application-wide methods in the class below, your models
+ * will inherit them.
+ *
+ * @package       cake
+ * @subpackage    cake.app
+ */
+class AppModel extends Model {
+}

Modified: trunk/src/Engine/app/config/core.php
===================================================================
--- trunk/src/Engine/app/config/core.php	2012-05-07 05:55:37 UTC (rev 106)
+++ trunk/src/Engine/app/config/core.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -201,12 +201,12 @@
 /**
  * A random string used in security hashing methods.
  */
-	Configure::write('Security.salt', '_DYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi');
+	Configure::write('Security.salt', 'b03a457cb957e9551f68f547246bdaa7d89536d6');
 
 /**
  * A random numeric string (digits only) used to encrypt/decrypt strings.
  */
-	Configure::write('Security.cipherSeed', '_76859309657453542496749683645');
+	Configure::write('Security.cipherSeed', '376665646235383030323365386262');
 
 /**
  * Apply timestamps with the last modified time to static assets (js, css, images).

Added: trunk/src/Engine/app/models/user_modify.php
===================================================================
--- trunk/src/Engine/app/models/user_modify.php	                        (rev 0)
+++ trunk/src/Engine/app/models/user_modify.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,122 @@
+<?php
+class UserModify extends AppModel {
+	var $name = 'UserModify';
+	var $displayField = 'name';
+	var $validate = array(
+		'user_id' => array(
+			'numeric' => array(
+				'rule' => array('numeric'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'name' => array(
+			'alphanumeric' => array(
+				'rule' => array('alphanumeric'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'country_id' => array(
+			'numeric' => array(
+				'rule' => array('numeric'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'mail_address' => array(
+			'email' => array(
+				'rule' => array('email'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'credit_number' => array(
+			'cc' => array(
+				'rule' => array('cc'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'credit_expire' => array(
+			'date' => array(
+				'rule' => array('date'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'credit_id' => array(
+			'numeric' => array(
+				'rule' => array('numeric'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'URL' => array(
+			'url' => array(
+				'rule' => array('url'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+		'apprication_date' => array(
+			'date' => array(
+				'rule' => array('date'),
+				//'message' => 'Your custom message here',
+				//'allowEmpty' => false,
+				//'required' => false,
+				//'last' => false, // Stop validation after this rule
+				//'on' => 'create', // Limit validation to 'create' or 'update' operations
+			),
+		),
+	);
+	//The Associations below have been created with all possible keys, those that are not needed can be removed
+
+	var $belongsTo = array(
+		'User' => array(
+			'className' => 'User',
+			'foreignKey' => 'user_id',
+			'conditions' => '',
+			'fields' => '',
+			'order' => ''
+		),
+		'Country' => array(
+			'className' => 'Country',
+			'foreignKey' => 'country_id',
+			'conditions' => '',
+			'fields' => '',
+			'order' => ''
+		),
+		'Credit' => array(
+			'className' => 'Credit',
+			'foreignKey' => 'credit_id',
+			'conditions' => '',
+			'fields' => '',
+			'order' => ''
+		)
+	);
+}

Added: trunk/src/Engine/app/tests/fixtures/user_modify_fixture.php
===================================================================
--- trunk/src/Engine/app/tests/fixtures/user_modify_fixture.php	                        (rev 0)
+++ trunk/src/Engine/app/tests/fixtures/user_modify_fixture.php	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,39 @@
+<?php
+/* UserModify Fixture generated on: 2012-05-29 19:03:03 : 1338310983 */
+class UserModifyFixture extends CakeTestFixture {
+	var $name = 'UserModify';
+
+	var $fields = array(
+		'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+		'user_id' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+		'password' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+		'name' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+		'address' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 256, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+		'country_id' => array('type' => 'integer', 'null' => true, 'default' => NULL),
+		'mail_address' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+		'credit_number' => array('type' => 'integer', 'null' => true, 'default' => NULL),
+		'credit_expire' => array('type' => 'datetime', 'null' => true, 'default' => NULL),
+		'credit_id' => array('type' => 'integer', 'null' => true, 'default' => NULL),
+		'URL' => array('type' => 'string', 'null' => true, 'default' => NULL, 'length' => 128, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+		'apprication_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+		'indexes' => array('PRIMARY' => array('column' => 'id', 'unique' => 1)),
+		'tableParameters' => array('charset' => 'latin1', 'collate' => 'latin1_swedish_ci', 'engine' => 'InnoDB')
+	);
+
+	var $records = array(
+		array(
+			'id' => 1,
+			'user_id' => 1,
+			'password' => 'Lorem ipsum dolor sit amet',
+			'name' => 'Lorem ipsum dolor sit amet',
+			'address' => 'Lorem ipsum dolor sit amet',
+			'country_id' => 1,
+			'mail_address' => 'Lorem ipsum dolor sit amet',
+			'credit_number' => 1,
+			'credit_expire' => '2012-05-29 19:03:03',
+			'credit_id' => 1,
+			'URL' => 'Lorem ipsum dolor sit amet',
+			'apprication_date' => '2012-05-29 19:03:03'
+		),
+	);
+}

Added: trunk/src/Engine/app/views/pages/home.ctp
===================================================================
--- trunk/src/Engine/app/views/pages/home.ctp	                        (rev 0)
+++ trunk/src/Engine/app/views/pages/home.ctp	2012-05-29 17:00:23 UTC (rev 107)
@@ -0,0 +1,101 @@
+
+<iframe src="http://cakephp.org/bake-banner" width="830" height="160" style="overflow:hidden; border:none;">
+	<p>For updates and important announcements, visit http://cakefest.org</p>
+</iframe>
+<h2>Sweet, "App" got Baked by CakePHP!</h2>
+
+<?php
+if (Configure::read() > 0):
+	Debugger::checkSecurityKeys();
+endif;
+?>
+<p>
+<?php
+	if (is_writable(TMP)):
+		echo '<span class="notice success">';
+			__('Your tmp directory is writable.');
+		echo '</span>';
+	else:
+		echo '<span class="notice">';
+			__('Your tmp directory is NOT writable.');
+		echo '</span>';
+	endif;
+?>
+</p>
+<div id="url-rewriting-warning" style="background-color:#e32; color:#fff; padding:3px; margin: 20px 0">
+	<?php __('URL rewriting is not properly configured on your server. '); ?>
+	<ol style="padding-left:20px">
+		<li>
+			<a target="_blank" href="http://book.cakephp.org/view/917/Apache-and-mod_rewrite-and-htaccess" style="color:#fff;">
+				<?php __('Help me configure it')?>
+			</a>
+		</li>
+		<li>
+			<a target="_blank" href="http://book.cakephp.org/view/931/CakePHP-Core-Configuration-Variables" style="color:#fff;">
+				<?php __('I don\'t / can\'t use URL rewriting')?>
+			</a>
+		</li>
+	</ol>
+</div>
+<p>
+<?php
+	$settings = Cache::settings();
+	if (!empty($settings)):
+		echo '<span class="notice success">';
+				printf(__('The %s is being used for caching. To change the config edit APP/config/core.php ', true), '<em>'. $settings['engine'] . 'Engine</em>');
+		echo '</span>';
+	else:
+		echo '<span class="notice">';
+				__('Your cache is NOT working. Please check the settings in APP/config/core.php');
+		echo '</span>';
+	endif;
+?>
+</p>
+<p>
+<?php
+	$filePresent = null;
+	if (file_exists(CONFIGS . 'database.php')):
+		echo '<span class="notice success">';
+			__('Your database configuration file is present.');
+			$filePresent = true;
+		echo '</span>';
+	else:
+		echo '<span class="notice">';
+			__('Your database configuration file is NOT present.');
+			echo '<br/>';
+			__('Rename config/database.php.default to config/database.php');
+		echo '</span>';
+	endif;
+?>
+</p>
+<?php
+if (!empty($filePresent)):
+	if (!class_exists('ConnectionManager')) {
+		require LIBS . 'model' . DS . 'connection_manager.php';
+	}
+	$db = ConnectionManager::getInstance();
+ 	$connected = $db->getDataSource('default');
+?>
+<p>
+<?php
+	if ($connected->isConnected()):
+		echo '<span class="notice success">';
+ 			__('Cake is able to connect to the database.');
+		echo '</span>';
+	else:
+		echo '<span class="notice">';
+			__('Cake is NOT able to connect to the database.');
+		echo '</span>';
+	endif;
+?>
+</p>
+<?php endif;?>
+<h3><?php __('Editing this Page') ?></h3>
+<p>
+<?php
+	printf(__('To change the content of this page, edit: %s
+		To change its layout, edit: %s
+		You can also add some CSS styles for your pages at: %s', true),
+		APP . 'views' . DS . 'pages' . DS . 'home.ctp.<br />',  APP . 'views' . DS . 'layouts' . DS . 'default.ctp.<br />', APP . 'webroot' . DS . 'css');
+?>
+</p>



Smartupload-svn メーリングリストの案内
Back to archive index