
# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: backup
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `backup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `file_url` text NOT NULL,
  `status` text NOT NULL,
  `created_at` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 49 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer` (
  `customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_type` text DEFAULT NULL,
  `lead_source` text DEFAULT NULL,
  `salutation` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `whatsapp` text DEFAULT NULL,
  `default_currency` text DEFAULT NULL,
  `website` text DEFAULT NULL,
  `gst_vat_number` text DEFAULT NULL,
  `address_line_1` text DEFAULT NULL,
  `address_line_2` text DEFAULT NULL,
  `country` text DEFAULT NULL,
  `state_province` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `zip_postal_code` text DEFAULT NULL,
  `shipping_address_line_1` varchar(255) DEFAULT NULL,
  `shipping_country` varchar(100) DEFAULT NULL,
  `shipping_state_province` varchar(100) DEFAULT NULL,
  `shipping_city` varchar(100) DEFAULT NULL,
  `shipping_zip_postal_code` varchar(20) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `type` text NOT NULL,
  `industry` text DEFAULT NULL,
  `contact_persons` text NOT NULL,
  `customer_docs` longtext NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`customer_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 439 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_ledger
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_ledger` (
  `id` int(11) NOT NULL,
  `entry_date` text DEFAULT NULL,
  `entry_type` text DEFAULT NULL,
  `reference_no` text DEFAULT NULL,
  `invoice_id` text NOT NULL,
  `payment_id` text NOT NULL,
  `description` text DEFAULT NULL,
  `debit` text DEFAULT NULL,
  `credit` text DEFAULT NULL,
  `balance` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customerpayment
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customerpayment` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` text NOT NULL,
  `customer_name` text DEFAULT NULL,
  `customer_info` longtext DEFAULT NULL,
  `invoice_id` longtext DEFAULT NULL,
  `current_invoice_number` text DEFAULT NULL,
  `payment_number` text DEFAULT NULL,
  `payment_date` text DEFAULT NULL,
  `payment_amount` text DEFAULT NULL,
  `balance_amount` text NOT NULL,
  `wallet_amount` text NOT NULL,
  `payment_type` text DEFAULT NULL,
  `transaction_type` text NOT NULL,
  `payment_bank` text DEFAULT NULL,
  `cheque_number` text DEFAULT NULL,
  `cheque_date` text DEFAULT NULL,
  `reference_no` text NOT NULL,
  `payee_bank` text NOT NULL,
  `pdc_date` text NOT NULL,
  `pdc_number` text NOT NULL,
  `pdc_status` text NOT NULL,
  `add_attachment` text NOT NULL,
  `doc` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `status` text NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  `status_history` text NOT NULL,
  `bank_transaction_id` text NOT NULL,
  `created_time` text DEFAULT NULL,
  `updated_time` text DEFAULT NULL,
  `created_username` text DEFAULT NULL,
  `updated_username` text DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 354 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customerwallet
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customerwallet` (
  `wallet_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` text DEFAULT NULL,
  `transactions` longtext DEFAULT NULL,
  `available_balance` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`wallet_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: deliverynote
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `deliverynote` (
  `deliverynote_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `proforma_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deliverynote_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deliverynote_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deliverynote_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `general_terms_conditions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `line_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `line_items_short` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `doc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lpo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_username` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_username` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locked` longtext NOT NULL,
  `serializationSerial` longtext NOT NULL,
  PRIMARY KEY (`deliverynote_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 92 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: deliverynote_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `deliverynote_settings` (
  `id` int(11) NOT NULL,
  `prefix` text NOT NULL,
  `padding` text NOT NULL,
  `startFrom` text NOT NULL,
  `terms_conditions` text NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: expense
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `expense` (
  `expense_id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_number` text DEFAULT NULL,
  `type_of_expense` text NOT NULL,
  `expense_date` text NOT NULL,
  `amount` text NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  PRIMARY KEY (`expense_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 52 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: expense_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `expense_settings` (
  `expense_id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(10) DEFAULT NULL,
  `padding` int(11) DEFAULT NULL,
  `startFrom` int(11) DEFAULT NULL,
  `type_of_expenses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `sub_type_of_expenses` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`expense_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 6 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: inventory
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `inventory` (
  `inventory_id` int(11) NOT NULL AUTO_INCREMENT,
  `inventory_type` text NOT NULL,
  `inventory_name` text NOT NULL,
  `description` text NOT NULL,
  `unit` text NOT NULL,
  `price` text NOT NULL,
  `buying_price` text NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  `unit_id` text DEFAULT NULL,
  `stock` text NOT NULL,
  `sku` text DEFAULT NULL,
  `supplier_prices` longtext NOT NULL,
  `serialization` text NOT NULL,
  `used_serialization` longtext NOT NULL,
  PRIMARY KEY (`inventory_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 1111 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: invoice
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` text DEFAULT NULL,
  `customer_name` text DEFAULT NULL,
  `customer_info` longtext DEFAULT NULL,
  `invoice_number` text DEFAULT NULL,
  `invoice_date` text DEFAULT NULL,
  `expiry_date` text DEFAULT NULL,
  `quote_ref_number` text DEFAULT NULL,
  `proforma_ref_number` varchar(255) DEFAULT NULL,
  `delivery_note_ref_number` text DEFAULT NULL,
  `lpo_number` text DEFAULT NULL,
  `currency` text DEFAULT NULL,
  `terms` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `line_items` text DEFAULT NULL,
  `updated_line_items` longtext DEFAULT NULL,
  `subtotal` text DEFAULT NULL,
  `total_invoice_value` decimal(10, 2) DEFAULT NULL,
  `balance_amount` text NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  `doc` text DEFAULT NULL,
  `invoice_docs` longtext NOT NULL,
  `status` text DEFAULT NULL,
  `status_history` text NOT NULL,
  `profit` text NOT NULL,
  `created_time` text DEFAULT NULL,
  `updated_time` text DEFAULT NULL,
  `created_username` text DEFAULT NULL,
  `updated_username` text DEFAULT NULL,
  `locked` longtext NOT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 427 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: invoice_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `invoice_settings` (
  `id` int(10) unsigned NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `padding` int(11) DEFAULT NULL,
  `startFrom` int(11) DEFAULT NULL,
  `expiryDays` int(11) DEFAULT NULL,
  `emailSubject` varchar(255) DEFAULT NULL,
  `emailBody` text DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `terms_conditions` text NOT NULL,
  `whatsappActive` text NOT NULL,
  `whatsappAttachments` text NOT NULL,
  `whatsappMessage` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: lead
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `lead` (
  `lead_id` int(11) NOT NULL AUTO_INCREMENT,
  `lead_type` text DEFAULT NULL,
  `customer_type` text NOT NULL,
  `lead_source` text DEFAULT NULL,
  `name` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `whatsapp` text DEFAULT NULL,
  `website` text DEFAULT NULL,
  `contact_persons` text DEFAULT NULL,
  `converted_to_customer` text DEFAULT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`lead_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 122 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: payment_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `payment_settings` (
  `id` int(11) NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `padding` varchar(10) DEFAULT NULL,
  `startFrom` varchar(20) DEFAULT NULL,
  `expiryDays` int(11) DEFAULT NULL,
  `emailSubject` text DEFAULT NULL,
  `emailBody` text DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `whatsappActive` text NOT NULL,
  `whatsappAttachments` text NOT NULL,
  `whatsappMessage` longtext NOT NULL,
  `paymentPrefix` text NOT NULL,
  `paymentPadding` text NOT NULL,
  `paymentStartFrom` text NOT NULL,
  `advancePaymentEmailSubject` text DEFAULT NULL,
  `advancePaymentEmailBody` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: proforma
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `proforma` (
  `proforma_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_info` longtext DEFAULT NULL,
  `customer_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `proforma_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `proforma_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiry_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cheque_date` text DEFAULT NULL,
  `quote_ref_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lpo_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `proforma_terms` text DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `line_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `subtotal` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_global` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `advance_payment_received` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `progress_amount_payable` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_proforma_value` decimal(10, 2) DEFAULT NULL,
  `balance_amount` text NOT NULL,
  `refund_amount` text NOT NULL,
  `created_at` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `advance_payment_doc` longtext NOT NULL,
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_history` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profit` text NOT NULL,
  `created_time` text NOT NULL,
  `updated_time` text DEFAULT NULL,
  `created_username` text NOT NULL,
  `updated_username` text NOT NULL,
  `billing_notes_status` text NOT NULL,
  `locked` text NOT NULL,
  PRIMARY KEY (`proforma_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 205 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: proforma_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `proforma_settings` (
  `id` int(11) NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `padding` varchar(10) DEFAULT NULL,
  `startFrom` varchar(20) DEFAULT NULL,
  `expiryDays` int(11) DEFAULT NULL,
  `proforma_terms_conditions` text DEFAULT NULL,
  `emailSubject` text DEFAULT NULL,
  `emailBody` text DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `autoAttachPdf` tinyint(1) DEFAULT NULL,
  `whatsappActive` text NOT NULL,
  `whatsappAttachments` text DEFAULT NULL,
  `whatsappMessage` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: purchase
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `purchase` (
  `purchase_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supplier_id` text DEFAULT NULL,
  `purchaseorder_ref_number` longtext NOT NULL,
  `purchase_number` text DEFAULT NULL,
  `invoice_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `line_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `total_value` text NOT NULL,
  `balance_amount` text NOT NULL,
  `currency` text NOT NULL,
  `tax` text NOT NULL,
  `lpo` text NOT NULL,
  `doc` longtext NOT NULL,
  `status` text NOT NULL,
  `returns` longtext NOT NULL,
  `locked` longtext NOT NULL,
  `created_username` text NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`purchase_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 244 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: purchase_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `purchase_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` longtext DEFAULT NULL,
  `padding` longtext DEFAULT NULL,
  `startFrom` longtext DEFAULT NULL,
  `terms_conditions` longtext DEFAULT NULL,
  `prefixSupplier` text NOT NULL,
  `paddingSupplier` text NOT NULL,
  `startFromSupplier` text NOT NULL,
  `emailSubject` longtext DEFAULT NULL,
  `emailBody` longtext DEFAULT NULL,
  `cc` longtext DEFAULT NULL,
  `po_prefix` longtext DEFAULT NULL,
  `po_padding` longtext DEFAULT NULL,
  `po_startFrom` longtext DEFAULT NULL,
  `po_emailSubject` longtext DEFAULT NULL,
  `po_emailBody` longtext DEFAULT NULL,
  `po_emailcc` longtext DEFAULT NULL,
  `po_terms_conditions` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: purchaseorder
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `purchaseorder` (
  `purchaseorder_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_name` longtext NOT NULL,
  `supplier_id` text NOT NULL,
  `purchaseorder_number` text NOT NULL,
  `purchaseorder_date` text NOT NULL,
  `quote_reference` longtext NOT NULL,
  `ship_via` longtext NOT NULL,
  `fob` longtext NOT NULL,
  `po_terms_conditions` longtext NOT NULL,
  `po_payment_terms` longtext NOT NULL,
  `line_items` longtext NOT NULL,
  `order_stock` text NOT NULL,
  `total_value` text NOT NULL,
  `balance_amount` text NOT NULL,
  `currency` text NOT NULL,
  `tax` text NOT NULL,
  `doc` longtext NOT NULL,
  `status` text NOT NULL,
  `returns` longtext NOT NULL,
  `locked` longtext NOT NULL,
  `closed` text NOT NULL,
  `created_username` text NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  PRIMARY KEY (`purchaseorder_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 43 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: quote
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `quote` (
  `quote_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_info` longtext DEFAULT NULL,
  `customer_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quote_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quote_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiry_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_terms_conditions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtotal` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_global` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_quote_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `line_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `doc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  `status_history` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `winning_probability` longtext DEFAULT NULL,
  `billing_notes_status` text NOT NULL,
  `billing_notes_short` text NOT NULL,
  `profit` text NOT NULL,
  `created_time` text DEFAULT NULL,
  `updated_time` text DEFAULT NULL,
  `created_username` text DEFAULT NULL,
  `updated_username` text DEFAULT NULL,
  `lpo_number` text NOT NULL,
  `lpo_document` longtext NOT NULL,
  `locked` text NOT NULL,
  PRIMARY KEY (`quote_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 810 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: quote_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `quote_settings` (
  `id` int(11) NOT NULL,
  `prefix` varchar(50) DEFAULT NULL,
  `padding` varchar(10) DEFAULT NULL,
  `startFrom` varchar(20) DEFAULT NULL,
  `terms_conditions` text NOT NULL,
  `expiryDays` int(11) DEFAULT NULL,
  `emailSubject` text DEFAULT NULL,
  `emailBody` text DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `winning_probability` longtext NOT NULL,
  `whatsappActive` text NOT NULL,
  `whatsappAttachments` text NOT NULL,
  `whatsappMessage` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: recurringinvoice
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `recurringinvoice` (
  `recurringinvoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_id` longtext DEFAULT NULL,
  `invoice_number` longtext DEFAULT NULL,
  `recurring_repeat_every` longtext DEFAULT NULL,
  `recurring_interval_count` longtext DEFAULT NULL,
  `recurring_start_date` longtext DEFAULT NULL,
  `recurring_end_date` longtext DEFAULT NULL,
  `recurring_never_expire` longtext DEFAULT NULL,
  `next_due_date` longtext DEFAULT NULL,
  `status` longtext DEFAULT NULL,
  `recurringinvoice_created_at` longtext DEFAULT NULL,
  `recurringinvoice_updated_at` longtext DEFAULT NULL,
  PRIMARY KEY (`recurringinvoice_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 41 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: role
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` text NOT NULL,
  `privileges` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 31 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: salesreturn
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `salesreturn` (
  `salesreturn_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `salesreturn_date` text NOT NULL,
  `invoice_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_info` longtext NOT NULL,
  `delivery_notes` longtext NOT NULL,
  `used_serial_numbers` longtext NOT NULL,
  `salesreturn_number` text NOT NULL,
  `line_items` longtext DEFAULT NULL,
  `updated_line_items` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` longtext DEFAULT NULL,
  `customer_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` longtext DEFAULT NULL,
  `return_amount` longtext DEFAULT NULL,
  `qty` longtext DEFAULT NULL,
  `return_qty` longtext DEFAULT NULL,
  `doc` longtext DEFAULT NULL,
  `terms_and_conditions` longtext DEFAULT NULL,
  `internal_notes` longtext DEFAULT NULL,
  PRIMARY KEY (`salesreturn_id`)
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: salesreturn_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `salesreturn_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` longtext DEFAULT NULL,
  `padding` longtext DEFAULT NULL,
  `startFrom` longtext DEFAULT NULL,
  `emailSubject` longtext DEFAULT NULL,
  `emailBody` longtext DEFAULT NULL,
  `terms_conditions` longtext DEFAULT NULL,
  `cc` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: supplier
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `supplier` (
  `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_line` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `credit_limit` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_persons` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `supplier_docs` longtext NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`supplier_id`)
) ENGINE = MyISAM AUTO_INCREMENT = 84 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: supplier_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `supplier_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` text NOT NULL,
  `padding` text NOT NULL,
  `startFrom` text NOT NULL,
  `prefixSupplierPayment` text DEFAULT NULL,
  `paddingSupplierPayment` text DEFAULT NULL,
  `startFromSupplierPayment` text DEFAULT NULL,
  `emailSubject` text NOT NULL,
  `emailBody` text NOT NULL,
  `cc` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: supplier_wallet
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `supplier_wallet` (
  `wallet_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` text NOT NULL,
  `transactions` longtext NOT NULL,
  `available_balance` text NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  PRIMARY KEY (`wallet_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: supplierpayment
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `supplierpayment` (
  `supplierpayment_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplierpayment_name` text DEFAULT NULL,
  `supplier_id` text NOT NULL,
  `purchase_id` text DEFAULT NULL,
  `current_purchase_number` text DEFAULT NULL,
  `supplierpayment_number` text DEFAULT NULL,
  `payment_date` text DEFAULT NULL,
  `payment_amount` text DEFAULT NULL,
  `balance_amount` text NOT NULL,
  `payment_type` text DEFAULT NULL,
  `payment_bank` text DEFAULT NULL,
  `cheque_number` text DEFAULT NULL,
  `cheque_date` text DEFAULT NULL,
  `pdc_date` text NOT NULL,
  `pdc_number` text NOT NULL,
  `pdc_status` text NOT NULL,
  `reference_no` text NOT NULL,
  `add_attachment` text NOT NULL,
  `doc` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `status` text NOT NULL,
  `created_username` text NOT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  `status_history` text NOT NULL,
  PRIMARY KEY (`supplierpayment_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 294 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: supplierpayment_settings
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `supplierpayment_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` text NOT NULL,
  `padding` text NOT NULL,
  `startFrom` text NOT NULL,
  `emailSubject` text NOT NULL,
  `emailBody` text NOT NULL,
  `cc` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: transation_bank
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `transation_bank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_method` text NOT NULL,
  `transaction_info` longtext NOT NULL,
  `status` text NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: unit
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `unit` (
  `unit_id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_name` text NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` text DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  PRIMARY KEY (`unit_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 89 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: backup
# ------------------------------------------------------------

INSERT INTO
  `backup` (`id`, `name`, `file_url`, `status`, `created_at`)
VALUES
  (
    46,
    'backup-1762236436270-1762236436644',
    '/backups/backup-1762236436270-1762236436644/database.sql',
    'Success',
    '2025-11-04T06:07:16.644Z'
  );
INSERT INTO
  `backup` (`id`, `name`, `file_url`, `status`, `created_at`)
VALUES
  (
    47,
    'backup-1763188788809-1763188788981',
    '/backups/backup-1763188788809-1763188788981/database.sql',
    'Restored',
    '2025-11-15T06:39:48.981Z'
  );
INSERT INTO
  `backup` (`id`, `name`, `file_url`, `status`, `created_at`)
VALUES
  (
    48,
    'backup-1767444410671-1767444411100',
    '/backups/backup-1767444410671-1767444411100/database.sql',
    'Backup DB',
    '2026-01-03T12:46:51.101Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer
# ------------------------------------------------------------

INSERT INTO
  `customer` (
    `customer_id`,
    `customer_type`,
    `lead_source`,
    `salutation`,
    `name`,
    `email`,
    `phone`,
    `whatsapp`,
    `default_currency`,
    `website`,
    `gst_vat_number`,
    `address_line_1`,
    `address_line_2`,
    `country`,
    `state_province`,
    `city`,
    `zip_postal_code`,
    `shipping_address_line_1`,
    `shipping_country`,
    `shipping_state_province`,
    `shipping_city`,
    `shipping_zip_postal_code`,
    `status`,
    `type`,
    `industry`,
    `contact_persons`,
    `customer_docs`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    438,
    'Company',
    'Referrals',
    '',
    'Testing Company',
    'jaseer9746@gmail.com',
    '+91558854585',
    '+9685654645654',
    'AED',
    'www.test.com',
    '54435435',
    'testing address\ndfg',
    '',
    'AF',
    'BDS',
    '',
    '564565',
    'testing address\ndfg',
    'AF',
    'BDS',
    '',
    '564565',
    '[{\"id\":12,\"key\":\"active\",\"label\":\"Active\"}]',
    'Normal',
    'IT',
    '[{\"salutation\":\"Mr.\",\"full_name\":\"Test user\",\"designation\":\"Test user\",\"department\":\"Test user\",\"phone_1\":\"+971456546546\",\"phone_2\":\"+968456456456546\",\"email\":\"jaseer9746@gmail.com\",\"notes\":\"\"}]',
    '[]',
    '2026-01-03T10:43:16.656Z',
    '2026-01-03T12:22:48.189Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_ledger
# ------------------------------------------------------------

INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1423,
    '2025-11-08T12:34:00.000Z',
    'Payment',
    'PAY-01',
    '0',
    '74',
    'Payment from Wilson PLC',
    '0.00',
    '10000.00',
    '-10000.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1424,
    '2025-11-08T14:52:00.000Z',
    'Payment',
    'PAY-2',
    '0',
    '75',
    'Payment from Wilson PLC',
    '0.00',
    '13.00',
    '-10013.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1425,
    '2025-11-08T15:11:00.000Z',
    'Payment',
    'PAY-3',
    '0',
    '76',
    'Payment from Ronald Hayes',
    '0.00',
    '500.00',
    '-10513.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1426,
    '2025-08-12T00:00:00.000Z',
    'Invoice',
    'IV-1',
    '64',
    '0',
    'Invoice to Wilson PLC',
    '42.00',
    '0.00',
    '-10471.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1427,
    '2025-08-12T00:00:00.000Z',
    'Invoice',
    'IV-2',
    '65',
    '0',
    'Invoice to Wilson PLC',
    '42.00',
    '0.00',
    '-10429.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1428,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-3',
    '73',
    '0',
    'Invoice to Wilson PLC',
    '12.60',
    '0.00',
    '-10416.40',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1429,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-4',
    '74',
    '0',
    'Invoice to Wilson PLC',
    '176.40',
    '0.00',
    '-10240.00',
    '2025-08-13 23:44:27',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1430,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-5',
    '75',
    '0',
    'Invoice to Ronald Hayes',
    '12.00',
    '0.00',
    '-10228.00',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1431,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-6',
    '76',
    '0',
    'Invoice to Bailey PLC',
    '12.00',
    '0.00',
    '-10216.00',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1432,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-7',
    '77',
    '0',
    'Invoice to Chambers Inc',
    '1.25',
    '0.00',
    '-10214.75',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1433,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-8',
    '78',
    '0',
    'Invoice to Test user',
    '1.31',
    '0.00',
    '-10213.44',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1434,
    '2025-08-13T00:00:00.000Z',
    'Invoice',
    'IV-9',
    '79',
    '0',
    'Invoice to Ronald Hayes',
    '630.00',
    '0.00',
    '-9583.44',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1435,
    '2025-08-14T00:00:00.000Z',
    'Invoice',
    'IV-10',
    '80',
    '0',
    'Invoice to Wilson PLC',
    '84.00',
    '0.00',
    '-9499.44',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1436,
    '2025-08-14T00:00:00.000Z',
    'Invoice',
    'IV-11',
    '81',
    '0',
    'Invoice to Wilson PLC',
    '1.31',
    '0.00',
    '-9498.13',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );
INSERT INTO
  `customer_ledger` (
    `id`,
    `entry_date`,
    `entry_type`,
    `reference_no`,
    `invoice_id`,
    `payment_id`,
    `description`,
    `debit`,
    `credit`,
    `balance`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1437,
    '2025-08-14T00:00:00.000Z',
    'Invoice',
    'IV-12',
    '82',
    '0',
    'Invoice to Wilson PLC',
    '12.60',
    '0.00',
    '-9485.53',
    '2025-08-13 23:44:28',
    '2025-11-28 02:41:20'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customerpayment
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customerwallet
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: deliverynote
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: deliverynote_settings
# ------------------------------------------------------------

INSERT INTO
  `deliverynote_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `terms_conditions`
  )
VALUES
  (
    3,
    'DLV',
    '4',
    '11',
    '<p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span lang=\"EN-US\" style=\"font-size: 12pt; line-height: 18.4px;\">Kindly check all product/services are delivered as specified in the respective LPO/Quote<o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-size: 12pt; line-height: 18.4px;\">If there is any dispute or mismatch on the delivery, please reach out to us at info@uptunist.com.</span></p>'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: expense
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: expense_settings
# ------------------------------------------------------------

INSERT INTO
  `expense_settings` (
    `expense_id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `type_of_expenses`,
    `sub_type_of_expenses`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    5,
    'EXP',
    1,
    1,
    '[{\"value\":\"vehicle\",\"title\":\"vehicle\",\"children\":[{\"value\":\"petrol\",\"title\":\"petrol\",\"children\":[]},{\"value\":\"fssfgjk\",\"title\":\"fssfgjk\",\"children\":[]},{\"value\":\"hjh\",\"title\":\"hjh\",\"children\":[]},{\"value\":\"rdfgh\",\"title\":\"rdfgh\",\"children\":[]}]},{\"value\":\"cvxvchsvhgwdh\",\"title\":\"cvxvchsvhgwdh\",\"children\":[{\"value\":\"tdgfgfgh\",\"title\":\"tdgfgfgh\",\"children\":[]}]},{\"value\":\"main\",\"title\":\"main\",\"children\":[]}]',
    '',
    '2025-09-08 00:32:54',
    '2025-11-05 22:58:42'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: inventory
# ------------------------------------------------------------

INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    145,
    'Product',
    'test1',
    'adasd dsfdsfdsfdf',
    'test1',
    '[{\"AED\":3434,\"OMR\":223,\"USD\":44}]',
    '[{\"AED\":33,\"OMR\":112,\"USD\":221}]',
    '2025-11-24T14:06:54.543Z',
    '2026-01-03T10:07:40.764Z',
    NULL,
    '548',
    '12345',
    '[{\"id\":81,\"name\":\"Test Supplier\",\"price\":5555}]',
    '[\"111\"]',
    '{\"inventory_id\":145,\"deliverynote_number\":null,\"usedSerial\":[\"111\"]}'
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    144,
    'Service',
    'gggggg',
    'ggggg',
    'LS',
    '[{\"AED\":6000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '',
    '1',
    'ggggg',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    130,
    'Service',
    'CRM Setup',
    'Customer management',
    'LS',
    '[{\"AED\":2500,\"AFN\":5000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'CRM001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    129,
    'Service',
    'Mobile App Maintenance',
    'Monthly updates',
    'LS',
    '[{\"AED\":1000,\"AFN\":2000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'APP002',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    128,
    'Product',
    'HDMI Cable 2m',
    'Full HD compatible',
    'LS',
    '[{\"AED\":30,\"AFN\":60}]',
    '[{\"AED\":15,\"AFN\":30}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'PRD012',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    127,
    'Product',
    'Ethernet Cable 10m',
    'Cat6 high speed',
    'LS',
    '[{\"AED\":40,\"AFN\":80}]',
    '[{\"AED\":20,\"AFN\":40}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '11',
    'PRD011',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    126,
    'Service',
    'Database Optimization',
    'Query tuning',
    'LS',
    '[{\"AED\":1000,\"AFN\":2000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'DB001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    124,
    'Service',
    'Cloud Migration',
    'Move site to cloud',
    'LS',
    '[{\"AED\":1800,\"AFN\":3600}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'CLD001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    125,
    'Service',
    'UI/UX Consultation',
    '1-hour session',
    'LS',
    '[{\"AED\":300,\"AFN\":600}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'UIX001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    123,
    'Product',
    'Printer Ink Cartridge',
    'Compatible models',
    'LS',
    '[{\"AED\":80,\"AFN\":160}]',
    '[{\"AED\":50,\"AFN\":100}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'PRD010',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    122,
    'Service',
    'Payment Gateway Setup',
    'Secure payment connect',
    'LS',
    '[{\"AED\":2100,\"AFN\":4200}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'PAY001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    121,
    'Service',
    'API Integration',
    'Connect with 3rd party',
    'LS',
    '[{\"AED\":2000,\"AFN\":4000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'API001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    120,
    'Product',
    'Notebook A5',
    'Spiral bound',
    'LS',
    '[{\"AED\":20,\"AFN\":40}]',
    '[{\"AED\":10,\"AFN\":20}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:08:55.480Z',
    '0',
    '11',
    'PRD009',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    112,
    'Service',
    'Website Speed Optimization',
    'Improve page load time',
    'LS',
    '[{\"AED\":900,\"AFN\":1800}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'SPD001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    111,
    'Service',
    'E-Commerce Setup',
    'WooCommerce configuration',
    'LS',
    '[{\"AED\":3500,\"AFN\":7000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'EC001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    119,
    'Service',
    'Custom Web Form',
    'Form with backend',
    'LS',
    '[{\"AED\":900,\"AFN\":1800}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '11',
    'FORM01',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    118,
    'Service',
    'Brochure Design',
    '4-page digital layout',
    'LS',
    '[{\"AED\":500,\"AFN\":1000}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '9',
    'BRD001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    117,
    'Product',
    'Office Pen Pack (10pcs)',
    'Black ink',
    'LS',
    '[{\"AED\":15,\"AFN\":30}]',
    '[{\"AED\":8,\"AFN\":16}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '69',
    'PRD008',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    116,
    'Service',
    'Analytics Integration',
    'Google Analytics setup',
    'LS',
    '[{\"AED\":400,\"AFN\":800}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'ANA001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    115,
    'Product',
    'Power Bank 10000mAh',
    'Dual USB output',
    'LS',
    '[{\"AED\":120,\"AFN\":240}]',
    '[{\"AED\":70,\"AFN\":140}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '1011',
    'PRD007',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    114,
    'Service',
    'SSL Certificate Setup',
    'Secure site via HTTPS',
    'LS',
    '[{\"AED\":250,\"AFN\":500}]',
    '',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '10',
    'SSL001',
    '',
    '',
    ''
  );
INSERT INTO
  `inventory` (
    `inventory_id`,
    `inventory_type`,
    `inventory_name`,
    `description`,
    `unit`,
    `price`,
    `buying_price`,
    `created_at`,
    `updated_at`,
    `unit_id`,
    `stock`,
    `sku`,
    `supplier_prices`,
    `serialization`,
    `used_serialization`
  )
VALUES
  (
    113,
    'Product',
    'Keyboard Wireless',
    'Compact Bluetooth',
    'LS',
    '[{\"AED\":90,\"AFN\":180}]',
    '[{\"AED\":50,\"AFN\":100}]',
    '2025-11-24T14:06:54.543Z',
    '2025-11-24T14:06:54.543Z',
    '0',
    '123',
    'PRD006',
    '',
    '',
    ''
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice_settings
# ------------------------------------------------------------

INSERT INTO
  `invoice_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `expiryDays`,
    `emailSubject`,
    `emailBody`,
    `cc`,
    `terms_conditions`,
    `whatsappActive`,
    `whatsappAttachments`,
    `whatsappMessage`
  )
VALUES
  (
    1,
    'INV',
    4,
    100,
    5,
    'Your Invoice from {{company}}',
    '<div bis_skin_checked=\"1\">Dear {{customer_name}},</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Please find attached the proforma invoice for your upcoming order.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Proforma Invoice Number:&nbsp;<span style=\"font-weight: bolder;\">{{invoice_number}}</span></div><div bis_skin_checked=\"1\">Date Issued:<span style=\"font-weight: bolder;\">&nbsp;</span><span style=\"font-weight: bolder;\">{{invoice_date}}</span></div><div bis_skin_checked=\"1\">Total Amount:&nbsp;<span style=\"font-weight: bolder;\">{{total_invoice_value}}</span></div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">This proforma invoice outlines the products/services and costs as discussed. It is not a final tax invoice but serves as a formal offer.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">To proceed with the order, kindly confirm by replying to this email or making the payment as per the instructions in the document.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">If you have any questions or need modifications, feel free to reply to this email. We look forward to working with you.&nbsp;</div>',
    '',
    '<p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-size: 12pt; line-height: 18.4px;\">Kindly ensure that all payments are made via Bank Transfer to the designated Bank Account.<o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-size: 12pt; line-height: 18.4px;\">Once payment has been made for Services Invoices, shall not be refunded.<o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-size: 12pt; line-height: 18.4px;\">If there is any dispute on this invoice, please reach out to us at info@uptunist.com.<o:p></o:p></span></p><p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-size: 12pt; line-height: 18.4px;\">All currencies mentioned in this invoice are in AED</span><span lang=\"EN-US\" style=\"font-size: 12pt; line-height: 18.4px;\"> Excluding VAT</span><span style=\"font-size: 12pt; line-height: 18.4px;\"> (Unit Arab Emirates Dirhams)<o:p></o:p></span></p>',
    'Active',
    'Active',
    'Here is your invoice'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: lead
# ------------------------------------------------------------

INSERT INTO
  `lead` (
    `lead_id`,
    `lead_type`,
    `customer_type`,
    `lead_source`,
    `name`,
    `email`,
    `phone`,
    `whatsapp`,
    `website`,
    `contact_persons`,
    `converted_to_customer`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    121,
    'Normal',
    'Company',
    'Referrals',
    'sdfdsfdsf',
    'dsfdsf@sdasd.com',
    '+971345345345',
    '+971345345435',
    'fsdfsdf.com',
    '[{\"salutation\":\"Mr.\",\"full_name\":\"gfdgdfg\",\"designation\":\"dfgdfg\",\"department\":\"dfgdfg\",\"phone_1\":\"+97134534\",\"phone_2\":\"+971435345345\",\"email\":\"dfgdfg@asdfas.com\",\"notes\":\"\"}]',
    '0',
    '2026-01-03T10:46:20.057Z',
    '2026-01-03T10:46:20.057Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: payment_settings
# ------------------------------------------------------------

INSERT INTO
  `payment_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `expiryDays`,
    `emailSubject`,
    `emailBody`,
    `cc`,
    `whatsappActive`,
    `whatsappAttachments`,
    `whatsappMessage`,
    `paymentPrefix`,
    `paymentPadding`,
    `paymentStartFrom`,
    `advancePaymentEmailSubject`,
    `advancePaymentEmailBody`
  )
VALUES
  (
    4,
    'PAY',
    '4',
    '100',
    3,
    'Your Payment Receipt from {{company}}',
    'Hello {{customer_name}},<div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Thank you for your payment. This email is to confirm that we have received your payment for the following invoice:&nbsp;</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Invoice Number:&nbsp;<b>{{current_invoice_number}}</b></div><div bis_skin_checked=\"1\">Date Paid: <b>{{payment_date}}</b></div><div bis_skin_checked=\"1\">Amount Received: <b>{{payment_amount}}</b></div><div bis_skin_checked=\"1\">Payment Method:&nbsp;<b>{{payment_type}}</b></div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">&nbsp;A PDF copy of your payment receipt is attached for your records.\n\nIf you have any questions or need further assistance, feel free to contact us.\n\nThank you for your business!&nbsp;</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">{{customer_id}}{{status}}</div>',
    '',
    'Active',
    'Active',
    'here is your payment reciept',
    'SUP-PAY',
    '4',
    '100',
    NULL,
    NULL
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: proforma
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: proforma_settings
# ------------------------------------------------------------

INSERT INTO
  `proforma_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `expiryDays`,
    `proforma_terms_conditions`,
    `emailSubject`,
    `emailBody`,
    `cc`,
    `autoAttachPdf`,
    `whatsappActive`,
    `whatsappAttachments`,
    `whatsappMessage`
  )
VALUES
  (
    1,
    'PI',
    '4',
    '100',
    5,
    '<p style=\"margin-bottom: 8px; border-style: initial !important;\"><br></p>',
    'Your Proforma Invoice from {{company}}',
    '<div bis_skin_checked=\"1\">Dear {{customer_name}},</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Please find attached the proforma invoice for your upcoming order.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Proforma Invoice Number:&nbsp;<b>{{proforma_number}}</b></div><div bis_skin_checked=\"1\">Date Issued:<b>&nbsp;{{proforma_date}}</b></div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">This proforma invoice outlines the products/services and costs as discussed. It is not a final tax invoice but serves as a formal offer.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">To proceed with the order, kindly confirm by replying to this email or making the payment as per the instructions in the document.</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">If you have any questions or need modifications, feel free to reply to this email. We look forward to working with you.&nbsp;</div><div bis_skin_checked=\"1\"></div>',
    '',
    1,
    'Active',
    'Active',
    'Kindly Find the proforma invoice'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: purchase
# ------------------------------------------------------------

INSERT INTO
  `purchase` (
    `purchase_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_ref_number`,
    `purchase_number`,
    `invoice_number`,
    `purchase_date`,
    `payment_terms`,
    `line_items`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `lpo`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    242,
    'Test Supplier',
    '81',
    '[\"puorder-2\"]',
    'PU-3',
    '5',
    '2025-11-29T00:00:00.000Z',
    '<br>',
    '[{\"key\":1764396360171,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":50,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"1732.50\",\"serialization\":true},{\"key\":1764396362696,\"type\":\"Service\",\"item_id\":144,\"item_name\":\"gggggg\",\"item_description\":\"ggggg\",\"qty\":25,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"ggggg\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396363304,\"type\":\"Service\",\"item_id\":130,\"item_name\":\"CRM Setup\",\"item_description\":\"Customer management\",\"qty\":50,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"CRM001\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396365240,\"type\":\"Service\",\"item_id\":129,\"item_name\":\"Mobile App Maintenance\",\"item_description\":\"Monthly updates\",\"qty\":25,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"APP002\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false}]',
    '1732.5',
    '1232.5',
    'AED',
    '\"yes\"',
    '[]',
    'doc/purchase/purchase-pu-3--29-11-2025-11-36-36-AM.pdf',
    'Partially Paid',
    '[]',
    'SUP-PAY-0100',
    'saleem',
    '2025-11-29T06:06:38.062Z',
    '2025-12-10T10:42:45.048Z'
  );
INSERT INTO
  `purchase` (
    `purchase_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_ref_number`,
    `purchase_number`,
    `invoice_number`,
    `purchase_date`,
    `payment_terms`,
    `line_items`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `lpo`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    240,
    'Test Supplier',
    '81',
    '[\"puorder-1\"]',
    'PU-1',
    '1',
    '2025-11-29T00:00:00.000Z',
    '',
    '[{\"key\":1764394476482,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":50,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"1732.50\",\"serialization\":true}]',
    '1732.5',
    '1732.5',
    'AED',
    '\"yes\"',
    '[]',
    'doc/purchase/purchase-pu-1--29-11-2025-11-35-12-AM.pdf',
    'Unpaid',
    '[]',
    '\"\"',
    'saleem',
    '2025-11-29T06:05:14.694Z',
    '2025-11-29T06:05:14.694Z'
  );
INSERT INTO
  `purchase` (
    `purchase_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_ref_number`,
    `purchase_number`,
    `invoice_number`,
    `purchase_date`,
    `payment_terms`,
    `line_items`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `lpo`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    241,
    'Test Supplier',
    '81',
    '[\"puorder-1\"]',
    'PU-2',
    '1',
    '2025-11-29T00:00:00.000Z',
    '<br>',
    '[{\"key\":1764394476482,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":50,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"1732.50\",\"serialization\":true}]',
    '1732.5',
    '1732.5',
    'AED',
    '\"yes\"',
    '[]',
    'doc/purchase/purchase-pu-2--29-11-2025-11-35-46-AM.pdf',
    'Unpaid',
    '[]',
    '\"\"',
    'saleem',
    '2025-11-29T06:05:49.216Z',
    '2025-11-29T06:05:49.216Z'
  );
INSERT INTO
  `purchase` (
    `purchase_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_ref_number`,
    `purchase_number`,
    `invoice_number`,
    `purchase_date`,
    `payment_terms`,
    `line_items`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `lpo`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    243,
    'Test Supplier',
    '81',
    '[\"puorder-2\"]',
    'PU-4',
    '5',
    '2025-11-29T00:00:00.000Z',
    '<br>',
    '[{\"key\":1764396360171,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":50,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"1732.50\",\"serialization\":true},{\"key\":1764396362696,\"type\":\"Service\",\"item_id\":144,\"item_name\":\"gggggg\",\"item_description\":\"ggggg\",\"qty\":15,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"ggggg\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396363304,\"type\":\"Service\",\"item_id\":130,\"item_name\":\"CRM Setup\",\"item_description\":\"Customer management\",\"qty\":50,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"CRM001\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396365240,\"type\":\"Service\",\"item_id\":129,\"item_name\":\"Mobile App Maintenance\",\"item_description\":\"Monthly updates\",\"qty\":5,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"APP002\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false}]',
    '1732.5',
    '1732.5',
    'AED',
    '\"yes\"',
    '[]',
    'doc/purchase/purchase-pu-4--29-11-2025-11-36-51-AM.pdf',
    'Unpaid',
    '[]',
    '\"\"',
    'saleem',
    '2025-11-29T06:06:53.528Z',
    '2025-11-29T06:06:53.528Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: purchase_settings
# ------------------------------------------------------------

INSERT INTO
  `purchase_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `terms_conditions`,
    `prefixSupplier`,
    `paddingSupplier`,
    `startFromSupplier`,
    `emailSubject`,
    `emailBody`,
    `cc`,
    `po_prefix`,
    `po_padding`,
    `po_startFrom`,
    `po_emailSubject`,
    `po_emailBody`,
    `po_emailcc`,
    `po_terms_conditions`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1,
    'PU',
    '1',
    '1',
    '<br>',
    'SUPPLIER PAYMENT',
    '1',
    '1',
    'Payment Receipt for Invoice {{number}}',
    'Hello {{customer_name}},\n\nThank you for your payment. This email is to confirm that we have received your payment for the following invoice:\n\nInvoice Number: {{number}}\nDate Paid: {{payment_date}}\nAmount Received: {{amount_paid}}\nPayment Method: {{payment_method}}\n\nA PDF copy of your payment receipt is attached for your records.\n\nIf you have any questions or need further assistance, feel free to contact us.\n\nThank you for your business!\n\nBest regards,\n{{company_name}}\n{{company_email}} | {{company_phone}}',
    'assad@asdas.com',
    'puorder',
    '1',
    '1',
    'fsf',
    'sdfdsfdsf',
    'dsf@asddd.com',
    'sdfdsf',
    '2025-09-08 05:39:18',
    '2025-11-24 20:09:08'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: purchaseorder
# ------------------------------------------------------------

INSERT INTO
  `purchaseorder` (
    `purchaseorder_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_number`,
    `purchaseorder_date`,
    `quote_reference`,
    `ship_via`,
    `fob`,
    `po_terms_conditions`,
    `po_payment_terms`,
    `line_items`,
    `order_stock`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `closed`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    40,
    'Test Supplier',
    '81',
    'puorder-1',
    '2025-11-29T00:00:00.000Z',
    '',
    '',
    '',
    'sdfdsf',
    '',
    '[{\"key\":1764394476482,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":100,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"3465.00\",\"serialization\":true}]',
    '[{\"item_id\":145,\"purchased_qty\":100}]',
    '3465',
    '3465',
    'AED',
    '\"yes\"',
    'doc/purchaseorder/purchaseorder-puorder-1--29-11-2025-11-04-39-AM.pdf',
    'Purchased',
    '[]',
    'PU-1, PU-2',
    'Closed',
    'saleem',
    '2025-11-29T05:34:43.843Z',
    '2025-11-29T06:05:50.119Z'
  );
INSERT INTO
  `purchaseorder` (
    `purchaseorder_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_number`,
    `purchaseorder_date`,
    `quote_reference`,
    `ship_via`,
    `fob`,
    `po_terms_conditions`,
    `po_payment_terms`,
    `line_items`,
    `order_stock`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `closed`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    41,
    'Test Supplier',
    '81',
    'puorder-2',
    '2025-11-29T00:00:00.000Z',
    '',
    '',
    '',
    'sdfdsf',
    '',
    '[{\"key\":1764396360171,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":100,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"3465.00\",\"serialization\":true},{\"key\":1764396362696,\"type\":\"Service\",\"item_id\":144,\"item_name\":\"gggggg\",\"item_description\":\"ggggg\",\"qty\":50,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"ggggg\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396363304,\"type\":\"Service\",\"item_id\":130,\"item_name\":\"CRM Setup\",\"item_description\":\"Customer management\",\"qty\":100,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"CRM001\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false},{\"key\":1764396365240,\"type\":\"Service\",\"item_id\":129,\"item_name\":\"Mobile App Maintenance\",\"item_description\":\"Monthly updates\",\"qty\":50,\"price\":\"\",\"buying_price\":\"\",\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"APP002\",\"unit\":\"LS\",\"total\":\"0.00\",\"serialization\":false}]',
    '[{\"item_id\":145,\"purchased_qty\":100},{\"item_id\":144,\"purchased_qty\":40},{\"item_id\":130,\"purchased_qty\":100},{\"item_id\":129,\"purchased_qty\":30}]',
    '3465',
    '3465',
    'AED',
    '\"yes\"',
    'doc/purchaseorder/purchaseorder-puorder-2--29-11-2025-11-36-13-AM.pdf',
    'Partially Purchased',
    '[]',
    'PU-3, PU-4',
    '',
    'saleem',
    '2025-11-29T06:06:17.594Z',
    '2025-11-29T06:06:54.449Z'
  );
INSERT INTO
  `purchaseorder` (
    `purchaseorder_id`,
    `supplier_name`,
    `supplier_id`,
    `purchaseorder_number`,
    `purchaseorder_date`,
    `quote_reference`,
    `ship_via`,
    `fob`,
    `po_terms_conditions`,
    `po_payment_terms`,
    `line_items`,
    `order_stock`,
    `total_value`,
    `balance_amount`,
    `currency`,
    `tax`,
    `doc`,
    `status`,
    `returns`,
    `locked`,
    `closed`,
    `created_username`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    42,
    'Test Supplier',
    '81',
    'puorder-3',
    '2025-11-30T00:00:00.000Z',
    '',
    '',
    '',
    'sdfdsf',
    '',
    '[{\"key\":1764467229350,\"type\":\"Product\",\"item_id\":145,\"item_name\":\"test1\",\"item_description\":\"adasd dsfdsfdsfdf\",\"qty\":1,\"price\":33,\"buying_price\":33,\"discountPercentage\":\"\",\"discountAmount\":\"\",\"sku\":\"12345\",\"unit\":\"test1\",\"total\":\"34.65\",\"serialization\":true}]',
    '[]',
    '34.65',
    '34.65',
    'AED',
    '\"yes\"',
    'doc/purchaseorder/purchaseorder-puorder-3--30-11-2025-07-17-09-AM.pdf',
    'Saved',
    '[]',
    '',
    '',
    'saleem',
    '2025-11-30T01:47:16.517Z',
    '2025-11-30T01:47:16.517Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: quote
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: quote_settings
# ------------------------------------------------------------

INSERT INTO
  `quote_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `terms_conditions`,
    `expiryDays`,
    `emailSubject`,
    `emailBody`,
    `cc`,
    `winning_probability`,
    `whatsappActive`,
    `whatsappAttachments`,
    `whatsappMessage`
  )
VALUES
  (
    1,
    'QT',
    '4',
    '100',
    '<div bis_skin_checked=\"1\"><p class=\"MsoNormal\" style=\"margin: 0cm; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0);\"><span style=\"font-family: Calibri, sans-serif; font-size: 11pt; text-indent: -108pt;\">Currency and TAX</span><span style=\"font-family: Calibri, sans-serif; font-size: 11pt; text-indent: -108pt;\">: All amounts mentioned in the proposal are in AED exclusive of VAT.</span></p><p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0cm 108pt; line-height: 16.8667px; font-size: 11pt; font-family: Arial, sans-serif; color: rgb(0, 0, 0); text-indent: -108pt;\"><span lang=\"EN\" style=\"font-family: Calibri, sans-serif;\">Payment Terms: One-time payments: 70% Advance - 30% on completion. Recurring payments: Quarterly in Advance. &nbsp;&nbsp;<o:p></o:p></span></p></div>',
    14,
    'Here’s your quote from {{company_name}}',
    'Hi&nbsp;{{customer_name}}<div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Thank you for your interest in our services. Please find below your quote details:&nbsp;</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">Quote Number: <b>{{quote_number}}&nbsp;</b></div><div bis_skin_checked=\"1\">Quote Date: <b>{{quote_date}}&nbsp;</b></div><div bis_skin_checked=\"1\">Total Amount: <b>{{total_quote_value}}&nbsp;</b></div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">You can view and download your full quote here: {{quote_link}}&nbsp;</div><div bis_skin_checked=\"1\"><br></div><div bis_skin_checked=\"1\">If you have any questions or need modifications, feel free to reply to this email.\n\nWe look forward to working with you.&nbsp;<br><br></div><div bis_skin_checked=\"1\"><br></div>',
    '',
    '[\"10\",\"30\",\"50\",\"70\",\"90\",\"100\"]',
    '0',
    'Active',
    'As discussed, please find the quotation details attached ?.\nLet me know if you have any questions or need any changes ?.\n\nLooking forward to your confirmation ✅.\n\nBest regards,\nTest admin\nUpturnist'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: recurringinvoice
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: role
# ------------------------------------------------------------

INSERT INTO
  `role` (
    `role_id`,
    `role_name`,
    `privileges`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    29,
    'Owner',
    '{\"dashboard\":{\"view\":true,\"modify\":true},\"lead\":{\"view\":true,\"modify\":true},\"customer\":{\"view\":true,\"modify\":true},\"purchase\":{\"view\":true,\"modify\":true},\"supplier\":{\"view\":true,\"modify\":true},\"purchase-settings\":{\"view\":true,\"modify\":true},\"inventory\":{\"view\":true,\"modify\":true},\"unit\":{\"view\":true,\"modify\":true},\"quote\":{\"view\":true,\"modify\":true},\"quote-settings\":{\"view\":true,\"modify\":true},\"proforma\":{\"view\":true,\"modify\":true},\"proforma-settings\":{\"view\":true,\"modify\":true},\"invoice\":{\"view\":true,\"modify\":true},\"invoice-settings\":{\"view\":true,\"modify\":true},\"deliverynote\":{\"view\":true,\"modify\":true},\"deliverynote-settings\":{\"view\":true,\"modify\":true},\"payment\":{\"view\":true,\"modify\":true},\"undefined\":{\"view\":true,\"modify\":true},\"supplierpayment\":{\"view\":true,\"modify\":true},\"payment-settings\":{\"view\":true,\"modify\":true},\"expense\":{\"view\":true,\"modify\":true},\"expense-settings\":{\"view\":true,\"modify\":true},\"reports\":{\"view\":true,\"modify\":true},\"Sales\":{\"view\":true,\"modify\":true},\"Customer\":{\"view\":true,\"modify\":true},\"Payment\":{\"view\":true,\"modify\":true},\"user\":{\"view\":true,\"modify\":true},\"role\":{\"view\":true,\"modify\":true},\"settings\":{\"view\":true,\"modify\":true},\"general-settings\":{\"view\":true,\"modify\":true},\"email-settings\":{\"view\":true,\"modify\":true},\"whatsapp-settings\":{\"view\":true,\"modify\":true},\"backup & restore\":{\"view\":true,\"modify\":true}}',
    'Saved',
    '2025-10-29T05:30:43.053Z',
    '2025-11-15T06:08:40.033Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: salesreturn
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: salesreturn_settings
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: supplier
# ------------------------------------------------------------

INSERT INTO
  `supplier` (
    `supplier_id`,
    `supplier_type`,
    `name`,
    `email`,
    `contact_number`,
    `address_line`,
    `website`,
    `currency`,
    `payment_terms`,
    `tax_number`,
    `credit_limit`,
    `contact_persons`,
    `supplier_docs`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    81,
    'Business',
    'Test Supplier',
    'jaseer9746@gmail.com',
    '+91',
    'Test house',
    'upturnist.com',
    'AED',
    'test terms and conditions',
    'test',
    '333',
    '[{\"salutation\":\"Mr.\",\"full_name\":\"Test\",\"designation\":\"Test\",\"department\":\"Test\",\"phone_1\":\"+9714444\",\"phone_2\":\"+968\",\"email\":\"jaseer9746@gmail.com\",\"notes\":\"\"}]',
    '',
    '2025-11-24T14:06:00.853Z',
    '2025-11-24T14:06:00.853Z'
  );
INSERT INTO
  `supplier` (
    `supplier_id`,
    `supplier_type`,
    `name`,
    `email`,
    `contact_number`,
    `address_line`,
    `website`,
    `currency`,
    `payment_terms`,
    `tax_number`,
    `credit_limit`,
    `contact_persons`,
    `supplier_docs`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    82,
    'Business',
    'asdasd',
    'asdasd@assasda.com',
    '+971345345345',
    'dfgdfgd',
    'uptufgrnist.com',
    'AED',
    'dfgdfg',
    '435345',
    '445454',
    '[{\"salutation\":\"Mr.\",\"full_name\":\"dfgdfgfdg\",\"designation\":\"dfgdfgdfg\",\"department\":\"dfgdfgdf\",\"phone_1\":\"+97145345\",\"phone_2\":\"+971345345\",\"email\":\"gfgdfg@asdad.com\",\"notes\":\"\"}]',
    '[]',
    '2025-11-26T12:29:45.758Z',
    '2025-11-26T12:29:45.758Z'
  );
INSERT INTO
  `supplier` (
    `supplier_id`,
    `supplier_type`,
    `name`,
    `email`,
    `contact_number`,
    `address_line`,
    `website`,
    `currency`,
    `payment_terms`,
    `tax_number`,
    `credit_limit`,
    `contact_persons`,
    `supplier_docs`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    83,
    'Individual',
    'sdfsdfdsf',
    'jaseersf9746@gmail.com',
    '+96823423432',
    'testing address',
    'sdsfdsf.com',
    'AUD',
    '<br>',
    'test',
    '45345345',
    '[{\"salutation\":\"Mr.\",\"full_name\":\"gdfgdfgdf\",\"designation\":\"fgdfg\",\"department\":\"dfgdf\",\"phone_1\":\"+971345435\",\"phone_2\":\"+97134534534\",\"email\":\"gdfgdfg@dasdc.com\",\"notes\":\"\"}]',
    '[]',
    '2025-11-26T12:30:20.810Z',
    '2025-11-26T14:01:34.927Z'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: supplier_settings
# ------------------------------------------------------------

INSERT INTO
  `supplier_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `prefixSupplierPayment`,
    `paddingSupplierPayment`,
    `startFromSupplierPayment`,
    `emailSubject`,
    `emailBody`,
    `cc`
  )
VALUES
  (
    1,
    'SUP',
    '4',
    '1',
    'SUPYYYYYY',
    '1',
    '1',
    'Payment Receipt for Invoice {{number}}',
    'Hello {{customer_name}},\n\nThank you for your payment. This email is to confirm that we have received your payment for the following invoice:\n\nInvoice Number: {{number}}\nDate Paid: {{payment_date}}\nAmount Received: {{amount_paid}}\nPayment Method: {{payment_method}}\n\nA PDF copy of your payment receipt is attached for your records.\n\nIf you have any questions or need further assistance, feel free to contact us.\n\nThank you for your business!\n\nBest regards,\n{{company_name}}\n{{company_email}} | {{company_phone}}',
    'jaseerali2012@gmail.com'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: supplier_wallet
# ------------------------------------------------------------


# ------------------------------------------------------------
# DATA DUMP FOR TABLE: supplierpayment
# ------------------------------------------------------------

INSERT INTO
  `supplierpayment` (
    `supplierpayment_id`,
    `supplierpayment_name`,
    `supplier_id`,
    `purchase_id`,
    `current_purchase_number`,
    `supplierpayment_number`,
    `payment_date`,
    `payment_amount`,
    `balance_amount`,
    `payment_type`,
    `payment_bank`,
    `cheque_number`,
    `cheque_date`,
    `pdc_date`,
    `pdc_number`,
    `pdc_status`,
    `reference_no`,
    `add_attachment`,
    `doc`,
    `notes`,
    `status`,
    `created_username`,
    `created_at`,
    `updated_at`,
    `status_history`
  )
VALUES
  (
    293,
    'Test Supplier',
    '81',
    '[{\"key\":242,\"purchase_id\":242,\"purchase_date\":\"2025-11-29T00:00:00.000Z\",\"purchase_number\":\"PU-3\",\"purchasePaymentNumber\":\"\",\"supplerPaymentNumber\":\"SUP-PAY-0100\",\"purchaseAmount\":1732.5,\"initialBalanceAmount\":1732.5,\"payAmount\":500,\"balanceAmount\":1232.5,\"status\":\"Partially Paid\",\"locked\":{},\"purchaseorder_ref_number\":[]},{\"key\":240,\"purchase_id\":240,\"purchase_date\":\"2025-11-29T00:00:00.000Z\",\"purchase_number\":\"PU-1\",\"purchasePaymentNumber\":\"\",\"supplerPaymentNumber\":\"SUP-PAY-0100\",\"purchaseAmount\":1732.5,\"initialBalanceAmount\":1732.5,\"payAmount\":0,\"balanceAmount\":1732.5,\"status\":\"Unpaid\",\"locked\":\"\",\"purchaseorder_ref_number\":[\"puorder-1\"]},{\"key\":241,\"purchase_id\":241,\"purchase_date\":\"2025-11-29T00:00:00.000Z\",\"purchase_number\":\"PU-2\",\"purchasePaymentNumber\":\"\",\"supplerPaymentNumber\":\"SUP-PAY-0100\",\"purchaseAmount\":1732.5,\"initialBalanceAmount\":1732.5,\"payAmount\":0,\"balanceAmount\":1732.5,\"status\":\"Unpaid\",\"locked\":\"\",\"purchaseorder_ref_number\":[\"puorder-1\"]},{\"key\":243,\"purchase_id\":243,\"purchase_date\":\"2025-11-29T00:00:00.000Z\",\"purchase_number\":\"PU-4\",\"purchasePaymentNumber\":\"\",\"supplerPaymentNumber\":\"SUP-PAY-0100\",\"purchaseAmount\":1732.5,\"initialBalanceAmount\":1732.5,\"payAmount\":0,\"balanceAmount\":1732.5,\"status\":\"Unpaid\",\"locked\":\"\",\"purchaseorder_ref_number\":[\"puorder-2\"]}]',
    '',
    'SUP-PAY-0100',
    '2025-12-10T00:00:00.000Z',
    'AED 500.00',
    'AED 6430.00',
    'Pdc',
    'Second Bank',
    '',
    '2025-12-10T00:00:00.000Z',
    '2025-12-18T00:00:00.000Z',
    '123456',
    'Clearance',
    '435435',
    'true',
    'doc/supplierpayment/supplierpayment-sup-pay-0100--12-10-2025-12-00-00-AM.pdf',
    '',
    'Partially Paid',
    'saleem',
    '2025-12-10T10:42:44.742Z',
    '2025-12-10T10:42:51.450Z',
    '[]'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: supplierpayment_settings
# ------------------------------------------------------------

INSERT INTO
  `supplierpayment_settings` (
    `id`,
    `prefix`,
    `padding`,
    `startFrom`,
    `emailSubject`,
    `emailBody`,
    `cc`
  )
VALUES
  (
    1,
    'SUPLL',
    '1',
    '1',
    'Payment Receipt for Invoice {{number}}',
    'Hello {{customer_name}},\n\nThank you for your payment. This email is to confirm that we have received your payment for the following invoice:\n\nInvoice Number: {{number}}\nDate Paid: {{payment_date}}\nAmount Received: {{amount_paid}}\nPayment Method: {{payment_method}}\n\nA PDF copy of your payment receipt is attached for your records.\n\nIf you have any questions or need further assistance, feel free to contact us.\n\nThank you for your business!\n\nBest regards,\n{{company_name}}\n{{company_email}} | {{company_phone}}',
    'jaseerali2012@gmail.com'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: transation_bank
# ------------------------------------------------------------

INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    1,
    'Unknown',
    '{\"proforma_id\":\"TXN-127581\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03\",\"payment_number\":null,\"reference_no\":null,\"cheque_number\":null,\"cheque_date\":\"2026-01-03\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"\",\"amount\":3000}',
    'Credit',
    '2026-01-03T10:08:28.788Z',
    '2026-01-03T10:08:28.788Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    2,
    '-',
    '{\"proforma_id\":\"[{\\\"key\\\":426,\\\"invoice_id\\\":426,\\\"invoice_number\\\":\\\"INV-0101\\\",\\\"delivery_note_number\\\":\\\"DLV-0013\\\",\\\"invoiceAmount\\\":3605.7,\\\"invoiceDate\\\":\\\"2026-01-03T00:00:00.000Z\\\",\\\"initialBalanceAmount\\\":3605.7,\\\"balanceAmount\\\":3605.7,\\\"payAmount\\\":0,\\\"status\\\":\\\"Unpaid\\\"},{\\\"key\\\":425,\\\"invoice_id\\\":425,\\\"invoice_number\\\":\\\"INV-0100\\\",\\\"delivery_note_number\\\":\\\"DLV-0011, DLV-0012\\\",\\\"invoiceAmount\\\":21634.2,\\\"invoiceDate\\\":\\\"2025-12-10T00:00:00.000Z\\\",\\\"initialBalanceAmount\\\":18634.2,\\\"balanceAmount\\\":18634.2,\\\"payAmount\\\":0,\\\"status\\\":\\\"Unpaid\\\"}]\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03T00:00:00.000Z\",\"payment_number\":\"PAY-0100\",\"reference_no\":\"PAY-0100\",\"cheque_number\":null,\"cheque_date\":\"2026-01-03T00:00:00.000Z\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"Amount credited from customerpayment\",\"amount\":3000}',
    'Credit',
    '2026-01-03T10:08:34.503Z',
    '2026-01-03T10:08:34.503Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    3,
    'Unknown',
    '{\"proforma_id\":\"TXN-422147\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03\",\"payment_number\":null,\"reference_no\":null,\"cheque_number\":null,\"cheque_date\":\"2026-01-03\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"\",\"amount\":2999.7999999999993}',
    'Credit',
    '2026-01-03T10:09:21.308Z',
    '2026-01-03T10:09:21.308Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    4,
    '-',
    '{\"proforma_id\":\"[{\\\"key\\\":426,\\\"invoice_id\\\":426,\\\"invoice_number\\\":\\\"INV-0101\\\",\\\"delivery_note_number\\\":\\\"DLV-0013\\\",\\\"invoiceAmount\\\":3605.7,\\\"invoiceDate\\\":\\\"2026-01-03T00:00:00.000Z\\\",\\\"initialBalanceAmount\\\":3605.7,\\\"balanceAmount\\\":3605.7,\\\"payAmount\\\":0,\\\"status\\\":\\\"Unpaid\\\"},{\\\"key\\\":425,\\\"invoice_id\\\":425,\\\"invoice_number\\\":\\\"INV-0100\\\",\\\"delivery_note_number\\\":\\\"DLV-0011, DLV-0012\\\",\\\"invoiceAmount\\\":21634.2,\\\"invoiceDate\\\":\\\"2025-12-10T00:00:00.000Z\\\",\\\"initialBalanceAmount\\\":18634.2,\\\"balanceAmount\\\":0,\\\"payAmount\\\":18634.2,\\\"status\\\":\\\"Paid\\\"}]\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03T00:00:00.000Z\",\"payment_number\":\"PAY-0100\",\"reference_no\":\"PAY-0100\",\"cheque_number\":null,\"cheque_date\":\"2026-01-03T00:00:00.000Z\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"Amount credited from customerpayment\",\"amount\":21634}',
    'Credit',
    '2026-01-03T10:09:26.734Z',
    '2026-01-03T10:09:26.734Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    5,
    'Unknown',
    '{\"proforma_id\":\"TXN-195478\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03\",\"payment_number\":null,\"reference_no\":null,\"cheque_number\":null,\"cheque_date\":\"2026-01-03\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"\",\"amount\":20000}',
    'Credit',
    '2026-01-03T10:10:02.125Z',
    '2026-01-03T10:10:02.125Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    6,
    'Cash',
    '{\"proforma_id\":\"[{\\\"key\\\":426,\\\"invoice_id\\\":426,\\\"invoice_number\\\":\\\"INV-0101\\\",\\\"delivery_note_number\\\":\\\"DLV-0013\\\",\\\"invoiceAmount\\\":3605.7,\\\"invoiceDate\\\":\\\"2026-01-03T00:00:00.000Z\\\",\\\"initialBalanceAmount\\\":3605.7,\\\"balanceAmount\\\":3605.7,\\\"payAmount\\\":0,\\\"status\\\":\\\"Unpaid\\\"}]\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":437,\"payee_bank\":null,\"payment_bank\":null,\"payment_date\":\"2026-01-03T00:00:00.000Z\",\"payment_number\":\"PAY-0100\",\"reference_no\":\"PAY-0100\",\"cheque_number\":null,\"cheque_date\":\"2026-01-03T00:00:00.000Z\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"Amount credited from customerpayment\",\"amount\":20000}',
    'Credit',
    '2026-01-03T10:10:08.322Z',
    '2026-01-03T10:10:08.322Z'
  );
INSERT INTO
  `transation_bank` (
    `id`,
    `payment_method`,
    `transaction_info`,
    `status`,
    `created_at`,
    `updated_at`
  )
VALUES
  (
    7,
    'Unknown',
    '{\"proforma_id\":\"TXN-917770\",\"proforma_number\":null,\"quote_ref_number\":null,\"customerr_id\":\"437\",\"payee_bank\":\"-\",\"payment_bank\":\"-\",\"payment_date\":\"2026-01-03\",\"payment_number\":\"-\",\"reference_no\":\"-\",\"cheque_number\":\"-\",\"cheque_date\":\"2026-01-03T00:00:00.000Z\",\"pdc_number\":null,\"pdc_date\":null,\"pdc_status\":null,\"payment_from\":\"\",\"amount\":3000}',
    'Credit',
    '2026-01-03T10:11:11.898Z',
    '2026-01-03T10:11:11.898Z'
  );

