From a1969a3ad5fb1971bf9650b0d32fff23cbdab9b8 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 18 Apr 2017 13:07:01 +0200 Subject: Rename 2017_xx_xx_xx_world_335.sql to 2017_04_18_00_world_335.sql --- .../world/3.3.5/2017_04_18_00_world_335.sql | 87 ++++++++++++++++++++++ .../world/3.3.5/2017_xx_xx_xx_world_335.sql | 87 ---------------------- 2 files changed, 87 insertions(+), 87 deletions(-) create mode 100644 sql/updates/world/3.3.5/2017_04_18_00_world_335.sql delete mode 100644 sql/updates/world/3.3.5/2017_xx_xx_xx_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_04_18_00_world_335.sql b/sql/updates/world/3.3.5/2017_04_18_00_world_335.sql new file mode 100644 index 00000000000..1ab4ea167c9 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_04_18_00_world_335.sql @@ -0,0 +1,87 @@ +DROP TABLE IF EXISTS `points_of_interest_locale`; +CREATE TABLE IF NOT EXISTS `points_of_interest_locale` ( + `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `locale` VARCHAR(4) NOT NULL, + `Name` TEXT, + `VerifiedBuild` SMALLINT(5) DEFAULT '0', + PRIMARY KEY (`ID`, `locale`) +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +-- koKR +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "koKR", `icon_name_loc1` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc1) > 0); + +-- frFR +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "frFR", `icon_name_loc2` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc2) > 0); + +-- deDE +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "deDE", `icon_name_loc3` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc3) > 0); + +-- zhCN +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "zhCN", `icon_name_loc4` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc4) > 0); + +-- zhTW +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "zhTW", `icon_name_loc5` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc5) > 0); + +-- esES +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "esES", `icon_name_loc6` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc6) > 0); + +-- esMX +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "esMX", `icon_name_loc7` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc7) > 0); + +-- ruRU +INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) + (SELECT `entry`, "ruRU", `icon_name_loc8` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc8) > 0); + +DROP TABLE IF EXISTS `locales_points_of_interest`; + +DROP TABLE IF EXISTS `page_text_locale`; +CREATE TABLE IF NOT EXISTS `page_text_locale` ( + `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `locale` VARCHAR(4) NOT NULL, + `Text` TEXT, + `VerifiedBuild` SMALLINT(5) DEFAULT '0', + PRIMARY KEY (`ID`, `locale`) +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +-- koKR +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "koKR", `text_loc1` FROM `locales_page_text` WHERE LENGTH(text_loc1) > 0); + +-- frFR +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "frFR", `text_loc2` FROM `locales_page_text` WHERE LENGTH(text_loc2) > 0); + +-- deDE +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "deDE", `text_loc3` FROM `locales_page_text` WHERE LENGTH(text_loc3) > 0); + +-- zhCN +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "zhCN", `text_loc4` FROM `locales_page_text` WHERE LENGTH(text_loc4) > 0); + +-- zhTW +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "zhTW", `text_loc5` FROM `locales_page_text` WHERE LENGTH(text_loc5) > 0); + +-- esES +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "esES", `text_loc6` FROM `locales_page_text` WHERE LENGTH(text_loc6) > 0); + +-- esMX +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "esMX", `text_loc7` FROM `locales_page_text` WHERE LENGTH(text_loc7) > 0); + +-- ruRU +INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) + (SELECT `entry`, "ruRU", `text_loc8` FROM `locales_page_text` WHERE LENGTH(text_loc8) > 0); + +DROP TABLE IF EXISTS `locales_page_text`; + +ALTER TABLE `points_of_interest` CHANGE `data` `Importance` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql/updates/world/3.3.5/2017_xx_xx_xx_world_335.sql b/sql/updates/world/3.3.5/2017_xx_xx_xx_world_335.sql deleted file mode 100644 index 1ab4ea167c9..00000000000 --- a/sql/updates/world/3.3.5/2017_xx_xx_xx_world_335.sql +++ /dev/null @@ -1,87 +0,0 @@ -DROP TABLE IF EXISTS `points_of_interest_locale`; -CREATE TABLE IF NOT EXISTS `points_of_interest_locale` ( - `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', - `locale` VARCHAR(4) NOT NULL, - `Name` TEXT, - `VerifiedBuild` SMALLINT(5) DEFAULT '0', - PRIMARY KEY (`ID`, `locale`) -) ENGINE=MYISAM DEFAULT CHARSET=utf8; - --- koKR -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "koKR", `icon_name_loc1` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc1) > 0); - --- frFR -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "frFR", `icon_name_loc2` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc2) > 0); - --- deDE -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "deDE", `icon_name_loc3` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc3) > 0); - --- zhCN -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "zhCN", `icon_name_loc4` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc4) > 0); - --- zhTW -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "zhTW", `icon_name_loc5` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc5) > 0); - --- esES -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "esES", `icon_name_loc6` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc6) > 0); - --- esMX -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "esMX", `icon_name_loc7` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc7) > 0); - --- ruRU -INSERT INTO `points_of_interest_locale` (`ID`, `locale`, `Name`) - (SELECT `entry`, "ruRU", `icon_name_loc8` FROM `locales_points_of_interest` WHERE LENGTH(icon_name_loc8) > 0); - -DROP TABLE IF EXISTS `locales_points_of_interest`; - -DROP TABLE IF EXISTS `page_text_locale`; -CREATE TABLE IF NOT EXISTS `page_text_locale` ( - `ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', - `locale` VARCHAR(4) NOT NULL, - `Text` TEXT, - `VerifiedBuild` SMALLINT(5) DEFAULT '0', - PRIMARY KEY (`ID`, `locale`) -) ENGINE=MYISAM DEFAULT CHARSET=utf8; - --- koKR -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "koKR", `text_loc1` FROM `locales_page_text` WHERE LENGTH(text_loc1) > 0); - --- frFR -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "frFR", `text_loc2` FROM `locales_page_text` WHERE LENGTH(text_loc2) > 0); - --- deDE -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "deDE", `text_loc3` FROM `locales_page_text` WHERE LENGTH(text_loc3) > 0); - --- zhCN -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "zhCN", `text_loc4` FROM `locales_page_text` WHERE LENGTH(text_loc4) > 0); - --- zhTW -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "zhTW", `text_loc5` FROM `locales_page_text` WHERE LENGTH(text_loc5) > 0); - --- esES -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "esES", `text_loc6` FROM `locales_page_text` WHERE LENGTH(text_loc6) > 0); - --- esMX -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "esMX", `text_loc7` FROM `locales_page_text` WHERE LENGTH(text_loc7) > 0); - --- ruRU -INSERT INTO `page_text_locale` (`ID`, `locale`, `Text`) - (SELECT `entry`, "ruRU", `text_loc8` FROM `locales_page_text` WHERE LENGTH(text_loc8) > 0); - -DROP TABLE IF EXISTS `locales_page_text`; - -ALTER TABLE `points_of_interest` CHANGE `data` `Importance` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'; -- cgit v1.2.3