· 4 years ago · Jan 05, 2021, 09:02 PM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Versión del servidor: 10.5.4-MariaDB-log - mariadb.org binary distribution
4-- SO del servidor: Win64
5-- HeidiSQL Versión: 11.0.0.5919
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-- Volcando estructura para tabla nexus.users_jail
15CREATE TABLE IF NOT EXISTS `users_jail` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `identifier` varchar(50) DEFAULT NULL,
18 `charId` int(11) DEFAULT NULL,
19 `jailTime` int(11) NOT NULL DEFAULT 0,
20 `jailType` varchar(50) DEFAULT NULL,
21 PRIMARY KEY (`id`),
22 KEY `identifier` (`identifier`)
23) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
24
25-- Volcando datos para la tabla nexus.users_jail: ~2 rows (aproximadamente)
26/*!40000 ALTER TABLE `users_jail` DISABLE KEYS */;
27INSERT INTO `users_jail` (`id`, `identifier`, `charId`, `jailTime`, `jailType`) VALUES
28 (1, '7991e33c01e8fd7b8928ec9cc3e5b34f6b835112', 80, 0, 'PRISON'),
29 (2, '7991e33c01e8fd7b8928ec9cc3e5b34f6b835112', 79, 0, 'other');
30/*!40000 ALTER TABLE `users_jail` ENABLE KEYS */;
31
32/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
33/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
34/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
35