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
);
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
);
--
+-- 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
--
--
--- 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
--