/[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 - (hide annotations) (download)
Mon Jun 13 22:56:03 2011 UTC (3 years, 1 month 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 swift 1.1 -- MySQL dump 8.22
2     --
3     -- Host: localhost Database: mailsql
4 nightmorph 1.2 -- -------------------------------------------------------
5 swift 1.1 -- 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