users

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(250) DEFAULT NULL,
  `home_room` int(10) unsigned NOT NULL DEFAULT '1694',
  `gotw_points_honor` int(11) DEFAULT '0',
  `facebook_id` varchar(100) NOT NULL DEFAULT '',
  `nux_room` enum('true','false') NOT NULL DEFAULT 'true',
  `mastertrade` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
  `gotw_points_calabazas` int(11) DEFAULT '0',
  `targeted_buy` int(10) NOT NULL,
  `namecolor` varchar(125) NOT NULL DEFAULT '000000',
  `bonus_points` int(11) DEFAULT '0',
  `nametag` varchar(125) NOT NULL,
  `cde` enum('0','1','2','3') NOT NULL DEFAULT '0',
  `gotw_points_huevo` int(11) DEFAULT '1',
  `tagcolor` varchar(255) DEFAULT NULL,
  `tag` varchar(255) DEFAULT NULL,
  `quiz_passed` enum('1','0') DEFAULT '1',
  `changename` enum('0','1') NOT NULL DEFAULT '1',
  `cms_colab` int(11) DEFAULT NULL,
  `pincode` varchar(255) NOT NULL,
  `pin_client` varchar(255) NOT NULL,
  `mysticdata` varchar(15) DEFAULT '100,100,100',
  `email_verificado` enum('0','1') NOT NULL DEFAULT '0',
  `cms_birthday` varchar(100) NOT NULL,
  `cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
  `cms_role` varchar(50) NOT NULL,
  `cms_rank` varchar(150) NOT NULL DEFAULT 'Usuario',
  `user_rank` int(11) NOT NULL DEFAULT '1',
  `cms_pin` enum('0','1','2') NOT NULL DEFAULT '0',
  `vip_time` int(11) NOT NULL,
  `vip_mes` int(11) NOT NULL,
  `cms_stories` int(50) NOT NULL DEFAULT '0',
  `code_forgot` varchar(50) NOT NULL,
  `cms_forgot_time` int(11) NOT NULL,
  `user_fondo` varchar(500) NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
  `user_referrals` varchar(100) NOT NULL DEFAULT '0',
  `user_new` enum('0','1') NOT NULL DEFAULT '0',
  `loto_clicks` int(2) NOT NULL DEFAULT '1',
  `respetos` int(5) NOT NULL DEFAULT '3',
  `public_stories` enum('0','1') NOT NULL DEFAULT '0',
  `swf_description` enum('0','1') NOT NULL DEFAULT '0',
  `time_pass` int(11) NOT NULL,
  `pin_act` enum('0','1') NOT NULL DEFAULT '0',
  `pin_intentos` int(5) NOT NULL DEFAULT '3',
  `pin_time` int(11) NOT NULL,
  `cuenta_suspendida` enum('0','1') NOT NULL DEFAULT '0',
  `premio` int(30) NOT NULL DEFAULT '0',
  `puntos_eventos` int(30) NOT NULL DEFAULT '0',
  `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
  `bubble_color` varchar(100) NOT NULL,
  `bubble_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`auth_ticket`,`pincode`,`pin_client`),
  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 `rank_vip` (`rank_vip`),
  KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;