summaryrefslogtreecommitdiff
path: root/tko/migrations/006_add_table_query_history.py
blob: 54b514da3e638ac131b18741bc0d451b531bac0d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
def migrate_up(manager):
	manager.execute_script(ADD_TABLE_QUERY_HISTORY)


def migrate_down(manager):
	manager.execute_script(DROP_TABLE_QUERY_HISTORY)


ADD_TABLE_QUERY_HISTORY = """
CREATE TABLE IF NOT EXISTS query_history
(uid VARCHAR(32), time_created VARCHAR(32), user_comment VARCHAR(256),
url VARCHAR(65534));
"""

DROP_TABLE_QUERY_HISTORY = """
DROP TABLE query_history;
"""