--
-- 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 `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 `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 `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 `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 `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);


