]>
Commit | Line | Data |
---|---|---|
fc4ac7ac MT |
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 | ||
9bfa4a36 MT |
18 | -- |
19 | -- Database: `mail` | |
20 | -- | |
21 | ||
22 | CREATE DATABASE `mail`; | |
23 | USE `mail`; | |
24 | ||
25 | -- -------------------------------------------------------- | |
26 | ||
fc4ac7ac MT |
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 |