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