dip/upgrade.mysql at master · daftano/dip · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

# commands for the first step to upgrade GnuDIP database to 2.3

######################################
# use GnuDIP database

use gnudip2;
#   ^ GnuDIP database

######################################
# queue

drop table queue;

######################################
# domains

alter table domains drop column zonefile;
alter table domains drop column zonetype;

######################################
# users

alter table users add column MXvalue   varchar(60);
alter table users add column MXbackup  enum('YES','NO') default 'NO' not null;
alter table users add column wildcard  enum('YES','NO') default 'NO' not null;
alter table users add column allowwild enum('YES','NO') default 'NO' not null;
alter table users add column allowmx   enum('YES','NO') default 'NO' not null;