-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Anamakine: localhost:3306 -- Üretim Zamanı: 20 Haz 2026, 19:46:42 -- Sunucu sürümü: 10.11.18-MariaDB -- PHP Sürümü: 8.4.21 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ı: `november_1` -- -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `domains` -- CREATE TABLE `domains` ( `id` bigint(20) UNSIGNED NOT NULL, `domain` varchar(190) NOT NULL, `server_id` bigint(20) UNSIGNED DEFAULT NULL, `cpanel_user` varchar(80) NOT NULL DEFAULT '', `cpanel_pass` text NOT NULL, `city` varchar(120) NOT NULL DEFAULT '', `district` varchar(120) NOT NULL DEFAULT '', `keywords` varchar(500) NOT NULL DEFAULT '', `vitrin_url` varchar(255) NOT NULL DEFAULT '', `tema_aktif` varchar(20) NOT NULL DEFAULT 'aktif', `site_baslik` varchar(255) NOT NULL DEFAULT '', `meta_aciklama` text DEFAULT NULL, `makale` longtext DEFAULT NULL, `w7_installed` tinyint(1) NOT NULL DEFAULT 0, `w7_api_token` varchar(190) NOT NULL DEFAULT '', `seo_status` varchar(50) NOT NULL DEFAULT 'bekliyor', `last_sync_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `domains` -- INSERT INTO `domains` (`id`, `domain`, `server_id`, `cpanel_user`, `cpanel_pass`, `city`, `district`, `keywords`, `vitrin_url`, `tema_aktif`, `site_baslik`, `meta_aciklama`, `makale`, `w7_installed`, `w7_api_token`, `seo_status`, `last_sync_at`, `created_at`) VALUES (20, 'amazonbusiness.site', 4, 'amazonbu', 'bdMMTawWe2HyhLWCzI3t4o9Eio6gLqXsAJsMEBjUrd8=', 'Eskişehir', '', '', 'https://beykoz1.store/', 'pasif', '', NULL, NULL, 1, '2a7e0d8c0288330cfbdb0e60ea959f9c09f1bd367d16e481', 'w7_kuruldu', '2026-06-20 19:42:44', '2026-06-20 19:41:19'), (21, 'apunair.site', 4, 'apunair', 'XAvNNEhYFv8X2J0EIvg6RFAr8bHMAUNzngZ3KFHAjps=', '', '', '', 'https://beykoz1.store/', 'pasif', '', NULL, NULL, 1, 'f390660e4616800e8e92df50b644b53b7375dfaef8a4f7a3', 'w7_kuruldu', '2026-06-20 19:42:28', '2026-06-20 19:41:19'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `hostnames_used` -- CREATE TABLE `hostnames_used` ( `hostname` varchar(190) NOT NULL, `server_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `job_type` varchar(80) NOT NULL, `target_type` varchar(50) NOT NULL DEFAULT '', `target_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `payload` longtext DEFAULT NULL, `status` varchar(30) NOT NULL DEFAULT 'pending', `result` longtext DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `jobs` -- INSERT INTO `jobs` (`id`, `job_type`, `target_type`, `target_id`, `payload`, `status`, `result`, `created_at`, `updated_at`) VALUES (1, 'ssh_test', 'server', 1, '[]', 'done', '{\"ip\":\"185.224.132.30\",\"port\":22,\"online\":true}', '2026-06-20 16:04:22', '2026-06-20 16:04:45'), (2, 'ssh_test', 'server', 2, '[]', 'done', '{\"ip\":\"212.162.155.153\",\"port\":22,\"online\":true}', '2026-06-20 16:08:38', '2026-06-20 16:09:18'), (3, 'ssh_test', 'server', 3, '[]', 'done', '{\"ip\":\"188.137.183.57\",\"port\":22,\"online\":true}', '2026-06-20 16:08:41', '2026-06-20 16:09:19'), (4, 'ssh_test', 'server', 4, '[]', 'done', '{\"ip\":\"188.137.183.158\",\"port\":22,\"online\":true}', '2026-06-20 16:08:45', '2026-06-20 16:09:19'), (5, 'ssh_test', 'server', 5, '[]', 'done', '{\"ip\":\"77.220.212.74\",\"port\":22,\"online\":true}', '2026-06-20 16:08:47', '2026-06-20 16:09:35'), (6, 'ssh_test', 'server', 6, '[]', 'done', '{\"ip\":\"77.220.212.40\",\"port\":22,\"online\":true}', '2026-06-20 16:08:50', '2026-06-20 16:09:35'), (7, 'ssh_test', 'server', 7, '[]', 'done', '{\"ip\":\"188.137.225.175\",\"port\":22,\"online\":true}', '2026-06-20 16:08:52', '2026-06-20 16:09:35'), (8, 'ssh_test', 'server', 8, '[]', 'done', '{\"ip\":\"188.137.225.106\",\"port\":22,\"online\":true}', '2026-06-20 16:08:54', '2026-06-20 16:09:37'), (9, 'ssh_test', 'server', 9, '[]', 'done', '{\"ip\":\"212.43.144.33\",\"port\":22,\"online\":true}', '2026-06-20 16:08:56', '2026-06-20 16:09:37'), (10, 'ssh_test', 'server', 10, '[]', 'done', '{\"ip\":\"212.43.144.206\",\"port\":22,\"online\":true}', '2026-06-20 16:08:59', '2026-06-20 16:09:37'), (11, 'ssh_test', 'server', 11, '[]', 'done', '{\"ip\":\"80.89.224.252\",\"port\":22,\"online\":true}', '2026-06-20 16:09:01', '2026-06-20 16:09:38'), (12, 'ssh_test', 'server', 12, '[]', 'done', '{\"ip\":\"80.89.224.47\",\"port\":22,\"online\":true}', '2026-06-20 16:09:03', '2026-06-20 16:09:38'), (13, 'ssh_test', 'server', 13, '[]', 'done', '{\"ip\":\"212.43.156.32\",\"port\":22,\"online\":true}', '2026-06-20 16:09:05', '2026-06-20 16:09:38'), (14, 'ssh_test', 'server', 14, '[]', 'done', '{\"ip\":\"212.43.156.65\",\"port\":22,\"online\":true}', '2026-06-20 16:09:07', '2026-06-20 16:09:39'), (15, 'ssh_test', 'server', 15, '[]', 'done', '{\"ip\":\"212.43.156.103\",\"port\":22,\"online\":true}', '2026-06-20 16:09:11', '2026-06-20 16:09:39'), (16, 'ssh_test', 'server', 16, '[]', 'done', '{\"ip\":\"212.43.159.232\",\"port\":22,\"online\":true}', '2026-06-20 16:09:14', '2026-06-20 16:09:39'), (17, 'ssh_test', 'server', 6, '[]', 'done', '{\"ip\":\"77.220.212.40\",\"port\":22,\"online\":true}', '2026-06-20 16:09:24', '2026-06-20 16:09:39'), (18, 'ssh_test', 'server', 7, '[]', 'done', '{\"ip\":\"188.137.225.175\",\"port\":22,\"online\":true}', '2026-06-20 16:09:28', '2026-06-20 16:09:39'), (19, 'ssh_test', 'server', 6, '[]', 'done', '{\"ip\":\"77.220.212.40\",\"port\":22,\"online\":true}', '2026-06-20 16:09:30', '2026-06-20 16:09:39'), (20, 'ssh_test', 'server', 16, '[]', 'done', '{\"ip\":\"212.43.159.232\",\"port\":22,\"online\":true}', '2026-06-20 16:20:06', '2026-06-20 16:20:47'), (21, 'ssh_test', 'server', 15, '[]', 'done', '{\"ip\":\"212.43.156.103\",\"port\":22,\"online\":true}', '2026-06-20 16:20:12', '2026-06-20 16:20:47'), (22, 'ssh_test', 'server', 14, '[]', 'done', '{\"ip\":\"212.43.156.65\",\"port\":22,\"online\":true}', '2026-06-20 16:20:15', '2026-06-20 16:20:47'), (23, 'ssh_test', 'server', 13, '[]', 'done', '{\"ip\":\"212.43.156.32\",\"port\":22,\"online\":true}', '2026-06-20 16:20:17', '2026-06-20 16:20:48'), (24, 'ssh_test', 'server', 12, '[]', 'done', '{\"ip\":\"80.89.224.47\",\"port\":22,\"online\":true}', '2026-06-20 16:20:19', '2026-06-20 16:20:48'), (25, 'ssh_test', 'server', 10, '[]', 'done', '{\"ip\":\"212.43.144.206\",\"port\":22,\"online\":true}', '2026-06-20 16:20:20', '2026-06-20 16:20:48'), (26, 'ssh_test', 'server', 9, '[]', 'done', '{\"ip\":\"212.43.144.33\",\"port\":22,\"online\":true}', '2026-06-20 16:20:22', '2026-06-20 16:20:48'), (27, 'ssh_test', 'server', 8, '[]', 'done', '{\"ip\":\"188.137.225.106\",\"port\":22,\"online\":true}', '2026-06-20 16:20:24', '2026-06-20 16:20:48'), (28, 'ssh_test', 'server', 7, '[]', 'done', '{\"ip\":\"188.137.225.175\",\"port\":22,\"online\":true}', '2026-06-20 16:20:25', '2026-06-20 16:20:48'), (29, 'ssh_test', 'server', 7, '[]', 'done', '{\"ip\":\"188.137.225.175\",\"port\":22,\"online\":true}', '2026-06-20 16:20:26', '2026-06-20 16:20:48'), (30, 'ssh_test', 'server', 6, '[]', 'done', '{\"ip\":\"77.220.212.40\",\"port\":22,\"online\":true}', '2026-06-20 16:20:28', '2026-06-20 16:20:49'), (31, 'ssh_test', 'server', 5, '[]', 'done', '{\"ip\":\"77.220.212.74\",\"port\":22,\"online\":true}', '2026-06-20 16:20:30', '2026-06-20 16:20:49'), (32, 'ssh_test', 'server', 4, '[]', 'done', '{\"ip\":\"188.137.183.158\",\"port\":22,\"online\":true}', '2026-06-20 16:20:32', '2026-06-20 16:20:49'), (33, 'ssh_test', 'server', 5, '[]', 'done', '{\"ip\":\"77.220.212.74\",\"port\":22,\"online\":true}', '2026-06-20 16:20:34', '2026-06-20 16:20:49'), (34, 'ssh_test', 'server', 3, '[]', 'done', '{\"ip\":\"188.137.183.57\",\"port\":22,\"online\":true}', '2026-06-20 16:20:36', '2026-06-20 16:20:49'), (35, 'ssh_test', 'server', 1, '[]', 'done', '{\"ip\":\"185.224.132.30\",\"port\":22,\"online\":true}', '2026-06-20 16:20:38', '2026-06-20 16:20:49'), (36, 'ssh_test', 'server', 2, '[]', 'done', '{\"ip\":\"212.162.155.153\",\"port\":22,\"online\":true}', '2026-06-20 16:20:54', '2026-06-20 16:20:59'), (37, 'ssh_test', 'server', 11, '[]', 'done', '{\"ip\":\"80.89.224.252\",\"port\":22,\"online\":true}', '2026-06-20 16:20:57', '2026-06-20 16:20:59'), (38, 'w7_upload', 'domain', 1, '[]', 'failed', 'WHM sifre sifirlama basarisiz. cPanel kullanici adini domain satirina elle girin.', '2026-06-20 16:28:21', '2026-06-20 16:28:28'), (39, 'w7_upload', 'domain', 1, '[]', 'failed', 'WHM sifre sifirlama basarisiz. cPanel kullanici adini domain satirina elle girin.', '2026-06-20 16:29:05', '2026-06-20 16:29:09'), (40, 'w7_upload', 'domain', 1, '[]', 'failed', 'WHM sifre sifirlama basarisiz. cPanel kullanici adini domain satirina elle girin.', '2026-06-20 16:30:04', '2026-06-20 16:30:08'), (41, 'w7_upload', 'domain', 1, '[]', 'failed', 'WHM sifre sifirlama basarisiz. cPanel kullanici adini domain satirina elle girin.', '2026-06-20 16:30:21', '2026-06-20 16:30:26'), (42, 'seo_generate', 'domain', 1, '{\"provider\":\"openai\"}', 'failed', 'Once W7 yukleyin', '2026-06-20 16:32:35', '2026-06-20 16:32:40'), (43, 'w7_upload', 'domain', 2, '[]', 'failed', 'Zip yukleme hatasi: ', '2026-06-20 16:36:27', '2026-06-20 16:36:39'), (44, 'w7_upload', 'domain', 2, '[]', 'failed', 'Zip yukleme hatasi: ', '2026-06-20 16:36:51', '2026-06-20 16:36:55'), (45, 'domain_whm', 'domain', 20, '[]', 'done', '{\"ok\":true,\"domain\":\"amazonbusiness.site\",\"cpanel_user\":\"amazonbu\",\"source\":\"whm_yeni\",\"message\":\"amazonbusiness.site: OK\"}', '2026-06-20 19:41:19', '2026-06-20 19:41:30'), (46, 'domain_whm', 'domain', 21, '[]', 'done', '{\"ok\":true,\"domain\":\"apunair.site\",\"cpanel_user\":\"apunair\",\"source\":\"whm_yeni\",\"message\":\"apunair.site: OK\"}', '2026-06-20 19:41:19', '2026-06-20 19:41:37'), (47, 'domain_w7', 'domain', 21, '[]', 'done', '{\"ok\":true,\"domain\":\"apunair.site\",\"cpanel_user\":\"apunair\",\"upload\":\"Zip acildi (W7 klasoru kontrol edin)\",\"skipped\":false,\"token_ok\":true,\"token_warning\":\"\",\"sync_error\":\"panel_token.txt yok — panelden W7 Duzelt yapin\",\"api_sync\":false,\"message\":\"apunair.site: OK\"}', '2026-06-20 19:42:15', '2026-06-20 19:42:28'), (48, 'domain_w7', 'domain', 20, '[]', 'done', '{\"ok\":true,\"domain\":\"amazonbusiness.site\",\"cpanel_user\":\"amazonbu\",\"upload\":\"Zip acildi (W7 klasoru kontrol edin)\",\"skipped\":false,\"token_ok\":true,\"token_warning\":\"\",\"sync_error\":\"panel_token.txt yok — panelden W7 Duzelt yapin\",\"api_sync\":false,\"message\":\"amazonbusiness.site: OK\"}', '2026-06-20 19:42:15', '2026-06-20 19:42:44'), (49, 'domain_sync', 'domain', 21, '{\"fields\":[\"tema_aktif\"]}', 'failed', 'apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', '2026-06-20 19:44:00', '2026-06-20 19:44:09'), (50, 'domain_sync', 'domain', 21, '{\"fields\":[\"tema_aktif\"]}', 'failed', 'apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', '2026-06-20 19:44:45', '2026-06-20 19:44:54'), (51, 'domain_sync', 'domain', 21, '{\"fields\":[\"vitrin_url\",\"tema_aktif\",\"sehir\"]}', 'failed', 'apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', '2026-06-20 19:45:05', '2026-06-20 19:45:10'), (52, 'domain_sync', 'domain', 20, '{\"fields\":[\"vitrin_url\",\"tema_aktif\",\"sehir\"]}', 'failed', 'amazonbusiness.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://amazonbusiness.site/W7/api.php kontrol edin', '2026-06-20 19:45:05', '2026-06-20 19:45:15'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `panel_logs` -- CREATE TABLE `panel_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `level` varchar(20) NOT NULL DEFAULT 'info', `category` varchar(50) NOT NULL DEFAULT '', `message` text NOT NULL, `context` longtext DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `panel_logs` -- INSERT INTO `panel_logs` (`id`, `level`, `category`, `message`, `context`, `created_at`) VALUES (1, 'info', 'domain', 'Toplu ekle: 2 domain, 2 kuyruk', NULL, '2026-06-20 19:41:19'), (2, 'info', 'job', 'Basladi #45: domain_whm (domain#20)', NULL, '2026-06-20 19:41:23'), (3, 'ok', 'job', 'Tamam #45: amazonbusiness.site: OK', '{\"ok\":true,\"domain\":\"amazonbusiness.site\",\"cpanel_user\":\"amazonbu\",\"source\":\"whm_yeni\",\"message\":\"amazonbusiness.site: OK\"}', '2026-06-20 19:41:30'), (4, 'info', 'job', 'Basladi #46: domain_whm (domain#21)', NULL, '2026-06-20 19:41:30'), (5, 'ok', 'job', 'Tamam #46: apunair.site: OK', '{\"ok\":true,\"domain\":\"apunair.site\",\"cpanel_user\":\"apunair\",\"source\":\"whm_yeni\",\"message\":\"apunair.site: OK\"}', '2026-06-20 19:41:37'), (6, 'info', 'queue', 'domain_w7 → 2 domain kuyruga alindi', NULL, '2026-06-20 19:42:15'), (7, 'info', 'job', 'Basladi #47: domain_w7 (domain#21)', NULL, '2026-06-20 19:42:20'), (8, 'ok', 'job', 'Tamam #47: apunair.site: OK', '{\"ok\":true,\"domain\":\"apunair.site\",\"cpanel_user\":\"apunair\",\"upload\":\"Zip acildi (W7 klasoru kontrol edin)\",\"skipped\":false,\"token_ok\":true,\"token_warning\":\"\",\"sync_error\":\"panel_token.txt yok — panelden W7 Duzelt yapin\",\"api_sync\":false,\"message\":\"apunair.site: OK\"}', '2026-06-20 19:42:28'), (9, 'info', 'job', 'Basladi #48: domain_w7 (domain#20)', NULL, '2026-06-20 19:42:35'), (10, 'ok', 'job', 'Tamam #48: amazonbusiness.site: OK', '{\"ok\":true,\"domain\":\"amazonbusiness.site\",\"cpanel_user\":\"amazonbu\",\"upload\":\"Zip acildi (W7 klasoru kontrol edin)\",\"skipped\":false,\"token_ok\":true,\"token_warning\":\"\",\"sync_error\":\"panel_token.txt yok — panelden W7 Duzelt yapin\",\"api_sync\":false,\"message\":\"amazonbusiness.site: OK\"}', '2026-06-20 19:42:44'), (11, 'info', 'queue', 'domain_sync → 1 domain kuyruga alindi', NULL, '2026-06-20 19:44:00'), (12, 'info', 'job', 'Basladi #49: domain_sync (domain#21)', NULL, '2026-06-20 19:44:06'), (13, 'err', 'job', 'Hata #49: apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', NULL, '2026-06-20 19:44:09'), (14, 'info', 'queue', 'domain_sync → 1 domain kuyruga alindi', NULL, '2026-06-20 19:44:45'), (15, 'info', 'job', 'Basladi #50: domain_sync (domain#21)', NULL, '2026-06-20 19:44:51'), (16, 'err', 'job', 'Hata #50: apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', NULL, '2026-06-20 19:44:54'), (17, 'info', 'queue', 'domain_sync → 2 domain kuyruga alindi', NULL, '2026-06-20 19:45:05'), (18, 'info', 'job', 'Basladi #51: domain_sync (domain#21)', NULL, '2026-06-20 19:45:08'), (19, 'err', 'job', 'Hata #51: apunair.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://apunair.site/W7/api.php kontrol edin', NULL, '2026-06-20 19:45:10'), (20, 'info', 'job', 'Basladi #52: domain_sync (domain#20)', NULL, '2026-06-20 19:45:11'), (21, 'err', 'job', 'Hata #52: amazonbusiness.site: panel_token.txt yok — panelden W7 Duzelt yapin — https://amazonbusiness.site/W7/api.php kontrol edin', NULL, '2026-06-20 19:45:15'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `servers` -- CREATE TABLE `servers` ( `id` bigint(20) UNSIGNED NOT NULL, `label` varchar(190) NOT NULL DEFAULT '', `ip` varchar(64) NOT NULL, `ssh_port` int(11) NOT NULL DEFAULT 22, `ssh_user` varchar(120) NOT NULL DEFAULT 'root', `ssh_pass` text NOT NULL, `whm_pass` text NOT NULL, `hostname` varchar(190) NOT NULL DEFAULT '', `os_type` varchar(50) NOT NULL DEFAULT 'almalinux9', `status` varchar(50) NOT NULL DEFAULT 'offline', `cpanel_ready` tinyint(1) NOT NULL DEFAULT 0, `is_ready` tinyint(1) NOT NULL DEFAULT 0, `last_check_at` datetime DEFAULT NULL, `last_error` text DEFAULT NULL, `provision_log` longtext DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `servers` -- INSERT INTO `servers` (`id`, `label`, `ip`, `ssh_port`, `ssh_user`, `ssh_pass`, `whm_pass`, `hostname`, `os_type`, `status`, `cpanel_ready`, `is_ready`, `last_check_at`, `last_error`, `provision_log`, `created_at`) VALUES (1, 'Sunucu1', '185.224.132.30', 22, 'root', 'DwpxluB/hRWhCUOyy/FZXDhjRMDa9sdxFyT0139WT8A=', 'DwpxluB/hRWhCUOyy/FZXDhjRMDa9sdxFyT0139WT8A=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:49', '', NULL, '2026-06-20 16:04:16'), (2, 'Sunucu2', '212.162.155.153', 22, 'root', '5i8oHrNJzc6Axeiu7vsySFwFHlPEJ5yixOMhFbrFWrs=', '5i8oHrNJzc6Axeiu7vsySFwFHlPEJ5yixOMhFbrFWrs=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:59', '', NULL, '2026-06-20 16:08:29'), (3, 'Sunucu3', '188.137.183.57', 22, 'root', '8UgO2kJ7inmbddXqzUM5VG+KoO3SyxSluJP8SXCTxpg=', '8UgO2kJ7inmbddXqzUM5VG+KoO3SyxSluJP8SXCTxpg=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:49', '', NULL, '2026-06-20 16:08:29'), (4, 'Sunucu4', '188.137.183.158', 22, 'root', 'tPdJKz0vplK5cFXkqvcKsUBOEurMB/igVYF5G+rIrzw=', 'tPdJKz0vplK5cFXkqvcKsUBOEurMB/igVYF5G+rIrzw=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:49', '', NULL, '2026-06-20 16:08:29'), (5, 'Sunucu5', '77.220.212.74', 22, 'root', 'ixgVDiiOC4N7uDlbEek2P5iktBNlH3+tKdKGm7d4lRc=', 'ixgVDiiOC4N7uDlbEek2P5iktBNlH3+tKdKGm7d4lRc=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:49', '', NULL, '2026-06-20 16:08:29'), (6, 'Sunucu6', '77.220.212.40', 22, 'root', 'aPvJsAQX3IAbw/gEYE5GSYoovycEiOwIIl97Y2+zeCo=', 'aPvJsAQX3IAbw/gEYE5GSYoovycEiOwIIl97Y2+zeCo=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:49', '', NULL, '2026-06-20 16:08:29'), (7, 'Sunucu7', '188.137.225.175', 22, 'root', 'CfpJTWX/BNmCzL9HoKgD6z3XyYbhqR48PTp5My+YCZo=', 'CfpJTWX/BNmCzL9HoKgD6z3XyYbhqR48PTp5My+YCZo=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:48', '', NULL, '2026-06-20 16:08:29'), (8, 'Sunucu8', '188.137.225.106', 22, 'root', '223kiHaj1EoG4ttWf8YOHGR80YEcwUI2Ht4+u1Z9ya8=', '223kiHaj1EoG4ttWf8YOHGR80YEcwUI2Ht4+u1Z9ya8=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:48', '', NULL, '2026-06-20 16:08:29'), (9, 'Sunucu9', '212.43.144.33', 22, 'root', 'Ngs+mXH0I0ncxPDgC7hlpp0VMpIeawlC071Z57xDSJI=', 'Ngs+mXH0I0ncxPDgC7hlpp0VMpIeawlC071Z57xDSJI=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:48', '', NULL, '2026-06-20 16:08:29'), (10, 'Sunucu10', '212.43.144.206', 22, 'root', 'kPs4niyKbicZIJuBb1EmYmk+1McC3uNOvY5jNH1bKxE=', 'kPs4niyKbicZIJuBb1EmYmk+1McC3uNOvY5jNH1bKxE=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:48', '', NULL, '2026-06-20 16:08:29'), (11, 'Sunucu11', '80.89.224.252', 22, 'root', 'b9fnPiJc1FxhkvM4WwsxcWQXV9FVIJh01O0rpSDucz8=', 'b9fnPiJc1FxhkvM4WwsxcWQXV9FVIJh01O0rpSDucz8=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:59', '', NULL, '2026-06-20 16:08:29'), (12, 'Sunucu12', '80.89.224.47', 22, 'root', 'b09lQ/wZ4CDjpO+nKymZEJcc/BKLKwmP6buOFrvbzos=', 'b09lQ/wZ4CDjpO+nKymZEJcc/BKLKwmP6buOFrvbzos=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:48', '', NULL, '2026-06-20 16:08:29'), (13, 'Sunucu13', '212.43.156.32', 22, 'root', 'VNS/ekMUoPSLsWx6/94Sn4CBN9sXVFBrDAceNvlxOtM=', 'VNS/ekMUoPSLsWx6/94Sn4CBN9sXVFBrDAceNvlxOtM=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:47', '', NULL, '2026-06-20 16:08:29'), (14, 'Sunucu14', '212.43.156.65', 22, 'root', '3DgHYvqZECunVr8wheko7tdtJt5cyN0tcIRITrQzgCY=', '3DgHYvqZECunVr8wheko7tdtJt5cyN0tcIRITrQzgCY=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:47', '', NULL, '2026-06-20 16:08:29'), (15, 'Sunucu15', '212.43.156.103', 22, 'root', '0mdNlOvgMm+CgRT6ZZSMGh2HuWfwwRtJ3Cl2+t+TOV4=', '0mdNlOvgMm+CgRT6ZZSMGh2HuWfwwRtJ3Cl2+t+TOV4=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:47', '', NULL, '2026-06-20 16:08:29'), (16, 'Sunucu16', '212.43.159.232', 22, 'root', '7E4PpC8c7R148D//Zm3M08YgfA4SAvt66XZq1TKubyU=', '7E4PpC8c7R148D//Zm3M08YgfA4SAvt66XZq1TKubyU=', '', 'almalinux9', 'online', 1, 1, '2026-06-20 16:20:47', '', NULL, '2026-06-20 16:08:29'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `settings` -- CREATE TABLE `settings` ( `key` varchar(120) NOT NULL, `value` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Tablo döküm verisi `settings` -- INSERT INTO `settings` (`key`, `value`) VALUES ('ai_anthropic_key', ''), ('ai_google_key', ''), ('ai_openai_key', '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'), ('default_vitrin_url', 'https://beykoz1.store/'), ('prompt_article', 'il ile ilgili Escort anahtar kelimelerini içeren sıradışı bir makale yazar mısın bana? ilçe fethiye ise anahtar kelimelere muğla yı da ekle.... yani hem Hem Fethiye Escort Hemde Muğla Escort bu bir örnekti Senden sohbet boyunca hep makale isteyeceğim ve her istediğime aynı anahtar kelimeler olabilir veya farklı olabilir... Makalenin konusu anahtar kelimeler ile ilgili olmak zorunda değil... Bağlam tamamen farklı olabilir. Her seferinde farklı iskelet yapısında bir makale yaz... Örneğin bir makale de anahtar kelimelerin yeri farklıyken diğerinde farklı olsun... Ayrıca tarz ve stil olarak ta her makale farklı olsun... Sana kaç anahtar kelime verdiysem o anahtar kelimeden rastgele 1 veya 2 tane oluşturulsun her bir anahtar kelime için sistem aynı anahtar kelimeyi kaç kere geçireceğine karar versin anahtar kelimeler bold olmalı.. Bir makalenin yazı düzeni paragraf başlık düzeni görüntü olarak farklıyken diğeri farklı olsun.... Makale çok uzun olmasına gerek yok kısa makale yeterlidir.'), ('prompt_meta', 'Eskort siteleri için slogan tarzı google meta açıklamaları yazar mısın il adına göre örneğin ilçe fethiye ise hem fethiye escort hemde muğla escort içermeli'), ('prompt_title', 'kanka ben escort sitesi işletiyorum ama sürekli her gün site açıyorum ve tittle bulmakta zorlanıyorum sana örnek tittle vereceğim ve ardından şehir isimleri vereceğim sana örnek verdiğim tittle lere göre deişik yapılarda değişik varyasyonlarda tittle ver\r\n\r\nörnek tittle larım bunlar\r\n\r\nEskişehir Escort : Eskişehir Escort Bayan Sitesi | Eve ve Otele Gelen Eskişehir Escort Bayanlar\r\n\r\nEskişehir Escort | Eskişehir\'in Bebekleri - Vip Model Escort Bayanlar Eskişehir Escortlar\r\n\r\nEskişehir Escort ❤️ Eskişehir\'de ❤️ Evlere ve Otellere Gelen Eskişehir Escort Bayanlar\r\n\r\nEskişehir Escort ❤️ 15 DK Adreste Eskişehir Escort ❤️ Memnuniyet Odaklı Görüşmeler\r\n\r\nEskişehir Escort ☀️ Eskişehir Vip Escort Bayanlar ☀️ Orjinal Resim Kullanan Eskişehir Escort Bayanlar\r\n\r\nÖrnek tittle lerimi gördün bu örnekte Eskişehir Escort bizim anahtar kelimemizdi...\r\n\r\nŞimdi aşağıda senden istediğim anahtar kelimeleri içeren Tittle lar üret\r\n\r\n3 Tane Eskişehir Escort\r\n3 Samsun Escort\r\n3 Manavgat Escort\r\n3 Trabzon Escort\r\n3 Bodrum Escort\r\n\r\n\r\nörnek tek tittle de birden fazla anahtar kelime istediğim zaman örneğin Bodrum Escort ve Muğla Escort ve Fethiye Esort tek tittle dediğim zaman bu Ve Kelimelerini eklemeyeceksin.. !!!!\r\n\r\nyani Tittle tipi şöyle olacak\r\n\r\nBodrum Escort | Muğla Escort - Bodrum Eve ve Otele Gelen Vip Bayanlar\r\nveya\r\nBodrum Escort : Eve ve Otele Gelen Fethiye Escort Bayanlar - Muğla Escort ile Vip Hizmet\r\nveya\r\nBodrum Escort ❤️ Muğla Escort Güzelleri ❤️Fethiye Vip Kızlar\r\nBodrum Escort ☀️ Muğla Escort Bayan Sitesi ☀️Fethiye Escort\'un Taş Hatunları\r\n\r\ngibi gibi benzer yapılarda olsun !!!!!!!!!!!! Anlaştık mı?\r\n\r\n\r\nYani il Bodrumsa Bodrum Escort ta içermeli tittle Muğla Escort da içermeli... \r\n\r\nFethiye ise Fethiye Escort ta içermei Muğla Escort ta aksi taktirde google hangi il olduğunu anlamıyor\r\nManavgat Escort içeriyorsa Side Escort ta içermeli Antalya Escortta'); -- -- Dökümü yapılmış tablolar için indeksler -- -- -- Tablo için indeksler `domains` -- ALTER TABLE `domains` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uq_domains_domain` (`domain`), ADD KEY `idx_domains_server_id` (`server_id`), ADD KEY `idx_domains_seo_status` (`seo_status`); -- -- Tablo için indeksler `hostnames_used` -- ALTER TABLE `hostnames_used` ADD PRIMARY KEY (`hostname`), ADD KEY `idx_hostnames_server_id` (`server_id`); -- -- Tablo için indeksler `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `idx_jobs_status` (`status`), ADD KEY `idx_jobs_target` (`target_type`,`target_id`); -- -- Tablo için indeksler `panel_logs` -- ALTER TABLE `panel_logs` ADD PRIMARY KEY (`id`), ADD KEY `idx_panel_logs_created` (`created_at`); -- -- Tablo için indeksler `servers` -- ALTER TABLE `servers` ADD PRIMARY KEY (`id`), ADD KEY `idx_servers_status` (`status`), ADD KEY `idx_servers_ready` (`is_ready`); -- -- Tablo için indeksler `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`key`); -- -- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri -- -- -- Tablo için AUTO_INCREMENT değeri `domains` -- ALTER TABLE `domains` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- Tablo için AUTO_INCREMENT değeri `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53; -- -- Tablo için AUTO_INCREMENT değeri `panel_logs` -- ALTER TABLE `panel_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- Tablo için AUTO_INCREMENT değeri `servers` -- ALTER TABLE `servers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- Dökümü yapılmış tablolar için kısıtlamalar -- -- -- Tablo kısıtlamaları `domains` -- ALTER TABLE `domains` ADD CONSTRAINT `fk_domains_server` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE SET NULL ON UPDATE 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 */;