-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 18 Şub 2026, 22:42:21
-- Sunucu sürümü: 11.4.9-MariaDB
-- PHP Sürümü: 8.4.16

START TRANSACTION;



--
-- Veritabanı: `vlinguacom_db`
--

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

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

CREATE TABLE `audios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `audios` (`id`, `title`, `url`, `created_at`, `updated_at`) VALUES
(28, 'A', 'audios/hXPOwIQ6ibWQIt6YxfgbXeNhZzW2wrz6E9EhW3U3.wav', '2025-10-02 09:51:52', '2025-10-02 09:51:52'),
(29, 'B', 'audios/SxFyK7DM7gwsJ8ydRzWZqUcfDZ3S8LctIaUBLMc5.wav', '2025-10-02 09:52:08', '2025-10-02 09:52:08'),
(30, 'C', 'audios/sY3euTef6LMXzjTi7Xqe9EuLAuWe21oLj2c0etLz.wav', '2025-10-02 09:52:21', '2025-10-02 09:52:21'),
(31, 'D', 'audios/8iehDYsa9RG1geOz4R5L1TQdif3X2XaB4CPrsQUm.wav', '2025-10-02 09:52:30', '2025-10-02 09:52:30'),
(32, 'E', 'audios/vR4rssEPeEVyGU7iW2twIsYgJ4F3K4nc0kcSaxTD.wav', '2025-10-02 09:52:40', '2025-10-02 09:52:40'),
(33, 'F', 'audios/EiC8u4EEtk5rPfdmllrxwDJq0xfqWCilC2VaVRsE.wav', '2025-10-02 09:52:49', '2025-10-02 09:52:49'),
(34, 'G', 'audios/5C7AWHWrEkquywLQDcu8DoiHHmKIznnQ8PG1Mltx.wav', '2025-10-02 09:52:59', '2025-10-02 09:52:59'),
(35, 'H', 'audios/iVHZ3a6nuiJQVcxKCGGpV3gXiJve7aazdWizL2dq.wav', '2025-10-02 09:53:10', '2025-10-02 09:53:10'),
(36, 'I', 'audios/aA7yQemimte4qqcOTPVLUAGsrNoc634xZBzgkgXA.wav', '2025-10-02 09:53:20', '2025-10-02 09:53:20'),
(37, 'J', 'audios/Xrh46GtHwShyboYaGJEV6095VJNdNAbo0HNYAvvu.wav', '2025-10-02 09:53:30', '2025-10-02 09:53:30'),
(38, 'K', 'audios/E3GySeDOX30RJjXJt7tWHM36YNKPqqNv9JNNvcnz.wav', '2025-10-02 09:53:40', '2025-10-02 09:53:40'),
(39, 'L', 'audios/lkZ4lFWSPg0kpw8fpsdkhQkKeHOvkPsklQicvvp1.wav', '2025-10-02 09:53:48', '2025-10-02 09:53:48'),
(40, 'M', 'audios/gcOwgZohlm0mgeCHpoXBOfPyIqTZzFnmcqow5v22.wav', '2025-10-02 09:53:57', '2025-10-02 09:53:57'),
(41, 'N', 'audios/3rTfZhHveehZjqalgSH8d8Twhjxd4IXS1DwyCDfK.wav', '2025-10-02 09:54:05', '2025-10-02 09:54:05'),
(42, 'O', 'audios/43xKsZcy678GuczSCMQSIzfPmL4tCPvO4BMHkfox.wav', '2025-10-02 09:54:13', '2025-10-02 09:54:13'),
(43, 'P', 'audios/U2YkJpidzyqUsPtHloWHmBpnAq4d1cVZj6m4kYvc.wav', '2025-10-02 09:54:22', '2025-10-02 09:54:22'),
(44, 'Q', 'audios/FMVaxs9N4HsLYUSbrae1vQdu8Gqn4Yh796y17SyB.wav', '2025-10-02 09:54:30', '2025-10-02 09:54:30'),
(45, 'R', 'audios/B533SfbOLesH8IPxdkPYujbC2yzh6N39vCk0MLIE.wav', '2025-10-02 09:54:39', '2025-10-02 09:54:39'),
(46, 'S', 'audios/SOJqIDpfmnB7xHlYR3Pl0YpDko7nbDiSnZgKo4OW.wav', '2025-10-02 09:54:51', '2025-10-02 09:54:51'),
(47, 'T', 'audios/F89zRrmMoIyMoPmVLNtqEGfUGKyqMyzn9iW9AMiw.wav', '2025-10-02 09:55:00', '2025-10-02 09:55:00'),
(48, 'U', 'audios/OWUJduCavlwMRotu7MVek65qjTUednl46iPfF2Ix.wav', '2025-10-02 09:55:07', '2025-10-02 09:55:07'),
(49, 'V', 'audios/mwfu5F5OmJkoU2lAG7AxcCATKny9DUc29DhnvLUX.wav', '2025-10-02 09:55:15', '2025-10-02 09:55:15'),
(50, 'W', 'audios/LMMT5KFhHH3iSl0tiZE6Vb8HruwttN2Jc17FFxbu.wav', '2025-10-02 09:55:22', '2025-10-02 09:55:22'),
(51, 'X', 'audios/Wi87FSMWLlReRpDl618oiTVpSzDfs3KwEa7IsyjZ.wav', '2025-10-02 09:55:31', '2025-10-02 09:55:31'),
(52, 'Y', 'audios/dM2eAyyCdP46vYIirGbFNrqYmMZTsl9yqS1Hzhov.wav', '2025-10-02 09:55:40', '2025-10-02 09:55:40'),
(53, 'Z', 'audios/mphfUlTHuXdXoOdGtapepol2zGy9V3yVFVO2b2W2.wav', '2025-10-02 09:55:46', '2025-10-02 09:55:46'),
(54, '1', 'audios/3r3DNpcXTFLh6UIJ8ptRNRAuBdhi2FF7J6ZdPvDI.mp3', '2026-02-09 09:20:19', '2026-02-09 09:20:19'),
(55, '2', 'audios/qFPsqStAPVdgck5PzfyEE7Nx1g9U49gRu89lj9ck.mp3', '2026-02-09 09:20:28', '2026-02-09 09:20:28'),
(56, '3', 'audios/c1kSo9n74L7Prb4JD5yjg2oCphhpJgdj50XXdEWG.mp3', '2026-02-09 09:20:35', '2026-02-09 09:20:35'),
(57, '4', 'audios/aE766knNLxoFPP5mkwIpwLjA7RaoLGYpUav3Htrw.mp3', '2026-02-09 09:20:40', '2026-02-09 09:20:40'),
(58, '5', 'audios/YICbFZQD8YBcyLTMAuqbeLE2fHbxTglWuudN67zX.mp3', '2026-02-09 09:20:46', '2026-02-09 09:20:46'),
(59, '6', 'audios/WeHBI9hB9E5TarwJDVXLXMPF8LmzUqSs6cuT6zXf.mp3', '2026-02-09 09:20:51', '2026-02-09 09:20:51'),
(60, '7', 'audios/Xb0uhk5NjIEiodaEh77WvAIxwta9WLh9zguUXjpV.mp3', '2026-02-09 09:20:59', '2026-02-09 09:20:59'),
(61, '8', 'audios/UqSf2GTIS2VONra9tetauPGB2Dpdc3OhwGZknuXW.mp3', '2026-02-09 09:21:08', '2026-02-09 09:21:08'),
(62, '9', 'audios/AmHtYXkMGitDeZBvl1VNAJ4tqf9D9epWU8mWORrq.mp3', '2026-02-09 09:21:14', '2026-02-09 09:21:14'),
(63, '10', 'audios/UINCvB87rLrZk3wwzMsS5x8zHSUGXqb0yc1XKHVb.mp3', '2026-02-09 09:21:19', '2026-02-09 09:21:19'),
(64, '11', 'audios/w6nruiTvIRSy5DUeEmp7fA7OjfAhlRwXQYnCHPmZ.mp3', '2026-02-09 09:21:24', '2026-02-09 09:21:24'),
(65, '12', 'audios/d3A4cb2fOIQDTx6ITOqW2FNBSolFvBzzSY0dKvbh.mp3', '2026-02-09 09:21:30', '2026-02-09 09:21:30'),
(66, '13', 'audios/z4S4p4lgR14lvCBn6NOa12SvDV0g4w2EFuN4ikyD.mp3', '2026-02-09 09:21:36', '2026-02-09 09:21:36');

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

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

CREATE TABLE `capital_matches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_image_path` varchar(255) NOT NULL,
  `capital_image_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `flag_matches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `flag_image_path` varchar(255) NOT NULL,
  `country_image_path` varchar(255) NOT NULL,
  `country_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `images` (`id`, `title`, `description`, `image_url`, `created_at`, `updated_at`) VALUES
(2, 'Lingoo 1 Alfabe', 'Lingoo 1 Alfabe', 'images/zgIyL9CB0pQTJasXwLWR9MWI4A9B3uYgZRqFkxyg.png', '2025-10-02 08:17:58', '2026-02-05 07:20:23'),
(9, 'gule-gule-kart', 'gule-gule-kart', 'images/X3O3GrjtwzUmM8Ez70g9IkmuEky1HQ2OgGoOQdgl.png', '2026-02-05 07:41:51', '2026-02-05 07:41:51'),
(10, 'gule-gule-kart-yazi', 'gule-gule-kart-yazi', 'images/jhYJWgIXo7htImg8hR4c6YFekVHIIbrDSu8MMJoH.png', '2026-02-05 07:42:06', '2026-02-05 07:42:06'),
(11, 'gunaydin-kart', 'gunaydin-kart', 'images/Lr8O6pyFPycdHDo2NhhMKBektRY0Hsy5EdYhLZVX.png', '2026-02-05 07:42:26', '2026-02-05 07:42:26'),
(12, 'gunaydin-kart-yazi', 'gunaydin-kart-yazi', 'images/FIILksuDHQLywuNEISVAYI5Vk2arvVeBQZqBiIVD.png', '2026-02-05 07:43:05', '2026-02-05 07:43:05'),
(13, 'iyi-aksamlar-kart', 'iyi-aksamlar-kart', 'images/9MYlYf5oDCZEl86PKkEcuccmtt8liFjUa60SdNG6.png', '2026-02-05 07:43:17', '2026-02-05 07:43:17'),
(14, 'iyi-aksamlar-kart-yazi', 'iyi-aksamlar-kart-yazi', 'images/xEy8sBSYiNt6nVDT3BbF7fNajyC3Z4j0x9vFFnI0.png', '2026-02-05 07:43:26', '2026-02-05 07:43:26'),
(15, 'iyi-geceler-kart', 'iyi-geceler-kart', 'images/02ETqwuQb09AYK6d4SfxNFicNCYY116CrloHUvkN.png', '2026-02-05 07:43:40', '2026-02-05 07:43:40'),
(16, 'iyi-geceler-kart-yazi', 'iyi-geceler-kart-yazi', 'images/1JG83xZVRngybkNpG11qqwVfz7EssC9wmt6FjXaF.png', '2026-02-05 07:43:57', '2026-02-05 07:43:57'),
(17, 'merhaba-kart', 'merhaba-kart', 'images/Yup83FYaGZZgUyo45Qyhvvrlvs1RcOdYecyjdqhE.png', '2026-02-05 07:44:27', '2026-02-05 07:44:27'),
(18, 'merhaba-kart-yazi', 'merhaba-kart-yazi', 'images/ODBMHCOPJP9k9f59PVWXOeodtuTTv8YsdZEAa3hv.png', '2026-02-05 07:44:38', '2026-02-05 07:44:38'),
(19, 'Etkinlik 1', 'Etkinlik 1', 'images/8DuDwHsIM8ysoafhEcirn9NG0qB70zfEt3Zmz11V.png', '2026-02-05 12:04:26', '2026-02-05 12:04:26'),
(20, 'Lektion 1', 'Lektion 1', 'images/7ASC7294mzxTM8JcWIo2RbulBWnaqTTfHw7Ih8Fn.png', '2026-02-05 12:05:02', '2026-02-05 12:05:02'),
(21, 'Lektion 2', 'Lektion 2', 'images/9xSm2mOTTSDVcB4niSH2RnWt4JNPjUEyPK3i6Gpe.png', '2026-02-05 12:05:12', '2026-02-05 12:05:12'),
(22, 'Lektion 3', 'Lektion 3', 'images/GXqkCitSUVFKajlVIY2Hg5e8W0lcKRi9d7iATnft.png', '2026-02-05 12:05:23', '2026-02-05 12:05:23'),
(23, 'Lektion 4', 'Lektion 4', 'images/BT4xCahGnKRIqKyjyzkf88oIyrb4t5CppY7lIM13.png', '2026-02-05 12:05:44', '2026-02-05 12:05:44'),
(24, 'Lektion 5', 'Lektion 5', 'images/lbQUEBNcWyXektZNd3mPZBkXLMULXDS0oP7bI5jy.png', '2026-02-05 12:05:57', '2026-02-05 12:05:57'),
(25, 'Lektion 6', 'Lektion 6', 'images/viEiWByx6EpMLDhfBRze4PTceqR1PMUCxQCLvbIY.png', '2026-02-05 12:06:09', '2026-02-05 12:06:09'),
(26, 'Lektion 7', 'Lektion 7', 'images/TmwQyEwEoZCnxXyS6OJuQRDGYv77XXolKfT2ZwAB.png', '2026-02-05 12:06:24', '2026-02-05 12:06:24'),
(27, 'Lektion 8', 'Lektion 8', 'images/WCouyZyMVUCV7keMEalMAfrBJM0iIg7SIAMn8NL4.png', '2026-02-05 12:06:36', '2026-02-05 12:06:36'),
(28, 'Lektion 9', 'Lektion 9', 'images/EbIZa9YVcUSauNxWpxjSV7H0Rtjv9nDd7ki1psDf.png', '2026-02-05 12:06:49', '2026-02-05 12:06:49'),
(29, 'Lektion 10', 'Lektion 10', 'images/n7rePn11o4JsvKc1YjbHMlm7BTEf4M3BbXGQeFR0.png', '2026-02-05 12:07:02', '2026-02-05 12:07:02'),
(30, 'sayılar', 'sayılar', 'images/EfQNiAaIM6KNJJVOkJeSHNAEbb6Mjp7TSebObrNg.jpg', '2026-02-09 09:13:43', '2026-02-09 09:13:43');

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

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

CREATE TABLE `image_audio_hotspots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_id` bigint(20) UNSIGNED NOT NULL,
  `audio_id` bigint(20) UNSIGNED DEFAULT NULL,
  `x` double(8,2) NOT NULL,
  `y` double(8,2) NOT NULL,
  `width` double(8,2) NOT NULL,
  `height` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `image_audio_hotspots` (`id`, `image_id`, `audio_id`, `x`, `y`, `width`, `height`, `created_at`, `updated_at`) VALUES
(21, 2, 28, 0.84, 0.74, 18.94, 17.08, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(22, 2, 29, 19.78, 0.19, 16.85, 17.27, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(23, 2, 30, 38.44, 0.00, 19.64, 18.20, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(24, 2, 31, 61.14, 0.00, 16.85, 18.01, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(25, 2, 32, 79.81, 0.37, 18.94, 16.34, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(26, 2, 33, 0.42, 19.13, 15.60, 16.34, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(27, 2, 34, 17.41, 19.87, 19.92, 18.38, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(28, 2, 35, 37.88, 19.68, 18.94, 16.90, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(29, 2, 36, 57.80, 18.75, 11.42, 17.64, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(30, 2, 37, 69.36, 18.20, 12.81, 20.24, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(31, 2, 38, 82.59, 18.38, 16.85, 20.43, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(32, 2, 39, 0.14, 37.51, 14.35, 19.68, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(33, 2, 40, 14.35, 38.25, 24.10, 19.87, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(34, 2, 41, 39.28, 39.55, 19.36, 18.75, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(35, 2, 42, 59.89, 39.37, 18.94, 19.68, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(36, 2, 43, 79.95, 39.55, 18.66, 19.31, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(37, 2, 48, 73.68, 60.35, 22.84, 18.01, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(38, 2, 47, 56.83, 59.79, 16.16, 17.45, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(39, 2, 46, 38.72, 60.90, 16.85, 16.90, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(40, 2, 45, 19.50, 60.53, 17.97, 16.71, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(41, 2, 44, 0.56, 60.16, 17.69, 18.38, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(42, 2, 53, 77.58, 80.40, 21.17, 17.83, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(43, 2, 52, 59.89, 79.29, 17.69, 20.43, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(44, 2, 51, 41.78, 79.84, 18.39, 18.75, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(45, 2, 50, 17.83, 80.40, 23.82, 18.75, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(46, 2, 49, 0.14, 79.47, 17.55, 19.68, '2025-10-08 08:50:08', '2025-10-08 08:50:08'),
(47, 30, 54, 5.29, 5.69, 14.21, 28.97, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(48, 30, 55, 21.31, 4.95, 14.62, 28.97, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(49, 30, 56, 38.30, 5.45, 14.21, 28.97, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(50, 30, 57, 54.60, 5.94, 15.32, 29.22, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(51, 30, 58, 71.45, 4.70, 15.74, 30.70, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(52, 30, 59, 4.87, 36.89, 16.85, 25.75, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(53, 30, 60, 23.40, 36.15, 11.00, 26.49, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(54, 30, 61, 36.49, 35.90, 14.62, 24.76, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(55, 30, 62, 52.79, 36.40, 14.48, 24.76, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(56, 30, 63, 68.66, 36.15, 18.25, 26.49, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(57, 30, 64, 13.79, 67.10, 21.03, 22.04, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(58, 30, 65, 38.16, 64.62, 22.28, 27.48, '2026-02-09 09:23:00', '2026-02-09 09:23:00'),
(59, 30, 66, 63.09, 65.12, 18.94, 24.51, '2026-02-09 09:23:00', '2026-02-09 09:23:00');

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `lessons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `background_url` varchar(255) DEFAULT NULL,
  `display_order` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `matches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_id` bigint(20) UNSIGNED DEFAULT NULL,
  `content_id` bigint(20) UNSIGNED DEFAULT NULL,
  `letter` varchar(5) NOT NULL,
  `object_name` varchar(255) NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `matches` (`id`, `section_id`, `content_id`, `letter`, `object_name`, `image_path`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, 'A', 'Apfel', 'matches/5VVyfnmLWGXHDMHCGtrGHtwG5mS0QjoQKk9kLBnv.jpg', '2025-10-09 08:35:58', '2025-10-10 10:35:53'),
(2, NULL, NULL, 'B', 'Buch', 'matches/JcnGAzvSsTMsGmU3qtWczPwPA9GrGsguNA6BmKh9.jpg', '2025-10-09 08:46:18', '2025-10-09 08:46:18'),
(3, NULL, NULL, 'C', 'Clown', 'matches/O9anT18a4Hon1XVsCelhfrxlrZtnRE2lui3ivPxS.jpg', '2025-10-09 08:46:49', '2025-10-09 08:46:49'),
(4, NULL, NULL, 'D', 'Drachen', 'matches/J1zVjD1myGc6SjLxGlrHWmcLP0fnDiw7KJ5ZyRbL.webp', '2025-10-09 08:47:04', '2025-10-09 08:47:04'),
(5, NULL, NULL, 'E', 'Eis', 'matches/AvbW0448Uz1B4YTN9HKGtjLhxA1NTuXmJXpXOZdK.jpg', '2025-10-09 08:47:15', '2025-10-09 08:47:15'),
(6, NULL, NULL, 'G', 'Gabel', 'matches/uiFMOdEkK2QxUPqGsVSOrTZkLCvmD3nPGrktExeq.webp', '2025-10-09 08:51:05', '2025-10-09 08:51:05'),
(7, NULL, NULL, 'H', 'Haus', 'matches/82Xn377F1J7IojgtvU6MGjnQs1RCXBq4nRLSaB0g.jpg', '2025-10-09 08:52:14', '2025-10-09 08:52:14'),
(8, NULL, NULL, 'F', 'Fisch', 'matches/NpyuHL3VkGJgmgsqbG87XoElhr0l6ySAhzgIYcKR.jpg', '2025-10-09 08:55:13', '2025-10-10 10:22:15'),
(9, NULL, NULL, 'I', 'Igel', 'matches/0nIZb9aixfAsn3j815n3lhHx6evIxvF9rSLKqBpr.jpg', '2025-10-09 09:25:14', '2025-10-09 09:25:14');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2025_09_20_020709_create_lessons_table', 1),
(6, '2025_09_20_020709_create_questions_table', 1),
(7, '2025_09_20_020710_create_progress_table', 1),
(8, '2025_09_21_205602_create_jobs_table', 1),
(9, '2025_09_21_213308_add_background_url_to_lessons_table', 1),
(10, '2025_09_21_214906_add_roles_to_users_table', 1),
(11, '2025_09_21_221701_create_settings_table', 1),
(12, '2025_09_23_103535_create_sections_table', 1),
(13, '2025_09_23_104535_create_section_items_table', 1),
(14, '2025_09_23_120716_create_videos_table', 1),
(15, '2025_09_23_121252_create_images_table', 1),
(17, '2025_09_23_122235_create_puzzles_table', 1),
(18, '2025_09_23_151741_add_slug_to_sections_table', 2),
(19, '2025_09_29_225432_update_section_items_table_for_images', 3),
(20, '2025_09_29_230856_add_content_id_to_lessons_table', 4),
(21, '2025_09_30_013051_add_thumbnail_to_sections_table', 5),
(22, '2025_09_30_014402_add_section_id_to_progress_table', 6),
(23, '2025_09_30_014600_make_lesson_id_nullable_in_progress_table', 7),
(25, '2025_10_02_115722_create_audio_table', 8),
(26, '2025_10_06_123456_create_image_audio_hotspots_table', 9),
(27, '2025_09_23_121712_create_quizzes_table', 10),
(28, '2025_10_09_000000_create_letter_objects_table', 11),
(29, '2025_10_10_000000_create_matches_table', 12),
(30, '2025_10_09_121911_add_content_id_to_matches_table', 13),
(31, '2025_10_10_120000_add_section_id_to_matches_table', 14),
(32, '2025_10_10_144936_add_piece_count_to_puzzles_table', 15),
(33, '2025_10_13_000000_create_support_tickets_table', 16),
(34, '2025_10_13_151605_alter_piece_count_on_puzzles_table', 17),
(35, '2026_01_28_000000_add_role_to_users_table', 18),
(36, '2026_02_15_000000_create_number_matches_table', 19),
(37, '2026_02_15_000010_create_flag_matches_table', 19),
(38, '2026_02_16_000000_create_capital_matches_table', 19);

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

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

CREATE TABLE `number_matches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `number` varchar(10) NOT NULL,
  `object_name` varchar(255) NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `progress` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `section_id` bigint(20) UNSIGNED DEFAULT NULL,
  `lesson_id` bigint(20) UNSIGNED DEFAULT NULL,
  `score` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `quiz_completed` tinyint(1) NOT NULL DEFAULT 0,
  `puzzle_completed` tinyint(1) NOT NULL DEFAULT 0,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `progress` (`id`, `user_id`, `section_id`, `lesson_id`, `score`, `quiz_completed`, `puzzle_completed`, `completed_at`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, 52, 0, 0, NULL, '2025-09-29 22:47:08', '2025-10-14 08:12:39'),
(2, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:02:12', '2025-09-29 23:02:12'),
(3, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:03:06', '2025-09-29 23:03:06'),
(4, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:13:45', '2025-09-29 23:13:45'),
(5, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:23:00', '2025-09-29 23:23:00'),
(6, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:23:19', '2025-09-29 23:23:19'),
(7, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:23:42', '2025-09-29 23:23:42'),
(8, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-29 23:23:44', '2025-09-29 23:23:44'),
(9, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:20:54', '2025-09-30 09:20:54'),
(10, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:20:58', '2025-09-30 09:20:58'),
(11, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:21:26', '2025-09-30 09:21:26'),
(12, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:21:28', '2025-09-30 09:21:28'),
(13, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:21:49', '2025-09-30 09:21:49'),
(14, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:25:59', '2025-09-30 09:25:59'),
(15, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:39:30', '2025-09-30 09:39:30'),
(16, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:41:36', '2025-09-30 09:41:36'),
(17, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:41:44', '2025-09-30 09:41:44'),
(18, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:41:50', '2025-09-30 09:41:50'),
(19, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:44:45', '2025-09-30 09:44:45'),
(20, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:44:48', '2025-09-30 09:44:48'),
(21, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:44:52', '2025-09-30 09:44:52'),
(22, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:47:41', '2025-09-30 09:47:41'),
(23, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:57:20', '2025-09-30 09:57:20'),
(24, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:57:24', '2025-09-30 09:57:24'),
(25, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 09:57:30', '2025-09-30 09:57:30'),
(26, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 10:15:44', '2025-09-30 10:15:44'),
(27, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 10:17:51', '2025-09-30 10:17:51'),
(28, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 10:17:54', '2025-09-30 10:17:54'),
(29, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 10:18:02', '2025-09-30 10:18:02'),
(30, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 10:18:22', '2025-09-30 10:18:22'),
(31, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:11:52', '2025-09-30 12:11:52'),
(32, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:12:19', '2025-09-30 12:12:19'),
(33, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:14:48', '2025-09-30 12:14:48'),
(34, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:15:25', '2025-09-30 12:15:25'),
(35, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:15:29', '2025-09-30 12:15:29'),
(36, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:16:47', '2025-09-30 12:16:47'),
(37, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:19:04', '2025-09-30 12:19:04'),
(38, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:24:56', '2025-09-30 12:24:56'),
(39, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:25:33', '2025-09-30 12:25:33'),
(40, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:26:25', '2025-09-30 12:26:25'),
(41, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:28:52', '2025-09-30 12:28:52'),
(42, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:29:12', '2025-09-30 12:29:12'),
(43, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:40:27', '2025-09-30 12:40:27'),
(44, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:49:27', '2025-09-30 12:49:27'),
(45, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:53:13', '2025-09-30 12:53:13'),
(46, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:55:05', '2025-09-30 12:55:05'),
(47, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:59:00', '2025-09-30 12:59:00'),
(48, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 12:59:17', '2025-09-30 12:59:17'),
(49, 3, NULL, NULL, 22, 0, 0, NULL, '2025-09-30 13:00:23', '2025-10-10 10:12:12'),
(50, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 13:55:43', '2025-09-30 13:55:43'),
(51, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 13:55:49', '2025-09-30 13:55:49'),
(52, 3, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 15:02:48', '2025-09-30 15:02:48'),
(53, 3, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 16:03:05', '2025-09-30 16:03:05'),
(54, 3, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 16:24:18', '2025-09-30 16:24:18'),
(55, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 17:23:35', '2025-09-30 17:23:35'),
(56, 1, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 17:49:19', '2025-09-30 17:49:19'),
(57, 3, NULL, NULL, 0, 0, 0, NULL, '2025-09-30 18:03:18', '2025-09-30 18:03:18'),
(58, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 03:52:23', '2025-10-01 03:52:23'),
(59, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 04:07:41', '2025-10-01 04:07:41'),
(60, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 05:01:33', '2025-10-01 05:01:33'),
(61, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 05:01:45', '2025-10-01 05:01:45'),
(62, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 05:02:31', '2025-10-01 05:02:31'),
(63, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 07:22:45', '2025-10-01 07:22:45'),
(64, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 07:59:51', '2025-10-01 07:59:51'),
(65, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:01:00', '2025-10-01 08:01:00'),
(66, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:01:48', '2025-10-01 08:01:48'),
(67, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:03:16', '2025-10-01 08:03:16'),
(68, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:03:18', '2025-10-01 08:03:18'),
(69, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:03:19', '2025-10-01 08:03:19'),
(70, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:03:52', '2025-10-01 08:03:52'),
(71, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:06:13', '2025-10-01 08:06:13'),
(72, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:49:44', '2025-10-01 08:49:44'),
(73, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 08:50:10', '2025-10-01 08:50:10'),
(74, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 09:48:40', '2025-10-01 09:48:40'),
(75, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 10:03:20', '2025-10-01 10:03:20'),
(76, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 10:27:51', '2025-10-01 10:27:51'),
(77, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 10:42:28', '2025-10-01 10:42:28'),
(78, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 10:42:51', '2025-10-01 10:42:51'),
(79, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 10:43:07', '2025-10-01 10:43:07'),
(80, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:15:37', '2025-10-01 11:15:37'),
(81, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:37:21', '2025-10-01 11:37:21'),
(82, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:39:30', '2025-10-01 11:39:30'),
(83, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:44:31', '2025-10-01 11:44:31'),
(84, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:45:13', '2025-10-01 11:45:13'),
(85, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:45:29', '2025-10-01 11:45:29'),
(86, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:45:53', '2025-10-01 11:45:53'),
(87, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:46:08', '2025-10-01 11:46:08'),
(88, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:46:58', '2025-10-01 11:46:58'),
(89, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:48:48', '2025-10-01 11:48:48'),
(90, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:48:51', '2025-10-01 11:48:51'),
(91, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:49:07', '2025-10-01 11:49:07'),
(92, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:49:17', '2025-10-01 11:49:17'),
(93, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 11:57:32', '2025-10-01 11:57:32'),
(94, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 12:13:23', '2025-10-01 12:13:23'),
(95, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 12:24:49', '2025-10-01 12:24:49'),
(96, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 12:27:33', '2025-10-01 12:27:33'),
(97, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 12:37:43', '2025-10-01 12:37:43'),
(98, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 13:17:37', '2025-10-01 13:17:37'),
(99, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 14:41:18', '2025-10-01 14:41:18'),
(100, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-01 18:06:56', '2025-10-01 18:06:56'),
(101, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 04:49:17', '2025-10-02 04:49:17'),
(102, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 04:53:47', '2025-10-02 04:53:47'),
(103, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 05:16:24', '2025-10-02 05:16:24'),
(104, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 05:16:33', '2025-10-02 05:16:33'),
(105, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 05:17:13', '2025-10-02 05:17:13'),
(106, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 05:53:29', '2025-10-02 05:53:29'),
(107, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 05:56:34', '2025-10-02 05:56:34'),
(108, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:35:34', '2025-10-02 07:35:34'),
(109, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:47:34', '2025-10-02 07:47:34'),
(110, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:54:00', '2025-10-02 07:54:00'),
(111, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:54:39', '2025-10-02 07:54:39'),
(112, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:56:37', '2025-10-02 07:56:37'),
(113, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:59:09', '2025-10-02 07:59:09'),
(114, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 07:59:56', '2025-10-02 07:59:56'),
(115, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:03:18', '2025-10-02 08:03:18'),
(116, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:03:57', '2025-10-02 08:03:57'),
(117, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:04:25', '2025-10-02 08:04:25'),
(118, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:08:14', '2025-10-02 08:08:14'),
(119, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:10:18', '2025-10-02 08:10:18'),
(120, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:10:55', '2025-10-02 08:10:55'),
(121, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:13:31', '2025-10-02 08:13:31'),
(122, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:19:05', '2025-10-02 08:19:05'),
(123, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:22:45', '2025-10-02 08:22:45'),
(124, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:23:46', '2025-10-02 08:23:46'),
(125, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:28:23', '2025-10-02 08:28:23'),
(126, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:29:41', '2025-10-02 08:29:41'),
(127, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:30:49', '2025-10-02 08:30:49'),
(128, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:31:37', '2025-10-02 08:31:37'),
(129, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:33:03', '2025-10-02 08:33:03'),
(130, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:35:29', '2025-10-02 08:35:29'),
(131, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:38:33', '2025-10-02 08:38:33'),
(132, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:40:29', '2025-10-02 08:40:29'),
(133, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:47:56', '2025-10-02 08:47:56'),
(134, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 08:49:37', '2025-10-02 08:49:37'),
(135, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 09:39:26', '2025-10-02 09:39:26'),
(136, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 09:40:05', '2025-10-02 09:40:05'),
(137, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 11:10:24', '2025-10-02 11:10:24'),
(138, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 11:10:27', '2025-10-02 11:10:27'),
(139, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 12:03:56', '2025-10-02 12:03:56'),
(140, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 12:12:21', '2025-10-02 12:12:21'),
(141, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 12:59:13', '2025-10-02 12:59:13'),
(142, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 13:03:26', '2025-10-02 13:03:26'),
(143, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 14:43:17', '2025-10-02 14:43:17'),
(144, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 14:57:37', '2025-10-02 14:57:37'),
(145, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 15:58:08', '2025-10-02 15:58:08'),
(146, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 16:23:48', '2025-10-02 16:23:48'),
(147, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 16:39:16', '2025-10-02 16:39:16'),
(148, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 16:54:24', '2025-10-02 16:54:24'),
(149, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-02 22:49:41', '2025-10-02 22:49:41'),
(150, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 00:35:50', '2025-10-03 00:35:50'),
(151, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 02:27:37', '2025-10-03 02:27:37'),
(152, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 03:17:27', '2025-10-03 03:17:27'),
(153, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 05:46:48', '2025-10-03 05:46:48'),
(154, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 07:24:47', '2025-10-03 07:24:47'),
(155, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 08:33:57', '2025-10-03 08:33:57'),
(156, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:21:34', '2025-10-03 09:21:34'),
(157, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:53:31', '2025-10-03 09:53:31'),
(158, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:55:04', '2025-10-03 09:55:04'),
(159, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:57:34', '2025-10-03 09:57:34'),
(160, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:59:01', '2025-10-03 09:59:01'),
(161, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 09:59:33', '2025-10-03 09:59:33'),
(162, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 10:00:14', '2025-10-03 10:00:14'),
(163, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 10:02:55', '2025-10-03 10:02:55'),
(164, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 10:03:01', '2025-10-03 10:03:01'),
(165, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-03 10:03:27', '2025-10-03 10:03:27'),
(166, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 04:33:26', '2025-10-04 04:33:26'),
(167, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 07:36:42', '2025-10-04 07:36:42'),
(168, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 07:49:39', '2025-10-04 07:49:39'),
(169, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:19:18', '2025-10-04 08:19:18'),
(170, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:32:14', '2025-10-04 08:32:14'),
(171, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:35:23', '2025-10-04 08:35:23'),
(172, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:35:39', '2025-10-04 08:35:39'),
(173, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:40:45', '2025-10-04 08:40:45'),
(174, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-04 08:40:51', '2025-10-04 08:40:51'),
(175, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-05 06:02:12', '2025-10-05 06:02:12'),
(176, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-05 06:02:37', '2025-10-05 06:02:37'),
(177, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-05 06:02:47', '2025-10-05 06:02:47'),
(178, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 03:52:16', '2025-10-06 03:52:16'),
(179, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 03:52:39', '2025-10-06 03:52:39'),
(180, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 05:24:27', '2025-10-06 05:24:27'),
(181, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 06:34:03', '2025-10-06 06:34:03'),
(182, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 06:34:06', '2025-10-06 06:34:06'),
(183, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 06:34:19', '2025-10-06 06:34:19'),
(184, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 08:21:18', '2025-10-06 08:21:18'),
(185, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-06 08:21:31', '2025-10-06 08:21:31'),
(186, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 06:44:11', '2025-10-07 06:44:11'),
(187, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 06:44:18', '2025-10-07 06:44:18'),
(188, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 09:39:00', '2025-10-07 09:39:00'),
(189, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 10:17:20', '2025-10-07 10:17:20'),
(190, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 10:18:13', '2025-10-07 10:18:13'),
(191, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 10:18:19', '2025-10-07 10:18:19'),
(192, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 11:54:34', '2025-10-07 11:54:34'),
(193, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 11:54:40', '2025-10-07 11:54:40'),
(194, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-07 12:38:18', '2025-10-07 12:38:18'),
(195, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 04:06:13', '2025-10-08 04:06:13'),
(196, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:42:53', '2025-10-08 05:42:53'),
(197, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:43:27', '2025-10-08 05:43:27'),
(198, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:43:42', '2025-10-08 05:43:42'),
(199, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:49:03', '2025-10-08 05:49:03'),
(200, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:52:08', '2025-10-08 05:52:08'),
(201, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 05:58:51', '2025-10-08 05:58:51'),
(202, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:02:53', '2025-10-08 06:02:53'),
(203, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:10:22', '2025-10-08 06:10:22'),
(204, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:22:26', '2025-10-08 06:22:26'),
(205, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:26:17', '2025-10-08 06:26:17'),
(206, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:29:55', '2025-10-08 06:29:55'),
(207, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:32:59', '2025-10-08 06:32:59'),
(208, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:42:59', '2025-10-08 06:42:59'),
(209, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:51:13', '2025-10-08 06:51:13'),
(210, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:52:38', '2025-10-08 06:52:38'),
(211, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:57:10', '2025-10-08 06:57:10'),
(212, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:57:15', '2025-10-08 06:57:15'),
(213, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:58:15', '2025-10-08 06:58:15'),
(214, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:58:19', '2025-10-08 06:58:19'),
(215, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 06:59:19', '2025-10-08 06:59:19'),
(216, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:01:23', '2025-10-08 07:01:23'),
(217, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:01:45', '2025-10-08 07:01:45'),
(218, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:01:53', '2025-10-08 07:01:53'),
(219, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:21:51', '2025-10-08 07:21:51'),
(220, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:28:11', '2025-10-08 07:28:11'),
(221, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:30:59', '2025-10-08 07:30:59'),
(222, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:36:15', '2025-10-08 07:36:15'),
(223, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:43:29', '2025-10-08 07:43:29'),
(224, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:47:58', '2025-10-08 07:47:58'),
(225, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:54:58', '2025-10-08 07:54:58'),
(226, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:55:31', '2025-10-08 07:55:31'),
(227, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:56:30', '2025-10-08 07:56:30'),
(228, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 07:57:07', '2025-10-08 07:57:07'),
(229, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:08:25', '2025-10-08 08:08:25'),
(230, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:08:33', '2025-10-08 08:08:33'),
(231, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:14:17', '2025-10-08 08:14:17'),
(232, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:29:28', '2025-10-08 08:29:28'),
(233, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:32:37', '2025-10-08 08:32:37'),
(234, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:37:05', '2025-10-08 08:37:05'),
(235, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:39:23', '2025-10-08 08:39:23'),
(236, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 08:50:13', '2025-10-08 08:50:13'),
(237, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:06:21', '2025-10-08 09:06:21'),
(238, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:19:04', '2025-10-08 09:19:04'),
(239, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:20:33', '2025-10-08 09:20:33'),
(240, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:20:38', '2025-10-08 09:20:38'),
(241, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:22:01', '2025-10-08 09:22:01'),
(242, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:22:53', '2025-10-08 09:22:53'),
(243, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:22:54', '2025-10-08 09:22:54'),
(244, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:25:34', '2025-10-08 09:25:34'),
(245, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:25:38', '2025-10-08 09:25:38'),
(246, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:26:34', '2025-10-08 09:26:34'),
(247, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 09:29:27', '2025-10-08 09:29:27'),
(248, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 11:11:15', '2025-10-08 11:11:15'),
(249, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 11:42:44', '2025-10-08 11:42:44'),
(250, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 12:31:14', '2025-10-08 12:31:14'),
(251, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 12:32:02', '2025-10-08 12:32:02'),
(252, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 12:40:30', '2025-10-08 12:40:30'),
(253, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 12:42:29', '2025-10-08 12:42:29'),
(254, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-08 12:52:54', '2025-10-08 12:52:54'),
(255, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 04:10:02', '2025-10-09 04:10:02'),
(256, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 06:01:28', '2025-10-09 06:01:28'),
(257, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 06:03:50', '2025-10-09 06:03:50'),
(258, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 06:18:58', '2025-10-09 06:18:58'),
(259, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 07:00:57', '2025-10-09 07:00:57'),
(260, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 07:05:43', '2025-10-09 07:05:43'),
(261, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 07:13:13', '2025-10-09 07:13:13'),
(262, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 07:17:56', '2025-10-09 07:17:56'),
(263, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 08:37:12', '2025-10-09 08:37:12'),
(264, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 08:37:41', '2025-10-09 08:37:41'),
(265, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 09:22:02', '2025-10-09 09:22:02'),
(266, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 09:29:40', '2025-10-09 09:29:40'),
(267, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 10:16:40', '2025-10-09 10:16:40'),
(268, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 10:18:32', '2025-10-09 10:18:32'),
(269, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 10:45:48', '2025-10-09 10:45:48'),
(270, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:20:07', '2025-10-09 11:20:07'),
(271, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:30:02', '2025-10-09 11:30:02'),
(272, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:30:07', '2025-10-09 11:30:07'),
(273, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:40:00', '2025-10-09 11:40:00'),
(274, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:44:07', '2025-10-09 11:44:07'),
(275, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:53:23', '2025-10-09 11:53:23'),
(276, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:57:29', '2025-10-09 11:57:29'),
(277, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 11:59:40', '2025-10-09 11:59:40'),
(278, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:00:52', '2025-10-09 12:00:52'),
(279, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:01:10', '2025-10-09 12:01:10'),
(280, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:02:09', '2025-10-09 12:02:09'),
(281, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:19:38', '2025-10-09 12:19:38'),
(282, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:20:45', '2025-10-09 12:20:45'),
(283, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:22:20', '2025-10-09 12:22:20'),
(284, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:26:02', '2025-10-09 12:26:02'),
(285, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:26:31', '2025-10-09 12:26:31'),
(286, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:28:12', '2025-10-09 12:28:12'),
(287, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:28:35', '2025-10-09 12:28:35'),
(288, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:28:58', '2025-10-09 12:28:58'),
(289, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:30:06', '2025-10-09 12:30:06'),
(290, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:32:50', '2025-10-09 12:32:50'),
(291, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:39:30', '2025-10-09 12:39:30'),
(292, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:41:46', '2025-10-09 12:41:46'),
(293, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:47:21', '2025-10-09 12:47:21'),
(294, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:47:35', '2025-10-09 12:47:35'),
(295, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:52:21', '2025-10-09 12:52:21'),
(296, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-09 12:54:49', '2025-10-09 12:54:49'),
(297, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 03:55:33', '2025-10-10 03:55:33'),
(298, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 03:56:54', '2025-10-10 03:56:54'),
(299, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 04:25:59', '2025-10-10 04:25:59'),
(300, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:05:38', '2025-10-10 05:05:38'),
(301, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:06:06', '2025-10-10 05:06:06'),
(302, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:08:16', '2025-10-10 05:08:16'),
(303, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:09:32', '2025-10-10 05:09:32'),
(304, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:16:21', '2025-10-10 05:16:21'),
(305, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:27:03', '2025-10-10 05:27:03'),
(306, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:34:42', '2025-10-10 05:34:42'),
(307, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:35:48', '2025-10-10 05:35:48'),
(308, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:39:50', '2025-10-10 05:39:50'),
(309, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:53:20', '2025-10-10 05:53:20'),
(310, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 05:53:32', '2025-10-10 05:53:32'),
(311, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:08:08', '2025-10-10 06:08:08'),
(312, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:12:58', '2025-10-10 06:12:58'),
(313, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:16:28', '2025-10-10 06:16:28'),
(314, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:45:22', '2025-10-10 06:45:22'),
(315, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:46:54', '2025-10-10 06:46:54'),
(316, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:47:44', '2025-10-10 06:47:44'),
(317, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:56:38', '2025-10-10 06:56:38'),
(318, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 06:59:12', '2025-10-10 06:59:12'),
(319, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:07:24', '2025-10-10 07:07:24'),
(320, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:12:18', '2025-10-10 07:12:18'),
(321, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:13:47', '2025-10-10 07:13:47'),
(322, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:18:37', '2025-10-10 07:18:37'),
(323, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:20:56', '2025-10-10 07:20:56'),
(324, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:22:03', '2025-10-10 07:22:03'),
(325, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:24:17', '2025-10-10 07:24:17'),
(326, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:25:11', '2025-10-10 07:25:11'),
(327, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 07:27:14', '2025-10-10 07:27:14'),
(328, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:07:45', '2025-10-10 10:07:45'),
(329, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:11:43', '2025-10-10 10:11:43'),
(330, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:11:46', '2025-10-10 10:11:46'),
(331, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:12:02', '2025-10-10 10:12:02'),
(332, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:13:06', '2025-10-10 10:13:06'),
(333, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:41:53', '2025-10-10 10:41:53'),
(334, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 10:42:31', '2025-10-10 10:42:31'),
(335, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 11:33:23', '2025-10-10 11:33:23'),
(336, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 12:22:04', '2025-10-10 12:22:04'),
(337, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 12:22:46', '2025-10-10 12:22:46'),
(338, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 12:24:31', '2025-10-10 12:24:31'),
(339, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 12:27:00', '2025-10-10 12:27:00'),
(340, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 12:53:39', '2025-10-10 12:53:39'),
(341, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 13:03:38', '2025-10-10 13:03:38'),
(342, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-10 15:35:56', '2025-10-10 15:35:56'),
(343, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:06:04', '2025-10-11 05:06:04'),
(344, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:08:07', '2025-10-11 05:08:07'),
(345, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:17:25', '2025-10-11 05:17:25'),
(346, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:19:21', '2025-10-11 05:19:21'),
(347, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:39:18', '2025-10-11 05:39:18'),
(348, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:45:04', '2025-10-11 05:45:04'),
(349, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:57:24', '2025-10-11 05:57:24'),
(350, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 05:57:44', '2025-10-11 05:57:44'),
(351, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 06:01:23', '2025-10-11 06:01:23'),
(352, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 06:18:23', '2025-10-11 06:18:23'),
(353, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 06:37:23', '2025-10-11 06:37:23'),
(354, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 08:57:23', '2025-10-11 08:57:23'),
(355, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 08:57:29', '2025-10-11 08:57:29'),
(356, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 08:57:41', '2025-10-11 08:57:41'),
(357, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 08:57:45', '2025-10-11 08:57:45'),
(358, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 08:57:48', '2025-10-11 08:57:48'),
(359, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 09:00:11', '2025-10-11 09:00:11'),
(360, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 09:35:14', '2025-10-11 09:35:14'),
(361, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 09:43:55', '2025-10-11 09:43:55'),
(362, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 10:34:30', '2025-10-11 10:34:30'),
(363, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 10:54:08', '2025-10-11 10:54:08'),
(364, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 12:09:57', '2025-10-11 12:09:57'),
(365, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 12:09:59', '2025-10-11 12:09:59'),
(366, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 12:10:02', '2025-10-11 12:10:02'),
(367, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 12:10:05', '2025-10-11 12:10:05'),
(368, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:18:31', '2025-10-11 16:18:31'),
(369, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:18:35', '2025-10-11 16:18:35'),
(370, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:30:31', '2025-10-11 16:30:31'),
(371, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:30:33', '2025-10-11 16:30:33'),
(372, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:30:34', '2025-10-11 16:30:34'),
(373, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:30:36', '2025-10-11 16:30:36'),
(374, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-11 16:30:37', '2025-10-11 16:30:37'),
(375, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:33:05', '2025-10-13 04:33:05'),
(376, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:38:45', '2025-10-13 04:38:45'),
(377, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:40:32', '2025-10-13 04:40:32'),
(378, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:41:33', '2025-10-13 04:41:33'),
(379, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:43:46', '2025-10-13 04:43:46'),
(380, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:49:50', '2025-10-13 04:49:50'),
(381, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 04:59:37', '2025-10-13 04:59:37'),
(382, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 05:05:52', '2025-10-13 05:05:52'),
(383, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 11:38:26', '2025-10-13 11:38:26'),
(384, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 11:39:48', '2025-10-13 11:39:48'),
(385, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-13 11:40:20', '2025-10-13 11:40:20'),
(386, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 08:12:30', '2025-10-14 08:12:30'),
(387, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 08:56:45', '2025-10-14 08:56:45'),
(388, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 09:05:13', '2025-10-14 09:05:13'),
(389, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 10:41:06', '2025-10-14 10:41:06'),
(390, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 11:08:28', '2025-10-14 11:08:28'),
(391, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 11:28:30', '2025-10-14 11:28:30'),
(392, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 11:49:34', '2025-10-14 11:49:34'),
(393, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 11:52:23', '2025-10-14 11:52:23'),
(394, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 11:54:18', '2025-10-14 11:54:18'),
(395, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:06:43', '2025-10-14 12:06:43'),
(396, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:07:28', '2025-10-14 12:07:28'),
(397, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:08:05', '2025-10-14 12:08:05'),
(398, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:09:41', '2025-10-14 12:09:41'),
(399, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:12:46', '2025-10-14 12:12:46'),
(400, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:13:06', '2025-10-14 12:13:06'),
(401, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:13:53', '2025-10-14 12:13:53'),
(402, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:25:50', '2025-10-14 12:25:50'),
(403, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:28:44', '2025-10-14 12:28:44'),
(404, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:57:36', '2025-10-14 12:57:36'),
(405, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-14 12:59:06', '2025-10-14 12:59:06'),
(406, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-15 16:14:44', '2025-10-15 16:14:44'),
(407, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-17 05:46:30', '2025-10-17 05:46:30'),
(408, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-17 05:51:29', '2025-10-17 05:51:29'),
(409, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-18 15:40:39', '2025-10-18 15:40:39'),
(410, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-18 15:42:56', '2025-10-18 15:42:56'),
(411, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-24 05:25:31', '2025-10-24 05:25:31'),
(412, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-27 06:19:30', '2025-10-27 06:19:30'),
(413, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-27 06:21:11', '2025-10-27 06:21:11'),
(414, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-27 06:21:15', '2025-10-27 06:21:15'),
(415, 1, NULL, NULL, 0, 0, 0, NULL, '2025-10-27 06:37:17', '2025-10-27 06:37:17'),
(416, 3, NULL, NULL, 0, 0, 0, NULL, '2025-10-28 06:37:08', '2025-10-28 06:37:08'),
(417, 1, NULL, NULL, 0, 0, 0, NULL, '2025-11-03 06:10:28', '2025-11-03 06:10:28'),
(418, 3, NULL, NULL, 0, 0, 0, NULL, '2025-12-21 10:51:07', '2025-12-21 10:51:07'),
(419, 3, NULL, NULL, 0, 0, 0, NULL, '2025-12-21 10:54:51', '2025-12-21 10:54:51'),
(420, 3, NULL, NULL, 0, 0, 0, NULL, '2025-12-21 10:54:56', '2025-12-21 10:54:56'),
(421, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-16 09:07:46', '2026-01-16 09:07:46'),
(422, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-19 06:47:36', '2026-01-19 06:47:36'),
(423, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-19 06:51:30', '2026-01-19 06:51:30'),
(424, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-19 06:56:54', '2026-01-19 06:56:54'),
(425, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-21 11:48:13', '2026-01-21 11:48:13'),
(426, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-21 11:48:43', '2026-01-21 11:48:43'),
(427, 3, NULL, NULL, 0, 0, 0, NULL, '2026-01-24 05:41:12', '2026-01-24 05:41:12'),
(428, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-24 06:09:13', '2026-01-24 06:09:13'),
(429, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-26 05:13:10', '2026-01-26 05:13:10'),
(430, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-26 13:55:16', '2026-01-26 13:55:16'),
(431, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-26 16:52:19', '2026-01-26 16:52:19'),
(432, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-28 06:31:07', '2026-01-28 06:31:07'),
(433, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-28 06:31:09', '2026-01-28 06:31:09'),
(434, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-28 11:29:05', '2026-01-28 11:29:05'),
(435, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-29 17:26:09', '2026-01-29 17:26:09'),
(436, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-29 17:26:13', '2026-01-29 17:26:13'),
(437, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-29 17:40:24', '2026-01-29 17:40:24'),
(438, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-31 10:55:04', '2026-01-31 10:55:04'),
(439, 1, NULL, NULL, 0, 0, 0, NULL, '2026-01-31 11:11:42', '2026-01-31 11:11:42'),
(440, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-02 16:21:43', '2026-02-02 16:21:43'),
(441, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-02 16:25:22', '2026-02-02 16:25:22'),
(442, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-02 16:25:51', '2026-02-02 16:25:51'),
(443, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-02 16:32:37', '2026-02-02 16:32:37'),
(444, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:50:57', '2026-02-05 09:50:57'),
(445, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:53:03', '2026-02-05 09:53:03'),
(446, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:53:52', '2026-02-05 09:53:52'),
(447, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:54:03', '2026-02-05 09:54:03'),
(448, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:54:07', '2026-02-05 09:54:07'),
(449, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:55:49', '2026-02-05 09:55:49'),
(450, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:56:14', '2026-02-05 09:56:14'),
(451, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:56:27', '2026-02-05 09:56:27'),
(452, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:57:06', '2026-02-05 09:57:06'),
(453, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:58:09', '2026-02-05 09:58:09'),
(454, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:58:28', '2026-02-05 09:58:28'),
(455, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:58:34', '2026-02-05 09:58:34'),
(456, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:58:40', '2026-02-05 09:58:40'),
(457, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:58:45', '2026-02-05 09:58:45'),
(458, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 09:59:55', '2026-02-05 09:59:55'),
(459, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:01:09', '2026-02-05 10:01:09'),
(460, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:01:16', '2026-02-05 10:01:16'),
(461, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:07:41', '2026-02-05 10:07:41'),
(462, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:09:01', '2026-02-05 10:09:01'),
(463, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:09:31', '2026-02-05 10:09:31'),
(464, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:17:54', '2026-02-05 10:17:54'),
(465, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:22:08', '2026-02-05 10:22:08'),
(466, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:23:58', '2026-02-05 10:23:58'),
(467, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:25:26', '2026-02-05 10:25:26'),
(468, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:26:34', '2026-02-05 10:26:34'),
(469, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:27:00', '2026-02-05 10:27:00'),
(470, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:27:03', '2026-02-05 10:27:03'),
(471, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:27:44', '2026-02-05 10:27:44'),
(472, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:29:24', '2026-02-05 10:29:24'),
(473, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:30:48', '2026-02-05 10:30:48'),
(474, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:58:43', '2026-02-05 10:58:43'),
(475, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 10:59:37', '2026-02-05 10:59:37'),
(476, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 11:20:35', '2026-02-05 11:20:35'),
(477, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 11:58:52', '2026-02-05 11:58:52'),
(478, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 12:18:20', '2026-02-05 12:18:20'),
(479, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 12:18:23', '2026-02-05 12:18:23'),
(480, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 12:20:15', '2026-02-05 12:20:15'),
(481, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 12:21:38', '2026-02-05 12:21:38'),
(482, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 12:26:13', '2026-02-05 12:26:13'),
(483, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 13:52:21', '2026-02-05 13:52:21'),
(484, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:08:32', '2026-02-05 17:08:32'),
(485, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:09:28', '2026-02-05 17:09:28'),
(486, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:11:57', '2026-02-05 17:11:57'),
(487, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:12:40', '2026-02-05 17:12:40'),
(488, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:19:16', '2026-02-05 17:19:16'),
(489, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:23:59', '2026-02-05 17:23:59'),
(490, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:28:08', '2026-02-05 17:28:08'),
(491, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:28:28', '2026-02-05 17:28:28'),
(492, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:34:04', '2026-02-05 17:34:04'),
(493, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:40:43', '2026-02-05 17:40:43'),
(494, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:40:58', '2026-02-05 17:40:58'),
(495, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:53:23', '2026-02-05 17:53:23'),
(496, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 17:55:36', '2026-02-05 17:55:36'),
(497, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-05 18:11:56', '2026-02-05 18:11:56'),
(498, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-06 08:32:29', '2026-02-06 08:32:29'),
(499, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-06 08:41:06', '2026-02-06 08:41:06'),
(500, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-06 08:42:06', '2026-02-06 08:42:06'),
(501, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-06 08:42:10', '2026-02-06 08:42:10'),
(502, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 07:16:37', '2026-02-09 07:16:37'),
(503, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 09:10:47', '2026-02-09 09:10:47'),
(504, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 09:23:25', '2026-02-09 09:23:25'),
(505, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 09:24:25', '2026-02-09 09:24:25'),
(506, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 09:36:23', '2026-02-09 09:36:23'),
(507, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 09:38:19', '2026-02-09 09:38:19'),
(508, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 13:09:34', '2026-02-09 13:09:34'),
(509, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:40:36', '2026-02-09 15:40:36'),
(510, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:42:28', '2026-02-09 15:42:28'),
(511, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:44:30', '2026-02-09 15:44:30'),
(512, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:44:32', '2026-02-09 15:44:32'),
(513, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:49:43', '2026-02-09 15:49:43'),
(514, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:52:47', '2026-02-09 15:52:47'),
(515, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-09 15:55:04', '2026-02-09 15:55:04'),
(516, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-10 08:43:50', '2026-02-10 08:43:50'),
(517, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-11 08:45:32', '2026-02-11 08:45:32'),
(518, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-11 08:45:33', '2026-02-11 08:45:33'),
(519, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-15 16:09:35', '2026-02-15 16:09:35'),
(520, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-15 16:09:55', '2026-02-15 16:09:55'),
(521, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-15 16:50:16', '2026-02-15 16:50:16'),
(522, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-15 17:10:32', '2026-02-15 17:10:32'),
(523, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-15 17:10:44', '2026-02-15 17:10:44'),
(524, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:17:07', '2026-02-16 15:17:07'),
(525, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:17:54', '2026-02-16 15:17:54'),
(526, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:18:34', '2026-02-16 15:18:34'),
(527, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:22:42', '2026-02-16 15:22:42'),
(528, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:30:20', '2026-02-16 15:30:20'),
(529, 1, NULL, NULL, 0, 0, 0, NULL, '2026-02-16 15:30:46', '2026-02-16 15:30:46'),
(530, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-17 07:26:51', '2026-02-17 07:26:51'),
(531, 5, NULL, NULL, 0, 0, 0, NULL, '2026-02-17 19:00:47', '2026-02-17 19:00:47');

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

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

CREATE TABLE `puzzles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `piece_count` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `puzzles` (`id`, `title`, `description`, `file_path`, `piece_count`, `created_at`, `updated_at`) VALUES
(7, 'kedi', 'puzzle için kedi görseli', 'puzzles/o33Zgv8Js2AnOtFRgb55PTG3DimmPO8H4VsFphys.png', 4, '2025-10-10 10:48:34', '2025-10-10 12:11:02'),
(9, 'Manzara', 'manzara', 'puzzles/9eC76GPB4itWYELlRaT9LV6hoOEeSbS23vGOPC8u.png', 4, '2025-10-13 11:28:12', '2025-10-13 11:28:12'),
(10, 'elma', 'elma resmi', 'puzzles/IJ9t73JfCyIAFWhVitpzGJAl3x5e3lnUUcncLWWN.jpg', 6, '2025-10-13 12:58:31', '2025-10-13 12:58:31'),
(11, 'doga', 'doga resmi', 'puzzles/FUfcN6lUZXY5ESz9CFqbcMqtU8CG7rcqX2CSDZoR.jpg', 8, '2025-10-14 12:09:03', '2025-10-14 12:09:03');

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

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

CREATE TABLE `questions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `lesson_id` bigint(20) UNSIGNED NOT NULL,
  `question_text` text NOT NULL,
  `type` enum('multi','boolean') NOT NULL DEFAULT 'multi',
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)),
  `correct_answer` varchar(255) NOT NULL,
  `display_order` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `quizzes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question_text` varchar(255) NOT NULL,
  `type` enum('boolean','multi','text') NOT NULL DEFAULT 'multi',
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)),
  `correct_answer` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `quizzes` (`id`, `question_text`, `type`, `options`, `correct_answer`, `created_at`, `updated_at`) VALUES
(1, 'Soru 1', 'multi', '\"[\\\"se\\\\u00e7enek 1\\\",\\\"se\\\\u00e7enek 2\\\",\\\"se\\\\u00e7enek 3\\\",\\\"se\\\\u00e7enek 4\\\"]\"', 'seçenek 3', '2025-10-08 12:29:26', '2025-10-08 12:29:26'),
(2, 'soru 2 doğru yanlış', 'boolean', '\"[\\\"do\\\\u011fru\\\"]\"', 'doğru', '2025-10-08 12:30:04', '2025-10-08 12:30:04');

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

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

CREATE TABLE `sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sections` (`id`, `title`, `thumbnail`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(7, 'DEMO', NULL, 'demo', 'Demo', '2026-02-05 11:58:24', '2026-02-05 11:58:24'),
(10, 'demo 2', NULL, 'demo-2', NULL, '2026-02-09 09:06:05', '2026-02-09 09:06:05');

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

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

CREATE TABLE `section_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_id` bigint(20) UNSIGNED DEFAULT NULL,
  `content_type` varchar(255) NOT NULL,
  `content_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `section_items` (`id`, `section_id`, `content_type`, `content_id`, `image_id`, `order`, `created_at`, `updated_at`) VALUES
(86, 7, 'image', 20, NULL, 1, '2026-02-05 12:19:23', '2026-02-05 12:26:08'),
(87, 7, 'video', 15, NULL, 2, '2026-02-05 12:19:29', '2026-02-05 12:26:08'),
(88, 7, 'image', 21, NULL, 3, '2026-02-05 12:19:41', '2026-02-05 12:26:08'),
(89, 7, 'video', 16, NULL, 4, '2026-02-05 12:19:53', '2026-02-05 12:26:08'),
(90, 7, 'image', 22, NULL, 5, '2026-02-05 12:20:01', '2026-02-05 12:26:08'),
(92, 7, 'video', 17, NULL, 6, '2026-02-05 12:21:20', '2026-02-05 12:26:08'),
(93, 7, 'image', 23, NULL, 7, '2026-02-05 12:22:05', '2026-02-05 12:26:08'),
(94, 7, 'video', 18, NULL, 8, '2026-02-05 12:22:13', '2026-02-05 12:26:08'),
(95, 7, 'image', 24, NULL, 9, '2026-02-05 12:22:22', '2026-02-05 12:26:08'),
(96, 7, 'video', 19, NULL, 10, '2026-02-05 12:22:30', '2026-02-05 12:26:08'),
(97, 7, 'image', 25, NULL, 11, '2026-02-05 12:22:56', '2026-02-05 12:26:08'),
(98, 7, 'video', 20, NULL, 12, '2026-02-05 12:23:05', '2026-02-05 12:26:08'),
(99, 7, 'image', 26, NULL, 13, '2026-02-05 12:23:16', '2026-02-05 12:26:08'),
(100, 7, 'video', 21, NULL, 14, '2026-02-05 12:23:24', '2026-02-05 12:26:08'),
(101, 7, 'image', 27, NULL, 15, '2026-02-05 12:23:29', '2026-02-05 12:26:08'),
(102, 7, 'video', 22, NULL, 16, '2026-02-05 12:24:01', '2026-02-05 12:26:08'),
(103, 7, 'image', 28, NULL, 17, '2026-02-05 12:24:23', '2026-02-05 12:26:08'),
(104, 7, 'video', 23, NULL, 18, '2026-02-05 12:24:44', '2026-02-05 12:26:08'),
(105, 7, 'image', 29, NULL, 19, '2026-02-05 12:24:57', '2026-02-05 12:26:08'),
(106, 7, 'video', 24, NULL, 20, '2026-02-05 12:25:09', '2026-02-05 12:26:08'),
(107, 7, 'image', 19, NULL, 21, '2026-02-05 12:25:30', '2026-02-05 12:26:08'),
(108, 7, 'video', 25, NULL, 22, '2026-02-05 12:25:41', '2026-02-05 12:26:08'),
(109, 7, 'image', 2, NULL, 23, '2026-02-05 12:26:02', '2026-02-05 12:26:08'),
(117, 10, 'image', 2, NULL, 1, '2026-02-09 09:06:21', '2026-02-15 16:09:21'),
(118, 10, 'matches', 0, NULL, 2, '2026-02-09 09:06:25', '2026-02-15 16:09:21'),
(119, 10, 'video', 15, NULL, 3, '2026-02-09 09:06:46', '2026-02-15 16:09:21'),
(120, 10, 'video', 16, NULL, 5, '2026-02-09 09:06:57', '2026-02-15 16:09:21'),
(121, 10, 'video', 17, NULL, 6, '2026-02-09 09:07:17', '2026-02-15 16:09:21'),
(122, 10, 'matches', 0, NULL, 7, '2026-02-09 09:08:52', '2026-02-15 16:09:21'),
(124, 10, 'matches', 0, NULL, 9, '2026-02-09 09:09:10', '2026-02-15 16:09:21'),
(125, 10, 'video', 18, NULL, 10, '2026-02-09 09:09:21', '2026-02-15 16:09:21'),
(126, 10, 'video', 19, NULL, 11, '2026-02-09 09:09:28', '2026-02-15 16:09:21'),
(127, 10, 'video', 25, NULL, 12, '2026-02-09 09:09:34', '2026-02-15 16:09:21'),
(128, 10, 'video', 20, NULL, 13, '2026-02-09 09:09:40', '2026-02-15 16:09:21'),
(129, 10, 'video', 21, NULL, 14, '2026-02-09 09:09:45', '2026-02-15 16:09:21'),
(130, 10, 'video', 22, NULL, 15, '2026-02-09 09:09:51', '2026-02-15 16:09:21'),
(131, 10, 'video', 23, NULL, 16, '2026-02-09 09:09:55', '2026-02-15 16:09:21'),
(132, 10, 'video', 24, NULL, 17, '2026-02-09 09:09:59', '2026-02-15 16:09:21'),
(133, 10, 'matches', 0, NULL, 18, '2026-02-09 09:10:03', '2026-02-15 16:09:21'),
(134, 10, 'image', 30, NULL, 8, '2026-02-09 09:23:55', '2026-02-15 16:09:21'),
(135, 10, 'flag_matches', 0, NULL, 4, '2026-02-15 16:09:09', '2026-02-15 16:09:21');

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

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

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `priority` varchar(255) NOT NULL DEFAULT 'normal',
  `admin_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `videos` (`id`, `title`, `description`, `thumbnail`, `video_url`, `created_at`, `updated_at`) VALUES
(15, '1-lingo-kendini-tanitma', '1-lingo-kendini-tanitma', NULL, 'videos/V7V7dBp2WbVpoXJxuP2PJhPn4GvBhT4StTIw4uKL.mp4', '2026-02-05 12:08:43', '2026-02-05 12:08:43'),
(16, '2-karpuz-zamana-gore-selamlama', '2-karpuz-zamana-gore-selamlama', NULL, 'videos/Tj1iMCN4KyGVjVjSpyBAtQBGncLBRLcSTwoANDUq.mp4', '2026-02-05 12:09:04', '2026-02-05 12:09:04'),
(17, '3-nasilsin-lina-lingo', '3-nasilsin-lina-lingo', NULL, 'videos/LhJqvBebuIwoGxoLUkpFJmjtKQz98JsHjK2bGHle.mp4', '2026-02-05 12:09:40', '2026-02-05 12:09:40'),
(18, '4-yasin-kac-lingo-lina-leo', '4-yasin-kac-lingo-lina-leo', NULL, 'videos/qw4EneRneaw4yiVywAe7inhmE93i9GTxPvRzSt0v.mp4', '2026-02-05 12:10:32', '2026-02-05 12:10:32'),
(19, '5-diyalog-yas-soru', '5-diyalog-yas-soru', NULL, 'videos/KfxO5ArSVxATKFOzpnULsTzGrSeTT6OgsolUHXT8.mp4', '2026-02-05 12:11:24', '2026-02-05 12:11:24'),
(20, '6-nerelisin-lingo', '6-nerelisin-lingo', NULL, 'videos/5PHKlBMuyeJ83NgQtoPiFzcO3Raykji6uvuMqmnP.mp4', '2026-02-05 12:11:54', '2026-02-05 12:11:54'),
(21, '7-nereliyiz-lingo-lina-leo', '7-nereliyiz-lingo-lina-leo', NULL, 'videos/LnLtOBEqqx1w1Kxf4QX1SMsBrpFPTLJ5oq144Se0.mp4', '2026-02-05 12:12:20', '2026-02-05 12:12:20'),
(22, '8-lina-lingo-leo-nerelisin-diyalog', '8-lina-lingo-leo-nerelisin-diyalog', NULL, 'videos/2sBl7ZclbsZAUot18SfsYpH3E9XTZT7C7gEhHB5z.mp4', '2026-02-05 12:12:50', '2026-02-05 12:12:50'),
(23, '9-nerede-yasiyorsun-lina-lingo-diyalog', '9-nerede-yasiyorsun-lina-lingo-diyalog', NULL, 'videos/ZomYnI56CfLaays5Ir9YoxO1PnRGrqVMg2KR04mr.mp4', '2026-02-05 12:13:25', '2026-02-05 12:13:25'),
(24, '10-nerede-yasiyorsun-lina-leo-lingo', '10-nerede-yasiyorsun-lina-leo-lingo', NULL, 'videos/wrID8VqcoLhqd3ZND9EILwD3zk0d1ofOe7WFnYoI.mp4', '2026-02-05 12:14:01', '2026-02-05 12:14:01'),
(25, '11-ulkeler-baskentleri-animasyon', '11-ulkeler-baskentleri-animasyon', NULL, 'videos/9wTjUJTUUilYHqQrcbiVMyyKG19YsCvV5275lMJz.mp4', '2026-02-05 12:14:23', '2026-02-05 12:14:23');

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

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

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

--
-- Tablo için indeksler `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- Tablo için indeksler `image_audio_hotspots`
--
ALTER TABLE `image_audio_hotspots`
  ADD PRIMARY KEY (`id`),
  ADD KEY `image_audio_hotspots_image_id_foreign` (`image_id`);

--
-- Tablo için indeksler `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Tablo için indeksler `matches`
--
ALTER TABLE `matches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `matches_content_id_index` (`content_id`),
  ADD KEY `matches_section_id_foreign` (`section_id`);

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

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

--
-- Tablo için indeksler `progress`
--
ALTER TABLE `progress`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `progress_user_id_lesson_id_unique` (`user_id`,`lesson_id`),
  ADD KEY `progress_lesson_id_foreign` (`lesson_id`),
  ADD KEY `progress_section_id_foreign` (`section_id`);

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

--
-- Tablo için indeksler `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `questions_lesson_id_foreign` (`lesson_id`);

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

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

--
-- Tablo için indeksler `section_items`
--
ALTER TABLE `section_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `section_items_section_id_foreign` (`section_id`),
  ADD KEY `section_items_image_id_foreign` (`image_id`);

--
-- Tablo için indeksler `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_tickets_user_id_foreign` (`user_id`);

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

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

--
-- Tablo için AUTO_INCREMENT değeri `audios`
--
ALTER TABLE `audios`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- Tablo için AUTO_INCREMENT değeri `capital_matches`
--
ALTER TABLE `capital_matches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `flag_matches`
--
ALTER TABLE `flag_matches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `images`
--
ALTER TABLE `images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- Tablo için AUTO_INCREMENT değeri `image_audio_hotspots`
--
ALTER TABLE `image_audio_hotspots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- Tablo için AUTO_INCREMENT değeri `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `lessons`
--
ALTER TABLE `lessons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `matches`
--
ALTER TABLE `matches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

--
-- Tablo için AUTO_INCREMENT değeri `number_matches`
--
ALTER TABLE `number_matches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `progress`
--
ALTER TABLE `progress`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=532;

--
-- Tablo için AUTO_INCREMENT değeri `puzzles`
--
ALTER TABLE `puzzles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Tablo için AUTO_INCREMENT değeri `questions`
--
ALTER TABLE `questions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `quizzes`
--
ALTER TABLE `quizzes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tablo için AUTO_INCREMENT değeri `sections`
--
ALTER TABLE `sections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Tablo için AUTO_INCREMENT değeri `section_items`
--
ALTER TABLE `section_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;

--
-- Tablo için AUTO_INCREMENT değeri `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `videos`
--
ALTER TABLE `videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

--
-- Tablo kısıtlamaları `image_audio_hotspots`
--
ALTER TABLE `image_audio_hotspots`
  ADD CONSTRAINT `image_audio_hotspots_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `images` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `matches`
--
ALTER TABLE `matches`
  ADD CONSTRAINT `matches_content_id_foreign` FOREIGN KEY (`content_id`) REFERENCES `section_items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `matches_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `progress`
--
ALTER TABLE `progress`
  ADD CONSTRAINT `progress_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `progress_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `progress_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `questions`
--
ALTER TABLE `questions`
  ADD CONSTRAINT `questions_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `section_items`
--
ALTER TABLE `section_items`
  ADD CONSTRAINT `section_items_image_id_foreign` FOREIGN KEY (`image_id`) REFERENCES `images` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `section_items_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD CONSTRAINT `support_tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

