tko/migrations/010_add_saved_queries.py

   1 UP_SQL = """
   2 CREATE TABLE `saved_queries` (
   3     `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
   4     `owner` varchar(80) NOT NULL,
   5     `name` varchar(100) NOT NULL,
   6     `url_token` longtext NOT NULL
   7 );
   8
   9 """
  10
  11 DOWN_SQL = """
  12 DROP TABLE IF EXISTS `saved_queries`;
  13 """
  14
  15 def migrate_up(manager):
  16     manager.execute(UP_SQL)
  17
  18
  19 def migrate_down(manager):
  20     manager.execute(DOWN_SQL)