CREATE TABLE IF NOT EXISTS `users_table` (
`userid` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
XX `password` varchar(60) NOT NULL,
XX `email` varchar(100) NOT NULL,
`user_level` tinyint(11) NOT NULL DEFAULT '1',
`plays` int(11) NOT NULL DEFAULT '0',
XX `newsletter` tinyint(1) NOT NULL DEFAULT '0',
`aim` varchar(150) NOT NULL,
`icq` varchar(150) NOT NULL,
`msn` varchar(150) NOT NULL,
`yim` varchar(150) NOT NULL,
`location` varchar(150) NOT NULL,
`occupation` varchar(50) NOT NULL,
`website` varchar(150) NOT NULL,
`link_a` varchar(150) NOT NULL,
`link_b` varchar(150) NOT NULL,
`link_c` varchar(150) NOT NULL,
`link_d` varchar(150) NOT NULL,
`link_e` varchar(150) NOT NULL,
`link_f` varchar(150) NOT NULL,
`link_g` varchar(150) NOT NULL,
`link_h` varchar(150) NOT NULL,
`sex` tinyint(1) NOT NULL DEFAULT '0',
`interests` varchar(255) NOT NULL,
`bio` text NOT NULL,
`ip` varchar(50) NOT NULL,
`blog_level` tinyint(1) NOT NULL DEFAULT '1',
`game_level` tinyint(1) NOT NULL DEFAULT '1',
`avatar` tinyint(1) NOT NULL DEFAULT '0',
`avatar_file` varchar(50) NOT NULL,
XX `activation_key` varchar(50) NOT NULL,
`status` varchar(50) NOT NULL,
XX `pass_answer` varchar(255) NOT NULL,
XX `pass_question` varchar(255) NOT NULL,
XX `new_email` varchar(255) NOT NULL,
XX `new_email_key` varchar(255) NOT NULL,
`date_joined` varchar(50) NOT NULL DEFAULT '',
`user_style` varchar(60) DEFAULT 'default',
`user_lang` varchar(50) DEFAULT NULL,
`user_session_time` int(11) NOT NULL DEFAULT '1355396812',
`user_flag` varchar(50) DEFAULT NULL,
XX `xmas_snow` int(15) NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;