uDHm1sjc

1SQL´S:
2ALTER TABLE users ADD staff_twitter varchar(50);
3ALTER TABLE users ADD staff_facebook varchar(50);
4ALTER TABLE users ADD forgot_ticket varchar(50);
5ALTER TABLE users ADD facebook_id varchar(50);
6ALTER TABLE users ADD pin varchar(50);
7ALTER TABLE users ADD facebook_change varchar(50) DEFAULT '0';
8ALTER TABLE users ADD facebook varchar(50);
9ALTER TABLE users ADD staff_background_url text(500);
10ALTER TABLE users ADD staff_ocult varchar(50) DEFAULT '0';
11ALTER TABLE users ADD role varchar(50);
12ALTER TABLE users ADD country_cf varchar(50) DEFAULT 'ec';
13ALTER TABLE users ADD last_used varchar(50) DEFAULT '0';
14ALTER TABLE users ADD refer_count varchar(50) DEFAULT '0';
15ALTER TABLE users ADD staff_profileimage_url varchar(150) DEFAULT '0';
16ALTER TABLE users ADD block_newfriends varchar(40) DEFAULT '0';
17ALTER TABLE users ADD hide_online varchar(40) DEFAULT '0';
18ALTER TABLE users ADD diamonds int(11) DEFAULT '0';
19ALTER TABLE users ADD last_online varchar(50) DEFAULT '0';
20
21DROP TABLE IF EXISTS `cms_subscriptions`;
22CREATE TABLE `cms_subscriptions` (
23  `user_id` int(10) unsigned NOT NULL,
24  `subscription_id` varchar(50) NOT NULL,
25  `timestamp_activated` int(11) NOT NULL,
26  `timestamp_expire` int(11) NOT NULL,
27  KEY `user_id` (`user_id`),
28  KEY `subscription_id` (`subscription_id`)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
30
31CREATE TABLE IF NOT EXISTS `stafflogs` (
32`id` int(11) NOT NULL,
33  `username` varchar(40) NOT NULL,
34  `message` varchar(40) NOT NULL,
35  `note` varchar(40) NOT NULL,
36  `action` text,
37  `userid` text,
38  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
39  `targetid` varchar(10) NOT NULL DEFAULT '0'
40) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7145 ;
41
42
43DROP TABLE IF EXISTS `cms_badges`;
44CREATE TABLE `cms_badges` (
45  `id` int(11) NOT NULL AUTO_INCREMENT,
46  `code` varchar(40) DEFAULT '0',
47  `price` varchar(40) DEFAULT '0',
48  PRIMARY KEY (`id`)
49) ENGINE=MyISAM AUTO_INCREMENT=7145 DEFAULT CHARSET=latin1;
50
51#
52# Data for table "cms_badges"
53#
54
55/*!40000 ALTER TABLE `cms_badges` DISABLE KEYS */;
56INSERT INTO `cms_badges` VALUES (1,'AXE','10'),(2,'DK3','10'),(3,'DK4','10'),(4,'DK5','10'),(5,'DK6','10'),(6,'DK7','10'),(7,'DK2','10'),(8,'DK1','10');
57/*!40000 ALTER TABLE `cms_badges` ENABLE KEYS */;
58
59DROP TABLE IF EXISTS `cms_news_new`;
60CREATE TABLE `cms_news_new` (
61  `id` int(11) NOT NULL AUTO_INCREMENT,
62  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
63  `shortstory` text COLLATE latin1_general_ci,
64  `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
65  `story` longtext CHARACTER SET latin1 COLLATE latin1_spanish_ci,
66  `author` text COLLATE latin1_general_ci,
67  `time` double NOT NULL,
68  `campaign` int(1) NOT NULL DEFAULT '0',
69  `campaignimg` varchar(500) COLLATE latin1_general_ci NOT NULL DEFAULT 'http://i.imgur.com/cGV4kO7.gif',
70  PRIMARY KEY (`id`)
71) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
72
73#
74# Data for table "cms_news_new"
75#
76
77/*!40000 ALTER TABLE `cms_news_new` DISABLE KEYS */;
78INSERT INTO `cms_news_new` VALUES (2,'Te damos la bienvenida a esta gran comunidad.','Te damos la bienvenida a esta gran comunidad.','http://habboo-a.akamaihd.net/c_images/web_promo/wintersport_topstory.gif','Te damos la bienvenida a esta gran comunidad.','yop',1,0,'http://habboo-a.akamaihd.net/c_images/web_promo/wintersport_topstory.gif'),(3,'la bida bale berga','nose :/((((','/Public/Images/news/TS_Web60.png',':((((',NULL,1,0,'http://habboo-a.akamaihd.net/c_images/web_promo/searoombundle_l_promo.png'),(63,'asfas','asfasf','/Public/Images/news/TS_Web60.png','<p>asfasf</p>',NULL,0,0,'asfasfas');
79/*!40000 ALTER TABLE `cms_news_new` ENABLE KEYS */;