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,
31 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
33 CREATE TABLE email_redirect_account (
34 uid
INT(11) UNSIGNED
NOT NULL,
35 redirect
VARCHAR(255) NOT NULL DEFAULT '',
36 rewrite
VARCHAR(255) NOT NULL DEFAULT '',
37 type ENUM('smtp','googleapps','imap','homonym') NOT NULL DEFAULT 'smtp',
38 action ENUM('default',
45 NOT NULL DEFAULT 'default',
46 broken
DATE NOT NULL DEFAULT '0000-00-00',
47 broken_level
TINYINT(1) NOT NULL DEFAULT 0,
48 last DATE NOT NULL DEFAULT '0000-00-00',
49 flags
ENUM('active','broken','disabled') NOT NULL,
50 hash
VARCHAR(32) DEFAULT NULL,
51 allow_rewrite
TINYINT(1) DEFAULT 0,
54 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
56 CREATE TABLE email_redirect_other (
57 hrmid
VARCHAR(255) NOT NULL DEFAULT '',
58 redirect
VARCHAR(255) NOT NULL DEFAULT '',
59 type ENUM('smtp','googleapps','imap','homonym') NOT NULL DEFAULT 'smtp',
60 action ENUM('default',
67 NOT NULL DEFAULT 'default',
70 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
72 CREATE TABLE email_virtual (
73 email
VARCHAR(255) NOT NULL,
74 redirect
VARCHAR(255) NOT NULL,
75 type ENUM('user','list','domain','event','admin','partner'),
76 expire
DATE NOT NULL DEFAULT '0000-00-00',
78 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
80 CREATE TABLE email_virtual_domains (
81 domain VARCHAR(255) NOT NULL PRIMARY KEY
82 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
84 -- vim:set syntax=mysql: