| 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 | -- |
