-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mitade_dcbot`
--

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

--
-- Table structure for table `authorized_users`
--

CREATE TABLE `authorized_users` (
  `user_id` varchar(255) NOT NULL,
  `added_by` varchar(255) NOT NULL,
  `added_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authorized_users`
--

INSERT INTO `authorized_users` (`user_id`, `added_by`, `added_at`) VALUES
('1105543189483495515', '253925794865348608', '2025-11-29 11:01:06');

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

--
-- Table structure for table `badwords`
--

CREATE TABLE `badwords` (
  `id` int(11) NOT NULL,
  `word` varchar(255) NOT NULL,
  `added_by` varchar(255) NOT NULL,
  `added_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `badwords`
--

INSERT INTO `badwords` (`id`, `word`, `added_by`, `added_at`) VALUES
(1, 'orospu cocugu', '253925794865348608', '2025-11-29 11:09:49');

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

--
-- Table structure for table `command_stats`
--

CREATE TABLE `command_stats` (
  `command_name` varchar(255) NOT NULL,
  `usage_count` int(11) DEFAULT 0,
  `last_used` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `command_stats`
--

INSERT INTO `command_stats` (`command_name`, `usage_count`, `last_used`) VALUES
('temizle', 5, '2025-11-29 12:58:59'),
('ticketkapa', 1, '2025-11-29 13:00:20'),
('ticketkapat', 4, '2025-11-29 17:00:06'),
('ticketpanel', 1, '2025-11-29 12:54:25');

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

--
-- Table structure for table `discord_users_cache`
--

CREATE TABLE `discord_users_cache` (
  `user_id` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `discriminator` varchar(10) DEFAULT '0',
  `avatar` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) NOT NULL,
  `cached_at` datetime DEFAULT current_timestamp(),
  `last_used_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `discord_users_cache`
--

INSERT INTO `discord_users_cache` (`user_id`, `username`, `discriminator`, `avatar`, `display_name`, `cached_at`, `last_used_at`) VALUES
('1190344371325915329', 'aksugllerden', '0', 'da32bf25502a24af18a162d8fa8e6259', 'Aksu', '2025-11-29 17:37:58', '2025-11-29 18:37:58'),
('1432675944044302441', 'alperenaygorr', '0', 'c5130ede4849104b5bc3ec9bfc491999', 'Alperen', '2025-11-29 17:37:58', '2025-11-29 18:37:58'),
('253925794865348608', 'nicetrydev', '0', '9dfa2da6091a34827c82bf3e32a2ea6e', 'nt', '2025-11-29 17:37:58', '2025-11-29 18:37:58'),
('524280636194816021', 'omeralpaykadioglu', '0', 'f88857948422772aa241bea3fcb00857', 'Ömer Alpay', '2025-11-29 17:37:58', '2025-11-29 18:37:58');

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

--
-- Table structure for table `message_logs`
--

CREATE TABLE `message_logs` (
  `id` int(11) NOT NULL,
  `guild_id` varchar(255) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `message_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `action_type` enum('edit','delete') NOT NULL,
  `old_content` text DEFAULT NULL,
  `new_content` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_logs`
--

CREATE TABLE `role_logs` (
  `id` int(11) NOT NULL,
  `guild_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `role_id` varchar(255) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `action_type` enum('add','remove','update') NOT NULL,
  `moderator_id` varchar(255) DEFAULT NULL,
  `moderator_username` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `server_growth`
--

CREATE TABLE `server_growth` (
  `id` int(11) NOT NULL,
  `guild_id` varchar(255) NOT NULL,
  `member_count` int(11) NOT NULL,
  `recorded_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sovus`
--

CREATE TABLE `sovus` (
  `id` int(11) NOT NULL,
  `response` text NOT NULL,
  `added_by` varchar(255) NOT NULL,
  `added_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sovus`
--

INSERT INTO `sovus` (`id`, `response`, `added_by`, `added_at`) VALUES
(1, 'amınake', '524280636194816021', '2025-11-29 11:25:24'),
(2, 'senin ben ta amınakoyayım', '253925794865348608', '2025-11-29 11:27:12'),
(3, 'Amına fışpır çektiğim sal beni', '1432675944044302441', '2025-11-29 11:27:16'),
(4, 'mehmet, sizin oralarda ben de tam bilmiyorum burda bingöllü bir arkadaş var o da diyo, ilk önce sizin ordaki gençler eşeklerle aşk yaşıyomuş. doğru mu? manita falan yapamadıklarından dolayı eşeklere şeker falan veriyolarmış. ne bilim böyle ekmek parçası falan. öpüyolarmış sonra da onlarla aşk yaşıyolarmış. sana bir de delikanlı sorusu. sen delikanli adama benziyorsun. sen hiç eşek siktin mi mehmet? delikanlı gibi. delikanlıı, hiç kıvırtma şansın olmaz valla. yok, yalan söylüyorsun, sıfatın kızardı mehmet valla yalan söylüyorsun. eşeğe ne verdin de ırzına geçtin eşşeloşeğin. delikanlı gibi. onun kulağına ferdi tayfur dan şarkı mı söyledin, ibrahim tatlıses gibi uzun hava mı çektin, oturdun eşekle muhabbet mi ettin, he?', '524280636194816021', '2025-11-29 11:27:21'),
(5, 'ne var lan götoş', '1432675944044302441', '2025-11-29 11:27:31'),
(6, 'ananı götünden siker erol taş gibi, kiraz ağacından kamçı yapar döverim orospu çocuğu seni', '524280636194816021', '2025-11-29 11:28:34'),
(7, 'Senin pornonu çekerim bak', '1432675944044302441', '2025-11-29 11:33:30'),
(8, 'ne var lan amınakoduğum', '253925794865348608', '2025-11-29 11:37:07'),
(9, 'ne istiyon amk', '253925794865348608', '2025-11-29 11:37:15'),
(10, 'lan siktir git bi sal beni', '253925794865348608', '2025-11-29 11:37:20'),
(11, 'mitade mitade ne var amk oglu ne var', '253925794865348608', '2025-11-29 11:37:27'),
(12, 'sığır siki', '524280636194816021', '2025-11-29 11:42:05'),
(13, 'sik kırığı', '524280636194816021', '2025-11-29 11:42:11'),
(14, 'sikimser pezevenk', '524280636194816021', '2025-11-29 11:42:18'),
(15, 'göt lalesi ibne', '524280636194816021', '2025-11-29 11:42:29'),
(16, 'amınake', '524280636194816021', '2025-11-29 11:25:24'),
(17, 'senin ben ta amınakoyayım', '253925794865348608', '2025-11-29 11:27:12'),
(18, 'Amına fışpır çektiğim sal beni', '1432675944044302441', '2025-11-29 11:27:16'),
(19, 'mehmet, sizin oralarda ben de tam bilmiyorum burda bingöllü bir arkadaş var o da diyo, ilk önce sizin ordaki gençler eşeklerle aşk yaşıyomuş. doğru mu? manita falan yapamadıklarından dolayı eşeklere şeker falan veriyolarmış. ne bilim böyle ekmek parçası falan. öpüyolarmış sonra da onlarla aşk yaşıyolarmış. sana bir de delikanlı sorusu. sen delikanli adama benziyorsun. sen hiç eşek siktin mi mehmet? delikanlı gibi. delikanlıı, hiç kıvırtma şansın olmaz valla. yok, yalan söylüyorsun, sıfatın kızardı mehmet valla yalan söylüyorsun. eşeğe ne verdin de ırzına geçtin eşşeloşeğin. delikanlı gibi. onun kulağına ferdi tayfur dan şarkı mı söyledin, ibrahim tatlıses gibi uzun hava mı çektin, oturdun eşekle muhabbet mi ettin, he?', '524280636194816021', '2025-11-29 11:27:21'),
(20, 'ne var lan götoş', '1432675944044302441', '2025-11-29 11:27:31'),
(21, 'ananı götünden siker erol taş gibi, kiraz ağacından kamçı yapar döverim orospu çocuğu seni', '524280636194816021', '2025-11-29 11:28:34'),
(22, 'Senin pornonu çekerim bak', '1432675944044302441', '2025-11-29 11:33:30'),
(23, 'ne var lan amınakoduğum', '253925794865348608', '2025-11-29 11:37:07'),
(24, 'ne istiyon amk', '253925794865348608', '2025-11-29 11:37:15'),
(25, 'lan siktir git bi sal beni', '253925794865348608', '2025-11-29 11:37:20'),
(26, 'mitade mitade ne var amk oglu ne var', '253925794865348608', '2025-11-29 11:37:27'),
(27, 'sığır siki', '524280636194816021', '2025-11-29 11:42:05'),
(28, 'sik kırığı', '524280636194816021', '2025-11-29 11:42:11'),
(29, 'sikimser pezevenk', '524280636194816021', '2025-11-29 11:42:18'),
(30, 'göt lalesi ibne', '524280636194816021', '2025-11-29 11:42:29'),
(31, 'amınake', '524280636194816021', '2025-11-29 11:25:24'),
(32, 'senin ben ta amınakoyayım', '253925794865348608', '2025-11-29 11:27:12'),
(33, 'Amına fışpır çektiğim sal beni', '1432675944044302441', '2025-11-29 11:27:16'),
(34, 'mehmet, sizin oralarda ben de tam bilmiyorum burda bingöllü bir arkadaş var o da diyo, ilk önce sizin ordaki gençler eşeklerle aşk yaşıyomuş. doğru mu? manita falan yapamadıklarından dolayı eşeklere şeker falan veriyolarmış. ne bilim böyle ekmek parçası falan. öpüyolarmış sonra da onlarla aşk yaşıyolarmış. sana bir de delikanlı sorusu. sen delikanli adama benziyorsun. sen hiç eşek siktin mi mehmet? delikanlı gibi. delikanlıı, hiç kıvırtma şansın olmaz valla. yok, yalan söylüyorsun, sıfatın kızardı mehmet valla yalan söylüyorsun. eşeğe ne verdin de ırzına geçtin eşşeloşeğin. delikanlı gibi. onun kulağına ferdi tayfur dan şarkı mı söyledin, ibrahim tatlıses gibi uzun hava mı çektin, oturdun eşekle muhabbet mi ettin, he?', '524280636194816021', '2025-11-29 11:27:21'),
(35, 'ne var lan götoş', '1432675944044302441', '2025-11-29 11:27:31'),
(36, 'ananı götünden siker erol taş gibi, kiraz ağacından kamçı yapar döverim orospu çocuğu seni', '524280636194816021', '2025-11-29 11:28:34'),
(37, 'Senin pornonu çekerim bak', '1432675944044302441', '2025-11-29 11:33:30'),
(38, 'ne var lan amınakoduğum', '253925794865348608', '2025-11-29 11:37:07'),
(39, 'ne istiyon amk', '253925794865348608', '2025-11-29 11:37:15'),
(40, 'lan siktir git bi sal beni', '253925794865348608', '2025-11-29 11:37:20'),
(41, 'mitade mitade ne var amk oglu ne var', '253925794865348608', '2025-11-29 11:37:27'),
(42, 'sığır siki', '524280636194816021', '2025-11-29 11:42:05'),
(43, 'sik kırığı', '524280636194816021', '2025-11-29 11:42:11'),
(44, 'sikimser pezevenk', '524280636194816021', '2025-11-29 11:42:18'),
(45, 'göt lalesi ibne', '524280636194816021', '2025-11-29 11:42:29'),
(46, 'amınake', '524280636194816021', '2025-11-29 11:25:24'),
(47, 'senin ben ta amınakoyayım', '253925794865348608', '2025-11-29 11:27:12'),
(48, 'Amına fışpır çektiğim sal beni', '1432675944044302441', '2025-11-29 11:27:16'),
(49, 'mehmet, sizin oralarda ben de tam bilmiyorum burda bingöllü bir arkadaş var o da diyo, ilk önce sizin ordaki gençler eşeklerle aşk yaşıyomuş. doğru mu? manita falan yapamadıklarından dolayı eşeklere şeker falan veriyolarmış. ne bilim böyle ekmek parçası falan. öpüyolarmış sonra da onlarla aşk yaşıyolarmış. sana bir de delikanlı sorusu. sen delikanli adama benziyorsun. sen hiç eşek siktin mi mehmet? delikanlı gibi. delikanlıı, hiç kıvırtma şansın olmaz valla. yok, yalan söylüyorsun, sıfatın kızardı mehmet valla yalan söylüyorsun. eşeğe ne verdin de ırzına geçtin eşşeloşeğin. delikanlı gibi. onun kulağına ferdi tayfur dan şarkı mı söyledin, ibrahim tatlıses gibi uzun hava mı çektin, oturdun eşekle muhabbet mi ettin, he?', '524280636194816021', '2025-11-29 11:27:21'),
(50, 'ne var lan götoş', '1432675944044302441', '2025-11-29 11:27:31'),
(51, 'ananı götünden siker erol taş gibi, kiraz ağacından kamçı yapar döverim orospu çocuğu seni', '524280636194816021', '2025-11-29 11:28:34'),
(52, 'Senin pornonu çekerim bak', '1432675944044302441', '2025-11-29 11:33:30'),
(53, 'ne var lan amınakoduğum', '253925794865348608', '2025-11-29 11:37:07'),
(54, 'ne istiyon amk', '253925794865348608', '2025-11-29 11:37:15'),
(55, 'lan siktir git bi sal beni', '253925794865348608', '2025-11-29 11:37:20'),
(56, 'mitade mitade ne var amk oglu ne var', '253925794865348608', '2025-11-29 11:37:27'),
(57, 'sığır siki', '524280636194816021', '2025-11-29 11:42:05'),
(58, 'sik kırığı', '524280636194816021', '2025-11-29 11:42:11'),
(59, 'sikimser pezevenk', '524280636194816021', '2025-11-29 11:42:18'),
(60, 'göt lalesi ibne', '524280636194816021', '2025-11-29 11:42:29');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `ticket_type` varchar(255) NOT NULL,
  `status` varchar(50) DEFAULT 'open',
  `created_at` datetime DEFAULT current_timestamp(),
  `closed_at` datetime DEFAULT NULL,
  `closed_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` (`id`, `ticket_id`, `user_id`, `channel_id`, `ticket_type`, `status`, `created_at`, `closed_at`, `closed_by`) VALUES
(1, 'TICKET-25392579-1764420870', '253925794865348608', '1444310559141920910', 'sales', 'closed', '2025-11-29 12:54:31', '2025-11-29 12:56:41', '1190344371325915329'),
(2, 'TICKET-52428063-1764420945', '524280636194816021', '1444310874700513401', 'sales', 'closed', '2025-11-29 12:55:46', '2025-11-29 12:58:34', '253925794865348608'),
(3, 'TICKET-25392579-1764421193', '253925794865348608', '1444311913004662835', 'sponsor', 'closed', '2025-11-29 12:59:53', '2025-11-29 13:00:38', '1190344371325915329'),
(13, 'TICKET-14326759-1764424745', '1432675944044302441', '1444326810169905164', 'sales', 'closed', '2025-11-29 16:59:05', '2025-11-29 16:59:27', '253925794865348608'),
(14, 'TICKET-11903443-1764424747', '1190344371325915329', '1444326817204011140', 'sales', 'closed', '2025-11-29 16:59:07', '2025-11-29 17:00:12', '253925794865348608');

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

--
-- Table structure for table `ticket_messages`
--

CREATE TABLE `ticket_messages` (
  `id` int(11) NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `message_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `discriminator` varchar(10) DEFAULT '0',
  `content` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `saved_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticket_messages`
--

INSERT INTO `ticket_messages` (`id`, `ticket_id`, `channel_id`, `message_id`, `user_id`, `username`, `avatar`, `discriminator`, `content`, `created_at`, `saved_at`) VALUES
(1, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326824560820234', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'sa', '2025-11-29 16:59:09', '2025-11-29 16:59:09'),
(2, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326826825486448', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'as', '2025-11-29 16:59:09', '2025-11-29 16:59:09'),
(3, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326828394283080', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', '1234', '2025-11-29 16:59:10', '2025-11-29 16:59:10'),
(4, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326833062678528', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', '456124', '2025-11-29 16:59:11', '2025-11-29 16:59:11'),
(5, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326833184178347', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'as', '2025-11-29 16:59:11', '2025-11-29 16:59:11'),
(6, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326838842294435', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', '123', '2025-11-29 16:59:12', '2025-11-29 16:59:12'),
(7, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326838808871053', '1190344371325915329', 'aksugllerden', 'da32bf25502a24af18a162d8fa8e6259', '0', 'as', '2025-11-29 16:59:12', '2025-11-29 16:59:12'),
(8, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326844219265035', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'Alperen', '2025-11-29 16:59:13', '2025-11-29 16:59:13'),
(9, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326848686194718', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'yazın bişiler', '2025-11-29 16:59:15', '2025-11-29 16:59:14'),
(10, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326868693159958', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'Aygör', '2025-11-29 16:59:19', '2025-11-29 16:59:19'),
(11, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326871901671575', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'tammadır', '2025-11-29 16:59:20', '2025-11-29 16:59:20'),
(12, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326873579524298', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'kafi', '2025-11-29 16:59:20', '2025-11-29 16:59:20'),
(13, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326880063782992', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', '!ticketkapat', '2025-11-29 16:59:22', '2025-11-29 16:59:22'),
(14, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326882886553661', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'bir dünya markasıdır', '2025-11-29 16:59:23', '2025-11-29 16:59:23'),
(20, 'TICKET-14326759-1764424745', '1444326810169905164', '1444326860598149295', '1190344371325915329', 'aksugllerden', 'da32bf25502a24af18a162d8fa8e6259', '0', '<@1444278322958700564>', '2025-11-29 16:59:17', '2025-11-29 16:59:27'),
(30, 'TICKET-11903443-1764424747', '1444326817204011140', '1444326992320135210', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', 'kapatmayın', '2025-11-29 16:59:49', '2025-11-29 16:59:49'),
(31, 'TICKET-11903443-1764424747', '1444326817204011140', '1444327065997410396', '253925794865348608', 'nicetrydev', '9dfa2da6091a34827c82bf3e32a2ea6e', '0', '!ticketkapat', '2025-11-29 17:00:06', '2025-11-29 17:00:06'),
(32, 'TICKET-11903443-1764424747', '1444326817204011140', '1444327076290105446', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'senin o amındaki kılları tek tek kopartarak sikerim sen kimsin lan', '2025-11-29 17:00:09', '2025-11-29 17:00:12'),
(34, 'TICKET-11903443-1764424747', '1444326817204011140', '1444327008476594216', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'ne diyon göt', '2025-11-29 16:59:53', '2025-11-29 17:00:12'),
(36, 'TICKET-11903443-1764424747', '1444326817204011140', '1444326981905813514', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'adam haklı birader', '2025-11-29 16:59:46', '2025-11-29 17:00:12'),
(37, 'TICKET-11903443-1764424747', '1444326817204011140', '1444326947298476283', '1432675944044302441', 'alperenaygorr', 'c5130ede4849104b5bc3ec9bfc491999', '0', 'SDKFLJDKSDİFSD', '2025-11-29 16:59:38', '2025-11-29 17:00:12'),
(38, 'TICKET-11903443-1764424747', '1444326817204011140', '1444326895498956800', '1190344371325915329', 'aksugllerden', 'da32bf25502a24af18a162d8fa8e6259', '0', '<@1444278322958700564>', '2025-11-29 16:59:26', '2025-11-29 17:00:12');

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

--
-- Table structure for table `user_stats`
--

CREATE TABLE `user_stats` (
  `user_id` varchar(255) NOT NULL,
  `message_count` int(11) DEFAULT 0,
  `last_active` datetime DEFAULT current_timestamp(),
  `joined_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_stats`
--

INSERT INTO `user_stats` (`user_id`, `message_count`, `last_active`, `joined_at`) VALUES
('1105543189483495515', 76, '2025-11-29 18:40:47', '2025-11-29 12:38:24'),
('1190344371325915329', 52, '2025-11-29 18:59:38', '2025-11-29 12:54:49'),
('1432675944044302441', 12, '2025-11-29 17:00:26', '2025-11-29 12:54:53'),
('253925794865348608', 164, '2025-11-29 18:59:42', '2025-11-29 12:38:20'),
('524280636194816021', 14, '2025-11-29 17:22:26', '2025-11-29 12:42:10');

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

--
-- Table structure for table `user_warns`
--

CREATE TABLE `user_warns` (
  `user_id` varchar(255) NOT NULL,
  `warn_count` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `voice_logs`
--

CREATE TABLE `voice_logs` (
  `id` int(11) NOT NULL,
  `guild_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `channel_name` varchar(255) NOT NULL,
  `action_type` enum('join','leave','move') NOT NULL,
  `old_channel_id` varchar(255) DEFAULT NULL,
  `old_channel_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `warns`
--

CREATE TABLE `warns` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `moderator_id` varchar(255) NOT NULL,
  `reason` text NOT NULL,
  `warn_count` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `webpanel_logs`
--

CREATE TABLE `webpanel_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `action` varchar(100) NOT NULL,
  `target_type` varchar(50) DEFAULT NULL,
  `target_id` varchar(255) DEFAULT NULL,
  `target_name` varchar(255) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `webpanel_users`
--

CREATE TABLE `webpanel_users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `role` varchar(50) DEFAULT 'user',
  `status` varchar(20) DEFAULT 'active',
  `created_at` datetime DEFAULT current_timestamp(),
  `last_login` datetime DEFAULT NULL,
  `last_login_ip` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `webpanel_users`
--

INSERT INTO `webpanel_users` (`id`, `username`, `password`, `email`, `full_name`, `role`, `status`, `created_at`, `last_login`, `last_login_ip`) VALUES
(1, 'admin', '$2y$10$5e2GbnrHiLOZ2OFr8EI1j.lbPadSStcZJBcdz7kWKhh1TrFCI2VmG', 'admin@example.com', 'Administrator', 'admin', 'active', '2025-11-29 16:55:52', '2025-11-29 18:14:20', '::1');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `authorized_users`
--
ALTER TABLE `authorized_users`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_added_at` (`added_at`);

--
-- Indexes for table `badwords`
--
ALTER TABLE `badwords`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `word` (`word`),
  ADD KEY `idx_word` (`word`);

--
-- Indexes for table `command_stats`
--
ALTER TABLE `command_stats`
  ADD PRIMARY KEY (`command_name`),
  ADD KEY `idx_usage_count` (`usage_count`);

--
-- Indexes for table `discord_users_cache`
--
ALTER TABLE `discord_users_cache`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_cached_at` (`cached_at`),
  ADD KEY `idx_last_used_at` (`last_used_at`);

--
-- Indexes for table `message_logs`
--
ALTER TABLE `message_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_guild_id` (`guild_id`),
  ADD KEY `idx_channel_id` (`channel_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_action_type` (`action_type`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `role_logs`
--
ALTER TABLE `role_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_guild_id` (`guild_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_role_id` (`role_id`),
  ADD KEY `idx_action_type` (`action_type`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `server_growth`
--
ALTER TABLE `server_growth`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_guild_id` (`guild_id`),
  ADD KEY `idx_recorded_at` (`recorded_at`);

--
-- Indexes for table `sovus`
--
ALTER TABLE `sovus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tickets`
--
ALTER TABLE `tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ticket_id` (`ticket_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_ticket_id` (`ticket_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `ticket_messages`
--
ALTER TABLE `ticket_messages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_message` (`ticket_id`,`message_id`),
  ADD KEY `idx_ticket_id` (`ticket_id`),
  ADD KEY `idx_channel_id` (`channel_id`),
  ADD KEY `idx_message_id` (`message_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `user_stats`
--
ALTER TABLE `user_stats`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_message_count` (`message_count`),
  ADD KEY `idx_last_active` (`last_active`);

--
-- Indexes for table `user_warns`
--
ALTER TABLE `user_warns`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_warn_count` (`warn_count`);

--
-- Indexes for table `voice_logs`
--
ALTER TABLE `voice_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_guild_id` (`guild_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_channel_id` (`channel_id`),
  ADD KEY `idx_action_type` (`action_type`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `warns`
--
ALTER TABLE `warns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_moderator_id` (`moderator_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `webpanel_logs`
--
ALTER TABLE `webpanel_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_action` (`action`),
  ADD KEY `idx_target_type` (`target_type`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `webpanel_users`
--
ALTER TABLE `webpanel_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD KEY `idx_username` (`username`),
  ADD KEY `idx_status` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `badwords`
--
ALTER TABLE `badwords`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `message_logs`
--
ALTER TABLE `message_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `role_logs`
--
ALTER TABLE `role_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `server_growth`
--
ALTER TABLE `server_growth`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sovus`
--
ALTER TABLE `sovus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT for table `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `ticket_messages`
--
ALTER TABLE `ticket_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `voice_logs`
--
ALTER TABLE `voice_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `warns`
--
ALTER TABLE `warns`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `webpanel_logs`
--
ALTER TABLE `webpanel_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `webpanel_users`
--
ALTER TABLE `webpanel_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

