repo.or.cz
/
autotest-zwu.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
blame
|
history
|
raw
|
HEAD
Planner: add migration script to drop planner tables from autotest_web database
[autotest-zwu.git]
/
tko
/
migrations
/
027_user_created_test_attributes.py
blob
05767cbc9908a71fc19e3e17cf11a9cbdf6cd376
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
"""
6
7
DOWN_SQL
=
"""
8
ALTER TABLE test_attributes DROP COLUMN user_created, DROP COLUMN id;
9
"""