diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-15 11:05:56 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-15 11:05:56 -0700 |
commit | 08447760cd3580504ff6d5c6ea8d5dd6cea1fb64 (patch) | |
tree | 67c77104fb1f78b9d2a2f2ebfeeba34bfd0549d1 /rust/migrations/2018-05-12-001226_init/up.sql | |
parent | 9a303b182a32d2908caaaf5d24c7bc1ff3831505 (diff) | |
download | fatcat-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.sql | 2 |
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 ); |