
--
-- Table structure for table `Al-Mukhainici_sessions`
--

CREATE TABLE `Al-Mukhainici_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainici_sessions`
--

INSERT INTO `Al-Mukhainici_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('ee2b361cc5846df32eb69a071640573fbcbd776b','3.90.141.80',1657005514,_binary '__ci_last_regenerate|i:1657005514;'),('f30007e1945e0ff67c35a3ad334a0510656a21fb','3.90.141.80',1657005514,_binary '__ci_last_regenerate|i:1657005514;'),('4fe6da4a37af76cac92824fcfcfe6ecaa367d1d9','34.228.191.207',1657005514,_binary '__ci_last_regenerate|i:1657005514;'),('342c35c720244ea494301cd09fc7ae8a4165cfb6','34.228.191.207',1657005515,_binary '__ci_last_regenerate|i:1657005515;'),('c79348a7e3799b34aa16f94fb41d502589ed926d','197.252.216.110',1657019420,_binary '__ci_last_regenerate|i:1657019420;'),('55d2c0ca4d70f0ac7c708e31ce659048ee5f0e75','161.8.109.180',1686557527,_binary '__ci_last_regenerate|i:1686557527;');

--
-- Table structure for table `Al-Mukhainiclient_groups`
--

CREATE TABLE `Al-Mukhainiclient_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiclient_groups`
--


--
-- Table structure for table `Al-Mukhainiclients`
--

CREATE TABLE `Al-Mukhainiclients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiclients`
--


--
-- Table structure for table `Al-Mukhainicontacts`
--

CREATE TABLE `Al-Mukhainicontacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainicontacts`
--


--
-- Table structure for table `Al-Mukhainicustom_field_values`
--

CREATE TABLE `Al-Mukhainicustom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainicustom_field_values`
--


--
-- Table structure for table `Al-Mukhainicustom_fields`
--

CREATE TABLE `Al-Mukhainicustom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainicustom_fields`
--


--
-- Table structure for table `Al-Mukhainicustom_widgets`
--

CREATE TABLE `Al-Mukhainicustom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainicustom_widgets`
--


--
-- Table structure for table `Al-Mukhainidashboards`
--

CREATE TABLE `Al-Mukhainidashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainidashboards`
--


--
-- Table structure for table `Al-Mukhainidelivery_note_items`
--

CREATE TABLE `Al-Mukhainidelivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainidelivery_note_items`
--


--
-- Table structure for table `Al-Mukhainidelivery_notes`
--

CREATE TABLE `Al-Mukhainidelivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainidelivery_notes`
--


--
-- Table structure for table `Al-Mukhainiemail_templates`
--

CREATE TABLE `Al-Mukhainiemail_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiemail_templates`
--


--
-- Table structure for table `Al-Mukhainienteries`
--

CREATE TABLE `Al-Mukhainienteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `branch_id` int(11) DEFAULT '0',
  `concerned_person` int(11) DEFAULT '0',
  `unit` text,
  `reference` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Al-Mukhainienteries`
--


--
-- Table structure for table `Al-Mukhainiestimate_forms`
--

CREATE TABLE `Al-Mukhainiestimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiestimate_forms`
--


--
-- Table structure for table `Al-Mukhainiestimate_items`
--

CREATE TABLE `Al-Mukhainiestimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiestimate_items`
--


--
-- Table structure for table `Al-Mukhainiestimate_requests`
--

CREATE TABLE `Al-Mukhainiestimate_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_form_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('new','processing','hold','canceled','estimated') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiestimate_requests`
--


--
-- Table structure for table `Al-Mukhainiestimates`
--

CREATE TABLE `Al-Mukhainiestimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','sent','accepted','declined','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiestimates`
--


--
-- Table structure for table `Al-Mukhainievents`
--

CREATE TABLE `Al-Mukhainievents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainievents`
--


--
-- Table structure for table `Al-Mukhainiexpense_categories`
--

CREATE TABLE `Al-Mukhainiexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiexpense_categories`
--


--
-- Table structure for table `Al-Mukhainiexpenses`
--

CREATE TABLE `Al-Mukhainiexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiexpenses`
--


--
-- Table structure for table `Al-Mukhainigeneral_files`
--

CREATE TABLE `Al-Mukhainigeneral_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainigeneral_files`
--


--
-- Table structure for table `Al-Mukhainihelp_articles`
--

CREATE TABLE `Al-Mukhainihelp_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainihelp_articles`
--


--
-- Table structure for table `Al-Mukhainihelp_categories`
--

CREATE TABLE `Al-Mukhainihelp_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainihelp_categories`
--


--
-- Table structure for table `Al-Mukhainiinternal_transactions`
--

CREATE TABLE `Al-Mukhainiinternal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `Al-Mukhainiinternal_transactions`
--


--
-- Table structure for table `Al-Mukhainiinvoice_items`
--

CREATE TABLE `Al-Mukhainiinvoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiinvoice_items`
--


--
-- Table structure for table `Al-Mukhainiinvoice_payments`
--

CREATE TABLE `Al-Mukhainiinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiinvoice_payments`
--


--
-- Table structure for table `Al-Mukhainiinvoices`
--

CREATE TABLE `Al-Mukhainiinvoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `revised` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiinvoices`
--


--
-- Table structure for table `Al-Mukhainiitem_categories`
--

CREATE TABLE `Al-Mukhainiitem_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiitem_categories`
--


--
-- Table structure for table `Al-Mukhainiitems`
--

CREATE TABLE `Al-Mukhainiitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiitems`
--


--
-- Table structure for table `Al-Mukhainilead_source`
--

CREATE TABLE `Al-Mukhainilead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainilead_source`
--

INSERT INTO `Al-Mukhainilead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `Al-Mukhainilead_status`
--

CREATE TABLE `Al-Mukhainilead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainilead_status`
--

INSERT INTO `Al-Mukhainilead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `Al-Mukhainileads`
--

CREATE TABLE `Al-Mukhainileads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainileads`
--


--
-- Table structure for table `Al-Mukhainileave_applications`
--

CREATE TABLE `Al-Mukhainileave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `paid_unpaid` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainileave_applications`
--


--
-- Table structure for table `Al-Mukhainileave_types`
--

CREATE TABLE `Al-Mukhainileave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `max_allowed` int(11) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainileave_types`
--

INSERT INTO `Al-Mukhainileave_types` VALUES (1,'Casual Leave','active','#83c340','',1,0),(2,'Annual Leave','active','#83c340','',1,0),(3,'Emergency leave','active','#29c2c2','',1,0),(4,'Eid Vacation','active','#83c340','',1,0);

--
-- Table structure for table `Al-Mukhainiloans`
--

CREATE TABLE `Al-Mukhainiloans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiloans`
--


--
-- Table structure for table `Al-Mukhainimessages`
--

CREATE TABLE `Al-Mukhainimessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainimessages`
--


--
-- Table structure for table `Al-Mukhainimilestones`
--

CREATE TABLE `Al-Mukhainimilestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainimilestones`
--


--
-- Table structure for table `Al-Mukhaininotes`
--

CREATE TABLE `Al-Mukhaininotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhaininotes`
--


--
-- Table structure for table `Al-Mukhaininotification_settings`
--

CREATE TABLE `Al-Mukhaininotification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Al-Mukhaininotification_settings`
--

INSERT INTO `Al-Mukhaininotification_settings` VALUES (1,'project_created','project',0,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `Al-Mukhaininotifications`
--

CREATE TABLE `Al-Mukhaininotifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `notify_to` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `event` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `project_comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_comment_id` int(11) NOT NULL,
  `project_file_id` int(11) NOT NULL,
  `leave_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `activity_log_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `invoice_payment_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL,
  `actual_message_id` int(11) NOT NULL,
  `parent_message_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `announcement_id` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhaininotifications`
--


--
-- Table structure for table `Al-Mukhainipayment_methods`
--

CREATE TABLE `Al-Mukhainipayment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'custom',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `online_payable` tinyint(1) NOT NULL DEFAULT '0',
  `available_on_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_payment_amount` double NOT NULL DEFAULT '0',
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipayment_methods`
--

INSERT INTO `Al-Mukhainipayment_methods` VALUES (1,'Cash','custom','',0,0,0,'a:0:{}',0),(4,'Bank transfer / Card','custom','',0,0,0,'a:0:{}',0),(5,'Cheque','custom','',0,0,0,'a:0:{}',0);

--
-- Table structure for table `Al-Mukhainipaypal_ipn`
--

CREATE TABLE `Al-Mukhainipaypal_ipn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `ipn_hash` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ipn_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipaypal_ipn`
--


--
-- Table structure for table `Al-Mukhainipayroll`
--

CREATE TABLE `Al-Mukhainipayroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` date NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipayroll`
--


--
-- Table structure for table `Al-Mukhainipayroll_detail`
--

CREATE TABLE `Al-Mukhainipayroll_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `salary` float(8,3) NOT NULL,
  `manual_deduction` float(8,3) NOT NULL,
  `manual_deduction_reason` text COLLATE utf8_unicode_ci,
  `manual_bounce` float(8,3) NOT NULL,
  `manual_bonus_reason` text COLLATE utf8_unicode_ci,
  `advance` float(10,3) NOT NULL,
  `loan` float(10,3) NOT NULL,
  `pasi_company` double DEFAULT '0',
  `pasi_employee` double DEFAULT '0',
  `job_s_company` double DEFAULT '0',
  `job_s_employee` double DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipayroll_detail`
--


--
-- Table structure for table `Al-Mukhainiposts`
--

CREATE TABLE `Al-Mukhainiposts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `share_with` text COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiposts`
--


--
-- Table structure for table `Al-Mukhainiproject_comments`
--

CREATE TABLE `Al-Mukhainiproject_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `customer_feedback_id` int(11) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiproject_comments`
--


--
-- Table structure for table `Al-Mukhainiproject_files`
--

CREATE TABLE `Al-Mukhainiproject_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiproject_files`
--


--
-- Table structure for table `Al-Mukhainiproject_members`
--

CREATE TABLE `Al-Mukhainiproject_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiproject_members`
--


--
-- Table structure for table `Al-Mukhainiproject_settings`
--

CREATE TABLE `Al-Mukhainiproject_settings` (
  `project_id` int(11) NOT NULL,
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_index` (`project_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiproject_settings`
--


--
-- Table structure for table `Al-Mukhainiproject_time`
--

CREATE TABLE `Al-Mukhainiproject_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` enum('open','logged','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'logged',
  `note` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiproject_time`
--


--
-- Table structure for table `Al-Mukhainiprojects`
--

CREATE TABLE `Al-Mukhainiprojects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `status` enum('open','completed','hold','canceled','pending','') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `labels` text COLLATE utf8_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiprojects`
--


--
-- Table structure for table `Al-Mukhainipurchase_order_items`
--

CREATE TABLE `Al-Mukhainipurchase_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipurchase_order_items`
--


--
-- Table structure for table `Al-Mukhainipurchase_order_payments`
--

CREATE TABLE `Al-Mukhainipurchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `purchase_order_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `prepayment_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipurchase_order_payments`
--


--
-- Table structure for table `Al-Mukhainipurchase_orders`
--

CREATE TABLE `Al-Mukhainipurchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `purchase_order_date` date NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `status` enum('draft','not_paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipurchase_orders`
--


--
-- Table structure for table `Al-Mukhainipurchase_return_items`
--

CREATE TABLE `Al-Mukhainipurchase_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `purchase_return_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipurchase_return_items`
--


--
-- Table structure for table `Al-Mukhainipurchase_returns`
--

CREATE TABLE `Al-Mukhainipurchase_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `shipment_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainipurchase_returns`
--


--
-- Table structure for table `Al-Mukhainiroles`
--

CREATE TABLE `Al-Mukhainiroles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiroles`
--


--
-- Table structure for table `Al-Mukhainisalary_advance`
--

CREATE TABLE `Al-Mukhainisalary_advance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisalary_advance`
--


--
-- Table structure for table `Al-Mukhainisale_return_items`
--

CREATE TABLE `Al-Mukhainisale_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_return_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `invoice_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisale_return_items`
--


--
-- Table structure for table `Al-Mukhainisale_returns`
--

CREATE TABLE `Al-Mukhainisale_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisale_returns`
--


--
-- Table structure for table `Al-Mukhainisettings`
--

CREATE TABLE `Al-Mukhainisettings` (
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'app',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisettings`
--

INSERT INTO `Al-Mukhainisettings` VALUES ('accepted_file_formats','jpg,jpeg,doc,pdf,csv,pptx,xlsx,docx,png,rar','app',0),('allow_partial_invoice_payment_from_clients','','app',0),('allowed_ip_addresses','','app',0),('app_title','Teamway ERP','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','1','app',0),('client_can_comment_on_files','1','app',0),('client_can_comment_on_tasks','1','app',0),('client_can_create_projects','1','app',0),('client_can_create_tasks','1','app',0),('client_can_edit_tasks','1','app',0),('client_can_view_activity','1','app',0),('client_can_view_gantt','1','app',0),('client_can_view_milestones','1','app',0),('client_can_view_overview','1','app',0),('client_can_view_project_files','1','app',0),('client_can_view_tasks','1','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','1','app',0),('client_message_users','5','app',0),('company_address','Post Box No: 673, Postal Code: 113','app',0),('company_email','info@teamway.om','app',0),('company_name','Teamway ERP','app',0),('company_phone','00968 - 24619009','app',0),('company_vat_number','','app',0),('company_website','www.teamway.om','app',0),('currency_position','right','app',0),('currency_symbol',' /OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_bank','900','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#054d7f ','app',0),('estimate_logo','','app',0),('favicon','','app',0),('first_day_of_week','0','app',0),('hidden_client_menus','','app',0),('imap_email','info@teamway.om','app',0),('imap_host','','app',0),('imap_password','00000','app',0),('imap_port','','app',0),('imap_ssl_enabled','1','app',0),('initial_number_of_the_estimate','2','app',0),('initial_number_of_the_invoice','2','app',0),('invoice_color','#054d7f ','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_logo','','app',0),('invoice_prefix','','app',0),('item_purchase_code','53434654','app',0),('language','english','app',0),('module_announcement','1','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','1','app',0),('module_lead','1','app',0),('module_leave','1','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','1','app',0),('module_todo','1','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','','app',0),('site_logo','','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('user_1_allowed_distance','100000','user',0),('user_1_dashboard','','user',0),('user_1_disable_push_notification','0','user',0),('user_1_hidden_topbar_menus','','user',0),('user_1_location','23.620058326708097,58.24233084570313','user',0),('user_1_notification_sound_volume','4','user',0),('user_1_personal_language','english','user',0),('user_10_dashboard','','user',0),('user_10_personal_language','english','user',0),('user_11_dashboard','','user',0),('user_2_dashboard','','user',0),('user_21_dashboard','','user',0),('user_21_personal_language','english','user',0),('user_23_dashboard','','user',0),('user_24_dashboard','','user',0),('user_24_personal_language','arabic','user',0),('user_25_dashboard','','user',0),('user_25_personal_language','english','user',0),('user_3_dashboard','','user',0),('user_4_dashboard','','user',0),('user_5_allowed_distance','100000000','user',0),('user_5_dashboard','6','user',0),('user_5_disable_push_notification','1','user',0),('user_5_hidden_topbar_menus','','user',0),('user_5_location','23.673522614041882,57.680654820312505','user',0),('user_5_notification_sound_volume','7','user',0),('user_5_personal_language','english','user',0),('user_6_dashboard','','user',0),('user_6_personal_language','english','user',0),('weekend','5,6','app',0);

--
-- Table structure for table `Al-Mukhainishipment_items`
--

CREATE TABLE `Al-Mukhainishipment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `shipment_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainishipment_items`
--


--
-- Table structure for table `Al-Mukhainishipments`
--

CREATE TABLE `Al-Mukhainishipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `delivery_note_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_note_date` date DEFAULT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainishipments`
--


--
-- Table structure for table `Al-Mukhainisocial_links`
--

CREATE TABLE `Al-Mukhainisocial_links` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `facebook` text COLLATE utf8_unicode_ci,
  `twitter` text COLLATE utf8_unicode_ci,
  `linkedin` text COLLATE utf8_unicode_ci,
  `googleplus` text COLLATE utf8_unicode_ci,
  `digg` text COLLATE utf8_unicode_ci,
  `youtube` text COLLATE utf8_unicode_ci,
  `pinterest` text COLLATE utf8_unicode_ci,
  `instagram` text COLLATE utf8_unicode_ci,
  `github` text COLLATE utf8_unicode_ci,
  `tumblr` text COLLATE utf8_unicode_ci,
  `vine` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisocial_links`
--


--
-- Table structure for table `Al-Mukhainistock_adjustments`
--

CREATE TABLE `Al-Mukhainistock_adjustments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainistock_adjustments`
--


--
-- Table structure for table `Al-Mukhainisuppliers`
--

CREATE TABLE `Al-Mukhainisuppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainisuppliers`
--


--
-- Table structure for table `Al-Mukhainitask_status`
--

CREATE TABLE `Al-Mukhainitask_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `key_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainitask_status`
--

INSERT INTO `Al-Mukhainitask_status` VALUES (1,'To Do','to_do','#F9A52D',0,0),(2,'In progress','in_progress','#1672B9',1,0),(3,'Done','done','#00B393',2,0),(4,'holding','','#aab7b7',3,0);

--
-- Table structure for table `Al-Mukhainitasks`
--

CREATE TABLE `Al-Mukhainitasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `milestone_id` int(11) NOT NULL DEFAULT '0',
  `assigned_to` int(11) NOT NULL,
  `deadline` date DEFAULT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `points` tinyint(4) NOT NULL DEFAULT '1',
  `status` enum('to_do','in_progress','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `status_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `collaborators` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `recurring_task_id` int(11) NOT NULL DEFAULT '0',
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `next_recurring_date` date DEFAULT NULL,
  `reminder_date` date NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainitasks`
--


--
-- Table structure for table `Al-Mukhainitaxes`
--

CREATE TABLE `Al-Mukhainitaxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Al-Mukhainitaxes`
--

INSERT INTO `Al-Mukhainitaxes` VALUES (1,'VAT (5%)',5,0);

--
-- Table structure for table `Al-Mukhainiteam`
--

CREATE TABLE `Al-Mukhainiteam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `members` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiteam`
--


--
-- Table structure for table `Al-Mukhainiteam_member_job_info`
--

CREATE TABLE `Al-Mukhainiteam_member_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date_of_hire` date DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `salary` double NOT NULL DEFAULT '0',
  `salary_term` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `working_hours` int(11) DEFAULT NULL,
  `yearly_leaves` int(11) DEFAULT NULL,
  `housing` float DEFAULT '0',
  `transportation` float DEFAULT '0',
  `telephone` float DEFAULT '0',
  `utility` float DEFAULT '0',
  `national` tinyint(4) DEFAULT '0',
  `pasi` tinyint(4) DEFAULT '1',
  `bank_title` text COLLATE utf8_unicode_ci,
  `account_title` text COLLATE utf8_unicode_ci,
  `account_no` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiteam_member_job_info`
--


--
-- Table structure for table `Al-Mukhainiticket_comments`
--

CREATE TABLE `Al-Mukhainiticket_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiticket_comments`
--


--
-- Table structure for table `Al-Mukhainiticket_types`
--

CREATE TABLE `Al-Mukhainiticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainiticket_types`
--

INSERT INTO `Al-Mukhainiticket_types` VALUES (1,'General Support',0),(2,'One way',0),(3,'Two way',0);

--
-- Table structure for table `Al-Mukhainitickets`
--

CREATE TABLE `Al-Mukhainitickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `ticket_type_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `status` enum('new','client_replied','open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `last_activity_at` datetime DEFAULT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `creator_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `creator_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL,
  `closed_at` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainitickets`
--


--
-- Table structure for table `Al-Mukhainito_do`
--

CREATE TABLE `Al-Mukhainito_do` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `status` enum('to_do','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `start_date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Al-Mukhainito_do`
--


--
-- Table structure for table `Al-Mukhainitransactions`
--

CREATE TABLE `Al-Mukhainitransactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` text NOT NULL,
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `reference` text,
  `bank_cash` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Al-Mukhainitransactions`
--


--
-- Table structure for table `AlMukhainiaccounts`
--

CREATE TABLE `AlMukhainiaccounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `is_inactive` int(11) NOT NULL DEFAULT '0',
  `acc_description` text,
  `module_id` int(11) DEFAULT '0',
  `module` enum('suppliers','team_members','clients','expenses','assets') DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AlMukhainiaccounts`
--

INSERT INTO `AlMukhainiaccounts` VALUES (1,'Assets','1',0,1,0,NULL,NULL,NULL,0),(2,'Liabilities','2',0,1,0,NULL,0,NULL,0),(3,'Equity','3',0,1,0,NULL,0,NULL,0),(4,'Expenses','4',0,1,0,NULL,0,NULL,0),(5,'Income','5',0,1,0,NULL,0,NULL,0),(6,'Others','6',0,1,0,NULL,0,NULL,0),(7,'Receviable','1-1',1,1,0,NULL,0,NULL,0),(8,'Bank and Cash','1-2',1,1,0,NULL,0,NULL,0),(9,'Current Assets','1-3',1,1,0,NULL,0,NULL,0),(10,'Non Current Assets','1-4',1,1,0,NULL,0,NULL,0),(11,'Prepayments','1-5',1,1,0,NULL,0,NULL,0),(12,'Fixed Assets','1-6',1,1,0,NULL,0,NULL,0),(13,'Payable','2-1',2,1,0,NULL,0,NULL,0),(14,'Credit Card','2-2',2,1,0,NULL,0,NULL,0),(15,'Current Liabilities','2-3',2,1,0,NULL,0,NULL,0),(18,'Non Current Liabilities','2-4',2,1,0,NULL,0,NULL,0),(19,'Equity','3-1',3,1,0,NULL,0,NULL,0),(20,'Current Year Earnings','3-2',3,1,0,NULL,0,NULL,0),(21,'Expenses','4-1',4,1,0,NULL,0,NULL,0),(22,'Depreciation','4-2',4,1,0,NULL,0,NULL,0),(23,'Cost of Revenue','4-3',4,1,0,NULL,0,NULL,0),(24,'Income','5-1',5,1,0,NULL,0,NULL,0),(25,'Other Income','5-2',5,1,0,NULL,0,NULL,0),(26,'Off Balance Sheet','6-1',6,1,0,NULL,0,NULL,0),(38,'Advance Payments','2-5',2,1,0,NULL,0,NULL,0),(77,'Retained Earnings A/c','3-2-1',20,0,0,'',0,'clients',0);

--
-- Table structure for table `AlMukhainiactivity_logs`
--

CREATE TABLE `AlMukhainiactivity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiactivity_logs`
--


--
-- Table structure for table `AlMukhainiannouncements`
--

CREATE TABLE `AlMukhainiannouncements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiannouncements`
--


--
-- Table structure for table `AlMukhainiattendance`
--

CREATE TABLE `AlMukhainiattendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiattendance`
--


--
-- Table structure for table `AlMukhainichecklist_items`
--

CREATE TABLE `AlMukhainichecklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainichecklist_items`
--


--
-- Table structure for table `AlMukhainici_sessions`
--

CREATE TABLE `AlMukhainici_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainici_sessions`
--

INSERT INTO `AlMukhainici_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('c79348a7e3799b34aa16f94fb41d502589ed926d','197.252.216.110',1657019936,_binary '__ci_last_regenerate|i:1657019936;'),('0d2d49ec8ea63ba423c917504f84e3a581c1f4c4','197.252.216.110',1657020384,_binary '__ci_last_regenerate|i:1657020384;'),('8d6b892a17e69074dd66d3c960e0a9e85dca17ba','197.252.212.90',1657020588,_binary '__ci_last_regenerate|i:1657020384;');

--
-- Table structure for table `AlMukhainiclient_groups`
--

CREATE TABLE `AlMukhainiclient_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiclient_groups`
--


--
-- Table structure for table `AlMukhainiclients`
--

CREATE TABLE `AlMukhainiclients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiclients`
--


--
-- Table structure for table `AlMukhainicontacts`
--

CREATE TABLE `AlMukhainicontacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `job_title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `created_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainicontacts`
--


--
-- Table structure for table `AlMukhainicustom_field_values`
--

CREATE TABLE `AlMukhainicustom_field_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `related_to_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to_id` int(11) NOT NULL,
  `custom_field_id` int(11) NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainicustom_field_values`
--


--
-- Table structure for table `AlMukhainicustom_fields`
--

CREATE TABLE `AlMukhainicustom_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `placeholder` text COLLATE utf8_unicode_ci NOT NULL,
  `example_variable_name` text COLLATE utf8_unicode_ci,
  `options` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `related_to` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_table` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `show_in_estimate` tinyint(1) NOT NULL DEFAULT '0',
  `visible_to_admins_only` tinyint(1) NOT NULL DEFAULT '0',
  `hide_from_clients` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainicustom_fields`
--


--
-- Table structure for table `AlMukhainicustom_widgets`
--

CREATE TABLE `AlMukhainicustom_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `show_title` tinyint(1) NOT NULL DEFAULT '0',
  `show_border` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainicustom_widgets`
--


--
-- Table structure for table `AlMukhainidashboards`
--

CREATE TABLE `AlMukhainidashboards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci,
  `data` text COLLATE utf8_unicode_ci,
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainidashboards`
--


--
-- Table structure for table `AlMukhainidelivery_note_items`
--

CREATE TABLE `AlMukhainidelivery_note_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT '0',
  `invoice_item_id` int(11) DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `delivery_note_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainidelivery_note_items`
--


--
-- Table structure for table `AlMukhainidelivery_notes`
--

CREATE TABLE `AlMukhainidelivery_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `project_id` int(11) NOT NULL DEFAULT '0',
  `delivery_note_date` date NOT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `status` enum('draft','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainidelivery_notes`
--


--
-- Table structure for table `AlMukhainiemail_templates`
--

CREATE TABLE `AlMukhainiemail_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email_subject` text COLLATE utf8_unicode_ci NOT NULL,
  `default_message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `custom_message` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiemail_templates`
--


--
-- Table structure for table `AlMukhainienteries`
--

CREATE TABLE `AlMukhainienteries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trans_id` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `type` enum('dr','cr') NOT NULL,
  `amount` double NOT NULL,
  `narration` text NOT NULL,
  `branch_id` int(11) DEFAULT '0',
  `concerned_person` int(11) DEFAULT '0',
  `unit` text,
  `reference` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AlMukhainienteries`
--


--
-- Table structure for table `AlMukhainiestimate_forms`
--

CREATE TABLE `AlMukhainiestimate_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `enable_attachment` tinyint(4) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiestimate_forms`
--


--
-- Table structure for table `AlMukhainiestimate_items`
--

CREATE TABLE `AlMukhainiestimate_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiestimate_items`
--


--
-- Table structure for table `AlMukhainiestimate_requests`
--

CREATE TABLE `AlMukhainiestimate_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_form_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `assigned_to` int(11) NOT NULL,
  `status` enum('new','processing','hold','canceled','estimated') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiestimate_requests`
--


--
-- Table structure for table `AlMukhainiestimates`
--

CREATE TABLE `AlMukhainiestimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','sent','accepted','declined','approved','request_approval') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiestimates`
--


--
-- Table structure for table `AlMukhainievents`
--

CREATE TABLE `AlMukhainievents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `location` mediumtext COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `editable_google_event` tinyint(1) NOT NULL DEFAULT '0',
  `google_event_id` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `color` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` int(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `last_start_date` date DEFAULT NULL,
  `recurring_dates` longtext COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_by` text COLLATE utf8_unicode_ci NOT NULL,
  `rejected_by` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainievents`
--


--
-- Table structure for table `AlMukhainiexpense_categories`
--

CREATE TABLE `AlMukhainiexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiexpense_categories`
--


--
-- Table structure for table `AlMukhainiexpenses`
--

CREATE TABLE `AlMukhainiexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `amount` double NOT NULL,
  `payment_mode` enum('bank','cash_on_hand','cheque','reimbursement','pt_cash') COLLATE utf8_unicode_ci NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` int(11) DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` enum('draft','request_approval','approved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiexpenses`
--


--
-- Table structure for table `AlMukhainigeneral_files`
--

CREATE TABLE `AlMukhainigeneral_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `eroom_id` int(11) NOT NULL DEFAULT '0',
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainigeneral_files`
--


--
-- Table structure for table `AlMukhainihelp_articles`
--

CREATE TABLE `AlMukhainihelp_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainihelp_articles`
--


--
-- Table structure for table `AlMukhainihelp_categories`
--

CREATE TABLE `AlMukhainihelp_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('help','knowledge_base') COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainihelp_categories`
--


--
-- Table structure for table `AlMukhainiinternal_transactions`
--

CREATE TABLE `AlMukhainiinternal_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `from_employee` int(11) NOT NULL,
  `to_employee` int(11) NOT NULL,
  `amount` float(10,3) NOT NULL,
  `note` text COLLATE utf8_bin NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_bin NOT NULL DEFAULT 'draft',
  `transaction_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `AlMukhainiinternal_transactions`
--


--
-- Table structure for table `AlMukhainiinvoice_items`
--

CREATE TABLE `AlMukhainiinvoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiinvoice_items`
--


--
-- Table structure for table `AlMukhainiinvoice_payments`
--

CREATE TABLE `AlMukhainiinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `invoice_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `account_transaction_id` int(11) NOT NULL DEFAULT '0',
  `advance_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiinvoice_payments`
--


--
-- Table structure for table `AlMukhainiinvoices`
--

CREATE TABLE `AlMukhainiinvoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `bill_date` date NOT NULL,
  `due_date` date NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `last_email_sent_date` date DEFAULT NULL,
  `status` enum('draft','not_paid','cancelled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `delivery_status` enum('delivered','not_delivered') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_delivered',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `tax_id` int(11) NOT NULL DEFAULT '0',
  `tax_id2` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(4) NOT NULL DEFAULT '0',
  `recurring_invoice_id` int(11) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `next_recurring_date` date DEFAULT NULL,
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `due_reminder_date` date DEFAULT NULL,
  `recurring_reminder_date` date DEFAULT NULL,
  `discount_amount` double NOT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci NOT NULL,
  `discount_type` enum('before_tax','after_tax') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `revised` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiinvoices`
--


--
-- Table structure for table `AlMukhainiitem_categories`
--

CREATE TABLE `AlMukhainiitem_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiitem_categories`
--


--
-- Table structure for table `AlMukhainiitems`
--

CREATE TABLE `AlMukhainiitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cost` double NOT NULL,
  `rate` double NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_type` enum('product','service') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiitems`
--


--
-- Table structure for table `AlMukhainilead_source`
--

CREATE TABLE `AlMukhainilead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainilead_source`
--

INSERT INTO `AlMukhainilead_source` VALUES (1,'Google',1,0),(2,'Facebook',2,0),(3,'Twitter',3,0),(4,'Youtube',4,0),(5,'Elsewhere',5,0);

--
-- Table structure for table `AlMukhainilead_status`
--

CREATE TABLE `AlMukhainilead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainilead_status`
--

INSERT INTO `AlMukhainilead_status` VALUES (1,'New','#f1c40f',0,0),(2,'Qualified','#2d9cdb',1,0),(3,'Discussion','#29c2c2',2,0),(4,'Negotiation','#2d9cdb',3,0),(5,'Won','#83c340',4,0),(6,'Lost','#e74c3c',5,0);

--
-- Table structure for table `AlMukhainileads`
--

CREATE TABLE `AlMukhainileads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date NOT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainileads`
--


--
-- Table structure for table `AlMukhainileave_applications`
--

CREATE TABLE `AlMukhainileave_applications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type_id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_hours` decimal(7,2) NOT NULL,
  `total_days` decimal(5,2) NOT NULL,
  `applicant_id` int(11) NOT NULL,
  `reason` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('pending','approved','rejected','canceled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `checked_at` datetime DEFAULT NULL,
  `checked_by` int(11) NOT NULL DEFAULT '0',
  `paid_unpaid` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `leave_type_id` (`leave_type_id`),
  KEY `user_id` (`applicant_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainileave_applications`
--


--
-- Table structure for table `AlMukhainileave_types`
--

CREATE TABLE `AlMukhainileave_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `max_allowed` int(11) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainileave_types`
--

INSERT INTO `AlMukhainileave_types` VALUES (1,'Casual Leave','active','#83c340','',1,0),(2,'Annual Leave','active','#83c340','',1,0),(3,'Emergency leave','active','#29c2c2','',1,0),(4,'Eid Vacation','active','#83c340','',1,0);

--
-- Table structure for table `AlMukhainiloans`
--

CREATE TABLE `AlMukhainiloans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiloans`
--


--
-- Table structure for table `AlMukhainimessages`
--

CREATE TABLE `AlMukhainimessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `from_user_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `status` enum('unread','read') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unread',
  `message_id` int(11) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_by_users` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `message_from` (`from_user_id`),
  KEY `message_to` (`to_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainimessages`
--


--
-- Table structure for table `AlMukhainimilestones`
--

CREATE TABLE `AlMukhainimilestones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `due_date` date NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainimilestones`
--


--
-- Table structure for table `AlMukhaininotes`
--

CREATE TABLE `AlMukhaininotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci,
  `files` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhaininotes`
--


--
-- Table structure for table `AlMukhaininotification_settings`
--

CREATE TABLE `AlMukhaininotification_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event` varchar(250) NOT NULL,
  `category` varchar(50) NOT NULL,
  `enable_email` int(1) NOT NULL DEFAULT '0',
  `enable_web` int(1) NOT NULL DEFAULT '0',
  `notify_to_team` text NOT NULL,
  `notify_to_team_members` text NOT NULL,
  `notify_to_terms` text NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `event` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AlMukhaininotification_settings`
--

INSERT INTO `AlMukhaininotification_settings` VALUES (1,'project_created','project',0,1,'1','5','client_primary_contact,client_all_contacts',1,0),(2,'project_deleted','project',0,1,'1','5','project_members,client_primary_contact,client_all_contacts',2,0),(3,'project_task_created','project',0,1,'','5','project_members,task_assignee',3,0),(4,'project_task_updated','project',0,1,'','','task_assignee',4,0),(5,'project_task_assigned','project',0,1,'','','task_assignee',5,0),(7,'project_task_started','project',0,1,'','5','project_members,client_primary_contact,client_all_contacts',7,0),(8,'project_task_finished','project',0,0,'','','',8,0),(9,'project_task_reopened','project',0,0,'','','',9,0),(10,'project_task_deleted','project',0,1,'','','task_assignee',10,0),(11,'project_task_commented','project',0,1,'','','task_assignee',11,0),(12,'project_member_added','project',0,1,'','','project_members',12,0),(13,'project_member_deleted','project',0,1,'','','project_members',13,0),(14,'project_file_added','project',0,1,'','','project_members',14,0),(15,'project_file_deleted','project',0,1,'','','project_members',15,0),(16,'project_file_commented','project',0,1,'','','project_members',16,0),(17,'project_comment_added','project',0,1,'','','project_members',17,0),(18,'project_comment_replied','project',0,1,'','','project_members,comment_creator',18,0),(19,'project_customer_feedback_added','project',0,1,'','','project_members',19,0),(20,'project_customer_feedback_replied','project',0,1,'','','project_members,comment_creator',20,0),(21,'client_signup','client',0,0,'','','',21,0),(22,'invoice_online_payment_received','invoice',0,0,'','','',22,0),(23,'leave_application_submitted','leave',0,0,'','','',23,0),(24,'leave_approved','leave',0,1,'','','leave_applicant',24,0),(25,'leave_assigned','leave',0,1,'','','leave_applicant',25,0),(26,'leave_rejected','leave',0,1,'','','leave_applicant',26,0),(27,'leave_canceled','leave',0,0,'','','',27,0),(28,'ticket_created','ticket',0,1,'','6,7,5,11,12,1','client_all_contacts',28,0),(29,'ticket_commented','ticket',0,1,'','','client_primary_contact,ticket_creator',29,0),(30,'ticket_closed','ticket',0,1,'','','client_primary_contact,ticket_creator',30,0),(31,'ticket_reopened','ticket',0,1,'','','client_primary_contact,ticket_creator',31,0),(32,'estimate_request_received','estimate',0,0,'','','',32,0),(33,'estimate_sent','estimate',0,0,'','','',33,0),(34,'estimate_accepted','estimate',0,0,'','','',34,0),(35,'estimate_rejected','estimate',0,0,'','','',35,0),(36,'new_message_sent','message',0,0,'','','',36,0),(37,'message_reply_sent','message',0,0,'','','',37,0),(38,'invoice_payment_confirmation','invoice',0,0,'','','',22,0),(39,'new_event_added_in_calendar','event',0,0,'','','',39,0),(40,'recurring_invoice_created_vai_cron_job','invoice',0,0,'','','',22,0),(41,'new_announcement_created','announcement',1,1,'','','recipient',41,0),(42,'invoice_due_reminder_before_due_date','invoice',0,0,'','','',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',0,0,'','','',22,0),(45,'project_completed','project',0,0,'','','',2,0),(46,'lead_created','lead',0,0,'','','',21,0),(47,'client_created_from_lead','lead',0,0,'','','',21,0),(48,'project_task_deadline_pre_reminder','project',0,1,'','','task_assignee',20,0),(49,'project_task_reminder_on_the_day_of_deadline','project',0,1,'','','task_assignee',20,0),(50,'project_task_deadline_overdue_reminder','project',0,1,'','','task_assignee',20,0),(51,'recurring_task_created_via_cron_job','project',0,1,'','','project_members,task_assignee',20,0),(52,'calendar_event_modified','event',0,0,'','','',39,0);

--
-- Table structure for table `AlMukhaininotifications`
--

CREATE TABLE `AlMukhaininotifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `notify_to` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `event` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  `project_comment_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `ticket_comment_id` int(11) NOT NULL,
  `project_file_id` int(11) NOT NULL,
  `leave_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `to_user_id` int(11) NOT NULL,
  `activity_log_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `lead_id` int(11) NOT NULL,
  `invoice_payment_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `estimate_request_id` int(11) NOT NULL,
  `actual_message_id` int(11) NOT NULL,
  `parent_message_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `announcement_id` int(11) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhaininotifications`
--


--
-- Table structure for table `AlMukhainipayment_methods`
--

CREATE TABLE `AlMukhainipayment_methods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'custom',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `online_payable` tinyint(1) NOT NULL DEFAULT '0',
  `available_on_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_payment_amount` double NOT NULL DEFAULT '0',
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipayment_methods`
--

INSERT INTO `AlMukhainipayment_methods` VALUES (1,'Cash','custom','',0,0,0,'a:0:{}',0),(4,'Bank transfer / Card','custom','',0,0,0,'a:0:{}',0),(5,'Cheque','custom','',0,0,0,'a:0:{}',0);

--
-- Table structure for table `AlMukhainipaypal_ipn`
--

CREATE TABLE `AlMukhainipaypal_ipn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` tinytext COLLATE utf8_unicode_ci,
  `ipn_hash` longtext COLLATE utf8_unicode_ci NOT NULL,
  `ipn_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipaypal_ipn`
--


--
-- Table structure for table `AlMukhainipayroll`
--

CREATE TABLE `AlMukhainipayroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` date NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipayroll`
--


--
-- Table structure for table `AlMukhainipayroll_detail`
--

CREATE TABLE `AlMukhainipayroll_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `salary` float(8,3) NOT NULL,
  `manual_deduction` float(8,3) NOT NULL,
  `manual_deduction_reason` text COLLATE utf8_unicode_ci,
  `manual_bounce` float(8,3) NOT NULL,
  `manual_bonus_reason` text COLLATE utf8_unicode_ci,
  `advance` float(10,3) NOT NULL,
  `loan` float(10,3) NOT NULL,
  `pasi_company` double DEFAULT '0',
  `pasi_employee` double DEFAULT '0',
  `job_s_company` double DEFAULT '0',
  `job_s_employee` double DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipayroll_detail`
--


--
-- Table structure for table `AlMukhainiposts`
--

CREATE TABLE `AlMukhainiposts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `post_id` int(11) NOT NULL,
  `share_with` text COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiposts`
--


--
-- Table structure for table `AlMukhainiproject_comments`
--

CREATE TABLE `AlMukhainiproject_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `comment_id` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `file_id` int(11) NOT NULL DEFAULT '0',
  `customer_feedback_id` int(11) NOT NULL DEFAULT '0',
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiproject_comments`
--


--
-- Table structure for table `AlMukhainiproject_files`
--

CREATE TABLE `AlMukhainiproject_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `file_id` text COLLATE utf8_unicode_ci,
  `service_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `file_size` double NOT NULL,
  `created_at` datetime NOT NULL,
  `project_id` int(11) NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiproject_files`
--


--
-- Table structure for table `AlMukhainiproject_members`
--

CREATE TABLE `AlMukhainiproject_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `is_leader` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiproject_members`
--


--
-- Table structure for table `AlMukhainiproject_settings`
--

CREATE TABLE `AlMukhainiproject_settings` (
  `project_id` int(11) NOT NULL,
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `unique_index` (`project_id`,`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiproject_settings`
--


--
-- Table structure for table `AlMukhainiproject_time`
--

CREATE TABLE `AlMukhainiproject_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `status` enum('open','logged','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'logged',
  `note` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiproject_time`
--


--
-- Table structure for table `AlMukhainiprojects`
--

CREATE TABLE `AlMukhainiprojects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `client_id` int(11) NOT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `status` enum('open','completed','hold','canceled','pending','') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  `labels` text COLLATE utf8_unicode_ci,
  `price` double NOT NULL DEFAULT '0',
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiprojects`
--


--
-- Table structure for table `AlMukhainipurchase_order_items`
--

CREATE TABLE `AlMukhainipurchase_order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `quantity` double NOT NULL,
  `unit_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rate` double NOT NULL,
  `total` double NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `purchase_order_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipurchase_order_items`
--


--
-- Table structure for table `AlMukhainipurchase_order_payments`
--

CREATE TABLE `AlMukhainipurchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `payment_date` date NOT NULL,
  `payment_method_id` int(11) NOT NULL,
  `cheque_due_date` date DEFAULT NULL,
  `cheque_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_account` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_number` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cheque_transaction_id` int(11) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `purchase_order_id` int(11) NOT NULL,
  `status` enum('draft','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `prepayment_transaction_id` int(11) NOT NULL DEFAULT '0',
  `created_by` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipurchase_order_payments`
--


--
-- Table structure for table `AlMukhainipurchase_orders`
--

CREATE TABLE `AlMukhainipurchase_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `purchase_order_date` date NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `labels` text COLLATE utf8_unicode_ci NOT NULL,
  `note` mediumtext COLLATE utf8_unicode_ci,
  `status` enum('draft','not_paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft',
  `approval_status` enum('not_approved','request_approval','approved') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_approved',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipurchase_orders`
--


--
-- Table structure for table `AlMukhainipurchase_return_items`
--

CREATE TABLE `AlMukhainipurchase_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `purchase_return_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipurchase_return_items`
--


--
-- Table structure for table `AlMukhainipurchase_returns`
--

CREATE TABLE `AlMukhainipurchase_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `shipment_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainipurchase_returns`
--


--
-- Table structure for table `AlMukhainiroles`
--

CREATE TABLE `AlMukhainiroles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` mediumtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiroles`
--


--
-- Table structure for table `AlMukhainisalary_advance`
--

CREATE TABLE `AlMukhainisalary_advance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `date` date DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisalary_advance`
--


--
-- Table structure for table `AlMukhainisale_return_items`
--

CREATE TABLE `AlMukhainisale_return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_return_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `invoice_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisale_return_items`
--


--
-- Table structure for table `AlMukhainisale_returns`
--

CREATE TABLE `AlMukhainisale_returns` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `payment_method_id` int(11) DEFAULT '0',
  `transaction_id` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT 'draft',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisale_returns`
--


--
-- Table structure for table `AlMukhainisettings`
--

CREATE TABLE `AlMukhainisettings` (
  `setting_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'app',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `setting_name` (`setting_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisettings`
--

INSERT INTO `AlMukhainisettings` VALUES ('accepted_file_formats','jpg,jpeg,doc,pdf,csv,pptx,xlsx,docx,png,rar','app',0),('allow_partial_invoice_payment_from_clients','','app',0),('allowed_ip_addresses','','app',0),('app_title','Teamway ERP','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','1','app',0),('client_can_comment_on_files','1','app',0),('client_can_comment_on_tasks','1','app',0),('client_can_create_projects','1','app',0),('client_can_create_tasks','1','app',0),('client_can_edit_tasks','1','app',0),('client_can_view_activity','1','app',0),('client_can_view_gantt','1','app',0),('client_can_view_milestones','1','app',0),('client_can_view_overview','1','app',0),('client_can_view_project_files','1','app',0),('client_can_view_tasks','1','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','1','app',0),('client_message_users','5','app',0),('company_address','Post Box No: 673, Postal Code: 113','app',0),('company_email','info@teamway.om','app',0),('company_name','Teamway ERP','app',0),('company_phone','00968 - 24619009','app',0),('company_vat_number','','app',0),('company_website','www.teamway.om','app',0),('currency_position','right','app',0),('currency_symbol',' /OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_bank','900','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#054d7f ','app',0),('estimate_logo','','app',0),('favicon','','app',0),('first_day_of_week','0','app',0),('hidden_client_menus','','app',0),('imap_email','info@teamway.om','app',0),('imap_host','','app',0),('imap_password','00000','app',0),('imap_port','','app',0),('imap_ssl_enabled','1','app',0),('initial_number_of_the_estimate','2','app',0),('initial_number_of_the_invoice','2','app',0),('invoice_color','#054d7f ','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_logo','','app',0),('invoice_prefix','','app',0),('item_purchase_code','53434654','app',0),('language','english','app',0),('module_announcement','1','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','1','app',0),('module_lead','1','app',0),('module_leave','1','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','1','app',0),('module_todo','1','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','','app',0),('site_logo','','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('user_1_allowed_distance','100000','user',0),('user_1_dashboard','','user',0),('user_1_disable_push_notification','0','user',0),('user_1_hidden_topbar_menus','','user',0),('user_1_location','23.620058326708097,58.24233084570313','user',0),('user_1_notification_sound_volume','4','user',0),('user_1_personal_language','english','user',0),('user_10_dashboard','','user',0),('user_10_personal_language','english','user',0),('user_11_dashboard','','user',0),('user_2_dashboard','','user',0),('user_21_dashboard','','user',0),('user_21_personal_language','english','user',0),('user_23_dashboard','','user',0),('user_24_dashboard','','user',0),('user_24_personal_language','arabic','user',0),('user_25_dashboard','','user',0),('user_25_personal_language','english','user',0),('user_3_dashboard','','user',0),('user_4_dashboard','','user',0),('user_5_allowed_distance','100000000','user',0),('user_5_dashboard','6','user',0),('user_5_disable_push_notification','1','user',0),('user_5_hidden_topbar_menus','','user',0),('user_5_location','23.673522614041882,57.680654820312505','user',0),('user_5_notification_sound_volume','7','user',0),('user_5_personal_language','english','user',0),('user_6_dashboard','','user',0),('user_6_personal_language','english','user',0),('weekend','5,6','app',0);

--
-- Table structure for table `AlMukhainishipment_items`
--

CREATE TABLE `AlMukhainishipment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `po_item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `shipment_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainishipment_items`
--


--
-- Table structure for table `AlMukhainishipments`
--

CREATE TABLE `AlMukhainishipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_order_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL,
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `delivery_note_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_note_date` date DEFAULT NULL,
  `status` enum('draft','approved') COLLATE utf8_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainishipments`
--


--
-- Table structure for table `AlMukhainisocial_links`
--

CREATE TABLE `AlMukhainisocial_links` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `facebook` text COLLATE utf8_unicode_ci,
  `twitter` text COLLATE utf8_unicode_ci,
  `linkedin` text COLLATE utf8_unicode_ci,
  `googleplus` text COLLATE utf8_unicode_ci,
  `digg` text COLLATE utf8_unicode_ci,
  `youtube` text COLLATE utf8_unicode_ci,
  `pinterest` text COLLATE utf8_unicode_ci,
  `instagram` text COLLATE utf8_unicode_ci,
  `github` text COLLATE utf8_unicode_ci,
  `tumblr` text COLLATE utf8_unicode_ci,
  `vine` text COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisocial_links`
--


--
-- Table structure for table `AlMukhainistock_adjustments`
--

CREATE TABLE `AlMukhainistock_adjustments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `quantity` double NOT NULL DEFAULT '0',
  `note` text COLLATE utf8_unicode_ci,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainistock_adjustments`
--


--
-- Table structure for table `AlMukhainisuppliers`
--

CREATE TABLE `AlMukhainisuppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8_unicode_ci,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `website` text COLLATE utf8_unicode_ci,
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alternative_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `note` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainisuppliers`
--


--
-- Table structure for table `AlMukhainitask_status`
--

CREATE TABLE `AlMukhainitask_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `key_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainitask_status`
--

INSERT INTO `AlMukhainitask_status` VALUES (1,'To Do','to_do','#F9A52D',0,0),(2,'In progress','in_progress','#1672B9',1,0),(3,'Done','done','#00B393',2,0),(4,'holding','','#aab7b7',3,0);

--
-- Table structure for table `AlMukhainitasks`
--

CREATE TABLE `AlMukhainitasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `milestone_id` int(11) NOT NULL DEFAULT '0',
  `assigned_to` int(11) NOT NULL,
  `deadline` date DEFAULT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `points` tinyint(4) NOT NULL DEFAULT '1',
  `status` enum('to_do','in_progress','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `status_id` int(11) NOT NULL,
  `start_date` date DEFAULT NULL,
  `collaborators` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `recurring` tinyint(1) NOT NULL DEFAULT '0',
  `repeat_every` int(11) NOT NULL DEFAULT '0',
  `repeat_type` enum('days','weeks','months','years') COLLATE utf8_unicode_ci DEFAULT NULL,
  `no_of_cycles` int(11) NOT NULL DEFAULT '0',
  `recurring_task_id` int(11) NOT NULL DEFAULT '0',
  `no_of_cycles_completed` int(11) NOT NULL DEFAULT '0',
  `created_date` date NOT NULL,
  `next_recurring_date` date DEFAULT NULL,
  `reminder_date` date NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `deleted` tinyint(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainitasks`
--


--
-- Table structure for table `AlMukhainitaxes`
--

CREATE TABLE `AlMukhainitaxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AlMukhainitaxes`
--

INSERT INTO `AlMukhainitaxes` VALUES (1,'VAT (5%)',5,0);

--
-- Table structure for table `AlMukhainiteam`
--

CREATE TABLE `AlMukhainiteam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `members` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiteam`
--


--
-- Table structure for table `AlMukhainiteam_member_job_info`
--

CREATE TABLE `AlMukhainiteam_member_job_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `date_of_hire` date DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `salary` double NOT NULL DEFAULT '0',
  `salary_term` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `working_hours` int(11) DEFAULT NULL,
  `yearly_leaves` int(11) DEFAULT NULL,
  `housing` float DEFAULT '0',
  `transportation` float DEFAULT '0',
  `telephone` float DEFAULT '0',
  `utility` float DEFAULT '0',
  `national` tinyint(4) DEFAULT '0',
  `pasi` tinyint(4) DEFAULT '1',
  `bank_title` text COLLATE utf8_unicode_ci,
  `account_title` text COLLATE utf8_unicode_ci,
  `account_no` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiteam_member_job_info`
--


--
-- Table structure for table `AlMukhainiticket_comments`
--

CREATE TABLE `AlMukhainiticket_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `files` longtext COLLATE utf8_unicode_ci,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiticket_comments`
--


--
-- Table structure for table `AlMukhainiticket_types`
--

CREATE TABLE `AlMukhainiticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainiticket_types`
--

INSERT INTO `AlMukhainiticket_types` VALUES (1,'General Support',0),(2,'One way',0),(3,'Two way',0);

--
-- Table structure for table `AlMukhainitickets`
--

CREATE TABLE `AlMukhainitickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `ticket_type_id` int(11) NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `status` enum('new','client_replied','open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `last_activity_at` datetime DEFAULT NULL,
  `assigned_to` int(11) NOT NULL DEFAULT '0',
  `creator_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `creator_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `labels` text COLLATE utf8_unicode_ci,
  `task_id` int(11) NOT NULL,
  `closed_at` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainitickets`
--


--
-- Table structure for table `AlMukhainito_do`
--

CREATE TABLE `AlMukhainito_do` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_by` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci,
  `labels` text COLLATE utf8_unicode_ci,
  `status` enum('to_do','done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'to_do',
  `start_date` date DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AlMukhainito_do`
--


--
-- Table structure for table `AlMukhainitransactions`
--

CREATE TABLE `AlMukhainitransactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `type` text NOT NULL,
  `is_manual` tinyint(1) NOT NULL DEFAULT '0',
  `reference` text,
  `bank_cash` int(11) DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AlMukhainitransactions`
--


--
-- Table structure for table `BinYdeedaccounts`
--

CREATE TABLE `BinYdeedaccounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acc_name` varchar(255) NOT NULL,
  `acc_code` varchar(255) DEFAULT NULL,
  `acc_parent` int(11) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `is_inactive` int(11) NOT NULL DEFAULT '0',
  `acc_description` text,
  `module_id` int(11) DEFAULT '0',
  `module` enum('suppliers','team_members','clients','expenses','assets') DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `BinYdeedaccounts`
--

INSERT INTO `BinYdeedaccounts` VALUES (1,'Asset','Asset',0,0,0,'Asset',NULL,NULL,0),(2,'Liabilities','2',0,1,0,NULL,0,NULL,0),(3,'Equity','3',0,1,0,NULL,0,NULL,0),(4,'Expenses','4',0,1,0,NULL,0,NULL,0),(5,'Income','5',0,1,0,NULL,0,NULL,0),(6,'Others','6',0,1,0,NULL,0,NULL,0),(7,'Receviable','1-1-1',7,1,0,'DUE 28/9/2022',NULL,NULL,0),(8,'current assets','Asset-1',1,1,0,'short team asset ',NULL,NULL,0),(9,'Current Assets','1-3',1,1,0,NULL,0,NULL,0),(10,'Non Current Assets','1-4',1,1,0,NULL,0,NULL,0),(11,'Prepayments','1-5',1,1,0,NULL,0,NULL,0),(12,'Fixed Assets','1-6',1,1,0,NULL,0,NULL,0),(13,'Payable','2-1',2,1,0,NULL,0,NULL,0),(14,'Credit Card','2-2',2,1,0,NULL,0,NULL,0),(15,'Current Liabilities','2-3',2,1,0,NULL,0,NULL,0),(18,'Non Current Liabilities','2-4',2,1,0,NULL,0,NULL,0),(19,'Equity','3-1',3,1,0,NULL,0,NULL,0),(20,'Current Year Earnings','3-2',3,1,0,NULL,0,NULL,0),(21,'Expenses','4-1',4,1,0,NULL,0,NULL,0),(22,'Depreciation','4-2',4,1,0,NULL,0,NULL,0),(23,'Cost of Revenue','4-3',4,1,0,NULL,0,NULL,0),(24,'Income','5-1',5,1,0,NULL,0,NULL,0),(25,'Other Income','5-2',5,1,0,NULL,0,NULL,0),(26,'Off Balance Sheet','6-1',6,1,0,NULL,0,NULL,0),(38,'Advance Payments','2-5',2,1,0,NULL,0,NULL,0),(77,'Retained Earnings A/c','3-2-1',20,0,0,'',0,'clients',0),(78,'MOHAMMED','2-1-1',13,0,0,NULL,0,NULL,0),(79,'MIddle East Tyres LLC','2-1-2',13,0,0,NULL,0,NULL,0),(80,'Electricity','4-1-1',21,0,0,NULL,0,NULL,0),(81,'BANK','1-2-1',8,0,0,'',NULL,NULL,0),(82,'MUSCAT BANK','1-2-1-1',81,0,0,'',NULL,NULL,0),(83,'said aljabri','1-1-1-2',7,0,0,NULL,0,NULL,0),(84,'AL Shouniz Trading','1-1-1-3',7,0,0,NULL,0,NULL,0),(85,'SOHAR ALUMINIUM COMPANY LLC','1-1-1-4',7,0,0,NULL,0,NULL,0),(86,'Bin Ydeed Trading ','1-1-1-5',7,0,0,NULL,0,NULL,0),(87,'Diesel ','4-1-2',21,0,0,NULL,0,NULL,0),(88,'Petroleum for Car','4-1-3',21,0,0,NULL,0,NULL,0),(89,'water','4-1-4',21,0,0,NULL,0,NULL,0),(90,'stationary','4-1-5',21,0,0,NULL,0,NULL,0),(91,'Salary','4-1-6',21,0,0,NULL,0,NULL,0),(92,'Travel Expense','4-1-7',21,0,0,NULL,0,NULL,0),(93,'Tools','4-1-8',21,0,0,NULL,0,NULL,0),(94,'National Plastic Factory LLC','1-1-1-6',7,0,0,NULL,0,NULL,0),(95,'Clients','Asset-6',1,0,0,'opening balance ',NULL,NULL,0);

--
-- Table structure for table `BinYdeedactivity_logs`
--

CREATE TABLE `BinYdeedactivity_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `action` enum('created','updated','deleted') COLLATE utf8_unicode_ci NOT NULL,
  `log_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `log_type_title` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `log_type_id` int(11) NOT NULL DEFAULT '0',
  `changes` mediumtext COLLATE utf8_unicode_ci,
  `log_for` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `log_for_id` int(11) NOT NULL DEFAULT '0',
  `log_for2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_for_id2` int(11) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=316 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedactivity_logs`
--

INSERT INTO `BinYdeedactivity_logs` VALUES (1,'2022-10-06 12:38:41',1,'created','item_categories','',1,NULL,'',0,'',0,0),(2,'2022-10-06 12:38:59',1,'created','item_categories','',2,NULL,'',0,'',0,0),(3,'2022-10-06 15:06:00',1,'created','items','',1,NULL,'',0,'',0,0),(4,'2022-10-06 15:07:43',1,'created','clients','',1,NULL,'',0,'',0,0),(5,'2022-10-06 15:07:43',1,'created','invoices','',1,NULL,'',0,'',0,0),(6,'2022-10-06 15:08:01',1,'created','invoice_items','',1,NULL,'',0,'',0,0),(7,'2022-10-06 15:08:21',1,'created','invoice_items','',2,NULL,'',0,'',0,0),(8,'2022-10-06 15:08:50',1,'created','invoice_items','',3,NULL,'',0,'',0,0),(9,'2022-10-06 15:09:03',1,'deleted','invoice_items','',3,NULL,'',0,NULL,NULL,0),(10,'2022-10-06 15:09:06',1,'deleted','invoice_items','',1,NULL,'',0,NULL,NULL,0),(11,'2022-10-06 15:09:08',1,'deleted','invoice_items','',2,NULL,'',0,NULL,NULL,0),(12,'2022-10-06 15:10:41',1,'deleted','invoices','',1,NULL,'',0,NULL,NULL,0),(13,'2022-10-06 15:16:49',1,'created','clients','',2,NULL,'',0,'',0,0),(14,'2022-10-06 15:16:49',1,'updated','clients','',2,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:85;}}','',0,'',0,0),(15,'2022-10-06 15:17:34',1,'created','invoices','',2,NULL,'',0,'',0,0),(16,'2022-10-06 15:19:36',1,'created','invoice_items','',4,NULL,'',0,'',0,0),(17,'2022-10-06 15:20:50',1,'updated','invoices','',2,'a:3:{s:13:\"discount_type\";a:2:{s:4:\"from\";s:10:\"before_tax\";s:2:\"to\";s:15:\"before_discount\";}s:15:\"discount_amount\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:2:\"10\";}s:20:\"discount_amount_type\";a:2:{s:4:\"from\";s:10:\"percentage\";s:2:\"to\";s:12:\"fixed_amount\";}}','',0,'',0,0),(18,'2022-10-06 15:25:42',1,'deleted','invoices','',2,NULL,'',0,NULL,NULL,0),(19,'2022-10-07 19:06:03',1,'deleted','items','',1,NULL,'',0,NULL,NULL,0),(20,'2022-10-07 19:11:19',1,'updated','clients','',2,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(21,'2022-10-07 19:12:19',1,'updated','clients','',1,'a:4:{s:5:\"email\";a:2:{s:4:\"from\";N;s:2:\"to\";s:18:\"sales@binydeed.com\";}s:7:\"website\";a:2:{s:4:\"from\";N;s:2:\"to\";s:16:\"www.binydeed.com\";}s:10:\"vat_number\";a:2:{s:4:\"from\";N;s:2:\"to\";s:12:\"OM1100039942\";}s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(22,'2022-10-07 19:12:19',1,'updated','clients','',1,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:86;}}','',0,'',0,0),(23,'2022-10-07 19:16:19',1,'created','estimates','',1,NULL,'',0,'',0,0),(24,'2022-10-07 19:26:09',1,'created','items','',2,NULL,'',0,'',0,0),(25,'2022-10-07 19:26:34',1,'created','item_categories','',3,NULL,'',0,'',0,0),(26,'2022-10-07 19:26:53',1,'updated','items','',2,'a:1:{s:11:\"category_id\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:1:\"3\";}}','',0,'',0,0),(27,'2022-10-07 19:28:02',1,'created','estimate_items','',1,NULL,'',0,'',0,0),(28,'2022-10-07 19:29:29',1,'created','estimates','',2,NULL,'',0,'',0,0),(29,'2022-10-07 19:29:29',1,'created','estimate_items','',2,NULL,'',0,'',0,0),(30,'2022-10-07 19:31:12',1,'created','invoices','',3,NULL,'',0,'',0,0),(31,'2022-10-07 19:31:31',1,'created','invoice_items','',5,NULL,'',0,'',0,0),(32,'2022-10-07 19:31:51',1,'updated','invoices','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(33,'2022-10-07 19:33:27',1,'created','invoice_payments','',1,NULL,'',0,'',0,0),(34,'2022-10-07 19:35:11',1,'updated','invoices','',3,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(35,'2022-10-07 19:49:10',1,'created','item_categories','',4,NULL,'',0,'',0,0),(36,'2022-10-07 19:49:28',1,'created','item_categories','',5,NULL,'',0,'',0,0),(37,'2022-10-07 19:49:40',1,'created','item_categories','',6,NULL,'',0,'',0,0),(38,'2022-10-07 19:50:40',1,'created','item_categories','',7,NULL,'',0,'',0,0),(39,'2022-10-07 19:50:52',1,'created','item_categories','',8,NULL,'',0,'',0,0),(40,'2022-10-07 19:51:24',1,'created','item_categories','',9,NULL,'',0,'',0,0),(41,'2022-10-07 19:53:25',1,'created','items','',3,NULL,'',0,'',0,0),(42,'2022-10-07 19:56:34',1,'created','items','',4,NULL,'',0,'',0,0),(43,'2022-10-07 19:58:10',1,'created','items','',5,NULL,'',0,'',0,0),(44,'2022-10-07 20:01:08',1,'created','items','',6,NULL,'',0,'',0,0),(45,'2022-10-07 20:01:54',1,'updated','items','',2,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:8:\"Deestone\";s:2:\"to\";s:8:\"DEESTONE\";}}','',0,'',0,0),(46,'2022-10-07 20:02:06',1,'updated','items','',2,'a:1:{s:11:\"category_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";s:1:\"4\";}}','',0,'',0,0),(47,'2022-10-07 20:10:36',1,'created','expenses','',1,NULL,'',0,'',0,0),(48,'2022-10-08 06:17:22',1,'deleted','invoice_payments','',1,NULL,'',0,NULL,NULL,0),(49,'2022-10-08 07:32:13',1,'deleted','items','',2,NULL,'',0,NULL,NULL,0),(50,'2022-10-08 07:35:23',1,'created','items','',7,NULL,'',0,'',0,0),(51,'2022-10-08 07:37:11',1,'created','items','',8,NULL,'',0,'',0,0),(52,'2022-10-08 07:46:15',1,'created','items','',9,NULL,'',0,'',0,0),(53,'2022-10-08 07:48:02',1,'updated','items','',4,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:47:\"15.5/80/25 12PR D308 E4 EU DEESTONE THAILAND TL\";s:2:\"to\";s:47:\"15.5/80/24 12PR D308 E4 EU DEESTONE THAILAND TL\";}}','',0,'',0,0),(54,'2022-10-08 07:51:07',1,'created','items','',10,NULL,'',0,'',0,0),(55,'2022-10-08 07:52:26',1,'created','items','',11,NULL,'',0,'',0,0),(56,'2022-10-08 07:53:41',1,'created','items','',12,NULL,'',0,'',0,0),(57,'2022-10-08 07:58:55',1,'created','items','',13,NULL,'',0,'',0,0),(58,'2022-10-08 08:00:59',1,'created','items','',14,NULL,'',0,'',0,0),(59,'2022-10-08 08:01:38',1,'created','invoices','',4,NULL,'',0,'',0,0),(60,'2022-10-08 08:02:58',1,'created','invoice_items','',6,NULL,'',0,'',0,0),(61,'2022-10-08 08:03:15',1,'created','invoice_items','',7,NULL,'',0,'',0,0),(62,'2022-10-08 08:03:29',1,'created','invoice_items','',8,NULL,'',0,'',0,0),(63,'2022-10-08 08:14:41',1,'created','items','',15,NULL,'',0,'',0,0),(64,'2022-10-08 08:15:12',1,'created','invoice_items','',9,NULL,'',0,'',0,0),(65,'2022-10-08 08:15:37',1,'deleted','invoices','',4,NULL,'',0,NULL,NULL,0),(66,'2022-10-08 08:18:23',1,'created','items','',16,NULL,'',0,'',0,0),(67,'2022-10-08 08:18:58',1,'updated','items','',15,'a:1:{s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"70\";s:2:\"to\";s:2:\"65\";}}','',0,'',0,0),(68,'2022-10-08 08:48:50',1,'created','items','',17,NULL,'',0,'',0,0),(69,'2022-10-08 08:54:57',1,'created','items','',18,NULL,'',0,'',0,0),(70,'2022-10-08 08:59:35',1,'updated','items','',7,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:9:\"DEESTONE \";s:2:\"to\";s:41:\"17.5/25 16PR D318 EU DEESTONE THAILAND TL\";}}','',0,'',0,0),(71,'2022-10-08 09:00:23',1,'created','invoices','',5,NULL,'',0,'',0,0),(72,'2022-10-08 09:00:54',1,'created','invoice_items','',10,NULL,'',0,'',0,0),(73,'2022-10-08 09:01:26',1,'updated','invoice_items','',10,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"17.5/25 16PR D318 EU DEESTONE THAILAND TL\";s:2:\"to\";s:7:\"17.5/15\";}s:11:\"description\";a:2:{s:4:\"from\";s:40:\"600/9 10PR D306 EU DEESTONE THAILAND TTF\";s:2:\"to\";s:0:\"\";}}','',0,'',0,0),(74,'2022-10-08 09:01:31',1,'deleted','invoice_items','',10,NULL,'',0,NULL,NULL,0),(75,'2022-10-08 09:01:45',1,'created','invoice_items','',11,NULL,'',0,'',0,0),(76,'2022-10-08 09:19:38',1,'updated','items','',7,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"17.5/25 16PR D318 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"17.5/25 16PR D318 EU DEESTONE THAILAND TL\";s:2:\"to\";s:23:\"17.5/25 16PR D318 EU TL\";}}','',0,'',0,0),(77,'2022-10-08 09:20:06',1,'updated','items','',6,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:8:\"DEESTONE\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(78,'2022-10-08 09:20:18',1,'updated','items','',5,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:8:\"DEESTONE\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(79,'2022-10-08 09:20:25',1,'updated','items','',4,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:8:\"DEESTONE\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(80,'2022-10-08 09:21:31',1,'updated','items','',8,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:44:\"18.4/26 12PR D314 E4 EU DEESTONE THAILAND TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}s:11:\"description\";a:2:{s:4:\"from\";s:44:\"18.4/26 12PR D314 E4 EU DEESTONE THAILAND TL\";s:2:\"to\";s:26:\"18.4/26 12PR D314 E4 EU TL\";}}','',0,'',0,0),(81,'2022-10-08 09:21:57',1,'updated','items','',9,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"1400/24 16PR D310 EU DEESTONE THAILAND TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"1400/24 16PR D310 EU DEESTONE THAILAND TL\";s:2:\"to\";s:23:\"1400/24 16PR D310 EU TL\";}}','',0,'',0,0),(82,'2022-10-08 09:24:10',1,'updated','items','',10,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"1600/25 32PR D313 EU DEESTONE THAILAND TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"1600/25 32PR D313 EU DEESTONE THAILAND TL\";s:2:\"to\";s:23:\"1600/25 32PR D313 EU TL\";}}','',0,'',0,0),(83,'2022-10-08 09:32:26',1,'updated','items','',4,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:29:\"15.5/80/24 12PR D308 E4 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:47:\"15.5/80/24 12PR D308 E4 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(84,'2022-10-08 09:33:08',1,'created','invoice_items','',12,NULL,'',0,'',0,0),(85,'2022-10-08 09:33:50',1,'updated','invoices','',5,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(86,'2022-10-08 09:35:51',1,'created','estimate_items','',3,NULL,'',0,'',0,0),(87,'2022-10-08 09:36:03',1,'created','estimate_items','',4,NULL,'',0,'',0,0),(88,'2022-10-08 09:36:11',1,'updated','estimates','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(89,'2022-10-08 09:38:21',1,'updated','estimates','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:8:\"accepted\";}}','',0,'',0,0),(90,'2022-10-08 09:38:52',1,'created','invoices','',6,NULL,'',0,'',0,0),(91,'2022-10-08 09:38:52',1,'updated','invoices','',6,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(92,'2022-10-08 09:38:52',1,'created','invoice_items','',13,NULL,'',0,'',0,0),(93,'2022-10-08 09:38:52',1,'created','invoice_items','',14,NULL,'',0,'',0,0),(94,'2022-10-08 09:38:52',1,'created','invoice_items','',15,NULL,'',0,'',0,0),(95,'2022-10-08 13:56:47',1,'created','clients','',3,NULL,'',0,'',0,0),(96,'2022-10-08 13:56:47',1,'updated','clients','',3,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:94;}}','',0,'',0,0),(97,'2022-10-08 13:57:15',1,'updated','estimates','',2,'a:2:{s:9:\"client_id\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:1:\"3\";}s:4:\"note\";a:2:{s:4:\"from\";s:71:\"1. price with out fitting\n2. One Year warranty\n3. delivery immediately \";s:2:\"to\";s:67:\"1. price with fitting\n2. One Year warranty\n3. delivery immediately \";}}','',0,'',0,0),(98,'2022-10-08 13:57:39',1,'deleted','estimate_items','',2,NULL,'',0,NULL,NULL,0),(99,'2022-10-08 13:58:00',1,'created','estimate_items','',5,NULL,'',0,'',0,0),(100,'2022-10-08 13:58:14',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(101,'2022-10-08 14:15:33',1,'updated','items','',15,'a:3:{s:5:\"title\";a:2:{s:4:\"from\";s:40:\"700/12 12PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:40:\"700/12 12PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:22:\"700/12 12PR D301 EU TL\";}s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"65\";s:2:\"to\";s:2:\"60\";}}','',0,'',0,0),(102,'2022-10-08 14:15:57',1,'updated','items','',14,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:40:\"650/10 10PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:40:\"650/10 10PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:22:\"650/10 10PR D301 EU TL\";}}','',0,'',0,0),(103,'2022-10-08 14:16:31',1,'updated','items','',11,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"20.5/25 20PR D313 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"20.5/25 20PR D313 EU DEESTONE THAILAND TL\";s:2:\"to\";s:23:\"20.5/25 20PR D313 EU TL\";}}','',0,'',0,0),(104,'2022-10-08 14:17:20',1,'updated','items','',12,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"10/16.5 10PR D311 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"10/16.5 10PR D311 EU DEESTONE THAILAND TL\";s:2:\"to\";s:23:\"10/16.5 10PR D311 EU TL\";}}','',0,'',0,0),(105,'2022-10-08 14:17:39',1,'updated','items','',13,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:40:\"300/15 20PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:40:\"300/15 20PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:22:\"300/15 20PR D301 EU TL\";}}','',0,'',0,0),(106,'2022-10-08 14:18:14',1,'updated','items','',16,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:49:\"815/15(28/9/15) 14PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:49:\"815/15(28/9/15) 14PR D301 EU DEESTONE THAILAND TL\";s:2:\"to\";s:31:\"815/15(28/9/15) 14PR D301 EU TL\";}}','',0,'',0,0),(107,'2022-10-08 14:18:29',1,'updated','items','',17,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:41:\"825/15 14PR D301 EU DEESTONE THAILAND TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:41:\"825/15 14PR D301 EU DEESTONE THAILAND TTF\";s:2:\"to\";s:23:\"825/15 14PR D301 EU TTF\";}}','',0,'',0,0),(108,'2022-10-08 14:18:47',1,'updated','items','',18,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:40:\"600/9 10PR D306 EU DEESTONE THAILAND TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}s:11:\"description\";a:2:{s:4:\"from\";s:40:\"600/9 10PR D306 EU DEESTONE THAILAND TTF\";s:2:\"to\";s:22:\"600/9 10PR D306 EU TTF\";}}','',0,'',0,0),(109,'2022-10-08 14:19:01',1,'updated','items','',15,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:22:\"700/12 12PR D301 EU TL\";s:2:\"to\";s:23:\"700/12 12PR D301 EU TTF\";}}','',0,'',0,0),(110,'2022-10-08 14:19:12',1,'updated','items','',14,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:22:\"650/10 10PR D301 EU TL\";s:2:\"to\";s:23:\"650/10 10PR D301 EU TTF\";}}','',0,'',0,0),(111,'2022-10-08 14:19:22',1,'updated','items','',13,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:22:\"300/15 20PR D301 EU TL\";s:2:\"to\";s:23:\"300/15 20PR D301 EU TTF\";}}','',0,'',0,0),(112,'2022-10-08 14:19:36',1,'updated','items','',16,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:31:\"815/15(28/9/15) 14PR D301 EU TL\";s:2:\"to\";s:32:\"815/15(28/9/15) 14PR D301 EU TTF\";}}','',0,'',0,0),(113,'2022-10-08 14:20:06',1,'updated','items','',4,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:29:\"15.5/80/24 12PR D308 E4 EU TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}s:11:\"description\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:30:\"15.5/80/24 12PR D308 E4 EU TL \";}}','',0,'',0,0),(114,'2022-10-08 14:21:41',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(115,'2022-10-08 14:22:42',1,'created','estimate_items','',6,NULL,'',0,'',0,0),(116,'2022-10-08 14:22:53',1,'deleted','estimate_items','',5,NULL,'',0,NULL,NULL,0),(117,'2022-10-08 14:22:59',1,'deleted','estimate_items','',5,NULL,'',0,NULL,NULL,0),(118,'2022-10-08 14:23:00',1,'deleted','estimate_items','',5,NULL,'',0,NULL,NULL,0),(119,'2022-10-08 14:23:00',1,'deleted','estimate_items','',5,NULL,'',0,NULL,NULL,0),(120,'2022-10-08 14:23:00',1,'deleted','estimate_items','',5,NULL,'',0,NULL,NULL,0),(121,'2022-10-08 14:23:32',1,'created','estimate_items','',7,NULL,'',0,'',0,0),(122,'2022-10-08 14:23:37',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(123,'2022-10-08 14:23:58',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(124,'2022-10-08 14:24:03',1,'deleted','estimate_items','',6,NULL,'',0,NULL,NULL,0),(125,'2022-10-08 14:24:10',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(126,'2022-10-08 14:26:04',1,'updated','items','',3,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:4:\"BOTO\";s:2:\"to\";s:26:\"315/80R22.5 20PR BT168 TL \";}s:11:\"description\";a:2:{s:4:\"from\";s:36:\"315/80R22.5 20PR BT168 BOTO TL CHINA\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(127,'2022-10-08 14:26:26',1,'updated','items','',4,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:30:\"15.5/80/24 12PR D308 E4 EU TL \";}s:11:\"description\";a:2:{s:4:\"from\";s:30:\"15.5/80/24 12PR D308 E4 EU TL \";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(128,'2022-10-08 14:27:02',1,'updated','items','',5,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:21:\"1000/20 16PR D309 TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:39:\"1000/20 16PR D309 DEESTONE THAILAND TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(129,'2022-10-08 14:27:31',1,'updated','items','',6,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:27:\"15.5/25 12PR DL-2 E3/L3  TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:44:\"15.5/25 12PR DL-2 E3/L3 DEESTONE THAILAND TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(130,'2022-10-08 14:27:56',1,'updated','items','',15,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"700/12 12PR D301 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"700/12 12PR D301 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(131,'2022-10-08 14:28:20',1,'updated','items','',16,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:32:\"815/15(28/9/15) 14PR D301 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:32:\"815/15(28/9/15) 14PR D301 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(132,'2022-10-08 14:28:40',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(133,'2022-10-08 14:28:44',1,'deleted','estimate_items','',7,NULL,'',0,NULL,NULL,0),(134,'2022-10-08 14:29:02',1,'created','estimate_items','',8,NULL,'',0,'',0,0),(135,'2022-10-08 14:29:27',1,'updated','estimate_items','',8,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"60\";s:2:\"to\";s:2:\"65\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"120\";s:2:\"to\";i:130;}}','',0,'',0,0),(136,'2022-10-08 14:29:37',1,'updated','estimates','',2,'a:2:{s:15:\"discount_amount\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:2:\"10\";}s:20:\"discount_amount_type\";a:2:{s:4:\"from\";s:10:\"percentage\";s:2:\"to\";s:12:\"fixed_amount\";}}','',0,'',0,0),(137,'2022-10-08 14:30:09',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(138,'2022-10-10 07:33:48',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:8:\"accepted\";}}','',0,'',0,0),(139,'2022-10-10 07:34:10',1,'created','invoices','',7,NULL,'',0,'',0,0),(140,'2022-10-10 07:34:10',1,'updated','invoices','',7,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(141,'2022-10-10 07:34:10',1,'created','invoice_items','',16,NULL,'',0,'',0,0),(142,'2022-10-10 07:37:50',1,'created','invoices','',8,NULL,'',0,'',0,0),(143,'2022-10-10 07:37:50',1,'updated','invoices','',8,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(144,'2022-10-10 07:37:50',1,'created','invoice_items','',17,NULL,'',0,'',0,0),(145,'2022-10-10 07:38:46',1,'created','invoice_payments','',2,NULL,'',0,'',0,0),(146,'2022-10-10 07:38:46',1,'updated','invoices','',8,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(147,'2022-10-10 08:04:10',1,'created','delivery_notes','',1,NULL,'',0,'',0,0),(148,'2022-10-10 08:04:10',1,'created','delivery_note_items','',1,NULL,'',0,'',0,0),(149,'2022-10-10 08:04:23',1,'updated','delivery_notes','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(150,'2022-10-10 08:04:23',1,'updated','invoices','',8,'a:1:{s:15:\"delivery_status\";a:2:{s:4:\"from\";s:13:\"not_delivered\";s:2:\"to\";s:9:\"delivered\";}}','',0,'',0,0),(151,'2022-10-10 08:21:40',1,'created','invoice_payments','',3,NULL,'',0,'',0,0),(152,'2022-10-10 08:21:40',1,'updated','invoices','',6,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(153,'2022-10-10 08:22:22',1,'created','invoice_payments','',4,NULL,'',0,'',0,0),(154,'2022-10-10 08:47:12',1,'updated','invoice_payments','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(155,'2022-10-10 08:47:12',1,'updated','invoice_payments','',3,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:3;}}','',0,'',0,0),(156,'2022-10-10 08:47:22',1,'updated','invoice_payments','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(157,'2022-10-10 08:47:22',1,'updated','invoice_payments','',4,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:4;}}','',0,'',0,0),(158,'2022-10-10 09:10:47',1,'created','invoices','',9,NULL,'',0,'',0,0),(159,'2022-10-10 09:11:49',1,'created','invoice_items','',18,NULL,'',0,'',0,0),(160,'2022-10-10 09:12:02',1,'created','invoice_items','',19,NULL,'',0,'',0,0),(161,'2022-10-10 09:12:25',1,'created','invoice_items','',20,NULL,'',0,'',0,0),(162,'2022-10-10 09:13:33',1,'updated','invoices','',9,'a:2:{s:13:\"discount_type\";a:2:{s:4:\"from\";s:10:\"before_tax\";s:2:\"to\";s:15:\"before_discount\";}s:15:\"discount_amount\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:3:\"100\";}}','',0,'',0,0),(163,'2022-10-10 09:13:42',1,'updated','invoices','',9,'a:2:{s:13:\"discount_type\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:15:\"before_discount\";}s:20:\"discount_amount_type\";a:2:{s:4:\"from\";s:10:\"percentage\";s:2:\"to\";s:12:\"fixed_amount\";}}','',0,'',0,0),(164,'2022-10-10 09:13:49',1,'updated','invoices','',9,'a:2:{s:13:\"discount_type\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:15:\"before_discount\";}s:15:\"discount_amount\";a:2:{s:4:\"from\";s:3:\"100\";s:2:\"to\";s:1:\"0\";}}','',0,'',0,0),(165,'2022-10-10 09:22:38',1,'created','items','',19,NULL,'',0,'',0,0),(166,'2022-10-10 09:22:38',1,'created','items','',20,NULL,'',0,'',0,0),(167,'2022-10-10 09:22:38',1,'created','items','',21,NULL,'',0,'',0,0),(168,'2022-10-10 09:22:38',1,'created','items','',22,NULL,'',0,'',0,0),(169,'2022-10-10 09:22:38',1,'created','items','',23,NULL,'',0,'',0,0),(170,'2022-10-10 09:22:38',1,'created','items','',24,NULL,'',0,'',0,0),(171,'2022-10-10 09:22:38',1,'created','items','',25,NULL,'',0,'',0,0),(172,'2022-10-10 09:22:38',1,'created','items','',26,NULL,'',0,'',0,0),(173,'2022-10-10 09:22:38',1,'created','items','',27,NULL,'',0,'',0,0),(174,'2022-10-10 09:23:19',1,'updated','items','',8,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:26:\"18.4/26 12PR D314 E4 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:26:\"18.4/26 12PR D314 E4 EU TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(175,'2022-10-10 09:23:38',1,'updated','items','',9,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:23:\"1400/24 16PR D310 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"1400/24 16PR D310 EU TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(176,'2022-10-10 09:23:56',1,'updated','items','',10,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:17:\"DEESTONE THAILAND\";s:2:\"to\";s:23:\"1600/25 32PR D313 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"1600/25 32PR D313 EU TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(177,'2022-10-10 09:24:15',1,'updated','items','',11,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:24:\"20.5/25 20PR D313 EU TL \";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"20.5/25 20PR D313 EU TL\";s:2:\"to\";s:17:\"DEESTONE THAILAND\";}}','',0,'',0,0),(178,'2022-10-10 09:24:31',1,'updated','items','',12,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"10/16.5 10PR D311 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"10/16.5 10PR D311 EU TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(179,'2022-10-10 09:24:47',1,'updated','items','',13,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"300/15 20PR D301 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"300/15 20PR D301 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(180,'2022-10-10 09:25:01',1,'updated','items','',14,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"650/10 10PR D301 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"650/10 10PR D301 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(181,'2022-10-10 09:25:17',1,'updated','items','',17,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"825/15 14PR D301 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"825/15 14PR D301 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(182,'2022-10-10 09:33:59',1,'created','items','',28,NULL,'',0,'',0,0),(183,'2022-10-10 09:33:59',1,'created','items','',29,NULL,'',0,'',0,0),(184,'2022-10-10 09:33:59',1,'created','items','',30,NULL,'',0,'',0,0),(185,'2022-10-10 09:33:59',1,'created','items','',31,NULL,'',0,'',0,0),(186,'2022-10-10 09:33:59',1,'created','items','',32,NULL,'',0,'',0,0),(187,'2022-10-10 09:33:59',1,'created','items','',33,NULL,'',0,'',0,0),(188,'2022-10-10 09:33:59',1,'created','items','',34,NULL,'',0,'',0,0),(189,'2022-10-10 09:33:59',1,'created','items','',35,NULL,'',0,'',0,0),(190,'2022-10-10 09:33:59',1,'created','items','',36,NULL,'',0,'',0,0),(191,'2022-10-10 09:33:59',1,'created','items','',37,NULL,'',0,'',0,0),(192,'2022-10-10 09:33:59',1,'created','items','',38,NULL,'',0,'',0,0),(193,'2022-10-10 09:33:59',1,'created','items','',39,NULL,'',0,'',0,0),(194,'2022-10-10 09:33:59',1,'created','items','',40,NULL,'',0,'',0,0),(195,'2022-10-10 13:06:27',1,'created','invoice_items','',21,NULL,'',0,'',0,0),(196,'2022-10-10 13:06:45',1,'deleted','invoices','',9,NULL,'',0,NULL,NULL,0),(197,'2022-10-10 13:08:36',1,'created','sale_returns','',1,NULL,'',0,'',0,0),(198,'2022-10-10 13:08:36',1,'created','sale_return_items','',1,NULL,'',0,'',0,0),(199,'2022-10-10 13:08:36',1,'created','sale_return_items','',2,NULL,'',0,'',0,0),(200,'2022-10-10 13:08:36',1,'created','sale_return_items','',3,NULL,'',0,'',0,0),(201,'2022-10-10 13:09:23',1,'updated','sale_returns','',1,'a:1:{s:4:\"note\";a:2:{s:4:\"from\";s:1:\"c\";s:2:\"to\";s:9:\"item no2\n\";}}','',0,'',0,0),(202,'2022-10-10 13:09:32',1,'updated','sale_returns','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(203,'2022-10-10 13:12:08',1,'created','delivery_notes','',2,NULL,'',0,'',0,0),(204,'2022-10-10 13:12:08',1,'created','delivery_note_items','',2,NULL,'',0,'',0,0),(205,'2022-10-10 13:12:08',1,'created','delivery_note_items','',3,NULL,'',0,'',0,0),(206,'2022-10-10 13:12:08',1,'created','delivery_note_items','',4,NULL,'',0,'',0,0),(207,'2022-10-10 13:12:20',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"10\";s:2:\"to\";i:9;}}','',0,'',0,0),(208,'2022-10-10 13:12:21',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"9\";s:2:\"to\";i:8;}}','',0,'',0,0),(209,'2022-10-10 13:12:21',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"8\";s:2:\"to\";i:7;}}','',0,'',0,0),(210,'2022-10-10 13:12:21',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"7\";s:2:\"to\";i:6;}}','',0,'',0,0),(211,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"6\";s:2:\"to\";i:5;}}','',0,'',0,0),(212,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"5\";s:2:\"to\";i:4;}}','',0,'',0,0),(213,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";i:3;}}','',0,'',0,0),(214,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";i:2;}}','',0,'',0,0),(215,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";i:1;}}','',0,'',0,0),(216,'2022-10-10 13:12:23',1,'updated','delivery_note_items','',4,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";i:0;}}','',0,'',0,0),(217,'2022-10-10 13:12:27',1,'updated','delivery_note_items','',3,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"10\";s:2:\"to\";i:9;}}','',0,'',0,0),(218,'2022-10-10 13:12:27',1,'updated','delivery_note_items','',3,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"9\";s:2:\"to\";i:8;}}','',0,'',0,0),(219,'2022-10-10 13:12:27',1,'updated','delivery_note_items','',3,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"8\";s:2:\"to\";i:7;}}','',0,'',0,0),(220,'2022-10-10 13:12:54',1,'updated','delivery_notes','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(221,'2022-10-10 13:12:54',1,'updated','invoices','',6,'a:1:{s:15:\"delivery_status\";a:2:{s:4:\"from\";s:13:\"not_delivered\";s:2:\"to\";s:9:\"delivered\";}}','',0,'',0,0),(222,'2022-10-10 13:14:57',1,'created','invoices','',10,NULL,'',0,'',0,0),(223,'2022-10-10 13:14:57',1,'updated','invoices','',10,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(224,'2022-10-10 13:14:57',1,'created','invoice_items','',22,NULL,'',0,'',0,0),(225,'2022-10-10 13:17:04',1,'created','estimates','',3,NULL,'',0,'',0,0),(226,'2022-10-10 13:17:20',1,'created','estimate_items','',9,NULL,'',0,'',0,0),(227,'2022-10-10 13:17:20',1,'created','estimate_items','',10,NULL,'',0,'',0,0),(228,'2022-10-10 13:17:20',1,'created','estimate_items','',11,NULL,'',0,'',0,0),(229,'2022-10-10 13:17:29',1,'updated','estimate_items','',9,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";s:2:\"10\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"150\";s:2:\"to\";i:1500;}}','',0,'',0,0),(230,'2022-10-10 13:17:35',1,'updated','estimate_items','',10,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";s:2:\"50\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"175\";s:2:\"to\";i:8750;}}','',0,'',0,0),(231,'2022-10-10 13:17:41',1,'updated','estimate_items','',11,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";s:2:\"45\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"215\";s:2:\"to\";i:9675;}}','',0,'',0,0),(232,'2022-10-10 13:17:50',1,'updated','estimate_items','',9,'a:1:{s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(233,'2022-10-10 13:18:03',1,'updated','estimate_items','',10,'a:1:{s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(234,'2022-10-10 13:18:08',1,'updated','estimate_items','',11,'a:1:{s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(235,'2022-10-10 13:18:24',1,'updated','estimates','',3,'a:2:{s:15:\"discount_amount\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:3:\"100\";}s:20:\"discount_amount_type\";a:2:{s:4:\"from\";s:10:\"percentage\";s:2:\"to\";s:12:\"fixed_amount\";}}','',0,'',0,0),(236,'2022-10-10 13:18:48',1,'updated','estimate_items','',9,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"10\";s:2:\"to\";s:1:\"1\";}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"1500\";s:2:\"to\";i:150;}}','',0,'',0,0),(237,'2022-10-10 13:18:55',1,'updated','estimate_items','',10,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"50\";s:2:\"to\";s:1:\"1\";}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"8750\";s:2:\"to\";i:175;}}','',0,'',0,0),(238,'2022-10-10 13:18:59',1,'updated','estimate_items','',11,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"45\";s:2:\"to\";s:1:\"1\";}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"9675\";s:2:\"to\";i:215;}}','',0,'',0,0),(239,'2022-10-10 13:21:19',1,'updated','estimates','',3,'a:1:{s:15:\"discount_amount\";a:2:{s:4:\"from\";s:3:\"100\";s:2:\"to\";s:1:\"0\";}}','',0,'',0,0),(240,'2022-10-10 13:21:46',1,'created','estimate_items','',12,NULL,'',0,'',0,0),(241,'2022-10-10 13:21:58',1,'created','estimate_items','',13,NULL,'',0,'',0,0),(242,'2022-10-10 13:22:29',1,'created','estimate_items','',14,NULL,'',0,'',0,0),(243,'2022-10-10 13:23:12',1,'updated','estimate_items','',14,'a:1:{s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(244,'2022-10-10 13:23:26',1,'updated','estimate_items','',14,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"70\";s:2:\"to\";s:2:\"66\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"700\";s:2:\"to\";i:660;}}','',0,'',0,0),(245,'2022-10-10 13:23:35',1,'updated','estimate_items','',14,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"66\";s:2:\"to\";s:2:\"75\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"660\";s:2:\"to\";i:750;}}','',0,'',0,0),(246,'2022-10-10 13:23:57',1,'created','estimates','',4,NULL,'',0,'',0,0),(247,'2022-10-10 13:23:57',1,'created','estimate_items','',15,NULL,'',0,'',0,0),(248,'2022-10-10 13:23:57',1,'created','estimate_items','',16,NULL,'',0,'',0,0),(249,'2022-10-10 13:23:57',1,'created','estimate_items','',17,NULL,'',0,'',0,0),(250,'2022-10-10 13:23:57',1,'created','estimate_items','',18,NULL,'',0,'',0,0),(251,'2022-10-10 13:23:57',1,'created','estimate_items','',19,NULL,'',0,'',0,0),(252,'2022-10-10 13:23:57',1,'created','estimate_items','',20,NULL,'',0,'',0,0),(253,'2022-10-10 13:24:22',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(254,'2022-10-10 13:24:36',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(255,'2022-10-10 13:24:41',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(256,'2022-10-10 13:25:09',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(257,'2022-10-10 13:25:47',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(258,'2022-10-10 13:25:51',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(259,'2022-10-10 13:26:15',1,'updated','estimates','',4,'a:1:{s:9:\"client_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";s:1:\"2\";}}','',0,'',0,0),(260,'2022-10-11 04:58:22',1,'created','item_categories','',10,NULL,'',0,'',0,0),(261,'2022-10-11 04:58:22',1,'created','items','',41,NULL,'',0,'',0,0),(262,'2022-10-11 04:58:22',1,'created','items','',42,NULL,'',0,'',0,0),(263,'2022-10-11 04:58:22',1,'created','items','',43,NULL,'',0,'',0,0),(264,'2022-10-11 04:58:22',1,'created','items','',44,NULL,'',0,'',0,0),(265,'2022-10-11 04:58:22',1,'created','items','',45,NULL,'',0,'',0,0),(266,'2022-10-11 04:58:22',1,'created','items','',46,NULL,'',0,'',0,0),(267,'2022-10-11 04:58:22',1,'created','items','',47,NULL,'',0,'',0,0),(268,'2022-10-11 04:58:22',1,'created','items','',48,NULL,'',0,'',0,0),(269,'2022-10-11 04:58:22',1,'created','items','',49,NULL,'',0,'',0,0),(270,'2022-10-11 04:58:22',1,'created','items','',50,NULL,'',0,'',0,0),(271,'2022-10-11 05:06:11',1,'created','item_categories','',11,NULL,'',0,'',0,0),(272,'2022-10-11 05:06:11',1,'created','items','',51,NULL,'',0,'',0,0),(273,'2022-10-11 05:06:11',1,'created','items','',52,NULL,'',0,'',0,0),(274,'2022-10-11 05:06:11',1,'created','items','',53,NULL,'',0,'',0,0),(275,'2022-10-11 05:06:11',1,'created','items','',54,NULL,'',0,'',0,0),(276,'2022-10-11 05:08:20',1,'created','clients','',4,NULL,'',0,'',0,0),(277,'2022-10-11 05:08:21',1,'created','invoices','',11,NULL,'',0,'',0,0),(278,'2022-10-11 05:11:42',1,'created','invoice_items','',23,NULL,'',0,'',0,0),(279,'2022-10-11 05:11:49',1,'updated','invoice_items','',23,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:3:\"115\";s:2:\"to\";s:5:\"110.5\";}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"230\";s:2:\"to\";d:221;}}','',0,'',0,0),(280,'2022-10-11 05:12:05',1,'created','invoice_items','',24,NULL,'',0,'',0,0),(281,'2022-10-11 05:14:17',1,'created','invoice_payments','',5,NULL,'',0,'',0,0),(282,'2022-10-11 05:14:17',1,'updated','invoices','',11,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(283,'2022-10-11 05:15:29',1,'updated','invoices','',11,'a:1:{s:4:\"note\";a:2:{s:4:\"from\";s:121:\"Note:\n1. Serial No: 2111201256,2201308631,2201313864,2201313860\n1102208082,1112303077\n2. As Agree Tyres with out warranty\";s:2:\"to\";s:197:\"Note:\n1. Serial No: 2111201256,2201308631,2201313864,2201313860\n1102208082,1112303077\n2. As Agree Tyres with out warranty\n3. payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat\";}}','',0,'',0,0),(284,'2022-10-11 05:15:40',1,'updated','invoices','',11,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(285,'2022-10-11 05:16:42',1,'created','delivery_notes','',3,NULL,'',0,'',0,0),(286,'2022-10-11 05:16:42',1,'created','delivery_note_items','',5,NULL,'',0,'',0,0),(287,'2022-10-11 05:16:42',1,'created','delivery_note_items','',6,NULL,'',0,'',0,0),(288,'2022-10-11 05:16:50',1,'updated','delivery_notes','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(289,'2022-10-11 05:16:50',1,'updated','invoices','',11,'a:1:{s:15:\"delivery_status\";a:2:{s:4:\"from\";s:13:\"not_delivered\";s:2:\"to\";s:9:\"delivered\";}}','',0,'',0,0),(290,'2022-10-11 08:11:13',1,'updated','invoice_payments','',5,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(291,'2022-10-11 08:11:13',1,'updated','invoice_payments','',5,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:9;}}','',0,'',0,0),(292,'2022-10-11 08:11:57',1,'updated','invoice_payments','',5,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(293,'2022-10-11 08:11:57',1,'updated','invoice_payments','',5,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"9\";s:2:\"to\";i:0;}}','',0,'',0,0),(294,'2022-10-11 08:44:04',1,'updated','items','',42,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(295,'2022-10-11 08:44:28',1,'updated','items','',43,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(296,'2022-10-11 08:44:46',1,'updated','items','',41,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(297,'2022-10-11 08:44:54',1,'updated','items','',44,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(298,'2022-10-11 08:45:02',1,'updated','items','',45,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(299,'2022-10-11 08:45:12',1,'updated','items','',46,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(300,'2022-10-11 08:45:24',1,'updated','items','',47,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(301,'2022-10-11 08:45:31',1,'updated','items','',48,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(302,'2022-10-11 08:45:42',1,'updated','items','',49,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(303,'2022-10-11 08:45:51',1,'updated','items','',50,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO BTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(304,'2022-10-11 08:45:59',1,'updated','items','',51,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO OTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(305,'2022-10-11 08:47:31',1,'updated','items','',52,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO OTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(306,'2022-10-11 08:47:37',1,'updated','items','',53,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO OTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(307,'2022-10-11 08:48:04',1,'updated','items','',54,'a:1:{s:11:\"description\";a:2:{s:4:\"from\";s:8:\"BOTO OTR\";s:2:\"to\";s:10:\"BOTO CHINA\";}}','',0,'',0,0),(308,'2022-10-11 08:48:22',1,'updated','items','',18,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:22:\"600/9 10PR D306 EU TTF\";}s:11:\"description\";a:2:{s:4:\"from\";s:22:\"600/9 10PR D306 EU TTF\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(309,'2022-10-11 08:49:15',1,'updated','items','',7,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:18:\"DEESTONE THAILAND \";s:2:\"to\";s:23:\"17.5/25 16PR D318 EU TL\";}s:11:\"description\";a:2:{s:4:\"from\";s:23:\"17.5/25 16PR D318 EU TL\";s:2:\"to\";s:18:\"DEESTONE THAILAND \";}}','',0,'',0,0),(310,'2022-10-11 08:51:38',1,'updated','items','',19,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:25:\"600/9  4.00 X treme Plus \";s:2:\"to\";s:29:\"600/9  4.00 X STD treme Plus \";}s:11:\"description\";a:2:{s:4:\"from\";s:13:\"ECOMASTER STD\";s:2:\"to\";s:19:\"Ecomaster Sri lanka\";}}','',0,'',0,0),(311,'2022-10-11 08:51:52',1,'updated','items','',20,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:27:\"6.50-10  5.00 X treme Plus \";s:2:\"to\";s:31:\"6.50-10  5.00 STD X treme Plus \";}s:11:\"description\";a:2:{s:4:\"from\";s:13:\"ECOMASTER STD\";s:2:\"to\";s:19:\"Ecomaster Sri lanka\";}}','',0,'',0,0),(312,'2022-10-11 08:52:05',1,'updated','items','',21,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:27:\"7.00-12/5.00  X treme Plus \";s:2:\"to\";s:31:\"7.00-12/5.00  STD X treme Plus \";}s:11:\"description\";a:2:{s:4:\"from\";s:13:\"ECOMASTER STD\";s:2:\"to\";s:19:\"Ecomaster Sri lanka\";}}','',0,'',0,0),(313,'2022-10-11 08:52:44',1,'updated','items','',22,'a:2:{s:5:\"title\";a:2:{s:4:\"from\";s:21:\"300-15/8.00 ECOMASTER\";s:2:\"to\";s:22:\"300-15 8.00 STD SOLID \";}s:11:\"description\";a:2:{s:4:\"from\";s:13:\"ECOMASTER STD\";s:2:\"to\";s:19:\"Ecomaster Sri lanka\";}}','',0,'',0,0),(314,'2022-10-12 13:46:35',1,'updated','invoice_payments','',5,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(315,'2022-10-12 13:46:35',1,'updated','invoice_payments','',5,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:10;}}','',0,'',0,0);

--
-- Table structure for table `BinYdeedannouncements`
--

CREATE TABLE `BinYdeedannouncements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int(11) NOT NULL,
  `share_with` mediumtext COLLATE utf8_unicode_ci,
  `created_at` datetime NOT NULL,
  `files` text COLLATE utf8_unicode_ci NOT NULL,
  `read_by` mediumtext COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedannouncements`
--


--
-- Table structure for table `BinYdeedattendance`
--

CREATE TABLE `BinYdeedattendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` enum('incomplete','pending','approved','rejected','deleted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'incomplete',
  `user_id` int(11) NOT NULL,
  `in_time` datetime NOT NULL,
  `out_time` datetime DEFAULT NULL,
  `checked_by` int(11) DEFAULT NULL,
  `note` text COLLATE utf8_unicode_ci,
  `checked_at` datetime DEFAULT NULL,
  `reject_reason` text COLLATE utf8_unicode_ci,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `checked_by` (`checked_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedattendance`
--


--
-- Table structure for table `BinYdeedchecklist_items`
--

CREATE TABLE `BinYdeedchecklist_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `is_checked` int(11) NOT NULL DEFAULT '0',
  `task_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedchecklist_items`
--


--
-- Table structure for table `BinYdeedci_sessions`
--

CREATE TABLE `BinYdeedci_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedci_sessions`
--

INSERT INTO `BinYdeedci_sessions` VALUES ('5db20a6d1b2f22ae44aae209b8db7ece38dbbc97','161.8.109.180',1665054866,_binary '__ci_last_regenerate|i:1665054713;user_id|s:1:\"1\";'),('ede4cd20b5beef2ba12285f418bc848fe43302ac','37.40.226.47',1665063716,_binary '__ci_last_regenerate|i:1665063716;user_id|s:1:\"1\";'),('31a5e7debad7ebae2fbd884c2dd18b6faf945a4d','37.40.226.47',1665066435,_binary '__ci_last_regenerate|i:1665066434;user_id|s:1:\"1\";'),('25f45a1584a820b6e4c8ce1bf008cf96692daaac','37.40.226.47',1665067001,_binary '__ci_last_regenerate|i:1665067001;user_id|s:1:\"1\";'),('5fb198950fcd3a0107d0a54249506dc6a39b7066','37.40.226.47',1665067339,_binary '__ci_last_regenerate|i:1665067339;user_id|s:1:\"1\";'),('479b07d6c04b1e3c9ab734f350b9db815c95d4fc','37.40.226.47',1665067707,_binary '__ci_last_regenerate|i:1665067707;user_id|s:1:\"1\";'),('013f31204c9cc5389d6acf98b36c74c5735efef7','37.40.226.47',1665068110,_binary '__ci_last_regenerate|i:1665068110;user_id|s:1:\"1\";'),('be49af02d2fe5f598164df8ce35c5ab00d366023','37.40.226.47',1665068659,_binary '__ci_last_regenerate|i:1665068659;user_id|s:1:\"1\";'),('c6c6046373b6d7fe8a0b5230dfd375b70b3f7079','54.38.214.107',1665068454,_binary '__ci_last_regenerate|i:1665068454;'),('05269d47c4e56ed7176c55afea12a9b9a9ce8c45','37.40.226.47',1665068984,_binary '__ci_last_regenerate|i:1665068984;user_id|s:1:\"1\";'),('38e802e7a9e0b7c69848bc4774c3035fc794ac20','37.40.226.47',1665069938,_binary '__ci_last_regenerate|i:1665069938;user_id|s:1:\"1\";'),('5fd2005c268ccd0ec12d8dca8546d367a89aecaa','37.40.226.47',1665069436,_binary '__ci_last_regenerate|i:1665069436;user_id|s:1:\"1\";'),('dec586485c8c8e6d353608570a6531fc29d70b83','37.40.226.47',1665069955,_binary '__ci_last_regenerate|i:1665069954;'),('2e97e104e0f5cd8cdd786fc7d6af11f82590e2cf','5.36.129.9',1665169860,_binary '__ci_last_regenerate|i:1665169860;user_id|s:1:\"1\";'),('a28c8d2e534a3dc000f8874c27e2705cf9e0cc0d','5.36.129.9',1665170179,_binary '__ci_last_regenerate|i:1665170179;user_id|s:1:\"1\";'),('b554910c2f76b079a46c3df35682b7fd748f6bd6','5.36.129.9',1665170779,_binary '__ci_last_regenerate|i:1665170779;user_id|s:1:\"1\";'),('1e61577fd4c2d097c5a2a18b8a8c38dc7def3085','5.36.129.9',1665170397,_binary '__ci_last_regenerate|i:1665170287;'),('0ea47dbc26360c344fe7ee7395445c1b85a35010','5.36.129.9',1665171111,_binary '__ci_last_regenerate|i:1665171111;user_id|s:1:\"1\";'),('59430b718c53ace6d0669fbd13c826bbcc030388','5.36.129.9',1665171434,_binary '__ci_last_regenerate|i:1665171434;user_id|s:1:\"1\";'),('19aff62fb1a10309669b53ab8668226f4b42881e','54.38.214.107',1665171207,_binary '__ci_last_regenerate|i:1665171207;'),('b901e3c89ba31488d44cc0b57fc26b75bdeab1e6','5.36.129.9',1665171883,_binary '__ci_last_regenerate|i:1665171883;user_id|s:1:\"1\";'),('fe21d5661d14f4ee35fc47a229b0bcd11524d92f','5.36.129.9',1665172290,_binary '__ci_last_regenerate|i:1665172290;user_id|s:1:\"1\";'),('cd91150fe82772d81d08c9f7c9d3a07a7874289a','5.36.129.9',1665172939,_binary '__ci_last_regenerate|i:1665172939;user_id|s:1:\"1\";'),('6364e1564efede4a135598fcba40d396f5a2c839','5.36.129.9',1665173324,_binary '__ci_last_regenerate|i:1665173324;user_id|s:1:\"1\";'),('94d65f7084a6ea90d4f6310dc77e0e9af7a94624','5.36.129.9',1665173902,_binary '__ci_last_regenerate|i:1665173902;user_id|s:1:\"1\";'),('8395ec030efd03748bc1db7c89e66e56c06c780c','5.36.129.9',1665174211,_binary '__ci_last_regenerate|i:1665174211;'),('39b91b08d0417f9ff528fbc9890d83e3a4840f63','37.40.226.47',1665208117,_binary '__ci_last_regenerate|i:1665208117;user_id|s:1:\"1\";'),('05f6d313e72f886038179ef376895034bdd09d42','37.40.226.47',1665209737,_binary '__ci_last_regenerate|i:1665209737;user_id|s:1:\"1\";'),('6a2dd5b631473dcb11ef493c2433cd3dc298dcfb','37.40.226.47',1665210038,_binary '__ci_last_regenerate|i:1665210038;user_id|s:1:\"1\";'),('c408f4e2abeba8517b8324bc8edd5467b5c53b32','37.40.226.47',1665210355,_binary '__ci_last_regenerate|i:1665210355;user_id|s:1:\"1\";'),('502c773ce91c55ea9f3ccfca3c3186a59debd4ec','37.40.226.47',1665210680,''),('28ac35560a97f7636710b359cd95d45778d51a6b','37.40.226.47',1665210990,_binary '__ci_last_regenerate|i:1665210990;user_id|s:1:\"1\";'),('14ccd8f173e23ebb3512a88af4c6a46a8078b8c0','37.40.226.47',1665210680,''),('167895dc8082e45b9507bc6ca70fb03800d0665a','37.40.226.47',1665211294,_binary '__ci_last_regenerate|i:1665211294;user_id|s:1:\"1\";'),('ff8936a44a45e36cb16a9a10a85d3088b7eb7b3d','37.40.226.47',1665211613,_binary '__ci_last_regenerate|i:1665211613;user_id|s:1:\"1\";'),('4d4a6317a6a02359084d3edb168046456b1db188','37.40.226.47',1665212070,_binary '__ci_last_regenerate|i:1665212070;user_id|s:1:\"1\";'),('7a3ea8b9249bde7593be032c17d26c98f8d14f72','37.40.226.47',1665213392,_binary '__ci_last_regenerate|i:1665213392;user_id|s:1:\"1\";'),('4be76981f16683e80febd3b69df8bac2f2f3ae8e','37.40.226.47',1665216065,_binary '__ci_last_regenerate|i:1665216065;user_id|s:1:\"1\";'),('84f8b776b59c023f7ad945c3a4339e998319f331','37.40.226.47',1665214047,_binary '__ci_last_regenerate|i:1665214047;user_id|s:1:\"1\";'),('fb3b876e9b706cd6ceed6f6459b6aea7876b3a00','37.40.226.47',1665216807,_binary '__ci_last_regenerate|i:1665216807;user_id|s:1:\"1\";'),('27dcacd1169d7a43ee906108b62f4bd05b5b6ac8','37.40.226.47',1665218836,_binary '__ci_last_regenerate|i:1665218836;user_id|s:1:\"1\";'),('f4c24ed3459eff8b2fab3c698de8718246cd7c67','37.40.226.47',1665219600,_binary '__ci_last_regenerate|i:1665219600;user_id|s:1:\"1\";'),('df7e8f805e07a1ebf8920da7ea6f5bbe57e553c4','37.40.226.47',1665220712,_binary '__ci_last_regenerate|i:1665220712;user_id|s:1:\"1\";'),('5a5ec09503b8740fbd3fc799535f3be9147f9bc1','37.40.226.47',1665221226,_binary '__ci_last_regenerate|i:1665221226;user_id|s:1:\"1\";'),('db08e8ea63cc5bbb85fb470cd205d7b0782af79f','37.40.226.47',1665221557,_binary '__ci_last_regenerate|i:1665221557;user_id|s:1:\"1\";'),('f75d2ea4eb852628504de316bb132fd8d0ed9cc5','37.40.226.47',1665221884,_binary '__ci_last_regenerate|i:1665221884;user_id|s:1:\"1\";'),('5110ce57d45999a7b4ec8cd7d4706cb72a40f89b','37.40.226.47',1665222253,_binary '__ci_last_regenerate|i:1665222253;user_id|s:1:\"1\";'),('9be9dd9f8ced29129f019ce516085becb0dabae7','37.40.226.47',1665222254,_binary '__ci_last_regenerate|i:1665222253;'),('07ce11c2159d8ff821381bf7ee856abf9a4c1de2','37.40.226.47',1665236857,_binary '__ci_last_regenerate|i:1665236857;user_id|s:1:\"1\";'),('e4743d2cda0c1227d7243836a716c3784c780d7a','37.40.226.47',1665237414,_binary '__ci_last_regenerate|i:1665237414;user_id|s:1:\"1\";'),('e500035ad4037aed7c05b0b46bf1afbefa0bd168','37.40.226.47',1665238875,_binary '__ci_last_regenerate|i:1665238875;user_id|s:1:\"1\";'),('59052faea0b1e4457f5ffa65017a321917142f71','37.40.226.47',1665239306,_binary '__ci_last_regenerate|i:1665239306;user_id|s:1:\"1\";'),('e689f80df9282c3935dc0b4d073a7f5f11b022be','37.40.226.47',1665239563,_binary '__ci_last_regenerate|i:1665239563;'),('ed069d8568a174e1abe7bc513a7678162e162638','5.36.129.9',1665292852,_binary '__ci_last_regenerate|i:1665292852;'),('e89ad053f78ebfeb40e4549881785ccbb50421e6','5.36.129.9',1665292936,_binary '__ci_last_regenerate|i:1665292852;user_id|s:1:\"1\";'),('c5cd5cefe4d9af3fb5011b2f4e1d770db823bd20','37.40.226.47',1665383073,_binary '__ci_last_regenerate|i:1665383073;user_id|s:1:\"1\";'),('d8b325c4bba68d5a984e813dd394ef6f676ec39c','37.40.226.47',1665383498,_binary '__ci_last_regenerate|i:1665383498;user_id|s:1:\"1\";'),('3759f4c3d1fec5483f893696251ecc4911f8d4db','37.40.226.47',1665383890,_binary '__ci_last_regenerate|i:1665383890;user_id|s:1:\"1\";'),('07972a791d016e7ecf9b5883b6eea677b13fe9ae','37.40.226.47',1665384202,_binary '__ci_last_regenerate|i:1665384202;user_id|s:1:\"1\";'),('05bb1bc5027dc7bc97be67b76ee303b926d81918','54.38.214.107',1665384147,_binary '__ci_last_regenerate|i:1665384147;'),('04d157810d648f51bafa8d8e4c5531d635f75fd6','37.40.226.47',1665385893,_binary '__ci_last_regenerate|i:1665385893;user_id|s:1:\"1\";'),('a0edfbf843ac77f01e81a50fd8d02866221fd8ad','37.40.226.47',1665385643,_binary '__ci_last_regenerate|i:1665385641;user_id|s:1:\"2\";'),('4c9b6a1f1998b5e0788857b95bad44fb8ee65666','37.40.226.47',1665386168,_binary '__ci_last_regenerate|i:1665386168;user_id|s:1:\"2\";'),('2153be0f208370dd13eeecce5952e391c541b568','37.40.226.47',1665386243,_binary '__ci_last_regenerate|i:1665386243;user_id|s:1:\"1\";'),('c3dfc98197a76e4ad46994e5a6d2d324da40b5ab','37.40.226.47',1665386950,_binary '__ci_last_regenerate|i:1665386950;user_id|s:1:\"1\";'),('7d01d596da03c2b9ee085eae00372959e0d9806e','37.40.226.47',1665386611,''),('098b7d1d72e9185ae3fa94453df832a409caea82','37.40.226.47',1665386986,_binary '__ci_last_regenerate|i:1665386985;user_id|s:1:\"2\";'),('977409e3999a736361033bfbc7ef79871d982ac6','37.40.226.47',1665386611,''),('a778dee1d1bf7e5cd178d2ce66064b8053f0c5f4','37.40.226.47',1665387407,_binary '__ci_last_regenerate|i:1665387407;user_id|s:1:\"1\";'),('96dac6b745e4613b6e409044187b095263f7977b','37.40.226.47',1665387428,_binary '__ci_last_regenerate|i:1665387428;user_id|s:1:\"2\";'),('b75aa0b60ac24c2698baf821ffe122a8606dba0d','37.40.226.47',1665389050,_binary '__ci_last_regenerate|i:1665389050;user_id|s:1:\"1\";'),('740ea4a7e51b28b4f19600e68b9e4f7ed46e9231','37.40.226.47',1665388114,_binary '__ci_last_regenerate|i:1665388112;user_id|s:1:\"2\";'),('d16166000ca33dcc2412d5d76e2206020359b091','54.38.214.107',1665387526,_binary '__ci_last_regenerate|i:1665387526;'),('99f65decb33979af3a948047ae2ea1c62d67593a','37.40.226.47',1665393707,_binary '__ci_last_regenerate|i:1665391610;user_id|s:1:\"2\";'),('0e2de576fee3ddd4ba727d014996e21fae9bbca4','37.40.226.47',1665388459,_binary '__ci_last_regenerate|i:1665388459;user_id|s:1:\"2\";'),('8dda26356df28e8ee9076262980b8177f4aed1a3','37.40.226.47',1665388879,_binary '__ci_last_regenerate|i:1665388879;user_id|s:1:\"2\";'),('64ff9acbad7d7dcd8ad64f2a0962de7a08190b30','37.40.226.47',1665389352,_binary '__ci_last_regenerate|i:1665389352;user_id|s:1:\"1\";'),('1755df95fbb96408df93b78c2152958dae435fdc','37.40.226.47',1665390041,_binary '__ci_last_regenerate|i:1665390041;user_id|s:1:\"1\";'),('b85e613bfa785f78ce7814b090ce8c27af74a4ba','37.40.226.47',1665391633,_binary '__ci_last_regenerate|i:1665391633;user_id|s:1:\"1\";'),('3831e0ad0c4efb6beb54f3d6ef722f9bcb38386e','54.38.214.107',1665390100,_binary '__ci_last_regenerate|i:1665390100;'),('1ae76267d33924913d3904af2824f6babb8979fa','37.40.226.47',1665390135,_binary '__ci_last_regenerate|i:1665390135;user_id|s:1:\"2\";'),('3a14d6f7bf91d9f8851157353bde7981a401b52f','54.38.214.107',1665390143,_binary '__ci_last_regenerate|i:1665390143;'),('ed69bbf100a31df20688783198bbddc10a57d343','37.40.226.47',1665390927,_binary '__ci_last_regenerate|i:1665390927;user_id|s:1:\"2\";'),('03fc1d27d203d53eec5600c29dd622c95bf375b2','37.40.226.47',1665391610,_binary '__ci_last_regenerate|i:1665391610;user_id|s:1:\"2\";'),('72a63b2e60fde998e06521292fb8d1d17424cdbc','37.40.226.47',1665392852,_binary '__ci_last_regenerate|i:1665392852;user_id|s:1:\"1\";'),('32a726f5e1d6f3cdc8661817739d89268c23065c','37.40.226.47',1665393395,_binary '__ci_last_regenerate|i:1665393394;user_id|s:1:\"1\";'),('c5b16d085804b090c66817ad5e03b350b95b7e9a','37.40.226.47',1665393716,_binary '__ci_last_regenerate|i:1665393716;user_id|s:1:\"1\";'),('a263aca2c8f8328e4f2fb502cfe0c73f613e42f9','37.40.226.47',1665394418,_binary '__ci_last_regenerate|i:1665394418;user_id|s:1:\"1\";'),('8036c87394d400a0c4408dcae902d341d957e4a9','37.40.226.47',1665396036,_binary '__ci_last_regenerate|i:1665396036;user_id|s:1:\"1\";'),('74211f22d924a873950984d81f6f5c8be9b8d058','37.40.226.47',1665396037,_binary '__ci_last_regenerate|i:1665396036;'),('cb58f18c4ee242429914deadd792dbc4741c1257','54.198.133.218',1665399700,_binary '__ci_last_regenerate|i:1665399700;'),('7fad9a7a212e6cd162ab3294c53a6d5a51dd9aeb','54.198.133.218',1665399701,_binary '__ci_last_regenerate|i:1665399701;'),('bb5b53540b76240ea204557ee349d7421df8f870','37.40.226.47',1665406583,_binary '__ci_last_regenerate|i:1665406583;user_id|s:1:\"1\";'),('134dd7ac9dc4dac8d1ab8d2c98f63ccf724b1047','37.40.226.47',1665406947,_binary '__ci_last_regenerate|i:1665406947;user_id|s:1:\"1\";'),('3adbd991a4597f2850feeb7363e64342e717231f','37.40.226.47',1665407245,''),('0f6634d674ca5db8841146223bb18b92445c7d03','37.40.226.47',1665407570,_binary '__ci_last_regenerate|i:1665407570;user_id|s:1:\"1\";'),('8eb930186733ece9aebf8bca31747ef59e7d9955','37.40.226.47',1665407245,''),('888040dbb63d28f8b0d2b7ce9d7989f420a63aa9','37.40.226.47',1665408237,_binary '__ci_last_regenerate|i:1665408237;user_id|s:1:\"1\";'),('6c5bd160382fb9049b5de9cd7fccd24e1625feb3','37.40.226.47',1665409204,_binary '__ci_last_regenerate|i:1665409204;user_id|s:1:\"1\";'),('a3cc421d93c6205fde7b14682e21af0bebd41ca3','161.8.109.180',1665409267,_binary '__ci_last_regenerate|i:1665409193;'),('f177dbeef1274ceee8fd87c4e6a1a9ba7018a0f3','37.40.226.47',1665409234,''),('f2fc0cbb362a6b59ffb98bdd569b13f4bc574f5b','37.40.226.47',1665409235,_binary '__ci_last_regenerate|i:1665409234;'),('725e480fd8062cf57d2ff9a122781b28c8414f1d','37.40.226.47',1665409235,''),('b8386b63216b9c730cccdabd1e97c3816dc9948c','37.40.226.47',1665424905,_binary '__ci_last_regenerate|i:1665424902;'),('58fdf8a27b7778155f988db22a2df483fb64829b','37.40.226.47',1665461397,_binary '__ci_last_regenerate|i:1665461397;'),('0a41752c25ead9ff331a6eb1d44a7bac595267d1','37.40.226.47',1665462499,_binary '__ci_last_regenerate|i:1665462499;user_id|s:1:\"1\";'),('b239a5fe8bfe402614295f88ae883400bc96c64a','37.40.226.47',1665462848,_binary '__ci_last_regenerate|i:1665462848;user_id|s:1:\"1\";'),('1a5b119dd914217148d276ba4a723baf67c70ec7','37.40.226.47',1665464274,_binary '__ci_last_regenerate|i:1665464274;user_id|s:1:\"1\";'),('98c1a8341bec657f79424f7eaf012eb99ca0f221','37.40.226.47',1665464771,_binary '__ci_last_regenerate|i:1665464771;user_id|s:1:\"1\";'),('1d4f9f8f77c0d81d2e1158d0c0ffcb6220115085','37.40.226.47',1665465078,_binary '__ci_last_regenerate|i:1665465078;user_id|s:1:\"1\";'),('97beba9f6cfb25d39149fb1cb95d2d6b9a28f78e','37.40.226.47',1665465403,_binary '__ci_last_regenerate|i:1665465403;user_id|s:1:\"1\";'),('e54f2697d7f16cbb7774a0c9c6718ded37df502c','54.38.214.107',1665465258,_binary '__ci_last_regenerate|i:1665465258;'),('4c4944bbbb81dfda6015eb1d32a610bda393b30c','37.40.226.47',1665466298,_binary '__ci_last_regenerate|i:1665466298;user_id|s:1:\"1\";'),('0995e06ffa24a9a9cd43021731c6ba58f8029553','37.40.226.47',1665470438,_binary '__ci_last_regenerate|i:1665470438;user_id|s:1:\"1\";'),('5296bb2094532793c9ef19d082ae5ff8451eb01a','161.8.109.180',1665468625,_binary '__ci_last_regenerate|i:1665468625;user_id|s:1:\"1\";'),('1e3b3d3fb86938db3ee90ea52f3470053f89cb86','161.8.109.180',1665469036,_binary '__ci_last_regenerate|i:1665469036;user_id|s:1:\"1\";'),('11d4b5dfaed06af9c5426d7a42a877f87ef6bce8','161.8.109.180',1665469841,_binary '__ci_last_regenerate|i:1665469841;user_id|s:1:\"1\";'),('aa600c58a22fffd5b4673f263e5f1b67e2d0f192','161.8.109.180',1665470039,_binary '__ci_last_regenerate|i:1665469841;user_id|s:1:\"1\";'),('050d67ed5df5a44b340404be1d5ed2b55eb21e90','37.40.226.47',1665471166,_binary '__ci_last_regenerate|i:1665471166;user_id|s:1:\"1\";'),('0d3fa5af89cfae4e66371f3f5201af3085db68cd','37.40.226.47',1665471995,_binary '__ci_last_regenerate|i:1665471995;user_id|s:1:\"1\";'),('cfd8c32b1ac7c36dc3003fe8808e152a5109e602','37.40.226.47',1665472377,_binary '__ci_last_regenerate|i:1665472377;user_id|s:1:\"1\";'),('a3edcae7dc44a4be05ac0a408f37029eaf2ae291','37.40.226.47',1665472787,_binary '__ci_last_regenerate|i:1665472787;user_id|s:1:\"1\";'),('20b9e5ab248069421da5638502d9d2b044eb1dfc','37.40.226.47',1665473987,_binary '__ci_last_regenerate|i:1665473987;user_id|s:1:\"1\";'),('d115ba3b73e47775fb9fd702b024786917e162a7','37.40.226.47',1665475157,_binary '__ci_last_regenerate|i:1665475157;user_id|s:1:\"1\";'),('631022abaa4f291ba88bbb4ca0279778060d1f5a','37.40.226.47',1665475691,_binary '__ci_last_regenerate|i:1665475691;user_id|s:1:\"1\";'),('578dc2239e07e2187351f710593651d3f802558d','37.40.226.47',1665477695,_binary '__ci_last_regenerate|i:1665477695;user_id|s:1:\"1\";'),('a76cb91f96d78f39feacfc7254ab1602cdf72ee4','37.40.226.47',1665481806,_binary '__ci_last_regenerate|i:1665481806;user_id|s:1:\"1\";'),('6896f4ef8cc021be156099a102d6cda2ed35f262','37.40.226.47',1665483277,_binary '__ci_last_regenerate|i:1665483277;user_id|s:1:\"1\";'),('9ae1cf5f85cf5c84b848997c305c09c21db2598c','37.40.226.47',1665492940,_binary '__ci_last_regenerate|i:1665492940;user_id|s:1:\"1\";'),('8f38b48fa07be969973a7e32fac6c8892cf511aa','37.40.226.47',1665498696,_binary '__ci_last_regenerate|i:1665498696;user_id|s:1:\"1\";'),('fa2755b3882f0df5f33c43c3c0c53daf77568d47','37.40.226.47',1665498697,_binary '__ci_last_regenerate|i:1665498696;'),('2fcf0917f53a2f47e8b7efe65c39ac83c559b745','37.40.226.47',1665582396,_binary '__ci_last_regenerate|i:1665582396;user_id|s:1:\"1\";'),('d9af7a5b6fbca1a6ceb7a51dfc0b1d7ab8dcaab0','37.40.226.47',1665583209,_binary '__ci_last_regenerate|i:1665582396;user_id|s:1:\"1\";'),('6c1b58eac879464ab76f17a4d4c65aed6aed3670','37.40.226.47',1665635279,_binary '__ci_last_regenerate|i:1665635276;'),('2663127265f8d113a054c207ef7230e668824c30','37.40.238.77',1679893659,_binary '__ci_last_regenerate|i:1679893656;'),('92bfc168f3b6f9dd1fad5d662052206d1cef0d99','5.21.203.33',1688298728,_binary '__ci_last_regenerate|i:1688298725;'),('7095f3bf9022e5ce551d9440f4c0db28cb45de59','51.15.229.68',1699600243,_binary '__ci_last_regenerate|i:1699600214;user_id|s:1:\"1\";'),('2ae67422cebba8198b7735ff0bc6bd8bb73f2c8d','138.199.21.208',1699810933,_binary '__ci_last_regenerate|i:1699810928;'),('144aa90e45602d08fa81f214413d11562bbcace4','37.40.91.56',1706590314,_binary '__ci_last_regenerate|i:1706590313;'),('60366cccd842a1e7e54dd647ce097e04fa08f661','161.8.109.180',1735642619,_binary '__ci_last_regenerate|i:1735642619;');

--
