0337d704 |
1 | -- |
2 | -- Table structure for table `emails` |
3 | -- |
4 | |
5 | CREATE TABLE `emails` ( |
6 | `uid` smallint(5) unsigned NOT NULL default '0', |
7 | `email` char(60) NOT NULL default '', |
8 | `rewrite` char(128) NOT NULL default '', |
9 | `panne` date NOT NULL default '0000-00-00', |
10 | `flags` enum('active','filter') NOT NULL default '', |
11 | PRIMARY KEY (`uid`,`email`), |
12 | KEY `emails` (`email`(20)), |
13 | KEY `uid` (`uid`) |
14 | ) TYPE=MyISAM PACK_KEYS=1 COMMENT='listes des emails'; |
15 | |
16 | -- |
17 | -- Table structure for table `virtual` |
18 | -- |
19 | |
20 | CREATE TABLE `virtual` ( |
21 | `vid` int(11) NOT NULL auto_increment, |
22 | `alias` varchar(255) NOT NULL default '', |
23 | `type` enum('user','list','dom') NOT NULL default 'user', |
24 | PRIMARY KEY (`vid`), |
25 | UNIQUE KEY `alias` (`alias`) |
26 | ) TYPE=MyISAM; |
27 | |
28 | -- |
29 | -- Table structure for table `virtual_domains` |
30 | -- |
31 | |
32 | CREATE TABLE `virtual_domains` ( |
33 | `domain` varchar(255) NOT NULL default '', |
34 | PRIMARY KEY (`domain`) |
35 | ) TYPE=MyISAM; |
36 | |
37 | -- |
38 | -- Table structure for table `virtual_redirect` |
39 | -- |
40 | |
41 | CREATE TABLE `virtual_redirect` ( |
42 | `vid` int(11) NOT NULL auto_increment, |
43 | `redirect` varchar(255) NOT NULL default '', |
44 | PRIMARY KEY (`vid`,`redirect`), |
45 | KEY `redirect` (`redirect`) |
46 | ) TYPE=MyISAM; |
47 | |