-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mfmyfrie_POSGo`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin_payment_settings`
--

CREATE TABLE `admin_payment_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `branch_type` varchar(191) DEFAULT NULL,
  `branch_manager` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `name`, `branch_type`, `branch_manager`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'xngine', 'retail', 0, 2, '2026-02-27 09:28:21', '2026-02-27 09:28:21');

-- --------------------------------------------------------

--
-- Table structure for table `branch_products`
--

CREATE TABLE `branch_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `branch_sales_targets`
--

CREATE TABLE `branch_sales_targets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `month` varchar(100) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branch_sales_targets`
--

INSERT INTO `branch_sales_targets` (`id`, `month`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'February-2026', 2, '2026-02-27 09:29:15', '2026-02-27 09:29:15');

-- --------------------------------------------------------

--
-- Table structure for table `branch_target_lists`
--

CREATE TABLE `branch_target_lists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `target_id` int(11) NOT NULL DEFAULT 0,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `target_amount` double DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branch_target_lists`
--

INSERT INTO `branch_target_lists` (`id`, `target_id`, `branch_id`, `target_amount`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1000, '2026-02-27 09:29:15', '2026-02-27 09:29:15');

-- --------------------------------------------------------

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `slug`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'كود', 'kod', 2, '2026-02-27 09:25:18', '2026-02-27 09:25:18');

-- --------------------------------------------------------

--
-- Table structure for table `calendars`
--

CREATE TABLE `calendars` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `className` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cash_registers`
--

CREATE TABLE `cash_registers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cash_registers`
--

INSERT INTO `cash_registers` (`id`, `name`, `branch_id`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'xngine cash', 1, 2, '2026-02-27 09:28:57', '2026-02-27 09:28:57');

-- --------------------------------------------------------

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'default', 'default', 2, '2026-02-27 09:25:03', '2026-02-27 09:25:03');

-- --------------------------------------------------------

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `discount` double NOT NULL DEFAULT 0,
  `limit` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `zipcode` varchar(50) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `customers` (`id`, `name`, `email`, `phone_number`, `address`, `city`, `state`, `country`, `zipcode`, `is_active`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'mohammad naji', 'm_n_7atamleh@yahoo.com', '+96211111111', ', Amman - Tla\' Al-Ali North, Sufyan Bin Wahab Street', 'Amman', 'Amman', 'Jordan', '11953', 1, 2, '2026-02-27 10:05:43', '2026-02-27 10:05:43');

-- --------------------------------------------------------

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

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `from` varchar(191) DEFAULT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_templates` (`id`, `name`, `from`, `slug`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'New user', 'POSGo SaaS', 'new_user', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'New Owner', 'POSGo SaaS', 'new_owner', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'New Customer', 'POSGo SaaS', 'new_customer', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'New Vendor', 'POSGo SaaS', 'new_vendor', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'New Quote', 'POSGo SaaS', 'new_quote', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

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

CREATE TABLE `email_template_langs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `lang` varchar(100) NOT NULL,
  `subject` varchar(191) NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_template_langs` (`id`, `parent_id`, `lang`, `subject`, `content`, `created_at`, `updated_at`) VALUES
(1, 1, 'ar', 'New user', '<p>مرحبًا,<b> {user_name} </b>!</p>\n                            <p>مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ <b> {app_name}</b> هو <br></p>\n                            <p><b>البريد الإلكتروني   : </b>{user_email}</p>\n                            <p><b>كلمة المرور   : </b>{user_password}</p>\n                            <p><b>عنوان url للتطبيق    : </b>{app_url}</p>\n                            <p>شكرا لتواصلك معنا،</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 1, 'da', 'New user', '<p>Hej,<b> {user_name} </b>!</p>\n                            <p>Velkommen til vores app, hvor du kan logge ind <b> {app_name}</b> er <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Adgangskode : </b>{user_password}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p> Tak fordi du tog kontakt med os,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 1, 'de', 'New user', '<p>Hallo,<b> {user_name} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{user_email}</p>\n                            <p><b>Passwort   : </b>{user_password}</p>\n                            <p><b> App-URL    : </b>{app_url}</p>\n                            <p>Danke, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 1, 'en', 'New user', '<p>Hello,<b> {user_name} </b>!</p>\n                            <p>Welcome to our app yore login detail for <b> {app_name}</b> is <br></p>\n                            <p><b>Email   : </b>{user_email}</p>\n                            <p><b>Password   : </b>{user_password}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p>Thank you for connecting with us,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 1, 'es', 'New user', '<p>Hola,<b> {user_name} </b>!</p>\n                            <p>Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para <b> {app_name}</b> es <br></p>\n                            <p><b>Correo electrónico   : </b>{user_email}</p>\n                            <p><b>Clave   : </b>{user_password}</p>\n                            <p><b>URL de la aplicación  : </b>{app_url}</p>\n                            <p>Gracias por conectar con nosotras,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 1, 'fr', 'New user', '<p>Bonjour,<b> {user_name} </b>!</p>\n                            <p>Bienvenue sur notre application autrefois les informations de connexion pour <b> {app_name}</b> est <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Mot de passe   : </b>{user_password}</p>\n                            <p><b>URL de l\'application   : </b>{app_url}</p>\n                            <p>Merci de nous avoir contacté,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 1, 'it', 'New user', '<p>Ciao,<b> {user_name} </b>!</p>\n                            <p>Benvenuto nella nostra app per i tuoi dati di accesso <b> {app_name}</b> è <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Parola d\'ordine   : </b>{user_password}</p>\n                            <p><b>URL dell\'app    : </b>{app_url}</p>\n                            <p>Grazie per esserti connesso con noi,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 1, 'ja', 'New user', '<p>こんにちは,<b> {user_name} </b>!</p>\n                            <p>私たちのアプリのyoreログインの詳細へようこそ <b> {app_name}</b> は <br></p>\n                            <p><b>Eメール   : </b>{user_email}</p>\n                            <p><b>パスワード   : </b>{user_password}</p>\n                            <p><b>アプリのURL    : </b>{app_url}</p>\n                            <p>ご連絡ありがとうございます,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 1, 'nl', 'New user', '<p>Hallo,<b> {user_name} </b>!</p>\n                            <p>Welkom bij de inloggegevens van onze app voor: <b> {app_name}</b> is <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Wachtwoord   : </b>{user_password}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p>Bedankt voor het contact met ons,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 1, 'pl', 'New user', '<p>Witam,<b> {user_name} </b>!</p>\n                            <p>Witamy w naszej aplikacji yore dane logowania do <b> {app_name}</b> jest <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Hasło   : </b>{user_password}</p>\n                            <p><b>URL aplikacji    : </b>{app_url}</p>\n                            <p>Dziękujemy za kontakt z nami,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(11, 1, 'ru', 'New user', '<p>Привет,<b> {user_name} </b>!</p>\n                            <p>Добро пожаловать в наше приложение. <b> {app_name}</b> является <br></p>\n                            <p><b>Эл. адрес   : </b>{user_email}</p>\n                            <p><b>Пароль   : </b>{user_password}</p>\n                            <p><b>URL приложения    : </b>{app_url}</p>\n                            <p>Спасибо, что связались с нами,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(12, 1, 'pt', 'New user', '<p>Olá,<b> {user_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Senha   : </b>{user_password}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(13, 1, 'tr', 'New user', '<p>Merhaba,<b> {user_name} </b>!</p>\n                            <p>Uygulamamıza hoş geldiniz, eski <b> {app_name}</b> için giriş ayrıntısı <br></p>\n                            <p><b>E-posta : </b>{user_email}</p>\n                            <p><b>Parola : </b>{user_password}</p>\n                            <p><b>Uygulama url : </b>{app_url}</p>\n                            <p>Bizimle bağlantı kurduğunuz için teşekkür ederiz,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(14, 1, 'he', 'New user', '<p>שלום,<b> {user_name} </b>!</p>\n                            <p>ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של <b> {app_name}</b> הוא <br></p>\n                            <p><b>דוא\"ל: </b>{user_email}</p>\n                            <p><b>סיסמה: </b>{user_password}</p>\n                            <p><b>כתובת אתר של אפליקציה: </b>{app_url}</p>\n                            <p>תודה שהתחברת אלינו,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(15, 1, 'zh', 'New user', '<p>您好，<b> {user_name} </b>！</p>\n                            <p>欢迎使用我们的应用，<b> {app_name}</b> 的登录详细信息是<br></p>\n                            <p><b>电子邮件：</b>{user_email}</p>\n                            <p><b>密码：</b>{user_password}</p>\n                            <p><b>应用程序网址：</b>{app_url}</p>\n                            <p>感谢您与我们联系，</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(16, 1, 'pt-br', 'New user', '<p>Olá,<b> {user_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{user_email}</p>\n                            <p><b>Senha   : </b>{user_password}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(17, 2, 'ar', 'New Owner', '<p>مرحبًا,<b> {owner_name} </b>!</p>\n                            <p>مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ <b> {app_name}</b> هو <br></p>\n                            <p><b>البريد الإلكتروني   : </b>{owner_email}</p>\n                            <p><b>كلمة المرور   : </b>{owner_password}</p>\n                            <p><b>عنوان url للتطبيق    : </b>{app_url}</p>\n                            <p>شكرا لتواصلك معنا،</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(18, 2, 'da', 'New Owner', '<p>Hej,<b> {owner_name} </b>!</p>\n                            <p>Velkommen til vores app, hvor du kan logge ind <b> {app_name}</b> er <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Adgangskode : </b>{owner_password}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p> Tak fordi du tog kontakt med os,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(19, 2, 'de', 'New Owner', '<p>Hallo,<b> {owner_name} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{owner_email}</p>\n                            <p><b>Passwort   : </b>{owner_password}</p>\n                            <p><b> App-URL    : </b>{app_url}</p>\n                            <p>Danke, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(20, 2, 'en', 'New Owner', '<p>Hello,<b> {owner_name} </b>!</p>\n                            <p>Welcome to our app yore login detail for <b> {app_name}</b> is <br></p>\n                            <p><b>Email   : </b>{owner_email}</p>\n                            <p><b>Password   : </b>{owner_password}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p>Thank you for connecting with us,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(21, 2, 'es', 'New Owner', '<p>Hola,<b> {owner_name} </b>!</p>\n                            <p>Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para <b> {app_name}</b> es <br></p>\n                            <p><b>Correo electrónico   : </b>{owner_email}</p>\n                            <p><b>Clave   : </b>{owner_password}</p>\n                            <p><b>URL de la aplicación  : </b>{app_url}</p>\n                            <p>Gracias por conectar con nosotras,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(22, 2, 'fr', 'New Owner', '<p>Bonjour,<b> {owner_name} </b>!</p>\n                            <p>Bienvenue sur notre application autrefois les informations de connexion pour <b> {app_name}</b> est <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Mot de passe   : </b>{owner_password}</p>\n                            <p><b>URL de l\'application   : </b>{app_url}</p>\n                            <p>Merci de nous avoir contacté,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(23, 2, 'it', 'New Owner', '<p>Ciao,<b> {owner_name} </b>!</p>\n                            <p>Benvenuto nella nostra app per i tuoi dati di accesso <b> {app_name}</b> è <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Parola d\'ordine   : </b>{owner_password}</p>\n                            <p><b>URL dell\'app    : </b>{app_url}</p>\n                            <p>Grazie per esserti connesso con noi,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(24, 2, 'ja', 'New Owner', '<p>こんにちは,<b> {owner_name} </b>!</p>\n                            <p>私たちのアプリのyoreログインの詳細へようこそ <b> {app_name}</b> は <br></p>\n                            <p><b>Eメール   : </b>{owner_email}</p>\n                            <p><b>パスワード   : </b>{owner_password}</p>\n                            <p><b>アプリのURL    : </b>{app_url}</p>\n                            <p>ご連絡ありがとうございます,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(25, 2, 'nl', 'New Owner', '<p>Hallo,<b> {owner_name} </b>!</p>\n                            <p>Welkom bij de inloggegevens van onze app voor: <b> {app_name}</b> is <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Wachtwoord   : </b>{owner_password}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p>Bedankt voor het contact met ons,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(26, 2, 'pl', 'New Owner', '<p>Witam,<b> {owner_name} </b>!</p>\n                            <p>Witamy w naszej aplikacji yore dane logowania do <b> {app_name}</b> jest <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Hasło   : </b>{owner_password}</p>\n                            <p><b>URL aplikacji    : </b>{app_url}</p>\n                            <p>Dziękujemy za kontakt z nami,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(27, 2, 'ru', 'New Owner', '<p>Привет,<b> {owner_name} </b>!</p>\n                            <p>Добро пожаловать в наше приложение. <b> {app_name}</b> является <br></p>\n                            <p><b>Эл. адрес   : </b>{owner_email}</p>\n                            <p><b>Пароль   : </b>{owner_password}</p>\n                            <p><b>URL приложения    : </b>{app_url}</p>\n                            <p>Спасибо, что связались с нами,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(28, 2, 'pt', 'New Owner', '<p>Olá,<b> {owner_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Senha   : </b>{owner_password}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(29, 2, 'tr', 'New Owner', '<p>Merhaba,<b> {owner_name} </b>!</p>\n                            <p>Uygulamamıza hoş geldiniz, eski <b> {app_name}</b> için giriş ayrıntısı <br></p>\n                            <p><b>E-posta : </b>{owner_email}</p>\n                            <p><b>Şifre : </b>{owner_password}</p>\n                            <p><b>Uygulama url : </b>{app_url}</p>\n                            <p>Bizimle bağlantı kurduğunuz için teşekkür ederiz,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(30, 2, 'he', 'New Owner', '<p>שלום,<b> {owner_name} </b>!</p>\n                            <p>ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של <b> {app_name}</b> הוא <br></p>\n                            <p><b>דוא\"ל: </b>{owner_email}</p>\n                            <p><b>סיסמה: </b>{owner_password}</p>\n                            <p><b>כתובת אתר של אפליקציה: </b>{app_url}</p>\n                            <p>תודה שהתחברת אלינו,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(31, 2, 'zh', 'New Owner', '<p>您好，<b> {owner_name} </b>！</p>\n                            <p>欢迎使用我们的应用，<b> {app_name}</b> 的登录详细信息是<br></p>\n                            <p><b>电子邮件：</b>{owner_email}</p>\n                            <p><b>密码：</b>{owner_password}</p>\n                            <p><b>应用程序网址：</b>{app_url}</p>\n                            <p>感谢您与我们联系，</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(32, 2, 'pt-br', 'New Owner', '<p>Olá,<b> {owner_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{owner_email}</p>\n                            <p><b>Senha   : </b>{owner_password}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(33, 3, 'ar', 'New Customer', '<p>مرحبًا,<b> {customer_name} </b>!</p>\n                            <p>مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ <b> {app_name}</b> هو <br></p>\n                            <p><b>البريد الإلكتروني   : </b>{customer_email}</p>\n                            <p><b>عنوان url للتطبيق    : </b>{app_url}</p>\n                            <p><b>عنوان العميل   : </b>{customer_address}</p>\n                            <p><b>بلد العميل   : </b>{customer_country}</p>\n                            <p><b>الرمز البريدي للعميل   : </b>{customer_zipcode}</p>\n                            <p>شكرا لتواصلك معنا,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(34, 3, 'da', 'New Customer', '<p>Hej,<b> {customer_name} </b>!</p>\n                            <p>Velkommen til vores app, hvor du kan logge ind <b> {app_name}</b> er <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Kundeadresse   : </b>{customer_address}</p>\n                            <p><b>Kundeland   : </b>{customer_country}</p>\n                            <p><b>Kundens postnummer   : </b>{customer_zipcode}</p>\n                            <p>Tak fordi du tog kontakt med os,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(35, 3, 'de', 'New Customer', '<p>Hallo,<b> {customer_name} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{customer_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Kundenadresse   : </b>{customer_address}</p>\n                            <p><b>Kundenland   : </b>{customer_country}</p>\n                            <p><b>Postleitzahl des Kunden : </b>{customer_zipcode}</p>\n                            <p>Vielen Dank, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(36, 3, 'en', 'New Customer', '<p>Hello,<b> {customer_name} </b>!</p>\n                            <p>Welcome to our app yore login detail for <b> {app_name}</b> is <br></p>\n                            <p><b>Email   : </b>{customer_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Customer Address   : </b>{customer_address}</p>\n                            <p><b>Customer Country   : </b>{customer_country}</p>\n                            <p><b>Customer Zipcode   : </b>{customer_zipcode}</p>\n                            <p>Thank you for connecting with us,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(37, 3, 'es', 'New Customer', '<p>Hola,<b> {customer_name} </b>!</p>\n                            <p>Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para <b> {app_name}</b> es <br></p>\n                            <p><b>Correo electrónico   : </b>{customer_email}</p>\n                            <p><b>URL de la aplicación    : </b>{app_url}</p>\n                            <p><b>Dirección del cliente   : </b>{customer_address}</p>\n                            <p><b>País del cliente   : </b>{customer_country}</p>\n                            <p><b>Código postal del cliente   : </b>{customer_zipcode}</p>\n                            <p>Gracias por conectar con nosotros,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(38, 3, 'fr', 'New Customer', '<p>Bonjour,<b> {customer_name} </b>!</p>\n                            <p>Bienvenue sur notre application autrefois les informations de connexion pour <b> {app_name}</b> est <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL de l\'application   : </b>{app_url}</p>\n                            <p><b>Adresse du client   : </b>{customer_address}</p>\n                            <p><b>Pays du client   : </b>{customer_country}</p>\n                            <p><b>Code postal du client   : </b>{customer_zipcode}</p>\n                            <p>Merci de nous avoir contacté,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(39, 3, 'it', 'New Customer', '<p>Ciao,<b> {customer_name} </b>!</p>\n                            <p>Benvenuto nella nostra app per i tuoi dati di accesso <b> {app_name}</b> è <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL dell\'app    : </b>{app_url}</p>\n                            <p><b>Indirizzo del cliente   : </b>{customer_address}</p>\n                            <p><b>Paese cliente   : </b>{customer_country}</p>\n                            <p><b>Codice postale del cliente   : </b>{customer_zipcode}</p>\n                            <p>Grazie per esserti connesso con noi,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(40, 3, 'ja', 'New Customer', '<p>こんにちは,<b> {customer_name} </b>!</p>\n                            <p>私たちのアプリのyoreログインの詳細へようこそ <b> {app_name}</b> は <br></p>\n                            <p><b>Eメール   : </b>{customer_email}</p>\n                            <p><b>アプリのURL    : </b>{app_url}</p>\n                            <p><b>お客様の住所   : </b>{customer_address}</p>\n                            <p><b>顧客の国   : </b>{customer_country}</p>\n                            <p><b>顧客の郵便番号   : </b>{customer_zipcode}</p>\n                            <p>ご連絡ありがとうございます,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(41, 3, 'nl', 'New Customer', '<p>Hallo,<b> {customer_name} </b>!</p>\n                            <p>Welkom bij de inloggegevens van onze app voor: <b> {app_name}</b> is <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Klant adres   : </b>{customer_address}</p>\n                            <p><b>Land van klant   : </b>{customer_country}</p>\n                            <p><b>Postcode klant   : </b>{customer_zipcode}</p>\n                            <p>Bedankt voor het contact met ons,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(42, 3, 'pl', 'New Customer', '<p>Witam,<b> {customer_name} </b>!</p>\n                            <p>Witamy w naszej aplikacji yore dane logowania do <b> {app_name}</b> jest <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL aplikacji    : </b>{app_url}</p>\n                            <p><b>Adres klienta   : </b>{customer_address}</p>\n                            <p><b>Kraj klienta   : </b>{customer_country}</p>\n                            <p><b>Kod pocztowy klienta   : </b>{customer_zipcode}</p>\n                            <p>Dziękujemy za kontakt z nami,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(43, 3, 'ru', 'New Customer', '<p>Привет,<b> {customer_name} </b>!</p>\n                            <p>Добро пожаловать в наше приложение. <b> {app_name}</b> является <br></p>\n                            <p><b>Эл. адрес   : </b>{customer_email}</p>\n                            <p><b>URL приложения    : </b>{app_url}</p>\n                            <p><b>Адрес клиента   : </b>{customer_address}</p>\n                            <p><b>Страна клиента  : </b>{customer_country}</p>\n                            <p><b>Страна клиента  : </b>{customer_zipcode}</p>\n                            <p>Спасибо, что связались с нами,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(44, 3, 'pt', 'New Customer', '<p>Olá,<b> {customer_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Endereço do cliente   : </b>{customer_address}</p>\n                            <p><b>País do cliente   : </b>{customer_country}</p>\n                            <p><b>CEP do cliente   : </b>{customer_zipcode}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(45, 3, 'tr', 'New Customer', '<p>Merhaba,<b> {customer_name} </b>!</p>\n                            <p>Uygulamamıza hoş geldiniz, eski <b> {app_name}</b> için giriş ayrıntısı <br></p>\n                            <p><b>E-posta : </b>{customer_email}</p>\n                            <p><b>Uygulama url : </b>{app_url}</p>\n                            <p><b>Müşteri Adresi : </b>{customer_address}</p>\n                            <p><b>Müşteri Ülkesi : </b>{customer_country}</p>\n                            <p><b>Müşteri Posta Kodu : </b>{customer_zipcode}</p>\n                            <p>Bizimle bağlantı kurduğunuz için teşekkür ederiz,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(46, 3, 'he', 'New Customer', '<p>שלום,<b> {customer_name} </b>!</p>\n                            <p>ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של <b> {app_name}</b> הוא <br></p>\n                            <p><b>דוא\"ל: </b>{customer_email}</p>\n                            <p><b>כתובת אתר של אפליקציה: </b>{app_url}</p>\n                            <p><b>כתובת לקוח: </b>{customer_address}</p>\n                            <p><b>ארץ לקוח: </b>{customer_country}</p>\n                            <p><b>מיקוד לקוח : </b>{customer_zipcode}</p>\n                            <p>תודה שהתחברת אלינו,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(47, 3, 'zh', 'New Customer', '<p>您好，<b> {customer_name} </b>！</p>\n                            <p>欢迎使用我们的应用，<b> {app_name}</b> 的登录详细信息是<br></p>\n                            <p><b>电子邮件：</b>{customer_email}</p>\n                            <p><b>应用程序网址：</b>{app_url}</p>\n                            <p><b>客户地址：</b>{customer_address}</p>\n                            <p><b>客户国家/地区：</b>{customer_country}</p>\n                            <p><b>客户邮政编码：</b>{customer_zipcode}</p>\n                            <p>感谢您与我们联系，</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(48, 3, 'pt-br', 'New Customer', '<p>Olá,<b> {customer_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Endereço do cliente   : </b>{customer_address}</p>\n                            <p><b>País do cliente   : </b>{customer_country}</p>\n                            <p><b>CEP do cliente   : </b>{customer_zipcode}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(49, 4, 'ar', 'New Vendor', '<p>مرحبًا,<b> {vendor_name} </b>!</p>\n                        <p>مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ <b> {app_name}</b> هو <br></p>\n                        <p><b>البريد الإلكتروني   : </b>{vendor_email}</p>\n                        <p><b>عنوان url للتطبيق    : </b>{app_url}</p>\n                        <p><b>عنوان البائع   : </b>{vendor_address}</p>\n                        <p><b>بلد البائع   : </b>{vendor_country}</p>\n                        <p><b>الرمز البريدي للبائع   : </b>{vendor_zipcode}</p>\n                        <p>شكرا لتواصلك معنا,</p>\n                        <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(50, 4, 'da', 'New Vendor', '<p>Hej,<b> {vendor_name} </b>!</p>\n                            <p>Velkommen til vores app, hvor du kan logge ind <b> {app_name}</b> er <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Leverandørens adresse   : </b>{vendor_address}</p>\n                            <p><b>Leverandørland   : </b>{vendor_country}</p>\n                            <p><b>Leverandørens postnummer   : </b>{vendor_zipcode}</p>\n                            <p>Tak fordi du tog kontakt med os,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(51, 4, 'de', 'New Vendor', '<p>Hallo,<b> {vendor_name} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{vendor_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Adresse des Anbieters   : </b>{vendor_address}</p>\n                            <p><b>Land des Anbieters   : </b>{vendor_country}</p>\n                            <p><b>Postleitzahl des Anbieters   : </b>{vendor_zipcode}</p>\n                            <p>Vielen Dank, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(52, 4, 'en', 'New Vendor', '<p>Hello,<b> {vendor_name} </b>!</p>\n                            <p>Welcome to our app yore login detail for <b> {app_name}</b> is <br></p>\n                            <p><b>Email   : </b>{vendor_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Vendor Address   : </b>{vendor_address}</p>\n                            <p><b>Vendor Country   : </b>{vendor_country}</p>\n                            <p><b>Vendor Zipcode   : </b>{vendor_zipcode}</p>\n                            <p>Thank you for connecting with us,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(53, 4, 'es', 'New Vendor', '<p>Hallo,<b> {vendor_name} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{vendor_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Adresse des Anbieters   : </b>{vendor_address}</p>\n                            <p><b>Land des Anbieters   : </b>{vendor_country}</p>\n                            <p><b>Postleitzahl des Anbieters   : </b>{vendor_zipcode}</p>\n                            <p>Vielen Dank, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(54, 4, 'fr', 'New Vendor', '<p>Bonjour,<b> {vendor_name} </b>!</p>\n                            <p>Bienvenue sur notre application autrefois les informations de connexion pour <b> {app_name}</b> est <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>URL de l\'application    : </b>{app_url}</p>\n                            <p><b>Adresse du vendeur   : </b>{vendor_address}</p>\n                            <p><b>Pays du vendeur   : </b>{vendor_country}</p>\n                            <p><b>Code postal du vendeur   : </b>{vendor_zipcode}</p>\n                            <p>Merci de nous avoir contacté,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(55, 4, 'it', 'New Vendor', '<p>Ciao,<b> {vendor_name} </b>!</p>\n                            <p>Benvenuto nella nostra app per i tuoi dati di accesso <b> {app_name}</b> è <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>URL dell\'app    : </b>{app_url}</p>\n                            <p><b>Indirizzo del venditore   : </b>{vendor_address}</p>\n                            <p><b>Paese fornitore   : </b>{vendor_country}</p>\n                            <p><b>Codice postale del venditore   : </b>{vendor_zipcode}</p>\n                            <p>Grazie per esserti connesso con noi,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(56, 4, 'ja', 'New Vendor', '<p>こんにちは,<b> {vendor_name} </b>!</p>\n                            <p>私たちのアプリのyoreログインの詳細へようこそ <b> {app_name}</b> は <br></p>\n                            <p><b>Eメール   : </b>{vendor_email}</p>\n                            <p><b>アプリのURL    : </b>{app_url}</p>\n                            <p><b>ベンダーの住所   : </b>{vendor_address}</p>\n                            <p><b>ベンダーの国   : </b>{vendor_country}</p>\n                            <p><b>ベンダーの郵便番号   : </b>{vendor_zipcode}</p>\n                            <p>ご連絡ありがとうございます,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(57, 4, 'nl', 'New Vendor', '<p>Hallo,<b> {vendor_name} </b>!</p>\n                            <p>Welkom bij de inloggegevens van onze app voor: <b> {app_name}</b> is <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>App-URL   : </b>{app_url}</p>\n                            <p><b>Adres leverancier  : </b>{vendor_address}</p>\n                            <p><b>Land van leverancier  : </b>{vendor_country}</p>\n                            <p><b>Postcode leverancier   : </b>{vendor_zipcode}</p>\n                            <p>Bedankt voor het contact met ons,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(58, 4, 'pl', 'New Vendor', '<p>Witam,<b> {vendor_name} </b>!</p>\n                            <p>Witamy w naszej aplikacji yore dane logowania do <b> {app_name}</b> jest <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>URL aplikacji    : </b>{app_url}</p>\n                            <p><b>Adres dostawcy   : </b>{vendor_address}</p>\n                            <p><b>Kraj dostawcy   : </b>{vendor_country}</p>\n                            <p><b>Kod pocztowy dostawcy   : </b>{vendor_zipcode}</p>\n                            <p>Dziękujemy za kontakt z nami,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(59, 4, 'ru', 'New Vendor', '<p>Привет,<b> {vendor_name} </b>!</p>\n                            <p>Добро пожаловать в наше приложение. <b> {app_name}</b> является <br></p>\n                            <p><b>Эл. адрес   : </b>{vendor_email}</p>\n                            <p><b>URL приложения    : </b>{app_url}</p>\n                            <p><b>Адрес поставщика   : </b>{vendor_address}</p>\n                            <p><b>Страна поставщика   : </b>{vendor_country}</p>\n                            <p><b>Почтовый индекс поставщика  : </b>{vendor_zipcode}</p>\n                            <p>Спасибо, что связались с нами,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(60, 4, 'pt', 'New Vendor', '<p>Olá,<b> {vendor_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Endereço do fornecedor   : </b>{vendor_address}</p>\n                            <p><b>País do fornecedor   : </b>{vendor_country}</p>\n                            <p><b>CEP do fornecedor   : </b>{vendor_zipcode}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(61, 4, 'tr', 'New Vendor', '<p>Merhaba,<b> {vendor_name} </b>!</p>\n                            <p>Uygulamamıza hoş geldiniz, eski <b> {app_name}</b> için giriş ayrıntısı <br></p>\n                            <p><b>E-posta : </b>{vendor_email}</p>\n                            <p><b>Uygulama urlsi : </b>{app_url}</p>\n                            <p><b>Satıcı Adresi : </b>{vendor_address}</p>\n                            <p><b>Satıcı Ülke : </b>{vendor_country}</p>\n                            <p><b>Satıcı Posta Kodu : </b>{vendor_zipcode}</p>\n                            <p>Bizimle bağlantı kurduğunuz için teşekkür ederiz,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(62, 4, 'he', 'New Vendor', '<p>שלום,<b> {vendor_name} </b>!</p>\n                            <p>ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של <b> {app_name}</b> הוא <br></p>\n                            <p><b>דוא\"ל: </b>{vendor_email}</p>\n                            <p><b>כתובת אתר של אפליקציה: </b>{app_url}</p>\n                            <p><b>כתובת ספק: </b>{vendor_address}</p>\n                            <p><b>ארץ הספק: </b>{vendor_country}</p>\n                            <p><b>מיקוד הספק: </b>{vendor_zipcode}</p>\n                            <p>תודה שהתחברת אלינו,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(63, 4, 'zh', 'New Vendor', '<p>您好，<b> {vendor_name} </b>！</p>\n                            <p>欢迎使用我们的应用，<b> {app_name}</b> 的登录详细信息是<br></p>\n                            <p><b>电子邮件：</b>{vendor_email}</p>\n                            <p><b>应用程序网址：</b>{app_url}</p>\n                            <p><b>供应商地址：</b>{vendor_address}</p>\n                            <p><b>供应商国家/地区：</b>{vendor_country}</p>\n                            <p><b>供应商邮政编码：</b>{vendor_zipcode}</p>\n                            <p>感谢您与我们联系，</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(64, 4, 'pt-br', 'New Vendor', '<p>Olá,<b> {vendor_name} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{vendor_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Endereço do fornecedor   : </b>{vendor_address}</p>\n                            <p><b>País do fornecedor   : </b>{vendor_country}</p>\n                            <p><b>CEP do fornecedor   : </b>{vendor_zipcode}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(65, 5, 'ar', 'New Quote', '<p>مرحبًا,<b> {quotation_customers} </b>!</p>\n                            <p>مرحبًا بك في التطبيق الخاص بنا تفاصيل تسجيل الدخول الخاصة بـ <b> {app_name}</b> هو <br></p>\n                            <p><b>البريد الإلكتروني   : </b>{customer_email}</p>\n                            <p><b>عنوان url للتطبيق    : </b>{app_url}</p>\n                            <p><b>رقم مرجع الاقتباس   : </b>{quotation_reference_no}</p>\n                            <p><b>تاريخ الاقتباس  : </b>{quotation_date}</p>\n                            <p>شكرا لتواصلك معنا,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(66, 5, 'da', 'New Quote', '<p>Hej,<b> {quotation_customers} </b>!</p>\n                            <p>Velkommen til vores app, hvor du kan logge ind <b> {app_name}</b> er <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Tilbudsreferencenr   : </b>{quotation_reference_no}</p>\n                            <p><b>Tilbudsdato  : </b>{quotation_date}</p>\n                            <p>Tak fordi du tog kontakt med os,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(67, 5, 'de', 'New Quote', '<p>Hallo,<b> {quotation_customers} </b>!</p>\n                            <p>Willkommen in unserer App für Ihre Login-Daten <b> {app_name}</b> ist <br></p>\n                            <p><b>Email   : </b>{customer_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Zitat-Referenz-Nr   : </b>{quotation_reference_no}</p>\n                            <p><b>Angebotsdatum : </b>{quotation_date}</p>\n                            <p>Vielen Dank, dass Sie sich mit uns verbunden haben,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(68, 5, 'en', 'New Quote', '<p>Hello,<b> {quotation_customers} </b>!</p>\n                            <p>Welcome to our app yore login detail for <b> {app_name}</b> is <br></p>\n                            <p><b>Email   : </b>{customer_email}</p>\n                            <p><b>App url    : </b>{app_url}</p>\n                            <p><b>Quotation Reference No   : </b>{quotation_reference_no}</p>\n                            <p><b>Quotation Date  : </b>{quotation_date}</p>\n                            <p>Thank you for connecting with us,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(69, 5, 'es', 'New Quote', '<p>Hola,<b> {quotation_customers} </b>!</p>\n                            <p>Bienvenido a nuestra aplicación antaño detalles de inicio de sesión para <b> {app_name}</b> es <br></p>\n                            <p><b>Correo electrónico   : </b>{customer_email}</p>\n                            <p><b>URL de la aplicación    : </b>{app_url}</p>\n                            <p><b>Número de referencia de cotización   : </b>{quotation_reference_no}</p>\n                            <p><b>Fecha de cotización  : </b>{quotation_date}</p>\n                            <p>Gracias por conectar con nosotras,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(70, 5, 'fr', 'New Quote', '<p>Bonjour,<b> {quotation_customers} </b>!</p>\n                            <p>Bienvenue sur notre application autrefois les informations de connexion pour <b> {app_name}</b> est <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL de l\'application   : </b>{app_url}</p>\n                            <p><b>Référence du devis Non  : </b>{quotation_reference_no}</p>\n                            <p><b>Date de cotation  : </b>{quotation_date}</p>\n                            <p>Merci de nous avoir contacté,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(71, 5, 'it', 'New Quote', '<p>Ciao,<b> {quotation_customers} </b>!</p>\n                            <p>Benvenuto nella nostra app per i tuoi dati di accesso <b> {app_name}</b> è <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL dell\'app    : </b>{app_url}</p>\n                            <p><b>Riferimento preventivo n   : </b>{quotation_reference_no}</p>\n                            <p><b>Data di preventivo  : </b>{quotation_date}</p>\n                            <p>Grazie per esserti connesso con noi,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(72, 5, 'ja', 'New Quote', '<p>こんにちは,<b> {quotation_customers} </b>!</p>\n                            <p>私たちのアプリのyoreログインの詳細へようこそ <b> {app_name}</b> は <br></p>\n                            <p><b>Eメール   : </b>{customer_email}</p>\n                            <p><b>アプリのURL    : </b>{app_url}</p>\n                            <p><b>見積もり参照番号   : </b>{quotation_reference_no}</p>\n                            <p><b>見積もり日  : </b>{quotation_date}</p>\n                            <p>ご連絡ありがとうございます,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(73, 5, 'nl', 'New Quote', '<p>Hallo,<b> {quotation_customers} </b>!</p>\n                            <p>Welkom bij de inloggegevens van onze app voor: <b> {app_name}</b> is <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>App-URL    : </b>{app_url}</p>\n                            <p><b>Referentienummer offerte:   : </b>{quotation_reference_no}</p>\n                            <p><b>Offertedatum:  : </b>{quotation_date}</p>\n                            <p>Bedankt voor het contact met ons,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(74, 5, 'pl', 'New Quote', '<p>Witam,<b> {quotation_customers} </b>!</p>\n                            <p>Witamy w naszej aplikacji yore dane logowania do <b> {app_name}</b> jest <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL aplikacji    : </b>{app_url}</p>\n                            <p><b>Numer referencyjny oferty  : </b>{quotation_reference_no}</p>\n                            <p><b>Data wyceny  : </b>{quotation_date}</p>\n                            <p>Dziękujemy za kontakt z nami,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(75, 5, 'ru', 'New Quote', '<p>Привет,<b> {quotation_customers} </b>!</p>\n                            <p>Добро пожаловать в наше приложение. <b> {app_name}</b> является <br></p>\n                            <p><b>Эл. адрес   : </b>{customer_email}</p>\n                            <p><b>URL приложения    : </b>{app_url}</p>\n                            <p><b>Цитата Номер ссылки   : </b>{quotation_reference_no}</p>\n                            <p><b>Дата котировки  : </b>{quotation_date}</p>\n                            <p>Спасибо, что связались с нами,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(76, 5, 'pt', 'New Quote', '<p>Olá,<b> {quotation_customers} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Nº de referência de cotação   : </b>{quotation_reference_no}</p>\n                            <p><b>Data de cotação  : </b>{quotation_date}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(77, 5, 'tr', 'New Quote', '<p>Merhaba,<b> {quotation_customers} </b>!</p>\n                            <p>Uygulamamıza hoş geldiniz, eski <b> {app_name}</b> için giriş ayrıntısı <br></p>\n                            <p><b>E-posta : </b>{customer_email}</p>\n                            <p><b>Uygulama url : </b>{app_url}</p>\n                            <p><b>Teklif Referans No : </b>{quotation_reference_no}</p>\n                            <p><b>Teklif Tarihi : </b>{quotation_date}</p>\n                            <p>Bizimle bağlantı kurduğunuz için teşekkür ederiz,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47');
INSERT INTO `email_template_langs` (`id`, `parent_id`, `lang`, `subject`, `content`, `created_at`, `updated_at`) VALUES
(78, 5, 'he', 'New Quote', '<p>שלום,<b> {quotation_customers} </b>!</p>\n                            <p>ברוך הבא לאפליקציה שלנו, פרטי ההתחברות של <b> {app_name}</b> הוא <br></p>\n                            <p><b>דוא\"ל: </b>{customer_email}</p>\n                            <p><b>כתובת אתר של אפליקציה: </b>{app_url}</p>\n                            <p><b>מספר סימוכין להצעת מחיר: </b>{quotation_reference_no}</p>\n                            <p><b>תאריך הצעת מחיר: </b>{quotation_date}</p>\n                            <p>תודה שהתחברת אלינו,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(79, 5, 'zh', 'New Quote', '<p>您好，<b> {quotation_customers} </b>！</p>\n                            <p>欢迎使用我们的应用，<b> {app_name}</b> 的登录详细信息是<br></p>\n                            <p><b>电子邮件：</b>{customer_email}</p>\n                            <p><b>应用程序网址：</b>{app_url}</p>\n                            <p><b>报价参考编号：</b>{quotation_reference_no}</p>\n                            <p><b>报价日期：</b>{quotation_date}</p>\n                            <p>感谢您与我们联系，</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(80, 5, 'pt-br', 'New Quote', '<p>Olá,<b> {quotation_customers} </b>!</p>\n                            <p>Bem-vindo ao nosso aplicativo antigo detalhe de login para <b> {app_name}</b> é <br></p>\n                            <p><b>E-mail   : </b>{customer_email}</p>\n                            <p><b>URL do aplicativo    : </b>{app_url}</p>\n                            <p><b>Nº de referência de cotação   : </b>{quotation_reference_no}</p>\n                            <p><b>Data de cotação  : </b>{quotation_date}</p>\n                            <p>Obrigado por conectar com a gente,</p>\n                            <p>{app_name}</p>', '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `branch_id` tinyint(4) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `amount` double DEFAULT 0,
  `note` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expense_categories`
--

CREATE TABLE `expense_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `join_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `landing_page_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `landing_page_settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(1, 'topbar_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'topbar_notification_msg', '70% Special Offer. Don’t Miss it. The offer ends in 72 hours.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'menubar_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'menubar_page', '[{\"menubar_page_name\": \"About Us\",\"template_name\": \"page_content\",\"page_url\": \"\",\"menubar_page_contant\": \"Welcome to the Posgo website. By accessing this website, you agree to comply with and be bound by the following terms and conditions of use. If you disagree with any part of these terms, please do not use our website. The content of the pages of this website is for your general information and use only. It is subject to change without notice. This website uses cookies to monitor browsing preferences. If you do allow cookies to be used, personal information may be stored by us for use by third parties. Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness, or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors, and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law. Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services, or information available through this website meet your specific requirements. This website contains material that is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance, and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions. Unauthorized use of this website may give rise to a claim for damages and\\/or be a criminal offense. From time to time, this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).\",\"page_slug\": \"about_us\",\"header\": \"on\",\"footer\": \"on\",\"login\": \"on\"},{\"menubar_page_name\": \"Terms and Conditions\",\"template_name\": \"page_content\",\"page_url\": \"\",\"menubar_page_contant\": \"Welcome to the Posgo website. By accessing this website, you agree to comply with and be bound by the following terms and conditions of use. If you disagree with any part of these terms, please do not use our website.\\r\\n\\r\\nThe content of the pages of this website is for your general information and use only. It is subject to change without notice.\\r\\n\\r\\nThis website uses cookies to monitor browsing preferences. If you do allow cookies to be used, personal information may be stored by us for use by third parties.\\r\\n\\r\\nNeither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness, or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors, and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.\\r\\n\\r\\nYour use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services, or information available through this website meet your specific requirements.\\r\\n\\r\\nThis website contains material that is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance, and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.\\r\\n\\r\\nUnauthorized use of this website may give rise to a claim for damages and\\/or be a criminal offense.\\r\\n\\r\\nFrom time to time, this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).\",\"page_slug\": \"terms_and_conditions\",\"header\": \"off\",\"footer\": \"on\",\"login\": \"on\"},{\"menubar_page_name\": \"Privacy Policy\",\"template_name\": \"page_content\",\"page_url\": \"\",\"menubar_page_contant\": \"Introduction: An overview of the privacy policy, including the purpose and scope of the policy. Information Collection: Details about the types of information collected from users\\/customers, such as personal information (name, address, email), device information, usage data, and any other relevant data. Data Usage: An explanation of how the collected data will be used, including providing services, improving products, personalization, analytics, and any other legitimate business purposes. Data Sharing: Information about whether and how the company shares user data with third parties, such as partners, service providers, or affiliates, along with the purposes of such sharing. Data Security: Details about the measures taken to protect user data from unauthorized access, loss, or misuse, including encryption, secure protocols, access controls, and data breach notification procedures. User Choices: Information on the choices available to users regarding the collection, use, and sharing of their personal data, including opt-out mechanisms and account settings. Cookies and Tracking Technologies: Explanation of the use of cookies, web beacons, and similar technologies for tracking user activity and collecting information for analytics and advertising purposes. Third-Party Links: Clarification that the companys website or services may contain links to third-party websites or services and that the privacy policy does not extend to those external sites. Data Retention: Details about the retention period for user data and how long it will be stored by the company. Legal Basis and Compliance: Information about the legal basis for processing personal data, compliance with applicable data protection laws, and the rights of users under relevant privacy regulations (e.g., GDPR, CCPA). Updates to the Privacy Policy: Notification that the privacy policy may be updated from time to time, and how users will be informed of any material changes. Contact Information: How users can contact the company regarding privacy-related concerns or inquiries.\",\"page_slug\": \"privacy_policy\",\"header\": \"off\",\"footer\": \"on\",\"login\": \"on\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'site_logo', 'site_logo.png', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 'site_description', 'We build modern web tools to help you jump-start your daily business work.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 'home_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 'home_offer_text', '70% Special Offer', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 'home_title', 'Home', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 'home_heading', 'POSGo SaaS Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(11, 'home_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(12, 'home_trusted_by', '1000+ Customer', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(13, 'home_live_demo_link', 'https://demo.workdo.io/posgo-saas/login', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(14, 'home_buy_now_link', 'https://codecanyon.net/item/posgo-saas-purchase-and-sales-management-tool/26199980', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(15, 'home_banner', 'home_banner.png', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(16, 'home_logo', 'home_logo.png,home_logo2.png,home_logo3.png,home_logo4.png,home_logo5.png,home_logo6.png,home_logo7.png', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(17, 'feature_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(18, 'feature_title', 'Features', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(19, 'feature_heading', 'Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(20, 'feature_description', 'Use these awesome forms to login or create new account in your project for free. Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(21, 'feature_buy_now_link', 'https://codecanyon.net/item/posgo-saas-purchase-and-sales-management-tool/26199980', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(22, 'feature_of_features', '[{\"feature_logo\":\"1688097751-feature_logo.png\",\"feature_heading\":\"Feature\",\"feature_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"feature_logo\":\"1688097795-feature_logo.png\",\"feature_heading\":\"Support\",\"feature_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"feature_logo\":\"1688097802-feature_logo.png\",\"feature_heading\":\"Integration\",\"feature_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(23, 'highlight_feature_heading', 'Happy Clients Use Dashboard', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(24, 'highlight_feature_description', 'POSGo SaaS Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(25, 'highlight_feature_image', 'highlight_feature_image.png', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(26, 'other_features', '[{\"other_features_image\":\"1688044209-other_features_image.png\",\"other_features_heading\":\"POSGo SaaS Purchase and Sales Management Tool\",\"other_featured_description\":\"<p>Use these awesome forms to login or create new account in your project for free.<\\/p>\",\"other_feature_buy_now_link\":\"https:\\/\\/codecanyon.net\\/item\\/posgo-saas-purchase-and-sales-management-tool\\/26199980\"},{\"other_features_image\":\"1688099315-other_features_image.png\",\"other_features_heading\":\"POSGo SaaS Purchase and Sales Management Tool\",\"other_featured_description\":\"<p>Use these awesome forms to login or create new account in your project for free.<\\/p>\",\"other_feature_buy_now_link\":\"https:\\/\\/codecanyon.net\\/item\\/posgo-saas-purchase-and-sales-management-tool\\/26199980\"},{\"other_features_image\":\"1688099474-other_features_image.png\",\"other_features_heading\":\"POSGo SaaS Purchase and Sales Management Tool\",\"other_featured_description\":\"<p>Use these awesome forms to login or create new account in your project for free.<\\/p>\",\"other_feature_buy_now_link\":\"https:\\/\\/codecanyon.net\\/item\\/posgo-saas-purchase-and-sales-management-tool\\/26199980\"},{\"other_features_image\":\"1688101388-other_features_image.png\",\"other_features_heading\":\"POSGo SaaS Purchase and Sales Management Tool\",\"other_featured_description\":\"<p>Use these awesome forms to login or create new account in your project for free.<\\/p>\",\"other_feature_buy_now_link\":\"https:\\/\\/codecanyon.net\\/item\\/posgo-saas-purchase-and-sales-management-tool\\/26199980\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(27, 'discover_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(28, 'discover_heading', 'POSGo SaaS Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(29, 'discover_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(30, 'discover_live_demo_link', 'https://demo.workdo.io/posgo-saas/login', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(31, 'discover_buy_now_link', 'https://codecanyon.net/item/posgo-saas-purchase-and-sales-management-tool/26199980', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(32, 'discover_of_features', '[{\"discover_logo\":\"1688101306-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098009-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098017-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098028-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098041-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098050-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098061-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"},{\"discover_logo\":\"1688098069-discover_logo.png\",\"discover_heading\":\"Feature\",\"discover_description\":\"<p>Use these awesome forms to login or create new account in your project for free.Use these awesome forms to login or create new account in your project for free.<\\/p>\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(33, 'screenshots_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(34, 'screenshots_heading', 'POSGo SaaS Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(35, 'screenshots_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(36, 'screenshots', '[{\"screenshots\":\"1688095576-screenshots.png\",\"screenshots_heading\":\"Dashboard\"},{\"screenshots\":\"1688101503-screenshots.png\",\"screenshots_heading\":\"Profile Overview\"},{\"screenshots\":\"1688101676-screenshots.png\",\"screenshots_heading\":\"Notification Overview\"},{\"screenshots\":\"1688042861-screenshots.png\",\"screenshots_heading\":\"Quaotation\"},{\"screenshots\":\"1688042703-screenshots.png\",\"screenshots_heading\":\"Invoice\"},{\"screenshots\":\"1688101481-screenshots.png\",\"screenshots_heading\":\"POS\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(37, 'plan_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(38, 'plan_title', 'Plan', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(39, 'plan_heading', 'POSGo SaaS All In One Place POSGo SaaS System', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(40, 'plan_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(41, 'faq_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(42, 'faq_title', 'Faq', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(43, 'faq_heading', 'POSGo SaaS Purchase and Sales Management Tool', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(44, 'faq_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(45, 'faqs', '[{\"faq_questions\":\"#What does \\\"Theme\\/Package Installation\\\" mean?\",\"faq_answer\":\"For an easy-to-install theme\\/package, we have included step-by-step detailed documentation (in English). However, if it is not done perfectly, please feel free to contact the support team at support@workdo.io\"},{\"faq_questions\":\"#What does \\\"Theme\\/Package Installation\\\" mean?\",\"faq_answer\":\"For an easy-to-install theme\\/package, we have included step-by-step detailed documentation (in English). However, if it is not done perfectly, please feel free to contact the support team at support@workdo.io\"},{\"faq_questions\":\"#What does \\\"Lifetime updates\\\" mean?\",\"faq_answer\":\"For an easy-to-install theme\\/package, we have included step-by-step detailed documentation (in English). However, if it is not done perfectly, please feel free to contact the support team at support@workdo.io\"},{\"faq_questions\":\"#What does \\\"Lifetime updates\\\" mean?\",\"faq_answer\":\"For an easy-to-install theme\\/package, we have included step-by-step detailed documentation (in English). However, if it is not done perfectly, please feel free to contact the support team at support@workdo.io\"},{\"faq_questions\":\"# What does \\\"6 months of support\\\" mean?\",\"faq_answer\":\"Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa\\r\\n                                    nesciunt\\r\\n                                    laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt\\r\\n                                    sapiente ea\\r\\n                                    proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven heard of them accusamus labore sustainable VHS.\"},{\"faq_questions\":\"# What does \\\"6 months of support\\\" mean?\",\"faq_answer\":\"Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa\\r\\n                                    nesciunt\\r\\n                                    laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt\\r\\n                                    sapiente ea\\r\\n                                    proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven heard of them accusamus labore sustainable VHS.\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(46, 'testimonials_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(47, 'testimonials_heading', 'From our Clients', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(48, 'testimonials_description', 'Use these awesome forms to login or create new account in your project for free.', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(49, 'testimonials_long_description', 'WorkDo seCommerce package offers you a “sales-ready.”secure online store. The package puts all the key pieces together, from design to payment processing. This gives you a headstart in your eCommerce venture. Every store is built using a reliable PHP framework -laravel. Thisspeeds up the development process while increasing the store’s security and performance.Additionally, thanks to the accompanying mobile app, you and your team can manage the store on the go. What’s more, because the app works both for you and your customers, you can use it to reach a wider audience.And, unlike popular eCommerce platforms, it doesn’t bind you to any terms and conditions or recurring fees. You get to choose where you host it or which payment gateway you use. Lastly, you getcomplete control over the looks of the store. And if it lacks any functionalities that you need, just reach out, and let’s discuss customization possibilities', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(50, 'testimonials', '[{\"testimonials_user_avtar\":\"1688099580-testimonials_user_avtar.jpg\",\"testimonials_title\":\"Tbistone\",\"testimonials_description\":\"Very quick customer support, installing this application on my machine locally, within 5 minutes of creating a ticket, the developer was able to fix the issue I had within 10 minutes. EXCELLENT! Thank you very much\",\"testimonials_user\":\"Chordsnstrings\",\"testimonials_designation\":\"from codecanyon\",\"testimonials_star\":\"4\"},{\"testimonials_user_avtar\":\"1688099587-testimonials_user_avtar.jpg\",\"testimonials_title\":\"Tbistone\",\"testimonials_description\":\"Very quick customer support, installing this application on my machine locally, within 5 minutes of creating a ticket, the developer was able to fix the issue I had within 10 minutes. EXCELLENT! Thank you very much\",\"testimonials_user\":\"Chordsnstrings\",\"testimonials_designation\":\"from codecanyon\",\"testimonials_star\":\"4\"},{\"testimonials_user_avtar\":\"1688099593-testimonials_user_avtar.jpg\",\"testimonials_title\":\"Tbistone\",\"testimonials_description\":\"Very quick customer support, installing this application on my machine locally, within 5 minutes of creating a ticket, the developer was able to fix the issue I had within 10 minutes. EXCELLENT! Thank you very much\",\"testimonials_user\":\"Chordsnstrings\",\"testimonials_designation\":\"from codecanyon\",\"testimonials_star\":\"4\"}]', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(51, 'footer_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(52, 'joinus_status', 'on', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(53, 'joinus_heading', 'Join Our Community', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(54, 'joinus_description', 'We build modern web tools to help you jump-start your daily business work.', '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

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

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `fullName` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `languages` (`id`, `code`, `fullName`, `created_at`, `updated_at`) VALUES
(1, 'ar', 'Arabic', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'zh', 'Chinese', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'da', 'Danish', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'de', 'German', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'en', 'English', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 'es', 'Spanish', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 'fr', 'French', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 'he', 'Hebrew', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 'it', 'Italian', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 'ja', 'Japanese', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(11, 'nl', 'Dutch', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(12, 'pl', 'Polish', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(13, 'pt', 'Portuguese', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(14, 'ru', 'Russian', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(15, 'tr', 'Turkish', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(16, 'pt-br', 'Portuguese(Brazil)', '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2020_01_08_102946_create_permission_tables', 1),
(5, '2020_01_13_051013_create_branches_table', 1),
(6, '2020_01_13_060248_create_taxes_table', 1),
(7, '2020_01_13_110148_create_units_table', 1),
(8, '2020_01_13_122418_create_products_table', 1),
(9, '2020_01_13_123207_create_categories_table', 1),
(10, '2020_01_13_123233_create_brands_table', 1),
(11, '2020_01_17_164241_create_cash_registers_table', 1),
(12, '2020_01_18_105949_create_purchases_table', 1),
(13, '2020_01_22_154101_create_customers_table', 1),
(14, '2020_01_22_164831_create_vendors_table', 1),
(15, '2020_01_23_102832_create_sales_table', 1),
(16, '2020_01_24_122536_create_purchased_items_table', 1),
(17, '2020_01_24_124332_create_selled_items_table', 1),
(18, '2020_01_27_171128_create_settings_table', 1),
(19, '2020_02_05_094618_create_products_returns_table', 1),
(20, '2020_02_05_095819_create_returned_items_table', 1),
(21, '2020_02_12_114307_create_quotations_table', 1),
(22, '2020_02_12_140623_create_quotation_items_table', 1),
(23, '2020_02_14_163303_create_calendars_table', 1),
(24, '2020_02_15_122212_create_notifications_table', 1),
(25, '2020_02_19_160028_create_todos_table', 1),
(26, '2020_02_20_092128_create_expenses_table', 1),
(27, '2020_02_20_092204_create_expense_categories_table', 1),
(28, '2020_02_20_112609_create_branch_sales_targets_table', 1),
(29, '2020_02_20_113020_create_branch_target_lists_table', 1),
(30, '2020_02_28_093751_create_plans_table', 1),
(31, '2020_02_28_114108_create_orders_table', 1),
(32, '2020_05_28_093858_create_coupons_table', 1),
(33, '2020_05_28_094224_create_users_coupons_table', 1),
(34, '2021_07_30_100526_admin_payment_settings', 1),
(35, '2021_11_17_105911_create_plan_request_table', 1),
(36, '2022_07_18_071630_create_email_templates_table', 1),
(37, '2022_07_18_071920_create_email_template_langs_table', 1),
(38, '2022_07_18_072307_create_user_email_templates_table', 1),
(39, '2023_03_16_051949_create_branch_products_table', 1),
(40, '2023_05_09_053324_create_notification_templates_table', 1),
(41, '2023_05_09_053403_create_notification_template_langs_table', 1),
(42, '2023_05_30_045428_create_webhooks_table', 1),
(43, '2023_06_05_043450_create_landing_page_settings_table', 1),
(44, '2023_06_08_085200_create_templates_table', 1),
(45, '2023_06_10_114031_create_join_us_table', 1),
(46, '2023_06_28_060137_create_languages_table', 1),
(47, '2024_02_08_035238_add_is_login_enable_to_users_table', 1),
(48, '2024_02_08_062426_add_trial_plan_to_users_table', 1),
(49, '2024_02_08_082918_add_trial_to_plans_table', 1),
(50, '2024_02_09_103439_add_is_disable_to_plans_table', 1),
(51, '2024_02_09_105224_add_is_refund_to_orders_table', 1),
(52, '2024_02_09_114833_update_password_for_users_table', 1),
(53, '2024_03_29_095108_create_referral_settings_table', 1),
(54, '2024_04_01_034719_add_reference_code_to_users_table', 1),
(55, '2024_04_01_105942_add_referring_company_referral_code_to_users_table', 1),
(56, '2024_04_02_071524_add_commission_amount_to_users_table', 1),
(57, '2024_04_03_044309_create_transactions_table', 1),
(58, '2024_04_03_071847_create_payout_requests_table', 1),
(59, '2024_04_05_051445_add_referral_code_to_transactions_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2);

-- --------------------------------------------------------

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

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from` date DEFAULT NULL,
  `to` date DEFAULT NULL,
  `color` varchar(30) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `slug` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
(1, 'New Customer', 'new_customer', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'New Vendor', 'new_vendor', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'New Quotation', 'new_quotation', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'New Sales', 'new_sales', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'New Return', 'new_return', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 'New Purchase', 'new_purchase', '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

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

CREATE TABLE `notification_template_langs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `lang` varchar(100) NOT NULL,
  `content` longtext NOT NULL,
  `variables` longtext NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notification_template_langs` (`id`, `parent_id`, `lang`, `content`, `variables`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'ar', 'تم إنشاء عميل جديد بواسطة {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 1, 'da', 'Ny bruger oprettet af {bruger_navn}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 1, 'de', 'Neuer Benutzer erstellt von {Benutzername}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 1, 'en', 'New Customer created by {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 1, 'es', 'Nueva usuario creada por {nombre_usuario}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 1, 'fr', 'Nouvel utilisateur créé par {Nom_utilisateur}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 1, 'it', 'Nuovo utente creato da {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 1, 'ja', 'によって作成された新しい顧客 {ユーザー名}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 1, 'nl', 'Nieuwe gebruiker gemaakt door {gebruikersnaam}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 1, 'pl', 'Nowy użytkownik utworzony przez {nazwa_użytkownika}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(11, 1, 'ru', 'Новый пользователь, созданный {имя_пользователя}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(12, 1, 'pt', 'Novo Usuário criado por {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(13, 1, 'tr', '{user_name} tarafından oluşturulan yeni İstemci.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(14, 1, 'he', 'לקוח חדש נוצר על ידי {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(15, 1, 'zh', '由 {user_name} 创建的新客户.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(16, 1, 'pt-br', 'Novo Usuário criado por {user_name}.', '{\n                    \"Customer Name\":\"customer_name\",\n                    \"Customer Email\": \"customer_email\",\n                    \"Customer Phone number\": \"customer_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(17, 2, 'ar', 'تم إنشاء بائع جديد بواسطة {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(18, 2, 'da', 'Ny leverandør oprettet af {bruger_navn}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(19, 2, 'de', 'Neuer Anbieter erstellt von {Benutzername}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(20, 2, 'en', 'New Vendor created by {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(21, 2, 'es', 'Nuevo proveedor creado por  {nombre_usuario}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(22, 2, 'fr', 'Nouveau fournisseur créé par {Nom_utilisateur}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(23, 2, 'it', 'Nuovo fornitore creato da {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(24, 2, 'ja', 'によって作成された新しいベンダー{ユーザー名}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(25, 2, 'nl', 'Nieuwe leverancier gemaakt door {gebruikersnaam}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(26, 2, 'pl', 'Nowy dostawca utworzony przez użytkownika {nazwa_użytkownika}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(27, 2, 'ru', 'Новый поставщик создан пользователем {имя_пользователя}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(28, 2, 'pt', 'Novo fornecedor criado por {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(29, 2, 'tr', '{user_name} tarafından oluşturulan yeni Satıcı.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(30, 2, 'he', 'ספק חדש שנוצר על ידי {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(31, 2, 'zh', '由 {user_name} 创建的新供应商。', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(32, 2, 'pt-br', 'Novo fornecedor criado por {user_name}.', '{\n                    \"Vendor Name\":\"vendor_name\",\n                    \"Vendor Email\": \"vendor_email\",\n                    \"Vendor Phone number\": \"vendor_phone_number\",\n                    \"Company Name\": \"user_name\",\n                    \"App Name\": \"app_name\"\n                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(33, 3, 'ar', 'عرض أسعار جديد تم إنشاؤه بواسطة{user_name}', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(34, 3, 'da', 'Nyt tilbud oprettet af {bruger_navn}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(35, 3, 'de', 'Neues Angebot erstellt von {Benutzername}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(36, 3, 'en', 'New Quotation created by {user_name}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(37, 3, 'es', 'Nuevo presupuesto creado por {nombre_usuario}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(38, 3, 'fr', 'Nouveau devis créé par {Nom_utilisateur}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(39, 3, 'it', 'Neues Angebot erstellt von {user_name}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(40, 3, 'ja', 'によって作成された新しい見積もり{ユーザー名}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(41, 3, 'nl', 'Nieuwe offerte gemaakt door {gebruikersnaam}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(42, 3, 'pl', 'Nowa oferta utworzona przez {nazwa_użytkownika}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(43, 3, 'ru', 'Новая цитата создана {имя_пользователя}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(44, 3, 'pt', 'Nova cotação criada por {user_name}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(45, 3, 'tr', '{user_name} tarafından oluşturulan Yeni Fiyat Teklifi.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(46, 3, 'he', 'הצעת מחיר חדשה שנוצרה על ידי {user_name}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(47, 3, 'zh', '由 {user_name} 创建的新报价。', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(48, 3, 'pt-br', 'Nova cotação criada por {user_name}.', '{\n                        \"Quotation Date\":\"quotation_date\",\n                        \"Quotation Reference No\":\"quotation_reference_no\",\n                        \"Quotation Customers\": \"quotation_customers\",\n                        \"Customer Email\": \"customer_email\",\n                        \"Company Name\": \"user_name\",\n                        \"App Name\": \"app_name\"\n                        }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(49, 4, 'ar', 'تم إنشاء المبيعات الجديدة {customer_email} بواسطة {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(50, 4, 'da', 'Nyt salgs-{customer_email} oprettet af {bruger_navn}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(51, 4, 'de', 'Neue Verkäufe {customer_email} erstellt von {Benutzername}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(52, 4, 'en', 'New Sales {customer_email} created by {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(53, 4, 'es', 'Nuevas ventas {customer_email} creadas por {nombre_usuario}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(54, 4, 'fr', 'Nouvelles ventes {customer_email} créées par {Nom_utilisateur}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(55, 4, 'it', 'Nuova vendita {customer_email} creata da {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(56, 4, 'ja', 'によって作成された新しいセールス {customer_email} {ユーザー名}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(57, 4, 'nl', 'Nieuwe verkoop {customer_email} gemaakt door {gebruikersnaam}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(58, 4, 'pl', 'Nowa sprzedaż {customer_email} utworzona przez użytkownika {nazwa_użytkownika}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(59, 4, 'ru', 'Новые продажи {customer_email}, созданные {имя_пользователя}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(60, 4, 'pt', 'Novas vendas {customer_email} criadas por {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(61, 4, 'tr', '{user_name} tarafından oluşturulan {customer_email} Yeni Satış.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(62, 4, 'he', 'מכירות חדשות {customer_email} שנוצרו על ידי {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(63, 4, 'zh', '由 {user_name} 创建的新销售 {customer_email}。', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(64, 4, 'pt-br', 'Novas vendas {customer_email} criadas por {user_name}.', '{\n                            \"Customer Name\": \"customer_name\",\n                            \"Customer Email\": \"customer_email\",\n                            \"Company Name\": \"user_name\",\n                            \"App Name\": \"app_name\"\n                            }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(65, 5, 'ar', 'عائد جديد تم إنشاؤه بواسطة {customer_name}{user_name}', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(66, 5, 'da', 'Ny retur {customer_name} oprettet af {bruger_navn}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(67, 5, 'de', 'Neue Rückgabe {customer_name} erstellt von {Benutzername}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(68, 5, 'en', 'New Return {customer_name} created by {user_name}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(69, 5, 'es', 'Nuevo retorno {customer_name} creado por {nombre_usuario}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(70, 5, 'fr', 'Nouveau retour {customer_name} créé par {Nom_utilisateur}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(71, 5, 'it', 'Nuovo reso {customer_name} creato da {user_name}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(72, 5, 'ja', 'によって作成された新しい返品 {customer_name}{ユーザー名}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(73, 5, 'nl', 'Nieuwe Return {customer_name} gemaakt door {gebruikersnaam}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(74, 5, 'pl', 'Nowy zwrot {customer_name} utworzony przez {nazwa_użytkownika}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(75, 5, 'ru', 'Новый Return {customer_name} создан {имя_пользователя}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(76, 5, 'pt', 'Novo retorno {customer_name} criado por {user_name}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(77, 5, 'tr', '{user_name} tarafından oluşturulan yeni {customer_name} İadesi.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(78, 5, 'he', 'החזרה חדשה {customer_name} נוצרה על ידי {user_name}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(79, 5, 'zh', '由 {user_name} 创建的新退货 {customer_name}。', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(80, 5, 'pt-br', 'Novo retorno {customer_name} criado por {user_name}.', '{\n                                \"Customer Name\": \"customer_name\",\n                                \"Vendor Name\": \"vendor_name\",\n                                \"Return Note\":\"return_note\",\n                                \"Staff Note\": \"staff_note\",\n                                \"Company Name\": \"user_name\",\n                                \"App Name\": \"app_name\"\n                                }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(81, 6, 'ar', 'عملية شراء جديدة تم إنشاؤها بواسطة {vendor_name}{user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(82, 6, 'da', 'Nyt køb {vendor_name} oprettet af {bruger_navn}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(83, 6, 'de', 'Neuer Kauf {vendor_name} erstellt von {Benutzername}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(84, 6, 'en', 'New Purchase {vendor_name} created by {user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(85, 6, 'es', 'Nueva compra {vendor_name} creada por {nombre_usuario}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(86, 6, 'fr', 'Nouvel achat {vendor_name} créé par {Nom_utilisateur}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(87, 6, 'it', 'Nuovo acquisto {vendor_name} creato da {user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(88, 6, 'ja', 'によって作成された新しい購入 {vendor_name}{ユーザー名}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(89, 6, 'nl', 'Nieuwe aankoop {vendor_name} gemaakt door {gebruikersnaam}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(90, 6, 'pl', 'Nowy zakup {vendor_name} utworzony przez {nazwa_użytkownika}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(91, 6, 'ru', 'Новая покупка {vendor_name} создана {имя_пользователя}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(92, 6, 'pt', 'Nova compra {vendor_name} criada por {user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(93, 6, 'tr', '{user_name} tarafından oluşturulan {vendor_name} adlı yeni Satın Alma.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(94, 6, 'he', 'רכישה חדשה {vendor_name} נוצרה על ידי {user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(95, 6, 'zh', '由 {user_name} 创建的新采购 {vendor_name}。', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(96, 6, 'pt-br', 'Nova compra {vendor_name} criada por {user_name}.', '{\n                                    \"Vendor Name\": \"vendor_name\",\n                                    \"Vendor Email\": \"vendor_email\",\n                                    \"Company Name\": \"user_name\",\n                                    \"App Name\": \"app_name\"\n                                    }', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `card_number` varchar(10) DEFAULT NULL,
  `card_exp_month` varchar(10) DEFAULT NULL,
  `card_exp_year` varchar(10) DEFAULT NULL,
  `plan_name` varchar(100) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `price` double DEFAULT 0,
  `price_currency` varchar(10) NOT NULL,
  `txn_id` varchar(100) NOT NULL,
  `payment_type` varchar(100) NOT NULL,
  `payment_status` varchar(100) NOT NULL,
  `receipt` varchar(191) DEFAULT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `is_refund` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

--
-- Table structure for table `payout_requests`
--

CREATE TABLE `payout_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `requested_date` date NOT NULL,
  `status` varchar(191) NOT NULL DEFAULT 'In Progress',
  `requested_amount` decimal(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- --------------------------------------------------------

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` decimal(30,2) DEFAULT 0.00,
  `duration` varchar(100) NOT NULL,
  `max_users` int(11) NOT NULL DEFAULT 0,
  `max_customers` int(11) NOT NULL DEFAULT 0,
  `max_vendors` int(11) NOT NULL DEFAULT 0,
  `storage_limit` double NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `enable_chatgpt` varchar(191) NOT NULL DEFAULT 'off',
  `trial` int(11) NOT NULL DEFAULT 0,
  `trial_days` varchar(191) DEFAULT NULL,
  `is_disable` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `plans` (`id`, `name`, `price`, `duration`, `max_users`, `max_customers`, `max_vendors`, `storage_limit`, `description`, `enable_chatgpt`, `trial`, `trial_days`, `is_disable`, `created_at`, `updated_at`) VALUES
(1, 'Free Plan', 0.00, 'Lifetime', 5, 5, 5, 20, NULL, 'on', 0, NULL, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

--
-- Table structure for table `plan_requests`
--

CREATE TABLE `plan_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `duration` varchar(20) NOT NULL DEFAULT 'monthly',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `purchase_price` decimal(25,2) DEFAULT 0.00,
  `sale_price` decimal(25,2) DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax_id` int(11) NOT NULL DEFAULT 0,
  `unit_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `brand_id` int(11) NOT NULL DEFAULT 0,
  `image` varchar(191) DEFAULT NULL,
  `product_type` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `slug`, `sku`, `purchase_price`, `sale_price`, `description`, `quantity`, `tax_id`, `unit_id`, `category_id`, `brand_id`, `image`, `product_type`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'تصميم QR حسب الطلب', 'tsmym-qr-hsb-altlb', 'SKU-296D944', 12.00, 3.00, 'كود', 981, 1, 1, 1, 1, NULL, 0, 2, '2026-02-27 09:35:00', '2026-02-27 10:09:20');

-- --------------------------------------------------------

--
-- Table structure for table `products_returns`
--

CREATE TABLE `products_returns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `reference_no` varchar(100) NOT NULL,
  `vendor_id` int(11) NOT NULL DEFAULT 0,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `return_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `purchased_items`
--

CREATE TABLE `purchased_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `cash_register_id` int(11) NOT NULL DEFAULT 0,
  `purchase_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax_id` int(11) NOT NULL DEFAULT 0,
  `tax` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchased_items`
--

INSERT INTO `purchased_items` (`id`, `branch_id`, `cash_register_id`, `purchase_id`, `product_id`, `price`, `quantity`, `tax_id`, `tax`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 12, 1000, 1, 0, '2026-02-27 10:06:29', '2026-02-27 10:06:29');

-- --------------------------------------------------------

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` varchar(50) NOT NULL,
  `vendor_id` int(11) NOT NULL DEFAULT 0,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `cash_register_id` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `invoice_id`, `vendor_id`, `branch_id`, `cash_register_id`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, '1', 0, 1, 1, 0, 2, '2026-02-27 10:06:29', '2026-02-27 10:06:29');

-- --------------------------------------------------------

--
-- Table structure for table `quotations`
--

CREATE TABLE `quotations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` int(11) NOT NULL DEFAULT 0,
  `date` date NOT NULL,
  `reference_no` varchar(100) NOT NULL,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `customer_email` varchar(191) DEFAULT NULL,
  `quotation_note` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `quotation_items`
--

CREATE TABLE `quotation_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quotation_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax_id` int(11) NOT NULL DEFAULT 0,
  `tax` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `referral_settings`
--

CREATE TABLE `referral_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `setting_status` varchar(191) NOT NULL,
  `commission_percentage` int(11) NOT NULL,
  `threshold_amt` int(11) NOT NULL,
  `settings_guidelines` longtext NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `returned_items`
--

CREATE TABLE `returned_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `return_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax_id` int(11) NOT NULL DEFAULT 0,
  `tax` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `created_by`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 0, 'web', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'Owner', 1, 'web', '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'Employee', 2, 'web', '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` varchar(50) NOT NULL,
  `customer_id` int(11) NOT NULL DEFAULT 0,
  `branch_id` int(11) NOT NULL DEFAULT 0,
  `cash_register_id` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `invoice_id`, `customer_id`, `branch_id`, `cash_register_id`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, '1', 0, 1, 1, 0, 2, '2026-02-27 10:07:18', '2026-02-27 10:07:18'),
(2, '2', 0, 1, 1, 0, 2, '2026-02-27 10:08:38', '2026-02-27 10:08:38'),
(3, '3', 0, 1, 1, 0, 2, '2026-02-27 10:09:20', '2026-02-27 10:09:20');

-- --------------------------------------------------------

--
-- Table structure for table `selled_items`
--

CREATE TABLE `selled_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sell_id` int(11) NOT NULL DEFAULT 0,
  `product_id` int(11) NOT NULL DEFAULT 0,
  `price` double DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `tax_id` int(11) NOT NULL DEFAULT 0,
  `tax` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `selled_items`
--

INSERT INTO `selled_items` (`id`, `sell_id`, `product_id`, `price`, `quantity`, `tax_id`, `tax`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 3, 3, 1, 0, '2026-02-27 10:07:18', '2026-02-27 10:07:18'),
(2, 2, 1, 3, 1, 1, 0, '2026-02-27 10:08:38', '2026-02-27 10:08:38'),
(3, 3, 1, 3, 15, 1, 0, '2026-02-27 10:09:20', '2026-02-27 10:09:20');

-- --------------------------------------------------------

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `name`, `value`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'local_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'wasabi_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 's3_storage_validation', 'jpg,jpeg,png,xlsx,xls,csv,pdf', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'local_storage_max_upload_size', '2048000', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'wasabi_max_upload_size', '2048000', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 's3_max_upload_size', '2048000', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 'storage_setting', 'local', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 'company_name', 'MF-MyFriend', 2, '2026-02-27 09:19:29', '2026-02-27 09:19:35'),
(9, 'company_address', 'Amman - Tla\' Al-Ali North, Sufyan Bin Wahab Street', 2, '2026-02-27 09:19:29', '2026-02-27 09:19:35'),
(10, 'company_city', 'Amman', 2, '2026-02-27 09:19:29', '2026-02-27 09:19:35'),
(14, 'purchase_invoice_template', 'template1', 2, '2026-02-27 09:22:47', '2026-02-27 09:22:47'),
(15, 'bill_qr_display', 'on', 2, '2026-02-27 09:22:47', '2026-02-27 09:22:47'),
(16, 'purchase_invoice_color', 'ffffff', 2, '2026-02-27 09:22:47', '2026-02-27 09:22:47'),
(17, 'barcode_type', 'code128', 2, NULL, NULL),
(18, 'barcode_format', 'css', 2, NULL, NULL),
(21, 'footer_text', '© 2026 POSGo SaaS', 1, NULL, NULL),
(22, 'default_language', 'en', 1, NULL, NULL),
(23, 'display_landing', 'on', 1, NULL, NULL),
(24, 'disable_signup_button', 'on', 1, NULL, NULL),
(25, 'color', 'theme-3', 1, NULL, NULL),
(26, 'color_flag', 'false', 1, NULL, NULL),
(27, 'cust_theme_bg', 'on', 1, NULL, NULL),
(28, 'cust_darklayout', 'off', 1, NULL, NULL),
(29, 'gdpr_cookie', 'off', 1, NULL, NULL),
(30, 'email_verification', 'off', 1, NULL, NULL),
(31, 'SITE_RTL', 'off', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `percentage` varchar(191) NOT NULL DEFAULT '0',
  `is_default` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `percentage`, `is_default`, `created_by`, `created_at`, `updated_at`) VALUES
(1, '0', '0', 0, 2, '2026-02-27 09:25:34', '2026-02-27 09:26:03'),
(2, '16', '16', 0, 2, '2026-02-27 09:25:44', '2026-02-27 09:25:44'),
(3, '4', '4', 0, 2, '2026-02-27 09:25:55', '2026-02-27 09:25:55'),
(4, '24', '24', 0, 2, '2026-02-27 09:26:12', '2026-02-27 09:26:12');

-- --------------------------------------------------------

--
-- Table structure for table `template`
--

CREATE TABLE `template` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_name` varchar(191) NOT NULL,
  `prompt` text NOT NULL,
  `module` varchar(191) NOT NULL,
  `field_json` text NOT NULL,
  `is_tone` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `template`
--

INSERT INTO `template` (`id`, `template_name`, `prompt`, `module`, `field_json`, `is_tone`, `created_at`, `updated_at`) VALUES
(1, 'return_note', 'rephrase this product return reason \'##reason##\' in  long description', 'return', '{\"field\":[{\"label\":\"Product return result \",\"placeholder\":\"e.g. size issue \",\"field_type\":\"textarea\",\"field_name\":\"reason\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 'staff_note', 'generate for employee note description about this product return reason \'##reason##\'', 'return', '{\"field\":[{\"label\":\"Product return result \",\"placeholder\":\"e.g. size issue \",\"field_type\":\"textarea\",\"field_name\":\"reason\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 'quotation_note', 'generate note for quotations ending notes for quotation with includes of this \'customer satisfication\'', 'quotations', '{\"field\":[{\"label\":\"Include focusable keywords \",\"placeholder\":\"e.g. customer service \",\"field_type\":\"textarea\",\"field_name\":\"reason\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 'invoice_footer_title', 'Generate a invoice footer titles for an invoice type to ##type##.', 'invoice_footer', '{\"field\":[{\"label\":\"Invoice Footer Type\",\"placeholder\":\"e.g.purchase, sale\",\"field_type\":\"text_box\",\"field_name\":\"type\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 'invoice_footer_notes', 'Generate a invoice footer notes for an invoice footer title is ##title##.', 'invoice_footer', '{\"field\":[{\"label\":\"Invoice Footer Title\",\"placeholder\":\"e.g.Invoice Accuracy\",\"field_type\":\"text_box\",\"field_name\":\"title\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 'title', 'Generate a creative and engaging event title for an upcoming event. The event can be a ##type##. Please focus on creating a title that captures the essence of the event, sparks curiosity, and encourages attendance. Aim to make the title memorable, intriguing, and aligned with the purpose and theme of the event. Consider the target audience, event objectives, and any specific keywords or ideas you would like to incorporate', 'calendars', '{\"field\":[{\"label\":\"Specific type of event\",\"placeholder\":\"e.g.conference, workshop, seminar\",\"field_type\":\"text_box\",\"field_name\":\"type\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 'description', 'generate a captivating description for the event that title is ##title##  in that activities are ##description##.please highlights its purpose, activities, and the benefits of attending', 'calendars', '{\"field\":[{\"label\":\"Event topic\",\"placeholder\":\"Employee Prefomance celebration \",\"field_type\":\"text_box\",\"field_name\":\"title\"},{\"label\":\"Event activiteis\",\"placeholder\":\"speech,presentation\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 'name', 'Create creative product names:  ##description##', 'product', '{\"field\":[{\"label\":\"Product Description\",\"placeholder\":\"e.g.Food,Electronics,Book\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 'description', 'Write a long creative product description for: ##title## \n\nTarget audience is: ##audience## \n\nUse this description: ##description## \n\nTone of generated text must be:\n ##tone_language## \n\n', 'product', '{\"field\":[{\"label\":\"Product name\",\"placeholder\":\"e.g. VR, Honda\",\"field_type\":\"text_box\",\"field_name\":\"title\"},{\"label\":\"Audience\",\"placeholder\":\"e.g. Women, Aliens\",\"field_type\":\"text_box\",\"field_name\":\"audience\"},{\"label\":\"Product Description\",\"placeholder\":\"e.g. VR is an innovative device that can allow you to be part of virtual world\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 'name', 'Generate a category name for a product in an ##product_name##, specifically related to ##instruction##.', 'category', '{\"field\":[{\"label\":\"Product name\",\"placeholder\":\"e.g.Systems and Control,Energy Systems\",\"field_type\":\"text_box\",\"field_name\":\"product_name\"},{\"label\":\"Category Instruction\",\"placeholder\":\"e.g.Book,Electronics\",\"field_type\":\"textarea\",\"field_name\":\"instruction\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(11, 'title', 'Generate a todo title for a ##description##.', 'todos', '{\"field\":[{\"label\":\"Todo Details\",\"placeholder\":\"e.g.Design Approved\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(12, 'note', 'generate short catchy description  for expense of ##description##', 'expense', '{\"field\":[{\"label\":\"Expense detail \",\"placeholder\":\"e.g. 12 computer\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]} ', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(13, 'name', 'generate category name of expense that indule this thing ##keyword##', 'expense_category', '{\"field\":[{\"label\":\"Expense type/item \",\"placeholder\":\"e.g. computer\",\"field_type\":\"textarea\",\"field_name\":\"keyword\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(14, 'name', 'Generate branch name for ##description##', 'branch', '{\"field\":[{\"label\":\"Branch Description\",\"placeholder\":\"e.g.\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(15, 'description', 'Generate a  tiny notification message and include this esentail detail ##description##', 'notifications', '{\"field\":[{\"label\":\"Notification description\",\"placeholder\":\"e.g. tommorow we have off\",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(16, 'content', 'Generate a meeting notification message for an ##topic## meeting. Include the date, time, location, and a brief agenda with three key discussion points.', 'notification template', '{\"field\":[{\"label\":\"Notification Message\",\"placeholder\":\"e.g.brief explanation of the purpose or background of the notification\",\"field_type\":\"textarea\",\"field_name\":\"topic\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(17, 'name', 'please suggest subscription plan  name  for this  :  ##description##  for my business', 'plan', '{\"field\":[{\"label\":\"What is your plan about?\",\"placeholder\":\"e.g. Describe your plan details \",\"field_type\":\"textarea\",\"field_name\":\"description\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(18, 'description', 'please suggest subscription plan  description  for this  :  ##title##:  for my business', 'plan', '{\"field\":[{\"label\":\"What is your plan title?\",\"placeholder\":\"e.g. Pro Resller,Exclusive Access\",\"field_type\":\"text_box\",\"field_name\":\"title\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(19, 'name', 'give 10 catchy only name of Offer or discount Coupon for : ##keywords##', 'coupon', '{\"field\":[{\"label\":\"Seed words\",\"placeholder\":\"e.g.coupon will provide you with a discount on your selected plan\",\"field_type\":\"text_box\",\"field_name\":\"keywords\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(20, 'meta_keywords', 'Write SEO meta title for:\n\n ##description## \n\nWebsite name is:\n ##title## \n\nSeed words:\n ##keywords## \n\n', 'seo', '{\"field\":[{\"label\":\"Website Name\",\"placeholder\":\"e.g. Amazon, Google\",\"field_type\":\"text_box\",\"field_name\":\"title\"},{\"label\":\"Website Description\",\"placeholder\":\"e.g. Describe what your website or business do\",\"field_type\":\"textarea\",\"field_name\":\"description\"},{\"label\":\"Keywords\",\"placeholder\":\"e.g.  cloud services, databases\",\"field_type\":\"text_box\",\"field_name\":\"keywords\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(21, 'meta_description', 'Write SEO meta description for:\n\n ##description## \n\nWebsite name is:\n ##title## \n\nSeed words:\n ##keywords## \n\n', 'seo', '{\"field\":[{\"label\":\"Website Name\",\"placeholder\":\"e.g. Amazon, Google\",\"field_type\":\"text_box\",\"field_name\":\"title\"},{\"label\":\"Website Description\",\"placeholder\":\"e.g. Describe what your website or business do\",\"field_type\":\"textarea\",\"field_name\":\"description\"},{\"label\":\"Keywords\",\"placeholder\":\"e.g.  cloud services, databases\",\"field_type\":\"text_box\",\"field_name\":\"keywords\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(22, 'cookie_title', 'please suggest me cookie title for this ##description## website which i can use in my website cookie', 'cookie', '{\"field\":[{\"label\":\"Website name or info\",\"placeholder\":\"e.g. example website \",\"field_type\":\"textarea\",\"field_name\":\"title\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(23, 'cookie_description', 'please suggest me  Cookie description for this cookie title ##title##  which i can use in my website cookie', 'cookie', '{\"field\":[{\"label\":\"Cookie Title \",\"placeholder\":\"e.g. example website \",\"field_type\":\"text_box\",\"field_name\":\"title\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(24, 'strictly_cookie_title', 'please suggest me only Strictly Cookie Title for this ##description## website which i can use in my website cookie', 'cookie', '{\"field\":[{\"label\":\"Website name or info\",\"placeholder\":\"e.g. example website \",\"field_type\":\"textarea\",\"field_name\":\"title\"}]}', 0, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(25, 'strictly_cookie_description', 'please suggest me Strictly Cookie description for this Strictly cookie title ##title##  which i can use in my website cookie', 'cookie', '{\"field\":[{\"label\":\"Strictly Cookie Title \",\"placeholder\":\"e.g. example website \",\"field_type\":\"text_box\",\"field_name\":\"title\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(26, 'more_information_description', 'I need assistance in crafting compelling content for my ##web_name## website\'s \'Contact Us\' page of my website. The page should provide relevant information to users, encourage them to reach out for inquiries, support, and feedback, and reflect the unique value proposition of my business.', 'cookie', '{\"field\":[{\"label\":\"Websit Name\",\"placeholder\":\"e.g. example website \",\"field_type\":\"text_box\",\"field_name\":\"web_name\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(27, 'content', 'generate email template for ##type##', 'email template', '{\"field\":[{\"label\":\"Email Type\",\"placeholder\":\"e.g. new user,new client\",\"field_type\":\"text_box\",\"field_name\":\"type\"}]}', 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

--
-- Table structure for table `todos`
--

CREATE TABLE `todos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `color` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `plan_price` decimal(8,2) NOT NULL,
  `commission_percentage` decimal(8,2) NOT NULL,
  `commission_amount` decimal(8,2) NOT NULL,
  `referral_code` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `shortname` varchar(50) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`id`, `name`, `shortname`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Q', 'Q', 2, '2026-02-27 09:26:37', '2026-02-27 09:26:49');

-- --------------------------------------------------------

--
-- Table structure for table `users_coupons`
--

CREATE TABLE `users_coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `order_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_email_templates`
--

CREATE TABLE `user_email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_email_templates`
--

INSERT INTO `user_email_templates` (`id`, `template_id`, `user_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(2, 2, 1, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(3, 3, 1, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(4, 4, 1, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(5, 5, 1, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(6, 1, 2, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(7, 2, 2, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(8, 3, 2, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(9, 4, 2, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47'),
(10, 5, 2, 1, '2026-02-27 09:15:47', '2026-02-27 09:15:47');

-- --------------------------------------------------------

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(15) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `zipcode` varchar(50) DEFAULT NULL,
  `is_active` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` (`id`, `name`, `email`, `phone_number`, `address`, `city`, `state`, `country`, `zipcode`, `is_active`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'Meeting-MF-MyFriend', 'Admin@mf-myfriend.online', '+962799539398', 'Jordan- Amman - Tla\' Al-Ali', 'amman', 'Amman', 'Jordan', '11953', 1, 2, '2026-02-27 09:31:30', '2026-02-27 09:31:30');

-- --------------------------------------------------------

--
-- Table structure for table `webhooks`
--

CREATE TABLE `webhooks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module` varchar(191) DEFAULT NULL,
  `method` varchar(191) NOT NULL,
  `url` varchar(191) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_payment_settings`
--
ALTER TABLE `admin_payment_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admin_payment_settings_name_created_by_unique` (`name`,`created_by`);

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branch_products`
--
ALTER TABLE `branch_products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branch_sales_targets`
--
ALTER TABLE `branch_sales_targets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `branch_target_lists`
--
ALTER TABLE `branch_target_lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `calendars`
--
ALTER TABLE `calendars`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cash_registers`
--
ALTER TABLE `cash_registers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customers_email_unique` (`email`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_template_langs`
--
ALTER TABLE `email_template_langs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `join_us`
--
ALTER TABLE `join_us`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `join_us_email_unique` (`email`);

--
-- Indexes for table `landing_page_settings`
--
ALTER TABLE `landing_page_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `landing_page_settings_name_unique` (`name`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_templates`
--
ALTER TABLE `notification_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notification_template_langs`
--
ALTER TABLE `notification_template_langs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_id_unique` (`order_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `payout_requests`
--
ALTER TABLE `payout_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plans_name_unique` (`name`);

--
-- Indexes for table `plan_requests`
--
ALTER TABLE `plan_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_returns`
--
ALTER TABLE `products_returns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchased_items`
--
ALTER TABLE `purchased_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quotations`
--
ALTER TABLE `quotations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quotation_items`
--
ALTER TABLE `quotation_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `referral_settings`
--
ALTER TABLE `referral_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `returned_items`
--
ALTER TABLE `returned_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `selled_items`
--
ALTER TABLE `selled_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_name_created_by_unique` (`name`,`created_by`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `template`
--
ALTER TABLE `template`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `todos`
--
ALTER TABLE `todos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_coupons`
--
ALTER TABLE `users_coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_email_templates`
--
ALTER TABLE `user_email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `vendors_email_unique` (`email`);

--
-- Indexes for table `webhooks`
--
ALTER TABLE `webhooks`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_payment_settings`
--
ALTER TABLE `admin_payment_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `branch_products`
--
ALTER TABLE `branch_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branch_sales_targets`
--
ALTER TABLE `branch_sales_targets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `branch_target_lists`
--
ALTER TABLE `branch_target_lists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `calendars`
--
ALTER TABLE `calendars`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cash_registers`
--
ALTER TABLE `cash_registers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `email_template_langs`
--
ALTER TABLE `email_template_langs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_categories`
--
ALTER TABLE `expense_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `join_us`
--
ALTER TABLE `join_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `landing_page_settings`
--
ALTER TABLE `landing_page_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `notification_template_langs`
--
ALTER TABLE `notification_template_langs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payout_requests`
--
ALTER TABLE `payout_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `plan_requests`
--
ALTER TABLE `plan_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `products_returns`
--
ALTER TABLE `products_returns`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchased_items`
--
ALTER TABLE `purchased_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `quotations`
--
ALTER TABLE `quotations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotation_items`
--
ALTER TABLE `quotation_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_settings`
--
ALTER TABLE `referral_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `returned_items`
--
ALTER TABLE `returned_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `selled_items`
--
ALTER TABLE `selled_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `template`
--
ALTER TABLE `template`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `todos`
--
ALTER TABLE `todos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `units`
--
ALTER TABLE `units`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users_coupons`
--
ALTER TABLE `users_coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_email_templates`
--
ALTER TABLE `user_email_templates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `webhooks`
--
ALTER TABLE `webhooks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

