1: <?php
 2: 
 3: class CreateTableSettedConfigurationKeys 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:                 'setted_configuration_keys' => array(
23:                     'id' => array('type' => 'integer', 'null' => false, 'default' => NULL, 'key' => 'primary'),
24:                     'name' => array('type' => 'string', 'null' => false, 'default' => NULL, 'key' => 'primary', 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
25:                     'value' => array('type' => 'string', 'null' => false, 'default' => NULL, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
26:                     'indexes' => array(
27:                         'PRIMARY' => array('column' => 'id', 'unique' => 1),
28:                     ),
29:                     'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'InnoDB'),
30:                 ),
31:             )
32:         ),
33:         'down' => array(
34:             'drop_table' => array(
35:                 'setted_configuration_keys'
36:             )
37:         ),
38:     );
39: 
40:     /**
41:      * Before migration callback
42:      *
43:      * @param string $direction, up or down direction of migration process
44:      * @return boolean Should process continue
45:      * @access public
46:      */
47:     public function before($direction) {
48:         return true;
49:     }
50: 
51:     /**
52:      * After migration callback
53:      *
54:      * @param string $direction, up or down direction of migration process
55:      * @return boolean Should process continue
56:      * @access public
57:      */
58:     public function after($direction) {
59:         return true;
60:     }
61: 
62: }
63: