/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# ------------------------------------------------------------
# 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: brand_settings
# ------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `brand_settings` (
`id` int(11) NOT NULL,
`company_name` varchar(255) DEFAULT NULL,
`address_line_1` varchar(255) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`state_province` varchar(100) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`postal_zip_code` varchar(20) DEFAULT NULL,
`phone` varchar(20) DEFAULT NULL,
`support_email` varchar(100) DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`tax_vat_registration_number` varchar(100) DEFAULT NULL,
`global_tax` text NOT NULL,
`default_language` varchar(50) DEFAULT NULL,
`bank_account_name` varchar(255) DEFAULT NULL,
`bank_name` varchar(255) DEFAULT NULL,
`bank_account_number` varchar(50) DEFAULT NULL,
`bank_iban` varchar(100) DEFAULT NULL,
`bank_branch_name` varchar(255) DEFAULT NULL,
`personal_name` varchar(255) DEFAULT NULL,
`personal_mobile_number` varchar(20) DEFAULT NULL,
`personal_email` varchar(100) DEFAULT NULL,
`company_logo` text DEFAULT NULL,
`company_logo_color` text NOT NULL,
`pdf_image_bg` text DEFAULT NULL,
`digital_signature` text DEFAULT NULL,
`created_at` timestamp NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`date_format` text DEFAULT NULL,
`date_separator` varchar(5) DEFAULT '/',
`time_zone` text DEFAULT NULL,
`currency_format` text DEFAULT NULL,
`decimal_precision` text DEFAULT NULL,
`thousand_separator` text DEFAULT NULL,
`financial_year_start` text DEFAULT NULL,
`land_phone_number` text DEFAULT NULL,
`designation` text DEFAULT NULL,
`primary_color` text DEFAULT NULL,
`secondary_color` text DEFAULT NULL,
`favicon` text DEFAULT NULL,
`signature` text NOT NULL,
`currencies` text NOT NULL,
`max_discount_percentage` text NOT NULL,
`max_discount_amount` text NOT NULL,
`payment_banks` longtext NOT NULL,
`seo_title` text DEFAULT NULL,
`seo_description` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB 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: email_settings
# ------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `email_settings` (
`id` int(11) NOT NULL,
`method` varchar(50) DEFAULT NULL,
`host` varchar(255) DEFAULT NULL,
`port` varchar(10) DEFAULT NULL,
`encryption` varchar(50) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`fromName` varchar(255) DEFAULT NULL,
`fromEmail` varchar(255) DEFAULT NULL,
`signature` text DEFAULT NULL,
PRIMARY KEY (`id`)
) 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: password_resets
# ------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `password_resets` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`token` varchar(255) NOT NULL,
`expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`used` tinyint(1) DEFAULT 0,
`created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE = InnoDB 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;
# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user
# ------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`full_name` text NOT NULL,
`username` text NOT NULL,
`password` varchar(255) NOT NULL,
`status` varchar(50) NOT NULL DEFAULT 'Active',
`email` varchar(100) NOT NULL,
`designation` varchar(100) DEFAULT NULL,
`mobile_number` varchar(20) DEFAULT NULL,
`digital_signature` text DEFAULT NULL,
`email_signature` text DEFAULT NULL,
`last_login_ip` varchar(45) DEFAULT NULL,
`last_login_at` text DEFAULT NULL,
`created_at` text DEFAULT NULL,
`updated_at` text DEFAULT NULL,
`privileges` longtext DEFAULT NULL,
`role_id` text DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 102 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_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: brand_settings
# ------------------------------------------------------------
INSERT INTO
`brand_settings` (
`id`,
`company_name`,
`address_line_1`,
`country`,
`state_province`,
`city`,
`postal_zip_code`,
`phone`,
`support_email`,
`website`,
`tax_vat_registration_number`,
`global_tax`,
`default_language`,
`bank_account_name`,
`bank_name`,
`bank_account_number`,
`bank_iban`,
`bank_branch_name`,
`personal_name`,
`personal_mobile_number`,
`personal_email`,
`company_logo`,
`company_logo_color`,
`pdf_image_bg`,
`digital_signature`,
`created_at`,
`updated_at`,
`date_format`,
`date_separator`,
`time_zone`,
`currency_format`,
`decimal_precision`,
`thousand_separator`,
`financial_year_start`,
`land_phone_number`,
`designation`,
`primary_color`,
`secondary_color`,
`favicon`,
`signature`,
`currencies`,
`max_discount_percentage`,
`max_discount_amount`,
`payment_banks`,
`seo_title`,
`seo_description`
)
VALUES
(
12,
'Apex IT Solutions FZ-LLC',
'Office 1205, Tower B, Business Bay',
'AE',
'DU',
'Business Bay',
'',
'+97145551010',
'sales@apexitsolutions.ae',
'www.apexitsolutions.ae',
'100200300400003',
'5',
'English',
'Acme Bank Account',
'Bank of Acme',
'123456789067878',
'1234',
'Main Branch',
'Muhammed Basheer',
'+971564475766',
'jaseer9746@gmail.com',
'/uploads/brand/ddlyc8fjw2g_2025_11_25.png',
'/uploads/brand/ddlyc8fjw2g_2025_11_25.png',
'',
'',
'2025-06-12 02:09:52',
'2025-11-25 07:33:46',
'DD/MM/YYYY',
'/',
'Asia/Dubai',
'before',
'2 decimals',
'aed',
'01-01',
'',
'Business Development Manager',
'#09b403',
'#ffffff',
'/uploads/brand/kbqjf1yff6_2025_10_27.jpg',
'',
'[\"AED\"]',
'20',
'500',
'[{\"bank_name\":\"My Bank\",\"account_number\":234255373764},{\"bank_name\":\"Second Bank\",\"account_number\":57556577599}]',
'Demo - Sales ERP by Upturnist',
'test description'
);
# ------------------------------------------------------------
# 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',
'Kindly check all product/services are delivered as specified in the respective LPO/Quote
If there is any dispute or mismatch on the delivery, please reach out to us at info@uptunist.com.
'
);
# ------------------------------------------------------------
# DATA DUMP FOR TABLE: email_settings
# ------------------------------------------------------------
INSERT INTO
`email_settings` (
`id`,
`method`,
`host`,
`port`,
`encryption`,
`username`,
`password`,
`fromName`,
`fromEmail`,
`signature`
)
VALUES
(
2,
'SMTP',
'smtp.maileroo.com',
'465',
'SSL',
'mail@upturnist.com',
'9ddee03d9cbfc4ba1ff05ea0',
'Upturnist Technologies',
'mail@upturnist.com',
'gfgbvjkhihihjk jhbhojhijiojpo dfgdfgdfgdffghvghj'
);
# ------------------------------------------------------------
# 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}}',
'Dear {{customer_name}},
Please find attached the proforma invoice for your upcoming order.
Proforma Invoice Number: {{invoice_number}}
Date Issued: {{invoice_date}}
Total Amount: {{total_invoice_value}}
This proforma invoice outlines the products/services and costs as discussed. It is not a final tax invoice but serves as a formal offer.
To proceed with the order, kindly confirm by replying to this email or making the payment as per the instructions in the document.
If you have any questions or need modifications, feel free to reply to this email. We look forward to working with you.
',
'',
'Kindly ensure that all payments are made via Bank Transfer to the designated Bank Account.
Once payment has been made for Services Invoices, shall not be refunded.
If there is any dispute on this invoice, please reach out to us at info@uptunist.com.
All currencies mentioned in this invoice are in AED Excluding VAT (Unit Arab Emirates Dirhams)
',
'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: password_resets
# ------------------------------------------------------------
INSERT INTO
`password_resets` (
`id`,
`user_id`,
`token`,
`expires_at`,
`used`,
`created_at`
)
VALUES
(
0,
4,
'2b35a0eb1ceab97481eb99be39da96060ac8fce2a598b1483ab9017fa47a1216',
'2025-07-21 00:24:29',
1,
'2025-07-21 00:21:22'
);
INSERT INTO
`password_resets` (
`id`,
`user_id`,
`token`,
`expires_at`,
`used`,
`created_at`
)
VALUES
(
0,
3,
'843fcd987e8418e5b49e900a50ac196d20a5c4d76cf7f53ca5b2294a1860c688',
'2025-08-06 03:06:30',
1,
'2025-08-06 03:05:23'
);
INSERT INTO
`password_resets` (
`id`,
`user_id`,
`token`,
`expires_at`,
`used`,
`created_at`
)
VALUES
(
0,
14,
'4d3da59b9f21363e0807e2e92ebdf90a5b4aa875ef2a8cb10b34259415fd6023',
'2025-08-11 03:20:08',
1,
'2025-08-11 03:18:44'
);
# ------------------------------------------------------------
# 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}},
Thank you for your payment. This email is to confirm that we have received your payment for the following invoice:
Invoice Number: {{current_invoice_number}}
Date Paid: {{payment_date}}
Amount Received: {{payment_amount}}
Payment Method: {{payment_type}}
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!
{{customer_id}}{{status}}
',
'',
'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,
'
',
'Your Proforma Invoice from {{company}}',
'Dear {{customer_name}},
Please find attached the proforma invoice for your upcoming order.
Proforma Invoice Number: {{proforma_number}}
Date Issued: {{proforma_date}}
This proforma invoice outlines the products/services and costs as discussed. It is not a final tax invoice but serves as a formal offer.
To proceed with the order, kindly confirm by replying to this email or making the payment as per the instructions in the document.
If you have any questions or need modifications, feel free to reply to this email. We look forward to working with you.
',
'',
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',
'
',
'[{\"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',
'
',
'[{\"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',
'
',
'[{\"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',
'
',
'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',
'Currency and TAX: All amounts mentioned in the proposal are in AED exclusive of VAT.
Payment Terms: One-time payments: 70% Advance - 30% on completion. Recurring payments: Quarterly in Advance.
Thank you for your interest in our services. Please find below your quote details:
Quote Number: {{quote_number}}
Quote Date: {{quote_date}}
Total Amount: {{total_quote_value}}
You can view and download your full quote here: {{quote_link}}
If you have any questions or need modifications, feel free to reply to this email.\n\nWe look forward to working with you.
',
'',
'[\"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',
'
',
'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'
);
# ------------------------------------------------------------
# DATA DUMP FOR TABLE: unit
# ------------------------------------------------------------
# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user
# ------------------------------------------------------------
INSERT INTO
`user` (
`user_id`,
`full_name`,
`username`,
`password`,
`status`,
`email`,
`designation`,
`mobile_number`,
`digital_signature`,
`email_signature`,
`last_login_ip`,
`last_login_at`,
`created_at`,
`updated_at`,
`privileges`,
`role_id`
)
VALUES
(
1,
'Super Admin',
'saleem',
'$2b$10$8GpXZ0nM/UkW5ZgDjhrsWe7WpqhHIw2i9u4opFajhcC/PmtHa2bx6',
'Active',
'sd@upturnist.com',
'superadmin',
'+971563723805',
'/uploads/profile/446mcykdupw_2025_11_15.webp',
'Regards,
Mohammed Saleem AK
Project Manager',
'103.74.137.225',
'2025-12-29T13:50:19.032Z',
'2025-09-26 12:37:25',
'2025-12-29T13:50:19.069Z',
'[\"*\"]',
'superadmin'
);
INSERT INTO
`user` (
`user_id`,
`full_name`,
`username`,
`password`,
`status`,
`email`,
`designation`,
`mobile_number`,
`digital_signature`,
`email_signature`,
`last_login_ip`,
`last_login_at`,
`created_at`,
`updated_at`,
`privileges`,
`role_id`
)
VALUES
(
98,
'Fatima Al-Husseini',
'fatima',
'$2b$10$oQih7zjKZKnko5fAhs7Cq.bHk2xodKqOYGqxL.2n.eUqzFuhWrlqC',
'[{\"id\":12,\"key\":\"active\",\"label\":\"Active\"}]',
'fatima@apexitsolutions.ae',
'Sales Manager',
'+971561234567',
'/uploads/profile/2rvfo01kmuy_2025_11_04.png',
NULL,
'2.48.229.207',
'2025-11-13T08:05:44.856Z',
'2025-11-04T04:30:29.390Z',
'2026-01-03T12:41:54.167Z',
'[]',
'29'
);
INSERT INTO
`user` (
`user_id`,
`full_name`,
`username`,
`password`,
`status`,
`email`,
`designation`,
`mobile_number`,
`digital_signature`,
`email_signature`,
`last_login_ip`,
`last_login_at`,
`created_at`,
`updated_at`,
`privileges`,
`role_id`
)
VALUES
(
99,
'demo',
'demo',
'$2b$10$j8Zx0EXovqbElFq7/OkEu.Xlx3yWEpRybx9yRkiXRjVo1Xtnjubs6',
'[{\"id\":12,\"key\":\"active\",\"label\":\"Active\"}]',
'demo@upturnist.com',
'sales',
'+971456777668',
'0',
'',
'2.48.229.207',
'2025-11-13T13:36:55.849Z',
'2025-11-12T09:13:43.544Z',
'2026-01-03T12:22:25.002Z',
'[]',
'29'
);
INSERT INTO
`user` (
`user_id`,
`full_name`,
`username`,
`password`,
`status`,
`email`,
`designation`,
`mobile_number`,
`digital_signature`,
`email_signature`,
`last_login_ip`,
`last_login_at`,
`created_at`,
`updated_at`,
`privileges`,
`role_id`
)
VALUES
(
101,
'test user demo',
'testuser',
'$2b$10$MZieD7P02VgRA7OwqFTM4u4cSTLLvR4.sdaD4/V5H9aLVvWlljBBq',
'[{\"id\":12,\"key\":\"active\",\"label\":\"Active\"}]',
'jaseerali2012@gmail.com',
'Test',
'+971195555555',
'0',
'',
'103.74.138.81',
'2025-11-15T07:38:05.015Z',
'2025-11-15T06:08:26.853Z',
'2026-01-03T12:22:19.332Z',
'[]',
'29'
);
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;