1 UP_SQL = """
2 ALTER TABLE special_tasks
3 ADD COLUMN success TINYINT(1)
4 NOT NULL DEFAULT 0;
5
6 UPDATE special_tasks
7 SET success = 1
8 WHERE is_complete = 1;
9 """
10
11 DOWN_SQL = """
12 ALTER TABLE special_tasks
13 DROP COLUMN success;
14 """
15