aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/176_world.sql
diff options
context:
space:
mode:
authorrunningnak3d@mangos.zipwow.ano <none@none>2008-12-15 10:42:35 +0000
committerrunningnak3d@mangos.zipwow.ano <none@none>2008-12-15 10:42:35 +0000
commit4b47c30641d31661c530e21dfd24a79b405736d2 (patch)
treeedbc6dbe32f693fe3ae7bd9bde505686db32fbcb /sql/updates/176_world.sql
parent7ed8e2993f37006a4f455f995ef61b6d0f867656 (diff)
* Fix revent SQL commits
* Fix EOL issues on all SQL files --HG-- branch : trunk
Diffstat (limited to 'sql/updates/176_world.sql')
-rw-r--r--sql/updates/176_world.sql64
1 files changed, 32 insertions, 32 deletions
diff --git a/sql/updates/176_world.sql b/sql/updates/176_world.sql
index 03c720d7ef5..12df2a083ca 100644
--- a/sql/updates/176_world.sql
+++ b/sql/updates/176_world.sql
@@ -1,32 +1,32 @@
-ALTER TABLE `npc_option`
- CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0',
- CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0',
- CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0',
- ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`,
- ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`,
- ADD COLUMN `box_text` text AFTER `option_text`;
-
-CREATE TABLE `locales_npc_option` (
- `entry` mediumint(8) unsigned NOT NULL default '0',
- `option_text_loc1` text,
- `option_text_loc2` text,
- `option_text_loc3` text,
- `option_text_loc4` text,
- `option_text_loc5` text,
- `option_text_loc6` text,
- `option_text_loc7` text,
- `option_text_loc8` text,
- `box_text_loc1` text,
- `box_text_loc2` text,
- `box_text_loc3` text,
- `box_text_loc4` text,
- `box_text_loc5` text,
- `box_text_loc6` text,
- `box_text_loc7` text,
- `box_text_loc8` text,
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-ALTER TABLE `creature_template`
- CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0',
- CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0';
+ALTER TABLE `npc_option`
+ CHANGE COLUMN `id` `id` mediumint(8) unsigned NOT NULL default '0',
+ CHANGE COLUMN `gossip_id` `gossip_id` mediumint(8) unsigned NOT NULL default '0',
+ CHANGE COLUMN `action` `action` mediumint(8) unsigned NOT NULL default '0',
+ ADD COLUMN `box_money` int(10) unsigned NOT NULL default '0' AFTER `action`,
+ ADD COLUMN `coded` tinyint(3) unsigned NOT NULL default '0' AFTER `box_money`,
+ ADD COLUMN `box_text` text AFTER `option_text`;
+
+CREATE TABLE `locales_npc_option` (
+ `entry` mediumint(8) unsigned NOT NULL default '0',
+ `option_text_loc1` text,
+ `option_text_loc2` text,
+ `option_text_loc3` text,
+ `option_text_loc4` text,
+ `option_text_loc5` text,
+ `option_text_loc6` text,
+ `option_text_loc7` text,
+ `option_text_loc8` text,
+ `box_text_loc1` text,
+ `box_text_loc2` text,
+ `box_text_loc3` text,
+ `box_text_loc4` text,
+ `box_text_loc5` text,
+ `box_text_loc6` text,
+ `box_text_loc7` text,
+ `box_text_loc8` text,
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+ALTER TABLE `creature_template`
+ CHANGE COLUMN `flags` `unit_flags` int(10) unsigned NOT NULL default '0',
+ CHANGE COLUMN `flag1` `type_flags` int(10) unsigned NOT NULL default '0';