summaryrefslogtreecommitdiffstats
path: root/TABLE_BACKUP_MX.TXT
blob: 9a9f9388d9e7fd0f4540cca1667bdc2f0cf199d0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#
# Postfix Admin
# by Mischa Peters <mischa at high5 dot net>
# Copyright (c) 2002 - 2005 High5!
# License Info: http://www.postfixadmin.com/?file=LICENSE.TXT
#

# mysql -u root [-p] < TABLE_BACKUP_MX.TXT

#
# Table structure for table domain_admins
#
USE postfix;

#
# Modify table structure for table domain
#
ALTER TABLE domain ADD transport VARCHAR(255) AFTER maxquota;
ALTER TABLE domain ADD backupmx TINYINT(1) DEFAULT '0' NOT NULL AFTER transport;