E3RRhfN3

1CREATE SEQUENCE seq_aliases_pkid;
2
3CREATE TABLE IF NOT EXISTS aliases (
4    pkid INT NOT NULL DEFAULT nextval('seq_aliases_pkid'),
5    mail VARCHAR(120) NOT NULL default '',
6    destination VARCHAR(120) NOT NULL default '',
7    enabled BOOLEAN NOT NULL default true,
8    PRIMARY KEY (pkid)
9);
10
11ALTER SEQUENCE seq_aliases_pkid OWNED BY aliases.pkid;
12CREATE UNIQUE INDEX idx_aliases_mail ON aliases(mail);
13
14CREATE SEQUENCE seq_domains_pkid;
15
16CREATE TABLE IF NOT EXISTS domains (
17    pkid INT NOT NULL DEFAULT nextval('seq_domains_pkid'),
18    domain VARCHAR(120) NOT NULL default '',
19    transport VARCHAR(120) NOT NULL default 'virtual:',
20    enabled BOOLEAN NOT NULL default true,
21    PRIMARY KEY (pkid)
22);
23
24ALTER SEQUENCE seq_domains_pkid OWNED BY domains.pkid;
25
26CREATE TABLE IF NOT EXISTS users (
27    id VARCHAR(128) NOT NULL default '',
28    name VARCHAR(128) NOT NULL default '',
29    uid INT NOT NULL default '5000',
30    gid INT NOT NULL default '5000',
31    home VARCHAR(255) NOT NULL default '/var/spool/mail/virtual',
32    maildir VARCHAR(255) NOT NULL default 'foobar/',
33    enabled BOOLEAN NOT NULL default true,
34    change_password BOOLEAN NOT NULL default true,
35    clear VARCHAR(128) NOT NULL default 'this should not be a real password horse table vape 654321',
36    crypt VARCHAR(128) NOT NULL default 'sdtrusfX0Jj66',
37    quota VARCHAR(255) NOT NULL default '',
38    PRIMARY KEY (id)
39);
40
41CREATE UNIQUE INDEX idx_users_id ON users(id);