diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2018-02-11 19:48:44 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2018-02-11 19:48:44 +0000 |
| commit | 71ed77066f2ccf10b5c90acf77a71a6a9b6e52e2 (patch) | |
| tree | 32464769627f79cf1a8799180107e2cdce7f4049 | |
| parent | Add range constraints for imported dates/timestamps. Add hack to correct mino... (diff) | |
| download | gentoobrowse-api-0.9.4.tar.bz2 gentoobrowse-api-0.9.4.tar.xz gentoobrowse-api-0.9.4.zip | |
Remove no-longer used table; user_ebuild_emailsgentoobrowse-api-0.9.4
| -rw-r--r-- | gentoobrowse-api/db/schema.sql | 21 | ||||
| -rw-r--r-- | gentoobrowse-api/unittests/data.sql | 1 | ||||
| -rw-r--r-- | gentoobrowse-api/unittests/fixtures/user_ebuild_emails.dat | 0 |
3 files changed, 0 insertions, 22 deletions
diff --git a/gentoobrowse-api/db/schema.sql b/gentoobrowse-api/db/schema.sql index 066d297..9f6cce7 100644 --- a/gentoobrowse-api/db/schema.sql +++ b/gentoobrowse-api/db/schema.sql @@ -526,13 +526,6 @@ CREATE TABLE use_local ( description text NOT NULL ); ALTER TABLE use_local OWNER TO gentoo; --- Name: user_ebuild_emails; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: -CREATE TABLE user_ebuild_emails ( - userid integer NOT NULL, - ebuildid integer NOT NULL, - sentat timestamp without time zone NOT NULL -); -ALTER TABLE user_ebuild_emails OWNER TO gentoo; -- Name: user_packages; Type: TABLE; Schema: gentoobrowse; Owner: gentoo; Tablespace: CREATE TABLE user_packages ( userid integer NOT NULL, @@ -641,9 +634,6 @@ ALTER TABLE package_urls CLUSTER ON pk_pkgurls; -- Name: pk_usegroup; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: ALTER TABLE ONLY use_groups ADD CONSTRAINT pk_usegroup PRIMARY KEY (usegroupid); --- Name: pk_userebuildemails; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT pk_userebuildemails PRIMARY KEY (userid, ebuildid); -- Name: pk_userpackages; Type: CONSTRAINT; Schema: gentoobrowse; Owner: gentoo; Tablespace: ALTER TABLE ONLY user_packages ADD CONSTRAINT pk_userpackages PRIMARY KEY (userid, packageid); @@ -774,12 +764,6 @@ ALTER TABLE ONLY use_group -- Name: fk_uselocal_package; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo ALTER TABLE ONLY use_local ADD CONSTRAINT fk_uselocal_package FOREIGN KEY (packageid) REFERENCES packages(packageid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userebuildemails_ebuild; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT fk_userebuildemails_ebuild FOREIGN KEY (ebuildid) REFERENCES ebuilds(ebuildid) ON UPDATE CASCADE ON DELETE CASCADE; --- Name: fk_userebuildemails_user; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo -ALTER TABLE ONLY user_ebuild_emails - ADD CONSTRAINT fk_userebuildemails_user FOREIGN KEY (userid) REFERENCES users(userid) ON UPDATE CASCADE ON DELETE CASCADE; -- Name: fk_userpackages_user; Type: FK CONSTRAINT; Schema: gentoobrowse; Owner: gentoo ALTER TABLE ONLY user_packages ADD CONSTRAINT fk_userpackages_user FOREIGN KEY (userid) REFERENCES users(userid) ON UPDATE CASCADE ON DELETE CASCADE; @@ -876,11 +860,6 @@ REVOKE ALL ON TABLE use_local FROM PUBLIC; REVOKE ALL ON TABLE use_local FROM gentoo; GRANT ALL ON TABLE use_local TO gentoo; GRANT SELECT ON TABLE use_local TO apache; --- Name: user_ebuild_emails; Type: ACL; Schema: gentoobrowse; Owner: gentoo -REVOKE ALL ON TABLE user_ebuild_emails FROM PUBLIC; -REVOKE ALL ON TABLE user_ebuild_emails FROM gentoo; -GRANT ALL ON TABLE user_ebuild_emails TO gentoo; -GRANT SELECT ON TABLE user_ebuild_emails TO apache; -- Name: user_packages; Type: ACL; Schema: gentoobrowse; Owner: gentoo REVOKE ALL ON TABLE user_packages FROM PUBLIC; REVOKE ALL ON TABLE user_packages FROM gentoo; diff --git a/gentoobrowse-api/unittests/data.sql b/gentoobrowse-api/unittests/data.sql index 75e5ddf..90d4434 100644 --- a/gentoobrowse-api/unittests/data.sql +++ b/gentoobrowse-api/unittests/data.sql @@ -24,7 +24,6 @@ COPY gentoobrowse.use_groups (usegroupid, name) FROM '$SCRIPTDIR/fixtures/use_gr COPY gentoobrowse.use_group (usegroupid, use, description) FROM '$SCRIPTDIR/fixtures/use_group.dat'; COPY gentoobrowse.use_local (packageid, use, description) FROM '$SCRIPTDIR/fixtures/use_local.dat'; COPY gentoobrowse.users (userid, username, userrealname, userpassword, useremail, verifyguid, lastmailshot, signedup) FROM '$SCRIPTDIR/fixtures/users.dat'; -COPY gentoobrowse.user_ebuild_emails (userid, ebuildid, sentat) FROM '$SCRIPTDIR/fixtures/user_ebuild_emails.dat'; COPY gentoobrowse.user_packages (userid, packageid, trackedsince) FROM '$SCRIPTDIR/fixtures/user_packages.dat'; COPY gentoobrowse.changelog (changeid, repoid, commitid, committime, authorname, authoremail, summary, body, files) FROM '$SCRIPTDIR/fixtures/changelog.dat'; diff --git a/gentoobrowse-api/unittests/fixtures/user_ebuild_emails.dat b/gentoobrowse-api/unittests/fixtures/user_ebuild_emails.dat deleted file mode 100644 index e69de29..0000000 --- a/gentoobrowse-api/unittests/fixtures/user_ebuild_emails.dat +++ /dev/null |