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 # mysql -u root [-p] < TABLE_CHANGES.TXT
11 0fd75c45 2022-07-30 mischa # Table structure for table domain_admins
13 0fd75c45 2022-07-30 mischa USE postfix;
14 0fd75c45 2022-07-30 mischa CREATE TABLE IF NOT EXISTS domain_admins (
15 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
16 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
17 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
18 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
19 0fd75c45 2022-07-30 mischa KEY username (username)
20 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Domain Admins';
23 0fd75c45 2022-07-30 mischa # Table structure for table log
25 0fd75c45 2022-07-30 mischa CREATE TABLE IF NOT EXISTS log (
26 0fd75c45 2022-07-30 mischa timestamp datetime NOT NULL default '0000-00-00 00:00:00',
27 0fd75c45 2022-07-30 mischa username varchar(255) NOT NULL default '',
28 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
29 0fd75c45 2022-07-30 mischa action varchar(255) NOT NULL default '',
30 0fd75c45 2022-07-30 mischa data varchar(255) NOT NULL default '',
31 0fd75c45 2022-07-30 mischa KEY timestamp (timestamp)
32 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Log';
35 0fd75c45 2022-07-30 mischa # Table structure for table vacation
37 0fd75c45 2022-07-30 mischa CREATE TABLE IF NOT EXISTS vacation (
38 0fd75c45 2022-07-30 mischa email varchar(255) NOT NULL default '',
39 0fd75c45 2022-07-30 mischa subject varchar(255) NOT NULL default '',
40 0fd75c45 2022-07-30 mischa body text NOT NULL,
41 0fd75c45 2022-07-30 mischa cache text NOT NULL,
42 0fd75c45 2022-07-30 mischa domain varchar(255) NOT NULL default '',
43 0fd75c45 2022-07-30 mischa created datetime NOT NULL default '0000-00-00 00:00:00',
44 0fd75c45 2022-07-30 mischa active tinyint(1) NOT NULL default '1',
45 0fd75c45 2022-07-30 mischa PRIMARY KEY (email),
46 0fd75c45 2022-07-30 mischa KEY email (email)
47 0fd75c45 2022-07-30 mischa ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Vacation';
50 0fd75c45 2022-07-30 mischa # Modify table structure for table admin
52 0fd75c45 2022-07-30 mischa ALTER TABLE admin CHANGE create_date created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
53 0fd75c45 2022-07-30 mischa ALTER TABLE admin CHANGE change_date modified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
54 0fd75c45 2022-07-30 mischa ALTER TABLE admin ADD INDEX (username);
57 0fd75c45 2022-07-30 mischa # Modify table structure for table alias
59 0fd75c45 2022-07-30 mischa ALTER TABLE alias CHANGE create_date created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
60 0fd75c45 2022-07-30 mischa ALTER TABLE alias CHANGE change_date modified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
61 0fd75c45 2022-07-30 mischa ALTER TABLE alias ADD INDEX (address);
64 0fd75c45 2022-07-30 mischa # Modify table structure for table domain
66 0fd75c45 2022-07-30 mischa ALTER TABLE domain CHANGE create_date created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
67 0fd75c45 2022-07-30 mischa ALTER TABLE domain CHANGE change_date modified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
68 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD aliases INT(10) DEFAULT '-1' NOT NULL AFTER description;
69 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD mailboxes INT(10) DEFAULT '-1' NOT NULL AFTER aliases;
70 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD maxquota INT(10) DEFAULT '-1' NOT NULL AFTER mailboxes;
71 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD transport VARCHAR(255) AFTER maxquota;
72 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD backupmx TINYINT(1) DEFAULT '0' NOT NULL AFTER transport;
73 0fd75c45 2022-07-30 mischa ALTER TABLE domain ADD INDEX (domain);
76 0fd75c45 2022-07-30 mischa # Modify table structure for table mailbox
78 0fd75c45 2022-07-30 mischa ALTER TABLE mailbox CHANGE create_date created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
79 0fd75c45 2022-07-30 mischa ALTER TABLE mailbox CHANGE change_date modified DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
80 0fd75c45 2022-07-30 mischa ALTER TABLE mailbox ADD quota INT(10) DEFAULT '-1' NOT NULL AFTER maildir;
81 0fd75c45 2022-07-30 mischa ALTER TABLE mailbox ADD INDEX (username);
84 0fd75c45 2022-07-30 mischa # Modify table structure for table vacation
86 0fd75c45 2022-07-30 mischa ALTER TABLE vacation ADD domain VARCHAR(255) DEFAULT '' NOT NULL AFTER cache;
87 0fd75c45 2022-07-30 mischa ALTER TABLE vacation ADD created DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER domain;
88 0fd75c45 2022-07-30 mischa ALTER TABLE vacation ADD active TINYINT(1) DEFAULT '1' NOT NULL AFTER created;
89 0fd75c45 2022-07-30 mischa ALTER TABLE vacation DROP PRIMARY KEY, ADD PRIMARY KEY(email);
92 0fd75c45 2022-07-30 mischa # Dumping data for table domain_admins
94 0fd75c45 2022-07-30 mischa INSERT INTO domain_admins (username,domain,created) SELECT admin.username,admin.domain,domain.created FROM admin LEFT JOIN domain ON domain.domain=admin.domain;
97 0fd75c45 2022-07-30 mischa # Modify data for table vacation
99 0fd75c45 2022-07-30 mischa UPDATE vacation SET domain=SUBSTRING_INDEX(email, '@', -1) WHERE email=email;
102 0fd75c45 2022-07-30 mischa # Modify table structure for table domain
104 0fd75c45 2022-07-30 mischa ALTER TABLE admin DROP domain;
