2 0fd75c45 2022-07-30 mischa # Postfix Admin
3 0fd75c45 2022-07-30 mischa # by Mischa Peters <mischa at high5 dot net>
4 0fd75c45 2022-07-30 mischa # Copyright (c) 2002 - 2005 High5!
5 0fd75c45 2022-07-30 mischa # License Info: http://www.postfixadmin.com/?file=LICENSE.TXT
8 0fd75c45 2022-07-30 mischa # This is the complete MySQL database structure for Postfix Admin.
9 0fd75c45 2022-07-30 mischa # If you are installing from scratch you can use this file otherwise you
10 0fd75c45 2022-07-30 mischa # need to use the TABLE_CHANGES.TXT or TABLE_BACKUP_MX.TXT that comes with Postfix Admin.
12 0fd75c45 2022-07-30 mischa # There are 2 entries for a database user in the file.
13 0fd75c45 2022-07-30 mischa # One you can use for Postfix and one for Postfix Admin.
15 0fd75c45 2022-07-30 mischa # If you run this file twice (2x) you will get an error on the user creation in MySQL.
16 0fd75c45 2022-07-30 mischa # To go around this you can either comment the lines below "USE MySQL" until "USE postfix".
17 0fd75c45 2022-07-30 mischa # Or you can remove the users from the database and run it again.
19 0fd75c45 2022-07-30 mischa # You can create the database from the shell with:
21 0fd75c45 2022-07-30 mischa # mysql -u root [-p] < DATABASE_MYSQL.TXT
24 0fd75c45 2022-07-30 mischa # Postfix / MySQL
26 0fd75c45 2022-07-30 mischa USE mysql;
27 0fd75c45 2022-07-30 mischa # Postfix user & password
28 0fd75c45 2022-07-30 mischa INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
29 0fd75c45 2022-07-30 mischa INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
30 0fd75c45 2022-07-30 mischa # Postfix Admin user & password
31 0fd75c45 2022-07-30 mischa INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
32 0fd75c45 2022-07-30 mischa INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
33 0fd75c45 2022-07-30 mischa FLUSH PRIVILEGES;
34 0fd75c45 2022-07-30 mischa GRANT USAGE ON postfix.* TO postfix@localhost;
35 0fd75c45 2022-07-30 mischa GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfix@localhost;
36 0fd75c45 2022-07-30 mischa GRANT USAGE ON postfix.* TO postfixadmin@localhost;
37 0fd75c45 2022-07-30 mischa GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfixadmin@localhost;
38 0fd75c45 2022-07-30 mischa CREATE DATABASE postfix;
39 0fd75c45 2022-07-30 mischa USE postfix;
42 0fd75c45 2022-07-30 mischa # Table structure for table admin
44 0fd75c45 2022-07-30 mischa CREATE TABLE admin (
45 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
46 0fd75c45 2022-07-30 mischa password varchar(255) NOT NULL default '',
47 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
48 0fd75c45 2022-07-30 mischa modified datetime NOT NULL default '0000-00-00 00:00:00',
49 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
50 0fd75c45 2022-07-30 mischa PRIMARY KEY (username),
51 0fd75c45 2022-07-30 mischa KEY username (username)
52 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Admins';
55 0fd75c45 2022-07-30 mischa # Table structure for table alias
57 0fd75c45 2022-07-30 mischa CREATE TABLE alias (
58 0fd75c45 2022-07-30 mischa address varchar(255) NOT NULL default '',
59 0fd75c45 2022-07-30 mischa goto text NOT NULL,
60 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
61 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
62 0fd75c45 2022-07-30 mischa modified datetime NOT NULL default '0000-00-00 00:00:00',
63 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
64 0fd75c45 2022-07-30 mischa PRIMARY KEY (address),
65 0fd75c45 2022-07-30 mischa KEY address (address)
66 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Aliases';
69 0fd75c45 2022-07-30 mischa # Table structure for table domain
71 0fd75c45 2022-07-30 mischa CREATE TABLE domain (
72 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
73 0fd75c45 2022-07-30 mischa description varchar(255) NOT NULL default '',
74 0fd75c45 2022-07-30 mischa aliases int(10) NOT NULL default '0',
75 0fd75c45 2022-07-30 mischa mailboxes int(10) NOT NULL default '0',
76 0fd75c45 2022-07-30 mischa maxquota int(10) NOT NULL default '0',
77 0fd75c45 2022-07-30 mischa transport varchar(255) default NULL,
78 0fd75c45 2022-07-30 mischa backupmx tinyint(1) NOT NULL default '0',
79 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
80 0fd75c45 2022-07-30 mischa modified datetime NOT NULL default '0000-00-00 00:00:00',
81 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
82 0fd75c45 2022-07-30 mischa PRIMARY KEY (domain),
83 0fd75c45 2022-07-30 mischa KEY domain (domain)
84 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Domains';
87 0fd75c45 2022-07-30 mischa # Table structure for table domain_admins
89 0fd75c45 2022-07-30 mischa CREATE TABLE domain_admins (
90 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
91 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
92 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
93 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
94 0fd75c45 2022-07-30 mischa KEY username (username)
95 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Domain Admins';
98 0fd75c45 2022-07-30 mischa # Table structure for table log
100 0fd75c45 2022-07-30 mischa CREATE TABLE log (
101 0fd75c45 2022-07-30 mischa timestamp datetime NOT NULL default '0000-00-00 00:00:00',
102 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
103 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
104 0fd75c45 2022-07-30 mischa action varchar(255) NOT NULL default '',
105 0fd75c45 2022-07-30 mischa data varchar(255) NOT NULL default '',
106 0fd75c45 2022-07-30 mischa KEY timestamp (timestamp)
107 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Log';
110 0fd75c45 2022-07-30 mischa # Table structure for table mailbox
112 0fd75c45 2022-07-30 mischa CREATE TABLE mailbox (
113 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
114 0fd75c45 2022-07-30 mischa password varchar(255) NOT NULL default '',
115 0fd75c45 2022-07-30 mischa name varchar(255) NOT NULL default '',
116 0fd75c45 2022-07-30 mischa maildir varchar(255) NOT NULL default '',
117 0fd75c45 2022-07-30 mischa quota int(10) NOT NULL default '0',
118 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
119 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
120 0fd75c45 2022-07-30 mischa modified datetime NOT NULL default '0000-00-00 00:00:00',
121 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
122 0fd75c45 2022-07-30 mischa PRIMARY KEY (username),
123 0fd75c45 2022-07-30 mischa KEY username (username)
124 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes';
127 0fd75c45 2022-07-30 mischa # Table structure for table vacation
129 0fd75c45 2022-07-30 mischa CREATE TABLE vacation (
130 0fd75c45 2022-07-30 mischa email varchar(255) NOT NULL default '',
131 0fd75c45 2022-07-30 mischa subject varchar(255) NOT NULL default '',
132 0fd75c45 2022-07-30 mischa body text NOT NULL,
133 0fd75c45 2022-07-30 mischa cache text NOT NULL,
134 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
135 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
136 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
137 0fd75c45 2022-07-30 mischa PRIMARY KEY (email),
138 0fd75c45 2022-07-30 mischa KEY email (email)
139 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Vacation';
