· 5 years ago · May 13, 2020, 08:30 AM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for globalvotes
5-- ----------------------------
6DROP TABLE IF EXISTS `globalvotes`;
7CREATE TABLE `globalvotes` (
8 `voteSite` tinyint(2) NOT NULL,
9 `lastRewardVotes` int(11) DEFAULT NULL,
10 PRIMARY KEY (`voteSite`) USING BTREE
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
12
13-- ----------------------------
14-- Records of globalvotes
15-- ----------------------------
16INSERT INTO `globalvotes` VALUES ('0', '13');
17INSERT INTO `globalvotes` VALUES ('1', '68');
18INSERT INTO `globalvotes` VALUES ('2', '0');
19INSERT INTO `globalvotes` VALUES ('3', '3');
20INSERT INTO `globalvotes` VALUES ('4', '2');
21INSERT INTO `globalvotes` VALUES ('5', '0');
22INSERT INTO `globalvotes` VALUES ('6', '0');
23INSERT INTO `globalvotes` VALUES ('7', '2');
24INSERT INTO `globalvotes` VALUES ('8', '3');
25INSERT INTO `globalvotes` VALUES ('9', '0');
26INSERT INTO `globalvotes` VALUES ('10', '75');
27
28-- ----------------------------
29-- Table structure for individualvotes
30-- ----------------------------
31DROP TABLE IF EXISTS `individualvotes`;
32CREATE TABLE `individualvotes` (
33 `voterIp` varchar(40) NOT NULL,
34 `voteSite` tinyint(3) NOT NULL,
35 `serverVotingTime` bigint(20) DEFAULT NULL,
36 `votingTimeSite` bigint(20) DEFAULT NULL,
37 `alreadyRewarded` tinyint(3) DEFAULT NULL,
38 PRIMARY KEY (`voterIp`,`voteSite`) USING BTREE
39) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
40
41-- ----------------------------
42-- Records of individualvotes
43-- ----------------------------
44
45-- ----------------------------
46-- Records of npc
47-- ----------------------------
48REPLACE `custom_npc` VALUES ('75014', '35587', 'Kaaya', '0', 'Vote Reward System', '0', 'NPC.a_traderC_Fhuman', '8.00', '21.00', '70', 'female', 'NpcVoteReward', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '88', '132', null, '0', '0', '0', 'LAST_HIT');