config/openmailadmin/mail.dump

   1 -- MySQL dump 10.10
   2 --
   3 -- Host: localhost    Database: mail
   4 -- ------------------------------------------------------
   5 -- Server version       5.0.24a
   6
   7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10 /*!40101 SET NAMES utf8 */;
  11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12 /*!40103 SET TIME_ZONE='+00:00' */;
  13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17
  18 --
  19 -- Database: `mail`
  20 --
  21
  22 CREATE DATABASE `mail`;
  23 USE `mail`;
  24
  25 -- --------------------------------------------------------
  26
  27 --
  28 -- Table structure for table `domains`
  29 --
  30
  31 DROP TABLE IF EXISTS `domains`;
  32 CREATE TABLE `domains` (
  33   `ID` int(10) unsigned NOT NULL auto_increment,
  34   `domain` varchar(64) NOT NULL default '',
  35   `categories` varchar(100) NOT NULL default 'all',
  36   `owner` varchar(16) NOT NULL default '',
  37   `a_admin` text,
  38   `neu` tinyint(1) NOT NULL default '1',
  39   PRIMARY KEY  (`ID`)
  40 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  41
  42 --
  43 -- Dumping data for table `domains`
  44 --
  45
  46
  47 /*!40000 ALTER TABLE `domains` DISABLE KEYS */;
  48 LOCK TABLES `domains` WRITE;
  49 UNLOCK TABLES;
  50 /*!40000 ALTER TABLE `domains` ENABLE KEYS */;
  51
  52 --
  53 -- Table structure for table `imap_demo`
  54 --
  55
  56 DROP TABLE IF EXISTS `imap_demo`;
  57 CREATE TABLE `imap_demo` (
  58   `mailbox` varchar(250) NOT NULL default '',
  59   `used` int(10) unsigned NOT NULL default '0',
  60   `qmax` int(10) unsigned NOT NULL default '0',
  61   `ACL` text,
  62   PRIMARY KEY  (`mailbox`)
  63 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  64
  65 --
  66 -- Dumping data for table `imap_demo`
  67 --
  68
  69
  70 /*!40000 ALTER TABLE `imap_demo` DISABLE KEYS */;
  71 LOCK TABLES `imap_demo` WRITE;
  72 INSERT INTO `imap_demo` VALUES ('shared',0,0,'anyone lrswipcda');
  73 UNLOCK TABLES;
  74 /*!40000 ALTER TABLE `imap_demo` ENABLE KEYS */;
  75
  76 --
  77 -- Table structure for table `user`
  78 --
  79
  80 DROP TABLE IF EXISTS `user`;
  81 CREATE TABLE `user` (
  82   `mbox` varchar(16) NOT NULL default '',
  83   `person` varchar(100) NOT NULL default '',
  84   `pate` varchar(16) NOT NULL default '',
  85   `canonical` varchar(100) NOT NULL default '',
  86   `password` varchar(40) NOT NULL default '',
  87   `domains` varchar(100) NOT NULL default '',
  88   `active` tinyint(1) NOT NULL default '0',
  89   `created` int(10) unsigned NOT NULL default '0',
  90   `last_login` int(10) unsigned NOT NULL default '0',
  91   `max_alias` int(10) unsigned NOT NULL default '1',
  92   `max_regexp` int(10) unsigned NOT NULL default '1',
  93   `a_admin_domains` tinyint(4) NOT NULL default '0',
  94   `a_admin_user` tinyint(4) NOT NULL default '0',
  95   `a_super` tinyint(4) default '0',
  96   PRIMARY KEY  (`mbox`)
  97 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  98
  99 --
 100 -- Dumping data for table `user`
 101 --
 102
 103
 104 /*!40000 ALTER TABLE `user` DISABLE KEYS */;
 105 LOCK TABLES `user` WRITE;
 106 INSERT INTO `user` VALUES ('admin','Admin John Doe','admin','admin@example.com','mailfire','all',1,1190483338,1190558772,10000,100,2,2,2),('cyrus','cyrus','cyrus','--@example.com','ipfire','none',1,1190483338,0,0,0,0,0,1);
 107 UNLOCK TABLES;
 108 /*!40000 ALTER TABLE `user` ENABLE KEYS */;
 109
 110 --
 111 -- Table structure for table `virtual`
 112 --
 113
 114 DROP TABLE IF EXISTS `virtual`;
 115 CREATE TABLE `virtual` (
 116   `address` varchar(255) NOT NULL default '',
 117   `dest` text,
 118   `owner` varchar(16) NOT NULL default '',
 119   `active` tinyint(1) NOT NULL default '1',
 120   `neu` tinyint(1) NOT NULL default '1',
 121   PRIMARY KEY  (`address`)
 122 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 123
 124 --
 125 -- Dumping data for table `virtual`
 126 --
 127
 128
 129 /*!40000 ALTER TABLE `virtual` DISABLE KEYS */;
 130 LOCK TABLES `virtual` WRITE;
 131 UNLOCK TABLES;
 132 /*!40000 ALTER TABLE `virtual` ENABLE KEYS */;
 133
 134 --
 135 -- Table structure for table `virtual_regexp`
 136 --
 137
 138 DROP TABLE IF EXISTS `virtual_regexp`;
 139 CREATE TABLE `virtual_regexp` (
 140   `ID` int(10) unsigned NOT NULL auto_increment,
 141   `reg_exp` varchar(255) NOT NULL default '',
 142   `dest` text,
 143   `owner` varchar(16) NOT NULL default '',
 144   `active` tinyint(1) NOT NULL default '0',
 145   `neu` tinyint(1) NOT NULL default '1',
 146   PRIMARY KEY  (`ID`)
 147 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 148
 149 --
 150 -- Dumping data for table `virtual_regexp`
 151 --
 152
 153
 154 /*!40000 ALTER TABLE `virtual_regexp` DISABLE KEYS */;
 155 LOCK TABLES `virtual_regexp` WRITE;
 156 UNLOCK TABLES;
 157 /*!40000 ALTER TABLE `virtual_regexp` ENABLE KEYS */;
 158 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 159
 160 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 161 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 162 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 163 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 164 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 165 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 166 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 167