[dak/master 4/4] Use PK at twerners suggestion
Signed-off-by: Mark Hymers <mhy@debian.org>
---
dak/dakdb/update45.py | 2 +-
dak/dakdb/update46.py | 10 +++++++---
2 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/dak/dakdb/update45.py b/dak/dakdb/update45.py
index 0a12d5b..32ed04f 100755
--- a/dak/dakdb/update45.py
+++ b/dak/dakdb/update45.py
@@ -42,7 +42,7 @@ CREATE TABLE extra_src_references (
bin_id INT4 NOT NULL REFERENCES binaries(id) ON DELETE CASCADE,
src_id INT4 NOT NULL REFERENCES source(id) ON DELETE RESTRICT,
- UNIQUE (bin_id, src_id)
+ PRIMARY KEY (bin_id, src_id)
)""")
c.execute("UPDATE config SET value = '45' WHERE name = 'db_revision'")
diff --git a/dak/dakdb/update46.py b/dak/dakdb/update46.py
index 652a965..d1b2d3a 100755
--- a/dak/dakdb/update46.py
+++ b/dak/dakdb/update46.py
@@ -43,7 +43,9 @@ def do_update(self):
c.execute("""
CREATE TABLE metadata_keys (
key_id SERIAL NOT NULL UNIQUE,
- key TEXT NOT NULL UNIQUE
+ key TEXT NOT NULL UNIQUE,
+
+ PRIMARY KEY (key_id)
)
""")
@@ -52,7 +54,8 @@ CREATE TABLE binaries_metadata (
bin_id INT4 NOT NULL REFERENCES binaries(id) ON DELETE CASCADE,
key_id INT4 NOT NULL REFERENCES metadata_keys(key_id),
value TEXT NOT NULL,
- UNIQUE (bin_id, key_id)
+
+ PRIMARY KEY (bin_id, key_id)
)
""")
@@ -61,7 +64,8 @@ CREATE TABLE source_metadata (
src_id INT4 NOT NULL REFERENCES source(id) ON DELETE CASCADE,
key_id INT4 NOT NULL REFERENCES metadata_keys(key_id),
value TEXT NOT NULL,
- UNIQUE (src_id, key_id)
+
+ PRIMARY KEY (src_id, key_id)
)
""")
--
1.7.2.5
Reply to: