-- 
-- Tablo yapısı : `haberler`
-- 

CREATE TABLE `haberler` (
  `id` bigint(20) NOT NULL auto_increment,
  `link` varchar(72) NOT NULL default '',
  `image1` bigint(20) NOT NULL default '0',
  `image2` bigint(20) NOT NULL default '0',
  `baslik` text NOT NULL,
  `spot` text NOT NULL,
  `yazi` text NOT NULL,
  `tarih` varchar(14) NOT NULL default '',
  `anasayfa` enum('Y','N') NOT NULL default 'Y',
  `bolum` tinyint(2) NOT NULL default '0',
  `haber` tinyint(1) NOT NULL default '0',
  `user` varchar(32) NOT NULL default '',
  `hit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- 
-- Tablo döküm verisi `haberler`
--

-- 
-- Tablo yapısı : `oykuler`
-- 

CREATE TABLE `oykuler` (
  `id` bigint(20) NOT NULL auto_increment,
  `link` varchar(72) NOT NULL default '',
  `image1` bigint(20) NOT NULL default '0',
  `image2` bigint(20) NOT NULL default '0',
  `image3` bigint(20) NOT NULL default '0',
  `image4` bigint(20) NOT NULL default '0',
  `image5` bigint(20) NOT NULL default '0',
  `image6` bigint(20) NOT NULL default '0',
  `baslik` text NOT NULL,
  `alani` text NOT NULL,
  `yayinevi` varchar(10) NOT NULL default '',
  `edturu` text NOT NULL,
  `tip` varchar(10) NOT NULL default '',
  `yazi` text NOT NULL,
  `adres` text NOT NULL,
  `akapak` text NOT NULL,
  `dili` text NOT NULL,
  `yazari` text NOT NULL,
  `ssayisi` bigint(4) NOT NULL default '0',
  `kturu` text NOT NULL,
  `agirlik` varchar(6) NOT NULL default '',
  `tell` varchar(6) NOT NULL default '',
  `gsm` varchar(6) NOT NULL default '',
  `email` varchar(25) NOT NULL default '0',
  `yili` varchar(10) NOT NULL default '',
  `fiyat` varchar(7) NOT NULL default '',
  `ytarih` varchar(14) NOT NULL default '',
  `yenilik` enum('Y','N') NOT NULL default 'N',
  `kbaski` enum('Y','N') NOT NULL default 'N',
  `badedi` enum('Y','N') NOT NULL default 'Y',
  `konu` enum('B','BL','M','H','E','EM','EB') NOT NULL default 'M',
  `anasayfa` enum('Y','N') NOT NULL default 'Y',
  `bolum` tinyint(2) NOT NULL default '0',
  `haber` tinyint(1) NOT NULL default '0',
  `user` varchar(32) NOT NULL default '',
  `hit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

-- 
-- Tablo döküm verisi `oykuler`
--