-- ----------------------------
--   Run this for LeeTWEB!  ---
-- ----------------------------

DROP TABLE IF EXISTS `leet_client`;
CREATE TABLE `leet_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,
  `error_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 leet_client
-- ----------------------------
INSERT INTO `leet_client` VALUES ('1', 'YOURIP', '30001', '30002', 'http://leethost.nl/r63/external_variables.txt', 'http://leethost.nl/r63/external_flash_texts.txt', 'http://leethost.nl/r63/Habbo.swf', 'http://www.leethotel.com/', 'http://leethost.nl/r63/', 'Merijn sucks...');

CREATE TABLE IF NOT EXISTS `leet_stafflog` (
  `id` int(6) NOT NULL auto_increment,
  `name` 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;


DROP TABLE IF EXISTS `leet_news`;
CREATE TABLE `leet_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `topstory_image` text NOT NULL,
  `body` text NOT NULL,
  `snippet` text NOT NULL,
  `auteur` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `leet_codes`;
CREATE TABLE `leet_codes` (
  `code` varchar(24) NOT NULL,
  `datumtijd` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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;