commit | author | age
|
e5fe2a
|
1 |
-- Migrate database from version 2.2 to version 2.3 |
b127d6
|
2 |
-- |
PB |
3 |
|
|
4 |
-- |
|
5 |
-- table: domain_option |
|
6 |
-- |
|
7 |
INSERT INTO domain_option (domain_option_name) |
e5fe2a
|
8 |
VALUES ('php'); |
b127d6
|
9 |
-- |
PB |
10 |
-- new domain options settings |
|
11 |
-- |
e5fe2a
|
12 |
-- existing default = On for DW-packet, Off otherwise. |
PB |
13 |
-- |
b127d6
|
14 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
e5fe2a
|
15 |
FROM domain |
PB |
16 |
JOIN unixuser on ( domain.domain_owner = unixuser.unixuser_id ) |
|
17 |
JOIN packet on ( unixuser.packet_id = packet.packet_id ) |
|
18 |
JOIN basepacket on ( packet.bp_id = basepacket.basepacket_id ) |
|
19 |
, domain_option |
|
20 |
WHERE basepacket.basepacket_code = 'DW/B' |
|
21 |
AND domain_option.domain_option_name = 'php' ; |
|
22 |
DELETE FROM domain__domain_option USING domain_option, domain |
|
23 |
JOIN unixuser on ( domain.domain_owner = unixuser.unixuser_id ) |
|
24 |
JOIN packet on ( unixuser.packet_id = packet.packet_id ) |
|
25 |
JOIN basepacket on ( packet.bp_id = basepacket.basepacket_id ) |
|
26 |
WHERE basepacket.basepacket_code != 'DW/B' |
|
27 |
AND domain__domain_option.domain_option_id = domain_option.domain_option_id |
|
28 |
AND domain_option.domain_option_name = 'php' ; |
b127d6
|
29 |
-- |
e5fe2a
|
30 |
-- End of migration to version 2.3 |
b127d6
|
31 |
-- |