· 8 years ago · Dec 03, 2017, 07:36 PM
1DROP TABLE IF EXISTS `pet_aura`;
2CREATE TABLE `pet_aura` (
3 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
4 `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
5 `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
6 `spell` int(11) unsigned NOT NULL DEFAULT '0',
7 `stackcount` int(11) unsigned NOT NULL DEFAULT '1',
8 `remaincharges` int(11) unsigned NOT NULL DEFAULT '0',
9 `basepoints0` int(11) NOT NULL DEFAULT '0',
10 `basepoints1` int(11) NOT NULL DEFAULT '0',
11 `basepoints2` int(11) NOT NULL DEFAULT '0',
12 `periodictime0` int(11) unsigned NOT NULL DEFAULT '0',
13 `periodictime1` int(11) unsigned NOT NULL DEFAULT '0',
14 `periodictime2` int(11) unsigned NOT NULL DEFAULT '0',
15 `maxduration` int(11) NOT NULL DEFAULT '0',
16 `remaintime` int(11) NOT NULL DEFAULT '0',
17 `effIndexMask` int(11) unsigned NOT NULL DEFAULT '0',
18 PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';