-- phpMyAdmin SQL Dump -- version 5.2.3 -- 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 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Veritabanı: `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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;