+-- TOC entry 36 (OID 543785)
+-- Name: mailing_lists; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE mailing_lists (
+ hostid integer NOT NULL,
+ email text NOT NULL,
+ entry_date date DEFAULT ('now'::text)::date NOT NULL,
+ pending text,
+ opt_out text NOT NULL,
+ name text NOT NULL
+);
+
+
+--
+-- TOC entry 37 (OID 543785)
+-- Name: mailing_lists; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE mailing_lists FROM PUBLIC;
+GRANT ALL ON TABLE mailing_lists TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 49 (OID 536388)