DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_code` varchar(32) NOT NULL DEFAULT '',
  `user_ins_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_session_code` varchar(32) NOT NULL DEFAULT '',
  `user_account_on` enum('1','0') NOT NULL DEFAULT '1',
  `user_login` varchar(50) NOT NULL DEFAULT '',
  `user_password` varchar(32) NOT NULL DEFAULT '',
  `user_name` varchar(250) NOT NULL DEFAULT '',
  `user_mail` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(250) NOT NULL DEFAULT '',
  `user_access_backoffice` enum('0','1') NOT NULL DEFAULT '0',
  `user_allow_multiple` enum('0','1') NOT NULL DEFAULT '0',
  `user_save_auth` enum('0','1') NOT NULL DEFAULT '0',
  `user_allow_edit_settings` enum('0','1') NOT NULL DEFAULT '0',
  `user_last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_default_admin_page` varchar(100) DEFAULT NULL,
  `user_default_editor` enum('default','visual','simple') NOT NULL DEFAULT 'default',
  `user_allow_change_editor` enum('1','0') NOT NULL DEFAULT '1',
  `user_visual_editor_panels` varchar(255) DEFAULT NULL,
  `user_simple_editor_panels` varchar(255) DEFAULT NULL,
  `user_show_material_thumbs` enum('1','0') NOT NULL DEFAULT '1',
  `user_show_rubric_thumbs` enum('0','1') NOT NULL DEFAULT '0',
  `user_show_ins_info` enum('1','0') NOT NULL DEFAULT '1',
  `id_city` int(11) NOT NULL DEFAULT '0',
  `user_confirmed` enum('0','1') NOT NULL DEFAULT '1',
  `user_changecode_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_code` (`user_code`),
  UNIQUE KEY `user_session_code` (`user_session_code`),
  UNIQUE KEY `auser_login_2` (`user_login`,`user_password`),
  KEY `user_ins_date` (`user_ins_date`),
  KEY `id_city` (`id_city`),
  KEY `user_confirmed` (`user_confirmed`),
  KEY `user_changecode_date` (`user_changecode_date`)
) TYPE=MyISAM AUTO_INCREMENT=79;