diff options
| author | Drahy <none@none> | 2009-05-09 12:27:41 +0200 |
|---|---|---|
| committer | Drahy <none@none> | 2009-05-09 12:27:41 +0200 |
| commit | 3b4e4b82159eff3411297e8e300cbc9a7bf7a1b5 (patch) | |
| tree | b63f894a3ef59cd97befbbbb5808feb8205482f2 /sql/updates/2412_characters.sql | |
| parent | efb79ea169cc6d1a7ca1a4c27b3adc32386d4522 (diff) | |
* Updated world_script_waypoints
* Updated world_scripts_structure
* Moved older sql files to 3.0.9_old folder and in file 0000_3.0.9_old (sql/updates) are stored all these sqls
* Also created folder Obsolete_updates where you can find unverified sqls
* This should help with sql maintaining
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/2412_characters.sql')
| -rw-r--r-- | sql/updates/2412_characters.sql | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/sql/updates/2412_characters.sql b/sql/updates/2412_characters.sql deleted file mode 100644 index e1f44c58ae3..00000000000 --- a/sql/updates/2412_characters.sql +++ /dev/null @@ -1,10 +0,0 @@ -DELETE FROM `character_aura` WHERE 'effect_index'>'1'; - ALTER TABLE `character_aura` CHANGE `effect_index` `effect_mask` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; - ALTER TABLE `character_aura` CHANGE `amount` `amount0` INT( 11 ) NOT NULL DEFAULT '0'; - ALTER TABLE `character_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; - ALTER TABLE `character_aura` ADD `amount2` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount1`; -DELETE FROM `pet_aura` WHERE 'effect_index'>'1'; - ALTER TABLE `pet_aura` CHANGE `effect_index` `effect_mask` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; - ALTER TABLE `pet_aura` CHANGE `amount` `amount0` INT( 11 ) NOT NULL DEFAULT '0'; - ALTER TABLE `pet_aura` ADD `amount1` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount0`; - ALTER TABLE `pet_aura` ADD `amount2` INT( 11 ) NOT NULL DEFAULT '0' AFTER `amount1`;
\ No newline at end of file |