-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 30 Oca 2022, 20:11:28
-- Sunucu sürümü: 10.3.32-MariaDB
-- PHP Sürümü: 7.3.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Veritabanı: `bayarajans_fotografci`
--

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

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

CREATE TABLE `ayarlar` (
  `id` int(11) NOT NULL,
  `site_title` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `site_description` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `site_author` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `site_renk` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `telefon1` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `telefon2` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `whatsapp` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `email1` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `email2` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `adres1` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `adres2` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `google_maps` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `facebook` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `twitter` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `linkedin` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `telegram` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `youtube` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `instagram` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `logo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `footer_logo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `favicon` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `footer_copyright` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `site_mail` text DEFAULT NULL,
  `site_mail_sifre` text DEFAULT NULL,
  `site_mail_port` text DEFAULT NULL,
  `site_mail_host` text DEFAULT NULL,
  `gonderen_email` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ayarlar` (`id`, `site_title`, `site_description`, `site_author`, `site_renk`, `telefon1`, `telefon2`, `whatsapp`, `email1`, `email2`, `adres1`, `adres2`, `google_maps`, `facebook`, `twitter`, `linkedin`, `telegram`, `youtube`, `instagram`, `logo`, `footer_logo`, `favicon`, `footer_copyright`, `site_mail`, `site_mail_sifre`, `site_mail_port`, `site_mail_host`, `gonderen_email`) VALUES
(1, 'Düğün Fotoğrafçısı Scripti v1', 'Düğün Fotoğrafçısı Scripti v1', 'Düğün Fotoğrafçısı Scripti v1', '#b5958e', '0326 606 01 96', '0326 606 01 96', '0326 606 01 96', 'info@bayarmedya.com', 'info@bayarmedya.com', 'İstanbul / Avrupa', '', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d192697.7932759511!2d28.8720964464606!3d41.00549580940238!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x14caa7040068086b%3A0xe1ccfe98bc01b0d0!2zxLBzdGFuYnVs!5e0!3m2!1str!2str!4v1641428043435!5m2!1str!2str\" width=\"100%\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\"></iframe>', '#', '#', '#', '#', '#', '#', '262161954-dugun-fotografcisi-scripti-v1.png', '99533783-dugun-fotografcisi-scripti-v1.png', '327552901-dugun-fotografcisi-scripti-v1.png', 'Copyright © 2021  Tüm Hakları Saklıdır.', '#', '#', '#', '#', '#');

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

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

CREATE TABLE `ekibimiz` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `unvan` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ekibimiz` (`id`, `adi`, `sira`, `resim`, `unvan`, `durum`, `aciklama`) VALUES
(3, 'Umut Tamirci', '1', '638-umut-tamirci.webp', 'Güzellik Uzmanı', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n'),
(4, 'Emre Kızıl', '1', '37-emre-kizil.webp', 'Güzellik Uzmanı', 'on', ''),
(5, 'Metin Dilmen', '2', '272-metin-dilmen.webp', 'Güzellik Uzmanı', 'on', ''),
(6, 'Gökhan Aykut', '4', '661-gokhan-aykut.webp', 'Güzellik Uzmanı', 'on', '');

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

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

CREATE TABLE `galeri` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `galeri` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`) VALUES
(11, '5', '5', '5-8597234.webp', '5', 'on', '', '5', 'sayfalar', '03.01.2022'),
(12, '6', '6', '6-9399665.webp', '6', 'on', '', '6', 'sayfalar', '03.01.2022'),
(10, '4', '4', '4-7114596.webp', '4', 'on', '', '4', 'sayfalar', '03.01.2022'),
(9, 'Düğün Fotoğrafçısı', '3', '-dugun-fotografcisi.webp', '33', 'on', '', 'dugun-fotografcisi', 'galeri', '03.01.2022'),
(8, 'Gelin & Damat Çekimi', '2', '-gelin-damat-cekimi.webp', '2', 'on', '<p>2</p>\r\n', 'gelin-damat-cekimi', 'galeri', '03.01.2022'),
(7, 'Kır Düğünü', '1', '-kir-dugunu.webp', '1', 'on', '', 'kir-dugunu', 'galeri', '03.01.2022');

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

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

CREATE TABLE `haberler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `haberler` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`) VALUES
(1, 'Blog 1', '1', '492-blog-1.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'blog-1', 'haberler', '30.01.2022'),
(2, 'Blog 2', '2', '358-blog-2.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'blog-2', 'haberler', '30.01.2022'),
(3, 'Blog 3', '3', '504-blog-3.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. ', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'blog-3', 'haberler', '30.01.2022'),
(4, 'Blog 4', '4', '483-blog-4.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<p>&nbsp;</p>\r\n', 'blog-4', 'haberler', '30.01.2022');

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

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

CREATE TABLE `hizmetler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `hizmetler` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`, `kategori`) VALUES
(10, 'Hizmet nedir', '1', '95-hizmet-nedirArray', 'qweqwe', 'on', '<p>Lorem Ipsum&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'hizmet-nedir', 'hizmetler', '30.01.2022', '4');

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

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

CREATE TABLE `hizmet_kategori` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `kategori` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `hizmet_kategori` (`id`, `adi`, `seo`, `durum`, `tur`, `resim`, `aciklama`, `onaciklama`, `kategori`, `tarih`, `sira`) VALUES
(1, 'hizmet kategori', 'hizmet-kategori', 'on', 'hizmet_kategori', '518-hizmet-kategori.webp', '<p>qweqw</p>\r\n', 'qweqweqwe', '0', '30.01.2022', '1'),
(2, 'Hizmet Kategori 2', 'hizmet-kategori-2', 'on', 'hizmet_kategori', '721-hizmet-kategori-2.webp', '', 'qweqwe', '0', '30.01.2022', '2'),
(3, 'Hizmet Kategori 3', 'hizmet-kategori-3', 'on', 'hizmet_kategori', '856-hizmet-kategori-3.webp', '', 'qweqwe', '0', '30.01.2022', '3'),
(4, 'Hizmet Alt Kategori 1', 'hizmet-alt-kategori-1', 'on', 'hizmet_kategori', '426-hizmet-alt-kategori-1.webp', '', 'wqeqw', '0', '30.01.2022', '4'),
(5, 'Hizmet Alt Kategori 2', 'hizmet-alt-kategori-2', 'on', 'hizmet_kategori', '390-hizmet-alt-kategori-2.webp', '', 'asd', '0', '30.01.2022', '5'),
(6, 'Hizmet Alt Kategori 3', 'hizmet-alt-kategori-3', 'on', 'hizmet_kategori', '625-hizmet-alt-kategori-3.webp', '', 'qwewq', '0', '30.01.2022', '6');

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

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

CREATE TABLE `ilanlar` (
  `id` int(11) NOT NULL,
  `ilan_adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `fiyat` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `adres` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `google_maps` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `video` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `gtarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `hit` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ilanlar` (`id`, `ilan_adi`, `fiyat`, `adres`, `resim`, `aciklama`, `google_maps`, `video`, `tur`, `durum`, `tarih`, `seo`, `gtarih`, `hit`) VALUES
(1, 'Bahçeli manzaralı ', '55', '55 W Jackson Blvd, Chicago, IL 60604, USA', '404-bahceli-manzarali.webp', '<p>Lorem ipsum, dolor sit amet consectetur adipisicing elit. Perspiciatis, suscipit, numquam accusantium eligendi veniam dolor placeat earum illo corporis esse nulla facere sunt assumenda? Perferendis omnis magni quos fugiat explicabo.</p>\r\n\r\n<p>Lorem ipsum dolor, sit amet consectetur adipisicing elit. Odit laboriosam voluptates dignissimos? Dolorum sed culpa repellat, itaque quas nostrum, eos qui nemo fugit reiciendis laboriosam vero magnam nam, dolorem officia.</p>\r\n\r\n<p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Natus voluptas assumenda ab, quos sequi rerum. Quos iusto ab alias, exercitationem autem a doloribus non. Vel porro tenetur omnis ut numquam.</p>\r\n', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d180875.28138651486!2d28.872096530693135!3d41.00523670852465!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x14caa7040068086b%3A0xe1ccfe98bc01b0d0!2zxLBzdGFuYnVs!5e0!3m2!1str!2str!4v1638459538653!5m2!1str!2str\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\"></iframe>', '<iframe width=\"100%\" height=\"656\" src=\"https://www.youtube.com/embed/-NInBEdSvp8\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', 'ilanlar', 'on', '08.12.2021', 'bahceli-manzarali', '12.12.2021', NULL);

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

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

CREATE TABLE `iletisimler` (
  `id` int(11) NOT NULL,
  `adsoyad` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `konu` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `istatik` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `icon` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `istatik` (`id`, `adi`, `sira`, `aciklama`, `icon`, `durum`) VALUES
(5, 'Uzman mühendislerimiz var', '1', '<p>Lorem ipsum, dolor sit amet consectetur adipisicing elit. Vitae dolor magnam, facilis voluptas quia excepturi provident cupiditate.</p>\r\n', 'Mühendisler', 'on'),
(6, '7/24 müşteri desteği.', '2', '<p>Lorem ipsum, dolor sit amet consectetur adipisicing elit. Vitae dolor magnam, facilis voluptas quia excepturi provident cupiditate.</p>\r\n', '7/24 Destek', 'on'),
(7, 'Müşteri Memnuniyeti', '3', '<p>Lorem ipsum, dolor sit amet consectetur adipisicing elit. Vitae dolor magnam, facilis voluptas quia excepturi provident cupiditate.</p>\r\n', 'Memnuniyet', 'on');

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

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

CREATE TABLE `mailler` (
  `id` int(11) NOT NULL,
  `mail` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `mailler` (`id`, `mail`) VALUES
(1, 'hilelicocuk5@gmail.com, umuttamirci7@gmail.com'),
(2, 'hilelicocuk5@gmail.com,umuttamirci37@gmail.com'),
(3, 'hilelicocuk5@gmail.com'),
(4, 'hilelicocuk5@gmail.com'),
(5, 'hilelicocuk5@gmail.com, umuttamirci7@gmail.com'),
(6, 'hilelicocuk5@gmail.com, umuttamirci37@gmail.com'),
(7, 'umuttamirci37@gmail.com,hilelicocuk5@gmail.com'),
(8, 'hilelicocuk5@gmail.com');

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

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

CREATE TABLE `randevular` (
  `id` int(11) NOT NULL,
  `adsoyad` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `telefon` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `hizmet` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `mesaj` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `referanslar` (
  `id` int(11) NOT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `linki` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `referanslar` (`id`, `sira`, `adi`, `linki`, `durum`, `resim`) VALUES
(1, '1', 'Bayar Medya', 'bayarmedya.com', 'on', '540-bayar-medya.webp');

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

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

CREATE TABLE `sayfalar` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `sayfalar` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`) VALUES
(1, 'Hakkımızda', '1', '-hakkimizda.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'on', '<p>Profesyonel ve Eğitimli kadromuz, faaliyet alanlarımızda kullandığımız profesyonel ekipmanlarımız ile Siz m&uuml;şterilerimizin &ccedil;&ouml;z&uuml;m ortağı olmaya ve uzun s&uuml;reli dostluklar kurarak hep birlikte daha m&uuml;kemmele ulaşmaya &ccedil;alışmaktayız...<br />\r\n<br />\r\nBuket Fotoğraf&ccedil;ılık, Organizasyon, Okul, Kreş, &Uuml;r&uuml;n, &Uuml;retim, Mekan, Gelin Damat, Moda, &Ouml;zel Davetler, M&uuml;zik Grupları, Kokteyl, A&ccedil;ılış, Fuar, Portre, Manken, Sanat&ccedil;ı konuları &ccedil;alışmalarımız arasındadır.<br />\r\n<br />\r\nTeknolojiyi yakından ve s&uuml;rekli takip ederek m&uuml;şterilerimize en iyi hizmeti verebilmeyi ama&ccedil;lamaktayız. Ulusal ve Uluslararası g&ouml;rsel ve basılı medyayı s&uuml;rekli takip ederek kendimizi geliştirmekte; sıra dışı &ccedil;alışmalara imza atmaktayız.<br />\r\n<br />\r\nFotoğraf &Ccedil;ekimlerimiz, Fotoğraf İşleme ve Baskısı konularındaki hassasiyetimiz Siz m&uuml;şterilerimiz i&ccedil;in iyisini değil; daima en ve daha iyisini yapabilmek i&ccedil;indir.</p>\r\n', 'hakkimizda', 'sayfalar', '03.01.2022'),
(2, 'Gizlilik Politikasi', '2', '927-gizlilik-politikasi.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'gizlilik-politikasi', 'sayfalar', '30.01.2022');

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

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

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `slider` (`id`, `adi`, `sira`, `resim`, `durum`) VALUES
(1, 'Hayatınıza Renk Katın', '1', '745-hayatiniza-renk-katin.webp', 'on'),
(4, 'Aşkınız Gerçek Olsun', '2', 'askiniz-gercek-olsun-7476357.webp', 'on');

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

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

CREATE TABLE `sss` (
  `id` int(11) NOT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `sss` (`id`, `sira`, `adi`, `aciklama`, `durum`) VALUES
(1, '1', 'Web site nedir?', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'on');

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

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

CREATE TABLE `urunler` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `urunler` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`) VALUES
(5, 'Toplu Maske Satışı', '1', '217-toplu-maske-satisi.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'toplu-maske-satisi', 'urunler', '18.12.2021'),
(6, 'Tansiyon Aleti', '2', '433-tansiyon-aleti.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n', 'tansiyon-aleti', 'urunler', '18.12.2021');

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

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

CREATE TABLE `urun_img` (
  `id` int(11) NOT NULL,
  `urun_id` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `img` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `urun_img` (`id`, `urun_id`, `tur`, `img`) VALUES
(131, '4', 'urunler', '1639679852-61bb876c5cd78.jpg'),
(128, '2', NULL, '1639677128-61bb7cc84aec6.jpg'),
(127, '1', NULL, '1639677002-61bb7c4a91885.jpg'),
(126, NULL, NULL, '1639676961-61bb7c2189370.jpg'),
(141, '6', 'urunler', '1639781375-61bd13ff2f12e.jpg'),
(140, '6', 'urunler', '1639781365-61bd13f55c1b0.jpg'),
(135, '5', 'urunler', '1639790881-61bd3921cb295.png'),
(136, '5', 'urunler', '1639790881-61bd3921cb360.png'),
(137, '5', 'urunler', '1639790881-61bd3921cb370.png'),
(138, '5', 'urunler', '1639790881-61bd3921cb59d.png'),
(139, '5', 'urunler', '1639790881-61bd3921cb66c.png');

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

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

CREATE TABLE `urun_secenek` (
  `id` int(11) NOT NULL,
  `urun_id` int(11) NOT NULL,
  `baslik` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `urun_secenek` (`id`, `urun_id`, `baslik`) VALUES
(51, 1, 'Beden'),
(25, 2, 'Beden'),
(52, 3, 'Beden'),
(27, 4, 'Beden'),
(28, 5, 'Beden'),
(29, 6, 'Beden'),
(30, 7, 'Beden'),
(31, 8, 'Beden'),
(32, 9, 'Beden'),
(33, 10, 'Beden'),
(34, 11, 'Beden'),
(35, 12, 'Beden'),
(36, 13, 'Beden'),
(37, 14, 'Beden'),
(38, 15, 'Beden'),
(39, 16, 'Beden'),
(40, 17, 'Beden'),
(41, 18, 'Beden'),
(42, 19, 'Beden'),
(43, 20, 'Beden'),
(44, 21, 'Beden'),
(45, 22, 'Beden'),
(46, 23, 'Beden'),
(47, 24, 'Beden');

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

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

CREATE TABLE `urun_secenek_alt` (
  `id` int(11) NOT NULL,
  `urun_secenek_id` int(11) NOT NULL,
  `baslik` varchar(255) NOT NULL,
  `stok` int(11) NOT NULL,
  `fiyat` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `urun_secenek_alt` (`id`, `urun_secenek_id`, `baslik`, `stok`, `fiyat`) VALUES
(153, 51, 'XL', 10, '10'),
(152, 51, 'M', 10, '10'),
(151, 51, 'S', 10, '10'),
(75, 25, 'XL', 10, '10'),
(74, 25, 'M', 10, '10'),
(73, 25, 'S', 10, '10'),
(156, 52, 'S', 10, '10'),
(155, 52, 'M', 10, '10'),
(154, 52, 'XL', 6, '10'),
(81, 27, 'XL', 10, '10'),
(80, 27, 'M', 10, '10'),
(79, 27, 'S', 10, '10'),
(84, 28, 'XL', 10, '10'),
(83, 28, 'M', 10, '10'),
(82, 28, 'S', 10, '10'),
(87, 29, 'XL', 10, '10'),
(86, 29, 'M', 10, '10'),
(85, 29, 'S', 10, '10'),
(90, 30, 'XL', 10, '10'),
(89, 30, 'M', 10, '10'),
(88, 30, 'S', 10, '10'),
(93, 31, 'XL', 10, '10'),
(92, 31, 'M', 10, '10'),
(91, 31, 'S', 10, '10'),
(96, 32, 'XL', 10, '10'),
(95, 32, 'M', 10, '10'),
(94, 32, 'S', 10, '10'),
(99, 33, 'XL', 10, '10'),
(98, 33, 'M', 10, '10'),
(97, 33, 'S', 10, '10'),
(102, 34, 'XL', 10, '10'),
(101, 34, 'M', 10, '10'),
(100, 34, 'S', 10, '10'),
(105, 35, 'XL', 10, '10'),
(104, 35, 'M', 10, '10'),
(103, 35, 'S', 10, '10'),
(108, 36, 'XL', 10, '10'),
(107, 36, 'M', 10, '10'),
(106, 36, 'S', 10, '10'),
(111, 37, 'XL', 10, '10'),
(110, 37, 'M', 10, '10'),
(109, 37, 'S', 10, '10'),
(114, 38, 'XL', 10, '10'),
(113, 38, 'M', 10, '10'),
(112, 38, 'S', 10, '10'),
(117, 39, 'XL', 10, '10'),
(116, 39, 'M', 10, '10'),
(115, 39, 'S', 10, '10'),
(120, 40, 'XL', 10, '10'),
(119, 40, 'M', 10, '10'),
(118, 40, 'S', 10, '10'),
(123, 41, 'XL', 10, '10'),
(122, 41, 'M', 10, '10'),
(121, 41, 'S', 10, '10'),
(126, 42, 'XL', 10, '10'),
(125, 42, 'M', 10, '10'),
(124, 42, 'S', 10, '10'),
(129, 43, 'XL', 10, '10'),
(128, 43, 'M', -2, '10'),
(127, 43, 'S', 10, '10'),
(132, 44, 'XL', 10, '10'),
(131, 44, 'M', 10, '10'),
(130, 44, 'S', 10, '10'),
(135, 45, 'XL', 10, '10'),
(134, 45, 'M', 10, '10'),
(133, 45, 'S', 10, '10'),
(138, 46, 'XL', 10, '10'),
(137, 46, 'M', 10, '10'),
(136, 46, 'S', 10, '10'),
(141, 47, 'XL', 10, '10'),
(140, 47, 'M', 10, '10'),
(139, 47, 'S', 10, '10');

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

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

CREATE TABLE `video` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `onaciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `seo` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tur` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `tarih` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `video` (`id`, `adi`, `sira`, `resim`, `onaciklama`, `durum`, `aciklama`, `seo`, `tur`, `tarih`) VALUES
(1, 'Video 1', '1', '995-video-1.webp', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 'on', '<p><iframe frameborder=\"0\" height=\"713\" src=\"https://www.youtube.com/embed/QfV8Twql98Q?list=RDQfV8Twql98Q\" title=\"YouTube video player\" width=\"1268\"></iframe></p>\r\n', 'video-1', 'video', '30.01.2022');

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

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

CREATE TABLE `yonetici` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sifre` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `normalsifre` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `yonetici` (`id`, `adi`, `sifre`, `normalsifre`) VALUES
(3, 'demo@demo.com', '89e495e7941cf9e40e6980d14a16bf023ccd4c91', 'demo');

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

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

CREATE TABLE `yorumlar` (
  `id` int(11) NOT NULL,
  `adi` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `sira` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `resim` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `unvan` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `durum` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL,
  `aciklama` text CHARACTER SET utf8 COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `yorumlar` (`id`, `adi`, `sira`, `resim`, `unvan`, `durum`, `aciklama`) VALUES
(3, 'Bayar Medya', '1', '-bayar-medya.webp', 'Web Tasarım', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n'),
(4, 'Emre Kızıl', '2', '-emre-kizil.webp', 'İç Mimar', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n'),
(5, 'Metin Dilmen', '3', '-metin-dilmen.webp', 'İnşaat Mühendisi', 'on', '<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n');

--
-- Dökümü yapılmış tablolar için indeksler
--

--
-- Tablo için indeksler `ayarlar`
--
ALTER TABLE `ayarlar`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `ekibimiz`
--
ALTER TABLE `ekibimiz`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `galeri`
--
ALTER TABLE `galeri`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `haberler`
--
ALTER TABLE `haberler`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `hizmetler`
--
ALTER TABLE `hizmetler`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `hizmet_kategori`
--
ALTER TABLE `hizmet_kategori`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `ilanlar`
--
ALTER TABLE `ilanlar`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `iletisimler`
--
ALTER TABLE `iletisimler`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `istatik`
--
ALTER TABLE `istatik`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `mailler`
--
ALTER TABLE `mailler`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `randevular`
--
ALTER TABLE `randevular`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `referanslar`
--
ALTER TABLE `referanslar`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `sayfalar`
--
ALTER TABLE `sayfalar`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `sss`
--
ALTER TABLE `sss`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `urunler`
--
ALTER TABLE `urunler`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `urun_img`
--
ALTER TABLE `urun_img`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `urun_secenek`
--
ALTER TABLE `urun_secenek`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `urun_secenek_alt`
--
ALTER TABLE `urun_secenek_alt`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `video`
--
ALTER TABLE `video`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `yonetici`
--
ALTER TABLE `yonetici`
  ADD PRIMARY KEY (`id`);

--
-- Tablo için indeksler `yorumlar`
--
ALTER TABLE `yorumlar`
  ADD PRIMARY KEY (`id`);

--
-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
--

--
-- Tablo için AUTO_INCREMENT değeri `ayarlar`
--
ALTER TABLE `ayarlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `ekibimiz`
--
ALTER TABLE `ekibimiz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `galeri`
--
ALTER TABLE `galeri`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- Tablo için AUTO_INCREMENT değeri `haberler`
--
ALTER TABLE `haberler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `hizmetler`
--
ALTER TABLE `hizmetler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Tablo için AUTO_INCREMENT değeri `hizmet_kategori`
--
ALTER TABLE `hizmet_kategori`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `ilanlar`
--
ALTER TABLE `ilanlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `iletisimler`
--
ALTER TABLE `iletisimler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `istatik`
--
ALTER TABLE `istatik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Tablo için AUTO_INCREMENT değeri `mailler`
--
ALTER TABLE `mailler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Tablo için AUTO_INCREMENT değeri `randevular`
--
ALTER TABLE `randevular`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `referanslar`
--
ALTER TABLE `referanslar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `sayfalar`
--
ALTER TABLE `sayfalar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `sss`
--
ALTER TABLE `sss`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Tablo için AUTO_INCREMENT değeri `urunler`
--
ALTER TABLE `urunler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tablo için AUTO_INCREMENT değeri `urun_img`
--
ALTER TABLE `urun_img`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=146;

--
-- Tablo için AUTO_INCREMENT değeri `urun_secenek`
--
ALTER TABLE `urun_secenek`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- Tablo için AUTO_INCREMENT değeri `urun_secenek_alt`
--
ALTER TABLE `urun_secenek_alt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=157;

--
-- Tablo için AUTO_INCREMENT değeri `video`
--
ALTER TABLE `video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tablo için AUTO_INCREMENT değeri `yonetici`
--
ALTER TABLE `yonetici`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `yorumlar`
--
ALTER TABLE `yorumlar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
