Nui7NEqz

1DROP TABLE IF EXISTS `user`;
2CREATE TABLE `user` (
3  `user_id` int(11) NOT NULL AUTO_INCREMENT,
4  `user_code` varchar(32) NOT NULL DEFAULT '',
5  `user_ins_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
6  `user_session_code` varchar(32) NOT NULL DEFAULT '',
7  `user_account_on` enum('1','0') NOT NULL DEFAULT '1',
8  `user_login` varchar(50) NOT NULL DEFAULT '',
9  `user_password` varchar(32) NOT NULL DEFAULT '',
10  `user_name` varchar(250) NOT NULL DEFAULT '',
11  `user_mail` varchar(100) NOT NULL DEFAULT '',
12  `user_url` varchar(250) NOT NULL DEFAULT '',
13  `user_access_backoffice` enum('0','1') NOT NULL DEFAULT '0',
14  `user_allow_multiple` enum('0','1') NOT NULL DEFAULT '0',
15  `user_save_auth` enum('0','1') NOT NULL DEFAULT '0',
16  `user_allow_edit_settings` enum('0','1') NOT NULL DEFAULT '0',
17  `user_last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
18  `user_default_admin_page` varchar(100) DEFAULT NULL,
19  `user_default_editor` enum('default','visual','simple') NOT NULL DEFAULT 'default',
20  `user_allow_change_editor` enum('1','0') NOT NULL DEFAULT '1',
21  `user_visual_editor_panels` varchar(255) DEFAULT NULL,
22  `user_simple_editor_panels` varchar(255) DEFAULT NULL,
23  `user_show_material_thumbs` enum('1','0') NOT NULL DEFAULT '1',
24  `user_show_rubric_thumbs` enum('0','1') NOT NULL DEFAULT '0',
25  `user_show_ins_info` enum('1','0') NOT NULL DEFAULT '1',
26  `id_city` int(11) NOT NULL DEFAULT '0',
27  `user_confirmed` enum('0','1') NOT NULL DEFAULT '1',
28  `user_changecode_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
29  PRIMARY KEY (`user_id`),
30  UNIQUE KEY `user_code` (`user_code`),
31  UNIQUE KEY `user_session_code` (`user_session_code`),
32  UNIQUE KEY `auser_login_2` (`user_login`,`user_password`),
33  KEY `user_ins_date` (`user_ins_date`),
34  KEY `id_city` (`id_city`),
35  KEY `user_confirmed` (`user_confirmed`),
36  KEY `user_changecode_date` (`user_changecode_date`)
37) TYPE=MyISAM AUTO_INCREMENT=79;