X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=ddd95df6e836633a778f885372780a692c835fc2;hb=2cc5a717993e43c75ab2e6cbda0361d4722d2227;hp=f6e43852c1ec2e48ce1ecd75f32b12917fe595ad;hpb=50f72e5597bef62747f462d26cae836c7c9ee6b9;p=cocanwiki.git diff --git a/cocanwiki.sql b/cocanwiki.sql index f6e4385..ddd95df 100644 --- a/cocanwiki.sql +++ b/cocanwiki.sql @@ -5,8 +5,6 @@ SET client_encoding = 'UNICODE'; SET check_function_bodies = false; -SET SESSION AUTHORIZATION 'postgres'; - -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres @@ -17,8 +15,6 @@ REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -SET SESSION AUTHORIZATION 'rich'; - SET search_path = public, pg_catalog; -- @@ -51,8 +47,6 @@ REVOKE ALL ON TABLE pages FROM PUBLIC; GRANT ALL ON TABLE pages TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 38 (OID 536004) -- Name: pages_id_seq; Type: ACL; Schema: public; Owner: rich @@ -62,8 +56,6 @@ REVOKE ALL ON TABLE pages_id_seq FROM PUBLIC; 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 @@ -88,8 +80,6 @@ REVOKE ALL ON TABLE contents FROM PUBLIC; GRANT ALL ON TABLE contents TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 39 (OID 536021) -- Name: contents_id_seq; Type: ACL; Schema: public; Owner: rich @@ -99,8 +89,6 @@ REVOKE ALL ON TABLE contents_id_seq FROM PUBLIC; 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 @@ -114,7 +102,9 @@ CREATE TABLE hosts ( create_account_anon boolean DEFAULT true NOT NULL, theme_css text, feedback_email text, - mailing_list boolean DEFAULT false NOT NULL + mailing_list boolean DEFAULT false NOT NULL, + is_template boolean DEFAULT false NOT NULL, + search_box boolean DEFAULT true NOT NULL ); @@ -127,8 +117,6 @@ REVOKE ALL ON TABLE hosts FROM PUBLIC; GRANT ALL ON TABLE hosts TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 40 (OID 536371) -- Name: hosts_id_seq; Type: ACL; Schema: public; Owner: rich @@ -138,8 +126,6 @@ REVOKE ALL ON TABLE hosts_id_seq FROM PUBLIC; 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 @@ -160,8 +146,6 @@ REVOKE ALL ON TABLE hostnames FROM PUBLIC; 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 @@ -183,8 +167,6 @@ REVOKE ALL ON TABLE email_notify FROM PUBLIC; 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 @@ -220,8 +202,6 @@ REVOKE ALL ON TABLE images FROM PUBLIC; GRANT ALL ON TABLE images TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 41 (OID 537151) -- Name: images_id_seq; Type: ACL; Schema: public; Owner: rich @@ -231,8 +211,6 @@ REVOKE ALL ON TABLE images_id_seq FROM PUBLIC; 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 @@ -259,8 +237,6 @@ REVOKE ALL ON TABLE files FROM PUBLIC; GRANT ALL ON TABLE files TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 42 (OID 537166) -- Name: files_id_seq; Type: ACL; Schema: public; Owner: rich @@ -270,8 +246,6 @@ REVOKE ALL ON TABLE files_id_seq FROM PUBLIC; 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 @@ -288,7 +262,8 @@ CREATE TABLE users ( 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 + can_edit_global_css boolean DEFAULT false NOT NULL, + force_password_change boolean DEFAULT false NOT NULL ); @@ -301,8 +276,6 @@ REVOKE ALL ON TABLE users FROM PUBLIC; GRANT ALL ON TABLE users TO "www-data"; -SET SESSION AUTHORIZATION 'rich'; - -- -- TOC entry 43 (OID 540816) -- Name: users_id_seq; Type: ACL; Schema: public; Owner: rich @@ -312,8 +285,6 @@ 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 @@ -334,8 +305,6 @@ 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 @@ -358,8 +327,6 @@ 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 @@ -382,8 +349,6 @@ 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 @@ -393,8 +358,6 @@ 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 @@ -415,8 +378,6 @@ 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 @@ -438,8 +399,6 @@ 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 @@ -460,8 +419,6 @@ 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 @@ -487,8 +444,6 @@ 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 @@ -499,7 +454,8 @@ CREATE TABLE mailing_lists ( email text NOT NULL, entry_date date DEFAULT ('now'::text)::date NOT NULL, pending text, - opt_out text NOT NULL + opt_out text NOT NULL, + name text NOT NULL ); @@ -509,11 +465,9 @@ CREATE TABLE mailing_lists ( -- REVOKE ALL ON TABLE mailing_lists FROM PUBLIC; -GRANT SELECT ON TABLE mailing_lists TO "www-data"; +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 @@ -595,7 +549,7 @@ CREATE UNIQUE INDEX sitemenu_url_uq ON sitemenu USING btree (hostid, url); -- --- TOC entry 62 (OID 542626) +-- TOC entry 63 (OID 542626) -- Name: contact_emails_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -603,7 +557,7 @@ CREATE UNIQUE INDEX contact_emails_uq ON contact_emails USING btree (contactid, -- --- TOC entry 63 (OID 543505) +-- TOC entry 64 (OID 543505) -- Name: themes_theme_css_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -611,7 +565,7 @@ CREATE UNIQUE INDEX themes_theme_css_uq ON themes USING btree (theme_css); -- --- TOC entry 64 (OID 543763) +-- TOC entry 65 (OID 543763) -- Name: page_emails_email_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -619,7 +573,7 @@ CREATE UNIQUE INDEX page_emails_email_uq ON page_emails USING btree (hostid, url -- --- TOC entry 65 (OID 543795) +-- TOC entry 66 (OID 543795) -- Name: mailing_lists_email_uq; Type: INDEX; Schema: public; Owner: rich -- @@ -627,6 +581,14 @@ CREATE UNIQUE INDEX mailing_lists_email_uq ON mailing_lists USING btree (hostid, -- +-- TOC entry 61 (OID 543880) +-- Name: contacts_name_uq; Type: INDEX; Schema: public; Owner: rich +-- + +CREATE UNIQUE INDEX contacts_name_uq ON contacts USING btree (hostid, name); + + +-- -- TOC entry 45 (OID 536012) -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -681,7 +643,7 @@ ALTER TABLE ONLY users -- --- TOC entry 61 (OID 542611) +-- TOC entry 62 (OID 542611) -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: rich -- @@ -690,7 +652,7 @@ ALTER TABLE ONLY contacts -- --- TOC entry 70 (OID 536029) +-- TOC entry 71 (OID 536029) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -699,7 +661,7 @@ ALTER TABLE ONLY contents -- --- TOC entry 73 (OID 536384) +-- TOC entry 74 (OID 536384) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -708,7 +670,7 @@ ALTER TABLE ONLY hostnames -- --- TOC entry 71 (OID 536394) +-- TOC entry 72 (OID 536394) -- Name: hosts_hostname_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -717,7 +679,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 66 (OID 536404) +-- TOC entry 67 (OID 536404) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -726,7 +688,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 74 (OID 536920) +-- TOC entry 75 (OID 536920) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -735,7 +697,7 @@ ALTER TABLE ONLY email_notify -- --- TOC entry 75 (OID 537160) +-- TOC entry 76 (OID 537160) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -744,7 +706,7 @@ ALTER TABLE ONLY images -- --- TOC entry 76 (OID 537175) +-- TOC entry 77 (OID 537175) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -753,7 +715,7 @@ ALTER TABLE ONLY files -- --- TOC entry 67 (OID 539155) +-- TOC entry 68 (OID 539155) -- Name: pages_redirect_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -762,7 +724,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 77 (OID 540827) +-- TOC entry 78 (OID 540827) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -771,7 +733,7 @@ ALTER TABLE ONLY users -- --- TOC entry 78 (OID 540837) +-- TOC entry 79 (OID 540837) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -780,7 +742,7 @@ ALTER TABLE ONLY usercookies -- --- TOC entry 68 (OID 540942) +-- TOC entry 69 (OID 540942) -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -789,7 +751,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 69 (OID 540947) +-- TOC entry 70 (OID 540947) -- Name: pages_user_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -798,7 +760,7 @@ ALTER TABLE ONLY pages -- --- TOC entry 79 (OID 540966) +-- TOC entry 80 (OID 540966) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -807,7 +769,7 @@ ALTER TABLE ONLY sitemenu -- --- TOC entry 80 (OID 540972) +-- TOC entry 81 (OID 540972) -- Name: sitemenu_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -816,7 +778,7 @@ ALTER TABLE ONLY sitemenu -- --- TOC entry 81 (OID 542613) +-- TOC entry 82 (OID 542613) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -825,7 +787,7 @@ ALTER TABLE ONLY contacts -- --- TOC entry 82 (OID 542622) +-- TOC entry 83 (OID 542622) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -834,7 +796,7 @@ ALTER TABLE ONLY contact_emails -- --- TOC entry 72 (OID 543506) +-- TOC entry 73 (OID 543506) -- Name: hosts_theme_css_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -843,7 +805,7 @@ ALTER TABLE ONLY hosts -- --- TOC entry 83 (OID 543759) +-- TOC entry 84 (OID 543759) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -852,7 +814,7 @@ ALTER TABLE ONLY page_emails -- --- TOC entry 84 (OID 543764) +-- TOC entry 85 (OID 543764) -- Name: page_emails_url_cn; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -861,7 +823,7 @@ ALTER TABLE ONLY page_emails -- --- TOC entry 85 (OID 543791) +-- TOC entry 86 (OID 543791) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich -- @@ -869,8 +831,6 @@ ALTER TABLE ONLY mailing_lists ADD CONSTRAINT "$1" FOREIGN KEY (hostid) REFERENCES hosts(id); -SET SESSION AUTHORIZATION 'postgres'; - -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres @@ -879,8 +839,6 @@ 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