mirror of
https://github.com/trickerer/Trinity-Bots
synced 2026-08-22 16:29:09 -04:00
df7171177c
f4211c974331f68a9df12cf262c80e8ca8d7ac972bfb2cf7e185da023d6ed27edc6732e79918b2cee3c7e0981f88418551f07201e58463bdffe25bc8953d2c42191cbb55ec1abd61ca21cd86b7353e87f7a4bf3ca5b177803e2e4699f0429aCloses #550. Closes #554. Closes #562. Closes #563. Closes #571. Closes #574. Closes #578. Closes #592. Closes #596. Closes #598.
29 lines
1.4 KiB
SQL
29 lines
1.4 KiB
SQL
--
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
DROP TABLE IF EXISTS `characters_npcbot`;
|
|
CREATE TABLE `characters_npcbot` (
|
|
`entry` int(10) unsigned NOT NULL COMMENT 'creature_template.entry',
|
|
`owner` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'characters.guid (lowguid)',
|
|
`roles` smallint(5) unsigned NOT NULL COMMENT 'bitmask: tank(1),dps(2),heal(4),ranged(8)',
|
|
`faction` int(10) unsigned NOT NULL DEFAULT '35',
|
|
`equipMhEx` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipOhEx` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipRhEx` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipHead` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipShoulders` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipChest` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipWaist` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipLegs` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipFeet` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipWrist` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipHands` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipBack` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipBody` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipFinger1` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipFinger2` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipTrinket1` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipTrinket2` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`equipNeck` int(10) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`entry`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|