-- Table structure for table `United_Petroleum_Industriesnotifications`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesnotifications`
--

INSERT INTO `United_Petroleum_Industriesnotifications` VALUES (1,1,'','2022-07-17 09:22:44','39','','leave_approved',0,0,0,0,0,0,1,0,39,0,0,0,0,0,0,0,0,0,0,0,0),(2,1,'','2022-07-27 06:59:19','','','project_created',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(3,1,'','2022-07-27 07:00:02','','','project_deleted',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(4,36,'','2022-08-09 09:34:47','42',',42','leave_approved',0,0,0,0,0,0,13,0,42,0,0,0,0,0,0,0,0,0,0,0,0),(5,36,'','2022-08-15 06:56:28','','','project_created',2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(6,36,'','2022-08-15 06:56:58','','','project_deleted',2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(7,36,'','2022-08-15 07:01:31','1',',1','project_task_created',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(8,1,'','2022-08-15 07:02:09','','','project_task_created',1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(9,1,'','2022-08-15 07:02:52','',',37,36,1','project_task_commented',1,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(10,36,'','2022-08-15 07:04:50','1','','project_task_created',1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(11,37,'','2022-08-15 07:50:59','36','','project_task_updated',1,3,0,0,0,0,0,0,0,1293,0,0,0,0,0,0,0,0,0,0,0),(12,37,'','2022-08-15 07:51:01','36','','project_task_updated',1,3,0,0,0,0,0,0,0,1294,0,0,0,0,0,0,0,0,0,0,0),(13,37,'','2022-08-15 07:51:02','36','','project_task_updated',1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(14,36,'','2022-08-15 07:52:19','1',',1','project_task_commented',1,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(15,36,'','2022-08-15 07:52:59','',',1','project_task_commented',1,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(16,36,'','2022-08-15 07:54:15','','','project_task_updated',1,3,0,0,0,0,0,0,0,1297,0,0,0,0,0,0,0,0,0,0,0),(17,1,'','2022-08-15 07:54:15','','','project_task_commented',1,1,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(18,36,'','2022-08-15 07:54:16','1','','project_task_updated',1,2,0,0,0,0,0,0,0,1299,0,0,0,0,0,0,0,0,0,0,0),(19,36,'','2022-08-15 07:54:18','','','project_task_updated',1,1,0,0,0,0,0,0,0,1300,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `United_Petroleum_Industriespayment_methods`
--

CREATE TABLE `United_Petroleum_Industriespayment_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 `United_Petroleum_Industriespayment_methods`
--

INSERT INTO `United_Petroleum_Industriespayment_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 `United_Petroleum_Industriespaypal_ipn`
--

CREATE TABLE `United_Petroleum_Industriespaypal_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 `United_Petroleum_Industriespaypal_ipn`
--


--
-- Table structure for table `United_Petroleum_Industriespayroll`
--

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

--
-- Dumping data for table `United_Petroleum_Industriespayroll`
--

INSERT INTO `United_Petroleum_Industriespayroll` VALUES (1,'2022-09-01','draft',1),(2,'2022-06-01','draft',1),(3,'2022-07-28','draft',1),(4,'2022-08-01','draft',1),(5,'2022-08-01','draft',1);

--
-- Table structure for table `United_Petroleum_Industriespayroll_detail`
--

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

--
-- Dumping data for table `United_Petroleum_Industriespayroll_detail`
--

INSERT INTO `United_Petroleum_Industriespayroll_detail` VALUES (1,1,36,800.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(2,1,1,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(3,1,39,620.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(4,1,37,400.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(5,1,38,2000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(6,2,36,800.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(7,2,39,620.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(8,2,37,400.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(9,2,38,2000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(10,2,1,500.000,0.000,NULL,0.000,NULL,0.000,0.000,57.5,35,5,5,0),(11,2,41,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(12,2,40,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(13,3,36,800.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(14,3,39,620.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(15,3,37,400.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(16,3,38,2000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(17,3,1,500.000,0.000,NULL,0.000,NULL,0.000,0.000,57.5,35,5,5,0),(18,3,41,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(19,3,40,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(20,4,36,830.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(21,4,1,500.000,0.000,NULL,0.000,NULL,0.000,0.000,57.5,35,5,5,0),(22,4,39,620.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(23,4,37,400.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(24,4,42,300.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(25,4,38,2000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(26,4,41,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(27,4,40,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(28,5,36,830.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(29,5,1,500.000,0.000,NULL,0.000,NULL,0.000,0.000,57.5,35,5,5,0),(30,5,39,620.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(31,5,37,400.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(32,5,42,300.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(33,5,38,2000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(34,5,41,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(35,5,40,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0);

--
-- Table structure for table `United_Petroleum_Industriesposts`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesposts`
--

INSERT INTO `United_Petroleum_Industriesposts` VALUES (1,36,'2022-08-15 06:42:17','hgfgh',0,'','a:1:{i:0;a:4:{s:9:\"file_name\";s:136:\"timeline_post_file62f9eac9886e0-2022-08-14-12_39_53-Fwd_-Shale-Shaker-UPI-Part-Numbers.---Abdullah@upioman.com---United-Petroluem-In.png\";s:9:\"file_size\";s:5:\"73301\";s:7:\"file_id\";N;s:12:\"service_type\";N;}}',1);

--
-- Table structure for table `United_Petroleum_Industriesproject_comments`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesproject_comments`
--

INSERT INTO `United_Petroleum_Industriesproject_comments` VALUES (1,1,'2022-08-15 07:02:52','amd',1,0,2,0,0,'a:0:{}',0),(2,36,'2022-08-15 07:52:19','jgjlfjhbkjn.',1,0,2,0,0,'a:0:{}',0),(3,36,'2022-08-15 07:52:59','kjkjgkjbkj',1,0,1,0,0,'a:0:{}',0),(4,1,'2022-08-15 07:54:15','aaaaa',1,0,1,0,0,'a:0:{}',0);

--
-- Table structure for table `United_Petroleum_Industriesproject_files`
--

CREATE TABLE `United_Petroleum_Industriesproject_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 `United_Petroleum_Industriesproject_files`
--


--
-- Table structure for table `United_Petroleum_Industriesproject_members`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesproject_members`
--

INSERT INTO `United_Petroleum_Industriesproject_members` VALUES (1,1,1,1,0),(2,36,2,1,0);

--
-- Table structure for table `United_Petroleum_Industriesproject_settings`
--

CREATE TABLE `United_Petroleum_Industriesproject_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 `United_Petroleum_Industriesproject_settings`
--


--
-- Table structure for table `United_Petroleum_Industriesproject_time`
--

CREATE TABLE `United_Petroleum_Industriesproject_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 `United_Petroleum_Industriesproject_time`
--


--
-- Table structure for table `United_Petroleum_Industriesprojects`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesprojects`
--

INSERT INTO `United_Petroleum_Industriesprojects` VALUES (1,'d','','2022-07-28','2022-07-30',1,'2022-07-27',1,'open','',1000,'',0,NULL,1),(2,'new workshope','ljkj','2022-08-16','2022-08-19',1,'2022-08-15',36,'open','',9,'',0,NULL,1);

--
-- Table structure for table `United_Petroleum_Industriespurchase_order_items`
--

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

--
-- Dumping data for table `United_Petroleum_Industriespurchase_order_items`
--

INSERT INTO `United_Petroleum_Industriespurchase_order_items` VALUES (1,9,'UPI Shaker Screen for Derrick-500 Pyramid API120','-',20,'PCS',35,700,0,1,1,0,0);

--
-- Table structure for table `United_Petroleum_Industriespurchase_order_payments`
--

CREATE TABLE `United_Petroleum_Industriespurchase_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 `United_Petroleum_Industriespurchase_order_payments`
--


--
-- Table structure for table `United_Petroleum_Industriespurchase_orders`
--

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

--
-- Dumping data for table `United_Petroleum_Industriespurchase_orders`
--

INSERT INTO `United_Petroleum_Industriespurchase_orders` VALUES (1,1,'2022-08-15',0,'','-','draft','not_approved',1),(2,21,'2022-10-18',0,'','','draft','not_approved',1);

--
-- Table structure for table `United_Petroleum_Industriespurchase_return_items`
--

CREATE TABLE `United_Petroleum_Industriespurchase_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 `United_Petroleum_Industriespurchase_return_items`
--


--
-- Table structure for table `United_Petroleum_Industriespurchase_returns`
--

CREATE TABLE `United_Petroleum_Industriespurchase_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 `United_Petroleum_Industriespurchase_returns`
--


--
-- Table structure for table `United_Petroleum_Industriesroles`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesroles`
--

INSERT INTO `United_Petroleum_Industriesroles` VALUES (1,'Accountant ','a:115:{s:5:\"leave\";s:3:\"all\";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\";s:3:\"all\";s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";s:3:\"all\";s:23:\"help_and_knowledge_base\";s:3:\"all\";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\";s:1:\"1\";s:34:\"can_view_team_members_social_links\";s:1:\"1\";s:29:\"team_member_update_permission\";s:3:\"all\";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\";s:1:\"1\";s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";s:1:\"1\";s:10:\"accounting\";s:3:\"all\";s:7:\"payroll\";s:3:\"all\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";s:25:\"can_access_delivery_notes\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";s:1:\"1\";s:25:\"can_delete_delivery_notes\";s:1:\"1\";s:31:\"delivery_note_manage_permission\";s:3:\"all\";s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";s:1:\"1\";s:18:\"can_edit_suppliers\";s:1:\"1\";s:20:\"can_delete_suppliers\";s:1:\"1\";s:26:\"supplier_manage_permission\";s:3:\"all\";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\";s:1:\"1\";s:32:\"purchase_order_manage_permission\";s:3:\"all\";s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";s:1:\"1\";s:16:\"can_delete_items\";s:1:\"1\";s:22:\"item_manage_permission\";s:3:\"all\";s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";s:1:\"1\";s:27:\"can_create_invoice_payments\";s:1:\"1\";s:25:\"can_edit_invoice_payments\";s:1:\"1\";s:27:\"can_delete_invoice_payments\";s:1:\"1\";s:34:\"can_access_purchase_order_payments\";s:1:\"1\";s:34:\"can_create_purchase_order_payments\";s:1:\"1\";s:32:\"can_edit_purchase_order_payments\";s:1:\"1\";s:34:\"can_delete_purchase_order_payments\";s:1:\"1\";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\";s:1:\"1\";s:25:\"contact_manage_permission\";s:3:\"all\";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\";s:3:\"all\";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:3:\"all\";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\";s:1:\"1\";s:26:\"estimate_manage_permission\";N;s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";s:8:\"discount\";i:0;s:8:\"expenses\";s:3:\"all\";s:9:\"estimates\";s:3:\"all\";s:8:\"invoices\";s:3:\"all\";s:16:\"invoice_payments\";s:3:\"all\";s:14:\"delivery_notes\";s:3:\"all\";s:15:\"purchase_orders\";s:3:\"all\";s:23:\"purchase_order_payments\";s:3:\"all\";s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(2,'Operation Lead','a:115:{s:5:\"leave\";s:3:\"all\";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\";s:3:\"all\";s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";s:3:\"all\";s:23:\"help_and_knowledge_base\";s:3:\"all\";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\";s:1:\"1\";s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";s:1:\"1\";s:16:\"can_delete_tasks\";s:1:\"1\";s:20:\"can_comment_on_tasks\";s:1:\"1\";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\";s:1:\"1\";s:16:\"can_delete_files\";s:1:\"1\";s:34:\"can_view_team_members_contact_info\";s:1:\"1\";s:34:\"can_view_team_members_social_links\";s:1:\"1\";s:29:\"team_member_update_permission\";s:3:\"all\";s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";s:3:\"all\";s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";s:1:\"1\";s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";s:1:\"1\";s:10:\"accounting\";s:3:\"all\";s:7:\"payroll\";s:3:\"all\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";s:25:\"can_access_delivery_notes\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";s:1:\"1\";s:25:\"can_delete_delivery_notes\";s:1:\"1\";s:31:\"delivery_note_manage_permission\";s:3:\"all\";s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";s:1:\"1\";s:18:\"can_edit_suppliers\";s:1:\"1\";s:20:\"can_delete_suppliers\";s:1:\"1\";s:26:\"supplier_manage_permission\";s:3:\"all\";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\";s:1:\"1\";s:32:\"purchase_order_manage_permission\";s:3:\"all\";s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";s:1:\"1\";s:16:\"can_delete_items\";s:1:\"1\";s:22:\"item_manage_permission\";s:3:\"all\";s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";s:1:\"1\";s:27:\"can_create_invoice_payments\";s:1:\"1\";s:25:\"can_edit_invoice_payments\";s:1:\"1\";s:27:\"can_delete_invoice_payments\";s:1:\"1\";s:34:\"can_access_purchase_order_payments\";s:1:\"1\";s:34:\"can_create_purchase_order_payments\";s:1:\"1\";s:32:\"can_edit_purchase_order_payments\";s:1:\"1\";s:34:\"can_delete_purchase_order_payments\";s:1:\"1\";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\";s:1:\"1\";s:25:\"contact_manage_permission\";s:3:\"all\";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\";s:3:\"all\";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:3:\"all\";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\";s:1:\"1\";s:26:\"estimate_manage_permission\";s:3:\"all\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";s:8:\"discount\";i:0;s:8:\"expenses\";s:3:\"all\";s:9:\"estimates\";s:3:\"all\";s:8:\"invoices\";s:3:\"all\";s:16:\"invoice_payments\";s:3:\"all\";s:14:\"delivery_notes\";s:3:\"all\";s:15:\"purchase_orders\";s:3:\"all\";s:23:\"purchase_order_payments\";s:3:\"all\";s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(3,'Operaton Engineer','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\";s:3:\"all\";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\";s:1:\"1\";s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";s:1:\"1\";s:16:\"can_delete_tasks\";s:1:\"1\";s:20:\"can_comment_on_tasks\";s:1:\"1\";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\";s:1:\"1\";s:16:\"can_delete_files\";s:1:\"1\";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\";s:3:\"all\";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\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";s:1:\"1\";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\";s:1:\"1\";s:18:\"can_edit_suppliers\";s:1:\"1\";s:20:\"can_delete_suppliers\";s:1:\"1\";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\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";s:1:\"1\";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\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:9:\"member:42\";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\";s:1:\"1\";s:25:\"contact_manage_permission\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:0:\"\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";s:8:\"discount\";i:0;s:8:\"expenses\";s:0:\"\";s:9:\"estimates\";s:0:\"\";s:8:\"invoices\";s:0:\"\";s:16:\"invoice_payments\";s:0:\"\";s:14:\"delivery_notes\";s:0:\"\";s:15:\"purchase_orders\";s:0:\"\";s:23:\"purchase_order_payments\";s:0:\"\";s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(4,'Workers Supervisor ','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\";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\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";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),(5,'Project Development Admin ','a:115:{s:5:\"leave\";s:3:\"all\";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\";s:3:\"all\";s:23:\"help_and_knowledge_base\";s:3:\"all\";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\";s:1:\"1\";s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";s:1:\"1\";s:16:\"can_delete_tasks\";s:1:\"1\";s:20:\"can_comment_on_tasks\";s:1:\"1\";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\";s:1:\"1\";s:16:\"can_delete_files\";s:1:\"1\";s:34:\"can_view_team_members_contact_info\";s:1:\"1\";s:34:\"can_view_team_members_social_links\";s:1:\"1\";s:29:\"team_member_update_permission\";s:3:\"all\";s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";s:3:\"all\";s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";s:1:\"1\";s:22:\"hide_team_members_list\";s:1:\"0\";s:28:\"can_delete_leave_application\";s:1:\"1\";s:10:\"accounting\";N;s:7:\"payroll\";s:3:\"all\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";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\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";s:0:\"\";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;}',1),(6,'General Manager ','a:115:{s:5:\"leave\";s:3:\"all\";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\";s:1:\"1\";s:16:\"can_create_tasks\";s:1:\"1\";s:14:\"can_edit_tasks\";s:1:\"1\";s:16:\"can_delete_tasks\";s:1:\"1\";s:20:\"can_comment_on_tasks\";s:1:\"1\";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\";s:1:\"1\";s:16:\"can_delete_files\";s:1:\"1\";s:34:\"can_view_team_members_contact_info\";s:1:\"1\";s:34:\"can_view_team_members_social_links\";s:1:\"1\";s:29:\"team_member_update_permission\";s:3:\"all\";s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";s:3:\"all\";s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";N;s:22:\"hide_team_members_list\";s:1:\"0\";s:28:\"can_delete_leave_application\";s:1:\"1\";s:10:\"accounting\";s:3:\"all\";s:7:\"payroll\";s:3:\"all\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";s:25:\"can_access_delivery_notes\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";s:1:\"1\";s:25:\"can_delete_delivery_notes\";s:1:\"1\";s:31:\"delivery_note_manage_permission\";s:3:\"all\";s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";s:1:\"1\";s:18:\"can_edit_suppliers\";s:1:\"1\";s:20:\"can_delete_suppliers\";s:1:\"1\";s:26:\"supplier_manage_permission\";s:3:\"all\";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\";s:1:\"1\";s:32:\"purchase_order_manage_permission\";s:3:\"all\";s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";s:1:\"1\";s:16:\"can_delete_items\";s:1:\"1\";s:22:\"item_manage_permission\";s:3:\"all\";s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";s:1:\"1\";s:27:\"can_create_invoice_payments\";s:1:\"1\";s:25:\"can_edit_invoice_payments\";s:1:\"1\";s:27:\"can_delete_invoice_payments\";s:1:\"1\";s:34:\"can_access_purchase_order_payments\";s:1:\"1\";s:34:\"can_create_purchase_order_payments\";s:1:\"1\";s:32:\"can_edit_purchase_order_payments\";s:1:\"1\";s:34:\"can_delete_purchase_order_payments\";s:1:\"1\";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\";s:1:\"1\";s:25:\"contact_manage_permission\";s:3:\"all\";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\";s:3:\"all\";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:3:\"all\";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\";s:1:\"1\";s:26:\"estimate_manage_permission\";s:3:\"all\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";N;s:8:\"discount\";i:0;s:8:\"expenses\";s:3:\"all\";s:9:\"estimates\";s:3:\"all\";s:8:\"invoices\";s:3:\"all\";s:16:\"invoice_payments\";s:3:\"all\";s:14:\"delivery_notes\";s:3:\"all\";s:15:\"purchase_orders\";s:3:\"all\";s:23:\"purchase_order_payments\";s:3:\"all\";s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0),(7,'Business Admin Trainee','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\";s:3:\"all\";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\";s:3:\"all\";s:7:\"payroll\";s:0:\"\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";s:25:\"can_access_delivery_notes\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";s:0:\"\";s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";s:1:\"1\";s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";s:0:\"\";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\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";s:0:\"\";s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";s:0:\"\";s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";s:1:\"1\";s:27:\"can_create_invoice_payments\";s:1:\"1\";s:25:\"can_edit_invoice_payments\";N;s:27:\"can_delete_invoice_payments\";N;s:34:\"can_access_purchase_order_payments\";s:1:\"1\";s:34:\"can_create_purchase_order_payments\";s:1:\"1\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";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),(8,'Project development Trainee','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\";s:3:\"all\";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\";s:3:\"all\";s:7:\"payroll\";s:0:\"\";s:5:\"eroom\";s:3:\"all\";s:4:\"logs\";s:3:\"all\";s:7:\"reports\";s:3:\"all\";s:25:\"can_access_delivery_notes\";s:1:\"1\";s:25:\"can_create_delivery_notes\";s:1:\"1\";s:23:\"can_edit_delivery_notes\";N;s:25:\"can_delete_delivery_notes\";N;s:31:\"delivery_note_manage_permission\";s:0:\"\";s:40:\"delivery_note_manage_permission_specific\";s:0:\"\";s:20:\"can_access_suppliers\";s:1:\"1\";s:20:\"can_create_suppliers\";s:1:\"1\";s:18:\"can_edit_suppliers\";N;s:20:\"can_delete_suppliers\";N;s:26:\"supplier_manage_permission\";s:0:\"\";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\";N;s:26:\"can_delete_purchase_orders\";N;s:32:\"purchase_order_manage_permission\";s:0:\"\";s:41:\"purchase_order_manage_permission_specific\";s:0:\"\";s:16:\"can_access_items\";s:1:\"1\";s:16:\"can_create_items\";s:1:\"1\";s:14:\"can_edit_items\";N;s:16:\"can_delete_items\";N;s:22:\"item_manage_permission\";s:0:\"\";s:31:\"item_manage_permission_specific\";s:0:\"\";s:19:\"can_access_expenses\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";s:1:\"1\";s:25:\"expense_manage_permission\";s:3:\"all\";s:34:\"expense_manage_permission_specific\";s:0:\"\";s:20:\"internal_transaction\";N;s:27:\"can_access_invoice_payments\";s:1:\"1\";s:27:\"can_create_invoice_payments\";s:1:\"1\";s:25:\"can_edit_invoice_payments\";s:1:\"1\";s:27:\"can_delete_invoice_payments\";s:1:\"1\";s:34:\"can_access_purchase_order_payments\";s:1:\"1\";s:34:\"can_create_purchase_order_payments\";s:1:\"1\";s:32:\"can_edit_purchase_order_payments\";s:1:\"1\";s:34:\"can_delete_purchase_order_payments\";s:1:\"1\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";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),(9,'OFFICE ADMIN','a:115:{s:5:\"leave\";s:3:\"all\";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\";s:3:\"all\";s:23:\"help_and_knowledge_base\";s:3:\"all\";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\";s:1:\"1\";s:34:\"can_view_team_members_social_links\";s:1:\"1\";s:29:\"team_member_update_permission\";s:3:\"all\";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\";s:1:\"1\";s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";s:1:\"1\";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\";s:1:\"1\";s:19:\"can_create_expenses\";s:1:\"1\";s:17:\"can_edit_expenses\";s:1:\"1\";s:19:\"can_delete_expenses\";N;s:25:\"expense_manage_permission\";s:0:\"\";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);

--
-- Table structure for table `United_Petroleum_Industriessalary_advance`
--

CREATE TABLE `United_Petroleum_Industriessalary_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 `United_Petroleum_Industriessalary_advance`
--


--
-- Table structure for table `United_Petroleum_Industriessale_return_items`
--

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

--
-- Dumping data for table `United_Petroleum_Industriessale_return_items`
--

INSERT INTO `United_Petroleum_Industriessale_return_items` VALUES (1,1,90,2,15,0,0),(2,1,30,3,12,0,0),(3,1,34,4,15,0,0),(4,1,37,5,15,0,0);

--
-- Table structure for table `United_Petroleum_Industriessale_returns`
--

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

--
-- Dumping data for table `United_Petroleum_Industriessale_returns`
--

INSERT INTO `United_Petroleum_Industriessale_returns` VALUES (1,7,1,4,0,'2022-08-07','draft','',1);

--
-- Table structure for table `United_Petroleum_Industriessettings`
--

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

INSERT INTO `United_Petroleum_Industriessettings` 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','Muscat/ Oman','app',0),('company_email','info@upioman.com','app',0),('company_name','United Petroleum Industries ','app',0),('company_phone','+968 7934 7920 - +968 7934 7943','app',0),('company_vat_number','OM1100019319','app',0),('company_website','https://upioman.com','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','30','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','0001','app',0),('initial_number_of_the_invoice','22022','app',0),('invoice_color','#054d7f ','app',0),('invoice_footer','<p align=\"center\" dir=\"RTL\" style=\"caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34); text-align: center; direction: rtl; unicode-bidi: embed; margin: 0in; font-size: 8pt; font-family: Segoe, sans-serif;\"><span lang=\"AR-OM\" style=\"font-size: 9pt; font-family: &quot;Times New Roman&quot;, serif;\">ص. ب : 619, الخويـر الرمز البـريدي 133, مـسـقـط, سـلـطنة عـمان, تـلـفون :&nbsp;</span><span dir=\"LTR\"></span><span dir=\"LTR\"></span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\"><span dir=\"LTR\"></span><span dir=\"LTR\"></span>+ 968 24502986</span><span lang=\"AR-OM\" style=\"font-size: 9pt; font-family: &quot;Times New Roman&quot;, serif;\">فاكس</span><span dir=\"LTR\"></span><span dir=\"LTR\"></span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\"><span dir=\"LTR\"></span><span dir=\"LTR\"></span>+968 24502379</span><span dir=\"RTL\"></span><span dir=\"RTL\"></span><span lang=\"AR-OM\" style=\"font-size: 9pt; font-family: &quot;Times New Roman&quot;, serif;\"><span dir=\"RTL\"></span><span dir=\"RTL\"></span>&nbsp;س. ت.&nbsp;</span><span dir=\"LTR\"></span><span dir=\"LTR\"></span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\"><span dir=\"LTR\"></span><span dir=\"LTR\"></span>1235490</span><span lang=\"AR-OM\" style=\"font-size: 9pt; font-family: &quot;Times New Roman&quot;, serif;\"></span></p><p align=\"center\" dir=\"RTL\" style=\"caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34); text-align: center; direction: rtl; unicode-bidi: embed; margin: 0in; font-size: 8pt; font-family: Segoe, sans-serif;\"><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\">P</span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\">.O.Box 619, Al-Khuwair P.C.:133, Muscat, Sultanate Of Oman Tel.: + 968 24502379&nbsp;</span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\">Fax: 24502986</span><span dir=\"LTR\" style=\"font-size: 9pt; font-family: Arial, sans-serif;\"><a href=\"http://c.r.no/\" target=\"_blank\" data-saferedirecturl=\"https://www.google.com/url?q=http://C.R.No&amp;source=gmail&amp;ust=1658124448475000&amp;usg=AOvVaw2OAyySks8y1OSmFZn48LZd\" style=\"color: rgb(17, 85, 204);\">C.R.No</a>&nbsp;1235490</span></p><div class=\"yj6qo ajU\" style=\"cursor: pointer; outline: none; padding: 10px 0px; width: 22px; margin: 2px 0px 0px; caret-color: rgb(34, 34, 34); color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif;\"><br></div>','app',0),('invoice_logo','a:1:{s:9:\"file_name\";s:35:\"_file62d3a79fdb23a-invoice-logo.png\";}','app',0),('invoice_prefix','UPI -AB-','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_36_dashboard','','user',0),('user_36_personal_language','english','user',0),('user_37_dashboard','','user',0),('user_38_dashboard','','user',0),('user_39_dashboard','','user',0),('user_39_personal_language','arabic','user',0),('user_4_dashboard','','user',0),('user_40_dashboard','','user',0),('user_41_dashboard','','user',0),('user_42_dashboard','','user',0),('user_42_personal_language','english','user',0),('user_43_dashboard','','user',0),('user_44_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 `United_Petroleum_Industriesshipment_items`
--

CREATE TABLE `United_Petroleum_Industriesshipment_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 `United_Petroleum_Industriesshipment_items`
--


--
-- Table structure for table `United_Petroleum_Industriesshipments`
--

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


--
-- Table structure for table `United_Petroleum_Industriessocial_links`
--

CREATE TABLE `United_Petroleum_Industriessocial_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 `United_Petroleum_Industriessocial_links`
--


--
-- Table structure for table `United_Petroleum_Industriesstock_adjustments`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesstock_adjustments`
--

INSERT INTO `United_Petroleum_Industriesstock_adjustments` VALUES (1,34,100,'',0),(2,30,84,'',0),(3,111,24,'',0),(4,111,-12,'',0),(5,103,10,'',0),(6,102,10,'',0),(7,42,30,'',0),(8,41,24,'',0),(9,40,46,'',0),(10,37,57,'',0),(11,34,-40,'',0),(12,30,-32,'',0),(13,25,24,'',0),(14,25,24,'',0),(15,25,-24,'',0),(16,116,5,'',0),(17,115,5,'',0),(18,115,-5,'',0),(19,103,28,'',0),(20,101,8,'',0),(21,40,10,'',0),(22,41,5,'',0),(23,30,10,'',0),(24,40,-4,'',0),(25,40,10,'',0),(26,34,20,'',0),(27,25,20,'',0),(28,40,20,'',0),(29,110,2,'',0),(30,109,2,'',0),(31,117,25,'',0),(32,102,12,'',0),(33,25,4,'',0),(34,30,4,'',0),(35,40,4,'',0),(36,40,12,'',0),(37,105,24,'',0),(38,115,14,'',0),(39,114,24,'',0),(40,114,32,'',0),(41,100,6,'',0),(42,102,6,'',0),(43,103,6,'',0),(44,40,9,'',0),(45,42,8,'',0),(46,40,15,'',0),(47,30,1,'',0),(48,37,12,'',0),(49,25,-16,'',0),(50,25,-4,'',0),(51,30,-11,'',0),(52,40,-48,'',0),(53,115,40,'',0),(54,114,8,'',0),(55,114,32,'',0),(56,103,-24,'',0),(57,25,11,'',0),(58,30,11,'',0),(59,40,-2,'',0),(60,34,-1,'',0),(61,42,7,'',0),(62,30,20,'',0),(63,34,6,'',0),(64,110,2,'',0),(65,40,2,'',0),(66,30,-30,'',0),(67,102,-12,'',0),(68,34,10,'',0),(69,103,152,'',0),(70,25,156,'',0),(71,30,215,'',0),(72,34,237,'',0),(73,37,205,'',0),(74,40,210,'',0),(75,107,24,'',0),(76,109,24,'',0),(77,110,22,'',0),(78,30,17,'',0),(79,42,-3,'',0),(80,30,188,'',0),(81,25,8,'',0),(82,34,30,'',0),(83,40,17,'',0),(84,25,19,'',0),(85,34,17,'',0),(86,30,-132,'',0),(87,115,12,'',0),(88,113,57,'',0),(89,113,3,'',0),(90,115,10,'',0),(91,115,-10,'',0),(92,113,-3,'',0),(93,37,25,'',0),(94,40,34,'',0),(95,41,88,'',0),(96,42,31,'',0),(97,109,2,'',0),(98,110,4,'',0),(99,103,26,'',0),(100,25,6,'',0),(101,30,6,'',0),(102,102,36,'',0);

--
-- Table structure for table `United_Petroleum_Industriessuppliers`
--

CREATE TABLE `United_Petroleum_Industriessuppliers` (
  `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=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `United_Petroleum_Industriessuppliers`
--

INSERT INTO `United_Petroleum_Industriessuppliers` VALUES (1,'a','a','aa','','','','','2022-08-15','','0000','0009','','','om111','',929,0,1),(2,'OILMEC DRILLING EQUIPMENTS PVT.LTD','OILMEC DRILLING EQUIPMENTS PVT.LTD','India','','','','','2022-10-10','','-','marketing@oilmecasia',NULL,NULL,'','',943,0,0),(3,'CRIMSON OIL TOOLS PRIVATE LIMITED ','','India \nWorks/Office :. Plot No. 4 & 5 Pali Bhakri Road, Faridabad -121004, Haryana INDIA','','','','','2022-10-10','','+ 91-01292480381','',NULL,NULL,'','',944,0,0),(4,'DHL','','oman DHL Express Oman Country Office |62 Exhibition St; Airport Heights, P.O. Box 818, PC 131, Muscat','','','','','2022-10-10','','9514617','24511388',NULL,NULL,'','',945,0,0),(5,'ANPING SHENGJIA HARDWARE MESH CO.,LTD','\" Ada shaleshakerscreen@163.com  ','China','','','','','2022-10-10','','+8615028821900','',NULL,NULL,'','',946,0,0),(6,'Infinity Advertising & Publithing','Mr. BADAR AL SHUKAILI email: badar@infinity.om','P.O Box: 1709 | P.C: 133 | Al Khuwair | Sultanate of Oman Tel & Fax: (00968) 24612020 ','','','','','2022-10-10','',' (00968) 99755427','',NULL,NULL,'','',947,0,0),(7,'Blast line l.l.c ','Anas Al Sulaimani anas@nektel.om','P.O.Box 93 | P.C.327 | Sohar Industrial Estate  | Sohar | Sultanate of Oman','','','','','2022-10-10','','+968 96466628','',NULL,NULL,'','',948,0,0),(8,'tuful travel','','','','','','','2022-10-10','','968 24550460 ( 3 lin','',NULL,NULL,'','',949,0,0),(9,'al ismaili travels','al ismaili travels','oman , nizwa','','','','','2022-10-10','','95881816 ','98959859',NULL,NULL,'','',950,0,0),(10,'Well Solutions Services LLC Business Unit of GULF ENERGY S.A.O.C','sbatrani@gulfenergy-int.com','P.O. Box: 786, PC 116, Mina Al Fahal, Sultanate of Oman','','','','','2022-10-10','','96893800213','',NULL,NULL,'','',951,0,0),(11,'Industrial Supplies Center LLC','','Mobella, muscat ,oman','','','','','2022-10-10','','24467233',' 99103371',NULL,NULL,'','',952,0,0),(12,'Ali and Yousuf Trading','','Mobella, muscat ,oman','','','','','2022-10-10','','24460670 99331470 96','',NULL,NULL,'','',953,0,0),(13,'Omani Packaging Co. SAOG الشركة العمانية للتغليف','','Rusayl Industrial Estate, Seeb','','','','','2022-10-10','','24446696',' 92041876',NULL,NULL,'','',954,0,0),(14,'اللمسة الذهبية Golden Touch','','Nizwa','','','','','2022-10-10','','79946411 ','91386311',NULL,NULL,'','',955,0,0),(15,'Arabic for Training and Safety LLC','','Nizwa, madain ','','','','','2022-10-10','','25449212','',NULL,NULL,'','',956,0,0),(16,'Riyam Engineering & Services LLC ريام للهندسة و الخدمات','','Way No.66 Ghala Industrial Area Muscat OM, 112','','','','','2022-10-10','','24230500','',NULL,NULL,'','',957,0,0),(17,'Mohsin Haider Darwish LLC. Engineering Products Division محسن حيدر درويش قسم المنتجات الهندسية','','Building # 120/A, Way # 6643, Al Omran Street Ghala Industrial Area','','','','','2022-10-10','','92945638 ','92349882',NULL,NULL,'','',958,0,0),(18,'Abu admadam albusaidi','','Nizwa','','','','','2022-10-10','','92582295','',NULL,NULL,'','',959,0,0),(19,'AL-QEMA AL-SHAMILAH LLCالقيمة الشاملة ش.م.م','','CJQ5+WGF, Al saroor street, Sohar','','','','','2022-10-10','','97755591','',NULL,NULL,'','',960,0,0),(20,'YKM Group Deira','YKM Group Deira','78R7+F3C - Deira Islands - Front - Dubai - United Arab Emirates','','','','','2022-10-10','','+971505997623','971501817749 ',NULL,NULL,'','',961,0,0),(21,'Badar Saif Auditing','Mr. Sajesh','','','','','','2022-10-18','','9656 9829','','','','','',966,0,0);

--
-- Table structure for table `United_Petroleum_Industriestask_status`
--

CREATE TABLE `United_Petroleum_Industriestask_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 `United_Petroleum_Industriestask_status`
--

INSERT INTO `United_Petroleum_Industriestask_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 `United_Petroleum_Industriestasks`
--

CREATE TABLE `United_Petroleum_Industriestasks` (
  `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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `United_Petroleum_Industriestasks`
--

INSERT INTO `United_Petroleum_Industriestasks` VALUES (1,'kj','',1,0,0,NULL,'',1,'to_do',3,NULL,'',0,0,0,'',0,0,0,'2022-08-15',NULL,'0000-00-00',0,0),(2,'qq','qq',1,0,1,NULL,'',1,'to_do',3,NULL,'',0,0,0,'',0,0,0,'2022-08-15',NULL,'0000-00-00',0,0),(3,'wqe','',1,0,36,NULL,'',1,'to_do',3,NULL,'',0,0,0,'',0,0,0,'2022-08-15',NULL,'0000-00-00',0,0);

--
-- Table structure for table `United_Petroleum_Industriestaxes`
--

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

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

--
-- Table structure for table `United_Petroleum_Industriesteam`
--

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


--
-- Table structure for table `United_Petroleum_Industriesteam_member_job_info`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesteam_member_job_info`
--

INSERT INTO `United_Petroleum_Industriesteam_member_job_info` VALUES (5,36,'2016-11-01',0,830,NULL,8,22,0,0,0,0,1,1,'bank_muscat','Abdullah ','0318014970750029'),(6,37,'2022-01-11',0,400,NULL,8,20,0,0,0,0,0,1,'nbo','Anwaar','1031593620017'),(7,38,'0000-00-00',0,2000,NULL,8,22,0,0,0,0,0,1,'oman_arab_bank','Mohammed','3106452682507'),(8,39,'0000-00-00',0,620,NULL,8,22,0,0,0,0,0,1,'bank_muscat','Ahmed ','0378017349270027'),(9,1,'0000-00-00',0,250,NULL,8,22,0,0,0,0,0,1,'bank_muscat','',''),(10,40,'0000-00-00',0,0,NULL,8,0,0,0,0,0,0,1,NULL,NULL,NULL),(11,41,'0000-00-00',0,0,NULL,6,0,0,0,0,0,0,1,NULL,NULL,NULL),(12,42,'0000-00-00',0,500,NULL,8,22,0,0,0,0,0,1,'bank_muscat','Maan ','0304044333240018'),(13,43,'0000-00-00',0,0,NULL,0,22,0,0,0,0,0,1,'bank_muscat','',''),(14,44,'2022-10-03',0,250,NULL,8,22,0,0,0,0,0,1,'bank_muscat','','');

--
-- Table structure for table `United_Petroleum_Industriesticket_comments`
--

CREATE TABLE `United_Petroleum_Industriesticket_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 `United_Petroleum_Industriesticket_comments`
--


--
-- Table structure for table `United_Petroleum_Industriesticket_types`
--

CREATE TABLE `United_Petroleum_Industriesticket_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 `United_Petroleum_Industriesticket_types`
--

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

--
-- Table structure for table `United_Petroleum_Industriestickets`
--

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


--
-- Table structure for table `United_Petroleum_Industriesto_do`
--

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

--
-- Dumping data for table `United_Petroleum_Industriesto_do`
--

INSERT INTO `United_Petroleum_Industriesto_do` VALUES (1,37,'2022-07-21 07:47:33','vat submation ','','','done','2022-07-27',0),(2,37,'2022-07-21 08:14:50','send email to TMMS for pending payment  ','','','done','2022-07-27',1),(3,37,'2022-07-21 08:21:37','add expenses for jul and jun 2022 ','','','done','2022-07-24',0),(4,37,'2022-07-21 09:19:11','cash flow ','','','done','2022-07-26',0),(5,37,'2022-08-01 10:35:10','add all expenses and invoice in ERP ','','','to_do','2022-08-04',1),(6,37,'2022-08-02 12:26:46','Review and approve all invoices','','','to_do',NULL,0),(7,37,'2022-08-14 12:39:50','account chart ','','','to_do','2022-08-17',0),(8,37,'2022-08-14 12:42:44','workshop insurance','','','to_do',NULL,1),(9,36,'2022-08-15 06:46:43','dffgg','mnnb','Important','to_do','2022-08-15',1),(10,36,'2022-08-15 06:48:51','hh','','','to_do',NULL,1);

--
-- Table structure for table `United_Petroleum_Industriestransactions`
--

CREATE TABLE `United_Petroleum_Industriestransactions` (
  `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=299 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `United_Petroleum_Industriestransactions`
--

INSERT INTO `United_Petroleum_Industriestransactions` VALUES (1,'2022-01-27','Automatic General Expense: Cash on hand',0,NULL,0,1),(2,'2022-01-31','Automatic General Expense: Cash on hand',0,NULL,0,1),(3,'2022-01-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(4,'2022-01-31','Automatic General Expense: Cash on hand',0,NULL,0,1),(5,'2022-03-31','Automatic General Expense: Cash on hand',0,NULL,0,1),(6,'2022-03-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(7,'2022-01-27','Automatic General Expense: Cash on hand',0,NULL,0,0),(8,'2022-01-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(9,'2022-01-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(10,'2022-04-30','Automatic General Expense: Cash on hand',0,NULL,0,0),(11,'2022-07-17','Automatic General Expense: Cash on hand',0,NULL,0,1),(12,'2022-02-28','Automatic General Expense: Cash on hand',0,NULL,0,0),(13,'2022-02-28','Automatic General Expense: Cash on hand',0,NULL,0,0),(14,'2022-04-21','Automatic General Expense: Cash on hand',0,NULL,0,0),(15,'2022-04-30','Automatic General Expense: Cash on hand',0,NULL,0,0),(16,'2022-05-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(17,'2022-05-02','Automatic General Expense: Cash on hand',0,NULL,0,0),(18,'2022-07-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(19,'2022-07-21','journal_entry',1,'',0,1),(20,'2022-07-21','payment_voucher',1,'',0,1),(21,'2022-07-24','journal_entry',1,'expense for July ',0,1),(22,'2022-07-30','Invoice: INV#7',0,NULL,0,0),(23,'2022-06-22','Invoice: INV#8',0,NULL,0,0),(24,'2022-07-14','Invoice: INV#10',0,NULL,0,0),(25,'2022-04-28','Invoice: INV#46',0,NULL,0,0),(26,'2022-06-14','Invoice Payment Received: INV#46',0,NULL,0,0),(27,'2022-05-29','Invoice Payment Received: INV#40',0,NULL,0,0),(28,'2022-05-12','Invoice Payment Received: INV#41',0,NULL,0,0),(29,'2022-05-29','Invoice Payment Received: INV#45',0,NULL,0,0),(30,'2022-03-02','Invoice Payment Received: INV#36',0,NULL,0,0),(31,'2022-04-10','Invoice Payment Received: INV#37',0,NULL,0,0),(32,'2022-04-10','Invoice Payment Received: INV#38',0,NULL,0,0),(33,'2022-04-28','Invoice Inventory: INV#46',0,NULL,0,0),(34,'2022-08-11','payment_voucher',1,'',0,1),(35,'2022-05-08','Invoice Payment Received: UPI54',0,NULL,0,0),(36,'2022-06-22','Invoice Inventory: UPI8',0,NULL,0,0),(37,'2022-04-28','Invoice Inventory: UPI46',0,NULL,0,0),(38,'2022-08-14','Invoice Payment Received: UPI8',0,NULL,0,0),(39,'2022-06-28','Invoice Payment Received: UPI52',0,NULL,0,0),(40,'2022-05-31','Invoice: UPI52',0,NULL,0,0),(41,'2022-09-04','Automatic General Expense: Bank',0,NULL,0,1),(42,'2022-07-07','Automatic General Expense: Bank',0,NULL,0,0),(43,'2022-08-02','Automatic General Expense: Bank',0,NULL,0,0),(44,'2022-09-04','Automatic General Expense: Bank',0,NULL,0,0),(45,'2022-09-14','Automatic General Expense: Cheque',0,NULL,0,0),(46,'2022-09-04','Automatic General Expense: Cheque',0,NULL,0,0),(47,'2022-06-20','Automatic General Expense: Cheque',0,NULL,0,1),(48,'2022-08-14','Invoice Payment Received: UPI10',0,NULL,0,0),(49,'2022-08-14','Invoice Payment Received: UPI7',0,NULL,0,0),(50,'2022-09-11','Invoice Payment Received: UPI58',0,NULL,0,0),(51,'2022-09-11','Invoice Payment Received: UPI13',0,NULL,0,0),(52,'2022-05-08','Invoice Payment Received: UPI14',0,NULL,0,0),(53,'2022-06-28','Invoice Payment Received: UPI53',0,NULL,0,0),(54,'2022-04-10','Invoice Payment Received: UPI39',0,NULL,0,0),(55,'2022-07-25','Automatic General Expense: Cheque',0,NULL,0,0),(56,'2022-08-25','Invoice: UPI59',0,NULL,0,0),(57,'2022-09-29','Invoice Payment Received: UPI59',0,NULL,0,0),(58,'2022-07-31','Automatic General Expense: Bank',0,NULL,0,0),(59,'2022-06-17','Automatic General Expense: Bank',0,NULL,0,0),(60,'2022-03-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(61,'2022-04-24','Automatic General Expense: Bank',0,NULL,0,0),(62,'2022-06-30','Automatic General Expense: Bank',0,NULL,0,0),(63,'2022-06-30','Automatic General Expense: Bank',0,NULL,0,0),(64,'2022-05-19','Automatic General Expense: Cash on hand',0,NULL,0,0),(65,'2022-04-25','Automatic General Expense: Bank',0,NULL,0,0),(66,'2022-04-26','Automatic General Expense: Bank',0,NULL,0,0),(67,'2022-05-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(68,'2022-05-31','Automatic General Expense: Bank',0,NULL,0,0),(69,'2022-05-19','Automatic General Expense: Cash on hand',0,NULL,0,0),(70,'2022-05-24','Automatic General Expense: Bank',0,NULL,0,0),(71,'2022-05-30','Automatic General Expense: Cash on hand',0,NULL,0,0),(72,'2022-05-31','Automatic General Expense: Bank',0,NULL,0,0),(73,'2022-05-31','Automatic General Expense: Bank',0,NULL,0,0),(74,'2022-05-24','Automatic General Expense: Cash on hand',0,NULL,0,0),(75,'2022-05-24','Automatic General Expense: Bank',0,NULL,0,0),(76,'2022-05-30','Automatic General Expense: Cash on hand',0,NULL,0,0),(77,'2021-12-31','Automatic General Expense: Cash on hand',0,NULL,0,0),(78,'2022-01-03','Automatic General Expense: Cheque',0,NULL,0,0),(79,'2022-01-10','Automatic General Expense: Bank',0,NULL,0,0),(80,'2022-01-12','Automatic General Expense: Cheque',0,NULL,0,0),(81,'2022-10-02','Automatic General Expense: Cheque',0,NULL,0,1),(82,'2022-01-26','Automatic General Expense: Cheque',0,NULL,0,0),(83,'2022-01-19','Automatic General Expense: Cheque',0,NULL,0,0),(84,'2022-01-16','Automatic General Expense: Cheque',0,NULL,0,0),(85,'2022-01-17','Automatic General Expense: Cheque',0,NULL,0,0),(86,'2022-01-31','Automatic General Expense: Bank',0,NULL,0,0),(87,'2022-01-31','Automatic General Expense: Bank',0,NULL,0,0),(88,'2022-01-26','Automatic General Expense: Bank',0,NULL,0,0),(89,'2022-01-31','Automatic General Expense: Bank',0,NULL,0,0),(90,'2022-02-07','Automatic General Expense: Cheque',0,NULL,0,0),(91,'2022-03-27','Automatic General Expense: Bank',0,NULL,0,0),(92,'2022-02-08','Automatic General Expense: Bank',0,NULL,0,0),(93,'2022-03-17','Automatic General Expense: Bank',0,NULL,0,0),(94,'2022-02-14','Automatic General Expense: Cheque',0,NULL,0,0),(95,'2022-02-10','Automatic General Expense: Cheque',0,NULL,0,0),(96,'2022-02-15','Automatic General Expense: Cheque',0,NULL,0,0),(97,'2022-03-10','Automatic General Expense: Cheque',0,NULL,0,0),(98,'2022-03-02','Automatic General Expense: Bank',0,NULL,0,0),(99,'2022-07-04','Automatic General Expense: Cheque',0,NULL,0,0),(100,'2022-05-15','Automatic General Expense: Cheque',0,NULL,0,0),(101,'2022-06-05','Automatic General Expense: Cheque',0,NULL,0,0),(102,'2022-06-02','Automatic General Expense: Bank',0,NULL,0,0),(103,'2022-02-13','Automatic General Expense: Bank',0,NULL,0,0),(104,'2022-03-03','Automatic General Expense: Cheque',0,NULL,0,0),(105,'2022-03-15','Automatic General Expense: Cheque',0,NULL,0,0),(106,'2022-03-17','Automatic General Expense: Bank',0,NULL,0,0),(107,'2022-02-27','Automatic General Expense: Cheque',0,NULL,0,0),(108,'2022-02-27','Automatic General Expense: Bank',0,NULL,0,0),(109,'2022-02-17','Automatic General Expense: Cheque',0,NULL,0,0),(110,'2022-02-21','Automatic General Expense: Bank',0,NULL,0,0),(111,'2022-02-27','Automatic General Expense: Bank',0,NULL,0,0),(112,'2022-03-27','Automatic General Expense: Cheque',0,NULL,0,0),(113,'2022-03-27','Automatic General Expense: Bank',0,NULL,0,0),(114,'2022-03-31','Automatic General Expense: Bank',0,NULL,0,0),(115,'2022-03-31','Automatic General Expense: Bank',0,NULL,0,0),(116,'2022-04-03','Automatic General Expense: Bank',0,NULL,0,0),(117,'2022-04-04','Automatic General Expense: Bank',0,NULL,0,0),(118,'2022-04-24','Automatic General Expense: Bank',0,NULL,0,0),(119,'2022-04-06','Automatic General Expense: Cheque',0,NULL,0,0),(120,'2022-04-18','Automatic General Expense: Cheque',0,NULL,0,0),(121,'2022-04-17','Automatic General Expense: Cheque',0,NULL,0,0),(122,'2022-04-20','Automatic General Expense: Bank',0,NULL,0,0),(123,'2022-04-20','Automatic General Expense: Bank',0,NULL,0,0),(124,'2022-05-08','Automatic General Expense: Bank',0,NULL,0,0),(125,'2022-05-12','Automatic General Expense: Bank',0,NULL,0,0),(126,'2022-05-15','Automatic General Expense: Cheque',0,NULL,0,0),(127,'2022-05-29','Automatic General Expense: Cheque',0,NULL,0,0),(128,'2022-05-15','Automatic General Expense: Cheque',0,NULL,0,0),(129,'2022-05-18','Automatic General Expense: Cheque',0,NULL,0,0),(130,'2022-05-25','Automatic General Expense: Cheque',0,NULL,0,0),(131,'2022-05-25','Automatic General Expense: Bank',0,NULL,0,0),(132,'2022-05-24','Automatic General Expense: Bank',0,NULL,0,0),(133,'2022-05-25','Automatic General Expense: Bank',0,NULL,0,0),(134,'2022-05-19','Automatic General Expense: Bank',0,NULL,0,0),(135,'2022-06-02','Automatic General Expense: Bank',0,NULL,0,0),(136,'2022-06-05','Automatic General Expense: Cheque',0,NULL,0,0),(137,'2022-06-14','Automatic General Expense: Bank',0,NULL,0,0),(138,'2022-06-15','Automatic General Expense: Cheque',0,NULL,0,0),(139,'2022-06-15','Automatic General Expense: Bank',0,NULL,0,0),(140,'2022-06-16','Automatic General Expense: Bank',0,NULL,0,0),(141,'2022-06-15','Automatic General Expense: Cheque',0,NULL,0,0),(142,'2022-06-23','Automatic General Expense: Cheque',0,NULL,0,0),(143,'2022-06-23','Automatic General Expense: Cheque',0,NULL,0,0),(144,'2022-06-26','Automatic General Expense: Bank',0,NULL,0,0),(145,'2022-06-26','Automatic General Expense: Bank',0,NULL,0,0),(146,'2022-07-03','Automatic General Expense: Bank',0,NULL,0,0),(147,'2022-07-07','Automatic General Expense: Cheque',0,NULL,0,0),(148,'2022-07-13','Automatic General Expense: Bank',0,NULL,0,0),(149,'2022-07-13','Automatic General Expense: Cheque',0,NULL,0,0),(150,'2022-07-27','Automatic General Expense: Bank',0,NULL,0,0),(151,'2022-07-17','Automatic General Expense: Cheque',0,NULL,0,0),(152,'2022-07-27','Automatic General Expense: Bank',0,NULL,0,0),(153,'2022-08-03','Automatic General Expense: Cheque',0,NULL,0,0),(154,'2022-08-28','Automatic General Expense: Bank',0,NULL,0,0),(155,'2022-08-28','Automatic General Expense: Bank',0,NULL,0,0),(156,'2022-08-28','Automatic General Expense: Bank',0,NULL,0,0),(157,'2022-08-28','Automatic General Expense: Bank',0,NULL,0,0),(158,'2022-08-15','Automatic General Expense: Cheque',0,NULL,0,0),(159,'2022-08-14','Automatic General Expense: Cheque',0,NULL,0,0),(160,'2022-08-17','Automatic General Expense: Cheque',0,NULL,0,0),(161,'2022-08-02','Automatic General Expense: Bank',0,NULL,0,1),(162,'2022-09-27','Automatic General Expense: Bank',0,NULL,0,0),(163,'2022-09-27','Automatic General Expense: Bank',0,NULL,0,0),(164,'2022-08-31','Automatic General Expense: Bank',0,NULL,0,0),(165,'2022-10-03','Automatic General Expense: Bank',0,NULL,0,0),(166,'2022-06-20','Automatic General Expense: Cheque',0,NULL,0,0),(167,'2022-02-27','Invoice: UPI39',0,NULL,0,0),(168,'2022-08-16','Invoice: UPI58',0,NULL,0,0),(169,'2022-10-04','receipt_voucher',1,'',0,1),(170,'2022-08-25','Invoice Inventory: UPI59',0,NULL,0,0),(171,'2022-08-16','Invoice Inventory: UPI58',0,NULL,0,0),(172,'2022-07-30','Invoice Inventory: UPI7',0,NULL,0,0),(173,'2022-07-14','Invoice Inventory: UPI10',0,NULL,0,0),(174,'2022-07-28','Invoice: UPI13',0,NULL,0,0),(175,'2022-07-28','Invoice Inventory: UPI13',0,NULL,0,0),(176,'2022-06-22','Invoice Inventory: UPI8',0,NULL,0,0),(177,'2022-04-19','Invoice Payment Received: UPI51',0,NULL,0,0),(178,'2022-01-19','Invoice: UPI51',0,NULL,0,0),(179,'2022-01-19','Invoice Inventory: UPI51',0,NULL,0,0),(180,'2022-03-27','Invoice: UPI54',0,NULL,0,0),(181,'2022-03-27','Invoice Inventory: UPI54',0,NULL,0,0),(182,'2022-05-23','Invoice: UPI53',0,NULL,0,0),(183,'2022-05-23','Invoice Inventory: UPI53',0,NULL,0,0),(184,'2022-04-21','Invoice: UPI45',0,NULL,0,0),(185,'2022-04-21','Invoice Inventory: UPI45',0,NULL,0,0),(186,'2022-01-19','Invoice: UPI37',0,NULL,0,0),(187,'2022-01-19','Invoice Inventory: UPI37',0,NULL,0,0),(188,'2022-04-05','Invoice: UPI41',0,NULL,0,0),(189,'2022-04-05','Invoice Inventory: UPI41',0,NULL,0,0),(190,'2022-03-13','Invoice: UPI14',0,NULL,0,0),(191,'2022-03-13','Invoice Inventory: UPI14',0,NULL,0,0),(192,'2022-05-31','Invoice Inventory: UPI52',0,NULL,0,0),(193,'2022-02-27','Invoice Inventory: UPI39',0,NULL,0,0),(194,'2022-04-11','Invoice: UPI40',0,NULL,0,0),(195,'2022-04-11','Invoice Inventory: UPI40',0,NULL,0,0),(196,'2022-01-23','Invoice: UPI36',0,NULL,0,0),(197,'2022-01-23','Invoice Inventory: UPI36',0,NULL,0,0),(198,'2022-02-27','Invoice: UPI38',0,NULL,0,0),(199,'2022-02-27','Invoice Inventory: UPI38',0,NULL,0,0),(200,'2022-10-04','Invoice: UPI64',0,NULL,0,0),(201,'2022-09-27','Automatic General Expense: Bank',0,NULL,0,0),(202,'2022-09-27','Automatic General Expense: Bank',0,NULL,0,0),(203,'2022-09-22','Automatic General Expense: Bank',0,NULL,0,0),(204,'2022-09-22','Automatic General Expense: Bank',0,NULL,0,0),(205,'2022-09-22','Automatic General Expense: Bank',0,NULL,0,0),(206,'2022-09-15','Automatic General Expense: Cheque',0,NULL,0,1),(207,'2022-09-11','Automatic General Expense: Cheque',0,NULL,0,0),(208,'2022-09-04','Automatic General Expense: Cheque',0,NULL,0,0),(209,'2022-09-25','Invoice: UPI62',0,NULL,0,0),(210,'2022-09-25','Invoice Inventory: UPI62',0,NULL,0,0),(211,'2022-05-10','Automatic General Expense: Cheque',0,NULL,0,0),(212,'2022-10-11','journal_entry',1,'',0,1),(213,'2022-10-11','journal_entry',1,'bank',0,1),(214,'2022-10-13','Automatic General Expense: Cheque',0,NULL,0,0),(215,'2022-09-07','Invoice: UPI -AB-60',0,NULL,0,0),(216,'2022-09-07','Invoice Inventory: UPI -AB-60',0,NULL,0,0),(217,'2022-10-19','Invoice Payment Received: UPI -AB-60',0,NULL,0,0),(218,'2022-09-01','Invoice: UPI -AB-61',0,NULL,0,0),(219,'2022-09-01','Invoice Inventory: UPI -AB-61',0,NULL,0,0),(220,'2022-10-19','Invoice Payment Received: UPI -AB-61',0,NULL,0,0),(221,'2022-07-24','Invoice: UPI -AB-42',0,NULL,0,0),(222,'2022-07-24','Invoice Inventory: UPI -AB-42',0,NULL,0,0),(223,'2022-10-19','Invoice Payment Received: UPI -AB-42',0,NULL,0,0),(224,'2022-10-03','Automatic General Expense: Bank',0,NULL,0,0),(225,'2022-10-04','Automatic General Expense: Bank',0,NULL,0,0),(226,'2022-10-03','Automatic General Expense: Bank',0,NULL,0,0),(227,'2022-10-06','Automatic General Expense: Bank',0,NULL,0,0),(228,'2022-10-03','Automatic General Expense: Cash on hand',0,NULL,0,0),(229,'2022-10-02','Automatic General Expense: Cash on hand',0,NULL,0,0),(230,'2022-10-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(231,'2022-10-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(232,'2022-10-01','Automatic General Expense: Bank',0,NULL,0,0),(233,'2022-10-11','Automatic General Expense: Cash on hand',0,NULL,0,0),(234,'2022-10-11','Automatic General Expense: Cash on hand',0,NULL,0,0),(235,'2022-10-10','Automatic General Expense: Cash on hand',0,NULL,0,0),(236,'2022-10-12','Automatic General Expense: Bank',0,NULL,0,0),(237,'2022-10-20','Automatic General Expense: Bank',0,NULL,0,0),(238,'2022-10-19','Automatic General Expense: Bank',0,NULL,0,0),(239,'2022-10-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(240,'2022-10-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(241,'2022-10-17','Automatic General Expense: Cash on hand',0,NULL,0,0),(242,'2022-10-16','Automatic General Expense: Cash on hand',0,NULL,0,0),(243,'2022-10-16','Automatic General Expense: Bank',0,NULL,0,0),(244,'2022-10-25','Automatic General Expense: Bank',0,NULL,0,0),(245,'2022-10-31','Automatic General Expense: Bank',0,NULL,0,0),(246,'2022-10-23','Automatic General Expense: Cash on hand',0,NULL,0,0),(247,'2022-10-26','Automatic General Expense: Bank',0,NULL,0,0),(248,'2022-10-27','Automatic General Expense: Cash on hand',0,NULL,0,0),(249,'2022-10-30','Automatic General Expense: Cash on hand',0,NULL,0,0),(250,'2022-10-25','Automatic General Expense: Cash on hand',0,NULL,0,0),(251,'2022-11-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(252,'2022-11-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(253,'2022-11-02','Automatic General Expense: Bank',0,NULL,0,0),(254,'2022-11-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(255,'2022-10-05','Automatic General Expense: Bank',0,NULL,0,0),(256,'2022-10-04','Automatic General Expense: Bank',0,NULL,0,0),(257,'2022-09-25','Automatic General Expense: Cash on hand',0,NULL,0,0),(258,'2022-09-01','Automatic General Expense: Cash on hand',0,NULL,0,0),(259,'2022-08-21','Automatic General Expense: Cash on hand',0,NULL,0,0),(260,'2022-08-17','Automatic General Expense: Cash on hand',0,NULL,0,0),(261,'2022-09-04','Automatic General Expense: Bank',0,NULL,0,0),(262,'2022-09-05','Automatic General Expense: Bank',0,NULL,0,0),(263,'2022-09-06','Automatic General Expense: Bank',0,NULL,0,0),(264,'2022-09-07','Automatic General Expense: Cash on hand',0,NULL,0,0),(265,'2022-09-07','Automatic General Expense: Bank',0,NULL,0,0),(266,'2022-09-07','Automatic General Expense: Cash on hand',0,NULL,0,0),(267,'2022-09-08','Automatic General Expense: Cash on hand',0,NULL,0,0),(268,'2022-09-20','Automatic General Expense: Cash on hand',0,NULL,0,0),(269,'2022-09-20','Automatic General Expense: Cash on hand',0,NULL,0,0),(270,'2022-09-19','Automatic General Expense: Cash on hand',0,NULL,0,0),(271,'2022-09-19','Automatic General Expense: Bank',0,NULL,0,0),(272,'2022-09-19','Automatic General Expense: Bank',0,NULL,0,0),(273,'2022-09-25','Automatic General Expense: Cash on hand',0,NULL,0,0),(274,'2022-09-25','Automatic General Expense: Bank',0,NULL,0,0),(275,'2022-09-25','Automatic General Expense: Bank',0,NULL,0,0),(276,'2022-09-15','Automatic General Expense: Cash on hand',0,NULL,0,0),(277,'2022-09-26','Automatic General Expense: Cash on hand',0,NULL,0,0),(278,'2022-09-26','Automatic General Expense: Cash on hand',0,NULL,0,0),(279,'2022-09-22','Automatic General Expense: Cash on hand',0,NULL,0,0),(280,'2022-09-22','Automatic General Expense: Bank',0,NULL,0,0),(281,'2022-09-21','Automatic General Expense: Cash on hand',0,NULL,0,0),(282,'2022-09-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(283,'2022-09-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(284,'2022-09-15','Automatic General Expense: Cash on hand',0,NULL,0,0),(285,'2022-09-25','Automatic General Expense: Cash on hand',0,NULL,0,0),(286,'2022-09-14','Automatic General Expense: Bank',0,NULL,0,0),(287,'2022-09-12','Automatic General Expense: Cash on hand',0,NULL,0,0),(288,'2022-09-15','Automatic General Expense: Bank',0,NULL,0,0),(289,'2022-09-18','Automatic General Expense: Cash on hand',0,NULL,0,0),(290,'2022-09-22','Automatic General Expense: Bank',0,NULL,0,0),(291,'2022-09-04','Automatic General Expense: Bank',0,NULL,0,0),(292,'2022-10-31','Invoice: UPI -AB-22023',0,NULL,0,0),(293,'2022-10-31','Invoice Inventory: UPI -AB-22023',0,NULL,0,0),(294,'2022-11-15','Invoice: UPI -AB-22024',0,NULL,0,0),(295,'2022-11-15','Invoice Inventory: UPI -AB-22024',0,NULL,0,0),(296,'2022-09-15','Automatic General Expense: Cheque',0,NULL,0,0),(297,'2022-10-19','Invoice: UPI -AB-22022',0,NULL,0,0),(298,'2022-10-19','Invoice Inventory: UPI -AB-22022',0,NULL,0,0);

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `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',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` VALUES (1,'Assets','1',0,1,0),(2,'Liabilities','2',0,1,0),(3,'Owner\'s Equity','3',0,1,0),(4,'Expenses','4',0,1,0),(5,'Revenue','5',0,1,0),(6,'Cost of Goods Sold','6',0,1,0),(7,'Current Assets','1-1',1,1,0),(8,'Fixed Assets','1-2',1,1,0),(9,'Current Liabilities','2-1',2,1,0),(10,'Long-term Liabilities','2-2',2,1,0),(11,'Capital','3-1',3,1,0),(12,'Retain Earnings','3-2',3,1,0),(13,'Partners\' Withdrawal','3-3',3,1,0),(14,'Products','5-1-1',47,1,0),(15,'Services','5-1-2',47,1,0),(17,'Discounts','5-1-3',47,1,0),(18,'Banks','1-1-1',7,1,0),(19,'Cash In Hand','1-1-2',7,1,0),(20,'Receivable Accounts','1-1-3',7,1,0),(21,'Receivable Notes','1-1-4',7,1,0),(22,'Other Receivable Accounts','1-1-5',7,1,0),(23,'Employee Petty Cash','1-1-6',7,1,0),(24,'Inventory','1-1-7',7,1,0),(25,'Suppliers','2-1-1',9,1,0),(26,'Salary Payable','2-1-2',9,1,0),(47,'Sales','5-1',5,1,0),(48,'Employee Reimbursement','2-1-3',9,1,0),(52,'Default Bank','123456789',18,1,0),(53,'cheques Payable','2-1-4',9,1,0),(59,'Prepayments','1-1-8',7,1,0),(60,'Advance Payments','2-1-5',9,1,0),(67,'Salaries','4-1',4,1,0),(83,'Mohd Ali','1-1-6-1',23,1,0),(84,'Mohd Ali','2-1-2-1',26,1,0),(85,'Mohd Ali','2-1-3-1',48,1,0),(86,'Mohd Bagi','1-1-6-2',23,1,0),(87,'Mohd Bagi','2-1-2-2',26,1,0),(88,'Mohd Bagi','2-1-3-2',48,1,0),(89,'Doaa Doaa','1-1-6-3',23,1,0),(90,'Doaa Doaa','2-1-2-3',26,1,0),(91,'Doaa Doaa','2-1-3-3',48,1,0),(92,'First Client','1-1-3-1',20,1,0),(93,'First Client','2-1-5-1',60,1,0),(94,'Omantel User 4','1-1-6-4',23,1,0),(95,'Omantel User 4','2-1-2-4',26,1,0),(96,'Omantel User 4','2-1-3-4',48,1,0),(97,'First Supplier','2-1-1-1',25,1,0),(98,'First Supplier','1-1-8-1',59,1,0),(99,'Arak Medical Clinic','1-1-3-2',20,1,0),(100,'Arak Medical Clinic','2-1-5-2',60,1,0),(101,'Al Maha','1-1-3-3',20,1,0),(102,'Al Maha','2-1-5-3',60,1,0);

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_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 `activity_logs`
--


--
-- Table structure for table `almukhatataccounts`
--

CREATE TABLE `almukhatataccounts` (
  `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=79 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `almukhatataccounts`
--

INSERT INTO `almukhatataccounts` 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),(78,'Souq Alsad','1-1-1',7,0,0,NULL,0,NULL,0);

--
-- Table structure for table `almukhatatactivity_logs`
--

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

--
-- Dumping data for table `almukhatatactivity_logs`
--

INSERT INTO `almukhatatactivity_logs` VALUES (1,'2022-11-06 09:53:55',1,'created','clients','',1,NULL,'',0,'',0,0),(2,'2022-11-06 09:53:55',1,'updated','clients','',1,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:78;}}','',0,'',0,0),(3,'2023-01-22 07:02:30',1,'created','leave_applications','',1,NULL,'',0,'',0,0),(4,'2023-01-22 07:04:16',1,'created','leave_applications','',2,NULL,'',0,'',0,0),(5,'2023-01-22 07:05:18',1,'created','leave_applications','',3,NULL,'',0,'',0,0),(6,'2023-01-22 07:09:22',1,'created','payroll','',1,NULL,'',0,'',0,0);

--
-- Table structure for table `almukhatatannouncements`
--

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


--
-- Table structure for table `almukhatatattendance`
--

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


--
-- Table structure for table `almukhatatchecklist_items`
--

CREATE TABLE `almukhatatchecklist_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 `almukhatatchecklist_items`
--


--
-- Table structure for table `almukhatatci_sessions`
--

CREATE TABLE `almukhatatci_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 `almukhatatci_sessions`
--

INSERT INTO `almukhatatci_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('93b9ba90e8ce90d497d09f60e95eb2290b309b3b','161.8.109.180',1665410640,_binary '__ci_last_regenerate|i:1665382987;user_id|s:1:\"1\";'),('5bb6c76cf109c5721eb5590bb13d323de5005088','185.112.104.133',1665403307,_binary '__ci_last_regenerate|i:1665403294;'),('d8c374f80ac28469a59477202286546c563eb10c','161.8.109.180',1665468230,''),('3fe63e0732643b5c73d0d056661d0244d9ed2542','161.8.109.180',1665468228,''),('1b4f3ab64d661a66ee581a466b14395aeac18308','5.162.14.81',1665901704,_binary '__ci_last_regenerate|i:1665901704;'),('dc0ce916720547ed63e145213afe3918a04253cb','145.255.104.208',1665901179,_binary '__ci_last_regenerate|i:1665901179;'),('f863bfed233001e9d2d61ad8092c164537e32dc6','145.255.104.208',1665901705,_binary '__ci_last_regenerate|i:1665901704;'),('9a37802e2b8ec91817ac94808402e8ca7a3e5414','5.21.229.132',1665911054,_binary '__ci_last_regenerate|i:1665911042;'),('49ad384bd43baafed41f23809a3bb4912befd855','188.135.98.144',1665911128,_binary '__ci_last_regenerate|i:1665911127;'),('c2eefea24b9b189f89d17396810dfb05501134a2','161.8.109.180',1665929094,_binary '__ci_last_regenerate|i:1665917051;user_id|s:1:\"1\";'),('eac853b5b9dd59e0e7023276f00a88c08e6e8643','18.205.25.99',1665917283,_binary '__ci_last_regenerate|i:1665917283;'),('7aa12e00c7182c8fc7ba4ee4c86c636c4f90ebda','18.205.25.99',1665917283,_binary '__ci_last_regenerate|i:1665917283;'),('1596dd3541163f961a574c9044aa84e15a34fbad','5.21.230.134',1665924130,_binary '__ci_last_regenerate|i:1665924117;'),('f77df529c5d4efebcffc43bf782bd7311aa06971','161.8.109.180',1665926785,_binary '__ci_last_regenerate|i:1665926657;user_id|s:1:\"1\";'),('93b131b7a0badf415572c608acc2e4674b608548','161.8.109.180',1665929376,_binary '__ci_last_regenerate|i:1665929376;'),('9a839f3a536cda8ab25f0ad586ec092ce5830eb6','161.8.109.180',1665926791,_binary '__ci_last_regenerate|i:1665926785;'),('e28ee05921921c3082d8381e2f263e6460ff0920','78.111.45.252',1665927828,_binary '__ci_last_regenerate|i:1665927821;'),('6ba32001a8484a2042de5e56a245e4860fb2800e','78.111.45.252',1665927857,_binary '__ci_last_regenerate|i:1665927854;'),('442ce296a98dcfb01a516ed1bf6121f8064c772b','161.8.109.180',1665929377,_binary '__ci_last_regenerate|i:1665929376;'),('af2d86260e9f8380965450a5344280599c40ebc8','3.238.129.74',1665929398,_binary '__ci_last_regenerate|i:1665929398;'),('5ecab3282d15e4b550d9cf599bb510a3e3889f09','3.238.129.74',1665929398,_binary '__ci_last_regenerate|i:1665929398;'),('66db746c256ee70c588ce61d2650dcb183d494f3','5.21.229.132',1665944209,_binary '__ci_last_regenerate|i:1665944196;'),('e417de6c1d3bf736e81a5b29e388cec6a254eb99','161.8.109.180',1665987219,''),('1f10c25ef4272710f2857875841100840838e353','161.8.109.180',1665987903,_binary '__ci_last_regenerate|i:1665987902;'),('e110774a097b33dea4f32c88877fca8c53c5c1b5','78.111.45.252',1666394007,_binary '__ci_last_regenerate|i:1666394002;'),('0db6c845714e4a4d22f1bd23f62ad95f25ec4b05','5.37.232.114',1667662521,_binary '__ci_last_regenerate|i:1667662516;'),('cf5a8d6610237d221c17a6957439a23b3f6b22c3','5.37.232.114',1667662983,_binary '__ci_last_regenerate|i:1667662983;user_id|s:1:\"1\";'),('79f079f46d32c98911878f14b6d66e2eef96b06e','5.37.232.114',1667665814,_binary '__ci_last_regenerate|i:1667662983;user_id|s:1:\"1\";'),('d623e052d64d60ad9f645150a0411a495ceebc1d','161.8.109.180',1667728200,_binary '__ci_last_regenerate|i:1667728200;user_id|s:1:\"1\";'),('1264f0de3ecf180d59c08469ceeb09a17e9b2ad0','161.8.109.180',1667728507,_binary '__ci_last_regenerate|i:1667728507;user_id|s:1:\"1\";'),('8cede569a4fd35c9767586a9ecf574df665e2db0','54.38.214.107',1667728480,_binary '__ci_last_regenerate|i:1667728479;'),('ea16d799daac4a3b7a7831ca5480bebb1897d65d','161.8.109.180',1667728738,_binary '__ci_last_regenerate|i:1667728507;user_id|s:1:\"1\";'),('cb5810f67b7e00a753536f4519d5c4c0e0453c98','217.138.200.22',1674366636,_binary '__ci_last_regenerate|i:1674366216;user_id|s:1:\"1\";'),('b1724e858ca6c17077811d5dc31fa2e5417f2262','145.255.113.205',1674366868,_binary '__ci_last_regenerate|i:1674366866;'),('5339b675c77308a12a534befa404b1e7c15b03bc','37.46.114.67',1674369707,_binary '__ci_last_regenerate|i:1674369707;user_id|s:1:\"1\";'),('60db103e5eb88a08b486edc1866855886b536d42','37.46.114.67',1674370233,_binary '__ci_last_regenerate|i:1674370233;user_id|s:1:\"1\";'),('b1e1841b7fd4f5ff1e8ba14e26f46ba8b39ccbc6','37.46.114.67',1674370808,_binary '__ci_last_regenerate|i:1674370808;user_id|s:1:\"1\";'),('f456699e578f54ab6e8fad28d95c9e3118c82a21','37.46.114.67',1674371118,_binary '__ci_last_regenerate|i:1674371118;user_id|s:1:\"1\";'),('51c3e8918c776a89a4ce9963ab59a8054106a36b','37.46.114.67',1674371435,_binary '__ci_last_regenerate|i:1674371435;user_id|s:1:\"1\";'),('d2272c76217312b7d08aeb3dbae57f77817fcbe1','37.46.114.67',1674382415,_binary '__ci_last_regenerate|i:1674382415;user_id|s:1:\"1\";'),('2707441be73c3005fdf6d2fd70149f07534d89bd','37.46.114.67',1674386213,_binary '__ci_last_regenerate|i:1674386213;user_id|s:1:\"1\";'),('b6f796cfe858b9edaf7520f764622f80161eb53e','37.46.114.67',1674392232,_binary '__ci_last_regenerate|i:1674386213;user_id|s:1:\"1\";'),('60383e6033a0cce2bf5ce27ff1326e1dcf762418','37.46.114.67',1675235182,_binary '__ci_last_regenerate|i:1675227298;user_id|s:1:\"1\";'),('100e8f7a9666096e347a4e207c0b4519b47b27a2','217.160.101.102',1675235486,_binary '__ci_last_regenerate|i:1675235385;user_id|s:1:\"1\";'),('fa9ab36b917b29bd62b7a73b9c8b81cc9a721416','185.80.220.38',1676372826,_binary '__ci_last_regenerate|i:1676372826;user_id|s:1:\"1\";'),('eb1ac18725988f7ff8e4f28a5637ccb223b5c549','185.80.220.38',1676373280,_binary '__ci_last_regenerate|i:1676373280;user_id|s:1:\"1\";'),('1f25ef956af764bd2aa42192e2c454e3567a3d04','185.80.220.38',1676373560,''),('3df166ca76b2c40105659bb7922de08fb10b6bba','185.80.220.38',1676374998,_binary '__ci_last_regenerate|i:1676373655;user_id|s:1:\"7\";'),('7b48f21718082fc40a9aeab5738458564d117d2e','185.80.220.38',1676454588,_binary '__ci_last_regenerate|i:1676454588;user_id|s:1:\"7\";'),('c9b83734d5c3df9bb61e9d4536e8049bbb01b5fe','185.80.220.38',1676454589,_binary '__ci_last_regenerate|i:1676454589;'),('c95ba7486234d3ada536e8c575f4b925273a8820','78.111.45.209',1677992614,_binary '__ci_last_regenerate|i:1677992557;user_id|s:1:\"1\";'),('c0491a3d11944bb0c0880a753531c4d28450ddf8','78.111.45.209',1678089545,_binary '__ci_last_regenerate|i:1678087149;user_id|s:1:\"1\";'),('f7a9d83fab0872f0e60b7c40e70ba134769fd986','185.107.56.30',1679303411,_binary '__ci_last_regenerate|i:1679303411;user_id|s:1:\"4\";'),('faa6e07d6818ac902d54516c91b4ca1e9d64066d','185.107.56.30',1679384440,_binary '__ci_last_regenerate|i:1679303411;user_id|s:1:\"4\";'),('299f76e0446ebe80d4920dd57a2d0fff6f6d7c7c','185.107.56.30',1679405182,_binary '__ci_last_regenerate|i:1679397472;user_id|s:1:\"4\";'),('313abd3ffbb94ed26b1645dcfc99533defaf3919','185.107.56.30',1679554084,_binary '__ci_last_regenerate|i:1679554082;'),('f16ed51e33d6170792857de02a4b8fce4addc2af','78.111.45.209',1679810589,_binary '__ci_last_regenerate|i:1679810589;'),('aa263d7666ac5e447c0fc68b40b4720011a64bd5','78.111.45.209',1679826511,_binary '__ci_last_regenerate|i:1679826511;user_id|s:1:\"4\";'),('6355533fb28d4047d708f18c984f08a50e14e1f8','78.111.45.209',1679831003,_binary '__ci_last_regenerate|i:1679826511;user_id|s:1:\"4\";'),('6b8fc8e1ec90ca83d69373711e2ed031928f3411','20.232.17.244',1679828071,_binary '__ci_last_regenerate|i:1679828065;'),('e3a8d5f1d2148cd4fca946784fbb78fda52e7927','78.111.45.209',1679981268,_binary '__ci_last_regenerate|i:1679981267;'),('8aa09b94e019acb21fe7f5829c4484142351cb76','78.111.45.209',1680001568,_binary '__ci_last_regenerate|i:1680001567;'),('b523ac1aaa12bd3a7e2e03a5196f488c1b93570b','78.111.45.209',1680417769,_binary '__ci_last_regenerate|i:1680417769;'),('4ad6fb6067040c3b1cf374b97901f1cd5bffd5ad','78.111.45.209',1680421428,_binary '__ci_last_regenerate|i:1680417797;user_id|s:1:\"7\";'),('76fd31b3c105c76de9a8c885352ec556fe3867e6','78.111.45.209',1680514066,_binary '__ci_last_regenerate|i:1680514065;'),('e7d1eb822e4860347b737112af05ee26d2f8f1a1','78.111.45.209',1680604945,_binary '__ci_last_regenerate|i:1680604944;'),('5eafa7dc6e73b110f5e5a9d4658a00247fdd63e8','78.111.45.209',1680671793,_binary '__ci_last_regenerate|i:1680671792;'),('7617590f11c3dfe136dfca39d24d11263dc63577','78.111.45.209',1680770005,_binary '__ci_last_regenerate|i:1680770004;'),('192a597765d8cd5a5c7c235441f218afbb43b7d6','78.111.45.209',1681034074,_binary '__ci_last_regenerate|i:1681034073;'),('951942e295bba1bd6a7fbf9f3160b6a80b6b5cca','78.111.45.209',1681104127,_binary '__ci_last_regenerate|i:1681104126;'),('487e0563eb0c509598faca8b5a008c265b5e82e3','78.111.45.209',1681120025,_binary '__ci_last_regenerate|i:1681120024;'),('c9dd71361bd30de35cda9ff3f446e46e6e3cc0b5','78.111.45.209',1682410523,_binary '__ci_last_regenerate|i:1682410522;');

--
-- Table structure for table `almukhatatclient_groups`
--

CREATE TABLE `almukhatatclient_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 `almukhatatclient_groups`
--


--
-- Table structure for table `almukhatatclients`
--

CREATE TABLE `almukhatatclients` (
  `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',
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `almukhatatclients`
--

INSERT INTO `almukhatatclients` VALUES (1,'Souq Alsad','','','','','','2022-11-06','','96732399','','','',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,78,0,'');

--
-- Table structure for table `almukhatatcontacts`
--

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


--
-- Table structure for table `almukhatatcustom_field_values`
--

CREATE TABLE `almukhatatcustom_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 `almukhatatcustom_field_values`
--


--
-- Table structure for table `almukhatatcustom_fields`
--

CREATE TABLE `almukhatatcustom_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 `almukhatatcustom_fields`
--


--
-- Table structure for table `almukhatatcustom_widgets`
--

CREATE TABLE `almukhatatcustom_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 `almukhatatcustom_widgets`
--


--
-- Table structure for table `almukhatatdashboards`
--

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


--
-- Table structure for table `almukhatatdelivery_note_items`
--

CREATE TABLE `almukhatatdelivery_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 `almukhatatdelivery_note_items`
--


--
-- Table structure for table `almukhatatdelivery_notes`
--

CREATE TABLE `almukhatatdelivery_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 `almukhatatdelivery_notes`
--


--
-- Table structure for table `almukhatatemail_templates`
--

CREATE TABLE `almukhatatemail_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 `almukhatatemail_templates`
--


--
-- Table structure for table `almukhatatenteries`
--

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

--
-- Dumping data for table `almukhatatenteries`
--

INSERT INTO `almukhatatenteries` VALUES (1,1,26,'dr',500,'ADVANCE SALARY FOR مصطفى رزق خليل زعرب',0,2,'0',1,0),(2,1,900,'cr',500,'ADVANCE SALARY FOR مصطفى رزق خليل زعرب',0,2,'0',1,0);

--
-- Table structure for table `almukhatatestimate_forms`
--

CREATE TABLE `almukhatatestimate_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 `almukhatatestimate_forms`
--


--
-- Table structure for table `almukhatatestimate_items`
--

CREATE TABLE `almukhatatestimate_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 `almukhatatestimate_items`
--


--
-- Table structure for table `almukhatatestimate_requests`
--

CREATE TABLE `almukhatatestimate_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 `almukhatatestimate_requests`
--


--
-- Table structure for table `almukhatatestimates`
--

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


--
-- Table structure for table `almukhatatevents`
--

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


--
-- Table structure for table `almukhatatexpense_categories`
--

CREATE TABLE `almukhatatexpense_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 `almukhatatexpense_categories`
--


--
-- Table structure for table `almukhatatexpenses`
--

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


--
-- Table structure for table `almukhatatgeneral_files`
--

CREATE TABLE `almukhatatgeneral_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 `almukhatatgeneral_files`
--


--
-- Table structure for table `almukhatathelp_articles`
--

CREATE TABLE `almukhatathelp_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 `almukhatathelp_articles`
--


--
-- Table structure for table `almukhatathelp_categories`
--

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

--
-- Dumping data for table `almukhatathelp_categories`
--

INSERT INTO `almukhatathelp_categories` VALUES (1,'قسم المشاريع والشؤون الفنية ','','knowledge_base',0,'active',0),(2,'قسم المبيعات وإدارة الأصول','','knowledge_base',0,'active',0),(3,'قسم التسويق','','knowledge_base',0,'active',0),(4,'قسم الشؤون المالية ','','knowledge_base',0,'active',0),(5,'قسم الشؤون الإدارية ','','knowledge_base',0,'active',0);

--
-- Table structure for table `almukhatatinternal_transactions`
--

CREATE TABLE `almukhatatinternal_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 `almukhatatinternal_transactions`
--


--
-- Table structure for table `almukhatatinvoice_items`
--

CREATE TABLE `almukhatatinvoice_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 `almukhatatinvoice_items`
--


--
-- Table structure for table `almukhatatinvoice_payments`
--

CREATE TABLE `almukhatatinvoice_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 `almukhatatinvoice_payments`
--


--
-- Table structure for table `almukhatatinvoices`
--

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


--
-- Table structure for table `almukhatatitem_categories`
--

CREATE TABLE `almukhatatitem_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 `almukhatatitem_categories`
--


--
-- Table structure for table `almukhatatitems`
--

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


--
-- Table structure for table `almukhatatlead_source`
--

CREATE TABLE `almukhatatlead_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 `almukhatatlead_source`
--

INSERT INTO `almukhatatlead_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 `almukhatatlead_status`
--

CREATE TABLE `almukhatatlead_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 `almukhatatlead_status`
--

INSERT INTO `almukhatatlead_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 `almukhatatleads`
--

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


--
-- Table structure for table `almukhatatleave_applications`
--

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

--
-- Dumping data for table `almukhatatleave_applications`
--

INSERT INTO `almukhatatleave_applications` VALUES (1,2,'2023-01-04','2023-01-09',48.00,6.00,2,'السفر لاداء العمرة ','','2023-01-22 07:02:30',1,'2023-01-22 07:02:30',1,1,0),(2,2,'2022-11-20','2022-11-24',40.00,5.00,7,'السفر ','','2023-01-22 07:04:16',1,'2023-01-22 07:04:16',1,1,0),(3,2,'2022-11-20','2022-11-24',40.00,5.00,7,'السفر','','2023-01-22 07:05:18',1,'2023-01-22 07:05:18',1,1,0);

--
-- Table structure for table `almukhatatleave_types`
--

CREATE TABLE `almukhatatleave_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 `almukhatatleave_types`
--

INSERT INTO `almukhatatleave_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 `almukhatatloans`
--

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

--
-- Dumping data for table `almukhatatloans`
--

INSERT INTO `almukhatatloans` VALUES (1,2,500,'2022-02-22',0);

--
-- Table structure for table `almukhatatmessages`
--

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


--
-- Table structure for table `almukhatatmilestones`
--

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


--
-- Table structure for table `almukhatatnotes`
--

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


--
-- Table structure for table `almukhatatnotification_settings`
--

CREATE TABLE `almukhatatnotification_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 `almukhatatnotification_settings`
--

INSERT INTO `almukhatatnotification_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 `almukhatatnotifications`
--

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

--
-- Dumping data for table `almukhatatnotifications`
--

INSERT INTO `almukhatatnotifications` VALUES (1,1,'','2022-11-06 09:54:39','','','project_created',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `almukhatatpayment_methods`
--

CREATE TABLE `almukhatatpayment_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 `almukhatatpayment_methods`
--

INSERT INTO `almukhatatpayment_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 `almukhatatpaypal_ipn`
--

CREATE TABLE `almukhatatpaypal_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 `almukhatatpaypal_ipn`
--


--
-- Table structure for table `almukhatatpayroll`
--

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

--
-- Dumping data for table `almukhatatpayroll`
--

INSERT INTO `almukhatatpayroll` VALUES (1,'2023-01-01','draft',0);

--
-- Table structure for table `almukhatatpayroll_detail`
--

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

--
-- Dumping data for table `almukhatatpayroll_detail`
--

INSERT INTO `almukhatatpayroll_detail` VALUES (1,1,1,0.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(2,1,7,700.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(3,1,6,500.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(4,1,3,4223.500,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(5,1,5,1000.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(6,1,8,500.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0),(7,1,2,700.000,0.000,NULL,0.000,NULL,0.000,500.000,0,0,0,0,0),(8,1,4,1300.000,0.000,NULL,0.000,NULL,0.000,0.000,0,0,0,0,0);

--
-- Table structure for table `almukhatatposts`
--

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


--
-- Table structure for table `almukhatatproject_comments`
--

CREATE TABLE `almukhatatproject_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 `almukhatatproject_comments`
--


--
-- Table structure for table `almukhatatproject_files`
--

CREATE TABLE `almukhatatproject_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 `almukhatatproject_files`
--


--
-- Table structure for table `almukhatatproject_members`
--

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

--
-- Dumping data for table `almukhatatproject_members`
--

INSERT INTO `almukhatatproject_members` VALUES (1,1,1,1,0);

--
-- Table structure for table `almukhatatproject_settings`
--

CREATE TABLE `almukhatatproject_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 `almukhatatproject_settings`
--


--
-- Table structure for table `almukhatatproject_time`
--

CREATE TABLE `almukhatatproject_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 `almukhatatproject_time`
--


--
-- Table structure for table `almukhatatprojects`
--

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

--
-- Dumping data for table `almukhatatprojects`
--

INSERT INTO `almukhatatprojects` VALUES (1,'Souq Al Sad','',NULL,NULL,1,'2022-11-06',1,'open','',0,'',0,NULL,0);

--
-- Table structure for table `almukhatatpurchase_order_items`
--

CREATE TABLE `almukhatatpurchase_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 `almukhatatpurchase_order_items`
--


--
-- Table structure for table `almukhatatpurchase_order_payments`
--

CREATE TABLE `almukhatatpurchase_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 `almukhatatpurchase_order_payments`
--


--
-- Table structure for table `almukhatatpurchase_orders`
--

CREATE TABLE `almukhatatpurchase_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 `almukhatatpurchase_orders`
--


--
-- Table structure for table `almukhatatpurchase_return_items`
--

CREATE TABLE `almukhatatpurchase_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 `almukhatatpurchase_return_items`
--


--
-- Table structure for table `almukhatatpurchase_returns`
--

CREATE TABLE `almukhatatpurchase_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 `almukhatatpurchase_returns`
--


--
-- Table structure for table `almukhatatroles`
--

CREATE TABLE `almukhatatroles` (
  `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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `almukhatatroles`
--

INSERT INTO `almukhatatroles` VALUES (1,'Accountant',NULL,0),(2,'قسم المشاريع','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\";N;s:17:\"can_edit_projects\";N;s:19:\"can_delete_projects\";N;s:30:\"can_add_remove_project_members\";s:1:\"1\";s:16:\"can_create_tasks\";N;s:14:\"can_edit_tasks\";N;s:16:\"can_delete_tasks\";N;s:20:\"can_comment_on_tasks\";s:1:\"1\";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\";s:1:\"1\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";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),(3,'قسم المبيعات','a:116:{s:5:\"leave\";s:0:\"\";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\";s:3:\"all\";s:6:\"ticket\";N;s:15:\"ticket_specific\";s:0:\"\";s:12:\"announcement\";s:0:\"\";s:23:\"help_and_knowledge_base\";s:0:\"\";s:23:\"can_manage_all_projects\";s:1:\"1\";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\";s:1:\"1\";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\";s:0:\"\";s:38:\"team_member_update_permission_specific\";s:0:\"\";s:27:\"timesheet_manage_permission\";s:0:\"\";s:36:\"timesheet_manage_permission_specific\";s:0:\"\";s:21:\"disable_event_sharing\";s:1:\"0\";s:22:\"hide_team_members_list\";N;s:28:\"can_delete_leave_application\";N;s:10:\"accounting\";s:0:\"\";s:7:\"payroll\";s:0:\"\";s:5:\"eroom\";s:0:\"\";s:4:\"logs\";s:0:\"\";s:13:\"expires_alert\";s:0:\"\";s:7:\"reports\";s:0:\"\";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\";s:0:\"\";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\";s:0:\"\";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\";s:3:\"all\";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\";s:3:\"all\";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\";s:3:\"all\";s:35:\"estimate_manage_permission_specific\";s:0:\"\";s:16:\"estimate_request\";s:3:\"all\";s:8:\"discount\";i:0;s:8:\"expenses\";s:0:\"\";s:9:\"estimates\";s:0:\"\";s:8:\"invoices\";s:0:\"\";s:16:\"invoice_payments\";s:0:\"\";s:14:\"delivery_notes\";s:0:\"\";s:15:\"purchase_orders\";s:0:\"\";s:23:\"purchase_order_payments\";s:0:\"\";s:8:\"payrolls\";N;s:21:\"internal_transactions\";N;}',0);

--
-- Table structure for table `almukhatatsalary_advance`
--

CREATE TABLE `almukhatatsalary_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 `almukhatatsalary_advance`
--


--
-- Table structure for table `almukhatatsale_return_items`
--

CREATE TABLE `almukhatatsale_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 `almukhatatsale_return_items`
--


--
-- Table structure for table `almukhatatsale_returns`
--

CREATE TABLE `almukhatatsale_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 `almukhatatsale_returns`
--


--
-- Table structure for table `almukhatatsettings`
--

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

INSERT INTO `almukhatatsettings` 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),('user_7_dashboard','','user',0),('user_7_personal_language','arabic','user',0),('user_8_dashboard','','user',0),('user_8_personal_language','arabic','user',0),('weekend','5,6','app',0);

--
-- Table structure for table `almukhatatshipment_items`
--

CREATE TABLE `almukhatatshipment_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 `almukhatatshipment_items`
--


--
-- Table structure for table `almukhatatshipments`
--

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


--
-- Table structure for table `almukhatatsocial_links`
--

CREATE TABLE `almukhatatsocial_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 `almukhatatsocial_links`
--


--
-- Table structure for table `almukhatatstock_adjustments`
--

CREATE TABLE `almukhatatstock_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 `almukhatatstock_adjustments`
--


--
-- Table structure for table `almukhatatsuppliers`
--

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


--
-- Table structure for table `almukhatattask_status`
--

CREATE TABLE `almukhatattask_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 `almukhatattask_status`
--

INSERT INTO `almukhatattask_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 `almukhatattasks`
--

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


--
-- Table structure for table `almukhatattaxes`
--

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

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

--
-- Table structure for table `almukhatatteam`
--

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


--
-- Table structure for table `almukhatatteam_member_job_info`
--

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

--
-- Dumping data for table `almukhatatteam_member_job_info`
--

INSERT INTO `almukhatatteam_member_job_info` VALUES (1,2,'2022-02-01',0,700,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(2,3,'2020-11-01',0,4223.5,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(3,4,'2021-12-08',0,1300,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(4,5,'2020-10-25',0,1000,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(5,6,'2021-11-01',0,500,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(6,7,'2022-06-01',0,700,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL),(7,8,'2021-10-31',0,500,NULL,8,31,0,0,0,0,0,1,NULL,NULL,NULL);

--
-- Table structure for table `almukhatatticket_comments`
--

CREATE TABLE `almukhatatticket_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 `almukhatatticket_comments`
--


--
-- Table structure for table `almukhatatticket_types`
--

CREATE TABLE `almukhatatticket_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 `almukhatatticket_types`
--

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

--
-- Table structure for table `almukhatattickets`
--

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


--
-- Table structure for table `almukhatatto_do`
--

CREATE TABLE `almukhatatto_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 `almukhatatto_do`
--


--
-- Table structure for table `almukhatattransactions`
--

CREATE TABLE `almukhatattransactions` (
  `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=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `almukhatattransactions`
--

INSERT INTO `almukhatattransactions` VALUES (1,'2023-01-22','ADVANCE SALARY FOR مصطفى رزق خليل زعرب',0,NULL,0,0);

--
-- Table structure for table `announcements`
--

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


--
-- Table structure for table `attendance`
--

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


--
-- Table structure for table `bgcaccounts`
--

CREATE TABLE `bgcaccounts` (
  `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=1039 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bgcaccounts`
--

INSERT INTO `bgcaccounts` VALUES (1,'Mustafa & Kamal Ashraf Trading ','1-1-2',7,0,0,'',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),(903,'Esri Muscat Co. LLC','1-1-1',7,0,0,NULL,0,NULL,0),(904,'Asset','4-1-1',21,0,0,NULL,0,NULL,0),(905,'Bayanat Geographical Consulting','0389043217960011_IBAN: OM840270389043217960011',8,0,1,'Company Account',NULL,NULL,0),(906,'Esri Muscat Co. LLC','2-1-1',13,0,0,NULL,0,NULL,0),(907,'Abaq Al Sharqya TRD','2-1-2',13,0,0,NULL,0,NULL,0),(908,'Global Chrome Company LLC','2-1-3',13,0,0,NULL,0,NULL,0),(909,'Ahjar Al Andalus Trad.Co.LLC','2-1-4',13,0,0,NULL,0,NULL,0),(910,'Ahjar Al Andalus Trad.Co.LLC','1-1-3',7,0,0,NULL,0,NULL,0),(911,'Al Shafaq Electrical Co ','1-1-4',7,0,0,NULL,0,NULL,0),(912,'Abaq Al Sharqya TRD','1-1-5',7,0,0,NULL,0,NULL,0),(913,'Ara\'a United Contracting LLC','1-1-6',7,0,0,NULL,0,NULL,0),(914,'Saqoor Al Abyad Trading & Contracting','1-1-7',7,0,0,NULL,0,NULL,0),(915,'AFAQ AL AHTRAF','1-1-8',7,0,0,NULL,0,NULL,0),(916,'ALBATNH HILLS ENGINEERING','1-1-9',7,0,0,NULL,0,NULL,0),(917,'Public Authority for Social Insurance (PASI)','1-1-10',7,0,0,NULL,0,NULL,0),(918,'Fees','4-1-2',21,0,0,NULL,0,NULL,0),(919,'stationary','4-1-3',21,0,0,NULL,0,NULL,0),(920,'Vehicle maintenance','4-1-4',21,0,0,NULL,0,NULL,0),(921,'Rent','4-1-5',21,0,0,NULL,0,NULL,0),(922,'Bill','4-1-6',21,0,0,NULL,0,NULL,0),(923,'Other','4-1-7',21,0,0,NULL,0,NULL,0),(924,'Mazoon Electricity Company SAOC (MZEC)','1-1-11',7,0,0,NULL,0,NULL,0),(925,'Majan Electricity Company SAOC','1-1-12',7,0,0,NULL,0,NULL,0),(926,' Muscat Electricity Distribution Company','1-1-13',7,0,0,NULL,0,NULL,0),(927,'KHATIB & ALAMI AND PARTNERS FOR ENGINEERING CONSULTANT','1-1-14',7,0,0,NULL,0,NULL,0),(928,'Oman Broadband','1-1-15',7,0,0,NULL,0,NULL,0),(929,'Majis Industrial Services','1-1-16',7,0,0,NULL,0,NULL,0),(930,'Bahwan Engineering Company','1-1-17',7,0,0,NULL,0,NULL,0),(931,'BGC','1-1-18',7,0,0,NULL,0,NULL,0),(932,'Gulf International Auditing & Consultancy ','2-1-5',13,0,0,NULL,0,NULL,0),(933,'Gulf International Auditing & Consultancy ','1-1-19',7,0,0,NULL,0,NULL,0),(934,'Invoice','4-1-8',21,0,0,NULL,0,NULL,0),(935,'Golden Sands Transport Services LLC','1-1-20',7,0,0,NULL,0,NULL,0),(936,'INTERNATIONAL MARBLE CO LLC','1-1-21',7,0,0,NULL,0,NULL,0),(937,'Ministry of Labour ','1-1-22',7,0,0,NULL,0,NULL,0),(938,'Telecommunications Regulatory Authority','1-1-23',7,0,0,NULL,0,NULL,0),(939,'AL-Khatoot AL-Amna','1-1-24',7,0,0,NULL,0,NULL,0),(940,'Oman Telecommunications Company (Omantel)','1-1-25',7,0,0,NULL,0,NULL,0),(941,'Awasr Oman','1-1-26',7,0,0,NULL,0,NULL,0),(942,'ROYAL OMAN POLICE','1-1-27',7,0,0,NULL,0,NULL,0),(943,'Jal Engineering Services LLC','1-1-28',7,0,0,NULL,0,NULL,0),(944,'Shell Oman Marketing SAOG','1-1-29',7,0,0,NULL,0,NULL,0),(945,'Leave payment','4-1-9',21,0,0,NULL,0,NULL,0),(946,'United Finance Company SAOG','1-1-30',7,0,0,NULL,0,NULL,0),(947,'Muscat Financ','1-1-31',7,0,0,NULL,0,NULL,0),(948,'Dar Al Mozon National LLC  ','1-1-32',7,0,0,NULL,0,NULL,0),(949,'Oman Water & Wastewater Services Company','1-1-33',7,0,0,NULL,0,NULL,0),(950,'Mijan International LLC','1-1-34',7,0,0,NULL,0,NULL,0),(951,'Mada Green Line International Trade.& Cont. LLC','1-1-35',7,0,0,NULL,0,NULL,0),(952,'Abraj Energy Services SAOC','1-1-36',7,0,0,NULL,0,NULL,0),(953,'Loan','4-1-10',21,0,0,NULL,0,NULL,0),(954,'Kamal','1-1-37',7,0,0,NULL,0,NULL,0),(955,'Electricty Power Generation','1-1-38',7,0,0,NULL,0,NULL,0),(956,'AL FALAHY COMPANY LLC','1-1-39',7,0,0,NULL,0,NULL,0),(957,'China Geo-Engineering Corporation International Ltd','1-1-40',7,0,0,NULL,0,NULL,0),(958,'AGFA','1-1-41',7,0,0,NULL,0,NULL,0),(959,'Aqwat trading & contracting LLC','1-1-42',7,0,0,NULL,0,NULL,0),(960,'AL MUNAWARA LLC','1-1-43',7,0,0,NULL,0,NULL,0),(961,'AC Energy & Projects ','1-1-44',7,0,0,NULL,0,NULL,0),(962,'NAFAL CONTRACTING & TRADING CO.LLC','1-1-45',7,0,0,NULL,0,NULL,0),(963,'MODERN MUSCAT MOUNTAINS ','1-1-46',7,0,0,NULL,0,NULL,0),(964,'Al Gulnar Al Fawah Contracting Company','1-1-47',7,0,0,NULL,0,NULL,0),(965,'Bashair Nimr  International  LLC ','1-1-48',7,0,0,NULL,0,NULL,0),(966,'Al Majadeef Trading LLC','1-1-49',7,0,0,NULL,0,NULL,0),(967,'ALMEST CONTRACTING COMPANY LLC','1-1-50',7,0,0,NULL,0,NULL,0),(968,'Rawabi Bidbid Contracting','1-1-51',7,0,0,NULL,0,NULL,0),(969,'We Network LLC','1-1-52',7,0,0,NULL,0,NULL,0),(970,'LS Cable & System LTD (Oman Office)','1-1-53',7,0,0,NULL,0,NULL,0),(971,'Oman INTERNATIONAL TELECOMMNICATION CO LLC','1-1-54',7,0,0,NULL,0,NULL,0),(972,'Precision Skills International LLC','1-1-55',7,0,0,NULL,0,NULL,0),(973,'STRABAG Oman LLC','1-1-56',7,0,0,NULL,0,NULL,0),(974,'Sharaf DG','1-1-57',7,0,0,NULL,0,NULL,0),(975,'DEVELOPER FOR CONSTRUCTION & MINTENANCE','1-1-58',7,0,0,NULL,0,NULL,0),(976,'OMAN POST COMPANY','1-1-59',7,0,0,NULL,0,NULL,0),(977,'Beautiful Coast Co.LLC','1-1-60',7,0,0,NULL,0,NULL,0),(978,'Al Majadief international llc','1-1-61',7,0,0,NULL,0,NULL,0),(979,'AL KAMASHAKI OVERSEAS EST','1-1-62',7,0,0,NULL,0,NULL,0),(980,'Food','4-1-11',21,0,0,NULL,0,NULL,0),(981,'Asset','4-1-12',21,0,0,NULL,0,NULL,0),(982,'International Electric  Co ( oman)LLC','1-1-63',7,0,0,NULL,0,NULL,0),(983,'Salary','4-1-13',21,0,0,NULL,0,NULL,0),(984,'Ebrahim Engineering Services & Ent','1-1-64',7,0,0,NULL,0,NULL,0),(985,'SALASEL ELECTRIC SERVICES ','1-1-65',7,0,0,NULL,0,NULL,0),(986,'National Contracting Company','1-1-66',7,0,0,NULL,0,NULL,0),(987,'Limited Liability Company','1-1-67',7,0,0,NULL,0,NULL,0),(988,'National United CO LLC','1-1-68',7,0,0,NULL,0,NULL,0),(989,'SHROOQ SAMAIL TRADING','1-1-69',7,0,0,NULL,0,NULL,0),(990,'NAFAL CONTRACTING & TRADING CO.LLC','1-1-70',7,0,0,NULL,0,NULL,0),(991,'JAL ENGINEERING SERVICES LLC ','1-1-71',7,0,0,NULL,0,NULL,0),(992,'Fugro','1-1-72',7,0,0,NULL,0,NULL,0),(993,'INTERNATIONAL ENERGY AND INVESTMENT LLC','1-1-73',7,0,0,NULL,0,NULL,0),(994,'Global Chemicals & Maintenance Systems LLC','1-1-74',7,0,0,NULL,0,NULL,0),(995,'Falaj Al Qaria International Co LLC,','1-1-75',7,0,0,NULL,0,NULL,0),(996,'Venus Engineering Services L.L.C.','1-1-76',7,0,0,NULL,0,NULL,0),(997,'GULF UNIQUE SERVICE & TRADING ','1-1-77',7,0,0,NULL,0,NULL,0),(998,'Oman Chamber of Commerce and Industry','1-1-78',7,0,0,NULL,0,NULL,0),(999,'United Engineering Projects Co: L.L.C','1-1-79',7,0,0,NULL,0,NULL,0),(1000,'Azmir Engineering Contracting','1-1-80',7,0,0,NULL,0,NULL,0),(1001,'Spectral Link Business Solutions L.L.C','1-1-81',7,0,0,NULL,0,NULL,0),(1002,'Electro House International & Services LLC','1-1-82',7,0,0,NULL,0,NULL,0),(1003,' Falaj Al Qaria International Co LLC','1-1-83',7,0,0,NULL,0,NULL,0),(1004,'Sahool Naqsi  (SNT)','1-1-84',7,0,0,NULL,0,NULL,0),(1005,'Global Computer Services L.L.C','1-1-85',7,0,0,NULL,0,NULL,0),(1006,'TARGET TECHNICAL SERVICES ','1-1-86',7,0,0,NULL,0,NULL,0),(1007,'AL-SHAFAQ CONSTRUCTIONS CO','1-1-87',7,0,0,NULL,0,NULL,0),(1008,'Al Dhakiliyah Electrical ','1-1-88',7,0,0,NULL,0,NULL,0),(1009,'Mowred Engineering  Services ','1-1-89',7,0,0,NULL,0,NULL,0),(1010,'EASTERN OVERSEAS L.L.C,','1-1-90',7,0,0,NULL,0,NULL,0),(1011,'Azmir Engineering Contracting','1-1-91',7,0,0,NULL,0,NULL,0),(1012,'FAKHR MAZOON','1-1-92',7,0,0,NULL,0,NULL,0),(1013,'Telecommunications Consultants India Limited','1-1-93',7,0,0,NULL,0,NULL,0),(1014,'eCity for IT Services.','1-1-94',7,0,0,NULL,0,NULL,0),(1015,'LS Cable and System LTD ','1-1-95',7,0,0,NULL,0,NULL,0),(1016,'Global Business & Telecom ','1-1-96',7,0,0,NULL,0,NULL,0),(1017,'إنتاج ش م م','1-1-97',7,0,0,NULL,0,NULL,0),(1018,'ABU HILAL AL-RASHDI TRAD & CONT','1-1-98',7,0,0,NULL,0,NULL,0),(1019,'Nakhal developement company','1-1-99',7,0,0,NULL,0,NULL,0),(1020,'ARA Petroleum Oman B44 Limited ','1-1-100',7,0,0,NULL,0,NULL,0),(1021,'Oman Pumps Mfg. & Engineering Services Co. (SAOC)','1-1-101',7,0,0,NULL,0,NULL,0),(1022,'Al-Akhdar Company Trad','1-1-102',7,0,0,NULL,0,NULL,0),(1023,'Tasnee Metal Company LLC','1-1-103',7,0,0,NULL,0,NULL,0),(1024,'Shining Star Trading LLC','1-1-104',7,0,0,NULL,0,NULL,0),(1025,'SHABAB HASSAS CO LLC','1-1-105',7,0,0,NULL,0,NULL,0),(1026,'SAID ABDULLAH SAID AL RASHDI TRAD & CONT CO LLC','1-1-106',7,0,0,NULL,0,NULL,0),(1027,'Apex Energy LLC','1-1-107',7,0,0,NULL,0,NULL,0),(1028,'Desert Sand Mobile for Trading','1-1-108',7,0,0,NULL,0,NULL,0),(1029,'DAR AL-WAFA AL-SHAMILA ENT. CONS.','1-1-109',7,0,0,NULL,0,NULL,0),(1030,'Geomatics Middle East ','1-1-110',7,0,0,NULL,0,NULL,0),(1031,'Geomatics Middle East','2-1-6',13,0,0,NULL,0,NULL,0),(1032,'Lucky Stars For Investment SPC','1-1-111',7,0,0,NULL,0,NULL,0),(1033,'MAZOON Mining Company LLC','1-1-112',7,0,0,NULL,0,NULL,0),(1034,'Al Dosari Global L.L.C','1-1-113',7,0,0,NULL,0,NULL,0),(1035,'MUSCAT MODERN ENERGY TECHNOLOGY','1-1-114',7,0,0,NULL,0,NULL,0),(1036,'Towell Engineering Group','1-1-115',7,0,0,NULL,0,NULL,0),(1037,'Grey Wolf Trading LLC','1-1-116',7,0,0,NULL,0,NULL,0),(1038,'Musalih','1-1-117',7,0,0,NULL,0,NULL,0);

--
