1 DROP TABLE vmail_user ;
2 DROP TABLE vmail_domain ;
3 CREATE TABLE vmail_domain (
5 name character varying(100) NOT NULL,
6 sys_user character varying(10) NOT NULL,
7 sys_edit timestamp without time zone NOT NULL
10 CREATE UNIQUE INDEX vmail_domain_id ON vmail_domain USING btree (id);
12 CREATE TABLE vmail_user (
14 vmail_domain_id integer NOT NULL,
15 username character varying(50) NOT NULL,
16 password character varying(50),
17 forward character varying(150),
18 active integer DEFAULT 0 NOT NULL,
19 sys_user character varying(10) NOT NULL,
20 sys_edit timestamp without time zone NOT NULL
23 CREATE UNIQUE INDEX vmail_user_id ON vmail_user USING btree (id);
24 CREATE INDEX vmail_user_vmail_domain_id ON vmail_user USING btree (vmail_domain_id);
26 REVOKE ALL ON TABLE vmail_user FROM PUBLIC;
27 REVOKE ALL ON TABLE vmail_user FROM joey;
28 GRANT ALL ON TABLE vmail_user TO joey;
29 GRANT ALL ON TABLE vmail_user TO "www-data";
31 REVOKE ALL ON SEQUENCE vmail_user_id_seq FROM PUBLIC;
32 REVOKE ALL ON SEQUENCE vmail_user_id_seq FROM joey;
33 GRANT ALL ON SEQUENCE vmail_user_id_seq TO joey;
34 GRANT ALL ON SEQUENCE vmail_user_id_seq TO "www-data";
36 REVOKE ALL ON TABLE vmail_domain FROM PUBLIC;
37 REVOKE ALL ON TABLE vmail_domain FROM joey;
38 GRANT ALL ON TABLE vmail_domain TO joey;
39 GRANT ALL ON TABLE vmail_domain TO "www-data";
41 REVOKE ALL ON SEQUENCE vmail_domain_id_seq FROM PUBLIC;
42 REVOKE ALL ON SEQUENCE vmail_domain_id_seq FROM joey;
43 GRANT ALL ON SEQUENCE vmail_domain_id_seq TO joey;
44 GRANT ALL ON SEQUENCE vmail_domain_id_seq TO "www-data";
46 INSERT INTO vmail_domain (name,sys_user,sys_edit) VALUES ('crossvoid.de','joey',now());
47 INSERT INTO vmail_user (vmail_domain_id,username,password,sys_user,sys_edit) VALUES (1,'joey',md5('foobarbaz'),'joey',now());