blob: cd7cd5c6bbdf6ee363ee2cad072f31e34d2c74dc [file] [log] [blame] [edit]
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)