Remove no-longer used table; user_ebuild_emailsgentoobrowse-api-0.9.4

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