1 CREATE TABLE vmail_domain (
3 name character varying(100) NOT NULL,
4 sys_user character varying(10) NOT NULL,
5 sys_edit timestamp without time zone NOT NULL,
9 CREATE UNIQUE INDEX vmail_domain_id ON vmail_domain USING btree (id);
11 CREATE TABLE vmail_user (
13 vmail_domain_id integer NOT NULL,
14 username character varying(50) NOT NULL,
15 password character varying(50),
16 active integer DEFAULT 0 NOT NULL,
17 sys_user character varying(10) NOT NULL,
18 sys_edit timestamp without time zone NOT NULL,
19 UNIQUE(vmail_domain_id,username)
22 CREATE UNIQUE INDEX vmail_user_id ON vmail_user USING btree (id);
23 CREATE INDEX vmail_user_vmail_domain_id ON vmail_user USING btree (vmail_domain_id);
25 -- ALTER TABLE ONLY vmail_user
26 -- ADD CONSTRAINT vmail_user_vmail_domain_id_username_key UNIQUE (vmail_domain_id, username);
28 CREATE TABLE vmail_alias (
30 vmail_domain_id integer NOT NULL,
31 username character varying(50) NOT NULL,
32 destination TEXT DEFAULT NULL,
33 active integer DEFAULT 0 NOT NULL,
34 sys_user character varying(10) NOT NULL,
35 sys_edit timestamp without time zone NOT NULL,
36 UNIQUE(vmail_domain_id,username)
39 CREATE UNIQUE INDEX vmail_alias_id ON vmail_alias USING btree (id);
40 CREATE INDEX vmail_alias_vmail_domain_id ON vmail_alias USING btree (vmail_domain_id);
42 REVOKE ALL ON TABLE vmail_user FROM PUBLIC;
43 GRANT SELECT ON TABLE vmail_user TO "vmail";
44 GRANT ALL ON TABLE vmail_user TO "hallinta";
46 REVOKE ALL ON SEQUENCE vmail_user_id_seq FROM PUBLIC;
47 GRANT ALL ON SEQUENCE vmail_user_id_seq TO "hallinta";
49 REVOKE ALL ON TABLE vmail_alias FROM PUBLIC;
50 GRANT SELECT ON TABLE vmail_alias TO "vmail";
51 GRANT ALL ON TABLE vmail_alias TO "hallinta";
53 REVOKE ALL ON SEQUENCE vmail_alias_id_seq FROM PUBLIC;
54 GRANT ALL ON SEQUENCE vmail_alias_id_seq TO "hallinta";
56 REVOKE ALL ON TABLE vmail_domain FROM PUBLIC;
57 GRANT SELECT ON TABLE vmail_domain TO "vmail";
58 GRANT ALL ON TABLE vmail_domain TO "hallinta";
60 REVOKE ALL ON SEQUENCE vmail_domain_id_seq FROM PUBLIC;
61 GRANT ALL ON SEQUENCE vmail_domain_id_seq TO "hallinta";