-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Nov 10, 2025 at 06:34 AM
-- Server version: 11.8.3-MariaDB-log
-- PHP Version: 7.2.34

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 */;

--
-- Database: `u988479389_autn`
--

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

--
-- Table structure for table `bot_settings`
--

CREATE TABLE `bot_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `updated_date` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `bot_settings`
--

INSERT INTO `bot_settings` (`id`, `setting_key`, `setting_value`, `updated_date`) VALUES
(1, 'header_text', '', '2025-11-09 23:57:09'),
(2, 'footer_text', '', '2025-11-09 23:57:09'),
(3, 'bot_status', 'active', '2025-11-10 00:03:38'),
(4, 'auto_forward', '1', '2025-11-09 23:57:09');

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

--
-- Table structure for table `link_replacements`
--

CREATE TABLE `link_replacements` (
  `id` int(11) NOT NULL,
  `find_link` varchar(500) NOT NULL,
  `replace_link` varchar(500) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `link_replacements`
--

INSERT INTO `link_replacements` (`id`, `find_link`, `replace_link`, `is_active`, `created_date`) VALUES
(1, 'https://t.me/+quUWMpcopEg5NGVk', 'https://t.me/+WeimFgT77j05ZDJk', 1, '2025-11-10 00:18:54');

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

--
-- Table structure for table `post_logs`
--

CREATE TABLE `post_logs` (
  `id` int(11) NOT NULL,
  `source_channel` varchar(255) DEFAULT NULL,
  `target_channel` varchar(255) DEFAULT NULL,
  `original_message` text DEFAULT NULL,
  `modified_message` text DEFAULT NULL,
  `post_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

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

--
-- Table structure for table `source_channels`
--

CREATE TABLE `source_channels` (
  `id` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `channel_name` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `added_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `source_channels`
--

INSERT INTO `source_channels` (`id`, `channel_id`, `channel_name`, `status`, `added_date`) VALUES
(1, '-1002875995813', NULL, 'active', '2025-11-10 00:18:05');

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

--
-- Table structure for table `target_channel`
--

CREATE TABLE `target_channel` (
  `id` int(11) NOT NULL,
  `channel_id` varchar(255) NOT NULL,
  `channel_name` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `updated_date` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `target_channel`
--

INSERT INTO `target_channel` (`id`, `channel_id`, `channel_name`, `is_active`, `updated_date`) VALUES
(1, '-1002511758738', NULL, 1, '2025-11-10 00:17:18');

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

--
-- Table structure for table `text_replacements`
--

CREATE TABLE `text_replacements` (
  `id` int(11) NOT NULL,
  `find_text` text NOT NULL,
  `replace_text` text NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `text_replacements`
--

INSERT INTO `text_replacements` (`id`, `find_text`, `replace_text`, `is_active`, `created_date`) VALUES
(1, 'Fagun', 'Gagun', 1, '2025-11-10 00:19:29');

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

--
-- Table structure for table `userid_replacements`
--

CREATE TABLE `userid_replacements` (
  `id` int(11) NOT NULL,
  `find_userid` varchar(255) NOT NULL,
  `replace_userid` varchar(255) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `userid_replacements`
--

INSERT INTO `userid_replacements` (`id`, `find_userid`, `replace_userid`, `is_active`, `created_date`) VALUES
(1, '@golo', '@golu', 1, '2025-11-10 00:19:16');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bot_settings`
--
ALTER TABLE `bot_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

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

--
-- Indexes for table `source_channels`
--
ALTER TABLE `source_channels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `channel_id` (`channel_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `userid_replacements`
--
ALTER TABLE `userid_replacements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
