X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=cocanwiki.sql;h=b9ab1c3773be4bc4f57efd40f5e5a9c1601cf924;hb=c0d8bbfd20d6fbf7d9176c5825b8943d3d2891a9;hp=dbd87b211442cadecaecce9bb78b98a2e15ef504;hpb=bb882f46f4f695469eb05d56fb5aee7bef0077df;p=cocanwiki.git

diff --git a/cocanwiki.sql b/cocanwiki.sql
index dbd87b2..b9ab1c3 100644
--- a/cocanwiki.sql
+++ b/cocanwiki.sql
@@ -265,7 +265,8 @@ CREATE TABLE users (
     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,
-    force_password_change boolean DEFAULT false NOT NULL
+    force_password_change boolean DEFAULT false NOT NULL,
+    can_import_mail boolean DEFAULT false NOT NULL
 );
 
 
@@ -585,7 +586,8 @@ GRANT ALL ON TABLE messages_id_seq TO "www-data";
 
 CREATE TABLE msg_references (
     message_id integer NOT NULL,
-    inet_message_id text NOT NULL
+    inet_message_id text NOT NULL,
+    ordering integer NOT NULL
 );
 
 
@@ -759,6 +761,14 @@ CREATE UNIQUE INDEX recently_visited_uq ON recently_visited USING btree (userid,
 
 
 --
+-- TOC entry 85 (OID 552155)
+-- Name: messages_inet_message_id_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX messages_inet_message_id_uq ON messages USING btree (hostid, inet_message_id);
+
+
+--
 -- TOC entry 57 (OID 536012)
 -- Name: pages_pkey; Type: CONSTRAINT; Schema: public; Owner: rich
 --
@@ -840,15 +850,6 @@ ALTER TABLE ONLY messages
 
 
 --
--- TOC entry 85 (OID 551683)
--- Name: messages_inet_message_id_key; Type: CONSTRAINT; Schema: public; Owner: rich
---
-
-ALTER TABLE ONLY messages
-    ADD CONSTRAINT messages_inet_message_id_key UNIQUE (inet_message_id);
-
-
---
 -- TOC entry 91 (OID 536029)
 -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: rich
 --