-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 23 May 2026, 23:25:59
-- Sunucu sürümü: 8.4.3
-- PHP Sürümü: 8.3.28

START TRANSACTION;



--
-- Veritabanı: `telegram`
--

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

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

CREATE TABLE `api_keys` (
  `id` int NOT NULL,
  `key_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_telegram_id` bigint NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_used` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `api_keys` (`id`, `key_name`, `api_key`, `user_telegram_id`, `is_active`, `created_at`, `last_used`, `expires_at`) VALUES
(1, 'benim', 'sk_4e25681d1ba80c2ed4b9d7907feedc1ee9ec25e85fbcaafb', 0, 1, '2026-01-19 16:28:44', NULL, NULL);

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

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

CREATE TABLE `download_logs` (
  `id` int NOT NULL,
  `file_id` int NOT NULL,
  `user_telegram_id` bigint NOT NULL,
  `download_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `download_logs` (`id`, `file_id`, `user_telegram_id`, `download_time`, `ip_address`, `user_agent`) VALUES
(1, 1, 0, '2026-01-19 13:09:49', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(2, 2, 0, '2026-01-19 13:09:55', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(3, 3, 0, '2026-01-19 13:24:23', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(4, 8, 0, '2026-01-19 13:25:31', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(5, 7, 0, '2026-01-19 13:25:35', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(6, 11, 0, '2026-01-19 13:41:39', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(7, 12, 0, '2026-01-19 13:41:42', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(8, 6, 0, '2026-01-19 13:41:44', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(9, 14, 0, '2026-01-19 13:51:40', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(10, 14, 0, '2026-01-19 16:33:35', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(11, 15, 0, '2026-01-21 18:50:46', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36'),
(12, 18, 0, '2026-04-30 20:16:22', '192.168.1.103', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(13, 18, 0, '2026-04-30 20:44:25', '192.168.1.103', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(14, 21, 0, '2026-04-30 22:09:21', '192.168.1.103', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(15, 21, 0, '2026-04-30 22:29:27', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(16, 21, 0, '2026-04-30 22:29:28', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(17, 21, 0, '2026-04-30 22:29:35', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(18, 21, 0, '2026-04-30 22:29:36', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(19, 21, 0, '2026-04-30 22:29:36', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(20, 21, 0, '2026-04-30 22:29:37', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(21, 21, 0, '2026-04-30 22:29:39', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(22, 21, 0, '2026-04-30 22:29:39', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(23, 21, 0, '2026-04-30 22:29:40', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(24, 21, 0, '2026-04-30 22:34:57', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(25, 21, 0, '2026-04-30 22:34:59', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(26, 21, 0, '2026-04-30 22:42:29', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(27, 21, 0, '2026-04-30 22:42:30', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(28, 21, 0, '2026-04-30 22:42:54', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(29, 21, 0, '2026-04-30 22:42:55', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(30, 21, 0, '2026-04-30 22:46:42', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(31, 21, 0, '2026-04-30 22:46:43', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(32, 21, 0, '2026-04-30 22:50:42', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(33, 21, 0, '2026-04-30 22:50:43', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(34, 21, 0, '2026-04-30 22:50:49', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(35, 21, 0, '2026-04-30 22:50:51', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(36, 21, 0, '2026-04-30 22:51:09', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(37, 21, 0, '2026-04-30 22:51:10', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(38, 21, 0, '2026-04-30 22:51:16', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(39, 21, 0, '2026-04-30 22:51:17', '192.168.1.103', 'AppleCoreMedia/1.0.0.23D8133 (iPhone; U; CPU OS 26_3_1 like Mac OS X; tr_tr)'),
(40, 22, 0, '2026-05-01 19:35:38', '192.168.1.104', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(41, 36, 0, '2026-05-01 21:13:07', '192.168.1.104', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(42, 21, 0, '2026-05-01 21:13:10', '192.168.1.104', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(43, 18, 0, '2026-05-01 21:13:18', '192.168.1.104', 'Expo/1017756 CFNetwork/3860.400.51 Darwin/25.3.0'),
(44, 46, 0, '2026-05-01 21:50:15', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(45, 21, 0, '2026-05-01 21:50:58', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(46, 36, 0, '2026-05-01 21:51:12', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(47, 21, 0, '2026-05-01 21:51:13', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(48, 18, 0, '2026-05-01 21:51:13', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(49, 16, 0, '2026-05-01 21:51:14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(50, 15, 0, '2026-05-01 21:51:14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(51, 21, 0, '2026-05-01 22:03:52', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(52, 46, 0, '2026-05-01 22:11:37', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(53, 43, 0, '2026-05-01 22:11:37', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36'),
(54, 36, 0, '2026-05-01 22:11:37', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Trae/1.107.1 Chrome/142.0.7444.235 Electron/39.2.7 Safari/537.36');

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

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

CREATE TABLE `files` (
  `id` int NOT NULL,
  `telegram_file_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telegram_message_id` bigint DEFAULT NULL,
  `file_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `share_token` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `share_expires_at` timestamp NULL DEFAULT NULL,
  `file_size` bigint NOT NULL,
  `file_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` text COLLATE utf8mb4_unicode_ci,
  `telegram_url` text COLLATE utf8mb4_unicode_ci,
  `uploaded_by` bigint DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `is_public_upload` tinyint(1) DEFAULT '0',
  `bot_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_engine` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'php',
  `is_chunked` tinyint(1) DEFAULT '0',
  `chunk_count` int DEFAULT '1',
  `is_downloaded` tinyint(1) DEFAULT '0',
  `download_count` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `folder_id` int DEFAULT NULL,
  `is_favorite` tinyint(1) DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `files` (`id`, `telegram_file_id`, `telegram_message_id`, `file_name`, `display_name`, `share_token`, `share_expires_at`, `file_size`, `file_type`, `mime_type`, `file_path`, `telegram_url`, `uploaded_by`, `user_id`, `is_public_upload`, `bot_token`, `upload_engine`, `is_chunked`, `chunk_count`, `is_downloaded`, `download_count`, `created_at`, `updated_at`, `folder_id`, `is_favorite`, `deleted_at`) VALUES
(3, 'BQACAgQAAyEGAATQVZmCAAMDaW4wdl8c5Rwoe3kMP1KRpdOBYmUAAi0dAALRr3BTeA_baDMcJUI4BA', 3, '676x676.png', '6362c4bc5ea2.png', NULL, NULL, 290189, 'image/png', 'image/png', NULL, NULL, NULL, 1, 0, NULL, 'php', 0, 1, 0, 1, '2026-01-19 13:24:07', '2026-01-19 13:24:23', NULL, 0, NULL),
(5, 'BQACAgQAAyEGAATQVZmCAAMFaW4wvVBNXgK_oSiPVkV9np0LegEAAi8dAALRr3BT2_Z5f59fASo4BA', 5, 'Ekran görüntüsü 2025-04-15 230057.png', 'b8b08173bf5c.png', NULL, NULL, 621951, 'image/png', 'image/png', NULL, NULL, NULL, 1, 0, NULL, 'php', 0, 1, 0, 0, '2026-01-19 13:25:18', '2026-01-19 13:25:18', NULL, 0, NULL),
(6, 'BQACAgQAAyEGAATQVZmCAAMGaW4wvlrY7zmZGwVizm71s_BNnOUAAjAdAALRr3BTpLcn4ELlykw4BA', 6, 'Ekran görüntüsü 2025-04-15 230304.png', '38c4fb17bcc9.png', NULL, NULL, 299348, 'image/png', 'image/png', NULL, NULL, NULL, 1, 0, NULL, 'php', 0, 1, 0, 1, '2026-01-19 13:25:19', '2026-01-19 13:41:44', NULL, 0, NULL),
(7, 'BQACAgQAAyEGAATQVZmCAAMHaW4wwJ1153koSNN97iKSQSgZDbgAAjEdAALRr3BTF6iOyLQ-fPw4BA', 7, 'ic_launcher.png', 'b9bd0b694bfe.png', NULL, NULL, 352146, 'image/png', 'image/png', NULL, NULL, NULL, 1, 0, NULL, 'php', 0, 1, 0, 1, '2026-01-19 13:25:20', '2026-01-19 13:25:35', NULL, 0, NULL),
(9, 'BQACAgQAAyEGAATQVZmCAAMJaW40fGAZjGaeknbvD51eCGBGuEEAAjMdAALRr3BTKBXWITVfESk4BA', 9, '8a7744c84e1f62ad.png', 'Ekran görüntüsü 2025-04-15 230304.png', NULL, NULL, 299348, 'image/png', 'image/png', NULL, 'https://t.me/c/3495270786/9', 0, 1, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 0, '2026-01-19 13:41:16', '2026-01-19 13:41:16', NULL, 0, NULL),
(11, 'BQACAgQAAyEGAATQVZmCAAMLaW40flPRKPrGCkCSvmrcKOwbbQwAAjUdAALRr3BTtK119BZKdbY4BA', 11, 'e5486abe22122fb0.png', 'ic_launcher.png', NULL, NULL, 352146, 'image/png', 'image/png', NULL, 'https://t.me/c/3495270786/11', 0, 1, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 1, '2026-01-19 13:41:19', '2026-01-19 13:41:39', NULL, 0, NULL),
(13, 'BQACAgQAAyEGAATQVZmCAAMNaW42YOSos1-DHs-i0VBuiyG9UJwAAqQcAALRr3hTwZ4dBm4TSUs4BA', 13, 'bdb3e4b7d6560b0a.png', '7653800-42.png', NULL, NULL, 1773, 'image/png', 'image/png', NULL, 'https://t.me/c/3495270786/13', 0, 1, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 0, '2026-01-19 13:49:21', '2026-01-19 13:49:21', NULL, 0, NULL),
(14, 'BQACAgQAAyEGAATQVZmCAAMOaW424uTaD8Q5YN3ZjEv9QHwwWaQAAqYcAALRr3hT1j1BLT00-Qk4BA', 14, '34e3962ea0d34021.jpg', 'Screenshot_20250302-203029.jpg', NULL, NULL, 94272, 'image/jpeg', 'image/jpeg', NULL, 'https://t.me/c/3495270786/14', 0, 1, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 2, '2026-01-19 13:51:31', '2026-01-19 16:33:35', NULL, 0, NULL),
(15, 'BQACAgQAAyEGAATQVZmCAAMPaXEf1ciwYXGT7hicmDS6W7Lqkw4AAnMcAAKzfolT-2EAARfGJnPkOAQ', 15, 'Mert%20Samet%20Tas%CC%A7%204%20Gu%CC%88nlu%CC%88k%20SBD%201.Hafta%20.txt', '2d282d8f0f33_Mert%20Samet%20Tas%CC%A7%204%20Gu%CC%88nlu%CC%88k%20SBD%201.Hafta%20.txt', NULL, NULL, 1994, 'text/plain', 'text/plain', NULL, NULL, NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 2, '2026-01-21 18:49:59', '2026-05-01 21:51:14', NULL, 0, NULL),
(16, 'BQACAgQAAyEGAATQVZmCAAMQaXEgFGjJQ0zVvlnainCEG96JL9EAAnYcAAKzfolTg6XE3gZrzAc4BA', 16, 'Dekont.pdf', 'ceb95fb31e30_Dekont.pdf', NULL, NULL, 127552, 'application/pdf', 'application/pdf', NULL, NULL, NULL, 2, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 1, '2026-01-21 18:51:02', '2026-05-01 21:51:14', NULL, 0, NULL),
(18, 'BQACAgQAAyEGAATQVZmCAAMSafO4efBTNAlhvbRwSEQa9742ihcAAucgAAKAHaBTzhmIlr_pMkI7BA', 18, '3A07B599-0A52-48EC-8DDC-35E9AB34FE7D.jpeg', '3A07B599-0A52-48EC-8DDC-35E9AB34FE7D.jpeg', '8ee03e733e6fed8d66ff5e794dba32b8e97fdbd6ab31ece2', NULL, 807330, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_4.jpeg', NULL, 2, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 4, '2026-04-30 20:15:54', '2026-05-01 21:51:13', NULL, 1, NULL),
(19, 'BQACAgQAAyEGAATQVZmCAAMTafPOSG6TYPh1hnxn2m2_Mg7Rw_kAAu4gAAKAHaBT5fx0phos3w47BA', 19, '6646A339-0DC3-466F-BA90-A952BAC5F399.jpeg', '6646A339-0DC3-466F-BA90-A952BAC5F399.jpeg', NULL, NULL, 807330, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_35.jpeg', NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 0, '2026-04-30 21:48:56', '2026-04-30 21:49:15', NULL, 0, '2026-04-30 18:49:15'),
(20, 'BQACAgQAAyEGAATQVZmCAAMWafPP_wLou851QEP9EBwtWAsFziMAAvEgAAKAHaBTN0vPcnMycOE7BA', 22, '42E41589-886F-44B8-8D62-927BE359AD5A.jpeg', '42E41589-886F-44B8-8D62-927BE359AD5A.jpeg', NULL, NULL, 802031, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_36.jpeg', NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 0, '2026-04-30 21:56:16', '2026-04-30 22:05:26', NULL, 0, '2026-04-30 19:05:26'),
(21, 'BAACAgQAAyEGAATQVZmCAAMYafPS-Rsn0bt2fk4qdtz8_jOn_lMAAvMgAAKAHaBTXz-LjjyzbxE7BA', 24, 'A84E3D35-C5BC-46AA-ADEA-EE1F6C006EFA.mp4', 'A84E3D35-.mp4', NULL, NULL, 8736763, 'video/mp4', 'video/mp4', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/videos/file_37.mp4', NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 30, '2026-04-30 22:09:00', '2026-05-01 22:03:52', NULL, 1, NULL),
(22, 'BQACAgQAAyEGAATQVZmCAAMZafT1h8Inge_4Ylkmrv9zNtZ5G5QAAkogAALJxKhT5aVpGht2Aks7BA', 25, 'IMG_3575.jpeg', 'IMG_3575.jpeg', '47339a21703ec5b6722e5e9b6a1fd57d2d1f152779115dc8', NULL, 1885413, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_38.jpeg', NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 1, '2026-05-01 18:48:41', '2026-05-01 20:46:12', NULL, 1, '2026-05-01 17:46:12'),
(23, 'BQACAgQAAyEGAATQVZmCAAMbafUAAZWjUbPCRAyNubZRaJMTCKCTAAJPIAACycSoU0FiA1C5DzjCOwQ', 27, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_5.txt', NULL, 3, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 0, '2026-05-01 19:35:50', '2026-05-01 19:35:50', NULL, 0, NULL),
(24, 'BQACAgQAAyEGAATQVZmCAAMeafUAAegLphPzL5S4h6G2vJyX0-K0AAJTIAACycSoU0Gwx_swx3jBOwQ', 30, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_2.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 19:37:14', '2026-05-01 19:37:14', NULL, 0, NULL),
(25, 'BQACAgQAAyEGAATQVZmCAAMfafUAAekJhcQK7VV7CwMw1YS2aG5UAAJUIAACycSoU77GYrL4wo6DOwQ', 31, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_3.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-01 19:37:14', '2026-05-01 19:37:14', NULL, 0, NULL),
(26, 'BQACAgQAAyEGAATQVZmCAAMgafUAAer67KXPG7EW0NVxn5CrUUH6AAJVIAACycSoU726jB01cCg1OwQ', 32, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_4.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 19:37:15', '2026-05-01 19:37:15', NULL, 0, NULL),
(27, 'BQACAgQAAyEGAATQVZmCAAMhafUBcQd4oC2LxflITq2H0_Va8bkAAlYgAALJxKhT0aQv881eG7I7BA', 33, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_39.txt', NULL, 3, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'php', 0, 1, 0, 0, '2026-05-01 19:39:30', '2026-05-01 19:39:30', NULL, 0, NULL),
(28, 'BQACAgQAAyEGAATQVZmCAAMiafUBcXsKYK5eA0toiBs6dI78t-EAAlcgAALJxKhTZWs3CzH5CpM7BA', 34, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_5.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 19:39:31', '2026-05-01 19:39:31', NULL, 0, NULL),
(29, 'chunked_011a2fe365d9954506fb55194f8ecac8', NULL, 'big-test.bin', 'big-test.bin', NULL, NULL, 50331648, 'application/octet-stream', 'application/octet-stream', NULL, NULL, NULL, 3, 0, NULL, 'php', 1, 2, 0, 0, '2026-05-01 19:44:38', '2026-05-01 19:44:38', NULL, 0, NULL),
(30, 'BQACAgQAAyEGAATQVZmCAAMlafUEEJCdQUZWO8MbDwU3wXMM3EAAAlogAALJxKhT5Tqn6zWcxNg7BA', 37, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_7.txt', NULL, 3, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 0, '2026-05-01 19:50:41', '2026-05-01 19:50:41', NULL, 0, NULL),
(31, 'BQACAgQAAyEGAATQVZmCAAMmafUER1wa93_euC5PDvnQvEx3zewAAlsgAALJxKhTfG0HoYzHv4g7BA', 38, 'small-test.txt', 'small-test.txt', NULL, NULL, 27, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_8.txt', NULL, 3, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 0, '2026-05-01 19:51:36', '2026-05-01 19:51:36', NULL, 0, NULL),
(32, 'BQACAgQAAyEGAATQVZmCAAMnafUGVuBC5_wj7e8Gv2IfN1bBg5kAAlwgAALJxKhTr9shCW-XDxs7BA', 39, 'upload-check.txt', 'upload-check.txt', NULL, NULL, 26, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_9.txt', NULL, 3, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 0, '2026-05-01 20:00:23', '2026-05-01 20:00:23', NULL, 0, NULL),
(33, 'BQACAgQAAyEGAATQVZmCAAMoafUGq8QgowHTBr1HItO5cHcKWeoAAl0gAALJxKhTxtzQZMTgxJU7BA', 40, 'upload-check.txt', 'upload-check.txt', NULL, NULL, 36, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_6.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-01 20:01:49', '2026-05-01 20:01:49', NULL, 0, NULL),
(34, 'BQACAgQAAyEGAATQVZmCAAMpafUH2-4UnFpkItctKr55cXty8rQAAl4gAALJxKhTLzsFKPNER4Q7BA', 41, 'Dekont.pdf', 'Dekont.pdf', NULL, NULL, 127552, 'application/pdf', 'application/pdf', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_7.pdf', NULL, 2, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 20:06:52', '2026-05-01 20:46:10', NULL, 0, '2026-05-01 17:46:10'),
(35, 'BQACAgQAAyEGAATQVZmCAAMqafUIeRs9JHe1XE3MO3JudQauIJUAAl8gAALJxKhT62_INq-4zCk7BA', 42, 'IMG_3575.jpeg', 'IMG_3575.jpeg', '2db123626408fdabc7ac7dea0b920984e76739b4616446d6', NULL, 1885413, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_8.jpeg', NULL, 2, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 20:09:31', '2026-05-01 20:10:29', NULL, 0, '2026-05-01 17:10:29'),
(36, 'BQACAgQAAyEGAATQVZmCAAMrafULrYrF2r-spmSVkarM3d1ZfjAAAmEgAALJxKhTjdWoXTCVT5k7BA', 43, 'IMG_3575.jpeg', 'IMG_3575.jpeg', NULL, NULL, 1885413, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_9.jpeg', NULL, 2, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 3, '2026-05-01 20:23:11', '2026-05-01 22:11:37', NULL, 1, NULL),
(37, 'BQACAgQAAyEGAATQVZmCAAMsafUNGbGN3tVNMFTyzncPNlbhw2YAAmQgAALJxKhTULy4ijdx8u87BA', 44, 'multi-1.txt', 'multi-1.txt', NULL, NULL, 14, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_10.txt', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 20:29:15', '2026-05-01 20:29:15', NULL, 0, NULL),
(38, 'BQACAgQAAyEGAATQVZmCAAMtafUNGnQeowtKfkl6KQLuVGQiQcUAAmUgAALJxKhT_xzBTYi-Mc47BA', 45, 'multi-2.txt', 'multi-2.txt', NULL, NULL, 14, 'text/plain', 'text/plain', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_10.txt', NULL, 3, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'python', 0, 1, 0, 0, '2026-05-01 20:29:16', '2026-05-01 20:29:16', NULL, 0, NULL),
(39, 'BQACAgQAAyEGAATQVZmCAAMuafUNNHel9o8EpyzD7W31r0r1l_EAAmggAALJxKhTsnBxg1E475I7BA', 46, 'IMG_3575.jpeg', 'IMG_3575.jpeg', NULL, NULL, 64, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_40.jpeg', NULL, 3, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'python', 0, 1, 0, 0, '2026-05-01 20:29:41', '2026-05-01 20:29:41', NULL, 0, NULL),
(40, 'BQACAgQAAyEGAATQVZmCAAMvafUNNfxW18XKPkq7kMIqDUr12VwAAmkgAALJxKhTYl5YGfThjvw7BA', 47, 'IMG_3576.jpeg', 'IMG_3576.jpeg', NULL, NULL, 64, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_11.jpeg', NULL, 3, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'python', 0, 1, 0, 0, '2026-05-01 20:29:42', '2026-05-01 20:29:42', NULL, 0, NULL),
(41, 'BQACAgQAAyEGAATQVZmCAAMwafUPw6pd6f3kSnvW5a06LYZG1w4AAm0gAALJxKhT9FnWx4ZWKu87BA', 48, 'Enabiz-Tahlilleri%202.pdf', 'Enabiz-Tahlilleri%202.pdf', NULL, NULL, 110245, 'application/pdf', 'application/pdf', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_11.pdf', NULL, 2, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'python', 0, 1, 0, 0, '2026-05-01 20:40:36', '2026-05-01 20:45:54', NULL, 0, '2026-05-01 17:45:54'),
(42, 'BQACAgQAAyEGAATQVZmCAAMxafUPxaNxV-NolB3Bic0Nxc8AAZFhAAJuIAACycSoUzGRKTrJxykzOwQ', 49, 'Enabiz-Tahlilleri.pdf', 'Enabiz-Tahlilleri.pdf', NULL, NULL, 110245, 'application/pdf', 'application/pdf', NULL, 'https://api.telegram.org/file/bot7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto/documents/file_41.pdf', NULL, 2, 0, '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', 'python', 0, 1, 0, 0, '2026-05-01 20:40:38', '2026-05-01 20:45:52', NULL, 0, '2026-05-01 17:45:52'),
(43, 'BQACAgQAAyEGAATQVZmCAAMyafUTvWF83_uDlSs2YdpAcn9MRZkAAg0ZAALJxLBTnVuTD3Z-Haw7BA', 50, 'IMG_3579.jpeg', 'file_20260501_205730_fc752904.jpeg', NULL, NULL, 2310865, 'image/jpeg', 'image/jpeg', NULL, 'https://api.telegram.org/file/bot8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw/documents/file_12.jpeg', NULL, 2, 0, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 1, '2026-05-01 20:57:34', '2026-05-01 22:11:37', NULL, 1, NULL),
(46, 'BQACAgQAAyEGAATQVZmCAAM1afUgDWU-3tWjgg9rWljziuCvXbcAAhYZAALJxLBTsdFEano0peE7BA', 53, '512x676.png', 'file_20260501_215005_84452737.png', '6b64cbb1ff9f315a5d2a5cc52d973b4d51ea2ac1cbb3ea63', NULL, 181258, 'image/png', 'image/png', NULL, 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_14.png', NULL, 2, 0, '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'php', 0, 1, 0, 2, '2026-05-01 21:50:06', '2026-05-01 22:11:37', NULL, 1, NULL),
(47, 'chunked_680c22155560c9297a800d619ef65931', NULL, 'trae-public-upload.txt', 'file_20260502_175949_4eebc2e4.txt', '1246616c0ff3e278fe31db7b4a9a6e31323c2f90c83401d8', NULL, 35, 'text/plain', 'text/plain', NULL, NULL, NULL, NULL, 0, NULL, 'php', 1, 2, 0, 0, '2026-05-02 17:59:50', '2026-05-02 17:59:51', NULL, 0, NULL),
(48, 'chunked_0288ca1fa25fa38c2952acc6ece4217e', NULL, 'c4fd9bf122bc.png', 'file_20260502_180127_a3a9f7d1.png', 'e12e53e63a2714d5384d681be6f92c08e49fd28418c49238', NULL, 1500723, 'image/png', 'image/png', NULL, NULL, NULL, NULL, 0, NULL, 'php', 1, 2, 0, 0, '2026-05-02 18:01:30', '2026-05-02 18:01:31', NULL, 0, NULL),
(49, 'chunked_3dda200d3658ccdc55a41ee95e5967d6', NULL, 'trae-expiring-upload.txt', 'file_20260502_180452_f902de45.txt', '159a11714af4556f34c98e1b4b9621f7f80fd7b405733e67', '2026-05-02 16:04:55', 21, 'text/plain', 'text/plain', NULL, NULL, NULL, NULL, 1, NULL, 'php', 1, 2, 0, 0, '2026-05-02 18:04:54', '2026-05-02 18:04:55', NULL, 0, NULL),
(50, 'chunked_fcf109edc9d634d779228c2db5e1ba50', NULL, '12.mp4', 'file_20260502_180524_1b66c76d.mp4', '5fa9000eb06262027f178b08f426a0b35dd3602520232c34', '2026-05-09 15:05:33', 4467519, 'video/mp4', 'video/mp4', NULL, NULL, NULL, NULL, 1, NULL, 'php', 1, 2, 0, 0, '2026-05-02 18:05:32', '2026-05-02 18:05:33', NULL, 0, NULL),
(52, 'chunked_ebb3a23038f1b16b11dbea817a6a4283', NULL, 'UnityHubSetup-x64.exe', 'file_20260508_211555_75b488bc.exe', 'e3a63295170ee9d991eb9f42bf2984cbeec98f671554f170', '2026-05-09 21:19:04', 148529824, 'application/x-msdownload', 'application/x-msdownload', NULL, NULL, NULL, NULL, 1, NULL, 'php', 1, 18, 0, 0, '2026-05-08 21:18:57', '2026-05-08 21:19:04', NULL, 0, NULL),
(53, 'chunked_463d73b78fcf12c323a6a358bb132218', NULL, 'sample.txt', 'file_20260508_212750_8ef9e6ca.txt', '196d68c4f39851eea5da9bfe864117b277698986a06cc923', '2026-05-08 22:27:53', 10, 'text/plain', 'text/plain', NULL, NULL, NULL, NULL, 1, NULL, 'php', 1, 2, 0, 0, '2026-05-08 21:27:52', '2026-05-08 21:27:53', NULL, 0, NULL),
(54, 'BQACAgQAAyEGAATQVZmCAANUaf5WcDQsjozSyLjUcYO4ChHUxmoAArweAAKFTfBTOLhV1LyIR7A7BA', 84, 'tiny-single-upload.txt', 'file_20260508_213232_cdd714cf.txt', 'a9c46cad545c079c8e49ae59f6ec5a265ab5a321a9d2817f', '2026-05-08 22:32:34', 18, 'text/plain', 'text/plain', NULL, NULL, NULL, NULL, 1, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-08 21:32:33', '2026-05-08 21:32:34', NULL, 0, NULL),
(55, 'BQACAgQAAyEGAATQVZmCAANVaf5Xmkyo0eJXwXU2DVjJPHAkLvoAAr0eAAKFTfBTaea74Y9ka_s7BA', 85, 'package-lock.json', 'file_20260508_213729_f7e56b37.json', '494ca905a0bc0a59d75715d56ddc6e18a65ddfd7bb9f375d', '2026-05-09 21:37:31', 97687, 'application/json', 'application/json', NULL, NULL, NULL, NULL, 1, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-08 21:37:30', '2026-05-08 21:37:31', NULL, 0, NULL),
(56, 'BQACAgQAAyEGAATQVZmCAANWaf5YIUabIODwBH8u1yKqMExVFhgAAsAeAAKFTfBTJt9FTNYfTTg7BA', 86, 'puppeteer-extractor.js', 'file_20260508_213945_29a0406f.js', '2ce6dbc58e08847c3c9a1da7822114dfc369ecfa3dca5683', '2026-05-09 21:39:46', 11977, 'text/javascript', 'text/javascript', NULL, NULL, NULL, NULL, 1, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-08 21:39:46', '2026-05-08 21:39:46', NULL, 0, NULL),
(57, 'BQACAgQAAyEGAATQVZmCAANXag3QZgeGx1HFq-NwjBlqFk9mNNEAAlkgAAJwmXFQ7iSWZSB1Gis7BA', 87, 'NamazVakti.php', 'file_20260520_151653_1d66da33.php', 'f604f959913f6468564ef6db5c262a111da517d7e1f0e753', '2026-05-21 15:16:55', 45306, 'application/octet-stream', 'application/octet-stream', NULL, NULL, NULL, NULL, 1, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-20 15:16:54', '2026-05-20 15:16:55', NULL, 0, NULL),
(58, 'BQACAgQAAyEGAATQVZmCAANYag3QheioRlhdYGJiEXGFAAGkwm-OAAJaIAACcJlxUEqKSeky3_NrOwQ', 88, 'c4fd9bf122bc.png', 'file_20260520_151723_fce17c0c.png', 'baa06e2db4cd78040f20054f85e2a289afdd614285b9bb49', '2026-05-21 15:17:26', 1500723, 'image/png', 'image/png', NULL, NULL, NULL, NULL, 1, '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', 'php', 0, 1, 0, 0, '2026-05-20 15:17:25', '2026-05-20 15:17:26', NULL, 0, NULL);

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

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

CREATE TABLE `file_parts` (
  `id` int NOT NULL,
  `file_id` int NOT NULL,
  `part_index` int NOT NULL,
  `telegram_file_id` varchar(255) NOT NULL,
  `telegram_message_id` bigint DEFAULT NULL,
  `part_name` varchar(500) DEFAULT NULL,
  `part_size` bigint NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `bot_token` varchar(255) DEFAULT NULL,
  `telegram_url` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `file_parts` (`id`, `file_id`, `part_index`, `telegram_file_id`, `telegram_message_id`, `part_name`, `part_size`, `mime_type`, `bot_token`, `telegram_url`, `created_at`) VALUES
(1, 29, 0, 'BQACAgQAAyEGAATQVZmCAAMjafUCn0ME4VwJwu1AVe8zaAdUhmoAAlggAALJxKhTdHtEI8flsa47BA', 35, 'big-test.part001of002.bin', 47185920, 'application/octet-stream', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-01 19:44:38'),
(2, 29, 1, 'BQACAgQAAyEGAATQVZmCAAMkafUCpMc9-nYscY3_MQFO30CUJKUAAlkgAALJxKhTc8YmhkHbOYs7BA', 36, 'big-test.part002of002.bin', 3145728, 'application/octet-stream', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', 'https://api.telegram.org/file/bot8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs/documents/file_6.bin', '2026-05-01 19:44:38'),
(3, 47, 0, 'BQACAgQAAyEGAATQVZmCAAM2afY7lY5joTXrN97znmn82pBXqt0AAmYaAALJxLhTP0U22skB5Qc7BA', 54, 'file_20260502_175949_4eebc2e4.part001of002.txt', 18, 'text/plain', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-02 17:59:50'),
(4, 47, 1, 'BQACAgQAAyEGAATQVZmCAAM3afY7ltzc4lvBIQrFD6y-7mjV32kAAmcaAALJxLhTh0moVV-aN_c7BA', 55, 'file_20260502_175949_4eebc2e4.part002of002.txt', 17, 'text/plain', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-02 17:59:50'),
(5, 48, 0, 'BQACAgQAAyEGAATQVZmCAAM4afY7-F4S2eXYCm-TmHWd_3f-pukAAmsaAALJxLhT0eRtmzcTTPQ7BA', 56, 'file_20260502_180127_a3a9f7d1.part001of002.png', 750362, 'image/png', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-02 18:01:30'),
(6, 48, 1, 'BQACAgQAAyEGAATQVZmCAAM5afY7-cLehoyLqldyFXHlDv9gf08AAmwaAALJxLhTNauWRQioybg7BA', 57, 'file_20260502_180127_a3a9f7d1.part002of002.png', 750361, 'image/png', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-02 18:01:30'),
(7, 49, 0, 'BQACAgQAAyEGAATQVZmCAAM6afY8xJQ3yTi7FQABUYjKvOA6BL8RAAJuGgACycS4U-MqVOcE7c7YOwQ', 58, 'file_20260502_180452_f902de45.part001of002.txt', 11, 'text/plain', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-02 18:04:54'),
(8, 49, 1, 'BQACAgQAAyEGAATQVZmCAAM7afY8xQ56tdSMhCj3TRgON1VOTcMAAm8aAALJxLhTgkFnNIz2P207BA', 59, 'file_20260502_180452_f902de45.part002of002.txt', 10, 'text/plain', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-02 18:04:54'),
(9, 50, 0, 'CgACAgQAAyEGAATQVZmCAAM8afY855BBFFmdFS9diKhJSWCYq-oAAnAaAALJxLhTxAJ4uRzkSF87BA', 60, 'file_20260502_180524_1b66c76d.part001of002.mp4', 2233760, 'video/mp4', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-02 18:05:32'),
(10, 50, 1, 'BQACAgQAAyEGAATQVZmCAAM9afY865EEEhuaQ1g6TMQxtIwcio0AAnEaAALJxLhT3p-GULnz3_k7BA', 61, 'file_20260502_180524_1b66c76d.part002of002.mp4', 2233759, 'video/mp4', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-02 18:05:32'),
(13, 52, 0, 'BQACAgQAAyEGAATQVZmCAANAaf5SlYjU7f3aXQsEwJD4gLHtvkcAAqceAAKFTfBTaUQuQ6dH_so7BA', 64, 'file_20260508_211555_75b488bc.part001of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(14, 52, 1, 'BQACAgQAAyEGAATQVZmCAANBaf5SoBKRHB-tGKuOraDXQDSSY_kAAqgeAAKFTfBTKBd-OcbYKN07BA', 65, 'file_20260508_211555_75b488bc.part002of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(15, 52, 2, 'BQACAgQAAyEGAATQVZmCAANCaf5Sq0M1ld4VSaI-UvnSNMtS85sAAqkeAAKFTfBTHxOLoS-A3Xw7BA', 66, 'file_20260508_211555_75b488bc.part003of018.exe', 8388608, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(16, 52, 3, 'BQACAgQAAyEGAATQVZmCAANDaf5StfLg7lMRYv2WS75crv9RkloAAqoeAAKFTfBTub7U8HyOtzY7BA', 67, 'file_20260508_211555_75b488bc.part004of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(17, 52, 4, 'BQACAgQAAyEGAATQVZmCAANEaf5SwCT7kOZVFGCoXa17B42UKCQAAqseAAKFTfBTflNQTeyECtA7BA', 68, 'file_20260508_211555_75b488bc.part005of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(18, 52, 5, 'BQACAgQAAyEGAATQVZmCAANFaf5Syu4RIwtJv_6CrQABJQN2Y1N5AAKsHgAChU3wUyvi1EZrWOxJOwQ', 69, 'file_20260508_211555_75b488bc.part006of018.exe', 8388608, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(19, 52, 6, 'BQACAgQAAyEGAATQVZmCAANGaf5S1IZolHlf9WQYQk3rGkCswLkAAq0eAAKFTfBTAsSmJQhaIy87BA', 70, 'file_20260508_211555_75b488bc.part007of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(20, 52, 7, 'BQACAgQAAyEGAATQVZmCAANHaf5S3i7m1EF-KosY7lHtgihD81oAAq4eAAKFTfBTthG94jdedGM7BA', 71, 'file_20260508_211555_75b488bc.part008of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(21, 52, 8, 'BQACAgQAAyEGAATQVZmCAANIaf5S6Jrz8POSV90-5eW2ge_YEjAAAq8eAAKFTfBTrqFQI2n2V6o7BA', 72, 'file_20260508_211555_75b488bc.part009of018.exe', 8388608, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(22, 52, 9, 'BQACAgQAAyEGAATQVZmCAANJaf5S8oxFn33-0hBiNEyZoBqWv3gAArAeAAKFTfBT02yOMRffVCU7BA', 73, 'file_20260508_211555_75b488bc.part010of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(23, 52, 10, 'BQACAgQAAyEGAATQVZmCAANKaf5S_JA4nMoX1U7TZoM4d14GHIMAArEeAAKFTfBT7M6GAdoiFY47BA', 74, 'file_20260508_211555_75b488bc.part011of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(24, 52, 11, 'BQACAgQAAyEGAATQVZmCAANLaf5TBjNQmNhPH5-M9VJz1qCaCcwAArIeAAKFTfBTKVVMVTvYIlI7BA', 75, 'file_20260508_211555_75b488bc.part012of018.exe', 8388608, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(25, 52, 12, 'BQACAgQAAyEGAATQVZmCAANMaf5TEBZDxum6Xwsp-kvdmbStj70AArMeAAKFTfBTFQPL2Y9r3RM7BA', 76, 'file_20260508_211555_75b488bc.part013of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(26, 52, 13, 'BQACAgQAAyEGAATQVZmCAANNaf5TG4BwQbDSZLVyeJWwYVUfZ6sAArQeAAKFTfBTlpObgJe9q5o7BA', 77, 'file_20260508_211555_75b488bc.part014of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(27, 52, 14, 'BQACAgQAAyEGAATQVZmCAANOaf5TJeCKEyy31izqRfivJU67GpkAArUeAAKFTfBT213zp2gvvVo7BA', 78, 'file_20260508_211555_75b488bc.part015of018.exe', 8388608, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(28, 52, 15, 'BQACAgQAAyEGAATQVZmCAANPaf5TL0-v6bFk1U9nxnNuJHPirHgAArYeAAKFTfBTgtl70frSLWM7BA', 79, 'file_20260508_211555_75b488bc.part016of018.exe', 8388608, 'application/x-msdownload', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:18:57'),
(29, 52, 16, 'BQACAgQAAyEGAATQVZmCAANQaf5TOWotHRK00RjdJUemRgEnkAwAArceAAKFTfBTJRuyTZnEyfI7BA', 80, 'file_20260508_211555_75b488bc.part017of018.exe', 8388608, 'application/x-msdownload', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:18:57'),
(30, 52, 17, 'BQACAgQAAyEGAATQVZmCAANRaf5TQE4JEodEqggtLtATpsO9pd8AArgeAAKFTfBTR-eaIVoObZw7BA', 81, 'file_20260508_211555_75b488bc.part018of018.exe', 5923488, 'application/x-msdownload', '7674057900:AAFhhQq9j5gLR0UeEg_XLECHCmyAdzskqto', NULL, '2026-05-08 21:18:57'),
(31, 53, 0, 'BQACAgQAAyEGAATQVZmCAANSaf5VVnERD9-YjP1udNUVhwkwoRMAAroeAAKFTfBTznf-4KhTwXY7BA', 82, 'file_20260508_212750_8ef9e6ca.part001of002.txt', 5, 'text/plain', '8449605453:AAFI7QH1gdvo429n06_1uvjbp5gAh3xjlYw', NULL, '2026-05-08 21:27:52'),
(32, 53, 1, 'BQACAgQAAyEGAATQVZmCAANTaf5VV_ZKzYUgbITKpW_dMQfev7sAArseAAKFTfBTQClCJwT_-Xw7BA', 83, 'file_20260508_212750_8ef9e6ca.part002of002.txt', 5, 'text/plain', '8505154109:AAExKru0XUvb7vYgH1zvGntJ_9Gz66WLscs', NULL, '2026-05-08 21:27:52');

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

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

CREATE TABLE `file_tags` (
  `file_id` int NOT NULL,
  `tag_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

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

CREATE TABLE `folders` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(7) DEFAULT '#3e577a',
  `icon` varchar(64) DEFAULT 'folder',
  `parent_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `folders` (`id`, `user_id`, `name`, `color`, `icon`, `parent_id`, `created_at`, `deleted_at`) VALUES
(3, 2, 'ad', '#2563EB', 'folder', NULL, '2026-05-01 22:07:22', '2026-05-01 19:10:50'),
(4, 2, 'ss', '#2563EB', 'folder', 3, '2026-05-01 22:07:33', NULL);

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

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

CREATE TABLE `share_collections` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `title` varchar(255) NOT NULL,
  `share_token` varchar(64) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

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

CREATE TABLE `share_collection_files` (
  `collection_id` int NOT NULL,
  `file_id` int NOT NULL,
  `sort_order` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

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

CREATE TABLE `system_config` (
  `config_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_value` text COLLATE utf8mb4_unicode_ci,
  `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 `system_config`
--

INSERT INTO `system_config` (`config_key`, `config_value`, `updated_at`) VALUES
('telethon_session', '1BJWap1sBuyx5HJpJ_3yZI-OFcB3JXk_Gm1he-8_2A428TzNdfnaZxk_v0-K__GD2Dw_dlHNHTQqSe_VALrwbGL2v_PZmplGsmYTlkBl9ymU1r7qlh6x0-EOPMX8VBJjjZ_1aUc84KUVQoYy91U4vcDxf-QUU3_nBcLLRvTgIXFT1yIW5TtCu5e5IfSDOGWhit1BZpFQv0Pzc-kBcapm6qMe8YR51oNwRcKGftMJqETEGpJt6KC-vMcQqYL9je1mWKHAAz_U2cdYoEDw7cNr1JXAIg3HqDtV218D4T87fW_1LU2mP0Zq_BK6RtujcGlfcrkdMt3_a-Z4hKjJHfbGZlhyY5RErtFY=', '2026-01-19 12:43:01');

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

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

CREATE TABLE `tags` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(7) DEFAULT '#3e577a',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `telegram_id` bigint DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `role` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'user',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `plan_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'free',
  `plan_storage_limit` bigint DEFAULT NULL,
  `plan_started_at` timestamp NULL DEFAULT NULL,
  `plan_expires_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `telegram_id`, `username`, `email`, `password_hash`, `first_name`, `last_name`, `is_active`, `role`, `created_at`, `updated_at`, `plan_type`, `plan_storage_limit`, `plan_started_at`, `plan_expires_at`) VALUES
(1, NULL, 'adminn', 'adminn@admin.com', '$2y$10$rWYCbJcwjFCKa8/lMQXqDuxaKlBPesothjdV2wlzVZj.NOXaonnqu', 'Sistem', 'Yöneticisi', 1, 'admin', '2026-01-19 12:46:05', '2026-01-19 13:40:47', 'free', NULL, NULL, NULL),
(2, NULL, 'köfte', 'admin2@admin.com', '$2y$10$mI5v1LeX.r7CaL6JAAfb1OVNSFY8wG6H6MJlwo7qzTtMjYUNCxWVa', 'köfte2', 'kofte', 1, 'user', '2026-01-21 18:10:15', '2026-05-01 18:39:29', 'pro', 549755813888, '2026-04-30 21:31:07', NULL),
(3, NULL, 'testuser', 'test@test.com', '$2y$10$bQLSInR9pAMSSX88FP/3V.JJ0z/cuSlX1WHQ30wF68T5aX88lXNqy', 'Test', 'User', 1, 'user', '2026-01-23 21:29:51', '2026-05-20 15:14:47', 'pro', 549755813888, '2026-05-01 19:35:51', NULL),
(4, NULL, 'free8013', 'free_20260501223927@test.com', '$2y$12$wBszcFRd5q5ZgMvFV4fgP.GUBM96MQJSoZBao2m9nXLiEUa0yjoBm', 'Free', 'User', 1, 'user', '2026-05-01 19:39:28', '2026-05-01 19:39:28', 'free', NULL, NULL, NULL);

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

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

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

--
-- Tablo için indeksler `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `telegram_file_id` (`telegram_file_id`),
  ADD UNIQUE KEY `idx_files_share_token` (`share_token`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `files_ibfk_folder_id` (`folder_id`);

--
-- Tablo için indeksler `file_parts`
--
ALTER TABLE `file_parts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_file_part_index` (`file_id`,`part_index`),
  ADD KEY `idx_file_parts_telegram_file_id` (`telegram_file_id`);

--
-- Tablo için indeksler `file_tags`
--
ALTER TABLE `file_tags`
  ADD PRIMARY KEY (`file_id`,`tag_id`),
  ADD KEY `tag_id` (`tag_id`);

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

--
-- Tablo için indeksler `share_collections`
--
ALTER TABLE `share_collections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `share_token` (`share_token`),
  ADD KEY `user_id` (`user_id`);

--
-- Tablo için indeksler `share_collection_files`
--
ALTER TABLE `share_collection_files`
  ADD PRIMARY KEY (`collection_id`,`file_id`),
  ADD KEY `idx_share_collection_order` (`collection_id`,`sort_order`),
  ADD KEY `file_id` (`file_id`);

--
-- Tablo için indeksler `system_config`
--
ALTER TABLE `system_config`
  ADD PRIMARY KEY (`config_key`);

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

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

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

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

--
-- Tablo için AUTO_INCREMENT değeri `download_logs`
--
ALTER TABLE `download_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- Tablo için AUTO_INCREMENT değeri `files`
--
ALTER TABLE `files`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- Tablo için AUTO_INCREMENT değeri `file_parts`
--
ALTER TABLE `file_parts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- Tablo için AUTO_INCREMENT değeri `folders`
--
ALTER TABLE `folders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tablo için AUTO_INCREMENT değeri `share_collections`
--
ALTER TABLE `share_collections`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `tags`
--
ALTER TABLE `tags`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- Tablo için AUTO_INCREMENT değeri `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- Tablo kısıtlamaları `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_ibfk_folder_id` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `files_ibfk_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_files_folder` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE SET NULL;

--
-- Tablo kısıtlamaları `file_parts`
--
ALTER TABLE `file_parts`
  ADD CONSTRAINT `fk_file_parts_file` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `file_tags`
--
ALTER TABLE `file_tags`
  ADD CONSTRAINT `file_tags_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `file_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `folders`
--
ALTER TABLE `folders`
  ADD CONSTRAINT `folders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `folders_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `share_collections`
--
ALTER TABLE `share_collections`
  ADD CONSTRAINT `share_collections_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `share_collection_files`
--
ALTER TABLE `share_collection_files`
  ADD CONSTRAINT `share_collection_files_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `share_collections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `share_collection_files_ibfk_2` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE CASCADE;

--
-- Tablo kısıtlamaları `tags`
--
ALTER TABLE `tags`
  ADD CONSTRAINT `tags_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

