bj84t9KT

1CREATE TABLE IF NOT EXISTS `doctor` (
2  `id` bigint(20) NOT NULL AUTO_INCREMENT,
3  `dr_name` varchar(65) NOT NULL,
4  `dr_name_e` varchar(65) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
5  `unique_name` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
6  `pass` char(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
7  `nickname` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
8  `specialization` int(11) NOT NULL,
9  `state` tinyint(4) NOT NULL,
10  `scientific_degree` int(11) DEFAULT NULL,
11  `university` int(11) DEFAULT NULL,
12  `grad_year` smallint(6) DEFAULT NULL,
13  `show_degree` tinyint(1) DEFAULT NULL,
14  `show_univ` tinyint(1) DEFAULT NULL,
15  `show_grad_year` tinyint(1) DEFAULT NULL,
16  `appendices` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
17  `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
18  `active` tinyint(1) NOT NULL DEFAULT '0',
19  `views` bigint(20) DEFAULT '0',
20  `search_result` bigint(20) DEFAULT '0',
21  `gender_male` tinyint(1) DEFAULT NULL,
22  `agent` int(11) DEFAULT NULL,
23  `next_step` tinyint(4) DEFAULT NULL,
24  PRIMARY KEY (`id`),
25  UNIQUE KEY `unique_name` (`unique_name`),
26  KEY `university` (`university`),
27  KEY `scientific_degree` (`scientific_degree`),
28  KEY `specialization` (`specialization`),
29  KEY `agent` (`agent`)
30) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;