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
8 CREATE UNIQUE INDEX vmail_domain_id ON vmail_domain USING btree (id);
10 CREATE TABLE vmail_user (
12 vmail_domain_id integer NOT NULL,
13 username character varying(50) NOT NULL,
14 password character varying(50),
15 forward character varying(150),
16 active integer DEFAULT 0 NOT NULL,
17 sys_user character varying(10) NOT NULL,
18 sys_edit timestamp without time zone NOT NULL
21 CREATE UNIQUE INDEX vmail_user_id ON vmail_user USING btree (id);
22 CREATE INDEX vmail_user_vmail_domain_id ON vmail_user USING btree (vmail_domain_id);
24 REVOKE ALL ON TABLE vmail_user FROM PUBLIC;
25 GRANT SELECT ON TABLE vmail_user TO "vmail";
26 GRANT ALL ON TABLE vmail_user TO "hallinta";
28 REVOKE ALL ON SEQUENCE vmail_user_id_seq FROM PUBLIC;
29 GRANT ALL ON SEQUENCE vmail_user_id_seq TO "hallinta";
31 REVOKE ALL ON TABLE vmail_domain FROM PUBLIC;
32 GRANT SELECT ON TABLE vmail_domain TO "vmail";
33 GRANT ALL ON TABLE vmail_domain TO "hallinta";
35 REVOKE ALL ON SEQUENCE vmail_domain_id_seq FROM PUBLIC;
36 GRANT ALL ON SEQUENCE vmail_domain_id_seq TO "hallinta";