1def migrate_up(manager): 2 manager.execute_script(ADD_COLUMNS) 3 4def migrate_down(manager): 5 manager.execute_script(DROP_COLUMNS) 6 7ADD_COLUMNS = """\ 8DELETE FROM embedded_graphing_queries; 9 10ALTER TABLE embedded_graphing_queries 11DROP COLUMN last_accessed; 12 13ALTER TABLE embedded_graphing_queries 14ADD COLUMN ( 15 last_updated DATETIME NOT NULL, 16 refresh_time DATETIME DEFAULT NULL, 17 cached_png MEDIUMBLOB 18); 19""" 20 21DROP_COLUMNS = """\ 22ALTER TABLE embedded_graphing_queries 23DROP COLUMN last_updated; 24 25ALTER TABLE embedded_graphing_queries 26DROP COLUMN cached_png; 27 28ALTER TABLE embedded_graphing_queries 29DROP COLUMN refresh_time; 30 31ALTER TABLE embedded_graphing_queries 32ADD COLUMN (last_accessed DATETIME NOT NULL); 33""" 34