summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-05-15 11:05:56 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-05-15 11:05:56 -0700
commit08447760cd3580504ff6d5c6ea8d5dd6cea1fb64 (patch)
tree67c77104fb1f78b9d2a2f2ebfeeba34bfd0549d1 /rust/migrations/2018-05-12-001226_init/up.sql
parent9a303b182a32d2908caaaf5d24c7bc1ff3831505 (diff)
downloadfatcat-08447760cd3580504ff6d5c6ea8d5dd6cea1fb64.tar.gz
fatcat-08447760cd3580504ff6d5c6ea8d5dd6cea1fb64.zip
diesel wants primary keys
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index fabd2c3f..f4583949 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -181,6 +181,7 @@ ALTER TABLE release_rev
-------------------- Inter-Entity Relations
CREATE TABLE release_contrib (
+ id BIGSERIAL PRIMARY KEY,
release_rev BIGSERIAL REFERENCES release_rev(id) NOT NULL,
creator_ident_id UUID REFERENCES creator_ident(id),
stub TEXT,
@@ -196,6 +197,7 @@ CREATE TABLE release_ref (
);
CREATE TABLE file_release (
+ id BIGSERIAL PRIMARY KEY,
file_rev BIGSERIAL REFERENCES file_rev(id) NOT NULL,
target_release_ident_id UUID REFERENCES creator_ident(id) NOT NULL
);