-- phpMyAdmin SQL Dump -- version 4.1.14 -- http://www.phpmyadmin.net -- -- Anamakine: 127.0.0.1 -- Üretim Zamanı: 24 Ara 2014, 14:15:56 -- Sunucu sürümü: 5.6.17 -- PHP Sürümü: 5.5.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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 utf8 */; -- -- Veritabanı: `petrol` -- -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `alt_urun_kategori` -- CREATE TABLE IF NOT EXISTS `alt_urun_kategori` ( `id` int(15) NOT NULL AUTO_INCREMENT, `sira` int(15) NOT NULL, `ust_id` int(11) NOT NULL, `kategori_adi` text COLLATE utf8_turkish_ci NOT NULL, `kategori_resim` text COLLATE utf8_turkish_ci NOT NULL, `durum` int(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=22 ; -- -- Tablo döküm verisi `alt_urun_kategori` -- INSERT INTO `alt_urun_kategori` (`id`, `sira`, `ust_id`, `kategori_adi`, `kategori_resim`, `durum`) VALUES (19, 1, 14, 'Endüstriyel Yağ Çözücüler', 'endustriyel_yag_cozuculer_1.jpg', 1), (20, 2, 14, 'Özel Temizleyiciler', 'endustriyel_ozel_temizleyiciler.jpg', 1), (21, 1, 15, 'Tekstil Hijyen Ürünleri', 'tekstil_hijyen_grubu.jpg', 1); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ayar` -- CREATE TABLE IF NOT EXISTS `ayar` ( `ayar_id` int(11) NOT NULL AUTO_INCREMENT, `copyright` text COLLATE utf8_turkish_ci NOT NULL, `site_title` char(70) COLLATE utf8_turkish_ci DEFAULT NULL, `site_meta` char(160) COLLATE utf8_turkish_ci DEFAULT NULL, `site_description` char(160) COLLATE utf8_turkish_ci DEFAULT NULL, `site_mail` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `site_logo` varchar(255) COLLATE utf8_turkish_ci NOT NULL, `site_mail_sifre` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `site_mail_host` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `site_mail_port` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `google_analytics` longtext COLLATE utf8_turkish_ci, `firma_telefon` longtext COLLATE utf8_turkish_ci NOT NULL, `firma_fax` longtext COLLATE utf8_turkish_ci NOT NULL, `firma_email` varchar(40) COLLATE utf8_turkish_ci NOT NULL, `firma_adres` longtext CHARACTER SET latin5 NOT NULL, `footer_adres` text COLLATE utf8_turkish_ci NOT NULL, `google_maps` longtext COLLATE utf8_turkish_ci NOT NULL, `facebook` longtext COLLATE utf8_turkish_ci NOT NULL, `twitter` longtext COLLATE utf8_turkish_ci NOT NULL, `gplus` longtext COLLATE utf8_turkish_ci NOT NULL, `linkedin` longtext COLLATE utf8_turkish_ci NOT NULL, `pinterest` longtext COLLATE utf8_turkish_ci NOT NULL, `firma_adi` longtext COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`ayar_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ; -- -- Tablo döküm verisi `ayar` -- INSERT INTO `ayar` (`ayar_id`, `copyright`, `site_title`, `site_meta`, `site_description`, `site_mail`, `site_logo`, `site_mail_sifre`, `site_mail_host`, `site_mail_port`, `google_analytics`, `firma_telefon`, `firma_fax`, `firma_email`, `firma_adres`, `footer_adres`, `google_maps`, `facebook`, `twitter`, `gplus`, `linkedin`, `pinterest`, `firma_adi`) VALUES (1, 'Copyright 2014 © Petrol Firma Scripti V8 Tüm Hakları Saklıdır.', 'Petrol Firma Scripti V8', 'Petrol Firma Scripti V8', 'Petrol Firma Scripti V8', '', 'LG.png', '', '', '', '', '0537 872 67 08', '0537 872 67 08', 'info@web-ofisi.com', 'Home Ofis Çalışma Sistemi', '', '', 'https://www.facebook.com/', 'https://twitter.com/', '', '', '', 'Petrol Firma Scripti V8'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `fotograf_galeri` -- CREATE TABLE IF NOT EXISTS `fotograf_galeri` ( `id` int(11) NOT NULL AUTO_INCREMENT, `adi` text COLLATE utf8_turkish_ci NOT NULL, `sira` int(11) NOT NULL, `resim` text COLLATE utf8_turkish_ci NOT NULL, `durum` int(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=104 ; -- -- Tablo döküm verisi `fotograf_galeri` -- INSERT INTO `fotograf_galeri` (`id`, `adi`, `sira`, `resim`, `durum`) VALUES (99, 'Deneme 3', 3, '003.jpg', 1), (100, 'Deneme 4', 4, '004.jpg', 1), (101, 'Deneme 5', 5, '46634_free_boats_shutterstock_9167947_web.jpg', 1), (98, 'Deneme 2', 2, '002.jpg', 1), (97, 'Deneme 1', 1, '001.jpg', 1), (102, 'Deneme 6', 6, '162444_flower_still_life_w725_h544.jpg', 1), (103, 'Deneme 7', 7, '655832_freegreatpicturecom_30673_stock_photo.jpg', 1); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `haberler` -- CREATE TABLE IF NOT EXISTS `haberler` ( `id` int(11) NOT NULL AUTO_INCREMENT, `adi` text COLLATE utf8_turkish_ci NOT NULL, `sira` int(11) NOT NULL, `seo` varchar(255) COLLATE utf8_turkish_ci NOT NULL, `aciklama` text COLLATE utf8_turkish_ci NOT NULL, `resim` text COLLATE utf8_turkish_ci NOT NULL, `durum` int(3) NOT NULL, `tarih` text COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=9 ; -- -- Tablo döküm verisi `haberler` -- INSERT INTO `haberler` (`id`, `adi`, `sira`, `seo`, `aciklama`, `resim`, `durum`, `tarih`) VALUES (8, 'Deneme Duyuru 2', 2, 'Deneme-Duyuru-2', 'Quisque at erat id neque semper lacinia imperdiet at leo.Nam ut venenatis neque, a blandit turpis.Phasellus diam libero, porttitor vitae consectetur eget, tincidunt ut velit.Integer vel urna eget velit ultricies pellentesque a vel ipsum.Vivamus luctus ac tortor consectetur vehicula.
\r\n
\r\nIn consequat leo a consectetur interdum.Pellentesque molestie, lacus non tincidunt sodales, risus elit aliquam metus, eu congue libero elit quis diam.Proin vitae tempus mauris, quis pharetra massa.In congue neque malesuada arcu fringilla scelerisque.In convallis ac odio eu cursus.Nullam enim odio, ultrices pretium adipiscing in , mattis ut odio.Phasellus vestibulum justo dapibus, egestas neque ut, tincidunt urna.Sed ultrices nec purus id convallis.Proin suscipit a justo id rutrum.Nunc enim purus, interdum quis magna a, mattis aliquet nunc.Suspendisse vitae felis dapibus, porta odio id, pulvinar arcu.Nullam luctus congue iaculis.Nulla ac tortor elementum ligula semper tincidunt.', '3501_655832-freegreatpicture.com-30673-stock-photo.jpg', 1, '24-12-2014'), (7, 'Deneme Haber 1', 1, 'Deneme-Haber-1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.Sed non egestas eros.Nunc mollis turpis et libero suscipit ornare.Quisque at erat id neque semper lacinia imperdiet at leo.Nam ut venenatis neque, a blandit turpis.Phasellus diam libero, porttitor vitae consectetur eget, tincidunt ut velit.Integer vel urna eget velit ultricies pellentesque a vel ipsum.Vivamus luctus ac tortor consectetur vehicula.
\r\n
\r\nIn consequat leo a consectetur interdum.Pellentesque molestie, lacus non tincidunt sodales, risus elit aliquam metus, eu congue libero elit quis diam.Proin vitae tempus mauris, quis pharetra massa.In congue neque malesuada arcu fringilla scelerisque.In convallis ac odio eu cursus.Nullam enim odio, ultrices pretium adipiscing in , mattis ut odio.Phasellus vestibulum justo dapibus, egestas neque ut, tincidunt urna.Sed ultrices nec purus id convallis.Proin suscipit a justo id rutrum.Nunc enim purus, interdum quis magna a, mattis aliquet nunc.Suspendisse vitae felis dapibus, porta odio id, pulvinar arcu.Nullam luctus congue iaculis.Nulla ac tortor elementum ligula semper tincidunt.', '7642_162444-flower-still-life_w725_h544.jpg', 1, '24-12-2014'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ik` -- CREATE TABLE IF NOT EXISTS `ik` ( `id` int(11) NOT NULL AUTO_INCREMENT, `isim` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `tc` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `dyeri` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `dtarihi` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `cinsiyet` varchar(10) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `mhali` varchar(10) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `askerlik` varchar(10) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `ev` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `cep` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `mesaj` text CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `tarih` varchar(255) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT NULL, `cv` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Tablo döküm verisi `ik` -- INSERT INTO `ik` (`id`, `isim`, `tc`, `dyeri`, `dtarihi`, `cinsiyet`, `mhali`, `askerlik`, `ev`, `cep`, `mail`, `mesaj`, `tarih`, `cv`) VALUES (3, 'osman fatsa', '43411208610', 'Dereli', '19111991', 'Bay', 'Bekar', 'Tecilli', '05378726708', '05378726708', 'osman_trs1967@hotmail.com', 'samsun', '16-08-2014', '5323_ped-2.jpg'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `iletisim` -- CREATE TABLE IF NOT EXISTS `iletisim` ( `id` int(11) NOT NULL AUTO_INCREMENT, `isim` text COLLATE utf8_turkish_ci NOT NULL, `mail` text COLLATE utf8_turkish_ci NOT NULL, `telefon` varchar(255) COLLATE utf8_turkish_ci NOT NULL, `konu` varchar(255) COLLATE utf8_turkish_ci NOT NULL, `mesaj` text COLLATE utf8_turkish_ci NOT NULL, `tarih` varchar(255) COLLATE utf8_turkish_ci NOT NULL, `durum` text COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=18 ; -- -- Tablo döküm verisi `iletisim` -- INSERT INTO `iletisim` (`id`, `isim`, `mail`, `telefon`, `konu`, `mesaj`, `tarih`, `durum`) VALUES (17, 'osman fatsa', 'osman_trs1967@hotmail.com', '05378726708', 'konu', 'mesaj', '24-12-2014', '2'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `sayfalar` -- CREATE TABLE IF NOT EXISTS `sayfalar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `adi` text COLLATE utf8_turkish_ci NOT NULL, `sira` int(11) NOT NULL, `aciklama` longtext COLLATE utf8_turkish_ci NOT NULL, `resim` text COLLATE utf8_turkish_ci NOT NULL, `durum` int(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=3 ; -- -- Tablo döküm verisi `sayfalar` -- INSERT INTO `sayfalar` (`id`, `adi`, `sira`, `aciklama`, `resim`, `durum`) VALUES (1, 'Hakkımızda', 1, '

Lorem ipsum dolor sit amet, consectetur adipiscing elit.Sed non egestas eros.Nunc mollis turpis et libero suscipit ornare.Quisque at erat id neque semper lacinia imperdiet at leo.Nam ut venenatis neque, a blandit turpis.Phasellus diam libero, porttitor vitae consectetur eget, tincidunt ut velit.Integer vel urna eget velit ultricies pellentesque a vel ipsum.Vivamus luctus ac tortor consectetur vehicula.

\r\n\r\n

In consequat leo a consectetur interdum.Pellentesque molestie, lacus non tincidunt sodales, risus elit aliquam metus, eu congue libero elit quis diam.Proin vitae tempus mauris, quis pharetra massa.In congue neque malesuada arcu fringilla scelerisque.In convallis ac odio eu cursus.Nullam enim odio, ultrices pretium adipiscing in , mattis ut odio.Phasellus vestibulum justo dapibus, egestas neque ut, tincidunt urna.Sed ultrices nec purus id convallis.Proin suscipit a justo id rutrum.Nunc enim purus, interdum quis magna a, mattis aliquet nunc.Suspendisse vitae felis dapibus, porta odio id, pulvinar arcu.Nullam luctus congue iaculis.Nulla ac tortor elementum ligula semper tincidunt.

\r\n\r\n

Donec et erat quis orci sollicitudin pharetra convallis sed mauris.Curabitur tempus suscipit metus ac mattis.Sed libero justo, vulputate nec felis sit amet, cursus sodales eros.Mauris eget ultricies est, ut vehicula mauris.Aenean ultrices, massa eget pulvinar posuere, metus sem pharetra ligula, eu eleifend diam nibh vel dui.Quisque sagittis quam ac leo auctor, ut porttitor sapien euismod.Donec sed tincidunt orci.Donec feugiat, dolor vel suscipit elementum, justo ipsum pulvinar nunc, sit amet vehicula nulla dui in dui.In in aliquet eros.Aliquam velit sapien, posuere a odio ut, sodales lacinia leo.Donec libero lectus, eleifend placerat feugiat scelerisque, blandit nec velit.Vestibulum eleifend, velit vitae porta accumsan, metus nunc bibendum mauris, at pulvinar erat felis eget odio.Morbi in nibh turpis.

\r\n\r\n

Nam vestibulum sem varius risus aliquam ultricies.Proin vulputate neque vel feugiat luctus.Ut quis accumsan lacus.Nullam felis mi, aliquam a sem eu, accumsan ornare arcu.Praesent faucibus lorem lectus, id porttitor metus luctus lacinia.In posuere lorem eget sem tristique suscipit.Integer bibendum libero laoreet dolor viverra, a gravida sapien pellentesque.Proin eu arcu mollis elit mollis sodales.Etiam blandit sit amet arcu vitae tincidunt.Aenean vestibulum tristique elit blandit tristique.Morbi pretium felis turpis, nec fringilla nibh mattis id.Donec vel molestie velit.Sed convallis augue eu nunc sagittis, sed gravida erat vehicula.Quisque vel placerat odio.

\r\n', 'kurumsal.jpg', 1), (2, 'İnsan Kaynakları Politikamız', 2, '

Lorem ipsum dolor sit amet, consectetur adipiscing elit.Sed non egestas eros.Nunc mollis turpis et libero suscipit ornare.Quisque at erat id neque semper lacinia imperdiet at leo.Nam ut venenatis neque, a blandit turpis.Phasellus diam libero, porttitor vitae consectetur eget, tincidunt ut velit.Integer vel urna eget velit ultricies pellentesque a vel ipsum.Vivamus luctus ac tortor consectetur vehicula.

\r\n\r\n

In consequat leo a consectetur interdum.Pellentesque molestie, lacus non tincidunt sodales, risus elit aliquam metus, eu congue libero elit quis diam.Proin vitae tempus mauris, quis pharetra massa.In congue neque malesuada arcu fringilla scelerisque.In convallis ac odio eu cursus.Nullam enim odio, ultrices pretium adipiscing in , mattis ut odio.Phasellus vestibulum justo dapibus, egestas neque ut, tincidunt urna.Sed ultrices nec purus id convallis.Proin suscipit a justo id rutrum.Nunc enim purus, interdum quis magna a, mattis aliquet nunc.Suspendisse vitae felis dapibus, porta odio id, pulvinar arcu.Nullam luctus congue iaculis.Nulla ac tortor elementum ligula semper tincidunt.

\r\n\r\n

Donec et erat quis orci sollicitudin pharetra convallis sed mauris.Curabitur tempus suscipit metus ac mattis.Sed libero justo, vulputate nec felis sit amet, cursus sodales eros.Mauris eget ultricies est, ut vehicula mauris.Aenean ultrices, massa eget pulvinar posuere, metus sem pharetra ligula, eu eleifend diam nibh vel dui.Quisque sagittis quam ac leo auctor, ut porttitor sapien euismod.Donec sed tincidunt orci.Donec feugiat, dolor vel suscipit elementum, justo ipsum pulvinar nunc, sit amet vehicula nulla dui in dui.In in aliquet eros.Aliquam velit sapien, posuere a odio ut, sodales lacinia leo.Donec libero lectus, eleifend placerat feugiat scelerisque, blandit nec velit.Vestibulum eleifend, velit vitae porta accumsan, metus nunc bibendum mauris, at pulvinar erat felis eget odio.Morbi in nibh turpis.

\r\n\r\n

Nam vestibulum sem varius risus aliquam ultricies.Proin vulputate neque vel feugiat luctus.Ut quis accumsan lacus.Nullam felis mi, aliquam a sem eu, accumsan ornare arcu.Praesent faucibus lorem lectus, id porttitor metus luctus lacinia.In posuere lorem eget sem tristique suscipit.Integer bibendum libero laoreet dolor viverra, a gravida sapien pellentesque.Proin eu arcu mollis elit mollis sodales.Etiam blandit sit amet arcu vitae tincidunt.Aenean vestibulum tristique elit blandit tristique.Morbi pretium felis turpis, nec fringilla nibh mattis id.Donec vel molestie velit.Sed convallis augue eu nunc sagittis, sed gravida erat vehicula.Quisque vel placerat odio.

\r\n', '15_org.png', 1); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `yonetici` -- CREATE TABLE IF NOT EXISTS `yonetici` ( `yonetici_id` int(11) NOT NULL AUTO_INCREMENT, `yonetici_ad_soyad` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `yonetici_kullanici` char(25) COLLATE utf8_turkish_ci DEFAULT NULL, `yonetici_sifre` char(25) COLLATE utf8_turkish_ci DEFAULT NULL, `yonetici_email` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, `yonetici_son_giris` char(55) COLLATE utf8_turkish_ci DEFAULT NULL, PRIMARY KEY (`yonetici_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ; -- -- Tablo döküm verisi `yonetici` -- INSERT INTO `yonetici` (`yonetici_id`, `yonetici_ad_soyad`, `yonetici_kullanici`, `yonetici_sifre`, `yonetici_email`, `yonetici_son_giris`) VALUES (1, 'Petrol Firma Scripti V8', 'admin', 'admin', 'info@web-ofisi.com', '29.04.2014'); /*!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 */;