Missed 2 migrations... Signed-off-by: James Ren <[email protected]>
--- /dev/null 2009-12-17 12:29:38.000000000 -0800 +++ autotest/frontend/migrations/050_more_test_planner_additions.py 2010-03-09 14:59:42.000000000 -0800 @@ -0,0 +1,13 @@ +UP_SQL = """ +ALTER TABLE `planner_test_runs` ADD CONSTRAINT `test_runs_unique` UNIQUE KEY (`plan_id`, `test_job_id`, `tko_test_id`, `host_id`); + +ALTER TABLE `planner_tests` ADD COLUMN `is_server` tinyint(1) DEFAULT 1; + +ALTER TABLE `planner_hosts` ADD COLUMN `added_by_label` tinyint(1) DEFAULT 0; +""" + +DOWN_SQL = """ +ALTER TABLE `planner_hosts` DROP COLUMN `added_by_label`; +ALTER TABLE `planner_tests` DROP COLUMN `is_server`; +ALTER TABLE `planner_test_runs` DROP KEY `test_runs_unique`; +""" --- /dev/null 2009-12-17 12:29:38.000000000 -0800 +++ autotest/frontend/migrations/051_rename_planner_tests.py 2010-03-09 14:59:42.000000000 -0800 @@ -0,0 +1,27 @@ +UP_SQL = """ +ALTER TABLE `planner_tests` RENAME TO `planner_test_configs`; + +ALTER TABLE `planner_test_jobs` DROP FOREIGN KEY `test_jobs_test_id_fk`; +ALTER TABLE `planner_test_jobs` DROP KEY `planner_test_jobs_test_id`; + +ALTER TABLE `planner_test_jobs` CHANGE COLUMN +`test_id` `test_config_id` INT NOT NULL; + +ALTER TABLE `planner_test_jobs` ADD CONSTRAINT `test_jobs_test_config_id_fk` +FOREIGN KEY `planner_test_jobs_test_config_id` +(`test_config_id`) REFERENCES `planner_test_configs` (`id`); +""" + +DOWN_SQL = """ +ALTER TABLE `planner_test_configs` RENAME TO `planner_tests`; + +ALTER TABLE `planner_test_jobs` DROP FOREIGN KEY `test_jobs_test_config_id_fk`; +ALTER TABLE `planner_test_jobs` DROP KEY `planner_test_jobs_test_config_id`; + +ALTER TABLE `planner_test_jobs` CHANGE COLUMN +`test_config_id` `test_id` INT NOT NULL; + +ALTER TABLE `planner_test_jobs` ADD CONSTRAINT `test_jobs_test_id_fk` +FOREIGN KEY `planner_test_jobs_test_id` +(`test_id`) REFERENCES `planner_tests` (`id`); +""" _______________________________________________ Autotest mailing list [email protected] http://test.kernel.org/cgi-bin/mailman/listinfo/autotest
