summaryrefslogtreecommitdiff
path: root/gentoobrowse/datasources/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'gentoobrowse/datasources/schema.sql')
-rw-r--r--gentoobrowse/datasources/schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql
index 1f1478f..36877a4 100644
--- a/gentoobrowse/datasources/schema.sql
+++ b/gentoobrowse/datasources/schema.sql
@@ -602,10 +602,10 @@ ALTER TABLE ONLY users
-- Name: repos_pkey; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace:
ALTER TABLE ONLY repos
ADD CONSTRAINT repos_pkey PRIMARY KEY (repoid);
--- Name: uni_ebuild_pkgver; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace:
+-- Name: uni_ebuild_pkgverrepo; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace:
ALTER TABLE ONLY ebuilds
- ADD CONSTRAINT uni_ebuild_pkgver UNIQUE (packageid, version);
-ALTER TABLE ebuilds CLUSTER ON uni_ebuild_pkgver;
+ ADD CONSTRAINT uni_ebuild_pkgverrepo UNIQUE (packageid, version, repoid);
+ALTER TABLE ebuilds CLUSTER ON uni_ebuild_pkgverrepo;
-- Name: uni_files_filename; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace:
ALTER TABLE ONLY files
ADD CONSTRAINT uni_files_filename UNIQUE (filename);