@@ -22,19 +22,19 @@ discard block |
||
22 | 22 | * Upgrade the database schema from version 29 to version 30. |
23 | 23 | */ |
24 | 24 | class Migration29 implements MigrationInterface { |
25 | - /** |
|
26 | - * Upgrade to to the next version |
|
27 | - */ |
|
28 | - public function upgrade() { |
|
29 | - // Originally migrated from PhpGedView, but never used. |
|
30 | - Database::exec("DROP TABLE IF EXISTS `##ip_address`"); |
|
25 | + /** |
|
26 | + * Upgrade to to the next version |
|
27 | + */ |
|
28 | + public function upgrade() { |
|
29 | + // Originally migrated from PhpGedView, but never used. |
|
30 | + Database::exec("DROP TABLE IF EXISTS `##ip_address`"); |
|
31 | 31 | |
32 | - // No longer used |
|
33 | - Database::exec("DELETE FROM `##user_setting` WHERE setting_name IN ('editaccount')"); |
|
34 | - Database::exec("DELETE FROM `##gedcom_setting` WHERE setting_name IN ('SHOW_STATS')"); |
|
35 | - Database::exec("DELETE FROM `##site_setting` WHERE setting_name IN ('REQUIRE_ADMIN_AUTH_REGISTRATION')"); |
|
32 | + // No longer used |
|
33 | + Database::exec("DELETE FROM `##user_setting` WHERE setting_name IN ('editaccount')"); |
|
34 | + Database::exec("DELETE FROM `##gedcom_setting` WHERE setting_name IN ('SHOW_STATS')"); |
|
35 | + Database::exec("DELETE FROM `##site_setting` WHERE setting_name IN ('REQUIRE_ADMIN_AUTH_REGISTRATION')"); |
|
36 | 36 | |
37 | - // https://bugs.launchpad.net/webtrees/+bug/1405672 |
|
37 | + // https://bugs.launchpad.net/webtrees/+bug/1405672 |
|
38 | 38 | try { |
39 | 39 | Database::exec( |
40 | 40 | "UPDATE `##site_access_rule` SET user_agent_pattern = 'Mozilla/5.0 (% Konqueror/%'" . |
@@ -44,32 +44,32 @@ discard block |
||
44 | 44 | // Duplicate key? Already done? |
45 | 45 | } |
46 | 46 | |
47 | - // Embedded variables are based on function names - which were renamed for PSR2 |
|
48 | - Database::exec( |
|
49 | - "UPDATE `##block_setting` " . |
|
50 | - " JOIN `##block` USING (block_id)" . |
|
51 | - " SET setting_value = REPLACE(setting_value, '#WT_VERSION#', '#webtreesVersion#')" . |
|
52 | - " WHERE setting_name = 'html' AND module_name = 'html'" |
|
53 | - ); |
|
54 | - Database::exec( |
|
55 | - "UPDATE `##block_setting` " . |
|
56 | - " JOIN `##block` USING (block_id)" . |
|
57 | - " SET setting_value = REPLACE(setting_value, '#browserTime24#', '#browserTime#')" . |
|
58 | - " WHERE setting_name = 'html' AND module_name = 'html'" |
|
59 | - ); |
|
47 | + // Embedded variables are based on function names - which were renamed for PSR2 |
|
48 | + Database::exec( |
|
49 | + "UPDATE `##block_setting` " . |
|
50 | + " JOIN `##block` USING (block_id)" . |
|
51 | + " SET setting_value = REPLACE(setting_value, '#WT_VERSION#', '#webtreesVersion#')" . |
|
52 | + " WHERE setting_name = 'html' AND module_name = 'html'" |
|
53 | + ); |
|
54 | + Database::exec( |
|
55 | + "UPDATE `##block_setting` " . |
|
56 | + " JOIN `##block` USING (block_id)" . |
|
57 | + " SET setting_value = REPLACE(setting_value, '#browserTime24#', '#browserTime#')" . |
|
58 | + " WHERE setting_name = 'html' AND module_name = 'html'" |
|
59 | + ); |
|
60 | 60 | |
61 | - // Language settings have changed from locale (en_GB) to language tag (en-GB) |
|
62 | - Database::exec( |
|
63 | - "UPDATE `##gedcom_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
64 | - ); |
|
65 | - Database::exec( |
|
66 | - "UPDATE `##site_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
67 | - ); |
|
68 | - Database::exec( |
|
69 | - "UPDATE `##user_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
70 | - ); |
|
71 | - Database::exec( |
|
72 | - "UPDATE `##block_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'languages'" |
|
73 | - ); |
|
74 | - } |
|
61 | + // Language settings have changed from locale (en_GB) to language tag (en-GB) |
|
62 | + Database::exec( |
|
63 | + "UPDATE `##gedcom_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
64 | + ); |
|
65 | + Database::exec( |
|
66 | + "UPDATE `##site_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
67 | + ); |
|
68 | + Database::exec( |
|
69 | + "UPDATE `##user_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'language'" |
|
70 | + ); |
|
71 | + Database::exec( |
|
72 | + "UPDATE `##block_setting` SET setting_value = REPLACE(setting_value, '_', '-') WHERE setting_name = 'languages'" |
|
73 | + ); |
|
74 | + } |
|
75 | 75 | } |