• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1def migrate_up(manager):
2    manager.execute('ALTER TABLE jobs ADD run_verify tinyint(1) default 1')
3    manager.execute('ALTER TABLE autotests ADD author VARCHAR(256)')
4    manager.execute('ALTER TABLE autotests ADD dependencies VARCHAR(256)')
5    manager.execute('ALTER TABLE autotests ADD experimental SMALLINT DEFAULT 0')
6    manager.execute('ALTER TABLE autotests ADD run_verify SMALLINT DEFAULT 1')
7    manager.execute('ALTER TABLE autotests ADD test_time SMALLINT DEFAULT 1')
8    manager.execute('ALTER TABLE autotests ADD test_category VARCHAR(256)')
9    manager.execute('ALTER TABLE autotests ADD sync_count INT(11) DEFAULT 1')
10
11
12def migrate_down(manager):
13    manager.execute('ALTER TABLE jobs DROP run_verify')
14    manager.execute('ALTER TABLE autotests DROP sync_count')
15    manager.execute('ALTER TABLE autotests DROP author')
16    manager.execute('ALTER TABLE autotests DROP dependencies')
17    manager.execute('ALTER TABLE autotests DROP experimental')
18    manager.execute('ALTER TABLE autotests DROP run_verify')
19    manager.execute('ALTER TABLE autotests DROP test_time')
20    manager.execute('ALTER TABLE autotests DROP test_category')
21