普通文本  |  12行  |  374 B

UP_SQL = """
ALTER TABLE special_tasks ADD requested_by_id integer;

ALTER TABLE special_tasks ADD CONSTRAINT special_tasks_requested_by_id
        FOREIGN KEY (requested_by_id) REFERENCES users (id) ON DELETE NO ACTION;
"""

DOWN_SQL = """
ALTER TABLE special_tasks DROP FOREIGN KEY special_tasks_requested_by_id;
ALTER TABLE special_tasks DROP COLUMN requested_by_id;
"""