| showard | c1a98d1 | 2010-01-15 00:22:22 +0000 | [diff] [blame] | 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 | """ |