· 5 years ago · Jul 15, 2020, 04:16 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versión del servidor: 5.7.24 - MySQL Community Server (GPL)
4-- SO del servidor: Win64
5-- HeidiSQL Versión: 10.3.0.5771
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
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
15-- Volcando estructura de base de datos para redemrp
16CREATE DATABASE IF NOT EXISTS `redemrp` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `redemrp`;
18
19-- Volcando estructura para tabla redemrp.characters
20CREATE TABLE IF NOT EXISTS `characters` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
23 `characterid` int(11) DEFAULT '0',
24 `thirst` int(11) DEFAULT '100',
25 `hungry` int(11) DEFAULT '100',
26 `health` int(11) DEFAULT '100',
27 `money` float DEFAULT '0',
28 `gold` int(11) DEFAULT '0',
29 `xp` float DEFAULT '0',
30 `level` float DEFAULT '0',
31 `job` varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
32 `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT 'first',
33 `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT 'last',
34 `jobgrade` int(11) DEFAULT '0',
35 `coords` varchar(200) COLLATE utf8mb4_bin DEFAULT '{}',
36 PRIMARY KEY (`id`),
37 UNIQUE KEY `identifier` (`identifier`)
38) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
39
40-- Volcando datos para la tabla redemrp.characters: ~2 rows (aproximadamente)
41/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
42INSERT IGNORE INTO `characters` (`id`, `identifier`, `characterid`, `thirst`, `hungry`, `health`, `money`, `gold`, `xp`, `level`, `job`, `firstname`, `lastname`, `jobgrade`, `coords`) VALUES
43 (26, 'steam:110000108381d36', 1, 70, 76, 100, 0, 0, 0, 0, 'unemployed', 'Kyz', 'Test', 0, '{"z":43.556583404541,"x":-800.81036376953,"y":-1219.7567138672}'),
44 (27, 'steam:110000114e6a67f', 1, 85, 88, 51, 0, 0, 0, 0, 'unemployed', 'Franco', 'Sanllehi', 0, '{"z":43.564140319824,"x":-795.71697998047,"y":-1225.2427978516}');
45/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
46
47-- Volcando estructura para tabla redemrp.clothes
48CREATE TABLE IF NOT EXISTS `clothes` (
49 `id` int(11) NOT NULL AUTO_INCREMENT,
50 `identifier` varchar(40) NOT NULL,
51 `charid` int(11) NOT NULL,
52 `clothes` json NOT NULL,
53 KEY `id` (`id`)
54) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
55
56-- Volcando datos para la tabla redemrp.clothes: ~0 rows (aproximadamente)
57/*!40000 ALTER TABLE `clothes` DISABLE KEYS */;
58/*!40000 ALTER TABLE `clothes` ENABLE KEYS */;
59
60-- Volcando estructura para tabla redemrp.factions
61CREATE TABLE IF NOT EXISTS `factions` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `name` varchar(50) NOT NULL,
64 `description` varchar(255) NOT NULL,
65 `boss` varchar(255) NOT NULL,
66 PRIMARY KEY (`id`),
67 UNIQUE KEY `id` (`id`)
68) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
69
70-- Volcando datos para la tabla redemrp.factions: ~2 rows (aproximadamente)
71/*!40000 ALTER TABLE `factions` DISABLE KEYS */;
72INSERT IGNORE INTO `factions` (`id`, `name`, `description`, `boss`) VALUES
73 (1, 'Forajidos', 'Foraji2', 'steam:110000108381d36'),
74 (2, 'Test', 'Testing', 'steam:110000108381d37');
75/*!40000 ALTER TABLE `factions` ENABLE KEYS */;
76
77-- Volcando estructura para tabla redemrp.factions_members
78CREATE TABLE IF NOT EXISTS `factions_members` (
79 `id` int(11) NOT NULL AUTO_INCREMENT,
80 `faction_id` int(11) NOT NULL,
81 `role_id` int(11) NOT NULL,
82 `member` varchar(50) NOT NULL DEFAULT '',
83 PRIMARY KEY (`id`),
84 KEY `FK_factions_members_factions` (`faction_id`),
85 KEY `FK_factions_members_factions_roles` (`role_id`),
86 CONSTRAINT `FK_factions_members_factions` FOREIGN KEY (`faction_id`) REFERENCES `factions` (`id`),
87 CONSTRAINT `FK_factions_members_factions_roles` FOREIGN KEY (`role_id`) REFERENCES `factions_roles` (`id`)
88) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
89
90-- Volcando datos para la tabla redemrp.factions_members: ~0 rows (aproximadamente)
91/*!40000 ALTER TABLE `factions_members` DISABLE KEYS */;
92INSERT IGNORE INTO `factions_members` (`id`, `faction_id`, `role_id`, `member`) VALUES
93 (1, 1, 1, 'steam:110000108381d36');
94/*!40000 ALTER TABLE `factions_members` ENABLE KEYS */;
95
96-- Volcando estructura para tabla redemrp.factions_roles
97CREATE TABLE IF NOT EXISTS `factions_roles` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `faction_id` int(11) NOT NULL DEFAULT '0',
100 `name` varchar(255) DEFAULT NULL,
101 `description` varchar(255) DEFAULT NULL,
102 `weigth` int(11) DEFAULT '0',
103 PRIMARY KEY (`id`),
104 KEY `FK_factions_roles_factions` (`faction_id`),
105 CONSTRAINT `FK_factions_roles_factions` FOREIGN KEY (`faction_id`) REFERENCES `factions` (`id`)
106) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
107
108-- Volcando datos para la tabla redemrp.factions_roles: ~2 rows (aproximadamente)
109/*!40000 ALTER TABLE `factions_roles` DISABLE KEYS */;
110INSERT IGNORE INTO `factions_roles` (`id`, `faction_id`, `name`, `description`, `weigth`) VALUES
111 (1, 1, 'Forastero', 'Nada', 0),
112 (2, 1, 'Malcriado', 'TEST', 1);
113/*!40000 ALTER TABLE `factions_roles` ENABLE KEYS */;
114
115-- Volcando estructura para tabla redemrp.outfits
116CREATE TABLE IF NOT EXISTS `outfits` (
117 `identifier` varchar(40) NOT NULL,
118 `charid` int(11) NOT NULL,
119 `name` varchar(255) NOT NULL,
120 `clothes` varchar(5000) NOT NULL
121) ENGINE=InnoDB DEFAULT CHARSET=utf8;
122
123-- Volcando datos para la tabla redemrp.outfits: ~0 rows (aproximadamente)
124/*!40000 ALTER TABLE `outfits` DISABLE KEYS */;
125/*!40000 ALTER TABLE `outfits` ENABLE KEYS */;
126
127-- Volcando estructura para tabla redemrp.skins
128CREATE TABLE IF NOT EXISTS `skins` (
129 `id` int(11) NOT NULL AUTO_INCREMENT,
130 `identifier` varchar(40) NOT NULL,
131 `charid` int(11) NOT NULL,
132 `skin` json NOT NULL,
133 KEY `id` (`id`)
134) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
135
136-- Volcando datos para la tabla redemrp.skins: ~1 rows (aproximadamente)
137/*!40000 ALTER TABLE `skins` DISABLE KEYS */;
138INSERT IGNORE INTO `skins` (`id`, `identifier`, `charid`, `skin`) VALUES
139 (6, 'steam:110000108381d36', 1, '{"sex": "1", "face": "56", "hair": "3", "beard": "1", "value": true, "moles_t": "1", "scars_t": "1", "spots_t": "1", "ageing_t": "1", "bodysize": "5", "eyecolor": "1", "moles_op": "1", "scars_op": "1", "spots_op": "1", "ageing_op": "1", "jaw_depth": "0", "jaw_width": "0", "nose_size": "0", "skincolor": "1", "chin_depth": "0", "chin_width": "0", "ears_angle": "0", "ears_width": "0", "eyebrows_t": "1", "eyes_angle": "0", "eyes_depth": "0", "face_width": "-100", "freckles_t": "1", "jaw_height": "0", "nose_angle": "0", "nose_width": "0", "chin_height": "0", "ears_height": "0", "eyebrows_c1": "1", "eyebrows_c2": "1", "eyebrows_c3": "1", "eyebrows_id": "1", "eyebrows_op": "1", "freckles_op": "1", "mouth_depth": "0", "mouth_width": "0", "mouth_x_pos": "0", "mouth_y_pos": "0", "nose_height": "0", "earlobe_size": "0", "eyelid_width": "0", "eyebrow_depth": "0", "eyebrow_width": "0", "eyelid_height": "0", "eyes_distance": "0", "eyebrow_height": "2", "nose_curvature": "0", "lower_lip_depth": "0", "lower_lip_width": "0", "upper_lip_depth": "0", "upper_lip_width": "0", "cheekbones_depth": "0", "cheekbones_width": "0", "lower_lip_height": "5", "upper_lip_height": "0", "cheekbones_height": "0", "nostrils_distance": "0"}'),
140 (7, 'steam:110000114e6a67f', 1, '{"sex": "1", "face": "1", "hair": "1", "beard": "1", "value": true, "moles_t": "1", "scars_t": "1", "spots_t": "1", "ageing_t": "1", "bodysize": "3", "eyecolor": "1", "moles_op": "1", "scars_op": "1", "spots_op": "1", "ageing_op": "1", "jaw_depth": "0", "jaw_width": "0", "nose_size": "0", "skincolor": "1", "chin_depth": "0", "chin_width": "0", "ears_angle": "0", "ears_width": "0", "eyebrows_t": "1", "eyes_angle": "0", "eyes_depth": "0", "face_width": "0", "freckles_t": "1", "jaw_height": "0", "nose_angle": "0", "nose_width": "0", "chin_height": "0", "ears_height": "0", "eyebrows_c1": "1", "eyebrows_c2": "1", "eyebrows_c3": "1", "eyebrows_id": "1", "eyebrows_op": "1", "freckles_op": "1", "mouth_depth": "0", "mouth_width": "0", "mouth_x_pos": "0", "mouth_y_pos": "0", "nose_height": "0", "earlobe_size": "0", "eyelid_width": "0", "eyebrow_depth": "0", "eyebrow_width": "0", "eyelid_height": "0", "eyes_distance": "0", "eyebrow_height": "0", "nose_curvature": "0", "lower_lip_depth": "0", "lower_lip_width": "0", "upper_lip_depth": "0", "upper_lip_width": "0", "cheekbones_depth": "0", "cheekbones_width": "0", "lower_lip_height": "0", "upper_lip_height": "0", "cheekbones_height": "0", "nostrils_distance": "0"}');
141/*!40000 ALTER TABLE `skins` ENABLE KEYS */;
142
143-- Volcando estructura para tabla redemrp.users
144CREATE TABLE IF NOT EXISTS `users` (
145 `id` int(11) NOT NULL AUTO_INCREMENT,
146 `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
147 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
148 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
149 `money` int(11) DEFAULT NULL,
150 `bank` int(11) DEFAULT NULL,
151 `permission_level` int(11) DEFAULT NULL,
152 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
153 PRIMARY KEY (`identifier`),
154 KEY `id` (`id`)
155) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
156
157-- Volcando datos para la tabla redemrp.users: ~2 rows (aproximadamente)
158/*!40000 ALTER TABLE `users` DISABLE KEYS */;
159INSERT IGNORE INTO `users` (`id`, `identifier`, `license`, `name`, `money`, `bank`, `permission_level`, `group`) VALUES
160 (9, 'steam:110000108381d36', 'license:rockstardevlicense', NULL, 0, 0, 100, 'superadmin'),
161 (10, 'steam:110000114e6a67f', 'license:rockstardevlicense', NULL, 0, 0, 0, 'user');
162/*!40000 ALTER TABLE `users` ENABLE KEYS */;
163
164-- Volcando estructura para tabla redemrp.user_inventory
165CREATE TABLE IF NOT EXISTS `user_inventory` (
166 `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
167 `charid` int(11) NOT NULL,
168 `items` varchar(8000) COLLATE utf8mb4_bin NOT NULL
169) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
170
171-- Volcando datos para la tabla redemrp.user_inventory: ~1 rows (aproximadamente)
172/*!40000 ALTER TABLE `user_inventory` DISABLE KEYS */;
173INSERT IGNORE INTO `user_inventory` (`identifier`, `charid`, `items`) VALUES
174 ('steam:110000108381d36', 1, '{"water":3,"bread":3}'),
175 ('steam:110000114e6a67f', 1, '{"water":3,"bread":3}');
176/*!40000 ALTER TABLE `user_inventory` ENABLE KEYS */;
177
178-- Volcando estructura para tabla redemrp.version
179CREATE TABLE IF NOT EXISTS `version` (
180 `id` int(11) NOT NULL,
181 `current` varchar(3) COLLATE utf8mb4_bin DEFAULT 'no',
182 `resource` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
183) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
184
185-- Volcando datos para la tabla redemrp.version: ~12 rows (aproximadamente)
186/*!40000 ALTER TABLE `version` DISABLE KEYS */;
187INSERT IGNORE INTO `version` (`id`, `current`, `resource`) VALUES
188 (1, 'no', 'redemrp'),
189 (2, 'no', NULL),
190 (3, 'no', NULL),
191 (3, 'no', NULL),
192 (4, 'no', NULL),
193 (4, 'no', NULL),
194 (4, 'no', NULL),
195 (5, 'yes', NULL),
196 (5, 'yes', NULL),
197 (5, 'yes', NULL),
198 (5, 'yes', NULL),
199 (5, 'yes', NULL);
200/*!40000 ALTER TABLE `version` ENABLE KEYS */;
201
202-- Volcando estructura para tabla redemrp.web_permissions
203CREATE TABLE IF NOT EXISTS `web_permissions` (
204 `username` varchar(50) DEFAULT NULL,
205 `password` varchar(50) DEFAULT NULL,
206 `role` varchar(50) DEFAULT NULL
207) ENGINE=InnoDB DEFAULT CHARSET=latin1;
208
209-- Volcando datos para la tabla redemrp.web_permissions: ~0 rows (aproximadamente)
210/*!40000 ALTER TABLE `web_permissions` DISABLE KEYS */;
211/*!40000 ALTER TABLE `web_permissions` ENABLE KEYS */;
212
213-- Volcando estructura para tabla redemrp.xp
214CREATE TABLE IF NOT EXISTS `xp` (
215 `id` int(11) NOT NULL AUTO_INCREMENT,
216 `identifier` varchar(50) DEFAULT NULL,
217 `miner` int(11) DEFAULT '0',
218 `carpenter` int(11) DEFAULT '0',
219 `hunter` int(11) DEFAULT '0',
220 `farmer` int(11) DEFAULT '0',
221 `chef` int(11) DEFAULT '0',
222 `explorer` int(11) DEFAULT '0',
223 PRIMARY KEY (`id`),
224 UNIQUE KEY `id` (`id`)
225) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
226
227-- Volcando datos para la tabla redemrp.xp: ~1 rows (aproximadamente)
228/*!40000 ALTER TABLE `xp` DISABLE KEYS */;
229INSERT IGNORE INTO `xp` (`id`, `identifier`, `miner`, `carpenter`, `hunter`, `farmer`, `chef`, `explorer`) VALUES
230 (4, 'steam:110000108381d36', 0, 0, 0, 0, 0, 0);
231/*!40000 ALTER TABLE `xp` ENABLE KEYS */;
232
233/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
234/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
235/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;