20 lines
432 B
Python
20 lines
432 B
Python
UP_SQL = """
|
|
ALTER TABLE users ADD COLUMN `reboot_before` smallint NOT NULL;
|
|
ALTER TABLE users ADD COLUMN `reboot_after` smallint NOT NULL;
|
|
UPDATE users SET reboot_before=1, reboot_after=2;
|
|
"""
|
|
|
|
|
|
DOWN_SQL = """
|
|
ALTER TABLE users DROP COLUMN reboot_before;
|
|
ALTER TABLE users DROP COLUMN reboot_after;
|
|
"""
|
|
|
|
|
|
def migrate_up(manager):
|
|
manager.execute_script(UP_SQL)
|
|
|
|
|
|
def migrate_down(manager):
|
|
manager.execute_script(DOWN_SQL)
|