/[gentoo]/xml/htdocs/doc/en/files/genericmailsql.sql
Gentoo

Contents of /xml/htdocs/doc/en/files/genericmailsql.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (show annotations) (download)
Mon Jun 13 22:56:03 2011 UTC (3 years, 4 months ago) by nightmorph
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +1 -1 lines
fix commenting in sql example, updated version by swift on bug 369673

1 -- MySQL dump 8.22
2 --
3 -- Host: localhost Database: mailsql
4 -- -------------------------------------------------------
5 -- Server version 3.23.52-log
6
7 --
8 -- Table structure for table 'alias'
9 --
10
11 DROP TABLE IF EXISTS alias;
12 CREATE TABLE alias (
13 id int(11) NOT NULL auto_increment,
14 alias varchar(128) NOT NULL default '',
15 destination varchar(128) NOT NULL default '',
16 PRIMARY KEY (id)
17 ) TYPE=MyISAM;
18
19 /*!40000 ALTER TABLE alias DISABLE KEYS */;
20
21 --
22 -- Dumping data for table 'alias'
23 --
24
25
26 LOCK TABLES alias WRITE;
27 INSERT INTO alias VALUES (1,'root','root@domain.com'),(2,'postmaster','postmaster@domain.com');
28
29 /*!40000 ALTER TABLE alias ENABLE KEYS */;
30 UNLOCK TABLES;
31
32 --
33 -- Table structure for table 'relocated'
34 --
35
36 DROP TABLE IF EXISTS relocated;
37 CREATE TABLE relocated (
38 id int(11) NOT NULL auto_increment,
39 email varchar(128) NOT NULL default '',
40 destination varchar(128) NOT NULL default '',
41 PRIMARY KEY (id)
42 ) TYPE=MyISAM;
43
44 /*!40000 ALTER TABLE relocated DISABLE KEYS */;
45
46 --
47 -- Dumping data for table 'relocated'
48 --
49
50
51 LOCK TABLES relocated WRITE;
52
53 /*!40000 ALTER TABLE relocated ENABLE KEYS */;
54 UNLOCK TABLES;
55
56 --
57 -- Table structure for table 'transport'
58 --
59
60 DROP TABLE IF EXISTS transport;
61 CREATE TABLE transport (
62 id int(11) NOT NULL auto_increment,
63 domain varchar(128) NOT NULL default '',
64 destination varchar(128) NOT NULL default '',
65 PRIMARY KEY (id),
66 UNIQUE KEY domain (domain)
67 ) TYPE=MyISAM;
68
69 /*!40000 ALTER TABLE transport DISABLE KEYS */;
70
71 --
72 -- Dumping data for table 'transport'
73 --
74
75
76 LOCK TABLES transport WRITE;
77 INSERT INTO transport VALUES (1,'domain.com','local:'),(2,'domain2.com','virtual:');
78
79 /*!40000 ALTER TABLE transport ENABLE KEYS */;
80 UNLOCK TABLES;
81
82 --
83 -- Table structure for table 'users'
84 --
85
86 DROP TABLE IF EXISTS users;
87 CREATE TABLE users (
88 id int(11) NOT NULL auto_increment,
89 email varchar(128) NOT NULL default '',
90 clear varchar(128) NOT NULL default '',
91 name tinytext NOT NULL,
92 uid int(11) NOT NULL default '1101',
93 gid int(11) NOT NULL default '1101',
94 homedir tinytext NOT NULL,
95 maildir tinytext NOT NULL,
96 quota tinytext NOT NULL,
97 postfix enum('n','y') NOT NULL default 'y',
98 PRIMARY KEY (id),
99 UNIQUE KEY email (email)
100 ) TYPE=MyISAM;
101
102 /*!40000 ALTER TABLE users DISABLE KEYS */;
103
104 --
105 -- Dumping data for table 'users'
106 --
107
108
109 LOCK TABLES users WRITE;
110 INSERT INTO users VALUES (1,'first@domain.com','password','first local user',1200,1200,'/home/first','/home/first/.maildir/','','y'),(2,'second@domain2.com','password','second user who lives in a virtual domain',1101,1101,'/home/vmail','/home/vmail/domain2.com/second/.maildir/','','y');
111
112 /*!40000 ALTER TABLE users ENABLE KEYS */;
113 UNLOCK TABLES;
114
115 --
116 -- Table structure for table 'virtual'
117 --
118
119 DROP TABLE IF EXISTS virtual;
120 CREATE TABLE virtual (
121 id int(11) NOT NULL auto_increment,
122 email varchar(128) NOT NULL default '',
123 destination varchar(128) NOT NULL default '',
124 PRIMARY KEY (id)
125 ) TYPE=MyISAM;
126
127 /*!40000 ALTER TABLE virtual DISABLE KEYS */;
128
129 --
130 -- Dumping data for table 'virtual'
131 --
132
133
134 LOCK TABLES virtual WRITE;
135
136 /*!40000 ALTER TABLE virtual ENABLE KEYS */;
137 UNLOCK TABLES;

  ViewVC Help
Powered by ViewVC 1.1.20