• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1UP_SQL = """
2ALTER TABLE special_tasks ADD requested_by_id integer;
3
4ALTER TABLE special_tasks ADD CONSTRAINT special_tasks_requested_by_id
5        FOREIGN KEY (requested_by_id) REFERENCES users (id) ON DELETE NO ACTION;
6"""
7
8DOWN_SQL = """
9ALTER TABLE special_tasks DROP FOREIGN KEY special_tasks_requested_by_id;
10ALTER TABLE special_tasks DROP COLUMN requested_by_id;
11"""
12