YjG02W9h

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.3.8-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Version:             9.5.0.5196
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-- Dumping structure for table habboapi.hibernate_sequence
15CREATE TABLE IF NOT EXISTS `hibernate_sequence` (
16  `next_val` bigint(20) DEFAULT NULL
17) ENGINE=MyISAM DEFAULT CHARSET=utf8;
18
19-- Data exporting was unselected.
20-- Dumping structure for table habboapi.server_config
21CREATE TABLE IF NOT EXISTS `server_config` (
22  `id` int(11) NOT NULL,
23  `config_key` varchar(255) NOT NULL,
24  `config_value` varchar(255) NOT NULL,
25  PRIMARY KEY (`id`),
26  UNIQUE KEY `UK_gn56snoy6xwobhmyn7vwmyw5y` (`config_key`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8;
28
29-- Data exporting was unselected.
30-- Dumping structure for table habboapi.users
31CREATE TABLE IF NOT EXISTS `users` (
32  `id` int(11) NOT NULL AUTO_INCREMENT,
33  `timestamp_created` int(11) NOT NULL,
34  `timestamp_updated` int(11) NOT NULL,
35  `figure` varchar(256) NOT NULL,
36  `gender` enum('M','F') NOT NULL,
37  `home_room` int(11) NOT NULL,
38  `ip_last` varchar(45) DEFAULT NULL,
39  `ip_register` varchar(45) NOT NULL,
40  `machine_id` varchar(255) DEFAULT NULL,
41  `motto` varchar(127) DEFAULT NULL,
42  `password` varchar(64) NOT NULL,
43  `rank` int(11) NOT NULL,
44  `username` varchar(25) NOT NULL,
45  PRIMARY KEY (`id`),
46  UNIQUE KEY `UK_r43af9ap4edm43mmtq01oddj6` (`username`)
47) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
48
49-- Data exporting was unselected.
50-- Dumping structure for table habboapi.user_security_tickets
51CREATE TABLE IF NOT EXISTS `user_security_tickets` (
52  `id` int(11) NOT NULL AUTO_INCREMENT,
53  `timestamp_created` int(11) NOT NULL,
54  `timestamp_updated` int(11) NOT NULL,
55  `ticket` varchar(255) NOT NULL,
56  `user_id` int(11) NOT NULL,
57  `user_ip` varchar(255) NOT NULL,
58  PRIMARY KEY (`id`)
59) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
60
61-- Data exporting was unselected.
62/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
63/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
64/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;