aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/0.8/4579.sql
diff options
context:
space:
mode:
authorSeline <none@none>2008-10-03 15:33:07 -0500
committerSeline <none@none>2008-10-03 15:33:07 -0500
commitbe22d45c0f6b4278709713d5457ec77853252796 (patch)
tree28dc122cda09fd026fd4e3fa880dfb25b4bb7f48 /sql/updates/0.8/4579.sql
parent9b1c0e006f20091f28f3f468cfcab1feb51286bd (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.sql274
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`;