DROP TABLE `tbl_settings`;

CREATE TABLE `tbl_settings` (
  `id` int(11) NOT NULL,
  `app_name` varchar(100) NOT NULL,
  `app_logo` varchar(200) NOT NULL,
  `app_email` varchar(100) NOT NULL,
  `app_author` varchar(100) NOT NULL,
  `app_contact` varchar(100) NOT NULL,
  `app_website` varchar(150) NOT NULL,
  `app_description` text NOT NULL,
  `app_developed_by` varchar(150) NOT NULL,
  `app_privacy_policy` text NOT NULL,
  `app_terms` text NOT NULL,
  `account_delete_intruction` text NOT NULL,
  `envato_buyer_name` varchar(100) NOT NULL,
  `envato_purchase_code` text NOT NULL,
  `envato_package_name` varchar(150) NOT NULL,
  `envato_api_key` text NOT NULL,
  `onesignal_app_id` text NOT NULL,
  `onesignal_rest_key` text NOT NULL,
  `is_rtl` varchar(10) NOT NULL DEFAULT 'false',
  `is_maintenance` varchar(10) NOT NULL DEFAULT 'false',
  `is_screenshot` varchar(10) NOT NULL DEFAULT 'false',
  `is_apk` varchar(10) NOT NULL DEFAULT 'false',
  `is_vpn` varchar(10) NOT NULL DEFAULT 'false',
  `is_xui_dns` varchar(10) NOT NULL DEFAULT 'false',
  `app_update_status` varchar(10) NOT NULL DEFAULT 'false',
  `app_new_version` double NOT NULL DEFAULT 1,
  `app_update_desc` text NOT NULL,
  `app_redirect_url` text NOT NULL,
  `custom_ads` varchar(10) NOT NULL DEFAULT 'false',
  `custom_ads_clicks` int(10) NOT NULL DEFAULT 12,
  `is_theme` varchar(255) NOT NULL,
  `is_dowload` varchar(255) NOT NULL DEFAULT 'true',
  `is_xui_radio` varchar(255) NOT NULL,
  `ad_network` varchar(30) NOT NULL DEFAULT 'admob',
  `publisher_id` text NOT NULL,
  `banner_ad` varchar(10) NOT NULL DEFAULT 'true',
  `banner_ad_id` text NOT NULL,
  `interstital_ad` varchar(10) NOT NULL DEFAULT 'true',
  `interstital_ad_id` text NOT NULL,
  `interstital_ad_click` int(10) NOT NULL DEFAULT 5,
  `ads_limits` varchar(10) NOT NULL DEFAULT 'true',
  `ads_count_click` int(10) NOT NULL DEFAULT 20,
  `is_select_xui` varchar(255) NOT NULL DEFAULT 'true',
  `is_select_stream` varchar(255) NOT NULL DEFAULT 'true',
  `is_select_playlist` varchar(255) NOT NULL DEFAULT 'true',
  `is_select_device_id` varchar(255) NOT NULL DEFAULT 'true',
  `is_select_single` varchar(255) NOT NULL DEFAULT 'true',
  `is_stream_dns` varchar(255) NOT NULL DEFAULT 'false',
  `is_stream_radio` varchar(255) NOT NULL DEFAULT 'false',
  `is_epg` varchar(255) NOT NULL,
  `is_local_storage` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `tbl_settings` (`id`, `app_name`, `app_logo`, `app_email`, `app_author`, `app_contact`, `app_website`, `app_description`, `app_developed_by`, `app_privacy_policy`, `app_terms`, `account_delete_intruction`, `envato_buyer_name`, `envato_purchase_code`, `envato_package_name`, `envato_api_key`, `onesignal_app_id`, `onesignal_rest_key`, `is_rtl`, `is_maintenance`, `is_screenshot`, `is_apk`, `is_vpn`, `is_xui_dns`, `app_update_status`, `app_new_version`, `app_update_desc`, `app_redirect_url`, `custom_ads`, `custom_ads_clicks`, `is_theme`, `is_dowload`, `is_xui_radio`, `ad_network`, `publisher_id`, `banner_ad`, `banner_ad_id`, `interstital_ad`, `interstital_ad_id`, `interstital_ad_click`, `ads_limits`, `ads_count_click`, `is_select_xui`, `is_select_stream`, `is_select_playlist`, `is_select_device_id`, `is_select_single`, `is_stream_dns`, `is_stream_radio`, `is_epg`, `is_local_storage`) VALUES
(1, 'StreamBox - Mobile', '44195_logo.png', 'info.nemosofts@gmail.com', 'nemosofts', '0356525684', 'nemosofts.com', 'Love this app? Let us Know in the Google Play Store how we can make it even better', 'thivakaran', '', '', 'eyJhbGciOiJIUzI1NiJ9.eyJhdWQiOiI2MmM1NWYzZGNiNjU0ZDUyNTY2ZjlhMTY3OTY0MzVkMiIsInN1YiI6IjY0Y2YwM2M1NGQ2NzkxMDEzOWVlNDEwMSIsInNjb3BlcyI6WyJhcGlfcmVhZCJdLCJ2ZXJzaW9uIjoxfQ.tRk2Qtia7FqPqri5zObYqHWGElhBRiHPi8rSSqnntJQ', '', '', '', '', '', '', 'false', 'false', 'false', 'false', 'false', 'true', 'false', 1, '', 'https://play.google.com/store/apps/details', 'false', 15, '1', 'true', 'false', 'admob', 'ca-app-pub-3940256099942544~3347511713', 'false', 'ca-app-pub-3940256099942544/6300978111', 'false', 'ca-app-pub-3940256099942544/1033173712', 20, 'true', 20, 'true', 'true', 'true', 'true', 'true', 'true', 'false', '2', 'true');

ALTER TABLE `tbl_settings`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tbl_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;