· 5 years ago · Feb 03, 2020, 03:28 PM
1-- Dumping structure for table lisa_srv.characters
2CREATE TABLE IF NOT EXISTS `characters` (
3 `ID` int(11) NOT NULL AUTO_INCREMENT,
4 `User_Account_ID` int(11) NOT NULL,
5 `Gender` tinytext CHARACTER SET latin1 DEFAULT NULL,
6 `Character_Name` text CHARACTER SET latin1 NOT NULL,
7 `Position` text CHARACTER SET latin1 NOT NULL,
8 `Dimension` int(11) DEFAULT 0,
9 `setPedHeadBlendData` text CHARACTER SET latin1 DEFAULT NULL,
10 `setPedEyeColor` text DEFAULT NULL,
11 `setPedHairStyle` text DEFAULT NULL,
12 `setPedHairColor` text CHARACTER SET latin1 DEFAULT NULL,
13 `setPedHeadOverlay` text DEFAULT NULL,
14 `setPedHeadOverlayColor` text DEFAULT NULL,
15 `setPedFaceFeature` text DEFAULT NULL,
16 `Inventory` longtext CHARACTER SET latin1 DEFAULT NULL,
17 `Equipped` longtext CHARACTER SET latin1 DEFAULT NULL,
18 `Energy` int(11) DEFAULT 1000,
19 `Hunger` int(11) DEFAULT 1000,
20 `Thirst` int(11) DEFAULT 1000,
21 `Money_Pocket` text NOT NULL DEFAULT '10.0',
22 `Money_Bank` text NOT NULL DEFAULT '0.0',
23 `IsPlayerInResidenceCol` tinyint(1) NOT NULL DEFAULT 0,
24 `ResidenceIdent` text CHARACTER SET latin1 DEFAULT NULL,
25 `ResidenceColType` text CHARACTER SET latin1 DEFAULT NULL,
26 `isinsideinterior` tinyint(1) NOT NULL DEFAULT 0,
27 PRIMARY KEY (`ID`),
28 UNIQUE KEY `Character_Name` (`Character_Name`) USING HASH
29) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
30
31-- Dumping data for table lisa_srv.characters: ~2 rows (approximately)
32/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
33INSERT INTO `characters` (`ID`, `User_Account_ID`, `Gender`, `Character_Name`, `Position`, `Dimension`, `setPedHeadBlendData`, `setPedEyeColor`, `setPedHairStyle`, `setPedHairColor`, `setPedHeadOverlay`, `setPedHeadOverlayColor`, `setPedFaceFeature`, `Inventory`, `Equipped`, `Energy`, `Hunger`, `Thirst`, `Money_Pocket`, `Money_Bank`, `IsPlayerInResidenceCol`, `ResidenceIdent`, `ResidenceColType`, `isinsideinterior`) VALUES
34 (1, 1, 'Female', 'Emma Peralta', '412.68133544921875, -975.2439575195312, 29.4315185546875', 0, '39, 27, 27, 0, 0, 0.0, 0.6, 0, 0, false', '2', '43, 0, 2', '54, 46', '0&0, 0&0, 1&255, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0', '0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0', '0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0', '{"0":{"13":{"usedurability":995}},"1":{"51":{}},"2":{"11":{"usedurability":2}},"3":{"1":{"timedurability":2880}},"4":{"20":{"usedurability":8}},"5":{"0":{"usedurability":1}},"6":{"4":{"timedurability":1000}},"7":{"100":{}},"8":{"14":{"timedurability":2880}},"9":{"15":{"timedurability":2880}},"10":{"16":{"timedurability":2880}},"11":{"50":{}},"12":{"51":{}},"13":{"52":{}},"14":{"53":{}}}', '{"0":null,"1":null,"2":null,"3":null,"4":{"7":{"timedurability":1000}},"5":null,"6":{"8":{"timedurability":1000}},"7":null,"8":null,"9":null,"10":null,"11":{"10":{"timedurability":1000}}}', 1000, 1000, 672, '30121.44999999995', '99000.0', 0, '{"x":1386.2244873046875,"y":-593.4774780273438,"z":73.48545837402344}', 'Residence', 0),
35 (2, 1, 'Male', 'Zeke Peralta', '-1366.20654296875, -973.8329467773438, 8.6051025390625', 0, '18, 7, 0, 12, 8, 0, 0.3, 0.5, 0, false', '0', '47, 0, 2', '2, 78', '0&0, 10&1, 12&1, 1&1, 0&0.1, 0&0, 0&0, 0&0.5, 0&0.3, 6&1, 2&1, 8&1, 0&0', '0&0, 55&0, 57&0, 0&0, 0&0, 0&0, 0&0, 0&0, 3&0, 0&0, 0&0, 0&0, 0&0', '-1, 0.1, -0.5, 0, 0, 0, 1, 0, 0.8, -0.8, 0.2, 0.4, -0.3, -1, -1, 1, -0.2, 1, -1, 1', '{"0":{"13":{"usedurability":962}},"3":{"5":{"timedurability":1000}},"4":{"11":{"usedurability":2}},"5":{"1":{"timedurability":2880}},"6":{"2":{"timedurability":1000}},"7":{"0":{"usedurability":3}},"8":{"52":{}},"9":{"50":{}},"10":{"23":{"usedurability":20}},"11":{"24":{"usedurability":40}},"13":{"120":{}},"14":{"20":{"usedurability":10}},"15":{"51":{}},"16":{"53":{}}}', '{"0":null,"1":null,"2":null,"3":null,"4":{"18":{"timedurability":2880}},"5":null,"6":{"19":{"timedurability":2880}},"7":null,"8":null,"9":null,"10":null,"11":{"17":{"timedurability":2880}}}', 1000, 836, 421, '117.42000000005149', '140141', 0, '{"x":1386.2244873046875,"y":-593.4774780273438,"z":73.48545837402344}', 'Residence', 0),
36 (3, 2, 'Female', 'queene aries', '459.5340576171875, -859.1868286132812, 27.2916259765625', 0, '39, 45, 0, 0, 45, 0, 0.5, 0.7, 0, false', '12', '49, 0, 2', '0, 0', '0&0, 0&0, 5&1, 0&0, 37&1, 1&0.6, 0&0, 0&0, 5&0.4, 0&0, 0&0, 0&0, 0&0', '0&0, 0&0, 0&54, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0, 0&0', '-0.4, -0.3, -0.1, 0, 0, 0, -0.5, 0, -0.6, 0, 0, -0.4, -0.4, 0, 0, 0, 0, 0, -0.2, -0.3', '{"0":{"0":{"usedurability":4}}}', '{"0":null,"1":null,"2":null,"3":null,"4":{"15":{"timedurability":2880}},"5":null,"6":{"16":{"timedurability":2880}},"7":null,"8":null,"9":null,"10":null,"11":{"14":{"timedurability":2880}}}', 1000, 959, 1000, '8.9', '0.0', 0, NULL, NULL, 0);
37/*!40000 ALTER TABLE `characters` ENABLE KEYS */;