1 DROP TABLE IF EXISTS email_source_account
;
2 DROP TABLE IF EXISTS email_source_other
;
3 DROP TABLE IF EXISTS homonyms_list
;
4 DROP TABLE IF EXISTS email_redirect_account
;
5 DROP TABLE IF EXISTS email_redirect_other
;
6 DROP TABLE IF EXISTS email_virtual
;
7 DROP TABLE IF EXISTS email_virtual_domains
;
9 CREATE TABLE email_source_account (
10 email
VARCHAR(255) NOT NULL PRIMARY KEY,
11 uid
INT(11) UNSIGNED
NOT NULL,
12 type ENUM('forlife', 'alias') NOT NULL DEFAULT 'forlife',
13 flags
SET('bestalias', 'usage', 'marital') NOT NULL DEFAULT '',
14 expire
DATE DEFAULT NULL,
17 FOREIGN KEY (uid
) REFERENCES accounts (uid
) ON UPDATE CASCADE ON DELETE CASCADE
18 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
20 CREATE TABLE email_source_other (
21 email
VARCHAR(255) NOT NULL PRIMARY KEY,
22 hrmid
VARCHAR(255) NOT NULL,
23 type ENUM('homonym', 'ax', 'honeypot'),
24 expire
DATE NOT NULL DEFAULT '0000-00-00'
25 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
27 CREATE TABLE homonyms_list (
28 hrmid
VARCHAR(255) NOT NULL,
29 uid
INT(11) UNSIGNED
NOT NULL,
30 PRIMARY KEY (hrmid
, uid
),
31 FOREIGN KEY (uid
) REFERENCES accounts (uid
) ON UPDATE CASCADE ON DELETE CASCADE
32 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
34 CREATE TABLE email_redirect_account (
35 uid
INT(11) UNSIGNED
NOT NULL,
36 redirect
VARCHAR(255) NOT NULL DEFAULT '',
37 rewrite
VARCHAR(255) NOT NULL DEFAULT '',
38 type ENUM('smtp', 'googleapps', 'imap', 'homonym') NOT NULL DEFAULT 'smtp',
39 action ENUM('default', 'drop_spams', 'let_spams', 'tag_and_drop_spams', 'tag_spams', 'imap_and_bounce', 'homonym') NOT NULL DEFAULT 'default',
40 broken_date
DATE NOT NULL DEFAULT '0000-00-00',
41 broken_level
TINYINT(1) NOT NULL DEFAULT 0,
42 last DATE NOT NULL DEFAULT '0000-00-00',
43 flags
ENUM('active', 'inactive', 'broken', 'disabled') NOT NULL,
44 hash
VARCHAR(32) DEFAULT NULL,
45 allow_rewrite
TINYINT(1) DEFAULT 0,
46 PRIMARY KEY (uid
, redirect
),
49 FOREIGN KEY (uid
) REFERENCES accounts (uid
) ON UPDATE CASCADE ON DELETE CASCADE
50 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
52 CREATE TABLE email_redirect_other (
53 hrmid
VARCHAR(255) NOT NULL DEFAULT '',
54 redirect
VARCHAR(255) NOT NULL DEFAULT '',
55 type ENUM('smtp', 'googleapps', 'imap', 'homonym') NOT NULL DEFAULT 'smtp',
56 action ENUM('default', 'drop_spams', 'let_spams', 'tag_and_drop_spams', 'tag_spams', 'imap_and_bounce', 'homonym') NOT NULL DEFAULT 'default',
57 PRIMARY KEY (hrmid
, redirect
),
60 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
62 CREATE TABLE email_virtual (
63 email
VARCHAR(255) NOT NULL,
64 redirect
VARCHAR(255) NOT NULL,
65 type ENUM('user', 'list', 'domain', 'event', 'admin', 'partner'),
66 expire
DATE NOT NULL DEFAULT '0000-00-00',
67 PRIMARY KEY (email
, domain, redirect
),
69 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
71 CREATE TABLE email_virtual_domains (
72 domain VARCHAR(255) NOT NULL PRIMARY KEY
73 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
75 -- vim:set syntax=mysql: