3 -- Name: user_ids; Type: SEQUENCE; Schema: public; Owner: postgres
6 CREATE SEQUENCE user_ids
14 -- Name: users; Type: TABLE; Schema: public; Owner: postgres
18 user_id integer DEFAULT nextval('user_ids'::text) PRIMARY KEY,
19 username character varying(128) DEFAULT ''::character varying NOT NULL,
20 mail_host character varying(128) DEFAULT ''::character varying NOT NULL,
21 alias character varying(128) DEFAULT ''::character varying NOT NULL,
22 created timestamp with time zone DEFAULT now() NOT NULL,
23 last_login timestamp with time zone DEFAULT now() NOT NULL,
24 "language" character varying(5) DEFAULT 'en'::character varying NOT NULL,
25 preferences text DEFAULT ''::text NOT NULL
28 CREATE INDEX users_username_id_idx ON users (username);
29 CREATE INDEX users_alias_id_idx ON users (alias);
34 -- Name: session; Type: TABLE; Schema: public; Owner: postgres
37 CREATE TABLE "session" (
38 sess_id character varying(40) DEFAULT ''::character varying PRIMARY KEY,
39 created timestamp with time zone DEFAULT now() NOT NULL,
40 changed timestamp with time zone DEFAULT now() NOT NULL,
41 ip character varying(41) NOT NULL,
48 -- Sequence "identity_ids"
49 -- Name: identity_ids; Type: SEQUENCE; Schema: public; Owner: postgres
52 CREATE SEQUENCE identity_ids
61 -- Name: identities; Type: TABLE; Schema: public; Owner: postgres
64 CREATE TABLE identities (
65 identity_id integer DEFAULT nextval('identity_ids'::text) PRIMARY KEY,
66 user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
67 del integer DEFAULT 0 NOT NULL,
68 standard integer DEFAULT 0 NOT NULL,
69 name character varying(128) NOT NULL,
70 organization character varying(128),
71 email character varying(128) NOT NULL,
72 "reply-to" character varying(128),
73 bcc character varying(128),
75 html_signature integer DEFAULT 0 NOT NULL
78 CREATE INDEX identities_user_id_idx ON identities (user_id);
82 -- Sequence "contact_ids"
83 -- Name: contact_ids; Type: SEQUENCE; Schema: public; Owner: postgres
86 CREATE SEQUENCE contact_ids
95 -- Name: contacts; Type: TABLE; Schema: public; Owner: postgres
98 CREATE TABLE contacts (
99 contact_id integer DEFAULT nextval('contact_ids'::text) PRIMARY KEY,
100 user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
101 changed timestamp with time zone DEFAULT now() NOT NULL,
102 del integer DEFAULT 0 NOT NULL,
103 name character varying(128) DEFAULT ''::character varying NOT NULL,
104 email character varying(128) DEFAULT ''::character varying NOT NULL,
105 firstname character varying(128) DEFAULT ''::character varying NOT NULL,
106 surname character varying(128) DEFAULT ''::character varying NOT NULL,
110 CREATE INDEX contacts_user_id_idx ON contacts (user_id);
113 -- Sequence "cache_ids"
114 -- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres
117 CREATE SEQUENCE cache_ids
125 -- Name: cache; Type: TABLE; Schema: public; Owner: postgres
128 CREATE TABLE "cache" (
129 cache_id integer DEFAULT nextval('cache_ids'::text) PRIMARY KEY,
130 user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
131 session_id character varying(40) REFERENCES "session" (sess_id),
132 cache_key character varying(128) DEFAULT ''::character varying NOT NULL,
133 created timestamp with time zone DEFAULT now() NOT NULL,
137 CREATE INDEX cache_user_id_idx ON "cache" (user_id, cache_key);
140 -- Sequence "message_ids"
141 -- Name: message_ids; Type: SEQUENCE; Schema: public; Owner: postgres
144 CREATE SEQUENCE message_ids
152 -- Name: messages; Type: TABLE; Schema: public; Owner: postgres
155 CREATE TABLE "messages" (
156 message_id integer DEFAULT nextval('message_ids'::text) PRIMARY KEY,
157 user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
158 del integer DEFAULT 0 NOT NULL,
159 cache_key character varying(128) DEFAULT ''::character varying NOT NULL,
160 created timestamp with time zone DEFAULT now() NOT NULL,
161 idx integer DEFAULT 0 NOT NULL,
162 uid integer DEFAULT 0 NOT NULL,
163 subject character varying(128) DEFAULT ''::character varying NOT NULL,
164 "from" character varying(128) DEFAULT ''::character varying NOT NULL,
165 "to" character varying(128) DEFAULT ''::character varying NOT NULL,
166 cc character varying(128) DEFAULT ''::character varying NOT NULL,
167 date timestamp with time zone NOT NULL,
168 size integer DEFAULT 0 NOT NULL,
169 headers text NOT NULL,
173 ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid);