Permalink
Browse files

Get special_product_platforms back into schema.sql

  • Loading branch information...
1 parent 690e93f commit 55a1345a01d7bf64299dff395aee4d1fbbe6655c @selenamarie selenamarie committed with lonnen Oct 30, 2012
Showing with 37 additions and 0 deletions.
  1. +37 −0 sql/schema.sql
View
@@ -7820,6 +7820,22 @@ CREATE TABLE socorro_db_version_history (
ALTER TABLE public.socorro_db_version_history OWNER TO postgres;
--
+-- Name: special_product_platforms; Type: TABLE; Schema: public; Owner: breakpad_rw; Tablespace:
+--
+
+CREATE TABLE special_product_platforms (
+ platform citext NOT NULL,
+ repository citext NOT NULL,
+ release_channel citext NOT NULL,
+ release_name citext NOT NULL,
+ product_name citext NOT NULL,
+ min_version major_version NOT NULL
+);
+
+
+ALTER TABLE public.special_product_platforms OWNER TO breakpad_rw;
+
+--
-- Name: tcbs_build; Type: TABLE; Schema: public; Owner: breakpad_rw; Tablespace:
--
@@ -8611,6 +8627,14 @@ ALTER TABLE ONLY socorro_db_version
--
+-- Name: special_product_platforms_key; Type: CONSTRAINT; Schema: public; Owner: breakpad_rw; Tablespace:
+--
+
+ALTER TABLE ONLY special_product_platforms
+ ADD CONSTRAINT special_product_platforms_key PRIMARY KEY (release_name, platform, repository, release_channel);
+
+
+--
-- Name: tcbs_build_key; Type: CONSTRAINT; Schema: public; Owner: breakpad_rw; Tablespace:
--
@@ -10621,6 +10645,19 @@ GRANT ALL ON TABLE socorro_db_version_history TO monitor;
--
+-- Name: special_product_platforms; Type: ACL; Schema: public; Owner: breakpad_rw
+--
+
+REVOKE ALL ON TABLE special_product_platforms FROM PUBLIC;
+REVOKE ALL ON TABLE special_product_platforms FROM breakpad_rw;
+GRANT ALL ON TABLE special_product_platforms TO breakpad_rw;
+GRANT SELECT ON TABLE special_product_platforms TO breakpad_ro;
+GRANT SELECT ON TABLE special_product_platforms TO breakpad;
+GRANT ALL ON TABLE special_product_platforms TO monitor;
+GRANT SELECT ON TABLE special_product_platforms TO analyst;
+
+
+--
-- Name: tcbs_build; Type: ACL; Schema: public; Owner: breakpad_rw
--

0 comments on commit 55a1345

Please sign in to comment.