X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=05c2a4358cd6e7363c71a9aa59d876cd0c481f8e;hb=c22e34dd58cdc2a79b71dedd3c52ed705c9b8b51;hp=212e74efb4d42de6f37b06736a4b2d2dbb01d1fe;hpb=799d629c5af725596497b7df2055db6ac6da91b7;p=cocanwiki.git diff --git a/cocanwiki.sql b/cocanwiki.sql index 212e74e..05c2a43 100644 --- a/cocanwiki.sql +++ b/cocanwiki.sql @@ -114,7 +114,8 @@ 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 ); @@ -288,7 +289,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 ); @@ -499,7 +501,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 ); @@ -595,7 +598,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 +606,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 +614,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 +622,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 +630,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 +692,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 +701,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 +710,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 +719,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 +728,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 +737,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 +746,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 +755,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 +764,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 +773,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 +782,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 +791,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 +800,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 +809,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 +818,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 +827,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 +836,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 +845,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 +854,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 +863,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 +872,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 --