--
-- Host: localhost    Database: growthdeskuser_wa_username_es
-- ------------------------------------------------------


--
-- Table structure for table `account_user_relations`
--

CREATE TABLE `account_user_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `mapped_user_id` bigint unsigned NOT NULL,
  `email` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_country_code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_user_relations_user_id_mapped_user_id_unique` (`user_id`,`mapped_user_id`),
  KEY `account_user_relations_user_id_index` (`user_id`),
  KEY `account_user_relations_mapped_user_id_index` (`mapped_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `account_user_relations`
--


--
-- Table structure for table `address_states`
--

CREATE TABLE `address_states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `directory_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `address_states`
--

INSERT INTO `address_states` VALUES (1,'Selangor','selangor','/directory-selangor/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(2,'WP Kuala Lumpur','kuala-lumpur','/directory-kuala-lumpur/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(3,'Negeri Sembilan','negeri-sembilan','/directory-negeri-sembilan/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(4,'Pulau Pinang','pulau-pinang','/directory-pulau-pinang/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(5,'Pahang','pahang','/directory-pahang/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(6,'Johor','johor','/directory-johor/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(7,'Sabah','sabah','/directory-sabah/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(8,'Sarawak','sarawak','/directory-sarawak/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(9,'Melaka','melaka','/directory-melaka/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(10,'Kelantan','kelantan','/directory-kelantan/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(11,'Kedah','kedah','/directory-kedah/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(12,'Perak','perak','/directory-perak/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(13,'Perlis','perlis','/directory-perlis/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(14,'Putrajaya','putrajaya','/directory-putrajaya/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17'),(15,'Terengganu','terengganu','/directory-terengganu/','MY','2026-04-07 06:34:17','2026-04-07 06:34:17');

--
-- Table structure for table `analytics_bi_summaries`
--

CREATE TABLE `analytics_bi_summaries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `analytic_viewid` bigint unsigned NOT NULL,
  `business_account_id` bigint unsigned NOT NULL,
  `group_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key1` timestamp NULL DEFAULT NULL,
  `group_key2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key4` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key5` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key6` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key7` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key8` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key9` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key10` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key11` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key12` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key13` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_key14` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `synced_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `group_type_index` (`analytic_viewid`,`business_account_id`,`group_type`(6)),
  KEY `group_key_index` (`analytic_viewid`,`business_account_id`,`group_key1`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `analytics_bi_summaries`
--

INSERT INTO `analytics_bi_summaries` VALUES (1,0,1,'statistics',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'{\"users\":{\"list\":{\"1\":6,\"0\":5},\"total\":11},\"referrals\":{\"list\":[],\"total\":0},\"points\":{\"list\":{\"spend\":0,\"unspend\":0},\"total\":0},\"chances\":{\"list\":{\"spend\":0,\"unspend\":35},\"total\":35},\"userActives\":{\"list\":{\"active\":2},\"total\":11},\"dstwSpin\":{\"list\":[],\"total\":0},\"plants\":{\"list\":[],\"total\":0},\"voucherDownloads\":{\"list\":{\"burnt\":4},\"total\":\"2\"},\"voucherTrnsAmt\":{\"list\":[],\"total\":0},\"receipts\":{\"list\":{\"complete\":11,\"other\":0},\"total\":11},\"receiptTrnsAmt\":{\"list\":{\"complete\":0,\"other\":0},\"total\":0},\"dcAppInstallApprovals\":{\"list\":{\"rejected\":0,\"pending\":0,\"scheduling\":0},\"total\":0},\"dcOfflineEngApprovals\":{\"list\":{\"rejected\":0,\"pending\":0,\"scheduling\":0},\"total\":0},\"dcSocialFollowsApprovals\":{\"list\":{\"rejected\":0,\"pending\":0,\"scheduling\":0},\"total\":0},\"dcTakeAPhotoApprovals\":{\"list\":{\"rejected\":0,\"pending\":0,\"scheduling\":0},\"total\":0},\"dcReceiptUploadApprovals\":{\"list\":{\"rejected\":0,\"pending\":0,\"scheduling\":0},\"total\":11}}','2026-05-13 10:00:26','2026-05-13 07:00:21','2026-05-13 10:00:26');

--
-- Table structure for table `analytics_view`
--

CREATE TABLE `analytics_view` (
  `viewid` bigint NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `data_group` text NOT NULL,
  `data_type` text NOT NULL,
  `setting` text NOT NULL,
  `is_home_bi` tinyint(1) NOT NULL DEFAULT '0',
  `bi_home_order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`viewid`),
  KEY `account_group_type_index` (`business_account_id`,`data_group`(8),`data_type`(20)),
  KEY `account_bi_order_index` (`business_account_id`,`is_home_bi`,`bi_home_order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `analytics_view`
--


--
-- Table structure for table `api_logs`
--

CREATE TABLE `api_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `response_headers` longtext COLLATE utf8mb4_unicode_ci,
  `response` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `apilable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apilable_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `apilable_key` (`apilable_type`,`apilable_id`),
  KEY `api_logs_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `api_logs`
--


--
-- Table structure for table `approvals`
--

CREATE TABLE `approvals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reviewed_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reviewed_at` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `status_reason` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ocr_appv_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `approvals_module_module_identifier_index` (`module`,`module_identifier`),
  KEY `approvals_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `approvals`
--

INSERT INTO `approvals` VALUES (1,'daily_challenge','34','1','2026-05-12 12:03:04','approved',NULL,'scheduling','2026-05-12 03:42:09','2026-05-12 04:03:04'),(2,'daily_challenge','35','1','2026-05-12 12:06:28','approved',NULL,'scheduling','2026-05-12 03:44:37','2026-05-12 04:06:28'),(3,'daily_challenge','36','1','2026-05-12 13:15:34','approved',NULL,'scheduling','2026-05-12 04:10:01','2026-05-12 05:15:34'),(4,'daily_challenge','37','1','2026-05-12 13:15:53','approved',NULL,'scheduling','2026-05-12 04:10:18','2026-05-12 05:15:53'),(5,'daily_challenge','38','1','2026-05-12 13:31:46','approved',NULL,'scheduling','2026-05-12 05:22:32','2026-05-12 05:31:46'),(6,'daily_challenge','39','1','2026-05-12 13:47:24','approved',NULL,'scheduling','2026-05-12 05:46:47','2026-05-12 05:47:24'),(7,'daily_challenge','40','1','2026-05-12 13:50:13','approved',NULL,'scheduling','2026-05-12 05:49:57','2026-05-12 05:50:13'),(8,'daily_challenge','41','1','2026-05-12 16:23:17','approved',NULL,'scheduling','2026-05-12 08:23:01','2026-05-12 08:23:17'),(9,'daily_challenge','46','1','2026-05-12 16:36:44','approved',NULL,'scheduling','2026-05-12 08:26:53','2026-05-12 08:36:44'),(10,'daily_challenge','48','1','2026-05-13 13:54:44','approved',NULL,'scheduling','2026-05-13 04:25:41','2026-05-13 05:54:44'),(11,'daily_challenge','50','1','2026-05-13 17:09:23','approved',NULL,'scheduling','2026-05-13 09:08:38','2026-05-13 09:09:23');

--
-- Table structure for table `asset_challenge_relations`
--

CREATE TABLE `asset_challenge_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_asset_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `challengable_index` (`model_type`,`model_id`),
  KEY `asset_challenge_relations_business_asset_id_index` (`business_asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_challenge_relations`
--


--
-- Table structure for table `asset_paths`
--

CREATE TABLE `asset_paths` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assetable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assetable_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_paths_assetable_type_assetable_id_index` (`assetable_type`,`assetable_id`),
  KEY `asset_paths_type_index` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `asset_paths`
--

INSERT INTO `asset_paths` VALUES (1,'image','App\\Models\\Receipts','1','public/business_account/1WAUsernameTest/receipts/9GyvPOwU7y-a1c243c5-521e-4149-afa0-b98131e490d2.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/9GyvPOwU7y-a1c243c5-521e-4149-afa0-b98131e490d2.jpeg','d2eab247fc3bda9e365ef52d6f94e532','image/jpeg',NULL,'2026-05-12 03:42:07','2026-05-12 03:42:07'),(2,'image','App\\Models\\Receipts','2','public/business_account/1WAUsernameTest/receipts/6nt66dgyBL-a1c244a9-42e7-46db-bcdc-30bdfc0db42c.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/6nt66dgyBL-a1c244a9-42e7-46db-bcdc-30bdfc0db42c.jpeg','d2eab247fc3bda9e365ef52d6f94e532','image/jpeg',NULL,'2026-05-12 03:44:36','2026-05-12 03:44:36'),(3,'image','App\\Models\\Receipts','3','public/business_account/1WAUsernameTest/receipts/wJlNWy85QF-a1c24dbf-52d3-4488-8e20-3c5846179fab.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/wJlNWy85QF-a1c24dbf-52d3-4488-8e20-3c5846179fab.jpeg','3019f36ba7fae4369698ea2c8d678056','image/jpeg',NULL,'2026-05-12 04:10:01','2026-05-12 04:10:01'),(4,'image','App\\Models\\Receipts','4','public/business_account/1WAUsernameTest/receipts/ua00kCvK9g-a1c24dd8-f2df-488e-a8e5-4dfe4dfcd1ae.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/ua00kCvK9g-a1c24dd8-f2df-488e-a8e5-4dfe4dfcd1ae.jpeg','0b935539bd6dc733656cd3a13f49d39f','image/jpeg',NULL,'2026-05-12 04:10:17','2026-05-12 04:10:17'),(5,'image','App\\Models\\Receipts','5','public/business_account/1WAUsernameTest/receipts/1Et31gAOYf-a1c267ae-77e4-4323-9e2b-e1257aa5c606.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/1Et31gAOYf-a1c267ae-77e4-4323-9e2b-e1257aa5c606.jpeg','eca4ef2ce4b83efc0d03194db7ae7462','image/jpeg',NULL,'2026-05-12 05:22:32','2026-05-12 05:22:32'),(6,'image','App\\Models\\Receipts','6','public/business_account/1WAUsernameTest/receipts/MM8RuAeraN-a1c2705b-0013-42d8-ad9c-5827e4dd9aaf.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/MM8RuAeraN-a1c2705b-0013-42d8-ad9c-5827e4dd9aaf.jpeg','f75900f0c450d08a97b595c0c33f18c5','image/jpeg',NULL,'2026-05-12 05:46:47','2026-05-12 05:46:47'),(7,'image','App\\Models\\Receipts','7','public/business_account/1WAUsernameTest/receipts/SaCtfMdh9j-a1c2717d-06fc-4b5e-8b79-df3dad1e017c.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/SaCtfMdh9j-a1c2717d-06fc-4b5e-8b79-df3dad1e017c.jpeg','550ec24d69941dd88acf7aea52107a4f','image/jpeg',NULL,'2026-05-12 05:49:57','2026-05-12 05:49:57'),(8,'image','App\\Models\\Receipts','8','public/business_account/1WAUsernameTest/receipts/vHkWp7QyCP-a1c2a83a-9416-47b0-94d0-f2388e973b1b.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/vHkWp7QyCP-a1c2a83a-9416-47b0-94d0-f2388e973b1b.jpeg','f2bc07cfa095371f3338b42dca6b5d94','image/jpeg',NULL,'2026-05-12 08:23:01','2026-05-12 08:23:01'),(9,'image','App\\Models\\Receipts','9','public/business_account/1WAUsernameTest/receipts/5U2zY9GGMB-a1c2a99c-c5ae-4079-93fe-948ad98a99fe.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/5U2zY9GGMB-a1c2a99c-c5ae-4079-93fe-948ad98a99fe.jpeg','b330dfd1361f3785c7185d9243d03e58','image/jpeg',NULL,'2026-05-12 08:26:53','2026-05-12 08:26:53'),(10,'image','App\\Models\\Receipts','10','public/business_account/1WAUsernameTest/receipts/ZUgMoJyQas-a1c45654-fdc8-44db-b765-d4a71ead768a.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/ZUgMoJyQas-a1c45654-fdc8-44db-b765-d4a71ead768a.jpeg','e4dcfd1abaa6af0d991949f30732388e','image/jpeg',NULL,'2026-05-13 04:25:40','2026-05-13 04:25:40'),(11,'image','App\\Models\\Receipts','11','public/business_account/1WAUsernameTest/receipts/vd62sQ4DAz-a1c4bb86-3e78-41b0-8172-a86a2a68869b.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/vd62sQ4DAz-a1c4bb86-3e78-41b0-8172-a86a2a68869b.jpeg','064e8ecfd7e259b0f63ca54105a49891','image/jpeg',NULL,'2026-05-13 09:08:38','2026-05-13 09:08:38');

--
-- Table structure for table `audit_revisions`
--

CREATE TABLE `audit_revisions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `business_account_id` bigint unsigned DEFAULT NULL COMMENT 'Changes apply to Business Account',
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `before_update` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `after_update` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `audit_revisions_user_id_index` (`user_id`),
  KEY `audit_revisions_``type``(6)_index` (`type`(6)),
  KEY `audit_revisions_business_account_id_type_index` (`business_account_id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_revisions`
--

INSERT INTO `audit_revisions` VALUES (1,NULL,NULL,'translation_command',NULL,'translations:import','2026-04-07 06:33:38'),(2,NULL,NULL,'translation_command',NULL,'translations:export','2026-04-07 06:33:42'),(3,NULL,NULL,'business_account',NULL,'{\"country\":\"SG\",\"language\":\"en\",\"company_name\":\"WA Username Test\",\"account_sn\":\"AUse\",\"hostname\":\"wa-username-testing.growthdesk.dev\",\"icon\":\"-\",\"sender_id\":\"SKALE\",\"noreply\":\"no-reply@skale.today\",\"is_agency\":\"0\",\"account_group\":null,\"updated_at\":\"2026-04-07 14:36:23\",\"created_at\":\"2026-04-07 14:36:23\",\"id\":1}','2026-04-07 06:36:24'),(4,NULL,1,'business_domains',NULL,'{\"hostname\":\"wa-username-testing.growthdesk.dev\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":1}','2026-04-07 06:36:24'),(5,NULL,NULL,'business_account','{\"country\":\"SG\",\"language\":\"en\",\"company_name\":\"WA Username Test\",\"account_sn\":\"AUse\",\"hostname\":\"wa-username-testing.growthdesk.dev\",\"icon\":\"-\",\"sender_id\":\"SKALE\",\"noreply\":\"no-reply@skale.today\",\"is_agency\":\"0\",\"account_group\":null,\"updated_at\":\"2026-04-07T06:36:23.000000Z\",\"created_at\":\"2026-04-07T06:36:23.000000Z\",\"id\":1}','{\"account_sn\":\"1AUse\",\"updated_at\":\"2026-04-07 14:36:24\",\"slug\":\"1WAUsernameTest\"}','2026-04-07 06:36:24'),(6,NULL,NULL,'business_account','{\"country\":\"SG\",\"language\":\"en\",\"company_name\":\"WA Username Test\",\"account_sn\":\"1AUse\",\"hostname\":\"wa-username-testing.growthdesk.dev\",\"icon\":\"-\",\"sender_id\":\"SKALE\",\"noreply\":\"no-reply@skale.today\",\"is_agency\":\"0\",\"account_group\":null,\"updated_at\":\"2026-04-07T06:36:24.000000Z\",\"created_at\":\"2026-04-07T06:36:23.000000Z\",\"id\":1,\"slug\":\"1WAUsernameTest\"}','{\"alias\":\"WA Username Test Campaign\"}','2026-04-07 06:36:24'),(7,NULL,1,'env_configs','{\"business_account_id\":1}','{\"CAMPAIGN_NAME\":\"WA Username Test Campaign\",\"CAMPAIGN_SHORT_NAME\":\"\",\"CAMPAIGN_DESCRIPTION\":\"\",\"CAMPAIGN_KEYWORDS\":\"\",\"IS_PRE_CAMPAIGN_GAME\":\"\",\"CAMPAIGN_START_MSG\":\"\",\"CAMPAIGN_END_MSG\":\"\",\"CAMPAIGN_REDEEM_END_MSG\":\"\",\"CLIENT_TERMS_LINK\":\"\",\"CLIENT_PRIVACY_LINK\":\"\",\"THEME_COLOR\":\"#410505\",\"TEXT_COLOR_DEFAULT\":\"#FFFFFF\",\"LOGO_WHITE_DEFAULT\":\"\",\"MASTHEAD_DEFAULT\":\"\",\"MASTHEAD_DEFAULT_POPUP\":\"\",\"BACKGROUND_IMG_DEFAULT\":\"\",\"BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BACKGROUND_IMG_POPUP_DEFAULT\":\"\",\"BACKGROUND_COLOR_POPUP_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BTN_FONT_COLOR_DEFAULT\":\"#3A3C6E\",\"BTN_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(90deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_FONT_COLOR_DEFAULT\":\"#323747\",\"CLIENT_CONTACT_US_EMAIL\":\"hello@skale.today\",\"CLIENT_FACEBOOK\":\"\",\"CLIENT_INSTAGRAM\":\"\",\"CLIENT_LINKEDIN\":\"\",\"CAMPAIGN_LICENSING_NO\":\"\",\"SOCIAL_SHARE_IMG_DEFAULT\":\"\",\"PWA_FAVICON\":\"\",\"PWA_FAVICON_16\":\"\",\"PWA_FAVICON_32\":\"\",\"PWA_FAVICON_96\":\"\",\"PWA_FAVICON_192\":\"\",\"PWA_FAVICON_256\":\"\",\"PWA_FAVICON_384\":\"\",\"PWA_FAVICON_512\":\"\",\"REG_EMAIL_MANDATORY\":\"true\",\"REG_ENABLE_DOB\":\"false\",\"REG_ENABLE_YEAR\":\"\",\"REG_ENABLE_ADDRESS\":\"\",\"REG_ENABLE_ADDRESS_STATE\":\"\",\"SRR_HAS_REQUIRE_MERCHANTS\":\"\",\"SRR_HAS_REQUIRE_TRANSACTION_AMOUNT\":\"\",\"CHALLENGE_APPROVE_TITLE\":\"\",\"CHALLENGE_APPROVE_SUBTITLE\":\"\",\"CHALLENGE_PENDING_TITLE\":\"\",\"CHALLENGE_PENDING_SUBTITLE\":\"\",\"CHALLENGE_SHORTCUT_SUBTITLE\":\"\",\"REFERRAL_INSTRUCTION\":\"Both you and your friend will get 1 points when they sign up through your link & upload their first receipt\",\"SOCIAL_SHARE_MSG\":\"Did you hear about :client_name\'s Platform? Join with my link below and you will immediately get :referrer_point free points right away. Start here: {referrer_link}\",\"REFERRAL_REWARD_LIMIT\":\"\",\"RIDDLE_LOSE\":\"\",\"RIDDLE_QNS_PER_DAY\":\"\",\"RIDDLE_QNS_RANDOMIZE\":\"\",\"FACEBOOK_PIXEL_ID\":\"\",\"GTM_CONTAINER_ID\":\"\",\"SKALE_PIXEL_ID\":\"\",\"TIKTOK_PIXEL_ID\":\"\",\"OTHER_ID\":\"\",\"DEFAULT_START_DATE\":\"2026-05-07\",\"DEFAULT_REDEEM_START_DATE\":\"2026-05-07\",\"DEFAULT_END_DATE\":\"2027-05-07\",\"DEFAULT_REDEEM_END_DATE\":\"2027-05-07\"}','2026-04-07 06:36:24'),(8,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"referrer_token\",\"settings\":15,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":1}','2026-04-07 06:36:24'),(9,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"referee_token\",\"settings\":15,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":2}','2026-04-07 06:36:24'),(10,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"popup:layout\",\"settings\":\"{\\\"layout\\\":\\\"components.main.popup.template\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":3}','2026-04-07 06:36:24'),(11,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"daily_checkin\",\"settings\":\"{\\\"is_active\\\":\\\"1\\\",\\\"type\\\":\\\"points\\\",\\\"qty\\\":\\\"10\\\",\\\"auto\\\":\\\"0\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":4}','2026-04-07 06:36:24'),(12,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"app:layout\",\"settings\":\"{\\\"layout\\\":\\\"enterprise_default\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":5}','2026-04-07 06:36:24'),(13,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"home:layout\",\"settings\":\"{\\\"layout\\\":\\\"enterprise\\\",\\\"showPoint\\\":true}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":6}','2026-04-07 06:36:24'),(14,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"group:layout\",\"settings\":\"{\\\"layout\\\":\\\"enterprise_default\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":7}','2026-04-07 06:36:24'),(15,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"login:layout\",\"settings\":\"{\\\"layout\\\":\\\"enterprise.login\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":8}','2026-04-07 06:36:24'),(16,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"register:layout\",\"settings\":\"{\\\"layout\\\":\\\"enterprise.register\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":9}','2026-04-07 06:36:24'),(17,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"basic_chance\",\"settings\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":\\\"1\\\"}\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":10}','2026-04-07 06:36:24'),(18,NULL,1,'sys_settings',NULL,'{\"business_account_id\":1,\"type\":\"homepage_required_login\",\"settings\":\"true\",\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":11}','2026-04-07 06:36:24'),(19,NULL,1,'notification_templates',NULL,'{\"slug\":\"welcome_with_otp_retry\",\"type\":\"sms\",\"content\":\"WA Username Test: OTP: {{otp_code}} Thank you for registering with us! Enter the OTP or verify via this link: {{login_url}}\",\"language\":\"en\",\"description\":\"Sent upon registration with OTP password for mobile verification \",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":1}','2026-04-07 06:36:24'),(20,NULL,1,'notification_templates',NULL,'{\"slug\":\"welcome_with_otp\",\"type\":\"sms\",\"content\":\"WA Username Test: {{otp_code}} Thank you for registering with us! Enter the OTP or verify via this link: {{login_url}}\",\"language\":\"en\",\"description\":\"Sent upon registration with OTP password for mobile verification \",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":2}','2026-04-07 06:36:24'),(21,NULL,1,'notification_templates',NULL,'{\"slug\":\"user_relogin\",\"type\":\"sms\",\"content\":\"WA Username Test: Login to your account via this link: {{login_url}}\",\"language\":\"en\",\"description\":\"Sent when user is logged out and attempts to relogin to platform\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":3}','2026-04-07 06:36:24'),(22,NULL,1,'notification_templates',NULL,'{\"slug\":\"user_login_via_otp\",\"type\":\"sms\",\"content\":\"WA Username Test: Your OTP To Login is: {{otp_code}}\",\"language\":\"en\",\"description\":\"Sent when user is logged out and attempts to relogin to platform via OTP\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":4}','2026-04-07 06:36:24'),(23,NULL,1,'notification_templates',NULL,'{\"slug\":\"receipt_approval_approved\",\"type\":\"sms\",\"content\":\"WA Username Test: Your receipt has been approved. Login to your account via this link:{{login_url}}\",\"language\":\"en\",\"description\":\"Shown when receipt uploaded is approved \",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":5}','2026-04-07 06:36:24'),(24,NULL,1,'notification_templates',NULL,'{\"slug\":\"receipt_approval_approved\",\"type\":\"in-app\",\"content\":\"WA Username Test: Your receipt has been approved.\",\"language\":\"en\",\"description\":\"Shown when receipt uploaded is approved \",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":6}','2026-04-07 06:36:24'),(25,NULL,1,'notification_templates',NULL,'{\"slug\":\"receipt_approval_rejected\",\"type\":\"in-app\",\"content\":\"WA Username Test: Your receipt has been rejected.\",\"language\":\"en\",\"description\":\"Shown when receipt uploaded is rejected \",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":7}','2026-04-07 06:36:24'),(26,NULL,1,'notification_templates',NULL,'{\"slug\":\"referral_success\",\"type\":\"in-app\",\"content\":\"WA Username Test: Congratulations! Someone registered using your referral link. You have been credited with additional tokens.\",\"language\":\"en\",\"description\":\"Shown when user successfully refers new prospect and prospect registers for platform\",\"cta_action\":\"referral\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":8}','2026-04-07 06:36:24'),(27,NULL,1,'notification_templates',NULL,'{\"slug\":\"referral_limit_reached\",\"type\":\"in-app\",\"content\":\"WA Username Test: You have reached the maximum referral reward limit of {{limit}}. Thank you for spreading the word!\",\"language\":\"en\",\"description\":\"Shown when referrer reaches maximum referral reward limit\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":9}','2026-04-07 06:36:24'),(28,NULL,1,'notification_templates',NULL,'{\"slug\":\"main_game_reward\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user played main game regardless of win or lose\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":10}','2026-04-07 06:36:24'),(29,NULL,1,'notification_templates',NULL,'{\"slug\":\"main_game_reward_won\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user played main game and win the game\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":11}','2026-04-07 06:36:24'),(30,NULL,1,'notification_templates',NULL,'{\"slug\":\"main_game_reward_lose\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user played main game and lose the game\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":12}','2026-04-07 06:36:24'),(31,NULL,1,'notification_templates',NULL,'{\"slug\":\"bonus_reward_voucher_provisioning\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user received reward by completed X number of grid\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":13}','2026-04-07 06:36:24'),(32,NULL,1,'notification_templates',NULL,'{\"slug\":\"upon_check_in\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user successfully check in\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":14}','2026-04-07 06:36:24'),(33,NULL,1,'notification_templates',NULL,'{\"slug\":\"upon_big_giveaway_challenge\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user successfully scan a QR code\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":15}','2026-04-07 06:36:24'),(34,NULL,1,'notification_templates',NULL,'{\"slug\":\"upon_login\",\"type\":\"in-app\",\"content\":\"\",\"language\":\"en\",\"description\":\"Shown when user successfully login\",\"status\":\"inactive\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":16}','2026-04-07 06:36:24'),(35,NULL,1,'daily_challenges',NULL,'{\"slug\":\"riddle\",\"business_account_id\":1,\"name\":\"Riddle\",\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":null,\"setting_details\":\"{\\\"num_question\\\":1,\\\"is_fixed_for_all_user\\\":1,\\\"question_mode\\\":\\\"fixed_across_user\\\"}\",\"day_week_settings\":null,\"is_active\":0,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":1}','2026-04-07 06:36:24'),(36,NULL,1,'daily_challenges',NULL,'{\"slug\":\"take_a_picture\",\"business_account_id\":1,\"name\":\"Take a Picture\",\"description\":\"To learn more, please head to the nearest customer service counter.\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Snap_Photo-min.png\",\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"is_active\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":2}','2026-04-07 06:36:24'),(37,NULL,1,'daily_challenges',NULL,'{\"slug\":\"offline_eng\",\"business_account_id\":1,\"name\":\"ScanQR Code In-Store\",\"description\":\"Spend In-Store and Unlock an Additional Attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Scan_QR-min.png\",\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":1}\",\"day_week_settings\":null,\"is_active\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":3}','2026-04-07 06:36:24'),(38,NULL,1,'daily_challenges',NULL,'{\"slug\":\"social_follow\",\"business_account_id\":1,\"name\":\"Join our Social Media\",\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Follow_Social_Media-min.png\",\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"is_active\":1,\"updated_at\":\"2026-04-07 14:36:24\",\"created_at\":\"2026-04-07 14:36:24\",\"id\":4}','2026-04-07 06:36:25'),(39,NULL,1,'daily_challenges',NULL,'{\"slug\":\"app_install\",\"business_account_id\":1,\"name\":\"Install App\",\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Install_App-min.png\",\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"is_active\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":5}','2026-04-07 06:36:25'),(40,NULL,1,'daily_challenges',NULL,'{\"slug\":\"upload_receipt\",\"business_account_id\":1,\"name\":\"Upload Receipt\",\"description\":\"Upload receipt of your purchase to unlock additional attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Upload_Receipt-min.png\",\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":1}\",\"day_week_settings\":null,\"is_active\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":6}','2026-04-07 06:36:25'),(41,NULL,1,'daily_challenges',NULL,'{\"slug\":\"scratchcard\",\"business_account_id\":1,\"name\":\"Scratch Card\",\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":null,\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"is_active\":0,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":7}','2026-04-07 06:36:25'),(42,NULL,1,'daily_challenges',NULL,'{\"slug\":\"spinandwin\",\"business_account_id\":1,\"name\":\"Spin And Win\",\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":null,\"setting_details\":\"{\\\"win_title\\\":\\\"Congratulations\\\",\\\"win_subtitle\\\":\\\"You have won\\\",\\\"lose_title\\\":\\\"Oh No!\\\",\\\"lose_subtitle\\\":\\\"Please try again\\\"}\",\"day_week_settings\":null,\"is_active\":0,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":8}','2026-04-07 06:36:25'),(43,NULL,1,'daily_challenges',NULL,'{\"slug\":\"slotmachine\",\"business_account_id\":1,\"name\":\"Match And Win\",\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07T06:36:24.909893Z\",\"date_to\":null,\"reward_details\":null,\"setting_details\":\"{\\\"default\\\":[],\\\"count\\\":3,\\\"background\\\":\\\"\\\",\\\"tiles\\\":{\\\"background_type\\\":\\\"color\\\",\\\"background\\\":\\\"#FFFFFF\\\",\\\"position\\\":\\\"\\\",\\\"spacing\\\":\\\"5\\\",\\\"size\\\":\\\"25,25\\\"},\\\"rest_chance_of_win\\\":null,\\\"max_chance_of_win\\\":null}\",\"is_active\":0,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":9}','2026-04-07 06:36:25'),(44,NULL,1,'questions',NULL,'{\"question_title\":\"What has to be broken before you can use it!\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":1}','2026-04-07 06:36:25'),(45,NULL,NULL,'question_choices',NULL,'{\"choice_description\":\"Egg\",\"question_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":1}','2026-04-07 06:36:25'),(46,NULL,NULL,'question_choices',NULL,'{\"choice_description\":\"Heart\",\"question_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":2}','2026-04-07 06:36:25'),(47,NULL,NULL,'question_choices',NULL,'{\"choice_description\":\"Head\",\"question_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":3}','2026-04-07 06:36:25'),(48,NULL,NULL,'question_choices',NULL,'{\"choice_description\":\"Brain\",\"question_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":4}','2026-04-07 06:36:25'),(49,NULL,1,'questions','{\"question_title\":\"What has to be broken before you can use it!\",\"business_account_id\":1,\"updated_at\":\"2026-04-07T06:36:25.000000Z\",\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"id\":1}','{\"question_choice_id\":1}','2026-04-07 06:36:25'),(50,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-1\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"win\",\"points\":\"1\",\"color\":\"#C73D30\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/500487933.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"1 Points\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":1}','2026-04-07 06:36:25'),(51,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.206201Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":1}','2026-04-07 06:36:25'),(52,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-2\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"lose\",\"points\":\"0\",\"color\":\"#FFFFFF\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/696600712.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"Try again\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":2}','2026-04-07 06:36:25'),(53,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.372690Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":2,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":2}','2026-04-07 06:36:25'),(54,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-3\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"win\",\"points\":\"1\",\"color\":\"#FFCC20\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/1993415940.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"1 Points\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":3}','2026-04-07 06:36:25'),(55,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.477891Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":3,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":3}','2026-04-07 06:36:25'),(56,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-4\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"lose\",\"points\":\"0\",\"color\":\"#AACAF7\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/1049926054.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"Try again\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":4}','2026-04-07 06:36:25'),(57,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.564690Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":4,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":4}','2026-04-07 06:36:25'),(58,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-5\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"win\",\"points\":\"1\",\"color\":\"#FFFFFF\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/541313044.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"1 Points\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":5}','2026-04-07 06:36:25'),(59,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.668754Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":5,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":5}','2026-04-07 06:36:25'),(60,NULL,1,'dstw_items',NULL,'{\"slug\":\"slot-6\",\"business_account_id\":1,\"chance_of_win\":1,\"status\":\"lose\",\"points\":\"0\",\"color\":\"#AACAF7\",\"img\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/spinwin\\/66063708.png\",\"details\":\"{\\\"type\\\":\\\"text\\\",\\\"message\\\":\\\"Try again\\\",\\\"font_color\\\":\\\"#EF9292\\\"}\",\"is_ignore_stock\":1,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":6}','2026-04-07 06:36:25'),(61,NULL,NULL,'dstw_item_periods',NULL,'{\"date_from\":\"2026-04-07T06:36:25.822223Z\",\"date_to\":\"9999-12-31T15:59:59.999999Z\",\"chance_of_win\":1,\"total_prize\":0,\"num_balance\":0,\"dstw_item_id\":6,\"updated_at\":\"2026-04-07 14:36:25\",\"created_at\":\"2026-04-07 14:36:25\",\"id\":6}','2026-04-07 06:36:25'),(62,NULL,1,'event_tag_categories',NULL,'{\"name\":\"Digital Engagement\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":1}','2026-04-07 06:36:26'),(63,NULL,1,'event_tag_types',NULL,'{\"name\":\"Visit to Site\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":1,\"event_tag_category_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":1}','2026-04-07 06:36:26'),(64,NULL,1,'event_tag_types',NULL,'{\"name\":\"Social Media Following\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":2,\"event_tag_category_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":2}','2026-04-07 06:36:26'),(65,NULL,1,'event_tag_types',NULL,'{\"name\":\"Register Gamification\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":3,\"event_tag_category_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":3}','2026-04-07 06:36:26'),(66,NULL,1,'event_tag_types',NULL,'{\"name\":\"In-Game Actions\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":4,\"event_tag_category_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":4}','2026-04-07 06:36:26'),(67,NULL,1,'event_tag_categories',NULL,'{\"name\":\"In-Store Engagement\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":2}','2026-04-07 06:36:26'),(68,NULL,1,'event_tag_types',NULL,'{\"name\":\"Scan QR\\/Input Pin Code\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":9,\"event_tag_category_id\":2,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":5}','2026-04-07 06:36:26'),(69,NULL,1,'event_tag_types',NULL,'{\"name\":\"Upload Photo (snap a photo)\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":5,\"event_tag_category_id\":2,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":6}','2026-04-07 06:36:26'),(70,NULL,1,'event_tag_categories',NULL,'{\"name\":\"Conversion Interest\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":3}','2026-04-07 06:36:26'),(71,NULL,1,'event_tag_types',NULL,'{\"name\":\"Voucher Download\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":6,\"event_tag_category_id\":3,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":7}','2026-04-07 06:36:26'),(72,NULL,1,'event_tag_categories',NULL,'{\"name\":\"Conversion\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":4}','2026-04-07 06:36:26'),(73,NULL,1,'event_tag_types',NULL,'{\"name\":\"Upload Receipt\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":7,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":8}','2026-04-07 06:36:26'),(74,NULL,1,'event_tag_types',NULL,'{\"name\":\"Voucher Redemption\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":8,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":9}','2026-04-07 06:36:26'),(75,NULL,1,'event_tag_types',NULL,'{\"name\":\"Scan QR\\/Input Pin Code\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":9,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":10}','2026-04-07 06:36:26'),(76,NULL,1,'event_tag_types',NULL,'{\"name\":\"Ecommerce Promo Code\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":10,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":11}','2026-04-07 06:36:26'),(77,NULL,1,'event_tag_types',NULL,'{\"name\":\"App Install\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":11,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":12}','2026-04-07 06:36:26'),(78,NULL,1,'event_tag_types',NULL,'{\"name\":\"Receipt Approved\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":12,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":13}','2026-04-07 06:36:26'),(79,NULL,1,'event_tag_types',NULL,'{\"name\":\"App Install Approved\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":13,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":14}','2026-04-07 06:36:26'),(80,NULL,1,'event_tag_types',NULL,'{\"name\":\"Social Media Following Approved\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":14,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":15}','2026-04-07 06:36:26'),(81,NULL,1,'event_tag_types',NULL,'{\"name\":\"Upload Photo (snap a photo) Approved\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":15,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":16}','2026-04-07 06:36:26'),(82,NULL,1,'event_tag_types',NULL,'{\"name\":\"Game Session State Updated\",\"description\":null,\"status\":\"active\",\"business_account_id\":1,\"event_tag_type_slug_id\":18,\"event_tag_category_id\":4,\"updated_at\":\"2026-04-07 14:36:26\",\"created_at\":\"2026-04-07 14:36:26\",\"id\":17}','2026-04-07 06:36:26'),(83,NULL,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiZTF2Q2Y4TE9LcUkzdzd3V1Y5U0tUdz09IiwibWFjIjoiZjI5N2RhZDA2OGNhYzA4NDczMjAxMDk1MzQ4YTIxZDJiM2FjMTc3MGJmMGIwZGFiNzU4Y2M4NWFkZmE1OTllZiJ9\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMU1YdG9CTU9xamplRXZOc2VnYXJFUT09IiwibWFjIjoiYzkwMzgzMDZlNjM4MGE1YzIyNTkwMGNiNjkwY2QzMGQxZjRlMGRlZTEyNjM4YzM1NjAzNjM0ZTAwNDY1NGE0NiJ9\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoid2w3MFFcL281NlExYVgrY0lYd09SeUZmT1wvU25RemJabXZIS1B4c3Q2SHhBPSIsIm1hYyI6IjQ4YzUwZWNkZWYwZDEzZjhiOTYxZGU5N2NmMjY0OGI0YzJjY2ViYmJmNDUzYmZjMDE0MzE3NDA2ODQyOWJjYTkifQ==\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile_country_code\":\"63\",\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"user_twofa\":\"294132\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 14:38:12\",\"created_at\":\"2026-04-07 14:38:12\",\"id\":2}','2026-04-07 06:38:12'),(84,NULL,1,'model_has_roles','App\\Events\\User\\RoleWasAssigned','{\"user_id\":2,\"role\":{\"id\":1,\"name\":\"super-admin\",\"guard_name\":\"web\"},\"created_at\":\"2026-04-07 14:38:12\"}','2026-04-07 06:38:12'),(85,NULL,1,'model_has_roles','App\\Events\\User\\RoleWasAssigned','{\"user_id\":2,\"role\":{\"id\":4,\"name\":\"admin\",\"guard_name\":\"web\"},\"created_at\":\"2026-04-07 14:38:12\"}','2026-04-07 06:38:12'),(86,NULL,1,'model_has_permissions','App\\Events\\User\\PermissionWasAssigned','{\"user_id\":2,\"role_id\":null,\"permission\":{\"id\":4,\"name\":\"blast-btn-send-test\",\"guard_name\":\"web\"},\"created_at\":\"2026-04-07 14:38:12\"}','2026-04-07 06:38:12'),(87,NULL,1,'model_has_permissions','App\\Events\\User\\PermissionWasAssigned','{\"user_id\":2,\"role_id\":null,\"permission\":{\"id\":5,\"name\":\"blast-btn-create-schedule\",\"guard_name\":\"web\"},\"created_at\":\"2026-04-07 14:38:12\"}','2026-04-07 06:38:12'),(88,NULL,1,'model_has_permissions','App\\Events\\User\\PermissionWasAssigned','{\"user_id\":2,\"role_id\":null,\"permission\":{\"id\":8,\"name\":\"can-manage-smart-receipt-service\",\"guard_name\":\"web\"},\"created_at\":\"2026-04-07 14:38:12\"}','2026-04-07 06:38:12'),(89,NULL,1,'users','{\"id\":2,\"business_account_id\":1,\"name\":\"EJ\",\"last_name\":false,\"email\":\"agas.ej@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"user_twofa\":\"294132\",\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T06:38:12.000000Z\",\"created_at\":\"2026-04-07T06:38:12.000000Z\",\"updated_at\":\"2026-04-07T06:38:12.000000Z\",\"google2fa_secret\":\"\"}','{\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07T06:52:34.300333Z\",\"updated_at\":\"2026-04-07 14:52:34\"}','2026-04-07 06:52:34'),(90,2,1,'users','{\"id\":2,\"business_account_id\":1,\"name\":\"EJ\",\"last_name\":false,\"email\":\"agas.ej@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"user_twofa\":\"294132\",\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07 14:52:34\",\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T06:38:12.000000Z\",\"created_at\":\"2026-04-07T06:38:12.000000Z\",\"updated_at\":\"2026-04-07T06:52:34.000000Z\",\"google2fa_secret\":\"\"}','{\"referrer_code\":\"9EDNDAE6\",\"updated_at\":\"2026-04-07 14:52:40\"}','2026-04-07 06:52:40'),(91,2,1,'users','{\"id\":2,\"business_account_id\":1,\"name\":\"EJ\",\"last_name\":false,\"email\":\"agas.ej@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"user_twofa\":\"294132\",\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07 14:52:34\",\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"9EDNDAE6\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T06:38:12.000000Z\",\"created_at\":\"2026-04-07T06:38:12.000000Z\",\"updated_at\":\"2026-04-07T06:52:40.000000Z\",\"google2fa_secret\":\"\"}','{\"updated_at\":\"2026-04-07 14:52:47\",\"google2fa_secret\":\"2WOO5C2F6PCQL2QQ\"}','2026-04-07 06:52:47'),(92,2,1,'users','{\"id\":2,\"business_account_id\":1,\"name\":\"EJ\",\"last_name\":false,\"email\":\"agas.ej@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"user_twofa\":\"294132\",\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07 14:52:34\",\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"9EDNDAE6\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T06:38:12.000000Z\",\"created_at\":\"2026-04-07T06:38:12.000000Z\",\"updated_at\":\"2026-04-07T06:52:47.000000Z\",\"google2fa_secret\":\"2WOO5C2F6PCQL2QQ\"}','{\"api_token\":\"a3fce5099219b0372d5ff64c49388b776d491b66a2512d05a03a4fcfd45dfaa7\",\"updated_at\":\"2026-04-07 14:53:05\"}','2026-04-07 06:53:05'),(93,2,1,'users','{\"id\":2,\"business_account_id\":1,\"name\":\"EJ\",\"last_name\":false,\"email\":\"agas.ej@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"user_twofa\":\"294132\",\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07 14:52:34\",\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$VVfSbulqM\\/eqj089i5k76eWOXBIDFfGIT4\\/r12uC5DUFS2x7Co1Lu\",\"api_token\":\"a3fce5099219b0372d5ff64c49388b776d491b66a2512d05a03a4fcfd45dfaa7\",\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"9EDNDAE6\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T06:38:12.000000Z\",\"created_at\":\"2026-04-07T06:38:12.000000Z\",\"updated_at\":\"2026-04-07T06:53:05.000000Z\",\"google2fa_secret\":\"2WOO5C2F6PCQL2QQ\"}','{\"api_token\":\"26d5af1082baf87606f9c37f133d20a89948baf36a179a79c2035a3adf0da615\",\"updated_at\":\"2026-04-07 14:53:06\"}','2026-04-07 06:53:06'),(94,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMW5NQk9PdE1UbEVqMllwYnlUTmZVSFczSDloZ3ZVcHlYc0ZUXC9lOFZHRDMzRjRDYUlIWUF5Tnhxak1WaVNGSHhjR1VTSTgxdGd5UnorWFQwYUFwQWtIXC9hd2lnUFFlWFgwKzFcL1wvN09jRjhrU1lhajdJSG9pTHhzS3BZTkNsZk16YlhFdkJHa25JNWF5MUJaUGJFQTJ4UzhOXC85WFFCR29UWFBYdXJsRElPT3pPXC9zRjZ2WTROdGJ2VUxpN2drZTJSVURQN0hKVEgzakFOc2hPVTJqK3FDdjZkSEhZS0kwQitlZFU2OFRFOFQ5Q3hPNVwvaGJwWjNRSitiQ05Tb2YxWDlMbmJoZVp5S050b1lBeWl0bm93S2tnPT0iLCJtYWMiOiJlMTJhNDRiMWQ1NWJmNDIzNjgxZWY2MjQ1NDYwM2QxYzk2ODcwNGJkNTMyMTI5Njk0Mzk3YTFhZDBkNWExM2I0In0=\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMWtaQmRLWFljWHhOXC9MQUZrUkM5ZDBXd2paTnZtKzNZZVVud3JKZzRUZWs9IiwibWFjIjoiMzdiZjI1ODhjZDFiZmY2NzdkYWM3ZDNjZDg5OWM5OTE0ZDI4MGYyNGM0Njc3Njc1YWUxZjFkMWUwNGU5MDdhZCJ9\",\"email_masked\":\"joh***@growthdesk.dev\",\"register_at\":\"2026-04-07 14:59:59\",\"wa_username\":\"johndoe0\",\"password\":\"$2y$10$K0KlAPMTIFTHkxwSf0GTK.u\\/C\\/LIcZm4r0YsWwJ3Q7iKJqVIbEJWi\",\"referrer_code\":\"HAS35670\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 15:02:48\",\"created_at\":\"2026-04-07 15:02:48\",\"id\":3}','2026-04-07 07:02:48'),(95,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMW5NQk9PdE1UbEVqMllwYnlUTmZVSFczSDloZ3ZVcHlYc0ZUXC9lOFZHRDMzRjRDYUlIWUF5Tnhxak1WaVNGSHhjR1VTSTgxdGd5UnorWFQwYUFwQWtIXC9hd2lnUFFlWFgwKzFcL1wvN09jRjhrU1lhajdJSG9pTHhzS3BZTkNsZk16YlhFdkJHa25JNWF5MUJaUGJFQTJ4UzhOXC85WFFCR29UWFBYdXJsRElPT3pPXC9zRjZ2WTROdGJ2VUxpN2drZTJSVURQN0hKVEgzakFOc2hPVTJqK3FDdjZkSEhZS0kwQitlZFU2OFRFOFQ5Q3hPNVwvaGJwWjNRSitiQ05Tb2YxWDlMbmJoZVp5S050b1lBeWl0bm93S2tnPT0iLCJtYWMiOiJlMTJhNDRiMWQ1NWJmNDIzNjgxZWY2MjQ1NDYwM2QxYzk2ODcwNGJkNTMyMTI5Njk0Mzk3YTFhZDBkNWExM2I0In0=\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMWtaQmRLWFljWHhOXC9MQUZrUkM5ZDBXd2paTnZtKzNZZVVud3JKZzRUZWs9IiwibWFjIjoiMzdiZjI1ODhjZDFiZmY2NzdkYWM3ZDNjZDg5OWM5OTE0ZDI4MGYyNGM0Njc3Njc1YWUxZjFkMWUwNGU5MDdhZCJ9\",\"email_masked\":\"joh***@growthdesk.dev\",\"register_at\":\"2026-04-07 15:12:59\",\"wa_username\":\"johndoe0\",\"password\":\"$2y$10$HeX0l0JDuNrpEgQC4ND8VuN5DSk3SlQf9zcdittNO\\/PiTQhzzDReS\",\"referrer_code\":\"4LGUZLKE\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 15:13:46\",\"created_at\":\"2026-04-07 15:13:46\",\"id\":4}','2026-04-07 07:13:46'),(96,2,1,'users','{\"id\":4,\"business_account_id\":1,\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiRFRvWlwvOHdzekhabGE4MEh6U091R1E9PSIsIm1hYyI6IjJhYmZhMDU0MWM3MzY4ZTZkYTI1YTNiNjk0YjMxYmRkYjRjNTkyYWM0NmRiMzA2MDk2Mjg2YWVkYTM3NzQwYjgifQ==\",\"last_name\":false,\"email\":\"johndoe0@growthdesk.dev\",\"email_masked\":\"joh***@growthdesk.dev\",\"mobile\":false,\"mobile_country_code\":null,\"wa_username\":\"johndoe0\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$HeX0l0JDuNrpEgQC4ND8VuN5DSk3SlQf9zcdittNO\\/PiTQhzzDReS\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"4LGUZLKE\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T07:12:59.000000Z\",\"created_at\":\"2026-04-07T07:13:46.000000Z\",\"updated_at\":\"2026-04-07T07:13:46.000000Z\",\"google2fa_secret\":\"\"}','{\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07T07:13:53.019671Z\",\"updated_at\":\"2026-04-07 15:13:53\"}','2026-04-07 07:13:53'),(97,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiVVZ6S0czbVRBaUVQUGdVMzhtdzNqZz09IiwibWFjIjoiYjQwOWUwMDNiYWY4MTE0NGJlMTFiOGY1YmFiOGZmYTc3M2NkZTRjNjY5MmU4YzQ0MmI1OTRkOWZmODU4MjM2MyJ9\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiZWdON1wveW1hMTgxVVR6ZVU1U2JKSU5IUXpDaFwvQWpOdnNmcngzVG9yR1YwPSIsIm1hYyI6Ijc4NGFkOGVjNzhjOGRiMTA2NmZlZjk4MDc4ODc0NWFiNmQ0MjM2ZmQ2NWEyZGQxOTM5YmNiMDM5Y2IxMGFmN2IifQ==\",\"email_masked\":\"joh***@growthdesk.dev\",\"register_at\":\"2026-04-07 15:13:59\",\"wa_username\":\"johndoe3\",\"password\":\"$2y$10$nH74i7yLI1HTlEbBICjOM.L3uziOQkj2uWO91HwR0qhPsnEK9p5Re\",\"referrer_code\":\"S0HSKRE7\",\"business_account_id\":1,\"updated_at\":\"2026-04-07 15:14:17\",\"created_at\":\"2026-04-07 15:14:17\",\"id\":5}','2026-04-07 07:14:17'),(98,NULL,1,'users','{\"id\":5,\"business_account_id\":1,\"name\":\"John Doe\",\"last_name\":false,\"email\":\"johndoe3@growthdesk.dev\",\"email_masked\":\"joh***@growthdesk.dev\",\"mobile\":false,\"mobile_country_code\":null,\"wa_username\":\"johndoe3\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$nH74i7yLI1HTlEbBICjOM.L3uziOQkj2uWO91HwR0qhPsnEK9p5Re\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"S0HSKRE7\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-07T07:13:59.000000Z\",\"created_at\":\"2026-04-07T07:14:17.000000Z\",\"updated_at\":\"2026-04-07T07:14:17.000000Z\",\"google2fa_secret\":\"\"}','{\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-07T07:14:30.217162Z\",\"updated_at\":\"2026-04-07 15:14:30\"}','2026-04-07 07:14:30'),(99,2,1,'questions',NULL,'{\"question_title\":\"Are you a cat or a dog person?\",\"business_account_id\":1,\"updated_at\":\"2026-04-13 17:10:24\",\"created_at\":\"2026-04-13 17:10:24\",\"id\":2}','2026-04-13 09:10:24'),(100,2,1,'question_choices',NULL,'{\"choice_description\":\"Cat\",\"question_id\":2,\"updated_at\":\"2026-04-13 17:10:24\",\"created_at\":\"2026-04-13 17:10:24\",\"id\":5}','2026-04-13 09:10:24'),(101,2,1,'question_choices',NULL,'{\"choice_description\":\"Dog\",\"question_id\":2,\"updated_at\":\"2026-04-13 17:10:24\",\"created_at\":\"2026-04-13 17:10:24\",\"id\":6}','2026-04-13 09:10:24'),(102,2,1,'question_choices',NULL,'{\"choice_description\":\"Both\",\"question_id\":2,\"updated_at\":\"2026-04-13 17:10:24\",\"created_at\":\"2026-04-13 17:10:24\",\"id\":7}','2026-04-13 09:10:24'),(103,2,1,'question_choices',NULL,'{\"choice_description\":\"Neither\",\"question_id\":2,\"updated_at\":\"2026-04-13 17:10:24\",\"created_at\":\"2026-04-13 17:10:24\",\"id\":8}','2026-04-13 09:10:24'),(104,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-04-16 07:53:11\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiS2U2akRtUXFHb3FhT2U3WVBadThjUT09IiwibWFjIjoiZWM1ZGEzNzdhMjA2NjU0YzgzYjM0MzgxOWUxNzU1NmUzNmRmODk4ZjBjZDI1ZmE2MjIwMjFmOGNlMGFlMzQzYyJ9\",\"mobile_country_code\":\"63\",\"password\":\"$2y$10$zTfAKCzKD0oUAD.cDds4Jeo7O6nbTi4zAutwrH9RT71srvG189cLi\",\"referrer_code\":\"NN2L5SA9\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 07:53:21\",\"created_at\":\"2026-04-16 07:53:21\",\"id\":6}','2026-04-15 23:53:21'),(105,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-04-16 07:53:11\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiS2U2akRtUXFHb3FhT2U3WVBadThjUT09IiwibWFjIjoiZWM1ZGEzNzdhMjA2NjU0YzgzYjM0MzgxOWUxNzU1NmUzNmRmODk4ZjBjZDI1ZmE2MjIwMjFmOGNlMGFlMzQzYyJ9\",\"mobile_country_code\":\"63\",\"password\":\"$2y$10$zacZxjbd\\/i.Dbqqd66AV4e3DLOVljMezBl2JlMo9aft6xLc6hFSRe\",\"referrer_code\":\"B8F07IZ2\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 07:53:23\",\"created_at\":\"2026-04-16 07:53:23\",\"id\":7}','2026-04-15 23:53:23'),(106,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-04-16 08:11:19\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiS2U2akRtUXFHb3FhT2U3WVBadThjUT09IiwibWFjIjoiZWM1ZGEzNzdhMjA2NjU0YzgzYjM0MzgxOWUxNzU1NmUzNmRmODk4ZjBjZDI1ZmE2MjIwMjFmOGNlMGFlMzQzYyJ9\",\"mobile_country_code\":\"63\",\"wa_bsuid\":\"PH.4534499620203017\",\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"referrer_code\":\"HQUE1BSC\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:11:27\",\"created_at\":\"2026-04-16 08:11:27\",\"id\":8}','2026-04-16 00:11:27'),(107,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534499620203017\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-04-16T00:11:27.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWmlyRTVDOFZia2tHQ3p6OGFia21jUT09IiwibWFjIjoiZTlmOGE0N2MzOTExNzQzMWU0M2YxYWY5YWU5ZWQ5ODg2MmIxZGIxZTc3NDk3Yzk2OTRjY2U3NjI0OTMxNzQ2OCJ9\",\"updated_at\":\"2026-04-16 08:11:35\"}','2026-04-16 00:11:35'),(108,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"wilson\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534499620203017\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-04-16T00:11:35.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiUHFnbUZDd1FYS3c3N3NzU2JEQWdWTjc4RXRyOTFoY25OY2IyZW9mcWI5WT0iLCJtYWMiOiI4ZTc1ZTliMjBmMDQ1OWMyMmNhNjkzNTMyNWRlYzdjYzEwMWJlNDM3OWFkNTg0ZDBmNTUyOTZjM2UxN2FhZjZmIn0=\",\"email_masked\":\"wil***@sample.com\",\"updated_at\":\"2026-04-16 08:11:41\"}','2026-04-16 00:11:41'),(109,2,1,'questions',NULL,'{\"question_title\":\"Which pet clinic or pet expo did you register from? (Reply \\u2018NONE\\u2019 if you did not register from any.)\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:11:54\",\"created_at\":\"2026-04-16 08:11:54\",\"id\":3}','2026-04-16 00:11:54'),(110,2,1,'questions',NULL,'{\"question_title\":\"What is the breed of your pet?\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:12:14\",\"created_at\":\"2026-04-16 08:12:14\",\"id\":4}','2026-04-16 00:12:14'),(111,2,1,'questions',NULL,'{\"question_title\":\"What is the name of your pet? (Just reply your pet name)\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:12:50\",\"created_at\":\"2026-04-16 08:12:50\",\"id\":5}','2026-04-16 00:12:50'),(112,2,1,'questions',NULL,'{\"question_title\":\"How old is your pet?\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:12:50\",\"created_at\":\"2026-04-16 08:12:50\",\"id\":6}','2026-04-16 00:12:50'),(113,2,1,'question_choices',NULL,'{\"choice_description\":\"<1 year\",\"question_id\":6,\"updated_at\":\"2026-04-16 08:12:50\",\"created_at\":\"2026-04-16 08:12:50\",\"id\":9}','2026-04-16 00:12:50'),(114,2,1,'question_choices',NULL,'{\"choice_description\":\"1-5 years\",\"question_id\":6,\"updated_at\":\"2026-04-16 08:12:50\",\"created_at\":\"2026-04-16 08:12:50\",\"id\":10}','2026-04-16 00:12:50'),(115,2,1,'question_choices',NULL,'{\"choice_description\":\"5-10 years\",\"question_id\":6,\"updated_at\":\"2026-04-16 08:12:51\",\"created_at\":\"2026-04-16 08:12:51\",\"id\":11}','2026-04-16 00:12:51'),(116,2,1,'question_choices',NULL,'{\"choice_description\":\"10 years+\",\"question_id\":6,\"updated_at\":\"2026-04-16 08:12:51\",\"created_at\":\"2026-04-16 08:12:51\",\"id\":12}','2026-04-16 00:12:51'),(117,2,1,'questions',NULL,'{\"question_title\":\"Are you a multiple pet household? (more than 1 pet)\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 08:12:51\",\"created_at\":\"2026-04-16 08:12:51\",\"id\":7}','2026-04-16 00:12:51'),(118,2,1,'question_choices',NULL,'{\"choice_description\":\"Yes\",\"question_id\":7,\"updated_at\":\"2026-04-16 08:12:51\",\"created_at\":\"2026-04-16 08:12:51\",\"id\":13}','2026-04-16 00:12:51'),(119,2,1,'question_choices',NULL,'{\"choice_description\":\"No\",\"question_id\":7,\"updated_at\":\"2026-04-16 08:12:51\",\"created_at\":\"2026-04-16 08:12:51\",\"id\":14}','2026-04-16 00:12:51'),(120,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-04-16 11:16:36\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMU1YdG9CTU9xamplRXZOc2VnYXJFUT09IiwibWFjIjoiYzkwMzgzMDZlNjM4MGE1YzIyNTkwMGNiNjkwY2QzMGQxZjRlMGRlZTEyNjM4YzM1NjAzNjM0ZTAwNDY1NGE0NiJ9\",\"mobile_country_code\":\"63\",\"wa_bsuid\":\"PH.4534357273550585\",\"password\":\"$2y$10$fra8UiWF2Q2hIqtPJ1Fy4.pq5HzbjAxoibyfog7eP4L6GawR4Vbpm\",\"referrer_code\":\"DCVVTN7G\",\"business_account_id\":1,\"updated_at\":\"2026-04-16 11:16:42\",\"created_at\":\"2026-04-16 11:16:42\",\"id\":9}','2026-04-16 03:16:42'),(121,2,1,'users','{\"id\":9,\"business_account_id\":1,\"name\":\"\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534357273550585\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$fra8UiWF2Q2hIqtPJ1Fy4.pq5HzbjAxoibyfog7eP4L6GawR4Vbpm\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"DCVVTN7G\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T03:16:36.000000Z\",\"created_at\":\"2026-04-16T03:16:42.000000Z\",\"updated_at\":\"2026-04-16T03:16:42.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoickwrVzZmSFZMQ0x1OFNRblZPT2Y2Zz09IiwibWFjIjoiOWJlNTg2YTViYTE3ZmJiOGM3Y2ZiZjg1YWYwMmVjMWU3OTFiODBmMjNiMWE3Y2FkMDViZTg5NzllMTM2NWViMiJ9\",\"updated_at\":\"2026-04-16 11:16:49\"}','2026-04-16 03:16:49'),(122,2,1,'users','{\"id\":9,\"business_account_id\":1,\"name\":\"EJJ\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534357273550585\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$fra8UiWF2Q2hIqtPJ1Fy4.pq5HzbjAxoibyfog7eP4L6GawR4Vbpm\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"DCVVTN7G\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T03:16:36.000000Z\",\"created_at\":\"2026-04-16T03:16:42.000000Z\",\"updated_at\":\"2026-04-16T03:16:49.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiVE5uQkZEKzJUY09DWldzdkkzbytaXC9cL05uQzNuUW11RDNZcGttUFdVRm5BPSIsIm1hYyI6ImVjMTRkOTc5YmVkN2E0MzdhZTM1NmEwYmM3NzQ4OWI5MjdkMDU2YTQ2NzFhZGJjMDZjMWY1YjFmOWYwOGM0MzAifQ==\",\"email_masked\":\"aga***@growthdesk.com\",\"updated_at\":\"2026-04-16 11:17:10\"}','2026-04-16 03:17:10'),(123,NULL,1,'users','{\"id\":9,\"business_account_id\":1,\"name\":\"EJJ\",\"last_name\":false,\"email\":\"agas.ejtest@growthdesk.com\",\"email_masked\":\"aga***@growthdesk.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534357273550585\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$fra8UiWF2Q2hIqtPJ1Fy4.pq5HzbjAxoibyfog7eP4L6GawR4Vbpm\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"DCVVTN7G\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T03:16:36.000000Z\",\"created_at\":\"2026-04-16T03:16:42.000000Z\",\"updated_at\":\"2026-04-16T03:17:10.000000Z\",\"google2fa_secret\":\"\"}','{\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-04-16T04:02:39.393332Z\",\"updated_at\":\"2026-04-16 12:02:39\"}','2026-04-16 04:02:39'),(124,2,1,'stores',NULL,'{\"name\":\"Test Store 1\",\"slug\":\"test-store-1\",\"status\":\"active\",\"business_account_id\":1,\"updated_at\":\"2026-04-23 14:26:29\",\"created_at\":\"2026-04-23 14:26:29\",\"id\":1}','2026-04-23 06:26:29'),(125,2,1,'stores','{\"name\":\"Test Store 1\",\"slug\":\"test-store-1\",\"status\":\"active\",\"business_account_id\":1,\"updated_at\":\"2026-04-23T06:26:29.000000Z\",\"created_at\":\"2026-04-23T06:26:29.000000Z\",\"id\":1}','{\"store_type_id\":1}','2026-04-23 06:26:29'),(126,2,1,'business_assets',NULL,'{\"name\":\"Test Outlet 1\",\"address\":\"Foo St.\",\"full_address\":null,\"type\":\"retail\",\"slug\":\"test-outlet-1\",\"store\":\"test-store-1\",\"identifier\":\"test-outlet-1\",\"status\":\"active\",\"redeem_code\":869644,\"promotion_code_display_method\":\"default\",\"company_name\":null,\"location_keywords\":\"[]\",\"is_smart_receipt_exclusion\":false,\"business_account_id\":1,\"updated_at\":\"2026-04-23 14:26:50\",\"created_at\":\"2026-04-23 14:26:50\",\"id\":1}','2026-04-23 06:26:50'),(127,2,1,'voucher_series',NULL,'{\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"title\":\"Sample Voucher\",\"series_id\":\"69eb03f19f4b3\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"redeem_max\":\"50\",\"max_use\":\"1\",\"max_usable_voucher\":\"50\",\"business_account_id\":1,\"updated_at\":\"2026-04-24 13:47:29\",\"created_at\":\"2026-04-24 13:47:29\",\"id\":1}','2026-04-24 05:47:29'),(128,2,1,'voucher_series','{\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"title\":\"Sample Voucher\",\"series_id\":\"69eb03f19f4b3\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"redeem_max\":\"50\",\"max_use\":\"1\",\"max_usable_voucher\":\"50\",\"business_account_id\":1,\"updated_at\":\"2026-04-24T05:47:29.000000Z\",\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"id\":1}','{\"series_id\":\"1AUse-042026-1\"}','2026-04-24 05:47:29'),(129,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":null,\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":0,\"use_count\":null,\"max_usable_voucher\":\"50\",\"unique_redeem_count\":null,\"unique_use_count\":null,\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":1,\"is_name_mandatory\":\"1\",\"req_mobile\":1,\"is_mobile_mandatory\":\"1\",\"req_email\":1,\"is_email_mandatory\":\"1\",\"sms_template\":null,\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":1,\"status\":\"draft\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":null,\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:47:29.000000Z\",\"module\":\"default\"}','{\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"req_name\":0,\"req_mobile\":0,\"req_email\":0,\"sms_template\":\"\",\"notif_sms\":0,\"updated_at\":\"2026-04-24 13:47:41\"}','2026-04-24 05:47:41'),(130,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":0,\"use_count\":null,\"max_usable_voucher\":\"50\",\"unique_redeem_count\":null,\"unique_use_count\":null,\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"draft\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":null,\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:47:41.000000Z\",\"module\":\"default\"}','{\"redemption_method\":\"none\",\"updated_at\":\"2026-04-24 13:47:55\"}','2026-04-24 05:47:55'),(131,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":0,\"use_count\":null,\"max_usable_voucher\":\"50\",\"unique_redeem_count\":null,\"unique_use_count\":null,\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"draft\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:47:55.000000Z\",\"module\":\"default\"}','{\"status\":\"active\",\"updated_at\":\"2026-04-24 13:48:07\"}','2026-04-24 05:48:07'),(132,2,1,'exclusive_reward_redemptions',NULL,'{\"series_id\":\"1AUse-042026-1\",\"point_required\":\"0\",\"updated_at\":\"2026-04-24 13:48:41\",\"created_at\":\"2026-04-24 13:48:41\",\"id\":1}','2026-04-24 05:48:41'),(133,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":0,\"use_count\":null,\"max_usable_voucher\":\"50\",\"unique_redeem_count\":null,\"unique_use_count\":null,\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"active\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:48:07.000000Z\",\"module\":\"default\"}','{\"redeem_count\":1,\"unique_redeem_count\":1,\"updated_at\":\"2026-04-24 13:49:01\"}','2026-04-24 05:49:01'),(134,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":1,\"use_count\":null,\"max_usable_voucher\":\"50\",\"unique_redeem_count\":\"1\",\"unique_use_count\":null,\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"active\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:49:01.000000Z\",\"module\":\"default\"}','{\"use_count\":1,\"unique_use_count\":1,\"updated_at\":\"2026-04-24 13:54:03\"}','2026-04-24 05:54:03'),(135,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":1,\"use_count\":\"1\",\"max_usable_voucher\":\"50\",\"unique_redeem_count\":\"1\",\"unique_use_count\":\"1\",\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"active\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:54:03.000000Z\",\"module\":\"default\"}','{\"redeem_count\":2,\"use_count\":2,\"updated_at\":\"2026-04-24 13:54:10\"}','2026-04-24 05:54:10'),(136,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":2,\"use_count\":\"2\",\"max_usable_voucher\":\"50\",\"unique_redeem_count\":\"1\",\"unique_use_count\":\"1\",\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"active\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T05:54:10.000000Z\",\"module\":\"default\"}','{\"use_count\":3,\"unique_use_count\":2,\"updated_at\":\"2026-04-24 17:24:08\"}','2026-04-24 09:24:08'),(137,2,1,'voucher_series','{\"id\":1,\"business_account_id\":1,\"title\":\"Sample Voucher\",\"series_id\":\"1AUse-042026-1\",\"voucher_type\":\"promo_code\",\"promotion_type\":\"free-gift\",\"tc\":\"<p>Not applicable with other discount codes, promotions or offers. General terms and conditions apply.<\\/p>\",\"tc_link\":\"https:\\/\\/growthdesk.com\\/legal\\/privacy-policy\\/\",\"redeem_start\":\"2026-04-01 00:00:00\",\"redeem_end\":\"2026-05-31 23:59:00\",\"redeem_max\":50,\"redeem_count\":2,\"use_count\":\"3\",\"max_usable_voucher\":\"50\",\"unique_redeem_count\":\"1\",\"unique_use_count\":\"2\",\"use_by\":\"2026-07-23 23:59:00\",\"use_by_date_option\":\"custom\",\"use_by_date_days\":null,\"max_use\":\"1\",\"max_download_per_series_per_user\":1,\"allow_download_after_expired\":0,\"allow_download_after_used\":\"0\",\"merchant_promo_code\":null,\"req_name\":0,\"is_name_mandatory\":\"1\",\"req_mobile\":0,\"is_mobile_mandatory\":\"1\",\"req_email\":0,\"is_email_mandatory\":\"1\",\"sms_template\":\"\",\"notification_template_to_admin_id\":null,\"notification_template_to_user_id\":null,\"is_one_sms\":\"1\",\"notif_sms\":0,\"status\":\"active\",\"is_private\":0,\"remark\":null,\"image\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/file\\/images\\/petfest-indonesia-1776925690-608242036.jpg\",\"redemption_method\":\"none\",\"promotion_mechanic\":null,\"promotion_mechanic_value\":null,\"order\":0,\"is_downloadable\":0,\"is_pool\":0,\"created_at\":\"Fri, Apr 24, 2026 1:47 PM\",\"updated_at\":\"2026-04-24T09:24:08.000000Z\",\"module\":\"default\"}','{\"use_count\":4,\"unique_use_count\":3,\"updated_at\":\"2026-04-24 17:27:38\"}','2026-04-24 09:27:38'),(138,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":null,\"wa_bsuid\":\"PH.4534499620203017\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-04-16T00:11:41.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiOXlwU21zenZVSWZLNUtTeHArbXJadz09IiwibWFjIjoiMTk2MzYxZTVhMWEzMGI0YWMyZGVkZDk4MTBlYmExMWU5MjcyMjc4NTc5ZWIxNjRhMWZhZWM0YzNkYTdiN2UyNCJ9\",\"updated_at\":\"2026-04-30 10:15:03\"}','2026-04-30 02:15:03'),(139,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-02-10 16:33:14\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiRDYwTnRkbU9qbFFETTR5Qndnem40UT09IiwibWFjIjoiMDBkNjFjNWJmMWQ3MjdmZTk1NjIwNzczZjIyNDA0ODljMmQxOTBjNTM0ZjJkZWJlMGI2ODA5OGYzYTE1MGRkMSJ9\",\"mobile_country_code\":\"60\",\"wa_bsuid\":\"MY.4539361923050120\",\"password\":\"$2y$10$.osRiXvjFP8ieqYsNs72len6hMMn3afC\\/SeGsKexxkXxq\\/ru1bxnK\",\"referrer_code\":\"XV7M7222\",\"business_account_id\":1,\"updated_at\":\"2026-05-07 18:26:19\",\"created_at\":\"2026-05-07 18:26:19\",\"id\":10}','2026-05-07 10:26:19'),(140,2,1,'users','{\"id\":10,\"business_account_id\":1,\"name\":\"\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"60\",\"wa_username\":null,\"wa_bsuid\":\"MY.4539361923050120\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$.osRiXvjFP8ieqYsNs72len6hMMn3afC\\/SeGsKexxkXxq\\/ru1bxnK\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"XV7M7222\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-02-10T08:33:14.000000Z\",\"created_at\":\"2026-05-07T10:26:19.000000Z\",\"updated_at\":\"2026-05-07T10:26:19.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWUZEb1ZsVE1FQ2FDMzRpcEZ4OFFtZz09IiwibWFjIjoiMjFhZWQzZjYyNTNkMmNhYmZlYmY0NDVmYmY5MDgwMDJkNmQwNDgwOTgwNGI0ODZhZGNlOTAyMTRlMzVjNDlhYSJ9\",\"updated_at\":\"2026-05-07 18:26:31\"}','2026-05-07 10:26:31'),(141,2,1,'users','{\"id\":10,\"business_account_id\":1,\"name\":\"Jacytest\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"60\",\"wa_username\":null,\"wa_bsuid\":\"MY.4539361923050120\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$.osRiXvjFP8ieqYsNs72len6hMMn3afC\\/SeGsKexxkXxq\\/ru1bxnK\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"XV7M7222\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-02-10T08:33:14.000000Z\",\"created_at\":\"2026-05-07T10:26:19.000000Z\",\"updated_at\":\"2026-05-07T10:26:31.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiZVwvUHRKUTF2a2FHK1pNVWxiVmtyRUtiOFNPQkpJUDNmNktsc2s3dlFWb1k9IiwibWFjIjoiYmIxZmE1MGU1MmNmZjJmNzA3MWM3MTJkN2JmNWRkYzJmNjcxYTRiNjkxM2YxODY5OTBmNGFlMzRjNWI2NTY0MCJ9\",\"email_masked\":\"jac***@skale.today\",\"updated_at\":\"2026-05-07 18:26:45\"}','2026-05-07 10:26:45'),(142,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-05-08 17:05:43\",\"mobile\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiZHRHYUh2MzZxRmdFakRPRzlHOXYxUT09IiwibWFjIjoiODg0NWM4ZTc3OGY5NDljYzg0ZTA4ZDVkNjAyN2I0MWUxNWY3MTgxODM4NGY0YjYxMTE4Y2E3MDBhZDU2NzMzYiJ9\",\"mobile_country_code\":\"65\",\"wa_bsuid\":\"SG.4542509739402005\",\"password\":\"$2y$10$g93W7YeCv26QJMqIFOSLsejeEZzpb2DPg6RI.8jtaa8XjVORG5P0q\",\"referrer_code\":\"SOFS3CIZ\",\"business_account_id\":1,\"updated_at\":\"2026-05-08 17:05:57\",\"created_at\":\"2026-05-08 17:05:57\",\"id\":11}','2026-05-08 09:05:57'),(143,2,1,'users','{\"id\":11,\"business_account_id\":1,\"name\":\"\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"65\",\"wa_username\":null,\"wa_bsuid\":\"SG.4542509739402005\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$g93W7YeCv26QJMqIFOSLsejeEZzpb2DPg6RI.8jtaa8XjVORG5P0q\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"SOFS3CIZ\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-05-08T09:05:43.000000Z\",\"created_at\":\"2026-05-08T09:05:57.000000Z\",\"updated_at\":\"2026-05-08T09:05:57.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMFVHc2ZQSkhvWmNIQXB6WGVtSU9oUT09IiwibWFjIjoiY2Y1ZGExMjVjN2JhZDRkYmVlM2Y5OTc2NDdmODg5OGYxNmE2NGE1ODZhZDIzOTNjZDU3MDFlYzkyYWY4MGI0MiJ9\",\"updated_at\":\"2026-05-08 17:06:18\"}','2026-05-08 09:06:18'),(144,2,1,'users','{\"id\":11,\"business_account_id\":1,\"name\":\"Yuet whey siah\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":\"65\",\"wa_username\":null,\"wa_bsuid\":\"SG.4542509739402005\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$g93W7YeCv26QJMqIFOSLsejeEZzpb2DPg6RI.8jtaa8XjVORG5P0q\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"SOFS3CIZ\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-05-08T09:05:43.000000Z\",\"created_at\":\"2026-05-08T09:05:57.000000Z\",\"updated_at\":\"2026-05-08T09:06:18.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiTU5KZ3J6UUU1NmpTRGk0R21PNlpuY3lrWXdobjcwS0YzQlphcWtQUmI1cz0iLCJtYWMiOiJlNmM0M2ZlZTNlNjYwYzdiZjJmOTJjOWFhNjViMWY0M2JmZTBiNjA2ZWQzMzIwOWMxMjBiZDliYTBkNjhjZTIwIn0=\",\"email_masked\":\"yue***@growthdesk.com\",\"updated_at\":\"2026-05-08 17:06:43\"}','2026-05-08 09:06:43'),(145,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"Wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"PH.4534499620203017\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-04-30T02:15:03.000000Z\",\"google2fa_secret\":\"\"}','{\"wa_bsuid\":\"US.13491208655302741925\",\"updated_at\":\"2026-05-11 11:58:22\"}','2026-05-11 03:58:22'),(146,2,1,'users',NULL,'{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQ1FnaWQ3bzJcL21XRU9zTHpqZVhtMVE9PSIsIm1hYyI6IjBmN2RlODgzOTg0NTNkZjJlNTQzOGFiNTVhNjg4YjYwZGU3Yzg5MTZlNDhjMGMwNTY0YjI1YTg4ZTE5NGVlNDQifQ==\",\"email_masked\":\"\",\"register_at\":\"2026-05-11 23:04:28\",\"wa_username\":\"@testuser_nophone4\",\"wa_bsuid\":\"US.13491208655302741927\",\"password\":\"$2y$10$7Iio85mJJM8eN\\/K2sqUOFe1f9ehHWvgwf815Uai1YBlXZK7Z4yq.6\",\"referrer_code\":\"AW27BBSD\",\"business_account_id\":1,\"updated_at\":\"2026-05-12 08:47:08\",\"created_at\":\"2026-05-12 08:47:08\",\"id\":12}','2026-05-12 00:47:08'),(147,2,1,'users','{\"id\":12,\"business_account_id\":1,\"name\":\"\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":null,\"wa_username\":\"@testuser_nophone4\",\"wa_bsuid\":\"US.13491208655302741927\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$7Iio85mJJM8eN\\/K2sqUOFe1f9ehHWvgwf815Uai1YBlXZK7Z4yq.6\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"AW27BBSD\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-05-11T15:04:28.000000Z\",\"created_at\":\"2026-05-12T00:47:08.000000Z\",\"updated_at\":\"2026-05-12T00:47:08.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiNTJGbE9seDFuSzgyWkQyeFIzUDY0QT09IiwibWFjIjoiNmFhMGUxYzJjYWY0YTVhYTU0ODY5MzlkZjI2ZGY2MTU2MzIwNTJiNjc4OGUyNTI5OTlmZDRlZGRlZDE2OGJmYyJ9\",\"updated_at\":\"2026-05-12 08:47:51\"}','2026-05-12 00:47:51'),(148,2,1,'users','{\"id\":12,\"business_account_id\":1,\"name\":\"Yuet Whey Siah\",\"last_name\":false,\"email\":\"\",\"email_masked\":\"\",\"mobile\":false,\"mobile_country_code\":null,\"wa_username\":\"@testuser_nophone4\",\"wa_bsuid\":\"US.13491208655302741927\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$7Iio85mJJM8eN\\/K2sqUOFe1f9ehHWvgwf815Uai1YBlXZK7Z4yq.6\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"AW27BBSD\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-05-11T15:04:28.000000Z\",\"created_at\":\"2026-05-12T00:47:08.000000Z\",\"updated_at\":\"2026-05-12T00:47:51.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiaGRFOFc2XC9QK0NJK0NnMkNEUDRYYTZDSjRFVEllTU13Tk1nTklqdXZyZUE9IiwibWFjIjoiMzc4ZDJmMWEzYzhhMDg2YWFmNjA0NGEyZDM2ZDc0YTc4Y2QyZDZjNTc0MWM1ZGJiYWVlOTI3NWYyZWNlOTM1YSJ9\",\"email_masked\":\"yue***@gmail.com\",\"updated_at\":\"2026-05-12 08:49:46\"}','2026-05-12 00:49:46'),(149,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"Wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-11T03:58:22.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWmlyRTVDOFZia2tHQ3p6OGFia21jUT09IiwibWFjIjoiZTlmOGE0N2MzOTExNzQzMWU0M2YxYWY5YWU5ZWQ5ODg2MmIxZGIxZTc3NDk3Yzk2OTRjY2U3NjI0OTMxNzQ2OCJ9\",\"updated_at\":\"2026-05-12 11:01:36\"}','2026-05-12 03:01:36'),(150,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-12T03:01:36.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiOXlwU21zenZVSWZLNUtTeHArbXJadz09IiwibWFjIjoiMTk2MzYxZTVhMWEzMGI0YWMyZGVkZDk4MTBlYmExMWU5MjcyMjc4NTc5ZWIxNjRhMWZhZWM0YzNkYTdiN2UyNCJ9\",\"updated_at\":\"2026-05-12 11:04:12\"}','2026-05-12 03:04:12'),(151,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"Wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-12T03:04:12.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWmlyRTVDOFZia2tHQ3p6OGFia21jUT09IiwibWFjIjoiZTlmOGE0N2MzOTExNzQzMWU0M2YxYWY5YWU5ZWQ5ODg2MmIxZGIxZTc3NDk3Yzk2OTRjY2U3NjI0OTMxNzQ2OCJ9\",\"updated_at\":\"2026-05-12 11:07:16\"}','2026-05-12 03:07:16'),(152,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-12T03:07:16.000000Z\",\"google2fa_secret\":\"\"}','{\"name\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiOXlwU21zenZVSWZLNUtTeHArbXJadz09IiwibWFjIjoiMTk2MzYxZTVhMWEzMGI0YWMyZGVkZDk4MTBlYmExMWU5MjcyMjc4NTc5ZWIxNjRhMWZhZWM0YzNkYTdiN2UyNCJ9\",\"updated_at\":\"2026-05-12 11:39:38\"}','2026-05-12 03:39:38'),(153,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":34,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 11:42:09\",\"created_at\":\"2026-05-12 11:42:09\",\"id\":1}','2026-05-12 03:42:09'),(154,1,1,'approvals','{\"id\":1,\"module\":\"daily_challenge\",\"module_identifier\":\"34\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T03:42:09.000000Z\",\"updated_at\":\"2026-05-12T03:42:09.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 11:43:46\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 11:43:46\"}','2026-05-12 03:43:46'),(155,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":35,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 11:44:37\",\"created_at\":\"2026-05-12 11:44:37\",\"id\":2}','2026-05-12 03:44:37'),(156,1,1,'approvals','{\"id\":1,\"module\":\"daily_challenge\",\"module_identifier\":\"34\",\"reviewed_by\":\"1\",\"reviewed_at\":\"2026-05-12 11:43:46\",\"status\":\"approved\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T03:42:09.000000Z\",\"updated_at\":\"2026-05-12T03:43:46.000000Z\"}','{\"reviewed_at\":\"2026-05-12 12:03:04\",\"updated_at\":\"2026-05-12 12:03:04\"}','2026-05-12 04:03:04'),(157,1,1,'approvals','{\"id\":2,\"module\":\"daily_challenge\",\"module_identifier\":\"35\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T03:44:37.000000Z\",\"updated_at\":\"2026-05-12T03:44:37.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 12:06:28\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 12:06:28\"}','2026-05-12 04:06:28'),(158,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":36,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 12:10:01\",\"created_at\":\"2026-05-12 12:10:01\",\"id\":3}','2026-05-12 04:10:01'),(159,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":37,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 12:10:18\",\"created_at\":\"2026-05-12 12:10:18\",\"id\":4}','2026-05-12 04:10:18'),(160,1,1,'approvals','{\"id\":3,\"module\":\"daily_challenge\",\"module_identifier\":\"36\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T04:10:01.000000Z\",\"updated_at\":\"2026-05-12T04:10:01.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 12:23:04\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 12:23:04\"}','2026-05-12 04:23:04'),(161,1,1,'approvals','{\"id\":3,\"module\":\"daily_challenge\",\"module_identifier\":\"36\",\"reviewed_by\":\"1\",\"reviewed_at\":\"2026-05-12 12:23:04\",\"status\":\"approved\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T04:10:01.000000Z\",\"updated_at\":\"2026-05-12T04:23:04.000000Z\"}','{\"reviewed_at\":\"2026-05-12 13:15:34\",\"updated_at\":\"2026-05-12 13:15:34\"}','2026-05-12 05:15:34'),(162,1,1,'approvals','{\"id\":4,\"module\":\"daily_challenge\",\"module_identifier\":\"37\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T04:10:18.000000Z\",\"updated_at\":\"2026-05-12T04:10:18.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 13:15:53\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 13:15:53\"}','2026-05-12 05:15:53'),(163,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":38,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 13:22:32\",\"created_at\":\"2026-05-12 13:22:32\",\"id\":5}','2026-05-12 05:22:32'),(164,1,1,'approvals','{\"id\":5,\"module\":\"daily_challenge\",\"module_identifier\":\"38\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T05:22:32.000000Z\",\"updated_at\":\"2026-05-12T05:22:32.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 13:31:46\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 13:31:46\"}','2026-05-12 05:31:46'),(165,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":39,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 13:46:47\",\"created_at\":\"2026-05-12 13:46:47\",\"id\":6}','2026-05-12 05:46:47'),(166,1,1,'approvals','{\"id\":6,\"module\":\"daily_challenge\",\"module_identifier\":\"39\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T05:46:47.000000Z\",\"updated_at\":\"2026-05-12T05:46:47.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 13:47:24\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 13:47:24\"}','2026-05-12 05:47:24'),(167,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":40,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 13:49:57\",\"created_at\":\"2026-05-12 13:49:57\",\"id\":7}','2026-05-12 05:49:57'),(168,1,1,'approvals','{\"id\":7,\"module\":\"daily_challenge\",\"module_identifier\":\"40\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T05:49:57.000000Z\",\"updated_at\":\"2026-05-12T05:49:57.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 13:50:13\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 13:50:13\"}','2026-05-12 05:50:13'),(169,NULL,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"Wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":0,\"user_verified_timestamp\":null,\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-12T03:39:38.000000Z\",\"google2fa_secret\":\"\"}','{\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-05-12T05:50:16.225420Z\",\"updated_at\":\"2026-05-12 13:50:16\"}','2026-05-12 05:50:16'),(170,2,1,'users','{\"id\":8,\"business_account_id\":1,\"name\":\"Wilson\",\"last_name\":false,\"email\":\"wilson@sample.com\",\"email_masked\":\"wil***@sample.com\",\"mobile\":false,\"mobile_country_code\":\"63\",\"wa_username\":\"@wilson_nophone\",\"wa_bsuid\":\"US.13491208655302741925\",\"user_twofa\":null,\"mobile_verified\":1,\"user_verified_timestamp\":\"2026-05-12 13:50:16\",\"user_membership_id\":null,\"membership_synced_date\":null,\"is_membership_auto_sync_mode\":null,\"user_avatar\":null,\"dob\":null,\"birth_month\":null,\"birth_year\":null,\"business_asset_id\":null,\"email_verified_at\":null,\"password\":\"$2y$10$Gb27\\/BG01i5JpbIDvLJ1GuFd00PGXksMGrQdHH921bPMoQAOUS57G\",\"api_token\":null,\"password_changed_at\":null,\"remember_token\":null,\"referrer_code\":\"HQUE1BSC\",\"reg_code\":null,\"reg_order\":null,\"register_at\":\"2026-04-16T00:11:19.000000Z\",\"created_at\":\"2026-04-16T00:11:27.000000Z\",\"updated_at\":\"2026-05-12T05:50:16.000000Z\",\"google2fa_secret\":\"\"}','{\"email\":\"eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoibEN0eDBOTWozcXZUOE9YV0c2Y2VJdVN2ak0wVXdRVUNMVGhDYWdXVm1Lbz0iLCJtYWMiOiI5YmIxMDFlOWI5MDAxZDNmZTVkNDA3YjBkYjczZGRhN2YyMzJlMjg2OWJmNmI2YzU4Y2E3NjViMzJlNDc3NjFmIn0=\",\"email_masked\":\"wil***@growthdesk.com\",\"updated_at\":\"2026-05-12 16:20:52\"}','2026-05-12 08:20:52'),(171,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":41,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 16:23:01\",\"created_at\":\"2026-05-12 16:23:01\",\"id\":8}','2026-05-12 08:23:01'),(172,1,1,'approvals','{\"id\":8,\"module\":\"daily_challenge\",\"module_identifier\":\"41\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T08:23:01.000000Z\",\"updated_at\":\"2026-05-12T08:23:01.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 16:23:17\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 16:23:17\"}','2026-05-12 08:23:17'),(173,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":46,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-12 16:26:53\",\"created_at\":\"2026-05-12 16:26:53\",\"id\":9}','2026-05-12 08:26:53'),(174,1,1,'approvals','{\"id\":9,\"module\":\"daily_challenge\",\"module_identifier\":\"46\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T08:26:53.000000Z\",\"updated_at\":\"2026-05-12T08:26:53.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-12 16:29:55\",\"status\":\"approved\",\"updated_at\":\"2026-05-12 16:29:55\"}','2026-05-12 08:29:55'),(175,1,1,'approvals','{\"id\":9,\"module\":\"daily_challenge\",\"module_identifier\":\"46\",\"reviewed_by\":\"1\",\"reviewed_at\":\"2026-05-12 16:29:55\",\"status\":\"approved\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-12T08:26:53.000000Z\",\"updated_at\":\"2026-05-12T08:29:55.000000Z\"}','{\"reviewed_at\":\"2026-05-12 16:36:44\",\"updated_at\":\"2026-05-12 16:36:44\"}','2026-05-12 08:36:44'),(176,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":48,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-13 12:25:41\",\"created_at\":\"2026-05-13 12:25:41\",\"id\":10}','2026-05-13 04:25:41'),(177,1,1,'env_configs','{\"CAMPAIGN_NAME\":\"WA Username Test Campaign\",\"CAMPAIGN_SHORT_NAME\":\"\",\"CAMPAIGN_DESCRIPTION\":\"\",\"CAMPAIGN_KEYWORDS\":\"\",\"IS_PRE_CAMPAIGN_GAME\":\"\",\"CAMPAIGN_START_MSG\":\"\",\"CAMPAIGN_END_MSG\":\"\",\"CAMPAIGN_REDEEM_END_MSG\":\"\",\"CLIENT_TERMS_LINK\":\"\",\"CLIENT_PRIVACY_LINK\":\"\",\"THEME_COLOR\":\"#410505\",\"TEXT_COLOR_DEFAULT\":\"#FFFFFF\",\"LOGO_WHITE_DEFAULT\":\"\",\"MASTHEAD_DEFAULT\":\"\",\"MASTHEAD_DEFAULT_POPUP\":\"\",\"BACKGROUND_IMG_DEFAULT\":\"\",\"BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BACKGROUND_IMG_POPUP_DEFAULT\":\"\",\"BACKGROUND_COLOR_POPUP_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BTN_FONT_COLOR_DEFAULT\":\"#3A3C6E\",\"BTN_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(90deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_FONT_COLOR_DEFAULT\":\"#323747\",\"CLIENT_CONTACT_US_EMAIL\":\"hello@skale.today\",\"CLIENT_FACEBOOK\":\"\",\"CLIENT_INSTAGRAM\":\"\",\"CLIENT_LINKEDIN\":\"\",\"CAMPAIGN_LICENSING_NO\":\"\",\"SOCIAL_SHARE_IMG_DEFAULT\":\"\",\"PWA_FAVICON\":\"\",\"PWA_FAVICON_16\":\"\",\"PWA_FAVICON_32\":\"\",\"PWA_FAVICON_96\":\"\",\"PWA_FAVICON_192\":\"\",\"PWA_FAVICON_256\":\"\",\"PWA_FAVICON_384\":\"\",\"PWA_FAVICON_512\":\"\",\"REG_EMAIL_MANDATORY\":\"true\",\"REG_ENABLE_DOB\":\"false\",\"REG_ENABLE_YEAR\":\"\",\"REG_ENABLE_ADDRESS\":\"\",\"REG_ENABLE_ADDRESS_STATE\":\"\",\"SRR_HAS_REQUIRE_MERCHANTS\":\"\",\"SRR_HAS_REQUIRE_TRANSACTION_AMOUNT\":\"\",\"CHALLENGE_APPROVE_TITLE\":\"\",\"CHALLENGE_APPROVE_SUBTITLE\":\"\",\"CHALLENGE_PENDING_TITLE\":\"\",\"CHALLENGE_PENDING_SUBTITLE\":\"\",\"CHALLENGE_SHORTCUT_SUBTITLE\":\"\",\"REFERRAL_INSTRUCTION\":\"Both you and your friend will get 1 points when they sign up through your link & upload their first receipt\",\"SOCIAL_SHARE_MSG\":\"Did you hear about :client_name\'s Platform? Join with my link below and you will immediately get :referrer_point free points right away. Start here: {referrer_link}\",\"REFERRAL_REWARD_LIMIT\":\"\",\"RIDDLE_LOSE\":\"\",\"RIDDLE_QNS_PER_DAY\":\"\",\"RIDDLE_QNS_RANDOMIZE\":\"\",\"FACEBOOK_PIXEL_ID\":\"\",\"GTM_CONTAINER_ID\":\"\",\"SKALE_PIXEL_ID\":\"\",\"TIKTOK_PIXEL_ID\":\"\",\"OTHER_ID\":\"\",\"DEFAULT_START_DATE\":\"2026-05-07\",\"DEFAULT_REDEEM_START_DATE\":\"2026-05-07\",\"DEFAULT_END_DATE\":\"2027-05-07\",\"DEFAULT_REDEEM_END_DATE\":\"2027-05-07\",\"business_account_id\":1}','{\"APP_URL\":\"http:\\/\\/wa-username-testing.growthdesk.dev\",\"APP_BASE_DOMAIN\":\"http:\\/\\/wa-username-testing.growthdesk.dev\"}','2026-05-13 05:37:07'),(178,1,1,'env_configs','{\"CAMPAIGN_NAME\":\"WA Username Test Campaign\",\"CAMPAIGN_SHORT_NAME\":\"\",\"CAMPAIGN_DESCRIPTION\":\"\",\"CAMPAIGN_KEYWORDS\":\"\",\"IS_PRE_CAMPAIGN_GAME\":\"\",\"CAMPAIGN_START_MSG\":\"\",\"CAMPAIGN_END_MSG\":\"\",\"CAMPAIGN_REDEEM_END_MSG\":\"\",\"CLIENT_TERMS_LINK\":\"\",\"CLIENT_PRIVACY_LINK\":\"\",\"THEME_COLOR\":\"#410505\",\"TEXT_COLOR_DEFAULT\":\"#FFFFFF\",\"LOGO_WHITE_DEFAULT\":\"\",\"MASTHEAD_DEFAULT\":\"\",\"MASTHEAD_DEFAULT_POPUP\":\"\",\"BACKGROUND_IMG_DEFAULT\":\"\",\"BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BACKGROUND_IMG_POPUP_DEFAULT\":\"\",\"BACKGROUND_COLOR_POPUP_DEFAULT\":\"linear-gradient(0deg, rgba(95, 59, 255, 1) 0%, rgba(0, 145, 255, 1) 100%)\",\"BTN_FONT_COLOR_DEFAULT\":\"#3A3C6E\",\"BTN_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(0deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_BACKGROUND_COLOR_DEFAULT\":\"linear-gradient(90deg, rgba(255, 191, 0, 1) 0%, rgba(255, 218, 65, 1) 100%)\",\"FOOTER_FONT_COLOR_DEFAULT\":\"#323747\",\"CLIENT_CONTACT_US_EMAIL\":\"hello@skale.today\",\"CLIENT_FACEBOOK\":\"\",\"CLIENT_INSTAGRAM\":\"\",\"CLIENT_LINKEDIN\":\"\",\"CAMPAIGN_LICENSING_NO\":\"\",\"SOCIAL_SHARE_IMG_DEFAULT\":\"\",\"PWA_FAVICON\":\"\",\"PWA_FAVICON_16\":\"\",\"PWA_FAVICON_32\":\"\",\"PWA_FAVICON_96\":\"\",\"PWA_FAVICON_192\":\"\",\"PWA_FAVICON_256\":\"\",\"PWA_FAVICON_384\":\"\",\"PWA_FAVICON_512\":\"\",\"REG_EMAIL_MANDATORY\":\"true\",\"REG_ENABLE_DOB\":\"false\",\"REG_ENABLE_YEAR\":\"\",\"REG_ENABLE_ADDRESS\":\"\",\"REG_ENABLE_ADDRESS_STATE\":\"\",\"SRR_HAS_REQUIRE_MERCHANTS\":\"\",\"SRR_HAS_REQUIRE_TRANSACTION_AMOUNT\":\"\",\"CHALLENGE_APPROVE_TITLE\":\"\",\"CHALLENGE_APPROVE_SUBTITLE\":\"\",\"CHALLENGE_PENDING_TITLE\":\"\",\"CHALLENGE_PENDING_SUBTITLE\":\"\",\"CHALLENGE_SHORTCUT_SUBTITLE\":\"\",\"REFERRAL_INSTRUCTION\":\"Both you and your friend will get 1 points when they sign up through your link & upload their first receipt\",\"SOCIAL_SHARE_MSG\":\"Did you hear about :client_name\'s Platform? Join with my link below and you will immediately get :referrer_point free points right away. Start here: {referrer_link}\",\"REFERRAL_REWARD_LIMIT\":\"\",\"RIDDLE_LOSE\":\"\",\"RIDDLE_QNS_PER_DAY\":\"\",\"RIDDLE_QNS_RANDOMIZE\":\"\",\"FACEBOOK_PIXEL_ID\":\"\",\"GTM_CONTAINER_ID\":\"\",\"SKALE_PIXEL_ID\":\"\",\"TIKTOK_PIXEL_ID\":\"\",\"OTHER_ID\":\"\",\"DEFAULT_START_DATE\":\"2026-05-07\",\"DEFAULT_REDEEM_START_DATE\":\"2026-05-07\",\"DEFAULT_END_DATE\":\"2027-05-07\",\"DEFAULT_REDEEM_END_DATE\":\"2027-05-07\",\"APP_URL\":\"http:\\/\\/wa-username-testing.growthdesk.dev\",\"APP_BASE_DOMAIN\":\"http:\\/\\/wa-username-testing.growthdesk.dev\",\"business_account_id\":1}','{\"LOGIN_METHOD\":\"default\"}','2026-05-13 05:37:08'),(179,1,1,'sys_settings','{\"id\":10,\"business_account_id\":1,\"type\":\"basic_chance\",\"settings\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":\\\"1\\\"}\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"settings\":\"{\\\"daily_limit\\\":1,\\\"qty\\\":\\\"\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(180,1,1,'daily_challenges','{\"id\":8,\"business_account_id\":1,\"slug\":\"spinandwin\",\"name\":\"Spin And Win\",\"short_name\":null,\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":null,\"setting_details\":\"{\\\"win_title\\\":\\\"Congratulations\\\",\\\"win_subtitle\\\":\\\"You have won\\\",\\\"lose_title\\\":\\\"Oh No!\\\",\\\"lose_subtitle\\\":\\\"Please try again\\\"}\",\"day_week_settings\":null,\"order\":null,\"is_active\":0,\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-04-07T06:36:25.000000Z\"}','{\"is_active\":1,\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(181,1,1,'daily_challenges','{\"id\":8,\"business_account_id\":1,\"slug\":\"spinandwin\",\"name\":\"Spin And Win\",\"short_name\":null,\"description\":null,\"img_landing_path\":null,\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":null,\"setting_details\":{\"win_title\":\"Congratulations\",\"win_subtitle\":\"You have won\",\"lose_title\":\"Oh No!\",\"lose_subtitle\":\"Please try again\"},\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-05-13T05:37:29.000000Z\"}','{\"setting_details\":\"{\\\"win_title\\\":\\\"Congratulations\\\",\\\"win_subtitle\\\":\\\"You have won\\\",\\\"lose_title\\\":\\\"Oh No!\\\",\\\"lose_subtitle\\\":\\\"Please try again\\\"}\"}','2026-05-13 05:37:29'),(182,1,1,'sys_settings','{\"id\":4,\"business_account_id\":1,\"type\":\"daily_checkin\",\"settings\":\"{\\\"is_active\\\":\\\"1\\\",\\\"type\\\":\\\"points\\\",\\\"qty\\\":\\\"10\\\",\\\"auto\\\":\\\"0\\\"}\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"settings\":\"{\\\"is_active\\\":\\\"1\\\",\\\"auto\\\":\\\"0\\\",\\\"qty\\\":\\\"10\\\",\\\"type\\\":\\\"points\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(183,1,1,'daily_challenges','{\"id\":3,\"business_account_id\":1,\"slug\":\"offline_eng\",\"name\":\"ScanQR Code In-Store\",\"short_name\":null,\"description\":\"Spend In-Store and Unlock an Additional Attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Scan_QR-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":1}\",\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":\\\"0\\\",\\\"qr_code\\\":\\\"0\\\",\\\"6_digit_pin\\\":\\\"0\\\",\\\"store_types_auto_include\\\":\\\"0\\\"}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(184,1,1,'daily_challenges','{\"id\":3,\"business_account_id\":1,\"slug\":\"offline_eng\",\"name\":\"ScanQR Code In-Store\",\"short_name\":null,\"description\":\"Spend In-Store and Unlock an Additional Attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Scan_QR-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]},\"setting_details\":{\"shortcut\":\"0\",\"daily_limit\":\"0\",\"qr_code\":\"0\",\"6_digit_pin\":\"0\",\"store_types_auto_include\":\"0\"},\"day_week_settings\":null,\"order\":null,\"is_active\":\"1\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-05-13T05:37:29.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":\\\"0\\\",\\\"qr_code\\\":\\\"0\\\",\\\"6_digit_pin\\\":\\\"0\\\",\\\"store_types_auto_include\\\":\\\"0\\\"}\"}','2026-05-13 05:37:29'),(185,1,1,'daily_challenges','{\"id\":4,\"business_account_id\":1,\"slug\":\"social_follow\",\"name\":\"Join our Social Media\",\"short_name\":null,\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Follow_Social_Media-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"lifetime_limit\\\":null,\\\"auto_approve\\\":\\\"1\\\",\\\"url\\\":{\\\"facebook\\\":null,\\\"instagram\\\":null,\\\"tiktok\\\":null},\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(186,1,1,'daily_challenges','{\"id\":4,\"business_account_id\":1,\"slug\":\"social_follow\",\"name\":\"Join our Social Media\",\"short_name\":null,\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Follow_Social_Media-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]},\"setting_details\":{\"shortcut\":\"0\",\"lifetime_limit\":null,\"auto_approve\":\"1\",\"url\":{\"facebook\":null,\"instagram\":null,\"tiktok\":null},\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}},\"day_week_settings\":null,\"order\":null,\"is_active\":\"1\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-05-13T05:37:29.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"lifetime_limit\\\":null,\\\"auto_approve\\\":\\\"1\\\",\\\"url\\\":{\\\"facebook\\\":null,\\\"instagram\\\":null,\\\"tiktok\\\":null},\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\"}','2026-05-13 05:37:29'),(187,1,1,'daily_challenges','{\"id\":5,\"business_account_id\":1,\"slug\":\"app_install\",\"name\":\"Install App\",\"short_name\":null,\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Install_App-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-04-07T06:36:25.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"lifetime_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"url\\\":{\\\"play\\\":null,\\\"ios\\\":null,\\\"huawei\\\":null},\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:29'),(188,1,1,'daily_challenges','{\"id\":5,\"business_account_id\":1,\"slug\":\"app_install\",\"name\":\"Install App\",\"short_name\":null,\"description\":null,\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Install_App-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]},\"setting_details\":{\"shortcut\":\"0\",\"lifetime_limit\":null,\"auto_approve\":\"0\",\"url\":{\"play\":null,\"ios\":null,\"huawei\":null},\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}},\"day_week_settings\":null,\"order\":null,\"is_active\":\"1\",\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-05-13T05:37:29.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"lifetime_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"url\\\":{\\\"play\\\":null,\\\"ios\\\":null,\\\"huawei\\\":null},\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\"}','2026-05-13 05:37:29'),(189,1,1,'daily_challenges','{\"id\":6,\"business_account_id\":1,\"slug\":\"upload_receipt\",\"name\":\"Upload Receipt\",\"short_name\":null,\"description\":\"Upload receipt of your purchase to unlock additional attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Upload_Receipt-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":\"2026-12-31 10:29:54\",\"reward_details\":{\"type\":\"chance\",\"qty\":1},\"setting_details\":{\"shortcut\":1},\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-04-07T06:36:25.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"reward_on_submit\\\":\\\"0\\\",\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\",\"updated_at\":\"2026-05-13 13:37:29\"}','2026-05-13 05:37:30'),(190,1,1,'daily_challenges','{\"id\":6,\"business_account_id\":1,\"slug\":\"upload_receipt\",\"name\":\"Upload Receipt\",\"short_name\":null,\"description\":\"Upload receipt of your purchase to unlock additional attempt\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Upload_Receipt-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":\"2026-12-31 10:29:54\",\"reward_details\":{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]},\"setting_details\":{\"shortcut\":\"0\",\"daily_limit\":null,\"auto_approve\":\"0\",\"reward_on_submit\":\"0\",\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}},\"day_week_settings\":null,\"order\":null,\"is_active\":\"1\",\"created_at\":\"2026-04-07T06:36:25.000000Z\",\"updated_at\":\"2026-05-13T05:37:29.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"reward_on_submit\\\":\\\"0\\\",\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\",\"updated_at\":\"2026-05-13 13:37:30\"}','2026-05-13 05:37:30'),(191,1,1,'daily_challenges','{\"id\":2,\"business_account_id\":1,\"slug\":\"take_a_picture\",\"name\":\"Take a Picture\",\"short_name\":null,\"description\":\"To learn more, please head to the nearest customer service counter.\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Snap_Photo-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":\"{\\\"type\\\":\\\"chance\\\",\\\"qty\\\":1}\",\"setting_details\":\"{\\\"shortcut\\\":0}\",\"day_week_settings\":null,\"order\":null,\"is_active\":1,\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"reward_on_submit\\\":\\\"0\\\",\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\",\"updated_at\":\"2026-05-13 13:37:30\"}','2026-05-13 05:37:30'),(192,1,1,'daily_challenges','{\"id\":2,\"business_account_id\":1,\"slug\":\"take_a_picture\",\"name\":\"Take a Picture\",\"short_name\":null,\"description\":\"To learn more, please head to the nearest customer service counter.\",\"img_landing_path\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/assets\\/images\\/daily_challenges\\/Challenge_images_Snap_Photo-min.png\",\"date_from\":\"2026-04-07 14:36:24\",\"date_to\":null,\"reward_details\":{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]},\"setting_details\":{\"shortcut\":\"0\",\"daily_limit\":null,\"auto_approve\":\"0\",\"reward_on_submit\":\"0\",\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}},\"day_week_settings\":null,\"order\":null,\"is_active\":\"1\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-05-13T05:37:30.000000Z\"}','{\"reward_details\":\"{\\\"qty\\\":\\\"1\\\",\\\"type\\\":\\\"chance\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"setting_details\":\"{\\\"shortcut\\\":\\\"0\\\",\\\"daily_limit\\\":null,\\\"auto_approve\\\":\\\"0\\\",\\\"reward_on_submit\\\":\\\"0\\\",\\\"examples\\\":[{\\\"name\\\":null},{\\\"name\\\":null},{\\\"name\\\":null}],\\\"messages\\\":{\\\"success\\\":{\\\"title\\\":null,\\\"subtitle\\\":null},\\\"error\\\":{\\\"title\\\":null,\\\"subtitle\\\":null}}}\"}','2026-05-13 05:37:30'),(193,1,1,'sys_settings','{\"id\":1,\"business_account_id\":1,\"type\":\"referrer_token\",\"settings\":\"15\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"settings\":\"{\\\"qty\\\":\\\"15\\\",\\\"type\\\":\\\"points\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"updated_at\":\"2026-05-13 13:37:30\"}','2026-05-13 05:37:30'),(194,1,1,'sys_settings','{\"id\":2,\"business_account_id\":1,\"type\":\"referee_token\",\"settings\":\"15\",\"created_at\":\"2026-04-07T06:36:24.000000Z\",\"updated_at\":\"2026-04-07T06:36:24.000000Z\"}','{\"settings\":\"{\\\"qty\\\":\\\"15\\\",\\\"type\\\":\\\"points\\\",\\\"additional\\\":[],\\\"caches\\\":[]}\",\"updated_at\":\"2026-05-13 13:37:30\"}','2026-05-13 05:37:30'),(195,1,1,'approvals','{\"id\":10,\"module\":\"daily_challenge\",\"module_identifier\":\"48\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-13T04:25:41.000000Z\",\"updated_at\":\"2026-05-13T04:25:41.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-13 13:54:44\",\"status\":\"approved\",\"updated_at\":\"2026-05-13 13:54:44\"}','2026-05-13 05:54:44'),(196,2,1,'approvals',NULL,'{\"module\":\"daily_challenge\",\"module_identifier\":50,\"ocr_appv_status\":\"scheduling\",\"updated_at\":\"2026-05-13 17:08:38\",\"created_at\":\"2026-05-13 17:08:38\",\"id\":11}','2026-05-13 09:08:38'),(197,1,1,'approvals','{\"id\":11,\"module\":\"daily_challenge\",\"module_identifier\":\"50\",\"reviewed_by\":null,\"reviewed_at\":null,\"status\":\"pending\",\"status_reason\":null,\"ocr_appv_status\":\"scheduling\",\"created_at\":\"2026-05-13T09:08:38.000000Z\",\"updated_at\":\"2026-05-13T09:08:38.000000Z\"}','{\"reviewed_by\":1,\"reviewed_at\":\"2026-05-13 17:09:23\",\"status\":\"approved\",\"updated_at\":\"2026-05-13 17:09:23\"}','2026-05-13 09:09:23');

--
-- Table structure for table `banner_settings`
--

CREATE TABLE `banner_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `position` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `desktop_image_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipad_image_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_image_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_datetime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_datetime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banner_settings_business_account_id_status(6)_index` (`business_account_id`,`status`(6))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banner_settings`
--


--
-- Table structure for table `billing_period_logs`
--

CREATE TABLE `billing_period_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `log_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_from` date NOT NULL,
  `date_to` date NOT NULL,
  `module` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billing_period_logs_business_account_id_date_from_index` (`business_account_id`,`date_from`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `billing_period_logs`
--


--
-- Table structure for table `blast_recipients`
--

CREATE TABLE `blast_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `blast_id` bigint unsigned NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `attempts` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `blast_recipients_blast_id_index` (`blast_id`),
  KEY `blast_recipients_type(3)_user_id(6)_index` (`type`(3),`user_id`(6))
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blast_recipients`
--

INSERT INTO `blast_recipients` VALUES (1,2,'2','6363','sms','Hey EJ,\nYou have new rewards waiting for you here https://wa-username-testing.growthdesk.dev/uid/Q07PTTAI04/my','{\"error\":\"-1008 = MISSING PARAMETER\"}','2026-04-30 05:29:02','2026-04-30 05:29:02',0),(2,3,'2','6363','whatsapp','','attempting','2026-04-30 05:35:59','2026-04-30 05:35:59',0),(3,3,'8','6363','whatsapp','','attempting','2026-04-30 05:35:59','2026-04-30 05:35:59',0),(4,4,'2','6363','whatsapp','','attempting','2026-04-30 06:52:53','2026-04-30 06:52:53',0),(5,4,'8','6363','whatsapp','','attempting','2026-04-30 06:52:53','2026-04-30 06:52:53',0),(6,5,'2','6363','whatsapp','','attempting','2026-04-30 07:03:55','2026-04-30 07:03:55',0),(7,5,'8','6363','whatsapp','','attempting','2026-04-30 07:03:55','2026-04-30 07:03:55',0),(8,6,'2','tes************e3','whatsapp','','attempting','2026-04-30 07:08:52','2026-04-30 07:08:52',0),(9,6,'8','wil*********ne','whatsapp','','attempting','2026-04-30 07:08:52','2026-04-30 07:08:52',0),(10,6,'2','tes************e3','whatsapp','','attempting','2026-04-30 07:29:21','2026-04-30 07:29:21',0),(11,6,'8','wil*********ne','whatsapp','','attempting','2026-04-30 07:29:21','2026-04-30 07:29:21',0),(12,6,'2','tes************e3','whatsapp','','attempting','2026-04-30 07:30:05','2026-04-30 07:30:05',0),(13,6,'8','wil*********ne','whatsapp','','attempting','2026-04-30 07:30:05','2026-04-30 07:30:05',0),(14,6,'2','@te*************e3','whatsapp','','attempting','2026-04-30 10:16:52','2026-04-30 10:16:52',0),(15,6,'8','@wi**********ne','whatsapp','','attempting','2026-04-30 10:16:52','2026-04-30 10:16:52',0),(16,6,'2','@te*************e3','whatsapp','','attempting','2026-04-30 10:17:11','2026-04-30 10:17:11',0),(17,6,'8','@wi**********ne','whatsapp','','attempting','2026-04-30 10:17:11','2026-04-30 10:17:11',0),(18,8,'8','@wi**********ne','whatsapp','','attempting','2026-05-12 06:08:05','2026-05-12 06:08:05',0),(19,9,'12','@te*************e4','whatsapp','','attempting','2026-05-12 06:32:37','2026-05-12 06:32:37',0),(20,9,'8','@wi**********ne','whatsapp','','attempting','2026-05-12 06:32:37','2026-05-12 06:32:37',0);

--
-- Table structure for table `blast_target_groups`
--

CREATE TABLE `blast_target_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `filters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint unsigned NOT NULL,
  `estimated_audience` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `exclusions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blast_target_groups_business_account_id_index` (`business_account_id`),
  KEY `blast_target_groups_created_by_index` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blast_target_groups`
--

INSERT INTO `blast_target_groups` VALUES (1,1,'Temp-1776149330','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-14 06:48:50','2026-04-14 06:48:50'),(2,1,'Temp-1776149405','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-14 06:50:05','2026-04-14 06:50:05'),(3,1,'Temp-1776149609','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">1</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">Q07PTTAI04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"Q07PTTAI04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-14 06:53:29','2026-04-14 06:53:29'),(4,1,'Temp-1776322111','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-16 06:48:31','2026-04-16 06:48:31'),(5,1,'Temp-1776322280','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">1</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">I07X60FF04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"I07X60FF04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-16 06:51:20','2026-04-16 06:51:20'),(6,1,'Temp-1776326289','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-16 07:58:09','2026-04-16 07:58:09'),(7,1,'Temp-1776669685','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-20 07:21:25','2026-04-20 07:21:25'),(8,1,'Temp-1777454575','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-29 09:22:55','2026-04-29 09:22:55'),(9,1,'Temp-1777516857','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 02:40:57','2026-04-30 02:40:57'),(10,1,'Temp-1777516863','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 02:41:03','2026-04-30 02:41:03'),(11,1,'Temp-1777516882','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 02:41:22','2026-04-30 02:41:22'),(12,1,'Temp-1777517703','\"\"','[]',1,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 02:55:03','2026-04-30 02:55:03'),(13,1,'Temp-1777521653','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">2</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">T16ZM2JP04, Q07PTTAI04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"T16ZM2JP04\",\"Q07PTTAI04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 04:00:53','2026-04-30 04:00:53'),(14,1,'Temp-1777521773','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 04:02:53','2026-04-30 04:02:53'),(15,1,'Temp-1777521814','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">2</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">T16ZM2JP04, Q07PTTAI04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"T16ZM2JP04\",\"Q07PTTAI04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 04:03:34','2026-04-30 04:03:34'),(16,1,'Temp-1777526645','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 05:24:05','2026-04-30 05:24:05'),(17,1,'Temp-1777530697','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 06:31:37','2026-04-30 06:31:37'),(18,1,'Temp-1777530744','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 06:32:24','2026-04-30 06:32:24'),(19,1,'Temp-1777530774','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">2</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">Q07PTTAI04, T16ZM2JP04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"Q07PTTAI04\",\"T16ZM2JP04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 06:32:54','2026-04-30 06:32:54'),(20,1,'Temp-1777532857','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 07:07:37','2026-04-30 07:07:37'),(21,1,'Temp-1777532888','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">2</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">Q07PTTAI04, T16ZM2JP04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"Q07PTTAI04\",\"T16ZM2JP04\"]}}]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 07:08:08','2026-04-30 07:08:08'),(22,1,'Temp-1777536636','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 08:10:36','2026-04-30 08:10:36'),(23,1,'Temp-1777536649','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 08:10:49','2026-04-30 08:10:49'),(24,1,'Temp-1777543926','\"\"','[]',2,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-04-30 10:12:06','2026-04-30 10:12:06'),(25,1,'Temp-1778565477','\"\"','[]',1,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-05-12 05:57:57','2026-05-12 05:57:57'),(26,1,'Temp-1778565555','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">1</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">T16ZM2JP04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"T16ZM2JP04\"]}}]',1,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-05-12 05:59:15','2026-05-12 05:59:15'),(27,1,'Temp-1778565654','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">1</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">T16ZM2JP04</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"T16ZM2JP04\"]}}]',1,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-05-12 06:00:54','2026-05-12 06:00:54'),(28,1,'Temp-1778567438','\"Only select from <span class=\\\"badge badge-btn badge-info\\\">2</span> user(s) <span class=\\\"badge badge-btn badge-info\\\">T16ZM2JP04, D12LZRYX05</span>\"','[{\"type\":\"pick_fixed_set_users\",\"data\":{\"pick_fixed_set_users_select\":[\"T16ZM2JP04\",\"D12LZRYX05\"]}}]',1,'count','{\"exclude_target_groups\":false,\"exclude_users\":false}','draft','2026-05-12 06:30:38','2026-05-12 06:30:38');

--
-- Table structure for table `blast_whatsapp_request_logs`
--

CREATE TABLE `blast_whatsapp_request_logs` (
  `blast_id` bigint unsigned NOT NULL,
  `req_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `req_response` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`blast_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blast_whatsapp_request_logs`
--

INSERT INTO `blast_whatsapp_request_logs` VALUES (3,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AxOTc','{\"name\":\"test1\",\"trigger_at\":\"2026-04-30T04:30:00.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"wa_username_testing_test_blast_01\",\"channel\":\"SKALE WA Test\"}','completed','2026-04-30 05:35:59','2026-04-30 05:35:59'),(4,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AyMDU','{\"name\":\"test2\",\"trigger_at\":\"2026-04-30T04:30:00.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"skale_wa_test_receipt_success_message_with_a_game_link\",\"channel\":\"SKALE WA Test\"}','completed','2026-04-30 06:52:53','2026-04-30 06:52:53'),(5,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AyMDY','{\"name\":\"Test Blast 3\",\"trigger_at\":\"2026-04-30T06:55:00.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"wa_username_testing_test_blast_01\",\"channel\":\"SKALE WA Test\"}','completed','2026-04-30 07:03:55','2026-04-30 07:03:56'),(6,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AyMDk','{\"name\":\"Test Blast 4\",\"trigger_at\":\"2026-04-30T06:55:00.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"wa_username_testing_test_blast_01\",\"channel\":\"SKALE WA Test\"}','completed','2026-04-30 10:17:11','2026-04-30 10:17:11'),(8,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AyMTI','{\"name\":\"Wilson Username Test Blast 2\",\"trigger_at\":\"2026-05-12T06:05:32.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"skale_wa_test_test_blast_for_username\",\"channel\":\"SKALE WA Test\"}','completed','2026-05-12 06:08:05','2026-05-12 06:08:05'),(9,'QXBwXE1vZGVsc1xBZGhvY1xBZGhvY0JsYXN0U2NoZWR1bGVyc0AyMTM','{\"name\":\"Wilson Username Test Blast 3\",\"trigger_at\":\"2026-05-12T06:30:00.000000Z\",\"finished_at\":null,\"cancelled_at\":null,\"reason\":null,\"template\":\"skale_wa_test_test_blast_for_username\",\"channel\":\"SKALE WA Test\"}','completed','2026-05-12 06:32:37','2026-05-12 06:32:38');

--
-- Table structure for table `blasts`
--

CREATE TABLE `blasts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `blast_group_id` bigint unsigned NOT NULL,
  `schedule_datetime` datetime NOT NULL,
  `sms` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `in_app` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `whatsapp` longtext COLLATE utf8mb4_unicode_ci,
  `created_by` bigint unsigned NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blasts_blast_group_id_index` (`blast_group_id`),
  KEY `blasts_created_by_index` (`created_by`),
  KEY `blasts_status(10)_index` (`status`(10))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blasts`
--

INSERT INTO `blasts` VALUES (1,'Test Blast','datetime',2,'2026-04-14 15:47:17','{\"content\":null,\"sender_id\":null}','{\"content\":\"<p>Hey {{recipient_name}},<br \\/>\\nYou have new rewards waiting for you here {{my_voucher_url}}<\\/p>\",\"email_subject\":\"Foo\",\"reply_to\":\"no-reply@growthdesk.dev\",\"sender_name\":\"Foo\"}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":null,\"variables\":null,\"content\":null}',2,'cancelled','2026-04-14 06:50:47','2026-04-14 06:52:18'),(2,'Test 2','datetime',3,'2026-04-14 15:52:48','{\"content\":\"Hey {{recipient_name}},\\nYou have new rewards waiting for you here {{my_voucher_url}}\",\"sender_id\":\"SKALE\"}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":null,\"variables\":null,\"content\":null}',2,'completed','2026-04-14 06:53:50','2026-04-30 05:29:03'),(3,'test1','datetime',13,'2026-04-30 12:30:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0MDkz\",\"variables\":{\"name\":\"{{recipient_name}}\"},\"content\":{\"slug\":\"wa_username_testing_test_blast_01\",\"content\":{\"body\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\",\"samples\":[],\"variables\":[\"name\"],\"body_raw\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\"}}}',2,'completed','2026-04-30 04:01:43','2026-04-30 05:35:59'),(4,'test2','datetime',15,'2026-04-30 12:30:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0MDY3\",\"variables\":[],\"content\":{\"slug\":\"skale_wa_test_receipt_success_message_with_a_game_link\",\"content\":{\"body\":\"Hi {{name}}! Your receipt has been validated and approved.\\n\\nYour points accumulated are {{points}}.\\n\\nSpoil your pet with rewards!\\nFind out the exciting rewards you can redeem for your pet here: {{login_url}}\\n\\nEvery purchase earns points for exciting treats for your furry pet.\",\"samples\":[],\"variables\":[\"name\",\"points\",\"login_url\"],\"body_raw\":\"Hi {{name}}! Your receipt has been validated and approved.<br \\/><br \\/>Your points accumulated are {{points}}.<br \\/><br \\/>Spoil your pet with rewards!<br \\/>Find out the exciting rewards you can redeem for your pet here: {{login_url}}<br \\/><br \\/>Every purchase earns points for exciting treats for your furry pet.\"}}}',2,'completed','2026-04-30 04:03:40','2026-04-30 06:52:53'),(5,'Test Blast 3','datetime',19,'2026-04-30 14:55:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0MDkz\",\"variables\":{\"name\":\"{{recipient_name}}\"},\"content\":{\"slug\":\"wa_username_testing_test_blast_01\",\"content\":{\"body\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\",\"samples\":[],\"variables\":[\"name\"],\"body_raw\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\"}}}',2,'completed','2026-04-30 06:33:15','2026-04-30 07:03:56'),(6,'Test Blast 4','datetime',21,'2026-04-30 14:55:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0MDkz\",\"variables\":{\"name\":\"{{recipient_name}}\"},\"content\":{\"slug\":\"wa_username_testing_test_blast_01\",\"content\":{\"body\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\",\"samples\":[],\"variables\":[\"name\"],\"body_raw\":\"Hello {{name}}! This message blast is used to test the functionality of WhatsApp notification in the campaign using the WhatsApp username.\"}}}',2,'completed','2026-04-30 07:08:14','2026-04-30 10:17:11'),(7,'Wilson Username Test Blast','datetime',26,'2026-05-12 14:30:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0NjM5\",\"variables\":[],\"content\":{\"slug\":\"skale_wa_test_test_blast_for_username\",\"content\":{\"body\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\",\"samples\":[],\"variables\":[],\"body_raw\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\"}}}',1,'cancelled','2026-05-12 06:00:00','2026-05-12 06:00:27'),(8,'Wilson Username Test Blast 2','datetime',27,'2026-05-12 14:05:32','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0NjM5\",\"variables\":[],\"content\":{\"slug\":\"skale_wa_test_test_blast_for_username\",\"content\":{\"body\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\",\"samples\":[],\"variables\":[],\"body_raw\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\"}}}',1,'completed','2026-05-12 06:01:04','2026-05-12 06:08:05'),(9,'Wilson Username Test Blast 3','datetime',28,'2026-05-12 14:30:00','{\"content\":null,\"sender_id\":null}','{\"content\":null,\"email_subject\":null,\"reply_to\":null,\"sender_name\":null}','{\"content\":null,\"cta_action\":null}','{\"wa_template_id\":\"QXBwXE1vZGVsc1xDaGFubmVsVGVtcGxhdGVzQDc0NjM5\",\"variables\":[],\"content\":{\"slug\":\"skale_wa_test_test_blast_for_username\",\"content\":{\"body\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\",\"samples\":[],\"variables\":[],\"body_raw\":\"Because when your pet is healthy, life is better for everyone. \\ud83d\\udc3e Trust Elanco for science-backed animal health solutions.\"}}}',1,'completed','2026-05-12 06:31:31','2026-05-12 06:32:38');

--
-- Table structure for table `bonus_module_request_logs`
--

CREATE TABLE `bonus_module_request_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bonus_module_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `requestor_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `requestor_id` bigint unsigned DEFAULT NULL,
  `transactionable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transactionable_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactionable_index` (`transactionable_type`,`transactionable_id`),
  KEY `requestor_index` (`requestor_type`,`requestor_id`),
  KEY `bonus_module_request_logs_bonus_module_id_index` (`bonus_module_id`),
  KEY `bonus_module_request_logs_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bonus_module_request_logs`
--


--
-- Table structure for table `bonus_modules`
--

CREATE TABLE `bonus_modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `event_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `daily_challenge_id` bigint unsigned DEFAULT NULL,
  `mechanism_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reward_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_num_trigger` int unsigned NOT NULL DEFAULT '1',
  `max_num_reward` int unsigned DEFAULT '1',
  `date_from` datetime DEFAULT NULL,
  `date_to` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `main_pair_index` (`business_account_id`,`event_type`),
  KEY `bonus_modules_daily_challenge_id_index` (`daily_challenge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bonus_modules`
--


--
-- Table structure for table `business_account_details`
--

CREATE TABLE `business_account_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `header` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_header` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `business_account_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_account_details_business_account_id_index` (`business_account_id`),
  CONSTRAINT `business_account_details_business_account_id_foreign` FOREIGN KEY (`business_account_id`) REFERENCES `business_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_account_details`
--


--
-- Table structure for table `business_account_domains`
--

CREATE TABLE `business_account_domains` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `hostname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_account_domains_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_account_domains`
--

INSERT INTO `business_account_domains` VALUES (1,1,'wa-username-testing.growthdesk.dev','2026-04-07 06:36:24','2026-04-07 06:36:24');

--
-- Table structure for table `business_account_groups`
--

CREATE TABLE `business_account_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_business_account_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_account_groups_name_index` (`name`),
  KEY `business_account_groups_main_business_account_id_index` (`main_business_account_id`),
  CONSTRAINT `business_account_groups_main_business_account_id_foreign` FOREIGN KEY (`main_business_account_id`) REFERENCES `business_accounts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_account_groups`
--


--
-- Table structure for table `business_account_summaries`
--

CREATE TABLE `business_account_summaries` (
  `business_account_id` bigint unsigned NOT NULL,
  `module_usage_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `business_account_summaries_business_account_id_unique` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_account_summaries`
--

INSERT INTO `business_account_summaries` VALUES (1,'{\"riddle\":false,\"dstw\":false,\"dsc\":false,\"plant\":false,\"dailyChallenge\":true}','2026-04-07 06:52:57','2026-04-07 06:53:26');

--
-- Table structure for table `business_accounts`
--

CREATE TABLE `business_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `hostname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_sn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_white` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apple_touch_icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tc_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sender_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `noreply` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_group` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `add_by_business_account_id` bigint unsigned DEFAULT NULL,
  `add_by_user_id` bigint unsigned DEFAULT NULL,
  `is_agency` tinyint(1) NOT NULL DEFAULT '0',
  `alias` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `status_updated_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `business_accounts_hostname_unique` (`hostname`),
  KEY `business_accounts_account_group(6)_index` (`account_group`(6)),
  KEY `business_accounts_add_by_business_account_id_index` (`add_by_business_account_id`),
  KEY `business_accounts_add_by_user_id_index` (`add_by_user_id`),
  KEY `business_accounts_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_accounts`
--

INSERT INTO `business_accounts` VALUES (1,'wa-username-testing.growthdesk.dev','SG','en','WA Username Test','1AUse','-',NULL,NULL,NULL,NULL,'SKALE','no-reply@skale.today',NULL,'1WAUsernameTest','default',NULL,NULL,0,'WA Username Test Campaign','active',NULL,'2026-04-07 06:36:23','2026-04-07 06:36:24');

--
-- Table structure for table `business_assets`
--

CREATE TABLE `business_assets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` int unsigned NOT NULL,
  `redeem_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qr_code_file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qr_code_file_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `partner_business_asset_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_id` int unsigned DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'retail',
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pixel_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coordinates` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `promotion_code_display_method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_smart_receipt_exclusion` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_grids` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_code_masked` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_keywords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `negative_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mall_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  PRIMARY KEY (`id`),
  KEY `business_assets_business_account_id_slug(10)_index` (`business_account_id`,`slug`(10)),
  KEY `business_assets_business_account_id_merchant_id_index` (`business_account_id`,`merchant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_assets`
--

INSERT INTO `business_assets` VALUES (1,1,'869644',NULL,NULL,NULL,NULL,'retail','Test Outlet 1','Foo St.',NULL,'','','default',NULL,NULL,NULL,'test-outlet-1','test-outlet-1',0,'active','2026-04-23 06:26:50','2026-04-23 06:26:50','test-store-1','',NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,'active');

--
-- Table structure for table `business_details`
--

CREATE TABLE `business_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_details`
--


--
-- Table structure for table `campaign_business_assets_relations`
--

CREATE TABLE `campaign_business_assets_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_asset_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaign_business_assets_relations`
--


--
-- Table structure for table `campaign_voucher_series`
--

CREATE TABLE `campaign_voucher_series` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `campaign_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `voucher_series_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaign_voucher_series`
--


--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `promo_icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `registration_start_date` datetime NOT NULL,
  `registration_end_date` datetime NOT NULL,
  `campaign_start_date` datetime NOT NULL,
  `campaign_end_date` datetime NOT NULL,
  `tnc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_banner` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaigns`
--


--
-- Table structure for table `category_criteria`
--

CREATE TABLE `category_criteria` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `criteria` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_criteria`
--


--
-- Table structure for table `category_group_items`
--

CREATE TABLE `category_group_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt_icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT '0',
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_group_items`
--


--
-- Table structure for table `category_group_settings`
--

CREATE TABLE `category_group_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `group_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_group_settings_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_group_settings`
--


--
-- Table structure for table `category_groups`
--

CREATE TABLE `category_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int DEFAULT '0',
  `created_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alt_icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bundles_left` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sms_template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email_template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `thumbnail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desktop_banner` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_banner` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_groups_business_account_id_status(6)_index` (`business_account_id`,`status`(6))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_groups`
--


--
-- Table structure for table `chance_distribution_transaction_items`
--

CREATE TABLE `chance_distribution_transaction_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `chance_trn_id` bigint unsigned NOT NULL,
  `reserved_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `issue_for` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_link_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_link_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chance_distribution_transaction_items_chance_trn_id_index` (`chance_trn_id`),
  KEY `foreign_link_index` (`issue_for`,`issue_link_id`),
  KEY `issue_link_index` (`issue_link_model`,`issue_link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chance_distribution_transaction_items`
--


--
-- Table structure for table `chance_distribution_transactions`
--

CREATE TABLE `chance_distribution_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `issue_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_chance` int unsigned NOT NULL,
  `issue_remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_auto_approved` tinyint NOT NULL,
  `approval_at` timestamp NULL DEFAULT NULL,
  `approver_user_id` bigint unsigned DEFAULT NULL,
  `num_balance` int unsigned NOT NULL DEFAULT '0',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_link_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_link_id` bigint unsigned DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ext_transaction_uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `external_link_index` (`issue_type`,`user_id`,`issue_link_id`),
  KEY `approval_date_index` (`user_id`,`status`,`approval_at`),
  KEY `foreign_link_index` (`status`,`issue_type`,`issue_link_id`),
  KEY `chance_distribution_transactions_approver_user_id_index` (`approver_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chance_distribution_transactions`
--

INSERT INTO `chance_distribution_transactions` VALUES (1,2,'basic',1,'Earned from Daily Basic',1,'2026-04-06 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-07 15:59:59','2026-04-07 06:52:40','2026-04-07 06:52:40',NULL),(2,4,'basic',1,'Earned from Daily Basic',1,'2026-04-06 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-07 15:59:59','2026-04-07 07:13:53','2026-04-07 07:13:53',NULL),(3,5,'basic',1,'Earned from Daily Basic',1,'2026-04-06 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-07 15:59:59','2026-04-07 07:14:31','2026-04-07 07:14:31',NULL),(4,5,'basic',1,'Earned from Daily Basic',1,'2026-04-07 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-08 15:59:59','2026-04-07 16:17:27','2026-04-07 16:17:27',NULL),(5,5,'basic',1,'Earned from Daily Basic',1,'2026-04-09 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-10 15:59:59','2026-04-10 00:49:35','2026-04-10 00:49:35',NULL),(6,5,'basic',1,'Earned from Daily Basic',1,'2026-04-10 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-11 15:59:59','2026-04-10 18:13:29','2026-04-10 18:13:29',NULL),(7,5,'basic',1,'Earned from Daily Basic',1,'2026-04-11 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-12 15:59:59','2026-04-12 07:59:10','2026-04-12 07:59:10',NULL),(8,5,'basic',1,'Earned from Daily Basic',1,'2026-04-12 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-13 15:59:59','2026-04-12 16:42:51','2026-04-12 16:42:51',NULL),(9,5,'basic',1,'Earned from Daily Basic',1,'2026-04-13 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-14 15:59:59','2026-04-13 16:12:37','2026-04-13 16:12:37',NULL),(10,2,'basic',1,'Earned from Daily Basic',1,'2026-04-13 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-14 15:59:59','2026-04-14 06:47:09','2026-04-14 06:47:09',NULL),(11,2,'basic',1,'Earned from Daily Basic',1,'2026-04-14 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-15 15:59:59','2026-04-14 16:00:03','2026-04-14 16:00:03',NULL),(12,9,'basic',1,'Earned from Daily Basic',1,'2026-04-15 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-16 15:59:59','2026-04-16 04:02:40','2026-04-16 04:02:40',NULL),(13,5,'basic',1,'Earned from Daily Basic',1,'2026-04-15 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-16 15:59:59','2026-04-16 06:47:59','2026-04-16 06:47:59',NULL),(14,2,'basic',1,'Earned from Daily Basic',1,'2026-04-15 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-16 15:59:59','2026-04-16 06:48:05','2026-04-16 06:48:05',NULL),(15,2,'basic',1,'Earned from Daily Basic',1,'2026-04-23 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-24 15:59:59','2026-04-24 05:48:51','2026-04-24 05:48:51',NULL),(16,2,'basic',1,'Earned from Daily Basic',1,'2026-04-24 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-25 15:59:59','2026-04-24 16:00:45','2026-04-24 16:00:45',NULL),(17,2,'basic',1,'Earned from Daily Basic',1,'2026-04-25 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-26 15:59:59','2026-04-25 17:00:23','2026-04-25 17:00:23',NULL),(18,2,'basic',1,'Earned from Daily Basic',1,'2026-04-26 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-27 15:59:59','2026-04-26 16:00:27','2026-04-26 16:00:27',NULL),(19,9,'basic',1,'Earned from Daily Basic',1,'2026-04-29 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-30 15:59:59','2026-04-30 02:23:11','2026-04-30 02:23:11',NULL),(20,1,'basic',1,'Earned from Daily Basic',1,'2026-04-29 16:00:00',NULL,1,'active',NULL,NULL,'2026-04-30 15:59:59','2026-04-30 02:54:45','2026-04-30 02:54:45',NULL),(21,1,'basic',1,'Earned from Daily Basic',1,'2026-05-10 16:00:00',NULL,1,'active',NULL,NULL,'2026-05-11 15:59:59','2026-05-11 04:05:47','2026-05-11 04:05:47',NULL),(22,1,'basic',1,'Earned from Daily Basic',1,'2026-05-11 16:00:00',NULL,1,'active',NULL,NULL,'2026-05-12 15:59:59','2026-05-12 02:26:38','2026-05-12 02:26:38',NULL),(23,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 03:43:46',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',34,'2026-05-13 03:43:45','2026-05-12 03:42:07','2026-05-12 03:43:46',NULL),(24,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 04:06:28',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',35,'2026-05-13 04:06:27','2026-05-12 03:44:36','2026-05-12 04:06:28',NULL),(25,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 04:23:05',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',36,'2026-05-13 04:23:04','2026-05-12 04:10:01','2026-05-12 04:23:05',NULL),(26,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 05:15:53',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',37,'2026-05-13 05:15:52','2026-05-12 04:10:17','2026-05-12 05:15:53',NULL),(27,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 05:31:46',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',38,'2026-05-13 05:31:45','2026-05-12 05:22:32','2026-05-12 05:31:46',NULL),(28,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 05:47:24',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',39,'2026-05-13 05:47:23','2026-05-12 05:46:47','2026-05-12 05:47:25',NULL),(29,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 05:50:13',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',40,'2026-05-13 05:50:12','2026-05-12 05:49:57','2026-05-12 05:50:13',NULL),(30,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 08:23:17',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',41,'2026-05-13 08:23:16','2026-05-12 08:23:01','2026-05-12 08:23:17',NULL),(31,11,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-12 08:29:55',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',46,'2026-05-13 08:29:54','2026-05-12 08:26:53','2026-05-12 08:29:55',NULL),(32,11,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-13 05:54:44',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',48,'2026-05-14 05:54:43','2026-05-13 04:25:40','2026-05-13 05:54:44',NULL),(33,1,'basic',1,'Earned from Daily Basic',1,'2026-05-12 16:00:00',NULL,1,'active',NULL,NULL,'2026-05-13 15:59:59','2026-05-13 05:36:25','2026-05-13 05:36:25',NULL),(34,8,'upload_receipt',1,'Earned From Daily ChallengeUpload Receipt',0,'2026-05-13 09:09:23',1,1,'active','App\\Models\\UserInteraction\\UserDailyChallenges',50,'2026-05-14 09:09:22','2026-05-13 09:08:38','2026-05-13 09:09:23',NULL);

--
-- Table structure for table `creative_template_layers`
--

CREATE TABLE `creative_template_layers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `template_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `layer_column_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `layer_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `align` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'center',
  `size_x` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_y` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_h` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_w` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `creative_template_layers`
--


--
-- Table structure for table `creative_templates`
--

CREATE TABLE `creative_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `canvas_w` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `canvas_h` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `creative_templates_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `creative_templates`
--


--
-- Table structure for table `custom_conversions`
--

CREATE TABLE `custom_conversions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_id` int NOT NULL,
  `platform` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `act_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `conversion_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_conversions`
--


--
-- Table structure for table `custom_pop_up_settings`
--

CREATE TABLE `custom_pop_up_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `popup_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `popup_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_setting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `automate_setting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cond_destination` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cond_num_appear` int unsigned DEFAULT NULL,
  `cond_filter` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cond_show_after_date` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_key_index` (`business_account_id`,`cond_destination`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_pop_up_settings`
--


--
-- Table structure for table `custom_pop_up_user_logs`
--

CREATE TABLE `custom_pop_up_user_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `custom_popup_setting_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_pop_up_user_logs_custom_popup_setting_id_index` (`custom_popup_setting_id`),
  KEY `custom_pop_up_user_logs_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_pop_up_user_logs`
--


--
-- Table structure for table `daily_challenges`
--

CREATE TABLE `daily_challenges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `img_landing_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_from` datetime NOT NULL,
  `date_to` datetime DEFAULT NULL,
  `reward_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `setting_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `day_week_settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order` int DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_slug_unique` (`business_account_id`,`slug`),
  KEY `account_activation_index` (`business_account_id`,`is_active`,`date_from`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_challenges`
--

INSERT INTO `daily_challenges` VALUES (1,1,'riddle','Riddle',NULL,NULL,NULL,'2026-04-07 14:36:24','2027-05-07 23:59:59',NULL,'{\"num_question\":1,\"is_fixed_for_all_user\":1,\"question_mode\":\"fixed_across_user\"}',NULL,NULL,1,'2026-04-07 06:36:24','2026-05-13 05:37:30'),(2,1,'take_a_picture','Take a Picture',NULL,'To learn more, please head to the nearest customer service counter.','https://wa-username-testing.growthdesk.dev/assets/images/daily_challenges/Challenge_images_Snap_Photo-min.png','2026-04-07 14:36:24','2027-05-07 23:59:59','{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]}','{\"shortcut\":\"0\",\"daily_limit\":null,\"auto_approve\":\"0\",\"reward_on_submit\":\"0\",\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}}',NULL,NULL,1,'2026-04-07 06:36:24','2026-05-13 05:37:30'),(3,1,'offline_eng','ScanQR Code In-Store',NULL,'Spend In-Store and Unlock an Additional Attempt','https://wa-username-testing.growthdesk.dev/assets/images/daily_challenges/Challenge_images_Scan_QR-min.png','2026-04-07 14:36:24','2027-05-07 23:59:59','{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]}','{\"shortcut\":\"0\",\"daily_limit\":\"0\",\"qr_code\":\"0\",\"6_digit_pin\":\"0\",\"store_types_auto_include\":\"0\"}',NULL,NULL,1,'2026-04-07 06:36:24','2026-05-13 05:37:30'),(4,1,'social_follow','Join our Social Media',NULL,NULL,'https://wa-username-testing.growthdesk.dev/assets/images/daily_challenges/Challenge_images_Follow_Social_Media-min.png','2026-04-07 14:36:24','2027-05-07 23:59:59','{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]}','{\"shortcut\":\"0\",\"lifetime_limit\":null,\"auto_approve\":\"1\",\"url\":{\"facebook\":null,\"instagram\":null,\"tiktok\":null},\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}}',NULL,NULL,1,'2026-04-07 06:36:24','2026-05-13 05:37:30'),(5,1,'app_install','Install App',NULL,NULL,'https://wa-username-testing.growthdesk.dev/assets/images/daily_challenges/Challenge_images_Install_App-min.png','2026-04-07 14:36:24','2027-05-07 23:59:59','{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]}','{\"shortcut\":\"0\",\"lifetime_limit\":null,\"auto_approve\":\"0\",\"url\":{\"play\":null,\"ios\":null,\"huawei\":null},\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}}',NULL,NULL,1,'2026-04-07 06:36:25','2026-05-13 05:37:30'),(6,1,'upload_receipt','Upload Receipt',NULL,'Upload receipt of your purchase to unlock additional attempt','https://wa-username-testing.growthdesk.dev/assets/images/daily_challenges/Challenge_images_Upload_Receipt-min.png','2026-04-07 14:36:24','2027-05-07 23:59:59','{\"qty\":\"1\",\"type\":\"chance\",\"additional\":[],\"caches\":[]}','{\"shortcut\":\"0\",\"daily_limit\":null,\"auto_approve\":\"0\",\"reward_on_submit\":\"0\",\"examples\":[{\"name\":null},{\"name\":null},{\"name\":null}],\"messages\":{\"success\":{\"title\":null,\"subtitle\":null},\"error\":{\"title\":null,\"subtitle\":null}}}',NULL,NULL,1,'2026-04-07 06:36:25','2026-05-13 05:37:30'),(7,1,'scratchcard','Scratch Card',NULL,NULL,NULL,'2026-04-07 14:36:24','2027-05-07 23:59:59',NULL,'{\"shortcut\":0}',NULL,NULL,0,'2026-04-07 06:36:25','2026-05-13 05:37:30'),(8,1,'spinandwin','Spin And Win',NULL,NULL,NULL,'2026-04-07 14:36:24',NULL,NULL,'{\"win_title\":\"Congratulations\",\"win_subtitle\":\"You have won\",\"lose_title\":\"Oh No!\",\"lose_subtitle\":\"Please try again\"}',NULL,NULL,1,'2026-04-07 06:36:25','2026-05-13 05:37:29'),(9,1,'slotmachine','Match And Win',NULL,NULL,NULL,'2026-04-07 14:36:24','2027-05-07 23:59:59',NULL,'{\"default\":[],\"count\":3,\"background\":\"\",\"tiles\":{\"background_type\":\"color\",\"background\":\"#FFFFFF\",\"position\":\"\",\"spacing\":\"5\",\"size\":\"25,25\"},\"rest_chance_of_win\":null,\"max_chance_of_win\":null}',NULL,NULL,0,'2026-04-07 06:36:25','2026-05-13 05:37:30');

--
-- Table structure for table `daily_check_in_summaries`
--

CREATE TABLE `daily_check_in_summaries` (
  `daily_check_in_id` bigint unsigned NOT NULL,
  `chance_issued` int unsigned DEFAULT NULL,
  `chance_balance` int unsigned DEFAULT NULL,
  `latest_chance_approval_at` timestamp NULL DEFAULT NULL,
  `latest_chance_update_at` timestamp NULL DEFAULT NULL,
  `point_issued` decimal(8,2) DEFAULT NULL,
  `latest_point_approval_at` timestamp NULL DEFAULT NULL,
  `latest_point_updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`daily_check_in_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_check_in_summaries`
--


--
-- Table structure for table `daily_check_ins`
--

CREATE TABLE `daily_check_ins` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `date_clocked` date NOT NULL,
  `time_clocked` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `daily_check_ins_user_id_date_clocked_index` (`user_id`,`date_clocked`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_check_ins`
--


--
-- Table structure for table `daily_core_ars`
--

CREATE TABLE `daily_core_ars` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `modules` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_from` datetime NOT NULL,
  `date_to` datetime DEFAULT NULL,
  `reward_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `setting_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `daily_core_ars_modules_slug_unique` (`modules`,`slug`),
  KEY `daily_core_ars_modules_is_active_date_from_index` (`modules`,`is_active`,`date_from`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `daily_core_ars`
--


--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_group_slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_group_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `server_directory` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `domains_account_group_slug_index` (`account_group_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `domains`
--


--
-- Table structure for table `draw_users`
--

CREATE TABLE `draw_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `draw_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `type` enum('main','sub') COLLATE utf8mb4_unicode_ci NOT NULL,
  `frequency` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `draw_users_draw_id_foreign` (`draw_id`),
  KEY `draw_users_user_id_foreign` (`user_id`),
  CONSTRAINT `draw_users_draw_id_foreign` FOREIGN KEY (`draw_id`) REFERENCES `draws` (`id`),
  CONSTRAINT `draw_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `draw_users`
--


--
-- Table structure for table `draws`
--

CREATE TABLE `draws` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exclusions` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings` longtext COLLATE utf8mb4_unicode_ci,
  `business_account_id` bigint unsigned DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL,
  `status` enum('active','draft') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `draws_created_by_foreign` (`created_by`),
  KEY `draws_business_account_id_index` (`business_account_id`),
  CONSTRAINT `draws_business_account_id_foreign` FOREIGN KEY (`business_account_id`) REFERENCES `business_accounts` (`id`),
  CONSTRAINT `draws_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `draws`
--


--
-- Table structure for table `dsc_api_access`
--

CREATE TABLE `dsc_api_access` (
  `sn` int NOT NULL,
  `label` text NOT NULL,
  `access_id` text NOT NULL,
  `private_key` text NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_api_access`
--


--
-- Table structure for table `dsc_entries`
--

CREATE TABLE `dsc_entries` (
  `sn` bigint NOT NULL AUTO_INCREMENT,
  `uid` varchar(20) NOT NULL,
  `user_uid` varchar(20) NOT NULL,
  `grid_id` varchar(20) NOT NULL,
  `card_id` varchar(20) NOT NULL,
  `spin_count` int NOT NULL DEFAULT '0',
  `receipt_path` text NOT NULL,
  `file_type` varchar(20) NOT NULL COMMENT '-receipt/-screen shot',
  `plain_name` text NOT NULL,
  `plain_email` text NOT NULL,
  `countrycode` text NOT NULL,
  `plain_mobile` text NOT NULL,
  `pos` text,
  `pos_value` varchar(191) DEFAULT NULL,
  `products` longtext,
  `txn_amount` double DEFAULT NULL,
  `data` text NOT NULL,
  `prize` text,
  `followup_data` text,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(20) NOT NULL,
  `status_reason` varchar(20) DEFAULT NULL,
  `ocr_result` text,
  `remark` varchar(30) DEFAULT NULL,
  `hide` varchar(191) DEFAULT '0',
  `user_device_agent_id` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `extracted_text` text NOT NULL,
  PRIMARY KEY (`sn`),
  KEY `index_grid_id` (`grid_id`),
  KEY `index_card_id` (`card_id`),
  KEY `index_pos` (`sn`),
  KEY `dsc_entries_user_uid(8)_status(6)_index` (`user_uid`(8),`status`(6)),
  KEY `dsc_entries_pos(10)_index` (`pos`(10)),
  KEY `dsc_entries_``status``(6)_index` (`status`(6))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_entries`
--


--
-- Table structure for table `dsc_grid`
--

CREATE TABLE `dsc_grid` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `grid_id` varchar(20) NOT NULL,
  `daily_challenge_id` bigint unsigned NOT NULL,
  `business_account_id` bigint unsigned NOT NULL,
  `card_id` bigint unsigned NOT NULL,
  `grid_completion_limit` int NOT NULL DEFAULT '1',
  `rejected_grid_image` varchar(191) NOT NULL,
  `pending_grid_image` varchar(191) NOT NULL,
  `completed_grid_image` varchar(191) NOT NULL,
  `incomplete_grid_image` varchar(191) NOT NULL,
  `incomplete_grid_message` longtext,
  `completed_grid_message` longtext,
  `pending_grid_message` longtext,
  `rejected_grid_message` longtext,
  `reward_image` varchar(255) NOT NULL,
  `reward_title` varchar(255) NOT NULL,
  `reward_description` varchar(255) NOT NULL,
  `pos_type` varchar(255) NOT NULL,
  `instruction_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `instruction_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `min_amount` double NOT NULL,
  `grid_success_hook` text,
  `admin_approval` tinyint(1) NOT NULL,
  `receipt_requirements` text,
  `pending_reward_image` text,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `account_card_index` (`business_account_id`,`card_id`),
  KEY `account_card_grid_index` (`business_account_id`,`card_id`,`grid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_grid`
--


--
-- Table structure for table `dsc_locations`
--

CREATE TABLE `dsc_locations` (
  `sn` int NOT NULL AUTO_INCREMENT,
  `location_code` varchar(8) NOT NULL,
  `location_name` text NOT NULL,
  `location_pin` varchar(8) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_locations`
--


--
-- Table structure for table `dsc_log`
--

CREATE TABLE `dsc_log` (
  `sn` bigint NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_uid` text NOT NULL,
  `event` text NOT NULL,
  `details` text NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sn`),
  KEY `dsc_log_user_uid(8)_index` (`user_uid`(8)),
  KEY `dsc_log_event(6)_index` (`event`(6))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_log`
--


--
-- Table structure for table `dsc_merchants`
--

CREATE TABLE `dsc_merchants` (
  `sn` int NOT NULL AUTO_INCREMENT,
  `location_code` varchar(20) NOT NULL,
  `sid` varchar(20) NOT NULL,
  `skale_business_profile_id` mediumtext,
  `merchant_name` mediumtext NOT NULL,
  `merchant_address` text NOT NULL,
  `merchant_state` varchar(191) NOT NULL,
  `merchant_logo` mediumtext,
  `merchant_grids` mediumtext,
  `merchant_code` mediumtext,
  `merchant_code_masked` mediumtext,
  `store_location` mediumtext NOT NULL,
  `product_keywords` text,
  `location_keywords` text NOT NULL,
  `mall_name` mediumtext,
  `merchant_brand` varchar(191) DEFAULT NULL,
  `shop_category` mediumtext,
  `company_name` mediumtext,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(191) NOT NULL DEFAULT 'active',
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `dsc_merchants`
--


--
-- Table structure for table `dsc_reward_groups`
--

CREATE TABLE `dsc_reward_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_item_quantity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_quantity_left` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notification_hook` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_need_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'false',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_reward_groups`
--


--
-- Table structure for table `dsc_reward_items`
--

CREATE TABLE `dsc_reward_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `group_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_reward_items`
--


--
-- Table structure for table `dsc_reward_pos`
--

CREATE TABLE `dsc_reward_pos` (
  `sn` bigint NOT NULL AUTO_INCREMENT,
  `reward_pos_id` varchar(20) NOT NULL,
  `reward_pos_key` varchar(20) NOT NULL,
  `reward_pin` varchar(20) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dsc_reward_pos`
--


--
-- Table structure for table `dsc_reward_redemption_logs`
--

CREATE TABLE `dsc_reward_redemption_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_uid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reward_item_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reward_group_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dsc_grid_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dsc_entry_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dsc_card_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_reward_redemption_logs`
--


--
-- Table structure for table `dsc_rewards_pos`
--

CREATE TABLE `dsc_rewards_pos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_rewards_pos`
--


--
-- Table structure for table `dsc_user_cards`
--

CREATE TABLE `dsc_user_cards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `daily_challenge_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_card_no` int NOT NULL,
  `is_active` tinyint NOT NULL DEFAULT '0',
  `is_completed` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_user_cards`
--


--
-- Table structure for table `dsc_user_grids`
--

CREATE TABLE `dsc_user_grids` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_card_id` bigint unsigned NOT NULL,
  `dsc_grid_id` bigint unsigned NOT NULL,
  `grid_id` bigint unsigned NOT NULL,
  `user_daily_challenge_id` bigint unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'incomplete',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dsc_user_grids_user_card_id_dsc_grid_id_unique` (`user_card_id`,`dsc_grid_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dsc_user_grids`
--


--
-- Table structure for table `dsc_users`
--

CREATE TABLE `dsc_users` (
  `sn` int NOT NULL AUTO_INCREMENT,
  `mobile_verified` tinyint(1) NOT NULL DEFAULT '0',
  `user_uid` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_email` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_mobile` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_email_masked` text NOT NULL,
  `user_mobile_masked` text NOT NULL,
  `user_avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `dob` date DEFAULT NULL,
  `state` varchar(191) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `user_membership_id` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `user_details` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_progress` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_reg_timestamp` timestamp NULL DEFAULT NULL,
  `user_last_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_last_active_timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_last_use_timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_verified_timestamp` timestamp NULL DEFAULT NULL,
  `user_activated_timestamp` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `business_account_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`sn`),
  KEY `dsc_users_user_uid(8)_index` (`user_uid`(8))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `dsc_users`
--


--
-- Table structure for table `dstw_entries`
--

CREATE TABLE `dstw_entries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `receipt_uid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt_hash` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `user_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_mobile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_country_code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `dstw_entries_receipt_uid(6)_index` (`receipt_uid`(6)),
  KEY `dstw_entries_receipt_hash(6)_index` (`receipt_hash`(6)),
  KEY `dstw_entries_user_email(90)_index` (`user_email`(90)),
  KEY `dstw_entries_user_mobile(90)_index` (`user_mobile`(90)),
  KEY `dstw_entries_user_id_index` (`user_id`),
  KEY `dstw_entries_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_entries`
--


--
-- Table structure for table `dstw_entry_statuses`
--

CREATE TABLE `dstw_entry_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dstw_entries_id` bigint unsigned DEFAULT NULL,
  `chance_transaction_item_id` bigint unsigned DEFAULT NULL,
  `dstw_item_id` bigint unsigned DEFAULT NULL,
  `dstw_item_period_id` bigint unsigned DEFAULT NULL,
  `dstw_item_multiplier_id` bigint unsigned DEFAULT NULL,
  `dstw_item_info` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chance_of_win` double DEFAULT NULL,
  `num_wheel_item` int unsigned NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_reason` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approval_at` timestamp NULL DEFAULT NULL,
  `approval_user_id` bigint unsigned DEFAULT NULL,
  `has_fraud_detection` tinyint(1) NOT NULL DEFAULT '0',
  `is_fraud_suspection` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_entry_statuses_dstw_entries_id_index` (`dstw_entries_id`),
  KEY `dstw_entry_statuses_dstw_item_id_index` (`dstw_item_id`),
  KEY `dstw_entry_statuses_dstw_item_period_id_index` (`dstw_item_period_id`),
  KEY `dstw_entry_statuses_status_index` (`status`),
  KEY `dstw_entry_statuses_chance_transaction_item_id_index` (`chance_transaction_item_id`),
  KEY `dstw_entry_statuses_approval_user_id_index` (`approval_user_id`),
  KEY `dstw_entry_statuses_dstw_item_multiplier_id_index` (`dstw_item_multiplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_entry_statuses`
--


--
-- Table structure for table `dstw_item_multipliers`
--

CREATE TABLE `dstw_item_multipliers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dstw_item_id` bigint unsigned NOT NULL,
  `amount_from` decimal(8,4) unsigned NOT NULL,
  `amount_to` double(8,4) unsigned DEFAULT NULL,
  `multiplier` decimal(8,2) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_item_multipliers_dstw_item_id_index` (`dstw_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_item_multipliers`
--


--
-- Table structure for table `dstw_item_periods`
--

CREATE TABLE `dstw_item_periods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dstw_item_id` int unsigned NOT NULL,
  `date_from` datetime NOT NULL,
  `date_to` datetime NOT NULL,
  `chance_of_win` double NOT NULL,
  `total_prize` int unsigned NOT NULL DEFAULT '0',
  `num_balance` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_item_periods_dstw_item_id_date_from_date_to_index` (`dstw_item_id`,`date_from`,`date_to`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_item_periods`
--

INSERT INTO `dstw_item_periods` VALUES (1,1,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(2,2,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(3,3,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(4,4,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(5,5,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(6,6,'2026-04-07 14:36:25','9999-12-31 23:59:59',1,0,0,'2026-04-07 06:36:25','2026-04-07 06:36:25');

--
-- Table structure for table `dstw_item_slots`
--

CREATE TABLE `dstw_item_slots` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dstw_item_id` bigint unsigned NOT NULL,
  `dstw_slot_id` bigint unsigned NOT NULL,
  `order` int NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_item_slots_dstw_item_id_index` (`dstw_item_id`),
  KEY `dstw_item_slots_dstw_slot_id_index` (`dstw_slot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_item_slots`
--


--
-- Table structure for table `dstw_item_vouchers`
--

CREATE TABLE `dstw_item_vouchers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dstw_item_id` bigint unsigned NOT NULL,
  `voucher_series_id` bigint unsigned NOT NULL,
  `group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_item_vouchers_dstw_item_id_index` (`dstw_item_id`),
  KEY `dstw_item_vouchers_voucher_series_id_index` (`voucher_series_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_item_vouchers`
--


--
-- Table structure for table `dstw_items`
--

CREATE TABLE `dstw_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `is_slot_based` tinyint(1) NOT NULL DEFAULT '0',
  `is_slot_randomizable` tinyint(1) NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `chance_of_win` double NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `position` int unsigned NOT NULL DEFAULT '0',
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'win',
  `points` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#FFFFFF',
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_ignore_stock` tinyint(1) DEFAULT '0',
  `is_require_address` tinyint(1) NOT NULL DEFAULT '0',
  `item_group` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `integration_details` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dstw_items_business_account_id_slug_index` (`business_account_id`,`slug`),
  KEY `dstw_items_is_active_business_account_id_index` (`is_active`,`business_account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_items`
--

INSERT INTO `dstw_items` VALUES (1,1,0,0,'slot-1','',1,1,0,'win','1','#C73D30','https://wa-username-testing.growthdesk.dev/file/spinwin/500487933.png','{\"type\":\"text\",\"message\":\"1 Points\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(2,1,0,0,'slot-2','',1,1,0,'lose','0','#FFFFFF','https://wa-username-testing.growthdesk.dev/file/spinwin/696600712.png','{\"type\":\"text\",\"message\":\"Try again\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(3,1,0,0,'slot-3','',1,1,0,'win','1','#FFCC20','https://wa-username-testing.growthdesk.dev/file/spinwin/1993415940.png','{\"type\":\"text\",\"message\":\"1 Points\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(4,1,0,0,'slot-4','',1,1,0,'lose','0','#AACAF7','https://wa-username-testing.growthdesk.dev/file/spinwin/1049926054.png','{\"type\":\"text\",\"message\":\"Try again\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(5,1,0,0,'slot-5','',1,1,0,'win','1','#FFFFFF','https://wa-username-testing.growthdesk.dev/file/spinwin/541313044.png','{\"type\":\"text\",\"message\":\"1 Points\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(6,1,0,0,'slot-6','',1,1,0,'lose','0','#AACAF7','https://wa-username-testing.growthdesk.dev/file/spinwin/66063708.png','{\"type\":\"text\",\"message\":\"Try again\",\"font_color\":\"#EF9292\"}',1,0,NULL,NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25');

--
-- Table structure for table `dstw_slots`
--

CREATE TABLE `dstw_slots` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dstw_slots`
--


--
-- Table structure for table `es_reward_code_rewards`
--

CREATE TABLE `es_reward_code_rewards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `es_reward_code_id` bigint unsigned NOT NULL,
  `mechanism_type` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `reward_value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `es_reward_code_rewards_es_reward_code_id_foreign` (`es_reward_code_id`),
  CONSTRAINT `es_reward_code_rewards_es_reward_code_id_foreign` FOREIGN KEY (`es_reward_code_id`) REFERENCES `es_reward_codes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `es_reward_code_rewards`
--


--
-- Table structure for table `es_reward_codes`
--

CREATE TABLE `es_reward_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_inventory` int NOT NULL DEFAULT '0',
  `current_inventory` int NOT NULL DEFAULT '0',
  `date_from` datetime NOT NULL,
  `date_to` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `es_reward_codes_business_account_id_foreign` (`business_account_id`),
  CONSTRAINT `es_reward_codes_business_account_id_foreign` FOREIGN KEY (`business_account_id`) REFERENCES `business_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `es_reward_codes`
--


--
-- Table structure for table `es_reward_codes_redemption_history`
--

