1def migrate_up(manager):
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')
6
7def migrate_down(manager):
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')
13