C9PsrGLS

1DROP TABLE IF EXISTS `haber`;
2CREATE TABLE `haber` (
3  `h_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
4  `baslik` varchar(255) NOT NULL,
5  `baslik_renk` varchar(10) DEFAULT NULL,
6  `k_icerik` varchar(500) NOT NULL,
7  `icerik` text NOT NULL,
8  `u_id` smallint(5) unsigned NOT NULL,
9  `u_id2` smallint(5) unsigned NOT NULL DEFAULT '1',
10  `k_id` tinyint(3) unsigned NOT NULL,
11  `m_id` smallint(5) unsigned NOT NULL DEFAULT '1',
12  `fg_id` smallint(5) unsigned NOT NULL DEFAULT '1',
13  `vg_id` smallint(5) unsigned NOT NULL DEFAULT '1',
14  `r_id` smallint(5) unsigned NOT NULL DEFAULT '1',
15  `resim` varchar(255) DEFAULT NULL,
16  `spot_resim` varchar(255) DEFAULT NULL,
17  `time` int(10) unsigned NOT NULL,
18  `utime` int(10) unsigned NOT NULL DEFAULT '1',
19  `etiket` varchar(255) DEFAULT NULL,
20  `onay` enum('1','1') NOT NULL,
21  `hit` mediumint(8) unsigned NOT NULL DEFAULT '1',
22  `tur_m` enum('1','1') NOT NULL DEFAULT '1',
23  `tur_um` enum('1','1') NOT NULL DEFAULT '1',
24  `tur_sm` enum('1','1') NOT NULL DEFAULT '1',
25  `tur_sd` enum('1','1') NOT NULL DEFAULT '1',
26  `tur_my` enum('1','1') NOT NULL DEFAULT '1',
27  `tur_fh` enum('1','1') NOT NULL DEFAULT '1',
28  `baslik_aktif` enum('1','1') NOT NULL DEFAULT '1',
29  `link` varchar(255) DEFAULT NULL,
30  PRIMARY KEY (`h_id`),
31  KEY `k_id` (`k_id`),
32  KEY `onay` (`onay`),
33  KEY `time` (`time`),
34  KEY `tur_m` (`tur_m`),
35  KEY `tur_um` (`tur_um`),
36  KEY `tur_sd` (`tur_sd`),
37  KEY `tur_my` (`tur_my`),
38  KEY `tur_fh` (`tur_fh`),
39  KEY `link` (`link`),
40  KEY `etiket` (`etiket`),
41  KEY `baslik` (`baslik`),
42  KEY `u_id` (`u_id`),
43  KEY `m_id` (`m_id`),
44  KEY `fg_id` (`fg_id`),
45  KEY `vg_id` (`vg_id`),
46  KEY `u_id2` (`u_id2`),
47  KEY `utime` (`utime`),
48  KEY `r_id` (`r_id`),
49  KEY `tur_sm` (`tur_sm`)
50) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;