From cb2bb1c1eeaed549327e862ef9568b06463adee2 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 11 Apr 2015 05:24:06 +0200 Subject: Core/Misc: Update page text locale to simple system --- sql/updates/world/2015_04_11_03_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2015_04_11_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_04_11_03_world.sql b/sql/updates/world/2015_04_11_03_world.sql new file mode 100644 index 00000000000..4dc3cce9542 --- /dev/null +++ b/sql/updates/world/2015_04_11_03_world.sql @@ -0,0 +1,12 @@ +DROP TABLE IF EXISTS `locales_page_text`; + +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' +) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +ALTER TABLE `page_text_locale` + ADD PRIMARY KEY (`ID`,`locale`); -- cgit v1.2.3