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;
"""