8Wk6D5dr

1
2DROP TABLE IF EXISTS `whitelist`;
3CREATE TABLE `whitelist`  (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
6  PRIMARY KEY (`id`) USING BTREE,
7  UNIQUE INDEX `identifier`(`identifier`) USING BTREE
8) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
9
10CREATE TABLE IF NOT EXISTS `users` (
11  `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
12  `group` varchar(50) DEFAULT 'user',
13  `warnings` int(11) DEFAULT 0,
14  `banned` tinyint(4) DEFAULT 0,
15  PRIMARY KEY (`identifier`),
16  UNIQUE KEY `identifier` (`identifier`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
18
19
20DROP TABLE IF EXISTS `characters`;
21CREATE TABLE `characters`  (
22  `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
23  `charidentifier` int(11) NOT NULL AUTO_INCREMENT,
24  `group` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'user',
25  `money` double(11, 2) NULL DEFAULT 0,
26  `gold` double(11, 2) NULL DEFAULT 0,
27  `rol` double(11, 2) NOT NULL DEFAULT 0,
28  `xp` int(11) NULL DEFAULT 0,
29  `inventory` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
30  `job` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'unemployed',
31  `status` varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '{}',
32  `firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT ' ',
33  `lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT ' ',
34  `skinPlayer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
35  `compPlayer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
36  `jobgrade` int(11) NULL DEFAULT 0,
37  `coords` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '{}',
38  `isdead` tinyint(1) NULL DEFAULT 0,
39  UNIQUE INDEX `identifier_charidentifier`(`identifier`, `charidentifier`) USING BTREE,
40  INDEX `charidentifier`(`charidentifier`) USING BTREE,
41  CONSTRAINT `FK_characters_users` FOREIGN KEY (`identifier`) REFERENCES `users` (`identifier`) ON DELETE CASCADE ON UPDATE CASCADE
42) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC;
43