diff options
Diffstat (limited to 'gentoobrowse/datasources/schema.sql')
-rw-r--r-- | gentoobrowse/datasources/schema.sql | 6 |
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); |