GRANT ALL ON TABLE pages TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 23 (OID 536004)
+-- TOC entry 38 (OID 536004)
-- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich
--
GRANT ALL ON TABLE pages_id_seq TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 7 (OID 536021)
-- Name: contents; Type: TABLE; Schema: public; Owner: rich
id serial NOT NULL,
pageid integer NOT NULL,
ordering integer NOT NULL,
- sectionname text NOT NULL,
+ sectionname text,
content text NOT NULL,
divname text
);
GRANT ALL ON TABLE contents TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 24 (OID 536021)
+-- TOC entry 39 (OID 536021)
-- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich
--
GRANT ALL ON TABLE contents_id_seq TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 9 (OID 536371)
-- Name: hosts; Type: TABLE; Schema: public; Owner: rich
canonical_hostname text NOT NULL,
css text,
edit_anon boolean DEFAULT true NOT NULL,
- create_account_anon boolean DEFAULT true NOT NULL
+ create_account_anon boolean DEFAULT true NOT NULL,
+ theme_css text,
+ feedback_email text,
+ mailing_list boolean DEFAULT false NOT NULL
);
GRANT ALL ON TABLE hosts TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 25 (OID 536371)
+-- TOC entry 40 (OID 536371)
-- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich
--
GRANT ALL ON TABLE hosts_id_seq TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 11 (OID 536379)
-- Name: hostnames; Type: TABLE; Schema: public; Owner: rich
GRANT ALL ON TABLE hostnames TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 13 (OID 536915)
-- Name: email_notify; Type: TABLE; Schema: public; Owner: rich
GRANT ALL ON TABLE email_notify TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 15 (OID 537151)
-- Name: images; Type: TABLE; Schema: public; Owner: rich
GRANT ALL ON TABLE images TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 26 (OID 537151)
+-- TOC entry 41 (OID 537151)
-- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich
--
GRANT ALL ON TABLE images_id_seq TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 17 (OID 537166)
-- Name: files; Type: TABLE; Schema: public; Owner: rich
GRANT ALL ON TABLE files TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 27 (OID 537166)
+-- TOC entry 42 (OID 537166)
-- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich
--
GRANT ALL ON TABLE files_id_seq TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
-- TOC entry 19 (OID 540816)
-- Name: users; Type: TABLE; Schema: public; Owner: rich
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_users boolean DEFAULT false NOT NULL,
+ can_manage_contacts boolean DEFAULT false NOT NULL,
+ can_manage_site boolean DEFAULT false NOT NULL,
+ can_edit_global_css boolean DEFAULT false NOT NULL
);
GRANT ALL ON TABLE users TO "www-data";
+SET SESSION AUTHORIZATION 'rich';
+
--
--- TOC entry 28 (OID 540816)
+-- TOC entry 43 (OID 540816)
-- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich
--
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
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 44 (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 29 (OID 543499)
+-- Name: themes; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE themes (
+ theme_css text NOT NULL,
+ name text NOT NULL,
+ description text NOT NULL
+);
+
+
+--
+-- TOC entry 30 (OID 543499)
+-- Name: themes; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE themes FROM PUBLIC;
+GRANT SELECT ON TABLE themes TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 31 (OID 543592)
+-- Name: server_settings; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE server_settings (
+ "version" integer NOT NULL,
+ stats_page text
+);
+
+
+--
+-- TOC entry 33 (OID 543592)
+-- Name: server_settings; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE server_settings FROM PUBLIC;
+GRANT SELECT ON TABLE server_settings TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 34 (OID 543754)
+-- Name: page_emails; Type: TABLE; Schema: public; Owner: rich
+--
+
+CREATE TABLE page_emails (
+ hostid integer NOT NULL,
+ url text NOT NULL,
+ email text NOT NULL,
+ entry_date date DEFAULT ('now'::text)::date NOT NULL,
+ last_sent date DEFAULT ('now'::text)::date NOT NULL,
+ pending text,
+ opt_out text NOT NULL
+);
+
+
--
--- TOC entry 33 (OID 536388)
+-- TOC entry 35 (OID 543754)
+-- Name: page_emails; Type: ACL; Schema: public; Owner: rich
+--
+
+REVOKE ALL ON TABLE page_emails FROM PUBLIC;
+GRANT ALL ON TABLE page_emails TO "www-data";
+
+
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- 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)
-- Name: hostnames_hostid_name_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 34 (OID 536389)
+-- TOC entry 50 (OID 536389)
-- Name: hostnams_name_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 30 (OID 536419)
+-- TOC entry 46 (OID 536419)
-- Name: pages_url_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 35 (OID 536924)
+-- TOC entry 51 (OID 536924)
-- Name: email_notify_email_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 36 (OID 540251)
+-- TOC entry 52 (OID 540251)
-- Name: images_name_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 38 (OID 540252)
+-- TOC entry 54 (OID 540252)
-- Name: files_name_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 41 (OID 540831)
+-- TOC entry 57 (OID 540831)
-- Name: users_name_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 40 (OID 540946)
+-- TOC entry 56 (OID 540946)
-- Name: users_id_uq; Type: INDEX; Schema: public; Owner: rich
--
--
--- TOC entry 29 (OID 536012)
+-- TOC entry 59 (OID 540970)
+-- Name: sitemenu_ordering_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX sitemenu_ordering_uq ON sitemenu USING btree (hostid, ordering);
+
+
+--
+-- TOC entry 60 (OID 540971)
+-- Name: sitemenu_url_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url);
+
+
+--
+-- TOC entry 62 (OID 542626)
+-- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, email);
+
+
+--
+-- TOC entry 63 (OID 543505)
+-- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css);
+
+
+--
+-- TOC entry 64 (OID 543763)
+-- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url, email);
+
+
+--
+-- TOC entry 65 (OID 543795)
+-- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, email);
+
+
+--
+-- TOC entry 45 (OID 536012)
-- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 31 (OID 536027)
+-- TOC entry 47 (OID 536027)
-- Name: contents_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 32 (OID 536377)
+-- TOC entry 48 (OID 536377)
-- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 37 (OID 537158)
+-- TOC entry 53 (OID 537158)
-- Name: images_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 39 (OID 537173)
+-- TOC entry 55 (OID 537173)
-- Name: files_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 42 (OID 540825)
+-- TOC entry 58 (OID 540825)
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 47 (OID 536029)
+-- TOC entry 61 (OID 542611)
+-- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contacts
+ ADD CONSTRAINT contacts_pkey PRIMARY KEY (id);
+
+
+--
+-- TOC entry 70 (OID 536029)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 49 (OID 536384)
+-- TOC entry 73 (OID 536384)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 48 (OID 536394)
+-- TOC entry 71 (OID 536394)
-- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 43 (OID 536404)
+-- TOC entry 66 (OID 536404)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 50 (OID 536920)
+-- TOC entry 74 (OID 536920)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 51 (OID 537160)
+-- TOC entry 75 (OID 537160)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 52 (OID 537175)
+-- TOC entry 76 (OID 537175)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 44 (OID 539155)
+-- TOC entry 67 (OID 539155)
-- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 53 (OID 540827)
+-- TOC entry 77 (OID 540827)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 54 (OID 540837)
+-- TOC entry 78 (OID 540837)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 45 (OID 540942)
+-- TOC entry 68 (OID 540942)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
--
--- TOC entry 46 (OID 540947)
+-- TOC entry 69 (OID 540947)
-- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
--
ADD CONSTRAINT pages_user_cn FOREIGN KEY (hostid, logged_user) REFERENCES users(hostid, id);
+--
+-- TOC entry 79 (OID 540966)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY sitemenu
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 80 (OID 540972)
+-- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY sitemenu
+ ADD CONSTRAINT sitemenu_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 81 (OID 542613)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contacts
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 82 (OID 542622)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY contact_emails
+ ADD CONSTRAINT "$1" FOREIGN KEY (contactid) REFERENCES contacts(id);
+
+
+--
+-- TOC entry 72 (OID 543506)
+-- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY hosts
+ ADD CONSTRAINT hosts_theme_css_cn FOREIGN KEY (theme_css) REFERENCES themes(theme_css);
+
+
+--
+-- TOC entry 83 (OID 543759)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY page_emails
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
+--
+-- TOC entry 84 (OID 543764)
+-- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY page_emails
+ ADD CONSTRAINT page_emails_url_cn FOREIGN KEY (hostid, url) REFERENCES pages(hostid, url) DEFERRABLE;
+
+
+--
+-- TOC entry 85 (OID 543791)
+-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
+--
+
+ALTER TABLE ONLY mailing_lists
+ ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id);
+
+
SET SESSION AUTHORIZATION 'postgres';
--
COMMENT ON SCHEMA public IS 'Standard public namespace';
+SET SESSION AUTHORIZATION 'rich';
+
+--
+-- TOC entry 32 (OID 543592)
+-- Name: TABLE server_settings; Type: COMMENT; Schema: public; Owner: rich
+--
+
+COMMENT ON TABLE server_settings IS 'This table contains global settings for the server. There should be only one row in this table. If you modify any setting, you must restart the webserver for the change to take effect. The "version" field is intended to be some sort of database version, but is currently unused.';
+
+
git.annexia.org / cocanwiki.git / blobdiff