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