w3ygnZDm

1
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);
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';
18
19CREATE table IF NOT EXISTS `stafflogs` (
20`id` int(11) NOT NULL,
21  `sou bixa` varchar(40) NOT NULL,
22  `message` varchar(40) NOT NULL,
23  `note` varchar(40) NOT NULL,
24  `action` text,
25  `userid` text,
26  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
27  `targetid` varchar(10) NOT NULL DEFAULT '0'
28) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7145 ;
29
30
31DROP table IF EXISTS `cms_news_new`;
32CREATE table `cms_news_new` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
35  `shortstory` text COLLATE latin1_general_ci,
36  `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',
37  `story` longtext CHARACTER SET latin1 COLLATE latin1_spanish_ci,
38  `author` text COLLATE latin1_general_ci,
39  `time` double NOT NULL,
40  `campaign` int(1) NOT NULL DEFAULT '0',
41  `campaignimg` varchar(500) COLLATE latin1_general_ci NOT NULL DEFAULT 'http://i.imgur.com/cGV4kO7.gif',
42  PRIMARY KEY (`id`)
43) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
44
45#
46# Data for table "cms_news_new"
47#
48
49/*!40000 ALTER table `cms_news_new` DISABLE KEYS */;
50INSERT 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','Sad(((',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');
51/*!40000 ALTER table `cms_news_new` ENABLE KEYS */;