From 71ed77066f2ccf10b5c90acf77a71a6a9b6e52e2 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sun, 11 Feb 2018 19:48:44 +0000 Subject: Remove no-longer used table; user_ebuild_emails --- gentoobrowse-api/db/schema.sql | 21 --------------------- gentoobrowse-api/unittests/data.sql | 1 - .../unittests/fixtures/user_ebuild_emails.dat | 0 3 files changed, 22 deletions(-) delete mode 100644 gentoobrowse-api/unittests/fixtures/user_ebuild_emails.dat 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 -- cgit v1.2.3