1 UP_SQL = """ 2 CREATE TABLE `afe_job_keyvals` ( 3 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, 4 `job_id` integer NOT NULL, 5 INDEX `afe_job_keyvals_job_id` (`job_id`), 6 FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE NO ACTION, 7 `key` varchar(90) NOT NULL, 8 INDEX `afe_job_keyvals_key` (`key`), 9 `value` varchar(300) NOT NULL 10 ) ENGINE=InnoDB; 11 12 CREATE TABLE `tko_job_keyvals` ( 13 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, 14 `job_id` int(10) unsigned NOT NULL, 15 INDEX `tko_job_keyvals_job_id` (`job_id`), 16 FOREIGN KEY (`job_id`) REFERENCES `tko_jobs` (`job_idx`) 17 ON DELETE NO ACTION, 18 `key` varchar(90) NOT NULL, 19 INDEX `tko_job_keyvals_key` (`key`), 20 `value` varchar(300) NOT NULL 21 ) ENGINE=InnoDB; 22 """ 23 24 25 DOWN_SQL = """ 26 DROP TABLE afe_job_keyvals; 27 DROP TABLE tko_job_keyvals; 28 """ 29
