diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-07 02:39:05 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-07 21:03:37 +0100 |
| commit | 1c64cce1859ae39a3360f21970bb86a8dedf1fda (patch) | |
| tree | 9a695ca065cef3929b953cd4a839b422f42f30f9 /gentoobrowse/datasources | |
| parent | Replace file finding with pure SQL version with multi-repo support (diff) | |
| download | gentoobrowse-1c64cce1859ae39a3360f21970bb86a8dedf1fda.tar.bz2 gentoobrowse-1c64cce1859ae39a3360f21970bb86a8dedf1fda.tar.xz gentoobrowse-1c64cce1859ae39a3360f21970bb86a8dedf1fda.zip | |
Replace categories and ebuilddefs
Diffstat (limited to 'gentoobrowse/datasources')
| -rw-r--r-- | gentoobrowse/datasources/schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/gentoobrowse/datasources/schema.sql b/gentoobrowse/datasources/schema.sql index a93a2c2..be36a20 100644 --- a/gentoobrowse/datasources/schema.sql +++ b/gentoobrowse/datasources/schema.sql @@ -312,6 +312,7 @@ COMMENT ON TABLE ebuild_uses IS 'Use flags affecting ebuilds'; CREATE TABLE ebuilds ( ebuildid integer NOT NULL, packageid integer NOT NULL, + repoid integer, version text NOT NULL, versioninst ebuildversion NOT NULL, slot text NOT NULL, @@ -684,6 +685,8 @@ CREATE INDEX idx_userpackages_package ON user_packages USING btree (packageid); -- Name: fk_ebuild_pkg; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo ALTER TABLE ONLY ebuilds ADD CONSTRAINT fk_ebuild_pkg FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; +ALTER TABLE ONLY ebuilds + ADD CONSTRAINT fk_ebuild_repo FOREIGN KEY (repoid) REFERENCES repos(repoid) ON UPDATE CASCADE ON DELETE CASCADE; -- Name: fk_ebuildarch_file; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo ALTER TABLE ONLY ebuild_archs ADD CONSTRAINT fk_ebuildarch_file FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; |