1: <?php
2:
3: class CreateTableSchedulingConfigurableShellCalls extends CakeMigration {
4:
5: 6: 7: 8: 9: 10:
11: public $description = '';
12:
13: 14: 15: 16: 17: 18:
19: public $migration = array(
20: 'up' => array(
21: 'create_table' => array(
22: 'scheduling_configurable_shell_calls' => 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: 'created' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
28: 'modified' => array('type' => 'datetime', 'null' => false, 'default' => NULL),
29: 'indexes' => array(
30: 'PRIMARY' => array('column' => 'id', 'unique' => 1),
31: ),
32: 'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'InnoDB'),
33: ),
34: ),
35: ),
36: 'down' => array(
37: 'drop_table' => array(
38: 'scheduling_configurable_shell_calls',
39: )
40: ),
41: );
42:
43: 44: 45: 46: 47: 48: 49:
50: public function before($direction) {
51: return true;
52: }
53:
54: 55: 56: 57: 58: 59: 60:
61: public function after($direction) {
62: return true;
63: }
64:
65: }
66: