summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index 7d236f80..a517d788 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -189,15 +189,15 @@ CREATE TABLE release_contrib (
);
CREATE TABLE release_ref (
- id BIGSERIAL PRIMARY KEY,
release_rev BIGSERIAL REFERENCES release_rev(id) NOT NULL,
target_release_ident_id UUID REFERENCES creator_ident(id),
index INTEGER,
stub TEXT
+ PRIMARY KEY (release_rev, target_release_ident_id)
);
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
+ target_release_ident_id UUID REFERENCES creator_ident(id) NOT NULL,
+ PRIMARY KEY (file_rev, target_release_ident_id)
);