/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `alisveris_listeleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `alisveris_listeleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `liste_adi` varchar(120) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'Ortak Alışveriş Listesi',
  `liste_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturan_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `tamamlayan_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `tamamlanma_tarihi` datetime(6) DEFAULT NULL,
  `kayit_surumu` int NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_alisveris_listeleri_id_hane` (`id`,`hane_id`),
  KEY `ix_alisveris_listeleri_hane_durum` (`hane_id`,`liste_durumu`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `alisveris_listesi_urunleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `alisveris_listesi_urunleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `alisveris_listesi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `urun_id` bigint DEFAULT NULL,
  `urun_adi_anlik` varchar(250) COLLATE utf8mb4_turkish_ci NOT NULL,
  `miktar` decimal(14,4) NOT NULL DEFAULT '1.0000',
  `olcu_birimi_id` bigint DEFAULT NULL,
  `kullanici_notu` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `oncelik` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'normal',
  `urun_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'bekliyor',
  `ekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `alan_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `alinma_tarihi` datetime(6) DEFAULT NULL,
  `kayit_surumu` int NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_liste_urunleri_id_liste` (`id`,`alisveris_listesi_id`),
  KEY `ix_liste_urunleri_liste_durum` (`alisveris_listesi_id`,`urun_durumu`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `alisveris_oturumlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `alisveris_oturumlari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_cihazi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `market_subesi_id` bigint DEFAULT NULL,
  `gecici_market_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `oturum_durumu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `para_birimi_kodu` varchar(3) COLLATE utf8mb4_turkish_ci NOT NULL,
  `tahmini_ara_toplam` decimal(14,2) NOT NULL DEFAULT '0.00',
  `tahmini_indirim_toplami` decimal(14,2) NOT NULL DEFAULT '0.00',
  `tahmini_genel_toplam` decimal(14,2) NOT NULL DEFAULT '0.00',
  `kasa_toplami` decimal(14,2) DEFAULT NULL,
  `fark_tutari` decimal(14,2) DEFAULT NULL,
  `kayit_surumu` int NOT NULL DEFAULT '1',
  `baslangic_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `bitis_tarihi` datetime(6) DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `kaynak_alisveris_listesi_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_alisveris_oturumlari_kullanici_durum` (`kullanici_id`,`oturum_durumu`,`baslangic_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `alisveris_oturumu_hareketleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `alisveris_oturumu_hareketleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `alisveris_oturumu_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `alisveris_oturumu_urunu_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_cihazi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `islem_uuid` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `islem_turu` varchar(40) COLLATE utf8mb4_turkish_ci NOT NULL,
  `onceki_veri` json DEFAULT NULL,
  `yeni_veri` json DEFAULT NULL,
  `islem_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_alisveris_hareketleri_islem` (`islem_uuid`),
  KEY `ix_alisveris_hareketleri_oturum_tarih` (`alisveris_oturumu_id`,`islem_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `alisveris_oturumu_urunleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `alisveris_oturumu_urunleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `alisveris_oturumu_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `urun_id` bigint DEFAULT NULL,
  `okutulan_barkod` varchar(64) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `urun_adi_anlik` varchar(250) COLLATE utf8mb4_turkish_ci NOT NULL,
  `miktar` decimal(14,4) NOT NULL DEFAULT '1.0000',
  `olcu_birimi_id` bigint DEFAULT NULL,
  `raf_birim_fiyati` decimal(14,4) DEFAULT NULL,
  `beklenen_satir_toplami` decimal(14,2) NOT NULL DEFAULT '0.00',
  `uygulanan_indirim` decimal(14,2) NOT NULL DEFAULT '0.00',
  `kasa_birim_fiyati` decimal(14,4) DEFAULT NULL,
  `kasa_satir_toplami` decimal(14,2) DEFAULT NULL,
  `fiyat_farki` decimal(14,2) DEFAULT NULL,
  `urun_durumu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'sepette',
  `kayit_surumu` int NOT NULL DEFAULT '1',
  `ekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `eklenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `iptal_edilme_tarihi` datetime(6) DEFAULT NULL,
  `kaynak_alisveris_listesi_urun_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_alisveris_oturumu_urunleri_oturum` (`alisveris_oturumu_id`,`urun_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `barkod_cozumleme_profilleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `barkod_cozumleme_profilleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `market_zinciri_id` bigint DEFAULT NULL,
  `profil_adi` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `profil_surumu` int NOT NULL DEFAULT '1',
  `barkod_uzunlugu` smallint NOT NULL,
  `kontrol_hanesi_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'ean_13',
  `gecerlilik_baslangici` date DEFAULT NULL,
  `gecerlilik_bitisi` date DEFAULT NULL,
  `profil_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_barkod_profilleri_id_zincir` (`id`,`market_zinciri_id`),
  UNIQUE KEY `uq_barkod_profilleri_surum` (`market_zinciri_id`,`profil_adi`,`profil_surumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `degisken_barkod_kurallari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `degisken_barkod_kurallari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `barkod_cozumleme_profili_id` bigint NOT NULL,
  `alan_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `baslangic_konumu` smallint NOT NULL,
  `alan_uzunlugu` smallint NOT NULL,
  `ondalik_basamak` smallint NOT NULL DEFAULT '0',
  `sabit_deger` varchar(64) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `siralama` smallint NOT NULL DEFAULT '0',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_degisken_barkod_kurallari_alan` (`barkod_cozumleme_profili_id`,`alan_turu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `denetim_kayitlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `denetim_kayitlari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kullanici_cihazi_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `islem_turu` varchar(60) COLLATE utf8mb4_turkish_ci NOT NULL,
  `tablo_adi` varchar(120) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kayit_kimligi` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `onceki_veri` json DEFAULT NULL,
  `yeni_veri` json DEFAULT NULL,
  `ip_adresi` varchar(45) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `aciklama` longtext COLLATE utf8mb4_turkish_ci,
  `islem_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  KEY `ix_denetim_kayitlari_kullanici_tarih` (`kullanici_id`,`islem_tarihi`),
  KEY `ix_denetim_kayitlari_tabla_kayit` (`tablo_adi`,`kayit_kimligi`,`islem_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `esitleme_islemleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `esitleme_islemleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `islem_uuid` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_cihazi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kayit_turu` varchar(60) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kayit_uuid` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kayit_sayisal_id` bigint DEFAULT NULL,
  `islem_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `beklenen_kayit_surumu` int DEFAULT NULL,
  `istek_verisi` json NOT NULL,
  `istemci_islem_tarihi` datetime(6) NOT NULL,
  `sunucu_islem_tarihi` datetime(6) DEFAULT NULL,
  `islem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `hata_kodu` varchar(80) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `hata_aciklamasi` longtext COLLATE utf8mb4_turkish_ci,
  `sonuc_verisi` json DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `tamamlanma_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_esitleme_islemleri_islem` (`islem_uuid`),
  KEY `ix_esitleme_islemleri_cihaz_durum` (`kullanici_cihazi_id`,`islem_durumu`,`olusturulma_tarihi`),
  KEY `ix_esitleme_islemleri_kullanici_durum` (`kullanici_id`,`islem_durumu`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `connection` text COLLATE utf8mb4_turkish_ci NOT NULL,
  `queue` text COLLATE utf8mb4_turkish_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `fiyat_dogrulamalari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fiyat_dogrulamalari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `fiyat_gozlemi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `dogrulama_turu` varchar(10) COLLATE utf8mb4_turkish_ci NOT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_fiyat_dogrulamalari_kullanici` (`fiyat_gozlemi_id`,`kullanici_id`),
  KEY `ix_fiyat_dogrulamalari_gozlem_tur` (`fiyat_gozlemi_id`,`dogrulama_turu`),
  KEY `ix_fiyat_dogrulamalari_kullanici_tarih` (`kullanici_id`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `fiyat_gozlemleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fiyat_gozlemleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `urun_id` bigint NOT NULL,
  `market_subesi_id` bigint NOT NULL,
  `alisveris_oturumu_urunu_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `fiyat` decimal(14,4) NOT NULL,
  `para_birimi_kodu` varchar(3) COLLATE utf8mb4_turkish_ci NOT NULL,
  `gozlem_tarihi` datetime(6) NOT NULL,
  `gecerlilik_baslangici` datetime(6) DEFAULT NULL,
  `gecerlilik_bitisi` datetime(6) DEFAULT NULL,
  `fiyat_kaynagi` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kaynak_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kampanyali_mi` tinyint(1) NOT NULL DEFAULT '0',
  `kampanya_aciklamasi` longtext COLLATE utf8mb4_turkish_ci,
  `guven_puani` decimal(5,2) NOT NULL DEFAULT '0.00',
  `dogrulama_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `gecersiz_kilma_nedeni` longtext COLLATE utf8mb4_turkish_ci,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_fiyat_gozlemleri_bilesik` (`id`,`urun_id`,`market_subesi_id`),
  KEY `ix_fiyat_gozlemleri_market_tarih` (`market_subesi_id`,`gozlem_tarihi`),
  KEY `ix_fiyat_gozlemleri_urun_market_tarih` (`urun_id`,`market_subesi_id`,`gozlem_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `gecici_marketler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `gecici_marketler` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `olusturan_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `market_adi` varchar(180) COLLATE utf8mb4_turkish_ci NOT NULL,
  `acik_adres` longtext COLLATE utf8mb4_turkish_ci,
  `konum` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kullanici_notu` longtext COLLATE utf8mb4_turkish_ci,
  `eslesen_market_subesi_id` bigint DEFAULT NULL,
  `eslestirme_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_gecici_marketler_id_kullanici` (`id`,`olusturan_kullanici_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `guncel_urun_fiyatlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `guncel_urun_fiyatlari` (
  `urun_id` bigint NOT NULL,
  `market_subesi_id` bigint NOT NULL,
  `fiyat_gozlemi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `guven_puani` decimal(5,2) NOT NULL,
  `son_dogrulama_tarihi` datetime(6) DEFAULT NULL,
  `fiyat_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`urun_id`,`market_subesi_id`),
  UNIQUE KEY `uq_guncel_urun_fiyatlari_gozlem` (`fiyat_gozlemi_id`),
  KEY `ix_guncel_urun_fiyatlari_market` (`market_subesi_id`,`fiyat_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_davetleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_davetleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `davet_kodu` varchar(12) COLLATE utf8mb4_turkish_ci NOT NULL,
  `davet_eden_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kabul_eden_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `davet_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `son_gecerlilik_tarihi` datetime(6) NOT NULL DEFAULT ((now(6) + interval 2 day)),
  `kabul_tarihi` datetime(6) DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_davetleri_kod` (`davet_kodu`),
  KEY `ix_hane_davetleri_kod_durum` (`davet_kodu`,`davet_durumu`,`son_gecerlilik_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_katilim_istekleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_katilim_istekleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `durum` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'bekliyor',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `sonuclandirilma_tarihi` datetime(6) DEFAULT NULL,
  `sonuclandiran_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `bekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_katilim_bekleyen` (`hane_id`,`bekleyen_kullanici_id`),
  KEY `ix_hane_katilim_istekleri_hane_durum` (`hane_id`,`durum`),
  KEY `ix_hane_katilim_istekleri_kullanici_durum` (`kullanici_id`,`durum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_mesaj_durumlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_mesaj_durumlari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_uyesi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `son_okunan_hane_mesaji_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `son_mesaj_okuma_tarihi` datetime(6) DEFAULT NULL,
  `bildirim_sessiz_mi` tinyint(1) NOT NULL DEFAULT '0',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_mesaj_durumlari_uyelik` (`hane_uyesi_id`),
  KEY `ix_hane_mesaj_durumlari_hane` (`hane_id`,`hane_uyesi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_mesaj_resimleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_mesaj_resimleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `yukleme_uuid` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `yukleyen_hane_uyesi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_mesaji_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `disk` varchar(60) COLLATE utf8mb4_turkish_ci NOT NULL,
  `depolama_yolu` varchar(500) COLLATE utf8mb4_turkish_ci NOT NULL,
  `islenmis_dosya_yolu` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kucuk_resim_yolu` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `orijinal_ad` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `mime_turu` varchar(100) COLLATE utf8mb4_turkish_ci NOT NULL,
  `uzanti` varchar(10) COLLATE utf8mb4_turkish_ci NOT NULL,
  `boyut_bayt` bigint NOT NULL,
  `genislik` int NOT NULL,
  `yukseklik` int NOT NULL,
  `sha256` varchar(64) COLLATE utf8mb4_turkish_ci NOT NULL,
  `tarama_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'bekliyor',
  `gecici_mi` tinyint(1) NOT NULL DEFAULT '1',
  `son_kullanma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `mesaja_baglanma_tarihi` datetime(6) DEFAULT NULL,
  `kucuk_resim_genislik` int unsigned DEFAULT NULL,
  `kucuk_resim_yukseklik` int unsigned DEFAULT NULL,
  `kucuk_resim_mime_turu` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kucuk_resim_boyut_bayt` bigint unsigned DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_mesaj_resimleri_depolama_yolu` (`disk`,`depolama_yolu`),
  UNIQUE KEY `uq_hane_mesaj_resimleri_yukleme` (`yukleme_uuid`),
  KEY `ix_hane_mesaj_resimleri_hane` (`hane_id`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_mesaj_gizlemeleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_mesaj_gizlemeleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_mesaji_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `gizlenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_mesaj_gizlemeleri_mesaj_kullanici` (`hane_mesaji_id`,`kullanici_id`),
  KEY `ix_hane_mesaj_gizlemeleri_kullanici_hane` (`kullanici_id`,`hane_id`),
  KEY `ix_hane_mesaj_gizlemeleri_hane_zaman` (`hane_id`,`gizlenme_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_mesajlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_mesajlari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `gonderen_hane_uyesi_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `istemci_mesaj_uuid` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `mesaj_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `icerik` longtext COLLATE utf8mb4_turkish_ci,
  `alisveris_listesi_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `liste_urunu_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `yanitlanan_mesaj_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `baglanti_url` longtext COLLATE utf8mb4_turkish_ci,
  `baglanti_alan_adi` varchar(253) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `liste_adi_anlik` varchar(200) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `listeyi_olusturan_anlik` varchar(160) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `liste_urun_sayisi_anlik` int DEFAULT NULL,
  `duzenlenme_tarihi` datetime(6) DEFAULT NULL,
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_mesajlari_istemci_uuid` (`gonderen_hane_uyesi_id`,`istemci_mesaj_uuid`),
  KEY `ix_hane_mesajlari_akis` (`hane_id`,`olusturulma_tarihi`,`id`),
  KEY `ix_hane_mesajlari_yanitlanan` (`yanitlanan_mesaj_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `hane_uyeleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hane_uyeleri` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `uye_rolu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'uye',
  `uyelik_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `katilma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `ayrilma_tarihi` datetime(6) DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_hane_uyeleri_hane_kullanici` (`hane_id`,`kullanici_id`),
  UNIQUE KEY `uq_hane_uyeleri_id_hane` (`id`,`hane_id`),
  KEY `ix_hane_uyeleri_hane_durum` (`hane_id`,`uyelik_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `haneler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `haneler` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_adi` varchar(120) COLLATE utf8mb4_turkish_ci NOT NULL,
  `olusturan_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `hane_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `katilim_onayi_gerekli` tinyint(1) NOT NULL DEFAULT '0',
  `fotografi_yolu` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `kayit_surumu` int NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_haneler_id` (`id`),
  KEY `ix_haneler_olusturan_durum` (`olusturan_kullanici_id`,`hane_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ilceler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ilceler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sehir_id` int NOT NULL,
  `ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `aktif_mi` tinyint(1) NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `ilceler_id_sehir_id_key` (`id`,`sehir_id`),
  KEY `ix_ilceler_normalize_ad` (`normalize_ad`),
  KEY `ix_ilceler_sehir` (`sehir_id`,`aktif_mi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_turkish_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `kullanici_cihazlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kullanici_cihazlari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `cihaz_uuid` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `cihaz_adi` varchar(150) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `cihaz_turu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL,
  `isletim_sistemi` varchar(40) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `isletim_sistemi_surumu` varchar(40) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `uygulama_surumu` varchar(40) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `bildirim_anahtari` longtext COLLATE utf8mb4_turkish_ci,
  `son_giris_tarihi` datetime(6) DEFAULT NULL,
  `son_esitleme_tarihi` datetime(6) DEFAULT NULL,
  `cihaz_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `iptal_edilme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_kullanici_cihazlari_cihaz` (`kullanici_id`,`cihaz_uuid`),
  UNIQUE KEY `uq_kullanici_cihazlari_id_kullanici` (`id`,`kullanici_id`),
  KEY `ix_kullanici_cihazlari_kullanici` (`kullanici_id`,`cihaz_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `kullanici_oturumlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kullanici_oturumlari` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kullanici_cihazi_id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `anahtar_ozeti` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ip_adresi` varchar(45) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `son_kullanim_tarihi` datetime(6) DEFAULT NULL,
  `son_gecerlilik_tarihi` datetime(6) DEFAULT NULL,
  `oturum_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `iptal_edilme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `kullanici_oturumlari_anahtar_ozeti_key` (`anahtar_ozeti`),
  KEY `ix_kullanici_oturumlari_kullanici` (`kullanici_id`,`oturum_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `kullanicilar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kullanicilar` (
  `id` char(36) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ad` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `soyad` varchar(80) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `telefon_normalize` varchar(20) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `eposta_normalize` varchar(254) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `lika_subject` varchar(191) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `profil_fotografi_url` varchar(2048) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `sifre_ozeti` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `telefon_dogrulandi_mi` tinyint(1) NOT NULL DEFAULT '0',
  `eposta_dogrulandi_mi` tinyint(1) NOT NULL DEFAULT '0',
  `hesap_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `son_giris_tarihi` datetime(6) DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_kullanicilar_lika_subject` (`lika_subject`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `mahalleler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mahalleler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sehir_id` int NOT NULL,
  `ilce_id` int NOT NULL,
  `ad` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_ad` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `posta_kodu` varchar(10) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kaynak_semt_id` int DEFAULT NULL,
  `aktif_mi` tinyint(1) NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_mahalleler_id_ilce_sehir` (`id`,`ilce_id`,`sehir_id`),
  KEY `ix_mahalleler_ilce` (`ilce_id`,`aktif_mi`),
  KEY `ix_mahalleler_normalize_ad` (`normalize_ad`),
  KEY `ix_mahalleler_sehir` (`sehir_id`,`aktif_mi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `markalar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `markalar` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `marka_adi` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_marka_adi` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `market_sube_fotograflari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `market_sube_fotograflari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `market_subesi_id` bigint DEFAULT NULL,
  `gecici_market_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `url` varchar(1000) COLLATE utf8mb4_turkish_ci NOT NULL,
  `aciklama` varchar(250) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `ana_fotograf_mi` tinyint(1) NOT NULL DEFAULT '0',
  `kaynak` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  KEY `ix_market_sube_fotograflari_sube_ana` (`market_subesi_id`,`ana_fotograf_mi`),
  KEY `ix_market_sube_fotograflari_gecici_market` (`gecici_market_id`,`olusturulma_tarihi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `market_subeleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `market_subeleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `market_zinciri_id` bigint DEFAULT NULL,
  `sube_adi` varchar(180) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_sube_adi` varchar(180) COLLATE utf8mb4_turkish_ci NOT NULL,
  `telefon` varchar(30) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `acik_adres` longtext COLLATE utf8mb4_turkish_ci,
  `konum` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `market_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'market',
  `dogrulama_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `ekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  `sube_kodu` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `normalize_acik_adres` varchar(1000) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `il` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `ilce` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `posta_kodu` varchar(20) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `sehir_id` int DEFAULT NULL,
  `ilce_id` int DEFAULT NULL,
  `mahalle_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_market_subeleri_normalize_ad` (`normalize_sube_adi`),
  KEY `ix_market_subeleri_normalize_adres` (`normalize_acik_adres`(768)),
  KEY `ix_market_subeleri_sehir_ilce_mahalle` (`sehir_id`,`ilce_id`,`mahalle_id`),
  KEY `ix_market_subeleri_zincir` (`market_zinciri_id`,`sistem_durumu`),
  KEY `ix_market_subeleri_zincir_il_ilce` (`market_zinciri_id`,`il`,`ilce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `market_urun_kodlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `market_urun_kodlari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `market_zinciri_id` bigint NOT NULL,
  `barkod_cozumleme_profili_id` bigint DEFAULT NULL,
  `market_urun_kodu` varchar(64) COLLATE utf8mb4_turkish_ci NOT NULL,
  `urun_id` bigint NOT NULL,
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_market_urun_kodlari` (`market_zinciri_id`,`market_urun_kodu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `marketler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `marketler` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `zincir_adi` varchar(180) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_zincir_adi` varchar(180) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ticari_unvan` varchar(250) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  `zincir_kodu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL,
  `zincir_turu` varchar(40) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'zincir',
  `logo_url` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `marka_rengi` varchar(7) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `web_adresi` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_market_zincirleri_kod` (`zincir_kodu`),
  KEY `ix_market_zincirleri_durum` (`sistem_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `olcu_birimleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `olcu_birimleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `olcu_birimi_kodu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `olcu_birimi_adi` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `fiziksel_buyukluk_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `temel_birim_mi` tinyint(1) NOT NULL DEFAULT '0',
  `temel_birime_katsayi` decimal(20,8) NOT NULL DEFAULT '1.00000000',
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `olcu_birimleri_olcu_birimi_kodu_key` (`olcu_birimi_kodu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `para_birimleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `para_birimleri` (
  `kod` varchar(3) COLLATE utf8mb4_turkish_ci NOT NULL,
  `para_birimi_adi` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `sembol` varchar(8) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ondalik_basamak` smallint NOT NULL DEFAULT '2',
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`kod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` text COLLATE utf8mb4_turkish_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_turkish_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_turkish_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sehirler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sehirler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ulke_id` int DEFAULT NULL,
  `ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `plaka_kodu` int DEFAULT NULL,
  `telefon_alan_kodu` int DEFAULT NULL,
  `aktif_mi` tinyint(1) NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  KEY `ix_sehirler_normalize_ad` (`normalize_ad`),
  KEY `ix_sehirler_ulke` (`ulke_id`,`aktif_mi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_turkish_ci,
  `payload` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sube_eslestirme_adaylari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sube_eslestirme_adaylari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sube_kaynak_kaydi_id` bigint NOT NULL,
  `market_subesi_id` bigint NOT NULL,
  `ad_benzerlik_puani` decimal(5,2) NOT NULL,
  `adres_benzerlik_puani` decimal(5,2) NOT NULL,
  `konum_mesafesi_metre` decimal(12,2) DEFAULT NULL,
  `toplam_puan` decimal(5,2) NOT NULL,
  `durum` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'bekliyor',
  `inceleyen_kullanici_id` bigint DEFAULT NULL,
  `incelenme_tarihi` datetime(6) DEFAULT NULL,
  `inceleme_notu` varchar(500) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `sube_eslestirme_adaylari_sube_kaynak_kaydi_id_market_subesi_key` (`sube_kaynak_kaydi_id`,`market_subesi_id`),
  KEY `ix_sube_eslestirme_kaynak_durum` (`sube_kaynak_kaydi_id`,`durum`),
  KEY `ix_sube_eslestirme_puan` (`toplam_puan`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sube_kaynak_kayitlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sube_kaynak_kayitlari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `market_zinciri_id` bigint NOT NULL,
  `eslesen_market_subesi_id` bigint DEFAULT NULL,
  `kaynak` varchar(100) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kaynak_kodu` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `sube_adi` varchar(200) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_sube_adi` varchar(200) COLLATE utf8mb4_turkish_ci NOT NULL,
  `acik_adres` longtext COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_acik_adres` varchar(1000) COLLATE utf8mb4_turkish_ci NOT NULL,
  `il` varchar(100) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ilce` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `enlem` decimal(10,7) DEFAULT NULL,
  `boylam` decimal(10,7) DEFAULT NULL,
  `fotograf_url` varchar(1000) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `ham_veri` json DEFAULT NULL,
  `durum` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'bekliyor',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `sehir_id` int DEFAULT NULL,
  `ilce_id` int DEFAULT NULL,
  `mahalle_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sube_kaynak_kayitlari_market_zinciri_id_kaynak_kaynak_kodu_key` (`market_zinciri_id`,`kaynak`,`kaynak_kodu`),
  KEY `ix_sube_kaynak_normalize_ad` (`normalize_sube_adi`),
  KEY `ix_sube_kaynak_normalize_adres` (`normalize_acik_adres`(768)),
  KEY `ix_sube_kaynak_sehir_ilce_mahalle` (`sehir_id`,`ilce_id`,`mahalle_id`),
  KEY `ix_sube_kaynak_zincir_durum` (`market_zinciri_id`,`durum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ulkeler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ulkeler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_ad` varchar(128) COLLATE utf8mb4_turkish_ci NOT NULL,
  `iso_kodu_2` varchar(2) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `iso_kodu_3` varchar(3) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `telefon_kodu` varchar(10) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `para_birimi` varchar(3) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `aktif_mi` tinyint(1) NOT NULL DEFAULT '1',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  KEY `ix_ulkeler_normalize_ad` (`normalize_ad`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `urun_aileleri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `urun_aileleri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `marka_id` bigint DEFAULT NULL,
  `aile_adi` varchar(200) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_aile_adi` varchar(200) COLLATE utf8mb4_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8mb4_turkish_ci,
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `urun_barkodlari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `urun_barkodlari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `urun_id` bigint NOT NULL,
  `barkod` varchar(64) COLLATE utf8mb4_turkish_ci NOT NULL,
  `barkod_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `ana_barkod_mu` tinyint(1) NOT NULL DEFAULT '0',
  `barkod_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `onay_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `ekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_urun_barkodlari_barkod` (`barkod`),
  KEY `ix_barkod_urun_durum` (`urun_id`,`barkod_durumu`,`onay_durumu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `urun_karsilastirma_gruplari`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `urun_karsilastirma_gruplari` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `grup_adi` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `grup_kodu` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `fiziksel_buyukluk_turu` varchar(30) COLLATE utf8mb4_turkish_ci NOT NULL,
  `temel_olcu_birimi_id` bigint NOT NULL,
  `aciklama` longtext COLLATE utf8mb4_turkish_ci,
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `urun_karsilastirma_gruplari_grup_kodu_key` (`grup_kodu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `urun_kategorileri`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `urun_kategorileri` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `ust_kategori_id` bigint DEFAULT NULL,
  `kategori_adi` varchar(150) COLLATE utf8mb4_turkish_ci NOT NULL,
  `kategori_kodu` varchar(80) COLLATE utf8mb4_turkish_ci NOT NULL,
  `aciklama` longtext COLLATE utf8mb4_turkish_ci,
  `siralama` int NOT NULL DEFAULT '0',
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `urun_kategorileri_kategori_kodu_key` (`kategori_kodu`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `urunler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `urunler` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `urun_ailesi_id` bigint DEFAULT NULL,
  `urun_karsilastirma_grubu_id` bigint DEFAULT NULL,
  `marka_id` bigint DEFAULT NULL,
  `kategori_id` bigint DEFAULT NULL,
  `urun_adi` varchar(250) COLLATE utf8mb4_turkish_ci NOT NULL,
  `normalize_urun_adi` varchar(250) COLLATE utf8mb4_turkish_ci NOT NULL,
  `net_miktar` decimal(14,4) DEFAULT NULL,
  `olcu_birimi_id` bigint DEFAULT NULL,
  `ambalaj_turu` varchar(60) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `aciklama` longtext COLLATE utf8mb4_turkish_ci,
  `onay_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'beklemede',
  `sistem_durumu` varchar(20) COLLATE utf8mb4_turkish_ci NOT NULL DEFAULT 'aktif',
  `ekleyen_kullanici_id` char(36) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `birlestirilen_urun_id` bigint DEFAULT NULL,
  `olusturulma_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `guncellenme_tarihi` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `silinme_tarihi` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_urunler_arama` (`normalize_urun_adi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_turkish_ci NOT NULL,
  `panel_erisimi_var_mi` tinyint(1) NOT NULL DEFAULT '1',
  `remember_token` varchar(100) COLLATE utf8mb4_turkish_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_turkish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'0001_01_01_000000_create_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2,'0001_01_01_000001_create_cache_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'0001_01_01_000002_create_jobs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2026_08_06_011231_create_personal_access_tokens_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2026_08_20_234800_add_api_performance_indexes',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2026_08_21_233000_add_panel_erisimi_to_users_table',3);