GIF89a=( ý' 7IAXKgNgYvYx\%wh&h}týh%ýs%xý}9ýRýý&ý0%ý (ý.ýý5ýSDýý&ýa)ýx5ýý;c*!&r)ï7õ<{4ý3ýH§KoTýýYýaqýýqýýFý !ý ' !ýNETSCAPE2.0 , =( ýýpH,ý$rýl:x(tJýZý,výýzýýxL.:ýýzýnýýý|Nýýýýý~ýýýýýýý& !ý0`9Rý}ýý"ý"a:Sý~xýýýýýýýýgýýýEýýýýýýýRýýýEýýýýBýý ýý8ýýDýýý"ýný ýHýýLýýDkDýBýýýýýDýýýTýýýH ýGýýA Rý |ýým&ýýE8ýSýkGýAýpxýaýýýR2XBýýE8Iýýý6Xý:vT)ý~ýýqýåýý"F~%xý ý 4#Zý0O|-4BsýX:= Qý SalýýyXJ`G&|shýýK3l7ýB|ý$'7J©*0!ýýDýn=ýPýýýýý0`ýRýljýýýýv>ýýý5 ý.69ýødýýýýýnlvý9ýýf{ýýýPbxýl5}ýpýýýýý3aýýýIýOýýýý!>ýýýiýý9ýý#ýý)pýa ½ ý{ý)vmýý%D~6fýýs}RýDýW Eý`!ý ý&L8xý ý{)x`X/>ý}mýýRý*|`Dý=ý_ ^ý5!_&'aýOý7ýcýý`DCx`ý¥ý9ýYýFýýý`?ýý"ý ýn@`ý} lýý@4>ýd S ývýxNýý"@~dýý=ýgýs~Gýýýýýýud &p8Qý)«lXDýýýýA~HýySunýjýýýk*DýLHý] ýýC"JýýXb~ªwSt}6K,ýýqýS:9*:ýýýlý@ý`ýý ý.ìýt9ýSý[©:ýý=`9Nýýýý{¿ýA !Rý:ýýý6ýýxý0ý_ ý;ýýýýýý^ýýý#ýýýý!ýýýýUýýý;0L1ýýýýýp%AýýU,uýý%ýSýý!ýýý~`ýGýýýý ýýý=4ýnpý3ýýýýýýýýýuýuýn|%2ýIýýrý#0ýýJ``8ý@S@5ýýýý^`8Eý]ý.ýSýýý7 ý ý0ýj SýDý zýýýiýSýýýýý!ýýýlýýw9*ýDýIýnEXýýý &AýGoýQfýýFýý;ýýý}ýJýýýýF5ýýQ|ýýýXýýTýýyýýý]ý o ýýC=ýý:ýýýPB@ DýSý(>ýCýx}`ýýxJ,ýàýýp+eE0`ý}`Aý/NEýý ý9@ýýý Hý7ý!%B0`ýl*ýý!8 2ý%ý ý:ý1ý0Eýýux%nP1ý!ýC)ýP81lýxF#¬{ýýýýB0>ýý
Server IP : 217.18.85.50 / Your IP : 18.116.89.70 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/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.8.2 -- https://www.phpmyadmin.net/ -- -- Anamakine: mysql -- Üretim Zamanı: 02 Tem 2018, 19:40:41 -- Sunucu sürümü: 5.7.22 -- PHP Sürümü: 7.2.6 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ı: `default` -- -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `adresses` -- CREATE TABLE `adresses` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `phone1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fax` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `long` double(8,2) DEFAULT NULL, `lat` double(8,2) DEFAULT NULL, `default` tinyint(1) 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 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, `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`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'fff', 'fff', 1, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- 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/img/', 'test', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `galleries` -- CREATE TABLE `galleries` ( `id` int(10) UNSIGNED 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 için tablo yapısı `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2018_07_02_185624_create_categories_table', 1), (2, '2018_07_02_185624_create_folders_table', 1), (3, '2018_07_02_185625_create_adresses_table', 1), (4, '2018_07_02_185625_create_galleries_table', 1), (5, '2018_07_02_185625_create_password_resets_table', 1), (6, '2018_07_02_185625_create_products_table', 1), (7, '2018_07_02_185625_create_references_table', 1), (8, '2018_07_02_185625_create_socials_table', 1), (9, '2018_07_02_185625_create_uploadedfiles_table', 1), (10, '2018_07_02_185625_create_urls_table', 1), (11, '2018_07_02_185625_create_users_table', 1), (12, '2018_07_02_185635_create_foreign_keys', 1); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `password_resets` -- CREATE TABLE `password_resets` ( `id` int(10) UNSIGNED NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` 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ı `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 NOT NULL, `short_detail` text COLLATE utf8mb4_unicode_ci NOT NULL, `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 NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `product_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `gallery_id` int(10) UNSIGNED 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`, `created_at`, `updated_at`, `deleted_at`, `product_type`, `gallery_id`) VALUES (1, 'fff', 'fff', 'fff', 1, 'fff', 'fff', 0, 0, 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, 'fff', 1); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `references` -- CREATE TABLE `references` ( `id` int(10) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `customer` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `gallery_id` int(10) UNSIGNED DEFAULT NULL, `product_id` int(10) UNSIGNED 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 DEFAULT 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 (1, 'test.jpg', NULL, 'original', 1, NULL, 1, NULL, NULL, 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; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) 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; -- -- 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` (`long`); -- -- Tablo için indeksler `categories` -- ALTER TABLE `categories` 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 `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Tablo için indeksler `password_resets` -- ALTER TABLE `password_resets` 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_gallery_id_foreign` (`gallery_id`), ADD KEY `references_product_id_foreign` (`product_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`); -- -- Tablo için indeksler `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`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; -- -- Tablo için AUTO_INCREMENT değeri `categories` -- ALTER TABLE `categories` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Tablo için AUTO_INCREMENT değeri `folders` -- ALTER TABLE `folders` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Tablo için AUTO_INCREMENT değeri `galleries` -- ALTER TABLE `galleries` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Tablo için AUTO_INCREMENT değeri `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- Tablo için AUTO_INCREMENT değeri `password_resets` -- ALTER TABLE `password_resets` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Tablo için AUTO_INCREMENT değeri `products` -- ALTER TABLE `products` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Tablo için AUTO_INCREMENT değeri `references` -- ALTER TABLE `references` 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=2; -- -- Tablo için AUTO_INCREMENT değeri `urls` -- ALTER TABLE `urls` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Tablo için AUTO_INCREMENT değeri `users` -- ALTER TABLE `users` 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 `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Tablo kısıtlamaları `references` -- ALTER TABLE `references` ADD CONSTRAINT `references_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, 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 */;