--
-- Host: localhost    Database: dugasoil_lawfirm
-- ------------------------------------------------------


--
-- Table structure for table `add_ons`
--

CREATE TABLE `add_ons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monthly_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yearly_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_enable` tinyint(1) NOT NULL DEFAULT '0',
  `package_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `add_ons`
--

INSERT INTO `add_ons` VALUES (1,'CarService','Car Service','0','0',NULL,1,'car-service','2025-05-15 01:09:23','2025-05-15 01:11:17'),(2,'GoogleCaptcha','Google Captcha','0','0',NULL,1,'google-captcha','2025-05-15 01:09:23','2025-05-15 01:11:17'),(3,'LandingPage','cms','0','0',NULL,1,'landing-page','2025-05-15 01:09:23','2025-05-15 01:11:17'),(4,'Paypal','Paypal','0','0',NULL,1,'paypal','2025-05-15 01:09:23','2025-05-15 01:11:17'),(5,'Photography','Photography','0','0',NULL,1,'photography','2025-05-15 01:09:23','2025-05-15 01:11:17'),(6,'Stripe','Stripe','0','0',NULL,1,'stripe','2025-05-15 01:09:23','2025-05-15 01:11:17');

--
-- Table structure for table `appointment_payments`
--

CREATE TABLE `appointment_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `appointment_id` bigint unsigned DEFAULT NULL,
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_date` date NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appointment_payments_appointment_id_foreign` (`appointment_id`),
  KEY `appointment_payments_business_id_foreign` (`business_id`),
  KEY `appointment_payments_created_by_foreign` (`created_by`),
  CONSTRAINT `appointment_payments_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointment_payments_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointment_payments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `appointment_payments`
--


--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `location_id` bigint unsigned NOT NULL,
  `service_id` bigint unsigned NOT NULL,
  `staff_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` longtext COLLATE utf8mb4_unicode_ci,
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appointment_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_field` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appointments_location_id_foreign` (`location_id`),
  KEY `appointments_service_id_foreign` (`service_id`),
  KEY `appointments_staff_id_foreign` (`staff_id`),
  KEY `appointments_business_id_foreign` (`business_id`),
  KEY `appointments_created_by_foreign` (`created_by`),
  CONSTRAINT `appointments_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  CONSTRAINT `appointments_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `appointments`
--


--
-- Table structure for table `bank_transfer_payments`
--

CREATE TABLE `bank_transfer_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `price_currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'USD',
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int NOT NULL,
  `business` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_transfer_payments`
--


--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blogs_business_id_foreign` (`business_id`),
  KEY `blogs_created_by_foreign` (`created_by`),
  CONSTRAINT `blogs_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blogs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--


--
-- Table structure for table `business_holidays`
--

CREATE TABLE `business_holidays` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_holidays_business_id_foreign` (`business_id`),
  KEY `business_holidays_created_by_foreign` (`created_by`),
  CONSTRAINT `business_holidays_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `business_holidays_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_holidays`
--


--
-- Table structure for table `business_hours`
--

CREATE TABLE `business_hours` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `day_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `day_off` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off',
  `break_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `business_hours_business_id_foreign` (`business_id`),
  KEY `business_hours_created_by_foreign` (`created_by`),
  CONSTRAINT `business_hours_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `business_hours_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_hours`
--


--
-- Table structure for table `businesses`
--

CREATE TABLE `businesses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_disable` int NOT NULL DEFAULT '1',
  `form_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `layouts` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `theme_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `businesses_created_by_foreign` (`created_by`),
  CONSTRAINT `businesses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `businesses`
--

INSERT INTO `businesses` VALUES (1,'WorkDo','active','workdo-2',1,'form-layout','Formlayout1','color1-Formlayout1',2,'2025-05-15 01:09:22','2025-05-15 01:09:22');

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--


--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_business_id_foreign` (`business_id`),
  KEY `categories_created_by_foreign` (`created_by`),
  CONSTRAINT `categories_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_us_business_id_foreign` (`business_id`),
  CONSTRAINT `contact_us_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us`
--


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

CREATE TABLE `coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` double NOT NULL DEFAULT '0',
  `limit` int NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES ('Leke','ALL','Lek'),('Dollars','USD','$'),('Afghanis','AFN','؋'),('Pesos','ARS','$'),('Guilders','AWG','ƒ'),('Dollars','AUD','$'),('New Manats','AZN','ман'),('Dollars','BSD','$'),('Dollars','BBD','$'),('Rubles','BYR','p.'),('Euro','EUR','€'),('Dollars','BZD','BZ$'),('Dollars','BMD','$'),('Bolivianos','BOB','$b'),('Convertible Marka','BAM','KM'),('Pula','BWP','P'),('Leva','BGN','лв'),('Reais','BRL','R$'),('Pounds','GBP','£'),('Dollars','BND','$'),('Riels','KHR','៛'),('Dollars','CAD','$'),('Dollars','KYD','$'),('Pesos','CLP','$'),('Yuan Renminbi','CNY','¥'),('Pesos','COP','$'),('Colón','CRC','₡'),('Kuna','HRK','kn'),('Pesos','CUP','₱'),('Koruny','CZK','Kč'),('Kroner','DKK','kr'),('Pesos','DOP','RD$'),('Dollars','XCD','$'),('Pounds','EGP','£'),('Colones','SVC','$'),('Pounds','FKP','£'),('Dollars','FJD','$'),('Cedis','GHC','¢'),('Pounds','GIP','£'),('Quetzales','GTQ','Q'),('Pounds','GGP','£'),('Dollars','GYD','$'),('Lempiras','HNL','L'),('Dollars','HKD','$'),('Forint','HUF','Ft'),('Kronur','ISK','kr'),('Rupees','INR','Rp'),('Rupiahs','IDR','Rp'),('Rials','IRR','﷼'),('Pounds','IMP','£'),('New Shekels','ILS','₪'),('Dollars','JMD','J$'),('Yen','JPY','¥'),('Pounds','JEP','£'),('Tenge','KZT','лв'),('Won','KPW','₩'),('Won','KRW','₩'),('Soms','KGS','лв'),('Kips','LAK','₭'),('Lati','LVL','Ls'),('Pounds','LBP','£'),('Dollars','LRD','$'),('Switzerland Francs','CHF','CHF'),('Litai','LTL','Lt'),('Denars','MKD','ден'),('Ringgits','MYR','RM'),('Rupees','MUR','₨'),('Pesos','MXN','$'),('Tugriks','MNT','₮'),('Meticais','MZN','MT'),('Dollars','NAD','$'),('Rupees','NPR','₨'),('Guilders','ANG','ƒ'),('Dollars','NZD','$'),('Cordobas','NIO','C$'),('Nairas','NGN','₦'),('Krone','NOK','kr'),('Rials','OMR','﷼'),('Rupees','PKR','₨'),('Balboa','PAB','B/.'),('Guarani','PYG','Gs'),('Nuevos Soles','PEN','S/.'),('Pesos','PHP','Php'),('Zlotych','PLN','zł'),('Rials','QAR','﷼'),('New Lei','RON','lei'),('Rubles','RUB','₽'),('Pounds','SHP','£'),('Riyals','SAR','﷼'),('Dinars','RSD','Дин.'),('Rupees','SCR','₨'),('Dollars','SGD','$'),('Dollars','SBD','$'),('Shillings','SOS','S'),('Rand','ZAR','R'),('Rupees','LKR','₨'),('Kronor','SEK','kr'),('Dollars','SRD','$'),('Pounds','SYP','£'),('New Dollars','TWD','NT$'),('Baht','THB','฿'),('Dollars','TTD','TT$'),('Lira','TRY','₺'),('Liras','TRL','£'),('Dollars','TVD','$'),('Hryvnia','UAH','₴'),('Pesos','UYU','$U'),('Sums','UZS','лв'),('Bolivares Fuertes','VEF','Bs'),('Dong','VND','₫'),('Rials','YER','﷼'),('Zimbabwe Dollars','ZWD','Z$'),('Bahraini Dinar','BHD','$'),('Turkish lira','TL','₺'),('United Arab Emirates Dirham','AED','د.إ'),('West African CFA franc','XOF','CFA'),('Bangladeshi taka','BDT','৳');

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `option` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_fields_business_id_foreign` (`business_id`),
  KEY `custom_fields_created_by_foreign` (`created_by`),
  CONSTRAINT `custom_fields_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `custom_fields_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_fields`
--


--
-- Table structure for table `custom_statuses`
--

CREATE TABLE `custom_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_statuses_business_id_foreign` (`business_id`),
  KEY `custom_statuses_created_by_foreign` (`created_by`),
  CONSTRAINT `custom_statuses_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `custom_statuses_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_statuses`
--


--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_user_id_foreign` (`user_id`),
  KEY `customers_business_id_foreign` (`business_id`),
  KEY `customers_created_by_foreign` (`created_by`),
  CONSTRAINT `customers_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `customers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--


--
-- Table structure for table `email_template_langs`
--

CREATE TABLE `email_template_langs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL DEFAULT '0',
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `module_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variables` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `email_template_langs_chk_1` CHECK (json_valid(`variables`))
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_template_langs`
--

INSERT INTO `email_template_langs` VALUES (1,1,'ar','Login Detail','<p>مرحبا،&nbsp;<br>مرحبا بك في {app_name}.</p><p><b>البريد الإلكتروني </b>: {email}<br><b>كلمه السر</b> : {password}</p><p>{app_url}</p><p>شكر،<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(2,1,'da','Login Detail','<p>Hej,&nbsp;<br>Velkommen til {app_name}.</p><p><b>E-mail </b>: {email}<br><b>Adgangskode</b> : {password}</p><p>{app_url}</p><p>Tak,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(3,1,'de','Login Detail','<p>Hallo,&nbsp;<br>Willkommen zu {app_name}.</p><p><b>Email </b>: {email}<br><b>Passwort</b> : {password}</p><p>{app_url}</p><p>Vielen Dank,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(4,1,'en','Login Detail','<p>Hello,&nbsp;<br />Welcome to {app_name}</p>\n                    <p><strong>Email </strong>: {email}<br /><strong>Password</strong> : {password}</p>\n                    <p>{app_url}</p>\n                    <p>Thanks,<br />{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(5,1,'es','Login Detail','<p>Hola,&nbsp;<br>Bienvenido a {app_name}.</p><p><b>Correo electrónico </b>: {email}<br><b>Contraseña</b> : {password}</p><p>{app_url}</p><p>Gracias,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(6,1,'fr','Login Detail','<p>Bonjour,&nbsp;<br>Bienvenue à {app_name}.</p><p><b>Email </b>: {email}<br><b>Mot de passe</b> : {password}</p><p>{app_url}</p><p>Merci,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(7,1,'it','Login Detail','<p>Ciao,&nbsp;<br>Benvenuto a {app_name}.</p><p><b>E-mail </b>: {email}<br><b>Parola d\'ordine</b> : {password}</p><p>{app_url}</p><p>Grazie,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(8,1,'ja','Login Detail','<p>こんにちは、&nbsp;<br>へようこそ {app_name}.</p><p><b>Eメール </b>: {email}<br><b>パスワード</b> : {password}</p><p>{app_url}</p><p>おかげで、<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(9,1,'nl','Login Detail','<p>Hallo,&nbsp;<br>Welkom bij {app_name}.</p><p><b>E-mail </b>: {email}<br><b>Wachtwoord</b> : {password}</p><p>{app_url}</p><p>Bedankt,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(10,1,'pl','Login Detail','<p>Witaj,&nbsp;<br>Witamy w {app_name}.</p><p><b>E-mail </b>: {email}<br><b>Hasło</b> : {password}</p><p>{app_url}</p><p>Dzięki,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(11,1,'ru','Login Detail','<p>Привет,&nbsp;<br>Добро пожаловать в {app_name}.</p><p><b>Электронное письмо </b>: {email}<br><b>пароль</b> : {password}</p><p>{app_url}</p><p>Спасибо,<br>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(12,1,'pt','Login Detail','<p>Ol&aacute;, Bem-vindo a {app_name}.</p>\n                    <p>E-mail: {email}</p>\n                    <p>Senha: {password}</p>\n                    <p>{app_url}</p>\n                    <p>&nbsp;</p>\n                    <p>Obrigado,</p>\n                    <p>{app_name}</p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(13,1,'tr','Login Detail','<p>Merhaba,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}a hoş geldiniz</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">E-posta: {email}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Şifre : {şifre}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_url}</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Teşekkürler,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{uygulama ismi}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Email\": \"email\",\n                    \"Password\": \"password\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(14,2,'ar','Appointment Details','<p>مرحبًا،</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">نشكرك على حجز موعد معنا في {app_name}. يسعدنا تأكيد تفاصيل موعدك:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">رقم الموعد: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">تاريخ الموعد: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">وقت الموعد: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">الخدمة: {خدمة}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">الموقع: {الموقع}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">طاقم العمل: {طاقم العمل}</span></p><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">تتبع الموعد</a></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">لقد تم جدولة موعدك بنجاح. إذا كنت بحاجة إلى إجراء أي تغييرات أو كانت لديك أي أسئلة، فلا تتردد في التواصل معنا.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">نحن نتطلع إلى مقابلتك وتقديم خدمة ممتازة لك. نشكرك على اختيار {app_name} لاحتياجات موعدك.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">شكرًا،<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم الشركة}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم التطبيق}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(15,2,'da','Appointment Details','<p>Hej,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Tak, fordi du reserverede en tid hos os på {app_name}. Vi er glade for at kunne bekræfte dine aftaledetaljer:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftalenummer: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaledato: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaletidspunkt: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service: {service}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Placering: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personale: {staff}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Spor aftale</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Din aftale er blevet planlagt. Hvis du har brug for at foretage ændringer eller har spørgsmål, så tøv ikke med at kontakte os.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Vi glæder os til at møde dig og give dig en fremragende service. Tak, fordi du valgte {app_name} til dine aftalebehov.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Tak,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{firmanavn}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(16,2,'de','Appointment Details','<p>Hallo,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Vielen Dank, dass Sie einen Termin bei uns unter {app_name} gebucht haben. Wir freuen uns, Ihre Termindetails zu bestätigen:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Terminnummer: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {Dienst}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Standort: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Mitarbeiter: {Mitarbeiter}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Termin verfolgen</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ihr Termin wurde erfolgreich vereinbart. Wenn Sie Änderungen vornehmen müssen oder Fragen haben, zögern Sie bitte nicht, uns zu kontaktieren.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Wir freuen uns darauf, Sie kennenzulernen und Ihnen einen exzellenten Service zu bieten. Vielen Dank, dass Sie sich für {app_name} für Ihren Terminbedarf entschieden haben.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Danke,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Name der Firma}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{App Name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(17,2,'en','Appointment Details','<p><font color=\"#1d1c1d\" face=\"Slack-Lato, Slack-Fractions, appleLogo, sans-serif\"><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures;\">Hello,</span></font></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Thank you for booking an appointment with us at {app_name}. Were excited to confirm your appointment details:<br></span><span style=\"background-color: var(--bs-card-bg); color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures; font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\"><br>Appointment Number: {appointment_number}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Date: {appointment_date}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Time: {appointment_time}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service: {service}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Location: {location}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Staff: {staff}</span></p><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Track Appointment</a></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Your appointment has been successfully scheduled. If you need to make any changes or have any questions, please dont hesitate to reach out to us.<br></span><span style=\"background-color: var(--bs-card-bg); color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-variant-ligatures: common-ligatures; font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Were looking forward to meeting you and providing you with excellent service. Thank you for choosing {app_name} for your appointment needs.</span></p><p><span style=\"background-color: var(--bs-card-bg); text-align: var(--bs-body-text-align); font-size: 15px; font-variant-ligatures: common-ligatures;\"><font color=\"#1d1c1d\" face=\"Slack-Lato, Slack-Fractions, appleLogo, sans-serif\">Thanks</font></span><span style=\"background-color: var(--bs-card-bg); text-align: var(--bs-body-text-align);\"><font color=\"#1d1c1d\" face=\"Slack-Lato, Slack-Fractions, appleLogo, sans-serif\"><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; font-weight: var(--bs-body-font-weight);\">,</span></font><br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{company_name}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(18,2,'es','Appointment Details','<p>Hola,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Gracias por reservar una cita con nosotros en {app_name}. Nos complace confirmar los detalles de su cita:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Número de cita: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Fecha de la cita: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hora de la cita: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servicio: {servicio}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ubicación: {ubicación}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personal: {personal}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Seguimiento de cita</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Su cita ha sido programada exitosamente. Si necesita realizar algún cambio o tiene alguna pregunta, no dude en comunicarse con nosotros.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Esperamos conocerlo y brindarle un excelente servicio. Gracias por elegir {app_name} para sus necesidades de citas.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Gracias,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de la aplicación}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(19,2,'fr','Appointment Details','<p>Bonjour,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Merci davoir pris rendez-vous avec nous à {app_name}. Nous sommes ravis de confirmer les détails de votre rendez-vous :</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numéro de rendez-vous : {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Date de rendez-vous : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Heure du rendez-vous : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service : {service}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Emplacement : {emplacement}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personnel : {personnel}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Suivre un rendez-vous</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Votre rendez-vous a été planifié avec succès. Si vous devez apporter des modifications ou si vous avez des questions, nhésitez pas à nous contacter.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Nous avons hâte de vous rencontrer et de vous offrir un excellent service. Merci davoir choisi {app_name} pour vos besoins en matière de rendez-vous.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Merci,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nom de lentreprise}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nom de lapplication}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(20,2,'it','Appointment Details','<p>Ciao,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Grazie per aver prenotato un appuntamento con noi presso {app_name}. Siamo entusiasti di confermare i dettagli del tuo appuntamento:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numero dellappuntamento: {appuntamento_numero}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data dellappuntamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Orario dellappuntamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servizio: {servizio}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Posizione: {posizione}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personale: {personale}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Tieni traccia dell\'appuntamento</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Il tuo appuntamento è stato pianificato con successo. Se hai bisogno di apportare modifiche o hai domande, non esitare a contattarci.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Non vediamo lora di incontrarvi e di fornirvi un servizio eccellente. Grazie per aver scelto {app_name} per le tue esigenze di appuntamento.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Grazie,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nome della ditta}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome dellapplicazione}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(21,2,'ja','Appointment Details','<p>こんにちは、</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name} でのご予約をいただきありがとうございます。ご予約の詳細を確認させていただきます。</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約番号: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約日: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約時間: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">サービス: {サービス}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">場所: {場所}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">スタッフ: {スタッフ}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">予約を追跡する</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予定が正常に設定されました。変更が必要な場合やご質問がある場合は、お気軽にお問い合わせください。<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">皆様にお会いし、優れたサービスを提供できることを楽しみにしています。ご予約のニーズに {app_name} をお選びいただきありがとうございます。</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">ありがとう、<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{会社名}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{アプリ名}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(22,2,'nl','Appointment Details','<p>Hallo,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Bedankt dat u een afspraak bij ons heeft geboekt op {app_name}. We zijn verheugd om uw afspraakgegevens te bevestigen:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraaknummer: {afspraaknummer}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraakdatum: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraaktijd: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {dienst}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Locatie: {locatie}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personeel: {personeel}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Afspraak bijhouden</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Uw afspraak is succesvol ingepland. Als u wijzigingen wilt aanbrengen of vragen heeft, aarzel dan niet om contact met ons op te nemen.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Wij kijken ernaar uit u te ontmoeten en u een uitstekende service te bieden. Bedankt dat u {app_name} heeft gekozen voor uw afspraakbehoeften.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Bedankt,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Bedrijfsnaam}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{applicatie naam}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(23,2,'pl','Appointment Details','<p>Cześć,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dziękujemy za rezerwację spotkania z nami w {app_name}. Z przyjemnością potwierdzimy szczegóły Twojej wizyty:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numer spotkania: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data spotkania: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Godzina spotkania: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Usługa: {usługa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Lokalizacja: {lokalizacja}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personel: {personel}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Śledź spotkanie</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Twoja wizyta została pomyślnie zaplanowana. Jeśli chcesz wprowadzić jakieś zmiany lub masz jakieś pytania, nie wahaj się z nami skontaktować.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Nie możemy się doczekać spotkania z Tobą i zapewnienia doskonałej obsługi. Dziękujemy, że wybrałeś aplikację {app_name} do celów związanych z spotkaniami.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dzięki,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa firmy}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa aplikacji}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(24,2,'ru','Appointment Details','<p>Привет,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Благодарим вас за запись к нам на встречу в {app_name}. Мы рады подтвердить детали вашей встречи:</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Номер встречи: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Дата встречи: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Время встречи: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Сервис: {сервис}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Местоположение: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Персонал: {сотрудник}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Отследить встречу</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ваша встреча успешно назначена. Если вам нужно внести какие-либо изменения или у вас есть какие-либо вопросы, пожалуйста, не стесняйтесь обращаться к нам.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Мы с нетерпением ждем встречи с вами и предоставления вам отличного сервиса. Благодарим вас за выбор {app_name} для назначения встреч.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Спасибо,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Название компании}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Имя приложения}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(25,2,'pt','Appointment Details','<p>Olá,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Obrigado por marcar uma consulta conosco em {app_name}. Temos o prazer de confirmar os detalhes do seu agendamento:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Número do agendamento: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data do agendamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Horário do agendamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Serviço: {serviço}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Localização: {local}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Equipe: {equipe}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Acompanhar compromisso</a></p></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Seu compromisso foi agendado com sucesso. Se você precisar fazer alguma alteração ou tiver alguma dúvida, não hesite em nos contatar.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Estamos ansiosos para conhecê-lo e oferecer-lhe um excelente serviço. Obrigado por escolher o {app_name} para suas necessidades de agendamento.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Obrigado,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome da empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome do aplicativo}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(26,2,'tr','Appointment Details','<p><font color=\"#1d1c1d\" face=\"Slack-Lato, Slack-Fractions, appleLogo, sans-serif\"><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures;\">Merhaba,</span></font></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Bizimle {app_name} üzerinden randevu aldığınız için teşekkür ederiz. Randevu ayrıntılarınızı onaylamaktan heyecan duyuyoruz:</span><br></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Numarası: {appointment_number}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Tarihi: {appointment_date}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Saati: {appointment_time}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hizmet: {hizmet}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Konum: {konum}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personel: {personel}</span><p><a href=\"{tracking_url}\" style=\"background-color: #2d3748; color: white; padding: 10px 20px; text-align: center; text-decoration: none; border-radius: 5px; display: inline-block; font-weight: bold;\">Randevuyu Takip Et</a></p></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevunuz başarıyla planlandı. Herhangi bir değişiklik yapmanız gerekiyorsa veya herhangi bir sorunuz varsa lütfen bizimle iletişime geçmekten çekinmeyin.<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Sizinle tanışmak ve size mükemmel hizmet sunmak için sabırsızlanıyoruz. Randevu ihtiyaçlarınız için {app_name} uygulamasını seçtiğiniz için teşekkür ederiz.</span></p><p><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Teşekkürler,<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Firma Adı}<br></span><span style=\"font-size: 15px; font-variant-ligatures: common-ligatures; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{uygulama ismi}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"Tracking URL\": \"tracking_url\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(27,3,'ar','Appointment Status Change','<p>مرحبًا،</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">أردنا إبلاغك بالتحديث الأخير بخصوص موعدك معنا في {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">فيما يلي التفاصيل المحدثة:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">رقم الموعد : {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">تاريخ الموعد : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">وقت الموعد : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">الخدمة : {خدمة}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">تم تحديث حالة موعدك. يرجى مراجعة التغييرات وإعلامنا إذا كان لديك أي أسئلة أو استفسارات.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">نشكرك على اختيار {app_name} لاحتياجات موعدك. نحن نقدر ثقتكم بنا ونتطلع لخدمتكم.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">شكرًا،<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم الشركة}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم التطبيق}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(28,3,'da','Appointment Status Change','<p>Hej,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Vi vil gerne informere dig om en nylig opdatering vedrørende din aftale med os på {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Her er de opdaterede detaljer:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftalenummer: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaledato: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaletidspunkt: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service: {service}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Din aftalestatus er blevet opdateret. Gennemgå ændringerne, og lad os vide, hvis du har spørgsmål eller bekymringer.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Tak, fordi du valgte {app_name} til dine aftalebehov. Vi værdsætter din tillid til os og ser frem til at tjene dig.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Tak,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{firmanavn}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(29,3,'de','Appointment Status Change','<p>Hallo,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Wir wollten Sie über ein aktuelles Update bezüglich Ihres Termins bei uns bei {app_name} informieren.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hier sind die aktualisierten Details:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Terminnummer: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {Dienst}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ihr Terminstatus wurde aktualisiert. Bitte überprüfen Sie die Änderungen und teilen Sie uns mit, wenn Sie Fragen oder Bedenken haben.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Vielen Dank, dass Sie sich für {app_name} für Ihren Terminbedarf entschieden haben. Wir wissen Ihr Vertrauen zu schätzen und freuen uns darauf, Sie zu betreuen.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Danke,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Name der Firma}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{App Name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(30,3,'en','Appointment Status Change','<p>Hello,&nbsp;</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">We wanted to inform you about a recent update regarding your appointment with us at {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Here are the updated details:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Number : {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Date : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Time : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service : {service}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Your appointment status has been updated. Please review the changes and let us know if you have any questions or concerns.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Thank you for choosing {app_name} for your appointment needs. We value your trust in us and look forward to serving you.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Thanks,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{company_name}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(31,3,'es','Appointment Status Change','<p>Hola,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Queríamos informarle sobre una actualización reciente sobre su cita con nosotros en {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aquí están los detalles actualizados:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Número de cita: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Fecha de la cita: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hora de la cita: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servicio: {servicio}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">El estado de su cita ha sido actualizado. Revise los cambios y avísenos si tiene alguna pregunta o inquietud.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Gracias por elegir {app_name} para sus necesidades de citas. Valoramos su confianza en nosotros y esperamos poder servirle.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Gracias,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de la aplicación}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(32,3,'fr','Appointment Status Change','<p>Bonjour,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Nous souhaitions vous informer dune mise à jour récente concernant votre rendez-vous avec nous à {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Voici les détails mis à jour :</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numéro de rendez-vous : {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Date de rendez-vous : {appointment_date}|<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Heure du rendez-vous : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service : {service}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Le statut de votre rendez-vous a été mis à jour. Veuillez examiner les modifications et faites-nous savoir si vous avez des questions ou des préoccupations.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Merci davoir choisi {app_name} pour vos besoins en matière de rendez-vous. Nous apprécions votre confiance en nous et sommes impatients de vous servir.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Merci,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nom de lentreprise}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nom de lapplication}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(33,3,'it','Appointment Status Change','<p>Ciao,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Volevamo informarti di un recente aggiornamento riguardante il tuo appuntamento con noi presso {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ecco i dettagli aggiornati:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numero dellappuntamento: {appuntamento_numero}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data dellappuntamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Orario dellappuntamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servizio: {servizio}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Lo stato del tuo appuntamento è stato aggiornato. Ti invitiamo a rivedere le modifiche e a farci sapere se hai domande o dubbi.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Grazie per aver scelto {app_name} per le tue esigenze di appuntamento. Apprezziamo la tua fiducia in noi e non vediamo lora di servirti.</span></p><p>Grazie,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nome della ditta}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome dellapplicazione}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(34,3,'ja','Appointment Status Change','<p>こんにちは、</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name} でのご予約に関する最新情報をお知らせいたします。<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">更新された詳細は次のとおりです。</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約番号 : {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約日 : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約時間 : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">サービス : {サービス}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約状況が更新されました。変更内容をご確認いただき、ご質問やご不明な点がございましたらお知らせください。<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">ご予約のニーズに {app_name} をお選びいただきありがとうございます。私たちはお客様の信頼を大切にし、お客様のお役にたてることを楽しみにしています。</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">ありがとう、<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{会社名}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{アプリ名}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(35,3,'nl','Appointment Status Change','<p>Hallo,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">We willen u informeren over een recente update over uw afspraak bij ons op {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hier zijn de bijgewerkte details:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraaknummer: {afspraaknummer}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraakdatum: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraaktijd: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {dienst}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Uw afspraakstatus is bijgewerkt. Controleer de wijzigingen en laat het ons weten als u vragen of opmerkingen heeft.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Bedankt dat u {app_name} heeft gekozen voor uw afspraakbehoeften. Wij waarderen uw vertrouwen in ons en kijken ernaar uit u van dienst te zijn.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Bedankt,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Bedrijfsnaam}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{applicatie naam}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(36,3,'pl','Appointment Status Change','<p>Cześć,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Chcieliśmy poinformować Cię o ostatniej aktualizacji dotyczącej Twojej wizyty w firmie {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Oto zaktualizowane szczegóły:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Numer spotkania: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data spotkania: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Godzina spotkania: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Usługa: {usługa}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Status Twojego spotkania został zaktualizowany. Zapoznaj się ze zmianami i daj nam znać, jeśli masz jakiekolwiek pytania lub wątpliwości.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dziękujemy, że wybrałeś aplikację {app_name} do celów związanych z spotkaniami. Cenimy Twoje zaufanie i cieszymy się, że możemy Ci służyć.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dzięki,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa firmy}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa aplikacji}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(37,3,'ru','Appointment Status Change','<p>Привет,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Мы хотели сообщить вам о недавней новости о вашей встрече с нами в {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Вот обновленные подробности:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Номер встречи: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Дата встречи: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Время встречи: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Сервис: {сервис}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Статус вашей встречи обновлен. Пожалуйста, ознакомьтесь с изменениями и сообщите нам, если у вас возникнут какие-либо вопросы или замечания.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Благодарим вас за выбор {app_name} для назначения встреч. Мы ценим ваше доверие к нам и с нетерпением ждем возможности служить вам.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Спасибо,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Название компании}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Имя приложения}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(38,3,'pt','Appointment Status Change','<p>Olá,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Gostaríamos de informá-lo sobre uma atualização recente sobre seu compromisso conosco em {app_name}.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aqui estão os detalhes atualizados:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Número do agendamento: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data do agendamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Horário do agendamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Serviço: {serviço}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">O status do seu agendamento foi atualizado. Revise as alterações e informe-nos se tiver alguma dúvida ou preocupação.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Obrigado por escolher o {app_name} para suas necessidades de agendamento. Valorizamos sua confiança em nós e estamos ansiosos para atendê-lo.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Obrigado,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome da empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome do aplicativo}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(39,3,'tr','Appointment Status Change','<p>Merhaba,</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name} uygulamasında bizimle randevunuzla ilgili son güncelleme hakkında sizi bilgilendirmek istedik.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">İşte güncellenen ayrıntılar:</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Numarası: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Tarihi : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Saati : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hizmet: {hizmet}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu durumunuz güncellendi. Lütfen değişiklikleri inceleyin ve herhangi bir sorunuz veya endişeniz varsa bize bildirin.<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu ihtiyaçlarınız için {app_name} uygulamasını seçtiğiniz için teşekkür ederiz. Bize olan güveninize değer veriyoruz ve size hizmet etmek için sabırsızlanıyoruz.</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Teşekkürler,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Firma Adı}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{uygulama ismi}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(40,4,'ar','Appointment Reminder','<p>مرحبًا {العميل}،</p><p>نأمل أن تجدك هذه الرسالة بخير.</p><p>هذا تذكير ودي بموعدك القادم مع {app_name}. التفاصيل هنا:</p><p>رقم الموعد: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">تاريخ الموعد: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">وقت الموعد: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">الخدمة: {خدمة}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">الموقع: {الموقع}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">طاقم العمل: {طاقم العمل}</span></p><p>نحن نتطلع إلى الترحيب بك في {appointment_date} في {appointment_time}. إذا كنت بحاجة إلى إجراء أي تغييرات أو كانت لديك أي أسئلة، فلا تتردد في الاتصال بنا.</p><p>شكرًا،<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم الشركة}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{اسم التطبيق}</span></p><div><br></div>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(41,4,'da','Appointment Reminder','<p>Hej {kunde}</p><p>Vi håber, at denne besked finder dig godt.</p><p>Dette er en venlig påmindelse om din kommende aftale med {app_name}. Her er detaljerne:</p><p>Aftalenummer: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaledato: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Aftaletidspunkt: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service: {service}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Placering: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personale: {staff}</span></p><p>Vi ser frem til at byde dig velkommen den {appointment_date} kl. {appointment_time}. Hvis du har brug for at foretage ændringer eller har spørgsmål, så tøv ikke med at kontakte os.</p><p>Tak,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{firmanavn}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(42,4,'de','Appointment Reminder','<p>Hallo {Kunde},</p><p>Wir hoffen, dass diese Nachricht Sie gut findet.</p><p>Dies ist eine freundliche Erinnerung an Ihren bevorstehenden Termin mit {app_name}. Hier sind die Details:</p><p>Terminnummer: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Termin: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {Dienst}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Standort: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Mitarbeiter: {Mitarbeiter}</span></p><p>Wir freuen uns, Sie am {appointment_date} um {appointment_time} begrüßen zu dürfen. Wenn Sie Änderungen vornehmen müssen oder Fragen haben, zögern Sie bitte nicht, mit uns Kontakt aufzunehmen.</p><p>Danke,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Name der Firma}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{App Name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(43,4,'en','Appointment Reminder','<p>Hello {customer},&nbsp;</p><p>We hope this message finds you well.</p><p>This is a friendly reminder of your upcoming appointment with {app_name}. Here are the details:</p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Number: {appointment_number}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Date: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Appointment Time: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service: {service}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Location: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Staff: {staff}</span></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">We look forward to welcoming you on {appointment_date} at {appointment_time}. If you need to make any changes or have any questions, please dont hesitate to get in touch with us.</span><br></p><p><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Thanks,<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{company_name}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{app_name}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(44,4,'es','Appointment Reminder','<p>Hola {cliente},</p><p>Esperamos que este mensaje te encuentre bien.</p><p>Este es un recordatorio amistoso de su próxima cita con {app_name}. Aquí están los detalles:</p><p>Número de cita: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Fecha de la cita: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hora de la cita: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servicio: {servicio}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Ubicación: {ubicación}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personal: {personal}</span></p><p>Esperamos darle la bienvenida el {appointment_date} a las {appointment_time}. Si necesita realizar algún cambio o tiene alguna pregunta, no dude en ponerse en contacto con nosotros.</p><p>Gracias,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nombre de la aplicación}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(45,4,'fr','Appointment Reminder','<p>Bonjour {client},</p><p>Nous espérons que ce message vous trouvera bien.</p><p>Ceci est un rappel amical de votre prochain rendez-vous avec {app_name}. Voici les détails:</p><p>Numéro de rendez-vous : {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Date de rendez-vous : {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Heure du rendez-vous : {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Service : {service}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Emplacement : {emplacement}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personnel : {personnel}</span></p><p>Nous sommes impatients de vous accueillir le {appointment_date} à {appointment_time}. Si vous devez apporter des modifications ou si vous avez des questions, nhésitez pas à nous contacter.</p><p>Merci,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nom de lentreprise}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nom de lapplication}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(46,4,'it','Appointment Reminder','<p>Ciao {cliente},</p><p>Ci auguriamo che questo messaggio ti trovi bene.</p><p>Questo è un promemoria amichevole del tuo prossimo appuntamento con {app_name}. Ecco i dettagli:</p><p>Numero dellappuntamento: {appuntamento_numero}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data dellappuntamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Orario dellappuntamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Servizio: {servizio}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Posizione: {posizione}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personale: {personale}</span></p><p>Non vediamo lora di darti il ​​benvenuto il {appointment_date} alle {appointment_time}. Se hai bisogno di apportare modifiche o hai domande, non esitare a contattarci.</p><p>Grazie,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nome della ditta}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome dellapplicazione}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(47,4,'ja','Appointment Reminder','<p>こんにちは、{顧客} 様</p><p>このメッセージがあなたに元気を与えてくれることを願っています。</p><p>これは、{app_name} との今後の予定についてのフレンドリーなリマインダーです。詳細は次のとおりです。</p><p>予約番号: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約日: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">予約時間: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">サービス: {サービス}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">場所: {場所}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">スタッフ: {スタッフ}</span></p><p>{appointment_date} の {appointment_time} にお会いできることを楽しみにしています。変更が必要な場合やご質問がある場合は、お気軽にお問い合わせください。</p><p>ありがとう、<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{会社名}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{アプリ名}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(48,4,'nl','Appointment Reminder','<p>Hallo {klant},</p><p>Wij hopen dat dit bericht u goed treft.</p><p>Dit is een vriendelijke herinnering aan uw aanstaande afspraak met {app_name}. Hier zijn de details:</p><p>Afspraaknummer: {afspraaknummer}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraakdatum: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Afspraaktijd: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Dienst: {dienst}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Locatie: {locatie}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personeel: {personeel}</span></p><p>We kijken ernaar uit u te verwelkomen op {appointment_date} om {appointment_time}. Als u wijzigingen wilt aanbrengen of vragen heeft, aarzel dan niet om contact met ons op te nemen.</p><p>Bedankt,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Bedrijfsnaam}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{applicatie naam}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(49,4,'pl','Appointment Reminder','<p>Witaj {kliencie},</p><p>Mamy nadzieję, że ta wiadomość zastanie Cię w dobrym zdrowiu.</p><p>To przyjazne przypomnienie o zbliżającym się spotkaniu w aplikacji {app_name}. Oto szczegóły:</p><p>Numer spotkania: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data spotkania: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Godzina spotkania: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Usługa: {usługa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Lokalizacja: {lokalizacja}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personel: {personel}</span></p><p>Czekamy na Ciebie w dniu {appointment_date} o godzinie {appointment_time}. Jeśli chcesz wprowadzić jakieś zmiany lub masz jakieś pytania, nie wahaj się z nami skontaktować.</p><p>Dzięki,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa firmy}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Nazwa aplikacji}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(50,4,'ru','Appointment Reminder','<p>Здравствуйте, {customer}!</p><p>Мы надеемся, что это сообщение застанет вас в добром здравии.</p><p>Это дружеское напоминание о вашей предстоящей встрече с {app_name}. Вот подробности:</p><p>Номер встречи: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Дата встречи: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Время встречи: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Сервис: {сервис}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Местоположение: {location}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Персонал: {сотрудник}</span></p><p>Мы с нетерпением ждем встречи с вами {appointment_date} в {appointment_time}. Если вам нужно внести какие-либо изменения или у вас есть какие-либо вопросы, пожалуйста, не стесняйтесь обращаться к нам.</p><p>Спасибо,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Название компании}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Имя приложения}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(51,4,'pt','Appointment Reminder','<p>Olá {cliente},</p><p>Esperamos que esta mensagem o encontre bem.</p><p>Este é um lembrete amigável do seu próximo compromisso com {app_name}. Aqui estão os detalhes:</p><p>Número do agendamento: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Data do agendamento: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Horário do agendamento: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Serviço: {serviço}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Localização: {local}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Equipe: {equipe}</span></p><p>Esperamos recebê-lo em {appointment_date} às {appointment_time}. Se precisar fazer alguma alteração ou tiver alguma dúvida, não hesite em entrar em contato conosco.</p><p>Obrigado,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome da empresa}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{nome do aplicativo}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21'),(52,4,'tr','Appointment Reminder','<p>Merhaba {müşteri},</p><p>Bu mesajın sizi iyi bulacağını umuyoruz.</p><p>Bu, {app_name} ile yaklaşan randevunuzla ilgili dostça bir hatırlatmadır. Detaylar burada:</p><p>Randevu Numarası: {appointment_number}<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Tarihi: {appointment_date}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Randevu Saati: {appointment_time}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Hizmet: {hizmet}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Konum: {konum}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">Personel: {personel}</span></p><p>Sizi {appointment_date} tarihinde, {appointment_time} saatinde karşılamayı sabırsızlıkla bekliyoruz. Herhangi bir değişiklik yapmanız gerekiyorsa veya herhangi bir sorunuz varsa, lütfen bizimle iletişime geçmekten çekinmeyin.</p><p>Teşekkürler,<br><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{Firma Adı}<br></span><span style=\"background-color: var(--bs-card-bg); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">{uygulama ismi}</span></p>',NULL,'{\n                    \"App Name\": \"app_name\",\n                    \"Company Name\": \"company_name\",\n                    \"App Url\": \"app_url\",\n                    \"Appointment Number\": \"appointment_number\",\n                    \"Appointment Date\": \"appointment_date\",\n                    \"Appointment Time\": \"appointment_time\",\n                    \"Service \": \"service\",\n                    \"Location \": \"location\",\n                    \"Staff\": \"staff\",\n                    \"customer\": \"customer\"\n                  }','2025-05-15 01:09:21','2025-05-15 01:09:21');

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

CREATE TABLE `email_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `business_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_templates` VALUES (1,'New User','BookingGo','general',1,0,'2025-05-15 01:09:21','2025-05-15 01:09:21'),(2,'Create Appointment','BookingGo','general',1,0,'2025-05-15 01:09:21','2025-05-15 01:09:21'),(3,'Appointment Status Change','BookingGo','general',1,0,'2025-05-15 01:09:21','2025-05-15 01:09:21'),(4,'Appointment Reminder','BookingGo','general',1,0,'2025-05-15 01:09:21','2025-05-15 01:09:21');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext 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 `files`
--

CREATE TABLE `files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `files_business_id_foreign` (`business_id`),
  KEY `files_created_by_foreign` (`created_by`),
  CONSTRAINT `files_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `files_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--


--
-- Table structure for table `join_us`
--

CREATE TABLE `join_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `join_us_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `join_us`
--


--
-- Table structure for table `landing_page_settings`
--

CREATE TABLE `landing_page_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `landing_page_settings_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_page_settings`
--

INSERT INTO `landing_page_settings` VALUES (1,'is_top_bar_active','on','2025-05-15 01:41:36','2025-05-15 01:42:33'),(2,'topbar_notification_msg','70% Special Offer. Don’t Miss it. The offer ends in 72 hours.','2025-05-15 01:41:45','2025-05-15 01:41:45'),(3,'is_buildtech_section_active','on','2025-05-15 01:41:59','2025-05-15 01:43:35'),(4,'is_faq_section_active','on','2025-05-15 01:42:00','2025-05-15 01:42:54'),(5,'is_package_details_section_active','on','2025-05-15 01:42:01','2025-05-15 01:43:03'),(6,'is_dedicated_section_active','on','2025-05-15 01:42:02','2025-05-15 01:43:21'),(7,'is_screenshots_section_active','on','2025-05-15 01:42:03','2025-05-15 01:43:15'),(8,'is_reviews_section_active','on','2025-05-15 01:42:05','2025-05-15 01:43:42'),(9,'is_features_section_active','on','2025-05-15 01:42:11','2025-05-15 01:42:44'),(10,'highlight_feature_heading','Why choose dedicated modules for Your Business?','2025-05-15 01:42:16','2025-05-15 01:42:16'),(11,'highlight_feature_description','With BookingGo, you can conveniently manage all your business functions from a single location.','2025-05-15 01:42:16','2025-05-15 01:42:16'),(12,'packagedetails_section_status','off','2025-05-15 01:43:09','2025-05-15 01:43:09'),(13,'packagedetails_heading','Start an Online Fashion Business with a Complete eCommerce Package','2025-05-15 01:43:09','2025-05-15 01:43:09'),(14,'packagedetails_short_description','Get a fashion-themed eCommerce store with a secure backend and convenient mobile app. Build a brand, manage your store wherever you are, and grow an online business.','2025-05-15 01:43:09','2025-05-15 01:43:09'),(15,'packagedetails_long_description','An effective fashion theme should be visually appealing and easy to navigate. A good theme makes it easy for customers to find and buy the items they’re interested in. The theme should also be responsive so that it looks good on all devices.With the Style theme, you get all of the above - and more. The theme gives you everything you need to sell your products and keep your audience coming back for more. Easily customize the theme and adjust its design to your branding needs. Add products, polish product pages, and start growing your online business.','2025-05-15 01:43:09','2025-05-15 01:43:09'),(16,'packagedetails_link','https://bookinggo-demo.workdo.io/login','2025-05-15 01:43:09','2025-05-15 01:43:09'),(17,'packagedetails_button_text','Get the Package','2025-05-15 01:43:09','2025-05-15 01:43:09'),(18,'dedicated_section_status','off','2025-05-15 01:43:22','2025-05-15 01:43:22'),(19,'dedicated_heading','Why Choose a Dedicated Fashion Theme for Your Business?','2025-05-15 01:43:22','2025-05-15 01:43:22'),(20,'dedicated_description','With Alligō, you can take care of the entire partner lifecycle - from onboarding through nurturing, cooperating, and rewarding. Find top performers and let go of those who arent a good fit.','2025-05-15 01:43:22','2025-05-15 01:43:22'),(21,'dedicated_live_demo_link','https://bookinggo-demo.workdo.io/login','2025-05-15 01:43:22','2025-05-15 01:43:22'),(22,'dedicated_link_button_text','View Live Demo','2025-05-15 01:43:22','2025-05-15 01:43:22'),(23,'buildtech_section_status','off','2025-05-15 01:43:35','2025-05-15 01:43:35'),(24,'buildtech_heading','Built with Technology You Can Trust','2025-05-15 01:43:35','2025-05-15 01:43:35'),(25,'buildtech_description','Our backend is built with Laravel - one of the most popular and highest-rated web development frameworks. Find out why we chose it - and how it benefits your business.','2025-05-15 01:43:35','2025-05-15 01:43:35');

--
-- Table structure for table `landingpage_pixels`
--

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

--
-- Dumping data for table `landingpage_pixels`
--


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

CREATE TABLE `languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` VALUES (1,'ar','Arabic','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(2,'da','Danish','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(3,'de','German','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(4,'en','English','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(5,'es','Spanish','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(6,'fr','French','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(7,'it','Italian','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(8,'ja','Japanese','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(9,'nl','Dutch','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(10,'pl','Polish','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(11,'pt','Portuguese','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(12,'ru','Russian','1','2025-05-15 01:09:19','2025-05-15 01:09:19'),(13,'tr','Turkish','1','2025-05-15 01:09:19','2025-05-15 01:09:19');

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` longtext COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `locations_business_id_foreign` (`business_id`),
  KEY `locations_created_by_foreign` (`created_by`),
  CONSTRAINT `locations_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `locations_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locations`
--


--
-- Table structure for table `login_details`
--

CREATE TABLE `login_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int NOT NULL,
  `business` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_details_business_foreign` (`business`),
  CONSTRAINT `login_details_business_foreign` FOREIGN KEY (`business`) REFERENCES `businesses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_details`
--

INSERT INTO `login_details` VALUES (1,'1','102.176.75.75','2025-05-15 03:13:06','{\"status\":\"success\",\"country\":\"Ghana\",\"countryCode\":\"GH\",\"region\":\"AA\",\"regionName\":\"Greater Accra Region\",\"city\":\"Accra\",\"zip\":\"\",\"lat\":5.5545,\"lon\":-0.1902,\"timezone\":\"Africa\\/Accra\",\"isp\":\"Vodafone Ghana\",\"org\":\"Ghana Telecommunications Company Limited\",\"as\":\"AS29614 Ghana Telecommunications Company Limited\",\"query\":\"102.176.75.75\",\"browser_name\":\"Opera\",\"os_name\":\"Windows\",\"browser_language\":\"en\",\"device_type\":\"desktop\",\"referrer_host\":true,\"referrer_path\":true}','super admin',1,NULL,'2025-05-15 01:13:06','2025-05-15 01:13:06'),(2,'2','102.176.75.75','2025-05-15 13:23:44','{\"status\":\"success\",\"country\":\"Ghana\",\"countryCode\":\"GH\",\"region\":\"AA\",\"regionName\":\"Greater Accra Region\",\"city\":\"Accra\",\"zip\":\"\",\"lat\":5.5545,\"lon\":-0.1902,\"timezone\":\"Africa\\/Accra\",\"isp\":\"Vodafone Ghana\",\"org\":\"Ghana Telecommunications Company Limited\",\"as\":\"AS29614 Ghana Telecommunications Company Limited\",\"query\":\"102.176.75.75\",\"browser_name\":\"Opera\",\"os_name\":\"Windows\",\"browser_language\":\"en\",\"device_type\":\"desktop\",\"referrer_host\":true,\"referrer_path\":true}','company',2,1,'2025-05-15 11:23:44','2025-05-15 11:23:44');

--
-- Table structure for table `marketplace_page_settings`
--

CREATE TABLE `marketplace_page_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=139 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketplace_page_settings`
--

INSERT INTO `marketplace_page_settings` VALUES (1,'product_main_banner','','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(2,'product_main_status','on','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(3,'product_main_heading','CarService','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(4,'product_main_description','<p>This theme prioritizes your clients experience. Imagine them effortlessly booking appointments directly through your BookingGo page, selecting their date, time, and the specific service needed (oil change, tire rotation, diagnostics, etc.) with just a few clicks. The platform also facilitates clear communication. You can answer client questions, confirm details, and even send automated appointment reminders – all within a centralized and organized platform. This eliminates confusion and ensures a smooth experience for your customers, leaving them feeling valued and informed.</p>','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(5,'product_main_demo_link','#','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(6,'product_main_demo_button_text','View Live Demo','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(7,'dedicated_theme_heading','BookingGo Car Services ThemeEmpowers Your Business','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(8,'dedicated_theme_description','<p>Running a car service business should not feel like navigating a stormy sea. BookingGo Car Services Theme is your trusty captain, offering a user-friendly online platform that streamlines your workflow, builds trust with clients, and frees you up to focus on smooth sailing – delivering exceptional service</p>','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(9,'dedicated_theme_sections','[\n            { \n                \"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Transparency Builds Trustworthy Relationships\",\n                \"dedicated_theme_section_description\":\"<p>BookingGo  Car Services Theme is your compass, guiding you towards building trust and establishing your expertise.  Customize your page with your company logo, brand colors, and high-quality photos showcasing your clean, well-equipped workshop and your friendly team. This personalized touch fosters trust with potential clients, demonstrating professionalism and a commitment to quality service.  Additionally, dedicate a section to clearly explain your service offerings. Outline service packages with detailed descriptions and transparent pricing structures. This allows clients to make informed decisions and choose the service that best suits their needs and budget, eliminating any surprises or hidden fees.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            },\n            {\"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Focus on Your Expertise, Not Marketing Maneuvers\",\n                \"dedicated_theme_section_description\":\"<p>With BookingGo, you can spend less time on marketing gymnastics and more time focusing on what you do best – providing top-notch car service. The theme allows for effortless promotion through seamless integration with social media platforms. You can easily share special promotions and showcase your expertise through service-specific posts. Furthermore, integrate a testimonial section where satisfied clients can sing your praises. These positive reviews act as powerful social proof, attracting new customers and reaffirming your reputation for excellent service.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            },\n            {\"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Streamlined Operations for a Well-Oiled Machine\",\n                \"dedicated_theme_section_description\":\"<p>BookingGo  Car Services Theme goes beyond just scheduling. It seamlessly integrates with existing appointment management and invoicing software, eliminating the need for manual data entry. This reduces the risk of errors and saves you valuable time, allowing you to focus on serving your clients. Additionally, the platform enables online payment options, offering your clients a secure and convenient way to settle their bills. This streamlines the entire process, freeing you and your staff to focus on what matters most – providing exceptional car service.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            }\n        ]','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(10,'dedicated_theme_sections_heading','','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(11,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"CarService\"},{\"screenshots\":\"\",\"screenshots_heading\":\"CarService\"},{\"screenshots\":\"\",\"screenshots_heading\":\"CarService\"},{\"screenshots\":\"\",\"screenshots_heading\":\"CarService\"},{\"screenshots\":\"\",\"screenshots_heading\":\"CarService\"}]','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(12,'addon_heading','Why choose dedicated modules for Your Business?','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(13,'addon_description','<p>With BookingGo, you can conveniently manage all your business functions from a single location.</p>','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(14,'addon_section_status','on','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(15,'whychoose_heading','Why choose dedicated modules for Your Business?','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(16,'whychoose_description','<p>With BookingGO, you can conveniently manage all your business functions from a single location.</p>','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(17,'pricing_plan_heading','Empower Your Workforce with BookingGo','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(18,'pricing_plan_description','<p>Access over Premium Add-ons for Stripe, Paypal, Google Recaptcha and more, all in one place!</p>','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(19,'pricing_plan_demo_link','#','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(20,'pricing_plan_demo_button_text','View Live Demo','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(21,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(22,'whychoose_sections_status','on','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(23,'dedicated_theme_section_status','on','CarService','2025-05-15 01:10:44','2025-05-15 01:10:44'),(24,'product_main_banner','','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(25,'product_main_status','on','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(26,'product_main_heading','Google Captcha','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(27,'product_main_description','<p>To start using reCAPTCHA, you need to sign up for an API key pair for your site. The key pair consists of a site key and secret key. The site key is used to invoke reCAPTCHA service on your site or mobile application. The secret key authorizes communication between your application backend and the reCAPTCHA server to verify the user`s response. The secret key needs to be kept safe for security purposes.</p>','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(28,'product_main_demo_link','#','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(29,'product_main_demo_button_text','View Live Demo','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(30,'dedicated_theme_heading','Google Captcha','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(31,'dedicated_theme_description','<p>Google Captcha, or reCAPTCHA, is a security tool that prevents automated bots from spamming websites. It presents challenges to users, ensuring they are human and not malicious bots. This helps protect online forms and enhance overall website security.</p>','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(32,'dedicated_theme_sections','[{\"dedicated_theme_section_image\": \"\",\"dedicated_theme_section_heading\": \"What Is ReCAPTCHA?\",\n              \"dedicated_theme_section_description\": \"CAPTCHA stands for Completely Automated Public Turing Test to tell Computers and Humans Apart. CAPTCHA is essentially a simple test that verifies that human website users are not malicious bots intent on enacting fraud and abuse on a site. Google has its own version of CAPTCHA, which is called reCAPTCHA. reCAPTCHA is a free service that uses an advanced risk analysis engine and adaptive CAPTCHAs to protect websites from abusive automated software.\",\"dedicated_theme_section_cards\": {\"1\": {\"title\": \"\",\"description\": \"\"}}},{\"dedicated_theme_section_image\": \"\",\n              \"dedicated_theme_section_heading\": \"Why Your Website Needs ReCAPTCHA\",\n              \"dedicated_theme_section_description\": \"Hackers, bad bots, and malicious software can wreak havoc on websites that don\'t have the proper protection — like reCAPTCHA — in place. To outsmart bad bots, you need the right tools working for your website. That\'s where reCAPTCHA comes in. Let\'s dive into how to set it up on your Morweb-powered site.\",\n              \"dedicated_theme_section_cards\": {\"1\": {\"title\": \"\",\"description\": \"\"}}}]','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(33,'dedicated_theme_sections_heading','','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(34,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"GoogleCaptcha\"},{\"screenshots\":\"\",\"screenshots_heading\":\"GoogleCaptcha\"},{\"screenshots\":\"\",\"screenshots_heading\":\"GoogleCaptcha\"}]','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(35,'addon_heading','Why choose dedicated modulesfor Your Business?','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(36,'addon_description','<p>With BookingGo, you can conveniently manage all your business functions from a single location.</p>','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(37,'addon_section_status','on','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(38,'whychoose_heading','Why choose dedicated modulesfor Your Business?','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(39,'whychoose_description','<p>With BookingGo, you can conveniently manage all your business functions from a single location.</p>','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(40,'pricing_plan_heading','Empower Your Workforce with BookingGo','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(41,'pricing_plan_description','<p>Access over Premium Add-ons for Stripe , Paypal , Google Recaptcha, and more, all in one place!</p>','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(42,'pricing_plan_demo_link','#','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(43,'pricing_plan_demo_button_text','View Live Demo','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(44,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(45,'whychoose_sections_status','on','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(46,'dedicated_theme_section_status','on','GoogleCaptcha','2025-05-15 01:10:44','2025-05-15 01:10:44'),(47,'product_main_banner','','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(48,'product_main_status','on','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(49,'product_main_heading','LandingPage','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(50,'product_main_description','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(51,'product_main_demo_link','#','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(52,'product_main_demo_button_text','View Live Demo','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(53,'dedicated_theme_heading','Lorem Ipsum is simply dummy text of the printing and typesetting industry.','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(54,'dedicated_theme_description','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(55,'dedicated_theme_sections','[\n                                                {\n                                                    \"dedicated_theme_section_image\": \"\",\n                                                    \"dedicated_theme_section_heading\": \"Lorem Ipsum\",\n                                                    \"dedicated_theme_section_description\": \"Lorem Ipsum is simply dummy text of the printing and typesetting industry. \",\n                                                    \"dedicated_theme_section_cards\": {\n                                                    \"1\": {\n                                                        \"title\": \"Lorem Ipsum\",\n                                                        \"description\": \"Lorem Ipsum is simply dummy text of the printing and typesetting industry. .\"\n                                                    },\n                                                    \"2\": {\n                                                    \"title\": \"Lorem Ipsum\",\n                                                        \"description\": \"Lorem Ipsum is simply dummy text of the printing and typesetting industry. .\"\n                                                    },\n                                                    \"3\": {\n                                                    \"title\": \"Lorem Ipsum\",\n                                                        \"description\": \"Lorem Ipsum is simply dummy text of the printing and typesetting industry. .\"\n                                                    }\n                                                    }\n                                                }\n                                            ]','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(56,'dedicated_theme_sections_heading','','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(57,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"LandingPage\"},{\"screenshots\":\"\",\"screenshots_heading\":\"LandingPage\"},{\"screenshots\":\"\",\"screenshots_heading\":\"LandingPage\"},{\"screenshots\":\"\",\"screenshots_heading\":\"LandingPage\"},{\"screenshots\":\"\",\"screenshots_heading\":\"LandingPage\"}]','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(58,'addon_heading','What is Lorem Ipsum?','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(59,'addon_description','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(60,'addon_section_status','on','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(61,'whychoose_heading','What is Lorem Ipsum?','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(62,'whychoose_description','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(63,'pricing_plan_heading','What is Lorem Ipsum?','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(64,'pricing_plan_description','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry.</p>','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(65,'pricing_plan_demo_link','#','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(66,'pricing_plan_demo_button_text','View Live Demo','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(67,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(68,'whychoose_sections_status','on','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(69,'dedicated_theme_section_status','on','LandingPage','2025-05-15 01:10:44','2025-05-15 01:10:44'),(70,'product_main_banner','','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(71,'product_main_status','on','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(72,'product_main_heading','Paypal','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(73,'product_main_description','<p>Check out faster, safer and more easily with PayPal, the service that lets you pay, send money, and accept payments without having to enter your financial details each time. PayPal prioritizes enabling secure transactions to allow users to send and receive money electronically. Compared to credit cards, PayPal can be considered as safe.</p>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(74,'product_main_demo_link','#','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(75,'product_main_demo_button_text','View Live Demo','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(76,'dedicated_theme_heading','<h2>Paypal<b> Payment</b> Getway</h2>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(77,'dedicated_theme_description','<p>Compared to credit cards, PayPal can be considered as safe.</p>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(78,'dedicated_theme_sections','[{\"dedicated_theme_section_image\":\"\",\"dedicated_theme_section_heading\":\"What are the benefits of using PayPal?\",\"dedicated_theme_section_description\":\"<p>PayPal is a fast, secure way to pay online. We help you make purchases at millions of online stores in the U.S. and across more than 200 global markets – all without the hassle of converting currency. It’s free to sign up for an account and download our app to receive and send money. We also make it quick and simple to make automatic payments for all your monthly bills and subscriptions.<\\/p>\",\"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}},{\"dedicated_theme_section_image\":\"\",\"dedicated_theme_section_heading\":\"The Advantages of Using PayPal\",\"dedicated_theme_section_description\":\"<p>PayPal. It features a robust, widely accessible system. You can create a free PayPal account and start receiving payments within minutes. Of course, using PayPal now and then is one thing, but setting it as your default payment system is another. Assess the platform’s advantages and gauge how they’ll benefit your freelance business.<\\/p>\",\"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}}]','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(79,'dedicated_theme_sections_heading','','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(80,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"Paypal\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Paypal\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Paypal\"}]','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(81,'addon_heading','<h2>Why choose dedicated modules<b> for Your Business?</b></h2>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(82,'addon_description','<p>with BookingGo, you can conveniently manage all your business functions from a single location.</p>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(83,'addon_section_status','on','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(84,'whychoose_heading','Why choose dedicated modulesfor Your Business?','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(85,'whychoose_description','<p>with BookingGo, you can conveniently manage all your business functions from a single location.</p>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(86,'pricing_plan_heading','Empower Your Workforce with BookingGo','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(87,'pricing_plan_description','<p>Access over Premium Add-ons for Stripe, Paypal, Google Recaptcha Communication, Management, and more, all in one place!</p>','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(88,'pricing_plan_demo_link','#','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(89,'pricing_plan_demo_button_text','View Live Demo','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(90,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(91,'whychoose_sections_status','on','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(92,'dedicated_theme_section_status','on','Paypal','2025-05-15 01:10:44','2025-05-15 01:10:44'),(93,'product_main_banner','','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(94,'product_main_status','on','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(95,'product_main_heading','Photography','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(96,'product_main_description','<p>Go beyond static galleries. This theme allows you to curate your photographic journey. Organize high-resolution images by themes, projects, or even chronological order to tell a visual story. Do not just display photos; showcase them in stunning slideshows with captivating captions that delve into your creative process. This allows potential clients to not only see your technical skills but also understand the emotions and experiences you strive to capture in your work.</p>','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(97,'product_main_demo_link','#','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(98,'product_main_demo_button_text','View Live Demo','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(99,'dedicated_theme_heading','The BookingGo Photography Theme A Deep Dive','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(100,'dedicated_theme_description','<p>The BookingGo Photography Theme is more than just a pretty face for your online presence. It is a comprehensive toolbox designed to empower you, the photographer, to not only showcase your work in a stunning and captivating way but also to streamline your entire workflow and connect with clients seamlessly.</p>','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(101,'dedicated_theme_sections','[\n            { \n                \"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Transforming Browsers into Engaged Clients\",\n                \"dedicated_theme_section_description\":\"<p>This theme goes beyond aesthetics. It fosters engagement and interaction with potential clients.  Strategically placed calls to action, like Book Now buttons and contact forms, make it easy for visitors to connect with you for inquiries and schedule sessions directly through BookingGo intuitive scheduling system.  Furthermore, you can showcase special packages and promotions directly within your galleries, sparking interest and driving potential clients to take the next step.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            },\n            {\"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Effortless Booking Management & Client Communication\",\n                \"dedicated_theme_section_description\":\"<p>BookingGo streamlines your booking process, freeing you up to focus on what you do best capturing stunning photographs.  Clients can book sessions directly through your BookingGo powered website, eliminating the need for back-and-forth emails and phone calls. The platform also facilitates two way communication, allowing you to answer client questions, discuss details, and prepare for the shoot  all within a centralized and organized space. This not only saves you time but also ensures a smooth and efficient experience for both you and your clients.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            },\n            {\"dedicated_theme_section_image\":\"\",\n                \"dedicated_theme_section_heading\":\"Building Trust & Credibility\",\n                \"dedicated_theme_section_description\":\"<p>Positive word of mouth is powerful, and this theme allows you to leverage it. Integrate a dedicated testimonial section where you can display glowing reviews from satisfied clients.  These testimonials serve as social proof,  building trust and credibility with potential clients who may be unfamiliar with your work.  Knowing that others have had positive experiences with your services puts them at ease and makes them more likely to choose you for their photography needs.<\\/p>\",\n                \"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}\n            }\n        ]','Photography','2025-05-15 01:10:44','2025-05-15 01:10:44'),(102,'dedicated_theme_sections_heading','','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(103,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"Photography\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Photography\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Photography\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Photography\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Photography\"}]','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(104,'addon_heading','Why choose dedicated modules for Your Business?','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(105,'addon_description','<p>With BookingGo, you can conveniently manage all your business functions from a single location.</p>','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(106,'addon_section_status','on','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(107,'whychoose_heading','Why choose dedicated modules for Your Business?','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(108,'whychoose_description','<p>With BookingGO, you can conveniently manage all your business functions from a single location.</p>','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(109,'pricing_plan_heading','Empower Your Workforce with BookingGo','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(110,'pricing_plan_description','<p>Access over Premium Add-ons for Stripe, Paypal, Google Recaptcha and more, all in one place!</p>','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(111,'pricing_plan_demo_link','#','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(112,'pricing_plan_demo_button_text','View Live Demo','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(113,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(114,'whychoose_sections_status','on','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(115,'dedicated_theme_section_status','on','Photography','2025-05-15 01:10:45','2025-05-15 01:10:45'),(116,'product_main_banner','','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(117,'product_main_status','on','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(118,'product_main_heading','Stripe','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(119,'product_main_description','<p>Stripe is an online payment processing and credit card processing platform for businesses. When a customer buys a product online, the funds need to be delivered to the seller Insert Stripe. Stripe allows safe and efficient processing of funds via credit card or bank and transfers those funds to the sellers account.</p>','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(120,'product_main_demo_link','#','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(121,'product_main_demo_button_text','View Live Demo','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(122,'dedicated_theme_heading','Stripe Payment Gateway','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(123,'dedicated_theme_description','<p>Stripe is an online payment processing and credit card processing platform for businesses.</p>','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(124,'dedicated_theme_sections','[{\"dedicated_theme_section_image\":\"\",\"dedicated_theme_section_heading\":\"Why use Stripe payment?\",\"dedicated_theme_section_description\":\"<p>Stripe Payments is a powerful payment processor for online sales. It can accept dozens of payment methods and more than 135 currencies. And its advanced developer tools allow you to create a checkout flow that feels custom, provided you know how to use them.<\\/p>\",\"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}},{\"dedicated_theme_section_image\":\"\",\"dedicated_theme_section_heading\":\"Stripe payment gateway\",\"dedicated_theme_section_description\":\"<p>Stripe users can accept in-person payments by integrating the company’s point-of-sale option, Stripe Terminal. But if you do most of your business in person, there are better options. For example, other payment processors, such as Square, offer specific restaurant and retail features like end-of-day reports and inventory tracking.That said, Stripe’s flat-rate pricing is easy to understand and there are no monthly fees. In addition, you can cancel at any time if it isn’t a good fit.<\\/p>\",\"dedicated_theme_section_cards\":{\"1\":{\"title\":null,\"description\":null}}}]','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(125,'dedicated_theme_sections_heading','','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(126,'screenshots','[{\"screenshots\":\"\",\"screenshots_heading\":\"Stripe\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Stripe\"},{\"screenshots\":\"\",\"screenshots_heading\":\"Stripe\"}]','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(127,'addon_heading','Why choose dedicated modulesfor Your Business?','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(128,'addon_description','<p>with BookingGo, you can conveniently manage all your business functions from a single location.</p>','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(129,'addon_section_status','on','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(130,'whychoose_heading','Why choose dedicated modulesfor Your Business?','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(131,'whychoose_description','<p>with BookingGo, you can conveniently manage all your business functions from a single location.</p>','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(132,'pricing_plan_heading','Empower Your Workforce with BookingGo','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(133,'pricing_plan_description','<p>Access over Premium Add-ons for Stripe, Paypal, Google Recaptcha Communication, Management, and more, all in one place!</p>','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(134,'pricing_plan_demo_link','#','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(135,'pricing_plan_demo_button_text','View Live Demo','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(136,'pricing_plan_text','{\"1\":{\"title\":\"Pay-as-you-go\"},\"2\":{\"title\":\"Unlimited installation\"},\"3\":{\"title\":\"Secure cloud storage\"}}','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(137,'whychoose_sections_status','on','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45'),(138,'dedicated_theme_section_status','on','Stripe','2025-05-15 01:10:45','2025-05-15 01:10:45');

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

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

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000001_create_cache_table',1),(2,'2014_10_12_000000_create_users_table',1),(3,'2014_10_12_100000_create_password_reset_tokens_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2019_05_03_000002_create_subscriptions_table',1),(6,'2019_05_03_000003_create_receipts_table',1),(7,'2019_05_03_000003_create_subscription_items_table',1),(8,'2019_05_03_000004_create_transactions_table',1),(9,'2019_08_19_000000_create_failed_jobs_table',1),(10,'2019_12_14_000001_create_personal_access_tokens_table',1),(11,'2023_10_18_110722_laratrust_setup_tables',1),(12,'2023_10_26_070645_create_settings_table',1),(13,'2023_10_26_070942_create_user_active_modules_table',1),(14,'2023_10_26_115816_create_add_ons_table',1),(15,'2023_10_27_101918_create_currencies_table',1),(16,'2023_10_27_123013_create_plans_table',1),(17,'2023_10_30_064000_create_coupons_table',1),(18,'2023_10_30_070428_create_user_coupons_table',1),(19,'2023_10_30_095152_create_orders_table',1),(20,'2023_10_30_105927_create_languages_table',1),(21,'2023_10_31_041456_create_bank_transfer_payments_table',1),(22,'2024_01_03_111111_create_businesses_table',1),(23,'2024_01_03_120907_create_login_details_table',1),(24,'2024_01_05_040107_create_locations_table',1),(25,'2024_01_05_054533_create_categories_table',1),(26,'2024_01_05_063646_create_services_table',1),(27,'2024_01_05_091920_create_staff_table',1),(28,'2024_01_08_091123_create_customers_table',1),(29,'2024_01_09_055753_create_business_hours_table',1),(30,'2024_01_11_031244_create_business_holidays_table',1),(31,'2024_01_17_035519_create_appointments_table',1),(32,'2024_01_23_043343_create_appointment_payments_table',1),(33,'2024_02_08_120809_add_is_enabled_to_plans_table',1),(34,'2024_02_09_120525_create_custom_statuses_table',1),(35,'2024_02_14_065118_create_notifications_table',1),(36,'2024_02_14_065925_create_email_templates_table',1),(37,'2024_02_14_070400_create_email_template_langs_table',1),(38,'2024_02_19_035940_create_files_table',1),(39,'2024_02_19_090509_add_attachment_to_appointments_table',1),(40,'2024_02_20_043459_create_custom_fields_table',1),(41,'2024_02_20_071421_add_custom_field_to_appointments_table',1),(42,'2024_02_22_061754_add_form_type_to_businesses_table',1),(43,'2024_03_12_121509_create_theme_settings_table',1),(44,'2024_03_18_035835_create_contact_us_table',1),(45,'2024_03_18_044744_create_blogs_table',1),(46,'2024_03_18_062406_create_testimonials_table',1),(47,'2024_03_19_064432_add_theme_color_to_businesses_table',1),(48,'2024_03_21_052938_change_business_field_nullable_in_login_details',1),(49,'2024_03_21_072203_create_subscribes_table',1),(50,'2024_03_21_104511_add_status_color_to_custom_statuses_table',1),(51,'2024_04_02_095524_create_notification_template_langs_table',1),(52,'2024_04_02_115823_create_landing_page_settings_table',1),(53,'2024_04_03_111218_create_join_us_table',1),(54,'2024_04_03_121928_create_landingpage_pixels_table',1),(55,'2024_04_04_102134_create_marketplace_page_settings_table',1),(56,'2024_04_10_094813_rename_workspace_in_bank_transfer_payments',1),(57,'2024_08_21_051103_add_is_free_to_services_table',1),(58,'2024_08_21_052359_change_price_field_nullable_in_services',1),(59,'2024_09_02_120706_add_image_to_add_ons_table',1),(60,'2024_10_03_104046_alter_table_locations_change_description',1),(61,'2024_10_03_111108_alter_table_services_change_description',1),(62,'2024_10_03_111408_alter_table_staff_change_description',1),(63,'2024_10_09_044307_change_appointment_id_field_in_appointment_payments',1),(64,'2024_10_17_094039_add_option_column_custom_field_table',1),(65,'2024_10_17_103134_change_notes_column_appointment_table',1),(66,'2024_10_17_111408_alter_table_customer_change_description',1),(67,'2024_10_17_115829_change_description_column_contact_us_table',1),(68,'2024_10_17_121149_change_label_column_files_table',1),(69,'2024_10_17_125707_change_description_column_testimonials_table',1),(70,'2024_10_17_130500_change_description_column_blogs_table',1),(71,'2025_03_18_093647_update_tables_for_changes',1),(72,'2025_05_08_102305_trigger_updater',1);

--
-- Table structure for table `notification_template_langs`
--

CREATE TABLE `notification_template_langs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL DEFAULT '0',
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `variables` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `notification_template_langs_chk_1` CHECK (json_valid(`variables`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_template_langs`
--


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

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(188) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_id` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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



--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_number` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_exp_month` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_exp_year` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan_id` int NOT NULL,
  `price` double NOT NULL,
  `price_currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `txn_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_order_id_unique` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


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

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

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


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(15,2),(19,2),(29,2),(30,2),(31,2),(32,2),(33,2),(34,2),(35,2),(36,2),(37,2),(38,2),(39,2),(40,2),(41,2),(42,2),(43,2),(44,2),(45,2),(46,2),(47,2),(48,2),(49,2),(50,2),(51,2),(52,2),(53,2),(54,2),(55,2),(56,2),(57,2),(58,2),(59,2),(60,2),(61,2),(62,2),(63,2),(64,2),(65,2),(66,2),(67,2),(68,2),(69,2),(70,2),(71,2),(72,2),(73,2),(74,2),(75,2),(76,2),(77,2),(78,2),(79,2),(80,2),(95,2),(96,2),(5,3),(8,3),(5,4),(8,4),(53,5),(54,5),(55,5),(56,5);

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `permission_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `permission_user_permission_id_foreign` (`permission_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_user`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Base',
  `created_by` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--



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

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text 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 `plans`
--

CREATE TABLE `plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_plan` int NOT NULL DEFAULT '0',
  `active` int NOT NULL DEFAULT '1',
  `is_free_plan` int NOT NULL DEFAULT '0',
  `package_price_monthly` double NOT NULL DEFAULT '0',
  `package_price_yearly` double NOT NULL DEFAULT '0',
  `price_per_user_monthly` double NOT NULL DEFAULT '0',
  `price_per_user_yearly` double NOT NULL DEFAULT '0',
  `price_per_business_monthly` int NOT NULL DEFAULT '0',
  `price_per_business_yearly` int NOT NULL DEFAULT '0',
  `modules` longtext COLLATE utf8mb4_unicode_ci,
  `trial` int NOT NULL DEFAULT '0',
  `trial_days` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_enabled` int NOT NULL DEFAULT '1',
  `number_of_business` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` VALUES (1,NULL,'5',1,1,0,0,0,0,0,0,0,NULL,0,NULL,1,'5','2025-05-15 01:09:21','2025-05-15 01:09:21'),(2,'Basic','5',0,1,1,0,0,0,0,0,0,'Stripe,Paypal,GoogleCaptcha,Photography,CarService',0,NULL,1,'5','2025-05-15 01:09:21','2025-05-15 01:09:21');

--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `billable_id` bigint unsigned NOT NULL,
  `billable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paddle_subscription_id` bigint unsigned DEFAULT NULL,
  `checkout_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `receipt_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paid_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `receipts_order_id_unique` (`order_id`),
  UNIQUE KEY `receipts_receipt_url_unique` (`receipt_url`),
  KEY `receipts_billable_id_billable_type_index` (`billable_id`,`billable_type`),
  KEY `receipts_paddle_subscription_id_index` (`paddle_subscription_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipts`
--


--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `role_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1,'App\\Models\\User'),(2,2,'App\\Models\\User');

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `module` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Base',
  `created_by` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'super admin',NULL,NULL,'web','Base',0,'2025-05-15 01:09:21','2025-05-15 01:09:21'),(2,'company',NULL,NULL,'web','Base',1,'2025-05-15 01:09:21','2025-05-15 01:09:21'),(3,'manager',NULL,NULL,'web','Base',2,'2025-05-15 01:09:22','2025-05-15 01:09:22'),(4,'staff',NULL,NULL,'web','Base',2,'2025-05-15 01:09:22','2025-05-15 01:09:22'),(5,'customer',NULL,NULL,'web','Base',2,'2025-05-15 01:09:22','2025-05-15 01:09:22');

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` longtext COLLATE utf8mb4_unicode_ci,
  `category_id` bigint unsigned NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_free` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '0 => paid, 1 => free',
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `services_category_id_foreign` (`category_id`),
  KEY `services_business_id_foreign` (`business_id`),
  KEY `services_created_by_foreign` (`created_by`),
  CONSTRAINT `services_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `services_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--


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

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci,
  `business` int NOT NULL DEFAULT '0',
  `created_by` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_created_by_index` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` VALUES (1,'currency_format','1',1,2,NULL,NULL),(2,'defult_currancy','USD',1,2,NULL,NULL),(3,'defult_currancy_symbol','$',1,2,NULL,NULL),(4,'defult_language','en',1,2,NULL,NULL),(5,'defult_timezone','Asia/Kolkata',1,2,NULL,NULL),(6,'site_currency_symbol_position','pre',1,2,NULL,NULL),(7,'site_date_format','d-m-Y',1,2,NULL,NULL),(8,'site_time_format','g:i A',1,2,NULL,NULL),(9,'title_text','BookingGo',1,2,NULL,NULL),(10,'footer_text','Copyright © BookingGo',1,2,NULL,NULL),(11,'site_rtl','off',1,2,NULL,NULL),(12,'cust_darklayout','off',1,2,NULL,NULL),(13,'site_transparent','on',1,2,NULL,NULL),(14,'color','theme-1',1,2,NULL,NULL),(15,'currency_format','1',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(16,'defult_currancy','USD',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(17,'defult_currancy_symbol','$',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(18,'defult_language','en',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(19,'defult_timezone','Asia/Kolkata',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(20,'title_text','Law Firm',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(21,'footer_text','Copyright © Law Firm',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(22,'landing_page','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(23,'site_rtl','off',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(24,'cust_darklayout','off',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(25,'site_transparent','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(26,'signup','off',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(27,'color','#000000',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(28,'meta_title','BookingGo SaaS - Multi Business Appointment Booking and Scheduling',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(29,'meta_keywords','BookingGo,SaaS solution,Multi-business functionality, Cloud-based access,Scalability,Multi-addons,Collaboration tool,Data management,Business productivity,Operational effectiveness',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(30,'meta_description','Discover the efficiency of BookingGo, a user-friendly web application by Rajodiya Apps. Streamline project management, organize tasks, collaborate seamlessly, and track progress effortlessly. Boost productivity with BookingGo\'s intuitive interface and comprehensive features. Revolutionize your project management process today. Try BookingGo!',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(31,'enable_cookie','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(32,'necessary_cookies','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(33,'cookie_logging','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(34,'cookie_title','We use cookies!',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(35,'cookie_description','Hi, this website uses essential cookies to ensure its proper operation and tracking cookies to understand how you interact with it',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(36,'strictly_cookie_title','Strictly necessary cookies',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(37,'strictly_cookie_description','These cookies are essential for the proper functioning of my website. Without these cookies, the website would not work properly',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(38,'more_information_description','For any queries in relation to our policy on cookies and your choices, please contact us',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(39,'contactus_url','#',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(40,'plan_package','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(41,'custome_package','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(42,'email_verification','on',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(43,'storage_setting','local',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(44,'local_storage_max_upload_size','204800',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(45,'local_storage_validation','jpeg,jpg,png,pdf,gif,svg',0,1,'2025-05-15 01:09:23','2025-05-15 01:09:23'),(46,'color_flag','true',0,1,NULL,NULL),(47,'bank_transfer_payment_is_on','on',0,1,NULL,NULL),(48,'bank_number','Bank Name: GTB\r\nAccount Name: Pierre Jude\r\nAccount Number: 75875959980',0,1,NULL,NULL),(49,'logo_dark','uploads/logo/logo_dark_1747279615.png',0,1,NULL,NULL),(50,'logo_light','uploads/logo/logo_light_1747279615.png',0,1,NULL,NULL),(51,'favicon','uploads/logo/favicon_1747279615.png',0,1,NULL,NULL),(52,'meta_image','uploads/meta/credit_card_PNG87_1747279670.png',0,1,NULL,NULL);

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `location_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `business_id` bigint unsigned NOT NULL,
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_user_id_foreign` (`user_id`),
  KEY `staff_business_id_foreign` (`business_id`),
  KEY `staff_created_by_foreign` (`created_by`),
  CONSTRAINT `staff_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `staff`
--


--
-- Table structure for table `subscribes`
--

CREATE TABLE `subscribes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscribes_business_id_foreign` (`business_id`),
  CONSTRAINT `subscribes_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribes`
--


--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint unsigned NOT NULL,
  `product_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_price_id_unique` (`subscription_id`,`price_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--


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

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `billable_id` bigint unsigned NOT NULL,
  `billable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paddle_id` int NOT NULL,
  `paddle_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paddle_plan` int NOT NULL,
  `quantity` int NOT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `paused_from` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_paddle_id_unique` (`paddle_id`),
  KEY `subscriptions_billable_id_billable_type_index` (`billable_id`,`billable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `testimonials_customer_id_foreign` (`customer_id`),
  KEY `testimonials_business_id_foreign` (`business_id`),
  KEY `testimonials_created_by_foreign` (`created_by`),
  CONSTRAINT `testimonials_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `testimonials_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `testimonials_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--


--
-- Table structure for table `theme_settings`
--

CREATE TABLE `theme_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_id` bigint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `theme_settings_business_id_foreign` (`business_id`),
  KEY `theme_settings_created_by_foreign` (`created_by`),
  CONSTRAINT `theme_settings_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `businesses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `theme_settings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `theme_settings`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `billable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billable_id` bigint unsigned NOT NULL,
  `paddle_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `paddle_subscription_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transactions_paddle_id_unique` (`paddle_id`),
  KEY `transactions_billable_type_billable_id_index` (`billable_type`,`billable_id`),
  KEY `transactions_paddle_subscription_id_index` (`paddle_subscription_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--


--
-- Table structure for table `user_active_modules`
--

CREATE TABLE `user_active_modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_active_modules_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_active_modules`
--

INSERT INTO `user_active_modules` VALUES (1,2,'LandingPage','2025-05-15 01:10:45','2025-05-15 01:10:45'),(2,2,'CarService','2025-05-15 01:10:53','2025-05-15 01:10:53'),(3,2,'GoogleCaptcha','2025-05-15 01:11:01','2025-05-15 01:11:01'),(4,2,'Paypal','2025-05-15 01:11:06','2025-05-15 01:11:06'),(5,2,'Photography','2025-05-15 01:11:12','2025-05-15 01:11:12'),(6,2,'Stripe','2025-05-15 01:11:17','2025-05-15 01:11:17');

--
-- Table structure for table `user_coupons`
--

CREATE TABLE `user_coupons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user` int NOT NULL,
  `coupon` int NOT NULL,
  `order` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_coupons`
--



