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) 21
