summaryrefslogtreecommitdiff
path: root/tko/migrations/006_add_table_query_history.py
blob: 41c5e29d897b792cc7e1198434fe11dd34380d03 (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(1000));
"""

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