01-- -----------------------
02-- Table structure for tvt
03-- -----------------------
04DROP TABLE IF EXISTS `tvt`;
05CREATE TABLE `tvt` (
06 `eventName` varchar(255) NOT NULL DEFAULT '',
07 `eventDesc` varchar(255) NOT NULL DEFAULT '',
08 `joiningLocation` varchar(255) NOT NULL DEFAULT '',
09 `minlvl` int(4) NOT NULL DEFAULT '0',
10 `maxlvl` int(4) NOT NULL DEFAULT '0',
11 `npcId` int(8) NOT NULL DEFAULT '0',
12 `npcX` int(11) NOT NULL DEFAULT '0',
13 `npcY` int(11) NOT NULL DEFAULT '0',
14 `npcZ` int(11) NOT NULL DEFAULT '0',
15 `npcHeading` int(11) NOT NULL DEFAULT '0',
16 `rewardId` int(11) NOT NULL DEFAULT '0',
17 `rewardAmount` int(11) NOT NULL DEFAULT '0',
18 `teamsCount` int(4) NOT NULL DEFAULT '0',
19 `joinTime` int(11) NOT NULL DEFAULT '0',
20 `eventTime` int(11) NOT NULL DEFAULT '0',
21 `minPlayers` int(4) NOT NULL DEFAULT '0',
22 `maxPlayers` int(4) NOT NULL DEFAULT '0',
23 `delayForNextEvent` BIGINT NOT NULL DEFAULT '0'
24) DEFAULT CHARSET=utf8;
25-- ---------------------
26-- Records for table tvt
27-- ---------------------
28
29INSERT INTO `tvt` values
30('TVT', 'A PvP Event', 'Giran', 1, 81, 70010, 82688, 148677, -3469, 0, 8752, 1, 2, 5, 5, 2, 50, 300000);