xref: /aosp_15_r20/external/autotest/tko/migrations/010_add_saved_queries.py (revision 9c5db1993ded3edbeafc8092d69fe5de2ee02df7)
1UP_SQL = """
2CREATE 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
11DOWN_SQL = """
12DROP TABLE IF EXISTS `saved_queries`;
13"""
14
15def migrate_up(manager):
16    manager.execute(UP_SQL)
17
18
19def migrate_down(manager):
20    manager.execute(DOWN_SQL)
21