-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 17 Şub 2026, 18:33:09
-- Sunucu sürümü: 10.11.15-MariaDB-cll-lve
-- PHP Sürümü: 8.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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ı: `qqqlgaig_dijiyazilim`
--

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

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

CREATE TABLE `api_logs` (
  `id` int(11) NOT NULL,
  `provider_id` int(11) DEFAULT NULL,
  `action` varchar(50) NOT NULL,
  `request_data` text DEFAULT NULL,
  `response_data` text DEFAULT NULL,
  `http_code` int(11) DEFAULT NULL,
  `error` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `api_providers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `api_url` varchar(255) NOT NULL,
  `api_key` varchar(255) NOT NULL,
  `balance` decimal(12,4) DEFAULT 0.0000,
  `currency` varchar(3) DEFAULT 'USD',
  `rate_multiplier` decimal(5,2) DEFAULT 1.00,
  `status` enum('active','inactive') DEFAULT 'active',
  `description` text DEFAULT NULL,
  `last_sync_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `api_providers` (`id`, `name`, `api_url`, `api_key`, `balance`, `currency`, `rate_multiplier`, `status`, `description`, `last_sync_at`, `created_at`, `updated_at`) VALUES
(1, 'Türkpanel', 'https://turkpaneli.com/api/v2', '40649035b8c998e4503bd2afd3b016b9', 28.7251, 'TRY', 1.40, 'active', NULL, '2026-02-12 15:41:26', '2026-02-10 20:23:50', '2026-02-12 15:41:26');

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

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

CREATE TABLE `api_services` (
  `id` int(10) UNSIGNED NOT NULL,
  `provider_id` int(10) UNSIGNED NOT NULL,
  `service_id` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `rate` decimal(12,4) NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `is_imported` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `api_services` (`id`, `provider_id`, `service_id`, `name`, `category`, `type`, `rate`, `min`, `max`, `description`, `is_imported`, `created_at`) VALUES
(5605, 1, '4177', '🙂 Instagram Bot Takipçi | Max 100K | Anlık Başlar', 'Instagram -  Bot Takipçi Garantisiz', 'Default', 21.0400, 10, 100000, NULL, 0, '2026-02-12 15:41:26');

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

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

CREATE TABLE `bank_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `account_holder` varchar(100) NOT NULL,
  `iban` varchar(34) NOT NULL,
  `branch_code` varchar(20) DEFAULT NULL,
  `account_number` varchar(30) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `bank_accounts` (`id`, `bank_name`, `account_holder`, `iban`, `branch_code`, `account_number`, `logo`, `is_active`, `sort_order`, `created_at`) VALUES
(1, 'Ziraat Bankası', 'ÖRNEK ŞİRKET LTD. ŞTİ.', 'TR00 0000 0000 0000 0000 0000 00', NULL, NULL, NULL, 1, 1, '2026-02-10 19:41:30'),
(2, 'Finansbank', 'ÖRNEK ŞİRKET LTD. ŞTİ.', 'TR00 0000 0000 0000 0000 0000 00', '', '', NULL, 1, 2, '2026-02-10 19:41:30'),
(4, 'Papara', 'Diji yazılım', 'TR42 4242 4242 4242 4242 4242 42', '1234', '12345678', NULL, 1, 0, '2026-02-11 09:30:33');

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

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

CREATE TABLE `campaign_banner` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `text` varchar(500) NOT NULL,
  `icon` varchar(50) DEFAULT 'fas fa-bullhorn',
  `bg_color` varchar(7) DEFAULT '#ef4444',
  `text_color` varchar(7) DEFAULT '#ffffff',
  `link` varchar(500) DEFAULT NULL,
  `link_text` varchar(100) DEFAULT NULL,
  `is_closable` tinyint(1) DEFAULT 1,
  `show_on_mobile` tinyint(1) DEFAULT 1,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `campaign_banner` (`id`, `is_active`, `text`, `icon`, `bg_color`, `text_color`, `link`, `link_text`, `is_closable`, `show_on_mobile`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES
(1, 0, '🔥 Bugüne özel tüm paketlerde %20 indirim! Kod: YENI20', 'fas fa-fire', '#ef4444', '#ffffff', NULL, NULL, 1, 1, NULL, NULL, '2026-02-13 17:23:33', '2026-02-13 17:23:33');

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

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `color` varchar(7) DEFAULT '#6366f1',
  `sort_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `parent_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `icon`, `color`, `sort_order`, `is_active`, `parent_id`, `created_at`) VALUES
(1, 'Instagram', 'instagram', 'Instagram takipçi, beğeni ve izlenme paketleri', 'fab fa-instagram', '#E4405F', 1, 1, NULL, '2026-02-10 19:41:30'),
(2, 'TikTok', 'tiktok', 'TikTok takipçi, beğeni ve izlenme paketleri', 'fab fa-tiktok', '#000000', 2, 1, NULL, '2026-02-10 19:41:30'),
(3, 'YouTube', 'youtube', 'YouTube abone, izlenme ve beğeni paketleri', 'fab fa-youtube', '#FF0000', 3, 1, NULL, '2026-02-10 19:41:30'),
(4, 'Twitter', 'twitter', 'Twitter takipçi, beğeni ve retweet paketleri', 'fab fa-x-twitter', '#1DA1F2', 4, 1, NULL, '2026-02-10 19:41:30'),
(6, 'Telegram', 'telegram', 'Telegram üye paketleri', 'fab fa-telegram', '#0088cc', 5, 1, NULL, '2026-02-10 19:41:30'),
(7, 'Spotify', 'spotify', 'Spotify dinlenme ve takipçi paketleri', 'fab fa-spotify', '#1db954', 6, 1, NULL, '2026-02-10 19:41:30'),
(8, 'Threads', 'threads', 'Threads takipçi ve beğeni paketleri', 'fab fa-threads', '#000000', 7, 1, NULL, '2026-02-10 19:41:30'),
(17, 'Takipçi', 'instagram-takipci', 'Instagram takipçi paketleri', 'fas fa-users', '#E4405F', 1, 1, 1, '2026-02-11 17:13:33'),
(18, 'Beğeni', 'instagram-begeni', 'Instagram beğeni paketleri', 'fas fa-heart', '#E4405F', 2, 1, 1, '2026-02-11 17:13:33'),
(19, 'Görüntülenme', 'instagram-goruntuleme', 'Instagram görüntülenme paketleri', 'fas fa-eye', '#E4405F', 3, 1, 1, '2026-02-11 17:13:33'),
(20, 'Takipçi', 'tiktok-takipci', 'TikTok takipçi paketleri', 'fas fa-users', '#000000', 1, 1, 2, '2026-02-11 17:13:33'),
(21, 'Beğeni', 'tiktok-begeni', 'TikTok beğeni paketleri', 'fas fa-heart', '#000000', 2, 1, 2, '2026-02-11 17:13:33'),
(22, 'İzlenme', 'tiktok-izlenme', 'TikTok izlenme paketleri', 'fas fa-play', '#000000', 3, 1, 2, '2026-02-11 17:13:33'),
(23, 'Abone', 'youtube-abone', 'YouTube abone paketleri', 'fas fa-user-plus', '#FF0000', 1, 1, 3, '2026-02-11 17:13:33'),
(24, 'Beğeni', 'youtube-begeni', 'YouTube beğeni paketleri', 'fas fa-thumbs-up', '#FF0000', 2, 1, 3, '2026-02-11 17:13:33'),
(25, 'İzlenme', 'youtube-izlenme', 'YouTube izlenme paketleri', 'fas fa-eye', '#FF0000', 3, 1, 3, '2026-02-11 17:13:33');

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

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

CREATE TABLE `contact_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `mail_sent` tinyint(1) DEFAULT 0,
  `mail_error` varchar(500) DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `contact_messages` (`id`, `name`, `email`, `subject`, `message`, `ip_address`, `mail_sent`, `mail_error`, `is_read`, `created_at`) VALUES
(1, 'Demo Hesap', 'demo@demo.com', 'İş Birliği', 'Hdhdjfjfnfnfnf', '94.54.242.88', 0, 'SMTP devre dışı', 0, '2026-02-11 12:30:09'),
(2, 'Demo Hesap', 'demo@demo.com', 'İade Talebi', 'Hshsjsjsjsndj', '94.54.242.88', 1, NULL, 0, '2026-02-11 12:34:30'),
(3, 'Alper Aydın', 'alperaydin4209@gmail.com', 'Sipariş Hakkında', 'Deneme test mesajdır', '94.54.242.88', 1, NULL, 0, '2026-02-12 14:40:50');

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

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

CREATE TABLE `coupons` (
  `id` int(11) UNSIGNED NOT NULL,
  `code` varchar(50) NOT NULL COMMENT 'Kupon kodu',
  `discount_type` enum('percent','fixed') NOT NULL DEFAULT 'percent' COMMENT 'İndirim tipi: yüzde veya sabit tutar',
  `discount_value` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'İndirim değeri',
  `min_amount` decimal(10,2) DEFAULT NULL COMMENT 'Minimum sipariş tutarı',
  `max_amount` decimal(10,2) DEFAULT NULL COMMENT 'Maksimum sipariş tutarı',
  `max_discount` decimal(10,2) DEFAULT NULL COMMENT 'Maksimum indirim tutarı (yüzde için)',
  `usage_limit` int(11) DEFAULT NULL COMMENT 'Toplam kullanım limiti',
  `usage_count` int(11) NOT NULL DEFAULT 0 COMMENT 'Toplam kullanım sayısı',
  `usage_limit_per_ip` int(11) DEFAULT 1 COMMENT 'IP başına kullanım limiti',
  `starts_at` datetime DEFAULT NULL COMMENT 'Başlangıç tarihi',
  `expires_at` datetime DEFAULT NULL COMMENT 'Bitiş tarihi',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Aktif mi?',
  `description` text DEFAULT NULL COMMENT 'Açıklama (admin için)',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `coupons` (`id`, `code`, `discount_type`, `discount_value`, `min_amount`, `max_amount`, `max_discount`, `usage_limit`, `usage_count`, `usage_limit_per_ip`, `starts_at`, `expires_at`, `is_active`, `description`, `created_at`, `updated_at`) VALUES
(2, 'R10', 'fixed', 5.00, 5.00, NULL, NULL, NULL, 1, 1, '2026-02-11 23:42:00', '2026-02-11 23:59:00', 1, 'Test Kuponu', '2026-02-11 20:42:24', '2026-02-11 20:56:46'),
(3, 'MERHABA', 'fixed', 20.00, 70.00, NULL, NULL, NULL, 2, 5, NULL, NULL, 1, '', '2026-02-11 20:46:56', '2026-02-12 10:59:42');

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

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

CREATE TABLE `coupon_usage` (
  `id` int(11) UNSIGNED NOT NULL,
  `coupon_id` int(11) UNSIGNED NOT NULL,
  `order_id` int(11) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) NOT NULL,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Uygulanan indirim tutarı',
  `used_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `coupon_usage` (`id`, `coupon_id`, `order_id`, `ip_address`, `discount_amount`, `used_at`) VALUES
(1, 3, 3, '94.54.242.88', 20.00, '2026-02-11 20:50:15'),
(2, 2, 4, '94.54.242.88', 5.00, '2026-02-11 20:56:46'),
(3, 3, 8, '94.54.242.88', 20.00, '2026-02-12 10:59:42');

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

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

CREATE TABLE `cron_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(10) UNSIGNED NOT NULL,
  `log_type` enum('admin_new_order','customer_status','api_check') NOT NULL,
  `status_sent` varchar(50) DEFAULT NULL,
  `email_sent_to` varchar(100) DEFAULT NULL,
  `success` tinyint(1) DEFAULT 1,
  `error_message` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `cron_logs` (`id`, `order_id`, `log_type`, `status_sent`, `email_sent_to`, `success`, `error_message`, `created_at`) VALUES
(23, 1, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-11 17:55:01'),
(24, 1, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 17:55:02'),
(25, 2, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-11 17:56:02'),
(26, 2, 'customer_status', 'processing', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 17:57:02'),
(27, 2, 'customer_status', 'paid', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 17:58:02'),
(28, 2, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 17:59:02'),
(29, 3, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-11 20:51:02'),
(30, 3, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 20:53:01'),
(31, 4, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-11 20:57:02'),
(32, 4, 'customer_status', 'processing', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 21:00:02'),
(33, 3, 'customer_status', 'cancelled', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 21:00:02'),
(34, 4, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-11 21:08:02'),
(35, 5, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 10:48:02'),
(36, 5, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 10:49:01'),
(37, 6, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 10:50:02'),
(38, 7, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 10:53:01'),
(39, 8, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 11:00:02'),
(40, 7, 'customer_status', 'processing', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 11:01:01'),
(41, 8, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 11:01:01'),
(42, 6, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 11:01:02'),
(43, 7, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 11:04:01'),
(44, 9, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 13:59:01'),
(45, 9, 'customer_status', 'completed', 'siberihbar8@gmail.com', 1, NULL, '2026-02-12 14:00:02'),
(46, 10, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 14:22:02'),
(47, 11, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 14:25:02'),
(48, 12, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 14:32:01'),
(49, 13, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-12 14:36:02'),
(50, 13, 'customer_status', 'completed', 'alpydhsm@gmail.com', 1, NULL, '2026-02-12 14:37:01'),
(51, 12, 'customer_status', 'completed', 'blablabaldk@gmail.com', 1, NULL, '2026-02-12 14:37:02'),
(52, 11, 'customer_status', 'completed', 'blblabla@gmail.com', 1, NULL, '2026-02-12 14:37:02'),
(53, 10, 'customer_status', 'completed', 'deneme@gmail.com', 1, NULL, '2026-02-12 14:37:02'),
(54, 14, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-13 18:00:02'),
(55, 15, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-13 18:02:02'),
(56, 16, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-13 18:04:01'),
(57, 17, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-13 18:06:02'),
(58, 16, 'customer_status', 'completed', 'qrdeneme2@gmail.com', 1, NULL, '2026-02-13 18:17:02'),
(59, 17, 'customer_status', 'completed', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-13 18:17:02'),
(60, 16, 'customer_status', 'processing', 'qrdeneme2@gmail.com', 1, NULL, '2026-02-13 18:18:02'),
(61, 14, 'customer_status', 'completed', 'test@gmail.com', 1, NULL, '2026-02-13 18:19:02'),
(62, 15, 'customer_status', 'completed', 'qrdeneme@gmail.com', 1, NULL, '2026-02-13 18:19:02'),
(63, 18, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 17:45:02'),
(64, 18, 'customer_status', 'paid', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 17:46:02'),
(65, 19, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 17:51:01'),
(66, 19, 'customer_status', 'paid', 'siberihbar8@gmail.com', 1, NULL, '2026-02-17 17:51:02'),
(67, 18, 'customer_status', 'processing', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 17:53:02'),
(68, 19, 'customer_status', 'cancelled', 'siberihbar8@gmail.com', 1, NULL, '2026-02-17 17:54:02'),
(69, 18, 'customer_status', 'completed', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 17:56:01'),
(70, 20, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:10:02'),
(71, 22, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:14:02'),
(72, 22, 'customer_status', 'paid', 'siberihbar8@gmail.com', 1, NULL, '2026-02-17 18:14:02'),
(73, 23, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:15:02'),
(74, 24, 'admin_new_order', 'new', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:16:02'),
(75, 23, 'customer_status', 'paid', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:16:03'),
(76, 22, 'customer_status', 'processing', 'siberihbar8@gmail.com', 1, NULL, '2026-02-17 18:20:02'),
(77, 24, 'customer_status', 'processing', 'deneme@gmail.com', 1, NULL, '2026-02-17 18:20:03'),
(78, 23, 'customer_status', 'cancelled', 'alperaydin4209@gmail.com', 1, NULL, '2026-02-17 18:21:02');

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

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

CREATE TABLE `fake_notification_cities` (
  `id` int(11) NOT NULL,
  `city` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `fake_notification_cities` (`id`, `city`, `is_active`, `created_at`) VALUES
(1, 'İstanbul', 1, '2026-02-13 08:35:01'),
(2, 'Ankara', 1, '2026-02-13 08:35:01'),
(3, 'İzmir', 1, '2026-02-13 08:35:01'),
(4, 'Bursa', 1, '2026-02-13 08:35:01'),
(5, 'Antalya', 1, '2026-02-13 08:35:01'),
(6, 'Adana', 1, '2026-02-13 08:35:01'),
(7, 'Konya', 1, '2026-02-13 08:35:01'),
(8, 'Gaziantep', 1, '2026-02-13 08:35:01'),
(9, 'Mersin', 1, '2026-02-13 08:35:01'),
(10, 'Kayseri', 1, '2026-02-13 08:35:01'),
(11, 'Eskişehir', 1, '2026-02-13 08:35:01'),
(12, 'Trabzon', 1, '2026-02-13 08:35:01'),
(13, 'Samsun', 1, '2026-02-13 08:35:01'),
(14, 'Denizli', 1, '2026-02-13 08:35:01'),
(15, 'Malatya', 1, '2026-02-13 08:35:01');

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

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

CREATE TABLE `fake_notification_items` (
  `id` int(11) NOT NULL,
  `platform` varchar(50) NOT NULL,
  `platform_icon` varchar(50) NOT NULL DEFAULT 'fas fa-shopping-cart',
  `platform_color` varchar(20) NOT NULL DEFAULT '#8b5cf6',
  `package_name` varchar(255) NOT NULL,
  `quantity_min` int(11) NOT NULL DEFAULT 100,
  `quantity_max` int(11) NOT NULL DEFAULT 10000,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `fake_notification_items` (`id`, `platform`, `platform_icon`, `platform_color`, `package_name`, `quantity_min`, `quantity_max`, `is_active`, `created_at`) VALUES
(1, 'Instagram', 'fab fa-instagram', '#E4405F', 'Takipçi', 500, 25000, 1, '2026-02-13 08:35:01'),
(2, 'Instagram', 'fab fa-instagram', '#E4405F', 'Beğeni', 100, 5000, 1, '2026-02-13 08:35:01'),
(3, 'Instagram', 'fab fa-instagram', '#E4405F', 'Video İzlenme', 1000, 50000, 1, '2026-02-13 08:35:01'),
(4, 'Instagram', 'fab fa-instagram', '#E4405F', 'Hikaye İzlenme', 500, 10000, 1, '2026-02-13 08:35:01'),
(5, 'TikTok', 'fab fa-tiktok', '#000000', 'Takipçi', 500, 20000, 1, '2026-02-13 08:35:01'),
(6, 'TikTok', 'fab fa-tiktok', '#000000', 'Beğeni', 200, 10000, 1, '2026-02-13 08:35:01'),
(7, 'TikTok', 'fab fa-tiktok', '#000000', 'Video İzlenme', 1000, 100000, 1, '2026-02-13 08:35:01'),
(8, 'YouTube', 'fab fa-youtube', '#FF0000', 'Abone', 100, 5000, 1, '2026-02-13 08:35:01'),
(9, 'YouTube', 'fab fa-youtube', '#FF0000', 'Video İzlenme', 1000, 50000, 1, '2026-02-13 08:35:01'),
(10, 'YouTube', 'fab fa-youtube', '#FF0000', 'Video Beğeni', 100, 5000, 1, '2026-02-13 08:35:01'),
(11, 'Twitter', 'fab fa-twitter', '#1DA1F2', 'Takipçi', 500, 15000, 1, '2026-02-13 08:35:01'),
(12, 'Twitter', 'fab fa-twitter', '#1DA1F2', 'Beğeni', 100, 5000, 1, '2026-02-13 08:35:01'),
(13, 'Spotify', 'fab fa-spotify', '#1DB954', 'Takipçi', 500, 10000, 1, '2026-02-13 08:35:01'),
(14, 'Spotify', 'fab fa-spotify', '#1DB954', 'Dinlenme', 1000, 50000, 1, '2026-02-13 08:35:01'),
(15, 'Telegram', 'fab fa-telegram', '#0088cc', 'Üye', 500, 10000, 1, '2026-02-13 08:35:01');

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

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

CREATE TABLE `fake_notification_names` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `fake_notification_names` (`id`, `name`, `is_active`, `created_at`) VALUES
(1, 'Ahmet Y.', 1, '2026-02-13 08:35:01'),
(2, 'Mehmet K.', 1, '2026-02-13 08:35:01'),
(3, 'Ayşe S.', 1, '2026-02-13 08:35:01'),
(4, 'Fatma D.', 1, '2026-02-13 08:35:01'),
(5, 'Ali R.', 1, '2026-02-13 08:35:01'),
(6, 'Zeynep T.', 1, '2026-02-13 08:35:01'),
(7, 'Mustafa B.', 1, '2026-02-13 08:35:01'),
(8, 'Elif M.', 1, '2026-02-13 08:35:01'),
(9, 'Hasan Ç.', 1, '2026-02-13 08:35:01'),
(10, 'Merve A.', 1, '2026-02-13 08:35:01'),
(11, 'Burak Ö.', 1, '2026-02-13 08:35:01'),
(12, 'Seda K.', 1, '2026-02-13 08:35:01'),
(13, 'Emre Y.', 1, '2026-02-13 08:35:01'),
(14, 'Deniz S.', 1, '2026-02-13 08:35:01'),
(15, 'Can T.', 1, '2026-02-13 08:35:01');

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

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

CREATE TABLE `fake_notification_settings` (
  `id` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `interval_min` int(11) NOT NULL DEFAULT 5,
  `interval_max` int(11) NOT NULL DEFAULT 15,
  `display_duration` int(11) NOT NULL DEFAULT 5,
  `position` enum('bottom-left','bottom-right','top-left','top-right') NOT NULL DEFAULT 'bottom-left',
  `show_on_mobile` tinyint(1) NOT NULL DEFAULT 1,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `fake_notification_settings` (`id`, `is_active`, `interval_min`, `interval_max`, `display_duration`, `position`, `show_on_mobile`, `updated_at`) VALUES
(1, 1, 1, 3, 5, 'bottom-left', 1, '2026-02-13 17:31:37');

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

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

CREATE TABLE `faqs` (
  `id` int(10) UNSIGNED NOT NULL,
  `question` varchar(500) NOT NULL,
  `answer` text NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` (`id`, `question`, `answer`, `sort_order`, `is_active`, `created_at`) VALUES
(1, 'Siparişim ne kadar sürede tamamlanır?', 'Her pakette belirtilen süre içerisinde siparişiniz tamamlanır. Genellikle 0-24 saat arasında değişmektedir.', 1, 1, '2026-02-10 19:41:30'),
(2, 'Ödeme yaptıktan sonra ne yapmalıyım?', 'Havale/EFT yaptıktan sonra dekont yüklemeniz yeterlidir. Ödemeniz onaylandıktan sonra siparişiniz başlar.', 2, 1, '2026-02-10 19:41:30'),
(3, 'Hesabımın şifresini istiyor musunuz?', 'Hayır! Hiçbir zaman şifrenizi istemiyoruz. Sadece kullanıcı adınız veya profilinizin linki yeterlidir.', 3, 1, '2026-02-10 19:41:30'),
(4, 'Garanti var mı?', 'Evet, tüm paketlerimizde belirtilen süre kadar garanti sunuyoruz. Düşüş olursa ücretsiz telafi yapılır.', 4, 1, '2026-02-10 19:41:30'),
(5, 'Güvenli mi?', 'Tamamen güvenlidir. Hesabınıza herhangi bir zarar gelmez. Binlerce mutlu müşterimiz bulunmaktadır.', 5, 1, '2026-02-10 19:41:30');

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

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

CREATE TABLE `iyzico_installments` (
  `id` int(10) UNSIGNED NOT NULL,
  `card_family` varchar(50) NOT NULL COMMENT 'Bonus, Maximum, World, Axess vb.',
  `installment_count` tinyint(2) NOT NULL COMMENT 'Taksit sayısı',
  `installment_rate` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT 'Komisyon oranı %',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `iyzico_installments` (`id`, `card_family`, `installment_count`, `installment_rate`, `is_active`, `created_at`) VALUES
(1, 'Bonus', 1, 0.00, 1, '2026-02-17 17:02:12'),
(2, 'Bonus', 2, 1.50, 1, '2026-02-17 17:02:12'),
(3, 'Bonus', 3, 2.50, 1, '2026-02-17 17:02:12'),
(4, 'Bonus', 6, 4.50, 1, '2026-02-17 17:02:12'),
(5, 'Bonus', 9, 6.50, 1, '2026-02-17 17:02:12'),
(6, 'Bonus', 12, 8.50, 1, '2026-02-17 17:02:12'),
(7, 'Maximum', 1, 0.00, 1, '2026-02-17 17:02:12'),
(8, 'Maximum', 2, 1.50, 1, '2026-02-17 17:02:12'),
(9, 'Maximum', 3, 2.50, 1, '2026-02-17 17:02:12'),
(10, 'Maximum', 6, 4.50, 1, '2026-02-17 17:02:12'),
(11, 'Maximum', 9, 6.50, 1, '2026-02-17 17:02:12'),
(12, 'Maximum', 12, 8.50, 1, '2026-02-17 17:02:12'),
(13, 'World', 1, 0.00, 1, '2026-02-17 17:02:12'),
(14, 'World', 2, 1.50, 1, '2026-02-17 17:02:12'),
(15, 'World', 3, 2.50, 1, '2026-02-17 17:02:12'),
(16, 'World', 6, 4.50, 1, '2026-02-17 17:02:12'),
(17, 'World', 9, 6.50, 1, '2026-02-17 17:02:12'),
(18, 'World', 12, 8.50, 1, '2026-02-17 17:02:12'),
(19, 'Axess', 1, 0.00, 0, '2026-02-17 17:02:12'),
(20, 'Axess', 2, 1.50, 0, '2026-02-17 17:02:12'),
(21, 'Axess', 3, 2.50, 1, '2026-02-17 17:02:12'),
(22, 'Axess', 6, 4.50, 1, '2026-02-17 17:02:12'),
(25, 'CardFinans', 1, 0.00, 1, '2026-02-17 17:02:12'),
(26, 'CardFinans', 2, 1.50, 1, '2026-02-17 17:02:12'),
(27, 'CardFinans', 3, 2.50, 1, '2026-02-17 17:02:12'),
(28, 'CardFinans', 6, 4.50, 1, '2026-02-17 17:02:12'),
(29, 'CardFinans', 9, 6.50, 1, '2026-02-17 17:02:12'),
(30, 'CardFinans', 12, 8.50, 1, '2026-02-17 17:02:12'),
(31, 'Paraf', 1, 0.00, 1, '2026-02-17 17:02:12'),
(32, 'Paraf', 2, 1.50, 1, '2026-02-17 17:02:12'),
(33, 'Paraf', 3, 2.50, 1, '2026-02-17 17:02:12'),
(34, 'Paraf', 6, 4.50, 1, '2026-02-17 17:02:12'),
(35, 'Paraf', 9, 6.50, 1, '2026-02-17 17:02:12'),
(36, 'Paraf', 12, 8.50, 1, '2026-02-17 17:02:12'),
(37, 'Axess', 9, 50.00, 1, '2026-02-17 18:09:04');

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

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

CREATE TABLE `iyzico_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_id` int(10) UNSIGNED DEFAULT NULL,
  `conversation_id` varchar(100) DEFAULT NULL,
  `action` varchar(50) NOT NULL COMMENT 'init, callback, refund, cancel',
  `status` varchar(50) DEFAULT NULL COMMENT 'success, failure',
  `error_code` varchar(50) DEFAULT NULL,
  `error_message` varchar(500) DEFAULT NULL,
  `request_data` text DEFAULT NULL,
  `response_data` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `iyzico_logs` (`id`, `order_id`, `conversation_id`, `action`, `status`, `error_code`, `error_message`, `request_data`, `response_data`, `ip_address`, `created_at`) VALUES
(1, 18, 'IYZICO_SP20260217F9896F_1771350287', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP20260217F9896F_1771350287\",\"price\":\"18.0\",\"basketId\":\"SP20260217F9896F\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771350287\",\"name\":\"Alper\",\"surname\":\"Aydın\",\"identityNumber\":\"11111111111\",\"email\":\"alperaydin4209@gmail.com\",\"gsmNumber\":\"+905076576457\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper Aydın\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper Aydın\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_17\",\"price\":\"18.0\",\"name\":\"Test Paket 1\",\"category1\":\"Spotify\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"http:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"18.0\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 17:44:47'),
(2, 18, 'IYZICO_SP20260217F9896F_1771350287', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350287966,\\\"conversationId\\\":\\\"IYZICO_SP20260217F9896F_1771350287\\\",\\\"token\\\":\\\"384124ad-fe45-4701-a917-e33eb85ad78d\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"384124ad-fe45-4701-a917-e33eb85ad78d\\\\\\\",price:18.00,pwiPrice:18.00,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"http:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Alper\\\\\\\",buyerSurname:\\\\\\\"Aydın\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905076576457\\\\\\\",email:\\\\\\\"alperaydin4209@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771350287963\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=384124ad-fe45-4701-a917-e33eb85ad78d&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=384124ad-fe45-4701-a917-e33eb85ad78d&lang=tr\\\",\\\"signature\\\":\\\"eacbfcf2441f4f4744e3012a01d2ee442f76392cf17561e08cc5af4ec783a1e8\\\"}\"', '94.54.242.220', '2026-02-17 17:44:48'),
(3, NULL, NULL, 'callback_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350343728,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629304\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"CREDIT_CARD\\\",\\\"cardAssociation\\\":\\\"TROY\\\",\\\"cardFamily\\\":\\\"Axess\\\",\\\"binNumber\\\":\\\"979207\\\",\\\"lastFourDigits\\\":\\\"7956\\\",\\\"basketId\\\":\\\"SP20260217F9896F\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_17\\\",\\\"paymentTransactionId\\\":\\\"30594651\\\",\\\"transactionStatus\\\":2,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.12180000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":18.00000000,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.12180000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"622662\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00046iyzihostrfn\\\",\\\"signature\\\":\\\"7339426b0e95877e73d4efe14f8a5524491f0158ced4bd2782e5fae15c11d2c5\\\",\\\"token\\\":\\\"384124ad-fe45-4701-a917-e33eb85ad78d\\\",\\\"callbackUrl\\\":\\\"http:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', '94.54.242.220', '2026-02-17 17:45:43'),
(4, 19, 'IYZICO_SP20260217DBC37F_1771350605', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP20260217DBC37F_1771350605\",\"price\":\"179.9\",\"basketId\":\"SP20260217DBC37F\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771350605\",\"name\":\"İyzico\",\"surname\":\"seneme\",\"identityNumber\":\"11111111111\",\"email\":\"siberihbar8@gmail.com\",\"gsmNumber\":\"+905076576457\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"İyzico seneme\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"İyzico seneme\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_3\",\"price\":\"179.9\",\"name\":\"Instagram 5000 Takipçi\",\"category1\":\"Takipçi\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"179.9\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 17:50:05'),
(5, 19, 'IYZICO_SP20260217DBC37F_1771350605', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350606118,\\\"conversationId\\\":\\\"IYZICO_SP20260217DBC37F_1771350605\\\",\\\"token\\\":\\\"b70858e8-82f4-4fda-86b2-6782965b072c\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"b70858e8-82f4-4fda-86b2-6782965b072c\\\\\\\",price:179.90,pwiPrice:179.90,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"İyzico\\\\\\\",buyerSurname:\\\\\\\"seneme\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905076576457\\\\\\\",email:\\\\\\\"siberihbar8@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771350606116\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=b70858e8-82f4-4fda-86b2-6782965b072c&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=b70858e8-82f4-4fda-86b2-6782965b072c&lang=tr\\\",\\\"signature\\\":\\\"0bf0f362cd360499a19a25f97d581a7e28abda539165d363fa623e3506cf0680\\\"}\"', '94.54.242.220', '2026-02-17 17:50:06'),
(6, NULL, NULL, 'callback_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350651548,\\\"price\\\":179.90000000,\\\"paidPrice\\\":216.22000000,\\\"installment\\\":9,\\\"paymentId\\\":\\\"28629318\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":20.18899389,\\\"merchantCommissionRateAmount\\\":36.32000000,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"CREDIT_CARD\\\",\\\"cardAssociation\\\":\\\"VISA\\\",\\\"cardFamily\\\":\\\"Denizbank CC\\\",\\\"binNumber\\\":\\\"460345\\\",\\\"lastFourDigits\\\":\\\"0000\\\",\\\"basketId\\\":\\\"SP20260217DBC37F\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_3\\\",\\\"paymentTransactionId\\\":\\\"30594656\\\",\\\"transactionStatus\\\":2,\\\"price\\\":179.90000000,\\\"paidPrice\\\":216.22000001,\\\"merchantCommissionRate\\\":20.18899389,\\\"merchantCommissionRateAmount\\\":36.32000001,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":173.37466001,\\\"convertedPayout\\\":{\\\"paidPrice\\\":216.22000001,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":173.37466001,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"188240\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00003iyzihostrfn\\\",\\\"signature\\\":\\\"60dbd16d6a9c753a57198c83ed2404b07710832796984b055b4b9d182961474f\\\",\\\"token\\\":\\\"b70858e8-82f4-4fda-86b2-6782965b072c\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":36.32000000}\"', '94.54.242.220', '2026-02-17 17:50:51'),
(7, 20, 'IYZICO_SP202602176EC9E3_1771351782', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP202602176EC9E3_1771351782\",\"price\":\"59.9\",\"basketId\":\"SP202602176EC9E3\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771351782\",\"name\":\"Hdhdhdhddh\",\"surname\":\"dndjd\",\"identityNumber\":\"11111111111\",\"email\":\"siberihbar8@gmail.com\",\"gsmNumber\":\"+905076574657\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Hdhdhdhddh dndjd\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Hdhdhdhddh dndjd\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_7\",\"price\":\"59.9\",\"name\":\"TikTok 1000 Takipçi\",\"category1\":\"Takipçi\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"59.9\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 18:09:42'),
(8, 20, 'IYZICO_SP202602176EC9E3_1771351782', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771351783283,\\\"conversationId\\\":\\\"IYZICO_SP202602176EC9E3_1771351782\\\",\\\"token\\\":\\\"ae54e508-3d6f-4e2e-bc1a-4af90468ad92\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"ae54e508-3d6f-4e2e-bc1a-4af90468ad92\\\\\\\",price:59.90,pwiPrice:59.90,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Hdhdhdhddh\\\\\\\",buyerSurname:\\\\\\\"dndjd\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905076574657\\\\\\\",email:\\\\\\\"siberihbar8@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771351783280\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=ae54e508-3d6f-4e2e-bc1a-4af90468ad92&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=ae54e508-3d6f-4e2e-bc1a-4af90468ad92&lang=tr\\\",\\\"signature\\\":\\\"0ccb79d7d199ea08a330d42585383ae8a03c8671b22e0a32e33416837dc6c1c4\\\"}\"', '94.54.242.220', '2026-02-17 18:09:43'),
(9, 21, 'IYZICO_SP20260217947BCC_1771351865', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP20260217947BCC_1771351865\",\"price\":\"59.9\",\"basketId\":\"SP20260217947BCC\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771351865\",\"name\":\"Hdhdhdhddh\",\"surname\":\"dndjd\",\"identityNumber\":\"11111111111\",\"email\":\"siberihbar8@gmail.com\",\"gsmNumber\":\"+905076574657\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Hdhdhdhddh dndjd\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Hdhdhdhddh dndjd\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_7\",\"price\":\"59.9\",\"name\":\"TikTok 1000 Takipçi\",\"category1\":\"Takipçi\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"59.9\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 18:11:05'),
(10, 21, 'IYZICO_SP20260217947BCC_1771351865', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771351865578,\\\"conversationId\\\":\\\"IYZICO_SP20260217947BCC_1771351865\\\",\\\"token\\\":\\\"f218af35-5ee3-436f-aacd-5071d9d96d31\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"f218af35-5ee3-436f-aacd-5071d9d96d31\\\\\\\",price:59.90,pwiPrice:59.90,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Hdhdhdhddh\\\\\\\",buyerSurname:\\\\\\\"dndjd\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905076574657\\\\\\\",email:\\\\\\\"siberihbar8@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771351865575\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=f218af35-5ee3-436f-aacd-5071d9d96d31&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=f218af35-5ee3-436f-aacd-5071d9d96d31&lang=tr\\\",\\\"signature\\\":\\\"f1649771536efc8a679bc4333eb1a9fdda2aeb55fb5b3e9219cb41558f4aedef\\\"}\"', '94.54.242.220', '2026-02-17 18:11:05'),
(11, 22, 'IYZICO_SP2026021741F8A5_1771351988', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP2026021741F8A5_1771351988\",\"price\":\"18.0\",\"basketId\":\"SP2026021741F8A5\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771351988\",\"name\":\"Alper\",\"surname\":\"Aydın\",\"identityNumber\":\"11111111111\",\"email\":\"siberihbar8@gmail.com\",\"gsmNumber\":\"+905076576457\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper Aydın\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper Aydın\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_17\",\"price\":\"18.0\",\"name\":\"Test Paket 1\",\"category1\":\"Spotify\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"18.0\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 18:13:08'),
(12, 22, 'IYZICO_SP2026021741F8A5_1771351988', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771351988478,\\\"conversationId\\\":\\\"IYZICO_SP2026021741F8A5_1771351988\\\",\\\"token\\\":\\\"fb66bc42-4724-4178-a258-e613d7812e5e\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"fb66bc42-4724-4178-a258-e613d7812e5e\\\\\\\",price:18.00,pwiPrice:18.00,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Alper\\\\\\\",buyerSurname:\\\\\\\"Aydın\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905076576457\\\\\\\",email:\\\\\\\"siberihbar8@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771351988476\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=fb66bc42-4724-4178-a258-e613d7812e5e&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=fb66bc42-4724-4178-a258-e613d7812e5e&lang=tr\\\",\\\"signature\\\":\\\"391dfa66e4f833c5e4a1d5017371843f74832cd094c9c92efa3adfeaa2b2733a\\\"}\"', '94.54.242.220', '2026-02-17 18:13:08'),
(13, NULL, NULL, 'callback_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352009694,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629374\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"DEBIT_CARD\\\",\\\"cardAssociation\\\":\\\"MASTER_CARD\\\",\\\"cardFamily\\\":\\\"Neo\\\",\\\"binNumber\\\":\\\"589004\\\",\\\"lastFourDigits\\\":\\\"0016\\\",\\\"basketId\\\":\\\"SP2026021741F8A5\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_17\\\",\\\"paymentTransactionId\\\":\\\"30594723\\\",\\\"transactionStatus\\\":2,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.55200000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":18.00000000,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.55200000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"872208\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00027iyzihostrfn\\\",\\\"signature\\\":\\\"a1790e692ea3d3207a916c34b6834e209d41e75d840a92113c62016cd37a5f12\\\",\\\"token\\\":\\\"fb66bc42-4724-4178-a258-e613d7812e5e\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', '94.54.242.220', '2026-02-17 18:13:29'),
(14, 23, 'IYZICO_SP2026021766847A_1771352054', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP2026021766847A_1771352054\",\"price\":\"179.9\",\"basketId\":\"SP2026021766847A\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771352054\",\"name\":\"Alper\",\"surname\":\"2\",\"identityNumber\":\"11111111111\",\"email\":\"alperaydin4209@gmail.com\",\"gsmNumber\":\"+905074736373\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper 2\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Alper 2\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_3\",\"price\":\"179.9\",\"name\":\"Instagram 5000 Takipçi\",\"category1\":\"Takipçi\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"179.9\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 18:14:14'),
(15, 23, 'IYZICO_SP2026021766847A_1771352054', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352054764,\\\"conversationId\\\":\\\"IYZICO_SP2026021766847A_1771352054\\\",\\\"token\\\":\\\"c60ccd6c-843b-4acb-8864-1efe2d54c43d\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"c60ccd6c-843b-4acb-8864-1efe2d54c43d\\\\\\\",price:179.90,pwiPrice:179.90,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Alper\\\\\\\",buyerSurname:\\\\\\\"2\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"+905074736373\\\\\\\",email:\\\\\\\"alperaydin4209@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771352054761\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=c60ccd6c-843b-4acb-8864-1efe2d54c43d&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=c60ccd6c-843b-4acb-8864-1efe2d54c43d&lang=tr\\\",\\\"signature\\\":\\\"4772c39a400f3bef8fbab65797be11655fbeed493bc8e49aed56680bec196560\\\"}\"', '94.54.242.220', '2026-02-17 18:14:14'),
(16, NULL, NULL, 'callback_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352114580,\\\"price\\\":179.90000000,\\\"paidPrice\\\":179.90000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629379\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"DEBIT_CARD\\\",\\\"cardAssociation\\\":\\\"MASTER_CARD\\\",\\\"cardFamily\\\":\\\"Neo\\\",\\\"binNumber\\\":\\\"589004\\\",\\\"lastFourDigits\\\":\\\"0016\\\",\\\"basketId\\\":\\\"SP2026021766847A\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_3\\\",\\\"paymentTransactionId\\\":\\\"30594728\\\",\\\"transactionStatus\\\":2,\\\"price\\\":179.90000000,\\\"paidPrice\\\":179.90000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":177.67110000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":179.90000000,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":177.67110000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"762459\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00027iyzihostrfn\\\",\\\"signature\\\":\\\"95213c24984a2697512e64026c81073da657902d39f0fc02289b06d6f5bc70d8\\\",\\\"token\\\":\\\"c60ccd6c-843b-4acb-8864-1efe2d54c43d\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', '94.54.242.220', '2026-02-17 18:15:14'),
(17, 24, 'IYZICO_SP20260217A2C5E4_1771352154', 'init', 'pending', NULL, NULL, '{\"locale\":\"tr\",\"conversationId\":\"IYZICO_SP20260217A2C5E4_1771352154\",\"price\":\"18.0\",\"basketId\":\"SP20260217A2C5E4\",\"paymentGroup\":\"PRODUCT\",\"buyer\":{\"id\":\"GUEST_1771352154\",\"name\":\"Test3\",\"surname\":\"3\",\"identityNumber\":\"11111111111\",\"email\":\"deneme@gmail.com\",\"gsmNumber\":\"+909393837373\",\"registrationAddress\":\"Türkiye\",\"city\":\"Istanbul\",\"country\":\"Turkey\",\"ip\":\"94.54.242.220\"},\"shippingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Test3 3\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"billingAddress\":{\"address\":\"Türkiye\",\"contactName\":\"Test3 3\",\"city\":\"Istanbul\",\"country\":\"Turkey\"},\"basketItems\":[{\"id\":\"PKG_17\",\"price\":\"18.0\",\"name\":\"Test Paket 1\",\"category1\":\"Spotify\",\"itemType\":\"VIRTUAL\"}],\"callbackUrl\":\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\",\"currency\":\"TRY\",\"paidPrice\":\"18.0\",\"forceThreeDS\":1,\"enabledInstallments\":[1,2,3,4,5,6,7,8,9,10]}', NULL, '94.54.242.220', '2026-02-17 18:15:54'),
(18, 24, 'IYZICO_SP20260217A2C5E4_1771352154', 'init_response', 'success', NULL, NULL, NULL, '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352154487,\\\"conversationId\\\":\\\"IYZICO_SP20260217A2C5E4_1771352154\\\",\\\"token\\\":\\\"a02010bf-bd54-4445-b845-5d94c285491d\\\",\\\"checkoutFormContent\\\":\\\"<script type=\\\\\\\"text\\/javascript\\\\\\\">if (typeof iyziInit == \'undefined\') {var iyziInit = {currency:\\\\\\\"TRY\\\\\\\",token:\\\\\\\"a02010bf-bd54-4445-b845-5d94c285491d\\\\\\\",price:18.00,pwiPrice:18.00,shippingDiscountAmount:null,locale:\\\\\\\"tr\\\\\\\",baseUrl:\\\\\\\"https:\\/\\/sandbox-api.iyzipay.com\\\\\\\", merchantGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-merchantgw.iyzipay.com\\\\\\\", consumerGatewayBaseUrl:\\\\\\\"https:\\/\\/sandbox-consumerapigw.iyzipay.com\\\\\\\", registerCardEnabled:true,bkmEnabled:true,bankTransferEnabled:false,bankTransferTimeLimit:{\\\\\\\"value\\\\\\\":5,\\\\\\\"type\\\\\\\":\\\\\\\"day\\\\\\\"},bankTransferRedirectUrl:\\\\\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\\\\\",bankTransferCustomUIProps:{},campaignEnabled:false,campaignMarketingUiDisplay:{},campaignMarketingUiDisplayV2:{\\\\\\\"mobile\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_C_v_1754637545492.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_G_v_1754637545949.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_M_P_v_1754637545797.png\\\\\\\"},\\\\\\\"desktop\\\\\\\":{\\\\\\\"cardTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_C_v_1754637546014.png\\\\\\\",\\\\\\\"gsmCheckContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_G_v_1754637546164.png\\\\\\\",\\\\\\\"pwiTabContent\\\\\\\":\\\\\\\"https:\\/\\/sandbox-static.iyzipay.com\\/marketing-display\\/campaign_D_P_v_1754637546098.png\\\\\\\"}},paymentSourceName:\\\\\\\"\\\\\\\",plusInstallmentResponseList:null,payWithIyzicoSingleTab:false,payWithIyzicoSingleTabV2:false,payWithIyzicoOneTab:false,mixPaymentEnabled:true,creditCardEnabled:true,bankTransferAccounts:[],userCards:[],fundEnabled:true,memberCheckoutOtpData:{},force3Ds:false,isSandbox:true,storeNewCardEnabled:true,paymentWithNewCardEnabled:true,enabledApmTypes:[\\\\\\\"SOFORT\\\\\\\",\\\\\\\"IDEAL\\\\\\\",\\\\\\\"QIWI\\\\\\\",\\\\\\\"GIROPAY\\\\\\\"],payWithIyzicoUsed:false,payWithIyzicoEnabled:true,payWithIyzicoCustomUI:{},buyerName:\\\\\\\"Test3\\\\\\\",buyerSurname:\\\\\\\"3\\\\\\\",merchantInfo:\\\\\\\"\\\\\\\",merchantName:\\\\\\\"Sandbox Merchant Name - 3410060\\\\\\\",cancelUrl:\\\\\\\"\\\\\\\",buyerProtectionEnabled:false,hide3DS:false,gsmNumber:\\\\\\\"\\\\\\\",email:\\\\\\\"deneme@gmail.com\\\\\\\",checkConsumerDetail:{},subscriptionPaymentEnabled:false,disabledCardStorageInfoCheckbox:false,ucsEnabled:false,fingerprintEnabled:false,payWithIyzicoFirstTab:false,creditEnabled:false,payWithIyzicoLead:false,zeroAuth:false,goBackUrl:\\\\\\\"\\\\\\\",customMerchantName:\\\\\\\"\\\\\\\",useCurrencySymbol:false,quickPwiEnabled:false,quickPwiNewCardEnabled:false,onlyQuickPwiView:false,checkoutRedesignEnabled:false,quickPwiMemberStatus:\\\\\\\"UNKNOWN\\\\\\\",consumerCardList:[],saveCardCheckboxEnabled:false,isForeignNumber:false,agreementCheckedByDefault:true,shopifyTestMode:false,shopifyTestModeCallbackUrl:\\\\\\\"\\\\\\\",metadata : {},createTag:function(){var iyziJSTag = document.createElement(\'script\');iyziJSTag.setAttribute(\'src\',\'https:\\/\\/sandbox-static.iyzipay.com\\/checkoutform\\/v2\\/bundle.js?v=1771352154484\');document.head.appendChild(iyziJSTag);}};iyziInit.createTag();}<\\/script>\\\",\\\"tokenExpireTime\\\":1800,\\\"paymentPageUrl\\\":\\\"https:\\/\\/sandbox-cpp.iyzipay.com?token=a02010bf-bd54-4445-b845-5d94c285491d&lang=tr\\\",\\\"payWithIyzicoPageUrl\\\":\\\"https:\\/\\/sandbox-ode.iyzico.com\\/?token=a02010bf-bd54-4445-b845-5d94c285491d&lang=tr\\\",\\\"signature\\\":\\\"1d2f50e197f98dc8b6e6ab64438a5e70137744a7ae4905cf68ba487bc3e0973f\\\"}\"', '94.54.242.220', '2026-02-17 18:15:54');

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

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

CREATE TABLE `marquee_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `text` varchar(500) NOT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `link` varchar(500) DEFAULT NULL,
  `link_text` varchar(100) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `marquee_items` (`id`, `text`, `icon`, `link`, `link_text`, `is_active`, `sort_order`, `start_date`, `end_date`, `created_at`) VALUES
(1, '🔥 Bugüne özel tüm paketlerde %20 indirim!', 'fas fa-fire', NULL, NULL, 1, 1, NULL, NULL, '2026-02-13 17:30:08'),
(2, '⚡ Siparişler anında teslim edilir', 'fas fa-bolt', NULL, NULL, 1, 2, NULL, NULL, '2026-02-13 17:30:08'),
(3, '🎁 İlk siparişinize özel %10 indirim kodu: HOSGELDIN', 'fas fa-gift', NULL, NULL, 1, 3, NULL, NULL, '2026-02-13 17:30:08');

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

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

CREATE TABLE `marquee_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `bg_color` varchar(7) DEFAULT '#ef4444',
  `text_color` varchar(7) DEFAULT '#ffffff',
  `speed` int(11) DEFAULT 30,
  `show_on_mobile` tinyint(1) DEFAULT 1,
  `is_closable` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `marquee_settings` (`id`, `is_active`, `bg_color`, `text_color`, `speed`, `show_on_mobile`, `is_closable`) VALUES
(1, 1, '#ef4444', '#ffffff', 20, 1, 0);

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

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

CREATE TABLE `notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `icon` varchar(50) DEFAULT 'fas fa-bell',
  `icon_color` varchar(20) DEFAULT '#6366f1',
  `link` varchar(500) DEFAULT NULL,
  `link_text` varchar(100) DEFAULT NULL,
  `target` enum('all','users','guests') DEFAULT 'all',
  `is_active` tinyint(1) DEFAULT 1,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notifications` (`id`, `title`, `message`, `icon`, `icon_color`, `link`, `link_text`, `target`, `is_active`, `start_date`, `end_date`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, '🎉 Hoş Geldiniz!', 'SMM Panel sistemimize hoş geldiniz. Paketlerimizi inceleyebilirsiniz.', 'fas fa-gift', '#10b981', '/#packages', 'Paketleri İncele', 'all', 1, NULL, NULL, 0, '2026-02-12 19:41:09', '2026-02-12 20:56:10'),
(2, '🔥 Yeni Paketler', 'Instagram ve TikTok paketlerimiz güncellendi!', 'fas fa-fire', '#ef4444', '/#packages', 'Hemen İncele', 'all', 1, NULL, NULL, 0, '2026-02-12 19:41:09', '2026-02-12 19:41:09'),
(4, 'Test Duyuru', 'Kampanyaya Girdik', 'fas fa-bullhorn', '#84cc16', 'https://www.google.com', 'Detaylar', 'guests', 1, NULL, NULL, 0, '2026-02-12 20:59:12', '2026-02-12 20:59:12');

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

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

CREATE TABLE `notification_reads` (
  `id` int(10) UNSIGNED NOT NULL,
  `notification_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `session_id` varchar(100) DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notification_reads` (`id`, `notification_id`, `user_id`, `session_id`, `read_at`) VALUES
(1, 1, NULL, '61a70b4139b8eb5e7c7e9cd03c502b08', '2026-02-13 08:31:26'),
(2, 2, NULL, '61a70b4139b8eb5e7c7e9cd03c502b08', '2026-02-13 08:31:26'),
(3, 4, NULL, '61a70b4139b8eb5e7c7e9cd03c502b08', '2026-02-13 08:31:26'),
(4, 1, NULL, '7d4678c2a18655b146b63778be979f8d', '2026-02-13 08:31:55'),
(5, 2, NULL, '7d4678c2a18655b146b63778be979f8d', '2026-02-13 08:31:55'),
(6, 4, NULL, '7d4678c2a18655b146b63778be979f8d', '2026-02-13 08:31:55'),
(7, 1, NULL, '57fe546b917299b9c3e702a2640139c7', '2026-02-13 08:38:00'),
(8, 2, NULL, '57fe546b917299b9c3e702a2640139c7', '2026-02-13 08:38:00'),
(9, 4, NULL, '57fe546b917299b9c3e702a2640139c7', '2026-02-13 08:38:00'),
(10, 1, NULL, '676cd27b7c5db7c9491c6bf8d4af35db', '2026-02-13 09:42:35'),
(11, 2, NULL, '676cd27b7c5db7c9491c6bf8d4af35db', '2026-02-13 09:42:35'),
(12, 4, NULL, '676cd27b7c5db7c9491c6bf8d4af35db', '2026-02-13 09:42:35'),
(13, 1, NULL, '521384dedb418a646023d499dc67e288', '2026-02-13 11:33:40'),
(14, 2, NULL, '521384dedb418a646023d499dc67e288', '2026-02-13 11:33:40'),
(15, 4, NULL, '521384dedb418a646023d499dc67e288', '2026-02-13 11:33:40'),
(16, 1, NULL, '592b653bb0bf5075307e8193fe863743', '2026-02-13 17:10:30'),
(17, 2, NULL, '592b653bb0bf5075307e8193fe863743', '2026-02-13 17:10:30'),
(18, 4, NULL, '592b653bb0bf5075307e8193fe863743', '2026-02-13 17:10:30'),
(19, 1, NULL, '32de851e7caa7ef66af823f20ed54484', '2026-02-13 17:35:37'),
(20, 2, NULL, '32de851e7caa7ef66af823f20ed54484', '2026-02-13 17:35:37'),
(21, 4, NULL, '32de851e7caa7ef66af823f20ed54484', '2026-02-13 17:35:37'),
(22, 1, 1, '592b653bb0bf5075307e8193fe863743', '2026-02-13 17:35:44'),
(23, 2, 1, '592b653bb0bf5075307e8193fe863743', '2026-02-13 17:35:44');

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

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

CREATE TABLE `orders` (
  `id` int(10) UNSIGNED NOT NULL,
  `order_number` varchar(20) NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `package_id` int(10) UNSIGNED NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `customer_email` varchar(100) NOT NULL,
  `customer_phone` varchar(20) DEFAULT NULL,
  `social_media_link` text NOT NULL,
  `social_media_username` varchar(100) DEFAULT NULL,
  `payment_method` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `discount_amount` decimal(10,2) DEFAULT 0.00,
  `coupon_id` int(11) UNSIGNED DEFAULT NULL,
  `coupon_code` varchar(50) DEFAULT NULL,
  `kdv_rate` decimal(5,2) DEFAULT NULL,
  `kdv_amount` decimal(10,2) DEFAULT NULL,
  `net_amount` decimal(10,2) DEFAULT NULL,
  `status` enum('pending','paid','processing','completed','cancelled','refunded') DEFAULT 'pending',
  `api_order_id` varchar(50) DEFAULT NULL,
  `api_status` varchar(50) DEFAULT NULL,
  `api_provider_id` int(10) UNSIGNED DEFAULT NULL,
  `payment_proof` varchar(255) DEFAULT NULL,
  `admin_note` text DEFAULT NULL,
  `customer_note` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `api_sent_at` datetime DEFAULT NULL,
  `api_error` varchar(500) DEFAULT NULL,
  `api_charge` decimal(10,4) DEFAULT NULL,
  `api_start_count` int(11) DEFAULT NULL,
  `api_remains` int(11) DEFAULT NULL,
  `iyzico_conversation_id` varchar(100) DEFAULT NULL COMMENT 'iyzico konuşma ID',
  `iyzico_token` varchar(255) DEFAULT NULL COMMENT 'iyzico checkout token',
  `iyzico_payment_id` varchar(100) DEFAULT NULL COMMENT 'iyzico ödeme ID',
  `iyzico_payment_transaction_id` varchar(100) DEFAULT NULL COMMENT 'iyzico işlem ID',
  `iyzico_fraud_status` varchar(50) DEFAULT NULL COMMENT 'iyzico fraud durumu',
  `iyzico_installment` tinyint(2) DEFAULT 1 COMMENT 'Taksit sayısı',
  `iyzico_card_family` varchar(50) DEFAULT NULL COMMENT 'Kart ailesi (Bonus, Maximum vb.)',
  `iyzico_card_type` varchar(20) DEFAULT NULL COMMENT 'Kart tipi (CREDIT_CARD, DEBIT_CARD)',
  `iyzico_card_association` varchar(20) DEFAULT NULL COMMENT 'Kart birliği (VISA, MASTER_CARD)',
  `iyzico_bin_number` varchar(10) DEFAULT NULL COMMENT 'Kart BIN numarası (ilk 6 hane)',
  `iyzico_last_four` varchar(4) DEFAULT NULL COMMENT 'Kart son 4 hane',
  `iyzico_raw_result` text DEFAULT NULL COMMENT 'iyzico ham yanıt (JSON)',
  `invoice_number` varchar(50) DEFAULT NULL,
  `invoice_generated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `orders` (`id`, `order_number`, `user_id`, `package_id`, `customer_name`, `customer_email`, `customer_phone`, `social_media_link`, `social_media_username`, `payment_method`, `amount`, `discount_amount`, `coupon_id`, `coupon_code`, `kdv_rate`, `kdv_amount`, `net_amount`, `status`, `api_order_id`, `api_status`, `api_provider_id`, `payment_proof`, `admin_note`, `customer_note`, `ip_address`, `paid_at`, `completed_at`, `created_at`, `updated_at`, `api_sent_at`, `api_error`, `api_charge`, `api_start_count`, `api_remains`, `iyzico_conversation_id`, `iyzico_token`, `iyzico_payment_id`, `iyzico_payment_transaction_id`, `iyzico_fraud_status`, `iyzico_installment`, `iyzico_card_family`, `iyzico_card_type`, `iyzico_card_association`, `iyzico_bin_number`, `iyzico_last_four`, `iyzico_raw_result`, `invoice_number`, `invoice_generated_at`) VALUES
(1, 'SP202602112EDB2B', NULL, 17, 'Alper Aydın', 'test@gmail.com', '05076576457', 'dijiyazilim', NULL, 'bank_transfer', 18.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, 'uploads/dekont/dekont_1770831970_52ed3930a29ca8f9.png', NULL, 'Merhaba', '176.89.206.228', NULL, '2026-02-11 17:47:55', '2026-02-11 17:46:10', '2026-02-12 14:01:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260211BD40CC', NULL),
(2, 'SP20260211856703', 1, 2, 'Test test', 'siberihbar8@gmail.com', '05076576457', 'Test', NULL, 'bank_transfer', 99.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', '2026-02-11 17:57:25', '2026-02-11 17:58:16', '2026-02-11 17:55:04', '2026-02-11 17:58:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB2026021181C6D2', NULL),
(3, 'SP2026021178540D', NULL, 3, 'Test Test', 'siberihbar8@gmail.com', '9576576457', 'dijiyazilim', NULL, 'bank_transfer', 159.90, 20.00, 3, 'MERHABA', NULL, NULL, NULL, 'cancelled', NULL, NULL, NULL, NULL, NULL, 'Test', '94.54.242.88', NULL, '2026-02-11 20:52:30', '2026-02-11 20:50:15', '2026-02-11 20:59:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260211E30B24', NULL),
(4, 'SP20260211E18D74', 1, 17, 'Alper Aydın', 'siberihbar8@gmail.com', '05076576457', 'Dijiyazilim', NULL, 'bank_transfer', 13.90, 5.00, 2, 'R10', NULL, NULL, NULL, 'completed', '9534802', 'Completed', NULL, NULL, NULL, 'Gızlıcolsun', '94.54.242.88', NULL, '2026-02-11 21:07:02', '2026-02-11 20:56:46', '2026-02-11 21:43:19', '2026-02-11 20:59:30', NULL, 2.1040, 5647, 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB202602111665E5', NULL),
(5, 'SP202602125772F3', 1, 3, 'Test test', 'test@gmail.com', '05076576457', 'Test', NULL, 'bank_transfer', 179.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', NULL, '2026-02-12 10:48:39', '2026-02-12 10:47:49', '2026-02-12 14:01:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB202602127DA461', NULL),
(6, 'SP20260212E9711E', 1, 9, 'Test', 'test@gmail.com', '05076576457', 'Test', NULL, 'bank_transfer', 23.88, 0.00, NULL, NULL, 20.00, 3.98, NULL, 'completed', NULL, NULL, NULL, 'uploads/dekont/dekont_1770893390_009fb3c6f33f0e6a.png', NULL, '', '94.54.242.88', NULL, '2026-02-12 11:00:09', '2026-02-12 10:49:50', '2026-02-12 14:01:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB2026021295A79C', NULL),
(7, 'SP20260212EB67BA', 1, 17, 'Alper Aydın', 'test@gmail.com', '05076576457', 'dijiyazilim', NULL, 'bank_transfer', 22.68, 0.00, NULL, NULL, 20.00, 3.78, NULL, 'completed', '9535925', 'Completed', NULL, NULL, NULL, 'Merhaba', '94.54.242.88', NULL, '2026-02-12 11:08:02', '2026-02-12 10:52:30', '2026-02-12 14:01:36', '2026-02-12 11:00:47', NULL, 2.1040, 5734, 0, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260212DF3BAC', NULL),
(8, 'SP20260212E586F8', 1, 3, 'Test', 'test@gmail.com', '05076576457', 'Dijiyazilim', NULL, 'bank_transfer', 195.88, 20.00, 3, 'MERHABA', 20.00, 35.98, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', NULL, '2026-02-12 11:00:33', '2026-02-12 10:59:42', '2026-02-12 14:01:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB202602121246D6', NULL),
(9, 'SP2026021258CA83', 1, 5, 'Test test', 'test@gmail.com', '05076576457', 'dijiyazilim', NULL, 'bank_transfer', 35.88, 0.00, NULL, NULL, 20.00, 5.98, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, 'Test', '94.54.242.88', NULL, '2026-02-12 13:59:47', '2026-02-12 13:58:29', '2026-02-12 14:01:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB2026021230C8EE', NULL),
(10, 'SP2026021212E0E5', 1, 3, 'Test Test', 'deneme@gmail.com', '05555555555', 'deneme', NULL, 'bank_transfer', 215.88, 0.00, NULL, NULL, 20.00, 35.98, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, 'Test', '94.54.242.88', NULL, '2026-02-12 14:36:20', '2026-02-12 14:21:53', '2026-02-12 14:36:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB202602124BF352', NULL),
(11, 'SP20260212351D61', 1, 2, 'Ndndnd', 'blblabla@gmail.com', '056473746463', 'Yest', NULL, 'bank_transfer', 119.88, 0.00, NULL, NULL, 20.00, 19.98, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', NULL, '2026-02-12 14:36:26', '2026-02-12 14:24:03', '2026-02-12 14:36:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260212A0CCEB', NULL),
(12, 'SP202602126D7F51', 1, 2, 'Hdhdhs', 'blablabaldk@gmail.com', '050765764837', 'dijiyazilim', NULL, 'bank_transfer', 119.88, 0.00, NULL, NULL, 20.00, 19.98, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, 'Hahah', '94.54.242.88', NULL, '2026-02-12 14:36:31', '2026-02-12 14:31:50', '2026-02-12 14:36:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260212F34133', NULL),
(13, 'SP20260212708C1C', 1, 3, 'Test tets', 'alpydhsm@gmail.com', '0545362635', 'Test', NULL, 'bank_transfer', 215.88, 0.00, NULL, NULL, 20.00, 35.98, NULL, 'completed', NULL, NULL, NULL, 'uploads/dekont/dekont_1770906919_b5b607ad884cd4a0.png', NULL, 'Test Açıklama Test Test', '94.54.242.88', NULL, '2026-02-12 14:36:35', '2026-02-12 14:35:19', '2026-02-12 14:36:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB2026021238DF01', NULL),
(14, 'SP20260213EED160', 1, 7, 'Test test', 'test@gmail.com', '057474747373', 'Deneme', NULL, 'bank_transfer', 59.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', NULL, '2026-02-13 18:18:28', '2026-02-13 17:59:26', '2026-02-13 18:18:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB2026021346771C', NULL),
(15, 'SP2026021368932A', 1, 11, 'Qr deneme', 'qrdeneme@gmail.com', '04847373636', 'Qrdeneme', NULL, 'bank_transfer', 149.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, 'Tets', '94.54.242.88', NULL, '2026-02-13 18:18:23', '2026-02-13 18:01:26', '2026-02-13 18:18:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'MKB20260213F8D885', NULL),
(16, 'SP2026021311BBF7', 1, 10, 'Qr deneme 2', 'qrdeneme2@gmail.com', '049484747473', 'Qrdeneme2', NULL, 'bank_transfer', 49.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, 'Hdhdhdndnd', '94.54.242.88', NULL, '2026-02-13 18:16:27', '2026-02-13 18:03:45', '2026-02-13 18:18:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'INV-2026-000016', '2026-02-13 18:15:02'),
(17, 'SP20260213B81C5C', NULL, 3, 'Alper Aydın', 'alperaydin4209@gmail.com', '05076576457', 'dijiyazilim', NULL, 'bank_transfer', 179.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.88', NULL, '2026-02-13 18:16:16', '2026-02-13 18:05:15', '2026-02-13 18:16:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'INV-2026-000017', '2026-02-13 18:15:45'),
(18, 'SP20260217F9896F', NULL, 17, 'Alper Aydın', 'alperaydin4209@gmail.com', '05076576457', 'dijiyazilim', NULL, 'iyzico', 18.00, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', '9552102', 'Completed', NULL, NULL, NULL, '', '94.54.242.220', '2026-02-17 17:45:43', '2026-02-17 17:55:24', '2026-02-17 17:44:47', '2026-02-17 17:55:24', '2026-02-17 17:52:04', NULL, 2.1110, 5186, 0, 'IYZICO_SP20260217F9896F_1771350287', '384124ad-fe45-4701-a917-e33eb85ad78d', '28629304', '30594651', '1', 1, 'Axess', 'CREDIT_CARD', 'TROY', '979207', '7956', '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350343728,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629304\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"CREDIT_CARD\\\",\\\"cardAssociation\\\":\\\"TROY\\\",\\\"cardFamily\\\":\\\"Axess\\\",\\\"binNumber\\\":\\\"979207\\\",\\\"lastFourDigits\\\":\\\"7956\\\",\\\"basketId\\\":\\\"SP20260217F9896F\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_17\\\",\\\"paymentTransactionId\\\":\\\"30594651\\\",\\\"transactionStatus\\\":2,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.12180000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":18.00000000,\\\"iyziCommissionRateAmount\\\":0.62820000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.12180000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"622662\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00046iyzihostrfn\\\",\\\"signature\\\":\\\"7339426b0e95877e73d4efe14f8a5524491f0158ced4bd2782e5fae15c11d2c5\\\",\\\"token\\\":\\\"384124ad-fe45-4701-a917-e33eb85ad78d\\\",\\\"callbackUrl\\\":\\\"http:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', 'MKB20260217C484FA', NULL),
(19, 'SP20260217DBC37F', NULL, 3, 'İyzico seneme', 'siberihbar8@gmail.com', '05076576457', 'şyzşcotest', NULL, 'iyzico', 179.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'cancelled', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.220', '2026-02-17 17:50:51', '2026-02-17 17:53:47', '2026-02-17 17:50:05', '2026-02-17 17:53:47', NULL, NULL, NULL, NULL, NULL, 'IYZICO_SP20260217DBC37F_1771350605', 'b70858e8-82f4-4fda-86b2-6782965b072c', '28629318', '30594656', '1', 9, 'Denizbank CC', 'CREDIT_CARD', 'VISA', '460345', '0000', '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771350651548,\\\"price\\\":179.90000000,\\\"paidPrice\\\":216.22000000,\\\"installment\\\":9,\\\"paymentId\\\":\\\"28629318\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":20.18899389,\\\"merchantCommissionRateAmount\\\":36.32000000,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"CREDIT_CARD\\\",\\\"cardAssociation\\\":\\\"VISA\\\",\\\"cardFamily\\\":\\\"Denizbank CC\\\",\\\"binNumber\\\":\\\"460345\\\",\\\"lastFourDigits\\\":\\\"0000\\\",\\\"basketId\\\":\\\"SP20260217DBC37F\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_3\\\",\\\"paymentTransactionId\\\":\\\"30594656\\\",\\\"transactionStatus\\\":2,\\\"price\\\":179.90000000,\\\"paidPrice\\\":216.22000001,\\\"merchantCommissionRate\\\":20.18899389,\\\"merchantCommissionRateAmount\\\":36.32000001,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":173.37466001,\\\"convertedPayout\\\":{\\\"paidPrice\\\":216.22000001,\\\"iyziCommissionRateAmount\\\":42.59534000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":173.37466001,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"188240\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00003iyzihostrfn\\\",\\\"signature\\\":\\\"60dbd16d6a9c753a57198c83ed2404b07710832796984b055b4b9d182961474f\\\",\\\"token\\\":\\\"b70858e8-82f4-4fda-86b2-6782965b072c\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":36.32000000}\"', 'MKB20260217BD1FE6', NULL),
(22, 'SP2026021741F8A5', NULL, 17, 'Alper Aydın', 'siberihbar8@gmail.com', '05076576457', 'dijiyazilim', NULL, 'iyzico', 18.00, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', '9552186', 'Completed', NULL, NULL, NULL, '', '94.54.242.220', '2026-02-17 18:13:29', '2026-02-17 18:32:02', '2026-02-17 18:13:08', '2026-02-17 18:32:02', '2026-02-17 18:19:47', NULL, 2.1110, 5324, 0, 'IYZICO_SP2026021741F8A5_1771351988', 'fb66bc42-4724-4178-a258-e613d7812e5e', '28629374', '30594723', '1', 1, 'Neo', 'DEBIT_CARD', 'MASTER_CARD', '589004', '0016', '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352009694,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629374\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"DEBIT_CARD\\\",\\\"cardAssociation\\\":\\\"MASTER_CARD\\\",\\\"cardFamily\\\":\\\"Neo\\\",\\\"binNumber\\\":\\\"589004\\\",\\\"lastFourDigits\\\":\\\"0016\\\",\\\"basketId\\\":\\\"SP2026021741F8A5\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_17\\\",\\\"paymentTransactionId\\\":\\\"30594723\\\",\\\"transactionStatus\\\":2,\\\"price\\\":18.00000000,\\\"paidPrice\\\":18.00000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.55200000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":18.00000000,\\\"iyziCommissionRateAmount\\\":0.19800000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":17.55200000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"872208\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00027iyzihostrfn\\\",\\\"signature\\\":\\\"a1790e692ea3d3207a916c34b6834e209d41e75d840a92113c62016cd37a5f12\\\",\\\"token\\\":\\\"fb66bc42-4724-4178-a258-e613d7812e5e\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', NULL, NULL),
(23, 'SP2026021766847A', NULL, 3, 'Alper 2', 'alperaydin4209@gmail.com', '05074736373', 'dijiyazilim2', NULL, 'iyzico', 179.90, 0.00, NULL, NULL, NULL, NULL, NULL, 'cancelled', NULL, NULL, NULL, NULL, NULL, '', '94.54.242.220', '2026-02-17 18:15:14', '2026-02-17 18:20:09', '2026-02-17 18:14:14', '2026-02-17 18:20:09', NULL, NULL, NULL, NULL, NULL, 'IYZICO_SP2026021766847A_1771352054', 'c60ccd6c-843b-4acb-8864-1efe2d54c43d', '28629379', '30594728', '1', 1, 'Neo', 'DEBIT_CARD', 'MASTER_CARD', '589004', '0016', '\"{\\\"status\\\":\\\"success\\\",\\\"locale\\\":\\\"tr\\\",\\\"systemTime\\\":1771352114580,\\\"price\\\":179.90000000,\\\"paidPrice\\\":179.90000000,\\\"installment\\\":1,\\\"paymentId\\\":\\\"28629379\\\",\\\"fraudStatus\\\":1,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"cardType\\\":\\\"DEBIT_CARD\\\",\\\"cardAssociation\\\":\\\"MASTER_CARD\\\",\\\"cardFamily\\\":\\\"Neo\\\",\\\"binNumber\\\":\\\"589004\\\",\\\"lastFourDigits\\\":\\\"0016\\\",\\\"basketId\\\":\\\"SP2026021766847A\\\",\\\"currency\\\":\\\"TRY\\\",\\\"itemTransactions\\\":[{\\\"itemId\\\":\\\"PKG_3\\\",\\\"paymentTransactionId\\\":\\\"30594728\\\",\\\"transactionStatus\\\":2,\\\"price\\\":179.90000000,\\\"paidPrice\\\":179.90000000,\\\"merchantCommissionRate\\\":0E-8,\\\"merchantCommissionRateAmount\\\":0E-8,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRate\\\":0E-8,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"blockageResolvedDate\\\":\\\"2026-02-25 00:00:00\\\",\\\"subMerchantPrice\\\":0E-8,\\\"subMerchantPayoutRate\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":177.67110000,\\\"convertedPayout\\\":{\\\"paidPrice\\\":179.90000000,\\\"iyziCommissionRateAmount\\\":1.97890000,\\\"iyziCommissionFee\\\":0.25000000,\\\"blockageRateAmountMerchant\\\":0E-8,\\\"blockageRateAmountSubMerchant\\\":0E-8,\\\"subMerchantPayoutAmount\\\":0E-8,\\\"merchantPayoutAmount\\\":177.67110000,\\\"iyziConversionRate\\\":0E-8,\\\"iyziConversionRateAmount\\\":0E-8,\\\"currency\\\":\\\"TRY\\\"}}],\\\"authCode\\\":\\\"762459\\\",\\\"phase\\\":\\\"AUTH\\\",\\\"mdStatus\\\":1,\\\"hostReference\\\":\\\"mock00027iyzihostrfn\\\",\\\"signature\\\":\\\"95213c24984a2697512e64026c81073da657902d39f0fc02289b06d6f5bc70d8\\\",\\\"token\\\":\\\"c60ccd6c-843b-4acb-8864-1efe2d54c43d\\\",\\\"callbackUrl\\\":\\\"https:\\/\\/dijiyazilim.com\\/iyzico-callback.php\\\",\\\"paymentStatus\\\":\\\"SUCCESS\\\",\\\"maturityChargeAmount\\\":0E-8}\"', 'MKB202602179968FC', NULL),
(24, 'SP20260217A2C5E4', NULL, 17, 'Test3 3', 'deneme@gmail.com', '9393837373', 'Deneme3', NULL, 'iyzico', 18.00, 0.00, NULL, NULL, NULL, NULL, NULL, 'completed', '9552185', 'Partial', NULL, NULL, NULL, '', '94.54.242.220', NULL, '2026-02-17 18:32:02', '2026-02-17 18:15:54', '2026-02-17 18:32:02', '2026-02-17 18:19:14', NULL, 1.6044, 4031, 24, 'IYZICO_SP20260217A2C5E4_1771352154', 'a02010bf-bd54-4445-b845-5d94c285491d', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `packages` (
  `id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
  `price` decimal(10,2) NOT NULL,
  `old_price` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `delivery_time` varchar(50) DEFAULT NULL,
  `required_field_label` varchar(255) DEFAULT 'Sosyal Medya Linki / Kullanıcı Adı',
  `required_field_placeholder` varchar(255) DEFAULT 'https://instagram.com/kullaniciadi veya @kullaniciadi',
  `required_field_hint` varchar(255) DEFAULT 'Hizmetin uygulanacağı hesabın linkini veya kullanıcı adını girin',
  `is_featured` tinyint(1) DEFAULT 0,
  `is_popular` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `total_sales` int(11) DEFAULT 0,
  `api_provider_id` int(10) UNSIGNED DEFAULT NULL,
  `api_service_id` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `packages` (`id`, `category_id`, `name`, `slug`, `description`, `features`, `price`, `old_price`, `quantity`, `delivery_time`, `required_field_label`, `required_field_placeholder`, `required_field_hint`, `is_featured`, `is_popular`, `is_active`, `sort_order`, `total_sales`, `api_provider_id`, `api_service_id`, `created_at`, `updated_at`) VALUES
(2, 17, 'Instagram 2500 Takipçi', 'instagram-2500-takipci', 'Gerçek görünümlü Türk takipçiler', '[\"Gerçek Görünümlü Hesaplar\",\"Anlık Başlangıç\",\"30 Gün Garanti\",\"7\\/24 Destek\"]', 99.90, 149.90, 2500, '0-6 Saat', 'Instagram Kullanıcı Adı veya Profil Linki', '@kullaniciadi veya https://instagram.com/kullaniciadi', 'Hesabınızın gizli olmadığından emin olun', 0, 0, 1, 6, 3, NULL, NULL, '2026-02-10 19:41:30', '2026-02-12 14:31:50'),
(3, 17, 'Instagram 5000 Takipçi', 'instagram-5000-takipci', 'Gerçek görünümlü Türk takipçiler', '[\"Gerçek Görünümlü Hesaplar\",\"Anlık Başlangıç\",\"30 Gün Garanti\",\"7\\/24 Destek\",\"Ekstra Hızlı\"]', 179.90, 249.90, 5000, '0-12 Saat', 'Instagram Kullanıcı Adı veya Profil Linki', '@kullaniciadi veya https://instagram.com/kullaniciadi', 'Hesabınızın gizli olmadığından emin olun', 1, 0, 1, 1, 8, NULL, NULL, '2026-02-10 19:41:30', '2026-02-17 18:14:14'),
(5, 17, 'Instagram 1000 Beğeni', 'instagram-1000-begeni', 'Gönderilerinize beğeni', '[\"Tüm Gönderilere Uygun\",\"Anlık Başlangıç\",\"Düşme Yok\"]', 29.90, 49.90, 1000, '0-1 Saat', 'Instagram Kullanıcı Adı veya Profil Linki', '@kullaniciadi veya https://instagram.com/kullaniciadi', 'Hesabınızın gizli olmadığından emin olun', 0, 0, 1, 7, 1, NULL, NULL, '2026-02-10 19:41:30', '2026-02-12 13:58:29'),
(6, 18, 'Instagram 5000 Beğeni', 'instagram-5000-begeni', 'Gönderilerinize beğeni', '[\"Tüm Gönderilere Uygun\",\"Anlık Başlangıç\",\"Düşme Yok\"]', 79.90, 119.90, 5000, '0-3 Saat', 'Instagram Kullanıcı Adı veya Profil Linki', '@kullaniciadi veya https://instagram.com/kullaniciadi', 'Hesabınızın gizli olmadığından emin olun', 0, 0, 1, 8, 1, NULL, NULL, '2026-02-10 19:41:30', '2026-02-11 17:38:15'),
(7, 20, 'TikTok 1000 Takipçi', 'tiktok-1000-takipci', 'TikTok hesabınız için takipçi', '[\"Kaliteli Takipçiler\",\"Hızlı Teslimat\",\"Garanti\"]', 59.90, 89.90, 1000, '0-6 Saat', 'TikTok Kullanıcı Adı veya Video Linki', '@kullaniciadi veya video linki', 'Hesabınızın gizli olmadığından emin olun', 1, 0, 1, 2, 3, NULL, NULL, '2026-02-10 19:41:30', '2026-02-17 18:11:05'),
(8, 20, 'TikTok 5000 Takipçi', 'tiktok-5000-takipci', 'TikTok hesabınız için takipçi', '[\"Kaliteli Takipçiler\",\"Hızlı Teslimat\",\"Garanti\",\"VIP Destek\"]', 199.90, 299.90, 5000, '0-24 Saat', 'TikTok Kullanıcı Adı veya Video Linki', '@kullaniciadi veya video linki', 'Hesabınızın gizli olmadığından emin olun', 0, 1, 1, 9, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-11 17:38:34'),
(9, 22, 'TikTok 10000 İzlenme', 'tiktok-10000-izlenme', 'Videolarınız için izlenme', '[\"Gerçek İzlenme\",\"Anlık Başlangıç\"]', 19.90, 39.90, 10000, '0-1 Saat', 'TikTok Kullanıcı Adı veya Video Linki', '@kullaniciadi veya video linki', 'Hesabınızın gizli olmadığından emin olun', 0, 0, 1, 10, 1, NULL, NULL, '2026-02-10 19:41:30', '2026-02-12 10:49:50'),
(10, 2, 'TikTok 5000 Beğeni', 'tiktok-5000-begeni', 'Videolarınız için beğeni', '[\"Kaliteli Beğeniler\", \"Hızlı Teslimat\"]', 49.90, 79.90, 5000, '0-3 Saat', 'TikTok Kullanıcı Adı veya Video Linki', '@kullaniciadi veya video linki', 'Hesabınızın gizli olmadığından emin olun', 0, 0, 1, 4, 1, NULL, NULL, '2026-02-10 19:41:30', '2026-02-13 18:03:45'),
(11, 23, 'YouTube 500 Abone', 'youtube-500-abone', 'Kanalınız için abone', '[\"Gerçek Aboneler\",\"Kalıcı\",\"Garanti\"]', 149.90, 249.90, 500, '1-3 Gün', 'YouTube Kanal veya Video Linki', 'https://youtube.com/watch?v=XXXXX veya kanal linki', 'Videonun herkese açık olduğundan emin olun', 1, 0, 1, 3, 1, NULL, NULL, '2026-02-10 19:41:30', '2026-02-13 18:01:26'),
(12, 3, 'YouTube 1000 Abone', 'youtube-1000-abone', 'Kanalınız için abone', '[\"Gerçek Aboneler\", \"Kalıcı\", \"Garanti\", \"VIP Destek\"]', 279.90, 399.90, 1000, '2-5 Gün', 'YouTube Kanal veya Video Linki', 'https://youtube.com/watch?v=XXXXX veya kanal linki', 'Videonun herkese açık olduğundan emin olun', 0, 1, 1, 2, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-10 19:52:12'),
(13, 3, 'YouTube 5000 İzlenme', 'youtube-5000-izlenme', 'Videolarınız için izlenme', '[\"Gerçek İzlenme\", \"Reklam Uyumlu\"]', 49.90, 79.90, 5000, '0-24 Saat', 'YouTube Kanal veya Video Linki', 'https://youtube.com/watch?v=XXXXX veya kanal linki', 'Videonun herkese açık olduğundan emin olun', 0, 0, 1, 3, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-10 19:52:12'),
(14, 3, 'YouTube 1000 Beğeni', 'youtube-1000-begeni', 'Videolarınız için beğeni', '[\"Gerçek Beğeniler\", \"Kalıcı\"]', 89.90, 129.90, 1000, '0-24 Saat', 'YouTube Kanal veya Video Linki', 'https://youtube.com/watch?v=XXXXX veya kanal linki', 'Videonun herkese açık olduğundan emin olun', 0, 0, 1, 4, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-10 19:52:12'),
(15, 4, 'Twitter 1000 Takipçi', 'twitter-1000-takipci', 'Profiliniz için takipçi', '[\"Kaliteli Takipçiler\",\"Hızlı Teslimat\"]', 69.90, 99.90, 1000, '0-12 Saat', 'Sosyal Medya Linki / Kullanıcı Adı', 'https://instagram.com/kullaniciadi veya @kullaniciadi', 'Hizmetin uygulanacağı hesabın linkini veya kullanıcı adını girin', 1, 0, 1, 4, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-11 17:37:02'),
(16, 4, 'Twitter 500 Retweet', 'twitter-500-retweet', 'Tweetleriniz için retweet', '[\"Gerçek Retweet\", \"Anlık\"]', 39.90, 59.90, 500, '0-6 Saat', 'Sosyal Medya Linki / Kullanıcı Adı', 'https://instagram.com/kullaniciadi veya @kullaniciadi', 'Hizmetin uygulanacağı hesabın linkini veya kullanıcı adını girin', 0, 0, 1, 2, 0, NULL, NULL, '2026-02-10 19:41:30', '2026-02-10 19:41:30'),
(17, 7, 'Test Paket 1', 'test-paket-1-1d8ab', 'Hahahaha la\r\nBalsjs\r\nSms', '[\"Test\",\"Deneme\",\"Hello\",\"World\"]', 18.00, 29.90, 100, '0-6', 'Kullanıcı Adınız', '@kullaniciadi', 'Gizli olmasın', 1, 1, 1, 5, 12, 1, '4177', '2026-02-10 21:44:56', '2026-02-17 18:15:54');

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

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

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `show_in_menu` tinyint(1) DEFAULT 0,
  `show_in_footer` tinyint(1) DEFAULT 0,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `is_active`, `show_in_menu`, `show_in_footer`, `sort_order`, `created_at`) VALUES
(1, 'Hakkımızda', 'hakkimizda', '<h2>Hakkımızda</h2><p>Türkiyenin en güvenilir sosyal medya hizmetleri.</p>', 1, 0, 1, 1, '2026-02-10 19:41:30'),
(2, 'Kullanım Koşulları', 'kullanim-kosullari', '<h2>Kullanım Koşulları</h2><p>Sitemizi kullanarak bu koşulları kabul etmiş olursunuz.</p>', 1, 0, 1, 2, '2026-02-10 19:41:30'),
(3, 'Gizlilik Politikası', 'gizlilik-politikasi', '<h2>Gizlilik Politikası</h2><p>Kişisel verileriniz bizim için önemlidir.</p>', 1, 0, 1, 3, '2026-02-10 19:41:30'),
(4, 'İade Politikası', 'iade-politikasi', '<h2>İade Politikası</h2><p>İade koşullarımız hakkında bilgi.</p>', 1, 0, 1, 4, '2026-02-10 19:41:30'),
(5, 'Test', 'test', '<strong>Bu Bir Test Sayfasdır.</strong>', 1, 1, 1, 0, '2026-02-11 09:34:07');

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

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

CREATE TABLE `payment_methods` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `payment_methods` (`id`, `name`, `code`, `description`, `icon`, `settings`, `is_active`, `sort_order`, `created_at`) VALUES
(1, 'Havale / EFT', 'bank_transfer', 'Banka havalesi ile ödeme yapın', 'fas fa-university', NULL, 1, 1, '2026-02-10 19:41:30'),
(2, 'iyzico', 'iyzico', 'Kredi/Banka kartı ile güvenli ödeme', 'fas fa-credit-card', '{\"installments\": [1, 2, 3, 6, 9, 12]}', 1, 2, '2026-02-10 19:41:30');

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

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

CREATE TABLE `popups` (
  `id` int(11) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL COMMENT 'Popup başlığı',
  `content` text DEFAULT NULL COMMENT 'Popup içeriği (HTML destekli)',
  `image` varchar(500) DEFAULT NULL COMMENT 'Popup resmi (opsiyonel)',
  `button_text` varchar(100) DEFAULT NULL COMMENT 'Buton yazısı',
  `button_url` varchar(500) DEFAULT NULL COMMENT 'Buton linki',
  `button_color` varchar(20) DEFAULT '#6366f1' COMMENT 'Buton rengi',
  `position` enum('center','bottom-right','bottom-left','top-right','top-left') DEFAULT 'center' COMMENT 'Popup konumu',
  `size` enum('small','medium','large') DEFAULT 'medium' COMMENT 'Popup boyutu',
  `animation` enum('fade','slide','zoom','bounce') DEFAULT 'fade' COMMENT 'Animasyon tipi',
  `show_close_button` tinyint(1) DEFAULT 1 COMMENT 'Kapatma butonu göster',
  `close_on_overlay` tinyint(1) DEFAULT 1 COMMENT 'Overlay tıklanınca kapat',
  `show_delay` int(11) DEFAULT 0 COMMENT 'Gösterim gecikmesi (saniye)',
  `display_frequency` enum('always','once','once_per_session','once_per_day') DEFAULT 'once_per_session' COMMENT 'Gösterim sıklığı',
  `start_date` datetime DEFAULT NULL COMMENT 'Başlangıç tarihi',
  `end_date` datetime DEFAULT NULL COMMENT 'Bitiş tarihi',
  `show_on_pages` text DEFAULT NULL COMMENT 'Gösterilecek sayfalar (JSON)',
  `exclude_pages` text DEFAULT NULL COMMENT 'Hariç tutulan sayfalar (JSON)',
  `target_audience` enum('all','guests','members') DEFAULT 'all' COMMENT 'Hedef kitle',
  `priority` int(11) DEFAULT 0 COMMENT 'Öncelik (yüksek = önce)',
  `is_active` tinyint(1) DEFAULT 1 COMMENT 'Aktif mi?',
  `view_count` int(11) DEFAULT 0 COMMENT 'Görüntülenme sayısı',
  `click_count` int(11) DEFAULT 0 COMMENT 'Tıklanma sayısı',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `popups` (`id`, `title`, `content`, `image`, `button_text`, `button_url`, `button_color`, `position`, `size`, `animation`, `show_close_button`, `close_on_overlay`, `show_delay`, `display_frequency`, `start_date`, `end_date`, `show_on_pages`, `exclude_pages`, `target_audience`, `priority`, `is_active`, `view_count`, `click_count`, `created_at`, `updated_at`) VALUES
(1, 'Paketix Popup', '', 'popup_1770892152_a3dcdd66.png', 'Hemen İncele!', 'https://www.google.com', '#6366f1', 'center', 'large', 'bounce', 1, 1, 5, 'always', NULL, NULL, NULL, NULL, 'all', 0, 1, 208, 2, '2026-02-12 10:26:45', '2026-02-17 18:16:26');

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

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

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('string','int','float','bool','json') DEFAULT 'string',
  `setting_group` varchar(50) DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `setting_group`, `created_at`, `updated_at`) VALUES
(1, 'site_url', 'https://dijiyazilim.com', 'string', 'general', '2026-02-10 19:41:30', '2026-02-17 17:48:04'),
(2, 'site_name', 'Paketix Script', 'string', 'general', '2026-02-10 19:41:30', '2026-02-12 10:48:46'),
(3, 'site_title', 'Paketix - Sosyal Medya Paketleri', 'string', 'general', '2026-02-10 19:41:30', '2026-02-12 10:48:46'),
(4, 'site_description', 'Instagram, TikTok, YouTube için uygun fiyatlı sosyal medya büyütme paketleri', 'string', 'general', '2026-02-10 19:41:30', '2026-02-12 10:48:46'),
(5, 'site_keywords', 'instagram takipçi, tiktok beğeni, youtube abone, sosyal medya', 'string', 'general', '2026-02-10 19:41:30', '2026-02-11 13:45:35'),
(6, 'site_logo', 'uploads/logo_1770848085.png', 'string', 'general', '2026-02-10 19:41:30', '2026-02-11 22:14:45'),
(7, 'site_favicon', 'uploads/favicon_1770851337.png', 'string', 'general', '2026-02-10 19:41:30', '2026-02-11 23:08:57'),
(8, 'active_theme_id', '34', 'int', 'appearance', '2026-02-10 19:41:30', '2026-02-13 17:19:01'),
(9, 'contact_email', 'info@paketix.com', 'string', 'contact', '2026-02-10 19:41:30', '2026-02-12 10:35:08'),
(10, 'contact_phone', '+90 5555555555', 'string', 'contact', '2026-02-10 19:41:30', '2026-02-12 10:35:08'),
(11, 'contact_address', 'İstanbul, Türkiye', 'string', 'contact', '2026-02-10 19:41:30', '2026-02-12 10:35:08'),
(12, 'whatsapp_number', '+17095067729', 'string', 'contact', '2026-02-10 19:41:30', '2026-02-11 13:45:48'),
(13, 'instagram_username', 'paketixx', 'string', 'contact', '2026-02-10 19:41:30', '2026-02-11 13:45:48'),
(14, 'currency_symbol', '₺', 'string', 'payment', '2026-02-10 19:41:30', '2026-02-11 13:45:41'),
(15, 'currency_code', 'TRY', 'string', 'payment', '2026-02-10 19:41:30', '2026-02-11 13:45:41'),
(16, 'maintenance_mode', '0', 'bool', 'system', '2026-02-10 19:41:30', '2026-02-17 18:24:37'),
(17, 'footer_text', '© 2026 Paketix. Tüm hakları saklıdır.', 'string', 'general', '2026-02-10 19:41:30', '2026-02-13 17:20:55'),
(18, 'footer_about', 'Türkiye\'nin Ücretsiz Paket Satış Yazılımı!', 'string', 'general', '2026-02-10 19:41:30', '2026-02-13 17:20:55'),
(19, 'telegram_username', 'paketixx', 'string', 'social', '2026-02-11 09:48:27', '2026-02-11 13:45:48'),
(20, 'twitter_username', 'Paketix', 'string', 'social', '2026-02-11 09:48:27', '2026-02-11 13:45:48'),
(21, 'facebook_username', 'paketix', 'string', 'social', '2026-02-11 09:48:27', '2026-02-11 13:45:48'),
(22, 'youtube_channel', 'Paketix', 'string', 'social', '2026-02-11 09:48:27', '2026-02-11 13:45:48'),
(23, 'tiktok_username', 'Paketix', 'string', 'social', '2026-02-11 09:48:27', '2026-02-11 13:45:48'),
(24, 'footer_whatsapp_enabled', '1', 'string', 'footer', '2026-02-11 09:49:57', '2026-02-13 17:20:55'),
(25, 'smtp_enabled', '1', 'bool', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(26, 'smtp_host', 'mail.dijiyazilim.com', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(27, 'smtp_port', '465', 'int', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(28, 'smtp_username', 'smm@dijiyazilim.com', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(29, 'smtp_password', 'Şifre', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-17 18:32:59'),
(30, 'smtp_encryption', 'ssl', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(31, 'smtp_from_email', 'smm@dijiyazilim.com', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(32, 'smtp_from_name', 'Paketix', 'string', 'smtp', '2026-02-11 11:13:36', '2026-02-11 14:23:56'),
(33, 'google_analytics_id', '', 'string', 'seo', '2026-02-11 13:45:35', '2026-02-11 13:45:35'),
(34, 'facebook_pixel_id', '', 'string', 'social', '2026-02-11 13:45:35', '2026-02-11 13:45:35'),
(35, 'demo_mode', '0', 'bool', 'general', '2026-02-11 13:52:33', '2026-02-13 17:12:40'),
(36, 'kdv_enabled', '0', 'bool', 'finance', '2026-02-12 10:31:12', '2026-02-13 17:20:55'),
(37, 'kdv_rate', '20', 'float', 'finance', '2026-02-12 10:31:12', '2026-02-12 10:48:46'),
(38, 'kdv_included', '0', 'bool', 'finance', '2026-02-12 10:31:12', '2026-02-13 17:20:55'),
(60, 'telegram_bot_enabled', '1', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(61, 'telegram_bot_token', '8162328294:AAEeR0u7wbemk_jTdvFtWxqdljQkA1JXpsQ', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(62, 'telegram_chat_id', '923714768', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(63, 'telegram_notify_new_order', '1', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(64, 'telegram_notify_payment', '1', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(65, 'telegram_notify_completed', '1', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(66, 'telegram_notify_contact', '1', 'string', 'telegram', '2026-02-12 14:31:11', '2026-02-12 14:31:11'),
(67, 'iyzico_enabled', '1', 'bool', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(68, 'iyzico_api_key', 'sandbox-MOECwHfOxX7dQPbjQSPYkifm8md4w1mX', 'string', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(69, 'iyzico_secret_key', 'sandbox-JvXtSLMMaaruyDUeCjtCGuRmV1MLmucH', 'string', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(70, 'iyzico_sandbox', '1', 'bool', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(71, 'iyzico_3d_enabled', '1', 'bool', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(72, 'iyzico_installment_enabled', '1', 'bool', 'payment', '2026-02-17 17:02:12', '2026-02-17 18:08:20'),
(79, 'iyzico_3d_secure', '1', 'string', 'payment', '2026-02-17 17:30:29', '2026-02-17 17:36:24'),
(80, 'iyzico_installment', '1', 'string', 'payment', '2026-02-17 17:30:29', '2026-02-17 17:36:24'),
(81, 'iyzico_max_installment', '10', 'string', 'payment', '2026-02-17 17:30:29', '2026-02-17 18:08:20');

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

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

CREATE TABLE `support_messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `is_admin` tinyint(1) DEFAULT 0,
  `message` text NOT NULL,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachments`)),
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `support_messages` (`id`, `ticket_id`, `user_id`, `is_admin`, `message`, `attachments`, `created_at`) VALUES
(2, 2, NULL, 0, 'Denememesajdenememesajdenememesaj', '[{\"name\":\"Paragraf metniniz.png\",\"path\":\"uploads\\/support\\/ticket_1770927888_0_0d233306.png\"}]', '2026-02-12 20:24:48'),
(3, 2, NULL, 0, 'Jdjdhdjdjdjdjdjddn', NULL, '2026-02-12 20:25:19'),
(4, 3, 1, 0, 'Denemjdjdndndndjdjdhd', NULL, '2026-02-12 20:27:28'),
(6, 3, 1, 1, 'Merhabalar', '[{\"name\":\"Paragraf metniniz.png\",\"path\":\"uploads\\/support\\/admin_1770929175_0_c376c7c1.png\"}]', '2026-02-12 20:46:15'),
(7, 2, 1, 1, 'Test mesajı', NULL, '2026-02-12 20:51:06');

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

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

CREATE TABLE `support_tickets` (
  `id` int(10) UNSIGNED NOT NULL,
  `ticket_number` varchar(20) NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `order_id` int(10) UNSIGNED DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `category` enum('general','order','payment','technical','refund','other') DEFAULT 'general',
  `priority` enum('low','normal','high','urgent') DEFAULT 'normal',
  `status` enum('open','answered','waiting','closed') DEFAULT 'open',
  `guest_name` varchar(100) DEFAULT NULL,
  `guest_email` varchar(255) DEFAULT NULL,
  `guest_phone` varchar(20) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `closed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `support_tickets` (`id`, `ticket_number`, `user_id`, `order_id`, `subject`, `category`, `priority`, `status`, `guest_name`, `guest_email`, `guest_phone`, `ip_address`, `created_at`, `updated_at`, `closed_at`) VALUES
(2, 'TKT-26911DD2', NULL, NULL, 'Denemekonu', 'technical', 'urgent', 'closed', 'Deneme denem', 'alperaydin4209@gmail.com', '05076576457', '94.54.242.88', '2026-02-12 20:24:48', '2026-02-12 20:51:54', NULL),
(3, 'TKT-F6E5F841', 1, NULL, 'Denem', 'general', 'normal', 'closed', NULL, NULL, NULL, NULL, '2026-02-12 20:27:28', '2026-02-12 20:46:34', NULL);

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

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

CREATE TABLE `themes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `folder` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `primary_color` varchar(7) DEFAULT '#6366f1',
  `secondary_color` varchar(7) DEFAULT '#8b5cf6',
  `accent_color` varchar(7) DEFAULT '#22d3ee',
  `background_color` varchar(7) DEFAULT '#0f172a',
  `text_color` varchar(7) DEFAULT '#f8fafc',
  `header_bg_color` varchar(7) DEFAULT NULL,
  `is_dark` tinyint(1) DEFAULT 1,
  `is_active` tinyint(1) DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `themes` (`id`, `name`, `folder`, `description`, `primary_color`, `secondary_color`, `accent_color`, `background_color`, `text_color`, `header_bg_color`, `is_dark`, `is_active`, `sort_order`, `created_at`) VALUES
(1, 'Modern Dark', 'modern-dark', 'Koyu renkli modern tasarım', '#6366f1', '#8b5cf6', '#22d3ee', '#0f172a', '#f8fafc', '#0c1222', 1, 1, 1, '2026-02-10 19:41:30'),
(2, 'Clean Light', 'clean-light', 'Açık renkli minimalist tasarım', '#3b82f6', '#0ea5e9', '#f59e0b', '#ffffff', '#1e293b', '#1e293b', 0, 1, 2, '2026-02-10 19:41:30'),
(3, 'Gradient Pro', 'gradient-pro', 'Gradient geçişli profesyonel tema', '#ec4899', '#8b5cf6', '#06b6d4', '#1a1a2e', '#eef2ff', '#12121f', 1, 1, 3, '2026-02-10 19:41:30'),
(4, 'Neon Glow', 'neon-glow', 'Neon efektli karanlık tema', '#00ff88', '#00d4ff', '#ff00ff', '#0a0a0a', '#ffffff', '#050505', 1, 1, 4, '2026-02-10 19:41:30'),
(5, 'Corporate Blue', 'corporate-blue', 'Kurumsal mavi tema', '#1e40af', '#3b82f6', '#f97316', '#f8fafc', '#1e293b', '#0f1729', 0, 1, 5, '2026-02-10 19:41:30'),
(6, 'Starter Orange', 'starter-orange', 'Enerjik turuncu tema', '#f97316', '#fb923c', '#0ea5e9', '#fffbeb', '#1c1917', '#1c1410', 0, 1, 6, '2026-02-10 19:41:30'),
(7, 'Forest Green', 'forest-green', 'Doğal yeşil tema', '#059669', '#10b981', '#f59e0b', '#022c22', '#ecfdf5', '#021a12', 1, 1, 7, '2026-02-10 19:41:30'),
(8, 'Royal Purple', 'royal-purple', 'Zarif mor tema', '#7c3aed', '#a855f7', '#f472b6', '#1e1b4b', '#f5f3ff', '#130f2b', 1, 1, 8, '2026-02-10 19:41:30'),
(12, 'Ateş', 'ates', 'Kırmızı ve turuncu tonlarında ateşli, enerjik bir tema', '#ef4444', '#f97316', '#fbbf24', '#18100e', '#fef2f2', '#120a08', 1, 1, 1, '2026-02-13 08:53:19'),
(31, 'Altın', 'altin', 'Altın sarısı ve turuncu, premium SMM panel görünümü', '#eab308', '#f59e0b', '#fcd34d', '#0d0b05', '#fefce8', '#0d0905', 1, 1, 10, '2026-02-13 09:02:01'),
(32, 'Okyanus', 'okyanus', 'Mavi ve cyan tonları, güvenilir SMM panel görünümü', '#3b82f6', '#06b6d4', '#22d3ee', '#030712', '#eff6ff', '#020610', 1, 1, 11, '2026-02-13 09:02:21'),
(33, 'Zümrüt', 'zumrut', 'Yeşil ve turkuaz, başarı odaklı SMM panel teması', '#10b981', '#14b8a6', '#34d399', '#020c08', '#ecfdf5', '#020a07', 1, 1, 12, '2026-02-13 09:02:30'),
(34, 'Kiraz', 'kiraz', 'Pembe ve kırmızı, dikkat çekici SMM panel teması', '#e11d48', '#f43f5e', '#fb7185', '#0f0508', '#fff1f2', '#1a0a10', 1, 1, 13, '2026-02-13 09:02:57'),
(36, 'Ferrari', 'ferrari', 'Yarış kırmızısı ve altın sarısı, hızlı ve prestijli SMM panel teması', '#ff0000', '#ffd700', '#ff6b00', '#120808', '#fff8dc', '#0f0505', 1, 1, 20, '2026-02-13 09:05:17');

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `role` enum('user','admin') DEFAULT 'user',
  `status` enum('active','inactive','banned') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `username`, `email`, `password`, `full_name`, `phone`, `role`, `status`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'alperaydin4209@gmail.com', '$2y$10$ggfsbA.L1BOFFp686dBTAejYLvtGErMNEnHXjE/qGDJPI69y3tqFi', 'Admin', '', 'admin', 'active', '2026-02-10 19:41:30', '2026-02-11 18:00:30'),
(3, 'demo', 'demo@demo.com', '$2y$10$9ZzVTXpCyUyY3R2AYnMGReiM.tq2qUXz02uWegiaUQMrJiS4GpdGK', 'Demo Hesap', '05555555555', 'admin', 'active', '2026-02-11 12:16:01', '2026-02-11 14:44:41');

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

--
-- Tablo için indeksler `api_logs`
--
ALTER TABLE `api_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `provider_id` (`provider_id`),
  ADD KEY `created_at` (`created_at`);

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

--
-- Tablo için indeksler `api_services`
--
ALTER TABLE `api_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `provider_service` (`provider_id`,`service_id`);

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

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

--
-- Tablo için indeksler `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `idx_parent_id` (`parent_id`);

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

--
-- Tablo için indeksler `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `is_active` (`is_active`),
  ADD KEY `expires_at` (`expires_at`);

--
-- Tablo için indeksler `coupon_usage`
--
ALTER TABLE `coupon_usage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupon_id` (`coupon_id`),
  ADD KEY `ip_address` (`ip_address`),
  ADD KEY `order_id` (`order_id`);

--
-- Tablo için indeksler `cron_logs`
--
ALTER TABLE `cron_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order_type` (`order_id`,`log_type`),
  ADD KEY `idx_order_status` (`order_id`,`log_type`,`status_sent`),
  ADD KEY `idx_created` (`created_at`);

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

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

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

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

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

--
-- Tablo için indeksler `iyzico_installments`
--
ALTER TABLE `iyzico_installments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_family_count` (`card_family`,`installment_count`);

--
-- Tablo için indeksler `iyzico_logs`
--
ALTER TABLE `iyzico_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_order_id` (`order_id`),
  ADD KEY `idx_conversation_id` (`conversation_id`),
  ADD KEY `idx_action` (`action`),
  ADD KEY `idx_created_at` (`created_at`);

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

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

--
-- Tablo için indeksler `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_active` (`is_active`),
  ADD KEY `idx_dates` (`start_date`,`end_date`);

--
-- Tablo için indeksler `notification_reads`
--
ALTER TABLE `notification_reads`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_read` (`notification_id`,`user_id`,`session_id`);

--
-- Tablo için indeksler `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_number` (`order_number`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `package_id` (`package_id`),
  ADD KEY `idx_api_order_id` (`api_order_id`),
  ADD KEY `idx_invoice_number` (`invoice_number`),
  ADD KEY `idx_iyzico_conversation` (`iyzico_conversation_id`),
  ADD KEY `idx_iyzico_token` (`iyzico_token`),
  ADD KEY `idx_iyzico_payment` (`iyzico_payment_id`);

--
-- Tablo için indeksler `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `api_provider_id` (`api_provider_id`);

--
-- Tablo için indeksler `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`);

--
-- Tablo için indeksler `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Tablo için indeksler `popups`
--
ALTER TABLE `popups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `is_active` (`is_active`),
  ADD KEY `priority` (`priority`),
  ADD KEY `start_date` (`start_date`),
  ADD KEY `end_date` (`end_date`);

--
-- Tablo için indeksler `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Tablo için indeksler `support_messages`
--
ALTER TABLE `support_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ticket` (`ticket_id`);

--
-- Tablo için indeksler `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ticket_number` (`ticket_number`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_ticket_number` (`ticket_number`);

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

--
-- Tablo için indeksler `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `username` (`username`);

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `api_services`
--
ALTER TABLE `api_services`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5606;

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

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

--
-- Tablo için AUTO_INCREMENT değeri `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `cron_logs`
--
ALTER TABLE `cron_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

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

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Tablo için AUTO_INCREMENT değeri `iyzico_installments`
--
ALTER TABLE `iyzico_installments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- Tablo için AUTO_INCREMENT değeri `iyzico_logs`
--
ALTER TABLE `iyzico_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `notification_reads`
--
ALTER TABLE `notification_reads`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- Tablo için AUTO_INCREMENT değeri `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- Tablo için AUTO_INCREMENT değeri `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- Tablo için AUTO_INCREMENT değeri `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- Tablo için AUTO_INCREMENT değeri `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- Tablo için AUTO_INCREMENT değeri `support_messages`
--
ALTER TABLE `support_messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- Tablo için AUTO_INCREMENT değeri `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

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

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

--
-- Tablo kısıtlamaları `api_services`
--
ALTER TABLE `api_services`
  ADD CONSTRAINT `api_services_ibfk_1` FOREIGN KEY (`provider_id`) REFERENCES `api_providers` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `coupon_usage`
--
ALTER TABLE `coupon_usage`
  ADD CONSTRAINT `fk_coupon_usage_coupon` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `notification_reads`
--
ALTER TABLE `notification_reads`
  ADD CONSTRAINT `notification_reads_ibfk_1` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `packages_ibfk_2` FOREIGN KEY (`api_provider_id`) REFERENCES `api_providers` (`id`) ON DELETE SET NULL;

--
-- Tablo kısıtlamaları `support_messages`
--
ALTER TABLE `support_messages`
  ADD CONSTRAINT `support_messages_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD CONSTRAINT `support_tickets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE 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 */;
