aboutsummaryrefslogtreecommitdiff
path: root/sql/old/3.2.2a/06932_characters_pet_aura.sql
blob: 90df4e858c98e12fcd34f17dede066242951a072 (plain) 
1
2
3
4
5

ALTER TABLE `pet_aura` DROP PRIMARY KEY,
    ADD COLUMN `base_amount0` INT(11) NOT NULL DEFAULT '0' AFTER `amount2`,
    ADD COLUMN `base_amount1` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount0`,
    ADD COLUMN `base_amount2` INT(11) NOT NULL DEFAULT '0' AFTER `base_amount1`,
    ADD COLUMN `recalculate_mask` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `effect_mask`;