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
32 -- Name: session; Type: TABLE; Schema: public; Owner: postgres
35 CREATE TABLE "session" (
36 sess_id character varying(40) DEFAULT ''::character varying PRIMARY KEY,
37 created timestamp with time zone DEFAULT now() NOT NULL,
38 changed timestamp with time zone DEFAULT now() NOT NULL,
39 ip character varying(16) NOT NULL,
46 -- Sequence "identity_ids"
47 -- Name: identity_ids; Type: SEQUENCE; Schema: public; Owner: postgres
50 CREATE SEQUENCE identity_ids
59 -- Name: identities; Type: TABLE; Schema: public; Owner: postgres
62 CREATE TABLE identities (
63 identity_id integer DEFAULT nextval('identity_ids'::text) PRIMARY KEY,
64 user_id integer NOT NULL REFERENCES users (user_id),
65 del integer DEFAULT 0 NOT NULL,
66 standard integer DEFAULT 0 NOT NULL,
67 name character varying(128) NOT NULL,
68 organization character varying(128),
69 email character varying(128) NOT NULL,
70 "reply-to" character varying(128),
71 bcc character varying(128),
78 -- Sequence "contact_ids"
79 -- Name: contact_ids; Type: SEQUENCE; Schema: public; Owner: postgres
82 CREATE SEQUENCE contact_ids
91 -- Name: contacts; Type: TABLE; Schema: public; Owner: postgres
94 CREATE TABLE contacts (
95 contact_id integer DEFAULT nextval('contact_ids'::text) PRIMARY KEY,
96 user_id integer NOT NULL REFERENCES users (user_id),
97 changed timestamp with time zone DEFAULT now() NOT NULL,
98 del integer DEFAULT 0 NOT NULL,
99 name character varying(128) DEFAULT ''::character varying NOT NULL,
100 email character varying(128) DEFAULT ''::character varying NOT NULL,
101 firstname character varying(128) DEFAULT ''::character varying NOT NULL,
102 surname character varying(128) DEFAULT ''::character varying NOT NULL,
109 -- Sequence "cache_ids"
110 -- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres
113 CREATE SEQUENCE cache_ids
121 -- Name: cache; Type: TABLE; Schema: public; Owner: postgres
124 CREATE TABLE "cache" (
125 cache_id integer DEFAULT nextval('cache_ids'::text) PRIMARY KEY,
126 user_id integer NOT NULL REFERENCES users (user_id),
127 session_id character varying(40) REFERENCES "session" (sess_id),
128 cache_key character varying(128) DEFAULT ''::character varying NOT NULL,
129 created timestamp with time zone DEFAULT now() NOT NULL,
136 -- Sequence "message_ids"
137 -- Name: message_ids; Type: SEQUENCE; Schema: public; Owner: postgres
140 CREATE SEQUENCE message_ids
148 -- Name: messages; Type: TABLE; Schema: public; Owner: postgres
151 CREATE TABLE "messages" (
152 message_id integer DEFAULT nextval('message_ids'::text) PRIMARY KEY,
153 user_id integer NOT NULL REFERENCES users (user_id),
154 del integer DEFAULT 0 NOT NULL,
155 cache_key character varying(128) DEFAULT ''::character varying NOT NULL,
156 created timestamp with time zone DEFAULT now() NOT NULL,
157 idx integer DEFAULT 0 NOT NULL,
158 uid integer DEFAULT 0 NOT NULL,
159 subject character varying(128) DEFAULT ''::character varying NOT NULL,
160 "from" character varying(128) DEFAULT ''::character varying NOT NULL,
161 "to" character varying(128) DEFAULT ''::character varying NOT NULL,
162 cc character varying(128) DEFAULT ''::character varying NOT NULL,
163 date timestamp with time zone NOT NULL,
164 size integer DEFAULT 0 NOT NULL,
165 headers text NOT NULL,