· 8 years ago · Jun 22, 2018, 08:16 PM
1-- ----------------------------
2-- Table structure for `dm`
3-- ----------------------------
4DROP TABLE IF EXISTS `dm`;
5CREATE TABLE `dm` (
6 `eventName` varchar(255) NOT NULL DEFAULT '',
7 `eventDesc` varchar(255) NOT NULL DEFAULT '',
8 `joiningLocation` varchar(255) NOT NULL DEFAULT '',
9 `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 `joinTime` int(11) NOT NULL DEFAULT '0',
19 `eventTime` int(11) NOT NULL DEFAULT '0',
20 `minPlayers` int(11) NOT NULL DEFAULT '0',
21 `maxPlayers` int(11) NOT NULL DEFAULT '0',
22 `color` int(11) NOT NULL DEFAULT '0',
23 `playerX` int(11) NOT NULL DEFAULT '0',
24 `playerY` int(11) NOT NULL DEFAULT '0',
25 `playerZ` int(11) NOT NULL DEFAULT '0',
26 `delayForNextEvent` bigint(20) NOT NULL DEFAULT '0'
27) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29-- ----------------------------
30-- Records of dm
31-- ----------------------------
32INSERT INTO `dm` VALUES ('DM', 'All vs All', 'Giran', '76', '81', '70014', '82580', '148552', '-3468', '1', '6673', '2', '2', '5', '2', '50', '2552550', '-20698', '-21022', '-3028', '300000');