
--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `percentage` decimal(5,2) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `quantity_redeemed` int DEFAULT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `coupons_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` VALUES (1,'WELCOME','WEL15',15.00,500,NULL,'active','2024-12-03 18:41:22','2024-12-03 18:41:22',NULL);

--
-- Table structure for table `email_logs`
--

CREATE TABLE `email_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `recipient` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('queued','sent','failed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'queued',
  `attempts` int NOT NULL DEFAULT '0',
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_logs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_logs`
--


--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` blob NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,'Reset Password','Reset Password',_binary '<p>Hi {{FirstName}},</p><p>You have submitted a password reset for your account. If this was not you, simply ignore this email. But if you did, click on this link {{Link}} to reset your password. If that doesn\'t work, copy and paste this link to your browser.</p><p>{{Link}}</p>','2024-08-12 05:21:48',1),(2,'Password Reset Notification','Your Password has been reset',_binary '<p>Hi {{FirstName}},</p><p>Your password has been reset successfully! You can login to your account.</p>','2024-08-12 05:21:48',1),(3,'Registration','Welcome to {{CompanyName}}',_binary '<p>Hello {{FirstName}},</p><p>I am Joe, the founder of {{CompanyName}} and I would like to extend my heartfelt welcome to you for joining our platform. We are excited to have you onboard. Feel free to explore our platform and let us know if you have any questions or need assistance. </p><p>Thank you for choosing our platform!</p><p>Best regards,</p><p>The {{CompanyName}} Team</p><p><br></p>','2024-08-12 05:21:48',1),(4,'Invite','You have been invited to join {{CompanyName}}',_binary '<p>Hello there,</p><p><span style=\"color: rgb(55, 65, 81);\">You\'ve received an invitation to join {{CompanyName}}\'s account from {{FirstName}}.</span></p><p>To get started, simply click on the following link: {{Link}}</p><p>Thank you and welcome aboard!</p><p>Best regards,</p><p>{{CompanyName}} Team </p><p><br></p>','2024-08-12 05:21:48',1),(5,'Verify Email','Please verify your email',_binary '<p>Hi {firstName},</p><p>Please verify your email by clicking on the link below.</p><p>{verificationLink}</p><p><span style=\"letter-spacing: 0em; text-align: var(--bs-body-text-align);\">Best regards,</span></p><p><br></p>','2024-08-12 05:21:48',1),(6,'Payment Success','Your subscription payment was successful',_binary '<p>Hello,</p><p>Your subscription payment was successful!</p>','2024-08-12 05:21:48',1),(7,'Payment Failed','Your subscription payment was unsuccessful',_binary '<p>Hello,</p><p>Your payment was unsuccessful, please check your payment and confirm.</p><p><br></p>','2024-08-12 05:21:48',1),(8,'Subscription Renewal','Your subscription has been renewed successfully',_binary '<p>Hi {{FirstName}},</p><p>Your subscription has been renewed successfully. </p>','2024-08-12 05:21:48',1),(9,'Subscription Plan Purchase','Your have subscribed to {{plan}} successfully',_binary '<p>Hi {{FirstName}},</p><p>You have been subscribed to the {{plan}} plan successfully.</p>','2024-08-12 05:21:48',1);

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'What is Marky?','Marky is a powerful WhatsApp marketing tool designed to help businesses engage with customers, send personalized messages, automate campaigns, and manage communications effectively through WhatsApp.',1,'2024-12-18 16:05:50','2024-12-18 16:05:50'),(2,'How do I get started with Marky?','To get started with Marky, simply sign up for an account, connect your WhatsApp Business number via the WhatsApp Cloud API, and start creating and sending campaigns with the easy-to-use interface.',1,'2024-12-18 16:06:21','2024-12-18 16:06:21'),(3,'Can I send bulk messages to multiple contacts?','Yes, Marky allows you to send bulk messages to large groups of contacts using broadcast lists. You can target specific segments to ensure personalized communication.',1,'2024-12-18 16:06:51','2024-12-18 16:06:51'),(4,'Can I send bulk messages to multiple contacts?','Yes, Marky allows you to send bulk messages to large groups of contacts using broadcast lists. You can target specific segments to ensure personalized communication.',1,'2024-12-18 16:07:23','2024-12-18 16:07:23'),(5,'Is there any limit on how many messages I can send?','The number of messages you can send depends on your subscription plan. Marky offers flexible pricing with different message volumes to suit businesses of all sizes.',1,'2024-12-18 16:07:55','2024-12-18 16:07:55'),(6,'Can I automate WhatsApp marketing campaigns?','Absolutely! Marky supports automated campaigns, allowing you to schedule messages, send reminders, or set up drip campaigns to nurture leads without manual effort.',1,'2024-12-18 16:08:48','2024-12-18 16:08:48'),(7,'What types of media can I send via Marky?','You can send a variety of media types, including text, images, videos, audio files, documents, and even product catalogs, making it easier to engage with your audience through rich content.',1,'2024-12-18 16:09:19','2024-12-18 16:09:19'),(8,'Does Marky support two-way communication?','Yes, Marky enables two-way communication, allowing your customers to reply to your messages. This feature is perfect for customer support, feedback, or personalized interactions.',1,'2024-12-18 16:10:52','2024-12-18 16:10:52'),(9,'Can I track the performance of my campaigns?','Yes, Marky provides detailed analytics and reporting. You can track delivery rates, open rates, message responses, and more to measure the effectiveness of your campaigns.',1,'2024-12-18 16:11:20','2024-12-18 16:11:20'),(10,'Do you have any cancellation fees?','No, Marky is a pay-as-you-go service, and we do not have any cancellation fees. You can cancel your plan at any time. However, we do not provide any refunds on payments made for your existing subscription or credits.',1,'2024-12-18 16:11:45','2024-12-18 16:11:45');

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'English','en','active',NULL,NULL,'2024-08-12 05:21:48','2024-08-12 05:21:48'),(2,'French','fr','active',NULL,NULL,'2024-08-12 05:21:48','2024-08-12 05:21:48'),(3,'Spanish','es','active',NULL,NULL,'2024-08-12 05:21:48','2024-08-12 05:21:48');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2019_12_14_000001_create_personal_access_tokens_table',1),(2,'2024_03_20_050200_create_auto_replies_table',1),(3,'2024_03_20_050311_create_billing_credits_table',1),(4,'2024_03_20_050348_create_billing_debits_table',1),(5,'2024_03_20_050430_create_billing_invoices_table',1),(6,'2024_03_20_050508_create_billing_items_table',1),(7,'2024_03_20_050600_create_billing_payments_table',1),(8,'2024_03_20_050635_create_billing_tax_rates_table',1),(9,'2024_03_20_050711_create_billing_transactions_table',1),(10,'2024_03_20_050751_create_blog_authors_table',1),(11,'2024_03_20_050826_create_blog_categories_table',1),(12,'2024_03_20_050912_create_blog_posts_table',1),(13,'2024_03_20_050959_create_blog_tags_table',1),(14,'2024_03_20_051036_create_campaigns_table',1),(15,'2024_03_20_051111_create_campaign_logs_table',1),(16,'2024_03_20_051154_create_chats_table',1),(17,'2024_03_20_051253_create_chat_logs_table',1),(18,'2024_03_20_051336_create_chat_media_table',1),(19,'2024_03_20_051414_create_contacts_table',1),(20,'2024_03_20_051449_create_contact_groups_table',1),(21,'2024_03_20_051537_create_coupons_table',1),(22,'2024_03_20_051613_create_email_logs_table',1),(23,'2024_03_20_051655_create_email_templates_table',1),(24,'2024_03_20_051739_create_failed_jobs_table',1),(25,'2024_03_20_051807_create_faqs_table',1),(26,'2024_03_20_051847_create_jobs_table',1),(27,'2024_03_20_051919_create_modules_table',1),(28,'2024_03_20_051953_create_notifications_table',1),(29,'2024_03_20_052034_create_organizations_table',1),(30,'2024_03_20_052107_create_pages_table',1),(31,'2024_03_20_052141_create_password_reset_tokens_table',1),(32,'2024_03_20_052223_create_payment_gateways_table',1),(33,'2024_03_20_052338_create_reviews_table',1),(34,'2024_03_20_052401_create_users_table',1),(35,'2024_03_20_052430_create_roles_table',1),(36,'2024_03_20_052513_create_role_permissions_table',1),(37,'2024_03_20_052620_create_settings_table',1),(38,'2024_03_20_052654_create_subscriptions_table',1),(39,'2024_03_20_052731_create_subscription_plans_table',1),(40,'2024_03_20_052808_create_tax_rates_table',1),(41,'2024_03_20_052839_create_teams_table',1),(42,'2024_03_20_052914_create_team_invites_table',1),(43,'2024_03_20_052920_create_ticket_categories_table',1),(44,'2024_03_20_052956_create_templates_table',1),(45,'2024_03_20_053038_create_tickets_table',1),(46,'2024_03_20_053205_create_ticket_comments_table',1),(47,'2024_04_08_133150_create_organization_api_keys_table',1),(48,'2024_04_24_211852_create_languages',1),(49,'2024_04_27_155643_create_contact_fields_table',1),(50,'2024_04_27_160152_add_metadata_to_contacts_table',1),(51,'2024_05_11_052902_create_chat_notes_table',1),(52,'2024_05_11_052925_create_chat_tickets_table',1),(53,'2024_05_11_052940_create_chat_ticket_logs_table',1),(54,'2024_05_11_053846_rename_chat_logs_table',1),(55,'2024_05_11_054010_create_chat_logs_2_table',1),(56,'2024_05_11_063255_add_user_id_to_chats_table',1),(57,'2024_05_11_063540_add_role_to_team_invites_table',1),(58,'2024_05_11_063819_update_agent_role_to_teams_table',1),(59,'2024_05_11_064650_add_deleted_by_to_organization_api_keys_table',1),(60,'2024_05_11_065031_add_organization_id_to_tickets_table',1),(61,'2024_05_28_080331_make_password_nullable_in_users_table',1),(62,'2024_05_30_125859_modify_campaigns_table',1),(63,'2024_06_03_124254_create_addons_table',1),(64,'2024_06_07_040536_update_users_table_for_facebook_login',1),(65,'2024_06_07_040843_update_chat_media_table',1),(66,'2024_06_07_074903_add_soft_delete_to_teams_and_organizations',1),(67,'2024_06_09_155053_modify_billing_payments_table',1),(68,'2024_06_12_070820_modify_faqs_table',1),(69,'2024_07_04_053236_modify_amount_columns_in_billing_tables',1),(70,'2024_07_04_054143_modify_contacts_table_encoding',1),(71,'2024_07_09_011419_drop_seo_from_pages_table',1),(72,'2024_07_17_062442_allow_null_content_in_pages_table',1),(73,'2018_08_08_100000_create_telescope_entries_table',2);

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `actions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` VALUES (1,'customers','view, create, edit, delete'),(2,'organizations','view, create, edit, delete'),(3,'billing','view'),(4,'support','view, create, assign'),(5,'team','view, create, edit, delete'),(6,'roles','view, create, edit, delete'),(7,'subscription_plans','view, create, edit, delete'),(8,'settings','general, timezone, broadcast_driver, payment_gateways, smtp, email_templates, billing, tax_rates, coupons, frontend');

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notifications_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `organization_api_keys`
--

CREATE TABLE `organization_api_keys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` bigint unsigned NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `organization_api_keys_token_unique` (`token`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organization_api_keys`
--

INSERT INTO `organization_api_keys` VALUES (1,'82309ebd-ee41-4d1c-adc2-aa704354358f',1,'zoDr9QN0J3CB9M5wmun3DEPicmgtPvAIhYCFtqDa',NULL,NULL,'2024-10-17 20:01:55','2024-10-17 20:01:55');

--
-- Table structure for table `organizations`
--

CREATE TABLE `organizations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `identifier` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `timezone` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `organizations_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` VALUES (1,'e8b4b5d4-a613-4f99-abd6-eb522c540fbc','202408130624472b2nR','Yugmedeals','{\"street\":\"1\\/48, alamaram street, kuppam village, ariyur\",\"city\":\"Vellore\",\"state\":\"Tamilnadu\",\"zip\":\"632055\",\"country\":\"India\"}','{\"whatsapp\":{\"access_token\":\"EAA2oBAHoJIYBOxT51ipD6Ql2vOFBbRr5ycQoZCPZA4ECvyZCBMV5EEFH7nUboANrKv4p83jKN7h1rmbV2X31qRONylZBuZAwDqwlMqE6NXIjRXyFRtpziTscizZApz0h3sscaVPNLtz0UhPtW8y5OZCNSZBagtijzfthp4965PGSZCmZAD4eX8n6HP8EdfliBGe8ZAMSYEimwXmVp4BY8Xf4EE06MADPNEGd0by5CUCPQvOiOtC6tgP5tHeORrKU5ImbsIT7OdatB4OgwZDZD\",\"waba_id\":\"429041796951758\",\"app_id\":\"3843909862564998\",\"phone_number_id\":\"326997097174987\",\"is_embedded_signup\":0,\"display_phone_number\":\"+91 87780 87798\",\"verified_name\":\"Yugmedeals Private Limited\",\"quality_rating\":\"GREEN\",\"name_status\":\"DECLINED\",\"messaging_limit_tier\":\"TIER_1K\",\"max_daily_conversation_per_phone\":null,\"max_phone_numbers_per_business\":null,\"number_status\":\"CONNECTED\",\"business_verification\":\"\",\"account_review_status\":\"APPROVED\",\"business_profile\":{\"about\":\"Hey there! I am using WhatsApp.\",\"address\":\"contactus@yugmedeals.com\",\"description\":\"Yugmedeals Super app\",\"industry\":\"OTHER\",\"email\":\"#164, Eriyur New street, rangapuram, vellore - 632009\"}}}',NULL,1,NULL,NULL,'2024-08-13 00:54:47','2024-11-28 13:25:01'),(2,'0378cfc0-7a00-4b50-b6a6-abe05f2212ce','202408161231303kCVK','Yugmedeals','{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','{\"whatsapp\":{\"access_token\":\"EAA2oBAHoJIYBOyZAjlekZBWQZBZCMhv50hORK8AdWhs8VzcckbdeZBZBpx3bx3i3poWomZA9rqKlw6m0UzXP7NYehqxuIabEP7StvVDWuEtPsmZAmVr38wlEo6EvZB0DRVqpm6OekZATXL0lgD3QZBqRu2xqnrTeo1YC8d6pXyajZC3SeIMdbkT2FndHBNwMdjaF2O1RM1guvSD4UiQeTMZCfIgTwixqRWxoLZBE1Uqyzn2qEz0OjhVvGCywU4Xj7vZA3g75xKegBKyR41LAQZDZD\",\"waba_id\":\"449571174913376\",\"app_id\":\"3843909862564998\",\"phone_number_id\":\"482596384935598\"}}',NULL,1,NULL,NULL,'2024-08-16 12:31:31','2024-11-08 18:44:06'),(3,'06ca15ab-f676-45a4-ae3d-58d1144b0c1e','202408170753284zqF1','Facebook Tester Private Limited',NULL,NULL,NULL,1,NULL,NULL,'2024-08-17 07:53:28','2024-08-17 07:53:28'),(4,'109eaf62-cb1e-450b-a9f8-783f56b51473','202408180751595uC1z','Armin Neimke',NULL,NULL,NULL,5,NULL,NULL,'2024-08-18 07:51:59','2024-08-18 07:51:59'),(5,'8799db11-8b6f-479e-9c58-d9cc87a7017c','2024091215133962GFy','Tester',NULL,NULL,NULL,1,NULL,NULL,'2024-09-12 15:13:39','2024-09-12 15:13:39'),(6,'44a43d90-4925-4228-b949-a47590a231ff','202410111907178Wmh7','Nothing',NULL,NULL,NULL,8,NULL,NULL,'2024-10-11 19:07:17','2024-10-11 19:07:17'),(7,'b21deda4-763e-4ea2-85e3-cc053c33caf5','202411050145479hM4W','Amber Vos',NULL,NULL,NULL,9,NULL,NULL,'2024-11-05 01:45:47','2024-11-05 01:45:47'),(8,'bfafbeeb-d9b1-4bfc-9484-6fb6da99dab9','2024112811294810bxNL','Chad',NULL,NULL,NULL,10,NULL,NULL,'2024-11-28 11:29:48','2024-11-28 11:29:48'),(9,'65a3bd01-ec2b-4a4a-ab5c-9188e21994d3','20241128113442119Ylr','Yugmedeals Official','{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','{\"whatsapp\":{\"access_token\":\"EAA2oBAHoJIYBOwnCBvta6D7UUo8plQpKJ1uETymZBsJjFZBSlRTpQ3IMN19PvZA3OovbQuW1z9NPp5ioCczYXhWNuaKz914tPTwdOyZBWEX1n4Fq2tCAU1p4ZB9pvSkCmok486UwmT2KUy75S0WoavvwNAPLGYFhu1wP3mfXGRwpgI7onOkHEnwGAVMtGQqvtIyQjZAW3jkaEHBA0nTlzQCuVbJsKIVIY8UczZB8rbydp3PhzkLQVIFRtbUV3bWAb8MtJUxESudqwZDZD\",\"waba_id\":\"498904336639927\",\"app_id\":\"3843909862564998\",\"phone_number_id\":\"507203362474232\",\"is_embedded_signup\":0,\"display_phone_number\":\"+91 75989 82975\",\"verified_name\":\"Yugmedeals\",\"quality_rating\":\"GREEN\",\"name_status\":\"APPROVED\",\"messaging_limit_tier\":\"TIER_1K\",\"max_daily_conversation_per_phone\":null,\"max_phone_numbers_per_business\":null,\"number_status\":\"CONNECTED\",\"business_verification\":\"\",\"account_review_status\":\"APPROVED\",\"business_profile\":{\"about\":\"Hey there! I am using WhatsApp.\",\"address\":null,\"description\":null,\"industry\":\"RETAIL\",\"email\":null}}}',NULL,11,NULL,NULL,'2024-11-28 11:34:42','2024-12-02 14:01:52'),(10,'dbc41e9c-2272-4a94-ad21-c3dc89e6d944','2024120215202812dShQ','Sri Chaitanya Poonamalle','{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','{\"whatsapp\":{\"access_token\":\"EAA2oBAHoJIYBO6vDvpaGlDZC2EeZAY7gaxPCJZAeR2O3Q4CFjDpywvu9XkWqqEd3vZCbdeinquhNNRvxdeVJZAb7ZC0CNRI1SiUePNr6h6IWrCZAxMzy4UGMDB2v1UcCOsjMsZA071F9UAQoyLoqeQAgKiNZAyZAChu4iBYA1FxJUSFb3qBbIN6QL1KZBmnQivUoGPZBdroZCvOGxLSCQosB2ZBLcRDX5VTfUZAKe4ZA9hNwKx8cfeZC8vrvk28m9ZADj2WJX4\",\"waba_id\":\"535498432969368\",\"app_id\":\"3843909862564998\",\"phone_number_id\":\"509893748871965\",\"is_embedded_signup\":0,\"display_phone_number\":\"+91 7397 752 882\",\"verified_name\":\"Sri Chaitanya Senior Secondary School\",\"quality_rating\":\"UNKNOWN\",\"name_status\":\"AVAILABLE_WITHOUT_REVIEW\",\"messaging_limit_tier\":\"TIER_250\",\"max_daily_conversation_per_phone\":null,\"max_phone_numbers_per_business\":null,\"number_status\":\"CONNECTED\",\"business_verification\":\"\",\"account_review_status\":\"APPROVED\",\"business_profile\":{\"about\":\"Hey there! I am using WhatsApp.\",\"address\":null,\"description\":null,\"industry\":\"EDU\",\"email\":null}}}',NULL,12,NULL,NULL,'2024-12-02 15:20:28','2024-12-05 11:32:51'),(11,'392ee719-8c1a-4e05-9ba1-42fb46386023','2024120416574913mhRi','Codevinez',NULL,NULL,NULL,13,NULL,NULL,'2024-12-04 16:57:49','2024-12-04 16:57:49'),(12,'783024cd-90a9-4788-baaa-11560f8faec0','2024120513442314soqA','Codevinez',NULL,NULL,NULL,14,NULL,NULL,'2024-12-05 13:44:23','2024-12-05 13:44:23'),(13,'52d3bf09-70f3-4e3c-8ae5-cc2a2b04fa6e','2024121715032415VTo9','Mohan Private Limited',NULL,'{\"tickets\":{\"active\":false,\"auto_assignment\":false,\"reassign_reopened_chats\":false,\"allow_agents_to_view_all_chats\":false}}',NULL,15,NULL,NULL,'2024-12-17 15:03:24','2024-12-17 16:59:11');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Privacy Policy','<p><strong>Privacy Policy</strong></p><p>Thank you for being a part of  Yugmedeals Marky - a product by Yugmedeals Private Limited. Your privacy is important to us.</p><p>Please read the following statement to learn about our information gathering and dissemination practices.</p><p><br></p><p><strong>SCOPE:</strong></p><p>Yugmedeals Private Limited (hereinafter referred to as “the Company”, “we”, “our”, “us”) inter alia, offers a suite of messaging software-as-a-service solutions through a single platform to enable its customer to manage communications with their users under the name and style of “Yugmedeals Marky - a product by Yugmedeals Private Limited” (hereinafter referred to as “Solution”) as a service to its customers, in order to enhance their user support through quicker responses and more efficient internal processes. The Solution is committed to protecting and respecting your privacy. This policy (“Privacy Policy”), together with the terms and conditions, available at [https://whatsapp.yugmedeals.com/pages/privacy-policy], and all other policies listed as part of the Solution, outlines the privacy practices of the Solution regarding collection, use and safeguard of your information through the Solution and the services offered thereupon. By using, registering or signing up for the Solution, you accept the terms of this Privacy Policy. If you do not accept any of these terms, your usage of the Solution will be restricted. Your clicking of the “ agree” button and submission of personal information or if you are a minor, the submission of your personal information either by your parents (or your legal guardian) or by you with the permission of your parents (or legal guardian) to the Solution will be deemed as your acceptance of this Privacy Policy and agree to be contacted by us to inform you about products and/or services and/or upcoming benefits offered by us or any of our affiliates or any other sub- domains. This Privacy Policy is an electronic record in terms of the Information Technology Act, 2000 (as amended/re-enacted from time to time) (“IT Act”) and rules thereunder, and, amongst others, is published in accordance with the provisions of Rule 3 (1) of the Information Technology (Intermediaries Guidelines) Rules, 2011, which mandates for publishing of rules and regulations, privacy policy and terms of use for access or usage of the Solution. This Privacy Policy is an electronic record, generated by a computer system and does not require any physical or digital signatures</p><p><br></p><p><strong>CHANGES TO THE PRIVACY POLICY:</strong></p><p>We will treat your information in accordance with applicable laws and regulations of India. This Privacy Policy is subject to modification(s) based on business, legal or regulatory requirements and will be updated online from time to time. We will make all efforts to communicate any significant changes to this Privacy Policy to you. You are encouraged to periodically visit this page to review the Privacy Policy and any changes to it. Your continued participation in the Solution after any modification(s) to this Privacy Policy will be deemed as your acceptance to such modification(s).</p><p><br></p><p><strong>PERSONAL INFORMATION WE COLLECT:</strong></p><p>“Personal information” is defined as information that can be used to identify you and may include details such as your name, age, gender, contact information and details, incoming/outgoing messages, business information, products and services you are interested in or require more information about. Insofar as sensitive personal information is concerned, it will carry the meaning as may be defined by applicable laws from time to time.</p><p>We collect, use and share your personal information in the following manner:</p><p><br></p><p><strong>Collection</strong></p><p>We may collect your personal information, whenever relevant, to provide you with the services and/or complete any transaction or provide any product you have requested or authorized under the Solution. You also consent to the collection of certain personal information in the course of your applying for the products and/or services with regards to the Solution.</p><p><br></p><p><strong>Usage</strong></p><p>We seek this personal information either to (a) validate and process your request for the usage of the Solution; or (b) assist the Company and/or any of its affiliates to handle and fulfill your orders and/or transactions, if any, or (c) to communicate details of any allied products and/or services and/or transaction to any third party; or (d) improve the quality of the Solution; or (e) assist you in determining the services/products best suited for your needs; or (f) facilitate our internal business operations, including the fulfilment of any legal and regulatory requirements; or (g) provide you with recommendation about services/products you may be interested in, based on your participation in the Solution; or (h) provide you with marketing communications and advertising that we believe may be of interest of you; or (i) resolve disputes or troubleshooting problems; or (j) detect and protect us against any error, fraud and other criminal activity; or (h) enforce our terms and conditions; or (i) as otherwise described to you at the time of collection.</p><p><br></p><p><strong>Sharing</strong></p><p>We may disclose your personal information to our affiliates when necessary (a) to provide the services on our behalf or on your behalf in relation to the Solution; or (b) to display advertising and promotional services; or (c) to provide search results and links (including paid listings and links); or (d) to provide efficient customer service. Please note that our entities and affiliates may market to you as a result of such sharing. If you wish to opt-out of any such sharing, do email us on contactus@yugmedeals.com. We may disclose your personal information to any third parties. This disclosure may be required for us to provide you and such third parties to provide services under the Solution or for enhancing your experience, or to comply with our legal obligations. We may also share your personal information with external organizations or individuals if we believe that such access, usage, preservation or disclosure of the personal information is reasonably necessary to:</p><p><br></p><p>(a) meet any applicable law, regulation, legal process or enforceable governmental request;</p><p><br></p><p>(b) detect, prevent or otherwise address fraud, security or technical issues;</p><p><br></p><p>(c) protect against any harm to rights, property or safety of our customers or the public, as required or permitted by applicable laws in India.</p><p><br></p><p><strong>‍NON-PERSONAL INFORMATION WE COLLECT:</strong></p><p>Non-personal information is defined as any information that does not personally identify you and may include unique system or hardware identifiers, system or application software, and peripherals. Any non-personal information, when clubbed with personal information shall be treated as personal information. The following is the manner in which we collect, use and share non-personal information.</p><p><br></p><p>Collection:</p><p>You agree that the Solution may collect diagnostic, technical, usage related information, for the usage purposes described below, or communicated to you at the time of collection. This information, once collected, is anonymized in a manner that does not personally identify you.</p><p><br></p><p>Usage:</p><p>The non-personal information is gathered periodically to provide and improve the Solution and services therein, facilitate the provision of software updates, product support and other services to you (if any) and to verify compliance with the terms of this Privacy Policy. As non-personal information does not personally identify you, we may use and disclose non-personal information at our discretion, subject to applicable laws.</p><p><br></p><p>Sharing:</p><p>To enable the Solution partners and Third Party Service Providers to improve their software, hardware and services designed for use with the Solution, we may also provide any such partner or Third Party Service Providers with a subset of diagnostic information that is relevant to such partner’s or Third Party Service Provider’s software, hardware and/or services, as long as the diagnostic information is in a form that does not personally identify you.</p><p><br></p><p>Cloud API:</p><p>WhatsApp Infrastructure means WhatsApp Enterprise Client deployment which helps communication between users and the Yugmedeals Marky platform.</p><p><br></p><p>The Client hereby confirms and agrees that upon sharing the data on the WhatsApp infrastructure, all the data shared by the Client in relation to the WhatsApp messaging will now reside on Cloud API\'s (\"Data Residence\"), a Meta Product.</p><p><br></p><p>It is further understood and accepted that any Client data previously routed &amp; stored on WhatsApp infrastructure i.e. for the purpose of messaging/notification on WhatsApp, the WhatsApp infrastructure shall henceforward be migrated to the data centers which are currently located in North America and European Union via Cloud API service by Meta.</p><p><br></p><p>For the purpose of the provision of services under this Agreement, the Client hereby acknowledges that for the WhatsApp infrastructure data localization is not offered by the Company for any such data shared or obtained by the Company in the process of providing the WhatsApp messaging to the Client.</p><p><br></p><p><strong>‍LOCATION SERVICES:</strong></p><p>The Solution, its licensees and agents, may access, collect and analyse your participation in the Solution and usage of the Solution therein and other information related to your location on a regular basis through Bluetooth and Wi-Fi signals and other technologies and data for the performance of the services provided by the Solution and to help improve the design, functionality, performance, and content of the Solution. In order to collect geo-location information, the location settings must be enabled on your device. Therefore, in some cases, the device may request that you enable the location settings. Except in cases where any specific services requested by you require or involve personal identification, the Solution collects location data anonymously and in a form that does not personally identify you. By using the Solution, you agree and consent to transmission, collection, maintenance, processing and use of your location data and queries to provide and improve such services of the Solution.</p><p><br></p><p><strong>COOKIES:</strong></p><p>We place both permanent and temporary cookies in your device in relation to the Solution. Information collected by cookies and other technologies are treated as non-personal information. However, to the extent that IP addresses or similar identifiers are considered personal information by local law, we treat any information linked to such identifiers as personal information. Similarly, to the extent that non-personal information is combined with personal information, we will treat the combined information as personal information.</p><p><br></p><p><strong>OTHER INFORMATION THE SOLUTION COLLECTS:</strong></p><p>The Solution may also collect other information about you in ways that the Solution describe to you or otherwise with your consent. You can choose not to provide us with certain types of information, but doing so may affect your ability to avail and/or use some services.</p><p><br></p><p>THIRD PARTY SERVICES, THIRD PARTY APPLICATIONS, WEBSITES &amp; SERVICES:</p><p>Third Party Services shall mean the third party services made available by the Company under the Solution including but not limited to WhatsApp business platforms and the term “Third Party Service Provider” shall mean the provider of such Third Party Services. The Solution may include links to other websites/applications or any of its sub domains or website/applications of any Third Party Service Providers or may display advertisements from such Third Party Service Providers and other content that links to Third Party Services. Such Third Party Services are governed by their respective privacy policies, which are out of our control. Once you leave our servers, use of any information you provide is governed by the privacy policy of the operators of the Third Party Services you are visiting and such policies may differ from this Privacy Policy. If you can\'t find the privacy policy of any of the Third Party Service Providers, you must contact the relevant website /application of such Third Party Service Providers directly for more information. We shall not be responsible for the privacy practices or the content of such Third Party Services. We shall not be liable for the services provided by the Third Party Service Providers, on the Solution. You shall assume all risks arising out of or resulting from any transaction undertaken by you with such Third Party Service Providers on the Solution and you agree and acknowledge that the Company shall not be responsible or liable for any losses arising out of your usage of such Third Party Services. We may use third party advertising companies to serve ads when you visit the Solution. Please note that any Third Party Services you access as a part of the Solution, may also collect, use and share information about you and your usage. We cannot control how these Third Party Service Providers collect, use, share or secure this information. These Third Party Service Providers who collects, processes, shares, uses, retains your personal and/or usage related information or with whom such information is shared pursuant to contractual obligations shall be solely responsible for such usage and liability, if any.</p><p><br></p><p><strong>ACCESS, CORRECTION AND DELETION:</strong></p><p>We strive hard to keep our records updated and accurate with your latest information. You shall be responsible to ensure that the information or data you provide from time to time is and shall be correct, current and updated and you have all the rights, permissions and consents to provide such information or data. You may note that deletion of certain information or withdrawal of consent may lead to cancellation of your access to the Solution or your access to certain features and services of the Solution. Additionally, we may not be able to process your request of correction, updating or deletion, in case the same is not supported by valid documents or data retention is required by the applicable law or law enforcement requests or under any judicial proceedings or it is extremely difficult to implement (such as requests related to backup copies or if a new system is required to process the request or change of technical design) or risks the privacy of other users.</p><p><br></p><p><strong>PROCESSING OF THE INFORMATION</strong></p><p>We along with our affiliates or Third Party Service Providers with whom we have entered into contractual arrangements may also process any personal and/or usage related information collected from you for legitimate commercial purposes including providing the aforementioned services for the Solution, unless you explicitly opt out. Doing so may affect your ability to avail and/or use the Solution.</p><p><br></p><p><strong>WAIVER OF LIABILITY</strong></p><p>Notwithstanding anything contrary mentioned in this Privacy Policy, we shall not be liable for any indirect, incidental, consequential, special or exemplary damage(s) arising due to loss of data or use arising out of or in connection with your access or use of or inability to access or use the Solution including but not limited to any sub-domains or any Third Party Services.</p><p><br></p><p><strong>QUERIES AND COMPLAINTS:</strong></p><p>We are committed to protect your personal information collected and processed by us and look forward to your continued support for the same. In case of any feedback or concern regarding protection of your personal information, or any privacy-related feedback or concerns you may contact the Data Protection officer Kiran at  grievance@yugmedeals.com or at contactus@yugmedeals.com for any other clarification.</p>','2024-12-18 15:03:33','2024-08-12 05:21:48'),(2,'Terms of Service','<p><strong>Terms &amp; Conditions</strong></p><p>IMPORTANT. READ CAREFULLY.</p><p>These terms and conditions for software licensing and its services (“Terms of Use”), is a legal agreement between \"<strong>Yugmedeals Marky</strong>\" (\"A unit of Yugmedeals Private Limited\") , (CIN U52100TN2021PTC144844), a company incorporated under the laws of India with its registered office at 101, Saffron, Nr. Centre Point, Ambawadi, Ahmedabad, Gujarat, whether acting on behalf of itself and/or on behalf of any of its affiliates and/or its third party suppliers and/or its licensors and/or service providers (hereinafter referred to as “Company” or “Our” or “Us”) and merchants (whether an individual or a legally recognized entity) involved in any lawful business for provision of any services or goods, across the territory of India (“Client”, “You” or “Your”).</p><p><br></p><p>‍ The Company, \"<strong>Yugmedeals Marky</strong>\" (\"A unit of Yugmedeals Private Limited\"), offers a suite of messaging software-as-a-service solutions through a single platform to enable its customer to manage communications with their users under the name and style of “Yugmedeals Marky” (“A unit of Yugmedeals Private Limited”). ‍</p><p><br></p><p>‍ The Company may, at its sole discretion, authorize such persons from time to time, who shall carry out all or any of its rights, duties and obligations under these Terms of Use and any reference to “Yugmedeals Private Limited” under these Terms of Use shall be construed to mean and include any such persons duly authorised and acting on behalf of the Company. ‍</p><p><br></p><p>‍ These Terms of Use are an electronic record in terms of the Information Technology Act, 2000, the applicable rules thereunder and the provisions pertaining to electronic records in various statutes as amended by the Information Technology Act, 2000. These Terms of Use are generated by a computer system and does not require any physical or digital signatures. ‍</p><p><br></p><p>‍ These Terms of Use are published in accordance with the provisions of Rule 3 (1) of the Information Technology (Intermediaries Guidelines) Rules, 2011 that require publishing of the rules and regulations, privacy policy and terms of use for access to or usage of any electronic devices and services.</p><p><br></p><p>BY USING THE SOLUTION, THE CLIENT ACCEPTS THE TERMS OF THESE TERMS OF USE AND ANY ADDENDUM OR ANNEXURE BEING PART OF THESE TERMS OF USE. IF THE CLIENT DOES NOT ACCEPT THESE TERMS, THE CLIENT SHOULD NOT USE THE SOLUTION. THE COMPANY MAY MODIFY OR UPDATE THESE TERMS OF USE FROM TIME TO TIME AND THE SAME SHALL BE MADE AVAILABLE AT [https://whatsapp.yugmedeals.com/pages/terms-of-service<a href=\"https://whatsapp.yugmedeals.com/pages/terms-of-service\">]</a> FOR ACCESS BY THE CLIENT.</p><p><br></p><p><strong>DEFINITIONS:</strong></p><p>In these Terms of Use, (i) capitalised terms defined by inclusion in quotations and/or parenthesis have the meanings so ascribed; and (ii) the capitalised terms as set out below shall have the meanings as indicated therein. In these Terms of Use, the headings are for convenience only and shall not in any way define or limit the scope.</p><p><br></p><p>“Applicable Law” means and includes all applicable Indian statutes, enactments, acts of legislature or parliament, laws, ordinances, rules, bye-laws, regulations, notifications, guidelines, policies, directions, directives and orders of any governmental authority or self-regulatory agency, statutory authority, tribunal, board, court in India.</p><p><br></p><p>“Applicable Data Protection Law” refers to all relevant laws, regulations, and guidelines issued by the Indian government related to aspects such as privacy, data processing, data protection, data security, encryption, or confidentiality. This includes, but is not limited to, the Indian Information Technology Act, 2000. The parties acknowledge and agree that when the Digital Personal Data Protection Act (DPDPA) of 2023 is introduced and enforced, the Applicable Data Protection Law will be updated to replace the IT Act, 2000 with the DPDPA, 2023, and shall apply retrospectively.</p><p><br></p><p>“Beta Products” means a pre-released version of the Solution or any of its components circulated to you to try under realistic conditions which are not pre-simulated.</p><p><br></p><p>“Business Day” shall mean any day other than Saturday, Sunday or any public holidays, on which the banks in Vellore, Tamil Nadu are open for business.</p><p><br></p><p>“Intellectual Property” means and includes all intellectual property, in any part of the world, whether registered or not registered, and in particular (i) all trademarks, service marks, trade names, logos, domain names; patents, design rights; trade secrets, including, know-how, technology, formulae, industrial and commercial information, techniques and inventions; processes, manuals, documentation, and technical data and information; copyrights, works of authorship, and topography rights, database rights; computer hardware and software including source code, computer programs, user interfaces, software applications, software platform or infrastructure and any other information in relation to the above; (ii) all rights under licenses in respect of all of the above; (iii) any applications or registrations for the protection of all of the rights specified at sub-clause (i) and (ii) herein above; and (iv) all renewals and extensions thereof; and the term “Intellectual Property Rights” shall be construed accordingly.</p><p><br></p><p>“Personal Data” means any information relating to an identified or identifiable natural person or that is otherwise considered personally identifiable information, personal information, or personal data under Applicable Data Protection Law.</p><p><br></p><p>“SaaS” means software as a service.</p><p><br></p><p>“Subscription Commencement Date” means the date on which the Client accepts and acknowledges these Terms of Use.</p><p><br></p><p>“Scheduled Maintenance” means the Company’s scheduled routine maintenance of the Solution for which the Client shall be notified at least two (2) hours in advance and shall not exceed eight (8) hours per week.</p><p><br></p><p>“Third Party Services” means the third-party services made available by the Company under the Solution including but not limited to WhatsApp.</p><p><br></p><p>“Update” means the modifications or revisions made to the Solution: (i) to improve upon or repair existing features and operations within the Solution; (ii) to ensure compatibility with new releases of existing systems (including hardware, operating systems and middleware) and external services through standardized interfaces; (iii) to comply with Applicable Laws, regulations, industry standards or market practice, other than an Upgrade.</p><p><br></p><p>“Upgrades” means new versions of the Solution intended to enhance the functionality of the Solution and that may change the version number of such Solution.</p><p><br></p><p><strong>TERM:</strong></p><p>These Terms of Use are effective until terminated in accordance with the terms set forth herein (“Term”) and will be automatically renewed beyond the Term (“Auto Renewal”), upon the same terms and conditions as set forth herein, unless expressly revoked by the Client in writing.</p><p><br></p><p><strong>GRANT OF LICENSE:</strong></p><p>During the Term, in consideration of payment of the Fees by the Client to the Company and subject to the terms and conditions herein, the Company grants to the Client, a limited, non- exclusive, personal, revocable, non- transferable and non- licensable license to access and use the Solution on a subscription basis, in accordance with these Terms of Use. Nothing contained herein shall be construed as creating any arrangement for transfer of title, ownership or interest including rights under any Intellectual Property in or of the Solution in favour of the Client.</p><p><br></p><p>The Solution shall be made available by the Company to the Client as a service on a SaaS model, whereby the Company will provide the Client access to the Solution by hosting the Solution on a centrally hosted system, to which the Client will be given necessary access. The Company reserves for itself all other rights and interests not explicitly granted under these Terms of Use. The Client’s subscription to the Solution shall commence on the Subscription Commencement Date, irrespective of the Trial Period. The Client agrees and acknowledges that any delay in implementation of the Solution that can be attributed to the Client, illustratively, due to non-provision or delay in provision of any material, information or documents requisitioned by the Company for the purposes of implementing the Solution, will not result in any change of the Subscription Commencement Date and will be liable to pay the Fees in accordance with the terms set out in these Terms of Use.</p><p><br></p><p>Notwithstanding the foregoing, the Client acknowledges and agrees that the use of the Solution shall be subject to such additional terms and conditions and privacy policy, as may be applicable thereto and available at [https://whatsapp.yugmedeals.com/pages/privacy-policy], including any updates thereto from time to time. For avoidance of doubt, these Terms of Use shall be in addition to and not in derogation of any terms and conditions and privacy policy applicable to the Solution. Such terms and conditions and the privacy policy applicable shall be read into and shall form an integral part of these Terms of Use.</p><p><br></p><p><strong>LICENSE AND USE OF SOLUTION :</strong></p><p>For availing the Solution, the Client hereby expressly consents and agrees to provide all information, including any applicable documents required by the Company, including Client’s identity, address and payment details, to the Company, from time to time.</p><p><br></p><p>‍ The Client acknowledges and agrees that the Solution provided under these Terms of Use, during the Term is non- exclusive in nature and that the Company shall be entitled, at all times, to deal with the Solution in any manner it deems fit which includes provision of services using the Solution by itself or any variation, Update or Upgrades through any third party, from time to time. At any time, the Solution shall include all modifications, Updates, future or new Upgrades, additions, at the sole discretion of the Company. It is hereby clarified that the Client’s continued use of the Solution pursuant to any such Updates and Upgrades will be considered deemed acceptance of such Updates and Upgrades. ‍</p><p><br></p><p>The License granted under these Terms of Use is only for the limited use of the Solution by the Client for its business operations and shall not include, without limitation, the right to:</p><p><br></p><p>(a) license, sublicense, sell, resell, transfer, assign, distribute or otherwise commercially exploit or make available to any third party the Solution or the content in any way;</p><p><br></p><p>(b) circumvent or disable any security or other technical features of the Solution;</p><p><br></p><p>(c) modify, reproduce or make derivative works based on the Solution or the content;</p><p><br></p><p>(d) create internet “links” to the Solution or “frame” or “mirror” any content on any other server or wireless or internet-based device;</p><p><br></p><p>(e) reverse engineer or access the Solution for any purpose whatsoever, including without limitation, to (i) build a competitive product or service, (ii) build a product using similar ideas, features, functions or graphics of the Solution; or (iii) to copy any ideas, features, functions or graphics of the Solution; or</p><p><br></p><p>(f) use the Solution for any purpose other than in connection with the Client’s internal business operations.</p><p><br></p><p>The provisions of this Clause 5 (License and Use of Solution) constitute a material term under these Terms of Use; the breach of which by the Client shall constitute an immediate and material breach and termination hereof. The Client agrees that the use of the Solution, or any part thereof, by any party other than the Client will not be permitted, unless specifically approved by the Company in writing. ‍</p><p><br></p><p><strong>IMPORTANT:</strong> Client will need to maintain access and be solely responsible for the registered SIM card and will need to present the same in cases of emergencies in no longer than 30 minutes.‍</p><p><br></p><p>The Solution shall, inter alia, consist of the following components:</p><p><br></p><p>(a) Client Data. The Solution shall be structured entirely on the Company’s proprietary platform under the name and style [‘Yugmedeals Marky’] and shall integrate within various information and inputs in relation to the business and user/ customer details of the Client, as provided to Company on the Subscription Commencement Date, or at any time during the usage of the Solution.</p><p><br></p><p>(b) Inbox Dashboard: The Client shall have access to its ‘Inbox Dashboard’, a web-based messaging application forming part of the Solution wherein the messages sent by the Client’s users is automatically visible to the Client in their messaging application such as WhatsApp/WhatsApp Business.</p><p><br></p><p>(c) Support and Assistance: The Company shall provide prompt support and assistance to the Client in case of any exigencies, breakdown, error or deficiency in the Solution that may affect the use of the Solution by the Client.</p><p><br></p><p>(d) Early Access to Beta Products: The Company may reach out to the Client in the event of testing any Beta Products, with a written request to the Client. Such early access to the Beta Products shall be made available to the Client on an ‘as is’, and ‘as available’ basis and to the extent permitted under Applicable Laws, without any warranties, representations, indemnities, or contractual commitments of any kind.</p><p><br></p><p><strong>RIGHTS AND OBLIGATIONS OF THE CLIENT :</strong></p><p>‍(i) Client’s unauthorised access: The Client shall take all reasonable measures to ensure that the information transmitted to or from the Company servers are secure and shall not authorise any third person to have any unauthorized access to the Company servers. The Client may authorize any of its personnel to use the Solution and must ensure that such authorised personnel follows reasonable security measures as would have been followed by the Client itself and in case of any default on the part of such authorised personnel shall be deemed to be a default by the Client under these Terms of Use.</p><p><br></p><p>(ii) Client Compliance with the law: The Client shall ensure that it has taken all necessary approvals, licenses from concerned authority(ies) within or outside the territory for utilizing the Solution from the Company. The Client shall be liable for any default committed by it or by any of its personnel, employees, consultants and any other personnel authorised on its behalf and shall be solely responsible for any claims or liabilities that may arise on account of any such default.</p><p><br></p><p>(iii) Client Cooperation: The Client shall cooperate with the Company for any integration, as may be required under these Terms of Use into its system and shall provide the Company unfettered access to its systems and computing platform as and when required.</p><p><br></p><p>(iv) Client Payment: The Client shall pay any and all payments due under these Terms of Use, as and when requested by the Company.</p><p><br></p><p>(v) Trial Period: In furtherance of the Company’s efforts to ensure client satisfaction, the Client shall, for usage of the Solution, may be placed on trial for a period of 7-14 days (“Trial Period”) from the Subscription Commencement Date and may be entitled to a limited/ complete use of the Solution for such Trial Period. The rights and obligations set out in these Terms of Use shall also apply to the use of the Solution during the Trial Period. The Client shall be entitled to terminate these Terms of Use on or before the expiry of the Trial Period, without payment of any Subscription Fees. However, on the expiry of the Trial Period, the Client shall be automatically charged for the Subscription Fees and/or the Usage Fees, as the case may be.</p><p><br></p><p><strong>LICENSE FEE AND PAYMENT TERMS :</strong></p><p><br></p><p>In consideration of grant of License, the Client shall pay the Company, the payments as set out below:</p><p><br></p><p>(a) Subscription Fee : The subscription period of the Solution shall commence from the Subscription Commencement Date and shall continue until the Subscription End Date, unless agreed otherwise between the Parties. On the Subscription Commencement Date, the Client agrees to provide appropriate details for the Company to process the payment of a non-transferable, non-refundable fee for subscribing the Solution, at the end of the Trial Period. The Client shall make the payment of the amount as indicated by the Company for the License of the Solution (“Subscription Fees”).</p><p><br></p><p>(b) Usage Fee : In addition to the Subscription Fee as set forth above, the Client shall also be required to recharge their Wallet as per their needs in order to send and receive conversation messages from their connected WhatsApp Business API number on Yugmedeals Marky as per conversation messaging charges defined in Yugmedeals Marky pricing page. Wallet Recharges are non-transferable and non-refundable. (“Usage Fees”). (The Subscription Fees and the Usage Fees shall hereinafter collectively be referred to as “Fees”).</p><p><br></p><p>All payments stipulated under these Terms of Use are exclusive of all government levies and taxes and all applicable taxes and charges payable on the Fees, including any goods and service tax, shall be borne by the Client at all times. The Client shall additionally bear to its own account all other taxes, as may be applicable, for payments made to the Company pursuant to these Terms of Use. The Client shall comply with all filing formalities and requirements in respect of any tax withholdings to be made, including the filing of withholding tax return as prescribed under the applicable tax laws and issue to the Company, a certificate for tax deducted or paid on its behalf at source in the form of a certificate issued in accordance with applicable tax laws. The Client shall make best efforts to ensure that the Company gets credit for any tax deducted and provide to the Company, all information that is necessary to assist the Company in connection with its tax and statutory obligations.</p><p><br></p><p><strong>General Payment Terms:</strong></p><p>The Client agrees that all payments required to be made by the Client to the Company under these Terms of Use shall be in accordance with the following terms: (a) The Client’s obligation to pay the amounts stipulated under these Terms of Use is absolute and shall not be negated by the Company not raising an invoice.</p><p><br></p><p>(b) The Client shall pay the Subscription Fee, immediately or at the end of the Trial Period as applicable; and (ii) the Usage Fee by the 5th (Fifth) day of every month for the work performed in the previous month.</p><p><br></p><p>(c) The Company shall have the right to suspend the Client’s access and use of the Solution, if the Usage Fee has not been paid within a stipulated time period indicated by the Company.</p><p><br></p><p>(d) In the event of any payment default by the Client in making any payment (whether in whole or part), the pending amount due from such Client, shall be subject to interest from the stipulated due date until the date of repayment, at a rate equal to 2% (two percent) per month (i.e. 24% (twenty four percent) annually) or the maximum allowed under Applicable Law, whichever is lesser.</p><p><br></p><p><strong>REPRESENTATIONS AND WARRANTIES </strong></p><p><br></p><p>Each Party hereby represents and warrants to the other that:</p><p><br></p><p>it is duly incorporated and validly existing under the Applicable Laws; it has taken all actions including any corporate actions necessary to execute, deliver and to perform obligations under these Terms of Use; it has obtained all the statutory approvals/ permissions/ no objections as necessary and required under the Applicable Law for carrying on its activities and related services; there are no judicial or administrative actions, proceedings or investigations pending or, to the best of its knowledge after due inquiry, overtly threatened against it, which would have a materially adverse effect on its capacity to perform the obligations under these Terms of Use; it is not subject to the obligations under any contract as a consequence of which it may be in breach of its obligations and covenants contained in these Terms of Use.</p><p><br></p><p>In addition to the general representations as set out above, the Client, further represents and warrants as follows:</p><p><br></p><p>it possesses the financial ability to make payment of Fees in relation to the Solution; it has procured and shall at all times during the Term continue to hold, all applicable and necessary third party approvals/consents, governmental approvals, registrations, authorizations, licenses, permits and any other permissions whatsoever required under the Applicable Law to utilize the Solution; and it is as on the Subscription Commencement Date e, and shall at all times during the Term continue to be, in full compliance with all Applicable Laws, including the Applicable Data Protection Laws.</p><p><br></p><p><strong>RIGHT TO SUSPEND CLIENT’S ACCESS TO THE SOLUTION</strong></p><p><br></p><p>(i) Company’s right to suspend access to the Solution: The Company may suspend the Client’s right to access or use any portion or all of the Solution immediately without notice to the Client if it determines that:</p><p><br></p><p>The Client’s use of the Solution: (i) poses a security risk to the Company, the Solution or any third party or; (ii) may adversely impact Company’s other services and products including the Solution or the systems or content of any of other customers of the Company; (iii) may subject the Company or its Affiliates, or any third party to liability; or (iv) may be fraudulent; The Client is in breach of these Terms of Use, including if the Client is delinquent on its payment obligations as stipulated under Clause 7 (License Fee and Payment Terms); or The Client ceases to operate in the ordinary course, has made an assignment for the benefit of creditors or similar disposition of assets, or become the subject of any bankruptcy, reorganization, liquidation, dissolution or similar proceeding.</p><p>(ii) Effect of suspension: If the Company suspends the Client’s right to access or use any portion or all of the Solution in accordance with Clause 9(i) above;</p><p><br></p><p>The Client shall remain responsible for all Fees incurred through the date of suspension; The Client shall remain responsible for all applicable Fees for any portion of the Solution to which the Client continues to have access, as well as any applicable data storage fees and charges, and fees and charges for in-process tasks completed and incurred through the date of suspension; The Company shall not erase any of the Clients’ content or data, uploaded prior to such suspension, as a result of suspension, except as specified elsewhere in these Terms of Use. The Company’s right to suspend the Client’s right to access or use the Solution is in addition to the Company’s right to terminate these Terms of Use pursuant to Clause 12 (Termination of the Agreement) herein.</p><p><br></p><p><strong>CONFIDENTIALITY</strong></p><p><br></p><p>(i) Definition and Exclusions:(a) For purpose of these Terms of Use, “Confidential Information” shall include any and all confidential and proprietary information or material (including information, data and materials relating to current or prospective products and processes) made available (whether intentionally or otherwise) to a Party or its affiliates or subcontractors, or its or its affiliates’ or its subcontractors’ employees, agents and other representatives, by or on behalf of the other Party and relating to the business, operations, affairs, technologies, plans and strategies of such other Party, whether observed or provided orally, in written, graphic or electronic form, or in the form of samples, and whether or not marked, labeled or otherwise identified as “confidential,” “secret” or “proprietary” (it being acknowledged and agreed that the existence and terms of these Terms of Use will be considered to be Confidential Information as to both Parties).</p><p>(b) Notwithstanding above, the Confidential Information does not include any information or items that: (i) were generally available to the public, or otherwise part of the public domain, when received by the receiving Party; (ii) become generally available to the public, or otherwise becomes part of the public domain, other than through breach of these Terms of Use; (iii) can be demonstrated by the receiving Party to have already been in its possession, or otherwise known by it, prior to the time of receipt from the disclosing Party; (iv) are received by the receiving Party from a third Party that is (1) in lawful possession thereof; and (2) under no confidentiality obligation to the disclosing Party; or (v) are independently developed by the receiving Party without use of the Confidential Information of the disclosing Party that has or could have commercial value or other utility in disclosing Party’s business and is treated with confidentiality.</p><p><br></p><p>(ii) Disclosure of Confidential Information</p><p><br></p><p>Each Party hereby agrees and acknowledges that it shall:</p><p>(a) use the same level of care to prevent disclosure of the Confidential Information of the disclosing Party to any third parties as it employs to avoid disclosure, publication, or dissemination of its own information of a similar nature, but in no event less than a reasonable standard of care;</p><p>(b) use the Confidential Information of the disclosing Party solely for the purpose of performing its obligations under these Terms of Use;</p><p>(c) not acquire any right in or assert any lien against Confidential Information of the disclosing Party;</p><p>(d) promptly return, or provide a copy of, as the disclosing Party directs, Confidential Information upon its request;</p><p>(e) notwithstanding the foregoing, the receiving Party may disclose Confidential Information of the disclosing Party to its employees, agents, and subcontractors who have: (i) a need to know such Confidential Information in order to perform their duties; and (ii) a legal duty to protect the Confidential Information. The receiving Party assumes full responsibility for the acts or omissions of its subcontractors and employees with respect to such Confidential Information; and</p><p>(f) immediately notify the disclosing Party, in the event of any unwanted disclosure or loss or breach of Confidential Information.</p><p><br></p><p>(iii) Required Disclosure</p><p><br></p><p>The receiving Party may disclose Confidential Information received from the disclosing Party, to the extent required by Applicable Laws or by order of a court or governmental agency; provided, however, that the receiving Party shall give the disclosing Party prompt notice and shall use its best efforts to cooperate with the disclosing Party if it wishes to obtain a protective order or otherwise protect the confidentiality of such Confidential Information, as the case may be. Further, the receiving Party may disclose the terms of these Terms of Use to the extent required to enforce its terms or its rights. The confidentiality obligations shall survive the termination of these Terms of Use.</p><p><br></p><p>(iv) Equitable Relief</p><p><br></p><p>Each Party acknowledges that any breach of the confidentiality obligations under these Terms of Use by the receiving Party or, or its personnel or subcontractors, will cause immediate and irreparable injury to the disclosing Party, and in the event of any such breach, the disclosing Party shall be entitled to injunctive relief, without bond or other security, and to any and all other remedies available at law or in equity.</p><p><br></p><p>(v) Return of Confidential Information</p><p><br></p><p>Unless it is expressly authorized by these Terms of Use to retain the disclosing Party’s Confidential Information, the receiving Party shall, either at the request of the disclosing Party or on termination and/or expiry of these Terms of Use, promptly return or destroy with a confirmation in writing, any and all Confidential Information received and all copies thereof.</p><p><br></p><p><strong>TERMINATION:</strong></p><p><br></p><p>These Terms of Use shall be terminated by the Client, on or before the Trial Period. The Client may terminate these Terms of Use, after the Trial Period, if it does not exercise the option of Auto Renewal and notifies the same in writing to the Company. On receipt of such written notification, the Company shall terminate the Client’s access to the Solution (“Subscription End Date”).</p><p><br></p><p>(ii) Effect of Termination:</p><p>(a) On the Subscription End Date, , all rights and benefits granted herein shall revert to respective Parties, and all amounts due from the Client till the Subscription End Date shall remain payable.</p><p>(b) On the Subscription End Date, the Client’s right to access and/or usage of the Solution shall immediately cease and the Client shall have no other or further right to access and use the Solution.</p><p>(c) The Client shall be required to destroy all Confidential Information, promotional and other materials or documentations (if any) furnished as well as any manuals, instruction booklets in any version or medium as provided by the Company to the Client pursuant to these Terms of Use. However, if the Client retains any copies of the Confidential Information after the Subscription End Date pursuant to any automatic archiving and back up procedures, the obligations set out under Clause 10 (Confidentiality) shall continue to apply.</p><p><br></p><p><strong>SERVICE LEVELS:</strong></p><p>The utilisation of the Solution under these Terms of Use shall be measured against the service levels and standards, as established in good faith by mutual agreement between the Parties (“SLA”).</p><p><br></p><p>Target Availability. The Company will use commercially reasonable efforts to make the Solution available with an uptime of 95% (ninety five percent) of each financial year(“Target Availability”).</p><p><br></p><p>Exclusions. The calculation of uptime will not include unavailability to the extent due to: (a) use of the Solution by the Client in a manner not authorized in these Terms of Use or any other applicable documents; (b) general internet problems, force majeure events or other factors outside of the Company’s reasonable control; (c) Clients\' equipment, software, network connections or other infrastructure; (d) third party systems, acts or omissions; or (e) any Scheduled Maintenance or reasonable emergency maintenance.</p><p><br></p><p>Remedy for Failure to Meet Target Availability. If there is a verified failure of services to meet Target Availability for two (2) consecutive months, then the Client shall have the right to terminate these Terms of Use by notifying the Company of such continuous unavailability after the end of the second such month. In such case of Target Availability, the Company will refund to Client any Fees as paid by the Client for the utilization of the Solution.</p><p><br></p><p><strong>THIRD PARTY APPLICATION</strong></p><p>Third party products, software, services, applications, including but not limited to Third Party Services, may be included with, or downloaded in the course of the Client availing the Solution. Notwithstanding anything to the contrary stated in these Terms of Use, the Company makes no representations whatsoever about any such third-party products, software, services and applications. Since the Company has no control over such products, software, services and applications, the Client acknowledges and agrees that the Company is not responsible for the availability of such products, software, services and applications and is not responsible or liable for any content, advertising, products, services, or other materials on or available from such third parties. The Client expressly acknowledges and agrees that use of such third-party products, software, services and applications is at the Client’s sole risk and that the entire risk of unsatisfactory quality, performance, accuracy and effort is with the Client and the Client hereby indemnifies, saves and holds harmless the Company from any and all such risks. The Client acknowledges and agrees that the use of any such third party products, software, services and applications is governed by such third party terms of use, license agreement, privacy policy, or other such agreement and that any information or personal data that the Client provides, whether knowingly or unknowingly, to such third parties, will be subject to such third party privacy policy, if such a policy exists and shall be incorporated herein by reference to the extent applicable under these Terms of Use.</p><p><br></p><p><strong>DATA PROTECTION &amp; PRIVACY</strong></p><p><br></p><p>(i) Unless explicitly stated otherwise in these Terms of Use, the Client shall be responsible to ensure that relevant consents under Applicable Data Protection Laws have been obtained from the users and/or individuals/ data subjects. The Client hereby agrees and acknowledges that the Company shall have no liability towards any users arising as a result of the collection and processing of any Personal Data by the Client.</p><p><br></p><p>(ii) The Client shall be responsible to maintain records of all consents collected as per the Applicable Data Protection Laws. The Client shall be liable to pay for any damages that the Company incurs due to inaccurate and/ or insufficient consents received from any users.</p><p><br></p><p>(iii) The Company will not use Personal Data collected on behalf of the Client, received from the Client or its authorized personnel or otherwise processed on behalf of the Client for any purpose other than as necessary for the utilization of the Solution under these Terms of Use.</p><p><br></p><p>(iv) The Parties shall be compliant with the provisions of Applicable Data Privacy Laws and shall undertake reasonable security practices as may be prescribed under such Applicable Data Protection Law.</p><p><br></p><p>(v) Cloud API: WhatsApp Infrastructure means WhatsApp Enterprise Client deployment which helps communication between users and the Yugmedeals Marky platform.</p><p>- The Client hereby confirms and agrees that upon sharing the data on the WhatsApp infrastructure, all the data shared by the Client in relation to the WhatsApp messaging will now reside on Cloud API\'s (\"Data Residence\"), a Meta Product..</p><p><br></p><p>- It is further understood and accepted that any Client data previously routed &amp; stored on WhatsApp infrastructure i.e. for the purpose of messaging/notification on WhatsApp, the WhatsApp infrastructure shall henceforward be migrated to the data centers of Meta.</p><p><br></p><p>- For the purpose of the provision of services under this Agreement, the Client hereby acknowledges that for the WhatsApp infrastructure data localization is not offered by the Company for any such data shared or obtained by the Company in the process of providing the WhatsApp messaging to the Client.</p><p><br></p><p><strong>DISCLAIMERS OF WARRANTIES</strong></p><p><br></p><p>(i) To the extent permitted by the Applicable Laws from time to time, the Company disclaims any and all representations and warranties that the Solution provided under these Terms of Use shall be uninterrupted, error-free and devoid of any bugs, viruses, bots or that the Solution shall be provided as timely and/or secure and/or on uninterrupted basis.</p><p><br></p><p>(ii) The Company shall not be liable for any errors, omissions, interruptions, deletion of files or emails, loss of or damage to data, errors, defects, viruses, delays in operation or transmission, or any failure of performance, communication failure, data pilferage due to the use of any data or information in respect of the Solution.</p><p><br></p><p><strong>INDEMNITY</strong></p><p>(i) Client Indemnity: The Client hereby agrees to indemnify, defend and hold harmless the Company, its Affiliates, directors, officers, agents, employees from and against any and all losses, liabilities, claims, damages, demands, suits, actions, proceedings, costs and expenses, incurred or suffered by the Company, in connection with or arising out of: (a) Breach of or violation of or non-compliance with any of the obligation, warranties, representation, covenants and undertakings herein, by the Client or any of its representatives; (b) infringement of any third party’s Intellectual Property Rights for availing the Solution from the Company. (ii) Company’s Indemnity: The Company agrees to indemnify, defend and hold harmless the Client from and against any and all losses, liabilities, claims, damages, demands, suits, actions, proceedings, costs and expenses in connection with or arising out of any third party claims for providing Solution to the Client.</p><p><br></p><p><strong>LIMITATION OF LIABILITY</strong></p><p>(i) Neither Party shall be liable to the other Party for any indirect, special, incidental, punitive or consequential loss or damages of any kind, or for any loss that could have been avoided by the use of reasonable diligence, arising in connection with the Terms of Use, even if the Party responsible for the damages has been advised or should be aware of the possibility of such damages.</p><p><br></p><p>(ii) In no event shall the maximum aggregate liability of the Company under these Terms of Use to the Client whether arising from contract, indemnity, tort or otherwise, exceed the amount of the Fees payable by the Client to the Company in the twelve (12) months preceding the date on which the claim arose.</p><p><br></p><p><strong>INTELLECTUAL PROPERTY RIGHTS :</strong></p><p>All Intellectual Property Rights in and title to the Solution, the present or future modifications, Updates and Upgrades shall unconditionally remain under the exclusive ownership of the Company at all times. These Terms of Use does not and shall not transfer any ownership or proprietary interest in the Solution from the Company to the Client, except as may be otherwise expressly provided herein or as may be agreed in writing by and between the Parties. The Client understands and acknowledges that the License granted herein pertains to the Solution solely developed by the Company, and does not include a license to any third-party software or intellectual property. cost and expense. The Client shall have no rights whatsoever with respect to any other software or products developed by the Company, not expressly subscribed or licensed under these Terms of Unless otherwise expressly agreed upon, the Client shall be solely responsible for obtaining and maintaining such third-party software and Intellectual Property Rights, at its solese. In the event the Client subsequently desires to license or deal in any other manner with any other software developed by the Company, then the Parties will negotiate in good faith to determine the terms upon which such other software/ solution would be provided to the Client. The Client shall at no time, during the Term or after its termination, contest the validity or ownership of the Intellectual Property of the Company. The Client shall not use or register any trademark, design, product name or trade name which is confusingly similar to Company’s trademarks, product names or trade names. The Client agrees to promptly notify the Company of any claims, demands or notices arising in connection with the Intellectual Property of the Company. The Client shall provide necessary support, execute documents and do such acts and things as may be reasonably requested by the Company in this regard.</p><p><br></p><p><strong>INDEPENDENT CONTRACTOR</strong></p><p>The relationship between Parties shall be on principal-to-principal basis. Each Party is an independent contractor and is not a legal representative, partner or agent of the other Party. Neither Party shall have any right, power or authority, whether express or implied, to create any obligation on behalf of the other Party or bind the other Party.</p><p><br></p><p><strong>GOVERNING LAW, ARBITRATION AND JURISDICTION</strong></p><p>Any and all questions of enforceability and interpretation, which may arise under these Terms of Use, shall be determined and governed by and in accordance with the laws of India and subject to the arbitration clause as set out below, the courts located at Vellore, Tamil Nadu shall have exclusive jurisdiction. In the event of any dispute arising out of or in relation to these Terms of Use, each Party shall make efforts to resolve the same amicably through their respective representatives/ senior management of both the parties. In case the dispute is not resolved amicably within 30 (thirty) days of arising of such dispute, then the dispute shall be referred to arbitration before a sole arbitrator appointed jointly by both Parties, in accordance with the Arbitration and Conciliation Act, 1996 and any amendments thereafter. The venue of arbitration shall be Vellore, Tamil Nadu. The language of the arbitration proceedings shall be English. Notwithstanding anything to the contrary, the Parties may agree to conduct the arbitration proceedings virtually through such video conferencing or other audio-visual means as may be mutually agreed between the Parties.</p><p><br></p><p><strong>PUBLICITY</strong></p><p>It is agreed between the Parties that the Company reserves the right to use certain details of the Client, including but not limited to the logo or name of the Client and any performance metrics obtained under these Terms of Use for its own marketing and advertising purposes. The Client hereby expressly consents to the usage of such details by the Company and provide the Company a perpetual, irrevocable, worldwide, royalty free license for the provision of such usage.</p><p><br></p><p><strong>FORCE MAJEURE</strong></p><p>Except for the duty to make payments hereunder when due, and the indemnification provisions under these Terms of Use, neither the Company nor the Client shall be liable by reason of any failure or delay in the performance of its obligations arising out of a Force Majeure Event. As used in these Terms of Use, “Force Majeure Event” shall mean: any act of God, act of nature or the elements, terrorism, insurrection, revolution or civil strife, piracy, civil war or hostile action, labor strikes, acts of public enemies, federal or state laws, rules and regulations of any governmental authorities having jurisdiction over the premises, inability to procure material, equipment, or necessary labor in the open market, acute and unusual labor, material, or equipment shortages, or any other causes (except financial) beyond the control of either Party. In the event, if one or more Force Majeure Events results in delay of 15 (fifteen) consecutive days in the performance of the obligations under these Terms of Use, the Parties shall mutually discuss to terminate these Terms of Use without any further liability. However, the Client shall be liable to pay the Company for the utilization of the Solution provided in accordance with these Terms of Use.</p><p><br></p><p><strong>CONTACT DETAILS</strong></p><p>All communications or notices permitted or required to be given or served to the Company under these Terms of Use shall be in writing, shall be addressed to the Company as per the details set out below. These details may be updated from time to time by the Company and shall also be made available on the Solution.</p><p><br></p><p>Email ID: <a href=\"mailto:grievance@yugmedeals.com\">grievance@yugmedeals.com</a> &amp; <a href=\"mailto:contactus@yugmedeals.com\">contactus@yugmedeals.com</a></p><p><br></p><p><strong>SURVIVAL AND SEVERABILITY</strong></p><p>The rights and obligations arising out of these Terms of Use, which by their nature should survive or are expressly so stated herein, shall remain in full force and effect to the extent so specified, notwithstanding any expiry or termination of these Terms of Use. If any provision of these Terms of Use (or any portion thereof) is determined to be invalid or unenforceable the remaining provisions of these Terms of Use shall not be affected by such determination, shall be binding upon the parties and shall be enforceable.</p><p><br></p><p><strong>WAIVER</strong></p><p>Neither Party shall, by mere lapse of time, without giving notice thereof, be deemed to have waived any right or remedy arising hereunder or in connection with any breach or illegality involving the other Party. The waiver by either Party of any such right or remedy shall not be construed as a waiver of any other right or remedy or as a continuing waiver with respect to any similar, ongoing, or repeated circumstances.</p><p><br></p><p><strong>ASSIGNMENT</strong></p><p>The Company may assign these Terms of Use and/or part thereof at its discretion, at any time, to any of its Affiliates, group companies, holding company, subsidiary companies, third parties without any notice to the Client. However, the Client shall not assign these Terms of Use or any part thereof to any party without taking prior written consent of the Company.</p>','2024-12-18 14:37:41','2024-08-12 05:21:48'),(3,'Refund Policy','<p><strong>Our Refund Policy :</strong></p><p><br></p><p>This policy is designed to be fair and reasonable, ensuring that customers feel secure in their transactions with Yugmedeals Marky, while also protecting the company from potential abuse of the refund process.</p><p><br></p><p><strong>1. Trial Period</strong></p><p>Yugmedeals Marky offers a 7 Days or 14-day free trial for new users, during which they can explore the Basic Plan features available on the platform. Since no credit card is required to start the trial and users are not charged.</p><p><br></p><p><strong>2. Subscription Services</strong></p><p>Following the free trial, if a user subscribes to any of Yugmedeals Marky paid services, they are ineligible to receive a refund. The FREE trial is provided to ensure that the users try out all the services and decide whether to continue with the Yugmedeals Marky platform. If the user feels unsatisfied, they can cancel their FREE Trial anytime and they will not be charged. If the user has subscribed to any Yugmedeals Marky Subscription plan, they are not eligible for a refund. They can cancel their subscription to ensure they are not charged the next month.</p><p><br></p><p><strong>3. Non-Refundable Services</strong></p><p>All Yugmedeals Marky services, such as the charges for an Yugmedeals Marky Plan, WhatsApp Conversation Credits (WCCs), Add-ons or any third-party integrations, are non-refundable due to the nature of the service and the costs incurred by Yugmedeals Marky to provide these services.</p><p><br></p><p><strong>4. Technical Issues</strong></p><p>If a user experiences continuous technical issues that prevent them from using the service effectively, and if these issues are verified by Yugmedeals Marky support team, a partial or full refund may be granted at Yugmedeals Marky discretion.</p><p><br></p><p><strong>5. Unauthorized Charges</strong></p><p>In the case of unauthorized or fraudulent charges, users should contact Yugmedeals Marky support immediately. If such claims are verified, Yugmedeals Marky will issue a full refund.</p><p><br></p><p><strong>6. Cancellation Policy</strong></p><p>A user may cancel their subscription at any time. However, the cancellation will be effective at the end of the current billing cycle, and users will not receive a refund for the remaining period of the subscription, except under special circumstances that will be reviewed on a case-by-case basis.</p><p><br></p><p><strong>7. Contact and Support</strong></p><p>For any refund-related queries, users are encouraged to contact Yugmedeals Marky customer support team, which is committed to providing efficient and personalized assistance.</p><p><br></p><p><strong>8. Refund Process</strong></p><p>To request a refund, users should write to us at contactus@yugmedeals.com. The request must include the transaction details and a clear explanation of the reason for the refund request.</p><p><br></p><p><strong>9. Policy Amendments</strong></p><p>Yugmedeals Marky reserves the right to modify this refund policy at any time, and the changes will be effective immediately upon posting the updated policy on the Yugmedeals Marky website.</p><p><br></p><p><strong>10. Legal Compliance</strong></p><p>This refund policy complies with the local laws and regulations where Yugmedeals Marky operates. Users are also encouraged to review the Terms of Service and Privacy Policy for a comprehensive understanding of their rights and obligations.</p>','2024-12-18 16:02:43','2024-12-18 16:00:49');

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--

INSERT INTO `password_reset_tokens` VALUES ('mohanasundar2410@gmail.com','$2y$10$ckClhPjPLG30TPCWr3/lBO7YpNsjU9Jrx/iNYKMsKcPFWq3b8oMYy','2024-08-17 08:14:12');

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` VALUES (1,'Paypal','{\"client_id\":\"AYbgtQ9g06hB4beYkQkHimwr9QLRjjTLL2D_HKC6No1Bwj6XL_z33cMNEGYmLsiVWC2JQA2BJAUW8S33\",\"secret\":\"EIsTOUc3noCKcq6oFYecBbYlbR8uCMV3NBYcSIbKW4xWyQY7lxsc6YYNdgfWbG7yuHuB7lYVllM5zKZc\",\"mode\":\"sandbox\",\"webhook_id\":\"2CB16610H85163838\"}',0,'2024-08-12 05:21:48','2024-12-03 18:38:03'),(2,'Stripe',NULL,0,'2024-08-12 05:21:48','2024-08-12 05:21:48'),(3,'Flutterwave',NULL,0,'2024-08-12 05:21:48','2024-08-12 05:21:48');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int NOT NULL DEFAULT '0',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (1,'Mohanasundar','Developer','Nice',5,NULL,0,'2024-12-03 18:50:17','2024-12-03 18:50:45');

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint unsigned NOT NULL,
  `module` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `role_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permissions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'9de0a1ce-f036-4580-8f32-8b21e9a8d028','admin','2024-08-12 05:21:48','2024-08-12 05:21:48',NULL),(2,'0c972256-db65-42c7-8bde-225b56e3e8d1','Staff','2024-08-12 05:21:48','2024-08-12 05:21:48',NULL);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES ('_method','put'),('address','164, Eriyur New Street, Rangapuram, vellore - 632009'),('allow_facebook_login','0'),('allow_google_login','0'),('app_environment','local'),('aws','{\"access_key\":\"AKIAZAEVXEG6BP5U4I2U\",\"secret_key\":\"sQo\\/VOkylcLRWgXepJ8pJVAifea1CgmjbzMgpOez\",\"default_region\":\"ap-south-1\",\"bucket\":\"codevinez\"}'),('aws_access_key',NULL),('aws_bucket',NULL),('aws_default_region',NULL),('aws_secret_key',NULL),('billing_address','No 164, new street, Eriyur, Rangapuram'),('billing_city','Tamil Nadu'),('billing_country','India'),('billing_name','YUGMEDEALS PRIVATE LIMITED'),('billing_phone_1','+919790213730'),('billing_phone_2',NULL),('billing_postal_code','632009'),('billing_state','Vellore'),('billing_tax_id','1'),('broadcast_driver','pusher'),('company_name','Yugmedeals Marky'),('currency','INR'),('date_format','d-M-y'),('default_image_api',NULL),('display_frontend','1'),('email','contactus@yugmedeals.com'),('facebook_login',NULL),('favicon','public/3IKYePVgftkf2cJrMtyTZyhcmNgi6kAI2bqa4JJt.png'),('google_analytics_status','0'),('google_analytics_tracking_id',NULL),('google_login',NULL),('google_maps_api_key',NULL),('invoice_prefix','YDWM'),('is_embedded_signup_active','1'),('is_tax_inclusive','0'),('logo','public/dZX5EeUNtG3mQXMymSVDhSrwy6dhvchPwUpQqNzP.png'),('mail_config','{\"driver\":\"smtp\",\"from_address\":\"noreply@yugmedeals.com\",\"from_name\":\"Yugmedeals Marky\",\"reply_to_name\":\"Yugmedeals Marky Support\",\"reply_to_address\":\"support@yugmedeals.com\",\"port\":\"465\",\"host\":\"smtp.zoho.com\",\"username\":\"noreply@yugmedeals.com\",\"password\":\"fEPYbLxhQDfV\",\"mail_config\":\"fEPYbLxhQDfV\"}'),('phone','+919790213730'),('pusher_app_cluster','ap2'),('pusher_app_id','1849264'),('pusher_app_key','76921fa9431e99e375b5'),('pusher_app_secret','e883bf754a90596cc2f7'),('razorpay_active','1'),('razorpay_key_id','rzp_live_XZdxUBKper998y'),('razorpay_secret_key','SPPxCREmbgxPnEzqjzQMBvvx'),('razorpay_webhook_secret','Aswqa@123'),('recaptcha_active','0'),('recaptcha_secret_key',NULL),('recaptcha_site_key',NULL),('smtp_email_active','1'),('socials','{\"facebook\":\"https:\\/\\/www.facebook.com\\/yugmedealsoffical\",\"twitter\":\"https:\\/\\/www.twitter.com\\/yugmedeals\",\"instagram\":\"https:\\/\\/www.instagram.com\\/yugmedeals\\/\",\"slack\":null,\"linkedin\":\"https:\\/\\/www.linkedin.com\\/company\\/yugmedeals\\/\"}'),('storage_system','aws'),('time_format','h:i A'),('timezone','Asia/Kolkata'),('title',NULL),('trial_limits','{\"users\":\"-1\",\"messages\":\"-1\",\"contacts\":\"-1\",\"campaigns\":\"-1\",\"automated_replies\":\"-1\"}'),('trial_period','7'),('type','storage'),('verify_email','1'),('whatsapp_access_token','EAA2oBAHoJIYBO0qzQy5srNRvN8bOe8h8cNRlikBsQBxQZAZBVx7YZA0ZAHlCg7HlcyZBm90GZASznyFbYegw0d4UM6bzG1Uhf8Le4UJYZBsSfsKZAel6wJLYPpvO5WKBGazjYI8sVsYBCMiAFjt2IlNq9ztKoXE9dZBn2Hmv3wZBLle2ZBlX3bckp1gjAJW6611huYxmAZDZD'),('whatsapp_callback_token','Alk45734Ftbh557'),('whatsapp_client_id','3843909862564998'),('whatsapp_client_secret','684f6d2865ab3823599437fc243a7b3b'),('whatsapp_config_id','472760119055150');

--
-- Table structure for table `subscription_plans`
--

CREATE TABLE `subscription_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(23,2) NOT NULL,
  `period` enum('monthly','yearly') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive','deleted') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_plans_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_plans`
--

INSERT INTO `subscription_plans` VALUES (1,'e5662aef-ef4e-4f80-b0fc-ef4e570cc7f5','Free',0.00,'monthly','{\"campaign_limit\":\"-1\",\"message_limit\":\"-1\",\"contacts_limit\":\"-1\",\"canned_replies_limit\":\"-1\",\"team_limit\":\"-1\"}','active','2024-08-13 07:46:46','2024-10-08 17:29:18','2024-10-08 17:29:18'),(2,'9e21758b-9328-490a-b62b-43bc8b44b6eb','Basic',99.00,'monthly','{\"campaign_limit\":\"-1\",\"message_limit\":\"-1\",\"contacts_limit\":\"-1\",\"canned_replies_limit\":\"-1\",\"team_limit\":\"-1\"}','active','2024-08-21 15:43:29','2024-10-08 17:29:12','2024-10-08 17:29:12'),(3,'b829b6b0-89ac-4059-ab6e-8d4983288d60','Basic',1499.00,'monthly','{\"campaign_limit\":\"10\",\"message_limit\":\"1500\",\"contacts_limit\":\"5000\",\"canned_replies_limit\":\"1000\",\"team_limit\":\"10\"}','active','2024-10-08 17:29:03','2024-12-02 15:57:47',NULL),(4,'29d12aa4-e277-4852-97f8-363e87a1ee9e','Standard',3499.00,'monthly','{\"campaign_limit\":\"99\",\"message_limit\":\"4500\",\"contacts_limit\":\"5000\",\"canned_replies_limit\":\"5000\",\"team_limit\":\"25\"}','active','2024-10-08 17:30:17','2024-10-08 17:34:22',NULL),(5,'6b94e16d-4155-49b6-a572-4acbece24bdf','premium',6499.00,'monthly','{\"campaign_limit\":\"200\",\"message_limit\":\"-1\",\"contacts_limit\":\"-1\",\"canned_replies_limit\":\"-1\",\"team_limit\":\"50\"}','active','2024-10-08 17:30:41','2024-10-08 17:34:48',NULL),(6,'1d5fe9ad-b8ce-4594-bdf9-a6bc2a76d1a1','Free',0.00,'monthly','{\"campaign_limit\":\"5\",\"message_limit\":\"999\",\"contacts_limit\":\"999\",\"canned_replies_limit\":\"899\",\"team_limit\":\"5\"}','active','2024-12-02 16:00:18','2024-12-02 16:00:18',NULL),(7,'9accb1ef-8938-471b-934d-4a719ed5ecbd','Basic',1049.00,'yearly','{\"campaign_limit\":\"10\",\"message_limit\":\"1500\",\"contacts_limit\":\"5000\",\"canned_replies_limit\":\"1000\",\"team_limit\":\"10\"}','active','2024-12-02 16:43:49','2024-12-02 16:43:49',NULL),(8,'b2b407b5-aa9a-49dc-adc7-a2e166592e84','Standard',2449.00,'yearly','{\"campaign_limit\":\"99\",\"message_limit\":\"4500\",\"contacts_limit\":\"5000\",\"canned_replies_limit\":\"5000\",\"team_limit\":\"25\"}','active','2024-12-02 16:46:05','2024-12-02 16:46:05',NULL),(9,'d2006ce7-20e3-4b70-894c-682002426f0b','Premium',4549.00,'yearly','{\"campaign_limit\":\"200\",\"message_limit\":\"-1\",\"contacts_limit\":\"-1\",\"canned_replies_limit\":\"-1\",\"team_limit\":\"50\"}','active','2024-12-02 16:49:42','2024-12-02 16:49:42',NULL);

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` bigint unsigned NOT NULL,
  `plan_id` bigint unsigned DEFAULT NULL,
  `payment_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `start_date` timestamp NULL DEFAULT NULL,
  `valid_until` datetime DEFAULT NULL,
  `status` enum('trial','active') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'trial',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_uuid_unique` (`uuid`),
  KEY `subscriptions_organization_id_foreign` (`organization_id`),
  CONSTRAINT `subscriptions_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` VALUES (1,'93ddaa5b-7dff-4385-a1a4-01c9edce5d5d',1,5,NULL,'2024-11-28 13:57:52','2024-12-28 13:57:52','active','2024-08-13 00:54:47','2024-11-28 13:57:52'),(2,'4d2987fa-8111-42ba-a620-48756a48d98f',2,5,NULL,'2024-11-08 18:14:56','2024-12-08 18:14:56','active','2024-08-16 12:31:31','2024-11-08 18:14:56'),(3,'4b4b1cc8-cc6a-47e5-b16f-49af6a98d4de',3,NULL,NULL,'2024-08-17 07:53:28','2024-09-06 07:53:28','trial','2024-08-17 07:53:28','2024-08-17 07:53:28'),(4,'5717d631-7f2e-4d51-b3c3-f30443685f59',4,NULL,NULL,'2024-08-18 07:51:59','2024-09-07 07:51:59','trial','2024-08-18 07:51:59','2024-08-18 07:51:59'),(5,'39d44416-a845-4db2-878a-c0d3a443c45f',5,NULL,NULL,'2024-09-12 15:13:39','2024-10-02 15:13:39','trial','2024-09-12 15:13:39','2024-09-12 15:13:39'),(6,'de1b5f35-1186-4ea4-9c54-3e097d3ac63a',6,NULL,NULL,'2024-10-11 19:07:17','2024-10-31 19:07:17','trial','2024-10-11 19:07:17','2024-10-11 19:07:17'),(7,'6df97fa8-2548-442e-8aa4-8b2dc33a044d',7,NULL,NULL,'2024-11-05 01:45:47','2024-11-25 01:45:47','trial','2024-11-05 01:45:47','2024-11-05 01:45:47'),(8,'60ff6fb1-6eff-4453-b672-62b3059a0a67',8,NULL,NULL,'2024-11-28 11:29:48','2024-12-18 11:29:48','trial','2024-11-28 11:29:48','2024-11-28 11:29:48'),(9,'2af45214-e024-4b37-a5fc-f2923d2838da',9,9,NULL,'2024-12-03 18:43:34','2025-12-03 18:43:34','active','2024-11-28 11:34:42','2024-12-03 18:43:34'),(10,'acd6c2a6-4509-4d36-863f-9c67a5b83b39',10,5,NULL,'2024-12-02 15:22:12','2025-01-02 15:22:12','active','2024-12-02 15:20:28','2024-12-02 15:22:12'),(11,'2c42eb6a-659f-47f8-83a2-725402dc0846',11,NULL,NULL,'2024-12-04 16:57:50','2024-12-11 16:57:50','trial','2024-12-04 16:57:50','2024-12-04 16:57:50'),(12,'9201e1da-ce56-4528-b891-30ad56dd2033',12,NULL,NULL,'2024-12-05 13:44:23','2024-12-12 13:44:23','trial','2024-12-05 13:44:23','2024-12-05 13:44:23'),(13,'d23b8f6f-414d-4dc5-bdc5-72a60c9fb085',13,NULL,NULL,'2024-12-17 15:03:24','2024-12-24 15:03:24','trial','2024-12-17 15:03:24','2024-12-17 15:03:24');

--
-- Table structure for table `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `percentage` decimal(5,2) NOT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tax_rates`
--

INSERT INTO `tax_rates` VALUES (1,'Indian Tax',18.00,'active',NULL,NULL,NULL);

--
-- Table structure for table `team_invites`
--

CREATE TABLE `team_invites` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `organization_id` bigint unsigned NOT NULL,
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invited_by` bigint unsigned NOT NULL,
  `expire_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `team_invites_organization_id_foreign` (`organization_id`),
  KEY `team_invites_invited_by_foreign` (`invited_by`),
  CONSTRAINT `team_invites_invited_by_foreign` FOREIGN KEY (`invited_by`) REFERENCES `users` (`id`),
  CONSTRAINT `team_invites_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_invites`
--


--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `role` enum('owner','manager','agent') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'manager',
  `status` enum('active','suspended') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_by` bigint unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `deleted_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `teams_uuid_unique` (`uuid`),
  KEY `teams_organization_id_foreign` (`organization_id`),
  KEY `teams_user_id_foreign` (`user_id`),
  KEY `teams_created_by_foreign` (`created_by`),
  CONSTRAINT `teams_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `teams_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  CONSTRAINT `teams_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` VALUES (1,'943e701d-3fb1-44c9-bcee-277d4f074b6e',1,2,'owner','active',1,NULL,NULL,'2024-08-13 00:54:47','2024-08-13 00:54:47'),(2,'70020a8b-1517-480c-9c65-7a11b44b3ece',2,3,'owner','active',1,NULL,NULL,'2024-08-16 12:31:31','2024-08-16 12:31:31'),(3,'e6e0aaa8-d52d-4382-82a5-3877e28c0dbf',3,4,'owner','active',1,NULL,NULL,'2024-08-17 07:53:28','2024-08-17 07:53:28'),(4,'7e19cdfa-c44c-4955-8b3c-efa119b3e15d',4,5,'owner','active',5,NULL,NULL,'2024-08-18 07:51:59','2024-08-18 07:51:59'),(5,'f0dc0ad3-7388-428a-a21b-d42768a2b4ae',5,6,'owner','active',1,NULL,NULL,'2024-09-12 15:13:39','2024-09-12 15:13:39'),(6,'11692fbd-3f0f-412d-aa52-eb3796317772',6,8,'owner','active',8,NULL,NULL,'2024-10-11 19:07:17','2024-10-11 19:07:17'),(7,'91dda65a-47b6-42e3-b1a0-e3f210c4b7fa',7,9,'owner','active',9,NULL,NULL,'2024-11-05 01:45:47','2024-11-05 01:45:47'),(8,'6c91b38d-c27b-43c5-bda6-8e19c9bada02',8,10,'owner','active',10,NULL,NULL,'2024-11-28 11:29:48','2024-11-28 11:29:48'),(9,'349f96a2-e07d-40eb-9687-fdceb44db5b7',9,11,'owner','active',11,NULL,NULL,'2024-11-28 11:34:42','2024-11-28 11:34:42'),(10,'67048fef-a130-47d0-ad09-68c6ebf90bc5',10,12,'owner','active',12,NULL,NULL,'2024-12-02 15:20:28','2024-12-02 15:20:28'),(11,'f75d08dc-47c3-4791-adfc-e67e59718a33',11,13,'owner','active',13,NULL,NULL,'2024-12-04 16:57:50','2024-12-04 16:57:50'),(12,'0d0fffda-677b-41bb-9df3-99583528fb28',12,14,'owner','active',14,NULL,NULL,'2024-12-05 13:44:23','2024-12-05 13:44:23'),(13,'eefd3a8f-878a-4cae-92e6-518c2c8869a9',13,15,'owner','active',15,NULL,NULL,'2024-12-17 15:03:24','2024-12-17 15:03:24');

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` bigint unsigned NOT NULL,
  `meta_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `templates_organization_id_foreign` (`organization_id`),
  KEY `templates_created_by_foreign` (`created_by`),
  CONSTRAINT `templates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `templates_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` VALUES (1,'0c1e07b7-1827-480c-b5b8-cccbcbade832',1,'1012981846949677','testing_template','MARKETING','en','{\"name\":\"testing_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Header Test\"},{\"type\":\"BODY\",\"text\":\"Content is hello\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1012981846949677\"}','APPROVED',2,'2024-08-13 06:18:27','2024-08-13 07:36:23','2024-11-28 13:23:58'),(2,'a597c040-3505-4319-9049-86220e4c71aa',2,'509657858407475','codevinez_campaign','MARKETING','en','{\"name\":\"codevinez_campaign\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Codevinez\"},{\"type\":\"BODY\",\"text\":\"Hi this codevinez team\"},{\"type\":\"FOOTER\",\"text\":\"Thank you!\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"509657858407475\"}','APPROVED',3,'2024-08-16 12:33:21','2024-08-16 12:33:21','2024-11-08 18:15:36'),(3,'f0a8e61e-9726-4836-bf5c-4d2e450735c1',2,'1012981846949677','testing_template','MARKETING','en','{\"name\":\"testing_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Header Test\"},{\"type\":\"BODY\",\"text\":\"Content is hello\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1012981846949677\"}','APPROVED',3,'2024-08-16 12:33:21','2024-08-16 12:33:21','2024-11-08 18:15:36'),(4,'a56d3259-4bf3-4299-89a4-9a1cc28a4d11',1,'790749119890071','codevinez_test_campaign','MARKETING','en','{\"name\":\"codevinez_test_campaign\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hello\"},{\"type\":\"BODY\",\"text\":\"Hey there!\"},{\"type\":\"FOOTER\",\"text\":\"Thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"790749119890071\"}','APPROVED',2,'2024-08-16 17:18:19','2024-12-02 14:08:15',NULL),(5,'44716845-497a-46f2-b886-ef2ba63747f8',1,'1188764112439503','codevinez_welcome','MARKETING','en','{\"name\":\"codevinez_welcome\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Codevinez Solutions Private limited\"},{\"type\":\"BODY\",\"text\":\"Welcome all\"},{\"type\":\"FOOTER\",\"text\":\"Thank you!\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1188764112439503\"}','APPROVED',2,'2024-08-17 09:27:27','2024-12-02 14:08:15',NULL),(6,'276519dd-58cf-414b-b4e8-4354e6f89316',1,'1025383742227498','offer_template','MARKETING','en','{\"name\":\"offer_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hurry Flat 50% Off\"},{\"type\":\"BODY\",\"text\":\"Hello {{1}} Grab Flat 50% Off On Adidas T-Shirts\",\"example\":{\"body_text\":[[\"Mohan\"]]}},{\"type\":\"FOOTER\",\"text\":\"Limited Offer\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"Buy Now\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1025383742227498\"}','APPROVED',2,'2024-08-17 14:21:15','2024-12-02 14:08:15',NULL),(7,'3b616006-7701-4659-9b99-4d90aa07b2a0',1,'1714985855907942','sample_template','UTILITY','en_US','{\"name\":\"sample_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hello World\"},{\"type\":\"BODY\",\"text\":\"Welcome and congratulations!! This message demonstrates your ability to send a WhatsApp message notification. Thank you for taking the time to test with us.\"},{\"type\":\"FOOTER\",\"text\":\"WhatsApp Business Platform sample message\"}],\"language\":\"en_US\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"1714985855907942\"}','APPROVED',2,'2024-08-21 08:15:13','2024-12-02 14:08:15',NULL),(8,'b3f08f0b-f949-4a07-9122-68b016ebbfad',1,'1060822925611080','image_template','MARKETING','en','{\"name\":\"image_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"IMAGE\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/427953643_1060822928944413_7442071328757910060_n.jpg?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=yV0uVcbzGJIQ7kNvgFwxpK0&_nc_zt=3&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=AAXa1Ec0YwxDaGuR0ClXxUL&oh=01_Q5AaIPItw6E5UjNaa08Nsu5XEUywuNLlczSidGRDLHr34O1N&oe=6774ED16\"]}},{\"type\":\"BODY\",\"text\":\"Yugmedeals Offering best deals\"},{\"type\":\"FOOTER\",\"text\":\"Thankyou\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"PHONE_NUMBER\",\"text\":\"Call Now\",\"phone_number\":\"+919790213730\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1060822925611080\"}','APPROVED',2,'2024-08-21 09:09:52','2024-12-02 14:08:15',NULL),(9,'04bf307a-0fcf-45f0-8a3c-b894dff033f1',1,'758825699598139','docs_campaign','MARKETING','en_GB','{\"name\":\"docs_campaign\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"DOCUMENT\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/445686592_758825702931472_9183411969051433344_n.pdf?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=uS3dKZrmAWgQ7kNvgFkEC9A&_nc_zt=3&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=AAXa1Ec0YwxDaGuR0ClXxUL&oh=01_Q5AaIKobo-RAHW5zJd89mbJbEVPAYZR2ZxwmjnNBMj_LYie6&oe=6774C999\"]}},{\"type\":\"BODY\",\"text\":\"Order invoice No.123456789\"},{\"type\":\"FOOTER\",\"text\":\"Yugmedeals private limited\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"View Invoice\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/invoice\"}]}],\"language\":\"en_GB\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"758825699598139\"}','APPROVED',2,'2024-08-21 09:19:51','2024-12-02 14:08:15',NULL),(10,'841e1634-5533-48a7-a79b-226acbe5fcb2',1,'512264444714633','video_template','MARKETING','en','{\"name\":\"video_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"VIDEO\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/369500748_512264448047966_4428550760143775378_n.mp4?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=1ayaJbW9R-AQ7kNvgE6WgdS&_nc_zt=28&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=AAXa1Ec0YwxDaGuR0ClXxUL&oh=01_Q5AaIK3EVwPxcdjmQDl2ObjQ_Zo61PnDJ-2e5qHsn56VxYIV&oe=6774EB6B\"]}},{\"type\":\"BODY\",\"text\":\"Food Ordering\"},{\"type\":\"FOOTER\",\"text\":\"Yugmedeals Private Limited\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"Order Now\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"512264444714633\"}','APPROVED',2,'2024-08-21 09:42:28','2024-12-02 14:08:15',NULL),(11,'0e72078d-6568-4154-bf3a-19470b83ef14',1,'522869043534028','order_invoice','MARKETING','ta','{\"name\":\"order_invoice\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"\\u0b8e\\u0b95\\u0bcd\\u0bae\\u0bbf\\u0b9f\\u0bc0\\u0bb2\\u0bcd\\u0bb8\\u0bcd\"},{\"type\":\"BODY\",\"text\":\"\\u0bb5\\u0ba3\\u0b95\\u0bcd\\u0b95\\u0bae\\u0bcd {{1}}\",\"example\":{\"body_text\":[[\"Mohan\"]]}},{\"type\":\"FOOTER\",\"text\":\"\\u0ba8\\u0ba9\\u0bcd\\u0bb1\\u0bbf\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"\\u0b87\\u0baa\\u0bcd\\u0baa\\u0bcb\\u0ba4\\u0bc1 \\u0baa\\u0bbe\\u0bb0\\u0bcd\\u0bb5\\u0bc8\\u0baf\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"ta\",\"status\":\"REJECTED\",\"category\":\"MARKETING\",\"id\":\"522869043534028\"}','REJECTED',2,'2024-08-21 15:23:10','2024-08-21 15:36:42','2024-11-28 13:23:58'),(12,'d0d9f4f8-7876-4cce-b08c-6da8def57730',1,'1062197588661596','welcome_message','MARKETING','ta','{\"name\":\"welcome_message\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"\\u0b8e\\u0b95\\u0bcd\\u0bae\\u0bbf\\u0b9f\\u0bc0\\u0bb2\\u0bcd\\u0bb8\\u0bcd\"},{\"type\":\"BODY\",\"text\":\"\\u0bb5\\u0ba3\\u0b95\\u0bcd\\u0b95\\u0bae\\u0bcd\"},{\"type\":\"FOOTER\",\"text\":\"\\u0ba8\\u0ba9\\u0bcd\\u0bb1\\u0bbf\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"\\u0b87\\u0baa\\u0bcd\\u0baa\\u0bcb\\u0ba4\\u0bc1 \\u0baa\\u0bbe\\u0bb0\\u0bcd\\u0bb5\\u0bc8\\u0baf\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"ta\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1062197588661596\"}','APPROVED',2,'2024-08-21 15:25:40','2024-12-02 14:08:15',NULL),(13,'46a41869-7bf0-4b62-b212-2c1d252c4221',1,'1190902175456403','name_template','MARKETING','en','{\"name\":\"name_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey!\"},{\"type\":\"BODY\",\"text\":\"Hi {{1}},\\r\\nHow are you\",\"example\":{\"body_text\":[[\"Mohan\"]]}},{\"type\":\"FOOTER\",\"text\":\"thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1190902175456403\"}','APPROVED',2,'2024-08-22 14:57:22','2024-12-02 14:08:15',NULL),(14,'8ce09989-c283-46da-ba40-75ad4c098afc',1,'960671775829675','plan_template','MARKETING','en','{\"name\":\"plan_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey there\"},{\"type\":\"BODY\",\"text\":\"Plan details\"},{\"type\":\"FOOTER\",\"text\":\"Thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"960671775829675\"}','APPROVED',2,'2024-08-22 16:13:04','2024-12-02 14:08:15',NULL),(15,'228750bd-b5ea-491b-9e8b-2cb86c77ab33',1,'2377858662403950','offer_template_2','MARKETING','en','{\"name\":\"offer_template_2\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey There\"},{\"type\":\"BODY\",\"text\":\"I got a offer for you\"},{\"type\":\"FOOTER\",\"text\":\"Thankyou\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"2377858662403950\"}','APPROVED',2,'2024-08-22 17:04:00','2024-12-02 14:08:15',NULL),(16,'9eccac47-3864-475d-a8aa-c614b1a2910f',1,'1161702508270923','monitor_up','UTILITY','en','{\"name\":\"monitor_up\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now UP \\ud83d\\udfe2.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"Example\",\"example.com\",\"http:\\/\\/localhost\\/server\\/monitor\\/1\"]]}}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"1161702508270923\"}','APPROVED',2,'2024-08-31 14:53:02','2024-12-02 14:08:15',NULL),(17,'f9ff8062-55e6-40af-9e48-e8494f1ff39f',1,'421309904294798','monitor_down','UTILITY','en','{\"name\":\"monitor_down\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now DOWN \\ud83d\\udd34.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"Example\",\"example.com\",\"http:\\/\\/localhost\\/server\\/monitor\\/1\"]]}}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"421309904294798\"}','APPROVED',2,'2024-08-31 14:57:35','2024-12-02 14:08:15',NULL),(18,'675025c7-ced7-4439-b60c-9f3a8a3eb275',2,'1161702508270923','monitor_up','UTILITY','en','{\"name\":\"monitor_up\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now UP \\ud83d\\udfe2.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"Example\",\"example.com\",\"http:\\/\\/localhost\\/server\\/monitor\\/1\"]]}}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"1161702508270923\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(19,'fa6cb4d4-67d2-4924-91ef-4b3d06e1db12',2,'421309904294798','monitor_down','UTILITY','en','{\"name\":\"monitor_down\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now DOWN \\ud83d\\udd34.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"Example\",\"example.com\",\"http:\\/\\/localhost\\/server\\/monitor\\/1\"]]}}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"421309904294798\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(20,'37755d3f-51af-4743-b621-eec84b7245a4',2,'1188764112439503','codevinez_welcome','MARKETING','en','{\"name\":\"codevinez_welcome\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Codevinez Solutions Private limited\"},{\"type\":\"BODY\",\"text\":\"Welcome all\"},{\"type\":\"FOOTER\",\"text\":\"Thank you!\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1188764112439503\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(21,'d2bc78f9-35e6-4c12-b646-f1cecadcd7f2',2,'960671775829675','plan_template','MARKETING','en','{\"name\":\"plan_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey there\"},{\"type\":\"BODY\",\"text\":\"Plan details\"},{\"type\":\"FOOTER\",\"text\":\"Thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"960671775829675\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(22,'a685ac2e-f5d4-40c0-9eab-4b613705a16b',2,'2377858662403950','offer_template_2','MARKETING','en','{\"name\":\"offer_template_2\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey There\"},{\"type\":\"BODY\",\"text\":\"I got a offer for you\"},{\"type\":\"FOOTER\",\"text\":\"Thankyou\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"2377858662403950\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(23,'3f620acc-d0b5-48e0-8964-537535518ae8',2,'1190902175456403','name_template','MARKETING','en','{\"name\":\"name_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hey!\"},{\"type\":\"BODY\",\"text\":\"Hi {{1}},\\r\\nHow are you\",\"example\":{\"body_text\":[[\"Mohan\"]]}},{\"type\":\"FOOTER\",\"text\":\"thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1190902175456403\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(24,'f5201f20-c8ac-4758-8a13-9b8eb1596ab3',2,'758825699598139','docs_campaign','MARKETING','en_GB','{\"name\":\"docs_campaign\",\"components\":[{\"type\":\"HEADER\",\"format\":\"DOCUMENT\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/445686592_758825702931472_9183411969051433344_n.pdf?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=E0Dq4tTssJMQ7kNvgHhl7Hx&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&oh=01_Q5AaILw_RcjVEfArsT_ljXeLZdjg6gOf5Xs_ICWb1sLy6Ati&oe=67075D19\"]}},{\"type\":\"BODY\",\"text\":\"Order invoice No.123456789\"},{\"type\":\"FOOTER\",\"text\":\"Yugmedeals private limited\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"View Invoice\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/invoice\"}]}],\"language\":\"en_GB\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"758825699598139\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(25,'828fc4dd-6eff-4d66-9607-ded44899cd63',2,'1062197588661596','welcome_message','MARKETING','ta','{\"name\":\"welcome_message\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"\\u0b8e\\u0b95\\u0bcd\\u0bae\\u0bbf\\u0b9f\\u0bc0\\u0bb2\\u0bcd\\u0bb8\\u0bcd\"},{\"type\":\"BODY\",\"text\":\"\\u0bb5\\u0ba3\\u0b95\\u0bcd\\u0b95\\u0bae\\u0bcd\"},{\"type\":\"FOOTER\",\"text\":\"\\u0ba8\\u0ba9\\u0bcd\\u0bb1\\u0bbf\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"\\u0b87\\u0baa\\u0bcd\\u0baa\\u0bcb\\u0ba4\\u0bc1 \\u0baa\\u0bbe\\u0bb0\\u0bcd\\u0bb5\\u0bc8\\u0baf\\u0bbf\\u0b9f\\u0bb5\\u0bc1\\u0bae\\u0bcd\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"ta\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1062197588661596\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(26,'236bb3a7-8b2e-40fc-b053-a349ef69ddf3',2,'512264444714633','video_template','MARKETING','en','{\"name\":\"video_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"VIDEO\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/369500748_512264448047966_4428550760143775378_n.mp4?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=4N7jOzUT4ogQ7kNvgHPwgnj&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&oh=01_Q5AaIL5lEjeZYzZDFkrA23mQ2L5KPjK1g5xMJJLGYVj-Vvlk&oe=67077EEB\"]}},{\"type\":\"BODY\",\"text\":\"Food Ordering\"},{\"type\":\"FOOTER\",\"text\":\"Yugmedeals Private Limited\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"Order Now\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"512264444714633\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(27,'8ae9b3e1-a761-4d1d-a01a-deb5de86e9bd',2,'1060822925611080','image_template','MARKETING','en','{\"name\":\"image_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"IMAGE\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/427953643_1060822928944413_7442071328757910060_n.jpg?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=CFeUxj5IVb8Q7kNvgGGOOlr&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&oh=01_Q5AaIDBO1SrhYqcYtZ04IX5RW-nTCe_z0-anOUYUX1t8eFFz&oe=67078096\"]}},{\"type\":\"BODY\",\"text\":\"Yugmedeals Offering best deals\"},{\"type\":\"FOOTER\",\"text\":\"Thankyou\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"PHONE_NUMBER\",\"text\":\"Call Now\",\"phone_number\":\"+919790213730\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1060822925611080\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(28,'5df28cbd-0438-4cbb-a2f1-303f8d348c9f',2,'1714985855907942','sample_template','UTILITY','en_US','{\"name\":\"sample_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hello World\"},{\"type\":\"BODY\",\"text\":\"Welcome and congratulations!! This message demonstrates your ability to send a WhatsApp message notification. Thank you for taking the time to test with us.\"},{\"type\":\"FOOTER\",\"text\":\"WhatsApp Business Platform sample message\"}],\"language\":\"en_US\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"1714985855907942\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(29,'5b54a4fe-5041-46d9-bdd2-605049e0507a',2,'1025383742227498','offer_template','MARKETING','en','{\"name\":\"offer_template\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hurry Flat 50% Off\"},{\"type\":\"BODY\",\"text\":\"Hello {{1}} Grab Flat 50% Off On Adidas T-Shirts\",\"example\":{\"body_text\":[[\"Mohan\"]]}},{\"type\":\"FOOTER\",\"text\":\"Limited Offer\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"URL\",\"text\":\"Buy Now\",\"url\":\"http:\\/\\/www.yugmedeals.com\\/\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1025383742227498\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(30,'a38b1a04-e06f-45d0-b9a2-8469ad4e800e',2,'790749119890071','codevinez_test_campaign','MARKETING','en','{\"name\":\"codevinez_test_campaign\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hello\"},{\"type\":\"BODY\",\"text\":\"Hey there!\"},{\"type\":\"FOOTER\",\"text\":\"Thank you\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"790749119890071\"}','APPROVED',3,'2024-09-10 13:15:39','2024-09-10 13:38:47','2024-11-08 18:15:36'),(31,'17e65a33-2f15-49ab-8163-97d417c840d9',1,'562705059456722','developer_notification_yugmedeals','MARKETING','en','{\"name\":\"developer_notification_yugmedeals\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Yugmedeals Error\"},{\"type\":\"BODY\",\"text\":\"Message : {{1}}  Affected Link : {{2}}\",\"example\":{\"body_text\":[[\"Error Message\",\"link\"]]}}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"562705059456722\"}','APPROVED',2,'2024-10-17 20:01:48','2024-12-02 14:08:15',NULL),(32,'5906406d-6a62-4714-be4d-da7152f83b78',1,'477475385321259','yugmedeals_error_notification','UTILITY','en_US','{\"name\":\"yugmedeals_error_notification\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Yugmedeals Error\"},{\"type\":\"BODY\",\"text\":\"Error_message: {{1}}\\r\\nError_link: {{2}}\\r\\nUser_id: {{3}}\",\"example\":{\"body_text\":[[\"This is Error\",\"https:\\/\\/yugmedeals.com\",\"1\"]]}}],\"language\":\"en_US\",\"status\":\"REJECTED\",\"category\":\"UTILITY\",\"id\":\"477475385321259\"}','REJECTED',2,'2024-10-17 21:32:21','2024-12-02 14:08:15',NULL),(33,'2b159eac-6bfd-451f-8733-70e87a287cc6',9,'590812570142144','test','MARKETING','en','{\"name\":\"test\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"hello\"},{\"type\":\"BODY\",\"text\":\"hi everybody\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"590812570142144\"}','APPROVED',11,'2024-11-30 19:37:28','2024-12-02 07:43:13','2024-12-02 07:45:15'),(34,'6705729f-af24-4ce2-8ac8-cb597a71c374',9,'1069655204777411','test','MARKETING','en','{\"name\":\"test\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Hello\"},{\"type\":\"BODY\",\"text\":\"Hey\"},{\"type\":\"FOOTER\",\"text\":\"yugmedeals\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1069655204777411\"}','APPROVED',11,'2024-12-02 10:50:49','2024-12-02 14:23:03',NULL),(35,'ee98b4b6-8ea4-4ec8-92e2-8e05334100c5',9,'912105217651898','welcome','MARKETING','en','{\"name\":\"welcome\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Welcome to yugmedeals\"},{\"type\":\"BODY\",\"text\":\"Hi there !\"},{\"type\":\"FOOTER\",\"text\":\"Yugmedeals private limited\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"912105217651898\"}','APPROVED',11,'2024-12-02 11:12:26','2024-12-02 14:23:03',NULL),(36,'8d43cc4b-9270-4871-978a-d1779d0f953b',9,'441520128802138','yugmedeals_error_report','MARKETING','en','{\"name\":\"yugmedeals_error_report\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Yugmedeals Error Report\"},{\"type\":\"BODY\",\"text\":\"Message : {{1}} Affected Link : {{2}}\",\"example\":{\"body_text\":[[\"Attempt to read property \\\"name\\\"\",\"https:\\/\\/www.yugmedeals.com\\/trending-categories\\/key\"]]}},{\"type\":\"FOOTER\",\"text\":\"Powered by Yugmedeals Private Limited\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"441520128802138\"}','APPROVED',11,'2024-12-02 14:12:08','2024-12-02 14:23:03',NULL),(37,'d8193e7d-69fa-4ba3-a823-88396a357626',9,'753367356995192','yugmedeals_server_monitor_up','UTILITY','en','{\"name\":\"yugmedeals_server_monitor_up\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Monitor Status\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now UP \\ud83d\\udfe2.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"Yugmedeals\",\"yugmedeals.com\",\"monitor.yugmedeals.com\"]]}},{\"type\":\"FOOTER\",\"text\":\"Powered by Yugmedeals Private Limited\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"753367356995192\"}','APPROVED',11,'2024-12-02 14:17:55','2024-12-02 14:23:03',NULL),(38,'703d5fc1-097e-45a2-925b-ff81e53d846b',9,'3908771596116801','yugmedeals_server_monitor_down','UTILITY','en','{\"name\":\"yugmedeals_server_monitor_down\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Server Down Report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now DOWN \\ud83d\\udd34.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"yugmedeals\",\"yugmedeals.com\",\"monitor.yugmedeals.com\"]]}},{\"type\":\"FOOTER\",\"text\":\"Powered by Yugmedeals Private Limited\"}],\"language\":\"en\",\"status\":\"REJECTED\",\"category\":\"UTILITY\",\"id\":\"3908771596116801\"}','REJECTED',11,'2024-12-02 14:20:02','2024-12-02 14:20:11','2024-12-02 14:20:30'),(39,'ae68edf8-b525-4456-96d9-a103503625f2',9,'1128373712208505','yugmedeals_server_monitor_status_down','UTILITY','en','{\"name\":\"yugmedeals_server_monitor_status_down\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"server report\"},{\"type\":\"BODY\",\"text\":\"Your {{1}} ({{2}}) monitor is now DOWN \\ud83d\\udd34.\\r\\n\\r\\nView all the details at {{3}}\\ud83d\\udd17.\",\"example\":{\"body_text\":[[\"yugmedeals\",\"yugmedeals.com\",\"monitor.yugmedeals.com\"]]}},{\"type\":\"FOOTER\",\"text\":\"Powered by Yugmedeals Private Limited\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"UTILITY\",\"id\":\"1128373712208505\"}','APPROVED',11,'2024-12-02 14:22:47','2024-12-02 14:23:03',NULL),(40,'c882af58-281f-49d8-888b-8b7e177023be',10,'1425343851759340','test_template','UTILITY','en','{\"name\":\"test_template\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"hello\"},{\"type\":\"BODY\",\"text\":\"welcome\"}],\"language\":\"en\",\"status\":\"REJECTED\",\"category\":\"UTILITY\",\"id\":\"1425343851759340\"}','REJECTED',12,'2024-12-05 12:42:33','2024-12-19 13:22:11',NULL),(41,'27489ec7-f7b8-4446-9602-36b0e3591e60',10,'1259760128577355','test_tem','MARKETING','en','{\"name\":\"test_tem\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"hello\"},{\"type\":\"BODY\",\"text\":\"welcome\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1259760128577355\"}','APPROVED',12,'2024-12-05 12:43:28','2024-12-19 13:22:11',NULL),(42,'742ed39d-1675-44e1-889d-553683f627fb',10,'1630356117656821','admission','MARKETING','en','{\"name\":\"admission\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"TEXT\",\"text\":\"Admission open\"},{\"type\":\"BODY\",\"text\":\"Admission open in sri chaitanya\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1630356117656821\"}','APPROVED',12,'2024-12-05 12:56:46','2024-12-19 13:22:11',NULL),(43,'bafd21da-4a12-445c-a56d-d6cc4672f380',10,'1001581802010046','test2','MARKETING','en','{\"name\":\"test2\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"IMAGE\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/455959451_1001581805343379_2833582735365486070_n.jpg?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=x7mKxKrbAZwQ7kNvgG5O6mp&_nc_zt=3&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=A_0q-AUxh1l_MocK8JEaPWD&oh=01_Q5AaIJuo6SaEFmh4vlFcq70VQLdVDS-DMKXNLSkpaxp6iIXS&oe=678B4AF2\"]}},{\"type\":\"BODY\",\"text\":\"admission open\"}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1001581802010046\"}','APPROVED',12,'2024-12-09 11:28:19','2024-12-19 13:22:11',NULL),(44,'529d99fe-1fb6-44cb-aa5f-c2e9e6f47e89',10,'1779161412914413','sri_chaitanya_school_avadi','MARKETING','en','{\"name\":\"sri_chaitanya_school_avadi\",\"parameter_format\":\"POSITIONAL\",\"components\":[{\"type\":\"HEADER\",\"format\":\"IMAGE\",\"example\":{\"header_handle\":[\"https:\\/\\/scontent.whatsapp.net\\/v\\/t61.29466-34\\/459405148_1779161416247746_5854213849072825419_n.jpg?ccb=1-7&_nc_sid=8b1bef&_nc_ohc=FlARpvhFS7IQ7kNvgFH36sN&_nc_zt=3&_nc_ht=scontent.whatsapp.net&edm=AH51TzQEAAAA&_nc_gid=A_0q-AUxh1l_MocK8JEaPWD&oh=01_Q5AaIDuvnxzw5DYscDjHqQrc-dxwjRcWWXJQAZoUkybmnxFa&oe=678B5CF6\"]}},{\"type\":\"BODY\",\"text\":\"Sri Chaitanya is thrilled to announce the opening of our new branch in Avadi! \\ud83c\\udf89 \\r\\nWith our commitment to excellence in education and holistic development, we look forward to shaping the future of young minds in Avadi. \\r\\n\\ud83e\\udd1dJoin us in this exciting journey towards success. Admissions are now open for AY 2025-2026.\\r\\nGive your child the best start up in future education.\\r\\nFor Contact : 7207501821 \\/ 61\"},{\"type\":\"FOOTER\",\"text\":\"Sri Chaitanya Techno School, Avadi\"},{\"type\":\"BUTTONS\",\"buttons\":[{\"type\":\"PHONE_NUMBER\",\"text\":\"For Enquiry\",\"phone_number\":\"+917207501821\"}]}],\"language\":\"en\",\"status\":\"APPROVED\",\"category\":\"MARKETING\",\"id\":\"1779161412914413\"}','APPROVED',12,'2024-12-09 11:33:47','2024-12-19 13:22:11',NULL);

--
-- Table structure for table `ticket_categories`
--

CREATE TABLE `ticket_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticket_categories`
--

INSERT INTO `ticket_categories` VALUES (1,'Signup/login issues'),(2,'Campaigns issues'),(3,'Whatsapp issue'),(4,'Template Issues'),(5,'Chatbot Issues'),(6,'Other');

--
-- Table structure for table `ticket_comments`
--

CREATE TABLE `ticket_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `message` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_comments_ticket_id_foreign` (`ticket_id`),
  KEY `ticket_comments_user_id_foreign` (`user_id`),
  CONSTRAINT `ticket_comments_ticket_id_foreign` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `ticket_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ticket_comments`
--

INSERT INTO `ticket_comments` VALUES (1,1,1,'Select order type',0,'2024-08-21 15:35:28','2024-08-21 15:35:28'),(2,1,2,'can you elaborate',0,'2024-08-21 15:35:52','2024-08-21 15:35:52');

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `subject` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` enum('critical','high','medium','low') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_to` bigint unsigned DEFAULT NULL,
  `status` enum('open','pending','resolved','closed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `closed_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tickets_user_id_foreign` (`user_id`),
  KEY `tickets_category_id_foreign` (`category_id`),
  KEY `tickets_assigned_to_foreign` (`assigned_to`),
  KEY `tickets_closed_by_foreign` (`closed_by`),
  CONSTRAINT `tickets_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`),
  CONSTRAINT `tickets_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `ticket_categories` (`id`),
  CONSTRAINT `tickets_closed_by_foreign` FOREIGN KEY (`closed_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--

INSERT INTO `tickets` VALUES (1,'b458828d-9d20-4173-af77-dc28f24f6aaf','SUP-000001-240821',NULL,2,4,'Template Not Approved','Hi Eazypost Team,\nMy template not approving by whatsapp why',NULL,1,'open',NULL,'2024-08-21 15:33:51','2024-08-21 15:36:12');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `meta` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `plan` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `plan_id` bigint unsigned DEFAULT NULL,
  `will_expire` date DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_deleted_at_unique` (`email`,`deleted_at`),
  UNIQUE KEY `users_facebook_id_unique` (`facebook_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'mohan','sundar','admin@gmail.com',NULL,NULL,'admin',NULL,NULL,NULL,'$2y$10$b7WEPw1hogNHDqfIo26pheSeV0ZijrStecMToJva2qfpEmsI5aCMG',1,NULL,NULL,NULL,NULL,NULL,'2024-08-12 05:26:36','2024-08-21 15:51:45',NULL),(2,'Mohanasundar','P','kiran@yugmedeals.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','2024-12-09 18:00:21','$2y$10$HA3RHRPHEd/I6MyeT5elVew/6ADJEfqbUFx2OrKfdXHeVUfGaoj9q',1,NULL,NULL,NULL,NULL,NULL,'2024-08-13 00:54:47','2024-12-09 18:00:21',NULL),(3,'Kiran','Kumar','kiranvpr@yahoo.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$4W881CiS9P.CWTnSPEXUKuuTX2AMfmRbjjhKGy8xlW4jFM02TG.ei',1,NULL,NULL,NULL,NULL,NULL,'2024-08-16 12:31:30','2024-08-16 12:31:30',NULL),(4,'Facebook','Tester','facebook@test.com',NULL,NULL,'user','+919999999999','{\"street\":\"1 Hacker Way,\",\"city\":\"Menlo Park,\",\"state\":\"California,\",\"zip\":\"94025\",\"country\":\"USA\"}',NULL,'$2y$10$dfKGMn8QxGhvBs3Ej3/hIuwprqw9FQxTWE5nbl0LFrG2Dlw016eDy',1,NULL,NULL,NULL,NULL,NULL,'2024-08-17 07:53:28','2024-08-17 07:53:28',NULL),(5,'Armin','Neimke','berkay_schlicht@mteen.net',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$XpdnlmDBr1VDhpWJIkeIV.TRKmoHIcvNiIN4MD7M7yw2OwWWkNuYa',1,NULL,NULL,NULL,NULL,NULL,'2024-08-18 07:51:59','2024-08-18 07:51:59',NULL),(6,'F','B','tester@example.com',NULL,NULL,'user',NULL,'{\"street\":\"Anna Nagar\",\"city\":\"Chennai\",\"state\":\"tamil nadu\",\"zip\":\"6000021\",\"country\":\"india\"}',NULL,'$2y$10$UTYRxnoETx8QoH9AFPX5b.ml6SSmH9b2rEwADWirWsL6lg1uOeKk6',1,NULL,NULL,NULL,NULL,NULL,'2024-09-12 15:13:39','2024-09-12 15:13:39',NULL),(7,'Thanush','Veerappan','vthanush666@gmail.com',NULL,NULL,'user','+937397187850','{\"street\":\"NO: 179 Chennai Salai Arumbaruthi\",\"city\":\"Vellore\",\"state\":\"Tamil Nadu\",\"zip\":\"632106\",\"country\":\"India\"}',NULL,'$2y$10$i4MpqRtXx4fxH8iyauggTeAauKfwwJ1jpGkLaEY6r90KvQF3s.lVa',1,NULL,NULL,NULL,NULL,NULL,'2024-09-29 22:57:35','2024-09-29 22:57:35',NULL),(8,'Raje','Kan','ragi9193@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$KgDYSyFBKu4cYJpjp2Q/jOU3gqhy5XqRSL7rbfyUg51W6tkVVHXOO',1,NULL,NULL,NULL,NULL,NULL,'2024-10-11 19:07:17','2024-10-11 19:12:27',NULL),(9,'Amber','Vos','anna_brouwer@ourtimesupport.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$T8yPT/meYiw5hIygIco9fethQib3HRr0ZtSJ.VTGvl3/3W.jimNSa',1,NULL,NULL,NULL,NULL,NULL,'2024-11-05 01:45:47','2024-11-05 01:45:47',NULL),(10,'Xuz','V','suryavprakash.01@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$2KjxgafPc5jMyOKy6TZx/..rqZUuUDzh0T29HuvuKs2ooewzuX.iu',1,NULL,NULL,NULL,NULL,NULL,'2024-11-28 11:29:48','2024-11-28 11:29:48',NULL),(11,'Yugmedeals','Official','contactus@yugmedeals.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','2024-12-03 18:43:01','$2y$10$0HCJDTNJ5iSG5VGVC90hmeTi/xor4xCfocSKAxh9ZR7M5RrRvbeI.',1,NULL,NULL,NULL,NULL,NULL,'2024-11-28 11:34:42','2024-12-03 18:43:01',NULL),(12,'Sri chaitanya','poonamalle','sctstamilnadu@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','2024-12-05 11:10:05','$2y$10$ApD90csghaXfX4k4YJ4ODuMSsMAnCrFYrNNXMD30ygGXD1.vkXglG',1,NULL,NULL,NULL,NULL,NULL,'2024-12-02 15:20:28','2024-12-05 11:10:05',NULL),(13,'Dhavid','Allwin','dhavidallwin22@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}',NULL,'$2y$10$PbnWgbDTzUBRC.iR6Sr.Cevsz8ci3.evN5Aa3jvL0bA1zwOG5wOre',1,NULL,NULL,NULL,NULL,NULL,'2024-12-04 16:57:49','2024-12-04 16:57:49',NULL),(14,'Surya','V','suryastonecold811.01@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','2024-12-05 14:10:57','$2y$10$qH71Aih6mO5RJ35jrS.ebuoDcIx1bdCUnblzpMHeN0Q8GAFiyD4iK',1,NULL,NULL,NULL,NULL,NULL,'2024-12-05 13:44:23','2024-12-05 14:10:57',NULL),(15,'Sundar','Mohan','mohanpmv.1@gmail.com',NULL,NULL,'user',NULL,'{\"street\":null,\"city\":null,\"state\":null,\"zip\":null,\"country\":null}','2024-12-17 15:04:06','$2y$10$21WCkLb08K3KF65oyLgfZOjWQT9I1rKGHptMJnHVzSQL5oG2OS64i',1,NULL,NULL,NULL,NULL,NULL,'2024-12-17 15:03:24','2024-12-17 15:04:06',NULL);


