New "basic" theme which includes only the necessary CSS.

[cocanwiki.git] / cocanwiki.sql

diff --git a/cocanwiki.sql b/cocanwiki.sql
index dbd87b2..b9ab1c3 100644 (file)
--- 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
 --