diff options
author | Seline <none@none> | 2008-10-03 15:33:07 -0500 |
---|---|---|
committer | Seline <none@none> | 2008-10-03 15:33:07 -0500 |
commit | be22d45c0f6b4278709713d5457ec77853252796 (patch) | |
tree | 28dc122cda09fd026fd4e3fa880dfb25b4bb7f48 /sql/updates/0.8/4579.sql | |
parent | 9b1c0e006f20091f28f3f468cfcab1feb51286bd (diff) |
[svn] * Remove all unneeded sql updates.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/0.8/4579.sql')
-rw-r--r-- | sql/updates/0.8/4579.sql | 274 |
1 files changed, 0 insertions, 274 deletions
diff --git a/sql/updates/0.8/4579.sql b/sql/updates/0.8/4579.sql deleted file mode 100644 index 49b9ba70f1e..00000000000 --- a/sql/updates/0.8/4579.sql +++ /dev/null @@ -1,274 +0,0 @@ -DROP TABLE IF EXISTS `locales_creature`; -CREATE TABLE `locales_creature` ( - `entry` int(11) unsigned NOT NULL default '0', - `name_loc1` varchar(100) NOT NULL default '', - `name_loc2` varchar(100) NOT NULL default '', - `name_loc3` varchar(100) NOT NULL default '', - `name_loc4` varchar(100) NOT NULL default '', - `name_loc5` varchar(100) NOT NULL default '', - `name_loc6` varchar(100) NOT NULL default '', - `name_loc7` varchar(100) NOT NULL default '', - `subname_loc1` varchar(100) default NULL, - `subname_loc2` varchar(100) default NULL, - `subname_loc3` varchar(100) default NULL, - `subname_loc4` varchar(100) default NULL, - `subname_loc5` varchar(100) default NULL, - `subname_loc6` varchar(100) default NULL, - `subname_loc7` varchar(100) default NULL, - `subname_loc8` varchar(100) default NULL, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `locales_gameobject`; -CREATE TABLE `locales_gameobject` ( - `entry` int(11) unsigned NOT NULL default '0', - `name_loc1` varchar(100) NOT NULL default '', - `name_loc2` varchar(100) NOT NULL default '', - `name_loc3` varchar(100) NOT NULL default '', - `name_loc4` varchar(100) NOT NULL default '', - `name_loc5` varchar(100) NOT NULL default '', - `name_loc6` varchar(100) NOT NULL default '', - `name_loc7` varchar(100) NOT NULL default '', - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `locales_item`; -CREATE TABLE `locales_item` ( - `entry` int(11) unsigned NOT NULL default '0', - `name_loc1` varchar(100) NOT NULL default '', - `name_loc2` varchar(100) NOT NULL default '', - `name_loc3` varchar(100) NOT NULL default '', - `name_loc4` varchar(100) NOT NULL default '', - `name_loc5` varchar(100) NOT NULL default '', - `name_loc6` varchar(100) NOT NULL default '', - `name_loc7` varchar(100) NOT NULL default '', - `description_loc1` varchar(255) default NULL, - `description_loc2` varchar(255) default NULL, - `description_loc3` varchar(255) default NULL, - `description_loc4` varchar(255) default NULL, - `description_loc5` varchar(255) default NULL, - `description_loc6` varchar(255) default NULL, - `description_loc7` varchar(255) default NULL, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `locales_quest`; -CREATE TABLE `locales_quest` ( - `entry` int(11) unsigned NOT NULL default '0', - `Title_loc1` text, - `Title_loc2` text, - `Title_loc3` text, - `Title_loc4` text, - `Title_loc5` text, - `Title_loc6` text, - `Title_loc7` text, - `Details_loc1` text, - `Details_loc2` text, - `Details_loc3` text, - `Details_loc4` text, - `Details_loc5` text, - `Details_loc6` text, - `Details_loc7` text, - `Objectives_loc1` text, - `Objectives_loc2` text, - `Objectives_loc3` text, - `Objectives_loc4` text, - `Objectives_loc5` text, - `Objectives_loc6` text, - `Objectives_loc7` text, - `OfferRewardText_loc1` text, - `OfferRewardText_loc2` text, - `OfferRewardText_loc3` text, - `OfferRewardText_loc4` text, - `OfferRewardText_loc5` text, - `OfferRewardText_loc6` text, - `OfferRewardText_loc7` text, - `RequestItemsText_loc1` text, - `RequestItemsText_loc2` text, - `RequestItemsText_loc3` text, - `RequestItemsText_loc4` text, - `RequestItemsText_loc5` text, - `RequestItemsText_loc6` text, - `RequestItemsText_loc7` text, - `EndText_loc1` text, - `EndText_loc2` text, - `EndText_loc3` text, - `EndText_loc4` text, - `EndText_loc5` text, - `EndText_loc6` text, - `EndText_loc7` text, - `ObjectiveText1_loc1` text, - `ObjectiveText1_loc2` text, - `ObjectiveText1_loc3` text, - `ObjectiveText1_loc4` text, - `ObjectiveText1_loc5` text, - `ObjectiveText1_loc6` text, - `ObjectiveText1_loc7` text, - `ObjectiveText2_loc1` text, - `ObjectiveText2_loc2` text, - `ObjectiveText2_loc3` text, - `ObjectiveText2_loc4` text, - `ObjectiveText2_loc5` text, - `ObjectiveText2_loc6` text, - `ObjectiveText2_loc7` text, - `ObjectiveText3_loc1` text, - `ObjectiveText3_loc2` text, - `ObjectiveText3_loc3` text, - `ObjectiveText3_loc4` text, - `ObjectiveText3_loc5` text, - `ObjectiveText3_loc6` text, - `ObjectiveText3_loc7` text, - `ObjectiveText4_loc1` text, - `ObjectiveText4_loc2` text, - `ObjectiveText4_loc3` text, - `ObjectiveText4_loc4` text, - `ObjectiveText4_loc5` text, - `ObjectiveText4_loc6` text, - `ObjectiveText4_loc7` text, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `locales_npc_text`; -CREATE TABLE `locales_npc_text` ( - `entry` int(11) unsigned NOT NULL default '0', - `Text0_0_loc1` longtext, - `Text0_0_loc2` longtext, - `Text0_0_loc3` longtext, - `Text0_0_loc4` longtext, - `Text0_0_loc5` longtext, - `Text0_0_loc6` longtext, - `Text0_0_loc7` longtext, - `Text0_1_loc1` longtext, - `Text0_1_loc2` longtext, - `Text0_1_loc3` longtext, - `Text0_1_loc4` longtext, - `Text0_1_loc5` longtext, - `Text0_1_loc6` longtext, - `Text0_1_loc7` longtext, - `Text1_0_loc1` longtext, - `Text1_0_loc2` longtext, - `Text1_0_loc3` longtext, - `Text1_0_loc4` longtext, - `Text1_0_loc5` longtext, - `Text1_0_loc6` longtext, - `Text1_0_loc7` longtext, - `Text1_1_loc1` longtext, - `Text1_1_loc2` longtext, - `Text1_1_loc3` longtext, - `Text1_1_loc4` longtext, - `Text1_1_loc5` longtext, - `Text1_1_loc6` longtext, - `Text1_1_loc7` longtext, - `Text2_0_loc1` longtext, - `Text2_0_loc2` longtext, - `Text2_0_loc3` longtext, - `Text2_0_loc4` longtext, - `Text2_0_loc5` longtext, - `Text2_0_loc6` longtext, - `Text2_0_loc7` longtext, - `Text2_1_loc1` longtext, - `Text2_1_loc2` longtext, - `Text2_1_loc3` longtext, - `Text2_1_loc4` longtext, - `Text2_1_loc5` longtext, - `Text2_1_loc6` longtext, - `Text2_1_loc7` longtext, - `Text3_0_loc1` longtext, - `Text3_0_loc2` longtext, - `Text3_0_loc3` longtext, - `Text3_0_loc4` longtext, - `Text3_0_loc5` longtext, - `Text3_0_loc6` longtext, - `Text3_0_loc7` longtext, - `Text3_1_loc1` longtext, - `Text3_1_loc2` longtext, - `Text3_1_loc3` longtext, - `Text3_1_loc4` longtext, - `Text3_1_loc5` longtext, - `Text3_1_loc6` longtext, - `Text3_1_loc7` longtext, - `Text4_0_loc1` longtext, - `Text4_0_loc2` longtext, - `Text4_0_loc3` longtext, - `Text4_0_loc4` longtext, - `Text4_0_loc5` longtext, - `Text4_0_loc6` longtext, - `Text4_0_loc7` longtext, - `Text4_1_loc1` longtext, - `Text4_1_loc2` longtext, - `Text4_1_loc3` longtext, - `Text4_1_loc4` longtext, - `Text4_1_loc5` longtext, - `Text4_1_loc6` longtext, - `Text4_1_loc7` longtext, - `Text5_0_loc1` longtext, - `Text5_0_loc2` longtext, - `Text5_0_loc3` longtext, - `Text5_0_loc4` longtext, - `Text5_0_loc5` longtext, - `Text5_0_loc6` longtext, - `Text5_0_loc7` longtext, - `Text5_1_loc1` longtext, - `Text5_1_loc2` longtext, - `Text5_1_loc3` longtext, - `Text5_1_loc4` longtext, - `Text5_1_loc5` longtext, - `Text5_1_loc6` longtext, - `Text5_1_loc7` longtext, - `Text6_0_loc1` longtext, - `Text6_0_loc2` longtext, - `Text6_0_loc3` longtext, - `Text6_0_loc4` longtext, - `Text6_0_loc5` longtext, - `Text6_0_loc6` longtext, - `Text6_0_loc7` longtext, - `Text6_1_loc1` longtext, - `Text6_1_loc2` longtext, - `Text6_1_loc3` longtext, - `Text6_1_loc4` longtext, - `Text6_1_loc5` longtext, - `Text6_1_loc6` longtext, - `Text6_1_loc7` longtext, - `Text7_0_loc1` longtext, - `Text7_0_loc2` longtext, - `Text7_0_loc3` longtext, - `Text7_0_loc4` longtext, - `Text7_0_loc5` longtext, - `Text7_0_loc6` longtext, - `Text7_0_loc7` longtext, - `Text7_1_loc1` longtext, - `Text7_1_loc2` longtext, - `Text7_1_loc3` longtext, - `Text7_1_loc4` longtext, - `Text7_1_loc5` longtext, - `Text7_1_loc6` longtext, - `Text7_1_loc7` longtext, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `locales_page_text`; -CREATE TABLE `locales_page_text` ( - `entry` int(11) unsigned NOT NULL default '0', - `Text_loc1` longtext, - `Text_loc2` longtext, - `Text_loc3` longtext, - `Text_loc4` longtext, - `Text_loc5` longtext, - `Text_loc6` longtext, - `Text_loc7` longtext, - PRIMARY KEY (`entry`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -DROP TABLE IF EXISTS `realmd`.`localization`; -CREATE TABLE `realmd`.`localization` ( - `locale` tinyint(3) unsigned NOT NULL default '0', - `string` char(2) NOT NULL DEFAULT '', - PRIMARY KEY (`locale`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO `realmd`.`localization` VALUES - (0,'en'), - (2,'fr'), - (3,'de'); - -ALTER TABLE `realmd`.`account` ADD COLUMN `locale` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `mutetime`; |