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

START TRANSACTION;



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

--
-- Table structure for table `db_amount`
--

CREATE TABLE `db_amount` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `py_amout` text DEFAULT NULL,
  `py_rcoin` text DEFAULT NULL,
  `amount_id` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_amount`
--

INSERT INTO `db_amount` (`id`, `py_amout`, `py_rcoin`, `amount_id`, `created_at`, `updated_at`) VALUES
(1, '1', '1000', '1', '2025-11-04 06:18:34', '2025-11-04 06:18:34'),
(2, '2', '2000', '1', '2025-11-04 06:18:40', '2025-11-04 06:18:40'),
(3, '3', '3000', '1', '2025-11-04 06:18:46', '2025-11-04 06:18:46'),
(4, '1', '1000', '2', '2025-11-04 06:19:39', '2025-11-04 06:19:39'),
(5, '2', '2000', '2', '2025-11-04 06:19:45', '2025-11-04 06:19:45'),
(7, '1', '1000', '3', '2025-11-04 06:20:34', '2025-11-04 06:20:34'),
(8, '2', '2000', '3', '2025-11-04 06:20:40', '2025-11-04 06:20:40'),
(9, '1', '1000', '4', '2025-11-04 06:21:26', '2025-11-04 06:21:26'),
(10, '2', '2000', '4', '2025-11-04 06:21:31', '2025-11-04 06:21:31'),
(11, '3', '3000', '4', '2025-11-04 06:21:36', '2025-11-04 06:21:36'),
(12, '1', '1000', '7', '2025-11-04 06:23:33', '2025-11-04 06:23:33'),
(13, '2', '2000', '7', '2025-11-04 06:23:45', '2025-11-04 06:23:45'),
(14, '3', '3000', '7', '2025-11-04 06:23:49', '2025-11-04 06:23:49'),
(15, '1', '1000', '6', '2025-11-04 06:24:01', '2025-11-04 06:24:01'),
(16, '2', '2000', '6', '2025-11-04 06:24:05', '2025-11-04 06:24:05'),
(17, '3', '3000', '6', '2025-11-04 06:24:09', '2025-11-04 06:24:09'),
(18, '1', '1000', '5', '2025-11-04 06:24:21', '2025-11-04 06:24:21'),
(19, '2', '2000', '5', '2025-11-04 06:24:26', '2025-11-04 06:24:26'),
(20, '3', '3000', '5', '2025-11-04 06:24:30', '2025-11-04 06:24:30');

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

--
-- Table structure for table `db_daily`
--

CREATE TABLE `db_daily` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `u_id` text DEFAULT NULL,
  `day1` text DEFAULT NULL,
  `day2` text DEFAULT NULL,
  `day3` text DEFAULT NULL,
  `day4` text DEFAULT NULL,
  `day5` text DEFAULT NULL,
  `day6` text DEFAULT NULL,
  `day7` text DEFAULT NULL,
  `status` varchar(250) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_daily`
--

INSERT INTO `db_daily` (`id`, `u_id`, `day1`, `day2`, `day3`, `day4`, `day5`, `day6`, `day7`, `status`, `created_at`, `updated_at`) VALUES
(1, '00syUOYPmOHRf0ApgVnkpPPSrU5vUCRni78Zas3EBBkMEDHgTM0svLxviHpwC24EH7WNGRgG9LZyypuSTFP2AG4Yw2vxukKbu3im', '2025-11-04', '2025-11-05', '2025-11-06', '2025-11-07', '2025-11-08', '2025-11-09', '2025-11-10', '1', '2025-11-04 05:05:54', '2025-11-04 05:10:50'),
(2, 'B5yeXr5eerqaLUIHVLrHzCvhtORmNj5zRwiJdcyKGiMuAE0NDBwGaxcwsPc0EfgS0y4VmkKJ8fROmGiC3y3n8c1eHPUDlx7B3QnJ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '2025-11-04 05:11:22', '2025-11-04 05:11:22'),
(3, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', '2025-11-04', '2025-11-05', '2025-11-06', '2025-11-07', '2025-11-08', '2025-11-09', '2025-11-10', '1', '2025-11-04 05:12:27', '2025-11-04 05:14:00');

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

--
-- Table structure for table `db_notification`
--

CREATE TABLE `db_notification` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `img` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `full_text` text DEFAULT NULL,
  `url` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_payment`
--

CREATE TABLE `db_payment` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `py_title` text DEFAULT NULL,
  `py_logo` text DEFAULT NULL,
  `py_amout` text DEFAULT NULL,
  `py_rcoin` text DEFAULT NULL,
  `py_inouthint` text DEFAULT NULL,
  `py_inputhint2` text DEFAULT NULL,
  `py_currency` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_payment`
--

INSERT INTO `db_payment` (`id`, `py_title`, `py_logo`, `py_amout`, `py_rcoin`, `py_inouthint`, `py_inputhint2`, `py_currency`, `created_at`, `updated_at`) VALUES
(2, 'Binance', '1762238969_6909a1f9899b5.png', NULL, NULL, 'type your name', 'type your email', '$', '2025-11-04 06:19:29', '2025-11-04 06:19:29'),
(5, 'Flipkart Gift', '1762239157_6909a2b538fc9.png', NULL, NULL, 'type your name', 'type your email', '$', '2025-11-04 06:22:37', '2025-11-04 06:22:37'),
(6, 'Google gift card', '1762239183_6909a2cfe120b.webp', NULL, NULL, 'type your name', 'type your email', '$', '2025-11-04 06:23:03', '2025-11-04 06:23:03'),
(7, 'Amazon gift card', '1762239207_6909a2e78ffe4.png', NULL, NULL, 'type your name', 'type your email', '$', '2025-11-04 06:23:27', '2025-11-04 06:23:27');

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

--
-- Table structure for table `db_refer`
--

CREATE TABLE `db_refer` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `u_id` text DEFAULT NULL,
  `r_uid` text DEFAULT NULL,
  `level` text DEFAULT NULL,
  `point` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_settings`
--

CREATE TABLE `db_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `app_config` text DEFAULT NULL,
  `game_config` text DEFAULT NULL,
  `refer_config` text DEFAULT NULL,
  `ad_unit` text DEFAULT NULL,
  `offer_survey` text DEFAULT NULL,
  `terms_title` text DEFAULT NULL,
  `terms_desc` text DEFAULT NULL,
  `privacy_title` text DEFAULT NULL,
  `privacy_desc` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_settings`
--

INSERT INTO `db_settings` (`id`, `app_config`, `game_config`, `refer_config`, `ad_unit`, `offer_survey`, `terms_title`, `terms_desc`, `privacy_title`, `privacy_desc`, `status`, `created_at`, `updated_at`) VALUES
(1, '{\"signup_bonus\":\"100\",\"support_email\":\"obuj90227@gmail.com\",\"onesignal_app_id\":\"d10d09e8-2331-4971-a0b6-cdfe1cbde2ca\",\"cap_greqpoint\":null,\"ai_apikey\":null}', '{\"game_winreward_min\":\"100\",\"game_winreward_max\":\"50\",\"fallback_1\":\"Admob\",\"fallback_2\":\"Admob\"}', '{\"level1_point\":\"100\",\"level2_point\":\"50\"}', '{\"admob_appid\":\"ds\",\"admob_bannerid\":\"ca-app-pub-3940256099942544\\/6300978111\",\"admob_intid\":\"ca-app-pub-3940256099942544\\/1033173712\",\"admob_rewardid\":\"ca-app-pub-3940256099942544\\/5224354917\",\"applovin_reward\":\"**************************\",\"fb_rewardid\":\"VID_HD_9_16_39S_APP_INSTALL#407103646956948_407112116956101\",\"vungle_appid\":\"**************************\",\"vungle_rewardid\":\"**************************\",\"inmobi_appid\":\"**************************\",\"inmobi_rewardid\":\"**************************\",\"facebook_test\":null,\"fb_bannerid\":\"**************************\"}', '{\"pubscale_appid\":\"94974737\",\"play_timeadsappid\":null,\"tapjoy_skdkey\":null,\"tapjoy_placementName\":null,\"bitlabs_token\":null,\"cpx_appid\":\"28644\",\"timewall_appid\":null,\"wanndsads_apikey\":null,\"monlix_appid\":\"2906\",\"offerwallmedia_apikey\":null}', NULL, NULL, 'Privacy Policy', '<p>zxds</p>', '0', NULL, '2025-11-04 06:33:58');

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

--
-- Table structure for table `db_task`
--

CREATE TABLE `db_task` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `task_id` text DEFAULT NULL,
  `user_id` text DEFAULT NULL,
  `task_type` text DEFAULT NULL,
  `type` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_tracking`
--

CREATE TABLE `db_tracking` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `u_id` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `reward` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_tracking`
--

INSERT INTO `db_tracking` (`id`, `u_id`, `name`, `title`, `reward`, `status`, `created_at`, `updated_at`) VALUES
(1, '00syUOYPmOHRf0ApgVnkpPPSrU5vUCRni78Zas3EBBkMEDHgTM0svLxviHpwC24EH7WNGRgG9LZyypuSTFP2AG4Yw2vxukKbu3im', NULL, 'Signup Bonus Reward', '100', '0', '2025-11-04 05:05:54', '2025-11-04 05:05:54'),
(2, 'B5yeXr5eerqaLUIHVLrHzCvhtORmNj5zRwiJdcyKGiMuAE0NDBwGaxcwsPc0EfgS0y4VmkKJ8fROmGiC3y3n8c1eHPUDlx7B3QnJ', NULL, 'Signup Bonus Reward', '100', '0', '2025-11-04 05:11:22', '2025-11-04 05:11:22'),
(3, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Signup Bonus Reward', '100', '0', '2025-11-04 05:12:27', '2025-11-04 05:12:27'),
(4, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '169', '0', '2025-11-04 05:36:57', '2025-11-04 05:36:57'),
(5, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '123', '0', '2025-11-04 05:44:49', '2025-11-04 05:44:49'),
(6, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '24', '0', '2025-11-04 05:45:42', '2025-11-04 05:45:42'),
(7, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '14', '0', '2025-11-04 05:46:21', '2025-11-04 05:46:21'),
(8, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '43', '0', '2025-11-04 05:47:37', '2025-11-04 05:47:37'),
(9, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', NULL, 'Game Win Reward', '135', '0', '2025-11-04 05:48:36', '2025-11-04 05:48:36');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2021_09_11_101603_create_admins_table', 1),
(6, '2021_09_28_150557_create_roles_table', 1),
(7, '2021_09_28_150603_create_permissions_table', 1),
(8, '2021_09_28_150804_create_users_permission_table', 1),
(9, '2021_09_28_150837_create_users_roles_table', 1),
(10, '2021_09_28_151026_create_roles_permissions_table', 1),
(11, '2021_10_12_151812_create_posts_table', 1),
(12, '2024_06_14_042314_create_tv_redeem_table', 1),
(13, '2024_06_14_042341_create_db_settings_table', 1),
(14, '2024_06_14_042355_create_db_tracking_table', 1),
(15, '2024_06_14_043605_create_redeem_request_table', 1),
(16, '2024_07_01_042708_create_auser_table', 1),
(17, '2025_01_18_213220_create_refer_mission_table', 1),
(18, '2025_01_20_174822_create_tv_work_table', 1),
(19, '2025_09_17_205711_create_db_refer', 1),
(20, '2025_09_17_210301_create_db_daily', 1),
(21, '2025_10_12_192056_create_db_banner', 1),
(22, '2025_10_14_182742_create_db_task', 1),
(23, '2025_10_18_215603_create_db_payment', 1),
(24, '2025_10_18_230141_create_py_request', 1),
(25, '2025_10_19_200247_create_db_notification', 1),
(26, '2025_10_27_101624_create_db_amount', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `py_request`
--

CREATE TABLE `py_request` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` text DEFAULT NULL,
  `op1` text DEFAULT NULL,
  `op2` text DEFAULT NULL,
  `py_title` text DEFAULT NULL,
  `py_rcoin` text DEFAULT NULL,
  `py_amout` text DEFAULT NULL,
  `py_currency` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `py_request`
--

INSERT INTO `py_request` (`id`, `uid`, `op1`, `op2`, `py_title`, `py_rcoin`, `py_amout`, `py_currency`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', 'rnxnc', 'mxmxx', 'Amazon gift card', '1000', '1', '$', 'Funny mekar', 1, '2025-11-04 06:26:12', '2025-11-04 06:26:12'),
(2, 'HWRce1Xpt6O8GXoZwsXAmfByERhKZVpFg9VivsQs3G9W6pIJQt3q6fSOCHsqAvxx8JOwDEnvTxqo8E7xocnXItWxgAr5xRQmAm77', 'hn', 'nn', 'Amazon gift card', '3000', '3', '$', 'Funny mekar', 1, '2025-11-04 06:31:25', '2025-11-04 06:31:25');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles_permissions`
--

CREATE TABLE `roles_permissions` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tv_redeem`
--

CREATE TABLE `tv_redeem` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `redeen_title` varchar(255) DEFAULT NULL,
  `redeem_img` text DEFAULT NULL,
  `redeem_coin` varchar(255) DEFAULT NULL,
  `redeem_amount` varchar(255) DEFAULT NULL,
  `redeem_hint1` varchar(255) DEFAULT NULL,
  `redeem_hint2` varchar(255) DEFAULT NULL,
  `redeem_hint3` varchar(255) DEFAULT NULL,
  `redeem_currency` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tv_work`
--

CREATE TABLE `tv_work` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `u_id` text DEFAULT NULL,
  `task_id` text DEFAULT NULL,
  `task_type` text DEFAULT NULL,
  `type` text DEFAULT NULL,
  `task_date` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users_permissions`
--

CREATE TABLE `users_permissions` (
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users_roles`
--

CREATE TABLE `users_roles` (
  `admin_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `posts_admin_id_foreign` (`admin_id`);

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

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

--
-- Indexes for table `roles_permissions`
--
ALTER TABLE `roles_permissions`
  ADD PRIMARY KEY (`role_id`,`permission_id`);

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

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

--
-- Indexes for table `users_permissions`
--
ALTER TABLE `users_permissions`
  ADD PRIMARY KEY (`admin_id`,`permission_id`);

--
-- Indexes for table `users_roles`
--
ALTER TABLE `users_roles`
  ADD PRIMARY KEY (`admin_id`,`role_id`);

--
-- AUTO_INCREMENT for table `db_amount`
--
ALTER TABLE `db_amount`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `db_daily`
--
ALTER TABLE `db_daily`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `db_notification`
--
ALTER TABLE `db_notification`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_payment`
--
ALTER TABLE `db_payment`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `db_refer`
--
ALTER TABLE `db_refer`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_settings`
--
ALTER TABLE `db_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `db_task`
--
ALTER TABLE `db_task`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_tracking`
--
ALTER TABLE `db_tracking`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `py_request`
--
ALTER TABLE `py_request`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tv_redeem`
--
ALTER TABLE `tv_redeem`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tv_work`
--
ALTER TABLE `tv_work`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;
COMMIT;

