CREATE TABLE IF NOT EXISTS `users` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) DEFAULT ' ',
  `password` varchar(40) DEFAULT ' ',
  `auth_ticket` varchar(250) DEFAULT ' ',
  `realname` varchar(40) DEFAULT ' ',
  `email` varchar(100) DEFAULT ' ',
  `online` int(1) NOT NULL DEFAULT '0',
  `rank` int(1) NOT NULL DEFAULT '0',
  `look` varchar(250) DEFAULT ' ',
  `sex` int(1) NOT NULL DEFAULT '1',
  `mission` varchar(60) DEFAULT 'I am Newbie',
  `credits` int(10) NOT NULL DEFAULT '1000',
  `pixels` int(10) NOT NULL DEFAULT '100',
  `shells` int(10) NOT NULL DEFAULT '10',
  `lastvisit` varchar(20) DEFAULT ' ',
  `respects` int(2) NOT NULL DEFAULT '0',
  `subscription_type` int(1) NOT NULL DEFAULT '0',
  `subscription_timestamp` int(9) NOT NULL DEFAULT '0',
  `have_normal_respects` int(1) NOT NULL DEFAULT '3',
  `have_pet_respects` int(1) NOT NULL DEFAULT '3',
  `friends` varchar(1000) DEFAULT ' ',
  `friendcategories` varchar(500) DEFAULT ' ',
  `friendrequests` varchar(500) DEFAULT ' ',
  `home_room` int(6) NOT NULL DEFAULT '0',
  `ownrooms` varchar(500) DEFAULT ' ',
  `salas_favoritas` varchar(500) DEFAULT ' ',
  `badges` varchar(1000) DEFAULT ' ',
  `totallength_hc` int(4) NOT NULL DEFAULT '0',
  `totallength_vip` int(4) NOT NULL DEFAULT '0',
  `access_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`),
  KEY `auth_ticket` (`auth_ticket`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;