CREATE TABLE IF NOT EXISTS `album` (
`haberid` int(11) NOT NULL auto_increment,
`baslik` text character set utf8 NOT NULL,
`yazan` text character set utf8 NOT NULL,
`saat` text character set utf8 NOT NULL,
`ayrinti` text character set utf8 NOT NULL,
`hit` int(11) NOT NULL,
`tarih` varchar(100) character set utf8 NOT NULL,
`resim1` text character set utf8 NOT NULL,
`etiketler` text character set utf8 NOT NULL,
`seo` varchar(200) character set utf8 NOT NULL,
`ozet` varchar(255) character set utf8 NOT NULL,
`durum` int(11) default '0',
`dil` int(11) NOT NULL,
PRIMARY KEY  (`haberid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=43 ;