text: 
  -- Table structure for table `ci_sessions`
  CREATE TABLE IF NOT EXISTS `ci_sessions` (
    `id` varchar(40) COLLATE utf8_swedish_ci NOT NULL,
    `ip_address` varchar(45) COLLATE utf8_swedish_ci NOT NULL,
    `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
    `data` blob NOT NULL,
    PRIMARY KEY (`id`),
    KEY `ci_sessions_timestamp` (`timestamp`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci;
  
  -- Table structure for table `login_attempts`
  CREATE TABLE IF NOT EXISTS `login_attempts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `ip_address` varchar(40) COLLATE utf8_bin NOT NULL,
    `login` varchar(50) COLLATE utf8_bin NOT NULL,
    `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- Table structure for table `user_autologin`
  CREATE TABLE IF NOT EXISTS `user_autologin` (
    `key_id` char(32) COLLATE utf8_bin NOT NULL,
    `user_id` int(11) NOT NULL DEFAULT '0',
    `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
    `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
    `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`key_id`,`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- Table structure for table `user_profiles`
  CREATE TABLE IF NOT EXISTS `user_profiles` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `country` varchar(20) COLLATE utf8_bin DEFAULT NULL,
    `website` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  -- Table structure for table `users`
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(50) COLLATE utf8_bin NOT NULL,
    `password` varchar(255) COLLATE utf8_bin NOT NULL,
    `email` varchar(100) COLLATE utf8_bin NOT NULL,
    `activated` tinyint(1) NOT NULL DEFAULT '1',
    `banned` tinyint(1) NOT NULL DEFAULT '0',
    `ban_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL,
    `new_password_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
    `new_password_requested` datetime DEFAULT NULL,
    `new_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
    `new_email_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
    `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
    `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  
  
  