· 6 years ago · Mar 29, 2019, 03:32 PM
1SET FOREIGN_KEY_CHECKS=0;
2-- ----------------------------
3-- Table structure for `rooms`
4-- ----------------------------
5DROP TABLE IF EXISTS `rooms`;
6CREATE TABLE `rooms` (
7 `id` int(10) NOT NULL AUTO_INCREMENT,
8 `roomtype` enum('public','private') NOT NULL DEFAULT 'private',
9 `caption` varchar(100) NOT NULL DEFAULT 'Room',
10 `owner` varchar(75) NOT NULL DEFAULT '',
11 `description` varchar(255) NOT NULL DEFAULT '',
12 `category` int(11) NOT NULL DEFAULT '0',
13 `state` enum('open','locked','password','invisible') NOT NULL DEFAULT 'open',
14 `users_now` int(11) NOT NULL DEFAULT '0',
15 `users_max` int(11) NOT NULL DEFAULT '25',
16 `model_name` varchar(50) NOT NULL,
17 `score` int(11) NOT NULL DEFAULT '0',
18 `tags` varchar(100) NOT NULL DEFAULT '',
19 `password` varchar(30) NOT NULL DEFAULT '',
20 `wallpaper` varchar(10) NOT NULL DEFAULT '0.0',
21 `floor` varchar(10) NOT NULL DEFAULT '0.0',
22 `landscape` varchar(10) NOT NULL DEFAULT '0.0',
23 `allow_pets` enum('0','1') NOT NULL DEFAULT '0',
24 `allow_pets_eat` enum('0','1') NOT NULL DEFAULT '0',
25 `room_blocking_disabled` enum('0','1') NOT NULL DEFAULT '0',
26 `allow_hidewall` enum('0','1') NOT NULL DEFAULT '0',
27 `wallthick` int(1) NOT NULL DEFAULT '0',
28 `floorthick` int(1) NOT NULL DEFAULT '0',
29 `group_id` int(11) unsigned NOT NULL DEFAULT '0',
30 `mute_settings` enum('0','1') NOT NULL DEFAULT '1',
31 `ban_settings` enum('0','1') NOT NULL DEFAULT '1',
32 `kick_settings` enum('0','1','2') NOT NULL DEFAULT '1',
33 `chat_mode` int(11) NOT NULL DEFAULT '0',
34 `chat_size` int(11) NOT NULL DEFAULT '0',
35 `chat_speed` int(11) NOT NULL DEFAULT '0',
36 `chat_extra_flood` int(11) NOT NULL DEFAULT '0',
37 `chat_hearing_distance` int(11) NOT NULL DEFAULT '14',
38 `trade_settings` int(11) NOT NULL DEFAULT '2',
39 `push_enabled` enum('0','1') NOT NULL DEFAULT '1',
40 `pull_enabled` enum('0','1') NOT NULL DEFAULT '1',
41 `enables_enabled` enum('0','1') NOT NULL DEFAULT '1',
42 `respect_notifications_enabled` enum('0','1') NOT NULL DEFAULT '1',
43 `pet_morphs_allowed` enum('0','1') NOT NULL DEFAULT '1',
44 `spull_enabled` enum('0','1') NOT NULL DEFAULT '1',
45 `spush_enabled` enum('0','1') NOT NULL DEFAULT '1',
46 `golpe_enabled` enum('0','1') NOT NULL DEFAULT '1',
47 `roller_speed` int(11) NOT NULL DEFAULT '4',
48 `besos_enabled` enum('0','1') NOT NULL DEFAULT '1',
49 `shoot` int(11) NOT NULL DEFAULT '1',
50 `hide_wired` enum('0','1') NOT NULL DEFAULT '0',
51 PRIMARY KEY (`id`),
52 UNIQUE KEY `id` (`id`),
53 KEY `owner` (`owner`),
54 KEY `users_now` (`users_now`),
55 KEY `roomtype` (`roomtype`),
56 KEY `caption` (`caption`),
57 KEY `score` (`score`),
58 KEY `category` (`category`),
59 KEY `group_id` (`group_id`)
60) ENGINE=InnoDB AUTO_INCREMENT=1006 DEFAULT CHARSET=latin1;
61
62-- ----------------------------
63-- Records of rooms
64-- ----------------------------
65INSERT INTO `rooms` VALUES ('209', 'private', 'test 2', '1417', '', '36', 'open', '0', '10', 'model_5', '1', '', '', '0.0', '0.0', '0.0', '0', '0', '0', '1', '-1', '-2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '1', '1', '1', '1', '1', '1', '1', '1', '4', '1', '1', '0');