tko/migrations/006_add_table_query_history.py

   1 def migrate_up(manager):
   2     manager.execute_script(ADD_TABLE_QUERY_HISTORY)
   3
   4
   5 def migrate_down(manager):
   6     manager.execute_script(DROP_TABLE_QUERY_HISTORY)
   7
   8
   9 ADD_TABLE_QUERY_HISTORY = """
  10 CREATE TABLE IF NOT EXISTS query_history
  11 (uid VARCHAR(32), time_created VARCHAR(32), user_comment VARCHAR(256),
  12 url VARCHAR(1000));
  13 """
  14
  15 DROP_TABLE_QUERY_HISTORY = """
  16 DROP TABLE query_history;
  17 """