Planner: add migration script to drop planner tables from autotest_web database
[autotest-zwu.git] / tko / migrations / 027_user_created_test_attributes.py
blob05767cbc9908a71fc19e3e17cf11a9cbdf6cd376
1 UP_SQL = """
2 ALTER TABLE test_attributes
3 ADD COLUMN id integer NOT NULL AUTO_INCREMENT PRIMARY KEY,
4 ADD COLUMN user_created bool NOT NULL DEFAULT FALSE;
5 """
7 DOWN_SQL = """
8 ALTER TABLE test_attributes DROP COLUMN user_created, DROP COLUMN id;
9 """