diff options
| author | QAston <none@none> | 2009-04-06 13:31:14 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-04-06 13:31:14 +0200 |
| commit | 20c02ef7606557a3932d2a3ca052242224a53b4a (patch) | |
| tree | 8b7718b7938184f9c0d0aa3dba70a46316786bfa /sql/updates/2412_characters.sql | |
| parent | 850537ece97dde9ee788ebc6e2c8edd7285b0d00 (diff) | |
*Update of aura system.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/2412_characters.sql')
| -rw-r--r-- | sql/updates/2412_characters.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/2412_characters.sql b/sql/updates/2412_characters.sql new file mode 100644 index 00000000000..22b5a751e71 --- /dev/null +++ b/sql/updates/2412_characters.sql @@ -0,0 +1,10 @@ +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 |