Create

--
-- Table structure for table `tbl_general_setting`
--

CREATE TABLE `tbl_general_setting` (
  `id` int(11) NOT NULL,
  `key` text NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_general_setting`
--

INSERT INTO `tbl_general_setting` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'DTTube', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(2, 'host_email', 'admin@admin.com', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(3, 'app_version', '1.1', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(4, 'author', 'Divintechs', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(5, 'email', 'admin@admin.com', '2023-04-21 05:09:12', '2023-08-26 06:11:38'),
(6, 'contact', '1234567890', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(7, 'app_desripation', 'DivineTechs, a top web & mobile app development company offering innovative solutions for diverse industry verticals. \r\nWe have creative and dedicated group of developers who are mastered in Apps Developments and Web Development with a nice in delivering quality solutions to customers across the globe.', '2023-04-21 05:09:12', '2024-01-11 10:36:55'),
(10, 'app_logo', '', '2023-04-21 05:09:12', '2024-07-01 06:47:40'),
(11, 'website', 'www.admin.com', '2023-04-21 05:09:12', '2023-08-26 06:11:33'),
(12, 'currency', 'USD', '2023-04-21 05:09:12', '2024-02-15 12:45:25'),
(13, 'currency_code', '$', '2023-04-21 05:09:12', '2024-02-15 12:45:25'),
(14, 'banner_ad', '0', '2023-04-21 05:09:12', '2024-02-15 12:26:06'),
(15, 'banner_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(16, 'interstital_ad', '0', '2023-04-21 05:09:12', '2024-02-15 12:26:06'),
(17, 'interstital_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(18, 'interstital_adclick', '', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(19, 'reward_ad', '0', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(20, 'reward_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(21, 'reward_adclick', '', '2023-04-21 05:09:12', '2023-08-26 06:14:39'),
(22, 'ios_banner_ad', '0', '2023-04-21 05:09:12', '2024-02-15 12:26:22'),
(23, 'ios_banner_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(24, 'ios_interstital_ad', '0', '2023-04-21 05:09:12', '2024-02-15 12:26:22'),
(25, 'ios_interstital_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(26, 'ios_interstital_adclick', '', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(27, 'ios_reward_ad', '0', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(28, 'ios_reward_adid', '', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(29, 'ios_reward_adclick', '', '2023-04-21 05:09:12', '2023-08-26 06:15:04'),
(30, 'fb_native_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:11'),
(31, 'fb_native_id', '', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(32, 'fb_banner_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:11'),
(33, 'fb_banner_id', '', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(34, 'fb_interstiatial_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:11'),
(35, 'fb_interstiatial_id', '', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(36, 'fb_rewardvideo_status', '0', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(37, 'fb_rewardvideo_id', '', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(38, 'fb_native_full_status', '0', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(39, 'fb_native_full_id', '', '2023-04-21 05:09:12', '2023-08-26 06:15:38'),
(40, 'fb_ios_native_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:25'),
(41, 'fb_ios_native_id', '', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(42, 'fb_ios_banner_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:25'),
(43, 'fb_ios_banner_id', '', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(44, 'fb_ios_interstiatial_status', '0', '2023-04-21 05:09:12', '2024-02-15 12:38:25'),
(45, 'fb_ios_interstiatial_id', '', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(46, 'fb_ios_rewardvideo_status', '0', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(47, 'fb_ios_rewardvideo_id', '', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(48, 'fb_ios_native_full_status', '0', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(49, 'fb_ios_native_full_id', '', '2023-04-21 05:09:12', '2023-08-26 06:16:07'),
(50, 'onesignal_apid', '', '2023-04-21 05:09:12', '2023-12-07 08:52:18'),
(51, 'onesignal_rest_key', '', '2023-04-21 05:09:12', '2023-12-07 08:52:18'),
(52, 'live_appid', '', '2023-10-17 10:35:28', '2023-10-17 10:40:15'),
(53, 'live_appsign', '', '2023-10-17 10:35:28', '2023-10-17 10:40:15'),
(54, 'live_serversecret', '', '2023-10-17 10:35:32', '2023-10-17 10:40:15'),
(55, 'rent_commission', '0', '2023-12-11 12:40:31', '2024-07-01 06:47:30'),
(56, 'banner_ads_status', '0', '2024-01-25 10:00:52', '2024-02-15 11:13:24'),
(57, 'banner_ads_cpv', '0', '2024-01-25 10:01:36', '2024-07-01 06:47:16'),
(58, 'banner_ads_cpc', '0', '2024-01-25 10:01:36', '2024-07-01 06:47:19'),
(59, 'interstital_ads_status', '0', '2024-01-25 10:02:06', '2024-02-15 11:13:34'),
(60, 'interstital_ads_cpv', '0', '2024-01-25 10:58:59', '2024-07-01 06:47:21'),
(61, 'interstital_ads_cpc', '0', '2024-01-25 10:58:59', '2024-07-01 06:47:22'),
(62, 'reward_ads_status', '0', '2024-01-25 10:59:58', '2024-02-15 11:13:35'),
(63, 'reward_ads_cpv', '0', '2024-01-25 10:59:58', '2024-07-01 06:47:23'),
(64, 'reward_ads_cpc', '0', '2024-01-25 11:00:04', '2024-07-01 06:47:23'),
(65, 'ads_commission', '0', '2024-01-25 11:00:44', '2024-07-01 06:47:25'),
(66, 'min_withdrawal_amount', '0', '2024-01-31 06:01:40', '2024-07-01 06:47:35'),
(67, 'vap_id_key', '', '2024-07-09 10:02:38', '2024-07-09 10:02:38'),
(68, 'after_day_delete_reels', '0', '2024-07-13 04:08:38', '2024-07-13 04:08:38');

Create Ads

--
-- Table structure for table `tbl_ads`
--
Create Ad
CREATE TABLE `tbl_ads` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT '1- Banner Ads, 2- Interstital Ads, 3- Reward Ads',
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL COMMENT '\r\n',
  `video` varchar(255) NOT NULL,
  `redirect_uri` text NOT NULL,
  `budget` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1 COMMENT '0- Inactive, 1- Active',
  `is_hide` int(11) NOT NULL DEFAULT 0 COMMENT '0- No, 1- Yes',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

---

--
-- Table structure for table `tbl_ads_package`
--

CREATE TABLE `tbl_ads_package` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `coin` int(11) NOT NULL,
  `android_product_package` varchar(255) NOT NULL,
  `ios_product_package` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

---

--
-- Table structure for table `tbl_ads_transaction`
--

CREATE TABLE `tbl_ads_transaction` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  `coin` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

---

--
-- Table structure for table `tbl_ads_view_click_count`
--

CREATE TABLE `tbl_ads_view_click_count` (
  `id` int(11) NOT NULL,
  `ads_type` int(11) NOT NULL COMMENT '1- Banner Ads, 2- Interstital Ads, 3- Reward Ads',
  `ads_id` int(11) NOT NULL,
  `device_type` int(11) NOT NULL DEFAULT 0 COMMENT '1- Android, 2- IOS, 3- Web',
  `device_token` varchar(255) NOT NULL,
  `content_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 0 COMMENT '1- CPV, 2- CPC',
  `total_coin` int(11) NOT NULL DEFAULT 0,
  `admin_commission` int(11) NOT NULL DEFAULT 0,
  `user_wallet_earning` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Create Hashgat

--
-- Table structure for table `tbl_hashtag`
--

CREATE TABLE `tbl_hashtag` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_used` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;