· 8 years ago · Nov 25, 2017, 07:56 PM
1DROP TABLE IF EXISTS `npc_vendor`;
2CREATE TABLE `npc_vendor` (
3 `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
4 `slot` smallint(6) NOT NULL DEFAULT '0',
5 `item` mediumint(8) NOT NULL DEFAULT '0',
6 `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0',
7 `incrtime` int(10) unsigned NOT NULL DEFAULT '0',
8 `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0',
9 `AchievementId` int(10) NOT NULL DEFAULT '0',
10 PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
11 KEY `slot` (`slot`)
12) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';