diff options
| author | runningnak3d@mangos.zipwow.ano <none@none> | 2008-12-15 10:42:35 +0000 |
|---|---|---|
| committer | runningnak3d@mangos.zipwow.ano <none@none> | 2008-12-15 10:42:35 +0000 |
| commit | 4b47c30641d31661c530e21dfd24a79b405736d2 (patch) | |
| tree | edbc6dbe32f693fe3ae7bd9bde505686db32fbcb /sql/updates/176_world.sql | |
| parent | 7ed8e2993f37006a4f455f995ef61b6d0f867656 (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.sql | 64 |
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'; |
