· 7 years ago · Sep 07, 2018, 04:34 PM
1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9
10CREATE TABLE IF NOT EXISTS `cms_alerts` (
11 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
12 `user_id` varchar(100) NOT NULL,
13 `alert` text NOT NULL,
14 `type` varchar(25) NOT NULL DEFAULT 'feed-notification',
15 PRIMARY KEY (`id`)
16) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
17
18CREATE TABLE IF NOT EXISTS `cms_faq` (
19 `id` int(255) NOT NULL AUTO_INCREMENT,
20 `type` varchar(255) NOT NULL DEFAULT 'type',
21 `catid` int(11) DEFAULT NULL,
22 `title` varchar(1000) NOT NULL,
23 `content` text,
24 `show_in_footer` tinyint(4) NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
27
28CREATE TABLE IF NOT EXISTS `cms_forum_posts` (
29 `id` int(15) NOT NULL AUTO_INCREMENT,
30 `threadid` int(15) NOT NULL DEFAULT '0',
31 `message` text NOT NULL,
32 `author` varchar(30) NOT NULL,
33 `date` varchar(30) NOT NULL,
34 `edit_date` varchar(30) NOT NULL,
35 `edit_author` varchar(25) NOT NULL,
36 `forumid` int(10) NOT NULL DEFAULT '0',
37 PRIMARY KEY (`id`)
38) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
39
40CREATE TABLE IF NOT EXISTS `cms_forum_threads` (
41 `id` int(15) NOT NULL AUTO_INCREMENT,
42 `type` tinyint(4) NOT NULL,
43 `title` varchar(30) NOT NULL,
44 `author` varchar(25) NOT NULL,
45 `date` varchar(35) NOT NULL,
46 `lastpost_author` varchar(25) NOT NULL,
47 `lastpost_date` varchar(35) NOT NULL,
48 `views` int(11) NOT NULL,
49 `posts` tinyint(4) NOT NULL,
50 `unix` varchar(40) NOT NULL,
51 `forumid` int(10) NOT NULL DEFAULT '0',
52 PRIMARY KEY (`id`)
53) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
54
55CREATE TABLE IF NOT EXISTS `cms_guestbook_entries` (
56 `id` int(10) NOT NULL AUTO_INCREMENT,
57 `message` varchar(500) DEFAULT NULL,
58 `time` varchar(100) DEFAULT NULL,
59 `widget_id` int(10) DEFAULT NULL,
60 `home_id` int(10) DEFAULT NULL,
61 `userid` int(10) DEFAULT NULL,
62 PRIMARY KEY (`id`)
63) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
64
65CREATE TABLE IF NOT EXISTS `cms_homes_group_linker` (
66 `userid` int(11) NOT NULL,
67 `groupid` int(11) NOT NULL,
68 `active` varchar(1) NOT NULL DEFAULT '0'
69) ENGINE=MyISAM DEFAULT CHARSET=latin1;
70
71CREATE TABLE IF NOT EXISTS `cms_homes_stickers` (
72 `id` int(11) NOT NULL AUTO_INCREMENT,
73 `userid` int(11) NOT NULL,
74 `x` varchar(6) NOT NULL DEFAULT '1' COMMENT 'left',
75 `y` varchar(6) NOT NULL DEFAULT '1' COMMENT 'top',
76 `z` varchar(6) NOT NULL DEFAULT '1' COMMENT 'z-index',
77 `data` text NOT NULL,
78 `type` varchar(1) NOT NULL DEFAULT '1',
79 `subtype` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Widget Type (if widget)',
80 `skin` text NOT NULL,
81 `groupid` int(11) NOT NULL DEFAULT '-1',
82 `var` int(100) DEFAULT NULL,
83 PRIMARY KEY (`id`)
84) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
85
86CREATE TABLE IF NOT EXISTS `cms_lotery` (
87 `id` int(10) NOT NULL AUTO_INCREMENT,
88 `userid` int(20) NOT NULL,
89 `ticket` varchar(5) NOT NULL,
90 PRIMARY KEY (`id`)
91) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
92
93CREATE TABLE IF NOT EXISTS `cms_recommended` (
94 `id` int(10) NOT NULL AUTO_INCREMENT,
95 `id_rec` int(10) DEFAULT NULL,
96 `type` enum('group','room') NOT NULL,
97 PRIMARY KEY (`id`)
98) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
99
100CREATE TABLE IF NOT EXISTS `cms_system` (
101 `sitename` varchar(30) COLLATE latin1_general_ci NOT NULL,
102 `shortname` varchar(30) COLLATE latin1_general_ci NOT NULL,
103 `site_closed` enum('0','1') COLLATE latin1_general_ci NOT NULL COMMENT 'Maintenance Mode',
104 `ip` varchar(50) COLLATE latin1_general_ci NOT NULL,
105 `texts` text COLLATE latin1_general_ci NOT NULL,
106 `variables` text COLLATE latin1_general_ci NOT NULL,
107 `productdata` text COLLATE latin1_general_ci NOT NULL,
108 `furnidata` text COLLATE latin1_general_ci NOT NULL,
109 `dcr` text COLLATE latin1_general_ci NOT NULL,
110 `flash_url` text COLLATE latin1_general_ci NOT NULL,
111 `flash_base` text CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
112 `start_credits` int(10) NOT NULL DEFAULT '0',
113 `start_pixels` int(10) NOT NULL DEFAULT '0',
114 `admin_notes` text COLLATE latin1_general_ci NOT NULL,
115 `chat_html` longtext CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
116 `radio_html` longtext COLLATE latin1_general_ci NOT NULL,
117 `client` enum('DCR','SWF') COLLATE latin1_general_ci NOT NULL DEFAULT 'DCR',
118 `free_rooms` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
119 `type_index` enum('veryold','old','new') COLLATE latin1_general_ci NOT NULL DEFAULT 'new',
120 `hotel_view` text COLLATE latin1_general_ci,
121 `text_client` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT 'Entra al Hotel',
122 `header_state` enum('none','visits','state') COLLATE latin1_general_ci NOT NULL DEFAULT 'none',
123 `show_extras` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
124 `register_enabled` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
125 `image_logo` mediumtext COLLATE latin1_general_ci NOT NULL,
126 `image_sublogo` mediumtext COLLATE latin1_general_ci NOT NULL,
127 `custom_logo` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
128 `custom_sublogo` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
129 `hc_months` int(2) NOT NULL DEFAULT '0',
130 `hc_type` enum('HC','VIP') COLLATE latin1_general_ci NOT NULL DEFAULT 'HC',
131 `analytics` longtext COLLATE latin1_general_ci NOT NULL,
132 `rea_time` varchar(30) COLLATE latin1_general_ci NOT NULL,
133 `site_description` text COLLATE latin1_general_ci NOT NULL,
134 `site_keywords` text COLLATE latin1_general_ci NOT NULL,
135 `hotel_status` enum('0','1','2') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
136 `flash_promo` enum('old','new') COLLATE latin1_general_ci NOT NULL DEFAULT 'old',
137 `enable_flash_promo` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
138 `enable_staffs_page` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
139 `enable_applications_page` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
140 `hc_maxmonths` int(2) NOT NULL DEFAULT '12',
141 `allow_group_purchase` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
142 `time_reload` int(20) NOT NULL,
143 `twitter_user` varchar(50) COLLATE latin1_general_ci NOT NULL,
144 `easy_style` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT 'normal',
145 `check_figures` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
146 `time_lotery` varchar(100) COLLATE latin1_general_ci NOT NULL,
147 `busytime` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
148 `conectionType` enum('normal','onlyID') COLLATE latin1_general_ci NOT NULL DEFAULT 'normal',
149 `language` enum('spanish','english') COLLATE latin1_general_ci NOT NULL DEFAULT 'spanish',
150 `typeButton` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
151 `hotel2` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
152 `url_hotel2` text CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
153 `logo_index` enum('1','2','3','4','5') CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '1',
154 `index_subtitle` text CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
155 `type_house` enum('1','2') CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '1',
156 `client_text` text CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL,
157 `https` enum('0','1') CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT '0',
158 `habbobuild` text COLLATE latin1_general_ci NOT NULL,
159 `image_fp` text COLLATE latin1_general_ci NOT NULL,
160 `maintenance` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0' COMMENT 'Maintenance Mode'
161) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
162
163/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
164/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
165/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;