install.d/emails/install.sql

   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