2 -- Table structure for table `emails`
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)),
14 ) TYPE=MyISAM PACK_KEYS
=1 COMMENT='listes des emails';
17 -- Table structure for table `virtual`
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',
25 UNIQUE KEY `
alias`
(`
alias`
)
29 -- Table structure for table `virtual_domains`
32 CREATE TABLE `virtual_domains`
(
33 `
domain`
varchar(255) NOT NULL default '',
34 PRIMARY KEY (`
domain`
)
38 -- Table structure for table `virtual_redirect`
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`
)