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

START TRANSACTION;



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

--
-- Table structure for table `tbl_advertisement`
--

CREATE TABLE `tbl_advertisement` (
  `id` int(11) NOT NULL,
  `ad_status` varchar(10) NOT NULL DEFAULT 'false',
  `ad_network` varchar(30) NOT NULL DEFAULT 'admob',
  `admob_publisher_id` text NOT NULL,
  `admob_banner_unit_id` text NOT NULL,
  `admob_interstitial_unit_id` text NOT NULL,
  `admob_native_unit_id` text NOT NULL,
  `admob_app_open_ad_unit_id` text NOT NULL,
  `admob_reward_ad_unit_id` text NOT NULL,
  `banner_movie` varchar(10) NOT NULL DEFAULT 'false',
  `banner_series` varchar(10) NOT NULL DEFAULT 'false',
  `banner_epg` varchar(10) NOT NULL DEFAULT 'false',
  `interstitial_post_list` varchar(10) NOT NULL DEFAULT 'false',
  `reward_ad_on_movie` varchar(10) NOT NULL DEFAULT 'false',
  `reward_ad_on_episodes` varchar(10) NOT NULL DEFAULT 'false',
  `reward_ad_on_live` varchar(10) NOT NULL DEFAULT 'false',
  `reward_ad_on_single` varchar(10) NOT NULL DEFAULT 'false',
  `reward_ad_on_local` varchar(10) NOT NULL DEFAULT 'false',
  `interstital_ad_click` int(10) NOT NULL DEFAULT 5,
  `reward_minutes` int(10) NOT NULL DEFAULT 5
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_advertisement`
--

INSERT INTO `tbl_advertisement` (`id`, `ad_status`, `ad_network`, `admob_publisher_id`, `admob_banner_unit_id`, `admob_interstitial_unit_id`, `admob_native_unit_id`, `admob_app_open_ad_unit_id`, `admob_reward_ad_unit_id`, `banner_movie`, `banner_series`, `banner_epg`, `interstitial_post_list`, `reward_ad_on_movie`, `reward_ad_on_episodes`, `reward_ad_on_live`, `reward_ad_on_single`, `reward_ad_on_local`, `interstital_ad_click`, `reward_minutes`) VALUES
(1, 'true', 'admob', 'ca-app-pub-3940256099942544', 'ca-app-pub-3940256099942544/6300978111', 'ca-app-pub-3940256099942544/1033173712', '', '', 'ca-app-pub-3940256099942544/5224354917', 'true', 'true', 'true', 'true', 'true', 'true', 'true', 'true', 'true', 10, 10);

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

--
-- Table structure for table `tbl_custom_ads`
--

CREATE TABLE `tbl_custom_ads` (
  `id` int(11) NOT NULL,
  `ads_type` varchar(255) NOT NULL,
  `ads_title` varchar(255) NOT NULL,
  `ads_image` varchar(255) NOT NULL,
  `ads_redirect_type` varchar(255) NOT NULL,
  `ads_redirect_url` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_notification`
--

CREATE TABLE `tbl_notification` (
  `id` int(11) NOT NULL,
  `notification_title` varchar(255) NOT NULL,
  `notification_msg` text NOT NULL,
  `notification_description` text NOT NULL,
  `notification_on` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `tbl_policy_deletion`
--

CREATE TABLE `tbl_policy_deletion` (
  `id` int(11) NOT NULL,
  `policy_type` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `report_msg` text NOT NULL,
  `deletion_on` varchar(200) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `tbl_poster_gallery`
--

CREATE TABLE `tbl_poster_gallery` (
  `id` int(11) NOT NULL,
  `poster_type` varchar(255) NOT NULL,
  `poster_image` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_poster_gallery`
--

INSERT INTO `tbl_poster_gallery` (`id`, `poster_type`, `poster_image`, `status`) VALUES
(1, 'movie_ui', '89005_poster.jpg', 1),
(2, 'movie_ui', '68145_poster.jpg', 1),
(3, 'movie_ui', '11996_poster.jpg', 1),
(12, 'sports_ui', '85896_poster.jpg', 1),
(13, 'ramadan_ui', '89919_poster.jpg', 1);

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

--
-- Table structure for table `tbl_stream_dns`
--

CREATE TABLE `tbl_stream_dns` (
  `id` int(11) NOT NULL,
  `dns_title` varchar(255) NOT NULL,
  `dns_base` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_stream_dns`
--

INSERT INTO `tbl_stream_dns` (`id`, `dns_title`, `dns_base`, `status`) VALUES
(1, 'Server 1', 'https://s2e.online', 1);

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

--
-- Table structure for table `tbl_token_code`
--

CREATE TABLE `tbl_token_code` (
  `id` int(10) NOT NULL,
  `token_name` varchar(60) NOT NULL,
  `token_code` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `tbl_xui_dns`
--

CREATE TABLE `tbl_xui_dns` (
  `id` int(11) NOT NULL,
  `dns_title` varchar(255) NOT NULL,
  `dns_base` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_xui_dns`
--

INSERT INTO `tbl_xui_dns` (`id`, `dns_title`, `dns_base`, `status`) VALUES
(11, 'Server 2', 'https://s2e.online', 1),
(12, 'Server 3', 'https://s2e.online', 1);

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

--
-- Table structure for table `tbl_xui_dns_block`
--

CREATE TABLE `tbl_xui_dns_block` (
  `id` int(11) NOT NULL,
  `dns_base` text NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `tbl_xui_dns_block`
--

INSERT INTO `tbl_xui_dns_block` (`id`, `dns_base`, `status`) VALUES
(1, 'example.com', 1);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_token_code`
--
ALTER TABLE `tbl_token_code`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

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

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

