1: <?php
 2: 
 3: class CreateTableConfigurationKeys extends CakeMigration {
 4: 
 5:     /**
 6:      * Migration description
 7:      *
 8:      * @var string
 9:      * @access public
10:      */
11:     public $description = '';
12: 
13:     /**
14:      * Actions to be performed
15:      *
16:      * @var array $migration
17:      * @access public
18:      */
19:     public $migration = array(
20:         'up' => array(
21:             'create_table' => array(
22:                 'configuration_keys' => array(
23:                     'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
24:                     'name' => array('type' => 'string', 'null' => true, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8', 'key' => 'primary'),
25:                     'description' => array('type' => 'string', 'null' => true, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
26:                     'default_value' => array('type' => 'string', 'null' => true, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
27:                     'setted_value' => array('type' => 'string', 'null' => true, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
28:                     'current_value' => array('type' => 'string', 'null' => true, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
29:                     'setted' => array('type' => 'boolean', 'null' => true, 'default' => NULL),
30:                     'indexes' => array(
31:                         'PRIMARY' => array('column' => 'id', 'unique' => 1),
32:                         'name' => array('column' => 'name', 'unique' => 0),
33:                     ),
34:                     'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'InnoDB'),
35:                 ),
36:             ),
37:         ),
38:         'down' => array(
39:             'drop_table' => array(
40:                 'configuration_keys',
41:             ),
42:         ),
43:     );
44: 
45:     /**
46:      * Before migration callback
47:      *
48:      * @param string $direction, up or down direction of migration process
49:      * @return boolean Should process continue
50:      * @access public
51:      */
52:     public function before($direction) {
53:         return true;
54:     }
55: 
56:     /**
57:      * After migration callback
58:      *
59:      * @param string $direction, up or down direction of migration process
60:      * @return boolean Should process continue
61:      * @access public
62:      */
63:     public function after($direction) {
64:         return true;
65:     }
66: 
67: }
68: