VBqWQLsp

1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `character_data`;
4CREATE TABLE `character_data` (
5  `CharacterID` int(10) unsigned NOT NULL AUTO_INCREMENT,
6  `PlayerID` varchar(255) NOT NULL DEFAULT '',
7  `Alive` int(1) NOT NULL DEFAULT '1',
8  `InstanceID` varchar(255) DEFAULT NULL,
9  `Worldspace` varchar(255) DEFAULT '[]',
10  `Inventory` varchar(999) DEFAULT '[]',
11  `Backpack` varchar(999) DEFAULT '[]',
12  `Medical` varchar(255) NOT NULL DEFAULT '[false,false,false,false,false,false,false,12000,[],[0,0],0]',
13  `Generation` varchar(255) DEFAULT NULL,
14  `Datestamp` timestamp NULL DEFAULT NULL,
15  `LastLogin` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
16  `LastAte` timestamp NULL DEFAULT NULL,
17  `LastDrank` timestamp NULL DEFAULT NULL,
18  `Humanity` varchar(255) DEFAULT NULL,
19  `KillsZ` mediumint(6) unsigned NOT NULL DEFAULT '0',
20  `HeadshotsZ` mediumint(6) unsigned NOT NULL DEFAULT '0',
21  `distanceFoot` varchar(255) NOT NULL DEFAULT '0',
22  `duration` varchar(255) NOT NULL DEFAULT '0',
23  `currentState` varchar(255) NOT NULL DEFAULT '["Makarov","aidlpercmstpsraswpstdnon_player_idlesteady01",36]',
24  `KillsH` mediumint(6) unsigned NOT NULL DEFAULT '0',
25  `KillsB` mediumint(6) unsigned NOT NULL DEFAULT '0',
26  `Model` varchar(255) NOT NULL DEFAULT '"Survivor1_DZ"',
27  PRIMARY KEY (`CharacterID`)
28) ENGINE=InnoDB AUTO_INCREMENT=1161 DEFAULT CHARSET=utf8;
29
30DROP TABLE IF EXISTS `object_data`;
31CREATE TABLE `object_data` (
32  `ObjectID` int(10) NOT NULL AUTO_INCREMENT,
33  `ObjectUID` varchar(255) DEFAULT NULL,
34  `Instance` varchar(255) DEFAULT '222',
35  `Classname` varchar(255) DEFAULT NULL,
36  `Damage` varchar(255) DEFAULT NULL,
37  `CharacterID` varchar(255) DEFAULT NULL,
38  `Worldspace` varchar(999) DEFAULT NULL,
39  `Inventory` varchar(999) DEFAULT NULL,
40  `Hitpoints` varchar(255) DEFAULT NULL,
41  `Fuel` varchar(255) DEFAULT NULL,
42  `Datestamp` varchar(255) DEFAULT NULL,
43  PRIMARY KEY (`ObjectID`)
44) ENGINE=InnoDB AUTO_INCREMENT=1010 DEFAULT CHARSET=utf8;
45
46DROP TABLE IF EXISTS `player_data`;
47CREATE TABLE `player_data` (
48  `PlayerID` varchar(20) NOT NULL DEFAULT '',
49  `PlayerName` varchar(24) NOT NULL DEFAULT '',
50  `PlayerSex` int(1) DEFAULT NULL,
51  PRIMARY KEY (`PlayerID`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8;
53
54DROP TABLE IF EXISTS `_coords_`;
55CREATE TABLE `_coords_` (
56  `Name` varchar(255) NOT NULL DEFAULT '',
57  `Coords` varchar(255) DEFAULT NULL,
58  PRIMARY KEY (`Name`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61INSERT INTO `_coords_` VALUES ('Airfield', '[125,[4644.31,10096.7,-0.00131226]]');
62INSERT INTO `_coords_` VALUES ('Airstrip Balota', '[211,[4796.83,2586.56,0.0584269]]');
63INSERT INTO `_coords_` VALUES ('Airstrip Krasnostav', '[135,[12019.9,12681.1,0.00146484]]');
64INSERT INTO `_coords_` VALUES ('Chernogorsk', '[257,[6917.12,3113.57,0.00143862]]');
65INSERT INTO `_coords_` VALUES ('Elektrozavodsk', '[142,[10460.9,2714.57,0.00132751]]');
66INSERT INTO `_coords_` VALUES ('Novy Sobor', '[292,[7354.17,7652.13,0.00158691]]');
67INSERT INTO `_coords_` VALUES ('Shaldhovka', '[275,[9593.38,6666.84,0]]');
68INSERT INTO `_coords_` VALUES ('Stary Sobor', '[274,[6493.5,7507.62,0.00137329]]');