1GT0299x

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : MicroServer
5Source Server Version : 50716
6Source Host           : localhost:3306
7Source Database       : db
8
9Target Server Type    : MYSQL
10Target Server Version : 50716
11File Encoding         : 65001
12
13Date: 2016-10-29 15:32:14
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for cms_news
20-- ----------------------------
21DROP TABLE IF EXISTS `cms_news`;
22CREATE TABLE `cms_news` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `title` varchar(100) NOT NULL,
25  `image` varchar(100) NOT NULL DEFAULT '0',
26  `shortstory` text NOT NULL,
27  `longstory` text NOT NULL,
28  `author` varchar(100) NOT NULL DEFAULT 'Tom',
29  `date` int(11) NOT NULL DEFAULT '0',
30  `type` varchar(100) NOT NULL DEFAULT '1',
31  `roomid` varchar(100) NOT NULL DEFAULT '1',
32  `updated` enum('0','1') NOT NULL DEFAULT '0',
33  `enabled` int(255) DEFAULT NULL,
34  `published` varchar(255) DEFAULT NULL,
35  `visible` varchar(255) DEFAULT NULL,
36  `comments_open` varchar(255) DEFAULT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
39
40
41-- ----------------------------
42-- Table structure for cms_rarevalues
43-- ----------------------------
44DROP TABLE IF EXISTS `cms_rarevalues`;
45CREATE TABLE `cms_rarevalues` (
46  `id` int(11) NOT NULL AUTO_INCREMENT,
47  `name` varchar(255) NOT NULL,
48  `imgurl` varchar(255) DEFAULT NULL,
49  `price` varchar(10) NOT NULL,
50  PRIMARY KEY (`id`,`name`)
51) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8;
52
53-- ----------------------------
54-- Records of cms_rarevalues
55-- ----------------------------
56INSERT INTO `cms_rarevalues` VALUES ('1', 'Aqua Laser', 'http://microhotel.co.uk/images/rares/laser_aqua.gif', '60000');
57INSERT INTO `cms_rarevalues` VALUES ('2', 'Aqua Marquee', 'http://microhotel.co.uk/images/rares/marquee_aqua.gif', '55000');
58INSERT INTO `cms_rarevalues` VALUES ('3', 'Aqua Monolith', 'http://microhotel.co.uk/images/rares/mono_aqua.gif', '45000');
59INSERT INTO `cms_rarevalues` VALUES ('4', 'Army Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_army.gif', '30000');
60INSERT INTO `cms_rarevalues` VALUES ('5', 'Black Dragon', 'http://microhotel.co.uk/images/rares/dragon_black.gif', '120000');
61INSERT INTO `cms_rarevalues` VALUES ('6', 'Black Monolith', 'http://microhotel.co.uk/images/rares/mono_black.gif', '45000');
62INSERT INTO `cms_rarevalues` VALUES ('7', 'Blue Bird Bath', ' http://microhotel.co.uk/images/rares/bath_blue.gif', '40000');
63INSERT INTO `cms_rarevalues` VALUES ('8', 'Blue Dragon', 'http://microhotel.co.uk/images/rares/dragon_blue.gif', '120000');
64INSERT INTO `cms_rarevalues` VALUES ('9', 'Blue Fan', 'http://microhotel.co.uk/images/rares/fan_blue.gif', '50000');
65INSERT INTO `cms_rarevalues` VALUES ('10', 'Blue Marquee', 'http://microhotel.co.uk/images/rares/marquee_blue.gif', '55000');
66INSERT INTO `cms_rarevalues` VALUES ('11', 'Blue Monolith', 'http://microhotel.co.uk/images/rares/mono_blue.gif', '45000');
67INSERT INTO `cms_rarevalues` VALUES ('12', 'Blue Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_blue.gif', '30000');
68INSERT INTO `cms_rarevalues` VALUES ('13', 'Bronze Dragon', 'http://microhotel.co.uk/images/rares/dragon_bronze.gif', '120000');
69INSERT INTO `cms_rarevalues` VALUES ('14', 'Bronze Trophy', 'http://microhotel.co.uk/images/rares/trophy_small_bronze.gif', '45000');
70INSERT INTO `cms_rarevalues` VALUES ('15', 'Brown Fan', 'http://microhotel.co.uk/images/rares/fan_brown.gif', '50000');
71INSERT INTO `cms_rarevalues` VALUES ('16', 'Dragon Egg', 'http://microhotel.co.uk/images/rares/dino.gif', '60000');
72INSERT INTO `cms_rarevalues` VALUES ('17', 'Forest Dragon', 'http://microhotel.co.uk/images/rares/forest_dragon.gif', '120000');
73INSERT INTO `cms_rarevalues` VALUES ('18', 'Fuchsia Fan', 'http://microhotel.co.uk/images/rares/fan_fuchsia.gif', '50000');
74INSERT INTO `cms_rarevalues` VALUES ('19', 'Fuchsia Monolith', 'http://microhotel.co.uk/images/rares/mono_fuchsia.gif', '45000');
75INSERT INTO `cms_rarevalues` VALUES ('20', 'Gold Dragon', 'http://microhotel.co.uk/images/rares/dragon_gold.gif', '120000');
76INSERT INTO `cms_rarevalues` VALUES ('21', 'Gold Trophy', 'http://microhotel.co.uk/images/rares/trophy_small_gold.gif', '45000');
77INSERT INTO `cms_rarevalues` VALUES ('22', 'Graphite Marquee', 'http://microhotel.co.uk/images/rares/marquee_graphite.gif', '55000');
78INSERT INTO `cms_rarevalues` VALUES ('23', 'Green Bird Bath', 'http://microhotel.co.uk/images/rares/bath_green.gif', '40000');
79INSERT INTO `cms_rarevalues` VALUES ('24', 'Green Dragon', 'http://microhotel.co.uk/images/rares/dragon_green.gif', '120000');
80INSERT INTO `cms_rarevalues` VALUES ('25', 'Green Fan', 'http://microhotel.co.uk/images/rares/fan_green.gif', '50000');
81INSERT INTO `cms_rarevalues` VALUES ('26', 'Green Marquee', 'http://microhotel.co.uk/images/rares/marquee_green.gif', '55000');
82INSERT INTO `cms_rarevalues` VALUES ('27', 'Green Parasol', 'http://microhotel.co.uk/images/rares/para_green.gif', '30000');
83INSERT INTO `cms_rarevalues` VALUES ('28', 'Grey Bird Bath', 'http://microhotel.co.uk/images/rares/bath_grey.gif', '40000');
84INSERT INTO `cms_rarevalues` VALUES ('29', 'Grey Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_grey.gif', '30000');
85INSERT INTO `cms_rarevalues` VALUES ('30', 'Holoboy', 'http://microhotel.co.uk/images/rares/holopod.gif', '65000');
86INSERT INTO `cms_rarevalues` VALUES ('31', 'Jade Dragon', 'http://microhotel.co.uk/images/rares/dragon_jade.gif', '120000');
87INSERT INTO `cms_rarevalues` VALUES ('32', 'Jade Monolith', 'http://microhotel.co.uk/images/rares/mono_jade.gif', '45000');
88INSERT INTO `cms_rarevalues` VALUES ('33', 'Khaki Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_khaki.gif', '30000');
89INSERT INTO `cms_rarevalues` VALUES ('34', 'Light Blue Monolith', 'http://microhotel.co.uk/images/rares/mono_lightblue.gif', '45000');
90INSERT INTO `cms_rarevalues` VALUES ('35', 'Lime Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_lime.gif', '30000');
91INSERT INTO `cms_rarevalues` VALUES ('36', 'Lollipop Dragon', 'http://microhotel.co.uk/images/rares/lollipop_dragon.gif', '120000');
92INSERT INTO `cms_rarevalues` VALUES ('37', 'Navy Marquee', 'http://microhotel.co.uk/images/rares/marquee_navy.gif', '55000');
93INSERT INTO `cms_rarevalues` VALUES ('38', 'Ocean Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_ocean.gif', '30000');
94INSERT INTO `cms_rarevalues` VALUES ('39', 'Ochre Fan', 'http://microhotel.co.uk/images/rares/fan_ochre.gif', '50000');
95INSERT INTO `cms_rarevalues` VALUES ('40', 'Orange Parasol', 'http://microhotel.co.uk/images/rares/para_orange.gif', '30000');
96INSERT INTO `cms_rarevalues` VALUES ('41', 'Orange Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_orange.gif', '30000');
97INSERT INTO `cms_rarevalues` VALUES ('42', 'Petal Patch', 'http://microhotel.co.uk/images/rares/petal.gif', '50000');
98INSERT INTO `cms_rarevalues` VALUES ('43', 'Pink Dragon', 'http://microhotel.co.uk/images/rares/dragon_pink.gif', '120000');
99INSERT INTO `cms_rarevalues` VALUES ('44', 'Pink Marquee', 'http://microhotel.co.uk/images/rares/marquee_pink.gif', '55000');
100INSERT INTO `cms_rarevalues` VALUES ('45', 'Pink Monolith', 'http://microhotel.co.uk/images/rares/mono_pink.gif', '45000');
101INSERT INTO `cms_rarevalues` VALUES ('46', 'Purple Dragon', 'http://microhotel.co.uk/images/rares/dragon_purple.gif', '120000');
102INSERT INTO `cms_rarevalues` VALUES ('47', 'Purple Fan', 'http://microhotel.co.uk/images/rares/fan_purple.gif', '50000');
103INSERT INTO `cms_rarevalues` VALUES ('48', 'Purple Marquee', 'http://microhotel.co.uk/images/rares/marquee_purple.gif', '55000');
104INSERT INTO `cms_rarevalues` VALUES ('49', 'Purple Parasol', 'http://microhotel.co.uk/images/rares/para_purple.gif', '30000');
105INSERT INTO `cms_rarevalues` VALUES ('50', 'Purple Sleeping Bag', 'http://microhotel.co.uk/images/rares/bag_purple.gif', '30000');
106INSERT INTO `cms_rarevalues` VALUES ('51', 'Red Amber Lamp', 'http://microhotel.co.uk/images/rares/amber_red.gif', '60000');
107INSERT INTO `cms_rarevalues` VALUES ('52', 'Red Barrier', 'http://microhotel.co.uk/images/rares/barrier_red.gif', '10000');
108INSERT INTO `cms_rarevalues` VALUES ('53', 'Red Bird Bath', 'http://microhotel.co.uk/images/rares/bath_red.gif', '40000');
109INSERT INTO `cms_rarevalues` VALUES ('54', 'Red Dragon', 'http://microhotel.co.uk/images/rares/dragon_red.gif', '120000');
110INSERT INTO `cms_rarevalues` VALUES ('55', 'Red Fan', 'http://microhotel.co.uk/images/rares/fan_red.gif', '50000');
111INSERT INTO `cms_rarevalues` VALUES ('56', 'Red Marquee', 'http://microhotel.co.uk/images/rares/marquee_red.gif', '55000');
112INSERT INTO `cms_rarevalues` VALUES ('57', 'Royal Egyptian Lamp', 'http://microhotel.co.uk/images/rares/amber_blue.gif', '60000');
113INSERT INTO `cms_rarevalues` VALUES ('58', 'Silver Dragon', 'http://microhotel.co.uk/images/rares/dragon_silver.gif', '120000');
114INSERT INTO `cms_rarevalues` VALUES ('59', 'Silver Trophy', 'http://microhotel.co.uk/images/rares/trophy_small_silver.gif', '45000');
115INSERT INTO `cms_rarevalues` VALUES ('60', 'Sky Dragon', 'http://microhotel.co.uk/images/rares/dragon_sky.gif', '120000');
116INSERT INTO `cms_rarevalues` VALUES ('61', 'Throne', 'http://microhotel.co.uk/images/rares/throne.gif', '60000');
117INSERT INTO `cms_rarevalues` VALUES ('62', 'Turquoise Fan', 'http://microhotel.co.uk/images/rares/fan_turquoise.gif', '50000');
118INSERT INTO `cms_rarevalues` VALUES ('63', 'Typewriter', 'http://microhotel.co.uk/images/rares/typo.gif', '80000');
119INSERT INTO `cms_rarevalues` VALUES ('64', 'Violet Monolith', 'http://microhotel.co.uk/images/rares/mono_violet.gif', '45000');
120INSERT INTO `cms_rarevalues` VALUES ('65', 'White Barrier', 'http://microhotel.co.uk/images/rares/barrier_white.gif', '10000');
121INSERT INTO `cms_rarevalues` VALUES ('66', 'White Marquee', 'http://microhotel.co.uk/images/rares/marquee_white.gif', '55000');
122INSERT INTO `cms_rarevalues` VALUES ('67', 'White Monolith', 'http://microhotel.co.uk/images/rares/mono_white.gif', '45000');
123INSERT INTO `cms_rarevalues` VALUES ('68', 'Yellow Amber Lamp', 'http://microhotel.co.uk/images/rares/amber_yellow.gif', '60000');
124INSERT INTO `cms_rarevalues` VALUES ('69', 'Yellow Barrier', 'http://microhotel.co.uk/images/rares/barrier_yellow.gif', '10000');
125INSERT INTO `cms_rarevalues` VALUES ('70', 'Yellow Fan', 'http://microhotel.co.uk/images/rares/fan_yellow.gif', '50000');
126INSERT INTO `cms_rarevalues` VALUES ('71', 'Yellow Marquee', 'http://microhotel.co.uk/images/rares/marquee_yellow.gif', '55000');
127INSERT INTO `cms_rarevalues` VALUES ('72', 'Yellow Monolith', 'http://microhotel.co.uk/images/rares/mono_yellow.gif', '45000');
128INSERT INTO `cms_rarevalues` VALUES ('73', 'Yellow Parasol', 'http://microhotel.co.uk/images/rares/para_yellow.gif', '30000');
129INSERT INTO `cms_rarevalues` VALUES ('74', 'Black Laser', 'http://microhotel.co.uk/images/rares/laser_black.gif', '60000');
130INSERT INTO `cms_rarevalues` VALUES ('75', 'Blue Laser', 'http://microhotel.co.uk/images/rares/laser_blue.gif', '60000');
131INSERT INTO `cms_rarevalues` VALUES ('76', 'Green Laser', 'http://microhotel.co.uk/images/rares/laser_green.gif', '60000');
132INSERT INTO `cms_rarevalues` VALUES ('77', 'Pink Laser', 'http://microhotel.co.uk/images/rares/laser_pink.gif', '60000');
133INSERT INTO `cms_rarevalues` VALUES ('78', 'Purple Laser', 'http://microhotel.co.uk/images/rares/laser_purple.gif', '60000');
134INSERT INTO `cms_rarevalues` VALUES ('79', 'Red Laser', 'http://microhotel.co.uk/images/rares/laser_red.gif', '60000');
135INSERT INTO `cms_rarevalues` VALUES ('80', 'Violet Laser', 'http://microhotel.co.uk/images/rares/laser_violet.gif', '60000');
136INSERT INTO `cms_rarevalues` VALUES ('81', 'White Laser', 'http://microhotel.co.uk/images/rares/laser_white.gif', '60000');
137INSERT INTO `cms_rarevalues` VALUES ('82', 'Yellow Laser', 'http://microhotel.co.uk/images/rares/laser_yellow.gif', '60000');
138INSERT INTO `cms_rarevalues` VALUES ('83', 'Aqua Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_aqua.gif', '35000');
139INSERT INTO `cms_rarevalues` VALUES ('84', 'Black Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_black.gif', '35000');
140INSERT INTO `cms_rarevalues` VALUES ('85', 'Blue Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_blue.gif', '35000');
141INSERT INTO `cms_rarevalues` VALUES ('86', 'Lime Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_lime.gif', '35000');
142INSERT INTO `cms_rarevalues` VALUES ('87', 'Orange Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_orange.gif', '35000');
143INSERT INTO `cms_rarevalues` VALUES ('88', 'Pink Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_pink.gif', '35000');
144INSERT INTO `cms_rarevalues` VALUES ('89', 'Purple Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_purple.gif', '35000');
145INSERT INTO `cms_rarevalues` VALUES ('90', 'White Inflatable', 'http://microhotel.co.uk/images/rares/inflatable_white.gif', '35000');
146INSERT INTO `cms_rarevalues` VALUES ('91', 'Aqua Oneway', 'http://microhotel.co.uk/images/rares/oneway_aqua.gif', '40000');
147INSERT INTO `cms_rarevalues` VALUES ('92', 'Beige Oneway', 'http://microhotel.co.uk/images/rares/oneway_beige.gif', '40000');
148INSERT INTO `cms_rarevalues` VALUES ('93', 'Black Oneway', 'http://microhotel.co.uk/images/rares/oneway_black.gif', '40000');
149INSERT INTO `cms_rarevalues` VALUES ('94', 'Blue Oneway', 'http://microhotel.co.uk/images/rares/oneway_blue.gif', '40000');
150INSERT INTO `cms_rarevalues` VALUES ('95', 'Green Oneway', 'http://microhotel.co.uk/images/rares/oneway_green.gif', '40000');
151INSERT INTO `cms_rarevalues` VALUES ('96', 'Pink Oneway', 'http://microhotel.co.uk/images/rares/oneway_pink.gif', '40000');
152INSERT INTO `cms_rarevalues` VALUES ('97', 'Red Oneway', 'http://microhotel.co.uk/images/rares/oneway_red.gif', '40000');
153INSERT INTO `cms_rarevalues` VALUES ('98', 'White Oneway', 'http://microhotel.co.uk/images/rares/oneway_white.gif', '40000');
154INSERT INTO `cms_rarevalues` VALUES ('99', 'Yellow Oneway', 'http://microhotel.co.uk/images/rares/oneway_yellow.gif', '40000');
155INSERT INTO `cms_rarevalues` VALUES ('100', 'Blue Pillar', 'http://microhotel.co.uk/images/rares/pillar_blue.gif', '30000');
156INSERT INTO `cms_rarevalues` VALUES ('101', 'Brown Pillar', 'http://microhotel.co.uk/images/rares/pillar_brown.gif', '30000');
157INSERT INTO `cms_rarevalues` VALUES ('102', 'Dark Grey Pillar', 'http://microhotel.co.uk/images/rares/pillar_darkgrey.gif', '30000');
158INSERT INTO `cms_rarevalues` VALUES ('103', 'Gold Pillar', 'http://microhotel.co.uk/images/rares/pillar_gold.gif', '30000');
159INSERT INTO `cms_rarevalues` VALUES ('104', 'Green Pillar', 'http://microhotel.co.uk/images/rares/pillar_green.gif', '30000');
160INSERT INTO `cms_rarevalues` VALUES ('105', 'Grey Pillar', 'http://microhotel.co.uk/images/rares/pillar_grey.gif', '30000');
161INSERT INTO `cms_rarevalues` VALUES ('106', 'Olive Pillar', 'http://microhotel.co.uk/images/rares/pillar_olive.gif', '30000');
162INSERT INTO `cms_rarevalues` VALUES ('107', 'Pink Pillar', 'http://microhotel.co.uk/images/rares/pillar_pink.gif', '30000');
163INSERT INTO `cms_rarevalues` VALUES ('108', 'Terracotta Pillar', 'http://microhotel.co.uk/images/rares/pillar_terra.gif', '30000');
164INSERT INTO `cms_rarevalues` VALUES ('109', 'White Pillar', 'http://microhotel.co.uk/images/rares/pillar_white.gif', '30000');
165INSERT INTO `cms_rarevalues` VALUES ('110', 'Aqua Pillow', 'http://microhotel.co.uk/images/rares/pillow_aqua.gif', '55000');
166INSERT INTO `cms_rarevalues` VALUES ('111', 'Black Pillow', 'http://microhotel.co.uk/images/rares/pillow_black.gif', '55000');
167INSERT INTO `cms_rarevalues` VALUES ('112', 'Blue Pillow', 'http://microhotel.co.uk/images/rares/pillow_blue.gif', '55000');
168INSERT INTO `cms_rarevalues` VALUES ('113', 'Bronze Pillow', 'http://microhotel.co.uk/images/rares/pillow_bronze-small.png', '55000');
169INSERT INTO `cms_rarevalues` VALUES ('114', 'Gold Pillow', 'http://microhotel.co.uk/images/rares/pillow_gold.gif', '55000');
170INSERT INTO `cms_rarevalues` VALUES ('115', 'Green Pillow', 'http://microhotel.co.uk/images/rares/pillow_green.gif', '55000');
171INSERT INTO `cms_rarevalues` VALUES ('116', 'Navy Pillow', 'http://microhotel.co.uk/images/rares/pillow_navy.gif', '55000');
172INSERT INTO `cms_rarevalues` VALUES ('117', 'Pink Pillow', 'http://microhotel.co.uk/images/rares/pillow_pink.gif', '55000');
173INSERT INTO `cms_rarevalues` VALUES ('118', 'Purple Pillow', 'http://microhotel.co.uk/images/rares/pillow_purple.gif', '55000');
174INSERT INTO `cms_rarevalues` VALUES ('119', 'Red Pillow', 'http://microhotel.co.uk/images/rares/pillow_red.gif', '55000');
175INSERT INTO `cms_rarevalues` VALUES ('120', 'Silver Pillow', 'http://microhotel.co.uk/images/rares/pillow_silver.gif', '55000');
176INSERT INTO `cms_rarevalues` VALUES ('121', 'White Pillow', 'http://microhotel.co.uk/images/rares/pillow_white.gif', '55000');
177INSERT INTO `cms_rarevalues` VALUES ('122', 'Blue Slurpee', 'http://microhotel.co.uk/images/rares/slurpee_blue.gif', '40000');
178INSERT INTO `cms_rarevalues` VALUES ('123', 'Green Slurpee', 'http://microhotel.co.uk/images/rares/slurpee_green.gif', '40000');
179INSERT INTO `cms_rarevalues` VALUES ('124', 'Pink Slurpee', 'http://microhotel.co.uk/images/rares/slurpee_pink.gif', '40000');
180INSERT INTO `cms_rarevalues` VALUES ('125', 'Purple Slurpee', 'http://microhotel.co.uk/images/rares/slurpee_purple.gif', '40000');
181INSERT INTO `cms_rarevalues` VALUES ('126', 'Aqua Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_aqua.gif', '50000');
182INSERT INTO `cms_rarevalues` VALUES ('127', 'Black Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_black.gif', '50000');
183INSERT INTO `cms_rarevalues` VALUES ('128', 'Blue Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_blue.gif', '50000');
184INSERT INTO `cms_rarevalues` VALUES ('129', 'Green Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_green.gif', '50000');
185INSERT INTO `cms_rarevalues` VALUES ('130', 'Pink Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_pink.gif', '50000');
186INSERT INTO `cms_rarevalues` VALUES ('131', 'Purple Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_purple.gif', '50000');
187INSERT INTO `cms_rarevalues` VALUES ('132', 'Red Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_red.gif', '50000');
188INSERT INTO `cms_rarevalues` VALUES ('133', 'Violet Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_violet.gif', '50000');
189INSERT INTO `cms_rarevalues` VALUES ('134', 'White Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_white.gif', '50000');
190INSERT INTO `cms_rarevalues` VALUES ('135', 'Yellow Smoke Machine', 'http://microhotel.co.uk/images/rares/smoke_yellow.gif', '50000');
191INSERT INTO `cms_rarevalues` VALUES ('136', 'Aqua Screen', 'http://microhotel.co.uk/images/rares/screen_aqua.gif', '30000');
192INSERT INTO `cms_rarevalues` VALUES ('137', 'Blue Screen', 'http://microhotel.co.uk/images/rares/screen_blue.gif', '30000');
193INSERT INTO `cms_rarevalues` VALUES ('138', 'Green Screen', 'http://microhotel.co.uk/images/rares/screen_green.gif', '30000');
194INSERT INTO `cms_rarevalues` VALUES ('139', 'Grey Screen', 'http://microhotel.co.uk/images/rares/screen_grey.gif', '30000');
195INSERT INTO `cms_rarevalues` VALUES ('140', 'Navy Screen', 'http://microhotel.co.uk/images/rares/screen_navy.gif', '30000');
196INSERT INTO `cms_rarevalues` VALUES ('141', 'Pink Screen', 'http://microhotel.co.uk/images/rares/screen_pink.gif', '30000');
197INSERT INTO `cms_rarevalues` VALUES ('142', 'Purple Screen', 'http://microhotel.co.uk/images/rares/screen_purple.gif', '30000');
198INSERT INTO `cms_rarevalues` VALUES ('143', 'Red Screen', 'http://microhotel.co.uk/images/rares/screen_red.gif', '30000');
199INSERT INTO `cms_rarevalues` VALUES ('144', 'White Screen', 'http://microhotel.co.uk/images/rares/screen_white.gif', '30000');
200INSERT INTO `cms_rarevalues` VALUES ('145', 'Yellow Screen', 'http://microhotel.co.uk/images/rares/screen_yellow.gif', '30000');
201INSERT INTO `cms_rarevalues` VALUES ('146', 'Holo Duck', 'http://microhotel.co.uk/images/rares/holoduck.gif', '65000');
202INSERT INTO `cms_rarevalues` VALUES ('147', 'Holo Heart', 'http://microhotel.co.uk/images/rares/holoheart.gif', '65000');
203INSERT INTO `cms_rarevalues` VALUES ('148', 'Holo Dragon Egg', 'http://microhotel.co.uk/images/rares/holodino.png', '65000');
204INSERT INTO `cms_rarevalues` VALUES ('149', 'Holo Girl', 'http://microhotel.co.uk/images/rares/hologirl.gif', '65000');
205INSERT INTO `cms_rarevalues` VALUES ('151', 'HC Sofa', 'http://microhotel.co.uk/images/rares/hc_sofa.gif', '35000');
206INSERT INTO `cms_rarevalues` VALUES ('152', 'Tropical Beach Rug', 'http://microhotel.co.uk/images/rares/tropical_beach_rug.gif', '20000');
207INSERT INTO `cms_rarevalues` VALUES ('153', 'T-Rex', 'http://microhotel.co.uk/images/rares/t_rex.gif', '30000');
208INSERT INTO `cms_rarevalues` VALUES ('154', 'Throne Statue', 'http://microhotel.co.uk/images/rares/thronestatue.png', '20000');
209INSERT INTO `cms_rarevalues` VALUES ('155', 'Snow Rug', 'http://microhotel.co.uk/images/rares/snow_rug.gif', '20000');
210INSERT INTO `cms_rarevalues` VALUES ('156', 'Silver Samovar', 'http://microhotel.co.uk/images/rares/silversamovar.png', '15000');
211INSERT INTO `cms_rarevalues` VALUES ('157', 'Samovar', 'http://microhotel.co.uk/images/rares/samovar.gif', '20000');
212INSERT INTO `cms_rarevalues` VALUES ('158', 'Rainbow Egg', 'http://microhotel.co.uk/images/rares/rainbowegg.png', '40000');
213INSERT INTO `cms_rarevalues` VALUES ('160', 'Black Dino', 'http://microhotel.co.uk/images/rares/black_dino.gif', '45000');
214INSERT INTO `cms_rarevalues` VALUES ('161', 'Orange Arcade', 'http://microhotel.co.uk/images/rares/arcade_orange.gif', '35000');
215INSERT INTO `cms_rarevalues` VALUES ('162', 'Red Arcade', 'http://microhotel.co.uk/images/rares/arcade_red.gif', '35000');
216INSERT INTO `cms_rarevalues` VALUES ('163', 'Aloe', 'http://microhotel.co.uk/images/rares/aloe.gif', '15000');
217INSERT INTO `cms_rarevalues` VALUES ('164', 'Golden Tablet', 'http://microhotel.co.uk/images/rares/ads_goldtabl.png', '65000');
218INSERT INTO `cms_rarevalues` VALUES ('165', 'Lollipop', 'http://microhotel.co.uk/images/rares/Ads_chups.gif', '30000');
219INSERT INTO `cms_rarevalues` VALUES ('166', 'Cheeto', 'http://microhotel.co.uk/images/rares/ads_cheetos.png', '20000');
220INSERT INTO `cms_rarevalues` VALUES ('167', 'Moon Rug', 'http://microhotel.co.uk/images/rares/moon_patch.gif', '25000');
221
222-- ----------------------------
223-- Table structure for cms_requests
224-- ----------------------------
225DROP TABLE IF EXISTS `cms_requests`;
226CREATE TABLE `cms_requests` (
227  `id` int(11) NOT NULL AUTO_INCREMENT,
228  `username` varchar(255) DEFAULT NULL,
229  `request` varchar(255) DEFAULT NULL,
230  PRIMARY KEY (`id`)
231) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
232
233
234-- ----------------------------
235-- Table structure for cms_suggestions
236-- ----------------------------
237DROP TABLE IF EXISTS `cms_suggestions`;
238CREATE TABLE `cms_suggestions` (
239  `id` int(11) NOT NULL AUTO_INCREMENT,
240  `username` varchar(255) DEFAULT NULL,
241  `save` int(11) DEFAULT NULL,
242  `suggestion` varchar(255) DEFAULT NULL,
243  `why` varchar(255) DEFAULT NULL,
244  `response` varchar(1000) DEFAULT NULL,
245  PRIMARY KEY (`id`)
246) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
247
248-- ----------------------------
249-- Table structure for housekeeping_perms
250-- ----------------------------
251DROP TABLE IF EXISTS `housekeeping_perms`;
252CREATE TABLE `housekeeping_perms` (
253  `id` int(11) NOT NULL AUTO_INCREMENT,
254  `perm` varchar(255) DEFAULT NULL,
255  `rank` varchar(255) DEFAULT NULL,
256  PRIMARY KEY (`id`)
257) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
258
259-- ----------------------------
260-- Records of housekeeping_perms
261-- ----------------------------
262INSERT INTO `housekeeping_perms` VALUES ('1', 'perm_filter', '7');
263INSERT INTO `housekeeping_perms` VALUES ('2', 'perm_stafflist', '2');
264INSERT INTO `housekeeping_perms` VALUES ('3', 'perm_values', '7');
265INSERT INTO `housekeeping_perms` VALUES ('4', 'perm_eventha', '2');
266INSERT INTO `housekeeping_perms` VALUES ('5', 'perm_trialapps', '5');
267INSERT INTO `housekeeping_perms` VALUES ('6', 'perm_edituser', '5');
268INSERT INTO `housekeeping_perms` VALUES ('7', 'perm_givevip', '5');
269INSERT INTO `housekeeping_perms` VALUES ('8', 'perm_changepw', '5');
270INSERT INTO `housekeeping_perms` VALUES ('9', 'perm_addnews', '5');
271INSERT INTO `housekeeping_perms` VALUES ('10', 'perm_editnews', '5');
272INSERT INTO `housekeeping_perms` VALUES ('11', 'perm_bans', '5');
273INSERT INTO `housekeeping_perms` VALUES ('12', 'perm_comments', '5');
274INSERT INTO `housekeeping_perms` VALUES ('13', 'perm_badges', '6');
275
276-- ----------------------------
277-- Table structure for site_news_comments
278-- ----------------------------
279DROP TABLE IF EXISTS `site_news_comments`;
280CREATE TABLE `site_news_comments` (
281  `id` int(11) NOT NULL AUTO_INCREMENT,
282  `article` varchar(255) DEFAULT NULL,
283  `userid` int(11) DEFAULT NULL,
284  `comment` varchar(255) DEFAULT NULL,
285  `posted_on` varchar(255) DEFAULT NULL,
286  `deleted` int(11) DEFAULT NULL,
287  PRIMARY KEY (`id`)
288) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
289
290
291-- ----------------------------
292-- Table structure for tmod
293-- ----------------------------
294DROP TABLE IF EXISTS `tmod`;
295CREATE TABLE `tmod` (
296  `AppID` int(11) NOT NULL AUTO_INCREMENT,
297  `different` varchar(6000) DEFAULT NULL,
298  `username` varchar(255) DEFAULT NULL,
299  `realname` varchar(255) DEFAULT NULL,
300  `age` int(11) DEFAULT NULL,
301  `why` varchar(6000) DEFAULT NULL,
302  `additional` varchar(6000) DEFAULT NULL,
303  `agree` varchar(1) DEFAULT NULL,
304  `denied` varchar(255) DEFAULT 'Not Read Yet',
305  `reply` varchar(1000) DEFAULT NULL,
306  `save` varchar(255) DEFAULT NULL,
307  PRIMARY KEY (`AppID`)
308) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
309
310ALTER TABLE `users` ADD `color` VARCHAR(255);
311ALTER TABLE `users` ADD `housekeeping_pin` INT(11);
312ALTER TABLE `users` ADD `skype` VARCHAR(255);
313ALTER TABLE `users` ADD `kik` VARCHAR(255);
314ALTER TABLE `users` ADD `hidden_staff` INT(11);
315ALTER TABLE `users` ADD `cms_comment_banned` INT(11);
316ALTER TABLE `users` ADD `refered_by` VARCHAR(255);