Files
TrinityCore2/sql/old/3.1.3/04211_world.sql
runningnak3d 0a5d8711e5 Misc: Restructuring directory layout to accomodate the fact that we will
be pushing DB content. We will no longer have a seperate DB repo.
2011-02-02 07:50:21 -07:00

3 lines
168 B
SQL

ALTER TABLE spell_pet_auras ADD effectId TINYINT( 3 ) UNSIGNED NOT NULL AFTER spell;
ALTER TABLE spell_pet_auras DROP PRIMARY KEY, ADD PRIMARY KEY(spell,effectId,pet);