6RvYNuxq

1DROP TABLE IF EXISTS `user_new`;
2CREATE TABLE IF NOT EXISTS `user_new` (
3  `id` int(11) NOT NULL,
4  `username` varchar(10) collate utf8_unicode_ci NOT NULL,
5  `firstName` varchar(30) collate utf8_unicode_ci NOT NULL,
6  `middleName` varchar(30) collate utf8_unicode_ci default NULL,
7  `sirName` varchar(30) collate utf8_unicode_ci NOT NULL,
8  `specialization` int(11) default NULL,
9  `graduationYear` year(4) default NULL,
10  `member` enum('true','false') collate utf8_unicode_ci NOT NULL,
11  `gender` enum('unknown','male','female') collate utf8_unicode_ci NOT NULL default 'unknown',
12  `imageId` int(11) NOT NULL,
13  `phoneNumber` int(11) default NULL,
14  `lastLogin` datetime default NULL,
15  `cardinfo` varchar(10) collate utf8_unicode_ci NOT NULL,
16  `description` varchar(500) collate utf8_unicode_ci NOT NULL,
17  `birthdate` date NOT NULL,
18  `altEmail` varchar(25) collate utf8_unicode_ci NOT NULL,
19  PRIMARY KEY  (`id`),
20  UNIQUE KEY `username` (`username`),
21  KEY `spesialization` (`specialization`,`access`),
22  KEY `access` (`access`)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;