+-- TOC entry 19 (OID 540816)
+-- Name: users; Type: TABLE; Schema: public; Owner: rich
+--
+
+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
+);
+
+
+--
+-- 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";
+
+
+--
+-- TOC entry 30 (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";
+
+
+--
+-- 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";
+
+
+--
+-- 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";
+
+
+--
+-- TOC entry 35 (OID 536388)