diff options
Diffstat (limited to 'sqitch/deploy/system_test_tables.sql')
-rw-r--r-- | sqitch/deploy/system_test_tables.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sqitch/deploy/system_test_tables.sql b/sqitch/deploy/system_test_tables.sql new file mode 100644 index 0000000..5c7b659 --- /dev/null +++ b/sqitch/deploy/system_test_tables.sql @@ -0,0 +1,21 @@ +-- Deploy guix-data-service:system_test_tables to pg + +BEGIN; + +CREATE TABLE system_tests ( + id integer NOT NULL GENERATED ALWAYS AS IDENTITY, + name varchar NOT NULL, + description varchar NOT NULL, + location_id integer NOT NULL REFERENCES locations (id), + PRIMARY KEY (name, description, location_id), + UNIQUE (id) +); + +CREATE TABLE guix_revision_system_test_derivations ( + guix_revision_id integer NOT NULL REFERENCES guix_revisions (id), + system_test_id integer NOT NULL REFERENCES system_tests (id), + derivation_id integer NOT NULL REFERENCES derivations (id), + PRIMARY KEY (guix_revision_id, system_test_id, derivation_id) +); + +COMMIT; |