KVM test: kvm_config: add helper to raise exception informing line number
[autotest-zwu.git] / frontend / migrations / 043_add_special_task_requested_by.py
blob9cc67ca8c753250493696512745082920ca8ffa6
1 UP_SQL = """
2 ALTER TABLE special_tasks ADD requested_by_id integer;
4 ALTER TABLE special_tasks ADD CONSTRAINT special_tasks_requested_by_id
5 FOREIGN KEY (requested_by_id) REFERENCES users (id) ON DELETE NO ACTION;
6 """
8 DOWN_SQL = """
9 ALTER TABLE special_tasks DROP FOREIGN KEY special_tasks_requested_by_id;
10 ALTER TABLE special_tasks DROP COLUMN requested_by_id;
11 """