-- ----------------------------
-- Table structure for `cms_client`
-- ----------------------------
DROP TABLE IF EXISTS `cms_client`;
CREATE TABLE `cms_client` (
  `id` int(6) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL,
  `port` varchar(5) NOT NULL,
  `mus_port` varchar(5) NOT NULL,
  `variable` varchar(100) NOT NULL,
  `texte` varchar(100) NOT NULL,
  `swf` varchar(150) NOT NULL,
  `erreur_page` varchar(150) default NULL,
  `version` varchar(150) default NULL,
  `loading_texte` varchar(150) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cms_client
-- ----------------------------
INSERT INTO `cms_client` VALUES ('1', '127.0.0.1', '30000', '30001', 'http://94.23.55.122/r64/gamedata/variables.txt', 'http://94.23.55.122/r64/gamedata/text.txt', 'http://94.23.55.122/r64/gordon/RELEASE63-33289-33285-201104271219_05654491c96b6366cd213f5455b329c6/Habbo.swf', 'http://www.jabbo.eu/client_error.php', 'http://94.23.55.122/r64/gordon/RELEASE63-33289-33285-201104271219_05654491c96b6366cd213f5455b329c6/', 'Chargement en cours.');

DROP TABLE IF EXISTS `cms_une`;
CREATE TABLE `cms_une` (
  `id` int(6) NOT NULL auto_increment,
  `titre` varchar(50) NOT NULL,
  `desc` varchar(150) character set latin1 collate latin1_general_ci NOT NULL,
  `url` varchar(150) character set latin1 collate latin1_general_ci NOT NULL,
  `image` varchar(150) character set latin1 collate latin1_general_ci NOT NULL,
  `auteur` varchar(50) default NULL,
  `date` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `cms_vouchers`;
CREATE TABLE `cms_vouchers` (
  `id` int(6) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '0',
  `code` varchar(40) NOT NULL,
  `value` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `code` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `cms_jetons`;
CREATE TABLE `cms_jetons` (
  `id` int(6) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '0',
  `code` varchar(40) NOT NULL,
  `value` int(6) default NULL,
  PRIMARY KEY  (`id`),
  KEY `code` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `cms_stafflog` (
  `id` int(6) NOT NULL auto_increment,
  `pseudo` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
  `action` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
  `date` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `cms_help` (
  `id` int(6) NOT NULL auto_increment,
  `sujet` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
  `question` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
  `article` text character set latin1 collate latin1_general_ci NOT NULL,
  `auteur` varchar(50) character set latin1 collate latin1_general_ci NOT NULL,
  `date` varchar(20) character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE  `users` ADD  `disabled` INT( 6 ) NOT NULL DEFAULT  '0',
ADD  `last_offline` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
ADD  `spam` INT( 6 ) NOT NULL DEFAULT  '0',
ADD  `jetons` INT( 6 ) NOT NULL DEFAULT  '0';