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

START TRANSACTION;



--
-- Database: `ibexx2`
--

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2022_05_14_101005_create_user_models_table', 1),
(2, '2014_10_12_000000_create_users_table', 2),
(3, '2014_10_12_100000_create_password_resets_table', 2),
(4, '2019_08_19_000000_create_failed_jobs_table', 2),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 2),
(6, '2022_05_25_064143_create_client_user_models_table', 3),
(7, '2022_05_26_063936_create_chips_deposit_models_table', 4),
(8, '2022_06_20_064620_create_manual_match_models_table', 5),
(9, '2022_06_22_065915_create_view_match_models_table', 6),
(10, '2022_06_23_082351_create_match_toss_models_table', 7),
(11, '2022_07_12_055111_create_view_soccer_matches_table', 8),
(12, '2022_07_12_094547_create_bet_transaction_models_table', 9),
(13, '2022_07_13_092623_create_chips_transaction_histories_table', 10),
(14, '2022_07_29_112213_create_front_client_profit_loss_models_table', 11),
(15, '2022_07_02_125510_create_bet_models_table', 12);

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

--
-- Table structure for table `tbl_admin_ac_statement`
--

CREATE TABLE `tbl_admin_ac_statement` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(11) NOT NULL,
  `team1` varchar(500) DEFAULT NULL,
  `team2` varchar(500) DEFAULT NULL,
  `selected_team` varchar(500) DEFAULT NULL,
  `credit` varchar(500) DEFAULT NULL,
  `debit` varchar(500) DEFAULT NULL,
  `balance` varchar(500) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `match_id` int(11) DEFAULT NULL,
  `statement_type` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_admin_chips_assign`
--

CREATE TABLE `tbl_admin_chips_assign` (
  `id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `admin_role_id` int(11) DEFAULT NULL,
  `assign_chips` int(11) DEFAULT NULL,
  `assign_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_admin_chips_assign`
--

INSERT INTO `tbl_admin_chips_assign` (`id`, `admin_id`, `admin_role_id`, `assign_chips`, `assign_by`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 10000000, NULL, '2022-08-15 10:51:21', '2022-09-28 10:00:43'),
(2, 46, NULL, 160000, 1, '2022-08-15 05:31:21', '2022-08-15 06:36:31'),
(3, 49, NULL, 8000, 1, '2022-08-15 06:36:41', '2022-08-17 05:05:12'),
(4, 48, NULL, 12000, 49, '2022-08-15 07:08:09', '2022-08-15 07:08:09'),
(5, 72, NULL, 25000, 1, '2022-08-17 05:04:31', '2022-08-17 05:04:31'),
(6, 60, NULL, 10000, 49, '2022-08-17 05:05:12', '2022-08-17 05:05:12'),
(7, 75, NULL, 5000, 1, '2022-09-13 04:17:21', '2022-09-13 04:17:21'),
(8, 76, NULL, 1000, 1, '2022-09-13 04:17:39', '2022-09-13 04:17:39');

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

--
-- Table structure for table `tbl_announcement`
--

CREATE TABLE `tbl_announcement` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(500) NOT NULL,
  `description` varchar(500) NOT NULL,
  `image` varchar(5000) NOT NULL,
  `custom_url` varchar(500) NOT NULL,
  `meta_title` varchar(500) NOT NULL,
  `meta_description` varchar(500) NOT NULL,
  `meta_keyword` varchar(500) NOT NULL,
  `status` varchar(500) NOT NULL,
  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updated_at` timestamp(6) NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_announcement`
--

INSERT INTO `tbl_announcement` (`id`, `title`, `description`, `image`, `custom_url`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `created_at`, `updated_at`) VALUES
(1, 'News And Announcment', 'Welcome To The Bet9Fair Betting Website.', 'public/Announcement/download (1)_1658924057.jpeg', 'News_And_Announcment', 'News_And_Announcment', 'News_And_Announcment', 'News_And_Announcment', 'active', '2022-07-27 12:14:17.554207', NULL);

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

--
-- Table structure for table `tbl_bet_complete`
--

CREATE TABLE `tbl_bet_complete` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gameId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eventName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oddsTeam` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oddsAmount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oddsRate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oddsType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '0=back, 1=lay',
  `available_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eventDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stake` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `game` int(11) DEFAULT NULL COMMENT '1=cricket, 2=soccer, 3=tennis'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_bet_complete`
--

INSERT INTO `tbl_bet_complete` (`id`, `gameId`, `eventName`, `user_client_id`, `oddsTeam`, `oddsAmount`, `oddsRate`, `oddsType`, `available_amount`, `eventDate`, `stake`, `created_at`, `updated_at`, `game`) VALUES
(1, '31782663', 'Kunshan v Heilongjiang Lava Spring / Sep 28 2022 12:30PM (IST)', '19', 'Heilongjiang Lava Spring', '500', '15.5', '0', NULL, 'Sep 28 2022 12:30PM (IST)', '500', '2022-09-28 07:39:01', NULL, 2),
(2, '1009281345', 'England T10 v West Indies T10 / Sep 28 2022  1:30PM (IST)', '19', 'West Indies T10', '100', '0', '0', NULL, 'Sep 28 2022  1:30PM (IST)', '100', '2022-09-28 08:31:07', NULL, 1);

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

--
-- Table structure for table `tbl_bet_transaction`
--

CREATE TABLE `tbl_bet_transaction` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `bet_chips` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `match_id` bigint(20) DEFAULT NULL,
  `team` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `match_status` int(11) NOT NULL DEFAULT '0' COMMENT '0 = pending, 1 = win , 2 = loss',
  `game` int(11) DEFAULT NULL COMMENT '1=cricket, 2=soccer, 3=tennis',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_bet_transaction`
--

INSERT INTO `tbl_bet_transaction` (`id`, `user_id`, `bet_chips`, `match_id`, `team`, `date`, `match_status`, `game`, `created_at`, `updated_at`) VALUES
(1, 19, '500', 31782663, 'Heilongjiang Lava Spring', 'Sep 28 2022 12:30PM (IST)', 1, 2, '2022-09-28 07:39:01', '2022-12-05 13:16:11'),
(2, 19, '100', 1009281345, 'West Indies T10', 'Sep 28 2022  1:30PM (IST)', 1, 1, '2022-09-28 08:31:07', '2022-12-05 13:16:11');

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

--
-- Table structure for table `tbl_chips_deposit`
--

CREATE TABLE `tbl_chips_deposit` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chips_amount` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_chips_deposit`
--

INSERT INTO `tbl_chips_deposit` (`id`, `client_id`, `chips_amount`, `created_user_id`, `remark`, `created_at`, `updated_at`) VALUES
(1, '19', '8900', '1', 'purchase chip', '2022-07-07 05:54:28', '2022-09-28 10:00:10'),
(2, '22', '3001', '1', 'chip purchase', '2022-07-09 14:16:29', '2022-07-13 10:12:35'),
(3, '23', '98000', '1', 'chipsss', '2022-07-11 08:15:29', '2022-07-11 08:18:13'),
(4, '21', '30000', '1', NULL, '2022-07-12 09:26:24', '2022-07-13 10:11:16'),
(5, '24', '98000', '1', NULL, '2022-07-13 05:55:19', '2022-08-01 11:55:14'),
(6, '28', '11000', '1', 'purchase chips', '2022-07-28 12:07:03', '2022-07-28 12:07:03'),
(7, '25', '500', '1', NULL, '2022-08-03 11:34:31', '2022-08-03 11:34:31'),
(8, '26', '500', '1', NULL, '2022-09-13 04:19:43', '2022-09-13 04:19:43');

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

--
-- Table structure for table `tbl_chips_summery`
--

CREATE TABLE `tbl_chips_summery` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `available_balance` int(11) DEFAULT NULL,
  `credit_balance` int(11) DEFAULT NULL,
  `debit_balance` int(11) DEFAULT NULL,
  `remaining_balance` int(11) DEFAULT NULL,
  `debit_credit` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `team_name` varchar(200) DEFAULT NULL,
  `is_win` int(11) DEFAULT NULL,
  `game` int(11) DEFAULT NULL COMMENT '1=cricket,2=soccer,3=tennis',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_deleted` int(11) NOT NULL DEFAULT '0',
  `game_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_chips_summery`
--

INSERT INTO `tbl_chips_summery` (`id`, `user_id`, `created_user`, `updated_user`, `available_balance`, `credit_balance`, `debit_balance`, `remaining_balance`, `debit_credit`, `date`, `time`, `team_name`, `is_win`, `game`, `created_at`, `updated_at`, `is_deleted`, `game_id`) VALUES
(1, 19, 1, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, 'Heilongjiang Lava Spring', NULL, 2, '2022-09-28 07:39:01', NULL, 0, 1),
(2, 19, 1, NULL, NULL, NULL, 100, NULL, NULL, NULL, NULL, 'West Indies T10', NULL, 1, '2022-09-28 08:31:07', NULL, 0, 1);

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

--
-- Table structure for table `tbl_chips_transaction_histories`
--

CREATE TABLE `tbl_chips_transaction_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_id` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `game_id` varchar(110) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `game` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '1=cricket,2=soccer,3=tennis',
  `chips_amount` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `available_amount` int(11) DEFAULT NULL,
  `by_who` int(11) DEFAULT NULL COMMENT '1 = admin deposit, 2 = win deposit, 3 = lose, 4= bet',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_chips_transaction_histories`
--

INSERT INTO `tbl_chips_transaction_histories` (`id`, `client_id`, `admin_id`, `game_id`, `game`, `chips_amount`, `available_amount`, `by_who`, `created_at`, `updated_at`) VALUES
(1, '19', NULL, '31782663', '2', '500', NULL, 4, '2022-09-28 07:39:01', '2022-12-05 13:16:11'),
(2, '19', NULL, '31782663', NULL, '1000', 3800, 2, '2022-09-28 07:43:01', '2022-12-05 13:16:11'),
(3, '19', NULL, '1009281345', '1', '100', NULL, 4, '2022-09-28 08:31:07', '2022-12-05 13:16:11'),
(4, '19', '1', NULL, NULL, '5000', 8700, 1, '2022-09-28 10:00:10', '2022-12-05 13:16:11'),
(5, '19', NULL, '1009281345', NULL, '200', 8900, 2, '2022-10-11 06:19:25', '2022-12-05 13:16:11');

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

--
-- Table structure for table `tbl_cricket`
--

CREATE TABLE `tbl_cricket` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_checked_id` varchar(500) DEFAULT NULL,
  `gameId` bigint(20) DEFAULT NULL,
  `marketId` double DEFAULT NULL,
  `eid` bigint(20) DEFAULT NULL,
  `eventName` varchar(500) DEFAULT NULL,
  `inPlay` varchar(500) DEFAULT NULL,
  `tv` varchar(500) DEFAULT NULL,
  `back1` double DEFAULT NULL,
  `t1_img` varchar(500) DEFAULT NULL,
  `t2_img` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_hide` int(11) NOT NULL DEFAULT '0',
  `lay1` double DEFAULT NULL,
  `back11` double DEFAULT NULL,
  `lay11` double DEFAULT NULL,
  `back12` double DEFAULT NULL,
  `lay12` double DEFAULT NULL,
  `m1` varchar(500) DEFAULT NULL,
  `f` varchar(500) DEFAULT NULL,
  `vir` int(11) DEFAULT NULL,
  `game_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_cricket`
--

INSERT INTO `tbl_cricket` (`id`, `is_checked_id`, `gameId`, `marketId`, `eid`, `eventName`, `inPlay`, `tv`, `back1`, `t1_img`, `t2_img`, `created_at`, `updated_at`, `is_hide`, `lay1`, `back11`, `lay11`, `back12`, `lay12`, `m1`, `f`, `vir`, `game_type_id`) VALUES
(1, '1009281345', 1009281345, 1.100928134515, 4, 'England T10 v West Indies T10 / Sep 28 2022  1:30PM (IST)', 'False', 'True', 0, NULL, NULL, '2022-09-28 07:37:35', '2022-09-28 07:37:35', 1, 0, 0, 0, 0, 0, 'False', 'True', 2, 1),
(2, '31777846', 31777846, 1.203949453, 4, 'India v South Africa / Sep 28 2022  7:00PM (IST)', 'False', 'False', 1.57, NULL, NULL, '2022-09-28 07:37:35', '2022-09-28 07:37:35', 1, 1.58, 2.74, 2.76, 0, 0, 'True', 'True', 1, 1),
(3, '561010033', 561010033, 1.561010033, 4, 'Melbourne Stars X v Sydney Sixers X / Sep 28 2022  3:05PM (IST)', 'True', 'False', 0, NULL, NULL, '2022-09-28 10:38:58', '2022-09-28 10:38:58', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, 1),
(4, '1009281356', 1009281356, 1.100928133715, 4, 'New Zealand T10 v Sri Lanka T10 / Sep 28 2022  4:30PM (IST)', 'False', 'True', 0, NULL, NULL, '2022-09-28 10:38:58', '2022-09-28 10:38:58', 0, 0, 0, 0, 0, 0, 'True', 'True', 2, 1),
(5, '462019544', 462019544, 1.462019544, 4, 'TKR XI v SLZ XI / Sep 30 2022 11:25AM (IST)', 'True', 'False', 0, NULL, NULL, '2022-09-30 07:04:12', '2022-09-30 07:04:12', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 1),
(6, '31779399', 31779399, 1.203987371, 4, 'Western Australia v NSW Blues / Oct  1 2022  7:35AM (IST)', 'False', 'False', 1.75, NULL, NULL, '2022-09-30 07:04:12', '2022-09-30 07:04:12', 0, 1.8, 2.26, 2.34, 0, 0, 'False', 'True', 1, 1),
(7, '31795761', 31795761, 1.204290617, 4, 'Bhilwara Kings v India Capitals / Oct  2 2022  3:30PM (IST)', 'True', 'True', 1.03, NULL, NULL, '2022-10-02 13:07:33', '2022-10-02 13:07:33', 0, 1.04, 30, 36, 0, 0, 'True', 'True', 1, 1),
(8, '1710012242', 1710012242, 1.171001224343, 4, 'Eastern Cape v Garden Route Badgers / Oct  2 2022  6:00PM (IST)', 'True', 'True', 0, NULL, NULL, '2022-10-02 13:07:33', '2022-10-02 13:07:33', 0, 0, 0, 0, 0, 0, 'True', 'True', 1, 1),
(9, '462019580', 462019580, 1.46201958, 4, 'TKR XI v JT XI / Oct  2 2022  6:00PM (IST)', 'True', 'False', 0, NULL, NULL, '2022-10-02 13:07:33', '2022-10-02 13:07:33', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 1),
(10, '31808579', 31808579, 1.204533002, 4, 'Thailand Women v UAE Women / Oct  7 2022  8:30AM (IST)', 'True', 'False', 0, NULL, NULL, '2022-10-07 06:08:22', '2022-10-07 06:08:22', 0, 1.01, 1000, 0, 0, 0, 'True', 'True', 1, 1),
(11, '462019657', 462019657, 1.462019657, 4, 'TKR XI v JT XI / Oct  7 2022 11:05AM (IST)', 'True', 'False', 0, NULL, NULL, '2022-10-07 06:08:22', '2022-10-07 06:08:22', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 1),
(12, '31808580', 31808580, 1.204533259, 4, 'India Women v Pakistan Women / Oct  7 2022  1:00PM (IST)', 'False', 'False', 1.11, NULL, NULL, '2022-10-07 06:08:22', '2022-10-07 06:08:22', 0, 1.12, 9.4, 10, 0, 0, 'True', 'True', 1, 1),
(13, '31799893', 31799893, 1.204504833, 4, 'New Zealand v Pakistan / Oct  8 2022 11:40AM (IST)', 'True', 'True', 14, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 15, 1.07, 1.08, 0, 0, 'True', 'True', 1, 1),
(14, '561010128', 561010128, 1.561010128, 4, 'Melbourne Stars XI  v Brisbane Heat XI  / Oct  8 2022 12:25PM (IST)', 'True', 'False', 0, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, 1),
(15, '31808593', 31808593, 1.204533595, 4, 'Bangladesh Women v India Women / Oct  8 2022  1:00PM (IST)', 'True', 'True', 70, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 75, 1.01, 1.02, 0, 0, 'True', 'True', 1, 1),
(16, '1710071626', 1710071626, 1.171007162727, 4, 'Gujranwala Giants v Bahawalpur Royals / Oct  8 2022  8:30PM (IST)', 'False', 'False', 0, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 0, 0, 0, 0, 0, 'False', 'False', 1, 1),
(17, '31811790', 31811790, 1.204599986, 4, 'Malaysia Women v Thailand Women / Oct  9 2022  8:30AM (IST)', 'False', 'False', 3.3, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 11, 1.1, 1.43, 0, 0, 'False', 'True', 1, 1),
(18, '31799905', 31799905, 1.204505066, 4, 'New Zealand v Bangladesh / Oct  9 2022 11:40AM (IST)', 'False', 'False', 1.19, NULL, NULL, '2022-10-08 08:53:13', '2022-10-08 08:53:13', 0, 1.24, 5.2, 6.4, 0, 0, 'False', 'False', 1, 1),
(19, '31859939', 31859939, 1.205888215, NULL, 'Ireland v New Zealand / Nov  4 2022  9:30AM (IST)', 'True', 'True', 13.5, NULL, NULL, '2022-11-04 05:06:09', '2022-11-04 05:06:09', 0, 14, 1.07, 1.08, 0, 0, 'True', 'True', 1, 1),
(20, '31846570', 31846570, 1.205925641, NULL, 'Sydney Thunder WBBL v Brisbane Heat WBBL / Nov  4 2022 10:00AM (IST)', 'True', 'True', 3.2, NULL, NULL, '2022-11-04 05:06:09', '2022-11-04 05:06:09', 0, 3.25, 1.45, 1.46, 0, 0, 'True', 'True', 1, 1),
(21, NULL, NULL, NULL, NULL, 'Rwanda vs Tanzania, 1st Match', NULL, NULL, NULL, NULL, NULL, '2022-12-14 06:46:35', '2022-12-14 06:46:35', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(22, NULL, NULL, NULL, NULL, 'Namibia vs Nepal, 2nd Match', NULL, NULL, NULL, NULL, NULL, '2022-12-14 06:49:22', '2022-12-14 06:49:22', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(23, NULL, NULL, NULL, NULL, 'Limpopo vs Garden Route Badgers, 13th Match', NULL, NULL, NULL, NULL, NULL, '2022-12-14 06:50:32', '2022-12-14 06:50:32', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `tbl_front_client_profit_loss`
--

CREATE TABLE `tbl_front_client_profit_loss` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `game_id` varchar(255) DEFAULT NULL,
  `selected_team` varchar(500) DEFAULT NULL,
  `bet_amount` bigint(20) DEFAULT NULL,
  `available_amount` bigint(20) DEFAULT NULL,
  `remaining_balance` int(11) DEFAULT NULL,
  `match_result_status` int(11) DEFAULT '0' COMMENT '0=pending, 1=win, 2=loss',
  `by_who` int(11) DEFAULT '4' COMMENT '4= bet , 1=win,2=loss',
  `is_declared` int(11) NOT NULL DEFAULT '0',
  `after_result_win_amount` int(11) DEFAULT NULL,
  `after_result_loss_amount` int(11) DEFAULT NULL,
  `game` int(11) DEFAULT NULL COMMENT '1=cricket,2=soccer,3=tennis',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_front_client_profit_loss`
--

INSERT INTO `tbl_front_client_profit_loss` (`id`, `client_id`, `game_id`, `selected_team`, `bet_amount`, `available_amount`, `remaining_balance`, `match_result_status`, `by_who`, `is_declared`, `after_result_win_amount`, `after_result_loss_amount`, `game`, `created_at`, `updated_at`) VALUES
(1, '19', '31782663', 'Heilongjiang Lava Spring', 500, NULL, NULL, 1, 1, 1, NULL, NULL, 2, '2022-09-28 07:39:01', '2022-09-28 07:43:01'),
(2, '19', '1009281345', 'West Indies T10', 100, NULL, NULL, 1, 1, 1, NULL, NULL, 1, '2022-09-28 08:31:07', '2022-10-11 06:19:25');

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

--
-- Table structure for table `tbl_manage_code`




-- Table structure for table `tbl_manual_match`
--

CREATE TABLE `tbl_manual_match` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sport_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `competition` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `market_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `team_one` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `team_two` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `match` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_matches`
--

CREATE TABLE `tbl_matches` (
  `id` int(10) UNSIGNED NOT NULL,
  `game_name` varchar(500) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `status` varchar(500) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_match_toss`
--

CREATE TABLE `tbl_match_toss` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_checked_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gameId` double DEFAULT NULL,
  `match_open_close` int(11) NOT NULL DEFAULT '0' COMMENT 'match open close status - 0 = close and 1 = open',
  `marketId` double DEFAULT NULL,
  `eid` bigint(20) DEFAULT NULL,
  `eventName` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inPlay` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tv` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `back1` double DEFAULT NULL,
  `lay1` double DEFAULT NULL,
  `back11` double DEFAULT NULL,
  `lay11` double DEFAULT NULL,
  `back12` double DEFAULT NULL,
  `lay12` double DEFAULT NULL,
  `m1` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `f` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vir` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `game_type_id` int(11) NOT NULL,
  `is_hide` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_match_toss`
--

INSERT INTO `tbl_match_toss` (`id`, `is_checked_id`, `gameId`, `match_open_close`, `marketId`, `eid`, `eventName`, `inPlay`, `tv`, `back1`, `lay1`, `back11`, `lay11`, `back12`, `lay12`, `m1`, `f`, `vir`, `created_at`, `updated_at`, `game_type_id`, `is_hide`) VALUES
(2, '31777846', 31777846, 1, 1.203949453, 4, 'India v South Africa / Sep 28 2022  7:00PM (IST)', 'False', 'False', 1.57, 1.58, 2.74, 2.76, 0, 0, 'True', 'True', 1, '2022-09-28 07:37:35', NULL, 1, 1),
(3, '31782663', 31782663, 0, 1.204059468, NULL, 'Kunshan v Heilongjiang Lava Spring / Sep 28 2022 12:30PM (IST)', 'True', 'True', 1.07, 1.08, 95, 100, 16.5, 18.5, 'False', 'False', 1, '2022-09-28 07:37:46', NULL, 2, 0),
(4, '31782423', 31782423, 0, 1.204056776, NULL, 'Kastamonuspor v Nevsehir Belediyespor / Sep 28 2022  3:30PM (IST)', 'False', 'True', 1.78, 1.84, 4.9, 5.4, 3.95, 4.3, 'False', 'False', 1, '2022-09-28 07:37:46', NULL, 2, 0),
(5, '31781042', 31781042, 0, 1.204027085, NULL, 'Golubic v Muchova / Sep 28 2022  3:00PM (IST)', 'False', 'True', 2.28, 2.34, 1.75, 1.79, 0, 0, 'True', 'False', 1, '2022-09-28 07:37:56', NULL, 3, 0),
(6, '31781107', 31781107, 0, 1.204028323, NULL, 'Thiem v Cilic / Sep 28 2022 11:00PM (IST)', 'False', 'True', 2.5, 2.6, 1.63, 1.66, 0, 0, 'True', 'False', 1, '2022-09-28 07:37:56', NULL, 3, 0),
(7, '561010033', 561010033, 0, 1.561010033, 4, 'Melbourne Stars X v Sydney Sixers X / Sep 28 2022  3:05PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, '2022-09-28 10:38:58', NULL, 1, 0),
(8, '1009281356', 1009281356, 0, 1.100928133715, 4, 'New Zealand T10 v Sri Lanka T10 / Sep 28 2022  4:30PM (IST)', 'False', 'True', 0, 0, 0, 0, 0, 0, 'True', 'True', 2, '2022-09-28 10:38:58', NULL, 1, 0),
(9, '462019544', 462019544, 0, 1.462019544, 4, 'TKR XI v SLZ XI / Sep 30 2022 11:25AM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, '2022-09-30 07:04:12', NULL, 1, 0),
(10, '31779399', 31779399, 0, 1.203987371, 4, 'Western Australia v NSW Blues / Oct  1 2022  7:35AM (IST)', 'False', 'False', 1.75, 1.8, 2.26, 2.34, 0, 0, 'False', 'True', 1, '2022-09-30 07:04:12', NULL, 1, 0),
(11, '31795761', 31795761, 0, 1.204290617, 4, 'Bhilwara Kings v India Capitals / Oct  2 2022  3:30PM (IST)', 'True', 'True', 1.03, 1.04, 30, 36, 0, 0, 'True', 'True', 1, '2022-10-02 13:07:33', NULL, 1, 0),
(12, '1710012242', 1710012242, 0, 1.171001224343, 4, 'Eastern Cape v Garden Route Badgers / Oct  2 2022  6:00PM (IST)', 'True', 'True', 0, 0, 0, 0, 0, 0, 'True', 'True', 1, '2022-10-02 13:07:33', NULL, 1, 0),
(13, '462019580', 462019580, 0, 1.46201958, 4, 'TKR XI v JT XI / Oct  2 2022  6:00PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, '2022-10-02 13:07:33', NULL, 1, 0),
(14, '31808579', 31808579, 0, 1.204533002, 4, 'Thailand Women v UAE Women / Oct  7 2022  8:30AM (IST)', 'True', 'False', 0, 1.01, 1000, 0, 0, 0, 'True', 'True', 1, '2022-10-07 06:08:22', NULL, 1, 0),
(15, '462019657', 462019657, 0, 1.462019657, 4, 'TKR XI v JT XI / Oct  7 2022 11:05AM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, '2022-10-07 06:08:22', NULL, 1, 0),
(16, '31808580', 31808580, 0, 1.204533259, 4, 'India Women v Pakistan Women / Oct  7 2022  1:00PM (IST)', 'False', 'False', 1.11, 1.12, 9.4, 10, 0, 0, 'True', 'True', 1, '2022-10-07 06:08:22', NULL, 1, 0),
(17, '31799893', 31799893, 0, 1.204504833, 4, 'New Zealand v Pakistan / Oct  8 2022 11:40AM (IST)', 'True', 'True', 14, 15, 1.07, 1.08, 0, 0, 'True', 'True', 1, '2022-10-08 08:53:13', NULL, 1, 0),
(18, '561010128', 561010128, 0, 1.561010128, 4, 'Melbourne Stars XI  v Brisbane Heat XI  / Oct  8 2022 12:25PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, '2022-10-08 08:53:13', NULL, 1, 0),
(19, '31808593', 31808593, 0, 1.204533595, 4, 'Bangladesh Women v India Women / Oct  8 2022  1:00PM (IST)', 'True', 'True', 70, 75, 1.01, 1.02, 0, 0, 'True', 'True', 1, '2022-10-08 08:53:13', NULL, 1, 0),
(20, '1710071626', 1710071626, 0, 1.171007162727, 4, 'Gujranwala Giants v Bahawalpur Royals / Oct  8 2022  8:30PM (IST)', 'False', 'False', 0, 0, 0, 0, 0, 0, 'False', 'False', 1, '2022-10-08 08:53:13', NULL, 1, 0),
(21, '31811790', 31811790, 0, 1.204599986, 4, 'Malaysia Women v Thailand Women / Oct  9 2022  8:30AM (IST)', 'False', 'False', 3.3, 11, 1.1, 1.43, 0, 0, 'False', 'True', 1, '2022-10-08 08:53:13', NULL, 1, 0),
(22, '31799905', 31799905, 0, 1.204505066, 4, 'New Zealand v Bangladesh / Oct  9 2022 11:40AM (IST)', 'False', 'False', 1.19, 1.24, 5.2, 6.4, 0, 0, 'False', 'False', 1, '2022-10-08 08:53:13', NULL, 1, 0),
(23, '31859939', 31859939, 0, 1.205888215, NULL, 'Ireland v New Zealand / Nov  4 2022  9:30AM (IST)', 'True', 'True', 13.5, 14, 1.07, 1.08, 0, 0, 'True', 'True', 1, '2022-11-04 05:06:09', NULL, 1, 0),
(24, '31846570', 31846570, 0, 1.205925641, NULL, 'Sydney Thunder WBBL v Brisbane Heat WBBL / Nov  4 2022 10:00AM (IST)', 'True', 'True', 3.2, 3.25, 1.45, 1.46, 0, 0, 'True', 'True', 1, '2022-11-04 05:06:09', NULL, 1, 0);

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

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `menu_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_menu` int(11) NOT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_icon`, `order_menu`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Dashboards', 'pe-7s-display1', 1, 'active', '2021-04-03 10:37:36', NULL),
(2, 'Match', 'pe-7s-display1', 2, 'active', '2022-06-14 10:37:36', '2022-06-14 08:47:04'),
(3, 'Admin', 'pe-7s-user', 3, 'active', '2021-04-03 10:40:53', '2022-06-21 11:51:26'),
(4, 'User', 'pe-7s-user', 4, 'active', '2021-04-25 10:40:53', '2022-06-14 10:25:02'),
(5, 'Fancy Result', 'pe-7s-graph', 5, 'active', '2022-06-13 10:40:53', '2022-06-14 10:25:06'),
(6, 'News And Announcement ', 'pe-7s-graph', 6, 'active', '2022-06-14 10:03:23', '2022-07-04 05:33:48'),
(7, 'My Profile', 'pe-7s-user', 7, 'active', '2022-06-14 10:03:23', '2022-06-14 10:24:40'),
(8, 'Report', 'pe-7s-user', 8, 'active', '2022-06-14 10:03:23', '2022-06-14 10:24:44');

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

--
-- Table structure for table `tbl_soccer`
--

CREATE TABLE `tbl_soccer` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_checked_id` varchar(500) DEFAULT NULL,
  `gameId` bigint(20) DEFAULT NULL,
  `marketId` double DEFAULT NULL,
  `eid` bigint(20) DEFAULT NULL,
  `eventName` varchar(500) DEFAULT NULL,
  `inPlay` varchar(500) DEFAULT NULL,
  `tv` varchar(500) DEFAULT NULL,
  `back1` double DEFAULT NULL,
  `t1_img` varchar(500) DEFAULT NULL,
  `t2_img` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_hide` int(11) NOT NULL DEFAULT '0',
  `lay1` double DEFAULT NULL,
  `back11` double DEFAULT NULL,
  `lay11` double DEFAULT NULL,
  `back12` double DEFAULT NULL,
  `lay12` double DEFAULT NULL,
  `m1` varchar(500) DEFAULT NULL,
  `f` varchar(500) DEFAULT NULL,
  `vir` int(11) DEFAULT NULL,
  `game_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_soccer`
--

INSERT INTO `tbl_soccer` (`id`, `is_checked_id`, `gameId`, `marketId`, `eid`, `eventName`, `inPlay`, `tv`, `back1`, `t1_img`, `t2_img`, `created_at`, `updated_at`, `is_hide`, `lay1`, `back11`, `lay11`, `back12`, `lay12`, `m1`, `f`, `vir`, `game_type_id`) VALUES
(1, '31782663', 31782663, 1.204059468, NULL, 'Kunshan v Heilongjiang Lava Spring / Sep 28 2022 12:30PM (IST)', 'True', 'True', 1.07, NULL, NULL, '2022-09-28 07:37:46', '2022-09-28 07:37:46', 0, 1.08, 95, 100, 16.5, 18.5, 'False', 'False', 1, 2),
(2, '31782423', 31782423, 1.204056776, NULL, 'Kastamonuspor v Nevsehir Belediyespor / Sep 28 2022  3:30PM (IST)', 'False', 'True', 1.78, NULL, NULL, '2022-09-28 07:37:46', '2022-09-28 07:37:46', 0, 1.84, 4.9, 5.4, 3.95, 4.3, 'False', 'False', 1, 2);

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

--
-- Table structure for table `tbl_sub_menu`
--

CREATE TABLE `tbl_sub_menu` (
  `id` int(10) UNSIGNED NOT NULL,
  `menu_id` int(11) NOT NULL,
  `sub_menu_name` varchar(250) DEFAULT NULL,
  `sub_menu_url` varchar(250) DEFAULT NULL,
  `sub_menu_order` int(11) NOT NULL,
  `visible_menu` int(11) NOT NULL,
  `menu_action` int(11) NOT NULL COMMENT '1=list, 2=create, 3=edit',
  `parent_sub_menu` int(11) NOT NULL,
  `sub_menu_level` int(11) NOT NULL COMMENT 'if having sub menu child of this menu then 2 otherwise 0',
  `parent_sub_menu_level` int(11) NOT NULL COMMENT 'if having sub menu label then sub menu label id otherwise 0',
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_sub_menu`
--

INSERT INTO `tbl_sub_menu` (`id`, `menu_id`, `sub_menu_name`, `sub_menu_url`, `sub_menu_order`, `visible_menu`, `menu_action`, `parent_sub_menu`, `sub_menu_level`, `parent_sub_menu_level`, `created_user`, `updated_user`, `created_at`, `updated_at`) VALUES
(1, 1, 'dashboard', 'dashboard', 1, 1, 1, 1, 0, 0, NULL, NULL, '2021-04-03 10:49:48', '2022-06-17 07:49:46'),
(2, 3, 'Admins', 'user_list', 2, 1, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-06-14 08:47:36'),
(3, 3, 'Admins', 'add_user', 2, 0, 2, 3, 2, 0, NULL, NULL, '2021-04-05 16:25:38', '2022-06-27 08:48:46'),
(4, 3, 'User Role', 'user_role_list', 2, 1, 1, 0, 2, 0, NULL, NULL, '2021-04-06 00:00:00', '2022-06-27 08:48:41'),
(5, 3, 'User Role', 'add_user_role', 2, 0, 2, 3, 0, 0, NULL, NULL, '2021-04-06 11:00:10', '2022-06-14 08:48:14'),
(7, 3, 'Role Permission', 'user_permission', 3, 1, 1, 0, 0, 0, NULL, NULL, '2021-04-06 11:15:24', '2022-06-14 08:47:55'),
(8, 6, 'Test Menu', 'test_all', 1, 0, 3, 95, 0, 0, NULL, NULL, '2021-04-07 16:55:18', '2022-05-23 09:36:46'),
(9, 4, 'client', 'client_list', 1, 1, 1, 0, 0, 0, NULL, NULL, '2021-04-06 11:15:24', '2022-06-14 08:48:39'),
(10, 4, 'client', 'add_client', 2, 0, 2, 4, 0, 0, NULL, NULL, '2021-04-06 11:15:24', '2022-06-14 08:48:55'),
(11, 5, 'Fancy Result', 'fancy_result', 1, 1, 1, 1, 0, 0, NULL, NULL, '2021-04-06 11:15:24', '2022-06-14 09:27:35'),
(12, 2, 'Create Match', 'create_match', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-14 10:48:27'),
(13, 2, 'Emergency Match', 'emergency_match', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-14 10:48:33'),
(14, 2, 'Create Manual Match', 'create_manual_match', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-14 10:48:39'),
(15, 2, 'View Match', 'view_match', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-14 10:48:53'),
(16, 2, 'Match Toss', 'match_toss', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-14 10:49:00'),
(17, 6, 'Announcement', 'announcement_list', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 10:51:45', '2022-06-14 10:52:01'),
(18, 8, 'Account Statement', 'account_statement', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:08:13', '2022-06-14 11:23:05'),
(19, 8, 'Block Market', 'block_market', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:08:13', '2022-06-14 11:23:13'),
(20, 8, 'Chips Statement ', 'chips_statement', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:08:13', '2022-06-14 11:23:22'),
(21, 8, 'Profit/Loss', 'profit_loss', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:08:13', '2022-06-14 11:23:29'),
(22, 8, 'Chips Summery', 'chips_summery', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:08:13', '2022-06-14 11:23:33'),
(23, 8, 'Chips Summery Client Report', 'chips_summery_client_report', 1, 1, 1, 1, 0, 0, NULL, NULL, '2022-06-14 11:25:04', '2022-06-20 07:02:33'),
(24, 2, 'Create Match', 'add_match', 0, 0, 2, 12, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-20 07:02:46'),
(25, 2, 'Create Manual Match', 'add_manual_match', 0, 0, 2, 14, 0, 0, NULL, NULL, '2022-06-14 09:06:12', '2022-06-20 07:03:24'),
(26, 6, 'Announcement', 'add_news', 2, 0, 2, 17, 17, 17, NULL, NULL, '2022-07-04 06:47:53', '2022-07-04 06:49:12'),
(27, 3, 'Admins', 'user_list_id', 2, 0, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-07-22 08:42:38'),
(28, 3, 'Admins', 'super_master_popup', 2, 0, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-07-22 08:42:45'),
(29, 3, 'Admins', 'smda_popup', 2, 0, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-07-22 08:42:54'),
(700, 3, 'Admins', 'master_popup', 2, 0, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-07-22 08:42:54'),
(701, 3, 'Admins', 'add_user_popup', 2, 0, 1, 0, 2, 0, NULL, NULL, '2021-04-05 16:23:25', '2022-07-22 08:42:54'),
(702, 3, 'Admins', 'withdrawl_admin', 2, 0, 2, 3, 2, 0, NULL, NULL, '2022-08-16 16:25:38', '2022-08-16 08:48:46'),
(703, 2, '', 'declare_match_win', 1, 0, 1, 1, 1, 0, NULL, NULL, '2022-10-07 14:41:55', NULL);

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

--
-- Table structure for table `tbl_tennis`
--

CREATE TABLE `tbl_tennis` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_checked_id` varchar(500) DEFAULT NULL,
  `gameId` bigint(20) DEFAULT NULL,
  `marketId` double DEFAULT NULL,
  `eid` bigint(20) DEFAULT NULL,
  `eventName` varchar(500) DEFAULT NULL,
  `inPlay` varchar(500) DEFAULT NULL,
  `tv` varchar(500) DEFAULT NULL,
  `back1` double DEFAULT NULL,
  `t1_img` varchar(500) DEFAULT NULL,
  `t2_img` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_hide` int(11) NOT NULL DEFAULT '0',
  `lay1` double DEFAULT NULL,
  `back11` double DEFAULT NULL,
  `lay11` double DEFAULT NULL,
  `back12` double DEFAULT NULL,
  `lay12` double DEFAULT NULL,
  `m1` varchar(500) DEFAULT NULL,
  `f` varchar(500) DEFAULT NULL,
  `vir` int(11) DEFAULT NULL,
  `game_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_tennis`
--

INSERT INTO `tbl_tennis` (`id`, `is_checked_id`, `gameId`, `marketId`, `eid`, `eventName`, `inPlay`, `tv`, `back1`, `t1_img`, `t2_img`, `created_at`, `updated_at`, `is_hide`, `lay1`, `back11`, `lay11`, `back12`, `lay12`, `m1`, `f`, `vir`, `game_type_id`) VALUES
(1, '31781042', 31781042, 1.204027085, NULL, 'Golubic v Muchova / Sep 28 2022  3:00PM (IST)', 'False', 'True', 2.28, NULL, NULL, '2022-09-28 07:37:56', '2022-09-28 07:37:56', 0, 2.34, 1.75, 1.79, 0, 0, 'True', 'False', 1, 3),
(2, '31781107', 31781107, 1.204028323, NULL, 'Thiem v Cilic / Sep 28 2022 11:00PM (IST)', 'False', 'True', 2.5, NULL, NULL, '2022-09-28 07:37:56', '2022-09-28 07:37:56', 0, 2.6, 1.63, 1.66, 0, 0, 'True', 'False', 1, 3);

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

--
-- Table structure for table `tbl_user_permission`
--

CREATE TABLE `tbl_user_permission` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_role` int(11) NOT NULL,
  `parent_menu_id` int(11) NOT NULL,
  `sub_menu_id` int(11) NOT NULL,
  `allow_view` enum('1','0') NOT NULL DEFAULT '0',
  `allow_edit` enum('1','0') NOT NULL DEFAULT '0',
  `allow_create` enum('1','0') NOT NULL DEFAULT '0',
  `allow_list` enum('0','1') NOT NULL DEFAULT '0',
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_user_permission`
--

INSERT INTO `tbl_user_permission` (`id`, `user_role`, `parent_menu_id`, `sub_menu_id`, `allow_view`, `allow_edit`, `allow_create`, `allow_list`, `created_user`, `updated_user`, `created_at`, `updated_at`) VALUES
(16, 2, 1, 1, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(17, 2, 4, 9, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(18, 2, 5, 11, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(19, 2, 6, 17, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(20, 2, 8, 18, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(21, 2, 8, 19, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(22, 2, 8, 20, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(23, 2, 8, 21, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(24, 2, 8, 22, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(25, 2, 8, 23, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:32', NULL),
(26, 2, 3, 2, '1', '1', '1', '0', NULL, NULL, '2022-07-18 09:51:58', NULL),
(27, 3, 1, 1, '1', '1', '1', '0', NULL, NULL, '2022-08-17 06:16:18', NULL),
(28, 3, 3, 2, '1', '1', '1', '0', NULL, NULL, '2022-08-17 06:16:18', NULL),
(29, 3, 4, 9, '1', '0', '0', '0', NULL, NULL, '2022-08-17 06:16:18', NULL);

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

--
-- Table structure for table `tbl_user_role`
--

CREATE TABLE `tbl_user_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_code` varchar(20) DEFAULT NULL,
  `role_name` varchar(50) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_user_role`
--

INSERT INTO `tbl_user_role` (`id`, `role_code`, `role_name`, `created_user`, `updated_user`, `status`, `created_at`, `updated_at`) VALUES
(1, 'URC0001', 'Admin', 1, 1, 'active', '2022-06-13 12:10:40', NULL),
(2, 'URC0002', 'Mini Admin', 1, NULL, 'active', '2022-06-13 06:42:24', '2022-06-13 06:42:24'),
(3, 'URC0003', 'Super Master', 1, NULL, 'active', '2022-06-13 06:42:42', '2022-06-13 06:42:42'),
(4, 'URC0004', 'SMDA', 1, NULL, 'active', '2022-06-13 06:42:53', '2022-06-13 06:42:53'),
(5, 'URC0005', 'Master', 1, NULL, 'active', '2022-06-13 06:43:09', '2022-06-13 06:43:09'),
(6, 'URC0006', 'Dealer', 1, NULL, 'active', '2022-06-13 06:43:20', '2022-06-13 06:43:20');

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

--
-- Table structure for table `tbl_view_match`
--

CREATE TABLE `tbl_view_match` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_checked_id` varchar(500) DEFAULT NULL,
  `gameId` bigint(20) DEFAULT NULL,
  `marketId` double DEFAULT NULL,
  `eid` bigint(20) DEFAULT NULL,
  `eventName` varchar(500) DEFAULT NULL,
  `inPlay` varchar(500) DEFAULT NULL,
  `tv` varchar(500) DEFAULT NULL,
  `back1` double DEFAULT NULL,
  `lay1` double DEFAULT NULL,
  `back11` double DEFAULT NULL,
  `lay11` double DEFAULT NULL,
  `back12` double DEFAULT NULL,
  `lay12` double DEFAULT NULL,
  `m1` varchar(500) DEFAULT NULL,
  `f` varchar(500) DEFAULT NULL,
  `vir` int(11) DEFAULT NULL,
  `run_status` int(11) NOT NULL DEFAULT '0' COMMENT '0 = running. 1 = suspended. 2 = completed\r\n\r\n',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `winner_teams` varchar(5000) DEFAULT NULL,
  `game_type_id` int(11) NOT NULL,
  `is_hide` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_view_match`
--

INSERT INTO `tbl_view_match` (`id`, `is_checked_id`, `gameId`, `marketId`, `eid`, `eventName`, `inPlay`, `tv`, `back1`, `lay1`, `back11`, `lay11`, `back12`, `lay12`, `m1`, `f`, `vir`, `run_status`, `created_at`, `updated_at`, `winner_teams`, `game_type_id`, `is_hide`) VALUES
(1, '1009281345', 1009281345, 1.100928134515, 4, 'England T10 v West Indies T10 / Sep 28 2022  1:30PM (IST)', 'False', 'True', 0, 0, 0, 0, 0, 0, 'False', 'True', 2, 2, '2022-09-28 07:37:35', NULL, 'West Indies T10', 1, 1),
(2, '31777846', 31777846, 1.203949453, 4, 'India v South Africa / Sep 28 2022  7:00PM (IST)', 'False', 'False', 1.57, 1.58, 2.74, 2.76, 0, 0, 'True', 'True', 1, 2, '2022-09-28 07:37:35', NULL, 'South Africa', 1, 1),
(3, '31782663', 31782663, 1.204059468, NULL, 'Kunshan v Heilongjiang Lava Spring / Sep 28 2022 12:30PM (IST)', 'True', 'True', 1.07, 1.08, 95, 100, 16.5, 18.5, 'False', 'False', 1, 2, '2022-09-28 07:37:46', NULL, 'Heilongjiang Lava Spring', 2, 1),
(4, '31782423', 31782423, 1.204056776, NULL, 'Kastamonuspor v Nevsehir Belediyespor / Sep 28 2022  3:30PM (IST)', 'False', 'True', 1.78, 1.84, 4.9, 5.4, 3.95, 4.3, 'False', 'False', 1, 0, '2022-09-28 07:37:46', NULL, NULL, 2, 0),
(5, '31781042', 31781042, 1.204027085, NULL, 'Golubic v Muchova / Sep 28 2022  3:00PM (IST)', 'False', 'True', 2.28, 2.34, 1.75, 1.79, 0, 0, 'True', 'False', 1, 0, '2022-09-28 07:37:56', NULL, NULL, 3, 0),
(6, '31781107', 31781107, 1.204028323, NULL, 'Thiem v Cilic / Sep 28 2022 11:00PM (IST)', 'False', 'True', 2.5, 2.6, 1.63, 1.66, 0, 0, 'True', 'False', 1, 0, '2022-09-28 07:37:56', NULL, NULL, 3, 0),
(7, '561010033', 561010033, 1.561010033, 4, 'Melbourne Stars X v Sydney Sixers X / Sep 28 2022  3:05PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, 0, '2022-09-28 10:38:58', NULL, NULL, 1, 0),
(8, '1009281356', 1009281356, 1.100928133715, 4, 'New Zealand T10 v Sri Lanka T10 / Sep 28 2022  4:30PM (IST)', 'False', 'True', 0, 0, 0, 0, 0, 0, 'True', 'True', 2, 0, '2022-09-28 10:38:58', NULL, NULL, 1, 0),
(9, '462019544', 462019544, 1.462019544, 4, 'TKR XI v SLZ XI / Sep 30 2022 11:25AM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 0, '2022-09-30 07:04:12', NULL, NULL, 1, 0),
(10, '31779399', 31779399, 1.203987371, 4, 'Western Australia v NSW Blues / Oct  1 2022  7:35AM (IST)', 'False', 'False', 1.75, 1.8, 2.26, 2.34, 0, 0, 'False', 'True', 1, 0, '2022-09-30 07:04:12', NULL, NULL, 1, 0),
(11, '31795761', 31795761, 1.204290617, 4, 'Bhilwara Kings v India Capitals / Oct  2 2022  3:30PM (IST)', 'True', 'True', 1.03, 1.04, 30, 36, 0, 0, 'True', 'True', 1, 0, '2022-10-02 13:07:33', NULL, NULL, 1, 0),
(12, '1710012242', 1710012242, 1.171001224343, 4, 'Eastern Cape v Garden Route Badgers / Oct  2 2022  6:00PM (IST)', 'True', 'True', 0, 0, 0, 0, 0, 0, 'True', 'True', 1, 0, '2022-10-02 13:07:33', NULL, NULL, 1, 0),
(13, '462019580', 462019580, 1.46201958, 4, 'TKR XI v JT XI / Oct  2 2022  6:00PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 0, '2022-10-02 13:07:33', NULL, NULL, 1, 0),
(14, '31808579', 31808579, 1.204533002, 4, 'Thailand Women v UAE Women / Oct  7 2022  8:30AM (IST)', 'True', 'False', 0, 1.01, 1000, 0, 0, 0, 'True', 'True', 1, 0, '2022-10-07 06:08:22', NULL, NULL, 1, 0),
(15, '462019657', 462019657, 1.462019657, 4, 'TKR XI v JT XI / Oct  7 2022 11:05AM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'False', 'True', 0, 0, '2022-10-07 06:08:22', NULL, NULL, 1, 0),
(16, '31808580', 31808580, 1.204533259, 4, 'India Women v Pakistan Women / Oct  7 2022  1:00PM (IST)', 'False', 'False', 1.11, 1.12, 9.4, 10, 0, 0, 'True', 'True', 1, 0, '2022-10-07 06:08:22', NULL, NULL, 1, 0),
(17, '31799893', 31799893, 1.204504833, 4, 'New Zealand v Pakistan / Oct  8 2022 11:40AM (IST)', 'True', 'True', 14, 15, 1.07, 1.08, 0, 0, 'True', 'True', 1, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(18, '561010128', 561010128, 1.561010128, 4, 'Melbourne Stars XI  v Brisbane Heat XI  / Oct  8 2022 12:25PM (IST)', 'True', 'False', 0, 0, 0, 0, 0, 0, 'True', 'True', 0, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(19, '31808593', 31808593, 1.204533595, 4, 'Bangladesh Women v India Women / Oct  8 2022  1:00PM (IST)', 'True', 'True', 70, 75, 1.01, 1.02, 0, 0, 'True', 'True', 1, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(20, '1710071626', 1710071626, 1.171007162727, 4, 'Gujranwala Giants v Bahawalpur Royals / Oct  8 2022  8:30PM (IST)', 'False', 'False', 0, 0, 0, 0, 0, 0, 'False', 'False', 1, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(21, '31811790', 31811790, 1.204599986, 4, 'Malaysia Women v Thailand Women / Oct  9 2022  8:30AM (IST)', 'False', 'False', 3.3, 11, 1.1, 1.43, 0, 0, 'False', 'True', 1, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(22, '31799905', 31799905, 1.204505066, 4, 'New Zealand v Bangladesh / Oct  9 2022 11:40AM (IST)', 'False', 'False', 1.19, 1.24, 5.2, 6.4, 0, 0, 'False', 'False', 1, 0, '2022-10-08 08:53:13', NULL, NULL, 1, 0),
(23, '31859939', 31859939, 1.205888215, NULL, 'Ireland v New Zealand / Nov  4 2022  9:30AM (IST)', 'True', 'True', 13.5, 14, 1.07, 1.08, 0, 0, 'True', 'True', 1, 0, '2022-11-04 05:06:09', NULL, NULL, 1, 0),
(24, '31846570', 31846570, 1.205925641, NULL, 'Sydney Thunder WBBL v Brisbane Heat WBBL / Nov  4 2022 10:00AM (IST)', 'True', 'True', 3.2, 3.25, 1.45, 1.46, 0, 0, 'True', 'True', 1, 0, '2022-11-04 05:06:09', NULL, NULL, 1, 0),
(25, NULL, NULL, NULL, NULL, 'Eastern Cape vs Tuskers, 11th Match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2022-12-14 06:27:24', NULL, NULL, 1, 0),
(26, NULL, NULL, NULL, NULL, 'Eastern Cape vs Tuskers, 11th Match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2022-12-14 06:28:14', NULL, NULL, 1, 0),
(27, NULL, NULL, NULL, NULL, 'Rwanda vs Tanzania, 1st Match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2022-12-14 06:32:27', NULL, NULL, 1, 0),
(28, NULL, NULL, NULL, NULL, 'Namibia vs Nepal, 2nd Match', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2022-12-14 06:44:16', NULL, NULL, 1, 0);

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

--
-- Table structure for table `tbl_view_soccer_match`
--

CREATE TABLE `tbl_view_soccer_match` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_checked_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `game_type_id` int(11) DEFAULT '2',
  `league_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `league_name` varchar(500) DEFAULT NULL,
  `home_name` varchar(500) DEFAULT NULL,
  `away_name` varchar(500) DEFAULT NULL,
  `location` varchar(500) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `short_name` varchar(500) DEFAULT NULL,
  `is_deleted` int(11) NOT NULL DEFAULT '0',
  `run_status` varchar(50) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- 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 `tbl_admin_ac_statement`
--
ALTER TABLE `tbl_admin_ac_statement`
  ADD PRIMARY KEY (`id`);

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- 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=16;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_manage_code`



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

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

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

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

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

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

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

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

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

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

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

