+
+CREATE TABLE users (
+ id serial NOT NULL,
+ hostid integer NOT NULL,
+ name text NOT NULL,
+ "password" text NOT NULL,
+ email text,
+ registration_date date DEFAULT ('now'::text)::date NOT NULL,
+ can_edit boolean DEFAULT true NOT NULL,
+ can_manage_users boolean DEFAULT false NOT NULL,
+ can_manage_contacts boolean DEFAULT false NOT NULL
+);
+
+
+--
+-- TOC entry 20 (OID 540816)
+-- Name: users; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE users FROM PUBLIC;
+GRANT ALL ON TABLE users TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 34 (OID 540816)
+-- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE users_id_seq FROM PUBLIC;
+GRANT ALL ON TABLE users_id_seq TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 21 (OID 540832)
+-- Name: usercookies; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE usercookies (
+ userid integer NOT NULL,
+ cookie text NOT NULL
+);
+
+
+--
+-- TOC entry 22 (OID 540832)
+-- Name: usercookies; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE usercookies FROM PUBLIC;
+GRANT ALL ON TABLE usercookies TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 23 (OID 540961)
+-- Name: sitemenu; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE sitemenu (
+ hostid integer NOT NULL,
+ url text NOT NULL,
+ label text NOT NULL,
+ ordering integer NOT NULL
+);
+
+
+--
+-- TOC entry 24 (OID 540961)
+-- Name: sitemenu; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE sitemenu FROM PUBLIC;
+GRANT ALL ON TABLE sitemenu TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 25 (OID 542605)
+-- Name: contacts; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE contacts (
+ id serial NOT NULL,
+ hostid integer NOT NULL,
+ name text NOT NULL,
+ subject text NOT NULL
+);
+
+
+--
+-- TOC entry 26 (OID 542605)
+-- Name: contacts; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE contacts FROM PUBLIC;
+GRANT ALL ON TABLE contacts TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 35 (OID 542605)
+-- Name: contacts_id_seq; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE contacts_id_seq FROM PUBLIC;
+GRANT ALL ON TABLE contacts_id_seq TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 27 (OID 542617)
+-- Name: contact_emails; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE contact_emails (
+ contactid integer NOT NULL,
+ email text NOT NULL
+);
+
+
+--
+-- TOC entry 28 (OID 542617)
+-- Name: contact_emails; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE contact_emails FROM PUBLIC;
+GRANT ALL ON TABLE contact_emails TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 40 (OID 536388)