--
-- Host: localhost    Database: greencard_agent_db
-- ------------------------------------------------------


--
-- Table structure for table `BankAccount`
--

CREATE TABLE `BankAccount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) NOT NULL,
  `last_name` varchar(191) NOT NULL,
  `bank_name` varchar(191) NOT NULL,
  `swift_code` varchar(191) NOT NULL,
  `bank_account` varchar(191) NOT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `BankAccount_userId_key` (`userId`),
  CONSTRAINT `BankAccount_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BankAccount`
--


--
-- Table structure for table `BusinessInfo`
--

CREATE TABLE `BusinessInfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `business_name` varchar(191) DEFAULT NULL,
  `business_type` varchar(191) DEFAULT NULL,
  `industry_category` varchar(191) DEFAULT NULL,
  `doing_business` varchar(191) DEFAULT NULL,
  `address_1` varchar(191) DEFAULT NULL,
  `address_2` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `zip_code` varchar(191) DEFAULT NULL,
  `ein` varchar(191) DEFAULT NULL,
  `ssn` varchar(191) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `ip_address` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `specific_industry` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `status` varchar(191) DEFAULT NULL,
  `bank_id_fee` varchar(191) DEFAULT NULL,
  `bank_status_fee` varchar(191) DEFAULT NULL,
  `billing_account_number` varchar(191) DEFAULT NULL,
  `billing_bank_name` varchar(191) DEFAULT NULL,
  `billing_routing_number` varchar(191) DEFAULT NULL,
  `dispute_fee` varchar(191) DEFAULT NULL,
  `fee_name` varchar(191) DEFAULT NULL,
  `fee_profile_id` varchar(191) DEFAULT NULL,
  `meta_data` varchar(191) DEFAULT NULL,
  `monthly_fee` varchar(191) DEFAULT NULL,
  `payment_charge_dollar_month` varchar(191) DEFAULT NULL,
  `payment_charge_max_amount` varchar(191) DEFAULT NULL,
  `payment_charge_per_month` varchar(191) DEFAULT NULL,
  `payment_customer_service_email` varchar(191) DEFAULT NULL,
  `payment_customer_service_phone` varchar(191) DEFAULT NULL,
  `payment_payouts_dollar_month` varchar(191) DEFAULT NULL,
  `payment_payouts_max_amount` varchar(191) DEFAULT NULL,
  `payment_payouts_per_month` varchar(191) DEFAULT NULL,
  `payment_service_use` varchar(191) DEFAULT NULL,
  `payment_statement_descriptor` varchar(191) DEFAULT NULL,
  `percent_cap` varchar(191) DEFAULT NULL,
  `percent_fee` varchar(191) DEFAULT NULL,
  `return_fee` varchar(191) DEFAULT NULL,
  `setup_fee` varchar(191) DEFAULT NULL,
  `transaction_fee` varchar(191) DEFAULT NULL,
  `transfer_account_number` varchar(191) DEFAULT NULL,
  `transfer_bank_name` varchar(191) DEFAULT NULL,
  `transfer_routing_number` varchar(191) DEFAULT NULL,
  `externalId` varchar(191) DEFAULT NULL,
  `onboarding_id` varchar(191) DEFAULT NULL,
  `payment_enable_ccd` tinyint(1) DEFAULT NULL,
  `payment_enable_ppd` tinyint(1) DEFAULT NULL,
  `payment_enable_tel` tinyint(1) DEFAULT NULL,
  `payment_enable_web` tinyint(1) DEFAULT NULL,
  `merchant_gate_id` varchar(191) DEFAULT NULL,
  `merchant_gate_key` varchar(191) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `enable_charges` tinyint(1) DEFAULT NULL,
  `enable_payouts` tinyint(1) DEFAULT NULL,
  `customer_type_business` tinyint(1) NOT NULL DEFAULT 1,
  `customer_type_consumer` tinyint(1) DEFAULT NULL,
  `ownership_percentage` varchar(191) DEFAULT NULL,
  `representative_email` varchar(191) DEFAULT NULL,
  `representative_first_name` varchar(191) DEFAULT NULL,
  `representative_last_name` varchar(191) DEFAULT NULL,
  `representative_title` varchar(191) DEFAULT NULL,
  `business_title` varchar(191) DEFAULT NULL,
  `company_dba` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `start_date` varchar(191) DEFAULT NULL,
  `state_formation` varchar(191) DEFAULT NULL,
  `representative_phone` varchar(191) DEFAULT NULL,
  `type_signer` varchar(191) DEFAULT NULL,
  `second_owner_email` varchar(191) DEFAULT NULL,
  `second_owner_first_name` varchar(191) DEFAULT NULL,
  `second_owner_last_name` varchar(191) DEFAULT NULL,
  `second_owner_phone` varchar(191) DEFAULT NULL,
  `second_owner_title` varchar(191) DEFAULT NULL,
  `isAuthorizedRepresentative` tinyint(1) NOT NULL DEFAULT 1,
  `credit_daily_max` int(11) DEFAULT NULL,
  `credit_hold_days` int(11) DEFAULT NULL,
  `credit_max` int(11) DEFAULT NULL,
  `credits` tinyint(1) DEFAULT NULL,
  `debit_daily_max` int(11) DEFAULT NULL,
  `debit_hold_days` int(11) DEFAULT NULL,
  `debit_max` int(11) DEFAULT NULL,
  `debits` tinyint(1) DEFAULT NULL,
  `business_description` varchar(255) DEFAULT NULL,
  `service_fee` tinyint(1) NOT NULL DEFAULT 0,
  `service_fee_amount` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `BusinessInfo_userId_key` (`userId`),
  UNIQUE KEY `BusinessInfo_externalId_key` (`externalId`),
  UNIQUE KEY `BusinessInfo_onboarding_id_key` (`onboarding_id`),
  CONSTRAINT `BusinessInfo_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BusinessInfo`
--

INSERT INTO `BusinessInfo` VALUES (1,'','','','','','','',NULL,'','',NULL,'',4,'2024-04-30 21:21:41.199','2024-06-16 02:07:26.970',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','jazz merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(2,'BGWG Merchant','LLC','','Smoke shop','123 Any St','','Irvine','US','12345','123456789',NULL,'bgwg.co',7,'2024-04-30 22:15:50.150','2024-07-23 14:32:49.222',7,NULL,'38.170.181.10','9999999399','Accounting, Auditing, Or Tax Prep','california','Accepted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'100000','1000','100','luke+bgwgmerchant@paygreencard.com','3344334323','100000','100','0','No Refunds','ACHDescrip',NULL,NULL,NULL,NULL,NULL,'4rYFsGXpUyJ1Ky5KaPnEkCs8fFz09ZFDdWrZQqmVB0Fu/G1Br92j/uoY2i0=','dvKoMT6CWf1LTlZDMLfz1WwqghPekeHsmg0TQJ+d+iRAt3sKj9ek+YPnCOu6p0EGMQ==','Dt0oJ5/geWCLZRJNeaeOuMw1n5cdI1nd3V/Q6XkG4AzKGjhKbvdFGOHB1RsYqT26cnDO','29383ca7-10ab-4fa2-bd10-cc6def2555da','21492366',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'100','luke+bgwgmerchant@paygreencard.com','Tommy','Merchant','CEO','CEO','BGWG Merchant','luke+bgwgmerchant@paygreencard.com','04/30/2012','california','9939399339','Luke Blackamore','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Best!',1,2),(3,'','','','','','','',NULL,'','',NULL,'',11,'2024-05-01 02:29:32.013','2024-06-16 02:07:26.969',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Test','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(4,'Ming Merchant','LLC','','We are the best!','8243 North Cactus Street El Cajon, CA 92020','','El Cajon','US','92020','123456789',NULL,'example.com',12,'2024-05-01 03:13:07.228','2024-06-16 02:07:26.970',12,NULL,'83.234.227.37','2345678902','Accounting, Auditing, Or Tax Prep','california','Submitted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'10000','1000','100','bigox.dev+merchant2@gmail.com','2345678902','10000','1000','20','Full refund with in 1 weeks of purchase','Test',NULL,NULL,NULL,NULL,NULL,'xxw1GqOtrtk7KsBsNAspAVmDbZHmQeeJjLh/ek05XozfUv19ZkgmxphZgdDN4iyGpM9z','rLJMroPUxNBCzHlyDpLkz1YpNDeRGcUIkiBI27JRZb4FE4c1Dyi7fN6SZVe3AsiDWg==','mIreGtwQ58++0v8QCwercnnzPhAg5VpTLrTHHQv9kOqEFWsGTQ254fSFFsQ=','7393a3d2-2081-43cb-82f9-a771e0257d0d','21507973',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'90','bigox.dev2020+merchant2@gmail.com','Ming','Jie','test','test','Ming Merchant2','bigox.dev+merchant2@gmail.com','05/01/2024','alaska','2345678912','Ming','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(5,'Ming Merchant','LLC','','test','test test','','test','US','12345','123456789',NULL,'example.com',13,'2024-05-01 16:39:08.644','2024-06-16 02:07:26.970',13,NULL,'38.170.181.10','2342342344','Accounting, Auditing, Or Tax Prep','california','Submitted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'10000','1000','100','bigox.dev2020+merchant3@gmail.com','2343234334','10000','100','1','test','test',NULL,NULL,NULL,NULL,NULL,'','','','b71a425a-dc53-4f18-8ebc-ae9afe7c18aa','21509963',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'1','bigox.dev2020+merchant3@gmail.com','Ming','Jie','Test','Test','Ming Merchant','bigox.dev2020+merchant3@gmail.com','05/01/2024','california','2345678902','Ming','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(6,'Ming Merchant','LLC','','We are the best!','Test Address','','Los Angeles','US','23456','342342342',NULL,'example.com',16,'2024-05-06 03:05:51.900','2024-06-16 02:07:26.970',16,NULL,'38.170.181.10','3423423445','Accounting, Auditing, Or Tax Prep','california','Submitted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'10000','1000','100','bigox.dev2020+merchant5@gmail.com','2353453455','10000','1000','1','Test','Test',NULL,NULL,NULL,NULL,NULL,'6a0xDbEJUW+yDIGolPrfqWjAaESc0Q2r/ODUPiTnavjJWw0+U5ti160CdLU=','ch/4B17XbuZNERklDfk85rUC9LfpVUDmU135FwQpOeDX/MHo2w5mlVCsHdS8W2D4Pg==','g6vLGEe2NzMza0++Z0dYLR5VcKv/pkK6Kt5GqW4IyLnWTAWlFxqC1sk1cD5EezRYmvXR','1767a1c8-994e-4f6c-84d5-2c0d1b4f6f51','21616313',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'80','bigox.dev2020+merchant5@gmail.com','Ming','Jie','Merchant','Merchant','Ming Merchant','bigox.dev2020+merchant5@gmail.com','05/01/2024','california','2344534534','Ming','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0.5),(7,'','','','','','','',NULL,'','',NULL,'',28,'2024-05-14 15:22:22.803','2024-06-16 02:07:26.970',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(8,'','','','','','','',NULL,'','',NULL,'',30,'2024-05-15 16:28:28.187','2024-06-16 02:07:26.970',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','CEO','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(9,'TEST','Corporation','','TEST','123 any st','','MV','US','12345','123456789',NULL,'www.paygreencard.com',31,'2024-05-15 22:11:43.777','2024-06-16 02:07:26.978',31,NULL,'2600:8802:3b00:8ba0::9fb0','9999393939','Grocery Stores, Supermarkets','california','Submitted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'1000','1000','1000','luke+donjon@paygreencard.com','3343434332','1000','1000','0','NONE','ACHDesc',NULL,NULL,NULL,NULL,NULL,'','','','c4222e30-7fd4-4c8d-a089-7a7d9b06c3da','21888180',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'100','luke+donjon@paygreencard.com','Don','John','CEO','CEO','TEST','luke+donjon@paygreencard.com','05/15/2024','california','4778577478','Luke','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(10,'Ming Merchant','LLC','','we\'re the best','8243 North Cactus Street El Cajon, CA 92020','','El Cajon','US','92020','235235223',NULL,'example.com',32,'2024-05-15 22:36:48.599','2024-06-16 02:07:26.979',32,NULL,'38.170.181.10','5622452342','Cleaning, Maintenance, and Janitorial Services','california','Submitted',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'1000','1000','1000','bigox.dev2020+merchant13@gmail.com','3453454354','1000','1000','1','test','test',NULL,NULL,NULL,NULL,NULL,'','','','71e076d5-29cc-4bc1-9756-3628c18daf79','21888653',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'50','bigox.dev2020+merchant13@gmail.com','Ming','Merchant','Merchant','Merchant','Ming Merchant2','bigox.dev2020+merchant13@gmail.com','05/15/2024','california','3243423423','Ming','','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(11,'','','','','','','',NULL,'','',NULL,'',33,'2024-05-17 14:46:22.665','2024-06-16 02:07:26.979',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(12,'','','','','','','',NULL,'','',NULL,'',37,'2024-05-17 14:54:09.206','2024-06-16 02:07:26.979',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(13,'','','','','','','',NULL,'','',NULL,'',51,'2024-05-20 13:19:56.359','2024-06-16 02:07:26.979',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(14,'','','','','','','',NULL,'','',NULL,'',55,'2024-05-21 00:21:48.320','2024-06-16 02:07:26.979',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','Merchant','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(15,'','','','','','','',NULL,'','',NULL,'',56,'2024-05-30 17:38:42.834','2024-06-16 02:07:26.979',NULL,NULL,'','','','','Register',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,'','','','','','dec','','','','','',NULL,'','','','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0);

--
-- Table structure for table `BusinessProcessingFee`
--

CREATE TABLE `BusinessProcessingFee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `processing_fee` decimal(10,4) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdby_userId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `BusinessProcessingFee_userId_fkey` (`userId`),
  CONSTRAINT `BusinessProcessingFee_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BusinessProcessingFee`
--

INSERT INTO `BusinessProcessingFee` VALUES (1,51,3.0000,'2024-05-20 13:19:56.284','2024-05-20 13:19:56.284',15),(2,54,3.0000,'2024-05-20 19:48:34.785','2024-05-20 19:48:34.785',1),(3,55,2.0000,'2024-05-21 00:21:48.222','2024-05-21 00:21:48.222',15),(4,7,4.0000,'2024-05-21 04:41:17.000','2024-05-21 04:41:23.000',1),(5,5,2.0000,'2024-05-22 22:59:00.469','2024-05-22 22:59:00.469',50),(6,5,3.0000,'2024-05-22 22:59:20.037','2024-05-22 22:59:20.037',50),(7,7,3.0000,'2024-05-27 23:42:01.900','2024-05-27 23:42:01.900',6),(8,32,1.0000,'2024-05-28 15:50:31.014','2024-05-28 15:50:31.014',15),(9,32,5.0000,'2024-05-28 15:50:57.456','2024-05-28 15:50:57.456',15),(10,32,0.0000,'2024-05-28 15:51:43.231','2024-05-28 15:51:43.231',15),(11,32,3.0000,'2024-05-28 15:52:44.264','2024-05-28 15:52:44.264',15),(12,56,2.0000,'2024-05-30 17:38:42.729','2024-05-30 17:38:42.729',6);

--
-- Table structure for table `CommissionHistory`
--

CREATE TABLE `CommissionHistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `commission` decimal(10,4) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdby_userId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `CommissionHistory_userId_fkey` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CommissionHistory`
--

INSERT INTO `CommissionHistory` VALUES (1,2,1.0000,'2024-04-30 21:12:28.403','2024-04-30 21:12:28.403',0),(2,3,2.0000,'2024-04-30 21:19:40.110','2024-04-30 21:19:40.110',0),(3,5,1.0000,'2024-04-30 21:43:15.992','2024-04-30 21:43:15.992',0),(4,6,1.0000,'2024-04-30 22:09:57.899','2024-04-30 22:09:57.899',0),(6,9,1.0000,'2024-05-01 02:15:23.746','2024-05-01 02:15:23.746',0),(7,10,2.0000,'2024-05-01 02:25:35.885','2024-05-01 02:25:35.885',0),(8,14,1.0000,'2024-05-06 02:00:06.819','2024-05-06 02:00:06.819',0),(9,15,1.0000,'2024-05-06 03:00:22.294','2024-05-06 03:00:22.294',0),(10,17,1.0000,'2024-05-06 18:24:53.831','2024-05-06 18:24:53.831',0),(11,27,1.0000,'2024-05-14 15:14:57.625','2024-05-14 15:14:57.625',0),(12,29,1.0000,'2024-05-14 15:24:30.981','2024-05-14 15:24:30.981',0),(13,37,3.0000,'2024-05-17 14:54:09.095','2024-05-17 14:54:09.095',15);

--
-- Table structure for table `CustomerGroup`
--

CREATE TABLE `CustomerGroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `group_name` varchar(191) NOT NULL,
  `customers` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CustomerGroup`
--


--
-- Table structure for table `EmailTemplate`
--

CREATE TABLE `EmailTemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `template_name` varchar(191) NOT NULL,
  `json_data` mediumtext NOT NULL,
  `html_data` mediumtext NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `EmailTemplate_userId_fkey` (`userId`),
  CONSTRAINT `EmailTemplate_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `EmailTemplate`
--

INSERT INTO `EmailTemplate` VALUES (2,43,'Template Name','{\"counters\":{\"u_row\":8,\"u_column\":13,\"u_content_menu\":1,\"u_content_text\":24,\"u_content_image\":8,\"u_content_button\":2,\"u_content_divider\":1,\"u_content_heading\":3},\"body\":{\"id\":\"0QFAKPxyzM\",\"rows\":[{\"id\":\"-Pm2fEb9Wp\",\"cells\":[1],\"columns\":[{\"id\":\"aREOk3UC4g\",\"contents\":[{\"id\":\"hpEzy7mhvP\",\"type\":\"image\",\"values\":{\"containerPadding\":\"10px 10px 0px\",\"anchor\":\"\",\"src\":{\"url\":\"https://assets.unlayer.com/stock-templates/1708477298296-green_card_logo_splash.png\",\"width\":1027,\"height\":1027,\"maxWidth\":\"15%\",\"autoWidth\":false},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_1\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"_override\":{\"mobile\":{\"src\":{\"maxWidth\":\"20%\",\"autoWidth\":false}}}}},{\"id\":\"wQof8hV6QL\",\"type\":\"heading\",\"values\":{\"containerPadding\":\"0px\",\"anchor\":\"\",\"headingType\":\"h1\",\"fontWeight\":400,\"fontSize\":\"48px\",\"color\":\"#ffffff\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_heading_1\",\"htmlClassNames\":\"u_content_heading\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<span>Greencard Payment</span>\",\"_override\":{\"mobile\":{\"fontSize\":\"45px\"}}}},{\"id\":\"tfkkYtjur9\",\"type\":\"heading\",\"values\":{\"containerPadding\":\"0px\",\"anchor\":\"\",\"headingType\":\"h2\",\"fontSize\":\"28px\",\"color\":\"#ffffff\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_heading_2\",\"htmlClassNames\":\"u_content_heading\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<span>Best Payment solution for merchants</span>\",\"_override\":{\"mobile\":{\"fontSize\":\"19px\"}}}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_1\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"0px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_1\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"A-f41NTazI\",\"cells\":[1],\"columns\":[{\"id\":\"SfLBIwDbWU\",\"contents\":[{\"id\":\"vjfsdzgJRX\",\"type\":\"button\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"href\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"buttonColors\":{\"color\":\"#FFFFFF\",\"backgroundColor\":\"#0071e3\",\"hoverColor\":\"#FFFFFF\",\"hoverBackgroundColor\":\"#3AAEE0\"},\"size\":{\"autoWidth\":true,\"width\":\"100%\"},\"fontSize\":\"17px\",\"textAlign\":\"center\",\"lineHeight\":\"120%\",\"padding\":\"10px 20px\",\"border\":{},\"borderRadius\":\"25px\",\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_button_2\",\"htmlClassNames\":\"u_content_button\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<span style=\\\"line-height: 20.4px;\\\">Join</span>\",\"calculatedWidth\":71,\"calculatedHeight\":40,\"_override\":{\"mobile\":{\"textAlign\":\"center\"}}},\"hasDeprecatedFontControls\":true}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_2\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"0px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_2\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"Rd4HAvqb8t\",\"cells\":[1],\"columns\":[{\"id\":\"_t6kskqCwL\",\"contents\":[{\"id\":\"AF8ZpW__0i\",\"type\":\"image\",\"values\":{\"containerPadding\":\"0px\",\"anchor\":\"\",\"src\":{\"url\":\"https://www.idemia.com/wp-content/uploads/2020/10/greenpay-sustainable-payment-solutions-idemia-450x256.jpg\",\"width\":450,\"height\":256},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_2\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"GvsqJNYPRO\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontWeight\":700,\"fontSize\":\"21px\",\"color\":\"#9d9d9d\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_6\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 140%;\\\">Easy to make transaction with safety</p>\",\"_override\":{\"mobile\":{\"fontSize\":\"18px\"}}}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_4\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"15px 15px 70px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_3\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"Wlvn-fimOW\",\"cells\":[1],\"columns\":[{\"id\":\"EmTZshrUgj\",\"contents\":[{\"id\":\"KXAX-ozp-i\",\"type\":\"heading\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"headingType\":\"h1\",\"fontSize\":\"32px\",\"color\":\"#ffffff\",\"textAlign\":\"center\",\"lineHeight\":\"120%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_heading_3\",\"htmlClassNames\":\"u_content_heading\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<span>Why Greencard is the best place</span>\",\"_override\":{\"mobile\":{\"fontSize\":\"28px\"}}}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_5\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"#1d1d1f\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"50px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_4\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"xsDeI6ThVX\",\"cells\":[1,1],\"columns\":[{\"id\":\"PtkZbFNtjL\",\"contents\":[{\"id\":\"JZtislN2W7\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"24px\",\"textAlign\":\"center\",\"lineHeight\":\"120%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_11\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 120%;\\\">Green Card Monthly Installments.</p>\"}},{\"id\":\"9rqc5f7Vsk\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"14px\",\"textAlign\":\"center\",\"lineHeight\":\"150%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_24\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 150%;\\\">Pay over time, interest-free when you choose to check out with Green Card Monthly Installments.</p>\"}},{\"id\":\"le8EzyAcDY\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"14px\",\"color\":\"#0071e3\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_13\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 140%;\\\">Learn more</p>\"}},{\"id\":\"EZmcoOSqCd\",\"type\":\"image\",\"values\":{\"containerPadding\":\"0px\",\"anchor\":\"\",\"src\":{\"url\":\"https://assets.unlayer.com/projects/139/1676497065877-apple_card_2x.jpg\",\"width\":700,\"height\":390},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_7\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_8\",\"htmlClassNames\":\"u_column\"},\"border\":{\"borderTopColor\":\"#CCC\",\"borderTopStyle\":\"solid\",\"borderTopWidth\":\"0px\",\"borderLeftColor\":\"#CCC\",\"borderLeftStyle\":\"solid\",\"borderLeftWidth\":\"0px\",\"borderRightColor\":\"#1d1d1f\",\"borderRightStyle\":\"solid\",\"borderRightWidth\":\"5px\",\"borderBottomColor\":\"#CCC\",\"borderBottomStyle\":\"solid\",\"borderBottomWidth\":\"0px\"},\"padding\":\"33px 0px 0px\",\"_override\":{\"mobile\":{\"border\":{\"borderTopColor\":\"#CCC\",\"borderTopStyle\":\"solid\",\"borderTopWidth\":\"0px\",\"borderLeftColor\":\"#CCC\",\"borderLeftStyle\":\"solid\",\"borderLeftWidth\":\"0px\",\"borderRightColor\":\"#CCC\",\"borderRightStyle\":\"solid\",\"borderRightWidth\":\"0px\",\"borderBottomColor\":\"#CCC\",\"borderBottomStyle\":\"solid\",\"borderBottomWidth\":\"0px\"}}},\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}},{\"id\":\"jAFMuhCh-p\",\"contents\":[{\"id\":\"tXUPtUC2gk\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"24px\",\"textAlign\":\"center\",\"lineHeight\":\"120%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_21\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 120%;\\\">Fully integrated suite of financial and payments products</p>\"}},{\"id\":\"fUoTe1sYhQ\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"14px\",\"color\":\"#0071e3\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_23\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 140%;\\\">Shop</p>\"}},{\"id\":\"ij9PdsfvZQ\",\"type\":\"image\",\"values\":{\"containerPadding\":\"21px 0px 0px\",\"anchor\":\"\",\"src\":{\"url\":\"https://assets.unlayer.com/projects/139/1676497143860-edu_mac_2x.jpg\",\"width\":700,\"height\":390},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_8\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_9\",\"htmlClassNames\":\"u_column\"},\"border\":{\"borderTopColor\":\"#CCC\",\"borderTopStyle\":\"solid\",\"borderTopWidth\":\"0px\",\"borderLeftColor\":\"#1d1d1f\",\"borderLeftStyle\":\"solid\",\"borderLeftWidth\":\"5px\",\"borderRightColor\":\"#CCC\",\"borderRightStyle\":\"solid\",\"borderRightWidth\":\"0px\",\"borderBottomColor\":\"#CCC\",\"borderBottomStyle\":\"solid\",\"borderBottomWidth\":\"0px\"},\"padding\":\"33px 0px 0px\",\"_override\":{\"mobile\":{\"border\":{\"borderTopColor\":\"#CCC\",\"borderTopStyle\":\"solid\",\"borderTopWidth\":\"0px\",\"borderLeftColor\":\"#CCC\",\"borderLeftStyle\":\"solid\",\"borderLeftWidth\":\"0px\",\"borderRightColor\":\"#CCC\",\"borderRightStyle\":\"solid\",\"borderRightWidth\":\"0px\",\"borderBottomColor\":\"#CCC\",\"borderBottomStyle\":\"solid\",\"borderBottomWidth\":\"0px\"}}},\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"#1d1d1f\",\"columnsBackgroundColor\":\"#000000\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"5px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_6\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"GyxkKaDoVf\",\"cells\":[1,1],\"columns\":[{\"id\":\"_QiC12awFa\",\"contents\":[{\"id\":\"S_hqZ7HMSl\",\"type\":\"image\",\"values\":{\"containerPadding\":\"0px\",\"anchor\":\"\",\"src\":{\"url\":\"https://assets.unlayer.com/stock-templates/1708478942947-img_login.jpg\",\"width\":2429,\"height\":1822},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_6\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_12\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}},{\"id\":\"tBvHHdYsbP\",\"contents\":[{\"id\":\"YBq_C6WCxM\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"24px\",\"textAlign\":\"center\",\"lineHeight\":\"120%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_18\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 120%;\\\">Accept and optimize payments, globally</p>\"}},{\"id\":\"0DF1Wlu-f8\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"14px\",\"textAlign\":\"center\",\"lineHeight\":\"150%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_19\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 150%;\\\">Increase authorization rates, optimize your checkout conversion, and offer local payment methods in every market</p>\"}},{\"id\":\"3PX82nq2MS\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"14px\",\"color\":\"#0071e3\",\"textAlign\":\"center\",\"lineHeight\":\"140%\",\"linkStyle\":{\"inherit\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_20\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 140%;\\\"><a rel=\\\"noopener\\\" href=\\\"https://dev2.web-store.paygreencard.com/\\\" target=\\\"_blank\\\" data-u-link-value=\\\"eyJuYW1lIjoid2ViIiwiYXR0cnMiOnsiaHJlZiI6Int7aHJlZn19IiwidGFyZ2V0Ijoie3t0YXJnZXR9fSJ9LCJ2YWx1ZXMiOnsiaHJlZiI6Imh0dHBzOi8vZGV2Mi53ZWItc3RvcmUucGF5Z3JlZW5jYXJkLmNvbS8iLCJ0YXJnZXQiOiJfYmxhbmsifX0=\\\">Find</a> a store</p>\"}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_13\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"33px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"#1d1d1f\",\"columnsBackgroundColor\":\"#000000\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"5px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_8\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"he9WBb_LIA\",\"cells\":[1],\"columns\":[{\"id\":\"9KxIY1TsoO\",\"contents\":[{\"id\":\"TJ6qaeBuzl\",\"type\":\"menu\",\"values\":{\"containerPadding\":\"5px\",\"anchor\":\"\",\"menu\":{\"items\":[{\"key\":\"1676496577930\",\"link\":{\"name\":\"web\",\"attrs\":{\"href\":\"{{href}}\",\"target\":\"{{target}}\"},\"values\":{\"href\":\"https://dev2.web-store.paygreencard.com/\",\"target\":\"_self\"}},\"text\":\"Find a Store\"},{\"key\":\"1676496581406\",\"link\":{\"name\":\"web\",\"attrs\":{\"href\":\"{{href}}\",\"target\":\"{{target}}\"},\"values\":{\"href\":\"https://dev2.dashboard.paygreencard.com/\",\"target\":\"_self\"}},\"text\":\"Dashboard\"},{\"key\":\"1676496588057\",\"link\":{\"name\":\"web\",\"attrs\":{\"href\":\"{{href}}\",\"target\":\"{{target}}\"},\"values\":{\"href\":\"https://www.apple.com/\",\"target\":\"_self\"}},\"text\":\"Download App\"}]},\"fontSize\":\"14px\",\"textColor\":\"#424245\",\"linkColor\":\"#d2d2d7\",\"align\":\"center\",\"layout\":\"horizontal\",\"separator\":\"|\",\"padding\":\"5px 10px\",\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_menu_1\",\"htmlClassNames\":\"u_content_menu\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"_override\":{\"mobile\":{\"layout\":\"vertical\"}}}},{\"id\":\"mNBB5zCn71\",\"type\":\"divider\",\"values\":{\"width\":\"100%\",\"border\":{\"borderTopWidth\":\"1px\",\"borderTopStyle\":\"solid\",\"borderTopColor\":\"#424245\"},\"textAlign\":\"center\",\"containerPadding\":\"10px\",\"anchor\":\"\",\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_divider_1\",\"htmlClassNames\":\"u_content_divider\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}},{\"id\":\"bo4vg76emo\",\"type\":\"text\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"fontSize\":\"12px\",\"color\":\"#86868b\",\"textAlign\":\"left\",\"lineHeight\":\"200%\",\"linkStyle\":{\"inherit\":false,\"linkColor\":\"#d2d2d7\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":false,\"linkHoverUnderline\":true,\"body\":false},\"hideDesktop\":false,\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_text_17\",\"htmlClassNames\":\"u_content_text\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true,\"text\":\"<p style=\\\"line-height: 200%;\\\">If you reside in the U.S. territories, please call Luke Blackmore at 435-234-2345 with questions about Green Card.</p>\\n<p style=\\\"line-height: 200%;\\\">TM and © 2023 Greencard Payment Inc. [Company address].</p>\\n<p style=\\\"line-height: 200%;\\\"><a rel=\\\"noopener\\\" href=\\\"https://www.google.com/\\\" target=\\\"_blank\\\" data-u-link-value=\\\"eyJuYW1lIjoid2ViIiwiYXR0cnMiOnsiaHJlZiI6Int7aHJlZn19IiwidGFyZ2V0Ijoie3t0YXJnZXR9fSJ9LCJ2YWx1ZXMiOnsiaHJlZiI6Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vIiwidGFyZ2V0IjoiX2JsYW5rIn19\\\">All Rights Reserved</a>    |   <a rel=\\\"noopener\\\" href=\\\"https://www.google.com/\\\" target=\\\"_blank\\\" data-u-link-value=\\\"eyJuYW1lIjoid2ViIiwiYXR0cnMiOnsiaHJlZiI6Int7aHJlZn19IiwidGFyZ2V0Ijoie3t0YXJnZXR9fSJ9LCJ2YWx1ZXMiOnsiaHJlZiI6Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vIiwidGFyZ2V0IjoiX2JsYW5rIn19\\\">Privacy Policy</a>  </p>\\n<p style=\\\"line-height: 200%;\\\">If you prefer not to receive commercial email from Apple, or if you’ve changed your email address, please <a rel=\\\"noopener\\\" href=\\\"https://www.google.com/\\\" target=\\\"_blank\\\" data-u-link-value=\\\"eyJuYW1lIjoid2ViIiwiYXR0cnMiOnsiaHJlZiI6Int7aHJlZn19IiwidGFyZ2V0Ijoie3t0YXJnZXR9fSJ9LCJ2YWx1ZXMiOnsiaHJlZiI6Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vIiwidGFyZ2V0IjoiX2JsYW5rIn19\\\">click here</a>.</p>\"}}],\"values\":{\"_meta\":{\"htmlID\":\"u_column_10\",\"htmlClassNames\":\"u_column\"},\"border\":{},\"padding\":\"0px 30px\",\"borderRadius\":\"0px\",\"backgroundColor\":\"\"}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"#1d1d1f\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"padding\":\"10px 10px 50px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_7\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"headers\":[],\"footers\":[],\"values\":{\"popupPosition\":\"center\",\"popupWidth\":\"600px\",\"popupHeight\":\"auto\",\"borderRadius\":\"10px\",\"contentAlign\":\"center\",\"contentVerticalAlign\":\"center\",\"contentWidth\":700,\"fontFamily\":{\"label\":\"Helvetica\",\"value\":\"helvetica,sans-serif\",\"url\":\"\",\"weights\":null,\"defaultFont\":true},\"textColor\":\"#ffffff\",\"popupBackgroundColor\":\"#FFFFFF\",\"popupBackgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"cover\",\"position\":\"center\"},\"popupOverlay_backgroundColor\":\"rgba(0, 0, 0, 0.1)\",\"popupCloseButton_position\":\"top-right\",\"popupCloseButton_backgroundColor\":\"#DDDDDD\",\"popupCloseButton_iconColor\":\"#000000\",\"popupCloseButton_borderRadius\":\"0px\",\"popupCloseButton_margin\":\"0px\",\"popupCloseButton_action\":{\"name\":\"close_popup\",\"attrs\":{\"onClick\":\"document.querySelector(\'.u-popup-container\').style.display = \'none\';\"}},\"backgroundColor\":\"#000000\",\"preheaderText\":\"\",\"linkStyle\":{\"body\":true,\"linkColor\":\"#0071e3\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true,\"inherit\":false},\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"_meta\":{\"htmlID\":\"u_body\",\"htmlClassNames\":\"u_body\"}}},\"schemaVersion\":16}','<!DOCTYPE HTML PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional //EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\">\n<head>\n<!--[if gte mso 9]>\n<xml>\n  <o:OfficeDocumentSettings>\n    <o:AllowPNG/>\n    <o:PixelsPerInch>96</o:PixelsPerInch>\n  </o:OfficeDocumentSettings>\n</xml>\n<![endif]-->\n  <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n  <meta name=\"x-apple-disable-message-reformatting\">\n  <!--[if !mso]><!--><meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\"><!--<![endif]-->\n  <title></title>\n  \n    <style type=\"text/css\">\n      @media only screen and (min-width: 720px) {\n  .u-row {\n    width: 700px !important;\n  }\n  .u-row .u-col {\n    vertical-align: top;\n  }\n\n  .u-row .u-col-50 {\n    width: 350px !important;\n  }\n\n  .u-row .u-col-100 {\n    width: 700px !important;\n  }\n\n}\n\n@media (max-width: 720px) {\n  .u-row-container {\n    max-width: 100% !important;\n    padding-left: 0px !important;\n    padding-right: 0px !important;\n  }\n  .u-row .u-col {\n    min-width: 320px !important;\n    max-width: 100% !important;\n    display: block !important;\n  }\n  .u-row {\n    width: 100% !important;\n  }\n  .u-col {\n    width: 100% !important;\n  }\n  .u-col > div {\n    margin: 0 auto;\n  }\n}\nbody {\n  margin: 0;\n  padding: 0;\n}\n\ntable,\ntr,\ntd {\n  vertical-align: top;\n  border-collapse: collapse;\n}\n\np {\n  margin: 0;\n}\n\n.ie-container table,\n.mso-container table {\n  table-layout: fixed;\n}\n\n* {\n  line-height: inherit;\n}\n\na[x-apple-data-detectors=\'true\'] {\n  color: inherit !important;\n  text-decoration: none !important;\n}\n\n@media (max-width: 480px) {\n  .hide-mobile {\n    max-height: 0px;\n    overflow: hidden;\n    display: none !important;\n  }\n}\n\ntable, td { color: #ffffff; } #u_body a { color: #0071e3; text-decoration: underline; } #u_content_text_17 a { color: #d2d2d7; text-decoration: none; } @media (max-width: 480px) { #u_content_image_1 .v-src-width { width: auto !important; } #u_content_image_1 .v-src-max-width { max-width: 20% !important; } #u_content_heading_1 .v-font-size { font-size: 45px !important; } #u_content_heading_2 .v-font-size { font-size: 19px !important; } #u_content_button_2 .v-text-align { text-align: center !important; } #u_content_text_6 .v-font-size { font-size: 18px !important; } #u_content_heading_3 .v-font-size { font-size: 28px !important; } #u_column_8 .v-col-border { border-top: 0px solid transparent !important;border-left: 0px solid transparent !important;border-right: 0px solid transparent !important;border-bottom: 0px solid transparent !important; } #u_column_9 .v-col-border { border-top: 0px solid transparent !important;border-left: 0px solid transparent !important;border-right: 0px solid transparent !important;border-bottom: 0px solid transparent !important; } #u_content_menu_1 .v-layout-display { display: block !important; } }\n    </style>\n  \n  \n\n</head>\n\n<body class=\"clean-body u_body\" style=\"margin: 0;padding: 0;-webkit-text-size-adjust: 100%;background-color: #000000;color: #ffffff\">\n  <!--[if IE]><div class=\"ie-container\"><![endif]-->\n  <!--[if mso]><div class=\"mso-container\"><![endif]-->\n  <table id=\"u_body\" style=\"border-collapse: collapse;table-layout: fixed;border-spacing: 0;mso-table-lspace: 0pt;mso-table-rspace: 0pt;vertical-align: top;min-width: 320px;Margin: 0 auto;background-color: #000000;width:100%\" cellpadding=\"0\" cellspacing=\"0\">\n  <tbody>\n  <tr style=\"vertical-align: top\">\n    <td style=\"word-break: break-word;border-collapse: collapse !important;vertical-align: top\">\n    <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td align=\"center\" style=\"background-color: #000000;\"><![endif]-->\n    \n  \n  \n<div class=\"u-row-container\" style=\"padding: 0px;background-color: transparent\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 0px;background-color: transparent;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"700\" class=\"v-col-border\" style=\"width: 700px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 700px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;\"><!--<![endif]-->\n  \n<table id=\"u_content_image_1\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px 10px 0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td class=\"v-text-align\" style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://assets.unlayer.com/stock-templates/1708477298296-green_card_logo_splash.png\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 15%;max-width: 102px;\" width=\"102\" class=\"v-src-width v-src-max-width\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table id=\"u_content_heading_1\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <!--[if mso]><table width=\"100%\"><tr><td><![endif]-->\n    <h1 class=\"v-text-align v-font-size\" style=\"margin: 0px; color: #ffffff; line-height: 140%; text-align: center; word-wrap: break-word; font-size: 48px; font-weight: 400;\"><span>Greencard Payment</span></h1>\n  <!--[if mso]></td></tr></table><![endif]-->\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table id=\"u_content_heading_2\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <!--[if mso]><table width=\"100%\"><tr><td><![endif]-->\n    <h2 class=\"v-text-align v-font-size\" style=\"margin: 0px; color: #ffffff; line-height: 140%; text-align: center; word-wrap: break-word; font-size: 28px; font-weight: 400;\"><span>Best Payment solution for merchants</span></h2>\n  <!--[if mso]></td></tr></table><![endif]-->\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 0px;background-color: transparent\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 0px;background-color: transparent;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"700\" class=\"v-col-border\" style=\"width: 700px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 700px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table id=\"u_content_button_2\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <!--[if mso]><style>.v-button {background: transparent !important;}</style><![endif]-->\n<div class=\"v-text-align\" align=\"center\">\n  <!--[if mso]><v:roundrect xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" href=\"\" style=\"height:40px; v-text-anchor:middle; width:71px;\" arcsize=\"62.5%\"  stroke=\"f\" fillcolor=\"#0071e3\"><w:anchorlock/><center style=\"color:#FFFFFF;\"><![endif]-->\n    <a href=\"\" target=\"_blank\" class=\"v-button v-font-size\" style=\"box-sizing: border-box;display: inline-block;text-decoration: none;-webkit-text-size-adjust: none;text-align: center;color: #FFFFFF; background-color: #0071e3; border-radius: 25px;-webkit-border-radius: 25px; -moz-border-radius: 25px; width:auto; max-width:100%; overflow-wrap: break-word; word-break: break-word; word-wrap:break-word; mso-border-alt: none;font-size: 17px;\">\n      <span style=\"display:block;padding:10px 20px;line-height:120%;\"><span style=\"line-height: 20.4px;\">Join</span></span>\n    </a>\n    <!--[if mso]></center></v:roundrect><![endif]-->\n</div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 15px 15px 70px;background-color: transparent\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 15px 15px 70px;background-color: transparent;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"700\" class=\"v-col-border\" style=\"width: 700px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 700px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td class=\"v-text-align\" style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://www.idemia.com/wp-content/uploads/2020/10/greenpay-sustainable-payment-solutions-idemia-450x256.jpg\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 100%;max-width: 450px;\" width=\"450\" class=\"v-src-width v-src-max-width\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table id=\"u_content_text_6\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 21px; font-weight: 700; color: #9d9d9d; line-height: 140%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 140%;\">Easy to make transaction with safety</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 50px;background-color: #1d1d1f\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 50px;background-color: #1d1d1f;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"700\" class=\"v-col-border\" style=\"width: 700px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 700px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table id=\"u_content_heading_3\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <!--[if mso]><table width=\"100%\"><tr><td><![endif]-->\n    <h1 class=\"v-text-align v-font-size\" style=\"margin: 0px; color: #ffffff; line-height: 120%; text-align: center; word-wrap: break-word; font-size: 32px; font-weight: 400;\"><span>Why Greencard is the best place</span></h1>\n  <!--[if mso]></td></tr></table><![endif]-->\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 5px;background-color: #1d1d1f\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: #000000;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 5px;background-color: #1d1d1f;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: #000000;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"345\" class=\"v-col-border\" style=\"width: 345px;padding: 33px 0px 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 5px solid #1d1d1f;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div id=\"u_column_8\" class=\"u-col u-col-50\" style=\"max-width: 320px;min-width: 350px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 33px 0px 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 5px solid #1d1d1f;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 24px; line-height: 120%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 120%;\">Green Card Monthly Installments.</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 14px; line-height: 150%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 150%;\">Pay over time, interest-free when you choose to check out with Green Card Monthly Installments.</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 14px; color: #0071e3; line-height: 140%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 140%;\">Learn more</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td class=\"v-text-align\" style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://assets.unlayer.com/projects/139/1676497065877-apple_card_2x.jpg\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 100%;max-width: 350px;\" width=\"350\" class=\"v-src-width v-src-max-width\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n<!--[if (mso)|(IE)]><td align=\"center\" width=\"345\" class=\"v-col-border\" style=\"width: 345px;padding: 33px 0px 0px;border-top: 0px solid transparent;border-left: 5px solid #1d1d1f;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div id=\"u_column_9\" class=\"u-col u-col-50\" style=\"max-width: 320px;min-width: 350px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 33px 0px 0px;border-top: 0px solid transparent;border-left: 5px solid #1d1d1f;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 24px; line-height: 120%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 120%;\">Fully integrated suite of financial and payments products</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 14px; color: #0071e3; line-height: 140%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 140%;\">Shop</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:21px 0px 0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td class=\"v-text-align\" style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://assets.unlayer.com/projects/139/1676497143860-edu_mac_2x.jpg\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 100%;max-width: 350px;\" width=\"350\" class=\"v-src-width v-src-max-width\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 5px;background-color: #1d1d1f\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: #000000;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 5px;background-color: #1d1d1f;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: #000000;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"350\" class=\"v-col-border\" style=\"width: 350px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-50\" style=\"max-width: 320px;min-width: 350px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:0px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td class=\"v-text-align\" style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://assets.unlayer.com/stock-templates/1708478942947-img_login.jpg\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 100%;max-width: 350px;\" width=\"350\" class=\"v-src-width v-src-max-width\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n<!--[if (mso)|(IE)]><td align=\"center\" width=\"350\" class=\"v-col-border\" style=\"width: 350px;padding: 33px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-50\" style=\"max-width: 320px;min-width: 350px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 33px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 24px; line-height: 120%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 120%;\">Accept and optimize payments, globally</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 14px; line-height: 150%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 150%;\">Increase authorization rates, optimize your checkout conversion, and offer local payment methods in every market</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 14px; color: #0071e3; line-height: 140%; text-align: center; word-wrap: break-word;\">\n    <p style=\"line-height: 140%;\"><a rel=\"noopener\" href=\"https://dev2.web-store.paygreencard.com/\" target=\"_blank\">Find</a> a store</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n  \n  \n<div class=\"u-row-container\" style=\"padding: 10px 10px 50px;background-color: #1d1d1f\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 700px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 10px 10px 50px;background-color: #1d1d1f;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:700px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"700\" class=\"v-col-border\" style=\"width: 700px;padding: 0px 30px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 700px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div class=\"v-col-border\" style=\"box-sizing: border-box; height: 100%; padding: 0px 30px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table id=\"u_content_menu_1\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:5px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n<div class=\"menu\" style=\"text-align:center\">\n<!--[if (mso)|(IE)]><table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\"><tr><![endif]-->\n\n  <!--[if (mso)|(IE)]><td style=\"padding:5px 10px\"><![endif]-->\n  \n    <a href=\"https://dev2.web-store.paygreencard.com/\" target=\"_self\" style=\"padding:5px 10px;display:inline-block;color:#d2d2d7;font-size:14px;text-decoration:none\"  class=\"v-font-size v-layout-display\">\n      Find a Store\n    </a>\n  \n  <!--[if (mso)|(IE)]></td><![endif]-->\n  \n    <!--[if (mso)|(IE)]><td style=\"padding:5px 10px\"><![endif]-->\n    <span style=\"padding:5px 10px;display:inline-block;color:#424245;font-size:14px;\" class=\"v-font-size hide-mobile\">\n      |\n    </span>\n    <!--[if (mso)|(IE)]></td><![endif]-->\n  \n\n  <!--[if (mso)|(IE)]><td style=\"padding:5px 10px\"><![endif]-->\n  \n    <a href=\"https://dev2.dashboard.paygreencard.com/\" target=\"_self\" style=\"padding:5px 10px;display:inline-block;color:#d2d2d7;font-size:14px;text-decoration:none\"  class=\"v-font-size v-layout-display\">\n      Dashboard\n    </a>\n  \n  <!--[if (mso)|(IE)]></td><![endif]-->\n  \n    <!--[if (mso)|(IE)]><td style=\"padding:5px 10px\"><![endif]-->\n    <span style=\"padding:5px 10px;display:inline-block;color:#424245;font-size:14px;\" class=\"v-font-size hide-mobile\">\n      |\n    </span>\n    <!--[if (mso)|(IE)]></td><![endif]-->\n  \n\n  <!--[if (mso)|(IE)]><td style=\"padding:5px 10px\"><![endif]-->\n  \n    <a href=\"https://www.apple.com/\" target=\"_self\" style=\"padding:5px 10px;display:inline-block;color:#d2d2d7;font-size:14px;text-decoration:none\"  class=\"v-font-size v-layout-display\">\n      Download App\n    </a>\n  \n  <!--[if (mso)|(IE)]></td><![endif]-->\n  \n\n<!--[if (mso)|(IE)]></tr></table><![endif]-->\n</div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <table height=\"0px\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"border-collapse: collapse;table-layout: fixed;border-spacing: 0;mso-table-lspace: 0pt;mso-table-rspace: 0pt;vertical-align: top;border-top: 1px solid #424245;-ms-text-size-adjust: 100%;-webkit-text-size-adjust: 100%\">\n    <tbody>\n      <tr style=\"vertical-align: top\">\n        <td style=\"word-break: break-word;border-collapse: collapse !important;vertical-align: top;font-size: 0px;line-height: 0px;mso-line-height-rule: exactly;-ms-text-size-adjust: 100%;-webkit-text-size-adjust: 100%\">\n          <span>&#160;</span>\n        </td>\n      </tr>\n    </tbody>\n  </table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n<table id=\"u_content_text_17\" style=\"font-family:helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:helvetica,sans-serif;\" align=\"left\">\n        \n  <div class=\"v-text-align v-font-size\" style=\"font-size: 12px; color: #86868b; line-height: 200%; text-align: left; word-wrap: break-word;\">\n    <p style=\"line-height: 200%;\">If you reside in the U.S. territories, please call Luke Blackmore at 435-234-2345 with questions about Green Card.</p>\n<p style=\"line-height: 200%;\">TM and © 2023 Greencard Payment Inc. [Company address].</p>\n<p style=\"line-height: 200%;\"><a rel=\"noopener\" href=\"https://www.google.com/\" target=\"_blank\">All Rights Reserved</a>    |   <a rel=\"noopener\" href=\"https://www.google.com/\" target=\"_blank\">Privacy Policy</a>  </p>\n<p style=\"line-height: 200%;\">If you prefer not to receive commercial email from Apple, or if you’ve changed your email address, please <a rel=\"noopener\" href=\"https://www.google.com/\" target=\"_blank\">click here</a>.</p>\n  </div>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n    <!--[if (mso)|(IE)]></td></tr></table><![endif]-->\n    </td>\n  </tr>\n  </tbody>\n  </table>\n  <!--[if mso]></div><![endif]-->\n  <!--[if IE]></div><![endif]-->\n</body>\n\n</html>\n','2024-02-27 07:01:12.512','2024-02-27 07:30:42.168'),(3,43,'Template Name2','{\"counters\":{\"u_column\":1,\"u_row\":1,\"u_content_image\":1},\"body\":{\"id\":\"xz3vpf1_GC\",\"rows\":[{\"id\":\"Yvt8uwiB0h\",\"cells\":[1],\"columns\":[{\"id\":\"TLLodCr-xI\",\"contents\":[{\"id\":\"BJRlWMUFkE\",\"type\":\"image\",\"values\":{\"containerPadding\":\"10px\",\"anchor\":\"\",\"src\":{\"url\":\"https://cdn.tools.unlayer.com/image/placeholder.png\",\"width\":800,\"height\":200},\"textAlign\":\"center\",\"altText\":\"\",\"action\":{\"name\":\"web\",\"values\":{\"href\":\"\",\"target\":\"_blank\"}},\"displayCondition\":null,\"_meta\":{\"htmlID\":\"u_content_image_1\",\"htmlClassNames\":\"u_content_image\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"values\":{\"backgroundColor\":\"\",\"padding\":\"0px\",\"border\":{},\"borderRadius\":\"0px\",\"_meta\":{\"htmlID\":\"u_column_1\",\"htmlClassNames\":\"u_column\"}}}],\"values\":{\"displayCondition\":null,\"columns\":false,\"backgroundColor\":\"\",\"columnsBackgroundColor\":\"\",\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\",\"customPosition\":[\"50%\",\"50%\"]},\"padding\":\"0px\",\"anchor\":\"\",\"hideDesktop\":false,\"_meta\":{\"htmlID\":\"u_row_1\",\"htmlClassNames\":\"u_row\"},\"selectable\":true,\"draggable\":true,\"duplicatable\":true,\"deletable\":true,\"hideable\":true}}],\"headers\":[],\"footers\":[],\"values\":{\"popupPosition\":\"center\",\"popupWidth\":\"600px\",\"popupHeight\":\"auto\",\"borderRadius\":\"10px\",\"contentAlign\":\"center\",\"contentVerticalAlign\":\"center\",\"contentWidth\":\"500px\",\"fontFamily\":{\"label\":\"Arial\",\"value\":\"arial,helvetica,sans-serif\"},\"textColor\":\"#000000\",\"popupBackgroundColor\":\"#FFFFFF\",\"popupBackgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"cover\",\"position\":\"center\"},\"popupOverlay_backgroundColor\":\"rgba(0, 0, 0, 0.1)\",\"popupCloseButton_position\":\"top-right\",\"popupCloseButton_backgroundColor\":\"#DDDDDD\",\"popupCloseButton_iconColor\":\"#000000\",\"popupCloseButton_borderRadius\":\"0px\",\"popupCloseButton_margin\":\"0px\",\"popupCloseButton_action\":{\"name\":\"close_popup\",\"attrs\":{\"onClick\":\"document.querySelector(\'.u-popup-container\').style.display = \'none\';\"}},\"backgroundColor\":\"#e7e7e7\",\"preheaderText\":\"\",\"linkStyle\":{\"body\":true,\"linkColor\":\"#0000ee\",\"linkHoverColor\":\"#0000ee\",\"linkUnderline\":true,\"linkHoverUnderline\":true},\"backgroundImage\":{\"url\":\"\",\"fullWidth\":true,\"repeat\":\"no-repeat\",\"size\":\"custom\",\"position\":\"center\"},\"_meta\":{\"htmlID\":\"u_body\",\"htmlClassNames\":\"u_body\"}}},\"schemaVersion\":16}','<!DOCTYPE HTML PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional //EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\">\n<head>\n<!--[if gte mso 9]>\n<xml>\n  <o:OfficeDocumentSettings>\n    <o:AllowPNG/>\n    <o:PixelsPerInch>96</o:PixelsPerInch>\n  </o:OfficeDocumentSettings>\n</xml>\n<![endif]-->\n  <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n  <meta name=\"x-apple-disable-message-reformatting\">\n  <!--[if !mso]><!--><meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\"><!--<![endif]-->\n  <title></title>\n  \n    <style type=\"text/css\">\n      @media only screen and (min-width: 520px) {\n  .u-row {\n    width: 500px !important;\n  }\n  .u-row .u-col {\n    vertical-align: top;\n  }\n\n  .u-row .u-col-100 {\n    width: 500px !important;\n  }\n\n}\n\n@media (max-width: 520px) {\n  .u-row-container {\n    max-width: 100% !important;\n    padding-left: 0px !important;\n    padding-right: 0px !important;\n  }\n  .u-row .u-col {\n    min-width: 320px !important;\n    max-width: 100% !important;\n    display: block !important;\n  }\n  .u-row {\n    width: 100% !important;\n  }\n  .u-col {\n    width: 100% !important;\n  }\n  .u-col > div {\n    margin: 0 auto;\n  }\n}\nbody {\n  margin: 0;\n  padding: 0;\n}\n\ntable,\ntr,\ntd {\n  vertical-align: top;\n  border-collapse: collapse;\n}\n\n.ie-container table,\n.mso-container table {\n  table-layout: fixed;\n}\n\n* {\n  line-height: inherit;\n}\n\na[x-apple-data-detectors=\'true\'] {\n  color: inherit !important;\n  text-decoration: none !important;\n}\n\ntable, td { color: #000000; } </style>\n  \n  \n\n</head>\n\n<body class=\"clean-body u_body\" style=\"margin: 0;padding: 0;-webkit-text-size-adjust: 100%;background-color: #e7e7e7;color: #000000\">\n  <!--[if IE]><div class=\"ie-container\"><![endif]-->\n  <!--[if mso]><div class=\"mso-container\"><![endif]-->\n  <table style=\"border-collapse: collapse;table-layout: fixed;border-spacing: 0;mso-table-lspace: 0pt;mso-table-rspace: 0pt;vertical-align: top;min-width: 320px;Margin: 0 auto;background-color: #e7e7e7;width:100%\" cellpadding=\"0\" cellspacing=\"0\">\n  <tbody>\n  <tr style=\"vertical-align: top\">\n    <td style=\"word-break: break-word;border-collapse: collapse !important;vertical-align: top\">\n    <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td align=\"center\" style=\"background-color: #e7e7e7;\"><![endif]-->\n    \n  \n  \n<div class=\"u-row-container\" style=\"padding: 0px;background-color: transparent\">\n  <div class=\"u-row\" style=\"margin: 0 auto;min-width: 320px;max-width: 500px;overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;background-color: transparent;\">\n    <div style=\"border-collapse: collapse;display: table;width: 100%;height: 100%;background-color: transparent;\">\n      <!--[if (mso)|(IE)]><table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr><td style=\"padding: 0px;background-color: transparent;\" align=\"center\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"width:500px;\"><tr style=\"background-color: transparent;\"><![endif]-->\n      \n<!--[if (mso)|(IE)]><td align=\"center\" width=\"500\" style=\"width: 500px;padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\" valign=\"top\"><![endif]-->\n<div class=\"u-col u-col-100\" style=\"max-width: 320px;min-width: 500px;display: table-cell;vertical-align: top;\">\n  <div style=\"height: 100%;width: 100% !important;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\">\n  <!--[if (!mso)&(!IE)]><!--><div style=\"box-sizing: border-box; height: 100%; padding: 0px;border-top: 0px solid transparent;border-left: 0px solid transparent;border-right: 0px solid transparent;border-bottom: 0px solid transparent;border-radius: 0px;-webkit-border-radius: 0px; -moz-border-radius: 0px;\"><!--<![endif]-->\n  \n<table style=\"font-family:arial,helvetica,sans-serif;\" role=\"presentation\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n  <tbody>\n    <tr>\n      <td style=\"overflow-wrap:break-word;word-break:break-word;padding:10px;font-family:arial,helvetica,sans-serif;\" align=\"left\">\n        \n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n  <tr>\n    <td style=\"padding-right: 0px;padding-left: 0px;\" align=\"center\">\n      \n      <img align=\"center\" border=\"0\" src=\"https://cdn.tools.unlayer.com/image/placeholder.png\" alt=\"\" title=\"\" style=\"outline: none;text-decoration: none;-ms-interpolation-mode: bicubic;clear: both;display: inline-block !important;border: none;height: auto;float: none;width: 100%;max-width: 480px;\" width=\"480\"/>\n      \n    </td>\n  </tr>\n</table>\n\n      </td>\n    </tr>\n  </tbody>\n</table>\n\n  <!--[if (!mso)&(!IE)]><!--></div><!--<![endif]-->\n  </div>\n</div>\n<!--[if (mso)|(IE)]></td><![endif]-->\n      <!--[if (mso)|(IE)]></tr></table></td></tr></table><![endif]-->\n    </div>\n  </div>\n  </div>\n  \n\n\n    <!--[if (mso)|(IE)]></td></tr></table><![endif]-->\n    </td>\n  </tr>\n  </tbody>\n  </table>\n  <!--[if mso]></div><![endif]-->\n  <!--[if IE]></div><![endif]-->\n</body>\n\n</html>\n','2024-03-29 15:56:07.296','2024-03-29 15:56:07.296');

--
-- Table structure for table `FactorAuthentication`
--

CREATE TABLE `FactorAuthentication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(191) NOT NULL,
  `secret_code` varchar(191) DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 0,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `FactorAuthentication_unique_id_key` (`unique_id`),
  KEY `FactorAuthentication_userId_fkey` (`userId`),
  CONSTRAINT `FactorAuthentication_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FactorAuthentication`
--

INSERT INTO `FactorAuthentication` VALUES (4,'94a10aa9-1748-4df7-924f-51ee36d31d00','GFDEER3VHI4CKSZWJ44SK5DWIBWTKRDO',0,16,'2024-05-06 16:30:44.873','2024-06-19 12:49:30.478',NULL),(5,'e9418ed2-bfef-4dec-8ed9-0a085c62681a','MNVUYXRSPIWHK42JLUVHQUKKOBIVIQ3C',0,16,'2024-05-07 11:46:40.143','2024-06-19 12:26:17.856',NULL),(6,'3332f085-7c9a-41a6-b865-52dd9460b420','NBSCSJSYFBZGGZJIKQ4FIKL3EQUD6QZI',1,13,'2024-05-07 14:37:08.232','2024-05-07 14:38:16.437',NULL),(7,'7bf70acf-51c4-4c3c-ac32-e03be21d99ed','ERCTKVKDLVAWMQTZOY7XIM2AEREUQSLZ',1,18,'2024-05-07 17:51:14.097','2024-05-07 17:51:47.249',NULL),(8,'3d6216eb-23a2-4ac4-bc79-a12a18d34f12','GR4TMLS3PBJE4PSGHFCG26Z7HBXHIKCS',0,18,'2024-05-07 17:53:38.861','2024-05-07 17:53:38.861',NULL),(9,'dfd8d621-e6a2-4718-9c9d-583e590022f5','JVTES6B3EYWE6VDDJZLWC2CIII7XQSLL',1,14,'2024-05-07 18:03:26.172','2024-05-07 18:04:27.385',NULL),(10,'2c5db7a2-9ceb-41d8-8e93-f44b835b78a4','MUUVQV3EIZEW2SJFHZPFOR2FMUWEOMSD',1,15,'2024-05-07 18:05:33.116','2024-05-07 18:06:11.679',NULL),(11,'5924f5c2-3d04-4186-8849-29c3e974c0a8','FYYDW6RWK5ID64DUENLVCQZGJVJEWSKH',0,18,'2024-05-07 18:09:20.732','2024-05-07 18:09:20.732',NULL),(12,'ab6b8e67-a89c-4f1c-ab62-0bdfdd90048b','IZ3SMOJQNZYDATDHNNRDUJDJLM5DYURS',1,18,'2024-05-07 18:09:32.507','2024-05-07 18:10:11.129',NULL),(13,'ceaa102b-269c-4489-bb72-0561e9f483a8','KZRHUPCMHFAEUTKULUXSYPDUI4WCSIKD',1,18,'2024-05-07 19:51:56.729','2024-05-07 19:52:43.424',NULL),(14,'48ad3082-f7d9-4fd2-a267-0e5dbc5a075f','HYWFGUCBG5TD46KPOJEVEY2ILYQWEMD3',0,1,'2024-05-07 21:55:26.856','2024-05-07 21:55:26.856',NULL),(15,'3133f838-5741-4ac9-8fea-b8fd1316941f','MMVCGQT3EQVDSMBFFQ7EYJCGK5KC6MDQ',0,1,'2024-05-07 21:56:06.231','2024-05-07 21:56:06.231',NULL),(16,'6655c770-3e14-4c43-9a34-d584e2f872e6','IJTUUTZGENQSISDGGARXGSJFMYZVC3CE',0,1,'2024-05-07 21:56:15.344','2024-05-07 21:56:15.344',NULL),(17,'2c5ca9ca-ab18-4655-9a08-89a65641f7ec','LVMD45LQFFGXC23LNNKEMZCQJJGCIJCC',0,1,'2024-05-08 17:16:12.169','2024-05-08 17:16:12.169',NULL),(18,'cf9ec6b1-92ee-440d-bdf7-1c26b27f5111','IV5SCZK2FITGS4DQEY6HG5K6GMYTYMLN',0,5,'2024-05-08 19:04:44.490','2024-05-08 19:04:44.490',NULL),(19,'31ed49a8-438c-407e-b2e0-077249ee4ae9','JNAEWM2QJRNWK22CGUXDINKFKB6VEP3X',0,5,'2024-05-08 20:29:01.496','2024-05-08 20:29:01.496',NULL),(20,'adae9055-84ac-44cb-bb11-28f5ff38f56d','NNEE42L5I4UTK4TJGZPDU42NH56SYMKG',0,1,'2024-05-09 16:17:39.910','2024-05-09 16:17:39.910',NULL),(21,'a784a0a0-f3cb-4e30-8d8d-4973555cb4fe','I5IUQTZOPFOVUWSALM7DIYRKOZ3WIJRV',0,1,'2024-05-09 16:20:10.016','2024-05-09 16:20:10.016',NULL),(22,'47048fd1-90f7-4d38-8948-0609167d60f5','GRPHCOKEFBBTS7J6NRXGCTBKGNBECN2Y',0,1,'2024-05-09 16:22:28.193','2024-05-09 16:22:28.193',NULL),(23,'4aaaf14b-76ed-40d4-a729-149b6e460e46','GZSHQPZDJFDTMKKQIQQSG7J6N5GS4Y2B',0,1,'2024-05-09 19:40:41.855','2024-05-09 19:40:41.855',NULL),(24,'92f32d88-858c-43ad-94a6-a6b37c24c481','FZIVQJDJGF3EOUJUKRYHOMLPJA2DE6SV',1,16,'2024-06-17 14:24:21.041','2024-06-19 13:43:27.530',NULL);

--
-- Table structure for table `InvoiceTracker`
--

CREATE TABLE `InvoiceTracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(191) DEFAULT NULL,
  `amount` decimal(10,4) DEFAULT NULL,
  `receiveId` int(11) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `senderEmail` varchar(191) DEFAULT NULL,
  `due_date` datetime(3) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `unit_price` decimal(65,30) DEFAULT NULL,
  `units` decimal(65,30) DEFAULT NULL,
  `payment_type` enum('FULL','PARTIAL','BOTH') DEFAULT NULL,
  `send_date` datetime(3) DEFAULT NULL,
  `invoice_type` enum('UPLOAD','DESCRIPTIVE') DEFAULT NULL,
  `payment_frequency` enum('ONETIME','MANDATE') DEFAULT NULL,
  `invoice_url` varchar(191) DEFAULT NULL,
  `config` varchar(191) DEFAULT NULL,
  `deposit_type` varchar(191) DEFAULT NULL,
  `end_date` datetime(3) DEFAULT NULL,
  `start_date` datetime(3) DEFAULT NULL,
  `approval_status` enum('OPENED','APPROVED','REJECTED','CANCELLED') NOT NULL DEFAULT 'OPENED',
  `paid_status` enum('BALANCE_DUE','PAID','PENDING','PAST_DUE','SCHEDULED') NOT NULL DEFAULT 'PENDING',
  `status` enum('open','cancelled','rejected','paid') NOT NULL DEFAULT 'open',
  `merchant_invoice` varchar(191) DEFAULT NULL,
  `customer_po` varchar(191) DEFAULT NULL,
  `is_approval` tinyint(1) DEFAULT 0,
  `invoice_id` varchar(30) DEFAULT NULL,
  `receiver_email` varchar(191) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `InvoiceTracker_unique_id_key` (`unique_id`),
  KEY `InvoiceTracker_receiveId_fkey` (`receiveId`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `InvoiceTracker`
--

INSERT INTO `InvoiceTracker` VALUES (1,'e03a796a-04bb-48f2-a458-b6b8f6d61307',15.0000,NULL,'2024-04-30 23:53:03.467','2024-04-30 23:53:03.467','luke+bgwgmerchant@paygreencard.com','2024-04-30 23:52:57.153','TEST',15.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-04-30 23:52:57.153','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-04-30 23:52:57.153','OPENED','PENDING','open','','',0,'INV-17673161','Luke+customer0429@paygreencard.com'),(2,'8ed8c69b-2350-4b61-ac34-d5d419f508a2',50.0000,NULL,'2024-05-01 12:39:36.608','2024-05-01 12:39:36.608','bigox.dev2020+merchant2@gmail.com','2024-05-01 12:39:23.710','test invoice',5.000000000000000000000000000000,10.000000000000000000000000000000,'FULL','2024-05-01 12:39:23.710','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 12:39:23.710','OPENED','PENDING','open','','',0,'INV-14512746','bigox.dev2020+customer1@gmail.com'),(3,'34e67e13-bfe8-47e5-b79b-d6dd7553bb9d',30.0000,NULL,'2024-05-01 13:34:26.349','2024-05-01 13:34:26.349','bigox.dev2020+merchant2@gmail.com','2024-05-01 13:34:18.224','test',3.000000000000000000000000000000,10.000000000000000000000000000000,'FULL','2024-05-01 13:34:18.224','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 13:34:18.224','OPENED','PENDING','open','','',0,'INV-89302556','bigox.dev2020+customer2@gmail.com'),(4,'6ccb1e7f-0eb3-4baa-bcad-10c564a6486c',55.0000,NULL,'2024-05-01 17:03:36.137','2024-05-01 17:03:36.137','bigox.dev2020+merchant3@gmail.com','2024-05-01 17:03:27.069','test',11.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-05-01 17:03:27.069','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 17:03:27.069','OPENED','PENDING','open','','',0,'INV-20817248','bigox.dev2020+customer4@gmail.com'),(5,'86bc9b7f-7ab9-42e4-bf59-980afe0bfd58',100.0000,3,'2024-05-01 17:42:13.761','2024-05-01 18:26:17.668','luke+bgwgmerchant@paygreencard.com','2024-05-01 17:42:04.287','test invoice',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 17:42:04.287','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 17:42:04.286','OPENED','PENDING','paid','','',0,'INV-74785371','jehanzebsherali@gmail.com'),(6,'f3cc6290-635d-4fc3-84be-1993dcd82dcd',66.0000,NULL,'2024-05-01 17:57:13.793','2024-05-01 21:55:17.872','luke+bgwgmerchant@paygreencard.com','2024-05-01 17:57:04.451','TEST',66.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 17:57:04.451','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 17:57:04.451','OPENED','PENDING','paid','','',0,'INV-18497836','Luke+customer0501@paygreencard.com'),(7,'5e797c14-c6c3-49c0-8d24-4c8120cb4f54',2000.0000,3,'2024-05-01 18:55:04.743','2024-05-01 18:56:20.808','luke+bgwgmerchant@paygreencard.com','2024-05-20 18:54:29.000','Invoice for Web & Ir payments',20.000000000000000000000000000000,100.000000000000000000000000000000,'FULL','2024-05-01 18:54:29.261','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-20 18:54:29.000','OPENED','PENDING','paid','000212','',0,'INV-63673858','jehanzebsherali@gmail.com'),(8,'eda4b7e0-5068-4c03-b026-7c5430733859',18.0000,NULL,'2024-05-01 19:14:26.866','2024-05-01 19:14:26.866','bigox.dev2020+merchant3@gmail.com','2024-05-01 19:14:16.349','test',3.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-05-01 19:14:16.349','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 19:14:16.349','OPENED','PENDING','open','','',0,'INV-93224293','bigox.dev2020+customer5@gmail.com'),(9,'badfed41-32cc-46e3-8f25-6f55c5ae1523',1.0000,3,'2024-05-01 19:35:17.452','2024-05-01 19:35:57.412','luke+bgwgmerchant@paygreencard.com','2024-05-01 19:35:10.905','test',1.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 19:35:10.905','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 19:35:10.905','OPENED','PENDING','paid','','',0,'INV-32778898','jehanzebsherali@gmail.com'),(10,'bb222638-da74-44d2-82da-15d54cf7e423',10.0000,3,'2024-05-01 19:37:58.769','2024-05-01 19:56:38.954','luke+bgwgmerchant@paygreencard.com','2024-05-09 19:37:38.000','invoice for multiple payment',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 19:37:38.737','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-09 19:37:38.000','OPENED','PENDING','paid','','',0,'INV-14878376','jehanzebsherali@gmail.com'),(11,'7dcf38e6-86be-423e-95d5-7157368b9867',100.0000,NULL,'2024-05-01 19:54:03.823','2024-05-01 19:54:03.823','bigox.dev2020+merchant3@gmail.com','2024-05-01 19:53:56.103','test',10.000000000000000000000000000000,10.000000000000000000000000000000,'FULL','2024-05-01 19:53:56.103','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 19:53:56.103','OPENED','PENDING','open','','',0,'INV-74696286','bigox.dev2020+customer6@gmail.com'),(12,'e0095d5d-ca2e-451c-a5c5-4de1badba803',120.0000,3,'2024-05-01 20:12:02.606','2024-05-02 18:54:28.801','luke+bgwgmerchant@paygreencard.com','2024-05-01 20:11:49.816','test desc new user',120.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 20:11:49.816','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 20:11:49.816','OPENED','PENDING','paid','','',0,'INV-65777911','jehanzebsherali@gmail.com'),(13,'c12c7400-8f94-40d3-a0bc-f66c0a1dd334',20.0000,19,'2024-05-01 20:56:27.438','2024-05-01 20:56:27.438','bigox.dev2020+merchant3@gmail.com','2024-05-01 20:56:19.391','test',5.000000000000000000000000000000,4.000000000000000000000000000000,'FULL','2024-05-01 20:56:19.391','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 20:56:19.391','OPENED','PENDING','open','','',0,'INV-29236589','bigox.dev2020+customer7@gmail.com'),(14,'c2c7d76a-629f-4b2b-bd6d-5281f12e0876',100.0000,NULL,'2024-05-01 22:07:26.767','2024-05-01 22:19:57.450','luke+bgwgmerchant@paygreencard.com','2024-05-01 22:07:19.717','test',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 22:07:19.717','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 22:07:19.717','OPENED','PENDING','paid','','',0,'INV-92770451','jehanzebsherali+100@gmail.com'),(15,'7e2e36ed-bcfe-407d-a7a9-c7a3febc596f',10.0000,20,'2024-05-01 23:17:17.256','2024-05-01 23:22:03.946','luke+bgwgmerchant@paygreencard.com','2024-05-01 23:17:07.425','TEST',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 23:17:07.425','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 23:17:07.424','OPENED','PENDING','paid','','',0,'INV-34714835','gccustomer0501@yopmail.com'),(16,'e7558275-5bd0-4089-aca4-0fe968c1e750',25.0000,20,'2024-05-01 23:25:30.290','2024-05-01 23:26:28.137','luke+bgwgmerchant@paygreencard.com','2024-05-01 23:25:21.577','TEST',25.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 23:25:21.577','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 23:25:21.577','OPENED','PENDING','paid','','',0,'INV-44617515','gccustomer0501@yopmail.com'),(17,'ff75de9b-87a1-4757-b0af-a07c653a7892',30.0000,20,'2024-05-01 23:28:22.449','2024-05-01 23:30:47.079','luke+bgwgmerchant@paygreencard.com','2024-05-01 23:28:11.739','TEST',30.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 23:28:11.739','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 23:28:11.739','OPENED','PENDING','paid','','',0,'INV-52541943','gccustomer0501@yopmail.com'),(18,'8a3a5216-1a69-41c5-b9ba-df44df012193',32.0000,21,'2024-05-01 23:34:09.363','2024-05-01 23:37:29.168','luke+bgwgmerchant@paygreencard.com','2024-05-01 23:34:01.568','TEST',32.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 23:34:01.568','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 23:34:01.567','OPENED','PENDING','paid','','',0,'INV-83753396','gccustomer0501-1@yopmail.com'),(19,'223fb687-4e1c-4b3c-a337-1186631b705a',40.0000,21,'2024-05-01 23:46:59.671','2024-05-01 23:47:09.545','luke+bgwgmerchant@paygreencard.com','2024-05-01 23:46:48.698','TEST',40.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-01 23:46:48.698','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-01 23:46:48.698','OPENED','PENDING','rejected','','',0,'INV-96701599','gccustomer0501-1@yopmail.com'),(20,'6257534e-02bc-427c-9318-832a50f37eba',100.0000,22,'2024-05-02 17:11:19.016','2024-05-02 17:18:25.905','luke+bgwgmerchant@paygreencard.com','2024-05-02 17:10:45.280','test',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-02 17:10:45.280','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-02 17:10:45.279','OPENED','PENDING','paid','','',0,'INV-99750591','musman01011996@gmail.com'),(21,'fdae4e61-4c69-4ce2-bdfc-590cb2cf09a5',15.0000,NULL,'2024-05-03 15:06:00.631','2024-05-03 15:06:11.102','bigox.dev2020+merchant3@gmail.com','2024-05-03 15:05:47.241','test',3.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-05-03 15:05:47.241','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-03 15:05:47.241','OPENED','PENDING','rejected','','',0,'INV-35809108','bigox.dev2020+customer11@gmail.com'),(22,'1e35d558-85ff-4a2c-af06-9b9f9288e6d3',10.0000,3,'2024-05-03 15:08:40.462','2024-05-03 15:10:55.940','luke+bgwgmerchant@paygreencard.com','2024-05-03 15:08:18.044','test inv 1-3 may',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-03 15:08:18.044','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-03 15:08:18.043','OPENED','PENDING','paid','','',0,'INV-79500913','jehanzebsherali@gmail.com'),(23,'2a8c2b93-1c57-4e3c-8465-cab2456e53ed',60.0000,25,'2024-05-10 10:29:59.766','2024-05-10 10:29:59.766','bigox.dev2020+merchant5@gmail.com','2024-05-10 10:29:48.166','Test Invoice',12.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-05-10 10:29:48.166','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-10 10:29:48.166','OPENED','PENDING','open','','',0,'INV-47163877','bigox.dev2020+customer12@gmail.com'),(24,'20c6b720-1ae4-4600-885c-a6acb80f4e38',13.0000,28,'2024-05-10 21:51:58.579','2024-05-10 21:51:58.579','luke+bgwgmerchant@paygreencard.com','2024-05-10 21:51:48.918','Gummies',13.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-10 21:51:48.918','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-10 21:51:48.918','OPENED','PENDING','open','','',0,'INV-21603335','luke+customer0510@paygreencard.com'),(25,'dfa7e416-7558-42c7-a680-b8113174c016',15.0000,25,'2024-05-10 22:47:39.125','2024-05-10 22:47:39.125','bigox.dev2020+merchant5@gmail.com','2024-05-10 22:47:31.552','test',3.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-05-10 22:47:31.553','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-10 22:47:31.552','OPENED','PENDING','open','','',0,'INV-95119851','bigox.dev2020+customer12@gmail.com'),(26,'8b9e19ba-ae78-4214-b25f-87e7226eba3d',30.0000,NULL,'2024-05-10 22:48:54.934','2024-05-10 22:48:54.934','bigox.dev2020+merchant5@gmail.com','2024-05-10 22:48:48.459','test',5.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-05-10 22:48:48.459','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-10 22:48:48.459','OPENED','PENDING','open','','',0,'INV-29155423','bigox.dev+customer13@gmail.com'),(27,'7539cf42-cee1-4c27-b3ad-3b98c58c73ca',30.0000,29,'2024-05-10 22:50:27.479','2024-05-30 10:30:17.091','bigox.dev2020+merchant5@gmail.com','2024-05-10 22:50:21.320','test',5.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-05-10 22:50:21.320','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-10 22:50:21.320','OPENED','PENDING','rejected','','',0,'INV-92990853','bigox.dev2020+customer14@gmail.com'),(28,'572fcecb-9a16-49d3-a0e9-a788d0f4d3de',10.0000,24,'2024-05-14 22:38:55.741','2024-05-14 22:38:55.741','luke+bgwgmerchant@paygreencard.com','2024-05-14 22:38:46.351','Gummies',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-14 22:38:46.351','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-14 22:38:46.350','OPENED','PENDING','open','','',0,'INV-89555899','luke@paygreencard.com'),(29,'62b392f1-e42d-4eef-ac4f-90f4eba5c740',20.0000,24,'2024-05-14 22:41:08.140','2024-05-14 22:45:54.926','luke+bgwgmerchant@paygreencard.com','2024-05-14 22:41:02.218','TEST',20.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-14 22:41:02.218','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-14 22:41:02.217','OPENED','PENDING','paid','','',0,'INV-63072444','luke@paygreencard.com'),(30,'c7e6fccd-668d-4e9e-a915-89a23c682414',20.0000,24,'2024-05-14 22:50:25.250','2024-05-14 23:01:58.244','luke+bgwgmerchant@paygreencard.com','2024-05-14 22:50:17.637','TEST',1.000000000000000000000000000000,20.000000000000000000000000000000,'FULL','2024-05-14 22:50:17.637','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-14 22:50:17.637','OPENED','PENDING','paid','','',0,'INV-33870466','luke@paygreencard.com'),(31,'7f8a6f15-708a-4be7-8b18-0e6a4466bae1',22.0000,29,'2024-05-14 23:38:45.290','2024-05-14 23:38:45.290','bigox.dev2020+merchant5@gmail.com','2024-05-14 23:38:24.670','test invoice',2.000000000000000000000000000000,11.000000000000000000000000000000,'FULL','2024-05-14 23:38:24.670','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-14 23:38:24.670','OPENED','PENDING','open','','',0,'INV-43184478','bigox.dev2020+customer14@gmail.com'),(32,'89f984ba-e280-49ea-91f3-ecb35e41fefe',10.0000,32,'2024-05-17 07:27:20.302','2024-05-17 07:31:07.229','luke+bgwgmerchant@paygreencard.com','2024-05-17 07:27:09.262','Test',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-17 07:27:09.262','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-17 07:27:09.262','OPENED','PENDING','paid','','',0,'INV-94177297','Luke+customer0517-1@paygreencard.com'),(33,'1056a555-daa8-4b61-86db-b3ff90d27d69',100.0000,3,'2024-05-18 00:40:58.338','2024-05-18 00:42:18.882','luke+bgwgmerchant@paygreencard.com','2024-05-18 00:40:51.235','test inv',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-18 00:40:51.235','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-18 00:40:51.234','OPENED','PENDING','paid','','',0,'INV-61895493','jehanzebsherali@gmail.com'),(34,'413a0e01-c19f-4d23-9494-4d4ddcfd30a1',600000.0000,24,'2024-05-18 01:22:01.725','2024-05-18 06:42:44.195','luke+bgwgmerchant@paygreencard.com','2024-05-18 01:21:14.713','TEST',1000.000000000000000000000000000000,600.000000000000000000000000000000,'FULL','2024-05-18 01:21:14.713','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-18 01:21:14.712','OPENED','PENDING','cancelled','','',0,'INV-84781039','luke@paygreencard.com'),(35,'ee24b5dd-45bf-4e97-b3da-f1e38df9fae7',10.0000,24,'2024-05-18 06:42:54.574','2024-05-18 06:43:28.489','luke+bgwgmerchant@paygreencard.com','2024-05-18 06:42:49.354','TEST',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-18 06:42:49.354','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-18 06:42:49.354','OPENED','PENDING','paid','','',0,'INV-72982902','luke@paygreencard.com'),(36,'fb0b00d5-41f0-41c0-b31f-a8630fb08c18',10.0000,33,'2024-05-18 06:51:57.948','2024-05-18 06:51:57.948','luke+bgwgmerchant@paygreencard.com','2024-05-18 06:51:49.412','Test',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-18 06:51:49.412','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-18 06:51:49.412','OPENED','PENDING','open','','',0,'INV-53342556','Luke+customer0517-2@paygreencard.com'),(37,'70eb3500-90c0-4a0a-a2d2-f206646108b9',100.0000,3,'2024-05-20 06:07:59.004','2024-05-20 06:36:06.824','luke+bgwgmerchant@paygreencard.com','2024-05-20 06:07:48.143','test inv',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-20 06:07:48.143','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-20 06:07:48.142','OPENED','PENDING','paid','','',0,'INV-23677538','jehanzebsherali@gmail.com'),(38,'ff16dca4-b32e-4f9c-b811-79b83c7cdf6e',10.0000,24,'2024-05-21 13:34:34.867','2024-05-21 13:34:34.867','luke+bgwgmerchant@paygreencard.com','2024-05-21 13:34:26.508','TEST',10.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-21 13:34:26.508','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-21 13:34:26.508','OPENED','PENDING','open','','',0,'INV-55559663','luke@paygreencard.com'),(39,'8a3e5019-e47a-47c4-9cdc-97d59233cd6a',100.0000,3,'2024-05-27 17:20:54.336','2024-06-20 15:40:48.785','luke+bgwgmerchant@paygreencard.com','2024-05-27 17:20:46.186','inv test',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-27 17:20:46.186','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-27 17:20:46.186','OPENED','PENDING','paid','','',0,'INV-32110605','jehanzebsherali@gmail.com'),(40,'5e6264ef-6275-488b-a520-47f436f71176',100.0000,3,'2024-05-30 16:15:53.156','2024-05-30 19:00:00.861','luke+bgwgmerchant@paygreencard.com','2024-05-30 16:15:37.236','test inv',1.000000000000000000000000000000,100.000000000000000000000000000000,'FULL','2024-05-30 16:15:37.236','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-30 16:15:37.236','OPENED','PENDING','paid','','',0,'INV-71616148','jehanzebsherali@gmail.com'),(41,'faadce34-683b-459f-80ed-23b3a4faa1ee',200.0000,3,'2024-05-30 17:49:40.204','2024-05-30 18:56:48.155','luke+bgwgmerchant@paygreencard.com','2024-05-30 17:49:28.300','inv bgwg',200.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-05-30 17:49:28.300','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-05-30 17:49:28.300','OPENED','PENDING','paid','','',0,'INV-98346279','jehanzebsherali@gmail.com'),(42,'ca72e49b-fc11-4ba8-80c6-48fba7d9ca8e',100.0000,3,'2024-06-03 21:25:19.598','2024-06-03 21:26:47.153','luke+bgwgmerchant@paygreencard.com','2024-06-03 21:25:11.672','test inv',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-03 21:25:11.672','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-03 21:25:11.672','OPENED','PENDING','paid','','',0,'INV-84791517','jehanzebsherali@gmail.com'),(43,'eff098b6-6a6c-4995-8e84-c8b3502a615e',2300.0000,22,'2024-06-14 15:57:36.270','2024-06-14 15:57:36.270','decent-mer1@gmail.com','2024-06-14 15:57:21.084','test invoice',2300.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-14 15:57:21.085','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-14 15:57:21.084','OPENED','PENDING','open','','',0,'INV-76858536','musman01011996@gmail.com'),(44,'ecf8df04-72d9-4bbd-a332-922d620d14cc',400.0000,22,'2024-06-15 00:09:27.205','2024-06-15 00:09:27.205','bigox.dev2020+merchant22@gmail.com','2024-06-15 00:09:01.967','test invoice',400.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-15 00:09:01.967','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-15 00:09:01.966','OPENED','PENDING','open','','',0,'INV-61044796','musman01011996@gmail.com'),(45,'3b30de62-40af-4629-bf40-0ad7d61f8186',100.0000,3,'2024-06-20 15:34:16.850','2024-06-20 15:37:58.394','luke+bgwgmerchant@paygreencard.com','2024-06-20 15:34:08.472','test inv',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-20 15:34:08.472','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-20 15:34:08.472','OPENED','PENDING','paid','','',0,'INV-47428976','jehanzebsherali@gmail.com'),(46,'fb761a2f-526c-4b60-a715-20a4f3bee74f',200.0000,3,'2024-06-20 16:29:59.432','2024-06-20 16:29:59.432','bigox.dev2020+merchant22@gmail.com','2024-06-20 16:29:52.637','test invoice',200.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-20 16:29:52.637','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-20 16:29:52.636','OPENED','PENDING','open','','',0,'INV-48246100','jehanzebsherali@gmail.com'),(47,'212fe776-503c-48c8-aa95-c9fb74f35921',300.0000,22,'2024-06-20 16:34:15.456','2024-06-20 16:34:15.456','bigox.dev2020+merchant22@gmail.com','2024-06-20 16:34:09.587','green invoice',150.000000000000000000000000000000,2.000000000000000000000000000000,'FULL','2024-06-20 16:34:09.587','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-20 16:34:09.587','OPENED','PENDING','open','','',0,'INV-18577662','musman01011996@gmail.com'),(48,'ed4ce2c0-c6d9-4d15-99dc-7e8c60e3e75a',30.0000,39,'2024-06-21 19:33:22.256','2024-06-21 19:33:22.256','luke+bgwgmerchant@paygreencard.com','2024-06-21 19:33:01.534','test',6.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-06-21 19:33:01.534','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-21 19:33:01.533','OPENED','PENDING','open','','',0,'INV-42391353','bigox.dev2020+customer111@gmail.com'),(49,'2ff29383-4137-4241-8b0b-6f6915a09202',30.0000,39,'2024-06-21 19:40:54.867','2024-07-23 13:40:33.688','luke+bgwgmerchant@paygreencard.com','2024-06-21 19:33:01.534','test',6.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-06-21 19:33:01.534','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-21 19:33:01.533','OPENED','PENDING','cancelled','','',0,'INV-85637146','bigox.dev2020+customer111@gmail.com'),(50,'a601029f-4323-4f90-bf53-1a82767409fe',36.0000,NULL,'2024-06-21 19:42:03.312','2024-06-21 19:42:03.312','luke+bgwgmerchant@paygreencard.com','2024-06-21 19:41:48.975','test',6.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-06-21 19:41:48.975','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-21 19:41:48.975','OPENED','PENDING','open','','',0,'INV-10623060','bigox.dev2020+customer123@gmail.com'),(51,'14e8dc74-2500-433f-bbae-5a496364c866',36.0000,NULL,'2024-06-21 19:44:55.271','2024-06-21 19:44:55.271','luke+bgwgmerchant@paygreencard.com','2024-06-21 19:41:48.975','test',6.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-06-21 19:41:48.975','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-21 19:41:48.975','OPENED','PENDING','open','','',0,'INV-94970473','bigox.dev2020+customer123@gmail.com'),(52,'31cf8009-b64b-4543-a292-af081ffb8662',6.0000,39,'2024-06-21 20:00:18.659','2024-06-21 20:00:18.659','luke+bgwgmerchant@paygreencard.com','2024-06-21 20:00:11.679','123',3.000000000000000000000000000000,2.000000000000000000000000000000,'FULL','2024-06-21 20:00:11.679','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-21 20:00:11.679','OPENED','PENDING','open','','',0,'INV-74486079','bigox.dev2020+customer111@gmail.com'),(53,'e78af88a-d5c0-4826-b31c-576d344cdf9e',100.0000,36,'2024-06-25 18:51:06.935','2024-06-25 18:51:06.935','luke+bgwgmerchant@paygreencard.com','2024-06-25 18:50:59.577','Test inv',100.000000000000000000000000000000,1.000000000000000000000000000000,'FULL','2024-06-25 18:50:59.577','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-06-25 18:50:59.577','OPENED','PENDING','open','','',0,'INV-43641235','dhruval1234@yopmail.com'),(54,'f4efb1e8-b6a8-41d1-abca-5f1132312bdb',21.0000,29,'2024-07-23 13:07:50.321','2024-07-23 13:07:50.321','bigox.dev2020+merchantuser4@gmail.com','2024-07-23 13:07:42.951','test',3.000000000000000000000000000000,7.000000000000000000000000000000,'FULL','2024-07-23 13:07:42.951','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-07-23 13:07:42.951','OPENED','PENDING','open','','',0,'INV-76760487','bigox.dev2020+customer14@gmail.com'),(55,'07f4e997-ebfa-4937-8dd7-2d11a375e75f',24.0000,29,'2024-07-23 13:16:38.103','2024-07-23 13:16:38.103','bigox.dev2020+merchant5@gmail.com','2024-07-23 13:14:13.694','test',4.000000000000000000000000000000,6.000000000000000000000000000000,'FULL','2024-07-23 13:14:13.694','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-07-23 13:14:13.694','OPENED','PENDING','open','','',0,'INV-17904002','bigox.dev2020+customer14@gmail.com'),(56,'bcca16ad-cc1e-4540-bb9d-3d24eeaf37f3',25.0000,29,'2024-07-23 13:24:19.838','2024-07-23 13:24:19.838','bigox.dev2020+merchant5@gmail.com','2024-07-23 13:24:10.423','test',5.000000000000000000000000000000,5.000000000000000000000000000000,'FULL','2024-07-23 13:24:10.423','DESCRIPTIVE','ONETIME','',NULL,'ONETIME',NULL,'2024-07-23 13:24:10.422','OPENED','PENDING','open','','',0,'INV-17673068','bigox.dev2020+customer14@gmail.com');

--
-- Table structure for table `LoginHistory`
--

CREATE TABLE `LoginHistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `device` varchar(191) DEFAULT NULL,
  `country_code` varchar(191) DEFAULT NULL,
  `country_name` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `os` varchar(191) DEFAULT NULL,
  `platform` varchar(191) DEFAULT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `LoginHistory_userId_fkey` (`userId`),
  CONSTRAINT `LoginHistory_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `LoginHistory`
--

INSERT INTO `LoginHistory` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1,'2024-04-30 21:15:19.807','2024-04-30 21:15:19.807',NULL,NULL),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'2024-04-30 21:21:03.037','2024-04-30 21:21:03.037',NULL,NULL),(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-04-30 21:42:11.188','2024-07-23 13:37:36.404',NULL,NULL),(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1,'2024-04-30 22:08:52.424','2024-04-30 22:08:52.424',NULL,NULL),(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1,'2024-04-30 22:11:08.502','2024-04-30 22:11:08.502',NULL,NULL),(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-04-30 22:37:15.699','2024-07-23 14:21:36.992',NULL,NULL),(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-01 01:52:49.185','2024-07-23 13:37:36.404',NULL,NULL),(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-01 01:53:40.839','2024-07-23 13:37:36.404',NULL,NULL),(10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-01 02:12:03.594','2024-07-23 13:37:36.404',NULL,NULL),(11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,'2024-05-01 02:27:04.561','2024-06-17 14:00:21.538',NULL,NULL),(12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-01 15:26:00.865','2024-07-23 13:37:36.404',NULL,NULL),(13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-01 15:29:34.144','2024-07-23 13:37:36.404',NULL,NULL),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-01 15:35:34.211','2024-07-23 14:21:36.992',NULL,NULL),(15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,'2024-05-01 16:30:38.466','2024-06-17 14:00:21.538',NULL,NULL),(16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12,1,'2024-05-01 16:35:52.853','2024-05-01 16:35:52.853',NULL,NULL),(17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,'2024-05-01 16:37:27.431','2024-06-17 14:00:21.538',NULL,NULL),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,0,'2024-05-01 17:03:03.171','2024-05-07 14:49:31.937',NULL,NULL),(19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-02 07:10:39.555','2024-07-23 13:37:36.404',NULL,NULL),(20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-03 15:21:13.705','2024-07-23 13:37:36.404',NULL,NULL),(21,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,'2024-05-06 01:49:16.686','2024-06-17 14:00:21.538',NULL,NULL),(22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 01:51:39.707','2024-07-23 13:37:36.404',NULL,NULL),(23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 02:52:54.848','2024-07-23 13:37:36.404',NULL,NULL),(24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 02:54:12.057','2024-07-23 13:37:36.404',NULL,NULL),(25,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-06 03:03:15.275','2024-07-09 20:50:51.855',NULL,NULL),(26,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-06 03:16:28.027','2024-07-23 13:23:43.012',NULL,NULL),(27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-06 14:48:13.470','2024-07-23 13:23:43.012',NULL,NULL),(28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-06 16:12:22.032','2024-06-28 19:32:01.744',NULL,NULL),(29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,0,'2024-05-06 16:16:03.838','2024-05-07 14:49:31.937',NULL,NULL),(30,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-06 16:16:18.286','2024-07-23 13:23:43.012',NULL,NULL),(31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 17:47:40.227','2024-07-23 13:37:36.404',NULL,NULL),(32,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 17:47:46.654','2024-07-23 13:37:36.404',NULL,NULL),(33,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 18:23:33.720','2024-07-23 13:37:36.404',NULL,NULL),(34,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 21:35:49.368','2024-07-23 13:37:36.404',NULL,NULL),(35,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-06 21:36:49.785','2024-07-23 13:37:36.404',NULL,NULL),(36,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 00:42:19.900','2024-07-23 13:23:43.012',NULL,NULL),(37,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 13:03:35.637','2024-07-23 13:23:43.012',NULL,NULL),(38,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 13:04:36.243','2024-07-23 13:23:43.012',NULL,NULL),(39,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 13:12:24.338','2024-07-23 13:23:43.012',NULL,NULL),(40,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 13:49:38.397','2024-07-23 13:23:43.012',NULL,NULL),(41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 14:12:25.563','2024-07-23 13:23:43.012',NULL,NULL),(42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 14:15:29.009','2024-07-23 13:23:43.012',NULL,NULL),(43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 14:19:42.228','2024-07-23 13:23:43.012',NULL,NULL),(44,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 14:23:34.198','2024-07-23 13:23:43.012',NULL,NULL),(45,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 14:33:00.989','2024-07-23 13:23:43.012',NULL,NULL),(46,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,0,'2024-05-07 14:36:04.397','2024-05-07 14:49:31.937',NULL,NULL),(47,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,0,'2024-05-07 14:39:05.522','2024-05-07 14:49:31.937',NULL,NULL),(48,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,0,'2024-05-07 14:39:38.546','2024-05-07 14:49:31.937',NULL,NULL),(49,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13,1,'2024-05-07 14:49:31.940','2024-05-07 14:49:31.940',NULL,NULL),(50,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-07 17:49:35.125','2024-07-23 13:37:36.404',NULL,NULL),(51,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 17:51:02.282','2024-07-03 17:09:19.461',NULL,NULL),(52,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 17:52:17.816','2024-07-03 17:09:19.461',NULL,NULL),(53,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 17:53:26.180','2024-07-03 17:09:19.461',NULL,NULL),(54,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-07 18:03:09.340','2024-06-28 19:32:01.744',NULL,NULL),(55,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-07 18:04:45.627','2024-06-28 19:32:01.744',NULL,NULL),(56,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-07 18:05:21.770','2024-07-09 20:50:51.855',NULL,NULL),(57,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-07 18:07:21.754','2024-07-09 20:50:51.855',NULL,NULL),(58,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 18:09:07.520','2024-07-03 17:09:19.461',NULL,NULL),(59,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 18:11:03.258','2024-07-03 17:09:19.461',NULL,NULL),(60,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 18:18:06.827','2024-07-03 17:09:19.461',NULL,NULL),(61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 18:45:07.737','2024-07-03 17:09:19.461',NULL,NULL),(62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 18:49:27.004','2024-07-03 17:09:19.461',NULL,NULL),(63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 19:12:19.358','2024-07-03 17:09:19.461',NULL,NULL),(64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 19:50:28.866','2024-07-03 17:09:19.461',NULL,NULL),(65,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,'2024-05-07 19:50:45.338','2024-06-17 14:00:21.538',NULL,NULL),(66,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-07 19:51:07.498','2024-07-09 20:50:51.855',NULL,NULL),(67,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 19:51:46.888','2024-07-03 17:09:19.461',NULL,NULL),(68,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 19:53:15.340','2024-07-03 17:09:19.461',NULL,NULL),(69,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 19:53:43.643','2024-07-03 17:09:19.461',NULL,NULL),(70,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 19:54:01.392','2024-07-23 13:23:43.012',NULL,NULL),(71,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 19:54:18.629','2024-07-23 13:23:43.012',NULL,NULL),(72,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-07 19:54:45.491','2024-07-23 13:23:43.012',NULL,NULL),(73,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 21:13:13.820','2024-07-03 17:09:19.461',NULL,NULL),(74,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 21:13:35.881','2024-07-03 17:09:19.461',NULL,NULL),(75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-07 21:14:06.262','2024-07-03 17:09:19.461',NULL,NULL),(76,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-07 21:14:38.884','2024-07-23 13:37:36.404',NULL,NULL),(77,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-07 21:55:18.091','2024-07-23 13:37:36.404',NULL,NULL),(78,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:28:01.846','2024-07-23 13:23:43.012',NULL,NULL),(79,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:30:11.789','2024-07-23 13:23:43.012',NULL,NULL),(80,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:30:30.805','2024-07-23 13:23:43.012',NULL,NULL),(81,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:31:21.311','2024-07-23 13:23:43.012',NULL,NULL),(82,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:32:48.481','2024-07-23 13:23:43.012',NULL,NULL),(83,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 00:34:40.561','2024-07-23 13:23:43.012',NULL,NULL),(84,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:05:48.830','2024-07-23 13:23:43.012',NULL,NULL),(85,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:07:30.430','2024-07-23 13:23:43.012',NULL,NULL),(86,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:10:31.300','2024-07-23 13:23:43.012',NULL,NULL),(87,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:15:59.654','2024-07-23 13:23:43.012',NULL,NULL),(88,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:16:21.873','2024-07-23 13:23:43.012',NULL,NULL),(89,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 01:16:47.393','2024-07-23 13:23:43.012',NULL,NULL),(90,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 14:31:06.974','2024-07-23 13:23:43.012',NULL,NULL),(91,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 14:45:24.556','2024-07-23 13:23:43.012',NULL,NULL),(92,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 14:55:59.169','2024-07-23 13:23:43.012',NULL,NULL),(93,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-08 15:09:15.644','2024-07-23 13:23:43.012',NULL,NULL),(94,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-08 16:15:52.953','2024-07-23 13:37:36.404',NULL,NULL),(95,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-08 16:23:07.554','2024-07-23 13:37:36.404',NULL,NULL),(96,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-08 18:45:00.285','2024-07-23 13:37:36.404',NULL,NULL),(97,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-09 16:01:04.231','2024-06-28 19:32:01.744',NULL,NULL),(98,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-10 05:21:57.614','2024-07-03 17:09:19.461',NULL,NULL),(99,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-10 05:23:26.061','2024-07-03 17:09:19.461',NULL,NULL),(100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-10 10:28:48.130','2024-07-23 13:23:43.012',NULL,NULL),(101,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-10 19:10:20.289','2024-07-23 13:23:43.012',NULL,NULL),(102,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-10 21:35:59.743','2024-07-03 17:09:19.461',NULL,NULL),(103,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-10 21:38:45.204','2024-07-03 17:09:19.461',NULL,NULL),(104,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-10 21:40:11.395','2024-07-03 17:09:19.461',NULL,NULL),(105,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-13 09:19:43.234','2024-07-23 13:23:43.012',NULL,NULL),(106,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-13 20:28:36.926','2024-07-23 13:37:36.404',NULL,NULL),(107,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-14 02:42:43.721','2024-07-09 20:50:51.855',NULL,NULL),(108,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-14 15:10:48.839','2024-07-09 20:50:51.855',NULL,NULL),(109,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-14 15:13:10.572','2024-06-28 19:32:01.744',NULL,NULL),(110,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-14 15:23:20.524','2024-06-28 19:32:01.744',NULL,NULL),(111,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-14 16:00:19.277','2024-07-23 13:23:43.012',NULL,NULL),(112,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-14 16:50:26.332','2024-07-23 14:21:36.992',NULL,NULL),(113,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-14 21:09:21.204','2024-07-03 17:09:19.461',NULL,NULL),(114,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-14 23:37:15.438','2024-07-23 13:23:43.012',NULL,NULL),(115,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-15 00:30:25.411','2024-07-23 13:23:43.012',NULL,NULL),(116,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-15 00:48:51.207','2024-07-23 14:21:36.992',NULL,NULL),(117,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-15 16:24:48.115','2024-07-03 17:09:19.461',NULL,NULL),(118,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-15 17:47:35.301','2024-07-23 13:37:36.404',NULL,NULL),(119,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-15 22:14:57.399','2024-07-09 20:50:51.855',NULL,NULL),(120,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-16 10:10:32.659','2024-07-09 20:50:51.855',NULL,NULL),(121,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-05-17 13:35:21.019','2024-06-28 19:32:01.744',NULL,NULL),(122,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-17 13:43:23.339','2024-07-09 20:50:51.855',NULL,NULL),(123,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-05-17 15:37:46.829','2024-07-09 17:18:24.055',NULL,NULL),(124,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-18 08:03:57.058','2024-07-03 17:09:19.461',NULL,NULL),(125,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-20 13:14:33.119','2024-07-09 20:50:51.855',NULL,NULL),(126,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-05-20 14:26:01.392','2024-07-23 13:23:43.012',NULL,NULL),(127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-20 15:51:32.338','2024-07-23 13:37:36.404',NULL,NULL),(128,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-20 15:57:10.101','2024-07-09 20:50:51.855',NULL,NULL),(129,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-20 16:17:56.757','2024-07-23 13:37:36.404',NULL,NULL),(130,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-21 00:20:59.961','2024-07-09 20:50:51.855',NULL,NULL),(131,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 00:22:55.989','2024-07-23 13:37:36.404',NULL,NULL),(132,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-21 00:29:37.612','2024-07-23 14:21:36.992',NULL,NULL),(133,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 11:35:00.071','2024-07-23 13:37:36.404',NULL,NULL),(134,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-21 11:39:40.784','2024-07-23 14:21:36.992',NULL,NULL),(135,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 12:14:18.199','2024-07-23 13:37:36.404',NULL,NULL),(136,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-05-21 12:22:46.466','2024-07-03 17:09:19.461',NULL,NULL),(137,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 13:40:40.454','2024-07-23 13:37:36.404',NULL,NULL),(138,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 14:18:30.107','2024-07-23 13:37:36.404',NULL,NULL),(139,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-05-21 15:57:49.535','2024-07-09 17:18:24.055',NULL,NULL),(140,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 16:11:35.158','2024-07-23 13:37:36.404',NULL,NULL),(141,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-05-21 18:33:28.025','2024-07-23 14:21:36.992',NULL,NULL),(142,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-21 18:41:31.051','2024-07-23 13:37:36.404',NULL,NULL),(143,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-28 15:39:46.071','2024-07-09 20:50:51.855',NULL,NULL),(144,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-05-31 15:35:47.533','2024-07-09 20:50:51.855',NULL,NULL),(145,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-05-31 18:07:08.787','2024-07-23 13:37:36.404',NULL,NULL),(146,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-06-06 16:10:57.766','2024-07-03 17:09:19.461',NULL,NULL),(147,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,1,'2024-06-17 14:00:21.541','2024-06-17 14:00:21.541',NULL,NULL),(148,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-06-17 14:01:44.379','2024-07-23 13:37:36.404',NULL,NULL),(149,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-17 14:04:36.114','2024-07-23 13:23:43.012',NULL,NULL),(150,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-06-17 14:43:07.549','2024-07-23 13:37:36.404',NULL,NULL),(151,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-17 14:45:45.370','2024-06-28 19:32:01.744',NULL,NULL),(152,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-17 14:54:36.148','2024-06-28 19:32:01.744',NULL,NULL),(153,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-06-17 14:57:26.195','2024-07-09 20:50:51.855',NULL,NULL),(154,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-17 14:58:18.382','2024-07-23 13:23:43.012',NULL,NULL),(155,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-17 16:38:31.715','2024-07-23 13:23:43.012',NULL,NULL),(156,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-19 13:27:26.781','2024-07-23 13:23:43.012',NULL,NULL),(157,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-06-19 18:00:11.096','2024-07-03 17:09:19.461',NULL,NULL),(158,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-19 21:38:29.162','2024-06-28 19:32:01.744',NULL,NULL),(159,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-06-19 21:43:10.480','2024-07-23 13:37:36.404',NULL,NULL),(160,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-06-19 21:50:04.673','2024-07-09 20:50:51.855',NULL,NULL),(161,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-19 21:50:51.096','2024-06-28 19:32:01.744',NULL,NULL),(162,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,0,'2024-06-19 21:51:18.983','2024-07-09 20:50:51.855',NULL,NULL),(163,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-20 09:55:23.753','2024-07-23 13:23:43.012',NULL,NULL),(164,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-06-20 15:33:01.582','2024-07-03 17:09:19.461',NULL,NULL),(165,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-06-21 19:32:21.107','2024-07-23 13:37:36.404',NULL,NULL),(166,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,1,'2024-06-21 22:49:20.061','2024-06-21 22:49:20.061',NULL,NULL),(167,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,0,'2024-06-21 23:13:33.367','2024-07-03 17:09:19.461',NULL,NULL),(168,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-06-24 22:10:15.250','2024-07-09 17:18:24.055',NULL,NULL),(169,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:29:57.677','2024-06-28 19:32:01.744',NULL,NULL),(170,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:30:10.382','2024-06-28 19:32:01.744',NULL,NULL),(171,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:36:18.270','2024-06-28 19:32:01.744',NULL,NULL),(172,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:38:55.708','2024-06-28 19:32:01.744',NULL,NULL),(173,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:41:34.536','2024-06-28 19:32:01.744',NULL,NULL),(174,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 12:43:32.890','2024-06-28 19:32:01.744',NULL,NULL),(175,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,0,'2024-06-25 12:48:04.939','2024-06-25 13:54:07.305',NULL,NULL),(176,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,0,'2024-06-25 12:52:35.450','2024-06-25 13:54:07.305',NULL,NULL),(177,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,0,'2024-06-25 13:06:53.871','2024-06-25 13:54:07.305',NULL,NULL),(178,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 13:24:59.821','2024-06-28 19:32:01.744',NULL,NULL),(179,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 13:47:04.605','2024-06-28 19:32:01.744',NULL,NULL),(180,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,'2024-06-25 13:49:59.392','2024-06-28 19:32:01.744',NULL,NULL),(181,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,1,'2024-06-25 13:54:07.307','2024-06-25 13:54:07.307',NULL,NULL),(182,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-06-25 13:56:50.991','2024-07-23 13:37:36.404',NULL,NULL),(183,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,0,'2024-06-25 14:02:27.892','2024-07-23 13:39:32.500',NULL,NULL),(184,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-06-25 23:05:51.540','2024-07-09 17:18:24.055',NULL,NULL),(185,NULL,NULL,NULL,NULL,NULL,NULL,NULL,62,1,'2024-06-25 23:07:37.868','2024-06-25 23:07:37.868',NULL,NULL),(186,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-06-26 16:54:23.727','2024-07-09 17:18:24.055',NULL,NULL),(187,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,1,'2024-06-26 17:02:41.211','2024-06-26 17:02:41.211',NULL,NULL),(188,NULL,NULL,NULL,NULL,NULL,NULL,NULL,65,0,'2024-06-27 21:49:55.712','2024-06-27 21:52:45.327',NULL,NULL),(189,NULL,NULL,NULL,NULL,NULL,NULL,NULL,65,1,'2024-06-27 21:52:45.331','2024-06-27 21:52:45.331',NULL,NULL),(190,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-28 19:28:11.861','2024-07-23 13:23:43.012',NULL,NULL),(191,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66,0,'2024-06-28 19:30:56.737','2024-07-23 13:07:20.839',NULL,NULL),(192,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,1,'2024-06-28 19:32:01.746','2024-06-28 19:32:01.746',NULL,NULL),(193,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-06-28 19:32:46.757','2024-07-23 13:23:43.012',NULL,NULL),(194,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66,0,'2024-06-28 19:34:01.499','2024-07-23 13:07:20.839',NULL,NULL),(195,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-07-01 14:08:48.696','2024-07-23 13:23:43.012',NULL,NULL),(196,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18,1,'2024-07-03 17:09:19.464','2024-07-03 17:09:19.464',NULL,NULL),(197,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-07-03 17:59:52.921','2024-07-09 17:18:24.055',NULL,NULL),(198,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-07-09 16:41:52.628','2024-07-09 17:18:24.055',NULL,NULL),(199,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-07-09 16:42:40.647','2024-07-09 17:18:24.055',NULL,NULL),(200,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-07-09 16:50:11.377','2024-07-09 17:18:24.055',NULL,NULL),(201,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,'2024-07-09 17:16:03.541','2024-07-09 17:18:24.055',NULL,NULL),(202,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,1,'2024-07-09 17:18:24.061','2024-07-09 17:18:24.061',NULL,NULL),(203,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-07-09 19:45:57.071','2024-07-23 13:37:36.404',NULL,NULL),(204,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'2024-07-09 19:47:04.242','2024-07-23 13:37:36.404',NULL,NULL),(205,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15,1,'2024-07-09 20:50:51.857','2024-07-09 20:50:51.857',NULL,NULL),(206,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-07-23 12:53:39.449','2024-07-23 13:23:43.012',NULL,NULL),(207,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66,0,'2024-07-23 12:55:10.262','2024-07-23 13:07:20.839',NULL,NULL),(208,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,0,'2024-07-23 13:03:59.230','2024-07-23 13:23:43.012',NULL,NULL),(209,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66,1,'2024-07-23 13:07:20.843','2024-07-23 13:07:20.843',NULL,NULL),(210,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,1,'2024-07-23 13:23:43.016','2024-07-23 13:23:43.016',NULL,NULL),(211,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'2024-07-23 13:37:36.407','2024-07-23 13:37:36.407',NULL,NULL),(212,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,1,'2024-07-23 13:39:32.502','2024-07-23 13:39:32.502',NULL,NULL),(213,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,0,'2024-07-23 14:20:43.628','2024-07-23 14:21:36.992',NULL,NULL),(214,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,1,'2024-07-23 14:21:36.993','2024-07-23 14:21:36.993',NULL,NULL);

--
-- Table structure for table `Loyalty`
--

CREATE TABLE `Loyalty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `points_per_dollar` int(11) NOT NULL DEFAULT 0,
  `dollar_per_points` int(11) NOT NULL DEFAULT 0,
  `points_expirydays` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updated_at` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `User` (`user_id`),
  CONSTRAINT `User` FOREIGN KEY (`user_id`) REFERENCES `User` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Loyalty`
--

INSERT INTO `Loyalty` VALUES (3,'175ccf7e-53c1-45b7-9266-a637ca67b590',16,50,1000,15,'2024-05-13 17:20:42.695','2024-05-13 17:20:42.695'),(4,'2d3483aa-7d42-47a3-a2ac-9fbf9e6cfb6d',7,1,1,90,'2024-05-17 08:05:06.162','2024-05-17 08:05:06.162');

--
-- Table structure for table `OtpTemp`
--

CREATE TABLE `OtpTemp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `key` varchar(255) NOT NULL,
  `exp_date` datetime NOT NULL,
  `otp` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `OtpTemp`
--

INSERT INTO `OtpTemp` VALUES (95,16,'59ab7a38-a625-4705-92dc-5dcf297bd983','2024-05-08 13:54:32',6468,0,'2024-05-08 13:44:32.155','2024-05-08 13:44:32.155'),(96,16,'87e33806-e963-48f2-9e2b-f707b6c60022','2024-05-08 13:56:53',9124,0,'2024-05-08 13:46:53.961','2024-05-08 13:46:53.961'),(97,16,'783bb895-67b0-4d0d-b5ad-8c1f0f1309ea','2024-05-08 13:58:45',5954,0,'2024-05-08 13:48:45.308','2024-05-08 13:48:45.308'),(98,16,'226fcc61-4b72-428d-b04b-92628fffc13e','2024-05-08 14:03:25',3537,0,'2024-05-08 13:53:25.198','2024-05-08 13:53:25.198'),(99,16,'a09773f0-a3ff-4471-91d7-1dd91b095fba','2024-05-08 14:26:21',4039,0,'2024-05-08 14:16:21.207','2024-05-08 14:16:21.207'),(100,16,'98a0fb20-d7a7-4d40-b86e-27f5c682bb39','2024-05-08 14:30:03',4740,0,'2024-05-08 14:20:03.315','2024-05-08 14:20:03.315'),(101,16,'b14634fc-fd94-4774-b661-fdc8e7de7a13','2024-05-08 14:35:37',6310,0,'2024-05-08 14:25:37.957','2024-05-08 14:25:37.957'),(102,16,'51f901de-a7b0-4eaa-8359-a67ea1a2553b','2024-05-08 14:42:08',4736,0,'2024-05-08 14:32:08.318','2024-05-08 14:32:08.318'),(103,16,'ede576ce-92fc-4290-9583-8a3f3cd9745d','2024-05-08 14:51:14',7062,0,'2024-05-08 14:41:14.411','2024-05-08 14:41:14.411'),(104,16,'de5a5755-785a-4f5a-ac46-7e0f6de196d4','2024-05-08 14:51:47',1007,0,'2024-05-08 14:41:47.053','2024-05-08 14:41:47.053'),(105,16,'4d71e40e-5f45-4e01-871d-3ed7ddeec32b','2024-05-08 14:53:56',5395,0,'2024-05-08 14:43:56.694','2024-05-08 14:43:56.694'),(106,16,'2db74373-67be-4a66-bea1-4e5256431d5a','2024-05-08 14:55:08',6555,0,'2024-05-08 14:45:08.388','2024-05-08 14:45:08.388'),(107,16,'c84e36fa-94ee-4db4-a459-fc4017d85361','2024-05-08 15:04:32',7091,0,'2024-05-08 14:54:32.533','2024-05-08 14:54:32.533'),(108,16,'0783a753-7f1b-45fd-96c1-d2af4ead664b','2024-05-08 15:05:37',6900,0,'2024-05-08 14:55:37.221','2024-05-08 14:55:37.221'),(109,16,'803e969c-520c-4fa8-aec9-9b1ca68150f3','2024-05-08 15:14:59',5880,0,'2024-05-08 15:04:59.253','2024-05-08 15:04:59.253'),(110,1,'c118d146-4f03-4e27-b4ab-888c8825608c','2024-05-08 15:34:10',2082,0,'2024-05-08 15:24:10.494','2024-05-08 15:24:10.494'),(111,1,'deaed7c2-d82a-465f-8c9e-7e17e02e8e29','2024-05-08 15:35:34',3373,0,'2024-05-08 15:25:34.739','2024-05-08 15:25:34.739'),(112,1,'afda18b5-1c80-4cef-83c9-6f7777c37e60','2024-05-08 15:50:30',3183,0,'2024-05-08 15:40:30.492','2024-05-08 15:40:30.492'),(115,1,'284595a3-0283-40f6-98db-d181db6a2b04','2024-05-08 16:10:05',8425,0,'2024-05-08 16:00:05.634','2024-05-08 16:00:05.634'),(116,1,'0709bb8c-9849-4385-a615-a8d7726ddb07','2024-05-08 16:25:37',9045,0,'2024-05-08 16:15:37.167','2024-05-08 16:15:37.167'),(117,1,'85aa041e-e479-413e-b813-5332796dab12','2024-05-08 16:32:54',9824,0,'2024-05-08 16:22:54.921','2024-05-08 16:22:54.921'),(118,1,'73fb1a8e-2ea2-48ca-a2b0-e7fad6a22e81','2024-05-08 18:53:26',7403,0,'2024-05-08 18:43:26.438','2024-05-08 18:43:26.438'),(119,1,'b0d659ee-d875-45f3-80b7-25b074bd5af8','2024-05-08 19:13:35',9563,0,'2024-05-08 19:03:35.052','2024-05-08 19:03:35.052'),(120,14,'f36c2426-c1b7-4c2c-b662-4fe3c0841954','2024-05-09 16:10:49',4020,0,'2024-05-09 16:00:49.780','2024-05-09 16:00:49.780'),(121,18,'fc2d3eb1-50a1-4a34-afda-2f3a3be88317','2024-05-10 05:19:13',8454,0,'2024-05-10 05:09:13.990','2024-05-10 05:09:13.990'),(122,18,'e2d159d3-916f-4d42-920e-ff5c59b5b82c','2024-05-10 05:31:41',1334,0,'2024-05-10 05:21:41.747','2024-05-10 05:21:41.747'),(123,18,'215ad705-1183-4d18-9b4c-7ddfb7fd4975','2024-05-10 05:33:15',2950,0,'2024-05-10 05:23:15.225','2024-05-10 05:23:15.225'),(124,16,'35d4743c-2876-4635-be9e-1a472e1e38b0','2024-05-10 10:38:34',2259,0,'2024-05-10 10:28:34.505','2024-05-10 10:28:34.505'),(125,16,'20cbaa47-4a90-4112-aa76-e2855dcd4c76','2024-05-10 19:16:45',6474,0,'2024-05-10 19:06:45.571','2024-05-10 19:06:45.571'),(126,18,'98f5723c-bdc0-4056-abe2-c4126c8cec48','2024-05-10 21:44:59',3117,0,'2024-05-10 21:34:59.968','2024-05-10 21:34:59.968'),(127,18,'d05b9e68-774e-4a0f-855f-bbe40ced7f1a','2024-05-10 21:48:23',3967,0,'2024-05-10 21:38:23.077','2024-05-10 21:38:23.077'),(128,18,'d280c88e-4ef7-44b3-bdc2-950bf6903e39','2024-05-10 21:49:54',9582,0,'2024-05-10 21:39:54.848','2024-05-10 21:39:54.849'),(129,16,'89a59a9b-57ee-41e6-85c9-d24db9f239bb','2024-05-13 09:29:27',7628,0,'2024-05-13 09:19:27.731','2024-05-13 09:19:27.731'),(130,1,'75cf54a0-c672-47a2-a391-745dbc535b74','2024-05-13 20:37:51',6378,0,'2024-05-13 20:27:51.305','2024-05-13 20:27:51.305'),(131,15,'d01043fd-3949-4522-8a61-edfdb35a8705','2024-05-14 02:52:30',8791,0,'2024-05-14 02:42:30.973','2024-05-14 02:42:30.973'),(132,15,'d805ebc0-4f87-467e-96e3-9ad9c9ae986f','2024-05-14 15:20:27',6790,0,'2024-05-14 15:10:27.462','2024-05-14 15:10:27.462'),(133,14,'7a9784b1-85f8-4ff5-8bf6-6e73de922bd7','2024-05-14 15:22:54',9463,0,'2024-05-14 15:12:54.885','2024-05-14 15:12:54.885'),(134,14,'b658d6bf-f55d-4e4e-83bf-e38554e2abe6','2024-05-14 15:33:07',4279,0,'2024-05-14 15:23:07.780','2024-05-14 15:23:07.780'),(135,16,'4a4aebb9-00a9-437d-b17a-bee1b2bc5113','2024-05-14 16:10:00',5783,0,'2024-05-14 16:00:00.735','2024-05-14 16:00:00.735'),(136,7,'6fa4b11b-2276-4d93-bec3-b127487449c3','2024-05-14 17:00:01',2844,0,'2024-05-14 16:50:01.462','2024-05-14 16:50:01.462'),(137,18,'df90fe10-4396-434a-bed8-5e7fddc3ae21','2024-05-14 21:18:28',2251,0,'2024-05-14 21:08:28.523','2024-05-14 21:08:28.523'),(138,18,'ea4a3ebc-b810-46a8-9e75-99a14ff80ae4','2024-05-14 21:52:47',7776,0,'2024-05-14 21:42:47.751','2024-05-14 21:42:47.751'),(139,16,'8a2b18e0-d95f-47d9-8ef4-e6b66456f789','2024-05-14 23:46:59',6166,0,'2024-05-14 23:36:59.659','2024-05-14 23:36:59.659'),(140,16,'6e68b8ac-7b66-4918-b921-2d6fb11ffd6a','2024-05-15 00:39:58',2674,0,'2024-05-15 00:29:58.794','2024-05-15 00:29:58.794'),(141,7,'648897d4-a4bf-48c1-a651-d23d274bec38','2024-05-15 00:58:36',1009,0,'2024-05-15 00:48:36.168','2024-05-15 00:48:36.168'),(142,18,'759d87aa-f885-4c9e-ad4a-ecd421a8b88c','2024-05-15 16:33:55',7930,0,'2024-05-15 16:23:55.019','2024-05-15 16:23:55.019'),(143,1,'e6903a21-9215-48d6-bf7e-0f2cd865d5cf','2024-05-15 16:37:46',9527,0,'2024-05-15 16:27:46.320','2024-05-15 16:27:46.320'),(144,18,'84edbb8b-193f-4a18-96dd-150a0c8954b0','2024-05-15 16:38:22',5494,0,'2024-05-15 16:28:22.946','2024-05-15 16:28:22.946'),(145,18,'49fb0be9-bf14-435d-be9b-b7e84df0e4b3','2024-05-15 16:38:33',3049,0,'2024-05-15 16:28:33.759','2024-05-15 16:28:33.759'),(146,1,'f8b91c1d-db72-4296-9303-f97bb2d639c7','2024-05-15 17:56:55',2210,0,'2024-05-15 17:46:55.551','2024-05-15 17:46:55.551'),(147,15,'44aed180-1d9d-4abb-baba-626786cf07ec','2024-05-15 22:24:45',2325,0,'2024-05-15 22:14:45.947','2024-05-15 22:14:45.947'),(148,15,'7acf99a7-208c-452b-befa-e092ea72224b','2024-05-16 10:20:16',1696,0,'2024-05-16 10:10:16.146','2024-05-16 10:10:16.146'),(149,1,'ee6b2e97-49a7-473b-9a36-d3af1e5c273d','2024-05-16 23:10:36',8525,0,'2024-05-16 23:00:36.984','2024-05-16 23:00:36.984'),(150,14,'2bdaf5d8-a0ca-46a7-9bc6-8e51f4fb94ae','2024-05-17 13:45:04',7230,0,'2024-05-17 13:35:04.837','2024-05-17 13:35:04.837'),(151,15,'97a5a014-9ce2-49eb-b970-e73fed6b3adf','2024-05-17 13:53:13',9991,0,'2024-05-17 13:43:13.861','2024-05-17 13:43:13.861'),(152,50,'e0a94152-fc08-402a-b33a-bcfdcc0e52db','2024-05-17 15:47:34',1034,0,'2024-05-17 15:37:34.268','2024-05-17 15:37:34.268'),(153,18,'10cd0f0d-4462-4702-811f-de11694c4da3','2024-05-18 08:13:35',1940,0,'2024-05-18 08:03:35.515','2024-05-18 08:03:35.515'),(154,15,'ea6e34a5-4c01-4427-9926-ccaea6e907e6','2024-05-20 13:24:21',2534,0,'2024-05-20 13:14:21.351','2024-05-20 13:14:21.351'),(155,16,'c81d82cc-69bb-44d9-ad54-88247e0bb8e5','2024-05-20 14:35:49',4612,0,'2024-05-20 14:25:49.211','2024-05-20 14:25:49.211'),(156,1,'e9722e0e-2c6b-4422-aefd-3a6512e10012','2024-05-20 16:01:03',9580,0,'2024-05-20 15:51:03.780','2024-05-20 15:51:03.780'),(157,15,'84a11e00-37de-4d37-b2f4-d4f52de5ecfe','2024-05-20 16:06:57',4520,0,'2024-05-20 15:56:57.587','2024-05-20 15:56:57.587'),(158,1,'0a9536d6-30f2-463b-8d31-0edb6b704056','2024-05-20 16:27:32',4377,0,'2024-05-20 16:17:32.860','2024-05-20 16:17:32.860'),(159,15,'55ade86a-d820-45a3-a047-65a3ba21ec9e','2024-05-21 00:30:46',5882,0,'2024-05-21 00:20:46.644','2024-05-21 00:20:46.644'),(160,1,'647e73f0-a213-43bb-824e-1fc98a5a40c2','2024-05-21 00:32:36',2522,0,'2024-05-21 00:22:36.205','2024-05-21 00:22:36.205'),(161,7,'76b0882c-67e8-4574-8621-9deb9ccaf0dc','2024-05-21 00:39:19',9979,0,'2024-05-21 00:29:19.103','2024-05-21 00:29:19.103'),(162,1,'b7e63a76-c40b-4318-aca1-7e1ff4afba3b','2024-05-21 11:44:42',7973,0,'2024-05-21 11:34:42.275','2024-05-21 11:34:42.275'),(163,7,'658bd654-4b17-4e1c-9518-7c37fb45b685','2024-05-21 11:49:27',8568,0,'2024-05-21 11:39:27.822','2024-05-21 11:39:27.823'),(164,1,'45aeb404-cf2a-42d0-b33f-3cf840581bbe','2024-05-21 12:24:04',2943,0,'2024-05-21 12:14:04.343','2024-05-21 12:14:04.343'),(165,18,'32513dc3-eb30-4b23-80d5-2eb41a11aa54','2024-05-21 12:32:26',8581,0,'2024-05-21 12:22:26.798','2024-05-21 12:22:26.798'),(166,1,'49aae9cb-4c21-4cde-844c-818a892771d4','2024-05-21 13:50:23',6269,0,'2024-05-21 13:40:23.627','2024-05-21 13:40:23.627'),(167,1,'0964d64c-0f2c-45fb-926b-6623a05d5694','2024-05-21 14:28:17',2367,0,'2024-05-21 14:18:17.668','2024-05-21 14:18:17.668'),(168,50,'1958761f-7433-46b8-baa8-109a9d83eeb8','2024-05-21 16:07:36',9109,0,'2024-05-21 15:57:36.784','2024-05-21 15:57:36.784'),(169,1,'4e95f2a8-6aea-4084-b694-e5707fa12f27','2024-05-21 16:21:15',7643,0,'2024-05-21 16:11:15.502','2024-05-21 16:11:15.502'),(170,7,'18727c1c-8f65-4d93-9a82-48fe90e12113','2024-05-21 18:43:00',1866,0,'2024-05-21 18:33:00.073','2024-05-21 18:33:00.073'),(171,1,'0283b7a8-b143-4ecd-bda3-09db54dabd24','2024-05-21 18:51:14',8950,0,'2024-05-21 18:41:14.242','2024-05-21 18:41:14.242'),(172,15,'b44d291e-8d60-454c-ba9d-a1f51576c4f3','2024-05-28 15:49:31',6447,0,'2024-05-28 15:39:31.621','2024-05-28 15:39:31.621'),(173,15,'0c2f84b9-949a-4414-8d71-449feccf68f5','2024-05-31 15:45:32',8122,0,'2024-05-31 15:35:32.787','2024-05-31 15:35:32.787'),(174,1,'bfa74731-79c1-44e7-9a98-2791377aeac4','2024-05-31 18:15:56',4762,0,'2024-05-31 18:05:56.908','2024-05-31 18:05:56.908'),(175,18,'0c4c009e-76a7-4049-864b-d3f71b6a3798','2024-06-06 16:20:30',8947,0,'2024-06-06 16:10:30.236','2024-06-06 16:10:30.236'),(176,1,'1cb3d437-d15e-4b43-8085-7dbee9cfe557','2024-06-14 06:07:41',8067,0,'2024-06-14 05:57:41.337','2024-06-14 05:57:41.337'),(177,18,'896f5689-9f52-4d01-8cb6-bc101d8b439a','2024-06-17 12:43:17',6164,0,'2024-06-17 12:33:17.409','2024-06-17 12:33:17.409'),(178,10,'47201b98-ba85-4110-aec6-d4c613358994','2024-06-17 14:10:06',1101,0,'2024-06-17 14:00:06.933','2024-06-17 14:00:06.933'),(179,1,'05fe2b0c-5f0c-4c46-a01a-cabb55d65d11','2024-06-17 14:11:10',4750,0,'2024-06-17 14:01:10.622','2024-06-17 14:01:10.622'),(180,16,'8562dccf-7b75-4de3-9b7c-8290e39e87ab','2024-06-17 14:14:19',3155,0,'2024-06-17 14:04:19.411','2024-06-17 14:04:19.411'),(181,1,'ff22d0eb-baa9-4dd6-aa87-d800ca0b569c','2024-06-17 14:52:43',1581,0,'2024-06-17 14:42:43.272','2024-06-17 14:42:43.272'),(182,14,'891bd8d7-55ef-4f2c-89af-7caeb4dc4653','2024-06-17 14:55:17',8892,0,'2024-06-17 14:45:17.532','2024-06-17 14:45:17.532'),(183,14,'4967ee70-252d-45f0-916e-2f918ebd7978','2024-06-17 15:04:25',4483,0,'2024-06-17 14:54:25.348','2024-06-17 14:54:25.348'),(184,15,'6d1f7591-eb72-4a94-b503-03453223932a','2024-06-17 15:07:15',6372,0,'2024-06-17 14:57:15.570','2024-06-17 14:57:15.570'),(185,16,'f33df3d6-aff9-42cf-8a5d-a2315fa6ec61','2024-06-17 15:08:04',8751,0,'2024-06-17 14:58:04.103','2024-06-17 14:58:04.103'),(186,16,'571c873d-fce7-4e23-97e7-af5a41a4e916','2024-06-17 16:48:19',3541,0,'2024-06-17 16:38:19.842','2024-06-17 16:38:19.842'),(187,16,'880ac015-28dc-4157-8099-35b169155fa3','2024-06-19 13:37:07',5531,0,'2024-06-19 13:27:07.128','2024-06-19 13:27:07.128'),(188,18,'a92672c4-c50b-46df-bf5a-0cc14b487794','2024-06-19 18:09:50',1101,0,'2024-06-19 17:59:50.434','2024-06-19 17:59:50.434'),(189,14,'bc69a963-7b8f-4310-bcac-e220d3379e47','2024-06-19 21:48:08',5230,0,'2024-06-19 21:38:08.967','2024-06-19 21:38:08.967'),(190,15,'8aeb22bc-83f3-4d9d-a124-7691ab883130','2024-06-19 21:52:26',7673,0,'2024-06-19 21:42:26.591','2024-06-19 21:42:26.591'),(191,1,'eb925282-6cc9-448e-b0b9-d3c779568a28','2024-06-19 21:52:35',5348,0,'2024-06-19 21:42:35.858','2024-06-19 21:42:35.858'),(192,15,'7490a804-731b-4c28-8618-0365c60078c9','2024-06-19 21:59:51',2113,0,'2024-06-19 21:49:51.019','2024-06-19 21:49:51.019'),(193,14,'cb58bef6-2242-4bd5-9ec2-81411095adb9','2024-06-19 22:00:40',3927,0,'2024-06-19 21:50:40.796','2024-06-19 21:50:40.796'),(194,15,'d0d44fc0-91ea-494d-a51b-34c770f231b9','2024-06-19 22:01:08',1592,0,'2024-06-19 21:51:08.565','2024-06-19 21:51:08.565'),(195,16,'93b47d96-0c2d-4d75-ae6e-02d5b0d1357a','2024-06-20 10:05:09',9601,0,'2024-06-20 09:55:09.066','2024-06-20 09:55:09.066'),(196,18,'ffb126e9-6f51-4fc1-a6d8-e1a80788a34f','2024-06-20 15:40:53',8918,0,'2024-06-20 15:30:53.487','2024-06-20 15:30:53.487'),(197,1,'0c1acfa5-94af-4b96-aca8-5fae43c9168d','2024-06-21 19:41:35',6929,0,'2024-06-21 19:31:35.835','2024-06-21 19:31:35.835'),(198,57,'ba2efbd0-c361-4060-be5e-598e9ff0426e','2024-06-21 22:58:57',4269,0,'2024-06-21 22:48:57.759','2024-06-21 22:48:57.759'),(199,18,'a89ca522-ff78-48a0-bc2b-5497581fda65','2024-06-21 23:09:58',8145,0,'2024-06-21 22:59:58.765','2024-06-21 22:59:58.765'),(200,18,'40dfdc95-0348-4413-84cc-72ef8224aa15','2024-06-21 23:11:00',4902,0,'2024-06-21 23:01:00.491','2024-06-21 23:01:00.491'),(201,18,'142fc6e1-6577-4220-968f-9ed5ff1b7cf7','2024-06-21 23:23:07',9942,0,'2024-06-21 23:13:07.487','2024-06-21 23:13:07.487'),(202,50,'9aebbb02-c5d6-474b-a08a-c27f8cd8eb9c','2024-06-24 22:19:49',7434,0,'2024-06-24 22:09:49.476','2024-06-24 22:09:49.476'),(203,14,'de6d70c3-e860-4836-97bf-8344941027d7','2024-06-25 12:39:38',3539,0,'2024-06-25 12:29:38.834','2024-06-25 12:29:38.834'),(204,14,'22f8e53f-b247-42be-a521-46e618bc8557','2024-06-25 12:46:07',2048,0,'2024-06-25 12:36:07.134','2024-06-25 12:36:07.134'),(205,60,'61ba7c88-db46-4812-8449-f20abd47860f','2024-06-25 12:57:54',6710,0,'2024-06-25 12:47:54.001','2024-06-25 12:47:54.001'),(206,60,'fb4727a2-8cd2-4696-aab3-27cf571b19ce','2024-06-25 13:02:21',7795,0,'2024-06-25 12:52:21.895','2024-06-25 12:52:21.895'),(207,60,'83a3bd95-d0ef-405f-b466-a14556710ba6','2024-06-25 13:16:41',7239,0,'2024-06-25 13:06:41.740','2024-06-25 13:06:41.740'),(208,14,'e17235f7-21c3-4ea4-bae2-b019018dbe0d','2024-06-25 13:34:45',1244,0,'2024-06-25 13:24:45.627','2024-06-25 13:24:45.627'),(209,14,'44ed5dc0-6fd9-4533-acdf-a9cccaefb61a','2024-06-25 13:56:48',1151,0,'2024-06-25 13:46:48.519','2024-06-25 13:46:48.519'),(210,14,'dd24df64-a8a0-4a8e-ad89-45c836c05517','2024-06-25 13:59:39',5561,0,'2024-06-25 13:49:39.491','2024-06-25 13:49:39.491'),(211,60,'da4104e1-f474-40c7-b3a7-307341d212a5','2024-06-25 14:03:53',7076,0,'2024-06-25 13:53:53.476','2024-06-25 13:53:53.476'),(212,1,'0479f72f-2b9e-4b6d-ab57-5f8500d74bb7','2024-06-25 14:06:12',9836,0,'2024-06-25 13:56:12.770','2024-06-25 13:56:12.770'),(213,61,'26d49432-ee36-4d71-8632-95eec5f8ad5b','2024-06-25 14:12:14',8641,0,'2024-06-25 14:02:14.553','2024-06-25 14:02:14.553'),(214,50,'eea03c96-4ba4-4abc-aeca-d90482d4abd3','2024-06-25 23:15:37',1299,0,'2024-06-25 23:05:37.772','2024-06-25 23:05:37.772'),(215,62,'31a7ef10-3344-4bcb-a72b-f9a41e4bfe4e','2024-06-25 23:17:22',5369,0,'2024-06-25 23:07:22.290','2024-06-25 23:07:22.290'),(216,50,'45cb27c6-fb5a-4c40-a114-872a4d39bb9c','2024-06-26 17:04:07',9553,0,'2024-06-26 16:54:07.974','2024-06-26 16:54:07.974'),(217,64,'99d87fc4-bc6a-4742-b082-f924deae5c92','2024-06-26 17:12:30',4877,0,'2024-06-26 17:02:30.788','2024-06-26 17:02:30.788'),(218,65,'a890155f-a890-4ba7-8466-e6ca25224fad','2024-06-27 21:59:43',8696,0,'2024-06-27 21:49:43.269','2024-06-27 21:49:43.269'),(219,65,'f4c925f1-7dfe-4204-b449-703517f933f5','2024-06-27 22:02:33',1488,0,'2024-06-27 21:52:33.424','2024-06-27 21:52:33.424'),(220,16,'3fe2c50d-e0e9-4ef3-ac26-548f74ca256b','2024-06-28 19:37:54',5067,0,'2024-06-28 19:27:54.224','2024-06-28 19:27:54.224'),(221,66,'c936b05a-6566-448a-8b4f-3fd142c9cbde','2024-06-28 19:40:46',8583,0,'2024-06-28 19:30:46.737','2024-06-28 19:30:46.737'),(222,14,'cb0b8924-5162-47e2-ab6b-afa9acd12c34','2024-06-28 19:41:51',4427,0,'2024-06-28 19:31:51.199','2024-06-28 19:31:51.199'),(223,16,'9af730cb-6b07-4a92-8064-c9c59de12c80','2024-06-28 19:42:37',3999,0,'2024-06-28 19:32:37.600','2024-06-28 19:32:37.600'),(224,66,'5e707d41-8000-4306-821c-12f33723a161','2024-06-28 19:43:50',3424,0,'2024-06-28 19:33:50.547','2024-06-28 19:33:50.547'),(225,16,'bf99b2ab-4b28-4ff2-88c4-6f1ef53c67b1','2024-07-01 14:18:36',3322,0,'2024-07-01 14:08:36.135','2024-07-01 14:08:36.135'),(226,50,'2e6c0e1e-f756-4b9b-bd62-94b1a5921a02','2024-07-03 17:14:56',9275,0,'2024-07-03 17:04:56.516','2024-07-03 17:04:56.516'),(227,18,'fcc40799-0551-42a4-b2b2-0986b78ba0c2','2024-07-03 17:15:31',2368,0,'2024-07-03 17:05:31.814','2024-07-03 17:05:31.814'),(228,18,'40303121-3564-49dd-b441-d83cac40ca95','2024-07-03 17:19:06',1769,0,'2024-07-03 17:09:06.778','2024-07-03 17:09:06.778'),(229,18,'196639eb-f0b0-4465-8787-83090fe4d6cb','2024-07-03 17:57:25',2118,0,'2024-07-03 17:47:25.572','2024-07-03 17:47:25.572'),(230,50,'29d0e4c5-cb6f-477c-969f-5472e441d53d','2024-07-03 18:09:39',9604,0,'2024-07-03 17:59:39.803','2024-07-03 17:59:39.803'),(231,50,'7c699f2a-ab61-462a-8494-f05500665187','2024-07-09 16:51:38',7090,0,'2024-07-09 16:41:38.425','2024-07-09 16:41:38.425'),(232,50,'2d47df8f-15e6-4892-80b5-6eff55874ed7','2024-07-09 16:52:30',2629,0,'2024-07-09 16:42:30.713','2024-07-09 16:42:30.713'),(233,50,'c0821ae6-b49e-45b3-b921-c82cc02e0091','2024-07-09 16:59:55',8447,0,'2024-07-09 16:49:55.280','2024-07-09 16:49:55.280'),(234,1,'f88e3719-5d26-4578-bcf4-419d3c095b0e','2024-07-09 17:01:31',1224,0,'2024-07-09 16:51:31.380','2024-07-09 16:51:31.380'),(235,1,'1f5e9419-27ce-4335-a44e-4feb94ea2525','2024-07-09 17:02:34',8036,0,'2024-07-09 16:52:34.650','2024-07-09 16:52:34.650'),(236,1,'f9dcc0b1-9614-44b1-8938-8fc2cd296a66','2024-07-09 17:03:58',1676,0,'2024-07-09 16:53:58.484','2024-07-09 16:53:58.484'),(237,15,'0923a15f-3edd-4ca4-90bc-f0c1a4e818ab','2024-07-09 17:04:42',5634,0,'2024-07-09 16:54:42.366','2024-07-09 16:54:42.366'),(238,50,'9a83c44e-dfdc-4b1a-a632-05a55f1665e8','2024-07-09 17:25:42',7475,0,'2024-07-09 17:15:42.701','2024-07-09 17:15:42.701'),(239,50,'25a74621-2e46-457e-a2ea-340bf2cb811e','2024-07-09 17:28:07',4629,0,'2024-07-09 17:18:07.119','2024-07-09 17:18:07.119'),(240,1,'b7d53dc6-ba13-4b8e-805f-1489b99bfd18','2024-07-09 19:52:28',6381,0,'2024-07-09 19:42:28.109','2024-07-09 19:42:28.109'),(241,1,'cca67dbc-e766-4128-a7ac-64bef86d0671','2024-07-09 19:56:07',8216,0,'2024-07-09 19:46:07.158','2024-07-09 19:46:07.158'),(242,1,'592575ea-1803-47f8-a3b5-a5552f2763b1','2024-07-09 19:56:51',3781,1,'2024-07-09 19:46:51.630','2024-07-09 19:46:51.630'),(243,15,'0960d3d2-27bc-4fd7-a0b0-9a53f8d7eb72','2024-07-09 21:00:23',9222,0,'2024-07-09 20:50:23.761','2024-07-09 20:50:23.761'),(244,16,'93f86c6e-f739-42bc-b06e-5b9fec48808e','2024-07-23 13:03:20',7613,0,'2024-07-23 12:53:20.834','2024-07-23 12:53:20.834'),(245,66,'94f618f5-eca7-439e-a473-feb447d497a2','2024-07-23 13:04:59',5655,0,'2024-07-23 12:54:59.491','2024-07-23 12:54:59.491'),(246,16,'8078f48f-71b4-4a04-a072-4ad7c3fea7b8','2024-07-23 13:13:46',2912,0,'2024-07-23 13:03:46.992','2024-07-23 13:03:46.992'),(247,66,'2b622579-49bf-4b39-8569-53ae3e28f050','2024-07-23 13:14:42',3256,0,'2024-07-23 13:04:42.171','2024-07-23 13:04:42.171'),(248,16,'11f562f6-656a-40af-9442-34f4a054604a','2024-07-23 13:33:29',1731,0,'2024-07-23 13:23:29.143','2024-07-23 13:23:29.143'),(249,1,'735070fb-ebed-4a97-9c3d-e0f93048fb55','2024-07-23 13:47:11',6777,0,'2024-07-23 13:37:11.408','2024-07-23 13:37:11.408'),(250,61,'a0f41462-819f-46ec-8bc5-140180b33a18','2024-07-23 13:49:17',9702,0,'2024-07-23 13:39:17.200','2024-07-23 13:39:17.200'),(251,7,'d675c6a1-5d4a-46cf-a5e4-73039e9ba593','2024-07-23 14:29:57',3061,0,'2024-07-23 14:19:57.239','2024-07-23 14:19:57.239');

--
-- Table structure for table `Permissions`
--

CREATE TABLE `Permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `permissions` longtext DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `Permissions_userId_key` (`userId`),
  CONSTRAINT `Permissions_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Permissions`
--

INSERT INTO `Permissions` VALUES (2,65,NULL,'2024-06-28 19:00:57.630','2024-06-28 19:00:57.630'),(3,66,'merchant-dashboard,customers,merchant-invoices,transactions,outreach,create-email-template,edit-email-template,sms-template,create-sms-template,edit-sms-template,customer-group,create-customer-group,edit-customer-group,crm-outreach,scheduled-outreach,create-scheduled-outreach','2024-06-28 19:29:44.629','2024-06-28 19:29:44.629'),(4,60,'','2024-06-28 19:32:17.880','2024-06-28 19:32:17.880'),(5,16,'','2024-07-23 12:54:36.725','2024-07-23 12:54:36.725'),(6,61,'merchant-dashboard,customers,merchant-invoices,transactions,outreach,create-email-template,edit-email-template,sms-template,create-sms-template,edit-sms-template,customer-group,create-customer-group,edit-customer-group,crm-outreach,scheduled-outreach,create-scheduled-outreach','2024-07-23 13:38:35.486','2024-07-23 13:38:35.486');

--
-- Table structure for table `ResetRequest`
--

CREATE TABLE `ResetRequest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `resetUrl` varchar(191) NOT NULL,
  `expireAt` datetime(3) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ResetRequest_userId_key` (`userId`),
  UNIQUE KEY `ResetRequest_resetUrl_key` (`resetUrl`),
  CONSTRAINT `ResetRequest_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ResetRequest`
--


--
-- Table structure for table `Roles`
--

CREATE TABLE `Roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('SUPERADMIN','AGENT','DISPENSARY') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Roles`
--


--
-- Table structure for table `ScheduledOutreach`
--

CREATE TABLE `ScheduledOutreach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `customer_email` varchar(191) NOT NULL,
  `customer_phone` varchar(191) NOT NULL,
  `type` enum('EMAIL','SMS') NOT NULL DEFAULT 'EMAIL',
  `content` mediumtext NOT NULL,
  `scheduled_time` datetime(3) NOT NULL,
  `status` enum('PENDING','CANCELLED','SENT') NOT NULL DEFAULT 'PENDING',
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ScheduledOutreach`
--


--
-- Table structure for table `SmsTemplate`
--

CREATE TABLE `SmsTemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `template_name` varchar(191) NOT NULL,
  `content` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `SmsTemplate_userId_fkey` (`userId`),
  CONSTRAINT `SmsTemplate_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `SmsTemplate`
--


--
-- Table structure for table `TestCI`
--

CREATE TABLE `TestCI` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `TestCI`
--


--
-- Table structure for table `Token`
--

CREATE TABLE `Token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(191) NOT NULL,
  `status` enum('EXPIRED','ACTIVE') NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `userId` int(11) NOT NULL,
  `expire_time` datetime(3) DEFAULT NULL,
  `type` enum('KYB','INVOICE') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `Token_token_key` (`token`),
  KEY `Token_userId_fkey` (`userId`),
  CONSTRAINT `Token_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Token`
--

INSERT INTO `Token` VALUES (1,'IkW0UIIHY2iG3yIogrRgeR7uVD9k','ACTIVE','2024-04-30 21:21:41.987','2024-04-30 21:21:41.987',4,NULL,NULL),(2,'MROejlCa2BhaGI63v3boIj9VQk9a','ACTIVE','2024-04-30 22:15:50.296','2024-04-30 22:15:50.296',7,NULL,NULL),(3,'dCYLrdLHtpJQofkMYWsDIZk4c8Hf','ACTIVE','2024-05-01 02:29:32.929','2024-05-01 02:29:32.929',11,NULL,NULL),(4,'0Hf0xYVGPHqSI07RUzSNnXau7nDW','ACTIVE','2024-05-01 03:13:08.026','2024-05-01 03:13:08.026',12,NULL,NULL),(5,'k1aPb828ROaPpVAfdbJ8L4FeUQzP','ACTIVE','2024-05-01 16:39:08.990','2024-05-01 16:39:08.990',13,NULL,NULL),(6,'S5SJyMZV0eaaHZ82WguiwVcrauqi','ACTIVE','2024-05-06 03:05:52.109','2024-05-06 03:05:52.109',16,NULL,NULL),(7,'UU9yb0nblfa6JAaXwaudKwCaaJQV','ACTIVE','2024-05-14 15:22:23.570','2024-05-14 15:22:23.570',28,NULL,NULL),(8,'0vLK57Gsj3EOEY7ZxQg0aCPw5VT7','ACTIVE','2024-05-15 16:28:28.521','2024-05-15 16:28:28.521',30,NULL,NULL),(9,'jqbqeAdaFPL4FaLs5FyUXf8Wt4s9','ACTIVE','2024-05-15 22:11:43.946','2024-05-15 22:11:43.946',31,NULL,NULL),(10,'Hi4uxUtY9i0vzsXWxrvizpMfhJik','ACTIVE','2024-05-15 22:36:49.528','2024-05-15 22:36:49.528',32,NULL,NULL),(11,'bMj65NeNPkq2ZiQRC3ObJrd2LW2v','ACTIVE','2024-05-17 14:46:23.454','2024-05-17 14:46:23.454',33,NULL,NULL),(12,'EtPO1qwyamOe9rFRKBwHfhxveQvf','ACTIVE','2024-05-17 14:54:10.186','2024-05-17 14:54:10.186',37,NULL,NULL),(13,'60HDcaRSzZPRpvCkYk9CL6TlZ0wy','ACTIVE','2024-05-20 13:19:57.127','2024-05-20 13:19:57.127',51,NULL,NULL),(14,'QSBwWyJudZQDr1mkcgNtTJIEUnyF','ACTIVE','2024-05-21 00:21:49.239','2024-05-21 00:21:49.239',55,NULL,NULL),(15,'NV0OFSWebmJle0qdq39vQRVYR1HV','ACTIVE','2024-05-30 17:38:46.984','2024-05-30 17:38:46.984',56,NULL,NULL);

--
-- Table structure for table `TransactionHistory`
--

CREATE TABLE `TransactionHistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(191) NOT NULL,
  `reference_id` varchar(191) DEFAULT NULL,
  `amount` decimal(10,4) DEFAULT NULL,
  `type` enum('WITHDRAWAL','DEPOSIT') NOT NULL,
  `status` enum('PENDING','COMPLETED','REJECT') NOT NULL,
  `reject_reason` varchar(191) DEFAULT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `commission` decimal(10,4) DEFAULT NULL,
  `settle_amount` decimal(10,4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `TransactionHistory_transaction_id_key` (`transaction_id`),
  UNIQUE KEY `TransactionHistory_reference_id_key` (`reference_id`),
  KEY `TransactionHistory_userId_fkey` (`userId`),
  CONSTRAINT `TransactionHistory_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `TransactionHistory`
--


--
-- Table structure for table `User`
--

CREATE TABLE `User` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `contact_number` varchar(191) DEFAULT NULL,
  `country_code` varchar(191) NOT NULL DEFAULT '+1',
  `ssn` varchar(191) DEFAULT NULL,
  `address_1` varchar(191) DEFAULT NULL,
  `address_2` varchar(191) DEFAULT NULL,
  `pincode` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `commission` decimal(10,4) DEFAULT NULL,
  `last_commission_update_time` datetime(3) DEFAULT NULL,
  `isOnBoard` tinyint(1) NOT NULL DEFAULT 0,
  `onboard_reject_reason` varchar(191) DEFAULT NULL,
  `role` int(11) NOT NULL,
  `unique_id` varchar(191) DEFAULT NULL,
  `isDeleted` tinyint(1) NOT NULL DEFAULT 0,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `dob` varchar(191) DEFAULT NULL,
  `register_status` enum('INITIATED','COMPLETED') NOT NULL DEFAULT 'INITIATED',
  `profile_photo_url` varchar(191) DEFAULT NULL,
  `twoFa_enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `User_email_key` (`email`),
  UNIQUE KEY `User_unique_id_key` (`unique_id`),
  KEY `User_createdBy_fkey` (`createdBy`),
  CONSTRAINT `User_createdBy_fkey` FOREIGN KEY (`createdBy`) REFERENCES `User` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `User`
--

INSERT INTO `User` VALUES (1,'nirnay@bucle.dev','$2a$10$mF7MfSYvMPkhQx2mQi.8susYTr/I7Qh12uCvP.C8fHnQBjNJkd5Mi','nirnay','+91 36453645634','+1','1',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,1,NULL,0,'2023-05-17 13:39:58.761','2023-05-19 13:06:34.253',NULL,NULL,NULL,'COMPLETED',NULL,0),(2,'jehanzebsherali+1@gmail.com','$2b$10$36fSbJYq6aV9FYSkNde0Q.Jn/bMpamo4rYZlLDb.yHAdxMz8SrDdq','Jazz ISO','5555484825','+1','554542154','99 B ravenw society',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,4,'fde67654-849e-414d-b2cd-853c5a9c12be',0,'2024-04-30 21:12:28.286','2024-04-30 21:12:49.388',1,NULL,NULL,'COMPLETED',NULL,0),(3,'jehanzebsherali+2@gmail.com','$2b$10$FF7kgRcBTwDVMiR7OrEJkOXguvNSyWkB0FZWvMWIKkjzIOq8n.N0e','jazz agent','5465456646','+1','545454555','721 D faisal Town Near gourmet bakery',NULL,NULL,NULL,NULL,NULL,1,2.0000,NULL,0,NULL,2,'40cda462-a3aa-4839-9ae0-05f4a3de5b89',0,'2024-04-30 21:19:39.978','2024-04-30 21:19:53.518',2,NULL,NULL,'COMPLETED',NULL,0),(4,'jehanzebsherali+3@gmail.com',NULL,'Jazz marchant','5454122154','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'ec50c194-870e-4499-a959-fe95615074e7',0,'2024-04-30 21:21:41.120','2024-04-30 21:21:41.120',3,NULL,NULL,'INITIATED',NULL,0),(5,'luke+bgwgiso@paygreencard.com','$2b$10$QoBk1dbjH1XDODAVGL70jeWwBBjaEUpkiensapDJY/gXGP23CdqDK','BGWG ISO','9998938388','+1','123456789','123 any st, irvine, ca 12345',NULL,NULL,NULL,NULL,NULL,1,3.0000,'2024-05-22 22:59:18.579',0,NULL,4,'bdd97112-5827-47e8-ba56-187bc15b7b4f',0,'2024-04-30 21:43:15.989','2024-05-22 22:59:20.034',1,NULL,NULL,'COMPLETED',NULL,0),(6,'luke+bgwgagent@paygreencard.com','$2b$10$zVDjZXA2ZxHdRrypE7MzZOu2evfHl.nfNRi7Yw9Zzti4jVp2V3vyy','BGWG Agent','9983838388','+1','777847474','123 any st, irvine, ca 12345',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,2,'e8289104-3672-43cc-abf0-52fcc840e33a',0,'2024-04-30 22:09:57.889','2024-04-30 22:10:05.691',5,NULL,NULL,'COMPLETED',NULL,0),(7,'luke+bgwgmerchant@paygreencard.com','$2a$10$mF7MfSYvMPkhQx2mQi.8susYTr/I7Qh12uCvP.C8fHnQBjNJkd5Mi','Tommy Merchant','9939399339','+1','1234','123 Home Address',NULL,'92691','Mission Viejo','California',NULL,1,3.0000,'2024-05-27 23:41:53.067',0,NULL,3,'bb555f57-2217-4947-9e6a-e10d7b094ca6',0,'2024-04-30 22:15:50.143','2024-06-19 18:25:01.815',6,NULL,'04/02/1980','COMPLETED','https://greencard-gateway.s3.us-east-1.amazonaws.com/profile_image/1718821501126bb555f57-2217-4947-9e6a-e10d7b094ca6.jpeg',0),(9,'bigox.dev2020+iso2@gmail.com','$2b$10$chMHVNA5QwD7WOALweT23e2vV7PIsGImtSHafV4nmT0pRDMSX5gNu','Ming ISO','1234567890','+1','123456789','240 E Santa Anita Ave #110',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,4,'892ac334-6d18-4af2-9459-1931cdd306fd',0,'2024-05-01 02:15:23.725','2024-05-01 02:15:40.629',1,NULL,NULL,'COMPLETED',NULL,0),(10,'bigox.dev2020+agent1@gmail.com','$2b$10$4xbrpiejry4L00iztLrsJuaCG8rM3hJR/8JwRutGHclKS8/S0DBeC','Ming AGENT','1234567891','+1','123456789','240 E Santa Anita Ave #110',NULL,NULL,NULL,NULL,NULL,1,2.0000,NULL,0,NULL,2,'eaa0241d-925c-4360-96e2-74081d828314',0,'2024-05-01 02:25:35.772','2024-05-01 02:25:51.123',9,NULL,NULL,'COMPLETED',NULL,0),(11,'bigox.dev2020+merchant1@gmail.com',NULL,'Ming Jie','1234567892','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'927d7a4e-c2c2-4182-8bb7-84d5adc7d95f',0,'2024-05-01 02:29:31.895','2024-05-01 02:29:31.895',10,NULL,NULL,'INITIATED',NULL,0),(12,'bigox.dev2020+merchant2@gmail.com','$2b$10$cuQ22myWjNAAPV67Bx2b5ez.xFvlodRNz5xXC1/u.ajhiOTtuGGfO','Ming Jie','2345678912','+1','1234','8243 North Cactus Street El Cajon, CA 92020',NULL,'92020','El Cajon','California',NULL,1,NULL,NULL,0,NULL,3,'1fffed2d-b9fd-458d-92c1-510796607e02',0,'2024-05-01 03:13:07.114','2024-05-01 16:32:29.277',10,NULL,'05/01/1998','COMPLETED',NULL,0),(13,'bigox.dev2020+merchant3@gmail.com','$2b$10$2JyLdjG7SCGGiLaxl.NtieKEy3rfy3eomLR5itSvV3tEi68MoczSi','Ming Jie','2345678902','+1','5435','Scenic Road',NULL,'12345','Charlotte','California',NULL,1,NULL,NULL,0,NULL,3,'d237249a-eb54-4f89-8eaa-8cad3d8675be',0,'2024-05-01 16:39:08.634','2024-06-03 16:15:52.114',10,NULL,'05/01/1999','COMPLETED',NULL,0),(14,'bigox.dev2020+iso1@gmail.com','$2b$10$S/8MPn98b9Wxl4aDe52bHeqJWS.u2xOD.t41rSHHeQ6UmgeNw8LaG','Ming Li','4565654654','+1','123456789','Test Address',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,4,'6710ac61-e806-4db4-92a9-7fbd2dfb4781',0,'2024-05-06 02:00:06.812','2024-05-17 13:35:47.469',1,NULL,NULL,'COMPLETED',NULL,0),(15,'bigox.dev2020+agent3@gmail.com','$2b$10$OjT0IUd3Px6ePn1QDikrVuUnfRgDIfTPc9JeOar99BM.y1WeCe5iW','Ming Agent','3423423432','+1','234235235','Test Address',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,2,'3f91cd3c-a52a-427b-be78-a59743f65f38',0,'2024-05-06 03:00:22.152','2024-05-07 19:51:35.221',14,NULL,NULL,'COMPLETED',NULL,0),(16,'bigox.dev2020+merchant5@gmail.com','$2b$10$18Gd3yobJSozqh886s2eeuevzbHGDkGNy5EBhtVuy6fRHHsdxEEti','Ming Jie','2344534534','+1','1323','Test Address',NULL,'23453','Los Angeles','California',NULL,1,NULL,NULL,0,NULL,3,'555dae1b-c17c-4ef2-96ef-bbee405c4356',0,'2024-05-06 03:05:51.802','2024-06-19 18:03:46.022',15,NULL,'05/02/1990','COMPLETED','https://greencard-gateway.s3.us-east-1.amazonaws.com/profile_image/1718820225654555dae1b-c17c-4ef2-96ef-bbee405c4356.jpeg',0),(17,'test-iso@gmail.com',NULL,'test iso','3498759822','+1','234353242','US new york',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,4,'186ca269-f854-42ca-954f-4e7b3fdb2bbf',0,'2024-05-06 18:24:53.821','2024-05-06 18:24:53.821',1,NULL,NULL,'INITIATED',NULL,0),(18,'info@paygreencard.com','$2a$10$mF7MfSYvMPkhQx2mQi.8susYTr/I7Qh12uCvP.C8fHnQBjNJkd5Mi','Luke Blackamore','+91 36453645634','+1','1',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,1,NULL,0,'2023-05-17 13:39:58.761','2024-05-07 21:13:22.986',NULL,NULL,NULL,'COMPLETED',NULL,0),(22,'agent-user@gmail.com','$2b$10$rUhbt9C5wdTX7f3.XmwMz.nHFp8/GsJOqhCSC1QQe6qR7cLGUfD3a','agent-user','2342352441','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,5,'ea4bfae8-37da-45f5-adb0-b38856de8758',0,'2024-05-08 18:12:23.080','2024-05-08 18:12:23.080',6,NULL,NULL,'COMPLETED',NULL,0),(25,'iso-user@gmail.com','$2b$10$cIJDpDt47Dhl2DDNbrXimOEZRz0c.15YYg/5OAI2UWeXk9qzEbdR6','iso-user','2342342342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,5,'83c49cb7-6466-4c3d-996b-6fd0cf5872e7',0,'2024-05-08 18:45:55.623','2024-05-08 18:45:55.623',5,NULL,NULL,'COMPLETED',NULL,0),(27,'bigox.dev2020+agent6@gmail.com',NULL,'Ming Agent','2345567879','+1','123479975','test address',NULL,NULL,NULL,NULL,NULL,1,1.0000,NULL,0,NULL,2,'a7372b3a-9c11-40c5-8970-50b7f29798e3',0,'2024-05-14 15:14:57.520','2024-05-14 15:14:57.520',14,NULL,NULL,'INITIATED',NULL,0),(28,'bigox.dev2020+merchant7@gmail.com',NULL,'Ming Merchant','4354534534','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'8f3baec2-36b9-4fb5-ab2d-1f03997df4a3',0,'2024-05-14 15:22:22.697','2024-05-14 15:22:22.697',15,NULL,NULL,'INITIATED',NULL,0),(29,'bigox.dev2020+agent7@gmail.com','$2b$10$kwu548B8HmZLyTOIFq97j.jDqd6maT7S61kq6lql8BI1egg1z/p46','Ming Agent','4353453454','+1','134523532','240 E Santa Anita Ave #110',NULL,NULL,NULL,NULL,NULL,0,1.0000,NULL,0,NULL,2,'46f0d940-5536-4426-8951-fbca4d2713d8',0,'2024-05-14 15:24:30.966','2024-05-18 07:51:21.679',14,NULL,NULL,'COMPLETED',NULL,0),(30,'luke.blackamore@gmail.com',NULL,'Tom Smith','1234567889','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'997d86c3-596b-411e-aa26-0a65f186d4b2',0,'2024-05-15 16:28:28.087','2024-05-15 16:28:28.087',6,NULL,NULL,'INITIATED',NULL,0),(31,'luke+donjon@paygreencard.com','$2b$10$vb1teX03sk1RhJlkJQG95.6jFs1niWkl5CLqq3VNQgX3QX8a3ePvO','Don John','4778577478','+1','1234','123 any st',NULL,'12345','MV','California',NULL,1,NULL,NULL,0,NULL,3,'c1ab42a5-4a70-468b-a547-f24301a58ace',0,'2024-05-15 22:11:43.771','2024-05-15 22:20:16.741',6,NULL,'05/15/1993','COMPLETED',NULL,0),(32,'bigox.dev2020+merchant13@gmail.com','$2b$10$473EPw8PswblcusM.TGyKeu0ApbLEiOTK.HhLxaV0eyyNP2xyaLoG','Ming Merchant','3243423423','+1','2323','test address',NULL,'23453','los angeles','California',NULL,1,3.0000,'2024-05-28 15:52:18.561',0,NULL,3,'8e949a04-9efb-4e02-8a76-fef41c3c1715',0,'2024-05-15 22:36:48.505','2024-06-03 16:18:13.515',15,NULL,'05/09/1990','COMPLETED',NULL,0),(33,'bigox.dev2020+merchant15@gmail.com',NULL,'Ming Merchant','4232343556','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'bcea044a-9da6-498c-bff1-e7a16abc9cc7',0,'2024-05-17 14:46:22.535','2024-05-17 14:46:22.535',15,NULL,NULL,'INITIATED',NULL,0),(34,'bigox.dev2020+merchant16@gmail.com',NULL,'Ming Merchant','2342342342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,3,'5ba80393-460a-4197-9fbf-b390f8ca78ff',0,'2024-05-17 14:50:48.306','2024-05-17 14:50:48.306',15,NULL,NULL,'INITIATED',NULL,0),(35,'bigox.dev2020+merchant17@gmail.com',NULL,'Ming Merchant','2342342342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,3,'6221754b-e999-4e4d-a084-2d77727075c5',0,'2024-05-17 14:51:36.766','2024-05-17 14:51:36.766',15,NULL,NULL,'INITIATED',NULL,0),(36,'bigox.dev2020+merchant18@gmail.com',NULL,'Ming Merchant','2342342342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,3,'1ad39944-fc38-4c60-83e4-3f4b9072dd4a',0,'2024-05-17 14:52:20.049','2024-05-17 14:52:20.049',15,NULL,NULL,'INITIATED',NULL,0),(37,'bigox.dev2020+merchant19@gmail.com',NULL,'Ming Merchant','2342342342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,3,'b6882ab9-5b88-419a-9c68-635b42aefe2e',0,'2024-05-17 14:54:09.018','2024-05-17 14:54:09.018',15,NULL,NULL,'INITIATED',NULL,0),(50,'musman01011996@gmail.com','$2a$10$mF7MfSYvMPkhQx2mQi.8susYTr/I7Qh12uCvP.C8fHnQBjNJkd5Mi','Usman','+91 36453645634','+1','1',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,1,NULL,0,'2023-05-17 13:39:58.761','2023-05-19 13:06:34.253',NULL,NULL,NULL,'COMPLETED',NULL,0),(51,'bigox.dev2020+merchant21@gmail.com',NULL,'Ming Merchant','3443452763','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'5b6998cf-06f3-47ec-b70a-c1af02379eed',0,'2024-05-20 13:19:56.213','2024-05-20 13:19:56.213',15,NULL,NULL,'INITIATED',NULL,0),(52,'bigox.dev2020+iso4@gmail.com',NULL,'Ming ISO','3445523623','+1','234346525','240 E Santa Anita',NULL,NULL,NULL,NULL,NULL,1,2.0000,NULL,0,NULL,4,'c2e7aae5-8fac-46f5-8177-77a9259b503a',0,'2024-05-20 19:30:42.525','2024-05-20 19:30:42.525',1,NULL,NULL,'INITIATED',NULL,0),(53,'bigox.dev2020+iso5@gmail.com',NULL,'Ming ISO','7659546456','+1','654423565','240 E Santa Anita',NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,4,'2afcc5d8-c5c2-4c3b-916b-a8db623bca5c',0,'2024-05-20 19:46:46.893','2024-05-20 19:46:46.893',1,NULL,NULL,'INITIATED',NULL,0),(54,'bigox.dev2020+iso6@gmail.com','$2b$10$pLgtLy3dE6QNzsba/6M38uLm2H2mvF9j9htdrf6gDbex6cvbOUb/u','Ming ISO','7659546453','+1','654423565','240 E Santa Anita',NULL,NULL,NULL,NULL,NULL,1,3.0000,NULL,0,NULL,4,'e6ba05c8-e28a-46a4-98e7-682f4d088849',0,'2024-05-20 19:48:34.671','2024-05-20 19:48:48.624',1,NULL,NULL,'COMPLETED',NULL,0),(55,'bigox.dev2020+merchant22@gmail.com',NULL,'Ming Merchant','3938728493','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'c5049d90-9dce-4d2e-b0be-cd07a4b981ea',0,'2024-05-21 00:21:48.093','2024-06-15 00:07:27.933',15,NULL,NULL,'INITIATED','https://greencard-gateway.s3.us-east-1.amazonaws.com/profile_image/1718410047588c5049d90-9dce-4d2e-b0be-cd07a4b981ea.jpeg',0),(56,'decent-mer1@gmail.com',NULL,'decent mer','2343243243','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,2.0000,NULL,0,NULL,3,'4fc5222a-ee59-4035-a6b2-a2565b214965',0,'2024-05-30 17:38:42.720','2024-07-03 18:04:57.102',6,NULL,NULL,'INITIATED','https://greencard-gateway.s3.us-east-1.amazonaws.com/profile_image/17200298965234fc5222a-ee59-4035-a6b2-a2565b214965.jpeg',0),(57,'mexok18594@lisoren.com','$2b$10$gxvuhnYYoy0CsWqBzMmpd.YNsU.OeKQW.h/imlwJDWD6noqVEWHly','mex','2342342234','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,5,'1abb919c-41f0-48f9-a719-3d5c2b07fd12',0,'2024-06-21 22:48:22.053','2024-06-21 22:48:22.053',55,NULL,NULL,'COMPLETED',NULL,0),(58,'bigox.dev+user1@gmail.com','$2b$10$swnICB1B/xwohIgjgFcXT.ujRhTwvjiKWn44OwRW1WILsCYe/ff2m','Ming Li','2343234526','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,5,'d9cf4064-93e2-4efa-b8fa-f7471327a4cb',0,'2024-06-24 13:32:26.691','2024-06-24 13:32:26.691',7,NULL,NULL,'COMPLETED',NULL,0),(60,'bigox.dev2020+isouser2@gmail.com','$2b$10$rzWEVAE/ntUBoV0rukHKcezE7mrLx2HloLQfT1P9dKulGsBpcTSyO','Ming Li','4234242342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,4,'a325ed16-4abf-4b54-95c4-ab128d361f17',0,'2024-06-25 12:47:06.492','2024-06-25 12:47:06.492',14,NULL,NULL,'COMPLETED',NULL,0),(61,'bigox.dev2020+merchantuser1@gmail.com','$2b$10$gOXQH1SNHmYcdQxpa66NPeeCXibMUOtUNiJrudAWagCAIXnIRxNFu','Ming Li','3234452342','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'ddfbc283-5eb4-4e0b-ba43-65894f33e02d',0,'2024-06-25 14:01:18.333','2024-06-25 14:01:18.333',7,NULL,NULL,'COMPLETED',NULL,0),(64,'bigox.dev2020+isouser3@gmail.com','$2b$10$/dgL9v1whWoBzYswJ0SJOukEAT5zinnHqSUxspxg.ixDhwgZfDCG2','Ming Li','4928492045','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,4,'69b6453e-7df8-4314-a40a-ad2aafecdc5d',0,'2024-06-26 17:01:50.235','2024-06-26 17:01:50.235',14,NULL,NULL,'COMPLETED',NULL,0),(65,'us.wns2023@gmail.com','$2b$10$SQDgWBqYtz19i8JLLGovF.a.qCiNYSjQ90t8HwUReISYQBBYvCHiK','us','8972349723','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,2,'9bdcbc95-a343-41c7-a9d2-a8ad416bc880',1,'2024-06-27 21:48:42.703','2024-06-28 19:18:13.167',6,NULL,NULL,'COMPLETED',NULL,0),(66,'bigox.dev2020+merchantuser4@gmail.com','$2b$10$UvheJ/Lnln0./Rpc2yW4J.cf22NYwcJFdtlQJvxPBgGXvDcd4aJue','Ming Li','4234242332','+1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,0,NULL,3,'3e8295b4-a3cd-4ff5-901e-c96be4c50ea4',0,'2024-06-28 19:29:03.573','2024-06-28 19:29:03.573',16,NULL,NULL,'COMPLETED',NULL,0);

--
-- Table structure for table `UserKey`
--

CREATE TABLE `UserKey` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_key` varchar(191) NOT NULL,
  `secret_key` varchar(191) NOT NULL,
  `status` enum('EXPIRED','ACTIVE') NOT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UserKey_api_key_key` (`api_key`),
  UNIQUE KEY `UserKey_secret_key_key` (`secret_key`),
  KEY `UserKey_userId_fkey` (`userId`),
  CONSTRAINT `UserKey_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `UserKey`
--

INSERT INTO `UserKey` VALUES (1,'uHJpb4W7M1FzjrLNtptvWc7ukREMfn58','7b2edd9c-b111-494a-9181-9735e6028a99','ACTIVE',12,'2024-05-01 13:33:40.262','2024-05-01 13:33:40.262'),(2,'QE73FkFlUZsFs2tyqpXqhgSLiwjC9sMQ','ffaae96e-3c31-46a6-8b0d-24eee40c8c46','ACTIVE',7,'2024-05-01 23:42:55.772','2024-05-01 23:42:55.772'),(3,'ZCrlsQ69s5Y1Ya1IvKq8XwVhyZTPy3yP','15cf15cb-d0b8-446a-a008-e9738a49d30b','ACTIVE',56,'2024-05-30 17:41:31.434','2024-05-30 17:41:31.434');

--
-- Table structure for table `UserVerification`
--

CREATE TABLE `UserVerification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_type` enum('DRIVINGLICENSE','PASSPORT') NOT NULL,
  `front_image_url` varchar(191) DEFAULT NULL,
  `back_image_url` varchar(191) DEFAULT NULL,
  `isVerified` tinyint(1) NOT NULL DEFAULT 0,
  `userId` int(11) NOT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UserVerification_userId_key` (`userId`),
  CONSTRAINT `UserVerification_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `UserVerification`
--

INSERT INTO `UserVerification` VALUES (1,'PASSPORT','iso_identity/front-identity/fde67654-849e-414d-b2cd-853c5a9c12be.jpeg','iso_identity/back-identity/fde67654-849e-414d-b2cd-853c5a9c12be.jpeg',1,2,NULL,NULL),(2,'DRIVINGLICENSE','agent_identity/front-identity/40cda462-a3aa-4839-9ae0-05f4a3de5b89.jpeg','agent_identity/back-identity/40cda462-a3aa-4839-9ae0-05f4a3de5b89.jpeg',1,3,NULL,NULL),(3,'DRIVINGLICENSE','iso_identity/front-identity/bdd97112-5827-47e8-ba56-187bc15b7b4f.jpeg','iso_identity/back-identity/bdd97112-5827-47e8-ba56-187bc15b7b4f.jpeg',1,5,NULL,NULL),(4,'DRIVINGLICENSE','agent_identity/front-identity/e8289104-3672-43cc-abf0-52fcc840e33a.jpeg','agent_identity/back-identity/e8289104-3672-43cc-abf0-52fcc840e33a.jpeg',1,6,NULL,NULL),(6,'DRIVINGLICENSE','iso_identity/front-identity/892ac334-6d18-4af2-9459-1931cdd306fd.jpeg','iso_identity/back-identity/892ac334-6d18-4af2-9459-1931cdd306fd.jpeg',1,9,NULL,NULL),(7,'DRIVINGLICENSE','agent_identity/front-identity/eaa0241d-925c-4360-96e2-74081d828314.jpeg','agent_identity/back-identity/eaa0241d-925c-4360-96e2-74081d828314.jpeg',1,10,NULL,NULL),(8,'DRIVINGLICENSE','iso_identity/front-identity/6710ac61-e806-4db4-92a9-7fbd2dfb4781.jpeg','iso_identity/back-identity/6710ac61-e806-4db4-92a9-7fbd2dfb4781.jpeg',1,14,NULL,NULL),(9,'DRIVINGLICENSE','agent_identity/front-identity/3f91cd3c-a52a-427b-be78-a59743f65f38.jpeg','agent_identity/back-identity/3f91cd3c-a52a-427b-be78-a59743f65f38.jpeg',1,15,NULL,NULL),(10,'DRIVINGLICENSE','agent_identity/front-identity/a7372b3a-9c11-40c5-8970-50b7f29798e3.jpeg',NULL,0,27,NULL,NULL),(11,'DRIVINGLICENSE','agent_identity/front-identity/46f0d940-5536-4426-8951-fbca4d2713d8.jpeg','agent_identity/back-identity/46f0d940-5536-4426-8951-fbca4d2713d8.jpeg',1,29,NULL,NULL),(12,'DRIVINGLICENSE','iso_identity/front-identity/e6ba05c8-e28a-46a4-98e7-682f4d088849.jpeg','iso_identity/back-identity/e6ba05c8-e28a-46a4-98e7-682f4d088849.jpeg',1,54,NULL,NULL);

--
-- Table structure for table `Vending`
--

CREATE TABLE `Vending` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vending_id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `userId` int(11) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `Vending_userId_fkey` (`userId`),
  CONSTRAINT `Vending_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Vending`
--

INSERT INTO `Vending` VALUES (2,'34-23-51-23-21-21','Green Card Demo-Default','510 Address',7,'2024-06-28 23:25:41.999','2024-07-03 17:10:10.717',0);


