[CMS] Conect Cms 1.0

ALTER table users ADD staff_twitter varchar(50);

ALTER table users ADD staff_facebook varchar(50);

ALTER table users ADD forgot_ticket varchar(50);

ALTER table users ADD facebook_id varchar(50);

ALTER table users ADD pin varchar(50);

ALTER table users ADD facebook_change varchar(50);

ALTER table users ADD facebook varchar(50);

ALTER table users ADD staff_background_url text(500);

ALTER table users ADD staff_ocult varchar(50) DEFAULT '0';

ALTER table users ADD role varchar(50);

ALTER table users ADD country_cf varchar(50) DEFAULT 'ec';

ALTER table users ADD last_used varchar(50) DEFAULT '0';

ALTER table users ADD refer_count varchar(50) DEFAULT '0';

ALTER table users ADD staff_profileimage_url varchar(150) DEFAULT '0';

ALTER table users ADD block_newfriends varchar(40) DEFAULT '0';

ALTER table users ADD hide_online varchar(40) DEFAULT '0';

CREATE table IF NOT EXISTS `stafflogs` (

`id` int(11) NOT NULL,

  `sou bixa` varchar(40) NOT NULL,

  `message` varchar(40) NOT NULL,

  `note` varchar(40) NOT NULL,

  `action` text,

  `userid` text,

  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `targetid` varchar(10) NOT NULL DEFAULT '0'

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7145 ;

DROP table IF EXISTS `cms_news_new`;

CREATE table `cms_news_new` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,

  `shortstory` text COLLATE latin1_general_ci,

  `image` varchar(255) COLLATE latin1_general_ci DEFAULT '/Public/Images/news/TS_Web60.png',

  `story` longtext CHARACTER SET latin1 COLLATE latin1_spanish_ci,

  `author` text COLLATE latin1_general_ci,

  `time` double NOT NULL,

  `campaign` int(1) NOT NULL DEFAULT '0',

  `campaignimg` varchar(500) COLLATE latin1_general_ci NOT NULL DEFAULT 'http://i.imgur.com/cGV4kO7.gif',

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#

# Data for table "cms_news_new"

#

/*!40000 ALTER table `cms_news_new` DISABLE KEYS */;

INSERT 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');

/*!40000 ALTER table `cms_news_new` ENABLE KEYS */;