CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(125) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
  `auth_ticket` varchar(60) DEFAULT NULL,
  `rank` int(1) unsigned DEFAULT '1',
  `rank_vip` int(1) DEFAULT '0',
  `credits` int(11) DEFAULT '50000',
  `vip_points` int(11) DEFAULT '0',
  `activity_points` int(11) DEFAULT '5000',
  `look` char(255) DEFAULT NULL,
  `gender` enum('M','F') DEFAULT 'M',
  `motto` char(50) DEFAULT NULL,
  `account_created` float DEFAULT '0',
  `last_online` int(11) DEFAULT '0',
  `online` enum('0','1') DEFAULT '0',
  `ip_last` varchar(45) DEFAULT '',
  `ip_reg` varchar(45) DEFAULT NULL,
  `home_room` int(10) DEFAULT '7',
  `is_muted` enum('0','1') DEFAULT '0',
  `block_newfriends` enum('0','1') DEFAULT '0',
  `hide_online` enum('0','1') DEFAULT '0',
  `hide_inroom` enum('0','1') DEFAULT '0',
  `vip` enum('0','1') DEFAULT '0',
  `volume` varchar(15) DEFAULT '100,100,100',
  `last_change` int(20) DEFAULT '0',
  `machine_id` varchar(125) DEFAULT '',
  `focus_preference` enum('0','1') DEFAULT '0',
  `chat_preference` enum('0','1') DEFAULT '0',
  `pets_muted` enum('0','1') DEFAULT '0',
  `bots_muted` enum('0','1') DEFAULT '0',
  `advertising_report_blocked` enum('0','1') DEFAULT '0',
  `gotw_points` int(11) DEFAULT '0',
  `ignore_invites` enum('0','1') DEFAULT '0',
  `time_muted` double DEFAULT '0',
  `allow_gifts` enum('0','1') DEFAULT '1',
  `trading_locked` double DEFAULT '0',
  `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
  `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
  `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
  `rangovandeweek` enum('1','0') CHARACTER SET utf8 DEFAULT '0',
  `staff_sinds` text,
  `rank_lijst` text CHARACTER SET utf8,
  `bcrypt_on` enum('1','0') CHARACTER SET utf8 DEFAULT '1',
  `rank_name` text CHARACTER SET utf8,
  `team` int(10) DEFAULT NULL,
  `staff_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `rankup` mediumtext CHARACTER SET utf8,
  `non_confirmed` int(11) NOT NULL,
  `donation` int(11) NOT NULL DEFAULT '0',
  `snow` int(11) NOT NULL DEFAULT '1',
  `pin` varchar(6) NOT NULL DEFAULT '123124',
  `dj` int(11) DEFAULT '0',
  PRIMARY KEY (`id`,`pin`),
  UNIQUE KEY `id` (`id`) USING HASH,
  UNIQUE KEY `username` (`username`) USING BTREE,
  KEY `rank` (`rank`),
  KEY `ip_last` (`ip_last`),
  KEY `ip_reg` (`ip_reg`),
  KEY `credits` (`credits`),
  KEY `activity_points` (`activity_points`),
  KEY `online` (`online`),
  KEY `mail` (`mail`),
  KEY `machine_id` (`machine_id`),
  KEY `auth_ticket` (`auth_ticket`),
  KEY `last_online` (`last_online`),
  KEY `home_room` (`home_room`),
  KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=76268 DEFAULT CHARSET=latin1;