· 7 years ago · Dec 08, 2018, 01:32 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.5.24-log - MySQL Community Server (GPL)
4-- Server OS: Win32
5-- HeidiSQL version: 7.0.0.4197
6-- Date/time: 2012-09-29 15:37:45
7-- --------------------------------------------------------
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET NAMES utf8 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping database structure for hivemind
15CREATE DATABASE IF NOT EXISTS `hivemind` /*!40100 DEFAULT CHARACTER SET utf8 */;
16USE `hivemind`;
17
18
19-- Dumping structure for table hivemind.character_data
20CREATE TABLE IF NOT EXISTS `character_data` (
21 `CharacterID` int(10) unsigned NOT NULL AUTO_INCREMENT,
22 `PlayerUID` varchar(16) NOT NULL DEFAULT '',
23 `Alive` tinyint(1) NOT NULL DEFAULT '1',
24 `InstanceID` varchar(4) NOT NULL DEFAULT '',
25 `Worldspace` varchar(64) NOT NULL DEFAULT '[]',
26 `Inventory` varchar(2048) NOT NULL DEFAULT '[]',
27 `Backpack` varchar(2048) NOT NULL DEFAULT '[]',
28 `Medical` varchar(128) NOT NULL DEFAULT '[]',
29 `Generation` smallint(4) unsigned NOT NULL DEFAULT '0',
30 `Datestamp` timestamp NULL DEFAULT NULL,
31 `LastLogin` timestamp NULL DEFAULT NULL,
32 `LastAte` timestamp NULL DEFAULT NULL,
33 `LastDrank` timestamp NULL DEFAULT NULL,
34 `Humanity` mediumint(6) DEFAULT NULL,
35 `KillsZ` mediumint(5) unsigned NOT NULL DEFAULT '0',
36 `HeadshotsZ` mediumint(5) unsigned NOT NULL DEFAULT '0',
37 `distanceFoot` bigint(15) unsigned NOT NULL DEFAULT '0',
38 `duration` int(10) NOT NULL DEFAULT '0',
39 `currentState` varchar(128) NOT NULL DEFAULT '[]',
40 `KillsH` mediumint(5) unsigned NOT NULL DEFAULT '0',
41 `KillsB` mediumint(5) unsigned NOT NULL DEFAULT '0',
42 `Model` varchar(32) NOT NULL DEFAULT '"Survivor1_DZ"',
43 PRIMARY KEY (`CharacterID`)
44) ENGINE=MyISAM AUTO_INCREMENT=215 DEFAULT CHARSET=utf8;
45
46-- Dumping data for table hivemind.character_data: 8 rows
47/*!40000 ALTER TABLE `character_data` DISABLE KEYS */;
48INSERT INTO `character_data` (`CharacterID`, `PlayerUID`, `Alive`, `InstanceID`, `Worldspace`, `Inventory`, `Backpack`, `Medical`, `Generation`, `Datestamp`, `LastLogin`, `LastAte`, `LastDrank`, `Humanity`, `KillsZ`, `HeadshotsZ`, `distanceFoot`, `duration`, `currentState`, `KillsH`, `KillsB`, `Model`) VALUES
49 (5, '24945606', 1, '222', '[55,[2444.17,10366.3,0.00131226]]', '[["M4A1_HWS_GL_SD_Camo","Binocular","MeleeFlashlight","ItemWatch","ItemToolbox","ItemMap","ItemKnife","ItemHatchet","ItemGPS","ItemEtool","ItemMatchbox"],[["30Rnd_556x45_StanagSD",22],["30Rnd_556x45_StanagSD",24],"30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","ItemBandage","ItemBandage","FlareGreen_M203","FlareGreen_M203","FlareGreen_M203"]]', '["DZ_Backpack_EP1",[[],[]],[["30Rnd_556x45_StanagSD"],[18]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[304.031,150.356]]', 1, '2012-09-24 17:43:22', '2012-09-29 15:27:35', '2012-09-24 17:43:22', '2012-09-24 17:43:22', 8661, 198, 125, 2791351, 487, '["M4A1_HWS_GL_SD_Camo","aidlpercmstpsraswrfldnon_idlesteady02",42]', 0, 1, 'Camo1_DZ'),
50 (214, '29247686', 1, '222', '[93,[2463.83,10385.7,0.00143433]]', '[["M4A1_HWS_GL_SD_Camo","Binocular","MeleeFlashlight","ItemWatch","ItemToolbox","ItemMap","ItemKnife","ItemHatchet","ItemGPS","ItemEtool","ItemMatchbox"],[["30Rnd_556x45_StanagSD",22],"30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","ItemBandage","ItemBandage","FlareGreen_M203","FlareGreen_M203","FlareGreen_M203"]]', '["DZ_Backpack_EP1",[[],[]],[["30Rnd_556x45_StanagSD"],[18]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[0,0]]', 1, '2012-09-29 15:29:20', '2012-09-29 15:30:02', '2012-09-29 15:29:20', '2012-09-29 15:29:20', 2500, 0, 0, 57372, 7, '["M4A1_HWS_GL_SD_Camo","amovpercmstpslowwrfldnon_diary",40]', 0, 0, '"Survivor2_DZ"'),
51 (212, '24182790', 1, '222', '[44,[2429.13,10344.2,0.00140381]]', '[["M4A1_HWS_GL_SD_Camo","Binocular","MeleeFlashlight","ItemWatch","ItemToolbox","ItemMap","ItemKnife","ItemHatchet","ItemGPS","ItemEtool","ItemMatchbox"],[["30Rnd_556x45_StanagSD",22],"30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","ItemBandage","ItemBandage","FlareGreen_M203","FlareGreen_M203","FlareGreen_M203"]]', '["DZ_Backpack_EP1",[[],[]],[["30Rnd_556x45_StanagSD"],[18]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[234.53,90.1219]]', 1, '2012-09-29 15:13:39', '2012-09-29 15:27:39', '2012-09-29 15:13:39', '2012-09-29 15:13:39', 2500, 0, 0, 90407, 11, '["M4A1_HWS_GL_SD_Camo","amovpercmstpslowwrfldnon_player_idlesteady02",42]', 0, 0, 'Survivor2_DZ'),
52 (211, '21356230', 1, '222', '[165,[2665.01,10187.5,0.0015564]]', '[["M4A1_HWS_GL_SD_Camo","Binocular","MeleeFlashlight","ItemWatch","ItemToolbox","ItemMap","ItemKnife","ItemHatchet","ItemGPS","ItemEtool","ItemMatchbox"],[["30Rnd_556x45_StanagSD",22],"30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","30Rnd_556x45_StanagSD","ItemBandage","ItemBandage","FlareGreen_M203","FlareGreen_M203","FlareGreen_M203","FlareGreen_M203"]]', '["DZ_Backpack_EP1",[[],[]],[["30Rnd_556x45_StanagSD"],[18]]]', '[false,false,false,false,false,false,false,12000,[],[0,0],0,[58.8001,32.4457]]', 1, '2012-09-28 20:07:06', '2012-09-29 14:28:11', '2012-09-28 20:07:06', '2012-09-28 20:07:06', 2490, 0, 0, 395377, 70, '["","",42]', 0, 0, '"Survivor2_DZ"');
53/*!40000 ALTER TABLE `character_data` ENABLE KEYS */;
54/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
55/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;