schema/pgsql-migrations/upgrade_142.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

ALTER TABLE import_run
  DROP CONSTRAINT import_run_source;

ALTER TABLE import_run
  ADD CONSTRAINT import_run_source
    FOREIGN KEY (source_id)
    REFERENCES import_source (id)
    ON DELETE CASCADE
    ON UPDATE RESTRICT;

INSERT INTO director_schema_migration
  (schema_version, migration_time)
  VALUES (142, NOW());