X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=05c2a4358cd6e7363c71a9aa59d876cd0c481f8e;hb=c22e34dd58cdc2a79b71dedd3c52ed705c9b8b51;hp=859eb4b94e4614aef388a9417b3b4e18e437263a;hpb=f33343df3525e01f05ecf80628cd46b6e5841001;p=cocanwiki.git diff --git a/cocanwiki.sql b/cocanwiki.sql index 859eb4b..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 ); @@ -596,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 -- @@ -604,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 -- @@ -612,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 -- @@ -620,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 -- @@ -628,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 -- @@ -682,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 -- @@ -691,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 -- @@ -700,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 -- @@ -709,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 -- @@ -718,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 -- @@ -727,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 -- @@ -736,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 -- @@ -745,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 -- @@ -754,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 -- @@ -763,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 -- @@ -772,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 -- @@ -781,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 -- @@ -790,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 -- @@ -799,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 -- @@ -808,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 -- @@ -817,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 -- @@ -826,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 -- @@ -835,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 -- @@ -844,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 -- @@ -853,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 -- @@ -862,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 --