-- Table structure for table `toda_tblcreditnote_refunds`
--

CREATE TABLE `toda_tblcreditnote_refunds` (
  `id` int NOT NULL AUTO_INCREMENT,
  `credit_note_id` int NOT NULL,
  `staff_id` int NOT NULL,
  `refunded_on` date NOT NULL,
  `payment_mode` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `amount` decimal(15,2) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcreditnote_refunds`
--


--
-- Table structure for table `toda_tblcreditnotes`
--

CREATE TABLE `toda_tblcreditnotes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clientid` int NOT NULL,
  `deleted_customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int NOT NULL,
  `prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int NOT NULL DEFAULT '1',
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `currency` int NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `status` int DEFAULT '1',
  `project_id` int NOT NULL DEFAULT '0',
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_credit_note` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `currency` (`currency`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcreditnotes`
--


--
-- Table structure for table `toda_tblcredits`
--

CREATE TABLE `toda_tblcredits` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` int NOT NULL,
  `credit_id` int NOT NULL,
  `staff_id` int NOT NULL,
  `date` date NOT NULL,
  `date_applied` datetime NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcredits`
--


--
-- Table structure for table `toda_tblcurrencies`
--

CREATE TABLE `toda_tblcurrencies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `symbol` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `decimal_separator` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thousand_separator` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placement` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isdefault` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcurrencies`
--

INSERT INTO `toda_tblcurrencies` VALUES (1,'$','USD','.',',','before',1),(2,'€','EUR',',','.','before',0);

--
-- Table structure for table `toda_tblcurrency_rate_logs`
--

CREATE TABLE `toda_tblcurrency_rate_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_currency_id` int DEFAULT NULL,
  `from_currency_name` varchar(100) DEFAULT NULL,
  `from_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `to_currency_id` int DEFAULT NULL,
  `to_currency_name` varchar(100) DEFAULT NULL,
  `to_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblcurrency_rate_logs`
--


--
-- Table structure for table `toda_tblcurrency_rates`
--

CREATE TABLE `toda_tblcurrency_rates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `from_currency_id` int DEFAULT NULL,
  `from_currency_name` varchar(100) DEFAULT NULL,
  `from_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `to_currency_id` int DEFAULT NULL,
  `to_currency_name` varchar(100) DEFAULT NULL,
  `to_currency_rate` decimal(15,6) NOT NULL DEFAULT '0.000000',
  `date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblcurrency_rates`
--


--
-- Table structure for table `toda_tblcustomer_admins`
--

CREATE TABLE `toda_tblcustomer_admins` (
  `staff_id` int NOT NULL,
  `customer_id` int NOT NULL,
  `date_assigned` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `customer_id` (`customer_id`),
  KEY `toda_staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcustomer_admins`
--


--
-- Table structure for table `toda_tblcustomer_groups`
--

CREATE TABLE `toda_tblcustomer_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupid` int NOT NULL,
  `customer_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `groupid` (`groupid`),
  KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcustomer_groups`
--


--
-- Table structure for table `toda_tblcustomers_groups`
--

CREATE TABLE `toda_tblcustomers_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcustomers_groups`
--


--
-- Table structure for table `toda_tblcustomfields`
--

CREATE TABLE `toda_tblcustomfields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldto` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `display_inline` tinyint(1) NOT NULL DEFAULT '0',
  `field_order` int DEFAULT '0',
  `active` int NOT NULL DEFAULT '1',
  `show_on_pdf` int NOT NULL DEFAULT '0',
  `show_on_ticket_form` tinyint(1) NOT NULL DEFAULT '0',
  `only_admin` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_on_client_portal` int NOT NULL DEFAULT '0',
  `disalow_client_to_edit` int NOT NULL DEFAULT '0',
  `bs_column` int NOT NULL DEFAULT '12',
  `default_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcustomfields`
--


--
-- Table structure for table `toda_tblcustomfieldsvalues`
--

CREATE TABLE `toda_tblcustomfieldsvalues` (
  `id` int NOT NULL AUTO_INCREMENT,
  `relid` int NOT NULL,
  `fieldid` int NOT NULL,
  `fieldto` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `relid` (`relid`),
  KEY `fieldto` (`fieldto`),
  KEY `fieldid` (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblcustomfieldsvalues`
--


--
-- Table structure for table `toda_tbldepartments`
--

CREATE TABLE `toda_tbldepartments` (
  `departmentid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `imap_username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_from_header` tinyint(1) NOT NULL DEFAULT '0',
  `host` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `encryption` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INBOX',
  `delete_after_import` int NOT NULL DEFAULT '0',
  `calendar_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `hidefromclient` tinyint(1) NOT NULL DEFAULT '0',
  `manager_id` int DEFAULT '0',
  `parent_id` int DEFAULT '0',
  PRIMARY KEY (`departmentid`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tbldepartments`
--


--
-- Table structure for table `toda_tbldismissed_announcements`
--

CREATE TABLE `toda_tbldismissed_announcements` (
  `dismissedannouncementid` int NOT NULL AUTO_INCREMENT,
  `announcementid` int NOT NULL,
  `staff` int NOT NULL,
  `userid` int NOT NULL,
  PRIMARY KEY (`dismissedannouncementid`),
  KEY `announcementid` (`announcementid`),
  KEY `toda_staff` (`staff`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tbldismissed_announcements`
--


--
-- Table structure for table `toda_tblemaillists`
--

CREATE TABLE `toda_tblemaillists` (
  `listid` int NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `creator` varchar(100) NOT NULL,
  `datecreated` datetime NOT NULL,
  PRIMARY KEY (`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblemaillists`
--


--
-- Table structure for table `toda_tblemailtemplates`
--

CREATE TABLE `toda_tblemailtemplates` (
  `emailtemplateid` int NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromname` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromemail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plaintext` int NOT NULL DEFAULT '0',
  `active` tinyint NOT NULL DEFAULT '0',
  `order` int NOT NULL,
  PRIMARY KEY (`emailtemplateid`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblemailtemplates`
--

INSERT INTO `toda_tblemailtemplates` VALUES (1,'client','new-client-created','english','New Contact Added/Registered (Welcome Email)','Welcome aboard','Dear {contact_firstname} {contact_lastname}<br /><br />Thank you for registering on the <strong>{companyname}</strong> CRM System.<br /><br />We just wanted to say welcome.<br /><br />Please contact us if you need any help.<br /><br />Click here to view your profile: <a href=\"{crm_url}\">{crm_url}</a><br /><br />Kind Regards, <br />{email_signature}<br /><br />(This is an automated email, so please don\'t reply to this email address)','{companyname} | CRM','',0,1,0),(2,'invoice','invoice-send-to-client','english','Send Invoice to Customer','Invoice with number {invoice_number} created','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">We have prepared the following invoice for you: <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Invoice status</strong>: {invoice_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(3,'ticket','new-ticket-opened-admin','english','New Ticket Opened (Opened by Staff, Sent to Customer)','New Support Ticket Opened','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">New support ticket has been opened.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department:</strong> {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a><br /><br />Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(4,'ticket','ticket-reply','english','Ticket Reply (Sent to Customer)','New Ticket Reply','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">You have a new ticket reply to ticket <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket Subject:</strong> {ticket_subject}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(5,'ticket','ticket-autoresponse','english','New Ticket Opened - Autoresponse','New Support Ticket Opened','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Thank you for contacting our support team. A support ticket has now been opened for your request. You will be notified when a response is made by email.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_public_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(6,'invoice','invoice-payment-recorded','english','Invoice Payment Recorded (Sent to Customer)','Invoice Payment Recorded','<span style=\"font-size: 12pt;\">Hello {contact_firstname}&nbsp;{contact_lastname}<br /><br /></span>Thank you for the payment. Find the payment details below:<br /><br />-------------------------------------------------<br /><br />Amount:&nbsp;<strong>{payment_total}<br /></strong>Date:&nbsp;<strong>{payment_date}</strong><br />Invoice number:&nbsp;<span style=\"font-size: 12pt;\"><strong># {invoice_number}<br /><br /></strong></span>-------------------------------------------------<br /><br />You can always view the invoice for this payment at the following link:&nbsp;<a href=\"{invoice_link}\"><span style=\"font-size: 12pt;\">{invoice_number}</span></a><br /><br />We are looking forward working with you.<br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(7,'invoice','invoice-overdue-notice','english','Invoice Overdue Notice','Invoice Overdue Notice - {invoice_number}','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">This is an overdue notice for invoice <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\">This invoice was due: {invoice_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(8,'invoice','invoice-already-send','english','Invoice Already Sent to Customer','Invoice # {invoice_number} ','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">At your request, here is the invoice with number <strong># {invoice_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(9,'ticket','new-ticket-created-staff','english','New Ticket Created (Opened by Customer, Sent to Staff Members)','New Ticket Created','<p><span style=\"font-size: 12pt;\">A new support ticket has been opened.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}<br /></span><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(10,'estimate','estimate-send-to-client','english','Send Estimate to Customer','Estimate # {estimate_number} created','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the attached estimate <strong># {estimate_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Estimate status:</strong> {estimate_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">We look forward to your communication.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}<br /></span>','{companyname} | CRM','',0,1,0),(11,'ticket','ticket-reply-to-admin','english','Ticket Reply (Sent to Staff)','New Support Ticket Reply','<span style=\"font-size: 12pt;\">A new support ticket reply from {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(12,'estimate','estimate-already-send','english','Estimate Already Sent to Customer','Estimate # {estimate_number} ','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /> <br /><span style=\"font-size: 12pt;\">Thank you for your estimate request.</span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(13,'contract','contract-expiration','english','Contract Expiration Reminder (Sent to Customer Contacts)','Contract Expiration Reminder','<span style=\"font-size: 12pt;\">Dear {client_company}</span><br /><br /><span style=\"font-size: 12pt;\">This is a reminder that the following contract will expire soon:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {contract_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Description:</strong> {contract_description}</span><br /><span style=\"font-size: 12pt;\"><strong>Date Start:</strong> {contract_datestart}</span><br /><span style=\"font-size: 12pt;\"><strong>Date End:</strong> {contract_dateend}</span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(14,'tasks','task-assigned','english','New Task Assigned (Sent to Staff)','New Task Assigned to You - {task_name}','<span style=\"font-size: 12pt;\">Dear {staff_firstname}</span><br /><br /><span style=\"font-size: 12pt;\">You have been assigned to a new task:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}<br /></span><strong>Start Date:</strong> {task_startdate}<br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {task_priority}<br /><br /></span><span style=\"font-size: 12pt;\"><span>You can view the task on the following link</span>: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(15,'tasks','task-added-as-follower','english','Staff Member Added as Follower on Task (Sent to Staff)','You are added as follower on task - {task_name}','<span style=\"font-size: 12pt;\">Hi {staff_firstname}<br /></span><br /><span style=\"font-size: 12pt;\">You have been added as follower on the following task:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Start date:</strong> {task_startdate}</span><br /><br /><span>You can view the task on the following link</span><span>: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(16,'tasks','task-commented','english','New Comment on Task (Sent to Staff)','New Comment on Task - {task_name}','Dear {staff_firstname}<br /><br />A comment has been made on the following task:<br /><br /><strong>Name:</strong> {task_name}<br /><strong>Comment:</strong> {task_comment}<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(17,'tasks','task-added-attachment','english','New Attachment(s) on Task (Sent to Staff)','New Attachment on Task - {task_name}','Hi {staff_firstname}<br /><br /><strong>{task_user_take_action}</strong> added an attachment on the following task:<br /><br /><strong>Name:</strong> {task_name}<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(18,'estimate','estimate-declined-to-staff','english','Estimate Declined (Sent to Staff)','Customer Declined Estimate','<span style=\"font-size: 12pt;\">Hi</span><br /> <br /><span style=\"font-size: 12pt;\">Customer ({client_company}) declined estimate with number <strong># {estimate_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(19,'estimate','estimate-accepted-to-staff','english','Estimate Accepted (Sent to Staff)','Customer Accepted Estimate','<span style=\"font-size: 12pt;\">Hi</span><br /> <br /><span style=\"font-size: 12pt;\">Customer ({client_company}) accepted estimate with number <strong># {estimate_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(20,'proposals','proposal-client-accepted','english','Customer Action - Accepted (Sent to Staff)','Customer Accepted Proposal','<div>Hi<br /> <br />Client <strong>{proposal_proposal_to}</strong> accepted the following proposal:<br /> <br /><strong>Number:</strong> {proposal_number}<br /><strong>Subject</strong>: {proposal_subject}<br /><strong>Total</strong>: {proposal_total}<br /> <br />View the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /> <br />Kind Regards,<br />{email_signature}</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>','{companyname} | CRM','',0,1,0),(21,'proposals','proposal-send-to-customer','english','Send Proposal to Customer','Proposal With Number {proposal_number} Created','Dear {proposal_proposal_to}<br /><br />Please find our attached proposal.<br /><br />This proposal is valid until: {proposal_open_till}<br />You can view the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /><br />Please don\'t hesitate to comment online if you have any questions.<br /><br />We look forward to your communication.<br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(22,'proposals','proposal-client-declined','english','Customer Action - Declined (Sent to Staff)','Client Declined Proposal','Hi<br /> <br />Customer <strong>{proposal_proposal_to}</strong> declined the proposal <strong>{proposal_subject}</strong><br /> <br />View the proposal on the following link <a href=\"{proposal_link}\">{proposal_number}</a>&nbsp;or from the admin area.<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(23,'proposals','proposal-client-thank-you','english','Thank You Email (Sent to Customer After Accept)','Thank for you accepting proposal','Dear {proposal_proposal_to}<br /> <br />Thank for for accepting the proposal.<br /> <br />We look forward to doing business with you.<br /> <br />We will contact you as soon as possible<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(24,'proposals','proposal-comment-to-client','english','New Comment  (Sent to Customer/Lead)','New Proposal Comment','Dear {proposal_proposal_to}<br /> <br />A new comment has been made on the following proposal: <strong>{proposal_number}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(25,'proposals','proposal-comment-to-admin','english','New Comment (Sent to Staff) ','New Proposal Comment','Hi<br /> <br />A new comment has been made to the proposal <strong>{proposal_subject}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{proposal_link}\">{proposal_number}</a>&nbsp;or from the admin area.<br /> <br />{email_signature}','{companyname} | CRM','',0,1,0),(26,'estimate','estimate-thank-you-to-customer','english','Thank You Email (Sent to Customer After Accept)','Thank for you accepting estimate','<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /> <br /><span style=\"font-size: 12pt;\">Thank for for accepting the estimate.</span><br /> <br /><span style=\"font-size: 12pt;\">We look forward to doing business with you.</span><br /> <br /><span style=\"font-size: 12pt;\">We will contact you as soon as possible.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(27,'tasks','task-deadline-notification','english','Task Deadline Reminder - Sent to Assigned Members','Task Deadline Reminder','Hi {staff_firstname}&nbsp;{staff_lastname}<br /><br />This is an automated email from {companyname}.<br /><br />The task <strong>{task_name}</strong> deadline is on <strong>{task_duedate}</strong>. <br />This task is still not finished.<br /><br />You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a><br /><br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(28,'contract','send-contract','english','Send Contract to Customer','Contract - {contract_subject}','<p><span style=\"font-size: 12pt;\">Hi&nbsp;{contact_firstname}&nbsp;{contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the <a href=\"{contract_link}\">{contract_subject}</a> attached.<br /><br />Description: {contract_description}<br /><br /></span><span style=\"font-size: 12pt;\">Looking forward to hear from you.</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(29,'invoice','invoice-payment-recorded-to-staff','english','Invoice Payment Recorded (Sent to Staff)','New Invoice Payment','<span style=\"font-size: 12pt;\">Hi</span><br /><br /><span style=\"font-size: 12pt;\">Customer recorded payment for invoice <strong># {invoice_number}</strong></span><br /> <br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(30,'ticket','auto-close-ticket','english','Auto Close Ticket','Ticket Auto Closed','<p><span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Ticket {ticket_subject} has been auto close due to inactivity.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket #</strong>: <a href=\"{ticket_public_url}\">{ticket_id}</a></span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority:</strong> {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(31,'project','new-project-discussion-created-to-staff','english','New Project Discussion (Sent to Project Members)','New Project Discussion Created - {project_name}','<p>Hi {staff_firstname}<br /><br />New project discussion created from <strong>{discussion_creator}</strong><br /><br /><strong>Subject:</strong> {discussion_subject}<br /><strong>Description:</strong> {discussion_description}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(32,'project','new-project-discussion-created-to-customer','english','New Project Discussion (Sent to Customer Contacts)','New Project Discussion Created - {project_name}','<p>Hello {contact_firstname} {contact_lastname}<br /><br />New project discussion created from <strong>{discussion_creator}</strong><br /><br /><strong>Subject:</strong> {discussion_subject}<br /><strong>Description:</strong> {discussion_description}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(33,'project','new-project-file-uploaded-to-customer','english','New Project File(s) Uploaded (Sent to Customer Contacts)','New Project File(s) Uploaded - {project_name}','<p>Hello {contact_firstname} {contact_lastname}<br /><br />New project file is uploaded on <strong>{project_name}</strong> from <strong>{file_creator}</strong><br /><br />You can view the project on the following link: <a href=\"{project_link}\">{project_name}</a><br /><br />To view the file in our CRM you can click on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(34,'project','new-project-file-uploaded-to-staff','english','New Project File(s) Uploaded (Sent to Project Members)','New Project File(s) Uploaded - {project_name}','<p>Hello&nbsp;{staff_firstname}</p>\r\n<p>New project&nbsp;file is uploaded on&nbsp;<strong>{project_name}</strong> from&nbsp;<strong>{file_creator}</strong></p>\r\n<p>You can view the project on the following link: <a href=\"{project_link}\">{project_name}<br /></a><br />To view&nbsp;the file you can click on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a></p>\r\n<p>Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(35,'project','new-project-discussion-comment-to-customer','english','New Discussion Comment  (Sent to Customer Contacts)','New Discussion Comment','<p><span style=\"font-size: 12pt;\">Hello {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">New discussion comment has been made on <strong>{discussion_subject}</strong> from <strong>{comment_creator}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Discussion subject:</strong> {discussion_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Comment</strong>: {discussion_comment}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(36,'project','new-project-discussion-comment-to-staff','english','New Discussion Comment (Sent to Project Members)','New Discussion Comment','<p>Hi {staff_firstname}<br /><br />New discussion comment has been made on <strong>{discussion_subject}</strong> from <strong>{comment_creator}</strong><br /><br /><strong>Discussion subject:</strong> {discussion_subject}<br /><strong>Comment:</strong> {discussion_comment}<br /><br />You can view the discussion on the following link: <a href=\"{discussion_link}\">{discussion_subject}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(37,'project','staff-added-as-project-member','english','Staff Added as Project Member','New project assigned to you','<p>Hi {staff_firstname}<br /><br />New project has been assigned to you.<br /><br />You can view the project on the following link <a href=\"{project_link}\">{project_name}</a><br /><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(38,'estimate','estimate-expiry-reminder','english','Estimate Expiration Reminder','Estimate Expiration Reminder','<p><span style=\"font-size: 12pt;\">Hello {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">The estimate with <strong># {estimate_number}</strong> will expire on <strong>{estimate_expirydate}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(39,'proposals','proposal-expiry-reminder','english','Proposal Expiration Reminder','Proposal Expiration Reminder','<p>Hello {proposal_proposal_to}<br /><br />The proposal {proposal_number}&nbsp;will expire on <strong>{proposal_open_till}</strong><br /><br />You can view the proposal on the following link: <a href=\"{proposal_link}\">{proposal_number}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(40,'staff','new-staff-created','english','New Staff Created (Welcome Email)','You are added as staff member','Hi {staff_firstname}<br /><br />You are added as member on our CRM.<br /><br />Please use the following logic credentials:<br /><br /><strong>Email:</strong> {staff_email}<br /><strong>Password:</strong> {password}<br /><br />Click <a href=\"{admin_url}\">here </a>to login in the dashboard.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(41,'client','contact-forgot-password','english','Forgot Password','Create New Password','<h2>Create a new password</h2>\r\nForgot your password?<br /> To create a new password, just follow this link:<br /> <br /><a href=\"{reset_password_url}\">Reset Password</a><br /> <br /> You received this email, because it was requested by a {companyname}&nbsp;user. This is part of the procedure to create a new password on the system. If you DID NOT request a new password then please ignore this email and your password will remain the same. <br /><br /> {email_signature}','{companyname} | CRM','',0,1,0),(42,'client','contact-password-reseted','english','Password Reset - Confirmation','Your password has been changed','<strong><span style=\"font-size: 14pt;\">You have changed your password.</span><br /></strong><br /> Please, keep it in your records so you don\'t forget it.<br /> <br /> Your email address for login is: {contact_email}<br /><br />If this wasnt you, please contact us.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(43,'client','contact-set-password','english','Set New Password','Set new password on {companyname} ','<h2><span style=\"font-size: 14pt;\">Setup your new password on {companyname}</span></h2>\r\nPlease use the following link to set up your new password:<br /><br /><a href=\"{set_password_url}\">Set new password</a><br /><br />Keep it in your records so you don\'t forget it.<br /><br />Please set your new password in <strong>48 hours</strong>. After that, you won\'t be able to set your password because this link will expire.<br /><br />You can login at: <a href=\"{crm_url}\">{crm_url}</a><br />Your email address for login: {contact_email}<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(44,'staff','staff-forgot-password','english','Forgot Password','Create New Password','<h2><span style=\"font-size: 14pt;\">Create a new password</span></h2>\r\nForgot your password?<br /> To create a new password, just follow this link:<br /> <br /><a href=\"{reset_password_url}\">Reset Password</a><br /> <br /> You received this email, because it was requested by a <strong>{companyname}</strong>&nbsp;user. This is part of the procedure to create a new password on the system. If you DID NOT request a new password then please ignore this email and your password will remain the same. <br /><br /> {email_signature}','{companyname} | CRM','',0,1,0),(45,'staff','staff-password-reseted','english','Password Reset - Confirmation','Your password has been changed','<span style=\"font-size: 14pt;\"><strong>You have changed your password.<br /></strong></span><br /> Please, keep it in your records so you don\'t forget it.<br /> <br /> Your email address for login is: {staff_email}<br /><br /> If this wasnt you, please contact us.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(46,'project','assigned-to-project','english','New Project Created (Sent to Customer Contacts)','New Project Created','<p>Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}</p>\r\n<p>New project is assigned to your company.<br /><br /><strong>Project Name:</strong>&nbsp;{project_name}<br /><strong>Project Start Date:</strong>&nbsp;{project_start_date}</p>\r\n<p>You can view the project on the following link:&nbsp;<a href=\"{project_link}\">{project_name}</a></p>\r\n<p>We are looking forward hearing from you.<br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(47,'tasks','task-added-attachment-to-contacts','english','New Attachment(s) on Task (Sent to Customer Contacts)','New Attachment on Task - {task_name}','<span>Hi {contact_firstname} {contact_lastname}</span><br /><br /><strong>{task_user_take_action}</strong><span> added an attachment on the following task:</span><br /><br /><strong>Name:</strong><span> {task_name}</span><br /><br /><span>You can view the task on the following link: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span>Kind Regards,</span><br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(48,'tasks','task-commented-to-contacts','english','New Comment on Task (Sent to Customer Contacts)','New Comment on Task - {task_name}','<span>Dear {contact_firstname} {contact_lastname}</span><br /><br /><span>A comment has been made on the following task:</span><br /><br /><strong>Name:</strong><span> {task_name}</span><br /><strong>Comment:</strong><span> {task_comment}</span><br /><br /><span>You can view the task on the following link: </span><a href=\"{task_link}\">{task_name}</a><br /><br /><span>Kind Regards,</span><br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(49,'leads','new-lead-assigned','english','New Lead Assigned to Staff Member','New lead assigned to you','<p>Hello {lead_assigned}<br /><br />New lead is assigned to you.<br /><br /><strong>Lead Name:</strong>&nbsp;{lead_name}<br /><strong>Lead Email:</strong>&nbsp;{lead_email}<br /><br />You can view the lead on the following link: <a href=\"{lead_link}\">{lead_name}</a><br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(50,'client','client-statement','english','Statement - Account Summary','Account Statement from {statement_from} to {statement_to}','Dear {contact_firstname} {contact_lastname}, <br /><br />Its been a great experience working with you.<br /><br />Attached with this email is a list of all transactions for the period between {statement_from} to {statement_to}<br /><br />For your information your account balance due is total:&nbsp;{statement_balance_due}<br /><br />Please contact us if you need more information.<br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(51,'ticket','ticket-assigned-to-admin','english','New Ticket Assigned (Sent to Staff)','New support ticket has been assigned to you','<p><span style=\"font-size: 12pt;\">Hi</span></p>\r\n<p><span style=\"font-size: 12pt;\">A new support ticket&nbsp;has been assigned to you.</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject</strong>: {ticket_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Department</strong>: {ticket_department}</span><br /><span style=\"font-size: 12pt;\"><strong>Priority</strong>: {ticket_priority}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Ticket message:</strong></span><br /><span style=\"font-size: 12pt;\">{ticket_message}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the ticket on the following link: <a href=\"{ticket_url}\">#{ticket_id}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span></p>','{companyname} | CRM','',0,1,0),(52,'client','new-client-registered-to-admin','english','New Customer Registration (Sent to admins)','New Customer Registration','Hello.<br /><br />New customer registration on your customer portal:<br /><br /><strong>Firstname:</strong>&nbsp;{contact_firstname}<br /><strong>Lastname:</strong>&nbsp;{contact_lastname}<br /><strong>Company:</strong>&nbsp;{client_company}<br /><strong>Email:</strong>&nbsp;{contact_email}<br /><br />Best Regards','{companyname} | CRM','',0,1,0),(53,'leads','new-web-to-lead-form-submitted','english','Web to lead form submitted - Sent to lead','{lead_name} - We Received Your Request','Hello {lead_name}.<br /><br /><strong>Your request has been received.</strong><br /><br />This email is to let you know that we received your request and we will get back to you as soon as possible with more information.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,0,0),(54,'staff','two-factor-authentication','english','Two Factor Authentication','Confirm Your Login','<p>Hi {staff_firstname}</p>\r\n<p style=\"text-align: left;\">You received this email because you have enabled two factor authentication in your account.<br />Use the following code to confirm your login:</p>\r\n<p style=\"text-align: left;\"><span style=\"font-size: 18pt;\"><strong>{two_factor_auth_code}<br /><br /></strong><span style=\"font-size: 12pt;\">{email_signature}</span><strong><br /><br /><br /><br /></strong></span></p>','{companyname} | CRM','',0,1,0),(55,'project','project-finished-to-customer','english','Project Marked as Finished (Sent to Customer Contacts)','Project Marked as Finished','<p>Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}</p>\r\n<p>You are receiving this email because project&nbsp;<strong>{project_name}</strong> has been marked as finished. This project is assigned under your company and we just wanted to keep you up to date.<br /><br />You can view the project on the following link:&nbsp;<a href=\"{project_link}\">{project_name}</a></p>\r\n<p>If you have any questions don\'t hesitate to contact us.<br /><br />Kind Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(56,'credit_note','credit-note-send-to-client','english','Send Credit Note To Email','Credit Note With Number #{credit_note_number} Created','Dear&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />We have attached the credit note with number <strong>#{credit_note_number} </strong>for your reference.<br /><br /><strong>Date:</strong>&nbsp;{credit_note_date}<br /><strong>Total Amount:</strong>&nbsp;{credit_note_total}<br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span><br /> <br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(57,'tasks','task-status-change-to-staff','english','Task Status Changed (Sent to Staff)','Task Status Changed','<span style=\"font-size: 12pt;\">Hi {staff_firstname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>{task_user_take_action}</strong> marked task as <strong>{task_status}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(58,'tasks','task-status-change-to-contacts','english','Task Status Changed (Sent to Customer Contacts)','Task Status Changed','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\"><strong>{task_user_take_action}</strong> marked task as <strong>{task_status}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Name:</strong> {task_name}</span><br /><span style=\"font-size: 12pt;\"><strong>Due date:</strong> {task_duedate}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the task on the following link: <a href=\"{task_link}\">{task_name}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(59,'staff','reminder-email-staff','english','Staff Reminder Email','You Have a New Reminder!','<p>Hello&nbsp;{staff_firstname}<br /><br /><strong>You have a new reminder&nbsp;linked to&nbsp;{staff_reminder_relation_name}!<br /><br />Reminder description:</strong><br />{staff_reminder_description}<br /><br />Click <a href=\"{staff_reminder_relation_link}\">here</a> to view&nbsp;<a href=\"{staff_reminder_relation_link}\">{staff_reminder_relation_name}</a><br /><br />Best Regards<br /><br /></p>','{companyname} | CRM','',0,1,0),(60,'contract','contract-comment-to-client','english','New Comment  (Sent to Customer Contacts)','New Contract Comment','Dear {contact_firstname} {contact_lastname}<br /> <br />A new comment has been made on the following contract: <strong>{contract_subject}</strong><br /> <br />You can view and reply to the comment on the following link: <a href=\"{contract_link}\">{contract_subject}</a><br /> <br />Kind Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(61,'contract','contract-comment-to-admin','english','New Comment (Sent to Staff) ','New Contract Comment','Hi {staff_firstname}<br /><br />A new comment has been made to the contract&nbsp;<strong>{contract_subject}</strong><br /><br />You can view and reply to the comment on the following link: <a href=\"{contract_link}\">{contract_subject}</a>&nbsp;or from the admin area.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(62,'subscriptions','send-subscription','english','Send Subscription to Customer','Subscription Created','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />We have prepared the subscription&nbsp;<strong>{subscription_name}</strong> for your company.<br /><br />Click <a href=\"{subscription_link}\">here</a> to review the subscription and subscribe.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(63,'subscriptions','subscription-payment-failed','english','Subscription Payment Failed','Your most recent invoice payment failed','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br br=\"\" />Unfortunately, your most recent invoice payment for&nbsp;<strong>{subscription_name}</strong> was declined.<br /><br />This could be due to a change in your card number, your card expiring,<br />cancellation of your credit card, or the card issuer not recognizing the<br />payment and therefore taking action to prevent it.<br /><br />Please update your payment information as soon as possible by logging in here:<br /><a href=\"{crm_url}/login\">{crm_url}/login</a><br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(64,'subscriptions','subscription-canceled','english','Subscription Canceled (Sent to customer primary contact)','Your subscription has been canceled','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />Your subscription&nbsp;<strong>{subscription_name} </strong>has been canceled, if you have any questions don\'t hesitate to contact us.<br /><br />It was a pleasure doing business with you.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(65,'subscriptions','subscription-payment-succeeded','english','Subscription Payment Succeeded (Sent to customer primary contact)','Subscription  Payment Receipt - {subscription_name}','Hello&nbsp;{contact_firstname}&nbsp;{contact_lastname}<br /><br />This email is to let you know that we received your payment for subscription&nbsp;<strong>{subscription_name}&nbsp;</strong>of&nbsp;<strong><span>{payment_total}<br /><br /></span></strong>The invoice associated with it is now with status&nbsp;<strong>{invoice_status}<br /></strong><br />Thank you for your confidence.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,1,0),(66,'contract','contract-expiration-to-staff','english','Contract Expiration Reminder (Sent to Staff)','Contract Expiration Reminder','Hi {staff_firstname}<br /><br /><span style=\"font-size: 12pt;\">This is a reminder that the following contract will expire soon:</span><br /><br /><span style=\"font-size: 12pt;\"><strong>Subject:</strong> {contract_subject}</span><br /><span style=\"font-size: 12pt;\"><strong>Description:</strong> {contract_description}</span><br /><span style=\"font-size: 12pt;\"><strong>Date Start:</strong> {contract_datestart}</span><br /><span style=\"font-size: 12pt;\"><strong>Date End:</strong> {contract_dateend}</span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(67,'gdpr','gdpr-removal-request','english','Removal Request From Contact (Sent to administrators)','Data Removal Request Received','Hello&nbsp;{staff_firstname}&nbsp;{staff_lastname}<br /><br />Data removal has been requested by&nbsp;{contact_firstname} {contact_lastname}<br /><br />You can review this request and take proper actions directly from the admin area.','{companyname} | CRM','',0,1,0),(68,'gdpr','gdpr-removal-request-lead','english','Removal Request From Lead (Sent to administrators)','Data Removal Request Received','Hello&nbsp;{staff_firstname}&nbsp;{staff_lastname}<br /><br />Data removal has been requested by {lead_name}<br /><br />You can review this request and take proper actions directly from the admin area.<br /><br />To view the lead inside the admin area click here:&nbsp;<a href=\"{lead_link}\">{lead_link}</a>','{companyname} | CRM','',0,1,0),(69,'client','client-registration-confirmed','english','Customer Registration Confirmed','Your registration is confirmed','<p>Dear {contact_firstname} {contact_lastname}<br /><br />We just wanted to let you know that your registration at&nbsp;{companyname} is successfully confirmed and your account is now active.<br /><br />You can login at&nbsp;<a href=\"{crm_url}\">{crm_url}</a> with the email and password you provided during registration.<br /><br />Please contact us if you need any help.<br /><br />Kind Regards, <br />{email_signature}</p>\r\n<p><br />(This is an automated email, so please don\'t reply to this email address)</p>','{companyname} | CRM','',0,1,0),(70,'contract','contract-signed-to-staff','english','Contract Signed (Sent to Staff)','Customer Signed a Contract','Hi {staff_firstname}<br /><br />A contract with subject&nbsp;<strong>{contract_subject} </strong>has been successfully signed by the customer.<br /><br />You can view the contract at the following link: <a href=\"{contract_link}\">{contract_subject}</a>&nbsp;or from the admin area.<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(71,'subscriptions','customer-subscribed-to-staff','english','Customer Subscribed to a Subscription (Sent to administrators and subscription creator)','Customer Subscribed to a Subscription','The customer <strong>{client_company}</strong> subscribed to a subscription with name&nbsp;<strong>{subscription_name}</strong><br /><br /><strong>ID</strong>:&nbsp;{subscription_id}<br /><strong>Subscription name</strong>:&nbsp;{subscription_name}<br /><strong>Subscription description</strong>:&nbsp;{subscription_description}<br /><br />You can view the subscription by clicking <a href=\"{subscription_link}\">here</a><br />\r\n<div style=\"text-align: center;\"><span style=\"font-size: 10pt;\">&nbsp;</span></div>\r\nBest Regards,<br />{email_signature}<br /><br /><span style=\"font-size: 10pt;\"><span style=\"color: #999999;\">You are receiving this email because you are either administrator or you are creator of the subscription.</span></span>','{companyname} | CRM','',0,1,0),(72,'client','contact-verification-email','english','Email Verification (Sent to Contact After Registration)','Verify Email Address','<p>Hello&nbsp;{contact_firstname}<br /><br />Please click the button below to verify your email address.<br /><br /><a href=\"{email_verification_url}\">Verify Email Address</a><br /><br />If you did not create an account, no further action is required</p>\r\n<p><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(73,'client','new-customer-profile-file-uploaded-to-staff','english','New Customer Profile File(s) Uploaded (Sent to Staff)','Customer Uploaded New File(s) in Profile','Hi!<br /><br />New file(s) is uploaded into the customer ({client_company}) profile by&nbsp;{contact_firstname}<br /><br />You can check the uploaded files into the admin area by clicking <a href=\"{customer_profile_files_admin_link}\">here</a> or at the following link:&nbsp;{customer_profile_files_admin_link}<br /><br />{email_signature}','{companyname} | CRM','',0,1,0),(74,'staff','event-notification-to-staff','english','Event Notification (Calendar)','Upcoming Event - {event_title}','Hi {staff_firstname}! <br /><br />This is a reminder for event <a href=\\\"{event_link}\\\">{event_title}</a> scheduled at {event_start_date}. <br /><br />Regards.','','',0,1,0),(75,'subscriptions','subscription-payment-requires-action','english','Credit Card Authorization Required - SCA','Important: Confirm your subscription {subscription_name} payment','<p>Hello {contact_firstname}</p>\r\n<p><strong>Your bank sometimes requires an additional step to make sure an online transaction was authorized.</strong><br /><br />Because of European regulation to protect consumers, many online payments now require two-factor authentication. Your bank ultimately decides when authentication is required to confirm a payment, but you may notice this step when you start paying for a service or when the cost changes.<br /><br />In order to pay the subscription <strong>{subscription_name}</strong>, you will need to&nbsp;confirm your payment by clicking on the follow link: <strong><a href=\"{subscription_authorize_payment_link}\">{subscription_authorize_payment_link}</a></strong><br /><br />To view the subscription, please click at the following link: <a href=\"{subscription_link}\"><span>{subscription_link}</span></a><br />or you can login in our dedicated area here: <a href=\"{crm_url}/login\">{crm_url}/login</a> in case you want to update your credit card or view the subscriptions you are subscribed.<br /><br />Best Regards,<br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(76,'invoice','invoice-due-notice','english','Invoice Due Notice','Your {invoice_number} will be due soon','<span style=\"font-size: 12pt;\">Hi {contact_firstname} {contact_lastname}<br /><br /></span>You invoice <span style=\"font-size: 12pt;\"><strong># {invoice_number} </strong>will be due on <strong>{invoice_duedate}</strong></span><br /><br /><span style=\"font-size: 12pt;\">You can view the invoice on the following link: <a href=\"{invoice_link}\">{invoice_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Kind Regards,</span><br /><span style=\"font-size: 12pt;\">{email_signature}</span>','{companyname} | CRM','',0,1,0),(77,'estimate_request','estimate-request-submitted-to-staff','english','Estimate Request Submitted (Sent to Staff)','New Estimate Request Submitted','<span> Hello,&nbsp;</span><br /><br />{estimate_request_email} submitted an estimate request via the {estimate_request_form_name} form.<br /><br />You can view the request at the following link: <a href=\"{estimate_request_link}\">{estimate_request_link}</a><br /><br />==<br /><br />{estimate_request_submitted_data}<br /><br />Kind Regards,<br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(78,'estimate_request','estimate-request-assigned','english','Estimate Request Assigned (Sent to Staff)','New Estimate Request Assigned','<span> Hello {estimate_request_assigned},&nbsp;</span><br /><br />Estimate request #{estimate_request_id} has been assigned to you.<br /><br />You can view the request at the following link: <a href=\"{estimate_request_link}\">{estimate_request_link}</a><br /><br />Kind Regards,<br /><span>{email_signature}</span>','{companyname} | CRM','',0,1,0),(79,'estimate_request','estimate-request-received-to-user','english','Estimate Request Received (Sent to User)','Estimate Request Received','Hello,<br /><br /><strong>Your request has been received.</strong><br /><br />This email is to let you know that we received your request and we will get back to you as soon as possible with more information.<br /><br />Best Regards,<br />{email_signature}','{companyname} | CRM','',0,0,0),(80,'notifications','non-billed-tasks-reminder','english','Non-billed tasks reminder (sent to selected staff members)','Action required: Completed tasks are not billed','Hello {staff_firstname}<br><br>The following tasks are marked as complete but not yet billed:<br><br>{unbilled_tasks_list}<br><br>Kind Regards,<br><br>{email_signature}','{companyname} | CRM','',0,1,0),(81,'invoice','invoices-batch-payments','english','Invoices Payments Recorded in Batch (Sent to Customer)','We have received your payments','Hello {contact_firstname} {contact_lastname}<br><br>Thank you for the payments. Please find the payments details below:<br><br>{batch_payments_list}<br><br>We are looking forward working with you.<br><br>Kind Regards,<br><br>{email_signature}','{companyname} | CRM','',0,1,0),(82,'contract','contract-sign-reminder','english','Contract Sign Reminder (Sent to Customer)','Contract Sign Reminder','<p>Hello {contact_firstname} {contact_lastname}<br /><br />This is a reminder to review and sign the contract:<a href=\"{contract_link}\">{contract_subject}</a></p><p>You can view and sign by visiting: <a href=\"{contract_link}\">{contract_subject}</a></p><p><br />We are looking forward working with you.<br /><br />Kind Regards,<br /><br />{email_signature}</p>','{companyname} | CRM','',0,1,0),(83,'file_sharing','fs-share-staff','english','Shared to staff','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(84,'file_sharing','fs-share-client','english','Shared to client','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(85,'file_sharing','fs-share-public','english','Shared to public','File Sharing','<span></span><br /><br /><span>Have files that have just been shared with you: {share_link}.</span>','{companyname} | CRM',NULL,0,1,0),(86,'staff','flexstage-tickets-success','english','Flexstage Tickets Success','Tickets - {event_name}','Hi there! <br/><br/>Find the tickets you ordered for the {event_name} event below.<br/><br/> Venue: {venue} <br/><br/> Date/Time: {date_time} <br/><br/> <strong>Tickets</strong><br/> {ticket_details}<br/>Regards.','{companyname} | CRM',NULL,0,1,0),(87,'staff','flexstage-event-invitation','english','Flexstage Event Invitation','Invitation - {event_name}','Hi there! <br/><br/>You are hereby invited for {event_name}.<br/><br/> Venue: {venue} <br/><br/> Date/Time: {date_time} <br/><br/> You can register for the event here: {event_link}<br><br/>Regards.','{companyname} | CRM',NULL,0,1,0),(88,'inventory_warning','inventory-warning-to-staff','english','Inventory warning (Sent to staff)','Inventory warning','Hi {staff_name}! <br /><br />This is a inventory warning<br />{<span 12pt=\"\">notification_content</span>}. <br /><br />Regards.','{companyname} | CRM',NULL,0,1,0),(89,'purchase_order','purchase-order-to-contact','english','Purchase Order (Sent to contact)','Purchase Order','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Order information with the number {po_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {public_link}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(90,'purchase_order','purchase-request-to-contact','english','Purchase Request (Sent to contact)','Purchase Request','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Request information with the number {pr_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {public_link}<br/ >{additional_content}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(91,'purchase_order','purchase-quotation-to-contact','english','Purchase Quotation (Sent to contact)','Purchase Quotation','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Quotation information with the number {pq_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {quotation_link}<br/ >{additional_content}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(92,'purchase_order','debit-note-to-contact','english','Debit Note (Sent to contact)','Debit Note','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Debit Note information with the number {dn_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />{additional_content}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(93,'purchase_order','purchase-statement-to-contact','english','Purchase Statement (Sent to contact)','Purchase Statement','<span style=\\\"font-size: 12pt;\\\"> Dear {contact_firstname} {contact_lastname} !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\">Its been a great experience working with you. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Attached with this email is a list of all transactions for the period between {statement_from} to {statement_to}<br/ ><br/ >For your information your account balance due is total: {statement_balance_due}<br /><br/ > Please contact us if you need more information.<br/ > <br />{additional_content}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(94,'purchase_order','vendor-registration-confirmed','english','Vendor Registration Confirmed','Your registration is confirmed','<p>Dear {contact_firstname} {contact_lastname}<br /><br />We just wanted to let you know that your registration at&nbsp;{companyname} is successfully confirmed and your account is now active.<br /><br />You can login at&nbsp;<a href=\"{vendor_portal_url}\">{vendor_portal_url}</a> with the email and password you provided during registration.<br /><br />Please contact us if you need any help.<br /><br />Kind Regards, <br />{email_signature}</p>\n <p><br />(This is an automated email, so please dont reply to this email address)</p>','{companyname} | CRM',NULL,0,1,0),(95,'purchase_order','purchase-contract-to-contact','english','Purchase Contract (Sent to contact)','Purchase Contract','<span style=\\\"font-size: 12pt;\\\"> Hello !. </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> We would like to share with you a link of Purchase Contract information with the number {contract_number} </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Please click on the link to view information: {contract_link}\n  </span><br /><br />','{companyname} | CRM',NULL,0,1,0),(96,'purchase_order','new-contact-created','english','New Contact Added/Registered (Welcome Email)','New Contact Added/Registered (Welcome Email)','<span style=\\\"font-size: 12pt;\\\"> Dear {contact_firstname} {contact_lastname}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> Welcome to our system </span><br /><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to login: {vendor_portal_link}</span><br /></span><br />','{companyname} | CRM',NULL,0,1,0),(97,'purchase_order','purchase-request-approval','english','Request approval','Request approval','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> You receive an approval request: {link} from {from_staff_name}</span>','{companyname} | CRM',NULL,0,1,0),(98,'purchase_order','purchase-send-approved','english','Email send approved','Email send approved','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\">{type} has been approved by {by_staff_name} </span><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to view detail: {link} </span><br /></span><br />','{companyname} | CRM',NULL,0,1,0),(99,'purchase_order','purchase-send-rejected','english','Email send rejected','Email send rejected','<span style=\\\"font-size: 12pt;\\\"> Hello {staff_name}! </span><br /><br /><span style=\\\"font-size: 12pt;\\\"> {type} has been declined by {by_staff_name} </span><br /><span style=\\\"font-size: 12pt;\\\"><br />Click here to view detail: {link}  </span><br /></span><br />','{companyname} | CRM',NULL,0,1,0);

--
-- Table structure for table `toda_tblestimate_request_forms`
--

CREATE TABLE `toda_tblestimate_request_forms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `recaptcha` int DEFAULT NULL,
  `status` int NOT NULL,
  `submit_btn_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submit_btn_bg_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#84c529',
  `submit_btn_text_color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#ffffff',
  `success_submit_msg` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `submit_action` int DEFAULT '0',
  `submit_redirect_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `language` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateadded` datetime DEFAULT NULL,
  `notify_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `responsible` int DEFAULT NULL,
  `notify_request_submitted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblestimate_request_forms`
--


--
-- Table structure for table `toda_tblestimate_request_status`
--

CREATE TABLE `toda_tblestimate_request_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `statusorder` int DEFAULT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblestimate_request_status`
--

INSERT INTO `toda_tblestimate_request_status` VALUES (1,'Cancelled',1,'#808080','cancelled'),(2,'Processing',2,'#007bff','processing'),(3,'Completed',3,'#28a745','completed');

--
-- Table structure for table `toda_tblestimate_requests`
--

CREATE TABLE `toda_tblestimate_requests` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `submission` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `date_estimated` datetime DEFAULT NULL,
  `from_form_id` int DEFAULT NULL,
  `assigned` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `default_language` int NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblestimate_requests`
--


--
-- Table structure for table `toda_tblestimates`
--

CREATE TABLE `toda_tblestimates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `datesend` datetime DEFAULT NULL,
  `clientid` int NOT NULL,
  `deleted_customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project_id` int NOT NULL DEFAULT '0',
  `number` int NOT NULL,
  `prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int NOT NULL DEFAULT '0',
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `expirydate` date DEFAULT NULL,
  `currency` int NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoiceid` int DEFAULT NULL,
  `invoiced_date` datetime DEFAULT NULL,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_agent` int NOT NULL DEFAULT '0',
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_estimate` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `pipeline_order` int DEFAULT '1',
  `is_expiry_notified` int NOT NULL DEFAULT '0',
  `acceptance_firstname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acceptance_date` datetime DEFAULT NULL,
  `acceptance_ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `currency` (`currency`),
  KEY `project_id` (`project_id`),
  KEY `sale_agent` (`sale_agent`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblestimates`
--


--
-- Table structure for table `toda_tblevents`
--

CREATE TABLE `toda_tblevents` (
  `eventid` int NOT NULL AUTO_INCREMENT,
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `userid` int NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime DEFAULT NULL,
  `public` int NOT NULL DEFAULT '0',
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isstartnotified` tinyint(1) NOT NULL DEFAULT '0',
  `reminder_before` int NOT NULL DEFAULT '0',
  `reminder_before_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`eventid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblevents`
--


--
-- Table structure for table `toda_tblexpenses`
--

CREATE TABLE `toda_tblexpenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` int NOT NULL,
  `currency` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `tax` int DEFAULT NULL,
  `tax2` int NOT NULL DEFAULT '0',
  `reference_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `expense_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clientid` int NOT NULL,
  `project_id` int NOT NULL DEFAULT '0',
  `billable` int DEFAULT '0',
  `invoiceid` int DEFAULT NULL,
  `paymentmode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `recurring_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repeat_every` int DEFAULT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `custom_recurring` int NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  `create_invoice_billable` tinyint(1) DEFAULT NULL,
  `send_invoice_to_customer` tinyint(1) NOT NULL,
  `recurring_from` int DEFAULT NULL,
  `dateadded` datetime NOT NULL,
  `addedfrom` int NOT NULL,
  `vendor` int DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `date_paid` date DEFAULT NULL,
  `status` int DEFAULT NULL,
  `is_bill` int NOT NULL DEFAULT '0',
  `reason_for_void` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `voided` int NOT NULL DEFAULT '0',
  `approved` int NOT NULL DEFAULT '0',
  `from_fleet` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `category` (`category`),
  KEY `currency` (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblexpenses`
--


--
-- Table structure for table `toda_tblexpenses_categories`
--

CREATE TABLE `toda_tblexpenses_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblexpenses_categories`
--

INSERT INTO `toda_tblexpenses_categories` VALUES (1,'Fleet: Work Order',NULL);

--
-- Table structure for table `toda_tblfiles`
--

CREATE TABLE `toda_tblfiles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filetype` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible_to_customer` int NOT NULL DEFAULT '0',
  `attachment_key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `external_link` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `thumbnail_link` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'For external usage',
  `staffid` int NOT NULL,
  `contact_id` int DEFAULT '0',
  `task_comment_id` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblfiles`
--


--
-- Table structure for table `toda_tblfilter_defaults`
--

CREATE TABLE `toda_tblfilter_defaults` (
  `filter_id` int unsigned NOT NULL,
  `staff_id` int NOT NULL,
  `identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `view` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `filter_id` (`filter_id`),
  KEY `toda_staff_id` (`staff_id`),
  CONSTRAINT `toda_tblfilter_defaults_ibfk_1` FOREIGN KEY (`filter_id`) REFERENCES `toda_tblfilters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `toda_tblfilter_defaults_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `toda_tblstaff` (`staffid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblfilter_defaults`
--


--
-- Table structure for table `toda_tblfilters`
--

CREATE TABLE `toda_tblfilters` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `builder` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `staff_id` int unsigned NOT NULL,
  `identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_shared` tinyint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblfilters`
--


--
-- Table structure for table `toda_tblfleet_benefit_and_penalty`
--

CREATE TABLE `toda_tblfleet_benefit_and_penalty` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text,
  `criteria_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `type` text,
  `date` date DEFAULT NULL,
  `benefit_formality` text,
  `reward` decimal(15,2) DEFAULT NULL,
  `penalty_formality` text,
  `amount_of_damage` decimal(15,2) DEFAULT NULL,
  `amount_of_compensation` decimal(15,2) DEFAULT NULL,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_benefit_and_penalty`
--


--
-- Table structure for table `toda_tblfleet_bookings`
--

CREATE TABLE `toda_tblfleet_bookings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `contactid` int DEFAULT NULL,
  `userid` int DEFAULT NULL,
  `approved` int NOT NULL DEFAULT '0',
  `status` varchar(45) NOT NULL DEFAULT 'new',
  `delivery_date` date DEFAULT NULL,
  `phone` text NOT NULL,
  `receipt_address` text NOT NULL,
  `delivery_address` text NOT NULL,
  `note` text NOT NULL,
  `invoice_id` int NOT NULL DEFAULT '0',
  `admin_note` text,
  `number` text,
  `amount` decimal(15,2) NOT NULL DEFAULT '0.00',
  `invoice_hash` text,
  `rating` int NOT NULL DEFAULT '0',
  `comments` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_bookings`
--


--
-- Table structure for table `toda_tblfleet_criterias`
--

CREATE TABLE `toda_tblfleet_criterias` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_criterias`
--


--
-- Table structure for table `toda_tblfleet_driver_documents`
--

CREATE TABLE `toda_tblfleet_driver_documents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `driver_id` int NOT NULL DEFAULT '0',
  `subject` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `type` varchar(45) NOT NULL DEFAULT 'driver',
  `vehicle_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_driver_documents`
--


--
-- Table structure for table `toda_tblfleet_events`
--

CREATE TABLE `toda_tblfleet_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `event_type` text NOT NULL,
  `event_time` datetime NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_events`
--


--
-- Table structure for table `toda_tblfleet_fuel_history`
--

CREATE TABLE `toda_tblfleet_fuel_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `fuel_time` datetime NOT NULL,
  `odometer` int DEFAULT NULL,
  `gallons` text,
  `price` decimal(15,2) DEFAULT NULL,
  `fuel_type` text,
  `reference` text,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_fuel_history`
--


--
-- Table structure for table `toda_tblfleet_garages`
--

CREATE TABLE `toda_tblfleet_garages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `country` int NOT NULL DEFAULT '0',
  `city` varchar(100) DEFAULT NULL,
  `zip` varchar(15) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `address` text,
  `notes` text,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_garages`
--


--
-- Table structure for table `toda_tblfleet_inspection_forms`
--

CREATE TABLE `toda_tblfleet_inspection_forms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `color` text,
  `description` text,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `slug` text,
  `hash` text,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) DEFAULT NULL,
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspection_forms`
--


--
-- Table structure for table `toda_tblfleet_inspection_question_box`
--

CREATE TABLE `toda_tblfleet_inspection_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspection_question_box`
--


--
-- Table structure for table `toda_tblfleet_inspection_question_box_description`
--

CREATE TABLE `toda_tblfleet_inspection_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext NOT NULL,
  `boxid` mediumtext NOT NULL,
  `questionid` int NOT NULL,
  `is_fail` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspection_question_box_description`
--


--
-- Table structure for table `toda_tblfleet_inspection_question_forms`
--

CREATE TABLE `toda_tblfleet_inspection_question_forms` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `question` mediumtext NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspection_question_forms`
--


--
-- Table structure for table `toda_tblfleet_inspection_results`
--

CREATE TABLE `toda_tblfleet_inspection_results` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inspection_id` int DEFAULT NULL,
  `boxid` int DEFAULT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `questionid` int DEFAULT NULL,
  `answer` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspection_results`
--


--
-- Table structure for table `toda_tblfleet_inspections`
--

CREATE TABLE `toda_tblfleet_inspections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `inspection_form_id` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) DEFAULT NULL,
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `is_recurring_from` int NOT NULL DEFAULT '0',
  `last_recurring_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_inspections`
--


--
-- Table structure for table `toda_tblfleet_insurance_categories`
--

CREATE TABLE `toda_tblfleet_insurance_categories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_insurance_categories`
--


--
-- Table structure for table `toda_tblfleet_insurance_company`
--

CREATE TABLE `toda_tblfleet_insurance_company` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_insurance_company`
--


--
-- Table structure for table `toda_tblfleet_insurance_status`
--

CREATE TABLE `toda_tblfleet_insurance_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_insurance_status`
--


--
-- Table structure for table `toda_tblfleet_insurance_types`
--

CREATE TABLE `toda_tblfleet_insurance_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_insurance_types`
--


--
-- Table structure for table `toda_tblfleet_insurances`
--

CREATE TABLE `toda_tblfleet_insurances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `insurance_category_id` int DEFAULT NULL,
  `insurance_type_id` int DEFAULT NULL,
  `name` text,
  `status` text,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `description` text,
  `amount` decimal(15,2) NOT NULL,
  `insurance_company_id` int NOT NULL DEFAULT '0',
  `insurance_status_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_insurances`
--


--
-- Table structure for table `toda_tblfleet_logbooks`
--

CREATE TABLE `toda_tblfleet_logbooks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `booking_id` int DEFAULT NULL,
  `odometer` int DEFAULT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'new',
  `date` date DEFAULT NULL,
  `description` text,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_logbooks`
--


--
-- Table structure for table `toda_tblfleet_maintenance_teams`
--

CREATE TABLE `toda_tblfleet_maintenance_teams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int DEFAULT NULL,
  `garage_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_maintenance_teams`
--


--
-- Table structure for table `toda_tblfleet_maintenances`
--

CREATE TABLE `toda_tblfleet_maintenances` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int DEFAULT NULL,
  `supplier_id` int DEFAULT NULL,
  `maintenance_type` varchar(30) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `warranty_improvement` int NOT NULL DEFAULT '0',
  `start_date` date DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `cost` decimal(15,2) DEFAULT NULL,
  `notes` text,
  `date_creator` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `garage_id` int NOT NULL DEFAULT '0',
  `parts` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_maintenances`
--


--
-- Table structure for table `toda_tblfleet_part_groups`
--

CREATE TABLE `toda_tblfleet_part_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_part_groups`
--


--
-- Table structure for table `toda_tblfleet_part_histories`
--

CREATE TABLE `toda_tblfleet_part_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `part_id` int NOT NULL,
  `type` text NOT NULL,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `start_time` text,
  `end_time` text,
  `start_by` int DEFAULT NULL,
  `end_by` int DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_part_histories`
--


--
-- Table structure for table `toda_tblfleet_part_types`
--

CREATE TABLE `toda_tblfleet_part_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_part_types`
--


--
-- Table structure for table `toda_tblfleet_parts`
--

CREATE TABLE `toda_tblfleet_parts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `part_type_id` int DEFAULT NULL,
  `brand` text,
  `model` text,
  `serial_number` text,
  `vehicle_id` int NOT NULL DEFAULT '0',
  `driver_id` int NOT NULL DEFAULT '0',
  `part_group_id` int DEFAULT NULL,
  `status` text,
  `purchase_vendor` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT NULL,
  `warranty_expiration_date` date DEFAULT NULL,
  `purchase_comments` text,
  `in_service_date` date DEFAULT NULL,
  `estimated_service_life_in_months` int DEFAULT NULL,
  `estimated_resale_value` decimal(15,2) DEFAULT NULL,
  `out_of_service_date` date DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_parts`
--


--
-- Table structure for table `toda_tblfleet_time_cards`
--

CREATE TABLE `toda_tblfleet_time_cards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `logbook_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `start_time` text NOT NULL,
  `end_time` text NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_time_cards`
--


--
-- Table structure for table `toda_tblfleet_vehicle_assignments`
--

CREATE TABLE `toda_tblfleet_vehicle_assignments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `driver_id` int NOT NULL,
  `vehicle_id` int NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `starting_odometer` float DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `ending_odometer` float DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_vehicle_assignments`
--


--
-- Table structure for table `toda_tblfleet_vehicle_groups`
--

CREATE TABLE `toda_tblfleet_vehicle_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_vehicle_groups`
--


--
-- Table structure for table `toda_tblfleet_vehicle_histories`
--

CREATE TABLE `toda_tblfleet_vehicle_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vehicle_id` int NOT NULL,
  `type` text NOT NULL,
  `from_value` text,
  `to_value` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_vehicle_histories`
--


--
-- Table structure for table `toda_tblfleet_vehicle_types`
--

CREATE TABLE `toda_tblfleet_vehicle_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_vehicle_types`
--


--
-- Table structure for table `toda_tblfleet_vehicles`
--

CREATE TABLE `toda_tblfleet_vehicles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `vehicle_type_id` int DEFAULT NULL,
  `vehicle_group_id` int DEFAULT NULL,
  `status` text,
  `description` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `model` text,
  `year` text,
  `width` text,
  `height` text,
  `length` text,
  `interior_volume` text,
  `passenger_volume` text,
  `cargo_volume` text,
  `ground_clearance` text,
  `bed_length` text,
  `curb_weight` text,
  `gross_vehicle_weight_rating` text,
  `towing_capacity` text,
  `max_payload` text,
  `epa_city` text,
  `epa_highway` text,
  `epa_combined` text,
  `oil_capacity` text,
  `in_service_date` date DEFAULT NULL,
  `in_service_odometer` int DEFAULT NULL,
  `estimated_service_life_in_months` text,
  `estimated_service_life_in_meter` text,
  `estimated_resale_value` text,
  `out_of_service_date` date DEFAULT NULL,
  `out_of_service_odometer` int DEFAULT NULL,
  `vin` text,
  `license_plate` text,
  `make` text,
  `trim` text,
  `registration_state` text,
  `ownership` text,
  `color` text,
  `body_type` text,
  `body_subtype` text,
  `msrp` text,
  `purchase_vendor` int DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT NULL,
  `odometer` int DEFAULT NULL,
  `notes` text,
  `expiration_date` date DEFAULT NULL,
  `max_meter_value` text,
  `engine_summary` text,
  `engine_brand` text,
  `aspiration` text,
  `block_type` text,
  `bore` text,
  `cam_type` text,
  `compression` text,
  `cylinders` text,
  `displacement` text,
  `fuel_induction` text,
  `max_hp` text,
  `max_torque` text,
  `redline_rpm` text,
  `stroke` text,
  `valves` text,
  `transmission_summary` text,
  `transmission_brand` text,
  `transmission_type` text,
  `transmission_gears` text,
  `drive_type` text,
  `brake_system` text,
  `front_track_width` text,
  `rear_track_width` text,
  `wheelbase` text,
  `front_wheel_diameter` text,
  `rear_wheel_diameter` text,
  `rear_axle` text,
  `front_tire_type` text,
  `front_tire_psi` text,
  `rear_tire_type` text,
  `rear_tire_psi` text,
  `fuel_type` text,
  `fuel_quality` text,
  `fuel_tank_1_capacity` text,
  `fuel_tank_2_capacity` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_vehicles`
--


--
-- Table structure for table `toda_tblfleet_work_order_details`
--

CREATE TABLE `toda_tblfleet_work_order_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `work_order_id` int DEFAULT NULL,
  `part_id` int DEFAULT NULL,
  `item_name` text,
  `qty` int DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_work_order_details`
--


--
-- Table structure for table `toda_tblfleet_work_orders`
--

CREATE TABLE `toda_tblfleet_work_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` text NOT NULL,
  `number` text,
  `vehicle_id` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `vendor_id` int DEFAULT NULL,
  `invoice_id` int DEFAULT NULL,
  `purchase_order_id` int DEFAULT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'open',
  `issue_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `complete_date` date DEFAULT NULL,
  `odometer_in` int DEFAULT NULL,
  `odometer_out` int DEFAULT NULL,
  `total` decimal(15,2) DEFAULT NULL,
  `work_requested` text,
  `notes` text,
  `datecreated` datetime DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `expense_id` int NOT NULL DEFAULT '0',
  `parts` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleet_work_orders`
--


--
-- Table structure for table `toda_tblflexcategories`
--

CREATE TABLE `toda_tblflexcategories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `slug` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexcategories`
--


--
-- Table structure for table `toda_tblflexemaillists`
--

CREATE TABLE `toda_tblflexemaillists` (
  `listid` int NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `creator` varchar(100) NOT NULL,
  `datecreated` datetime NOT NULL,
  PRIMARY KEY (`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexemaillists`
--


--
-- Table structure for table `toda_tblflexevents`
--

CREATE TABLE `toda_tblflexevents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` mediumtext NOT NULL,
  `slug` mediumtext NOT NULL,
  `description` text,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `create_date` datetime NOT NULL,
  `auto_sync_attendees` tinyint(1) NOT NULL DEFAULT '0',
  `auto_add_to_calendar` tinyint(1) NOT NULL DEFAULT '0',
  `category_id` int NOT NULL,
  `summary` mediumtext,
  `type` mediumtext NOT NULL,
  `location` mediumtext,
  `event_link` mediumtext,
  `password` mediumtext,
  `longitude` double(15,12) DEFAULT NULL,
  `latitude` double(15,12) DEFAULT NULL,
  `privacy` mediumtext NOT NULL,
  `created_by` int NOT NULL,
  `tags` mediumtext,
  PRIMARY KEY (`id`),
  KEY `toda_category_event_fk` (`category_id`),
  CONSTRAINT `toda_category_event_fk` FOREIGN KEY (`category_id`) REFERENCES `toda_tblflexcategories` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexevents`
--


--
-- Table structure for table `toda_tblfleximages`
--

CREATE TABLE `toda_tblfleximages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `file_name` mediumtext NOT NULL,
  `original_file_name` mediumtext NOT NULL,
  `filetype` mediumtext NOT NULL,
  `dateadded` datetime NOT NULL,
  `uploaded_by` int NOT NULL,
  `subject` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `toda_event_image_fk` (`event_id`),
  CONSTRAINT `toda_event_image_fk` FOREIGN KEY (`event_id`) REFERENCES `toda_tblflexevents` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfleximages`
--


--
-- Table structure for table `toda_tblflexinvitationsemailsendcron`
--

CREATE TABLE `toda_tblflexinvitationsemailsendcron` (
  `id` int NOT NULL AUTO_INCREMENT,
  `eventid` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `emailid` int DEFAULT NULL,
  `listid` varchar(11) DEFAULT NULL,
  `log_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexinvitationsemailsendcron`
--


--
-- Table structure for table `toda_tblflexinvitationsendlog`
--

CREATE TABLE `toda_tblflexinvitationsendlog` (
  `id` int NOT NULL AUTO_INCREMENT,
  `eventid` int NOT NULL,
  `total` int NOT NULL,
  `date` datetime NOT NULL,
  `iscronfinished` int NOT NULL DEFAULT '0',
  `send_to_mail_lists` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexinvitationsendlog`
--


--
-- Table structure for table `toda_tblflexlistemails`
--

CREATE TABLE `toda_tblflexlistemails` (
  `emailid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexlistemails`
--


--
-- Table structure for table `toda_tblflexsocialchannels`
--

CREATE TABLE `toda_tblflexsocialchannels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `channel_id` mediumtext NOT NULL,
  `url` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `toda_event_socialchannel_fk` (`event_id`),
  CONSTRAINT `toda_event_socialchannel_fk` FOREIGN KEY (`event_id`) REFERENCES `toda_tblflexevents` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexsocialchannels`
--


--
-- Table structure for table `toda_tblflexspeakers`
--

CREATE TABLE `toda_tblflexspeakers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `name` mediumtext NOT NULL,
  `email` mediumtext NOT NULL,
  `image` mediumtext NOT NULL,
  `show` tinyint(1) DEFAULT '0',
  `bio` text,
  PRIMARY KEY (`id`),
  KEY `toda_event_speaker_fk` (`event_id`),
  CONSTRAINT `toda_event_speaker_fk` FOREIGN KEY (`event_id`) REFERENCES `toda_tblflexevents` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexspeakers`
--


--
-- Table structure for table `toda_tblflexticketorders`
--

CREATE TABLE `toda_tblflexticketorders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `eventid` int NOT NULL,
  `invoiceid` int DEFAULT NULL,
  `attendee_name` varchar(100) NOT NULL,
  `attendee_email` varchar(100) NOT NULL,
  `attendee_mobile` varchar(100) DEFAULT NULL,
  `attendee_company` varchar(100) DEFAULT NULL,
  `total_amount` double(15,3) NOT NULL DEFAULT '0.000',
  `tickets_sent` tinyint(1) NOT NULL DEFAULT '0',
  `in_leads` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexticketorders`
--


--
-- Table structure for table `toda_tblflextickets`
--

CREATE TABLE `toda_tblflextickets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `name` mediumtext NOT NULL,
  `status` mediumtext NOT NULL,
  `quantity` int NOT NULL,
  `paid` tinyint(1) DEFAULT '0',
  `currency` mediumtext,
  `price` double(15,3) DEFAULT NULL,
  `min_buying_limit` int DEFAULT NULL,
  `max_buying_limit` int DEFAULT NULL,
  `sales_start_date` datetime DEFAULT NULL,
  `sales_end_date` datetime DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  KEY `toda_event_ticket_fk` (`event_id`),
  CONSTRAINT `toda_event_ticket_fk` FOREIGN KEY (`event_id`) REFERENCES `toda_tblflexevents` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflextickets`
--


--
-- Table structure for table `toda_tblflexticketsales`
--

CREATE TABLE `toda_tblflexticketsales` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ticketorderid` int NOT NULL,
  `eventid` int NOT NULL,
  `ticketid` int NOT NULL,
  `reference_code` varchar(100) NOT NULL,
  `quantity` int NOT NULL,
  `sub_total` double(15,3) DEFAULT NULL,
  `checked_in` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexticketsales`
--


--
-- Table structure for table `toda_tblflexvideos`
--

CREATE TABLE `toda_tblflexvideos` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `url` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `toda_event_video_fk` (`event_id`),
  CONSTRAINT `toda_event_video_fk` FOREIGN KEY (`event_id`) REFERENCES `toda_tblflexevents` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblflexvideos`
--


--
-- Table structure for table `toda_tblfmlcustomfields`
--

CREATE TABLE `toda_tblfmlcustomfields` (
  `customfieldid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `fieldname` varchar(150) NOT NULL,
  `fieldslug` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfmlcustomfields`
--


--
-- Table structure for table `toda_tblfmlcustomfieldvalues`
--

CREATE TABLE `toda_tblfmlcustomfieldvalues` (
  `customfieldvalueid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `customfieldid` int NOT NULL,
  `emailid` int NOT NULL,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldvalueid`),
  KEY `listid` (`listid`),
  KEY `customfieldid` (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfmlcustomfieldvalues`
--


--
-- Table structure for table `toda_tblform_question_box`
--

CREATE TABLE `toda_tblform_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblform_question_box`
--


--
-- Table structure for table `toda_tblform_question_box_description`
--

CREATE TABLE `toda_tblform_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `boxid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblform_question_box_description`
--


--
-- Table structure for table `toda_tblform_questions`
--

CREATE TABLE `toda_tblform_questions` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblform_questions`
--


--
-- Table structure for table `toda_tblform_results`
--

CREATE TABLE `toda_tblform_results` (
  `resultid` int NOT NULL AUTO_INCREMENT,
  `boxid` int NOT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `questionid` int NOT NULL,
  `answer` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `resultsetid` int NOT NULL,
  PRIMARY KEY (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblform_results`
--


--
-- Table structure for table `toda_tblfs_downloads`
--

CREATE TABLE `toda_tblfs_downloads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hash_share` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(255) NOT NULL,
  `browser_name` varchar(45) DEFAULT NULL,
  `http_user_agent` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_downloads`
--


--
-- Table structure for table `toda_tblfs_file_overview`
--

CREATE TABLE `toda_tblfs_file_overview` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fileid` varchar(255) NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `path` text,
  `number` int NOT NULL DEFAULT '0',
  `created_at` varchar(11) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `hash` varchar(250) NOT NULL DEFAULT '',
  `dir` int NOT NULL DEFAULT '0',
  `hash_share` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_file_overview`
--

INSERT INTO `toda_tblfs_file_overview` VALUES (1,'1733147601','directory','Main File Sharing/labs-labs',0,'1','2024-12-02 13:53:21','2024-12-02 13:53:21','',1,'tNGqXv'),(2,'1733147602','directory','modules/file_sharing/uploads/Main File Sharing/labs-labs/Shared',0,'1','2024-12-02 13:53:22','2024-12-02 13:53:22','',1,'V8VDPz'),(3,'173314760285','directory','modules/file_sharing/uploads/Main File Sharing/.trash/labs-labs',0,'1','2024-12-02 13:53:22','2024-12-02 13:53:22','',1,'uWZl0r'),(4,'1733147609','directory','/var/www/html/tagrit/modules/file_sharing/uploads/Main File Sharing/labs-labs',0,'1','2024-12-02 13:53:29','2024-12-02 13:53:29','',1,'wVseGa'),(5,'173314760968','directory','modules/file_sharing/uploads/Main File Sharing/labs-labs/Shared',0,'1','2024-12-02 13:53:30','2024-12-02 13:53:30','',1,'hyJKvo');

--
-- Table structure for table `toda_tblfs_genenal_ip_share`
--

CREATE TABLE `toda_tblfs_genenal_ip_share` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parrent_id` varchar(11) NOT NULL,
  `ip_share` varchar(20) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_genenal_ip_share`
--


--
-- Table structure for table `toda_tblfs_setting_configuration`
--

CREATE TABLE `toda_tblfs_setting_configuration` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) DEFAULT NULL,
  `is_read` int NOT NULL DEFAULT '0',
  `is_upload` int NOT NULL DEFAULT '0',
  `is_download` int NOT NULL DEFAULT '0',
  `is_delete` int NOT NULL DEFAULT '0',
  `is_write` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `max_size` int NOT NULL DEFAULT '2',
  `min_size` int NOT NULL DEFAULT '1',
  `created_at` varchar(11) DEFAULT NULL,
  `inserted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_share` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_setting_configuration`
--


--
-- Table structure for table `toda_tblfs_setting_configuration_relationship`
--

CREATE TABLE `toda_tblfs_setting_configuration_relationship` (
  `id` int NOT NULL AUTO_INCREMENT,
  `configuration_id` int NOT NULL,
  `rel_type` varchar(45) NOT NULL,
  `rel_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_setting_configuration_relationship`
--


--
-- Table structure for table `toda_tblfs_sharing_relationship`
--

CREATE TABLE `toda_tblfs_sharing_relationship` (
  `id` int NOT NULL AUTO_INCREMENT,
  `share_id` int NOT NULL,
  `type` varchar(45) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_sharing_relationship`
--


--
-- Table structure for table `toda_tblfs_sharings`
--

CREATE TABLE `toda_tblfs_sharings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `is_read` int NOT NULL DEFAULT '0',
  `is_upload` int NOT NULL DEFAULT '0',
  `is_download` int NOT NULL DEFAULT '0',
  `is_delete` int NOT NULL DEFAULT '0',
  `is_write` int NOT NULL DEFAULT '0',
  `password` varchar(255) DEFAULT NULL,
  `expiration_date_apply` int DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `expiration_date_delete` int DEFAULT NULL,
  `download_limits_apply` int DEFAULT NULL,
  `download_limits` int DEFAULT NULL,
  `download_limits_delete` int DEFAULT NULL,
  `hash_share` varchar(255) DEFAULT NULL,
  `created_at` int NOT NULL,
  `type` varchar(45) NOT NULL,
  `inserted_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `isowner` tinyint DEFAULT NULL,
  `phash` text,
  `locked` tinyint DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `read` tinyint DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `ts` varchar(255) DEFAULT NULL,
  `write` tinyint DEFAULT NULL,
  `hash` text,
  `url` text,
  `has_been_deleted` int NOT NULL DEFAULT '0',
  `downloads` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblfs_sharings`
--


--
-- Table structure for table `toda_tblgdpr_requests`
--

CREATE TABLE `toda_tblgdpr_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clientid` int NOT NULL DEFAULT '0',
  `contact_id` int NOT NULL DEFAULT '0',
  `lead_id` int NOT NULL DEFAULT '0',
  `request_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_from` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblgdpr_requests`
--


--
-- Table structure for table `toda_tblgoals`
--

CREATE TABLE `toda_tblgoals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `goal_type` int NOT NULL,
  `contract_type` int NOT NULL DEFAULT '0',
  `achievement` int NOT NULL,
  `notify_when_fail` tinyint(1) NOT NULL DEFAULT '1',
  `notify_when_achieve` tinyint(1) NOT NULL DEFAULT '1',
  `notified` int NOT NULL DEFAULT '0',
  `staff_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoals`
--


--
-- Table structure for table `toda_tblgoods_delivery`
--

CREATE TABLE `toda_tblgoods_delivery` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rel_type` int DEFAULT NULL COMMENT 'type goods delivery',
  `rel_document` int DEFAULT NULL COMMENT 'document id of goods delivery',
  `customer_code` text,
  `customer_name` varchar(100) DEFAULT NULL,
  `to_` varchar(100) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `description` text COMMENT 'the reason delivery',
  `staff_id` int DEFAULT NULL COMMENT 'salesman',
  `date_c` date DEFAULT NULL,
  `date_add` date DEFAULT NULL,
  `goods_delivery_code` varchar(100) DEFAULT NULL COMMENT 'số chứng từ xuất kho',
  `warehouse_id` int DEFAULT NULL,
  `total_money` varchar(200) DEFAULT NULL,
  `approval` int DEFAULT '0' COMMENT 'status approval ',
  `addedfrom` int DEFAULT NULL,
  `total_discount` varchar(100) DEFAULT NULL,
  `after_discount` varchar(100) DEFAULT NULL,
  `invoice_id` varchar(100) DEFAULT NULL,
  `project` text,
  `type` text,
  `department` int DEFAULT NULL,
  `requester` int DEFAULT NULL,
  `invoice_no` text,
  `pr_order_id` int DEFAULT NULL,
  `type_of_delivery` varchar(100) DEFAULT 'total',
  `additional_discount` decimal(15,2) DEFAULT '0.00',
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `delivery_status` varchar(100) DEFAULT 'ready_for_packing',
  `shipping_fee` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_delivery`
--


--
-- Table structure for table `toda_tblgoods_delivery_detail`
--

CREATE TABLE `toda_tblgoods_delivery_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_delivery_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` text,
  `warehouse_id` text,
  `unit_id` text,
  `quantities` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `total_money` varchar(200) DEFAULT NULL,
  `note` text,
  `discount` varchar(100) DEFAULT NULL,
  `discount_money` varchar(100) DEFAULT NULL,
  `available_quantity` varchar(100) DEFAULT NULL,
  `tax_id` varchar(100) DEFAULT NULL,
  `total_after_discount` varchar(100) DEFAULT NULL,
  `expiry_date` text,
  `lot_number` text,
  `guarantee_period` text,
  `tax_rate` text,
  `tax_name` text,
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `packing_qty` decimal(15,2) DEFAULT '0.00',
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_delivery_detail`
--


--
-- Table structure for table `toda_tblgoods_delivery_invoices_pr_orders`
--

CREATE TABLE `toda_tblgoods_delivery_invoices_pr_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL COMMENT 'goods_delivery_id',
  `rel_type` int DEFAULT NULL COMMENT 'invoice_id or purchase order id',
  `type` varchar(100) DEFAULT NULL COMMENT 'invoice,  purchase_orders',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_delivery_invoices_pr_orders`
--


--
-- Table structure for table `toda_tblgoods_receipt`
--

CREATE TABLE `toda_tblgoods_receipt` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `supplier_code` varchar(100) DEFAULT NULL,
  `supplier_name` text,
  `deliver_name` text,
  `buyer_id` int DEFAULT NULL,
  `description` text,
  `pr_order_id` int DEFAULT NULL COMMENT 'code puchase request agree',
  `date_c` date DEFAULT NULL,
  `date_add` date DEFAULT NULL,
  `goods_receipt_code` varchar(100) DEFAULT NULL,
  `warehouse_id` int DEFAULT NULL,
  `total_tax_money` varchar(100) DEFAULT NULL,
  `total_goods_money` varchar(100) DEFAULT NULL,
  `value_of_inventory` varchar(100) DEFAULT NULL,
  `total_money` varchar(100) DEFAULT NULL COMMENT 'total_money = total_tax_money +total_goods_money ',
  `addedfrom` int DEFAULT NULL,
  `approval` int DEFAULT '0',
  `project` text,
  `type` text,
  `department` int DEFAULT NULL,
  `requester` int DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `invoice_no` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_receipt`
--


--
-- Table structure for table `toda_tblgoods_receipt_detail`
--

CREATE TABLE `toda_tblgoods_receipt_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_receipt_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` text,
  `warehouse_id` text,
  `unit_id` text,
  `quantities` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `tax` varchar(100) DEFAULT NULL,
  `tax_money` varchar(100) DEFAULT NULL,
  `goods_money` varchar(100) DEFAULT NULL,
  `date_manufacture` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `note` text,
  `discount` varchar(100) DEFAULT NULL,
  `discount_money` varchar(100) DEFAULT NULL,
  `lot_number` varchar(100) DEFAULT NULL,
  `tax_rate` text,
  `sub_total` decimal(15,2) DEFAULT '0.00',
  `tax_name` text,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_receipt_detail`
--


--
-- Table structure for table `toda_tblgoods_transaction_detail`
--

CREATE TABLE `toda_tblgoods_transaction_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `goods_receipt_id` int DEFAULT NULL COMMENT 'id_goods_receipt_id or goods_delivery_id',
  `goods_id` int NOT NULL COMMENT ' is id commodity',
  `old_quantity` varchar(100) DEFAULT NULL,
  `quantity` varchar(100) DEFAULT NULL,
  `date_add` datetime DEFAULT NULL,
  `commodity_id` int NOT NULL,
  `warehouse_id` text NOT NULL,
  `note` text,
  `status` int DEFAULT NULL COMMENT '1:Goods receipt note 2:Goods delivery note',
  `purchase_price` varchar(100) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `expiry_date` text,
  `lot_number` text,
  `from_stock_name` int DEFAULT NULL,
  `to_stock_name` int DEFAULT NULL,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`commodity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgoods_transaction_detail`
--


--
-- Table structure for table `toda_tblgroup_checklist`
--

CREATE TABLE `toda_tblgroup_checklist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `meta` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgroup_checklist`
--


--
-- Table structure for table `toda_tblgroup_checklist_allocation`
--

CREATE TABLE `toda_tblgroup_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `meta` varchar(100) DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblgroup_checklist_allocation`
--


--
-- Table structure for table `toda_tblhr_allocation_asset`
--

CREATE TABLE `toda_tblhr_allocation_asset` (
  `allocation_id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` int unsigned NOT NULL,
  `asset_name` varchar(100) DEFAULT NULL,
  `assets_amount` int unsigned NOT NULL,
  `status_allocation` int unsigned DEFAULT '0' COMMENT '1: Allocated 0: Unallocated',
  PRIMARY KEY (`allocation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_allocation_asset`
--


--
-- Table structure for table `toda_tblhr_allowance_type`
--

CREATE TABLE `toda_tblhr_allowance_type` (
  `type_id` int unsigned NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL,
  `allowance_val` decimal(15,2) NOT NULL,
  `taxable` tinyint(1) NOT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_allowance_type`
--


--
-- Table structure for table `toda_tblhr_checklist_allocation`
--

CREATE TABLE `toda_tblhr_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `group_id` int DEFAULT NULL,
  `status` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_checklist_allocation`
--


--
-- Table structure for table `toda_tblhr_contract_template`
--

CREATE TABLE `toda_tblhr_contract_template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text,
  `job_position` longtext,
  `content` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_contract_template`
--


--
-- Table structure for table `toda_tblhr_dependent_person`
--

CREATE TABLE `toda_tblhr_dependent_person` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staffid` int unsigned DEFAULT NULL,
  `dependent_name` varchar(100) DEFAULT NULL,
  `relationship` varchar(100) DEFAULT NULL,
  `dependent_bir` date DEFAULT NULL,
  `start_month` date DEFAULT NULL,
  `end_month` date DEFAULT NULL,
  `dependent_iden` varchar(20) NOT NULL,
  `reason` longtext,
  `status` int unsigned DEFAULT '0',
  `status_comment` longtext,
  PRIMARY KEY (`id`,`dependent_iden`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_dependent_person`
--


--
-- Table structure for table `toda_tblhr_education`
--

CREATE TABLE `toda_tblhr_education` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `programe_id` int DEFAULT NULL,
  `training_programs_name` text NOT NULL,
  `training_places` text,
  `training_time_from` datetime DEFAULT NULL,
  `training_time_to` datetime DEFAULT NULL,
  `date_create` datetime DEFAULT NULL,
  `training_result` varchar(150) DEFAULT NULL,
  `degree` varchar(150) DEFAULT NULL,
  `notes` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_education`
--


--
-- Table structure for table `toda_tblhr_group_checklist_allocation`
--

CREATE TABLE `toda_tblhr_group_checklist_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `meta` varchar(100) DEFAULT NULL,
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_group_checklist_allocation`
--


--
-- Table structure for table `toda_tblhr_job_p`
--

CREATE TABLE `toda_tblhr_job_p` (
  `job_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_name` varchar(100) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_job_p`
--


--
-- Table structure for table `toda_tblhr_job_position`
--

CREATE TABLE `toda_tblhr_job_position` (
  `position_id` int unsigned NOT NULL AUTO_INCREMENT,
  `position_name` varchar(200) NOT NULL,
  `job_position_description` text,
  `job_p_id` int unsigned NOT NULL,
  `position_code` varchar(50) DEFAULT NULL,
  `department_id` text,
  PRIMARY KEY (`position_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_job_position`
--


--
-- Table structure for table `toda_tblhr_jp_interview_training`
--

CREATE TABLE `toda_tblhr_jp_interview_training` (
  `training_process_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_position_id` longtext,
  `training_name` varchar(100) DEFAULT NULL,
  `training_type` int DEFAULT NULL,
  `description` text,
  `date_add` datetime DEFAULT NULL,
  `position_training_id` text,
  `mint_point` int DEFAULT NULL,
  `additional_training` varchar(100) DEFAULT '',
  `staff_id` text,
  `time_to_start` date DEFAULT NULL,
  `time_to_end` date DEFAULT NULL,
  PRIMARY KEY (`training_process_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_jp_interview_training`
--


--
-- Table structure for table `toda_tblhr_jp_salary_scale`
--

CREATE TABLE `toda_tblhr_jp_salary_scale` (
  `salary_scale_id` int unsigned NOT NULL AUTO_INCREMENT,
  `job_position_id` int unsigned NOT NULL,
  `rel_type` varchar(100) DEFAULT NULL COMMENT 'salary:allowance:insurance',
  `rel_id` int DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`salary_scale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_jp_salary_scale`
--


--
-- Table structure for table `toda_tblhr_knowedge_base_article_feedback`
--

CREATE TABLE `toda_tblhr_knowedge_base_article_feedback` (
  `articleanswerid` int NOT NULL AUTO_INCREMENT,
  `articleid` int NOT NULL,
  `answer` int NOT NULL,
  `ip` varchar(40) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`articleanswerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_knowedge_base_article_feedback`
--


--
-- Table structure for table `toda_tblhr_knowledge_base`
--

CREATE TABLE `toda_tblhr_knowledge_base` (
  `articleid` int NOT NULL AUTO_INCREMENT,
  `articlegroup` int NOT NULL,
  `subject` mediumtext NOT NULL,
  `description` text NOT NULL,
  `slug` mediumtext NOT NULL,
  `active` tinyint NOT NULL,
  `datecreated` datetime NOT NULL,
  `article_order` int NOT NULL DEFAULT '0',
  `staff_article` int NOT NULL DEFAULT '0',
  `question_answers` int DEFAULT '0',
  `file_name` varchar(255) DEFAULT '',
  `curator` varchar(11) DEFAULT '',
  `benchmark` int DEFAULT '0',
  `score` int DEFAULT '0',
  PRIMARY KEY (`articleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_knowledge_base`
--


--
-- Table structure for table `toda_tblhr_knowledge_base_groups`
--

CREATE TABLE `toda_tblhr_knowledge_base_groups` (
  `groupid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `group_slug` text,
  `description` mediumtext,
  `active` tinyint NOT NULL,
  `color` varchar(10) DEFAULT '#28B8DA',
  `group_order` int DEFAULT '0',
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_knowledge_base_groups`
--


--
-- Table structure for table `toda_tblhr_list_staff_quitting_work`
--

CREATE TABLE `toda_tblhr_list_staff_quitting_work` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staffid` int DEFAULT NULL,
  `staff_name` text,
  `department_name` text,
  `role_name` text,
  `email` text,
  `dateoff` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `approval` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_list_staff_quitting_work`
--


--
-- Table structure for table `toda_tblhr_p_t_form_question_box`
--

CREATE TABLE `toda_tblhr_p_t_form_question_box` (
  `boxid` int NOT NULL AUTO_INCREMENT,
  `boxtype` varchar(10) NOT NULL,
  `questionid` int NOT NULL,
  PRIMARY KEY (`boxid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_p_t_form_question_box`
--


--
-- Table structure for table `toda_tblhr_p_t_form_question_box_description`
--

CREATE TABLE `toda_tblhr_p_t_form_question_box_description` (
  `questionboxdescriptionid` int NOT NULL AUTO_INCREMENT,
  `description` mediumtext NOT NULL,
  `boxid` mediumtext NOT NULL,
  `questionid` int NOT NULL,
  `correct` int DEFAULT '1' COMMENT '0: correct 1: incorrect',
  PRIMARY KEY (`questionboxdescriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_p_t_form_question_box_description`
--


--
-- Table structure for table `toda_tblhr_p_t_form_results`
--

CREATE TABLE `toda_tblhr_p_t_form_results` (
  `resultid` int NOT NULL AUTO_INCREMENT,
  `boxid` int NOT NULL,
  `boxdescriptionid` int DEFAULT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `questionid` int NOT NULL,
  `answer` text,
  `resultsetid` int NOT NULL,
  PRIMARY KEY (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_p_t_form_results`
--


--
-- Table structure for table `toda_tblhr_p_t_surveyresultsets`
--

CREATE TABLE `toda_tblhr_p_t_surveyresultsets` (
  `resultsetid` int NOT NULL AUTO_INCREMENT,
  `trainingid` int NOT NULL,
  `ip` varchar(40) NOT NULL,
  `useragent` varchar(150) NOT NULL,
  `date` datetime NOT NULL,
  `staff_id` int unsigned NOT NULL,
  PRIMARY KEY (`resultsetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_p_t_surveyresultsets`
--


--
-- Table structure for table `toda_tblhr_position_training`
--

CREATE TABLE `toda_tblhr_position_training` (
  `training_id` int NOT NULL AUTO_INCREMENT,
  `subject` mediumtext NOT NULL,
  `training_type` int unsigned NOT NULL,
  `slug` mediumtext NOT NULL,
  `description` text,
  `viewdescription` text,
  `datecreated` datetime NOT NULL,
  `redirect_url` varchar(100) DEFAULT NULL,
  `send` tinyint(1) NOT NULL DEFAULT '0',
  `onlyforloggedin` int DEFAULT '0',
  `fromname` varchar(100) DEFAULT NULL,
  `iprestrict` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `hash` varchar(32) NOT NULL,
  `mint_point` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`training_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_position_training`
--


--
-- Table structure for table `toda_tblhr_position_training_question_form`
--

CREATE TABLE `toda_tblhr_position_training_question_form` (
  `questionid` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) DEFAULT NULL,
  `question` mediumtext NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `question_order` int NOT NULL,
  `point` int NOT NULL,
  PRIMARY KEY (`questionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_position_training_question_form`
--


--
-- Table structure for table `toda_tblhr_procedure_retire`
--

CREATE TABLE `toda_tblhr_procedure_retire` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_name` text,
  `option_name` text,
  `status` int DEFAULT '1',
  `people_handle_id` int NOT NULL,
  `procedure_retire_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_procedure_retire`
--


--
-- Table structure for table `toda_tblhr_procedure_retire_manage`
--

CREATE TABLE `toda_tblhr_procedure_retire_manage` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name_procedure_retire` text NOT NULL,
  `department` varchar(250) NOT NULL,
  `datecreator` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_procedure_retire_manage`
--


--
-- Table structure for table `toda_tblhr_procedure_retire_of_staff`
--

CREATE TABLE `toda_tblhr_procedure_retire_of_staff` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int DEFAULT NULL,
  `option_name` text,
  `status` int DEFAULT '0',
  `staffid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_procedure_retire_of_staff`
--


--
-- Table structure for table `toda_tblhr_procedure_retire_of_staff_by_id`
--

CREATE TABLE `toda_tblhr_procedure_retire_of_staff_by_id` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_name` text,
  `people_handle_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_procedure_retire_of_staff_by_id`
--


--
-- Table structure for table `toda_tblhr_profile_option`
--

CREATE TABLE `toda_tblhr_profile_option` (
  `option_id` int unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(200) NOT NULL,
  `option_val` longtext,
  `auto` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`option_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_profile_option`
--

INSERT INTO `toda_tblhr_profile_option` VALUES (1,'job_position_prefix','#JOB',1),(2,'job_position_number','1',1),(3,'contract_code_prefix','#CONTRACT',1),(4,'contract_code_number','1',1),(5,'staff_code_prefix','EC',1),(6,'staff_code_number','1',1);

--
-- Table structure for table `toda_tblhr_rec_transfer_records`
--

CREATE TABLE `toda_tblhr_rec_transfer_records` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staffid` int NOT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `gender` varchar(11) DEFAULT NULL,
  `staff_identifi` varchar(20) DEFAULT NULL,
  `creator` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_rec_transfer_records`
--


--
-- Table structure for table `toda_tblhr_salary_form`
--

CREATE TABLE `toda_tblhr_salary_form` (
  `form_id` int unsigned NOT NULL AUTO_INCREMENT,
  `form_name` varchar(200) NOT NULL,
  `salary_val` decimal(15,2) NOT NULL,
  `tax` tinyint(1) NOT NULL,
  PRIMARY KEY (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_salary_form`
--


--
-- Table structure for table `toda_tblhr_staff_contract`
--

CREATE TABLE `toda_tblhr_staff_contract` (
  `id_contract` int unsigned NOT NULL AUTO_INCREMENT,
  `contract_code` varchar(200) NOT NULL,
  `name_contract` int NOT NULL,
  `staff` int NOT NULL,
  `start_valid` date DEFAULT NULL,
  `end_valid` date DEFAULT NULL,
  `contract_status` varchar(100) DEFAULT NULL,
  `sign_day` date DEFAULT NULL,
  `staff_delegate` int DEFAULT NULL,
  `hourly_or_month` longtext,
  `content` longtext,
  `hash` varchar(32) DEFAULT NULL,
  `signature` varchar(40) DEFAULT NULL,
  `signer` int DEFAULT NULL,
  `staff_signature` varchar(40) DEFAULT NULL,
  `staff_sign_day` date DEFAULT NULL,
  PRIMARY KEY (`id_contract`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_staff_contract`
--


--
-- Table structure for table `toda_tblhr_staff_contract_detail`
--

CREATE TABLE `toda_tblhr_staff_contract_detail` (
  `contract_detail_id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_contract_id` int unsigned NOT NULL,
  `type` text,
  `rel_type` text,
  `rel_value` decimal(15,2) DEFAULT '0.00',
  `since_date` date DEFAULT NULL,
  `contract_note` text,
  PRIMARY KEY (`contract_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_staff_contract_detail`
--


--
-- Table structure for table `toda_tblhr_staff_contract_type`
--

CREATE TABLE `toda_tblhr_staff_contract_type` (
  `id_contracttype` int unsigned NOT NULL AUTO_INCREMENT,
  `name_contracttype` varchar(200) NOT NULL,
  `description` longtext,
  `duration` int DEFAULT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `insurance` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id_contracttype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_staff_contract_type`
--


--
-- Table structure for table `toda_tblhr_training_allocation`
--

CREATE TABLE `toda_tblhr_training_allocation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_process_id` varchar(100) NOT NULL,
  `staffid` int DEFAULT NULL,
  `training_type` int DEFAULT NULL,
  `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `training_name` varchar(150) DEFAULT NULL,
  `jp_interview_training_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_training_allocation`
--


--
-- Table structure for table `toda_tblhr_type_of_trainings`
--

CREATE TABLE `toda_tblhr_type_of_trainings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_type_of_trainings`
--

INSERT INTO `toda_tblhr_type_of_trainings` VALUES (1,'Basic training');

--
-- Table structure for table `toda_tblhr_views_tracking`
--

CREATE TABLE `toda_tblhr_views_tracking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(40) NOT NULL,
  `date` datetime NOT NULL,
  `view_ip` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_views_tracking`
--


--
-- Table structure for table `toda_tblhr_workplace`
--

CREATE TABLE `toda_tblhr_workplace` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `workplace_address` varchar(400) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `default` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblhr_workplace`
--


--
-- Table structure for table `toda_tblinternal_delivery_note`
--

CREATE TABLE `toda_tblinternal_delivery_note` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `internal_delivery_name` text,
  `description` text,
  `staff_id` int DEFAULT NULL,
  `date_c` date DEFAULT NULL,
  `date_add` date DEFAULT NULL,
  `internal_delivery_code` varchar(100) DEFAULT NULL,
  `approval` int DEFAULT '0' COMMENT 'status approval ',
  `addedfrom` int DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `datecreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblinternal_delivery_note`
--


--
-- Table structure for table `toda_tblinternal_delivery_note_detail`
--

CREATE TABLE `toda_tblinternal_delivery_note_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `internal_delivery_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `from_stock_name` text,
  `to_stock_name` text,
  `unit_id` text,
  `available_quantity` text,
  `quantities` text,
  `unit_price` varchar(100) DEFAULT NULL,
  `into_money` varchar(100) DEFAULT NULL,
  `note` text,
  `commodity_name` text,
  `serial_number` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblinternal_delivery_note_detail`
--


--
-- Table structure for table `toda_tblinventory_commodity_min`
--

CREATE TABLE `toda_tblinventory_commodity_min` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int NOT NULL,
  `commodity_code` varchar(100) DEFAULT NULL,
  `commodity_name` varchar(100) DEFAULT NULL,
  `inventory_number_min` varchar(100) DEFAULT NULL,
  `inventory_number_max` varchar(100) DEFAULT '0',
  PRIMARY KEY (`id`,`commodity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblinventory_commodity_min`
--


--
-- Table structure for table `toda_tblinventory_manage`
--

CREATE TABLE `toda_tblinventory_manage` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `warehouse_id` int NOT NULL,
  `commodity_id` int NOT NULL,
  `inventory_number` varchar(100) DEFAULT NULL,
  `date_manufacture` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `lot_number` varchar(100) DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`,`commodity_id`,`warehouse_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblinventory_manage`
--


--
-- Table structure for table `toda_tblinvoicepaymentrecords`
--

CREATE TABLE `toda_tblinvoicepaymentrecords` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoiceid` int NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `paymentmode` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paymentmethod` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `daterecorded` datetime NOT NULL,
  `note` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transactionid` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `invoiceid` (`invoiceid`),
  KEY `paymentmethod` (`paymentmethod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblinvoicepaymentrecords`
--


--
-- Table structure for table `toda_tblinvoices`
--

CREATE TABLE `toda_tblinvoices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `datesend` datetime DEFAULT NULL,
  `clientid` int NOT NULL,
  `deleted_customer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int NOT NULL,
  `prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_format` int NOT NULL DEFAULT '0',
  `datecreated` datetime NOT NULL,
  `date` date NOT NULL,
  `duedate` date DEFAULT NULL,
  `currency` int NOT NULL,
  `subtotal` decimal(15,2) NOT NULL,
  `total_tax` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total` decimal(15,2) NOT NULL,
  `adjustment` decimal(15,2) DEFAULT NULL,
  `addedfrom` int DEFAULT NULL,
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int DEFAULT '1',
  `clientnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `adminnote` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_overdue_reminder` date DEFAULT NULL,
  `last_due_reminder` date DEFAULT NULL,
  `cancel_overdue_reminders` int NOT NULL DEFAULT '0',
  `allowed_payment_modes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `token` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `discount_percent` decimal(15,2) DEFAULT '0.00',
  `discount_total` decimal(15,2) DEFAULT '0.00',
  `discount_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `recurring` int NOT NULL DEFAULT '0',
  `recurring_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_recurring` tinyint(1) NOT NULL DEFAULT '0',
  `cycles` int NOT NULL DEFAULT '0',
  `total_cycles` int NOT NULL DEFAULT '0',
  `is_recurring_from` int DEFAULT NULL,
  `last_recurring_date` date DEFAULT NULL,
  `terms` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sale_agent` int NOT NULL DEFAULT '0',
  `billing_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `billing_country` int DEFAULT NULL,
  `shipping_street` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_country` int DEFAULT NULL,
  `include_shipping` tinyint(1) NOT NULL,
  `show_shipping_on_invoice` tinyint(1) NOT NULL DEFAULT '1',
  `show_quantity_as` int NOT NULL DEFAULT '1',
  `project_id` int DEFAULT '0',
  `subscription_id` int NOT NULL DEFAULT '0',
  `perfex_saas_packageid` int DEFAULT NULL,
  `short_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_fleet` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `currency` (`currency`),
  KEY `clientid` (`clientid`),
  KEY `project_id` (`project_id`),
  KEY `sale_agent` (`sale_agent`),
  KEY `total` (`total`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblinvoices`
--


--
-- Table structure for table `toda_tblitem_tax`
--

CREATE TABLE `toda_tblitem_tax` (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemid` int NOT NULL,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxrate` decimal(15,2) NOT NULL,
  `taxname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `itemid` (`itemid`),
  KEY `rel_id` (`rel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblitem_tax`
--


--
-- Table structure for table `toda_tblitemable`
--

CREATE TABLE `toda_tblitemable` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `long_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `qty` decimal(15,2) NOT NULL,
  `rate` decimal(15,2) NOT NULL,
  `unit` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_order` int DEFAULT NULL,
  `wh_delivered_quantity` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`),
  KEY `qty` (`qty`),
  KEY `rate` (`rate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblitemable`
--


--
-- Table structure for table `toda_tblitems`
--

CREATE TABLE `toda_tblitems` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `long_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rate` decimal(15,2) NOT NULL,
  `tax` int DEFAULT NULL,
  `tax2` int DEFAULT NULL,
  `unit` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_id` int NOT NULL DEFAULT '0',
  `commodity_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `commodity_barcode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `unit_id` int DEFAULT NULL,
  `sku_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_price` decimal(15,2) DEFAULT NULL,
  `sub_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` int DEFAULT '1',
  `parent_id` int DEFAULT NULL,
  `attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `parent_attributes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `can_be_sold` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'can_be_sold',
  `can_be_purchased` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'can_be_purchased',
  `can_be_manufacturing` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'can_be_manufacturing',
  `can_be_inventory` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'can_be_inventory',
  `from_vendor_item` int DEFAULT NULL,
  `guarantee` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `profif_ratio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `long_descriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `without_checking_warehouse` int DEFAULT '0',
  `series_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `warehouse_id` int DEFAULT NULL,
  `origin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_id` int DEFAULT NULL,
  `style_id` int DEFAULT NULL,
  `model_id` int DEFAULT NULL,
  `size_id` int DEFAULT NULL,
  `commodity_type` int DEFAULT NULL,
  `commodity_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `tax` (`tax`),
  KEY `tax2` (`tax2`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblitems`
--


--
-- Table structure for table `toda_tblitems_groups`
--

CREATE TABLE `toda_tblitems_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `commodity_group_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `display` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblitems_groups`
--

INSERT INTO `toda_tblitems_groups` VALUES (1,'Fleet: Parts','FLEET_PARTS',10,1,'');

--
-- Table structure for table `toda_tblitems_of_vendor`
--

CREATE TABLE `toda_tblitems_of_vendor` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `vendor_id` int NOT NULL,
  `description` text NOT NULL,
  `long_description` text,
  `rate` decimal(15,2) DEFAULT NULL,
  `tax` int DEFAULT NULL,
  `tax2` int DEFAULT NULL,
  `unit` varchar(40) DEFAULT NULL,
  `group_id` int NOT NULL,
  `commodity_code` varchar(100) NOT NULL,
  `commodity_barcode` text,
  `unit_id` int DEFAULT NULL,
  `sku_code` varchar(200) DEFAULT NULL,
  `sku_name` varchar(200) DEFAULT NULL,
  `sub_group` varchar(200) DEFAULT NULL,
  `active` int DEFAULT NULL,
  `parent` int DEFAULT NULL,
  `attributes` longtext,
  `parent_attributes` longtext,
  `commodity_type` int DEFAULT NULL,
  `origin` varchar(100) DEFAULT NULL,
  `commodity_name` varchar(200) NOT NULL,
  `series_id` text,
  `long_descriptions` longtext,
  `share_status` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblitems_of_vendor`
--


--
-- Table structure for table `toda_tblknowedge_base_article_feedback`
--

CREATE TABLE `toda_tblknowedge_base_article_feedback` (
  `articleanswerid` int NOT NULL AUTO_INCREMENT,
  `articleid` int NOT NULL,
  `answer` int NOT NULL,
  `ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`articleanswerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblknowedge_base_article_feedback`
--


--
-- Table structure for table `toda_tblknowledge_base`
--

CREATE TABLE `toda_tblknowledge_base` (
  `articleid` int NOT NULL AUTO_INCREMENT,
  `articlegroup` int NOT NULL,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint NOT NULL,
  `datecreated` datetime NOT NULL,
  `article_order` int NOT NULL DEFAULT '0',
  `staff_article` int NOT NULL DEFAULT '0',
  `question_answers` int DEFAULT '0',
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `curator` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `benchmark` int DEFAULT '0',
  `score` int DEFAULT '0',
  PRIMARY KEY (`articleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblknowledge_base`
--


--
-- Table structure for table `toda_tblknowledge_base_groups`
--

CREATE TABLE `toda_tblknowledge_base_groups` (
  `groupid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `group_slug` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `active` tinyint NOT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#28B8DA',
  `group_order` int DEFAULT '0',
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblknowledge_base_groups`
--


--
-- Table structure for table `toda_tbllead_activity_log`
--

CREATE TABLE `toda_tbllead_activity_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `leadid` int NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `additional_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` datetime NOT NULL,
  `staffid` int NOT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_activity` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tbllead_activity_log`
--


--
-- Table structure for table `toda_tbllead_integration_emails`
--

CREATE TABLE `toda_tbllead_integration_emails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dateadded` datetime NOT NULL,
  `leadid` int NOT NULL,
  `emailid` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tbllead_integration_emails`
--


--
-- Table structure for table `toda_tblleads`
--

CREATE TABLE `toda_tblleads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hash` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country` int NOT NULL DEFAULT '0',
  `zip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned` int NOT NULL DEFAULT '0',
  `dateadded` datetime NOT NULL,
  `from_form_id` int NOT NULL DEFAULT '0',
  `status` int NOT NULL,
  `source` int NOT NULL,
  `lastcontact` datetime DEFAULT NULL,
  `dateassigned` date DEFAULT NULL,
  `last_status_change` datetime DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leadorder` int DEFAULT '1',
  `phonenumber` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_converted` datetime DEFAULT NULL,
  `lost` tinyint(1) NOT NULL DEFAULT '0',
  `junk` int NOT NULL DEFAULT '0',
  `last_lead_status` int NOT NULL DEFAULT '0',
  `is_imported_from_email_integration` tinyint(1) NOT NULL DEFAULT '0',
  `email_integration_uid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `default_language` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_id` int NOT NULL DEFAULT '0',
  `lead_value` decimal(15,2) DEFAULT NULL,
  `vat` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `company` (`company`),
  KEY `email` (`email`),
  KEY `assigned` (`assigned`),
  KEY `status` (`status`),
  KEY `source` (`source`),
  KEY `lastcontact` (`lastcontact`),
  KEY `dateadded` (`dateadded`),
  KEY `leadorder` (`leadorder`),
  KEY `from_form_id` (`from_form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblleads`
--


--
-- Table structure for table `toda_tblleads_email_integration`
--

CREATE TABLE `toda_tblleads_email_integration` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'the ID always must be 1',
  `active` int NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `imap_server` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `check_every` int NOT NULL DEFAULT '5',
  `responsible` int NOT NULL,
  `lead_source` int NOT NULL,
  `lead_status` int NOT NULL,
  `encryption` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `folder` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_run` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_lead_imported` tinyint(1) NOT NULL DEFAULT '1',
  `notify_lead_contact_more_times` tinyint(1) NOT NULL DEFAULT '1',
  `notify_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notify_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mark_public` int NOT NULL DEFAULT '0',
  `only_loop_on_unseen_emails` tinyint(1) NOT NULL DEFAULT '1',
  `delete_after_import` int NOT NULL DEFAULT '0',
  `create_task_if_customer` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblleads_email_integration`
--

INSERT INTO `toda_tblleads_email_integration` VALUES (1,0,'','','',10,0,0,0,'tls','INBOX','',1,1,'assigned','',0,1,0,1);

--
-- Table structure for table `toda_tblleads_sources`
--

CREATE TABLE `toda_tblleads_sources` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblleads_sources`
--

INSERT INTO `toda_tblleads_sources` VALUES (2,'Facebook'),(3,'Flexstage Events'),(1,'Google');

--
-- Table structure for table `toda_tblleads_status`
--

CREATE TABLE `toda_tblleads_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `statusorder` int DEFAULT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '#28B8DA',
  `isdefault` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblleads_status`
--

INSERT INTO `toda_tblleads_status` VALUES (1,'Customer',1000,'#7cb342',1),(2,'Event Attendees',2,'#28B8DA',0);

--
-- Table structure for table `toda_tbllistemails`
--

CREATE TABLE `toda_tbllistemails` (
  `emailid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tbllistemails`
--


--
-- Table structure for table `toda_tblmail_queue`
--

CREATE TABLE `toda_tblmail_queue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `engine` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bcc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','sending','sent','failed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `headers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblmail_queue`
--


--
-- Table structure for table `toda_tblmaillistscustomfields`
--

CREATE TABLE `toda_tblmaillistscustomfields` (
  `customfieldid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `fieldname` varchar(150) NOT NULL,
  `fieldslug` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblmaillistscustomfields`
--


--
-- Table structure for table `toda_tblmaillistscustomfieldvalues`
--

CREATE TABLE `toda_tblmaillistscustomfieldvalues` (
  `customfieldvalueid` int NOT NULL AUTO_INCREMENT,
  `listid` int NOT NULL,
  `customfieldid` int NOT NULL,
  `emailid` int NOT NULL,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`customfieldvalueid`),
  KEY `listid` (`listid`),
  KEY `customfieldid` (`customfieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `toda_tblmaillistscustomfieldvalues`
--


--
-- Table structure for table `toda_tblmigrations`
--

CREATE TABLE `toda_tblmigrations` (
  `version` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblmigrations`
--

INSERT INTO `toda_tblmigrations` VALUES (316);

--
-- Table structure for table `toda_tblmilestones`
--

CREATE TABLE `toda_tblmilestones` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description_visible_to_customer` tinyint(1) DEFAULT '0',
  `start_date` date DEFAULT NULL,
  `due_date` date NOT NULL,
  `project_id` int NOT NULL,
  `color` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `milestone_order` int NOT NULL DEFAULT '0',
  `datecreated` date NOT NULL,
  `hide_from_customer` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblmilestones`
--


--
-- Table structure for table `toda_tblmodules`
--

CREATE TABLE `toda_tblmodules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `module_name` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `installed_version` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblmodules`
--

INSERT INTO `toda_tblmodules` VALUES (1,'accounting','1.3.0',1),(2,'menu_setup_client','1.0.1',1),(3,'courier','1.0',1),(4,'exports','1.0.0',1),(5,'file_sharing','1.1.0',1),(6,'fleet','1.0.0',1),(7,'flexstage','1.0.2',1),(8,'goals','2.3.0',1),(9,'hr_profile','1.0.7',1),(10,'menu_setup','2.3.0',1),(11,'purchase','1.5.0',1),(12,'surveys','2.3.0',1),(13,'theme_style','2.3.0',1),(14,'warehouse','1.3.9',1);

--
-- Table structure for table `toda_tblnewsfeed_comment_likes`
--

CREATE TABLE `toda_tblnewsfeed_comment_likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `postid` int NOT NULL,
  `commentid` int NOT NULL,
  `userid` int NOT NULL,
  `dateliked` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnewsfeed_comment_likes`
--


--
-- Table structure for table `toda_tblnewsfeed_post_comments`
--

CREATE TABLE `toda_tblnewsfeed_post_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `userid` int NOT NULL,
  `postid` int NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnewsfeed_post_comments`
--


--
-- Table structure for table `toda_tblnewsfeed_post_likes`
--

CREATE TABLE `toda_tblnewsfeed_post_likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `postid` int NOT NULL,
  `userid` int NOT NULL,
  `dateliked` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnewsfeed_post_likes`
--


--
-- Table structure for table `toda_tblnewsfeed_posts`
--

CREATE TABLE `toda_tblnewsfeed_posts` (
  `postid` int NOT NULL AUTO_INCREMENT,
  `creator` int NOT NULL,
  `datecreated` datetime NOT NULL,
  `visibility` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pinned` int NOT NULL,
  `datepinned` datetime DEFAULT NULL,
  PRIMARY KEY (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnewsfeed_posts`
--


--
-- Table structure for table `toda_tblnotes`
--

CREATE TABLE `toda_tblnotes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rel_id` int NOT NULL,
  `rel_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_contacted` datetime DEFAULT NULL,
  `addedfrom` int NOT NULL,
  `dateadded` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `rel_id` (`rel_id`),
  KEY `rel_type` (`rel_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnotes`
--


--
-- Table structure for table `toda_tblnotifications`
--

CREATE TABLE `toda_tblnotifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `isread` int NOT NULL DEFAULT '0',
  `isread_inline` tinyint(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromuserid` int NOT NULL,
  `fromclientid` int NOT NULL DEFAULT '0',
  `from_fullname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `touserid` int NOT NULL,
  `fromcompany` int DEFAULT NULL,
  `link` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `additional_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tblnotifications`
--


--
-- Table structure for table `toda_tbloptions`
--

CREATE TABLE `toda_tbloptions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=705 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toda_tbloptions`
--

INSERT INTO `toda_tbloptions` VALUES (1,'dateformat','Y-m-d|%Y-%m-%d',1),(2,'companyname','Toda Global',1),(3,'services','1',1),(4,'maximum_allowed_ticket_attachments','4',1),(5,'ticket_attachments_file_extensions','.jpg,.png,.pdf,.doc,.zip,.rar',1),(6,'staff_access_only_assigned_departments','1',1),(7,'use_knowledge_base','1',1),(8,'smtp_email','',1),(9,'smtp_password','',1),(10,'company_info_format','{company_name}<br />\r\n      {address}<br />\r\n      {city} {state}<br />\r\n      {country_code} {zip_code}<br />\r\n      {vat_number_with_label}',0),(11,'smtp_port','',1),(12,'smtp_host','',1),(13,'smtp_email_charset','utf-8',1),(14,'default_timezone','Europe/Berlin',1),(15,'clients_default_theme','perfex',1),(16,'company_logo','',1),(17,'tables_pagination_limit','25',1),(18,'main_domain','',1),(19,'allow_registration','0',1),(20,'knowledge_base_without_registration','1',1),(21,'email_signature','',1),(22,'default_staff_role','1',1),(23,'newsfeed_maximum_files_upload','10',1),(24,'contract_expiration_before','4',1),(25,'invoice_prefix','INV-',1),(26,'decimal_separator','.',1),(27,'thousand_separator',',',1),(28,'invoice_company_name','',1),(29,'invoice_company_address','',1),(30,'invoice_company_city','',1),(31,'invoice_company_country_code','',1),(32,'invoice_company_postal_code','',1),(33,'invoice_company_phonenumber','',1),(34,'view_invoice_only_logged_in','0',1),(35,'invoice_number_format','1',1),(36,'next_invoice_number','1',0),(37,'active_language','english',1),(38,'invoice_number_decrement_on_delete','1',1),(39,'automatically_send_invoice_overdue_reminder_after','1',1),(40,'automatically_resend_invoice_overdue_reminder_after','3',1),(41,'expenses_auto_operations_hour','21',1),(42,'delete_only_on_last_invoice','1',1),(43,'delete_only_on_last_estimate','1',1),(44,'create_invoice_from_recurring_only_on_paid_invoices','0',1),(45,'allow_payment_amount_to_be_modified','1',1),(46,'rtl_support_client','0',1),(47,'limit_top_search_bar_results_to','10',1),(48,'estimate_prefix','EST-',1),(49,'next_estimate_number','1',0),(50,'estimate_number_decrement_on_delete','1',1),(51,'estimate_number_format','1',1),(52,'estimate_auto_convert_to_invoice_on_client_accept','1',1),(53,'exclude_estimate_from_client_area_with_draft_status','1',1),(54,'rtl_support_admin','0',1),(55,'last_cron_run','1733698263',1),(56,'show_sale_agent_on_estimates','1',1),(57,'show_sale_agent_on_invoices','1',1),(58,'predefined_terms_invoice','',1),(59,'predefined_terms_estimate','',1),(60,'default_task_priority','2',1),(61,'dropbox_app_key','',1),(62,'show_expense_reminders_on_calendar','1',1),(63,'only_show_contact_tickets','1',1),(64,'predefined_clientnote_invoice','',1),(65,'predefined_clientnote_estimate','',1),(66,'custom_pdf_logo_image_url','',1),(67,'favicon','',1),(68,'invoice_due_after','30',1),(69,'google_api_key','',1),(70,'google_calendar_main_calendar','',1),(71,'default_tax','a:0:{}',1),(72,'show_invoices_on_calendar','1',1),(73,'show_estimates_on_calendar','1',1),(74,'show_contracts_on_calendar','1',1),(75,'show_tasks_on_calendar','1',1),(76,'show_customer_reminders_on_calendar','1',1),(77,'output_client_pdfs_from_admin_area_in_client_language','0',1),(78,'show_lead_reminders_on_calendar','1',1),(79,'send_estimate_expiry_reminder_before','4',1),(80,'leads_default_source','',1),(81,'leads_default_status','',1),(82,'proposal_expiry_reminder_enabled','1',1),(83,'send_proposal_expiry_reminder_before','4',1),(84,'default_contact_permissions','a:6:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"4\";i:4;s:1:\"5\";i:5;s:1:\"6\";}',1),(85,'pdf_logo_width','150',1),(86,'access_tickets_to_none_staff_members','0',1),(87,'customer_default_country','',1),(88,'view_estimate_only_logged_in','0',1),(89,'show_status_on_pdf_ei','1',1),(90,'email_piping_only_replies','0',1),(91,'email_piping_only_registered','0',1),(92,'default_view_calendar','dayGridMonth',1),(93,'email_piping_default_priority','2',1),(94,'total_to_words_lowercase','0',1),(95,'show_tax_per_item','1',1),(96,'total_to_words_enabled','0',1),(97,'receive_notification_on_new_ticket','1',0),(98,'autoclose_tickets_after','0',1),(99,'media_max_file_size_upload','10',1),(100,'client_staff_add_edit_delete_task_comments_first_hour','0',1),(101,'show_projects_on_calendar','1',1),(102,'leads_kanban_limit','50',1),(103,'tasks_reminder_notification_before','2',1),(104,'pdf_font','freesans',1),(105,'pdf_table_heading_color','#323a45',1),(106,'pdf_table_heading_text_color','#ffffff',1),(107,'pdf_font_size','10',1),(108,'default_leads_kanban_sort','leadorder',1),(109,'default_leads_kanban_sort_type','asc',1),(110,'allowed_files','.png,.jpg,.pdf,.doc,.docx,.xls,.xlsx,.zip,.rar,.txt',1),(111,'show_all_tasks_for_project_member','1',1),(112,'email_protocol','smtp',1),(113,'calendar_first_day','0',1),(114,'recaptcha_secret_key','',1),(115,'show_help_on_setup_menu','1',1),(116,'show_proposals_on_calendar','1',1),(117,'smtp_encryption','',1),(118,'recaptcha_site_key','',1),(119,'smtp_username','',1),(120,'auto_stop_tasks_timers_on_new_timer','1',1),(121,'notification_when_customer_pay_invoice','1',1),(122,'calendar_invoice_color','#FF6F00',1),(123,'calendar_estimate_color','#FF6F00',1),(124,'calendar_proposal_color','#84c529',1),(125,'new_task_auto_assign_current_member','1',1),(126,'calendar_reminder_color','#03A9F4',1),(127,'calendar_contract_color','#B72974',1),(128,'calendar_project_color','#B72974',1),(129,'update_info_message','',1),(130,'show_estimate_reminders_on_calendar','1',1),(131,'show_invoice_reminders_on_calendar','1',1),(132,'show_proposal_reminders_on_calendar','1',1),(133,'proposal_due_after','7',1),(134,'allow_customer_to_change_ticket_status','0',1),(135,'lead_lock_after_convert_to_customer','0',1),(136,'default_proposals_pipeline_sort','pipeline_order',1),(137,'default_proposals_pipeline_sort_type','asc',1),(138,'default_estimates_pipeline_sort','pipeline_order',1),(139,'default_estimates_pipeline_sort_type','asc',1),(140,'use_recaptcha_customers_area','0',1),(141,'remove_decimals_on_zero','0',1),(142,'remove_tax_name_from_item_table','0',1),(143,'pdf_format_invoice','A4-PORTRAIT',1),(144,'pdf_format_estimate','A4-PORTRAIT',1),(145,'pdf_format_proposal','A4-PORTRAIT',1),(146,'pdf_format_payment','A4-PORTRAIT',1),(147,'pdf_format_contract','A4-PORTRAIT',1),(148,'swap_pdf_info','0',1),(149,'exclude_invoice_from_client_area_with_draft_status','1',1),(150,'cron_has_run_from_cli','1',1),(151,'hide_cron_is_required_message','0',0),(152,'auto_assign_customer_admin_after_lead_convert','1',1),(153,'show_transactions_on_invoice_pdf','1',1),(154,'show_pay_link_to_invoice_pdf','1',1),(155,'tasks_kanban_limit','50',1),(156,'purchase_key','',1),(157,'estimates_pipeline_limit','50',1),(158,'proposals_pipeline_limit','50',1),(159,'proposal_number_prefix','PRO-',1),(160,'number_padding_prefixes','6',1),(161,'show_page_number_on_pdf','0',1),(162,'calendar_events_limit','4',1),(163,'show_setup_menu_item_only_on_hover','0',1),(164,'company_requires_vat_number_field','1',1),(165,'company_is_required','1',1),(166,'allow_contact_to_delete_files','0',1),(167,'company_vat','',1),(168,'di','',1),(169,'invoice_auto_operations_hour','21',1),(170,'use_minified_files','1',1),(171,'only_own_files_contacts','0',1),(172,'allow_primary_contact_to_view_edit_billing_and_shipping','0',1),(173,'estimate_due_after','7',1),(174,'staff_members_open_tickets_to_all_contacts','1',1),(175,'time_format','24',1),(176,'delete_activity_log_older_then','1',1),(177,'disable_language','0',1),(178,'company_state','',1),(179,'email_header','<!doctype html>\r\n      <html>\r\n      <head>\r\n      <meta name=\"viewport\" content=\"width=device-width\" />\r\n      <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\r\n      <style>\r\n      body {\r\n        background-color: #f6f6f6;\r\n        font-family: sans-serif;\r\n        -webkit-font-smoothing: antialiased;\r\n        font-size: 14px;\r\n        line-height: 1.4;\r\n        margin: 0;\r\n        padding: 0;\r\n        -ms-text-size-adjust: 100%;\r\n        -webkit-text-size-adjust: 100%;\r\n      }\r\n      table {\r\n        border-collapse: separate;\r\n        mso-table-lspace: 0pt;\r\n        mso-table-rspace: 0pt;\r\n        width: 100%;\r\n      }\r\n      table td {\r\n        font-family: sans-serif;\r\n        font-size: 14px;\r\n        vertical-align: top;\r\n      }\r\n      /* -------------------------------------\r\n      BODY & CONTAINER\r\n      ------------------------------------- */\r\n      .body {\r\n        background-color: #f6f6f6;\r\n        width: 100%;\r\n      }\r\n      /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink down on a phone or something */\r\n      \r\n      .container {\r\n        display: block;\r\n        margin: 0 auto !important;\r\n        /* makes it centered */\r\n        max-width: 680px;\r\n        padding: 10px;\r\n        width: 680px;\r\n      }\r\n      /* This should also be a block element, so that it will fill 100% of the .container */\r\n      \r\n      .content {\r\n        box-sizing: border-box;\r\n        display: block;\r\n        margin: 0 auto;\r\n        max-width: 680px;\r\n        padding: 10px;\r\n      }\r\n      /* -------------------------------------\r\n      HEADER, FOOTER, MAIN\r\n      ------------------------------------- */\r\n      \r\n      .main {\r\n        background: #fff;\r\n        border-radius: 3px;\r\n        width: 100%;\r\n      }\r\n      .wrapper {\r\n        box-sizing: border-box;\r\n        padding: 20px;\r\n      }\r\n      .footer {\r\n        clear: both;\r\n        padding-top: 10px;\r\n        text-align: center;\r\n        width: 100%;\r\n      }\r\n      .footer td,\r\n      .footer p,\r\n      .footer span,\r\n      .footer a {\r\n        color: #999999;\r\n        font-size: 12px;\r\n        text-align: center;\r\n      }\r\n      hr {\r\n        border: 0;\r\n        border-bottom: 1px solid #f6f6f6;\r\n        margin: 20px 0;\r\n      }\r\n      /* -------------------------------------\r\n      RESPONSIVE AND MOBILE FRIENDLY STYLES\r\n      ------------------------------------- */\r\n      \r\n      @media only screen and (max-width: 620px) {\r\n        table[class=body] .content {\r\n          padding: 0 !important;\r\n        }\r\n        table[class=body] .container {\r\n          padding: 0 !important;\r\n          width: 100% !important;\r\n        }\r\n        table[class=body] .main {\r\n          border-left-width: 0 !important;\r\n          border-radius: 0 !important;\r\n          border-right-width: 0 !important;\r\n        }\r\n      }\r\n      </style>\r\n      </head>\r\n      <body class=\"\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"body\">\r\n      <tr>\r\n      <td>&nbsp;</td>\r\n      <td class=\"container\">\r\n      <div class=\"content\">\r\n      <!-- START CENTERED WHITE CONTAINER -->\r\n      <table class=\"main\">\r\n      <!-- START MAIN CONTENT AREA -->\r\n      <tr>\r\n      <td class=\"wrapper\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n      <td>',1),(180,'show_pdf_signature_invoice','1',0),(181,'show_pdf_signature_estimate','1',0),(182,'signature_image','',0),(183,'email_footer','</td>\r\n      </tr>\r\n      </table>\r\n      </td>\r\n      </tr>\r\n      <!-- END MAIN CONTENT AREA -->\r\n      </table>\r\n      <!-- START FOOTER -->\r\n      <div class=\"footer\">\r\n      <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n      <td class=\"content-block\">\r\n      <span>{companyname}</span>\r\n      </td>\r\n      </tr>\r\n      </table>\r\n      </div>\r\n      <!-- END FOOTER -->\r\n      <!-- END CENTERED WHITE CONTAINER -->\r\n      </div>\r\n      </td>\r\n      <td>&nbsp;</td>\r\n      </tr>\r\n      </table>\r\n      </body>\r\n      </html>',1),(184,'exclude_proposal_from_client_area_with_draft_status','1',1),(185,'pusher_app_key','',1),(186,'pusher_app_secret','',1),(187,'pusher_app_id','',1),(188,'pusher_realtime_notifications','0',1),(189,'pdf_format_statement','A4-PORTRAIT',1),(190,'pusher_cluster','',1),(191,'show_table_export_button','to_all',1),(192,'allow_staff_view_proposals_assigned','1',1),(193,'show_cloudflare_notice','1',0),(194,'task_modal_class','modal-lg',1),(195,'lead_modal_class','modal-lg',1),(196,'show_timesheets_overview_all_members_notice_admins','0',1),(197,'desktop_notifications','0',1),(198,'hide_notified_reminders_from_calendar','1',0),(199,'customer_info_format','{company_name}<br />\r\n      {street}<br />\r\n      {city} {state}<br />\r\n      {country_code} {zip_code}<br />\r\n      {vat_number_with_label}',0),(200,'timer_started_change_status_in_progress','1',0),(201,'default_ticket_reply_status','3',1),(202,'default_task_status','auto',1),(203,'email_queue_skip_with_attachments','1',1),(204,'email_queue_enabled','0',1),(205,'last_email_queue_retry','1733697910',1),(206,'auto_dismiss_desktop_notifications_after','0',1),(207,'proposal_info_format','{proposal_to}<br />\r\n      {address}<br />\r\n      {city} {state}<br />\r\n      {country_code} {zip_code}<br />\r\n      {phone}<br />\r\n      {email}',0),(208,'ticket_replies_order','asc',1),(209,'new_recurring_invoice_action','generate_and_send',0),(210,'bcc_emails','',0),(211,'email_templates_language_checks','',0),(212,'proposal_accept_identity_confirmation','1',0),(213,'estimate_accept_identity_confirmation','1',0),(214,'new_task_auto_follower_current_member','0',1),(215,'task_biillable_checked_on_creation','1',1),(216,'predefined_clientnote_credit_note','',1),(217,'predefined_terms_credit_note','',1),(218,'next_credit_note_number','1',1),(219,'credit_note_prefix','CN-',1),(220,'credit_note_number_decrement_on_delete','1',1),(221,'pdf_format_credit_note','A4-PORTRAIT',1),(222,'show_pdf_signature_credit_note','1',0),(223,'show_credit_note_reminders_on_calendar','1',1),(224,'show_amount_due_on_invoice','1',1),(225,'show_total_paid_on_invoice','1',1),(226,'show_credits_applied_on_invoice','1',1),(227,'staff_members_create_inline_lead_status','1',1),(228,'staff_members_create_inline_customer_groups','1',1),(229,'staff_members_create_inline_ticket_services','1',1),(230,'staff_members_save_tickets_predefined_replies','1',1),(231,'staff_members_create_inline_contract_types','1',1),(232,'staff_members_create_inline_expense_categories','1',1),(233,'show_project_on_credit_note','1',1),(234,'proposals_auto_operations_hour','21',1),(235,'estimates_auto_operations_hour','21',1),(236,'contracts_auto_operations_hour','21',1),(237,'credit_note_number_format','1',1),(238,'allow_non_admin_members_to_import_leads','0',1),(239,'e_sign_legal_text','By clicking on \"Sign\", I consent to be legally bound by this electronic representation of my signature.',1),(240,'show_pdf_signature_contract','1',1),(241,'view_contract_only_logged_in','0',1),(242,'show_subscriptions_in_customers_area','1',1),(243,'calendar_only_assigned_tasks','0',1),(244,'after_subscription_payment_captured','send_invoice_and_receipt',1),(245,'mail_engine','phpmailer',1),(246,'gdpr_enable_terms_and_conditions','0',1),(247,'privacy_policy','',1),(248,'terms_and_conditions','',1),(249,'gdpr_enable_terms_and_conditions_lead_form','0',1),(250,'gdpr_enable_terms_and_conditions_ticket_form','0',1),(251,'gdpr_contact_enable_right_to_be_forgotten','0',1),(252,'show_gdpr_in_customers_menu','1',1),(253,'show_gdpr_link_in_footer','1',1),(254,'enable_gdpr','0',1),(255,'gdpr_on_forgotten_remove_invoices_credit_notes','0',1),(256,'gdpr_on_forgotten_remove_estimates','0',1),(257,'gdpr_enable_consent_for_contacts','0',1),(258,'gdpr_consent_public_page_top_block','',1),(259,'gdpr_page_top_information_block','',1),(260,'gdpr_enable_lead_public_form','0',1),(261,'gdpr_show_lead_custom_fields_on_public_form','0',1),(262,'gdpr_lead_attachments_on_public_form','0',1),(263,'gdpr_enable_consent_for_leads','0',1),(264,'gdpr_lead_enable_right_to_be_forgotten','0',1),(265,'allow_staff_view_invoices_assigned','1',1),(266,'gdpr_data_portability_leads','0',1),(267,'gdpr_lead_data_portability_allowed','',1),(268,'gdpr_contact_data_portability_allowed','',1),(269,'gdpr_data_portability_contacts','0',1),(270,'allow_staff_view_estimates_assigned','1',1),(271,'gdpr_after_lead_converted_delete','0',1),(272,'gdpr_show_terms_and_conditions_in_footer','0',1),(273,'save_last_order_for_tables','0',1),(274,'company_logo_dark','',1),(275,'customers_register_require_confirmation','0',1),(276,'allow_non_admin_staff_to_delete_ticket_attachments','0',1),(277,'receive_notification_on_new_ticket_replies','1',0),(278,'google_client_id','',1),(279,'enable_google_picker','1',1),(280,'show_ticket_reminders_on_calendar','1',1),(281,'ticket_import_reply_only','0',1),(282,'visible_customer_profile_tabs','all',0),(283,'show_project_on_invoice','1',1),(284,'show_project_on_estimate','1',1),(285,'staff_members_create_inline_lead_source','1',1),(286,'lead_unique_validation','[\"email\"]',1),(287,'last_upgrade_copy_data','',1),(288,'custom_js_admin_scripts','',1),(289,'custom_js_customer_scripts','0',1),(290,'stripe_webhook_id','',1),(291,'stripe_webhook_signing_secret','',1),(292,'stripe_ideal_webhook_id','',1),(293,'stripe_ideal_webhook_signing_secret','',1),(294,'show_php_version_notice','1',0),(295,'recaptcha_ignore_ips','',1),(296,'show_task_reminders_on_calendar','1',1),(297,'customer_settings','true',1),(298,'tasks_reminder_notification_hour','21',1),(299,'allow_primary_contact_to_manage_other_contacts','0',1),(300,'items_table_amounts_exclude_currency_symbol','1',1),(301,'round_off_task_timer_option','0',1),(302,'round_off_task_timer_time','5',1),(303,'bitly_access_token','',1),(304,'enable_support_menu_badges','0',1),(305,'attach_invoice_to_payment_receipt_email','0',1),(306,'invoice_due_notice_before','2',1),(307,'invoice_due_notice_resend_after','0',1),(308,'_leads_settings','true',1),(309,'show_estimate_request_in_customers_area','0',1),(310,'gdpr_enable_terms_and_conditions_estimate_request_form','0',1),(311,'identification_key','14745289791733147571674dbbb34d22c',1),(312,'automatically_stop_task_timer_after_hours','8',1),(313,'automatically_assign_ticket_to_first_staff_responding','0',1),(314,'reminder_for_completed_but_not_billed_tasks','0',1),(315,'staff_notify_completed_but_not_billed_tasks','',1),(316,'reminder_for_completed_but_not_billed_tasks_days','',1),(317,'tasks_reminder_notification_last_notified_day','',1),(318,'staff_related_ticket_notification_to_assignee_only','0',1),(319,'show_pdf_signature_proposal','1',1),(320,'enable_honeypot_spam_validation','0',1),(321,'microsoft_mail_client_id','',1),(322,'microsoft_mail_client_secret','',1),(323,'microsoft_mail_azure_tenant_id','',1),(324,'google_mail_client_id','',1),(325,'google_mail_client_secret','',1),(326,'google_mail_refresh_token','',1),(327,'microsoft_mail_refresh_token','',1),(328,'automatically_set_logged_in_staff_sales_agent','1',1),(329,'contract_sign_reminder_every_days','0',1),(330,'last_updated_date','',1),(331,'v310_incompatible_tables','[]',1),(332,'required_register_fields','[]',0),(333,'allow_non_admin_members_to_delete_tickets_and_replies','0',1),(334,'allow_non_admin_members_to_edit_ticket_messages','0',1),(335,'proposal_auto_convert_to_invoice_on_client_accept','0',1),(336,'show_project_on_proposal','1',1),(337,'upgraded_from_version','',0),(338,'perfex_saas_installation_secured','true',0),(339,'sms_clickatell_api_key','',1),(340,'sms_clickatell_active','0',1),(341,'sms_clickatell_initialized','1',1),(342,'sms_msg91_sender_id','',1),(343,'sms_msg91_api_type','api',1),(344,'sms_msg91_auth_key','',1),(345,'sms_msg91_active','0',1),(346,'sms_msg91_initialized','1',1),(347,'sms_twilio_account_sid','',1),(348,'sms_twilio_auth_token','',1),(349,'sms_twilio_phone_number','',1),(350,'sms_twilio_sender_id','',1),(351,'sms_twilio_active','0',1),(352,'sms_twilio_initialized','1',1),(353,'acc_first_month_of_financial_year','January',1),(354,'acc_first_month_of_tax_year','same_as_financial_year',1),(355,'acc_accounting_method','accrual',1),(356,'acc_close_the_books','0',1),(357,'acc_allow_changes_after_viewing','allow_changes_after_viewing_a_warning',1),(358,'acc_close_book_password','',1),(359,'acc_close_book_passwordr','',1),(360,'acc_enable_account_numbers','0',1),(361,'acc_show_account_numbers','0',1),(362,'acc_closing_date','',1),(363,'acc_add_default_account','1',1),(364,'acc_add_default_account_new','0',1),(365,'acc_invoice_automatic_conversion','1',1),(366,'acc_payment_automatic_conversion','1',1),(367,'acc_credit_note_automatic_conversion','1',1),(368,'acc_credit_note_refund_automatic_conversion','1',1),(369,'acc_expense_automatic_conversion','1',1),(370,'acc_tax_automatic_conversion','1',1),(371,'acc_invoice_payment_account','66',1),(372,'acc_invoice_deposit_to','1',1),(373,'acc_payment_payment_account','1',1),(374,'acc_payment_deposit_to','13',1),(375,'acc_credit_note_payment_account','1',1),(376,'acc_credit_note_deposit_to','13',1),(377,'acc_credit_note_refund_payment_account','1',1),(378,'acc_credit_note_refund_deposit_to','13',1),(379,'acc_expense_payment_account','13',1),(380,'acc_expense_deposit_to','80',1),(381,'acc_tax_payment_account','29',1),(382,'acc_tax_deposit_to','1',1),(383,'acc_expense_tax_payment_account','13',1),(384,'acc_expense_tax_deposit_to','29',1),(385,'acc_active_payment_mode_mapping','1',1),(386,'acc_active_expense_category_mapping','1',1),(387,'acc_payment_expense_automatic_conversion','1',1),(388,'acc_payment_sale_automatic_conversion','1',1),(389,'acc_expense_payment_payment_account','1',1),(390,'acc_expense_payment_deposit_to','1',1),(391,'acc_pl_total_insurance_automatic_conversion','1',1),(392,'acc_pl_total_insurance_payment_account','13',1),(393,'acc_pl_total_insurance_deposit_to','32',1),(394,'acc_pl_tax_paye_automatic_conversion','1',1),(395,'acc_pl_tax_paye_payment_account','13',1),(396,'acc_pl_tax_paye_deposit_to','28',1),(397,'acc_pl_net_pay_automatic_conversion','1',1),(398,'acc_pl_net_pay_payment_account','13',1),(399,'acc_pl_net_pay_deposit_to','56',1),(400,'acc_wh_stock_import_automatic_conversion','1',1),(401,'acc_wh_stock_import_payment_account','87',1),(402,'acc_wh_stock_import_deposit_to','37',1),(403,'acc_wh_stock_export_automatic_conversion','1',1),(404,'acc_wh_stock_export_payment_account','37',1),(405,'acc_wh_stock_export_deposit_to','1',1),(406,'acc_wh_loss_adjustment_automatic_conversion','1',1),(407,'acc_wh_decrease_payment_account','37',1),(408,'acc_wh_decrease_deposit_to','1',1),(409,'acc_wh_increase_payment_account','87',1),(410,'acc_wh_increase_deposit_to','37',1),(411,'acc_wh_opening_stock_automatic_conversion','1',1),(412,'acc_wh_opening_stock_payment_account','88',1),(413,'acc_wh_opening_stock_deposit_to','37',1),(414,'acc_pur_order_automatic_conversion','1',1),(415,'acc_pur_order_payment_account','13',1),(416,'acc_pur_order_deposit_to','80',1),(417,'acc_pur_payment_automatic_conversion','1',1),(418,'acc_pur_payment_payment_account','16',1),(419,'acc_pur_payment_deposit_to','37',1),(420,'acc_mrp_manufacturing_order_automatic_conversion','1',1),(421,'acc_mrp_material_cost_payment_account','13',1),(422,'acc_mrp_material_cost_deposit_to','45',1),(423,'acc_mrp_labour_cost_payment_account','13',1),(424,'acc_mrp_labour_cost_deposit_to','18',1),(425,'acc_pur_order_return_automatic_conversion','1',1),(426,'acc_pur_order_return_payment_account','80',1),(427,'acc_pur_order_return_deposit_to','13',1),(428,'acc_pur_refund_automatic_conversion','1',1),(429,'acc_pur_refund_payment_account','37',1),(430,'acc_pur_refund_deposit_to','16',1),(431,'acc_pur_invoice_automatic_conversion','1',1),(432,'acc_pur_invoice_payment_account','13',1),(433,'acc_pur_invoice_deposit_to','80',1),(434,'acc_omni_sales_order_return_automatic_conversion','1',1),(435,'acc_omni_sales_order_return_payment_account','1',1),(436,'acc_omni_sales_order_return_deposit_to','66',1),(437,'acc_omni_sales_refund_automatic_conversion','1',1),(438,'acc_omni_sales_refund_payment_account','13',1),(439,'acc_omni_sales_refund_deposit_to','1',1),(440,'acc_routing_number_icon_a','a',1),(441,'acc_routing_number_icon_b','a',1),(442,'acc_bank_account_icon_a','a',1),(443,'acc_bank_account_icon_b','a',1),(444,'acc_current_check_no_icon_a','a',1),(445,'acc_current_check_no_icon_b','a',1),(446,'acc_check_type','type_1',1),(447,'acc_fe_asset_automatic_conversion','1',1),(448,'acc_fe_asset_payment_account','13',1),(449,'acc_fe_asset_deposit_to','1',1),(450,'acc_fe_license_automatic_conversion','1',1),(451,'acc_fe_license_payment_account','13',1),(452,'acc_fe_license_deposit_to','1',1),(453,'acc_fe_consumable_automatic_conversion','1',1),(454,'acc_fe_consumable_payment_account','13',1),(455,'acc_fe_consumable_deposit_to','1',1),(456,'acc_fe_component_automatic_conversion','1',1),(457,'acc_fe_component_payment_account','13',1),(458,'acc_fe_component_deposit_to','1',1),(459,'acc_fe_maintenance_automatic_conversion','1',1),(460,'acc_fe_maintenance_payment_account','13',1),(461,'acc_fe_maintenance_deposit_to','1',1),(462,'acc_fe_depreciation_automatic_conversion','1',1),(463,'acc_fe_depreciation_payment_account','13',1),(464,'acc_fe_depreciation_deposit_to','1',1),(465,'acc_wh_stock_export_profit_payment_account','66',1),(466,'acc_wh_stock_export_profit_deposit_to','1',1),(467,'update_bank_account_v124','1',1),(468,'update_income_statement_modifications_v125','1',1),(469,'acc_enable_income_statement_modifications','0',1),(470,'acc_invoice_discount_payment_account','1',1),(471,'acc_invoice_discount_deposit_to','19',1),(472,'acc_pur_tax_automatic_conversion','1',1),(473,'acc_pur_tax_payment_account','13',1),(474,'acc_pur_tax_deposit_to','29',1),(475,'acc_wh_stock_import_return_automatic_conversion','0',1),(476,'acc_wh_stock_import_return_payment_account','1',1),(477,'acc_wh_stock_import_return_deposit_to','37',1),(478,'acc_wh_stock_export_profit_automatic_conversion','1',1),(479,'menu_setup_client_client_menu_active','[]',1),(480,'fs_global_max_size','2',1),(481,'fs_global_extension','.jpg,.png,.pdf,.doc,.zip,.rar',1),(482,'fs_global_amount_expiration','3',1),(483,'fs_global_notification','1',1),(484,'fs_global_email','0',1),(485,'fs_client_visible','0',1),(486,'fs_permisstion_staff_view','1',1),(487,'fs_permisstion_staff_upload_and_override','1',1),(488,'fs_permisstion_staff_delete','1',1),(489,'fs_permisstion_staff_upload','1',1),(490,'fs_permisstion_staff_download','1',1),(491,'fs_permisstion_staff_share','1',1),(492,'fs_permisstion_client_view','1',1),(493,'fs_permisstion_client_upload_and_override','1',1),(494,'fs_permisstion_client_delete','1',1),(495,'fs_permisstion_client_upload','1',1),(496,'fs_permisstion_client_download','1',1),(497,'file_sharing_security','?3HTtb?HgTA@%7zm',1),(498,'fs_the_administrator_of_the_public_folder','',1),(499,'fs_allow_file_editing','1',1),(500,'fs_hidden_files','.tmb,index.html',1),(501,'fs_permisstion_staff_share_to_client','1',1),(502,'flexstage_send_emails_per_cron_run','100',1),(503,'last_flexstage_send_cron','',1),(504,'flexstage_customer_reference_id','1',1),(505,'flexstage_lead_source','3',1),(506,'flexstage_lead_status','2',1),(507,'flexstage_color','#a9b338',1),(508,'flexstage_qrcode_image_width','150',1),(509,'hr_profile_hide_menu','1',1),(510,'aside_menu_active','[]',1),(511,'setup_menu_active','[]',1),(512,'survey_send_emails_per_cron_run','100',1),(513,'last_survey_send_cron','',1),(514,'theme_style','[]',1),(515,'theme_style_custom_admin_area','',1),(516,'theme_style_custom_clients_area','',1),(517,'theme_style_custom_clients_and_admin_area','',1),(518,'warehouse_selling_price_rule_profif_ratio','0',1),(519,'profit_rate_by_purchase_price_sale','0',1),(520,'warehouse_the_fractional_part','0',1),(521,'warehouse_integer_part','0',1),(522,'auto_create_goods_received','0',1),(523,'auto_create_goods_delivery','0',1),(524,'goods_receipt_warehouse','0',1),(525,'barcode_with_sku_code','0',1),(526,'revert_goods_receipt_goods_delivery','0',1),(527,'cancelled_invoice_reverse_inventory_delivery_voucher','0',1),(528,'uncancelled_invoice_create_inventory_delivery_voucher','0',1),(529,'inventory_auto_operations_hour','0',1),(530,'automatically_send_items_expired_before','0',1),(531,'inventorys_cronjob_active','0',1),(532,'inventory_cronjob_notification_recipients','',1),(533,'inventory_received_number_prefix','NK',1),(534,'next_inventory_received_mumber','1',1),(535,'inventory_delivery_number_prefix','XK',1),(536,'next_inventory_delivery_mumber','1',1),(537,'internal_delivery_number_prefix','ID',1),(538,'next_internal_delivery_mumber','1',1),(539,'item_sku_prefix','',1),(540,'goods_receipt_required_po','0',1),(541,'goods_delivery_required_po','0',1),(542,'goods_delivery_pdf_display','0',1),(543,'display_product_name_when_print_barcode','0',1),(544,'show_item_cf_on_pdf','0',1),(545,'goods_delivery_pdf_display_outstanding','0',1),(546,'goods_delivery_pdf_display_warehouse_lotnumber_bottom_infor','0',1),(547,'packing_list_number_prefix','PL',1),(548,'next_packing_list_number','1',1),(549,'wh_return_request_within_x_day','30',1),(550,'wh_fee_for_return_order','0',1),(551,'wh_return_policies_information','',1),(552,'wh_refund_loyaty_point','1',1),(553,'order_return_number_prefix','ReReturn',1),(554,'next_order_return_number','1',1),(555,'e_order_return_number_prefix','DEReturn',1),(556,'e_next_order_return_number','1',1),(557,'warehouse_receive_return_order ','0',1),(558,'wh_display_shipment_on_client_portal','1',1),(559,'wh_on_total_items','200',1),(560,'wh_products_by_serial','1',1),(561,'wh_shortened_form_pdf','0',1),(562,'wh_show_price_when_print_barcode','1',1),(563,'notify_customer_when_change_delivery_status','1',1),(564,'wh_hide_shipping_fee','0',1),(565,'lot_number_prefix','LOT',1),(566,'next_lot_number','1',1),(567,'auto_generate_lotnumber','0',1),(568,'custom_name_for_meter','m',1),(569,'custom_name_for_kg','kg',1),(570,'custom_name_for_m3','m3',1),(571,'packing_list_pdf_display_rate','1',1),(572,'packing_list_pdf_display_tax','1',1),(573,'packing_list_pdf_display_subtotal','1',1),(574,'packing_list_pdf_display_discount_percent','1',1),(575,'packing_list_pdf_display_discount_amount','1',1),(576,'packing_list_pdf_display_totalpayment','1',1),(577,'packing_list_pdf_display_summary','1',1),(578,'pur_invoice_auto_operations_hour','21',1),(579,'next_debit_note_number','1',1),(580,'debit_note_number_format','1',1),(581,'debit_note_prefix','DN-',1),(582,'show_purchase_tax_column','1',1),(583,'po_only_prefix_and_number','0',1),(584,'cr_date_cronjob_currency_rates','2024-12-08',1),(585,'cr_automatically_get_currency_rate','1',1),(586,'cr_global_amount_expiration','0',1),(587,'pur_return_request_within_x_day','30',1),(588,'pur_fee_for_return_order','0',1),(589,'pur_return_policies_information','',1),(590,'pur_order_return_number_prefix','OReturn',1),(591,'next_pur_order_return_number','1',1),(592,'send_email_welcome_for_new_contact','1',1),(593,'reset_purchase_order_number_every_month','1',1),(594,'pur_company_address','',1),(595,'pur_company_city','',1),(596,'pur_company_state','',1),(597,'pur_company_zipcode','',1),(598,'pur_company_country_code','',1),(599,'allow_vendors_to_register','1',1),(600,'pur_company_country_text','',1),(601,'paymentmethod_authorize_acceptjs_active','0',1),(602,'paymentmethod_authorize_acceptjs_label','Authorize.net Accept.js',1),(603,'paymentmethod_authorize_acceptjs_public_key','',0),(604,'paymentmethod_authorize_acceptjs_api_login_id','',0),(605,'paymentmethod_authorize_acceptjs_api_transaction_key','',0),(606,'paymentmethod_authorize_acceptjs_description_dashboard','Payment for Invoice {invoice_number}',0),(607,'paymentmethod_authorize_acceptjs_currencies','USD',0),(608,'paymentmethod_authorize_acceptjs_test_mode_enabled','0',0),(609,'paymentmethod_authorize_acceptjs_default_selected','1',1),(610,'paymentmethod_authorize_acceptjs_initialized','1',1),(611,'paymentmethod_instamojo_active','0',1),(612,'paymentmethod_instamojo_label','Instamojo',1),(613,'paymentmethod_instamojo_fee_fixed','0',0),(614,'paymentmethod_instamojo_fee_percent','0',0),(615,'paymentmethod_instamojo_api_key','',0),(616,'paymentmethod_instamojo_auth_token','',0),(617,'paymentmethod_instamojo_description_dashboard','Payment for Invoice {invoice_number}',0),(618,'paymentmethod_instamojo_currencies','INR',0),(619,'paymentmethod_instamojo_test_mode_enabled','1',0),(620,'paymentmethod_instamojo_default_selected','1',1),(621,'paymentmethod_instamojo_initialized','1',1),(622,'paymentmethod_mollie_active','0',1),(623,'paymentmethod_mollie_label','Mollie',1),(624,'paymentmethod_mollie_api_key','',0),(625,'paymentmethod_mollie_description_dashboard','Payment for Invoice {invoice_number}',0),(626,'paymentmethod_mollie_currencies','EUR',0),(627,'paymentmethod_mollie_test_mode_enabled','1',0),(628,'paymentmethod_mollie_default_selected','1',1),(629,'paymentmethod_mollie_initialized','1',1),(630,'paymentmethod_paypal_braintree_active','0',1),(631,'paymentmethod_paypal_braintree_label','Braintree',1),(632,'paymentmethod_paypal_braintree_merchant_id','',0),(633,'paymentmethod_paypal_braintree_api_public_key','',0),(634,'paymentmethod_paypal_braintree_api_private_key','',0),(635,'paymentmethod_paypal_braintree_currencies','USD',0),(636,'paymentmethod_paypal_braintree_paypal_enabled','1',0),(637,'paymentmethod_paypal_braintree_test_mode_enabled','1',0),(638,'paymentmethod_paypal_braintree_default_selected','1',1),(639,'paymentmethod_paypal_braintree_initialized','1',1),(640,'paymentmethod_paypal_checkout_active','0',1),(641,'paymentmethod_paypal_checkout_label','Paypal Smart Checkout',1),(642,'paymentmethod_paypal_checkout_fee_fixed','0',0),(643,'paymentmethod_paypal_checkout_fee_percent','0',0),(644,'paymentmethod_paypal_checkout_client_id','',0),(645,'paymentmethod_paypal_checkout_secret','',0),(646,'paymentmethod_paypal_checkout_payment_description','Payment for Invoice {invoice_number}',0),(647,'paymentmethod_paypal_checkout_currencies','USD,CAD,EUR',0),(648,'paymentmethod_paypal_checkout_test_mode_enabled','1',0),(649,'paymentmethod_paypal_checkout_default_selected','1',1),(650,'paymentmethod_paypal_checkout_initialized','1',1),(651,'paymentmethod_paypal_active','0',1),(652,'paymentmethod_paypal_label','Paypal',1),(653,'paymentmethod_paypal_fee_fixed','0',0),(654,'paymentmethod_paypal_fee_percent','0',0),(655,'paymentmethod_paypal_username','',0),(656,'paymentmethod_paypal_password','',0),(657,'paymentmethod_paypal_signature','',0),(658,'paymentmethod_paypal_description_dashboard','Payment for Invoice {invoice_number}',0),(659,'paymentmethod_paypal_currencies','EUR,USD',0),(660,'paymentmethod_paypal_test_mode_enabled','1',0),(661,'paymentmethod_paypal_default_selected','1',1),(662,'paymentmethod_paypal_initialized','1',1),(663,'paymentmethod_payu_money_active','0',1),(664,'paymentmethod_payu_money_label','PayU Money',1),(665,'paymentmethod_payu_money_fee_fixed','0',0),(666,'paymentmethod_payu_money_fee_percent','0',0),(667,'paymentmethod_payu_money_key','',0),(668,'paymentmethod_payu_money_salt','',0),(669,'paymentmethod_payu_money_description_dashboard','Payment for Invoice {invoice_number}',0),(670,'paymentmethod_payu_money_currencies','INR',0),(671,'paymentmethod_payu_money_test_mode_enabled','1',0),(672,'paymentmethod_payu_money_default_selected','1',1),(673,'paymentmethod_payu_money_initialized','1',1),(674,'paymentmethod_stripe_active','0',1),(675,'paymentmethod_stripe_label','Stripe Checkout',1),(676,'paymentmethod_stripe_fee_fixed','0',0),(677,'paymentmethod_stripe_fee_percent','0',0),(678,'paymentmethod_stripe_api_publishable_key','',0),(679,'paymentmethod_stripe_api_secret_key','',0),(680,'paymentmethod_stripe_description_dashboard','Payment for Invoice {invoice_number}',0),(681,'paymentmethod_stripe_currencies','USD,CAD',0),(682,'paymentmethod_stripe_allow_primary_contact_to_update_credit_card','1',0),(683,'paymentmethod_stripe_default_selected','1',1),(684,'paymentmethod_stripe_initialized','1',1),(685,'paymentmethod_stripe_ideal_active','0',1),(686,'paymentmethod_stripe_ideal_label','Stripe iDEAL',1),(687,'paymentmethod_stripe_ideal_api_secret_key','',0),(688,'paymentmethod_stripe_ideal_api_publishable_key','',0),(689,'paymentmethod_stripe_ideal_description_dashboard','Payment for Invoice {invoice_number}',0),(690,'paymentmethod_stripe_ideal_statement_descriptor','Payment for Invoice {invoice_number}',0),(691,'paymentmethod_stripe_ideal_currencies','EUR',0),(692,'paymentmethod_stripe_ideal_default_selected','1',1),(693,'paymentmethod_stripe_ideal_initialized','1',1),(694,'paymentmethod_two_checkout_active','0',1),(695,'paymentmethod_two_checkout_label','2Checkout',1),(696,'paymentmethod_two_checkout_fee_fixed','0',0),(697,'paymentmethod_two_checkout_fee_percent','0',0),(698,'paymentmethod_two_checkout_merchant_code','',0),(699,'paymentmethod_two_checkout_secret_key','',0),(700,'paymentmethod_two_checkout_description','Payment for Invoice {invoice_number}',0),(701,'paymentmethod_two_checkout_currencies','USD, EUR, GBP',0),(702,'paymentmethod_two_checkout_test_mode_enabled','1',0),(703,'paymentmethod_two_checkout_default_selected','1',1),(704,'paymentmethod_two_checkout_initialized','1',1);

--
