1UP_SQL = """ 2CREATE 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 12CREATE 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 25DOWN_SQL = """ 26DROP TABLE afe_job_keyvals; 27DROP TABLE tko_job_keyvals; 28""" 29