-- Table structure for table `erp_demopurchase_order_payments`
--

CREATE TABLE `erp_demopurchase_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 AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demopurchase_order_payments`
--

INSERT INTO `erp_demopurchase_order_payments` VALUES (1,2500,'2022-07-24',4,'2022-07-24','','','',0,'',2,'draft',0,0,0,1,'2022-07-24 14:44:07'),(2,4000,'2022-08-03',4,'2022-08-02','','','',0,'',5,'approved',0,21,0,1,'2022-08-02 08:54:03'),(3,4000,'2022-08-02',4,'2022-08-02','','','',0,'',5,'approved',0,22,0,1,'2022-08-02 08:54:35'),(4,210,'2022-08-16',4,'2022-08-21','','','',0,'',10,'draft',0,0,0,1,'2022-08-21 15:17:59'),(5,1000,'2022-09-08',4,'2022-09-07','','','',0,'',11,'draft',1,0,0,1,'2022-09-07 14:15:26'),(6,325,'2022-09-07',4,'2022-09-07','','','',0,'',13,'approved',0,113,0,1,'2022-09-07 14:23:55'),(7,2250,'2022-09-24',4,'2022-09-24','','','',0,'TT',17,'approved',0,147,0,1,'2022-09-24 08:11:19'),(8,945,'2022-09-24',4,'2022-09-24','','','',0,'TT',18,'approved',0,149,0,1,'2022-09-24 08:13:48'),(9,36750,'2022-09-30',4,'2022-09-24','','','',0,'tt',19,'draft',0,0,0,1,'2022-09-24 18:05:49'),(10,500,'2022-09-27',4,'2022-09-26','','','',0,'',21,'approved',0,174,0,1,'2022-09-26 09:17:41'),(11,100,'2022-11-08',4,'2022-11-01','','','',0,'',26,'approved',0,271,0,1,'2022-11-01 12:16:06'),(12,3500,'2022-11-04',4,'2022-11-03','','','',0,'',27,'approved',0,277,0,1,'2022-11-03 08:23:49'),(13,1000,'2022-11-10',5,'2022-11-03','bnm,','vghcdj','3456',0,'',6,'approved',0,308,0,1,'2022-11-03 08:55:05'),(14,1000,'2022-11-14',4,'2022-11-13','','','',0,'',28,'approved',0,315,0,1,'2022-11-13 09:34:25'),(15,1000,'2022-11-14',4,'2022-11-13','','','',0,'',28,'approved',0,316,0,1,'2022-11-13 09:40:31'),(16,500,'2023-02-07',4,'2023-02-06','','','',0,'',33,'approved',0,396,0,1,'2023-02-06 12:23:18'),(17,500,'2023-02-17',4,'2023-02-16','','','',0,'',34,'approved',0,399,0,1,'2023-02-16 08:58:59'),(18,600,'2023-04-19',4,'2023-04-18','','','',0,'',35,'approved',0,423,0,1,'2023-04-18 10:35:17'),(19,2,'2023-07-13',1,'2023-07-14','','','',0,'',36,'draft',0,0,0,1,'2023-07-14 10:21:50');

--
-- Table structure for table `erp_demopurchase_orders`
--

CREATE TABLE `erp_demopurchase_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 AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demopurchase_orders`
--

INSERT INTO `erp_demopurchase_orders` VALUES (1,1,'2022-07-20',0,'','','draft','not_approved',0),(2,1,'2022-07-24',0,'','','not_paid','approved',0),(3,1,'2022-07-26',0,'','','draft','not_approved',0),(4,1,'2022-07-27',0,'','','draft','not_approved',0),(5,2,'2022-08-02',0,'','','not_paid','approved',0),(6,3,'2022-08-09',0,'','','not_paid','not_approved',0),(7,2,'2022-08-13',6,'','','draft','approved',0),(8,4,'2022-08-18',0,'','','draft','approved',0),(9,5,'2022-08-18',12,'','','draft','approved',0),(10,6,'2022-08-21',5,'','','not_paid','approved',0),(11,4,'2022-09-04',17,'','','not_paid','approved',0),(12,4,'2022-09-07',22,'','','draft','approved',0),(13,5,'2022-09-07',0,'','','not_paid','approved',0),(14,6,'2022-09-22',14,'','300/15 8.00 SOLID DEESTONE','draft','approved',0),(15,6,'2022-09-22',20,'','300/15','draft','approved',0),(16,7,'2022-09-24',22,'','','draft','approved',0),(17,7,'2022-09-24',15,'','SOLID Tyres','not_paid','approved',0),(18,7,'2022-09-24',0,'','payment CASH','not_paid','approved',0),(19,7,'2022-09-24',22,'','CASH','not_paid','approved',0),(20,8,'2022-09-26',23,'','','draft','not_approved',0),(21,8,'2022-09-26',23,'','','not_paid','approved',0),(22,4,'2022-10-04',0,'','','draft','approved',0),(23,5,'2022-10-22',24,'','steel','draft','not_approved',0),(24,4,'2022-10-26',0,'','','draft','approved',0),(25,4,'2022-10-27',0,'','','draft','approved',0),(26,4,'2022-11-01',17,'','payemnt','not_paid','approved',0),(27,4,'2022-11-03',27,'','','not_paid','approved',0),(28,9,'2022-11-13',0,'','','not_paid','approved',0),(29,4,'2022-11-15',14,'','','draft','approved',0),(30,4,'2023-01-29',31,'','','draft','approved',0),(31,6,'2023-01-29',31,'','','draft','approved',0),(32,4,'2023-01-31',34,'','','draft','approved',0),(33,4,'2023-02-02',0,'','','not_paid','approved',0),(34,4,'2023-02-16',17,'','','not_paid','approved',0),(35,4,'2023-04-18',28,'','','not_paid','approved',0),(36,4,'2023-07-14',14,'','','not_paid','approved',0);

--
-- Table structure for table `erp_demopurchase_return_items`
--

CREATE TABLE `erp_demopurchase_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demopurchase_return_items`
--

INSERT INTO `erp_demopurchase_return_items` VALUES (1,0,14,100,0,1,0);

--
-- Table structure for table `erp_demopurchase_returns`
--

CREATE TABLE `erp_demopurchase_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demopurchase_returns`
--

INSERT INTO `erp_demopurchase_returns` VALUES (1,10,NULL,6,1,0,'2022-09-25','draft','',0);

--
-- Table structure for table `erp_demoroles`
--

CREATE TABLE `erp_demoroles` (
  `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 AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoroles`
--

INSERT INTO `erp_demoroles` VALUES (1,'test','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";N;s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";s:1:\"1\";s:19:\"can_create_contacts\";s:1:\"1\";s:17:\"can_edit_contacts\";s:1:\"1\";s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";N;s:17:\"can_edit_invoices\";N;s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";N;s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(2,'test',NULL,0),(3,'Director','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";s:1:\"1\";s:17:\"can_edit_projects\";s:1:\"1\";s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";s:1:\"1\";s:19:\"can_create_contacts\";s:1:\"1\";s:17:\"can_edit_contacts\";s:1:\"1\";s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";s:1:\"1\";s:16:\"can_edit_clients\";s:1:\"1\";s:18:\"can_delete_clients\";s:1:\"1\";s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";s:1:\"1\";s:17:\"can_edit_invoices\";N;s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";s:1:\"1\";s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(4,'Sales','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";s:1:\"1\";s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";s:1:\"1\";s:16:\"can_edit_clients\";s:1:\"1\";s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";s:1:\"1\";s:17:\"can_edit_invoices\";s:1:\"1\";s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";s:1:\"1\";s:20:\"can_create_estimates\";s:1:\"1\";s:18:\"can_edit_estimates\";s:1:\"1\";s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(5,'PROJECT MANAGER','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";s:1:\"1\";s:17:\"can_edit_projects\";s:1:\"1\";s:19:\"can_delete_projects\";s:1:\"1\";s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";s:1:\"1\";s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";s:1:\"1\";s:19:\"can_edit_milestones\";s:1:\"1\";s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";N;s:17:\"can_edit_invoices\";N;s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";s:1:\"1\";s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";s:0:\"\";s:9:\"estimates\";s:0:\"\";s:8:\"invoices\";s:0:\"\";s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(6,'Marketing Manger','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";s:1:\"1\";s:17:\"can_edit_projects\";s:1:\"1\";s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";s:1:\"1\";s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";N;s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";s:1:\"1\";s:17:\"can_edit_invoices\";s:1:\"1\";s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";s:1:\"1\";s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";s:0:\"\";s:9:\"estimates\";s:3:\"all\";s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(7,'project manger',NULL,0),(8,'Clients','a:116:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";s:1:\"1\";s:19:\"can_create_projects\";s:1:\"1\";s:17:\"can_edit_projects\";s:1:\"1\";s:19:\"can_delete_projects\";s:1:\"1\";s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:13:\"expires_alert\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";s:1:\"1\";s:16:\"can_edit_clients\";s:1:\"1\";s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";N;s:19:\"can_create_invoices\";N;s:17:\"can_edit_invoices\";N;s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";N;s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";s:0:\"\";s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(9,'Project manger (Maintance)',NULL,0),(10,'Sales Manager Team A','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";N;s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";s:1:\"1\";s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";s:1:\"1\";s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";s:1:\"1\";s:17:\"can_edit_invoices\";s:1:\"1\";s:19:\"can_delete_invoices\";s:1:\"1\";s:25:\"invoice_manage_permission\";s:8:\"specific\";s:34:\"invoice_manage_permission_specific\";s:6:\"team:1\";s:20:\"can_access_estimates\";N;s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(11,'Project Engineer',NULL,0),(12,'Faince',NULL,0),(13,'Accountant','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";N;s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";s:1:\"1\";s:26:\"can_create_purchase_orders\";s:1:\"1\";s:24:\"can_edit_purchase_orders\";s:1:\"1\";s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";N;s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";s:1:\"1\";s:19:\"can_create_invoices\";s:1:\"1\";s:17:\"can_edit_invoices\";s:1:\"1\";s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";s:1:\"1\";s:20:\"can_create_estimates\";s:1:\"1\";s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',1),(14,'Purchase','a:115:{s:5:\"leave\";N;s:14:\"leave_specific\";s:0:\"\";s:10:\"attendance\";N;s:19:\"attendance_specific\";s:0:\"\";s:7:\"invoice\";N;s:8:\"estimate\";N;s:7:\"expense\";N;s:6:\"client\";N;s:4:\"lead\";N;s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";N;s:23:\"help_and_knowledge_base\";N;s:23:\"can_manage_all_projects\";N;s:19:\"can_create_projects\";N;s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";N;s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";N;s:24:\"show_assigned_tasks_only\";N;s:21:\"can_create_milestones\";N;s:19:\"can_edit_milestones\";N;s:21:\"can_delete_milestones\";N;s:16:\"can_delete_files\";N;s:34:\"can_view_team_members_contact_info\";N;s:34:\"can_view_team_members_social_links\";N;s:29:\"team_member_update_permission\";N;s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";N;s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";N;s:7:\"payroll\";N;s:5:\"eroom\";N;s:4:\"logs\";N;s:7:\"reports\";N;s:25:\"can_access_delivery_notes\";N;s:25:\"can_create_delivery_notes\";N;s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";N;s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";N;s:20:\"can_create_suppliers\";N;s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";N;s:35:\"supplier_manage_permission_specific\";s:0:\"\";s:26:\"can_access_purchase_orders\";N;s:26:\"can_create_purchase_orders\";N;s:24:\"can_edit_purchase_orders\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";N;s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";N;s:16:\"can_create_items\";N;s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";N;s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";N;s:19:\"can_create_expenses\";N;s:17:\"can_edit_expenses\";N;s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";N;s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";N;s:27:\"can_create_invoice_payments\";N;s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";N;s:34:\"can_create_purchase_order_payments\";N;s:32:\"can_edit_purchase_order_payments\";N;s:34:\"can_delete_purchase_order_payments\";N;s:19:\"can_access_contacts\";N;s:19:\"can_create_contacts\";N;s:17:\"can_edit_contacts\";N;s:19:\"can_delete_contacts\";N;s:25:\"contact_manage_permission\";N;s:34:\"contact_manage_permission_specific\";s:0:\"\";s:18:\"can_access_clients\";N;s:18:\"can_create_clients\";N;s:16:\"can_edit_clients\";N;s:18:\"can_delete_clients\";N;s:24:\"client_manage_permission\";N;s:33:\"client_manage_permission_specific\";s:0:\"\";s:19:\"can_access_invoices\";N;s:19:\"can_create_invoices\";N;s:17:\"can_edit_invoices\";N;s:19:\"can_delete_invoices\";N;s:25:\"invoice_manage_permission\";N;s:34:\"invoice_manage_permission_specific\";s:0:\"\";s:20:\"can_access_estimates\";N;s:20:\"can_create_estimates\";N;s:18:\"can_edit_estimates\";N;s:20:\"can_delete_estimates\";N;s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";N;s:9:\"estimates\";N;s:8:\"invoices\";N;s:16:\"invoice_payments\";N;s:14:\"delivery_notes\";N;s:15:\"purchase_orders\";N;s:23:\"purchase_order_payments\";N;s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(15,'Coordinator',NULL,0),(16,'Sales Executive',NULL,0),(17,'تاجر',NULL,0),(18,'Worker',NULL,0);

--
-- Table structure for table `erp_demosalary_advance`
--

CREATE TABLE `erp_demosalary_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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demosalary_advance`
--

INSERT INTO `erp_demosalary_advance` VALUES (1,41,500,'2022-08-09',0),(2,53,100,'2022-11-17',0),(3,56,100,'2022-11-22',0),(4,55,50,'2023-07-11',0);

--
-- Table structure for table `erp_demosale_return_items`
--

CREATE TABLE `erp_demosale_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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demosale_return_items`
--

INSERT INTO `erp_demosale_return_items` VALUES (1,1,1,1,1,0,0),(2,2,1,1,1,0,0),(3,3,1,1,1,0,0),(4,4,31,85,2,0,0),(5,4,27,86,1,0,0),(6,4,25,87,1,0,0);

--
-- Table structure for table `erp_demosale_returns`
--

CREATE TABLE `erp_demosale_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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demosale_returns`
--

INSERT INTO `erp_demosale_returns` VALUES (1,1,1,4,0,'2022-07-25','approved','dammage',0),(2,1,1,4,0,'2022-08-15','approved','',0),(3,1,1,4,0,'2022-08-15','draft','',0),(4,157,32,1,0,'2022-10-18','approved','',0);

--
-- Table structure for table `erp_demosettings`
--

CREATE TABLE `erp_demosettings` (
  `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 `erp_demosettings`
--

INSERT INTO `erp_demosettings` 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','CR:1502140   P.CODE:111   P.O.BOX:2929   GSM:79119561   E-MAIL:INFO@ALARABIYADATE.COM\nالمقر الرئيسي للشركة - رقم البناية000, رقم القطعة311, رقم الشارع 63, الموالح الجنوبية - السيب, ص.ب 2929, الرمز البريدي 111, روي, سلطنة عمان - هاتف +96879119561 فاكس: +96824703016','app',0),('company_email','info@alarabiyadate.com','app',0),('company_name','ALARABIYA COMPANY','app',0),('company_phone','79119561 - 24287926','app',0),('company_vat_number','','app',0),('company_website','https://alarabiyadate.com/','app',0),('cost_of_goods_sold','1','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','923','app',0),('default_cash_on_hand','931','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','','app',0),('default_inventory','10','app',0),('default_sales','20','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('discount','4','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','#ADD8E6','app',0),('estimate_logo','a:1:{s:9:\"file_name\";s:36:\"_file639cae77dd94d-estimate-logo.png\";}','app',0),('favicon','a:1:{s:9:\"file_name\";s:30:\"_file636f9c5175a88-favicon.png\";}','app',0),('financial_year_end','2022-01-01','app',0),('first_day_of_week','6','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','87','app',0),('initial_number_of_the_invoice','1036','app',0),('invoice_color','#0096FF','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_logo','a:1:{s:9:\"file_name\";s:35:\"_file643bc8408da50-invoice-logo.png\";}','app',0),('invoice_prefix','Taadq/','app',0),('item_purchase_code','53434654','app',0),('language','english','app',0),('leave_salary_expenses','21','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),('payable_cheques','13','app',0),('payable_EOS_benefits','21','app',0),('payable_job_security','21','app',0),('payable_leave_salaries','21','app',0),('payable_PASI','21','app',0),('payable_salaries','21','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),('receivable_cheques','5','app',0),('rows_per_page','100','app',0),('salary_advances','21','app',0),('salary_expenses','21','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','info@alarabiyadate.com','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','a:4:{s:9:\"file_name\";s:42:\"system_file636f9c517cb0b-Teamway-Logo.jpeg\";s:9:\"file_size\";s:5:\"23170\";s:7:\"file_id\";N;s:12:\"service_type\";N;}','app',0),('site_logo','a:1:{s:9:\"file_name\";s:32:\"_file636f9c5174fd1-site-logo.png\";}','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_37_dashboard','','user',0),('user_39_dashboard','','user',0),('user_4_dashboard','','user',0),('user_47_dashboard','','user',0),('user_47_personal_language','english','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),('VAT_expense','21','app',0),('VAT_in','5','app',0),('VAT_out','21','app',0),('weekend','0','app',0);

--
-- Table structure for table `erp_demoshipment_items`
--

CREATE TABLE `erp_demoshipment_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 AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoshipment_items`
--

INSERT INTO `erp_demoshipment_items` VALUES (1,4,1,10,0,1,0),(2,4,6,998,0,2,0),(3,2,7,0,0,2,0),(4,5,8,0,0,2,0),(5,6,9,1,0,2,0),(6,1,10,1,0,2,0),(7,20,18,3,0,3,0),(8,21,19,5,0,3,0),(9,16,16,2,0,4,1),(10,15,17,1,0,4,0),(11,0,27,100,0,6,0),(12,25,35,1,0,7,0),(13,33,36,0,0,7,0),(14,28,37,10,0,8,0),(15,39,38,5,0,9,0),(16,39,38,5,0,10,0),(17,53,41,5,0,11,0),(18,53,41,5,0,12,0),(19,56,43,4,0,13,0),(20,40,44,2,0,14,0),(21,51,45,1,0,14,0),(22,40,46,1,0,15,0),(23,39,47,1,0,15,0);

--
-- Table structure for table `erp_demoshipments`
--

CREATE TABLE `erp_demoshipments` (
  `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 AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoshipments`
--

INSERT INTO `erp_demoshipments` VALUES (1,2,1,'2022-07-25','234124545','2022-07-25','41545545','2022-07-25','approved','',0),(2,7,2,'2022-08-13','','0000-00-00','','0000-00-00','approved','',0),(3,12,4,'2022-09-08','5665767','2022-09-08','2','2022-09-08','approved','HGJGHJ',0),(4,11,4,'2022-09-07','54Q','2022-09-08','5356','2022-09-08','approved','',0),(5,15,6,'2022-09-22','15','2022-09-22','','0000-00-00','approved','',0),(6,19,7,'2022-09-24','#19','2022-09-24','','0000-00-00','draft','',0),(7,26,4,'2022-11-01','3819050','2022-11-02','8494','2022-11-08','approved','',0),(8,27,4,'2022-11-03','4567','2022-11-10','23','2022-11-10','approved','',0),(9,28,9,'2022-11-14','1234','2022-11-14','122','2022-11-14','approved','',0),(10,28,9,'2022-11-15','1343','2022-11-15','5315','2022-11-15','approved','',0),(11,31,6,'2023-01-29','123','2023-01-29','222','2023-01-29','approved','123',0),(12,31,6,'2023-01-29','123','2023-01-29','123123','2023-01-29','approved','123123',0),(13,33,4,'2023-02-07','123','2023-02-07','123','2023-02-07','approved','',0),(14,34,4,'2023-02-16','13445','2023-02-16','22','2023-02-16','approved','tc',0),(15,35,4,'2023-04-18','123','2023-04-18','12','2023-04-18','approved','',0);

--
-- Table structure for table `erp_demosocial_links`
--

CREATE TABLE `erp_demosocial_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 `erp_demosocial_links`
--


--
-- Table structure for table `erp_demostock_adjustments`
--

CREATE TABLE `erp_demostock_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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demostock_adjustments`
--

INSERT INTO `erp_demostock_adjustments` VALUES (1,28,100,'',0),(2,27,20,'',0),(3,26,-51,'',0),(4,25,-26,'',0),(5,27,-10,'',0),(6,31,10,'',0),(7,36,5,'',0);

--
-- Table structure for table `erp_demosuppliers`
--

CREATE TABLE `erp_demosuppliers` (
  `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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demosuppliers`
--

INSERT INTO `erp_demosuppliers` VALUES (1,'test','44444','','','','','','2022-07-20','','343343','','','','','',904,0,1),(2,'xx company','mohammed','test','','','','','2022-08-02','','8i763356','84734763','','','','',912,0,1),(3,'civil company','mohammed','','','','','','2022-08-08','','343487585','','','','','',920,0,1),(4,'AB COMPANY','','','','','','','2022-08-18','','9777777','','','','12345678','',924,0,0),(5,'XY COMPANY','','','','','','','2022-08-18','','95555','','','','154654','',925,0,0),(6,'Amriya incense ','98777777','Muscat ','','','','','2022-08-21','','98777760','','','','','',926,0,0),(7,'Deestone Tyres Company LTD','Mr. Tum','Thailand ','','','','','2022-09-22','','0066951481354','','','','','',934,0,0),(8,'ahmed','','','','','','','2022-09-26','','78994555','','','','','',938,0,0),(9,'China company','Ahmed','','','','','','2022-11-13','','9878`637','','','','','',952,0,0);

--
-- Table structure for table `erp_demotask_status`
--

CREATE TABLE `erp_demotask_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=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demotask_status`
--

INSERT INTO `erp_demotask_status` VALUES (1,'To Do','to_do','#d43480',1,0),(2,'In progress','in_progress','#1672B9',2,0),(3,'Done','done','#83c340',3,0),(4,'holding','','#aab7b7',4,0),(5,'تم التحويل','','#dbadff',0,0);

--
-- Table structure for table `erp_demotasks`
--

CREATE TABLE `erp_demotasks` (
  `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 AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demotasks`
--

INSERT INTO `erp_demotasks` VALUES (1,'design','',1,0,37,'2022-07-31','',1,'to_do',1,'2022-07-24','',0,0,0,'',0,0,0,'2022-07-24',NULL,'0000-00-00',0,0),(2,'شش','ششش',1,0,37,'2022-07-28','ش',2,'to_do',2,'2022-07-27','',0,0,0,'',0,0,0,'2022-07-27',NULL,'0000-00-00',0,0),(3,'survey','',1,0,37,'2022-07-30','',4,'to_do',3,'2022-07-27','',0,0,0,'',0,0,0,'2022-07-27',NULL,'0000-00-00',0,0),(4,'Site visit','ghfzghgh',4,1,1,'2022-08-05','',1,'to_do',3,'2022-08-04','38',10000000,0,0,'',0,0,0,'2022-08-04',NULL,'0000-00-00',0,0),(5,'MAKE graphic design','DHJKJFHFGDHF',5,0,39,'2022-08-11','',1,'to_do',4,'2022-08-07','',10000000,0,0,'',0,0,0,'2022-08-07',NULL,'0000-00-00',0,0),(6,'maintance ','light',6,0,1,NULL,'',1,'to_do',1,NULL,'',-492,0,0,'',0,0,0,'2022-08-07',NULL,'0000-00-00',0,0),(7,'maintance ','signboard',6,0,1,NULL,'',1,'to_do',3,NULL,'',10000000,0,0,'',0,0,0,'2022-08-07',NULL,'0000-00-00',0,0),(8,'Maintance','',6,0,1,NULL,'',1,'to_do',3,NULL,'',0,0,0,'',0,0,0,'2022-08-07',NULL,'0000-00-00',0,0),(9,'Site visit','jdbJDDM,D',11,0,41,'2022-08-13','',1,'to_do',3,'2022-08-08','1',10000000,0,0,'',0,0,0,'2022-08-08',NULL,'0000-00-00',0,0),(10,'content','test',16,0,38,'2022-08-21','',1,'to_do',3,'2022-08-14','',10000000,0,0,'',0,0,0,'2022-08-14',NULL,'0000-00-00',0,0),(11,'Register all the business cards. ','You have to write all the business cards. ',13,0,1,NULL,'',5,'to_do',1,'2022-08-21','',0,0,0,'',0,0,0,'2022-08-21',NULL,'0000-00-00',0,0),(12,'Site visit','',17,0,43,'2022-08-30','',1,'to_do',1,'2022-08-23','38',10000000,0,0,'',0,0,0,'2022-08-23',NULL,'0000-00-00',0,0),(13,'Construction of MH','excavation ',21,0,1,'2022-09-05','Construction',1,'to_do',3,'2022-09-01','',10,0,0,'',0,0,0,'2022-09-01',NULL,'0000-00-00',0,0),(14,'VISIT SIDE','FGF',22,0,43,'2022-09-07','',1,'to_do',3,'2022-09-07','38',0,0,0,'',0,0,0,'2022-09-07',NULL,'0000-00-00',0,0),(15,'purchase steel ','need to purchase steel and plan for exuviation ',24,0,0,'2022-10-25','',1,'to_do',1,'2022-10-23','',0,0,0,'',0,0,0,'2022-10-22',NULL,'0000-00-00',0,0),(16,'purchase blocks ','sold and hall blocks',24,0,1,'2022-10-29','',1,'to_do',3,'2022-10-23','',0,0,0,'',0,0,0,'2022-10-22',NULL,'0000-00-00',0,0),(17,'Visit site','jkdnkjcn',26,0,43,'2022-10-27','',1,'to_do',4,'2022-10-27','',10000000,0,0,'',0,0,0,'2022-10-27',NULL,'0000-00-00',0,0),(18,'Prototype','test',28,0,53,'2022-11-17','',1,'to_do',3,'2022-11-13','53',10000000,0,0,'',0,0,0,'2022-11-13',NULL,'0000-00-00',0,0),(19,'uvd','--',28,0,1,NULL,'',3,'to_do',1,NULL,'',0,0,0,'',0,0,0,'2022-11-23',NULL,'0000-00-00',0,0),(20,'mashermint','it should tack mashrint by zaheer',30,0,1,NULL,'',5,'to_do',1,NULL,'1',0,0,0,'',0,0,0,'2022-12-21',NULL,'0000-00-00',0,0),(21,'paint','paint 3 doors',17,0,1,'2023-01-30','',3,'to_do',4,'2023-01-28','',10000000,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,0),(22,'design','',31,0,0,NULL,'',1,'to_do',3,NULL,'',0,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,1),(23,'purchase','purchase material',31,0,0,'2023-01-31','',2,'to_do',1,'2023-01-29','',0,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,1),(24,'manufacture','',31,0,1,'2023-02-03','',3,'to_do',1,'2023-01-31','',0,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,1),(25,'paint','',31,0,0,'2023-02-04','',4,'to_do',1,'2023-02-03','',0,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,1),(26,'site vist','',33,3,56,'2023-02-06','',1,'to_do',2,'2023-01-29','56',10000000,0,0,'',0,0,0,'2023-01-29',NULL,'0000-00-00',0,0),(27,'SITE VISIT','TEST',34,0,56,'2023-02-01','',1,'to_do',2,'2023-01-31','1',10000000,0,0,'',0,0,0,'2023-01-31',NULL,'0000-00-00',0,0),(28,'Meet client','tset',29,0,60,'2023-04-14','',1,'to_do',3,'2023-04-13','',10000000,0,0,'',0,0,0,'2023-04-13',NULL,'0000-00-00',0,0);

--
-- Table structure for table `erp_demotaxes`
--

CREATE TABLE `erp_demotaxes` (
  `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 `erp_demotaxes`
--

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

--
-- Table structure for table `erp_demoteam`
--

CREATE TABLE `erp_demoteam` (
  `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoteam`
--

INSERT INTO `erp_demoteam` VALUES (1,'Sales Team A','37,39,41,42',0),(2,'Team B','42,40,43',0);

--
-- Table structure for table `erp_demoteam_member_job_info`
--

CREATE TABLE `erp_demoteam_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 AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoteam_member_job_info`
--

INSERT INTO `erp_demoteam_member_job_info` VALUES (5,37,'2022-03-07',0,1000,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(6,38,'2022-07-26',0,1000,NULL,8,30,0,0,0,0,0,1,'bank_muscat','',''),(7,39,'2022-07-31',0,500,NULL,8,30,20,10,10,5,0,1,'bank_muscat','',''),(8,40,'2022-05-24',0,1000,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(9,41,'2022-08-01',0,1000,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(10,42,'2022-08-14',0,350,NULL,120,30,0,0,0,0,0,1,NULL,NULL,NULL),(11,43,'2022-08-01',0,300,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(12,44,'2022-07-31',0,1000,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(13,47,'2022-10-10',0,22222,NULL,11111,20,0,0,0,0,0,1,NULL,NULL,NULL),(14,49,'0000-00-00',0,5000,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(15,50,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(16,51,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(17,52,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(18,53,'2022-04-25',0,500,NULL,8,30,100,10,10,0,0,1,'bank_muscat','',''),(19,54,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(20,55,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(21,56,'2023-02-04',0,250,NULL,10,30,0,0,0,0,0,1,NULL,NULL,NULL),(22,57,'0000-00-00',0,0,NULL,5,0,0,0,0,0,0,1,NULL,NULL,NULL),(23,58,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(24,59,'2023-01-31',0,20000,NULL,8,30,0,0,0,0,0,1,NULL,NULL,NULL),(25,60,'0000-00-00',0,500,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL),(26,61,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL);

--
-- Table structure for table `erp_demoticket_comments`
--

CREATE TABLE `erp_demoticket_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 `erp_demoticket_comments`
--


--
-- Table structure for table `erp_demoticket_types`
--

CREATE TABLE `erp_demoticket_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 `erp_demoticket_types`
--

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

--
-- Table structure for table `erp_demotickets`
--

CREATE TABLE `erp_demotickets` (
  `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 `erp_demotickets`
--


--
-- Table structure for table `erp_demoto_do`
--

CREATE TABLE `erp_demoto_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 AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demoto_do`
--

INSERT INTO `erp_demoto_do` VALUES (1,1,'2022-07-26 06:56:23','afdghhgad','','','done',NULL,0),(2,1,'2022-07-26 06:56:25','gadghfgdh','','','done',NULL,0),(3,1,'2022-08-02 09:06:28','hgchagcvhdGC','','','done',NULL,0),(4,1,'2022-08-14 12:40:21','call leads','','','done',NULL,0),(5,1,'2022-08-14 12:40:25','design','','','done',NULL,0),(6,1,'2022-08-22 17:06:53','زياره المواقع','','','done',NULL,0),(7,1,'2022-09-22 14:56:00','92219977','','','done',NULL,0),(8,1,'2022-10-19 16:24:35','ask payment on sunday','','','to_do',NULL,1),(9,1,'2022-10-19 16:25:03','ask for Ture land ','','','to_do',NULL,1),(10,1,'2022-10-19 16:27:59','plan for Nov','','','done','2022-10-31',0),(11,1,'2022-10-27 09:44:34','vist','','','done',NULL,0),(12,1,'2022-11-13 10:14:13','meeting','','','done',NULL,0),(13,1,'2022-11-13 10:14:16','demo','','','done',NULL,0),(14,1,'2022-11-27 09:56:10','Documentaion','','','done',NULL,0),(15,1,'2023-01-31 07:06:47','vist','','','done',NULL,0);

--
-- Table structure for table `erp_demotransactions`
--

CREATE TABLE `erp_demotransactions` (
  `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 AUTO_INCREMENT=445 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `erp_demotransactions`
--

INSERT INTO `erp_demotransactions` VALUES (1,'2022-07-21','Invoice: INVOICE #1',0,NULL,0,0),(2,'2022-07-22','Invoice Payment Received: INVOICE #1',0,NULL,0,0),(3,'2022-07-25','Invoice Payment Received: INVOICE #3',0,NULL,0,0),(4,'2022-07-27','Invoice Payment Received: INVOICE #3',0,NULL,0,0),(5,'2022-07-24','Automatic General Expense: Cash on hand',0,NULL,0,1),(6,'2022-07-24','Purchase Order: PURCHASE ORDER #2',0,NULL,0,0),(7,'2022-07-24','Invoice: INVOICE #4',0,NULL,0,0),(8,'2022-07-24','Automatic General Expense: Cash on hand',0,NULL,0,0),(9,'2022-07-26','Invoice: INVOICE #5',0,NULL,0,0),(10,'2022-07-26','Invoice: INVOICE #6',0,NULL,0,0),(11,'2022-07-26','Invoice: INVOICE #7',0,NULL,0,0),(12,'2022-07-27','Invoice Payment Received: INVOICE #7',0,NULL,0,0),(13,'2022-07-29','Invoice Payment Received: INVOICE #7',0,NULL,0,0),(14,'2022-07-26','Invoice Inventory: INVOICE #7',0,NULL,0,0),(15,'2022-07-26','Automatic General Expense: Cash on hand',0,NULL,0,0),(16,'2022-07-27','Invoice Payment Received: INVOICE #6',0,NULL,0,0),(17,'2022-07-27','Invoice Payment Received: INVOICE #6',0,NULL,0,0),(18,'2022-07-28','Invoice: Tax 11',0,NULL,0,0),(19,'2022-07-28','Invoice: Tax 12',0,NULL,0,0),(20,'2022-08-02','Purchase Order: PURCHASE ORDER #5',0,NULL,0,0),(21,'2022-08-03','Automatic Purchase Payment: PURCHASE ORDER #5',0,NULL,0,0),(22,'2022-08-02','Automatic Purchase Payment: PURCHASE ORDER #5',0,NULL,0,0),(23,'2022-08-03','Invoice Payment Received: Tax 13',0,NULL,0,1),(24,'2022-08-02','Invoice Inventory: Tax 13',0,NULL,0,0),(25,'2022-08-05','Invoice Payment Received: Tax 15',0,NULL,0,1),(26,'2022-08-04','Automatic General Expense: Cash on hand',0,NULL,0,0),(27,'2022-08-10','Invoice Payment Received: Tax 15',0,NULL,0,0),(28,'2022-08-04','Admin Admin Automatic Salaries Booking: July-2022',0,NULL,0,0),(29,'2022-08-04','Ali elsheikh Automatic Salaries Booking: July-2022',0,NULL,0,0),(30,'2022-08-04','Ali Ali Automatic Salaries Booking: July-2022',0,NULL,0,0),(31,'2022-08-04','MOHAMMED SAID Automatic Salaries Booking: July-2022',0,NULL,0,0),(32,'2022-08-04','Rayaa NUMANI Automatic Salaries Booking: July-2022',0,NULL,0,0),(33,'2022-08-08','Invoice Payment Received: Tax 16',0,NULL,0,0),(34,'2022-08-16','Invoice Payment Received: Tax 16',0,NULL,0,0),(35,'2022-08-02','Invoice: Tax 14',0,NULL,0,0),(36,'2022-07-28','Invoice: Tax 10',0,NULL,0,0),(37,'2022-07-27','Invoice: Tax 8',0,NULL,0,0),(38,'2022-08-08','Invoice Payment Received: Tax 17',0,NULL,0,0),(39,'2022-08-15','Invoice Payment Received: Tax 17',0,NULL,0,0),(40,'2022-08-08','Automatic General Expense: Cash on hand',0,NULL,0,0),(41,'2022-08-08','Invoice: Tax 18',0,NULL,0,0),(42,'2022-08-08','ADVANCE SALARY FOR Salima ali',0,NULL,0,0),(43,'2022-08-15','Sale Return: SALE RETURN #2',0,NULL,0,0),(44,'2022-08-15','Sale Return Refund: SALE RETURN #2',0,NULL,0,0),(45,'2022-08-15','Sale Return Refund: SALE RETURN #2',0,NULL,0,0),(46,'2022-08-15','Sale Return Refund: SALE RETURN #2',0,NULL,0,0),(47,'2022-07-25','Sale Return: SALE RETURN #1',0,NULL,0,0),(48,'2022-08-11','ADVANCE SALARY FOR Marwan Emad',0,NULL,0,0),(49,'2022-08-13','Purchase Order: PURCHASE ORDER #7',0,NULL,0,0),(50,'2022-08-14','Invoice Payment Received: Tax invoice20',0,NULL,0,0),(51,'2022-08-15','Invoice Payment Received: Tax invoice20',0,NULL,0,0),(52,'2022-08-14','Automatic General Expense: Cash on hand',0,NULL,0,0),(53,'2022-08-14','Automatic General Expense: Cash on hand',0,NULL,0,0),(54,'2022-08-17','Invoice Payment Received: Tax invoice22',0,NULL,0,0),(55,'2022-08-18','Invoice Payment Received: Tax invoice22',0,NULL,0,1),(56,'2022-08-17','Automatic General Expense: Cash on hand',0,NULL,0,1),(57,'2022-08-18','receipt_voucher',1,'CASH',0,0),(58,'2022-08-18','journal_entry',1,'',0,0),(59,'2022-08-18','Purchase Order: PURCHASE ORDER #8',0,NULL,0,0),(60,'2022-08-18','payment_voucher',1,'',0,0),(61,'2022-08-18','Purchase Order: PURCHASE ORDER #9',0,NULL,0,0),(62,'2022-08-02','Automatic General Expense: المبلغ في اليد',0,NULL,0,0),(63,'2022-08-03','Invoice Payment Received: AMI/2022/13',0,NULL,0,0),(64,'2022-08-21','Purchase Order: PURCHASE ORDER #10',0,NULL,0,0),(65,'2022-08-23','Automatic General Expense: Cash on hand',0,NULL,0,0),(66,'2022-08-24','Invoice Payment Received: AMI/2022/103',0,NULL,0,0),(67,'2022-08-23','Invoice: AMI/2022/104',0,NULL,0,0),(68,'2022-08-25','Invoice Payment Received: AMI/2022/106',0,NULL,0,0),(69,'2022-08-25','Invoice Payment Received: AMI/2022/105',0,NULL,0,0),(70,'2022-08-24','Invoice: AMI/2022/107',0,NULL,0,0),(71,'2022-08-25','Invoice Payment Received: AMI/2022/107',0,NULL,0,0),(72,'2022-08-24','Invoice: AMI/2022/108',0,NULL,0,0),(73,'2022-08-24','Invoice Payment Received: AMI/2022/108',0,NULL,0,0),(74,'2022-08-25','Invoice: AMI/2022/109',0,NULL,0,0),(75,'2022-08-28','Invoice: AMI/2022/110',0,NULL,0,0),(76,'2022-08-30','journal_entry',1,'',0,0),(77,'2022-08-07','Automatic General Expense: Cash on hand',0,NULL,0,0),(78,'2022-08-31','Invoice: AMI/2022/115',0,NULL,0,0),(79,'2022-09-01','Invoice Payment Received: AMI/2022/115',0,NULL,0,0),(80,'2022-09-02','Invoice Payment Received: AMI/2022/115',0,NULL,0,0),(81,'2022-09-03','Invoice Payment Received: AMI/2022/115',0,NULL,0,0),(82,'2022-08-31','Invoice: AMI/2022/114',0,NULL,0,0),(83,'2022-09-02','Invoice Payment Received: AMI/2022/114',0,NULL,0,1),(84,'2022-09-03','Invoice Payment Received: AMI/2022/114',0,NULL,0,0),(85,'2022-09-01','Admin Admin Automatic Salaries Booking: October-2022',0,NULL,0,0),(86,'2022-09-01','Ali elsheikh Automatic Salaries Booking: October-2022',0,NULL,0,0),(87,'2022-09-01','Ali Ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(88,'2022-09-01','Ali Ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(89,'2022-09-01','Doaa abduljabar Automatic Salaries Booking: October-2022',0,NULL,0,0),(90,'2022-09-01','Marwan Emad Automatic Salaries Booking: October-2022',0,NULL,0,0),(91,'2022-09-01','MOHAMMED SAID Automatic Salaries Booking: October-2022',0,NULL,0,0),(92,'2022-09-01','Rayaa NUMANI Automatic Salaries Booking: October-2022',0,NULL,0,0),(93,'2022-09-01','Salima ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(94,'2022-09-01','Admin Admin Automatic Salaries process: October-2022',0,NULL,0,0),(95,'2022-09-01','Ali elsheikh Automatic Salaries process: October-2022',0,NULL,0,0),(96,'2022-09-01','Ali Ali Automatic Salaries process: October-2022',0,NULL,0,0),(97,'2022-09-01','Ali Ali Automatic Salaries process: October-2022',0,NULL,0,0),(98,'2022-09-01','Doaa abduljabar Automatic Salaries process: October-2022',0,NULL,0,0),(99,'2022-09-01','Marwan Emad Automatic Salaries process: October-2022',0,NULL,0,0),(100,'2022-09-01','MOHAMMED SAID Automatic Salaries process: October-2022',0,NULL,0,0),(101,'2022-09-01','Rayaa NUMANI Automatic Salaries process: October-2022',0,NULL,0,0),(102,'2022-09-01','Salima ali Automatic Salaries process: October-2022',0,NULL,0,0),(103,'2022-09-06','Invoice: AMI/2022/120',0,NULL,0,0),(104,'2022-09-20','Invoice Payment Received: AMI/2022/120',0,NULL,0,0),(105,'2022-09-14','Invoice Payment Received: AMI/2022/121',0,NULL,0,0),(106,'2022-09-15','Invoice Payment Received: AMI/2022/121',0,NULL,0,0),(107,'2022-09-07','Invoice Inventory: AMI/2022/121',0,NULL,0,0),(108,'2022-09-07','Automatic General Expense: Cash on hand',0,NULL,0,0),(109,'2022-09-07','Purchase Order: PURCHASE ORDER #12',0,NULL,0,0),(110,'2022-09-04','Purchase Order: PURCHASE ORDER #11',0,NULL,0,0),(111,'2022-09-08','Automatic Purchase Payment: PURCHASE ORDER #11',0,NULL,0,1),(112,'2022-09-07','Purchase Order: PURCHASE ORDER #13',0,NULL,0,0),(113,'2022-09-07','Automatic Purchase Payment: PURCHASE ORDER #13',0,NULL,0,0),(114,'2022-09-08','Invoice: AMI/2022/122',0,NULL,0,0),(115,'2022-09-09','Invoice Payment Received: AMI/2022/122',0,NULL,0,0),(116,'2022-09-10','Invoice Payment Received: AMI/2022/122',0,NULL,0,0),(117,'2022-09-08','Invoice Inventory: AMI/2022/122',0,NULL,0,0),(118,'2022-09-08','Admin Admin Automatic Salaries Booking: September-2022',0,NULL,0,0),(119,'2022-09-08','Ali elsheikh Automatic Salaries Booking: September-2022',0,NULL,0,0),(120,'2022-09-08','Ali Ali Automatic Salaries Booking: September-2022',0,NULL,0,0),(121,'2022-09-08','Marwan Emad Automatic Salaries Booking: September-2022',0,NULL,0,0),(122,'2022-09-08','MOHAMMED SAID Automatic Salaries Booking: September-2022',0,NULL,0,0),(123,'2022-09-08','Rayaa NUMANI Automatic Salaries Booking: September-2022',0,NULL,0,0),(124,'2022-09-08','Salima ali Automatic Salaries Booking: September-2022',0,NULL,0,0),(125,'2022-09-08','Admin Admin Automatic Salaries process: September-2022',0,NULL,0,0),(126,'2022-09-08','Ali elsheikh Automatic Salaries process: September-2022',0,NULL,0,0),(127,'2022-09-08','Ali Ali Automatic Salaries process: September-2022',0,NULL,0,0),(128,'2022-09-08','Marwan Emad Automatic Salaries process: September-2022',0,NULL,0,0),(129,'2022-09-08','MOHAMMED SAID Automatic Salaries process: September-2022',0,NULL,0,0),(130,'2022-09-08','Rayaa NUMANI Automatic Salaries process: September-2022',0,NULL,0,0),(131,'2022-09-08','Salima ali Automatic Salaries process: September-2022',0,NULL,0,0),(132,'2022-09-22','Purchase Order: PURCHASE ORDER #14',0,NULL,0,0),(133,'2022-09-22','Purchase Order: PURCHASE ORDER #15',0,NULL,0,0),(134,'2022-09-22','Invoice: AMI/2022/126',0,NULL,0,0),(135,'2022-09-22','Invoice Payment Received: AMI/2022/126',0,NULL,0,0),(136,'2022-09-02','Invoice Payment Received: AMI/2022/114',0,NULL,0,0),(137,'2022-09-22','Invoice Payment Received: AMI/2022/126',0,NULL,0,0),(138,'2022-09-24','Purchase Order:  أمر شراء #16',0,NULL,0,0),(139,'2022-09-24','Invoice Payment Received: AMI/2022/130',0,NULL,0,0),(140,'2022-09-24','Invoice: AMI/2022/130',0,NULL,0,0),(141,'2022-09-24','Automatic General Expense: Cash on hand',0,NULL,0,1),(142,'2022-09-24','Invoice Payment Received: AMI/2022/131',0,NULL,0,0),(143,'2022-09-24','Invoice: AMI/2022/131',0,NULL,0,0),(144,'2022-09-30','Invoice Payment Received: AMI/2022/132',0,NULL,0,0),(145,'2022-09-24','Invoice: AMI/2022/132',0,NULL,0,0),(146,'2022-09-24','Purchase Order: PURCHASE ORDER #17',0,NULL,0,0),(147,'2022-09-24','Automatic Purchase Payment: PURCHASE ORDER #17',0,NULL,0,0),(148,'2022-09-24','Purchase Order: PURCHASE ORDER #18',0,NULL,0,0),(149,'2022-09-24','Automatic Purchase Payment: PURCHASE ORDER #18',0,NULL,0,0),(150,'2022-09-24','Invoice: AMI/2022/134',0,NULL,0,0),(151,'2022-09-24','Invoice Inventory: AMI/2022/134',0,NULL,0,0),(152,'2022-09-22','Automatic General Expense: Cash on hand',0,NULL,0,0),(153,'2022-09-24','Automatic General Expense: Cash on hand',0,NULL,0,1),(154,'2022-09-24','Automatic General Expense: Cash on hand',0,NULL,0,1),(155,'2022-09-24','Automatic General Expense: Cash on hand',0,NULL,0,1),(156,'2022-09-24','Invoice: AMI/2022/136',0,NULL,0,0),(157,'2022-09-24','Automatic General Expense: Cash on hand',0,NULL,0,0),(158,'2022-09-30','Invoice Payment Received: AMI/2022/138',0,NULL,0,1),(159,'2022-10-05','Invoice Payment Received: AMI/2022/138',0,NULL,0,1),(160,'2022-09-30','Invoice Payment Received: AMI/2022/138',0,NULL,0,0),(161,'2022-09-24','Invoice: AMI/2022/138',0,NULL,0,0),(162,'2022-10-05','Invoice Payment Received: AMI/2022/138',0,NULL,0,0),(163,'2022-09-24','Invoice Inventory: AMI/2022/138',0,NULL,0,0),(164,'2022-09-24','Purchase Order: PURCHASE ORDER #19',0,NULL,0,0),(165,'2022-09-30','Invoice Payment Received: AMI/2022/136',0,NULL,0,0),(166,'2022-09-25','Invoice Payment Received: AMI/2022/139',0,NULL,0,0),(167,'2022-09-25','Automatic General Expense: Bank',0,NULL,0,1),(168,'2022-09-27','Invoice Payment Received: AMI/2022/142',0,NULL,0,0),(169,'2022-09-28','Invoice Payment Received: AMI/2022/142',0,NULL,0,0),(170,'2022-09-27','Invoice Payment Received: AMI/2022/143',0,NULL,0,0),(171,'2022-09-27','Invoice Payment Received: AMI/2022/143',0,NULL,0,0),(172,'2022-09-26','Automatic General Expense: Bank',0,NULL,0,0),(173,'2022-09-26','Purchase Order: PURCHASE ORDER #21',0,NULL,0,0),(174,'2022-09-27','Automatic Purchase Payment: PURCHASE ORDER #21',0,NULL,0,0),(175,'2022-10-04','Invoice: AMI/2022/147',0,NULL,0,0),(176,'2022-10-04','Invoice: AMI/2022/148',0,NULL,0,0),(177,'2022-10-04','Purchase Order: PURCHASE ORDER #22',0,NULL,0,0),(178,'2022-10-11','Invoice Payment Received: AMI/2022/154',0,NULL,0,0),(179,'2022-10-11','Automatic General Expense: Bank',0,NULL,0,0),(180,'2022-10-11','Invoice Payment Received: AMI/2022/155',0,NULL,0,0),(181,'2022-10-12','Automatic General Expense: Bank',0,NULL,0,0),(182,'2022-10-11','Automatic General Expense: Cash on hand',0,NULL,0,0),(183,'2022-10-11','Invoice Payment Received: AMI/2022/155',0,NULL,0,0),(184,'2022-10-11','Automatic General Expense: Cash on hand',0,NULL,0,0),(185,'2022-10-11','Admin Admin Automatic Salaries Booking: September-2022',0,NULL,0,0),(186,'2022-10-11','Ali elsheikh Automatic Salaries Booking: September-2022',0,NULL,0,0),(187,'2022-10-11','Ali Ali Automatic Salaries Booking: September-2022',0,NULL,0,0),(188,'2022-10-11','Doaa abduljabar Automatic Salaries Booking: September-2022',0,NULL,0,0),(189,'2022-10-11','Marwan Emad Automatic Salaries Booking: September-2022',0,NULL,0,0),(190,'2022-10-11','MOHAMMED SAID Automatic Salaries Booking: September-2022',0,NULL,0,0),(191,'2022-10-11','Rayaa NUMANI Automatic Salaries Booking: September-2022',0,NULL,0,0),(192,'2022-10-11','Salima ali Automatic Salaries Booking: September-2022',0,NULL,0,0),(193,'2022-10-11','Admin Admin Automatic Salaries process: September-2022',0,NULL,0,0),(194,'2022-10-11','Ali elsheikh Automatic Salaries process: September-2022',0,NULL,0,0),(195,'2022-10-11','Ali Ali Automatic Salaries process: September-2022',0,NULL,0,0),(196,'2022-10-11','Doaa abduljabar Automatic Salaries process: September-2022',0,NULL,0,0),(197,'2022-10-11','Marwan Emad Automatic Salaries process: September-2022',0,NULL,0,0),(198,'2022-10-11','MOHAMMED SAID Automatic Salaries process: September-2022',0,NULL,0,0),(199,'2022-10-11','Rayaa NUMANI Automatic Salaries process: September-2022',0,NULL,0,0),(200,'2022-10-11','Salima ali Automatic Salaries process: September-2022',0,NULL,0,0),(201,'2022-10-16','Invoice: AMI/2022/156',0,NULL,0,0),(202,'2022-10-18','Automatic General Expense: المبلغ في اليد',0,NULL,0,1),(203,'2022-10-18','Invoice Payment Received: AMI/2022/157',0,NULL,0,0),(204,'2022-10-18','Invoice: AMI/2022/157',0,NULL,0,0),(205,'2022-10-18','Sale Return: SALE RETURN #4',0,NULL,0,0),(206,'2022-10-19','Automatic General Expense: Cash on hand',0,NULL,0,0),(207,'2022-10-22','Invoice Payment Received: AMI/2022/159',0,NULL,0,0),(208,'2022-10-22','journal_entry',1,'',0,0),(209,'2022-10-22','Invoice: AMI/2022/161',0,NULL,0,0),(210,'2022-10-22','Invoice Payment Received: AMI/2022/161',0,NULL,0,0),(211,'2022-10-22','Automatic General Expense: Cheque',0,NULL,0,0),(212,'2022-10-22','Cheque Release: Expense',0,NULL,0,0),(213,'2022-10-23','Invoice: AMI/2022/162',0,NULL,0,0),(214,'2022-10-24','Invoice Payment Received: AMI/2022/162',0,NULL,0,0),(215,'2022-10-23','Automatic General Expense: Cash on hand',0,NULL,0,0),(216,'2022-10-25','journal_entry',1,'',0,0),(217,'2022-10-25','ADVANCE SALARY FOR Salima ali',0,NULL,0,0),(218,'2022-10-26','Purchase Order: PURCHASE ORDER #24',0,NULL,0,0),(219,'2022-10-28','Invoice Payment Received: AMI/2022/163',0,NULL,0,0),(220,'2022-10-14','Automatic General Expense: Cash on hand',0,NULL,0,0),(221,'2022-10-28','Invoice Payment Received: AMI/2022/164',0,NULL,0,0),(222,'2022-10-27','Invoice Inventory: AMI/2022/164',0,NULL,0,0),(223,'2022-10-27','Automatic General Expense: Bank',0,NULL,0,0),(224,'2022-10-27','Rayaa NUMANI Automatic Salaries Booking: November-2022',0,NULL,0,0),(225,'2022-10-27','Ali elsheikh Automatic Salaries Booking: November-2022',0,NULL,0,0),(226,'2022-10-27','Ali Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(227,'2022-10-27','MOHAMMED SAID Automatic Salaries Booking: November-2022',0,NULL,0,0),(228,'2022-10-27','Salima ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(229,'2022-10-27','Marwan Emad Automatic Salaries Booking: November-2022',0,NULL,0,0),(230,'2022-10-27','Doaa abduljabar Automatic Salaries Booking: November-2022',0,NULL,0,0),(231,'2022-10-27','Ali Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(232,'2022-10-27','mohamed ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(233,'2022-10-27','Admin Admin Automatic Salaries Booking: November-2022',0,NULL,0,0),(234,'2022-10-27','Rayaa NUMANI Automatic Salaries process: November-2022',0,NULL,0,0),(235,'2022-10-27','Ali elsheikh Automatic Salaries process: November-2022',0,NULL,0,0),(236,'2022-10-27','Ali Ali Automatic Salaries process: November-2022',0,NULL,0,0),(237,'2022-10-27','MOHAMMED SAID Automatic Salaries process: November-2022',0,NULL,0,0),(238,'2022-10-27','Salima ali Automatic Salaries process: November-2022',0,NULL,0,0),(239,'2022-10-27','Marwan Emad Automatic Salaries process: November-2022',0,NULL,0,0),(240,'2022-10-27','Doaa abduljabar Automatic Salaries process: November-2022',0,NULL,0,0),(241,'2022-10-27','Ali Ali Automatic Salaries process: November-2022',0,NULL,0,0),(242,'2022-10-27','mohamed ali Automatic Salaries process: November-2022',0,NULL,0,0),(243,'2022-10-27','Admin Admin Automatic Salaries process: November-2022',0,NULL,0,0),(244,'2022-10-28','Invoice Payment Received: AMI/2022/165',0,NULL,0,0),(245,'2022-10-28','Invoice Payment Received: AMI/2022/165',0,NULL,0,0),(246,'2022-10-27','Automatic General Expense: Bank',0,NULL,0,0),(247,'2022-10-27','Admin Admin Automatic Salaries Booking: December-2022',0,NULL,0,0),(248,'2022-10-27','Ali elsheikh Automatic Salaries Booking: December-2022',0,NULL,0,0),(249,'2022-10-27','Ali Ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(250,'2022-10-27','Ali Ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(251,'2022-10-27','Doaa abduljabar Automatic Salaries Booking: December-2022',0,NULL,0,0),(252,'2022-10-27','Marwan Emad Automatic Salaries Booking: December-2022',0,NULL,0,0),(253,'2022-10-27','mohamed ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(254,'2022-10-27','MOHAMMED SAID Automatic Salaries Booking: December-2022',0,NULL,0,0),(255,'2022-10-27','Rayaa NUMANI Automatic Salaries Booking: December-2022',0,NULL,0,0),(256,'2022-10-27','salim ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(257,'2022-10-27','Salima ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(258,'2022-10-27','Admin Admin Automatic Salaries process: December-2022',0,NULL,0,0),(259,'2022-10-27','Ali elsheikh Automatic Salaries process: December-2022',0,NULL,0,0),(260,'2022-10-27','Ali Ali Automatic Salaries process: December-2022',0,NULL,0,0),(261,'2022-10-27','Ali Ali Automatic Salaries process: December-2022',0,NULL,0,0),(262,'2022-10-27','Doaa abduljabar Automatic Salaries process: December-2022',0,NULL,0,0),(263,'2022-10-27','Marwan Emad Automatic Salaries process: December-2022',0,NULL,0,0),(264,'2022-10-27','mohamed ali Automatic Salaries process: December-2022',0,NULL,0,0),(265,'2022-10-27','MOHAMMED SAID Automatic Salaries process: December-2022',0,NULL,0,0),(266,'2022-10-27','Rayaa NUMANI Automatic Salaries process: December-2022',0,NULL,0,0),(267,'2022-10-27','salim ali Automatic Salaries process: December-2022',0,NULL,0,0),(268,'2022-10-27','Salima ali Automatic Salaries process: December-2022',0,NULL,0,0),(269,'2022-10-27','Purchase Order: PURCHASE ORDER #25',0,NULL,0,0),(270,'2022-11-01','Purchase Order: PURCHASE ORDER #26',0,NULL,0,0),(271,'2022-11-08','Automatic Purchase Payment: PURCHASE ORDER #26',0,NULL,0,0),(272,'2022-11-01','Invoice Payment Received: AMI/2022/166',0,NULL,0,0),(273,'2022-11-09','Invoice Payment Received: AMI/2022/167',0,NULL,0,0),(274,'2022-11-10','Invoice Payment Received: AMI/2022/167',0,NULL,0,0),(275,'2022-11-03','Automatic General Expense: Cash on hand',0,NULL,0,0),(276,'2022-11-03','Purchase Order: PURCHASE ORDER #27',0,NULL,0,0),(277,'2022-11-04','Automatic Purchase Payment: PURCHASE ORDER #27',0,NULL,0,0),(278,'2022-11-03','journal_entry',1,'',0,0),(279,'2022-11-03','Admin Admin Automatic Salaries Booking: October-2022',0,NULL,0,0),(280,'2022-11-03','Ali elsheikh Automatic Salaries Booking: October-2022',0,NULL,0,0),(281,'2022-11-03','Ali Ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(282,'2022-11-03','Ali Ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(283,'2022-11-03','Doaa abduljabar Automatic Salaries Booking: October-2022',0,NULL,0,0),(284,'2022-11-03','Marwan Emad Automatic Salaries Booking: October-2022',0,NULL,0,0),(285,'2022-11-03','MOHAMMED SAID Automatic Salaries Booking: October-2022',0,NULL,0,0),(286,'2022-11-03','Rayaa NUMANI Automatic Salaries Booking: October-2022',0,NULL,0,0),(287,'2022-11-03','Salima ali Automatic Salaries Booking: October-2022',0,NULL,0,0),(288,'2022-11-03','Admin Admin Automatic Salaries Booking: November-2022',0,NULL,0,0),(289,'2022-11-03','Ali elsheikh Automatic Salaries Booking: November-2022',0,NULL,0,0),(290,'2022-11-03','Ali Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(291,'2022-11-03','Ali Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(292,'2022-11-03','Doaa abduljabar Automatic Salaries Booking: November-2022',0,NULL,0,0),(293,'2022-11-03','Marwan Emad Automatic Salaries Booking: November-2022',0,NULL,0,0),(294,'2022-11-03','mohamed ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(295,'2022-11-03','MOHAMMED SAID Automatic Salaries Booking: November-2022',0,NULL,0,0),(296,'2022-11-03','Rayaa NUMANI Automatic Salaries Booking: November-2022',0,NULL,0,0),(297,'2022-11-03','Salima ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(298,'2022-11-03','Admin Admin Automatic Salaries process: November-2022',0,NULL,0,0),(299,'2022-11-03','Ali elsheikh Automatic Salaries process: November-2022',0,NULL,0,0),(300,'2022-11-03','Ali Ali Automatic Salaries process: November-2022',0,NULL,0,0),(301,'2022-11-03','Ali Ali Automatic Salaries process: November-2022',0,NULL,0,0),(302,'2022-11-03','Doaa abduljabar Automatic Salaries process: November-2022',0,NULL,0,0),(303,'2022-11-03','Marwan Emad Automatic Salaries process: November-2022',0,NULL,0,0),(304,'2022-11-03','mohamed ali Automatic Salaries process: November-2022',0,NULL,0,0),(305,'2022-11-03','MOHAMMED SAID Automatic Salaries process: November-2022',0,NULL,0,0),(306,'2022-11-03','Rayaa NUMANI Automatic Salaries process: November-2022',0,NULL,0,0),(307,'2022-11-03','Salima ali Automatic Salaries process: November-2022',0,NULL,0,0),(308,'2022-11-10','Automatic Purchase Payment: PURCHASE ORDER #6',0,NULL,0,0),(309,'2022-11-10','Invoice: AMI/2022/169',0,NULL,0,0),(310,'2022-11-11','Bank Money Transfer',1,NULL,0,0),(311,'2022-10-22','Cheque Release: Expense',0,NULL,0,0),(312,'2022-11-11','Invoice: AMI/2022/170',0,NULL,0,0),(313,'2022-11-12','Invoice: AMI/2022/171',0,NULL,0,0),(314,'2022-11-13','Purchase Order: PURCHASE ORDER #28',0,NULL,0,0),(315,'2022-11-14','Automatic Purchase Payment: PURCHASE ORDER #28',0,NULL,0,0),(316,'2022-11-14','Automatic Purchase Payment: PURCHASE ORDER #28',0,NULL,0,0),(317,'2022-11-14','Invoice Payment Received: AMI/2022/172',0,NULL,0,0),(318,'2022-11-13','Invoice Inventory: AMI/2022/172',0,NULL,0,0),(319,'2022-11-13','Automatic General Expense: Bank',0,NULL,0,0),(320,'2022-11-14','Invoice Payment Received: AMI/2022/171',0,NULL,0,0),(321,'2022-11-11','Invoice Payment Received: AMI/2022/169',0,NULL,0,0),(322,'2022-11-14','Invoice: AMI/2022/175',0,NULL,0,0),(323,'2022-11-15','Purchase Order: PURCHASE ORDER #29',0,NULL,0,0),(324,'2022-11-15','Invoice: AMI/2022/177',0,NULL,0,0),(325,'2022-11-15','Invoice Payment Received: AMI/2022/178',0,NULL,0,0),(326,'2022-11-17','Invoice Payment Received: AMI/2022/178',0,NULL,0,0),(327,'2022-11-15','Automatic General Expense: Bank',0,NULL,0,0),(328,'2022-11-15','ADVANCE SALARY FOR Doaa Elsheikh',0,NULL,0,0),(329,'2022-11-15','Admin Admin Automatic Salaries Booking: December-2022',0,NULL,0,0),(330,'2022-11-15','Doaa Elsheikh Automatic Salaries Booking: December-2022',0,NULL,0,0),(331,'2022-11-15','Laila Ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(332,'2022-11-15','Salma Ali Automatic Salaries Booking: December-2022',0,NULL,0,0),(333,'2022-11-15','Admin Admin Automatic Salaries process: December-2022',0,NULL,0,0),(334,'2022-11-15','Doaa Elsheikh Automatic Salaries process: December-2022',0,NULL,0,0),(335,'2022-11-15','Laila Ali Automatic Salaries process: December-2022',0,NULL,0,0),(336,'2022-11-15','Salma Ali Automatic Salaries process: December-2022',0,NULL,0,0),(337,'2022-11-16','Invoice: Taadq/1001',0,NULL,0,0),(338,'2022-11-16','Invoice: Taadq/1002',0,NULL,0,0),(339,'2022-11-16','Invoice: Taadq/1003',0,NULL,0,0),(340,'2022-11-17','Invoice: Taadq/1004',0,NULL,0,0),(341,'2022-11-17','Invoice: Taadq/1005',0,NULL,0,0),(342,'2022-11-19','Invoice: Taadq/1006',0,NULL,0,0),(343,'2022-11-19','Invoice: Taadq/1007',0,NULL,0,0),(344,'2022-11-19','Invoice: Taadq/1008',0,NULL,0,0),(345,'2022-11-20','ADVANCE SALARY FOR ahmed Mohammed',0,NULL,0,0),(346,'2022-11-20','Admin Admin Automatic Salaries Booking: November-2022',0,NULL,0,0),(347,'2022-11-20','ahmed Mohammed Automatic Salaries Booking: November-2022',0,NULL,0,0),(348,'2022-11-20','Doaa Elsheikh Automatic Salaries Booking: November-2022',0,NULL,0,0),(349,'2022-11-20','Laila Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(350,'2022-11-20','Salma Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(351,'2022-11-20','Admin Admin Automatic Salaries process: November-2022',0,NULL,0,0),(352,'2022-11-20','ahmed Mohammed Automatic Salaries process: November-2022',0,NULL,0,0),(353,'2022-11-20','Doaa Elsheikh Automatic Salaries process: November-2022',0,NULL,0,0),(354,'2022-11-20','Laila Ali Automatic Salaries process: November-2022',0,NULL,0,0),(355,'2022-11-20','Salma Ali Automatic Salaries process: November-2022',0,NULL,0,0),(356,'2022-11-22','Invoice: Taadq/1011',0,NULL,0,0),(357,'2022-11-23','Invoice Payment Received: Taadq/1011',0,NULL,0,0),(358,'2022-11-22','Invoice: Taadq/1012',0,NULL,0,0),(359,'2022-11-28','Invoice Payment Received: Taadq/1014',0,NULL,0,0),(360,'2022-11-27','Invoice Payment Received: Taadq/1014',0,NULL,0,0),(361,'2022-11-27','Admin Admin Automatic Salaries Booking: November-2022',0,NULL,0,0),(362,'2022-11-27','ahmed Mohammed Automatic Salaries Booking: November-2022',0,NULL,0,0),(363,'2022-11-27','Ali Elsheikh Automatic Salaries Booking: November-2022',0,NULL,0,0),(364,'2022-11-27','Doaa Elsheikh Automatic Salaries Booking: November-2022',0,NULL,0,0),(365,'2022-11-27','Laila Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(366,'2022-11-27','Salma Ali Automatic Salaries Booking: November-2022',0,NULL,0,0),(367,'2022-11-27','Admin Admin Automatic Salaries process: November-2022',0,NULL,0,0),(368,'2022-11-27','ahmed Mohammed Automatic Salaries process: November-2022',0,NULL,0,0),(369,'2022-11-27','Ali Elsheikh Automatic Salaries process: November-2022',0,NULL,0,0),(370,'2022-11-27','Doaa Elsheikh Automatic Salaries process: November-2022',0,NULL,0,0),(371,'2022-11-27','Laila Ali Automatic Salaries process: November-2022',0,NULL,0,0),(372,'2022-11-27','Salma Ali Automatic Salaries process: November-2022',0,NULL,0,0),(373,'2022-11-29','Invoice Payment Received: Taadq/1016',0,NULL,0,0),(374,'2022-12-02','Invoice Payment Received: Taadq/1016',0,NULL,0,0),(375,'2022-11-27','Invoice: Taadq/1015',0,NULL,0,0),(376,'2022-12-11','Invoice Payment Received: Taadq/1015',0,NULL,0,0),(377,'2022-12-26','Invoice Payment Received: Taadq/1015',0,NULL,0,0),(378,'2022-12-21','Invoice: Taadq/1017',0,NULL,0,0),(379,'2022-11-14','Invoice: Taadq/173',0,NULL,0,0),(380,'2023-01-29','journal_entry',1,'123',0,0),(381,'2023-01-29','Purchase Order: PURCHASE ORDER #30',0,NULL,0,0),(382,'2023-01-29','Purchase Order: PURCHASE ORDER #31',0,NULL,0,0),(383,'2023-01-31','Invoice Payment Received: Taadq/1024',0,NULL,0,0),(384,'2023-01-29','Invoice Inventory: Taadq/1024',0,NULL,0,0),(385,'2023-01-30','Invoice Payment Received: Taadq/1024',0,NULL,0,0),(386,'2023-01-29','Automatic General Expense: Cash on hand',0,NULL,0,0),(387,'2023-01-31','Invoice Payment Received: Taadq/1025',0,NULL,0,0),(388,'2023-02-02','Invoice Payment Received: Taadq/1025',0,NULL,0,0),(389,'2023-01-30','Automatic General Expense: Bank',0,NULL,0,0),(390,'2023-02-01','Invoice Payment Received: Taadq/1027',0,NULL,0,0),(391,'2023-02-01','Invoice Payment Received: Taadq/1027',0,NULL,0,0),(392,'2023-01-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(393,'2023-01-31','Purchase Order: PURCHASE ORDER #32',0,NULL,0,0),(394,'2023-02-06','Automatic General Expense: Cash on hand',0,NULL,0,0),(395,'2023-02-02','Purchase Order: PURCHASE ORDER #33',0,NULL,0,0),(396,'2023-02-07','Automatic Purchase Payment: PURCHASE ORDER #33',0,NULL,0,0),(397,'2023-02-10','Invoice: Taadq/1031',0,NULL,0,0),(398,'2023-02-16','Purchase Order: PURCHASE ORDER #34',0,NULL,0,0),(399,'2023-02-17','Automatic Purchase Payment: PURCHASE ORDER #34',0,NULL,0,0),(400,'2023-04-13','Admin Admin Automatic Salaries Booking: April-2023',0,NULL,0,0),(401,'2023-04-13','ahmed Mohammed Automatic Salaries Booking: April-2023',0,NULL,0,0),(402,'2023-04-13','Ali Elsheikh Automatic Salaries Booking: April-2023',0,NULL,0,0),(403,'2023-04-13','Azhar Ali Automatic Salaries Booking: April-2023',0,NULL,0,0),(404,'2023-04-13','Doaa Elsheikh Automatic Salaries Booking: April-2023',0,NULL,0,0),(405,'2023-04-13','Laila Ali Automatic Salaries Booking: April-2023',0,NULL,0,0),(406,'2023-04-13','Saif ali Automatic Salaries Booking: April-2023',0,NULL,0,0),(407,'2023-04-13','Salma Ali Automatic Salaries Booking: April-2023',0,NULL,0,0),(408,'2023-04-13','Admin Admin Automatic Salaries process: April-2023',0,NULL,0,0),(409,'2023-04-13','ahmed Mohammed Automatic Salaries process: April-2023',0,NULL,0,0),(410,'2023-04-13','Ali Elsheikh Automatic Salaries process: April-2023',0,NULL,0,0),(411,'2023-04-13','Azhar Ali Automatic Salaries process: April-2023',0,NULL,0,0),(412,'2023-04-13','Doaa Elsheikh Automatic Salaries process: April-2023',0,NULL,0,0),(413,'2023-04-13','Laila Ali Automatic Salaries process: April-2023',0,NULL,0,0),(414,'2023-04-13','Saif ali Automatic Salaries process: April-2023',0,NULL,0,0),(415,'2023-04-13','Salma Ali Automatic Salaries process: April-2023',0,NULL,0,0),(416,'2023-04-14','Invoice Payment Received: Taadq/1033',0,NULL,0,0),(417,'2023-04-16','Invoice Payment Received: Taadq/1033',0,NULL,0,0),(418,'2023-01-05','Invoice: Taadq/1036',0,NULL,0,0),(419,'2023-04-19','Invoice Payment Received: Taadq/1037',0,NULL,0,0),(420,'2023-04-19','Invoice Payment Received: Taadq/1037',0,NULL,0,0),(421,'2023-04-18','Invoice Inventory: Taadq/1037',0,NULL,0,0),(422,'2023-04-18','Purchase Order: PURCHASE ORDER #35',0,NULL,0,0),(423,'2023-04-19','Automatic Purchase Payment: PURCHASE ORDER #35',0,NULL,0,0),(424,'2023-05-31','Invoice: Taadq/1038',0,NULL,0,0),(425,'2023-06-08','Invoice: Taadq/1039',0,NULL,0,0),(426,'2023-06-08','Invoice: Taadq/1040',0,NULL,0,0),(427,'2023-06-08','Invoice: Taadq/1041',0,NULL,0,0),(428,'2023-06-18','Invoice: Taadq/1042',0,NULL,0,0),(429,'2023-07-02','Invoice: Taadq/1044',0,NULL,0,0),(430,'2023-07-02','Invoice: Taadq/1045',0,NULL,0,0),(431,'2023-07-03','Invoice: Taadq/1046',0,NULL,0,0),(432,'2023-07-10','Invoice: Taadq/1047',0,NULL,0,0),(433,'2023-07-14','ADVANCE SALARY FOR Laila Ali',0,NULL,0,0),(434,'2023-07-14','ADVANCE SALARY FOR Ali Elsheikh',0,NULL,0,0),(435,'2023-07-14','Purchase Order:  أمر شراء #36',0,NULL,0,0),(436,'2023-07-20','Invoice: Taadq/1048',0,NULL,0,0),(437,'2023-08-02','Invoice: Taadq/1049',0,NULL,0,0),(438,'2023-08-03','Invoice: Taadq/1050',0,NULL,0,0),(439,'2023-08-03','Invoice: Taadq/1051',0,NULL,0,0),(440,'2023-08-04','Invoice: Taadq/1052',0,NULL,0,0),(441,'2023-08-22','Invoice: Taadq/1054',0,NULL,0,0),(442,'2023-09-01','Invoice: Taadq/1055',0,NULL,0,0),(443,'2023-09-01','Invoice: Taadq/1056',0,NULL,0,0),(444,'2023-09-05','Invoice: Taadq/1057',0,NULL,0,0);

--
-- Table structure for table `erp_demousers`
--

CREATE TABLE `erp_demousers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `superior_id` int(11) DEFAULT '-1',
  `user_type` enum('staff','client','lead') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'client',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `message_checked_at` datetime DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `notification_checked_at` datetime DEFAULT NULL,
  `is_primary_contact` tinyint(1) NOT NULL DEFAULT '0',
  `job_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `disable_login` tinyint(1) NOT NULL DEFAULT '0',
  `note` mediumtext COLLATE utf8_unicode_ci,
  `address` text COLLATE utf8_unicode_ci,
  `alternative_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,
  `dob` date DEFAULT NULL,
  `ssn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` enum('male','female') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male',
  `sticky_note` mediumtext COLLATE utf8_unicode_ci,
  `external_links` mediumtext COLLATE utf8_unicode_ci,
  `skype` text COLLATE utf8_unicode_ci,
  `enable_web_notification` tinyint(1) NOT NULL DEFAULT '1',
  `enable_email_notification` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `last_online` datetime DEFAULT NULL,
  `pt_account_id` int(11) NOT NULL DEFAULT '0',
  `sal_account_id` int(11) NOT NULL DEFAULT '0',
  `imb_account_id` int(11) NOT NULL DEFAULT '0',
  `resident_card_no` text COLLATE utf8_unicode_ci,
  `resident_card_expiry` date DEFAULT NULL,
  `passport_no` text COLLATE utf8_unicode_ci,
  `passport_expiry` date DEFAULT NULL,
  `requested_account_removal` tinyint(1) DEFAULT '0',
  `payroll` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_type` (`user_type`),
  KEY `email` (`email`),
  KEY `client_id` (`client_id`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `erp_demousers`
--

INSERT INTO `erp_demousers` VALUES (1,'Admin','Admin',-1,'staff',1,0,'admin@teamway.om','e10adc3949ba59abbe56e057f20f883e','a:1:{s:9:\"file_name\";s:29:\"_file6370c8b1aec3e-avatar.png\";}','active','2023-11-20 08:08:30',0,'2023-01-31 06:57:54',0,'Admin',0,NULL,'','','','','2022-07-18','','male','Assets management/Inventory \nDaily Area cheklist \nWeekly inspection\nSend notification of employee and admin on last date of leave\n',NULL,'',1,1,'2022-07-18 09:22:15','2025-05-28 07:41:06',80,81,82,NULL,NULL,NULL,NULL,0,1,0),(36,'yahya','albarashdi',-1,'client',0,0,'yahya@gmail.com','d41d8cd98f00b204e9800998ecf8427e',NULL,'active',NULL,4,NULL,1,'',0,'',NULL,NULL,'42145456',NULL,NULL,NULL,'male',NULL,NULL,'',1,1,'2022-07-24 13:47:22',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(37,'Rayaa','NUMANI',-1,'staff',0,3,'rayaa@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'DIRECTOR',0,NULL,'',NULL,'96732399',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-07-24 14:12:07','2022-07-27 08:24:56',0,0,0,NULL,NULL,NULL,NULL,0,1,1),(38,'Ali','elsheikh',-1,'staff',0,3,'ali@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'director',0,NULL,'gbfdgb',NULL,'515677',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-07-26 06:54:23',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(39,'Ali','Ali',-1,'staff',0,4,'alim@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'sales assitant ',0,NULL,'',NULL,'9673234',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-08-02 08:45:51','2022-08-07 10:20:31',0,0,0,NULL,NULL,NULL,NULL,0,1,1),(40,'MOHAMMED','SAID',-1,'staff',0,5,'SAID@GMAIL.COM','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'PROJECT MANAGER',0,NULL,'',NULL,'65466466',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-08-04 08:59:34',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(41,'Salima','ali',-1,'staff',0,6,'salima@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'marketing',0,NULL,'dnmbc',NULL,'9483847',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-08-08 07:51:48',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(42,'Marwan','Emad',-1,'staff',0,0,'marwam@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'accounting',0,NULL,'',NULL,'0512345678',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-08-11 08:16:17',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(43,'Doaa','abduljabar',-1,'staff',0,4,'doaa@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'sales',0,NULL,'jhqf',NULL,'78`4674',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-08-14 12:31:37',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(44,'Ali','Ali',-1,'staff',0,5,'ali1@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'senior project manger ',0,NULL,'',NULL,'901479824975',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-08-23 07:09:28',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(45,'Osama','Abubaker',-1,'client',0,0,'osaama498@gmail.com','d41d8cd98f00b204e9800998ecf8427e',NULL,'active',NULL,24,NULL,1,'Manager',0,'',NULL,NULL,'91730041',NULL,NULL,NULL,'male',NULL,NULL,'',1,1,'2022-09-24 05:19:51',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(46,'','',-1,'client',0,0,'',NULL,NULL,'active',NULL,0,NULL,0,'Untitled',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,NULL,NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(47,'mohamed','ali',-1,'staff',0,0,'m.m@m.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'test',0,NULL,'oman',NULL,'12345678',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-10-10 13:25:17','2022-10-10 13:36:02',0,0,0,NULL,NULL,NULL,NULL,0,1,1),(48,'NASER','ALAAMRI',-1,'client',0,0,'goldengoals222@gmail.com','d41d8cd98f00b204e9800998ecf8427e',NULL,'active',NULL,34,NULL,1,'FFF',0,'',NULL,NULL,'0000000000',NULL,NULL,NULL,'male',NULL,NULL,'',1,1,'2022-10-22 05:49:37',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(49,'Amal','ali',-1,'staff',0,13,'amal@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'inactive',NULL,0,NULL,0,'fdagf',0,NULL,'hbf,jfmrf',NULL,'94377486',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-10-27 08:53:13',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(50,'salim','ali',-1,'staff',0,13,'salim@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'aggg',0,NULL,'kdjner',NULL,'13255',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-10-27 13:58:38',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(51,'sara','ali',-1,'staff',0,14,'sara@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'sales',0,NULL,'',NULL,'233245',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-11-01 11:18:23',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(52,'Ali ','Mohammed',-1,'staff',0,15,'ali123@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'Coordinator',0,NULL,'test',NULL,'96732399',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-11-03 08:10:53',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(53,'Doaa','Elsheikh',-1,'staff',0,4,'doaa@gmail.com','af9433fc7745a9a7c37e32fab8bbcfd1',NULL,'active',NULL,0,NULL,0,'Sales',0,NULL,'',NULL,'96732399',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-11-13 09:20:12',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(54,'Salma','Ali',-1,'staff',0,14,'salma@gmail.com','ef82d7be0e12d33765403cf2987edf33',NULL,'active',NULL,0,NULL,0,'Purchase assistant',0,NULL,'',NULL,'976543',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-11-13 11:53:48',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(55,'Laila','Ali',-1,'staff',0,16,'laila@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'Sales',0,NULL,'',NULL,'78767654',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-11-15 10:24:33',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(56,'ahmed','Mohammed',-1,'staff',1,0,'Ahmed@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'Operation supervisor',0,NULL,'Muscat Almawaleh',NULL,'79119561',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-11-20 11:08:14',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(57,'h','a',-1,'staff',0,0,'h@hg.v','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'it',0,NULL,'-',NULL,'-',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2022-11-27 06:21:24',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,1),(58,'Ali','Elsheikh',-1,'staff',0,4,'ali@gmsil.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'Sales Executive',0,NULL,'',NULL,'admin@teamway.om',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2022-11-27 09:41:16',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(59,'Saif','ali',-1,'staff',0,3,'saif@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'GM',0,NULL,'',NULL,'987654323',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2023-01-31 07:39:34',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(60,'Azhar','Ali',-1,'staff',0,4,'azhar@gmail.com','e10adc3949ba59abbe56e057f20f883e',NULL,'active',NULL,0,NULL,0,'Sales',0,NULL,'',NULL,'97865544',NULL,NULL,NULL,'female',NULL,NULL,NULL,1,1,'2023-04-13 09:10:20',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0),(61,'Salah','ali',-1,'staff',0,4,'salah@gmail.com','21c6cf59906e3d1e9a94ce2034982a8d',NULL,'active',NULL,0,NULL,0,'Sales executive',0,NULL,'',NULL,'9673244',NULL,NULL,NULL,'male',NULL,NULL,NULL,1,1,'2023-04-18 10:15:08',NULL,0,0,0,NULL,NULL,NULL,NULL,0,1,0);

--
-- Table structure for table `estimate_forms`
--

CREATE TABLE `estimate_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 `estimate_forms`
--


--
-- Table structure for table `estimate_items`
--

CREATE TABLE `estimate_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 `estimate_items`
--


--
-- Table structure for table `estimate_requests`
--

CREATE TABLE `estimate_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 `estimate_requests`
--


--
-- Table structure for table `estimates`
--

CREATE TABLE `estimates` (
  `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 `estimates`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `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 `events`
--


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

CREATE TABLE `expense_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 `expense_categories`
--


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

CREATE TABLE `expenses` (
  `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 `expenses`
--


--
-- Table structure for table `expires`
--

CREATE TABLE `expires` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item` text COLLATE utf8_unicode_ci,
  `type` text COLLATE utf8_unicode_ci,
  `department_id` int(11) DEFAULT NULL,
  `expiry` date DEFAULT NULL,
  `recurring_charges` int(11) DEFAULT NULL,
  `responsible_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `status` enum('alert','ignore') COLLATE utf8_unicode_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expires`
--

INSERT INTO `expires` VALUES (1,'Vehicle 123/AB','Car Registration',1,'2012-12-12',300,36,325,'alert',1),(2,'www.abcdd.com','Domain',2,'2020-08-08',0,35,109,'ignore',1),(3,'www.abc.com','Hosting',2,'2021-07-22',100,36,109,'alert',1),(4,'qqq','Visa',1,'2020-08-25',0,68,0,'ignore',1),(5,'MUNICIPAL LICENSE','Insurance',1,'2021-12-18',100,77,0,'alert',0),(6,'TENANCY AGREEMENT','Insurance',1,'2023-01-31',1,77,0,'alert',0),(7,'COMMERCIAL REGISTRATION','Insurance',1,'2022-08-12',36,77,0,'alert',0),(8,'M. BAGI VISA','Visa',1,'2024-02-09',350,77,0,'alert',0),(9,'M.ESSAM VISA','Visa',1,'2021-10-04',350,77,0,'alert',1),(10,'MOMIN VISA','Visa',1,'2023-08-20',350,77,0,'alert',0),(11,'SOLMAZ VISA','Visa',1,'2023-01-16',350,77,0,'alert',1),(12,'MAJDELDIN VISA','Visa',1,'2022-12-08',350,77,0,'alert',0),(13,' ACCENT MOTOR VEHICLE LICENSE (14391)','Insurance',1,'2022-07-25',44,77,0,'alert',0),(14,'TAGHRID VISA','Visa',1,'2023-10-12',350,77,0,'alert',0),(15,'SHARIF VISA','Visa',1,'2023-01-28',350,77,0,'alert',0),(16,'HUSAM FUAD VISA','Visa',1,'2022-02-06',350,77,0,'alert',0),(17,'SAKIBUL VISA','Visa',1,'2022-05-13',350,77,0,'alert',0),(18,'ALAA VISA','Visa',1,'2023-04-07',402,77,0,'alert',0),(19,'SONATA MOTOR VEHICLE LICENSE(3284)','Car Insurance',1,'2022-05-10',100,77,0,'alert',0),(20,'SONATA MOTOR VEHICHLE LICENSE(99710)','Car Insurance',1,'2023-03-09',44,77,0,'alert',0),(21,'MALIPU MOTOR VEHICLE LICENSE','Car Insurance',1,'2022-09-04',100,77,0,'alert',0),(22,'RENT A CAR 4815','Insurance',1,'2020-11-24',0,77,0,'alert',1),(23,'RENT A CAR (4815) SOLMAZ','Car Insurance',1,'2020-11-24',100,77,0,'ignore',1),(24,'M.ALI VISA','Visa',1,'2022-08-10',350,77,0,'alert',0),(25,'TALHA VISA','Visa',1,'2021-04-16',350,77,0,'alert',1),(26,'MUFEEZ VISA','Visa',1,'2022-01-17',350,77,0,'alert',1),(27,'AMAR VISA','Visa',1,'2022-09-15',350,77,0,'alert',1),(28,'IMRAN VISA','Visa',1,'2023-02-04',350,77,0,'alert',0),(29,'DOAA VISA','Visa',1,'2022-12-14',350,77,0,'alert',0),(30,'SHAHID VISA','Visa',1,'2023-12-25',350,77,0,'alert',0),(31,'TAGHRID VISA','Visa',1,'2021-10-11',350,77,0,'alert',1),(32,'WISAM VISA','Visa',1,'2020-11-19',350,77,0,'alert',1),(33,'OMER KHAN VISA','Visa',1,'2023-11-24',350,77,0,'alert',0),(34,'ADNAN VISA','Visa',1,'2021-03-21',350,77,0,'alert',1),(35,'BASHAR VISA','Visa',1,'2022-07-29',350,77,0,'alert',1),(36,'MUFEEZ VISA','Visa',1,'2022-01-17',350,77,0,'alert',1),(37,'EMAN VISA','Visa',1,'2022-01-10',350,77,0,'alert',1),(38,'AMANI ID CARD','Visa',8,'2022-07-03',0,77,0,'alert',0),(39,'OMAYER VISA','Visa',1,'2023-01-30',350,77,0,'alert',0),(40,'SHUBAZ VISA','Visa',1,'2022-12-22',0,77,0,'alert',0),(41,'WALEED VISA','Visa',1,'2022-12-04',0,77,0,'alert',0),(42,'WAQAS VISA','Visa',1,'2021-08-30',0,77,0,'alert',1),(43,'MOHAMED BASHEER','Visa',1,'2023-01-09',0,77,0,'alert',0),(44,'ALI','Visa',8,'2025-06-03',0,77,0,'alert',0),(45,'RAKIB','Visa',1,'2023-01-12',0,77,0,'alert',0),(46,'ZUHAIB','Visa',1,'2021-06-17',0,77,0,'alert',1),(47,'ID CARD DHAI','Visa',1,'2022-01-12',0,77,0,'alert',1),(48,'Mustafa','Visa',1,'2021-07-14',350,77,0,'alert',1),(49,'M.Nasser','Visa',1,'2023-04-14',350,77,0,'alert',0),(50,'Abdel Gader','Visa',1,'2024-01-23',350,77,0,'alert',0),(51,'Makkawi','Visa',1,'2023-03-28',350,77,0,'alert',0),(52,'VEHICLE DRIVER LICENCE/ MAKKAWI','Car Registration',1,'2023-11-19',100,77,0,'alert',0),(53,'VEHICLE DRIVER LICENCE /M.NASSER','Car Registration',1,'2022-05-02',100,77,0,'alert',0),(54,'jay','Visa',1,'2028-07-01',0,77,0,'alert',1),(55,'SUBARU MOTOR VEHICLE LICENSE (19458)','Car Insurance',1,'2022-05-19',100,77,0,'alert',0),(56,'Yaqoub ','Visa',1,'2022-05-08',350,77,0,'alert',1),(57,'Zahid','Visa',1,'2023-04-21',350,77,0,'alert',0),(58,'MOMEN LICENSE ','Car Insurance',1,'2023-02-23',50,77,0,'alert',0),(59,'MAKKAWI LICENSE ','Car Insurance',1,'2021-11-19',50,77,0,'alert',1),(60,'MAJD LICENSE ','Car Insurance',1,'2027-06-20',50,77,0,'alert',0),(61,'SHARIF LICENSE ','Car Insurance',1,'2023-06-01',50,77,0,'alert',0),(62,'VEHICLE DRIVER LICENCE/','Car Insurance',1,'2022-08-08',40,77,0,'alert',1),(63,'MEMBER CERTIFICATE ','Insurance',1,'2023-08-03',38,77,0,'alert',0),(64,'I10 VEHICLE LICENSE (13408) ','Car Insurance',2,'2023-08-08',40,77,0,'alert',0),(65,'DOAA LICENSE ','Car Insurance',2,'2022-05-12',40,77,0,'alert',0),(66,'Mahmoud ','Visa',1,'2023-03-01',350,77,0,'alert',0),(67,'Jehad','Visa',1,'2023-01-27',350,77,0,'alert',0),(68,'Vehicle driver','Car Insurance',1,'2023-02-07',40,77,0,'alert',0);

--
-- Table structure for table `final_erp_testaccounts`
--

CREATE TABLE `final_erp_testaccounts` (
  `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 `final_erp_testaccounts`
--

INSERT INTO `final_erp_testaccounts` 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 `final_erp_testactivity_logs`
--

CREATE TABLE `final_erp_testactivity_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 `final_erp_testactivity_logs`
--


--
-- Table structure for table `final_erp_testannouncements`
--

CREATE TABLE `final_erp_testannouncements` (
  `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 `final_erp_testannouncements`
--


--
-- Table structure for table `final_erp_testattendance`
--

CREATE TABLE `final_erp_testattendance` (
  `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 `final_erp_testattendance`
--


--
-- Table structure for table `final_erp_testchecklist_items`
--

CREATE TABLE `final_erp_testchecklist_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 `final_erp_testchecklist_items`
--


--
-- Table structure for table `final_erp_testci_sessions`
--

CREATE TABLE `final_erp_testci_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 `final_erp_testci_sessions`
--

INSERT INTO `final_erp_testci_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('0bb70792d0afb6d43c27f2db0ca2f26d9ece771f','197.252.202.129',1652869978,_binary '__ci_last_regenerate|i:1652869752;user_id|s:1:\"1\";');

--
-- Table structure for table `final_erp_testclient_groups`
--

CREATE TABLE `final_erp_testclient_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 `final_erp_testclient_groups`
--


--
-- Table structure for table `final_erp_testclients`
--

CREATE TABLE `final_erp_testclients` (
  `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 `final_erp_testclients`
--


--
-- Table structure for table `final_erp_testcontacts`
--

CREATE TABLE `final_erp_testcontacts` (
  `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 `final_erp_testcontacts`
--


--
-- Table structure for table `final_erp_testcustom_field_values`
--

CREATE TABLE `final_erp_testcustom_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 `final_erp_testcustom_field_values`
--


--
-- Table structure for table `final_erp_testcustom_fields`
--

CREATE TABLE `final_erp_testcustom_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 `final_erp_testcustom_fields`
--


--
-- Table structure for table `final_erp_testcustom_widgets`
--

CREATE TABLE `final_erp_testcustom_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 `final_erp_testcustom_widgets`
--


--
-- Table structure for table `final_erp_testdashboards`
--

CREATE TABLE `final_erp_testdashboards` (
  `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 `final_erp_testdashboards`
--


--
-- Table structure for table `final_erp_testdelivery_note_items`
--

CREATE TABLE `final_erp_testdelivery_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 `final_erp_testdelivery_note_items`
--


--
-- Table structure for table `final_erp_testdelivery_notes`
--

CREATE TABLE `final_erp_testdelivery_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 `final_erp_testdelivery_notes`
--


--
-- Table structure for table `final_erp_testemail_templates`
--

CREATE TABLE `final_erp_testemail_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 `final_erp_testemail_templates`
--


--
-- Table structure for table `final_erp_testenteries`
--

CREATE TABLE `final_erp_testenteries` (
  `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 `final_erp_testenteries`
--


--
-- Table structure for table `final_erp_testestimate_forms`
--

CREATE TABLE `final_erp_testestimate_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 `final_erp_testestimate_forms`
--


--
-- Table structure for table `final_erp_testestimate_items`
--

CREATE TABLE `final_erp_testestimate_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 `final_erp_testestimate_items`
--


--
-- Table structure for table `final_erp_testestimate_requests`
--

CREATE TABLE `final_erp_testestimate_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 `final_erp_testestimate_requests`
--


--
-- Table structure for table `final_erp_testestimates`
--

CREATE TABLE `final_erp_testestimates` (
  `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 `final_erp_testestimates`
--


--
-- Table structure for table `final_erp_testevents`
--

CREATE TABLE `final_erp_testevents` (
  `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 `final_erp_testevents`
--


--
-- Table structure for table `final_erp_testexpense_categories`
--

CREATE TABLE `final_erp_testexpense_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 `final_erp_testexpense_categories`
--


--
-- Table structure for table `final_erp_testexpenses`
--

CREATE TABLE `final_erp_testexpenses` (
  `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 `final_erp_testexpenses`
--


--
-- Table structure for table `final_erp_testgeneral_files`
--

CREATE TABLE `final_erp_testgeneral_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 `final_erp_testgeneral_files`
--


--
-- Table structure for table `final_erp_testhelp_articles`
--

CREATE TABLE `final_erp_testhelp_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 `final_erp_testhelp_articles`
--


--
-- Table structure for table `final_erp_testhelp_categories`
--

CREATE TABLE `final_erp_testhelp_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 `final_erp_testhelp_categories`
--


--
-- Table structure for table `final_erp_testinternal_transactions`
--

CREATE TABLE `final_erp_testinternal_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 `final_erp_testinternal_transactions`
--


--
-- Table structure for table `final_erp_testinvoice_items`
--

CREATE TABLE `final_erp_testinvoice_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 `final_erp_testinvoice_items`
--


--
-- Table structure for table `final_erp_testinvoice_payments`
--

CREATE TABLE `final_erp_testinvoice_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 `final_erp_testinvoice_payments`
--


--
-- Table structure for table `final_erp_testinvoices`
--

CREATE TABLE `final_erp_testinvoices` (
  `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 `final_erp_testinvoices`
--


--
-- Table structure for table `final_erp_testitem_categories`
--

CREATE TABLE `final_erp_testitem_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 `final_erp_testitem_categories`
--


--
-- Table structure for table `final_erp_testitems`
--

CREATE TABLE `final_erp_testitems` (
  `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 `final_erp_testitems`
--


--
-- Table structure for table `final_erp_testlead_source`
--

CREATE TABLE `final_erp_testlead_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 `final_erp_testlead_source`
--

INSERT INTO `final_erp_testlead_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 `final_erp_testlead_status`
--

CREATE TABLE `final_erp_testlead_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 `final_erp_testlead_status`
--

INSERT INTO `final_erp_testlead_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 `final_erp_testleads`
--

CREATE TABLE `final_erp_testleads` (
  `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 `final_erp_testleads`
--


--
-- Table structure for table `final_erp_testleave_applications`
--

CREATE TABLE `final_erp_testleave_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 `final_erp_testleave_applications`
--


--
-- Table structure for table `final_erp_testleave_types`
--

CREATE TABLE `final_erp_testleave_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 `final_erp_testleave_types`
--

INSERT INTO `final_erp_testleave_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 `final_erp_testloans`
--

CREATE TABLE `final_erp_testloans` (
  `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 `final_erp_testloans`
--


--
-- Table structure for table `final_erp_testmessages`
--

CREATE TABLE `final_erp_testmessages` (
  `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 `final_erp_testmessages`
--


--
-- Table structure for table `final_erp_testmilestones`
--

CREATE TABLE `final_erp_testmilestones` (
  `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 `final_erp_testmilestones`
--


--
-- Table structure for table `final_erp_testnotes`
--

CREATE TABLE `final_erp_testnotes` (
  `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 `final_erp_testnotes`
--


--
-- Table structure for table `final_erp_testnotification_settings`
--

CREATE TABLE `final_erp_testnotification_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 `final_erp_testnotification_settings`
--

INSERT INTO `final_erp_testnotification_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 `final_erp_testnotifications`
--

CREATE TABLE `final_erp_testnotifications` (
  `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 `final_erp_testnotifications`
--


--
-- Table structure for table `final_erp_testpayment_methods`
--

CREATE TABLE `final_erp_testpayment_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 `final_erp_testpayment_methods`
--

INSERT INTO `final_erp_testpayment_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 `final_erp_testpaypal_ipn`
--

CREATE TABLE `final_erp_testpaypal_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 `final_erp_testpaypal_ipn`
--


--
-- Table structure for table `final_erp_testpayroll`
--

CREATE TABLE `final_erp_testpayroll` (
  `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 `final_erp_testpayroll`
--


--
-- Table structure for table `final_erp_testpayroll_detail`
--

CREATE TABLE `final_erp_testpayroll_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 `final_erp_testpayroll_detail`
--


--
-- Table structure for table `final_erp_testposts`
--

CREATE TABLE `final_erp_testposts` (
  `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 `final_erp_testposts`
--


--
-- Table structure for table `final_erp_testproject_comments`
--

CREATE TABLE `final_erp_testproject_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 `final_erp_testproject_comments`
--


--
-- Table structure for table `final_erp_testproject_files`
--

CREATE TABLE `final_erp_testproject_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 `final_erp_testproject_files`
--


--
-- Table structure for table `final_erp_testproject_members`
--

CREATE TABLE `final_erp_testproject_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 `final_erp_testproject_members`
--


--
-- Table structure for table `final_erp_testproject_settings`
--

CREATE TABLE `final_erp_testproject_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 `final_erp_testproject_settings`
--


--
-- Table structure for table `final_erp_testproject_time`
--

CREATE TABLE `final_erp_testproject_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 `final_erp_testproject_time`
--


--
-- Table structure for table `final_erp_testprojects`
--

CREATE TABLE `final_erp_testprojects` (
  `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 `final_erp_testprojects`
--


--
-- Table structure for table `final_erp_testpurchase_order_items`
--

CREATE TABLE `final_erp_testpurchase_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 `final_erp_testpurchase_order_items`
--


--
-- Table structure for table `final_erp_testpurchase_order_payments`
--

CREATE TABLE `final_erp_testpurchase_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 `final_erp_testpurchase_order_payments`
--


--
-- Table structure for table `final_erp_testpurchase_orders`
--

CREATE TABLE `final_erp_testpurchase_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 `final_erp_testpurchase_orders`
--


--
-- Table structure for table `final_erp_testpurchase_return_items`
--

CREATE TABLE `final_erp_testpurchase_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 `final_erp_testpurchase_return_items`
--


--
-- Table structure for table `final_erp_testpurchase_returns`
--

CREATE TABLE `final_erp_testpurchase_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 `final_erp_testpurchase_returns`
--


--
-- Table structure for table `final_erp_testroles`
--

CREATE TABLE `final_erp_testroles` (
  `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 `final_erp_testroles`
--


--
-- Table structure for table `final_erp_testsalary_advance`
--

CREATE TABLE `final_erp_testsalary_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 `final_erp_testsalary_advance`
--


--
-- Table structure for table `final_erp_testsale_return_items`
--

CREATE TABLE `final_erp_testsale_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 `final_erp_testsale_return_items`
--


--
-- Table structure for table `final_erp_testsale_returns`
--

CREATE TABLE `final_erp_testsale_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 `final_erp_testsale_returns`
--


--
-- Table structure for table `final_erp_testsettings`
--

CREATE TABLE `final_erp_testsettings` (
  `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 `final_erp_testsettings`
--

INSERT INTO `final_erp_testsettings` 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 `final_erp_testshipment_items`
--

CREATE TABLE `final_erp_testshipment_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 `final_erp_testshipment_items`
--


--
-- Table structure for table `final_erp_testshipments`
--

CREATE TABLE `final_erp_testshipments` (
  `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 `final_erp_testshipments`
--


--
-- Table structure for table `final_erp_testsocial_links`
--

CREATE TABLE `final_erp_testsocial_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 `final_erp_testsocial_links`
--


--
-- Table structure for table `final_erp_teststock_adjustments`
--

CREATE TABLE `final_erp_teststock_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 `final_erp_teststock_adjustments`
--


--
-- Table structure for table `final_erp_testsuppliers`
--

CREATE TABLE `final_erp_testsuppliers` (
  `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 `final_erp_testsuppliers`
--


--
-- Table structure for table `final_erp_testtask_status`
--

CREATE TABLE `final_erp_testtask_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 `final_erp_testtask_status`
--

INSERT INTO `final_erp_testtask_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 `final_erp_testtasks`
--

CREATE TABLE `final_erp_testtasks` (
  `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 `final_erp_testtasks`
--


--
-- Table structure for table `final_erp_testtaxes`
--

CREATE TABLE `final_erp_testtaxes` (
  `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 `final_erp_testtaxes`
--

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

--
-- Table structure for table `final_erp_testteam`
--

CREATE TABLE `final_erp_testteam` (
  `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 `final_erp_testteam`
--


--
-- Table structure for table `final_erp_testteam_member_job_info`
--

CREATE TABLE `final_erp_testteam_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 `final_erp_testteam_member_job_info`
--


--
-- Table structure for table `final_erp_testticket_comments`
--

CREATE TABLE `final_erp_testticket_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 `final_erp_testticket_comments`
--


--
-- Table structure for table `final_erp_testticket_types`
--

CREATE TABLE `final_erp_testticket_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 `final_erp_testticket_types`
--

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

--
-- Table structure for table `final_erp_testtickets`
--

CREATE TABLE `final_erp_testtickets` (
  `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 `final_erp_testtickets`
--


--
-- Table structure for table `final_erp_testto_do`
--

CREATE TABLE `final_erp_testto_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 `final_erp_testto_do`
--


--
-- Table structure for table `final_erp_testtransactions`
--

CREATE TABLE `final_erp_testtransactions` (
  `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 `final_erp_testtransactions`
--


--
-- Table structure for table `final_erp_testusers`
--

CREATE TABLE `final_erp_testusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `superior_id` int(11) DEFAULT '-1',
  `user_type` enum('staff','client','lead') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'client',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `message_checked_at` datetime DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT '0',
  `notification_checked_at` datetime DEFAULT NULL,
  `is_primary_contact` tinyint(1) NOT NULL DEFAULT '0',
  `job_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Untitled',
  `disable_login` tinyint(1) NOT NULL DEFAULT '0',
  `note` mediumtext COLLATE utf8_unicode_ci,
  `address` text COLLATE utf8_unicode_ci,
  `alternative_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,
  `dob` date DEFAULT NULL,
  `ssn` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gender` enum('male','female') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'male',
  `sticky_note` mediumtext COLLATE utf8_unicode_ci,
  `external_links` mediumtext COLLATE utf8_unicode_ci,
  `skype` text COLLATE utf8_unicode_ci,
  `enable_web_notification` tinyint(1) NOT NULL DEFAULT '1',
  `enable_email_notification` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `last_online` datetime DEFAULT NULL,
  `pt_account_id` int(11) NOT NULL DEFAULT '0',
  `sal_account_id` int(11) NOT NULL DEFAULT '0',
  `imb_account_id` int(11) NOT NULL DEFAULT '0',
  `resident_card_no` text COLLATE utf8_unicode_ci,
  `resident_card_expiry` date DEFAULT NULL,
  `passport_no` text COLLATE utf8_unicode_ci,
  `passport_expiry` date DEFAULT NULL,
  `requested_account_removal` tinyint(1) DEFAULT '0',
  `payroll` tinyint(1) DEFAULT '1',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_type` (`user_type`),
  KEY `email` (`email`),
  KEY `client_id` (`client_id`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `final_erp_testusers`
--

INSERT INTO `final_erp_testusers` VALUES (1,'Admin','Admin',-1,'staff',1,0,'test2@test.com','e10adc3949ba59abbe56e057f20f883e','','active','2021-10-01 19:15:29',0,'2021-06-16 07:37:08',0,'Admin',0,NULL,'','','','','2022-05-18','','male','',NULL,'',1,1,'2022-05-18 10:28:49','2022-05-18 10:32:23',80,81,82,NULL,NULL,NULL,NULL,0,1,0);

--
-- Table structure for table `general_files`
--

CREATE TABLE `general_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 `general_files`
--


--
-- Table structure for table `help_articles`
--

CREATE TABLE `help_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 `help_articles`
--


--
-- Table structure for table `help_categories`
--

CREATE TABLE `help_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 `help_categories`
--


--
-- Table structure for table `ikomanaccounts`
--

CREATE TABLE `ikomanaccounts` (
  `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 `ikomanaccounts`
--

INSERT INTO `ikomanaccounts` VALUES (1,'Assets','1',0,1,0,NULL,0,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 `ikomanactivity_logs`
--

CREATE TABLE `ikomanactivity_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 `ikomanactivity_logs`
--


--
-- Table structure for table `ikomanannouncements`
--

CREATE TABLE `ikomanannouncements` (
  `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 `ikomanannouncements`
--


--
-- Table structure for table `ikomanattendance`
--

CREATE TABLE `ikomanattendance` (
  `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 `ikomanattendance`
--


--
-- Table structure for table `ikomanchecklist_items`
--

CREATE TABLE `ikomanchecklist_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 `ikomanchecklist_items`
--


--
-- Table structure for table `ikomanci_sessions`
--

CREATE TABLE `ikomanci_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 `ikomanci_sessions`
--

INSERT INTO `ikomanci_sessions` VALUES ('3fee7887fba15c3ab749d9ca5b0ad4993501a6bd','5.36.77.210',1634105248,_binary '__ci_last_regenerate|i:1634105206;user_id|s:1:\"1\";'),('f54859547076a216db1c4235e21773ee1ab4f22e','5.36.77.210',1634105241,_binary '__ci_last_regenerate|i:1634105240;'),('5999c24c12ba5783c14508e8987dd7631ff36da9','5.36.77.210',1634105242,_binary '__ci_last_regenerate|i:1634105242;'),('e790ad28b3f55cfcd7e0a033bb085b3e762a1a24','5.36.77.210',1634105244,_binary '__ci_last_regenerate|i:1634105244;'),('9888898c09b7806255c5d9e8d6c78b0599b503a1','5.36.77.210',1634105245,_binary '__ci_last_regenerate|i:1634105245;'),('4c71f85dc6aa7166542bf0b0dc4fb05a264973d7','5.36.77.210',1634105247,_binary '__ci_last_regenerate|i:1634105247;'),('409c3ca9b007c62f410b35087971cb44ac59494c','5.36.77.210',1634105248,_binary '__ci_last_regenerate|i:1634105248;'),('6ee18f38af83f90ab7068c169ac6ede48a046a27','5.36.77.210',1634105252,_binary '__ci_last_regenerate|i:1634105249;'),('0cdfff1760c0b2a3751470a964e08dc3a2dcea09','161.8.109.180',1634105799,_binary '__ci_last_regenerate|i:1634105798;user_id|s:1:\"1\";'),('fcec92b1bd23aa8900c59eb7c28002996e95963b','161.8.109.180',1634105811,_binary '__ci_last_regenerate|i:1634105798;user_id|s:1:\"1\";'),('5da2b8701e06bb15e2d3d275ad55c5de4742a327','5.36.77.210',1634118509,_binary '__ci_last_regenerate|i:1634118509;user_id|s:1:\"1\";'),('de36840a5d987711529042ac0e72452da19bd4ff','5.36.77.210',1634118508,_binary '__ci_last_regenerate|i:1634118226;user_id|s:1:\"1\";'),('f9e83d6758b8ef3a38bc6f1ee5f3c10ec3fc859c','5.36.77.210',1634118516,_binary '__ci_last_regenerate|i:1634118509;user_id|s:1:\"1\";'),('47feabc28d1cfc431f9f9ff18ca81e65d0f5c8f3','5.36.77.210',1634118847,_binary '__ci_last_regenerate|i:1634118847;user_id|s:1:\"1\";'),('876e1573362dc33de483b0897fb7a86faead4dcc','5.36.77.210',1634119240,_binary '__ci_last_regenerate|i:1634119240;user_id|s:1:\"1\";'),('4164ad9a684b6c349ce432b7d4ed6d424cfd6875','5.36.77.210',1634119787,_binary '__ci_last_regenerate|i:1634119240;user_id|s:1:\"1\";'),('9e0c39fae1708e2c5315b48cb15420cceb3ce166','89.187.174.75',1634202757,_binary '__ci_last_regenerate|i:1634202757;'),('a60cb722a6d72f73a17ba746f321d0bb6cd7d3ec','89.187.174.75',1634202758,_binary '__ci_last_regenerate|i:1634202758;'),('bdbae0318b7aec736a0a75082e77c78b3a65c803','161.8.109.180',1634204237,_binary '__ci_last_regenerate|i:1634203035;user_id|s:1:\"1\";'),('fc11a8218b1602801d8baa34d98bc26a67f4c79e','161.8.118.29',1634203260,_binary '__ci_last_regenerate|i:1634203235;'),('2630c1f5ae22fd5760bd7fe37736bd8bd5487e9a','161.8.109.180',1634204285,''),('990fd2d4c6bc5f2bb65eb8d5a6e21cf907123e13','161.8.121.85',1634289511,_binary '__ci_last_regenerate|i:1634289505;'),('6b40d374dc617119e528f6fa976103dc567b63ed','161.8.121.85',1634290022,_binary '__ci_last_regenerate|i:1634290022;user_id|s:1:\"1\";'),('cd522f75d0985c3199f5a55d39896f943aa4a1e7','161.8.121.85',1634290470,_binary '__ci_last_regenerate|i:1634290470;user_id|s:1:\"1\";'),('f6bded22d6913dfefbb2b0964e3738ff89d29ccd','161.8.121.85',1634290784,_binary '__ci_last_regenerate|i:1634290784;user_id|s:1:\"1\";'),('93d1517f476dbefdd71e658cfeca4cd178fef849','161.8.121.85',1634291194,_binary '__ci_last_regenerate|i:1634291194;user_id|s:1:\"1\";'),('ed5e1ed4a1c0ef9e80dc7b19778bdbc238f5883d','161.8.121.85',1634291872,_binary '__ci_last_regenerate|i:1634291872;user_id|s:1:\"1\";'),('5d21fd98b52dfa00d841ab57f952916ba8e9f5d8','161.8.121.85',1634292239,_binary '__ci_last_regenerate|i:1634292238;user_id|s:1:\"1\";'),('2bac720d992017647317670546f11a6b3ec703e3','161.8.121.85',1634292556,_binary '__ci_last_regenerate|i:1634292556;user_id|s:1:\"1\";'),('2653da4c22a2e71e64b6195cbd783a49560f4e09','161.8.121.85',1634292695,_binary '__ci_last_regenerate|i:1634292556;user_id|s:1:\"1\";'),('ef13c3d0106dd75d6a3d7ec7feb6504456613946','161.8.121.85',1634292694,_binary '__ci_last_regenerate|i:1634292694;'),('a6c25329f1d2f98a52b158dc38b717e5ff2abe06','161.8.121.85',1634292694,_binary '__ci_last_regenerate|i:1634292694;'),('c7c43d5e84f884b4c4ff815954107e514499242c','161.8.121.85',1634292701,_binary '__ci_last_regenerate|i:1634292701;'),('5580f364728b1b8431eaca0c89218412aa420514','161.8.121.85',1634292702,_binary '__ci_last_regenerate|i:1634292702;'),('c25758f3fe20cf01043ca5dcae742debd1cdf1f8','161.8.109.180',1634394616,_binary '__ci_last_regenerate|i:1634382444;user_id|s:1:\"1\";'),('d10c59734c4ae3d8ec9a44636302ed9cf36d034b','161.8.109.180',1634447602,''),('343a39e4341b14c2a8ad12a1b6af360978a4e98f','161.8.109.180',1634447602,''),('da948bff93e28de96784379f939164a19072204e','85.154.185.226',1634525053,_binary '__ci_last_regenerate|i:1634525037;'),('5340019065ffc93261909460ff9b998751613389','5.37.196.127',1635760725,_binary '__ci_last_regenerate|i:1635760721;'),('a18dc68691d0c9d8d8d67df30482c1f6ce31fdff','82.178.243.118',1636445629,_binary '__ci_last_regenerate|i:1636445591;'),('6a6296dadccc17a4acb2b6e2ab55a872c9d404b1','82.178.242.211',1638462531,_binary '__ci_last_regenerate|i:1638462457;'),('b4948e8b26b3a110eaec47a9fab6a05342467bcc','82.178.84.77',1638588297,_binary '__ci_last_regenerate|i:1638588293;'),('5961ae54408710a9a275decfbee28f4646a3b27a','5.36.99.40',1639481002,_binary '__ci_last_regenerate|i:1639480999;'),('f77df2a33ae38232ffb0c93aa721668a9899f168','85.154.60.193',1639837766,_binary '__ci_last_regenerate|i:1639837764;'),('da5b0a8d9ef4e49c55252be573dda1c2bf6c8ed8','5.36.113.186',1639993468,_binary '__ci_last_regenerate|i:1639993466;'),('1abe769ff8020456924699a9b7c5094657e737ab','188.135.84.186',1640276804,_binary '__ci_last_regenerate|i:1640276804;'),('399f98f1b165a131bf29d723a03c9f843e2663d0','188.135.84.186',1640282920,_binary '__ci_last_regenerate|i:1640282920;'),('9a6ed5dff3fd46a512319d47b96c60edec8648dd','85.154.182.220',1640282921,_binary '__ci_last_regenerate|i:1640282920;'),('eb2bbb754dd3ca611e9926d3a5ac00a29ecabb1a','197.252.217.248',1641454555,_binary '__ci_last_regenerate|i:1641454555;user_id|s:1:\"1\";'),('aa759ad655ca44d281d984d382def8a9fdb945e8','197.252.217.248',1641454940,_binary '__ci_last_regenerate|i:1641454940;user_id|s:1:\"1\";'),('a1a16b16292d118f7d0ab66ebf0a9f3d4a02adbc','197.252.217.248',1641455029,''),('f6be367d13977fd4413cf7e84ebf51c25581416c','197.252.217.248',1641455030,_binary '__ci_last_regenerate|i:1641455029;'),('627b7a19ba036c50273c8f027106ca2eed7c6589','197.252.217.248',1641455300,_binary '__ci_last_regenerate|i:1641455045;user_id|s:1:\"1\";'),('f569114eaeae9faa05595c545b03f6c8451e673d','197.252.219.136',1641672756,_binary '__ci_last_regenerate|i:1641672756;'),('cf19ad8cb179a878d71476aee79f966da23fd1f4','197.252.219.136',1641677406,_binary '__ci_last_regenerate|i:1641677406;'),('d159961ca23ca3471d3ceefa8a8e9f56581c8ce0','197.252.219.136',1641677935,_binary '__ci_last_regenerate|i:1641677935;user_id|s:1:\"1\";'),('515cea4efb4e6fa8eeba4dc55a0dc68a495fa751','197.252.219.136',1641678581,_binary '__ci_last_regenerate|i:1641678581;user_id|s:1:\"1\";'),('fdd244c4cdbbb56e4a37c900308f3f9aa7104da0','197.252.219.136',1641683808,_binary '__ci_last_regenerate|i:1641678581;user_id|s:1:\"1\";'),('1b88f4c9d7e3b9cc82398c4e53f3c79cec4f4bb5','197.252.219.136',1641683871,''),('241d3d978feb3ebfb2e58e40f89eccbedc9e47cc','197.252.219.136',1641685381,_binary '__ci_last_regenerate|i:1641684871;user_id|s:1:\"1\";'),('3eb9202e3096203611a6cf99c0d0ca6cd5d5f335','197.252.219.136',1641685716,_binary '__ci_last_regenerate|i:1641685648;user_id|s:1:\"1\";'),('42102454784a38af17f1f625f7b23a02f2748494','197.252.219.136',1641685758,_binary '__ci_last_regenerate|i:1641685727;user_id|s:1:\"1\";'),('25bf18e6217e80d75f372359e4d36c5929df23df','197.252.219.136',1641686498,_binary '__ci_last_regenerate|i:1641686099;user_id|s:1:\"1\";'),('49febf8548988d7f7928553fceb95ac31f0b12b1','197.252.219.136',1641686965,_binary '__ci_last_regenerate|i:1641686852;user_id|s:1:\"1\";'),('c828bf643b11e2a6434a670bf58a1e39c7f2661f','197.252.219.136',1641687370,_binary '__ci_last_regenerate|i:1641687335;user_id|s:1:\"1\";'),('55c3d6ac60eff71d7c964070a95fed2210f3a32e','197.252.219.136',1641688416,_binary '__ci_last_regenerate|i:1641688416;user_id|s:1:\"1\";'),('ffaeb0c799e340f13037ce78d72a827b2982140c','197.252.219.136',1641687697,_binary '__ci_last_regenerate|i:1641687697;'),('6227157b4fc88d9b9882e8e9171574dbd772a00a','197.252.219.136',1641687699,_binary '__ci_last_regenerate|i:1641687698;user_id|s:1:\"1\";'),('ec6236c67ba39335b81497da3b72029bece13432','197.252.219.136',1641689022,_binary '__ci_last_regenerate|i:1641689022;user_id|s:1:\"1\";'),('28dd4f67c864d731071c74482339f8e5247dc9c2','197.252.219.136',1641689984,_binary '__ci_last_regenerate|i:1641689648;user_id|s:1:\"1\";'),('0eaa4c34c289f66e2858301f7aadde7533f927e6','197.252.219.136',1641689649,_binary '__ci_last_regenerate|i:1641689648;user_id|s:1:\"1\";'),('c1f20b325a2cca15c9a2304c8487a98118839450','197.252.219.136',1641690716,_binary '__ci_last_regenerate|i:1641690716;user_id|s:1:\"1\";'),('a56a6b88d043ee4b82e1bdf5d81a8f6d73380726','197.252.219.136',1641691192,_binary '__ci_last_regenerate|i:1641691192;user_id|s:1:\"1\";'),('16bd957b1e6ddc832d589eaadde2f3c673125fe9','197.252.219.136',1641691743,_binary '__ci_last_regenerate|i:1641691192;user_id|s:1:\"1\";'),('54be265983f53b3aa726ed432491697243c90385','197.252.219.136',1641691764,''),('d46c70b469039381338271bbd73394dd042a0169','197.252.219.136',1641692770,_binary '__ci_last_regenerate|i:1641692768;'),('f5de1b57a305d4d77a389c713549431adfbcd7b6','195.181.161.3',1644734636,_binary '__ci_last_regenerate|i:1644734632;'),('6aed3b14c4f6f9b48fbf6f26de4e3f4715e87608','161.8.72.129',1646374730,_binary '__ci_last_regenerate|i:1646374730;'),('15b616a1ed65d167cd1ba9f8056dfaa8a9d351e6','161.8.72.129',1646374326,_binary '__ci_last_regenerate|i:1646374245;'),('e376e15377565e52b275c42bddbc9dc2fe92f18f','161.8.72.129',1646374833,_binary '__ci_last_regenerate|i:1646374730;'),('3ebfb040778ec75993ebc7431dbccf779f944f74','5.162.196.53',1646379532,_binary '__ci_last_regenerate|i:1646379499;'),('63a0093c5d02d0c0d60c8939bf2860513631125e','37.40.143.57',1646384806,_binary '__ci_last_regenerate|i:1646384802;'),('3f68e7d18bf35e345656e6fe76602fe078a033e7','37.40.143.57',1646384820,_binary '__ci_last_regenerate|i:1646384820;'),('c369ec162424ede668fccb3172a5e1aeba6f174f','37.40.143.57',1646384987,_binary '__ci_last_regenerate|i:1646384854;'),('1435826e04ec0bf87fd76cda978bc38d5b950a9b','37.41.19.237',1646426392,_binary '__ci_last_regenerate|i:1646426325;'),('0982903ddc22268c31fa7c39991c4e335dc21716','37.41.142.128',1646629122,_binary '__ci_last_regenerate|i:1646628982;'),('fca20791259fc227574a0cc1899fa30685832864','197.252.202.161',1647415103,_binary '__ci_last_regenerate|i:1647415103;user_id|s:1:\"1\";'),('1b35a56c1255049c29fae24e908c4160f4abe844','197.252.202.161',1647417706,_binary '__ci_last_regenerate|i:1647417706;user_id|s:1:\"1\";'),('687861a8ed5dff77a53803447ba883c7f3018338','197.252.202.161',1647418066,_binary '__ci_last_regenerate|i:1647418066;user_id|s:1:\"1\";'),('b8b87b34087bbd22b911118dd44c22fe52772d3d','197.252.202.161',1647418439,_binary '__ci_last_regenerate|i:1647418066;user_id|s:1:\"1\";'),('a49a20b117e9aaf9602c851b162426387649e5a1','197.252.202.161',1647418911,_binary '__ci_last_regenerate|i:1647418650;user_id|s:1:\"1\";'),('87d21d8f5b85571a34df0a888021048b1e722903','197.252.202.161',1647418965,''),('fa8283f19ccdddfafc21278346b5de2f99629180','197.252.202.134',1647771314,_binary '__ci_last_regenerate|i:1647771310;'),('0ef14d7642988066c3e1bec825a8a6d3f89fc363','89.147.129.2',1650985928,_binary '__ci_last_regenerate|i:1650985924;'),('819882ea74b854d2d3bd2fc17e7795b1ace4d8ef','37.40.99.197',1651214990,_binary '__ci_last_regenerate|i:1651214990;'),('70cf01e83dde6ebec55531f4fc50b2944a199100','37.40.99.197',1651214683,_binary '__ci_last_regenerate|i:1651214673;'),('0e09ac77771b54abec6427121869c3add45359b8','37.40.99.197',1651214996,_binary '__ci_last_regenerate|i:1651214990;');

--
