| Server IP : 217.18.85.50 / Your IP : 3.147.82.108 Web Server : LiteSpeed System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64 User : ferhatgenc ( ) PHP Version : 7.2.34 Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/ferhatgenc/www/old/ |
Upload File : |
-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Anamakine: 127.0.0.1
-- Üretim Zamanı: 16 Eyl 2018, 23:56:43
-- Sunucu sürümü: 10.1.31-MariaDB
-- PHP Sürümü: 7.2.3
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ı: `gencpf`
--
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `adresses`
--
CREATE TABLE `adresses` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
`address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone1` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone1_humanr` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ekrana basılacak format',
`phone2` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone2_humanr` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ekrana basılacak format',
`fax` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fax_humanr` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ekrana basılacak format',
`email1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lng` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lat` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`default` tinyint(1) NOT NULL DEFAULT '0',
`ordernum` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `adresses`
--
INSERT INTO `adresses` (`id`, `title`, `address`, `phone1`, `phone1_humanr`, `phone2`, `phone2_humanr`, `fax`, `fax_humanr`, `email1`, `email2`, `lng`, `lat`, `default`, `ordernum`, `created_at`, `updated_at`) VALUES
(1, 'OFİS', 'Çarşı Mahallesi Ceviz Altı Sokak Yavuz Selim İş Merkezi Kat:1 No:72 Ortahisar / Trabzon', '00904623230002', '0 (462) 323 00 02', '00905070184101', '0 (507) 018 41 01', '00904623230002', '0 (462) 323 00 02', 'info@gencprefabrik.com', NULL, '39.72296', '41.005662', 1, 0, '2018-09-11 18:58:20', '2018-09-11 19:06:38'),
(2, 'SHOWROOM', 'Kaleköy Mahallesi Sahil Yolu Üzeri Çarşıbaşı / Trabzon', '00904623230002', '0 (462) 323 00 02', '00905070184101', '0 (507) 018 41 01', '00904623230002', '0 (462) 323 00 02', 'info@gencprefabrik.com', NULL, '39.352094', '41.071427', 0, 2, '2018-09-11 19:06:09', '2018-09-11 19:06:09'),
(3, 'ÜRETİM TESİSİ', 'Derecik Karaman Mahallesi Atatürk Caddesi No:16 Akçaabat / Trabzon', '00904622494944', '0 (462) 249 49 44', '00905070184101', '0 (507) 018 41 01', NULL, NULL, 'info@gencprefabrik.com', NULL, '39.6034766', '40.9502598', 0, 3, '2018-09-11 19:12:54', '2018-09-11 19:12:54');
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `categories`
--
CREATE TABLE `categories` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`ordernum` smallint(6) NOT NULL,
`category_id` int(11) DEFAULT NULL,
`image` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `categories`
--
INSERT INTO `categories` (`id`, `title`, `slug`, `ordernum`, `category_id`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Prefabrik Evler', 'prefabrik-evler', 1, 0, 86, '2018-07-05 16:52:40', '2018-09-02 11:53:50', NULL),
(2, 'Çelik Evler', 'celik-evler', 2, 0, 0, '2018-07-05 16:55:42', '2018-07-05 16:55:42', NULL),
(3, 'Konteynerler', 'konteynerler', 3, 0, 0, '2018-07-05 16:56:40', '2018-07-05 16:56:40', NULL),
(4, 'Ofisler', 'ofisler', 4, 0, 0, '2018-07-05 17:01:27', '2018-07-05 17:01:27', NULL),
(5, 'Hangarlar', 'hangarlar', 5, 0, 0, '2018-07-05 17:01:57', '2018-07-05 17:01:57', NULL),
(6, 'Diğer Ürünler', 'diger-urunler', 6, 0, 0, '2018-07-05 17:02:19', '2018-07-05 17:02:19', NULL),
(7, 'Tek Katlı Prefabrik Evler', 'tek-katli-prefabrik-evler', 1, 1, 0, '2018-07-05 17:02:51', '2018-07-05 17:04:22', NULL),
(8, 'Çift Katlı Prefabrik Evler', 'cift-katli-prefabrik-evler', 2, 1, 0, '2018-07-05 17:03:14', '2018-07-05 17:04:35', NULL),
(9, 'Tek Katlı Çelik Evler', 'tek-katli-celik-evler', 1, 2, 0, '2018-07-05 17:03:42', '2018-07-05 17:04:52', NULL),
(10, 'Çift Katlı Çelik Evler', 'cift-katli-celik-evler', 2, 2, 0, '2018-07-05 17:04:04', '2018-07-05 17:04:04', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `configs`
--
CREATE TABLE `configs` (
`id` int(10) UNSIGNED NOT NULL,
`config_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`config_value` text COLLATE utf8mb4_unicode_ci,
`config_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`params` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `configs`
--
INSERT INTO `configs` (`id`, `config_key`, `config_value`, `config_type`, `params`) VALUES
(1, 'vitrin', '[\"1\",\"3\",\"4\",\"5\",\"6\",\"7\"]', NULL, NULL),
(2, 'contact.socialmedia', '{\"fb\":\"https:\\/\\/www.facebook.com\\/gencprefabrik\",\"tw\":null,\"yt\":null,\"in\":null,\"vi\":null,\"gp\":\"deneme\"}', NULL, NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `contents`
--
CREATE TABLE `contents` (
`id` int(10) UNSIGNED NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`short_detail` text COLLATE utf8mb4_unicode_ci,
`detail` text COLLATE utf8mb4_unicode_ci,
`image` int(11) DEFAULT NULL,
`ctype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `content_sitemap`
--
CREATE TABLE `content_sitemap` (
`content_id` int(11) NOT NULL,
`sitemap_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `folders`
--
CREATE TABLE `folders` (
`id` int(10) UNSIGNED NOT NULL,
`path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `folders`
--
INSERT INTO `folders` (`id`, `path`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'uploads/urun_GP10052/', 'urun_GP10052', '2018-07-25 15:25:59', '2018-07-25 15:25:59', NULL),
(2, 'uploads/urun_GP10034/', 'urun_GP10034', '2018-08-05 11:28:05', '2018-08-05 11:28:05', NULL),
(4, 'uploads/galleries/3/', '3', '2018-08-25 21:03:10', '2018-08-25 21:03:10', NULL),
(5, 'uploads/galleries/1/', '1', '2018-08-26 17:16:19', '2018-08-26 17:16:19', NULL),
(6, 'uploads/galleries/2/', '2', '2018-08-30 17:53:29', '2018-08-30 17:53:29', NULL),
(7, 'uploads/galleries/5/', '5', '2018-08-31 18:09:31', '2018-08-31 18:09:31', NULL),
(8, 'uploads/kategoriler/', '1-image.jpg', '2018-09-02 11:53:50', '2018-09-02 11:53:50', NULL),
(9, 'uploads/galleries/8/', '8', '2018-09-10 17:45:49', '2018-09-10 17:45:49', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `galleries`
--
CREATE TABLE `galleries` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`gallery_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_type` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`model_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `galleries`
--
INSERT INTO `galleries` (`id`, `title`, `gallery_type`, `model_type`, `model_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Genel Galeri', 'general', NULL, NULL, '2018-08-05 14:10:51', '2018-08-21 22:00:02', NULL),
(2, 'Prefabrik Evler', 'product_category', 'App\\Models\\Category', 1, NULL, '2018-08-25 20:15:23', NULL),
(3, 'Deneme', 'product_category', 'App\\Models\\Category', 3, '2018-08-25 20:22:19', '2018-08-25 20:22:19', NULL),
(4, 'Ofisler', 'product_category', 'App\\Models\\Category', 4, '2018-08-30 17:31:52', '2018-08-30 17:31:52', NULL),
(5, 'Hangarlar', 'product_category', 'App\\Models\\Category', 5, '2018-08-30 17:31:58', '2018-08-30 17:31:58', NULL),
(6, '102m² Prefabrik Ev', 'product', 'App\\Models\\Product', 1, '2018-08-30 17:47:48', '2018-08-30 17:47:48', NULL),
(7, '130m² Prefabrik Ev', 'product', 'App\\Models\\Product', 4, '2018-08-30 17:48:37', '2018-08-30 17:48:37', NULL),
(8, 'Deneme referans', 'reference_gallery', 'App\\Models\\Reference', 1, '2018-09-04 20:53:38', '2018-09-04 20:53:38', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `messages`
--
CREATE TABLE `messages` (
`id` int(11) NOT NULL,
`subject` varchar(1000) DEFAULT NULL,
`mail` varchar(1000) DEFAULT NULL,
`ip` varchar(50) DEFAULT NULL,
`data` text NOT NULL,
`is_read` int(11) NOT NULL DEFAULT '0',
`is_deleted` int(11) NOT NULL DEFAULT '0',
`file` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Tablo döküm verisi `messages`
--
INSERT INTO `messages` (`id`, `subject`, `mail`, `ip`, `data`, `is_read`, `is_deleted`, `file`, `created_at`, `updated_at`, `deleted_at`) VALUES
(8, 'Genç Prefabrik - İletişim Formu', 'erayera@gmail.com', '127.0.0.1', '{\"Ad Soyad\":\"Eray DEM\\u0130REL\",\"E-Posta\":\"erayera@gmail.com\",\"Telefon\":\"5436187991\",\"Firma Ad\\u0131\":\"SunEra\",\"\\u0130leti\":\"Ankara beni bulsun.\",\"IP\":\"127.0.0.1\"}', 0, 0, 0, '2018-09-16 18:50:21', '2018-09-16 18:50:21', NULL),
(9, 'Genç Prefabrik - İletişim Formu', 'erayera@gmail.com', '127.0.0.1', '{\"Ad Soyad\":\"Eray DEM\\u0130REL\",\"E-Posta\":\"erayera@gmail.com\",\"Telefon\":\"5436187991\",\"Firma Ad\\u0131\":\"SunEra\",\"\\u0130leti\":\"Ankara beni bulsun.\",\"IP\":\"127.0.0.1\"}', 0, 0, 0, '2018-09-16 18:51:24', '2018-09-16 18:51:24', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `products`
--
CREATE TABLE `products` (
`id` int(10) UNSIGNED NOT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`category_id` int(10) UNSIGNED DEFAULT NULL,
`detail` text COLLATE utf8mb4_unicode_ci,
`short_detail` text COLLATE utf8mb4_unicode_ci,
`balconies` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`salons` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`rooms` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`floors` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`bathrooms` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`area` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`const_time` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`uploadedfile_id` int(10) UNSIGNED DEFAULT NULL,
`product_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gallery_id` int(10) UNSIGNED DEFAULT NULL,
`image` int(10) UNSIGNED DEFAULT NULL,
`plan1` int(10) UNSIGNED DEFAULT NULL,
`plan2` int(10) UNSIGNED DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `products`
--
INSERT INTO `products` (`id`, `code`, `title`, `slug`, `category_id`, `detail`, `short_detail`, `balconies`, `salons`, `rooms`, `floors`, `bathrooms`, `area`, `const_time`, `uploadedfile_id`, `product_type`, `gallery_id`, `image`, `plan1`, `plan2`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'GP10052', '102m² Prefabrik Ev', '102-m2-prefabrik-ev-gp10052', 7, NULL, NULL, 1, 1, 3, 1, 1, 102, 15, NULL, NULL, NULL, 22, 23, 24, '2018-07-22 20:35:59', '2018-08-05 13:47:30', NULL),
(3, 'GP10034', '73m² Prefabrik Ev', '73-m2-prefabrik-ev-gp10034', 7, NULL, NULL, 1, 1, 3, 1, 1, 73, 15, NULL, NULL, NULL, 17, NULL, NULL, '2018-07-25 18:01:05', '2018-08-05 12:01:46', NULL),
(4, 'GP10065', '130m² Prefabrik Ev', '130-m2-prefabrik-ev-gp10065', 7, '', NULL, 1, 1, 5, 1, 1, 130, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:03:11', '2018-07-25 18:03:11', NULL),
(5, 'GP10006', '40m² Prefabrik Ev', '40-m2-prefabrik-ev-gp10006', 7, '', NULL, 1, 1, 1, 1, 1, 40, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:04:19', '2018-07-25 18:04:19', NULL),
(6, 'GP10067', '70m² Prefabrik Ev', '70-m2-prefabrik-ev-gp10067', 7, '', NULL, 1, 1, 2, 1, 1, 70, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:11:52', '2018-07-25 18:11:52', NULL),
(7, 'GP10010', '70m² Prefabrik Ev', '70-m2-prefabrik-ev-gp10010', 7, '', NULL, 1, 1, 2, 1, 1, 70, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:12:51', '2018-07-25 18:12:51', NULL),
(8, 'GP10038', '100m² Prefabrik Ev', '100-m2-prefabrik-ev-gp10038', 7, '', NULL, 0, 1, 4, 1, 2, 100, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:15:05', '2018-07-25 18:15:05', NULL),
(9, 'GP10026', '45m² Prefabrik Ev', '45-m2-prefabrik-ev-gp10026', 7, '', NULL, 1, 1, 3, 1, 1, 45, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:16:15', '2018-07-25 18:16:15', NULL),
(10, 'GP10084', '100m² Prefabrik Ev', '100-m2-prefabrik-ev-gp10084', 7, '', NULL, 1, 1, 3, 1, 1, 100, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:17:44', '2018-07-25 18:17:44', NULL),
(11, 'GP10024', '49m² Prefabrik Ev', '49-m2-prefabrik-ev-gp10024', 7, '', NULL, 1, 1, 2, 1, 1, 49, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:20:54', '2018-07-25 18:20:54', NULL),
(12, 'GP10017', '150m² Prefabrik Ev', '150-m2-prefabrik-ev-gp10017', 7, '', NULL, 1, 1, 4, 1, 2, 150, 30, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:22:17', '2018-07-25 18:22:17', NULL),
(13, 'GP10036', '53m² Prefabrik Ev', '53-m2-prefabrik-ev-gp10036', 7, '', NULL, 0, 1, 3, 1, 1, 53, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:24:11', '2018-07-25 18:24:11', NULL),
(14, 'GP10043', '80m² Prefabrik Ev', '80-m2-prefabrik-ev-gp10043', 7, '', NULL, 1, 1, 2, 1, 1, 80, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:27:13', '2018-07-25 18:27:13', NULL),
(15, 'GP10062', '77m² Prefabrik Ev', '77-m2-prefabrik-ev-gp10062', 7, '', NULL, 2, 1, 3, 1, 1, 77, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:28:26', '2018-07-25 18:28:26', NULL),
(16, 'GP10016', '95m² Prefabrik Ev', '95-m2-prefabrik-ev-gp10016', 7, '', NULL, 1, 1, 4, 1, 2, 95, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 18:31:15', '2018-07-25 18:31:15', NULL),
(17, 'GP10046', '90m² Prefabrik Ev', '90-m2-prefabrik-ev-gp10046', 7, '', NULL, 2, 1, 4, 1, 1, 90, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:51:16', '2018-08-01 14:51:16', NULL),
(18, 'GP10040', '80m² Prefabrik Ev', '80-m2-prefabrik-ev-gp10040', 7, '', NULL, 1, 1, 4, 1, 1, 80, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:52:58', '2018-08-01 14:52:58', NULL),
(19, 'GP10035', '89m² Prefabrik Ev', '89-m2-prefabrik-ev-gp10035', 7, '', NULL, 1, 1, 3, 1, 1, 89, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:54:03', '2018-08-01 14:54:03', NULL),
(20, 'GP10081', '166m² Prefabrik Ev', '166-m2-prefabrik-ev-gp10081', 7, '', NULL, 1, 1, 5, 1, 3, 166, 25, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:55:52', '2018-08-01 14:55:52', NULL),
(21, 'GP10044', '129m² Prefabrik Ev', '129-m2-prefabrik-ev-gp10044', 7, '', NULL, 1, 1, 2, 1, 1, 129, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:57:36', '2018-08-01 14:57:36', NULL),
(22, 'GP10072', '77m² Prefabrik Ev', '77-m2-prefabrik-ev-gp10072', 7, '', NULL, 1, 1, 3, 1, 1, 77, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:58:45', '2018-08-01 14:58:45', NULL),
(23, 'GP10061', '70m² Prefabrik Ev', '70-m2-prefabrik-ev-gp10061', 7, '', NULL, 1, 1, 2, 1, 1, 70, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 14:59:36', '2018-08-01 14:59:36', NULL),
(24, 'GP10080', '95m² Prefabrik Ev', '95-m2-prefabrik-ev-gp10080', 7, '', NULL, 1, 1, 4, 1, 1, 95, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:00:45', '2018-08-01 15:00:45', NULL),
(25, 'GP10060', '50m² Prefabrik Ev', '50-m2-prefabrik-ev-gp10060', 7, '', NULL, 1, 1, 2, 1, 1, 50, 10, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:12:22', '2018-08-01 15:12:22', NULL),
(26, 'GP10041', '80m² Prefabrik Ev', '80-m2-prefabrik-ev-gp10041', 7, '', NULL, 1, 1, 3, 1, 1, 80, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:13:30', '2018-08-01 15:13:30', NULL),
(27, 'GP10028', '90m² Prefabrik Ev', '90-m2-prefabrik-ev-gp10028', 7, '', NULL, 1, 1, 3, 1, 1, 90, 15, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:14:20', '2018-08-01 15:14:20', NULL),
(28, 'GP20034', '80m² Dubleks Prefabrik Ev', '80-m2-dubleks-prefabrik-ev-gp20034', 8, '', NULL, 1, 1, 2, 2, 1, 80, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:18:51', '2018-08-01 15:18:51', NULL),
(29, 'GP20008', '105m² Dubleks Prefabrik Ev', '105-m2-dubleks-prefabrik-ev-gp20008', 8, '', NULL, 2, 1, 4, 2, 2, 105, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:20:08', '2018-08-01 15:20:08', NULL),
(30, 'GP20022', '122m² Dubleks Prefabrik Ev', '122-m2-dubleks-prefabrik-ev-gp20022', 8, '', NULL, 3, 1, 4, 2, 2, 122, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:21:19', '2018-08-01 15:21:19', NULL),
(31, 'GP20003', '155m² Dubleks Prefabrik Ev', '155-m2-dubleks-prefabrik-ev-gp20003', 8, '', NULL, 2, 1, 4, 2, 3, 155, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:22:07', '2018-08-01 15:22:07', NULL),
(32, 'GP20064', '86m² Dubleks Prefabrik Ev', '86-m2-dubleks-prefabrik-ev-gp20064', 8, '', NULL, 2, 1, 4, 2, 2, 86, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:23:00', '2018-08-01 15:23:00', NULL),
(33, 'GP20061', '114m² Dubleks Prefabrik Ev', '114-m2-dubleks-prefabrik-ev-gp20061', 8, '', NULL, 2, 1, 4, 2, 2, 114, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:24:11', '2018-08-01 15:24:11', NULL),
(34, 'GP20010', '149m² Dubleks Prefabrik Ev', '149-m2-dubleks-prefabrik-ev-gp20010', 8, '', NULL, 3, 1, 4, 2, 3, 149, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:25:28', '2018-08-01 15:25:28', NULL),
(35, 'GP20065', '158m² Dubleks Prefabrik Ev', '158-m2-dubleks-prefabrik-ev-gp20065', 8, '', NULL, 2, 1, 4, 2, 3, 158, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:26:20', '2018-08-01 15:26:20', NULL),
(36, 'GP20016', '100m² Dubleks Prefabrik Ev', '100-m2-dubleks-prefabrik-ev-gp20016', 8, '', NULL, 2, 1, 3, 2, 2, 100, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:27:26', '2018-08-01 15:27:26', NULL),
(37, 'GP20038', '114m² Dubleks Prefabrik Ev', '114-m2-dubleks-prefabrik-ev-gp20038', 8, '', NULL, 3, 1, 4, 2, 2, 114, 20, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-01 15:28:14', '2018-08-01 15:28:14', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `references`
--
CREATE TABLE `references` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`detail` text COLLATE utf8mb4_unicode_ci,
`customer` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`province` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ngbh` varchar(70) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`completed_at` date DEFAULT NULL,
`service_or_product` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_id` int(10) UNSIGNED DEFAULT NULL,
`service_given` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `references`
--
INSERT INTO `references` (`id`, `title`, `detail`, `customer`, `province`, `ngbh`, `completed_at`, `service_or_product`, `product_id`, `service_given`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Deneme referans', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras aliquam neque nibh, quis congue ligula varius vitae. Nam id rhoncus dui. Quisque nec hendrerit diam. Sed ornare mi hendrerit leo dignissim dictum. Aliquam imperdiet, nibh sit amet tincidunt fringilla, enim massa pulvinar sapien, porta condimentum arcu diam ac lectus. Ut eget orci varius, euismod mi at, fermentum justo. Integer sed nulla sit amet nulla euismod dictum in vitae nibh. Pellentesque non elit at massa placerat finibus. Integer sem eros, molestie non libero at, convallis efficitur sapien. Pellentesque condimentum lectus in euismod fermentum.', 'Eray DEMİREL', 'Saruhanlı / MANİSA', 'İstasyon mah.', '2018-08-01', 'product', 5, NULL, '2018-09-04 20:53:24', '2018-09-10 17:14:47', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `sitemaps`
--
CREATE TABLE `sitemaps` (
`id` int(10) UNSIGNED NOT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `socials`
--
CREATE TABLE `socials` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`icon` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `uploadedfiles`
--
CREATE TABLE `uploadedfiles` (
`id` int(10) UNSIGNED NOT NULL,
`filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_id` int(10) UNSIGNED NOT NULL,
`file_type` enum('original','resized','edited') COLLATE utf8mb4_unicode_ci NOT NULL,
`folder_id` int(10) UNSIGNED DEFAULT NULL,
`gallery_id` int(10) UNSIGNED DEFAULT NULL,
`order` int(10) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Tablo döküm verisi `uploadedfiles`
--
INSERT INTO `uploadedfiles` (`id`, `filename`, `file_id`, `file_type`, `folder_id`, `gallery_id`, `order`, `created_at`, `updated_at`, `deleted_at`) VALUES
(13, 'G9FAuvRssXNXreuJOkJxytzIJvdISPip8gmzVw9C.jpeg', 0, 'original', 1, NULL, 0, '2018-07-25 16:06:23', '2018-07-25 16:06:23', NULL),
(14, '73-m2-prefabrik-ev-gp10034-image.jpg', 0, 'original', 2, NULL, 0, '2018-08-05 11:28:05', '2018-08-05 11:28:05', NULL),
(15, '73-m2-prefabrik-ev-gp10034-image.jpg', 0, 'original', 2, NULL, 0, '2018-08-05 11:29:06', '2018-08-05 11:29:06', NULL),
(16, '73-m2-prefabrik-ev-gp10034-image.jpg', 0, 'original', 2, NULL, 0, '2018-08-05 11:29:57', '2018-08-05 11:29:57', NULL),
(17, '73-m2-prefabrik-ev-gp10034-image.jpg', 0, 'original', 2, NULL, 0, '2018-08-05 12:01:46', '2018-08-05 12:01:46', NULL),
(18, '102-m2-prefabrik-ev-gp10052-image.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 12:04:04', '2018-08-05 12:04:04', NULL),
(19, '102-m2-prefabrik-ev-gp10052-image.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:36:12', '2018-08-05 13:36:12', NULL),
(20, '102-m2-prefabrik-ev-gp10052-image.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:37:11', '2018-08-05 13:37:11', NULL),
(21, '102-m2-prefabrik-ev-gp10052-image.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:44:23', '2018-08-05 13:44:23', NULL),
(22, '102-m2-prefabrik-ev-gp10052-image.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:47:30', '2018-08-05 13:47:30', NULL),
(23, '102-m2-prefabrik-ev-gp10052-plan1.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:47:30', '2018-08-05 13:47:30', NULL),
(24, '102-m2-prefabrik-ev-gp10052-plan2.jpg', 0, 'original', 1, NULL, 0, '2018-08-05 13:47:30', '2018-08-05 13:47:30', NULL),
(29, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-QXuji7.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:44:16', '2018-08-26 19:27:32', '2018-08-26 19:27:32'),
(30, '10926391_788952751184222_4576179368011213165_n-bQ7ckV.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:49:02', '2018-08-26 19:35:39', '2018-08-26 19:35:39'),
(31, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-1OjH4S.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:50:03', '2018-08-26 19:35:36', '2018-08-26 19:35:36'),
(32, '10926391_788952751184222_4576179368011213165_n-vQubHd.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:50:43', '2018-08-26 19:35:34', '2018-08-26 19:35:34'),
(33, '90_3-IFBE2a.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:51:11', '2018-08-26 19:35:12', '2018-08-26 19:35:12'),
(34, '90_2-9QGPOn.jpg', 0, 'original', 5, 1, 0, '2018-08-26 17:54:02', '2018-08-26 19:30:28', '2018-08-26 19:30:28'),
(35, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-IUB2dy.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:36:00', '2018-08-26 19:38:57', '2018-08-26 19:38:57'),
(36, '90_2-0kSFla.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:36:00', '2018-08-26 19:38:55', '2018-08-26 19:38:55'),
(37, '90_3-lzZDbX.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:36:00', '2018-08-26 19:38:59', '2018-08-26 19:38:59'),
(38, '10926391_788952751184222_4576179368011213165_n-ahuJZd.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:36:00', '2018-08-26 19:38:54', '2018-08-26 19:38:54'),
(39, '62824813-minimalist-wallpapers-ZzTHK2.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:40:03', '2018-08-26 19:40:17', '2018-08-26 19:40:17'),
(40, '33442874_2186301098063621_1028200267125882880_n-j41Nn4.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:40:03', '2018-08-26 19:41:17', '2018-08-26 19:41:17'),
(41, '62935167-minimalist-wallpapers-Ehoqyy.png', 0, 'original', 5, 1, 0, '2018-08-26 19:40:03', '2018-08-26 19:41:24', '2018-08-26 19:41:24'),
(42, '62998275-minimalist-wallpapers-1CBkJ9.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:40:03', '2018-08-26 19:41:23', '2018-08-26 19:41:23'),
(43, '63312286-minimalist-wallpapers-B31lzV.png', 0, 'original', 5, 1, 0, '2018-08-26 19:40:04', '2018-08-26 19:41:26', '2018-08-26 19:41:26'),
(44, '63387409-minimalist-wallpapers-FjaL6U.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:40:04', '2018-08-26 19:41:21', '2018-08-26 19:41:21'),
(45, '90_2-u8X3mt.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:41:34', '2018-08-26 19:45:18', '2018-08-26 19:45:18'),
(46, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-fRP63L.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:41:34', '2018-08-26 19:45:29', '2018-08-26 19:45:29'),
(47, '90_3-zXu9dw.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:41:34', '2018-08-26 19:45:25', '2018-08-26 19:45:25'),
(48, '10926391_788952751184222_4576179368011213165_n-6e7Nyw.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:41:34', '2018-08-26 19:45:23', '2018-08-26 19:45:23'),
(49, '62824813-minimalist-wallpapers-F51Fq5.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:44:59', '2018-08-26 19:45:27', '2018-08-26 19:45:27'),
(50, '33442874_2186301098063621_1028200267125882880_n-iC9cwJ.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:44:59', '2018-08-26 19:45:21', '2018-08-26 19:45:21'),
(51, '62935167-minimalist-wallpapers-ttxcZX.png', 0, 'original', 5, 1, 0, '2018-08-26 19:44:59', '2018-08-26 19:45:24', '2018-08-26 19:45:24'),
(52, '62998275-minimalist-wallpapers-ot0GFD.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:44:59', '2018-08-26 19:45:19', '2018-08-26 19:45:19'),
(53, '63312286-minimalist-wallpapers-Yc5G9F.png', 0, 'original', 5, 1, 0, '2018-08-26 19:45:00', '2018-08-26 19:45:20', '2018-08-26 19:45:20'),
(54, '63387409-minimalist-wallpapers-DIydN9.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:00', '2018-08-26 19:45:30', '2018-08-26 19:45:30'),
(55, '62824813-minimalist-wallpapers-gINqza.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:37', '2018-08-26 19:49:45', '2018-08-26 19:49:45'),
(56, '33442874_2186301098063621_1028200267125882880_n-5YdiUH.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:37', '2018-08-26 19:49:48', '2018-08-26 19:49:48'),
(57, '62935167-minimalist-wallpapers-srODad.png', 0, 'original', 5, 1, 0, '2018-08-26 19:45:37', '2018-08-26 19:49:51', '2018-08-26 19:49:51'),
(58, '62998275-minimalist-wallpapers-KmTf7X.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:37', '2018-08-26 19:49:50', '2018-08-26 19:49:50'),
(59, '63312286-minimalist-wallpapers-S0Qakk.png', 0, 'original', 5, 1, 0, '2018-08-26 19:45:38', '2018-08-26 19:49:54', '2018-08-26 19:49:54'),
(60, '63387409-minimalist-wallpapers-CzLaSk.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:38', '2018-08-26 19:49:53', '2018-08-26 19:49:53'),
(61, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-xfkrrj.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:49', '2018-08-26 19:49:56', '2018-08-26 19:49:56'),
(62, '10926391_788952751184222_4576179368011213165_n-xUZjCo.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:45:51', '2018-08-26 19:45:56', '2018-08-26 19:45:56'),
(63, '90_2-EjbSpb.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:56:31', '2018-08-26 19:58:00', '2018-08-26 19:58:00'),
(64, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-WEHTam.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:56:31', '2018-08-26 19:57:57', '2018-08-26 19:57:57'),
(65, '90_2-rMxjRw.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:57:42', '2018-08-26 19:58:02', '2018-08-26 19:58:02'),
(66, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-2qxliE.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:57:42', '2018-08-26 19:57:59', '2018-08-26 19:57:59'),
(67, '90_3-KYbiKM.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:57:42', '2018-08-26 19:58:03', '2018-08-26 19:58:03'),
(68, '10926391_788952751184222_4576179368011213165_n-icKZA1.jpg', 0, 'original', 5, 1, 0, '2018-08-26 19:57:42', '2018-08-26 19:58:05', '2018-08-26 19:58:05'),
(69, '62824813-minimalist-wallpapers-UuhIxY.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:21:13', '2018-08-26 20:21:38', '2018-08-26 20:21:38'),
(70, '33442874_2186301098063621_1028200267125882880_n-NrptTa.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:21:13', '2018-08-26 20:37:28', '2018-08-26 20:37:28'),
(71, '62935167-minimalist-wallpapers-EX5IdT.png', 0, 'original', 5, 1, 0, '2018-08-26 20:21:13', '2018-08-26 20:37:41', '2018-08-26 20:37:41'),
(72, '62998275-minimalist-wallpapers-SP31Lv.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:21:13', '2018-08-26 20:37:45', '2018-08-26 20:37:45'),
(73, '63312286-minimalist-wallpapers-Fp4RkA.png', 0, 'original', 5, 1, 0, '2018-08-26 20:21:14', '2018-08-26 20:37:48', '2018-08-26 20:37:48'),
(74, '63387409-minimalist-wallpapers-WYqugZ.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:21:14', '2018-08-26 20:37:50', '2018-08-26 20:37:50'),
(75, '90_2-LWJoGQ.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:38:05', '2018-08-26 20:38:18', '2018-08-26 20:38:18'),
(76, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-bSayvx.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:38:05', '2018-08-26 20:38:25', '2018-08-26 20:38:25'),
(77, '90_3-MIrApw.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:38:05', '2018-08-26 20:38:22', '2018-08-26 20:38:22'),
(78, '10926391_788952751184222_4576179368011213165_n-1mHof3.jpg', 0, 'original', 5, 1, 0, '2018-08-26 20:38:05', '2018-08-26 20:38:27', '2018-08-26 20:38:27'),
(79, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-rhcXmH.jpg', 0, 'original', 5, 1, 0, '2018-08-28 17:27:52', '2018-08-28 17:28:00', '2018-08-28 17:28:00'),
(80, '10926391_788952751184222_4576179368011213165_n-OmUOzi.jpg', 0, 'original', 6, 2, 0, '2018-08-30 17:53:30', '2018-08-30 17:53:30', NULL),
(81, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-1R07DE.jpg', 0, 'original', 6, 2, 0, '2018-08-30 17:53:39', '2018-08-30 17:53:39', NULL),
(82, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-CCr6OD.jpg', 0, 'original', 5, 1, 0, '2018-08-30 18:20:53', '2018-08-30 18:35:26', '2018-08-30 18:35:26'),
(83, '10926391_788952751184222_4576179368011213165_n-B2PKle.jpg', 0, 'original', 5, 1, 0, '2018-08-30 18:20:53', '2018-08-30 18:20:53', NULL),
(84, '9f73fe12-3805-4ca8-9fbe-0103350c9fd9-gz4iCe.jpg', 0, 'original', 7, 5, 0, '2018-08-31 18:09:31', '2018-08-31 18:09:31', NULL),
(85, '10926391_788952751184222_4576179368011213165_n-nbg9tg.jpg', 0, 'original', 7, 5, 0, '2018-08-31 18:09:34', '2018-08-31 18:09:34', NULL),
(86, '1-image.jpg', 0, 'original', 8, NULL, 0, '2018-09-02 11:53:50', '2018-09-02 11:53:50', NULL),
(87, 'Ekran Görüntüsü (7)-1XMccI.png', 0, 'original', 9, 8, 0, '2018-09-10 17:45:50', '2018-09-14 15:46:36', '2018-09-14 15:46:36'),
(88, 'Ekran Görüntüsü (1)-8c3PMB.png', 0, 'original', 9, 8, 0, '2018-09-10 17:45:59', '2018-09-14 15:46:39', '2018-09-14 15:46:39'),
(89, 'DSC_0111_02-30-23-j7EP7P.jpg', 0, 'original', 9, 8, 0, '2018-09-10 17:46:18', '2018-09-14 15:46:41', '2018-09-14 15:46:41'),
(90, 'DSC_0138-mgnTWz.jpg', 0, 'original', 9, 8, 0, '2018-09-10 17:46:18', '2018-09-14 15:46:43', '2018-09-14 15:46:43'),
(91, 'DSC_0111_02-30-23-cGxL3D.jpg', 0, 'original', 9, 8, 0, '2018-09-14 15:55:07', '2018-09-14 15:55:07', NULL),
(92, 'DSC_0138-BnvGjo.jpg', 0, 'original', 9, 8, 0, '2018-09-14 15:55:07', '2018-09-14 15:55:07', NULL),
(93, 'Ekran Görüntüsü (7)-qZsxlx.png', 0, 'original', 9, 8, 0, '2018-09-14 15:55:16', '2018-09-14 15:55:16', NULL),
(94, 'Ekran Görüntüsü (1)-gAgOHO.png', 0, 'original', 9, 8, 0, '2018-09-14 15:55:16', '2018-09-14 15:55:16', NULL);
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `urls`
--
CREATE TABLE `urls` (
`id` int(10) UNSIGNED NOT NULL,
`url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`url_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` bigint(20) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dökümü yapılmış tablolar için indeksler
--
--
-- Tablo için indeksler `adresses`
--
ALTER TABLE `adresses`
ADD PRIMARY KEY (`id`),
ADD KEY `adresses_long_index` (`lng`);
--
-- Tablo için indeksler `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `configs`
--
ALTER TABLE `configs`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `contents`
--
ALTER TABLE `contents`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `folders`
--
ALTER TABLE `folders`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `galleries`
--
ALTER TABLE `galleries`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `messages`
--
ALTER TABLE `messages`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`),
ADD KEY `products_category_id_foreign` (`category_id`),
ADD KEY `products_gallery_id_foreign` (`gallery_id`);
--
-- Tablo için indeksler `references`
--
ALTER TABLE `references`
ADD PRIMARY KEY (`id`),
ADD KEY `references_product_id_foreign` (`product_id`);
--
-- Tablo için indeksler `sitemaps`
--
ALTER TABLE `sitemaps`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `socials`
--
ALTER TABLE `socials`
ADD PRIMARY KEY (`id`);
--
-- Tablo için indeksler `uploadedfiles`
--
ALTER TABLE `uploadedfiles`
ADD PRIMARY KEY (`id`),
ADD KEY `uploadedfiles_folder_id_foreign` (`folder_id`),
ADD KEY `uploadedfiles_gallery_id_foreign` (`gallery_id`);
--
-- Tablo için indeksler `urls`
--
ALTER TABLE `urls`
ADD PRIMARY KEY (`id`),
ADD KEY `urls_model_type_model_id_index` (`model_type`,`model_id`);
--
-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
--
--
-- Tablo için AUTO_INCREMENT değeri `adresses`
--
ALTER TABLE `adresses`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Tablo için AUTO_INCREMENT değeri `categories`
--
ALTER TABLE `categories`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- Tablo için AUTO_INCREMENT değeri `configs`
--
ALTER TABLE `configs`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- Tablo için AUTO_INCREMENT değeri `contents`
--
ALTER TABLE `contents`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Tablo için AUTO_INCREMENT değeri `folders`
--
ALTER TABLE `folders`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- Tablo için AUTO_INCREMENT değeri `galleries`
--
ALTER TABLE `galleries`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- Tablo için AUTO_INCREMENT değeri `messages`
--
ALTER TABLE `messages`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- Tablo için AUTO_INCREMENT değeri `products`
--
ALTER TABLE `products`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
--
-- Tablo için AUTO_INCREMENT değeri `references`
--
ALTER TABLE `references`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Tablo için AUTO_INCREMENT değeri `sitemaps`
--
ALTER TABLE `sitemaps`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Tablo için AUTO_INCREMENT değeri `socials`
--
ALTER TABLE `socials`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Tablo için AUTO_INCREMENT değeri `uploadedfiles`
--
ALTER TABLE `uploadedfiles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;
--
-- Tablo için AUTO_INCREMENT değeri `urls`
--
ALTER TABLE `urls`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Dökümü yapılmış tablolar için kısıtlamalar
--
--
-- Tablo kısıtlamaları `products`
--
ALTER TABLE `products`
ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `products_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `galleries` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
--
-- Tablo kısıtlamaları `references`
--
ALTER TABLE `references`
ADD CONSTRAINT `references_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
--
-- Tablo kısıtlamaları `uploadedfiles`
--
ALTER TABLE `uploadedfiles`
ADD CONSTRAINT `uploadedfiles_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT `uploadedfiles_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `galleries` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
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 */;