| mbligh | e8819cd | 2008-02-15 16:48:40 +0000 | [diff] [blame] | 1 | def migrate_up(manager): |
| jadmanski | 0afbb63 | 2008-06-06 21:10:57 +0000 | [diff] [blame] | 2 | manager.execute('ALTER TABLE autotests DROP params') |
| 3 | manager.execute('ALTER TABLE jobs DROP kernel_url, DROP status, ' |
| 4 | 'DROP submitted_on') |
| 5 | manager.execute('ALTER TABLE host_queue_entries DROP created_on') |
| mbligh | aa383b7 | 2008-03-12 20:11:56 +0000 | [diff] [blame] | 6 | |
| 7 | def migrate_down(manager): |
| jadmanski | 0afbb63 | 2008-06-06 21:10:57 +0000 | [diff] [blame] | 8 | manager.execute('ALTER TABLE autotests ADD params VARCHAR(255)') |
| 9 | manager.execute('ALTER TABLE jobs ADD kernel_url VARCHAR(255), ' |
| 10 | 'ADD status VARCHAR(255), ADD submitted_on datetime') |
| 11 | manager.execute('ALTER TABLE host_queue_entries ADD created_on ' |
| 12 | 'datetime') |
