CREATE TABLE IF NOT EXISTS `ayar` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SiteBaslik` varchar(70) NOT NULL,
  `SiteMeta` varchar(260) NOT NULL,
  `SiteDesc` varchar(160) NOT NULL,
  `SiteMail` varchar(155) NOT NULL,
  `Logo` varchar(255) NOT NULL,
  `SiteAdi` char(255) NOT NULL,
  `HaberlerAdet` char(6) NOT NULL,
  `ResimlerAdet` char(6) NOT NULL,
  `GalerilerAdet` varchar(255) NOT NULL,
  `UrunlerAdet` varchar(255) NOT NULL,
  `SlaytlarAdet` varchar(255) NOT NULL,
  `AnketlerAdet` varchar(255) NOT NULL,
  `VideoGaleri` varchar(255) NOT NULL,
  `MailServer` varchar(255) NOT NULL,
  `SMTPUsername` varchar(255) NOT NULL,
  `SMTPPassword` varchar(255) NOT NULL,
  `MailTip` varchar(255) NOT NULL,
  `Port` varchar(255) NOT NULL,
  `ResimYazi` varchar(255) NOT NULL,
  `SSL` int(1) NOT NULL,
  `FotoGaleri` int(1) NOT NULL,
  `HaberKucukResimW` varchar(255) NOT NULL,
  `HaberKucukResimH` varchar(255) NOT NULL,
  `HaberBuyukResimW` varchar(255) NOT NULL,
  `HaberBuyukResimH` varchar(255) NOT NULL,
  `HaberHit` int(1) NOT NULL,
  `GaleriKucukResimW` varchar(255) NOT NULL,
  `GaleriKucukResimH` varchar(255) NOT NULL,
  `GaleriBuyukResimW` varchar(255) NOT NULL,
  `GaleriBuyukResimH` varchar(255) NOT NULL,
  `SlaytBuyukResimW` varchar(255) NOT NULL,
  `SlaytBuyukResimH` varchar(255) NOT NULL,
  `UrunKucukResimW` varchar(255) NOT NULL,
  `UrunKucukResimH` varchar(255) NOT NULL,
  `UrunBuyukResimW` varchar(255) NOT NULL,
  `UrunBuyukResimH` varchar(255) NOT NULL,
  `KategoriBuyukResimH` varchar(255) NOT NULL,
  `KategoriBuyukResimW` varchar(255) NOT NULL,
  `UrunHit` int(1) NOT NULL,
  `SlaytModul` int(1) NOT NULL,
  `Screen` varchar(255) NOT NULL,
  `UrunMarkalar` int(1) NOT NULL,
  `AnaSayfaIcerik` int(11) NOT NULL,
  `FooterTip` int(1) NOT NULL,
  `SiteArkaPlanResmi` varchar(255) NOT NULL,
  `Renk` varchar(255) NOT NULL,
  `MenuRenk` varchar(255) NOT NULL,
  `AnaSayfaUrunler` int(1) NOT NULL,
  `AnaSayfaUrunlerK` int(1) NOT NULL,
  `AnaSayfaAciklama` int(1) NOT NULL,
  `Sartlar` text NOT NULL,
  `Markalar` int(1) DEFAULT NULL,
  `DetayliArama` int(1) NOT NULL,
  `Slider` int(1) NOT NULL,
  `FiyatDurumu` int(1) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;



CREATE TABLE IF NOT EXISTS `etiketler` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Etiketler` varchar(255) NOT NULL,
  `VeriId` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`),
  FULLTEXT KEY `Etiketler` (`Etiketler`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=288 ;



CREATE TABLE IF NOT EXISTS `firma` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `FirmaAdi` varchar(255) NOT NULL,
  `FirmaMail` varchar(255) NOT NULL,
  `FirmaAdres` text NOT NULL,
  `FirmaTel` varchar(255) NOT NULL,
  `FirmaFax` varchar(255) NOT NULL,
  `FirmaGoogleAnalytics` text NOT NULL,
  `FirmaGoogleMaps` text NOT NULL,
  `Backlink` text NOT NULL,
  `Facebook` text NOT NULL,
  `Twitter` text NOT NULL,
  `YouTube` varchar(255) NOT NULL,
  `Flickr` varchar(255) NOT NULL,
  `Google` varchar(255) NOT NULL,
  `Yahoo` varchar(255) NOT NULL,
  `Linkedin` varchar(255) NOT NULL,
  `Banka` text NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;



CREATE TABLE IF NOT EXISTS `galeriler` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Baslik` varchar(155) NOT NULL,
  `Resim` varchar(255) NOT NULL,
  `Durum` char(11) DEFAULT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `KatId` int(11) NOT NULL,
  `Sira` int(5) NOT NULL,
  `Thumb` varchar(255) NOT NULL,
  `Ozet` text NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;



CREATE TABLE IF NOT EXISTS `galeriresim` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Baslik` varchar(155) NOT NULL,
  `Ozet` text NOT NULL,
  `Resim` varchar(255) NOT NULL,
  `Durum` char(11) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `GaleriId` int(11) NOT NULL,
  `Thumb` varchar(255) DEFAULT NULL,
  `Okunma` bigint(20) NOT NULL,
  `Sira` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;



CREATE TABLE IF NOT EXISTS `haberler` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `HaberBaslik` varchar(255) DEFAULT NULL,
  `Seo` varchar(255) NOT NULL,
  `Ozet` text NOT NULL,
  `Icerik` text NOT NULL,
  `KatId` int(11) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Durum` tinyint(1) NOT NULL DEFAULT '1',
  `Okunma` bigint(11) NOT NULL,
  `Resim` text DEFAULT NULL,
  `Thumb` text DEFAULT NULL,
  `Sira` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  FULLTEXT KEY `Icerik` (`Icerik`),
  FULLTEXT KEY `HaberBaslik` (`HaberBaslik`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;



CREATE TABLE IF NOT EXISTS `kullanicilar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adi` varchar(100) NOT NULL,
  `soyadi` varchar(100) NOT NULL,
  `sehir` char(100) NOT NULL,
  `ilce` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `kullanici` varchar(255) NOT NULL,
  `sifre` varchar(255) NOT NULL,
  `telefon` varchar(255) NOT NULL,
  `adres` text NOT NULL,
  `tc` varchar(16) NOT NULL,
  `vd` varchar(30) NOT NULL,
  `firmaadi` varchar(255) NOT NULL,
  `ip` varchar(75) NOT NULL,
  `kullanici_seviye` enum('0','1','2','3') NOT NULL DEFAULT '1',
  `kayit_tarih` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `akod` int(1) NOT NULL,
  `iskonto` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;



CREATE TABLE IF NOT EXISTS `maillist` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Email` varchar(255) NOT NULL,
  `IP` varchar(255) NOT NULL,
  `Tarih` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;



CREATE TABLE IF NOT EXISTS `markalar` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Baslik` varchar(155) NOT NULL,
  `Resim` varchar(255) DEFAULT NULL,
  `Thumb` varchar(255) DEFAULT NULL,
  `Durum` char(11) NOT NULL,
  `Menu` int(1) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL,
  `Sira` int(5) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;



CREATE TABLE IF NOT EXISTS `mesaj` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `AdSoyad` varchar(155) NOT NULL,
  `Email` varchar(155) NOT NULL,
  `Telefon` varchar(155) NOT NULL,
  `Konu` varchar(155) NOT NULL,
  `Mesaj` text NOT NULL,
  `Tarih` varchar(155) NOT NULL,
  `IP` varchar(155) NOT NULL,
  `Durum` varchar(10) NOT NULL,
  `Okunma` bigint(2) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Tablo için tablo yapısı `odemebildirimleri`
--

CREATE TABLE IF NOT EXISTS `odemebildirimleri` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SiparisNo` varchar(155) NOT NULL,
  `Banka` varchar(155) NOT NULL,
  `Tarih` varchar(155) NOT NULL,
  `Mesaj` text NOT NULL,
  `Olusturulma` varchar(155) NOT NULL,
  `IP` varchar(155) NOT NULL,
  `Durum` varchar(10) NOT NULL,
  `Okunma` bigint(2) NOT NULL,
  `Uye` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;



CREATE TABLE IF NOT EXISTS `sayfa` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `SayfaBaslik` varchar(155) NOT NULL,
  `SayfaIcerik` text NOT NULL,
  `Durum` char(5) NOT NULL,
  `Menu` char(5) NOT NULL,
  `Etiket` varchar(255) NOT NULL,
  `Olusturulma` varchar(155) NOT NULL,
  `Guncelleme` varchar(155) NOT NULL,
  `Sira` int(5) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `MetaDesc` varchar(160) NOT NULL,
  `MetaKey` varchar(260) NOT NULL,
  `KatId` varchar(255) NOT NULL,
  `Bolge` int(5) DEFAULT NULL,
  `Okunma` bigint(20) NOT NULL,
  `Dosya` varchar(155) DEFAULT NULL,
  `SayfaLinki` varchar(255) NOT NULL,
  `AltSayfa` varchar(255) NOT NULL,
  `Resim` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  FULLTEXT KEY `SayfaIcerik` (`SayfaIcerik`),
  FULLTEXT KEY `Title` (`Title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;



CREATE TABLE IF NOT EXISTS `sayfakategori` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Baslik` varchar(255) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `MetaKey` varchar(160) NOT NULL,
  `MetaDesc` varchar(255) NOT NULL,
  `Durum` varchar(155) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Sira` int(5) NOT NULL,
  `Menu` char(5) DEFAULT NULL,
  `Icerik` text DEFAULT NULL,
  `KategoriLinki` varchar(255) DEFAULT NULL,
  `UstMenu` varchar(255) NOT NULL,
  `Okunma` bigint(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


CREATE TABLE IF NOT EXISTS `sepet` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `UrunId` varchar(255) NOT NULL,
  `Baslik` text NOT NULL,
  `Kdv` int(11) NOT NULL,
  `Fiyat` varchar(255) NOT NULL,
  `Cins` varchar(255) NOT NULL,
  `Indirim` varchar(255) DEFAULT NULL,
  `UyeIndirim` int(5) NOT NULL,
  `Uye` varchar(500) NOT NULL,
  `Adet` varchar(1000) NOT NULL,
  `SepetId` varchar(255) NOT NULL,
  `OdemeTipi` int(1) NOT NULL,
  UNIQUE KEY `id` (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;



CREATE TABLE IF NOT EXISTS `siparisler` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `SepetId` varchar(255) NOT NULL,
  `UyeId` int(11) NOT NULL,
  `OdemeTipi` int(11) NOT NULL,
  `Not` text DEFAULT NULL,
  `Durum` int(11) NOT NULL,
  `Olusturulma` varchar(255) NOT NULL,
  `SiparisNo` varchar(100) NOT NULL,
  `IP` varchar(255) NOT NULL,
  `Admin` int(11) NOT NULL,
  UNIQUE KEY `id` (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;



CREATE TABLE IF NOT EXISTS `slayt` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Resim` varchar(255) DEFAULT NULL,
  `Baslik` varchar(255) NOT NULL,
  `Aciklama` text NOT NULL,
  `Durum` int(1) DEFAULT NULL,
  `Sira` int(5) NOT NULL,
  `Olusturulma` varchar(155) NOT NULL,
  `Guncelleme` varchar(155) NOT NULL,
  `Link` text NOT NULL,
  `Secim` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;



CREATE TABLE IF NOT EXISTS `urunkategori` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Baglanti` varchar(255) NOT NULL,
  `Baslik` varchar(255) NOT NULL,
  `Perma` varchar(255) NOT NULL,
  `Durum` varchar(155) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Menu` varchar(255) NOT NULL,
  `Sira` int(5) NOT NULL,
  `MetaKey` varchar(260) NOT NULL,
  `MetaDesc` varchar(160) NOT NULL,
  `Resim` varchar(255) DEFAULT NULL,
  `Thumb` varchar(255) DEFAULT NULL,
  `Aciklama` text NOT NULL,
  UNIQUE KEY `Id` (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=711 ;


CREATE TABLE IF NOT EXISTS `urunler` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `KatId` varchar(255) NOT NULL,
  `Baslik` text NOT NULL,
  `Fiyat` varchar(20) NOT NULL,
  `Indirim` varchar(20) NOT NULL,
  `Cins` varchar(6) NOT NULL,
  `Kdv` varchar(2) NOT NULL,
  `Ozellik` text NOT NULL,
  `Resim` varchar(255) DEFAULT NULL,
  `Resim2` varchar(255) DEFAULT NULL,
  `Resim3` varchar(255) DEFAULT NULL,
  `Resim4` varchar(255) DEFAULT NULL,
  `Durum` varchar(155) NOT NULL,
  `Olusturulma` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Guncelleme` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Title` varchar(60) NOT NULL,
  `MetaKey` text NOT NULL,
  `MetaDesc` text NOT NULL,
  `Sira` int(5) NOT NULL,
  `Okunma` bigint(20) NOT NULL,
  `UrunKodu` char(155) NOT NULL,
  `Marka` varchar(255) DEFAULT NULL,
  `Thumb` varchar(255) DEFAULT NULL,
  `Etiket` varchar(255) NOT NULL,
  `Stok` int(11) NOT NULL DEFAULT '0',
  `StokAdet` varchar(255) NOT NULL,
  `Yorum` int(1) NOT NULL,
  PRIMARY KEY (`Id`),
  FULLTEXT KEY `UrunOzellik` (`Ozellik`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=142 ;


CREATE TABLE IF NOT EXISTS `yonetici` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `KullaniciAdi` varchar(66) NOT NULL,
  `AdSoyad` varchar(255) NOT NULL,
  `KullaniciSifre` varchar(66) NOT NULL,
  `KullaniciMail` varchar(66) NOT NULL,
  `Yetki` int(255) NOT NULL,
  `Sans` varchar(1) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;



CREATE TABLE IF NOT EXISTS `yorumlar` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Yorum` text,
  `VeriId` int(11) DEFAULT NULL,
  `AdSoyad` varchar(50) DEFAULT NULL,
  `EMail` varchar(50) DEFAULT NULL,
  `Tarih` varchar(50) DEFAULT NULL,
  `Tip` int(11) DEFAULT NULL,
  `Onay` varchar(255) DEFAULT NULL,
  `IP` varchar(50) DEFAULT NULL,
  `UyeId` int(11) NOT NULL,
  `Admin` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `VeriId` (`VeriId`),
  KEY `Onay` (`Onay`),
  KEY `UyeId` (`UyeId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;