svnno****@sourc*****
svnno****@sourc*****
2012年 6月 3日 (日) 22:25:32 JST
Revision: 114
http://sourceforge.jp/projects/smartupload/scm/svn/commits/114
Author: hryksbt
Date: 2012-06-03 22:25:31 +0900 (Sun, 03 Jun 2012)
Log Message:
-----------
モデルを一通り用意
Modified Paths:
--------------
trunk/Documents/DBテーブル定義(ユーザ管理DB).xlsx
Added Paths:
-----------
trunk/src/Engine/app/models/attribute.php
trunk/src/Engine/app/models/bank.php
trunk/src/Engine/app/models/branch.php
trunk/src/Engine/app/models/category.php
trunk/src/Engine/app/tests/cases/models/branch.test.php
trunk/src/Engine/app/tests/fixtures/attribute_fixture.php
trunk/src/Engine/app/tests/fixtures/bank_fixture.php
trunk/src/Engine/app/tests/fixtures/branch_fixture.php
trunk/src/Engine/app/tests/fixtures/category_fixture.php
-------------- next part --------------
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/models/attribute.php
===================================================================
--- trunk/src/Engine/app/models/attribute.php (rev 0)
+++ trunk/src/Engine/app/models/attribute.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,126 @@
+<?php
+class Attribute extends AppModel {
+ var $name = 'Attribute';
+ var $displayField = 'id';
+ var $validate = array(
+ 'id' => array(
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ '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
+ ),
+ ),
+ '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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'attribute' => 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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ 'maxlength' => array(
+ 'rule' => array('maxlength'),
+ //'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
+ ),
+ ),
+ 'delete_flag' => array(
+ 'boolean' => array(
+ 'rule' => array('boolean'),
+ //'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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'regist_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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'modify_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' => ''
+ )
+ );
+}
Added: trunk/src/Engine/app/models/bank.php
===================================================================
--- trunk/src/Engine/app/models/bank.php (rev 0)
+++ trunk/src/Engine/app/models/bank.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,143 @@
+<?php
+class Bank extends AppModel {
+ var $name = 'Bank';
+ var $displayField = 'id';
+ var $validate = array(
+ '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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'bank_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
+ ),
+ 'maxlength' => array(
+ 'rule' => array('maxlength'),
+ //'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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'branch_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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'delete_flag' => array(
+ 'boolean' => array(
+ 'rule' => array('boolean'),
+ //'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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'regist_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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'modify_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(
+ 'Branch' => array(
+ 'className' => 'Branch',
+ 'foreignKey' => 'branch_id',
+ 'conditions' => '',
+ 'fields' => '',
+ 'order' => ''
+ )
+ );
+
+ var $hasMany = array(
+ 'User' => array(
+ 'className' => 'User',
+ 'foreignKey' => 'bank_id',
+ 'dependent' => false,
+ 'conditions' => '',
+ 'fields' => '',
+ 'order' => '',
+ 'limit' => '',
+ 'offset' => '',
+ 'exclusive' => '',
+ 'finderQuery' => '',
+ 'counterQuery' => ''
+ )
+ );
+
+}
Added: trunk/src/Engine/app/models/branch.php
===================================================================
--- trunk/src/Engine/app/models/branch.php (rev 0)
+++ trunk/src/Engine/app/models/branch.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,79 @@
+<?php
+class Branch extends AppModel {
+ var $name = 'Branch';
+ var $displayField = 'id';
+ var $validate = array(
+ 'id' => array(
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ '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
+ ),
+ ),
+ 'branch_name' => array(
+ 'maxlength' => array(
+ 'rule' => array('maxlength'),
+ //'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
+ ),
+ '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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'delete_flag' => array(
+ 'boolean' => array(
+ 'rule' => array('boolean'),
+ //'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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'regist_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
+ ),
+ ),
+ );
+}
Added: trunk/src/Engine/app/models/category.php
===================================================================
--- trunk/src/Engine/app/models/category.php (rev 0)
+++ trunk/src/Engine/app/models/category.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,115 @@
+<?php
+class Category extends AppModel {
+ var $name = 'Category';
+ var $displayField = 'id';
+ var $validate = array(
+ '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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'category_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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ 'maxlength' => array(
+ 'rule' => array('maxlength'),
+ //'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
+ ),
+ ),
+ 'delete_flag' => array(
+ 'boolean' => array(
+ 'rule' => array('boolean'),
+ //'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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'regist_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
+ ),
+ 'notempty' => array(
+ 'rule' => array('notempty'),
+ //'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
+ ),
+ ),
+ 'modify_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 $hasMany = array(
+ 'Content' => array(
+ 'className' => 'Content',
+ 'foreignKey' => 'category_id',
+ 'dependent' => false,
+ 'conditions' => '',
+ 'fields' => '',
+ 'order' => '',
+ 'limit' => '',
+ 'offset' => '',
+ 'exclusive' => '',
+ 'finderQuery' => '',
+ 'counterQuery' => ''
+ )
+ );
+
+}
Added: trunk/src/Engine/app/tests/cases/models/branch.test.php
===================================================================
--- trunk/src/Engine/app/tests/cases/models/branch.test.php (rev 0)
+++ trunk/src/Engine/app/tests/cases/models/branch.test.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,17 @@
+<?php
+/* Branch Test cases generated on: 2012-06-03 14:53:48 : 1338728028*/
+App::import('Model', 'Branch');
+
+class BranchTestCase extends CakeTestCase {
+ var $fixtures = array('app.branch');
+
+ function startTest() {
+ $this->Branch =& ClassRegistry::init('Branch');
+ }
+
+ function endTest() {
+ unset($this->Branch);
+ ClassRegistry::flush();
+ }
+
+}
Added: trunk/src/Engine/app/tests/fixtures/attribute_fixture.php
===================================================================
--- trunk/src/Engine/app/tests/fixtures/attribute_fixture.php (rev 0)
+++ trunk/src/Engine/app/tests/fixtures/attribute_fixture.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,27 @@
+<?php
+/* Attribute Fixture generated on: 2012-06-03 14:47:16 : 1338727636 */
+class AttributeFixture extends CakeTestFixture {
+ var $name = 'Attribute';
+
+ var $fields = array(
+ 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+ 'user_id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+ 'attribute' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+ 'delete_flag' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+ 'regist_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+ 'modify_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+ 'indexes' => array('PRIMARY' => array('column' => 'user_id', 'unique' => 1), 'id' => array('column' => 'id', 'unique' => 1)),
+ 'tableParameters' => array('charset' => 'latin1', 'collate' => 'latin1_swedish_ci', 'engine' => 'InnoDB')
+ );
+
+ var $records = array(
+ array(
+ 'id' => 1,
+ 'user_id' => 1,
+ 'attribute' => 'Lorem ipsum dolor sit amet',
+ 'delete_flag' => 1,
+ 'regist_date' => '2012-06-03 14:47:16',
+ 'modify_date' => '2012-06-03 14:47:16'
+ ),
+ );
+}
Added: trunk/src/Engine/app/tests/fixtures/bank_fixture.php
===================================================================
--- trunk/src/Engine/app/tests/fixtures/bank_fixture.php (rev 0)
+++ trunk/src/Engine/app/tests/fixtures/bank_fixture.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,27 @@
+<?php
+/* Bank Fixture generated on: 2012-06-03 14:49:23 : 1338727763 */
+class BankFixture extends CakeTestFixture {
+ var $name = 'Bank';
+
+ var $fields = array(
+ 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+ 'bank_name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+ 'branch_id' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+ 'delete_flag' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+ 'regist_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+ 'modify_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,
+ 'bank_name' => 'Lorem ipsum dolor sit amet',
+ 'branch_id' => 1,
+ 'delete_flag' => 1,
+ 'regist_date' => '2012-06-03 14:49:23',
+ 'modify_date' => '2012-06-03 14:49:23'
+ ),
+ );
+}
Added: trunk/src/Engine/app/tests/fixtures/branch_fixture.php
===================================================================
--- trunk/src/Engine/app/tests/fixtures/branch_fixture.php (rev 0)
+++ trunk/src/Engine/app/tests/fixtures/branch_fixture.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,25 @@
+<?php
+/* Branch Fixture generated on: 2012-06-03 14:53:48 : 1338728028 */
+class BranchFixture extends CakeTestFixture {
+ var $name = 'Branch';
+
+ var $fields = array(
+ 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+ 'branch_name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 64, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+ 'delete_flag' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+ 'regist_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+ 'modify_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,
+ 'branch_name' => 'Lorem ipsum dolor sit amet',
+ 'delete_flag' => 1,
+ 'regist_date' => '2012-06-03 14:53:48',
+ 'modify_date' => '2012-06-03 14:53:48'
+ ),
+ );
+}
Added: trunk/src/Engine/app/tests/fixtures/category_fixture.php
===================================================================
--- trunk/src/Engine/app/tests/fixtures/category_fixture.php (rev 0)
+++ trunk/src/Engine/app/tests/fixtures/category_fixture.php 2012-06-03 13:25:31 UTC (rev 114)
@@ -0,0 +1,25 @@
+<?php
+/* Category Fixture generated on: 2012-06-03 14:43:05 : 1338727385 */
+class CategoryFixture extends CakeTestFixture {
+ var $name = 'Category';
+
+ var $fields = array(
+ 'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
+ 'category_name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'length' => 128, 'collate' => 'latin1_swedish_ci', 'charset' => 'latin1'),
+ 'delete_flag' => array('type' => 'integer', 'null' => false, 'default' => NULL),
+ 'regist_date' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
+ 'modify_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,
+ 'category_name' => 'Lorem ipsum dolor sit amet',
+ 'delete_flag' => 1,
+ 'regist_date' => '2012-06-03 14:43:05',
+ 'modify_date' => '2012-06-03 14:43:05'
+ ),
+ );
+}