| showard | 6f1593c | 2008-07-11 16:56:16 +0000 | [diff] [blame] | 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) | ||||