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

START TRANSACTION;



--
-- Database: `dalanlotto`
--

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

--
-- Table structure for table `adminDetail`
--

CREATE TABLE `adminDetail` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `parentId` int NOT NULL,
  `isSuperAdmin` tinyint(1) NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `adminDetail`
--

INSERT INTO `adminDetail` (`id`, `userId`, `parentId`, `isSuperAdmin`, `name`, `image`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, 0, 1, 'Super Admin', '78912660-42f4-4e9a-90b8-b92b98f8b06f.png', 0, 1686740457, '2022-05-02 00:55:27', '2023-06-14 11:00:57'),
(8, 44, 0, 0, 'Nitin Lotto', '2f608992-bb0b-486d-8096-386300fa0e87.svg', 1686739944, 1686740178, '2023-06-14 10:52:23', '2023-06-14 10:56:18'),
(9, 45, 1, 0, 'Manager on', '0c89c844-3ca3-4363-acc2-99c086aaf219.jpeg', 1686902766, 1686902897, '2023-06-16 08:06:06', '2023-06-17 16:49:10'),
(12, 48, 1, 0, 'Udit', '5d2617d3-574c-4f8c-af90-a835171604ab.jpeg', 1687055233, 1687055233, '2023-06-18 02:27:12', '2023-06-18 02:27:12'),
(13, 49, 0, 0, 'DALAN LOTTO', 'ea04b73a-8b90-4d65-8480-a4eb966d8633.jpeg', 1687213336, 1687453711, '2023-06-19 22:22:16', '2023-06-22 17:08:31'),
(14, 50, 49, 0, 'Obenel surin', '2b5c5a63-eac6-4a5b-aa5a-a9e190631789.jpeg', 1687453680, 1687453680, '2023-06-22 17:08:00', '2023-06-22 17:08:00');

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

--
-- Table structure for table `agentDetail`
--

CREATE TABLE `agentDetail` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `adminId` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agentDetail`
--

INSERT INTO `agentDetail` (`id`, `userId`, `adminId`, `name`, `image`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 84, 1, 'Nitin Agant', '7c436b67-e04b-490f-ad4f-9ce7c729d4ec.svg', 1690807269, 1690807269, '2023-07-31 12:41:08', '2023-07-31 12:41:08'),
(2, 85, 1, 'Mukesh', 'de884e44-d36f-406c-8edd-949c8fe0fa72.jpeg', 1690861351, 1690861351, '2023-08-01 03:42:31', '2023-08-01 03:42:31'),
(3, 86, 1, 'Mukesh', 'ecf19d50-ff00-40f3-bad9-42fb7753f046.jpeg', 1690861407, 1690861407, '2023-08-01 03:43:27', '2023-08-01 03:43:27'),
(4, 87, 1, 'Mohan Das Karamchand', 'ec9f8e5d-dd3b-43e8-a1cf-eda973d04e2b.jpeg', 1690861535, 1690861591, '2023-08-01 03:45:34', '2023-08-01 03:46:31'),
(5, 88, 1, 'Angelina', '4f020f82-a77c-42a4-afb2-c826d5756b32.jpeg', 1690861633, 1690861633, '2023-08-01 03:47:13', '2023-08-01 03:47:13'),
(6, 89, 1, 'Angelina', '9033f58c-21e7-49d8-9245-ae7fd2975170.jpeg', 1690861724, 1690861724, '2023-08-01 03:48:43', '2023-08-01 03:48:43'),
(7, 90, 1, 'Martin', '063acaa1-2bd5-4076-8744-c4b29225c05c.jpeg', 1690863411, 1690863411, '2023-08-01 04:16:50', '2023-08-01 04:16:50'),
(8, 92, 1, 'Nitin Agent', 'e4ba0f3c-77cd-477d-b29c-9ccf17a13414.png', 1690868595, 1690868595, '2023-08-01 05:43:15', '2023-08-01 05:43:15'),
(9, 93, 1, 'Joshua Hernandez', '', 1690940617, 1690940617, '2023-08-02 01:43:37', '2023-08-02 01:43:37');

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int NOT NULL,
  `userId` int NOT NULL COMMENT 'customer id',
  `productId` int NOT NULL,
  `quantity` smallint NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`id`, `userId`, `productId`, `quantity`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(3, 30, 5, 3, 1684436408, 1684437245, '2023-05-18 19:00:07', '2023-05-18 19:14:04'),
(15, 30, 6, 1, 1684439929, 1684439929, '2023-05-18 19:58:48', '2023-05-18 19:58:48');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=>inactive, 1=>active',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `status`, `title`, `image`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, 'Medical and Recreational', 'medical-and-recreational.png', 1684426428, 1684426428, '2023-05-18 16:13:48', '2023-05-18 16:19:51');

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

--
-- Table structure for table `interest`
--

CREATE TABLE `interest` (
  `id` int NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=>inactive, 1=>active',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interest`
--

INSERT INTO `interest` (`id`, `status`, `title`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, 'Foodie', 1683938449, 1683938672, '2023-05-13 00:40:48', '2023-05-13 00:44:31'),
(2, 1, 'Travel', 1683938682, 1683938682, '2023-05-13 00:44:42', '2023-05-13 00:44:42'),
(3, 1, 'Art', 1683938691, 1683941275, '2023-05-13 00:44:51', '2023-05-13 01:27:55'),
(4, 1, 'Cook', 1683938709, 1683938709, '2023-05-13 00:45:09', '2023-05-13 00:45:09'),
(5, 1, 'Dance', 1683938723, 1683938723, '2023-05-13 00:45:23', '2023-05-13 00:45:23'),
(6, 1, 'Yoga', 1683938736, 1683938736, '2023-05-13 00:45:35', '2023-05-13 00:45:35'),
(7, 1, 'Running', 1683938752, 1683938752, '2023-05-13 00:45:52', '2023-05-13 00:45:52'),
(8, 1, 'Festival', 1683938772, 1683938772, '2023-05-13 00:46:12', '2023-05-13 00:46:12'),
(9, 1, 'Surfing', 1683938782, 1683938782, '2023-05-13 00:46:22', '2023-05-13 00:46:22'),
(10, 1, 'Pubg', 1683938822, 1686720423, '2023-05-13 00:47:02', '2023-06-14 05:27:03'),
(27, 1, 'jab', 1686720429, 1686720429, '2023-06-14 05:27:09', '2023-06-14 05:27:09');

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

--
-- Table structure for table `lottery`
--

CREATE TABLE `lottery` (
  `id` int NOT NULL,
  `adminId` int NOT NULL,
  `lotteryCompanyId` int NOT NULL,
  `lotteryType` tinyint NOT NULL COMMENT '1=>static-ticket-price\r\n2=>flexible-ticket-price',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastDateToPurchase` datetime NOT NULL,
  `lotteryResultDate` datetime NOT NULL,
  `priceOfTicket` decimal(7,2) NOT NULL,
  `totalTickets` int NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lottery`
--

INSERT INTO `lottery` (`id`, `adminId`, `lotteryCompanyId`, `lotteryType`, `title`, `description`, `lastDateToPurchase`, `lotteryResultDate`, `priceOfTicket`, `totalTickets`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(5, 44, 5, 1, 'New york 2021', '<p>this is lottry. this is lottry. this is lottry. this is lottry. this is lottry. this is lottry. this is lottry. this is lottry. this is lottry. this is lottry.&nbsp;</p>', '2023-06-16 00:00:00', '2023-06-21 00:00:00', 33.00, 12, 1686740879, 1686740879, '2023-06-14 11:07:58', '2023-06-14 11:07:58'),
(6, 1, 3, 2, 'Testing lottery', '<p>this is just a test</p>', '2023-08-14 00:00:00', '2023-08-14 00:00:00', 10.00, 0, 1691475756, 1691475756, '2023-08-08 06:22:35', '2023-08-20 14:47:48'),
(8, 1, 8, 2, 'Florida PM Fixed', '<p>&nbsp;Florida PM Fixed Florida PM Fixed Florida PM Fixed Florida PM Fixed Florida PM Fixed&nbsp; 420</p>', '2023-08-23 13:30:00', '2023-08-23 13:31:00', 100.00, 0, 1692583763, 1692836635, '2023-08-21 02:09:22', '2023-08-24 00:23:55'),
(9, 1, 8, 2, 'Florida soir', '<p>Florida soir</p>', '2023-08-25 21:40:00', '2023-08-25 21:45:00', 0.00, 0, 1692655141, 1692987958, '2023-08-21 21:59:01', '2023-08-25 18:25:57'),
(10, 1, 7, 2, 'Florida matin', '<p>Florida matin</p>', '2023-08-22 13:28:00', '2023-08-22 13:30:00', 0.00, 0, 1692655625, 1692749446, '2023-08-21 22:07:05', '2023-08-23 00:10:45'),
(11, 1, 5, 2, 'New York matin', '<p>New York matin</p>', '2023-08-25 14:28:00', '2023-08-25 14:30:00', 0.00, 0, 1692655744, 1692987830, '2023-08-21 22:09:04', '2023-08-25 18:23:49'),
(12, 1, 6, 2, 'New York soir', '<p>New York soir</p>', '2023-08-25 21:40:00', '2023-08-25 21:45:00', 0.00, 0, 1692663219, 1692985838, '2023-08-22 00:13:39', '2023-08-25 17:50:37'),
(13, 1, 11, 1, 'DALAN ball jackpot', '<p>Dl</p>', '2023-08-25 13:00:00', '2023-08-25 13:30:00', 5.00, 0, 1692663311, 1692988087, '2023-08-22 00:15:11', '2023-08-25 18:28:06'),
(14, 1, 8, 2, 'Wallet F L', '<p>this is test this is test this is test this is test this is test this is test this is test this is test this is test this is test this is test&nbsp;</p>', '2023-08-25 00:00:00', '2023-08-26 00:00:00', 0.00, 0, 1692770656, 1692770656, '2023-08-23 06:04:15', '2023-08-23 06:04:15'),
(15, 1, 5, 1, 'New York Static', '<pre style=\"font-family: &quot;JetBrains Mono&quot;, monospace; font-size: 9.8pt;\"><font color=\"#871094\">hello test </font>hello test hello test hello test hello test </pre>', '2023-08-27 10:09:00', '2023-08-29 07:06:00', 100.00, 0, 1692777416, 1692777416, '2023-08-23 07:56:56', '2023-08-23 07:56:56'),
(16, 1, 7, 2, 'Florida Flexi', '<p>This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test This is test&nbsp;</p>', '2023-08-29 20:09:00', '2023-08-30 00:00:00', 0.00, 0, 1693309295, 1693309295, '2023-08-29 11:41:35', '2023-08-29 11:41:35'),
(17, 1, 8, 2, 'Nitin Test Flexi', '<p>Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery. Nitin Test Flexi lottery.&nbsp;<br></p>', '2023-09-03 00:00:00', '2023-09-05 00:00:00', 0.00, 0, 1693652028, 1693652028, '2023-09-02 10:53:47', '2023-09-02 10:53:47');

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

--
-- Table structure for table `lotteryCompany`
--

CREATE TABLE `lotteryCompany` (
  `id` int NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryCompany`
--

INSERT INTO `lotteryCompany` (`id`, `title`, `image`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(2, 'ABC Lottery Company', '8c09f105-c7a9-4ba0-863f-f07a665b5c7a.jpeg', 1686722958, 1686722958, '2023-06-14 06:09:18', '2023-06-14 06:09:18'),
(3, 'XYZ lotter company', 'b7fe4e9e-af02-4d8d-b16e-d48d9bd43382.avif', 1686723041, 1686723363, '2023-06-14 06:10:40', '2023-06-14 06:16:02'),
(5, 'New York matin', '963ad62b-6249-416a-998f-0c47aeeeb27e.png', 1686740429, 1692703260, '2023-06-14 11:00:29', '2023-08-22 11:21:00'),
(6, 'New York soir', 'f32d7e6f-850d-41b5-88a2-efad454a0ebd.png', 1687003690, 1692703244, '2023-06-17 12:08:10', '2023-08-22 11:20:43'),
(7, 'Florida matin', '10eb2827-eddc-45fb-acc4-ac5a5fcfe06a.jpeg', 1687003767, 1692703288, '2023-06-17 12:09:26', '2023-08-22 11:21:28'),
(8, 'Florida soir', '34f2956a-b5d8-4308-84e8-bf40cb7da5c4.jpeg', 1687003798, 1692703276, '2023-06-17 12:09:57', '2023-08-22 11:21:15'),
(9, 'Power ball ny', 'e97e791b-76f3-47a0-9fe6-aab569a41087.jpeg', 1687003854, 1688483386, '2023-06-17 12:10:53', '2023-07-04 15:09:46'),
(10, 'Mega millions', 'be57f3bd-0ba1-4941-8da9-c0fc59029cd7.png', 1687865925, 1687865925, '2023-06-27 11:38:45', '2023-06-27 11:38:45'),
(11, 'Dalan lotto jackpot matin', 'a90665ff-465b-412e-9353-e5de240311bd.jpeg', 1688299951, 1692529780, '2023-07-02 12:12:30', '2023-08-20 11:09:39');

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

--
-- Table structure for table `lotteryFlexibleTypes`
--

CREATE TABLE `lotteryFlexibleTypes` (
  `id` int NOT NULL,
  `type` tinyint NOT NULL,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryFlexibleTypes`
--

INSERT INTO `lotteryFlexibleTypes` (`id`, `type`, `title`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, 'Borlette', 1693161163, 1693161163, '2023-08-27 18:32:43', '2023-08-27 18:32:43'),
(2, 2, 'Mariage', 1693161163, 1693161163, '2023-08-27 18:32:43', '2023-08-27 18:59:19'),
(3, 3, 'Lotto 3', 1693161163, 1693161163, '2023-08-27 18:32:43', '2023-08-27 18:32:43'),
(4, 4, 'Lotto 4', 1693161163, 1693161163, '2023-08-27 18:32:43', '2023-08-27 18:32:43'),
(5, 5, 'Lotto 5', 1693161163, 1693161163, '2023-08-27 18:32:43', '2023-08-27 18:32:43');

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

--
-- Table structure for table `lotteryNumberLimit`
--

CREATE TABLE `lotteryNumberLimit` (
  `id` int NOT NULL,
  `type` tinyint NOT NULL,
  `limit` int NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryNumberLimit`
--

INSERT INTO `lotteryNumberLimit` (`id`, `type`, `limit`, `name`, `description`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, 15000, 'borlette', 'two digit number (55)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:47:28'),
(2, 2, 1000, 'mariage', '23X33 ', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 20:14:18'),
(3, 3, 1000, 'lotto3', 'three digit number (655)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 20:14:18'),
(4, 4, 1000, 'lotto4', 'four digit number (6455)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 20:14:18'),
(5, 5, 1, 'lotto5', 'five digit number (63455)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 20:14:18');

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

--
-- Table structure for table `lotteryPurchase`
--

CREATE TABLE `lotteryPurchase` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `ticketSellerId` int NOT NULL,
  `lotteryId` int NOT NULL,
  `b1` int NOT NULL,
  `b2` int NOT NULL,
  `b3` int NOT NULL,
  `b4` int NOT NULL,
  `b5` int NOT NULL,
  `b6` int NOT NULL,
  `ticketCost` decimal(7,2) NOT NULL,
  `appServiceCharge` decimal(7,2) NOT NULL,
  `finalAmount` decimal(7,2) NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryPurchase`
--

INSERT INTO `lotteryPurchase` (`id`, `userId`, `ticketSellerId`, `lotteryId`, `b1`, `b2`, `b3`, `b4`, `b5`, `b6`, `ticketCost`, `appServiceCharge`, `finalAmount`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 29, 0, 1, 10, 20, 30, 40, 50, 60, 41.00, 1.00, 42.00, 1692542750, 1692542750, '2023-08-20 14:45:50', '2023-08-20 14:45:50'),
(2, 29, 0, 6, 0, 0, 0, 0, 0, 0, 41.00, 1.00, 42.00, 1692542880, 1692542880, '2023-08-20 14:47:59', '2023-08-20 14:47:59'),
(3, 94, 0, 14, 0, 0, 0, 0, 0, 0, 115.00, 1.00, 116.00, 1692770692, 1692770692, '2023-08-23 06:04:52', '2023-08-23 06:04:52'),
(4, 94, 0, 15, 10, 20, 30, 40, 50, 60, 100.00, 1.00, 101.00, 1692777816, 1692777816, '2023-08-23 08:03:36', '2023-08-23 08:03:36'),
(5, 96, 0, 15, 368, 25, 69, 48, 99, 50, 100.00, 1.00, 101.00, 1692803424, 1692803424, '2023-08-23 15:10:24', '2023-08-23 15:10:24'),
(6, 96, 0, 14, 0, 0, 0, 0, 0, 0, 250.00, 1.00, 251.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(7, 96, 0, 17, 0, 0, 0, 0, 0, 0, 160.00, 1.00, 161.00, 1693652181, 1693652181, '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(8, 95, 0, 17, 0, 0, 0, 0, 0, 0, 70.00, 1.00, 71.00, 1693652470, 1693652470, '2023-09-02 11:01:10', '2023-09-02 11:01:10');

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

--
-- Table structure for table `lotteryPurchaseFlexibleTickets`
--

CREATE TABLE `lotteryPurchaseFlexibleTickets` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `lotteryPurchaseId` int NOT NULL,
  `lotteryId` int NOT NULL,
  `type` tinyint NOT NULL,
  `number` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(7,2) NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryPurchaseFlexibleTickets`
--

INSERT INTO `lotteryPurchaseFlexibleTickets` (`id`, `userId`, `lotteryPurchaseId`, `lotteryId`, `type`, `number`, `amount`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 29, 2, 6, 1, '20', 30.50, 1692542880, 1692542880, '2023-08-20 14:47:59', '2023-08-20 14:47:59'),
(2, 29, 2, 6, 2, '25', 10.50, 1692542880, 1692542880, '2023-08-20 14:47:59', '2023-08-20 14:47:59'),
(3, 94, 3, 14, 12, '36', 100.00, 1692770692, 1692770692, '2023-08-23 06:04:52', '2023-08-23 06:04:52'),
(4, 94, 3, 14, 12, '5', 15.00, 1692770692, 1692770692, '2023-08-23 06:04:52', '2023-08-23 06:04:52'),
(5, 96, 6, 14, 1, '36', 20.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(6, 96, 6, 14, 3, '966', 30.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(7, 96, 6, 14, 4, '6358', 40.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(8, 96, 6, 14, 2, '63', 40.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(9, 96, 6, 14, 5, '69845', 60.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(10, 96, 6, 14, 5, '54896', 60.00, 1692803507, 1692803507, '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(11, 96, 7, 17, 1, '33', 10.00, 1693652181, 1693652181, '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(12, 96, 7, 17, 2, '36X55', 50.00, 1693652181, 1693652181, '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(13, 96, 7, 17, 5, '55555', 100.00, 1693652181, 1693652181, '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(14, 95, 8, 17, 1, '25', 10.00, 1693652470, 1693652470, '2023-09-02 11:01:10', '2023-09-02 11:01:10'),
(15, 95, 8, 17, 2, '25X36', 20.00, 1693652470, 1693652470, '2023-09-02 11:01:10', '2023-09-02 11:01:10'),
(16, 95, 8, 17, 4, '2596', 40.00, 1693652470, 1693652470, '2023-09-02 11:01:10', '2023-09-02 11:01:10');

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

--
-- Table structure for table `lotteryPurchaseWinner`
--

CREATE TABLE `lotteryPurchaseWinner` (
  `id` int NOT NULL,
  `lotteryPurchaseId` int NOT NULL,
  `userId` int NOT NULL,
  `lotteryId` int NOT NULL,
  `ticketSellerId` int NOT NULL,
  `ticketNumber` int NOT NULL,
  `winnerPositionNo` int NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lotteryResult`
--

CREATE TABLE `lotteryResult` (
  `id` int NOT NULL,
  `lotteryId` int NOT NULL,
  `lotto` mediumint NOT NULL,
  `place1st` mediumint NOT NULL,
  `place2nd` mediumint NOT NULL,
  `place3rd` mediumint NOT NULL,
  `b1` int NOT NULL,
  `b2` int NOT NULL,
  `b3` int NOT NULL,
  `b4` int NOT NULL,
  `b5` int NOT NULL,
  `b6` int NOT NULL,
  `lotteryResultJson` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryResult`
--

INSERT INTO `lotteryResult` (`id`, `lotteryId`, `lotto`, `place1st`, `place2nd`, `place3rd`, `b1`, `b2`, `b3`, `b4`, `b5`, `b6`, `lotteryResultJson`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 17, 5, 25, 36, 55, 0, 0, 0, 0, 0, 0, '{\"type1BorletteWininngNumber\":[\"25\",\"36\",\"55\"],\"type2MariageWininngNumber\":[\"25X36\",\"36X25\",\"36X55\",\"55X36\",\"25X55\",\"55X25\"],\"type3Lotto3WininngNumber\":\"525\",\"type4Lotto4WininngNumber\":\"3655\",\"type5Lotto5WininngNumber\":\"52536\",\"userIdBasedWinningAmounts\":{\"95\":500,\"96\":1000}}', 1693653364, 1693653364, '2023-09-02 11:16:03', '2023-09-02 11:16:03');

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

--
-- Table structure for table `lotteryWinningPrize`
--

CREATE TABLE `lotteryWinningPrize` (
  `id` int NOT NULL,
  `type` tinyint NOT NULL,
  `prize` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lotteryWinningPrize`
--

INSERT INTO `lotteryWinningPrize` (`id`, `type`, `prize`, `name`, `description`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 1, '60|20|10', 'borlette', 'two digit number (55)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:46:48'),
(2, 2, '1000', 'mariage', '23X33 ', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:46:48'),
(3, 3, '500', 'lotto3', 'three digit number (655)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:46:48'),
(4, 4, '5000', 'lotto4', 'four digit number (6455)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:46:48'),
(5, 5, '25000', 'lotto5', 'five digit number (63455)', 1693161164, 1693161164, '2023-08-27 18:37:02', '2023-09-02 12:46:48');

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int NOT NULL,
  `type` tinyint NOT NULL,
  `byUserId` int NOT NULL,
  `toUserId` int NOT NULL,
  `lotteryId` int NOT NULL,
  `text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notificationData` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `isRead` tinyint NOT NULL COMMENT '0=>not_read, 1=>read',
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `type`, `byUserId`, `toUserId`, `lotteryId`, `text`, `notificationData`, `isRead`, `createdAt`, `updatedAt`) VALUES
(1, 1, 89, 29, 0, 'Agent: Angelina sent you OTP for withdrawing $10. Your OTP is: 1111', '{}', 0, '2023-08-01 03:50:26', '2023-08-01 03:50:26'),
(2, 2, 89, 29, 0, 'You have withdrawn $100 through agent Angelina.', '{}', 0, '2023-08-01 03:50:44', '2023-08-01 03:50:44'),
(3, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $5000. Your OTP is: 1111', '{}', 0, '2023-08-01 06:04:46', '2023-08-01 06:04:46'),
(4, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $550. Your OTP is: 1111', '{}', 0, '2023-08-01 06:06:57', '2023-08-01 06:06:57'),
(5, 2, 92, 53, 0, 'You have withdrawn $550 through agent Nitin Agent.', '{}', 0, '2023-08-01 06:08:18', '2023-08-01 06:08:18'),
(6, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $100. Your OTP is: 1111', '{}', 0, '2023-08-01 06:18:00', '2023-08-01 06:18:00'),
(7, 2, 92, 53, 0, 'You have withdrawn $100 through agent Nitin Agent.', '{}', 0, '2023-08-01 06:18:04', '2023-08-01 06:18:04'),
(8, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $4000. Your OTP is: 1111', '{}', 0, '2023-08-01 14:07:12', '2023-08-01 14:07:12'),
(9, 2, 92, 53, 0, 'You have withdrawn $4000 through agent Nitin Agent.', '{}', 0, '2023-08-01 14:07:29', '2023-08-01 14:07:29'),
(10, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $55. Your OTP is: 1111', '{}', 0, '2023-08-01 14:40:25', '2023-08-01 14:40:25'),
(11, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $200. Your OTP is: 1111', '{}', 0, '2023-08-01 17:03:40', '2023-08-01 17:03:40'),
(12, 2, 92, 53, 0, 'You have withdrawn $200 through agent Nitin Agent.', '{}', 0, '2023-08-01 17:03:45', '2023-08-01 17:03:45'),
(13, 1, 92, 53, 0, 'Agent: Nitin Agent sent you OTP for withdrawing $120. Your OTP is: 1111', '{}', 0, '2023-08-01 17:05:59', '2023-08-01 17:05:59'),
(14, 2, 92, 53, 0, 'You have withdrawn $120 through agent Nitin Agent.', '{}', 0, '2023-08-01 17:06:13', '2023-08-01 17:06:13'),
(15, 1, 93, 60, 0, 'Agent: Joshua Hernandez sent you OTP for withdrawing $1000. Your OTP is: 1111', '{}', 0, '2023-08-02 11:39:23', '2023-08-02 11:39:23'),
(16, 3, 1, 95, 0, '$500 amount won from the lottery \"Nitin Test Flexi\"', '{}', 0, '2023-09-02 11:16:03', '2023-09-02 11:16:03'),
(17, 3, 1, 96, 0, '$1000 amount won from the lottery \"Nitin Test Flexi\"', '{}', 0, '2023-09-02 11:16:03', '2023-09-02 11:16:03');

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

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `userAddressId` int NOT NULL,
  `orderType` tinyint NOT NULL COMMENT '0=>delivery, 1=>reserve',
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id`, `userId`, `userAddressId`, `orderType`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 30, 14, 1, 1684726178, 1684726178, '2023-05-22 03:29:37', '2023-05-22 03:29:37');

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

--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int NOT NULL,
  `accessor` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `accessor`, `title`, `content`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 'aboutUs', 'About Us', '<h1 style=\"color: rgb(0, 0, 0);\"><span style=\"font-size: 36px;\">About Us</span></h1><h1 style=\"color: rgb(0, 0, 0);\"><span style=\"font-size: 14px; font-weight: normal;\">Sudah merupakan fakta bahwa seorang pembaca akan terpengaruh oleh isi tulisan dari sebuah halaman saat ia melihat tata letaknya. Maksud penggunaan Lorem Ipsum adalah karena ia kurang lebih memiliki penyebaran huruf yang normal, ketimbang menggunakan kalimat seperti \"Bagian isi disini, bagian isi disini\", sehingga ia seolah menjadi naskah Inggris yang bisa dibaca. Banyak paket Desktop Publishing dan editor situs web yang kini menggunakan Lorem Ipsum sebagai contoh teks. Karenanya pencarian terhadap kalimat \"Lorem Ipsum\" akan berujung pada banyak situs web yang masih dalam tahap pengembangan. Berbagai versi juga telah berubah dari tahun ke tahun, kadang karena tidak sengaja, kadang karena disengaja (misalnya karena dimasukkan unsur humor atau semacamnya)</span></h1>\n<p></p>', 1591716283, 1682862356, '2020-03-23 15:32:10', '2023-04-30 13:45:55'),
(2, 'termsAndConditions', 'Terms & Conditions', '<h1 style=\"color: rgb(0, 0, 0);\"><font face=\"Times New Roman\">Terms And Conditions</font></h1><h1 style=\"color: rgb(0, 0, 0);\"><span style=\"font-size: 14px; font-weight: normal;\">Sudah merupakan fakta bahwa seorang pembaca akan terpengaruh oleh isi tulisan dari sebuah halaman saat ia melihat tata letaknya. Maksud penggunaan Lorem Ipsum adalah karena ia kurang lebih memiliki penyebaran huruf yang normal, ketimbang menggunakan kalimat seperti \"Bagian isi disini, bagian isi disini\", sehingga ia seolah menjadi naskah Inggris yang bisa dibaca. Banyak paket Desktop Publishing dan editor situs web yang kini menggunakan Lorem Ipsum sebagai contoh teks. Karenanya pencarian terhadap kalimat \"Lorem Ipsum\" akan berujung pada banyak situs web yang masih dalam tahap pengembangan. Berbagai versi juga telah berubah dari tahun ke tahun, kadang karena tidak sengaja, kadang karena disengaja (misalnya karena dimasukkan unsur humor atau semacamnya)</span><font face=\"Times New Roman\"><br></font></h1>\n<p></p>\n<p></p>\n<p></p>', 1591716283, 1682862310, '2020-03-23 15:32:39', '2023-04-30 13:45:09'),
(3, 'privacyPolicy', 'Privacy Policy', '<h1 style=\"color: rgb(0, 0, 0); font-family: Times;\">Privacy Policy</h1><h1 style=\"color: rgb(0, 0, 0);\"><span style=\"font-size: 14px; font-weight: normal;\">Sudah merupakan fakta bahwa seorang pembaca akan terpengaruh oleh isi tulisan dari sebuah halaman saat ia melihat tata letaknya. Maksud penggunaan Lorem Ipsum adalah karena ia kurang lebih memiliki penyebaran huruf yang normal, ketimbang menggunakan kalimat seperti \"Bagian isi disini, bagian isi disini\", sehingga ia seolah menjadi naskah Inggris yang bisa dibaca. Banyak paket Desktop Publishing dan editor situs web yang kini menggunakan Lorem Ipsum sebagai contoh teks. Karenanya pencarian terhadap kalimat \"Lorem Ipsum\" akan berujung pada banyak situs web yang masih dalam tahap pengembangan. Berbagai versi juga telah berubah dari tahun ke tahun, kadang karena tidak sengaja, kadang karena disengaja (misalnya karena dimasukkan unsur humor atau semacamnya)</span></h1>', 1591716283, 1682862329, '2020-03-23 15:33:04', '2023-04-30 13:45:28');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=>inactive, 1=>active',
  `userId` int NOT NULL COMMENT 'id of the seller',
  `categoryId` int NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(9,2) NOT NULL,
  `date` date NOT NULL COMMENT 'YYYY-MM-DD',
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `status`, `userId`, `categoryId`, `title`, `description`, `price`, `date`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(5, 1, 34, 1, 'Ice Cream Cake', 'A very reacreational ice cream cake', 10.00, '2023-05-20', 1684434463, 1684434463, '2023-05-18 18:27:42', '2023-05-18 18:27:42'),
(6, 1, 34, 1, 'Skin Cream', 'A skin recreational cream', 20.00, '2023-05-21', 1684436481, 1684436481, '2023-05-18 19:01:20', '2023-05-18 19:01:20');

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

--
-- Table structure for table `productImages`
--

CREATE TABLE `productImages` (
  `id` int NOT NULL,
  `productId` int NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `productImages`
--

INSERT INTO `productImages` (`id`, `productId`, `image`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(7, 5, '95e00d6a-9e2f-4b0b-8a2e-917f17180479.jpeg', 1684434463, 1684434463, '2023-05-18 18:27:42', '2023-05-18 18:27:42'),
(8, 5, 'd3e8ceb6-94e5-4c59-aa73-b9f3cbec34e3.webp', 1684434463, 1684434463, '2023-05-18 18:27:42', '2023-05-18 18:27:42'),
(9, 6, 'c298fba1-3a09-41b3-8039-11fb0afd1c2a.webp', 1684436481, 1684436481, '2023-05-18 19:01:20', '2023-05-18 19:01:20'),
(10, 6, 'c7327bc2-2511-4be1-baab-e5d855c1b9b9.jpeg', 1684436481, 1684436481, '2023-05-18 19:01:20', '2023-05-18 19:01:20');

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

--
-- Table structure for table `sellerDetail`
--

CREATE TABLE `sellerDetail` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `freeDeliveryAmount` decimal(7,2) NOT NULL,
  `delivery` tinyint NOT NULL COMMENT '0=>no, 1=>yes',
  `websiteLink` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sellerDetail`
--

INSERT INTO `sellerDetail` (`id`, `userId`, `name`, `image`, `freeDeliveryAmount`, `delivery`, `websiteLink`, `latitude`, `longitude`, `location`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(4, 34, 'The Recreational3', 'f94c52f6-d7c3-4f2a-9cfc-2caaaca4d682.jpeg', 30.00, 1, 'https://google.com/', 30.01312311, 76.13511231, 'Chandigarh', 1684223946, 1684223946, '2023-05-16 07:59:05', '2023-05-16 07:59:05');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `name`, `value`, `comment`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 'maximum_site_commission', '1', 'USD', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-26 06:54:31'),
(2, 'global_delivery_charge_for_seller', '2', 'USD', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-09-21 11:29:44'),
(3, 'global_delivery_charge_for_delivery_staff', '3', 'USD', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-26 06:54:31'),
(4, 'enable_disable_referral_system', '1', '0=>disabled 1=>enabled', 1592274435, 1592274435, '2020-06-16 02:27:15', '2021-06-29 09:41:54'),
(5, 'referral_reward_points_for_drivers', '1..g', 'number', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-09-21 11:22:08'),
(6, 'referral_signup_bonus_for_drivers', '2', 'number', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-26 07:03:35'),
(7, 'enable_disable_promo_code', '1', '0=>disabled 1=>enabled', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-09-21 11:22:00'),
(8, 'promo_code', 'XJKSDS923S', 'promo code text', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-16 02:36:37'),
(9, 'apply_on_category', '1', '0=>no 1=>yes', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-09-21 11:22:29'),
(11, 'promo_code_discount_value', '200grdhbtrhth', 'in %', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-09-21 11:22:33'),
(12, 'duration_of_promo_code', '201', '', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-23 11:19:33'),
(13, 'notification_email', 'test@gmail.com', 'email for notification and updates', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-06-23 11:20:04'),
(14, 'tax_category', 'GST', '', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-08-26 08:07:51'),
(15, 'tax_percentage', '10', 'in %', 1592274435, 1592274435, '2020-06-16 02:27:15', '2020-08-26 08:07:51'),
(16, 'rewardsToEuroConversionRate', '100', 'How many rewards to 1 Euro', 1592274435, 1592274435, '2020-06-16 02:27:15', '2022-10-03 08:59:55'),
(17, 'rewardsPerBooking', '20', 'How many rewards per booking', 1592274435, 1592274435, '2020-06-16 02:27:15', '2022-10-03 08:59:55'),
(18, 'rewardsDescription', '<p style=\"outline: none; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 10px 0px 0px; font-size: 16px; line-height: 2.12; color: rgb(45, 42, 43); font-family: Poppins, sans-serif;\">🏅 ➛ 💵</p>', 'Description of rewards', 1592274435, 1592274435, '2020-06-16 02:27:15', '2023-02-06 00:06:53');

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

--
-- Table structure for table `ticketSellerDetail`
--

CREATE TABLE `ticketSellerDetail` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `adminId` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticketSellerDetail`
--

INSERT INTO `ticketSellerDetail` (`id`, `userId`, `adminId`, `name`, `image`, `latitude`, `longitude`, `location`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(1, 34, 1, 'Markus', 'c5c5dd47-05c8-4d22-b70f-9a2f1ef63e21.jpeg', 30.92342300, 76.23923500, 'Mohali Pind', 1686720185, 1686720185, '2023-06-14 05:23:05', '2023-06-14 08:37:55'),
(2, 51, 44, 'Lucy', '4ba98477-e9e6-4245-856d-92b0b2f383f2.jpeg', 30.92342300, 76.23923500, 'Mohali Pind', 1686720185, 1686720185, '2023-06-14 05:23:05', '2023-07-03 07:12:15'),
(3, 52, 1, 'Manzo Ticket Seller', '8d5525a4-f570-4500-81c2-7fc2112baaf6.jpeg', 30.01312311, 76.13511231, 'Kharar', 1689423312, 1689423312, '2023-07-15 12:15:11', '2023-07-15 12:15:11'),
(4, 54, 1, 'Halo Ticket Seller', 'ffa388eb-fe12-476e-bae8-e188610ea2a7.jpeg', 30.01312311, 76.13511231, 'Kharar', 1689424076, 1689424076, '2023-07-15 12:27:55', '2023-07-15 12:27:55'),
(5, 55, 1, 'Nitin tic seller', 'eddcc654-b0e7-42e8-96e4-007054f7d676.jpg', 31.70871530, 76.93201040, 'Mandi', 1689426841, 1689597662, '2023-07-15 13:14:01', '2023-07-17 12:41:02'),
(6, 56, 1, 'Matt', 'd3d73374-fe65-4b97-bf57-9ce1955e561d.jpeg', 30.01312311, 76.13511231, 'Mohali', 1689502783, 1689502783, '2023-07-16 10:19:43', '2023-07-16 10:19:43'),
(7, 59, 1, 'seller ticket', 'c955105b-c684-4404-87ca-ed9e02f0c825.jpg', 31.70871530, 76.93201040, 'Mandi', 1689610987, 1689610987, '2023-07-17 16:23:06', '2023-07-17 16:23:06'),
(8, 61, 49, 'Johnsley', '4b64bcfc-2a43-4b2f-aa3d-778aafa84632.jpg', 18.97118700, -72.28521500, 'Haiti', 1689624514, 1689624514, '2023-07-17 20:08:34', '2023-07-17 20:08:34'),
(9, 63, 49, 'josh', '84e482f8-14a7-4b50-abc4-a04cd3991e18.jpg', 18.97118700, -72.28521500, 'Haiti', 1689687291, 1689687291, '2023-07-18 13:34:51', '2023-07-18 13:34:51'),
(10, 64, 49, 'josh', '1f2bca9e-bed3-4953-b8f2-42f837e23246.jpg', 18.97118700, -72.28521500, 'Haiti', 1689687352, 1689687352, '2023-07-18 13:35:52', '2023-07-18 13:35:52'),
(11, 65, 1, 'Mathew Ticket Seller', '85bc44cc-ac0d-4b48-a5ce-eaa10a7f8bba.jpeg', 30.01312311, 76.13511231, 'Kharar', 1689705045, 1689705045, '2023-07-18 18:30:44', '2023-07-18 18:30:44'),
(12, 66, 1, 'Carnage Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705178, 1689705178, '2023-07-18 18:32:58', '2023-07-18 18:32:58'),
(13, 67, 49, 'Carman Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705327, 1689705327, '2023-07-18 18:35:26', '2023-07-18 18:35:26'),
(14, 68, 49, 'Karma Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705550, 1689705550, '2023-07-18 18:39:09', '2023-07-18 18:39:09'),
(15, 69, 49, 'Karma2 Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705734, 1689705734, '2023-07-18 18:42:13', '2023-07-18 18:42:13'),
(16, 70, 49, 'Chamoli Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705758, 1689705758, '2023-07-18 18:42:37', '2023-07-18 18:42:37'),
(17, 71, 49, 'Rob Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689705802, 1689705802, '2023-07-18 18:43:22', '2023-07-18 18:43:22'),
(18, 72, 49, 'Joe', '75440251-fb0d-438e-8b66-084f122e6388.jpg', 18.97118700, -72.28521500, 'Haiti', 1689727837, 1689727837, '2023-07-19 00:50:36', '2023-07-19 00:50:36'),
(19, 73, 49, 'Joe', '4a23ffdc-4f32-44cb-92fe-953980d4c91f.jpg', 18.97118700, -72.28521500, 'Haiti', 1689728021, 1689728021, '2023-07-19 00:53:40', '2023-07-19 00:53:40'),
(20, 74, 49, 'Qikhoe', '2cf7b70e-62b4-4e15-ba6c-20a8643e1f73.jpg', 18.97118700, -72.28521500, 'Haiti', 1689728158, 1689728158, '2023-07-19 00:55:57', '2023-07-19 00:55:57'),
(21, 75, 44, 'Ron Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689742429, 1689742429, '2023-07-19 04:53:48', '2023-07-19 04:53:48'),
(22, 76, 44, 'Don Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689742473, 1689742473, '2023-07-19 04:54:33', '2023-07-19 04:54:33'),
(23, 77, 44, 'Rod Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689742534, 1689742534, '2023-07-19 04:55:33', '2023-07-19 04:55:33'),
(24, 78, 1, 'Tony Ticket Seller', '', 30.01312311, 76.13511231, 'Kharar', 1689742809, 1689742809, '2023-07-19 05:00:08', '2023-07-19 05:00:08'),
(25, 79, 49, 'yoga', '3f551d9f-3f0a-47c8-b3ed-a4f08247c70e.jpg', 31.70871530, 76.93201040, 'Mandi', 1689744823, 1689744823, '2023-07-19 05:33:42', '2023-07-19 05:33:42'),
(26, 81, 49, 'Samotchky Dragenis', 'c59327c8-b4d4-4415-9813-22a15df2a855.jpg', 18.97118700, -72.28521500, 'Haiti', 1689766500, 1689766500, '2023-07-19 11:35:00', '2023-07-19 11:35:00'),
(27, 82, 49, 'Samotchky Dragenis', '8dc8876c-bd9f-458a-8f84-8ace9ee1bca3.jpg', 18.97118700, -72.28521500, 'Haiti', 1689766767, 1689766767, '2023-07-19 11:39:26', '2023-07-19 11:39:26'),
(28, 83, 49, 'bertho', '747fc930-479a-44bd-b742-490a78ad431a.jpg', 18.97118700, -72.28521500, 'Haiti', 1689861151, 1689861151, '2023-07-20 13:52:31', '2023-07-20 13:52:31'),
(29, 98, 49, 'mak', 'f5fd0818-2ecc-4dde-9c6f-08f58008fb62.jpg', 18.97118700, -72.28521500, 'Haiti', 1692836874, 1692836874, '2023-08-24 00:27:54', '2023-08-24 00:27:54');

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

--
-- Table structure for table `userAddress`
--

CREATE TABLE `userAddress` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `completeAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `zipCode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `countryCode` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userAddress`
--

INSERT INTO `userAddress` (`id`, `userId`, `name`, `completeAddress`, `city`, `state`, `country`, `latitude`, `longitude`, `zipCode`, `countryCode`, `phone`, `created`, `updated`, `createdAt`, `updatedAt`) VALUES
(14, 30, 'Jones12', '#123 Street, Abc Building, New York12', 'New York12', 'NY12', 'US21', 23.00000000, 133.00000000, '1413513', '+13', '92342312133', 1684725915, 1684725924, '2023-05-22 03:25:14', '2023-05-22 03:25:23'),
(15, 30, '', '', '', '', '', 0.00000000, 0.00000000, '', '', '', 1684726149, 1684726149, '2023-05-22 03:29:09', '2023-05-22 03:29:09');

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

--
-- Table structure for table `userImages`
--

CREATE TABLE `userImages` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` int NOT NULL,
  `updated` int NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `userWalletTransaction`
--

CREATE TABLE `userWalletTransaction` (
  `id` int NOT NULL,
  `userId` int NOT NULL,
  `sentById` int NOT NULL,
  `sentToId` int NOT NULL,
  `transactionType` tinyint NOT NULL COMMENT '0=>default, 1=>withdrawal',
  `amountChangeType` tinyint NOT NULL COMMENT '0=>noChange, 1=>positive, 2=>negative',
  `amountChange` decimal(15,2) NOT NULL,
  `currentAmount` decimal(15,2) NOT NULL,
  `apiUsed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'api name or cron',
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `transferId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `transactionJson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `userWalletTransaction`
--

INSERT INTO `userWalletTransaction` (`id`, `userId`, `sentById`, `sentToId`, `transactionType`, `amountChangeType`, `amountChange`, `currentAmount`, `apiUsed`, `message`, `transferId`, `transactionJson`, `createdAt`, `updatedAt`) VALUES
(8, 29, 54, 29, 0, 1, 5.00, 5.00, 'sendCredit', '$5 amount credited to 29 wallet', '', '{}', '2023-07-17 14:48:11', '2023-07-17 14:48:11'),
(9, 53, 55, 53, 0, 1, 55.00, 55.00, 'sendCredit', '$55 amount credited to 53 wallet', '', '{}', '2023-07-17 16:15:20', '2023-07-17 16:15:20'),
(10, 53, 53, 57, 0, 2, 5.00, 50.00, 'sendMoney', '$5 amount debited from 57 wallet', '', '{}', '2023-07-17 16:16:02', '2023-07-17 16:16:02'),
(11, 57, 53, 57, 0, 1, 5.00, 5.00, 'sendMoney', '$5 amount credited to 57 wallet', '', '{}', '2023-07-17 16:16:02', '2023-07-17 16:16:02'),
(12, 53, 55, 53, 0, 1, 5000.00, 5050.00, 'sendCredit', '$5000 amount credited to 53 wallet', '', '{}', '2023-07-17 16:24:13', '2023-07-17 16:24:13'),
(13, 53, 53, 35, 0, 2, 500.00, 4550.00, 'sendMoney', '$500 amount debited from 35 wallet', '', '{}', '2023-07-18 11:54:09', '2023-07-18 11:54:09'),
(14, 35, 53, 35, 0, 1, 500.00, 500.00, 'sendMoney', '$500 amount credited to 35 wallet', '', '{}', '2023-07-18 11:54:09', '2023-07-18 11:54:09'),
(15, 62, 1, 62, 0, 1, 5000.00, 5000.00, 'adminAddUserWalletModule', '$5000 amount credited to 62 wallet', '', '{}', '2023-07-18 12:17:47', '2023-07-18 12:17:47'),
(16, 62, 62, 60, 0, 2, 1000.00, 4000.00, 'sendMoney', '$1000 amount debited from 60 wallet', '', '{}', '2023-07-18 12:19:06', '2023-07-18 12:19:06'),
(17, 60, 62, 60, 0, 1, 1000.00, 1000.00, 'sendMoney', '$1000 amount credited to 60 wallet', '', '{}', '2023-07-18 12:19:06', '2023-07-18 12:19:06'),
(18, 62, 62, 60, 0, 2, 2000.00, 2000.00, 'sendMoney', '$2000 amount debited from 60 wallet', '', '{}', '2023-07-18 12:20:22', '2023-07-18 12:20:22'),
(19, 60, 62, 60, 0, 1, 2000.00, 3000.00, 'sendMoney', '$2000 amount credited to 60 wallet', '', '{}', '2023-07-18 12:20:22', '2023-07-18 12:20:22'),
(20, 29, 89, 29, 0, 1, 100.00, 105.00, 'sendCredit', '$100 amount credited to 29 wallet', '', '{}', '2023-08-01 03:49:31', '2023-08-01 03:49:31'),
(21, 29, 89, 29, 0, 2, 100.00, 5.00, 'withdrawAmountThroughAgent', '$100 amount deducted from 29 wallet', '', '{}', '2023-08-01 03:50:44', '2023-08-01 03:50:44'),
(22, 1, 89, 1, 0, 1, 5.00, 5.00, 'withdrawAmountThroughAgent', '$5 amount credit from 29 wallet', '', '{}', '2023-08-01 03:50:44', '2023-08-01 03:50:44'),
(23, 53, 92, 53, 0, 1, 500.00, 5050.00, 'sendCredit', '$500 amount credited to 53 wallet', '', '{}', '2023-08-01 05:55:48', '2023-08-01 05:55:48'),
(24, 53, 92, 53, 0, 2, 550.00, 4500.00, 'withdrawAmountThroughAgent', '$550 amount deducted from 53 wallet', '', '{}', '2023-08-01 06:08:18', '2023-08-01 06:08:18'),
(25, 1, 92, 53, 0, 1, 27.50, 32.50, 'withdrawAmountThroughAgent', '$27.5 amount credit from 53 wallet', '', '{}', '2023-08-01 06:08:18', '2023-08-01 06:08:18'),
(26, 29, 92, 29, 0, 1, 5.00, 10.00, 'sendCredit', '$5 amount credited to 29 wallet', '', '{}', '2023-08-01 06:17:33', '2023-08-01 06:17:33'),
(27, 53, 92, 53, 0, 2, 100.00, 4400.00, 'withdrawAmountThroughAgent', '$100 amount deducted from 53 wallet', '', '{}', '2023-08-01 06:18:04', '2023-08-01 06:18:04'),
(28, 1, 92, 53, 0, 1, 5.00, 37.50, 'withdrawAmountThroughAgent', '$5 amount credit from 53 wallet', '', '{}', '2023-08-01 06:18:04', '2023-08-01 06:18:04'),
(29, 29, 92, 29, 0, 1, 200.00, 210.00, 'sendCredit', '$200 amount credited to 29 wallet', '', '{}', '2023-08-01 14:06:26', '2023-08-01 14:06:26'),
(30, 53, 92, 53, 0, 2, 4000.00, 400.00, 'withdrawAmountThroughAgent', '$4000 amount deducted from 53 wallet', '', '{}', '2023-08-01 14:07:29', '2023-08-01 14:07:29'),
(31, 1, 92, 53, 0, 1, 200.00, 237.50, 'withdrawAmountThroughAgent', '$200 amount credit from 53 wallet', '', '{}', '2023-08-01 14:07:29', '2023-08-01 14:07:29'),
(32, 53, 92, 53, 0, 2, 200.00, 200.00, 'withdrawAmountThroughAgent', '$200 amount deducted from 53 wallet', '', '{}', '2023-08-01 17:03:45', '2023-08-01 17:03:45'),
(33, 1, 92, 53, 0, 1, 10.00, 247.50, 'withdrawAmountThroughAgent', '$10 amount credit from 53 wallet', '', '{}', '2023-08-01 17:03:45', '2023-08-01 17:03:45'),
(34, 29, 92, 29, 0, 1, 500.00, 710.00, 'sendCredit', '$500 amount credited to 29 wallet', '', '{}', '2023-08-01 17:05:00', '2023-08-01 17:05:00'),
(35, 53, 92, 53, 0, 2, 120.00, 80.00, 'withdrawAmountThroughAgent', '$120 amount deducted from 53 wallet', '', '{}', '2023-08-01 17:06:13', '2023-08-01 17:06:13'),
(36, 1, 92, 53, 0, 1, 6.00, 253.50, 'withdrawAmountThroughAgent', '$6 amount credit from 53 wallet', '', '{}', '2023-08-01 17:06:13', '2023-08-01 17:06:13'),
(37, 94, 92, 94, 0, 1, 1000.00, 1000.00, 'sendCredit', '$1000 amount credited to 94 wallet', '', '{}', '2023-08-23 06:00:11', '2023-08-23 06:00:11'),
(38, 94, 94, 1, 0, 2, 116.00, 884.00, 'withdrawAmountThroughAgent', '$116 amount deducted from wallet for purchasing Wallet F L', '', '{}', '2023-08-23 06:04:52', '2023-08-23 06:04:52'),
(39, 1, 94, 1, 0, 1, 1.00, 254.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Akshay\'s wallet for buying Wallet F L lottery', '', '{}', '2023-08-23 06:04:52', '2023-08-23 06:04:52'),
(40, 94, 94, 1, 0, 2, 101.00, 783.00, 'withdrawAmountThroughAgent', '$101 amount deducted from wallet for purchasing New York Static', '', '{}', '2023-08-23 08:03:36', '2023-08-23 08:03:36'),
(41, 1, 94, 1, 0, 1, 1.00, 255.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Akshay\'s wallet for buying New York Static lottery', '', '{}', '2023-08-23 08:03:36', '2023-08-23 08:03:36'),
(42, 96, 92, 96, 0, 1, 1000.00, 1000.00, 'sendCredit', '$1000 amount credited to 96 wallet', '', '{}', '2023-08-23 15:09:32', '2023-08-23 15:09:32'),
(43, 96, 96, 1, 0, 2, 101.00, 899.00, 'withdrawAmountThroughAgent', '$101 amount deducted from wallet for purchasing New York Static', '', '{}', '2023-08-23 15:10:24', '2023-08-23 15:10:24'),
(44, 1, 96, 1, 0, 1, 1.00, 256.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Rajiv\'s wallet for buying New York Static lottery', '', '{}', '2023-08-23 15:10:24', '2023-08-23 15:10:24'),
(45, 96, 96, 1, 0, 2, 251.00, 648.00, 'withdrawAmountThroughAgent', '$251 amount deducted from wallet for purchasing Wallet F L', '', '{}', '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(46, 1, 96, 1, 0, 1, 1.00, 257.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Rajiv\'s wallet for buying Wallet F L lottery', '', '{}', '2023-08-23 15:11:46', '2023-08-23 15:11:46'),
(47, 96, 96, 1, 0, 2, 161.00, 487.00, 'withdrawAmountThroughAgent', '$161 amount deducted from wallet for purchasing Nitin Test Flexi', '', '{}', '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(48, 1, 96, 1, 0, 1, 1.00, 258.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Rajiv\'s wallet for buying Nitin Test Flexi lottery', '', '{}', '2023-09-02 10:56:21', '2023-09-02 10:56:21'),
(49, 95, 92, 95, 0, 1, 1000.00, 1000.00, 'sendCredit', '$1000 amount credited to 95 wallet', '', '{}', '2023-09-02 10:59:54', '2023-09-02 10:59:54'),
(50, 95, 95, 1, 0, 2, 71.00, 929.00, 'withdrawAmountThroughAgent', '$71 amount deducted from wallet for purchasing Nitin Test Flexi', '', '{}', '2023-09-02 11:01:10', '2023-09-02 11:01:10'),
(51, 1, 95, 1, 0, 1, 1.00, 259.50, 'withdrawAmountThroughAgent', '$1 amount App service charge credited from Udit\'s wallet for buying Nitin Test Flexi lottery', '', '{}', '2023-09-02 11:01:10', '2023-09-02 11:01:10'),
(52, 95, 1, 95, 0, 1, 500.00, 1429.00, 'declareResultSubmitFromAdmin', '$500 amount won from the lottery \"Nitin Test Flexi\"', '', '{}', '2023-09-02 11:16:03', '2023-09-02 11:16:03'),
(53, 96, 1, 96, 0, 1, 1000.00, 1487.00, 'declareResultSubmitFromAdmin', '$1000 amount won from the lottery \"Nitin Test Flexi\"', '', '{}', '2023-09-02 11:16:03', '2023-09-02 11:16:03');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `adminDetail`
--
ALTER TABLE `adminDetail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `adminDetail_userId_foreign_idx` (`userId`);

--
-- Indexes for table `agentDetail`
--
ALTER TABLE `agentDetail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `adminDetail_userId_foreign_idx` (`userId`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cascade_delete_user_detail_user_idx` (`userId`);

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

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

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

--
-- Indexes for table `sellerDetail`
--
ALTER TABLE `sellerDetail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cascade_delete_user_detail_user_idx` (`userId`);

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

--
-- Indexes for table `ticketSellerDetail`
--
ALTER TABLE `ticketSellerDetail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cascade_delete_user_detail_user_idx` (`userId`);

--
-- Indexes for table `userAddress`
--
ALTER TABLE `userAddress`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cascade_delete_user_detail_user_idx` (`userId`);

--
-- Indexes for table `userImages`
--
ALTER TABLE `userImages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cascade_vendor_delivery_options_user_idx` (`userId`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `adminDetail`
--
ALTER TABLE `adminDetail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `agentDetail`
--
ALTER TABLE `agentDetail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `interest`
--
ALTER TABLE `interest`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `lottery`
--
ALTER TABLE `lottery`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `lotteryCompany`
--
ALTER TABLE `lotteryCompany`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `lotteryFlexibleTypes`
--
ALTER TABLE `lotteryFlexibleTypes`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lotteryNumberLimit`
--
ALTER TABLE `lotteryNumberLimit`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `lotteryPurchase`
--
ALTER TABLE `lotteryPurchase`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `lotteryPurchaseFlexibleTickets`
--
ALTER TABLE `lotteryPurchaseFlexibleTickets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `lotteryPurchaseWinner`
--
ALTER TABLE `lotteryPurchaseWinner`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lotteryResult`
--
ALTER TABLE `lotteryResult`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lotteryWinningPrize`
--
ALTER TABLE `lotteryWinningPrize`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `productImages`
--
ALTER TABLE `productImages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `sellerDetail`
--
ALTER TABLE `sellerDetail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `ticketSellerDetail`
--
ALTER TABLE `ticketSellerDetail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `userAddress`
--
ALTER TABLE `userAddress`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `userImages`
--
ALTER TABLE `userImages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userWalletTransaction`
--
ALTER TABLE `userWalletTransaction`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `adminDetail`
--
ALTER TABLE `adminDetail`
  ADD CONSTRAINT `adminDetail_userId_foreign_idx` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

