Commit | Line | Data |
---|---|---|
b172472d FB |
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; | |
8 | ||
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, | |
15 | KEY (uid), | |
16 | KEY (type), | |
17 | FOREIGN KEY (uid) REFERENCES accounts (uid) ON UPDATE CASCADE ON DELETE CASCADE | |
18 | ) ENGINE=InnoDB, CHARSET=utf8 ; | |
19 | ||
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 ; | |
26 | ||
27 | CREATE TABLE homonyms_list ( | |
28 | hrmid VARCHAR(255) NOT NULL, | |
29 | uid INT(11) UNSIGNED NOT NULL, | |
30 | KEY(hrmid) | |
31 | ) ENGINE=InnoDB, CHARSET=utf8 ; | |
32 | ||
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', | |
39 | 'drop_spams', | |
40 | 'let_spams', | |
41 | 'tag_and_drop_spams', | |
42 | 'tag_spams', | |
43 | 'imap_and_bounce', | |
44 | 'homonym') | |
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, | |
52 | KEY (uid), | |
53 | KEY (redirect) | |
54 | ) ENGINE=InnoDB, CHARSET=utf8 ; | |
55 | ||
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', | |
61 | 'drop_spams', | |
62 | 'let_spams', | |
63 | 'tag_and_drop_spams', | |
64 | 'tag_spams', | |
65 | 'imap_and_bounce', | |
66 | 'homonym') | |
67 | NOT NULL DEFAULT 'default', | |
68 | KEY (hrmid), | |
69 | KEY (redirect) | |
70 | ) ENGINE=InnoDB, CHARSET=utf8 ; | |
71 | ||
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', | |
77 | KEY (email) | |
78 | ) ENGINE=InnoDB, CHARSET=utf8 ; | |
79 | ||
80 | CREATE TABLE email_virtual_domains ( | |
81 | domain VARCHAR(255) NOT NULL PRIMARY KEY | |
82 | ) ENGINE=InnoDB, CHARSET=utf8; | |
83 | ||
84 | -- vim:set syntax=mysql: |