--
-- Host: localhost    Database: teamwayomantelx_manufacturing
-- ------------------------------------------------------


--
-- Table structure for table `nizwa_packing_productsaccounts`
--

CREATE TABLE `nizwa_packing_productsaccounts` (
  `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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsaccounts`
--

INSERT INTO `nizwa_packing_productsaccounts` VALUES (1,'Assets','1',0,1,0,NULL,0,NULL,0),(2,'Non-Current Assets','1-1',1,0,0,NULL,0,NULL,0),(3,'Office Devices, Furniture and Fixtures','1-1-1',2,0,0,NULL,0,NULL,0),(4,'Office Devices, Furniture and Fixtures','1-1-1-1',3,0,0,NULL,0,NULL,0),(5,'Machinery, Tools & Equipments','1-1-2',2,0,0,NULL,0,NULL,0),(6,'Machinery, Tools & Equipments','1-1-2-1',5,0,0,NULL,0,NULL,0),(7,'Motor Vehicles','1-1-3',2,0,0,NULL,0,NULL,0),(8,'Motor Vehicles','1-1-3-1',7,0,0,NULL,0,NULL,0),(9,'Long Term Investments ','1-1-4',2,0,0,NULL,0,NULL,0),(10,'Long Term Investments ','1-1-4-1',9,0,0,NULL,0,NULL,0),(11,'Intangible Assets','1-1-5',2,0,0,NULL,0,NULL,0),(12,'Intangible Assets','1-1-5-1',11,0,0,NULL,0,NULL,0),(13,'Current Assets','1-2',1,0,0,NULL,0,NULL,0),(14,'Employees Payments','1-2-1',13,0,0,NULL,0,NULL,0),(15,'Employees loans','1-2-1-1',14,0,0,NULL,0,NULL,0),(16,'Employees petty cash','1-2-1-2',14,0,0,NULL,0,NULL,0),(17,'Inventories','1-2-2',13,0,0,NULL,0,NULL,0),(18,'Default Inventory','1-2-2-1',17,0,0,NULL,0,NULL,0),(19,'Account Receivable - Customers','1-2-3',13,0,0,NULL,0,NULL,0),(20,'Account Receivable - Cheques On Hand','1-2-4',13,0,0,NULL,0,NULL,0),(21,'PDC Receivable','1-2-4-1',20,0,0,NULL,0,NULL,0),(22,'RD Receivable Cheques','1-2-4-2',20,0,0,NULL,0,NULL,0),(23,'Legal Cheques','1-2-4-3',20,0,0,NULL,0,NULL,0),(24,'Cash-On-Hand(Safes)','1-2-5',13,0,0,NULL,0,NULL,0),(25,'Bank Accounts','1-2-6',13,0,0,NULL,0,NULL,0),(26,'Deferred Taxes','1-2-7',13,0,0,NULL,0,NULL,0),(27,'VAT-In','1-2-7-1',26,0,0,NULL,0,NULL,0),(28,'Liabilities','2',0,1,0,NULL,0,NULL,0),(29,'Non-Current Liability','2-1',28,0,0,NULL,0,NULL,0),(30,'Mortgage Loan Payable','2-1-1',29,0,0,NULL,0,NULL,0),(31,'Mortgage Loan Payable','2-1-1-1',30,0,0,NULL,0,NULL,0),(32,'Othor -Longe term - Liabilities','2-1-2',29,0,0,NULL,0,NULL,0),(33,'Othor -Longe term - Liabilities','2-1-2-1',32,0,0,NULL,0,NULL,0),(34,'Deferred Taxes','2-1-3',29,0,0,NULL,0,NULL,0),(35,'VAT-Out','2-1-3-1',34,0,0,NULL,0,NULL,0),(36,'Current Liability','2-2',28,0,0,NULL,0,NULL,0),(37,'Account Payables - Suppliers','2-2-1',36,0,0,NULL,0,NULL,0),(38,'Accumulated Depreciation ','2-2-2',36,0,0,NULL,0,NULL,0),(39,'Accumulated Depreciation ','2-2-2-1',38,0,0,NULL,0,NULL,0),(40,'Service Providers','2-2-3',36,0,0,NULL,0,NULL,0),(41,'Default Service Provider','2-2-3-1',40,0,0,NULL,0,NULL,0),(42,'Account Payable - Cheques','2-2-4',36,0,0,NULL,0,NULL,0),(43,'PDC Payables','2-2-4-1',42,0,0,NULL,0,NULL,0),(44,'RD Payables Cheques','2-2-4-2',43,0,0,NULL,0,NULL,0),(45,'Employees Payments','2-2-5',36,0,0,NULL,0,NULL,0),(46,'Payable Salaries','2-2-5-1',45,0,0,NULL,0,NULL,0),(47,'Equity','3',0,1,0,NULL,0,NULL,0),(48,'Owners Equity','3-1',47,0,0,NULL,0,NULL,0),(49,'SHARE HOLDERS A/C','3-1-1',48,0,0,NULL,0,NULL,0),(50,'SHARE HOLDERS A/C','3-1-1-1',49,0,0,NULL,0,NULL,0),(51,'OWNER CURRENT A/C','3-1-2',48,0,0,NULL,0,NULL,0),(52,'OWNER CURRENT A/C','3-1-2-1',51,0,0,NULL,0,NULL,0),(53,'PROFIT & LOSS A/C','3-1-3',48,0,0,NULL,0,NULL,0),(54,'Retained Profit & Loss','3-1-3-1',53,0,0,NULL,0,NULL,0),(55,'Current Profit & Loss','3-1-3-2',53,0,0,NULL,0,NULL,0),(56,'Expenses','4',0,1,0,NULL,0,NULL,0),(57,'Direct Expenses','4-1',56,0,0,NULL,0,NULL,0),(58,'Sales Returns And Allowances','4-1-1',57,0,0,NULL,0,NULL,0),(59,'Sales Returns','4-1-1-1',58,0,0,NULL,0,NULL,0),(60,'Sales Discount','4-1-1-2',58,0,0,NULL,0,NULL,0),(61,'Cost of Revenue','4-1-2',57,0,0,NULL,0,NULL,0),(62,'Default Cost Of Good Sold','4-1-2-1',61,0,0,NULL,0,NULL,0),(63,'Indirect Expenses','4-2',56,0,0,NULL,0,NULL,0),(64,'Employees & Benefits Expenses','4-2-1',63,0,0,NULL,0,NULL,0),(65,'Salaries','4-2-1-1',64,0,0,NULL,0,NULL,0),(66,'Advance Salaries','4-2-1-2',64,0,0,NULL,0,NULL,0),(67,'Income','5',0,1,0,NULL,0,NULL,0),(68,'Direct Income','5-1',67,0,0,NULL,0,NULL,0),(69,'Sales Revenue','5-1-1',68,0,0,NULL,0,NULL,0),(70,'Default Sales','5-1-1-1',69,0,0,NULL,0,NULL,0),(71,'Indirect Income','5-2',67,0,0,NULL,0,NULL,0),(72,'Other Revenue','5-2-1',71,0,0,NULL,0,NULL,0),(73,'Other Revenue','5-2-1-1',72,0,0,NULL,0,NULL,0),(74,'GIT','1-2-8',13,0,0,NULL,0,NULL,0),(75,'Default Git','1-2-8-1',74,0,0,NULL,0,NULL,0),(76,'Client 1','1-2-3-1',19,0,0,NULL,0,NULL,0),(77,'Test Bank','1-2-6-1',25,0,0,'Test Bank',NULL,NULL,0),(78,'TetraObject','2-2-1-1',37,0,0,NULL,0,NULL,0),(79,'Save 1','1-2-5-1',24,0,0,'',NULL,NULL,0),(80,'Intelligent Projects 12','1-2-3-2',19,0,0,NULL,0,NULL,0),(81,'bank 2','1-2-6-2',25,0,0,'',NULL,NULL,0),(82,'bank 3','1-2-6-3',25,0,0,'',NULL,NULL,0),(83,'Ex Cat1','4-1-3',57,0,0,NULL,0,NULL,0),(84,'item type','4-1-3-1',83,0,0,NULL,0,NULL,0),(85,'Ahmed','1-2-3-3',19,0,0,NULL,0,NULL,0),(86,'Ammar','1-2-3-4',19,0,0,NULL,0,NULL,0),(87,'Ali','1-2-3-5',19,0,0,NULL,0,NULL,0),(88,'naning','2-2-1-2',37,0,0,NULL,0,NULL,0),(89,'Hamed M','1-2-3-6',19,0,0,NULL,0,NULL,0),(90,'SHIHAB AL KALBANI','1-2-3-7',19,0,0,NULL,0,NULL,0),(91,'ahmed','1-2-3-8',19,0,0,NULL,0,NULL,0),(92,'lumber world','2-2-1-3',37,0,0,NULL,0,NULL,0),(93,'golden torch','2-2-1-4',37,0,0,NULL,0,NULL,0);

--
-- Table structure for table `nizwa_packing_productsactivity_logs`
--

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

--
-- Dumping data for table `nizwa_packing_productsactivity_logs`
--

INSERT INTO `nizwa_packing_productsactivity_logs` VALUES (1,'2023-03-21 09:47:37',1,'created','clients','',1,NULL,'',0,'',0,0),(2,'2023-03-21 09:47:37',1,'created','estimates','',1,NULL,'',0,'',0,0),(3,'2023-03-21 09:50:48',1,'created','clients','',2,NULL,'',0,'',0,0),(4,'2023-03-21 09:50:48',1,'updated','clients','',2,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:91;}}','',0,'',0,0),(5,'2023-03-21 09:52:02',1,'created','item_categories','',32,NULL,'',0,'',0,0),(6,'2023-03-21 09:52:11',1,'created','item_categories','',33,NULL,'',0,'',0,0),(7,'2023-03-21 09:52:20',1,'created','item_categories','',34,NULL,'',0,'',0,0),(8,'2023-03-21 09:52:27',1,'created','item_categories','',35,NULL,'',0,'',0,0),(9,'2023-03-21 09:52:37',1,'created','item_categories','',36,NULL,'',0,'',0,0),(10,'2023-03-21 09:58:25',1,'created','items','',1,NULL,'',0,'',0,0),(11,'2023-03-21 09:59:36',1,'created','items','',2,NULL,'',0,'',0,0),(12,'2023-03-21 10:00:19',1,'created','items','',3,NULL,'',0,'',0,0),(13,'2023-03-21 10:01:24',1,'created','item_categories','',37,NULL,'',0,'',0,0),(14,'2023-03-21 10:02:15',1,'updated','item_categories','',34,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:10:\"chemichals\";s:2:\"to\";s:5:\"doors\";}}','',0,'',0,0),(15,'2023-03-21 10:05:05',1,'created','items','',4,NULL,'',0,'',0,0),(16,'2023-03-21 10:06:00',1,'created','items','',5,NULL,'',0,'',0,0),(17,'2023-03-21 10:09:28',1,'created','estimates','',2,NULL,'',0,'',0,0),(18,'2023-03-21 10:10:40',1,'created','estimate_items','',1,NULL,'',0,'',0,0),(19,'2023-03-21 10:11:35',1,'created','estimate_items','',2,NULL,'',0,'',0,0),(20,'2023-03-21 10:13:08',1,'created','estimate_items','',3,NULL,'',0,'',0,0),(21,'2023-03-21 10:13:41',1,'updated','estimate_items','',1,'a:1:{s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(22,'2023-03-21 10:15:36',1,'updated','estimate_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";i:2;}s:5:\"total\";a:2:{s:4:\"from\";s:2:\"60\";s:2:\"to\";i:120;}}','',0,'',0,0),(23,'2023-03-21 10:15:36',1,'updated','estimate_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";i:3;}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"120\";s:2:\"to\";i:180;}}','',0,'',0,0),(24,'2023-03-21 10:15:37',1,'updated','estimate_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";i:4;}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"180\";s:2:\"to\";i:240;}}','',0,'',0,0),(25,'2023-03-21 10:15:38',1,'updated','estimate_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";i:5;}s:5:\"total\";a:2:{s:4:\"from\";s:3:\"240\";s:2:\"to\";i:300;}}','',0,'',0,0),(26,'2023-03-21 10:17:16',1,'deleted','estimate_items','',2,NULL,'',0,NULL,NULL,0),(27,'2023-03-21 10:19:20',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(28,'2023-03-21 10:21:29',1,'updated','estimates','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:8:\"accepted\";}}','',0,'',0,0),(29,'2023-03-21 10:26:27',1,'created','invoices','',1,NULL,'',0,'',0,0),(30,'2023-03-21 10:28:19',1,'updated','invoices','',1,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(31,'2023-03-21 10:29:52',1,'updated','invoices','',1,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(32,'2023-03-21 10:31:29',1,'created','invoices','',2,NULL,'',0,'',0,0),(33,'2023-03-21 10:31:51',1,'created','invoice_items','',1,NULL,'',0,'',0,0),(34,'2023-03-21 10:32:19',1,'updated','invoices','',2,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(35,'2023-03-21 10:33:04',1,'updated','invoices','',2,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(36,'2023-03-21 10:33:04',1,'created','job_orders','',1,NULL,'',0,'',0,0),(37,'2023-03-21 10:40:30',1,'created','invoices','',3,NULL,'',0,'',0,0),(38,'2023-03-21 10:40:30',1,'updated','invoices','',3,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(39,'2023-03-21 10:40:30',1,'created','invoice_items','',2,NULL,'',0,'',0,0),(40,'2023-03-21 10:40:30',1,'created','invoice_items','',3,NULL,'',0,'',0,0),(41,'2023-03-21 10:42:30',1,'updated','estimates','',2,'a:1:{s:10:\"project_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:1;}}','',0,'',0,0),(42,'2023-03-21 10:50:29',1,'created','invoice_payments','',1,NULL,'',0,'',0,0),(43,'2023-03-21 10:50:29',1,'updated','invoices','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(44,'2023-03-21 10:50:38',1,'updated','invoice_payments','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(45,'2023-03-21 10:50:38',1,'updated','invoice_payments','',1,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:57;}}','',0,'',0,0),(46,'2023-03-21 10:52:02',1,'created','invoice_payments','',2,NULL,'',0,'',0,0),(47,'2023-03-21 10:52:07',1,'updated','invoice_payments','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(48,'2023-03-21 10:52:07',1,'updated','invoice_payments','',2,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:58;}}','',0,'',0,0),(49,'2023-03-21 10:53:42',1,'updated','job_orders','',1,'a:7:{s:20:\"scheduled_start_date\";a:2:{s:4:\"from\";N;s:2:\"to\";s:10:\"2023-03-21\";}s:17:\"expected_duration\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"5\";}s:8:\"priority\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"1\";}s:13:\"current_stage\";a:2:{s:4:\"from\";N;s:2:\"to\";s:11:\"In Progress\";}s:11:\"team_member\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"0\";}s:10:\"total_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:3:\"NaN\";}s:9:\"worksheet\";a:2:{s:4:\"from\";N;s:2:\"to\";s:6:\"a:0:{}\";}}','',0,'',0,0),(50,'2023-03-21 10:53:42',1,'created','materials_bill','',1,NULL,'',0,'',0,0),(51,'2023-03-21 10:54:57',1,'updated','job_orders','',1,'a:2:{s:14:\"operation_cost\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:0:\"\";}s:10:\"total_cost\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:3:\"NaN\";}}','',0,'',0,0),(52,'2023-03-21 10:54:57',1,'created','materials_bill','',2,NULL,'',0,'',0,0),(53,'2023-03-21 10:54:57',1,'created','materials_bill','',3,NULL,'',0,'',0,0),(54,'2023-03-21 10:54:57',1,'created','materials_bill','',4,NULL,'',0,'',0,0),(55,'2023-03-21 10:58:35',1,'updated','job_orders','',1,'a:2:{s:11:\"team_member\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}s:10:\"total_cost\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:3:\"152\";}}','',0,'',0,0),(56,'2023-03-21 10:58:35',1,'created','materials_bill','',5,NULL,'',0,'',0,0),(57,'2023-03-21 10:58:35',1,'created','materials_bill','',6,NULL,'',0,'',0,0),(58,'2023-03-21 10:58:35',1,'created','materials_bill','',7,NULL,'',0,'',0,0),(59,'2023-03-21 11:00:09',1,'updated','invoices','',2,'a:1:{s:11:\"sale_status\";a:2:{s:4:\"from\";s:7:\"Pending\";s:2:\"to\";s:5:\"Ready\";}}','',0,'',0,0),(60,'2023-03-21 11:00:10',1,'updated','invoices','',1,'a:1:{s:11:\"sale_status\";a:2:{s:4:\"from\";s:7:\"Pending\";s:2:\"to\";s:11:\"In Progress\";}}','',0,'',0,0),(61,'2023-03-21 11:05:12',1,'created','suppliers','',4,NULL,'',0,'',0,0),(62,'2023-03-21 11:05:12',1,'updated','suppliers','',4,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:92;}}','',0,'',0,0),(63,'2023-03-21 11:05:33',1,'created','suppliers','',5,NULL,'',0,'',0,0),(64,'2023-03-21 11:05:33',1,'updated','suppliers','',5,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:93;}}','',0,'',0,0),(65,'2023-03-21 11:07:23',1,'created','purchase_orders','',1,NULL,'',0,'',0,0),(66,'2023-03-21 11:08:10',1,'created','purchase_order_items','',1,NULL,'',0,'',0,0),(67,'2023-03-21 11:08:10',1,'created','purchase_order_items','',2,NULL,'',0,'',0,0),(68,'2023-03-21 11:08:10',1,'created','purchase_order_items','',3,NULL,'',0,'',0,0),(69,'2023-03-21 11:08:21',1,'updated','purchase_order_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";i:2;}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"15.5\";s:2:\"to\";d:31;}}','',0,'',0,0),(70,'2023-03-21 11:08:24',1,'updated','purchase_order_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";i:3;}s:5:\"total\";a:2:{s:4:\"from\";s:2:\"31\";s:2:\"to\";d:46.5;}}','',0,'',0,0),(71,'2023-03-21 11:08:26',1,'updated','purchase_order_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";i:2;}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"46.5\";s:2:\"to\";d:31;}}','',0,'',0,0),(72,'2023-03-21 11:08:27',1,'updated','purchase_order_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";i:1;}s:5:\"total\";a:2:{s:4:\"from\";s:2:\"31\";s:2:\"to\";d:15.5;}}','',0,'',0,0),(73,'2023-03-21 11:08:33',1,'updated','purchase_order_items','',1,'a:2:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";i:2;}s:5:\"total\";a:2:{s:4:\"from\";s:4:\"15.5\";s:2:\"to\";d:31;}}','',0,'',0,0),(74,'2023-03-21 11:10:49',1,'updated','purchase_order_items','',1,'a:3:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:1:\"5\";}s:5:\"total\";a:2:{s:4:\"from\";s:2:\"31\";s:2:\"to\";d:77.5;}s:6:\"tax_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}}','',0,'',0,0),(75,'2023-03-21 11:13:16',1,'updated','purchase_orders','',1,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(76,'2023-03-21 11:14:48',1,'created','purchase_order_payments','',1,NULL,'',0,'',0,0),(77,'2023-03-21 11:14:48',1,'updated','purchase_orders','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(78,'2023-03-21 11:14:57',1,'updated','purchase_order_payments','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(79,'2023-03-21 11:14:57',1,'updated','purchase_order_payments','',1,'a:1:{s:14:\"transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:60;}}','',0,'',0,0),(80,'2023-03-21 11:17:38',1,'created','shipments','',1,NULL,'',0,'',0,0),(81,'2023-03-21 11:17:38',1,'created','shipment_items','',1,NULL,'',0,'',0,0),(82,'2023-03-21 11:17:38',1,'created','shipment_items','',2,NULL,'',0,'',0,0),(83,'2023-03-21 11:17:38',1,'created','shipment_items','',3,NULL,'',0,'',0,0),(84,'2023-03-21 11:17:48',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"5\";s:2:\"to\";i:4;}}','',0,'',0,0),(85,'2023-03-21 11:17:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";i:3;}}','',0,'',0,0),(86,'2023-03-21 11:17:54',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";i:2;}}','',0,'',0,0),(87,'2023-03-21 11:17:57',1,'updated','shipments','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";N;s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(88,'2023-03-21 11:20:27',1,'created','task','design',1,NULL,'project',1,'',0,0),(89,'2023-03-21 11:20:41',1,'updated','task','design',1,'a:2:{s:4:\"sort\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:8:\"10000000\";}s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";s:1:\"2\";}}','project',1,'',0,0),(90,'2023-03-21 11:20:42',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:1:\"3\";}}','project',1,'',0,0),(91,'2023-03-21 11:20:43',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";s:1:\"4\";}}','project',1,'',0,0),(92,'2023-03-21 11:20:45',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";s:1:\"3\";}}','project',1,'',0,0),(93,'2023-03-21 11:20:46',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";s:1:\"2\";}}','project',1,'',0,0),(94,'2023-03-21 11:20:54',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:1:\"3\";}}','project',1,'',0,0),(95,'2023-03-21 11:21:01',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";s:1:\"4\";}}','project',1,'',0,0),(96,'2023-03-21 11:21:04',1,'updated','task','design',1,'a:1:{s:9:\"status_id\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";s:1:\"1\";}}','project',1,'',0,0),(97,'2023-05-14 11:49:55',1,'created','invoices','',4,NULL,'',0,'',0,0),(98,'2023-05-14 11:51:44',1,'created','items','',6,NULL,'',0,'',0,0),(99,'2023-05-14 11:52:15',1,'created','items','',7,NULL,'',0,'',0,0),(100,'2023-05-14 11:52:54',1,'deleted','invoices','',4,NULL,'',0,NULL,NULL,0),(101,'2023-05-14 11:53:04',1,'created','invoices','',5,NULL,'',0,'',0,0),(102,'2023-05-14 11:53:11',1,'created','invoice_items','',4,NULL,'',0,'',0,0),(103,'2023-05-14 11:53:16',1,'updated','invoices','',5,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(104,'2023-05-14 11:53:28',1,'updated','invoices','',5,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(105,'2023-05-14 11:53:28',1,'created','job_orders','',2,NULL,'',0,'',0,0),(106,'2023-05-14 11:54:04',1,'created','invoices','',6,NULL,'',0,'',0,0),(107,'2023-05-14 12:01:51',1,'created','invoices','',7,NULL,'',0,'',0,0),(108,'2023-05-14 12:02:28',1,'created','invoice_items','',5,NULL,'',0,'',0,0),(109,'2023-05-14 12:02:34',1,'updated','invoices','',7,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(110,'2023-05-14 12:02:46',1,'updated','invoices','',7,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(111,'2023-05-14 12:02:46',1,'created','job_orders','',3,NULL,'',0,'',0,0),(112,'2023-05-14 12:04:16',1,'updated','job_orders','',3,'a:6:{s:8:\"priority\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"1\";}s:13:\"current_stage\";a:2:{s:4:\"from\";N;s:2:\"to\";s:11:\"In Progress\";}s:11:\"team_member\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"0\";}s:14:\"operation_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"5\";}s:10:\"total_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:4:\"1005\";}s:9:\"worksheet\";a:2:{s:4:\"from\";N;s:2:\"to\";s:6:\"a:0:{}\";}}','',0,'',0,0),(113,'2023-05-14 12:04:16',1,'created','materials_bill','',8,NULL,'',0,'',0,0),(114,'2023-09-07 12:03:18',1,'created','invoices','',8,NULL,'',0,'',0,0),(115,'2023-09-07 12:03:32',1,'created','invoice_items','',6,NULL,'',0,'',0,0),(116,'2023-09-07 12:03:35',1,'updated','invoices','',8,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(117,'2023-09-07 12:04:00',1,'updated','invoices','',8,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(118,'2023-09-07 12:04:00',1,'created','job_orders','',4,NULL,'',0,'',0,0),(119,'2023-09-07 12:04:00',1,'created','materials_bill','',9,NULL,'',0,'',0,0),(120,'2023-09-07 12:04:00',1,'created','materials_bill','',10,NULL,'',0,'',0,0),(121,'2023-09-07 12:04:00',1,'created','materials_bill','',11,NULL,'',0,'',0,0),(122,'2023-09-07 12:04:56',1,'updated','job_orders','',4,'a:8:{s:20:\"scheduled_start_date\";a:2:{s:4:\"from\";N;s:2:\"to\";s:10:\"2023-09-07\";}s:15:\"actual_duration\";a:2:{s:4:\"from\";N;s:2:\"to\";s:10:\"2023-09-21\";}s:8:\"priority\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"1\";}s:13:\"current_stage\";a:2:{s:4:\"from\";N;s:2:\"to\";s:11:\"In Progress\";}s:11:\"team_member\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"1\";}s:14:\"operation_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:2:\"20\";}s:10:\"total_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:3:\"152\";}s:9:\"worksheet\";a:2:{s:4:\"from\";N;s:2:\"to\";s:6:\"a:0:{}\";}}','',0,'',0,0),(123,'2023-09-07 12:04:56',1,'created','materials_bill','',12,NULL,'',0,'',0,0),(124,'2023-09-07 12:04:56',1,'created','materials_bill','',13,NULL,'',0,'',0,0),(125,'2023-09-07 12:04:56',1,'created','materials_bill','',14,NULL,'',0,'',0,0),(126,'2023-09-07 12:06:49',1,'created','estimates','',3,NULL,'',0,'',0,0),(127,'2023-09-07 12:06:59',1,'updated','estimates','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(128,'2023-09-07 12:07:04',1,'updated','estimates','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(129,'2023-09-07 12:07:16',1,'created','estimate_items','',4,NULL,'',0,'',0,0),(130,'2023-09-07 12:07:20',1,'updated','estimates','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(131,'2023-09-07 12:07:26',1,'updated','estimates','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:8:\"accepted\";}}','',0,'',0,0),(132,'2023-09-07 12:59:32',1,'created','estimates','',4,NULL,'',0,'',0,0),(133,'2023-09-07 13:01:35',1,'created','estimate_items','',5,NULL,'',0,'',0,0),(134,'2023-09-07 13:01:44',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(135,'2023-09-07 13:02:21',1,'updated','estimates','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:8:\"accepted\";}}','',0,'',0,0),(136,'2023-09-07 13:02:36',1,'created','invoices','',9,NULL,'',0,'',0,0),(137,'2023-09-07 13:02:36',1,'updated','invoices','',9,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(138,'2023-09-07 13:02:36',1,'created','invoice_items','',7,NULL,'',0,'',0,0),(139,'2023-09-07 13:03:27',1,'updated','invoices','',9,'a:1:{s:14:\"confirm_status\";a:2:{s:4:\"from\";s:13:\"not_confirmed\";s:2:\"to\";s:9:\"confirmed\";}}','',0,'',0,0),(140,'2023-09-07 13:03:27',1,'created','job_orders','',5,NULL,'',0,'',0,0),(141,'2023-09-07 13:03:27',1,'created','materials_bill','',15,NULL,'',0,'',0,0),(142,'2023-09-07 13:03:27',1,'created','materials_bill','',16,NULL,'',0,'',0,0),(143,'2023-09-07 13:03:27',1,'created','materials_bill','',17,NULL,'',0,'',0,0),(144,'2023-09-07 13:04:58',1,'created','invoice_payments','',3,NULL,'',0,'',0,0),(145,'2023-09-07 13:04:58',1,'updated','invoices','',9,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(146,'2023-09-07 13:05:10',1,'updated','invoice_payments','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(147,'2023-09-07 13:05:10',1,'updated','invoice_payments','',3,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:66;}}','',0,'',0,0),(148,'2023-09-07 13:06:20',1,'created','invoice_payments','',4,NULL,'',0,'',0,0),(149,'2023-09-07 13:06:31',1,'updated','invoice_payments','',4,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(150,'2023-09-07 13:06:31',1,'updated','invoice_payments','',4,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:67;}}','',0,'',0,0),(151,'2023-09-07 13:09:14',1,'updated','job_orders','',5,'a:9:{s:20:\"scheduled_start_date\";a:2:{s:4:\"from\";N;s:2:\"to\";s:10:\"2023-09-07\";}s:17:\"expected_duration\";a:2:{s:4:\"from\";N;s:2:\"to\";s:2:\"30\";}s:15:\"actual_duration\";a:2:{s:4:\"from\";N;s:2:\"to\";s:9:\"2023-10-7\";}s:8:\"priority\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"1\";}s:13:\"current_stage\";a:2:{s:4:\"from\";N;s:2:\"to\";s:11:\"In Progress\";}s:11:\"team_member\";a:2:{s:4:\"from\";N;s:2:\"to\";s:1:\"0\";}s:14:\"operation_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:3:\"100\";}s:10:\"total_cost\";a:2:{s:4:\"from\";N;s:2:\"to\";s:3:\"232\";}s:9:\"worksheet\";a:2:{s:4:\"from\";N;s:2:\"to\";s:6:\"a:0:{}\";}}','',0,'',0,0),(152,'2023-09-07 13:09:14',1,'created','materials_bill','',18,NULL,'',0,'',0,0),(153,'2023-09-07 13:09:14',1,'created','materials_bill','',19,NULL,'',0,'',0,0),(154,'2023-09-07 13:09:14',1,'created','materials_bill','',20,NULL,'',0,'',0,0),(155,'2023-09-07 13:16:04',1,'updated','job_orders','',4,'a:1:{s:13:\"current_stage\";a:2:{s:4:\"from\";s:11:\"In Progress\";s:2:\"to\";s:8:\"Finished\";}}','',0,'',0,0),(156,'2023-09-07 13:16:04',1,'created','materials_bill','',21,NULL,'',0,'',0,0),(157,'2023-09-07 13:16:04',1,'created','materials_bill','',22,NULL,'',0,'',0,0),(158,'2023-09-07 13:16:04',1,'created','materials_bill','',23,NULL,'',0,'',0,0);

--
-- Table structure for table `nizwa_packing_productsannouncements`
--

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


--
-- Table structure for table `nizwa_packing_productsattendance`
--

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


--
-- Table structure for table `nizwa_packing_productsbudgeting`
--

CREATE TABLE `nizwa_packing_productsbudgeting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `estimate_request_id` int(11) NOT NULL DEFAULT '0',
  `estimate_date` date NOT NULL,
  `valid_until` date DEFAULT 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 DEFAULT NULL,
  `discount_amount` double DEFAULT NULL,
  `profit` double DEFAULT NULL,
  `discount_amount_type` enum('percentage','fixed_amount') COLLATE utf8_unicode_ci DEFAULT NULL,
  `project_id` int(11) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsbudgeting`
--


--
-- Table structure for table `nizwa_packing_productsbudgeting_forms`
--

CREATE TABLE `nizwa_packing_productsbudgeting_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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsbudgeting_forms`
--


--
-- Table structure for table `nizwa_packing_productsbudgeting_items`
--

CREATE TABLE `nizwa_packing_productsbudgeting_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,
  `estimate_id` int(11) NOT NULL,
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  `quotation_uom` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `quotation_quantity` double DEFAULT NULL,
  `item_price` double DEFAULT NULL,
  `quotation_selling_rate` double DEFAULT NULL,
  `quotation_total` double DEFAULT NULL,
  `cost_uom` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cost_quantity` double DEFAULT NULL,
  `cost_rate` double DEFAULT NULL,
  `cost_total` double DEFAULT NULL,
  `material_cost` double DEFAULT NULL,
  `labour_cost` double DEFAULT NULL,
  `machinery` double DEFAULT NULL,
  `others` double DEFAULT NULL,
  `profit` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsbudgeting_items`
--


--
-- Table structure for table `nizwa_packing_productsbudgeting_requests`
--

CREATE TABLE `nizwa_packing_productsbudgeting_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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsbudgeting_requests`
--


--
-- Table structure for table `nizwa_packing_productschecklist_items`
--

CREATE TABLE `nizwa_packing_productschecklist_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 `nizwa_packing_productschecklist_items`
--


--
-- Table structure for table `nizwa_packing_productsci_sessions`
--

CREATE TABLE `nizwa_packing_productsci_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 `nizwa_packing_productsci_sessions`
--

INSERT INTO `nizwa_packing_productsci_sessions` VALUES ('a86684d44f65534fdc92b4e3488cdb0072cba8a9','161.8.109.180',1678110515,_binary '__ci_last_regenerate|i:1678110463;user_id|s:1:\"1\";'),('c0c839159e862eb0bfdb1621699bd16ce8772998','145.255.120.16',1678110473,''),('2c39465401c26732b1d5edf49b7d37b1f875f835','161.8.109.180',1678110594,_binary '__ci_last_regenerate|i:1678110594;'),('413941feccbc195441fc35e97cc7e312ef160237','161.8.109.180',1678110594,_binary '__ci_last_regenerate|i:1678110594;'),('99d891e3a59bb5fa98095b03474729dec338ec0c','145.255.120.72',1678187516,_binary '__ci_last_regenerate|i:1678187516;'),('851d0274e8532164f8f6fe7fc5ddc7517c06a292','161.8.109.180',1679307578,_binary '__ci_last_regenerate|i:1679307578;'),('08ae336edde12ec555849e0dd39cf2dc829bd327','161.8.109.180',1679307578,_binary '__ci_last_regenerate|i:1679307578;'),('4b0ce507f94bfc281456742bfab939cdd8911455','5.32.215.203',1679321712,_binary '__ci_last_regenerate|i:1679321604;user_id|s:1:\"1\";'),('8a2c062bd556214ac4705f35e044a2ee8b5d6349','161.8.109.180',1679392030,_binary '__ci_last_regenerate|i:1679392030;user_id|s:1:\"1\";'),('3be14a024a4cece2d861472b1832c8cf2658d7f9','161.8.109.180',1679392363,_binary '__ci_last_regenerate|i:1679392363;user_id|s:1:\"1\";'),('d6a40a5dbac3950d0f43b228e7c7d550528b6f76','161.8.109.180',1679392871,_binary '__ci_last_regenerate|i:1679392871;user_id|s:1:\"1\";'),('5577932fca21cdd05fe5c3937c4edd446522f213','161.8.109.180',1679393172,_binary '__ci_last_regenerate|i:1679393172;user_id|s:1:\"1\";'),('75ceaeb7674d47f4ec678d4ecd63a76ba22c5a9d','161.8.109.180',1679393496,_binary '__ci_last_regenerate|i:1679393496;user_id|s:1:\"1\";'),('a14d50f5e92d838a4d9b5600f28ffda5b7ba0b38','161.8.109.180',1679393869,_binary '__ci_last_regenerate|i:1679393869;user_id|s:1:\"1\";'),('f556822992c5639ca59977f8281ecbc52c28c803','161.8.109.180',1679394216,_binary '__ci_last_regenerate|i:1679394216;user_id|s:1:\"1\";'),('659d08e45ef4ca941b493d375f588433fef14296','161.8.109.180',1679394517,_binary '__ci_last_regenerate|i:1679394517;user_id|s:1:\"1\";'),('9e9be5437f5e1d4f5d16a15e93c79d79b53224ef','161.8.109.180',1679394822,_binary '__ci_last_regenerate|i:1679394822;user_id|s:1:\"1\";'),('ec8522becf384fed849ceede4e597e6a1fb08145','161.8.109.180',1679395143,_binary '__ci_last_regenerate|i:1679395143;user_id|s:1:\"1\";'),('ca6832c0b7912d607aa8827c6e0cdbce89f364d6','161.8.109.180',1679395792,_binary '__ci_last_regenerate|i:1679395792;user_id|s:1:\"1\";'),('aa0b565281fee00e2ecd3e33bbc00f8dece386b8','161.8.109.180',1679395192,_binary '__ci_last_regenerate|i:1679395151;'),('7899d70d263040d431c7e1196100d5531cf1da89','88.208.229.43',1679397764,_binary '__ci_last_regenerate|i:1679395205;user_id|s:1:\"1\";'),('330a078c32c9142aa76427f494e938d52f4ab77f','54.38.214.107',1679395350,_binary '__ci_last_regenerate|i:1679395350;'),('58f298d701c127a4aa336ff4ac2bb1698722660c','161.8.109.180',1679396098,_binary '__ci_last_regenerate|i:1679396098;user_id|s:1:\"1\";'),('48090b13bc8b318020bef50c7a28bb111fc1aadc','54.38.214.107',1679395829,_binary '__ci_last_regenerate|i:1679395829;'),('25a0029b3b6a7f6e039557647eefb048c2096d93','54.38.214.107',1679395922,_binary '__ci_last_regenerate|i:1679395922;'),('852cf750bd441b29bc365318e6680f419128443d','161.8.109.180',1679396401,_binary '__ci_last_regenerate|i:1679396401;user_id|s:1:\"1\";'),('deb4c8c3828263d471001b3a3803c106976eaa35','161.8.109.180',1679396758,_binary '__ci_last_regenerate|i:1679396758;user_id|s:1:\"1\";'),('a5711e1c52f365c06ceea3e2f3291bd73b12bcc4','54.38.214.107',1679396409,_binary '__ci_last_regenerate|i:1679396409;'),('a573dc6adf3017fa8ed4a781f8ebbf4cd340243d','54.38.214.107',1679396411,_binary '__ci_last_regenerate|i:1679396410;'),('eb6accadf5354a63e63e0911b5ca84ceb4998602','161.8.109.180',1679397196,_binary '__ci_last_regenerate|i:1679397196;user_id|s:1:\"1\";'),('fd9307b8815ab107ac6a4243a0372c5447f433b8','161.8.109.180',1679397591,_binary '__ci_last_regenerate|i:1679397591;user_id|s:1:\"1\";'),('1a6040a61a36e2c18bf46f68590b5d2bd562ec8e','54.38.214.107',1679397288,_binary '__ci_last_regenerate|i:1679397288;'),('98230f7ed177789fb3c0da8e5021efe97808f038','54.38.214.107',1679397627,_binary '__ci_last_regenerate|i:1679397627;'),('90edd384eb9817192c20339cd0f843a090dd2790','54.38.214.107',1679397641,_binary '__ci_last_regenerate|i:1679397641;'),('202fbecf4a3a317b6ede34cad25b0a945bdc9795','54.38.214.107',1679397642,_binary '__ci_last_regenerate|i:1679397642;'),('89cf41be8fd779122547e1d72a866212853f618a','54.38.214.107',1679397644,_binary '__ci_last_regenerate|i:1679397643;'),('fc71021b9eb43ece14edc9be425b051ce73b669e','54.38.214.107',1679397645,_binary '__ci_last_regenerate|i:1679397645;'),('2b2279b29ba2bacf54469ff667efd28f632c18e2','54.38.214.107',1679397646,_binary '__ci_last_regenerate|i:1679397646;'),('c3770337d0f3d23da6357b79620c099bf0b2b98c','54.38.214.107',1679397655,_binary '__ci_last_regenerate|i:1679397655;'),('a368eac5954c96cb26d40160dc405260cb5b97da','54.38.214.107',1679397661,_binary '__ci_last_regenerate|i:1679397661;'),('2c7ae0835b6576d98d1375819491440846a99b71','54.38.214.107',1679397664,_binary '__ci_last_regenerate|i:1679397664;'),('47a9481cbb56286f36f28f746de03fc421ffee4a','161.8.109.180',1679397883,_binary '__ci_last_regenerate|i:1679397881;'),('8d5562ab2a90be2d86065954cecf8e78b383a75b','161.8.109.180',1679738788,_binary '__ci_last_regenerate|i:1679738788;'),('142c2d507fb90d2cd57c11453efb1a9b9fc237c1','161.8.109.180',1679738789,_binary '__ci_last_regenerate|i:1679738789;'),('db7ae71045b92fe1effba93076223518b9104813','188.66.171.249',1679748834,_binary '__ci_last_regenerate|i:1679738912;user_id|s:1:\"1\";'),('91551b9dfc8f84f17a226d01fde161e50387679c','40.94.90.83',1680689375,_binary '__ci_last_regenerate|i:1680689375;'),('b4e818fb1dedb92c4719ed90e5e4efd09a06b5d2','40.94.105.66',1680689381,_binary '__ci_last_regenerate|i:1680689380;'),('1e77074bcaa904cc224dfdd33c61265b5f171b01','40.94.104.32',1680689393,_binary '__ci_last_regenerate|i:1680689393;'),('075dbd19f1a224bd70861713aef21508cc7b2b72','40.94.105.24',1680689394,_binary '__ci_last_regenerate|i:1680689394;'),('66c45aa9ea365303f1b888c0ea577f4369eb6b0c','161.8.109.180',1680776992,_binary '__ci_last_regenerate|i:1680776992;'),('5eb4457042f3269f65e32502df10682d907e8855','161.8.109.180',1680776992,_binary '__ci_last_regenerate|i:1680776992;'),('df40498a7024ef98e3347d945549910124b72f66','145.255.121.75',1681066087,_binary '__ci_last_regenerate|i:1681050099;user_id|s:1:\"1\";'),('8a454c35d761b3cecf42e85ce6102fd4207f7874','155.94.250.115',1681124623,_binary '__ci_last_regenerate|i:1681120102;user_id|s:1:\"1\";'),('95f56b6fd1176677a86f66cf39b00ba2f8581634','188.135.102.203',1681127721,_binary '__ci_last_regenerate|i:1681127694;user_id|s:1:\"1\";'),('388c113ea1559e5e978f6e4a240b29344c65f472','161.8.109.180',1681215982,_binary '__ci_last_regenerate|i:1681215885;user_id|s:1:\"1\";'),('08a84ade1586d65aea29750cae575804fcff3b7a','40.94.97.27',1681382474,_binary '__ci_last_regenerate|i:1681382474;'),('8e4c12728972eb7da80be2e6da1800ddbbbb5f81','40.94.102.99',1681382474,_binary '__ci_last_regenerate|i:1681382474;'),('f2bc369d6a3d8026a6fd9a749e6a40515c2ae3eb','40.94.96.40',1681382498,_binary '__ci_last_regenerate|i:1681382498;'),('f202c534cee2a7f2ac3868d9e469b232dc897abe','188.135.100.216',1681716532,_binary '__ci_last_regenerate|i:1681716532;'),('3df062fec769d9c37d1d6bc87ba40656b8305e49','188.135.100.216',1681716627,_binary '__ci_last_regenerate|i:1681716546;user_id|s:1:\"1\";'),('4f25f1871d58b26c5f9c4997925bd31596f28661','212.72.12.174',1684064995,_binary '__ci_last_regenerate|i:1684064995;user_id|s:1:\"1\";'),('fda7b449bb3d75842a35131b71997d423492c99b','45.80.151.145',1684065276,_binary '__ci_last_regenerate|i:1684065276;user_id|s:1:\"1\";'),('197fcb427801947b0a6dd0522480b477fad3b14a','3.237.2.156',1684064950,_binary '__ci_last_regenerate|i:1684064950;'),('c1cec2ee3cb0e9a53280f03744997004452aa848','3.237.2.156',1684064951,_binary '__ci_last_regenerate|i:1684064951;'),('08af63c0be26336a346614a121fb0d526751070b','212.72.12.174',1684065303,_binary '__ci_last_regenerate|i:1684065303;user_id|s:1:\"1\";'),('e87f0320390c852353a8254c6090be6e76a600de','45.80.151.145',1684065587,_binary '__ci_last_regenerate|i:1684065587;user_id|s:1:\"1\";'),('3f763446acefd2a3c9b197ce4c1de0379a129c2d','212.72.12.174',1684065611,_binary '__ci_last_regenerate|i:1684065611;user_id|s:1:\"1\";'),('c3f22b7c72cec6a2ebc68444bf2672f505a0c8d9','45.80.151.145',1684072951,_binary '__ci_last_regenerate|i:1684065587;user_id|s:1:\"1\";'),('181da8f0bfdd3ec5ff5ef8908952be31269b0e73','212.72.12.174',1684067023,_binary '__ci_last_regenerate|i:1684065611;user_id|s:1:\"1\";'),('509c41d34656fa554416aa4d43993e8bef1ac8b7','89.147.146.168',1684093050,''),('447c65649c2164f4b028be05dc968e057867c019','89.147.146.168',1684093050,''),('f7aa33840923cb744643504ea13237075d74f6a6','161.8.109.180',1687071465,_binary '__ci_last_regenerate|i:1687071464;'),('c4f08c60638e1c468eaad9e4c04631d5b3762692','52.55.8.51',1687071473,_binary '__ci_last_regenerate|i:1687071473;'),('e90d56e84178bbb6bb5b562eb091812262d28281','161.8.109.180',1688640824,_binary '__ci_last_regenerate|i:1688640824;user_id|s:1:\"1\";'),('0eaa7ae423437b8ace3f12f0ab42ac576567ba1c','161.8.109.180',1688649567,_binary '__ci_last_regenerate|i:1688640824;user_id|s:1:\"1\";'),('9629cf278bb340118219e8036be840f1d59517f8','161.8.109.180',1694071032,_binary '__ci_last_regenerate|i:1694071019;'),('479c1e8aca6917b9342ac44cc517b55491f0d13f','161.8.109.180',1694083119,_binary '__ci_last_regenerate|i:1694083119;'),('225f7d73968eb66b468680842738bef3ce87dcec','161.8.109.180',1694088059,_binary '__ci_last_regenerate|i:1694088059;user_id|s:1:\"1\";'),('dc44c40e749701e1ecdbd378171ee7470ea75a1a','34.207.139.108',1694083178,_binary '__ci_last_regenerate|i:1694083178;'),('020d72e7c533645cc1aa59f6956f3fd697327422','34.207.139.108',1694083179,_binary '__ci_last_regenerate|i:1694083178;'),('6e140eecfa83d7f40a4d7372e6139628a15a35a5','161.8.109.180',1694088367,_binary '__ci_last_regenerate|i:1694088367;user_id|s:1:\"1\";'),('7a6e6c210a1b39b29c2e18ce9646d997b09de29b','161.8.109.180',1694089572,_binary '__ci_last_regenerate|i:1694089572;user_id|s:1:\"1\";'),('47b62db0d99f38d599c43394d24396e114379d7a','161.8.109.180',1694089099,_binary '__ci_last_regenerate|i:1694089099;user_id|s:1:\"1\";'),('5bdf918973f9ebe490378bc43168993410ce4102','161.8.109.180',1694091517,_binary '__ci_last_regenerate|i:1694091517;user_id|s:1:\"1\";'),('4816e3acc36b7253839f958192854ca78b285d97','161.8.109.180',1694090201,_binary '__ci_last_regenerate|i:1694090201;user_id|s:1:\"1\";'),('a6392d72b0a541dc3b8e2aa98d623dc929e51127','161.8.109.180',1694091158,_binary '__ci_last_regenerate|i:1694091157;user_id|s:1:\"1\";'),('c518daab3ad336a95736c4cb40392792a0023eaf','161.8.109.180',1694091821,_binary '__ci_last_regenerate|i:1694091821;user_id|s:1:\"1\";'),('38e45529755201a4329743e33813ce16541c66bd','161.8.109.180',1694092155,_binary '__ci_last_regenerate|i:1694092155;user_id|s:1:\"1\";'),('558c5f0b0263e477055bb267d20e237c0ff2f58b','54.38.214.107',1694091898,_binary '__ci_last_regenerate|i:1694091898;'),('010cc72be3088794e56ea65663b434d62f4c6824','54.38.214.107',1694091980,_binary '__ci_last_regenerate|i:1694091980;'),('249eb74a9a5d4e7c7593e44e89c318deca14f259','161.8.109.180',1694092525,_binary '__ci_last_regenerate|i:1694092525;user_id|s:1:\"1\";'),('d26f7ecc0c01971a6e6e1408d02eedf051fc40f1','161.8.109.180',1694095973,_binary '__ci_last_regenerate|i:1694092525;user_id|s:1:\"1\";'),('aa17fd98cb6a9f5d49e786d1bb70a345047f63c0','161.8.109.180',1694254954,_binary '__ci_last_regenerate|i:1694254954;'),('5949532c03ca4a6432a45e532ac1d0c34c5d6daa','161.8.109.180',1694268327,_binary '__ci_last_regenerate|i:1694268327;'),('bc0b1c92bba33eefc6a6b44d242ca63d17e9023e','161.8.109.180',1694353088,_binary '__ci_last_regenerate|i:1694353088;'),('e20693dee5056f1f2572e5c5dcefb496a26e7f01','161.8.109.180',1694432008,_binary '__ci_last_regenerate|i:1694432008;user_id|s:1:\"1\";'),('c7bb1a359c2910dc5a4e7330ec4b345a3eb49bb3','161.8.109.180',1694434705,_binary '__ci_last_regenerate|i:1694432008;user_id|s:1:\"1\";'),('b13f6e1423e7ea5795f36f043a989adfce739c5a','188.135.25.243',1696508033,_binary '__ci_last_regenerate|i:1696507976;'),('d1edec7de2fac615dc3a9ce55e26eb5338fca22f','3.95.137.154',1696508037,_binary '__ci_last_regenerate|i:1696508037;'),('80e9cb4297a162cd679e6b9418491877a6951bb1','161.8.109.180',1696678395,_binary '__ci_last_regenerate|i:1696678395;'),('672960cdaa596b81a105b2fa65f20797ea313845','161.8.109.180',1696678423,_binary '__ci_last_regenerate|i:1696678414;'),('5350b67fb98db2a56e9ac99fa1e1d9aecfcaf585','161.8.109.180',1707901937,_binary '__ci_last_regenerate|i:1707901937;'),('02b7a8c4e91d28261c616d7c82bd9fe7bff1a470','185.254.196.81',1712885513,_binary '__ci_last_regenerate|i:1712885513;'),('6ce530983d03c986a7a95d7ed48511e3447ee3f5','37.19.73.127',1721472233,_binary '__ci_last_regenerate|i:1721472233;'),('3fd44f0564c555fc1bc17e8fde94305a693b6007','95.216.195.32',1722769073,_binary '__ci_last_regenerate|i:1722769073;'),('9443cf9d130621daceec3b2b81c2d73d5f147f86','52.102.16.117',1726750527,_binary '__ci_last_regenerate|i:1726750526;'),('9e3d9af1333fb33683a25861bca14271135d5d03','84.242.34.177',1726750531,_binary '__ci_last_regenerate|i:1726750529;'),('abd243913442d9f28e495b0ad8bb62d6382f644d','52.102.16.117',1726750530,_binary '__ci_last_regenerate|i:1726750527;'),('59c5b3d8db88670e5570f12d06762d7370f961a4','40.94.97.63',1726750592,_binary '__ci_last_regenerate|i:1726750592;'),('c3ca1f50123010b30ad3149e73e806d5c6f37e31','13.79.159.217',1728991165,_binary '__ci_last_regenerate|i:1728991165;'),('8598817921083b8fc3847be9b06e1d19e40aeee5','134.19.179.195',1729464771,_binary '__ci_last_regenerate|i:1729464771;'),('a639e340cb8584fab475b5a5693313097ecca55c','84.39.116.180',1729580488,_binary '__ci_last_regenerate|i:1729580488;'),('44f2a5536ac80d4ac4fde9d2a584c306996fd345','213.152.161.30',1729581047,_binary '__ci_last_regenerate|i:1729581047;'),('c328572b7b535894b0f3b3cc3b7031ef812974bd','204.8.98.15',1729581797,_binary '__ci_last_regenerate|i:1729581797;'),('bfa9df241e29ad23159fe14b435f5898867fa8df','87.101.92.171',1729605041,_binary '__ci_last_regenerate|i:1729605040;'),('504f4e168ae6e0d16be3248998c66a965a610d00','62.102.148.189',1729626973,_binary '__ci_last_regenerate|i:1729626972;'),('2507c6db21a84fecc8e3a2cc454fbbd0dd97e971','79.110.62.220',1731066902,_binary '__ci_last_regenerate|i:1731066901;'),('21de5e9a72b740f94afa99863e84dba595cf9f43','79.110.62.220',1731072637,_binary '__ci_last_regenerate|i:1731072637;'),('c33648f6b36e6767f87f2173805d893054eec1a9','79.110.62.220',1731142910,_binary '__ci_last_regenerate|i:1731142910;'),('c1298aac49dcd2265158776548fcf8d5cec82cf7','79.110.62.220',1731395626,_binary '__ci_last_regenerate|i:1731395626;'),('92c2d6535e44e12ae51feb9f3217f0f1c8069f07','79.110.62.220',1731399900,_binary '__ci_last_regenerate|i:1731399900;'),('51ddb673e1e7422dfd237ff6e6e917d8dc18906a','40.94.96.97',1735801988,_binary '__ci_last_regenerate|i:1735801985;'),('48493e244d86db72739a6815163d57d589df25de','213.152.187.195',1740065559,_binary '__ci_last_regenerate|i:1740065559;');

--
-- Table structure for table `nizwa_packing_productsclient_groups`
--

CREATE TABLE `nizwa_packing_productsclient_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 `nizwa_packing_productsclient_groups`
--


--
-- Table structure for table `nizwa_packing_productsclients`
--

CREATE TABLE `nizwa_packing_productsclients` (
  `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,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `starred_by` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `group_ids` text COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_lead` tinyint(1) NOT NULL DEFAULT '0',
  `lead_status_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `lead_source_id` int(11) NOT NULL,
  `last_lead_status` text COLLATE utf8_unicode_ci NOT NULL,
  `client_migration_date` date NOT NULL,
  `vat_number` text COLLATE utf8_unicode_ci,
  `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `disable_online_payment` tinyint(1) NOT NULL DEFAULT '0',
  `geo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `advance_account_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsclients`
--

INSERT INTO `nizwa_packing_productsclients` VALUES (1,'a','test',NULL,NULL,NULL,NULL,'2023-03-21',NULL,'755778',NULL,NULL,'','',0,1,0,0,0,0,'','0000-00-00',NULL,NULL,0,NULL,0,0),(2,'ahmed','barka','','','','','2023-03-21','','123456','aasdf@test.om','','','',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,91,0);

--
-- Table structure for table `nizwa_packing_productscontacts`
--

CREATE TABLE `nizwa_packing_productscontacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci DEFAULT 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 `nizwa_packing_productscontacts`
--


--
-- Table structure for table `nizwa_packing_productscustom_field_values`
--

CREATE TABLE `nizwa_packing_productscustom_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 `nizwa_packing_productscustom_field_values`
--


--
-- Table structure for table `nizwa_packing_productscustom_fields`
--

CREATE TABLE `nizwa_packing_productscustom_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 `nizwa_packing_productscustom_fields`
--


--
-- Table structure for table `nizwa_packing_productscustom_widgets`
--

CREATE TABLE `nizwa_packing_productscustom_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 `nizwa_packing_productscustom_widgets`
--


--
-- Table structure for table `nizwa_packing_productsdashboards`
--

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


--
-- Table structure for table `nizwa_packing_productsdelivery_note_items`
--

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

--
-- Dumping data for table `nizwa_packing_productsdelivery_note_items`
--

INSERT INTO `nizwa_packing_productsdelivery_note_items` VALUES (2,8,14,'product 13','',3,'PC',15,45,0,1,0),(3,7,15,'Product test','desc',1,'PC',25,25,0,1,0),(4,10,19,'Product 22','sadasd',50,'PC',15,750,0,2,0),(5,12,22,'product 33','',2,'PC',15,30,0,3,0);

--
-- Table structure for table `nizwa_packing_productsdelivery_notes`
--

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

--
-- Dumping data for table `nizwa_packing_productsdelivery_notes`
--


--
-- Table structure for table `nizwa_packing_productsdepartments`
--

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

--
-- Dumping data for table `nizwa_packing_productsdepartments`
--


--
-- Table structure for table `nizwa_packing_productsemail_templates`
--

CREATE TABLE `nizwa_packing_productsemail_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 `nizwa_packing_productsemail_templates`
--


--
-- Table structure for table `nizwa_packing_productsenteries`
--

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

--
-- Dumping data for table `nizwa_packing_productsenteries`
--

INSERT INTO `nizwa_packing_productsenteries` VALUES (1,54,35,'cr',0,'Invoice: AMI/1',0,0,'0',0,0),(2,54,70,'cr',0,'Invoice: AMI/1',0,0,'0',0,0),(3,55,91,'dr',1050,'Invoice: Invoice/2',0,0,'0',0,0),(4,55,35,'cr',50,'Invoice: Invoice/2',0,0,'0',0,0),(5,55,70,'cr',1000,'Invoice: Invoice/2',0,0,'0',0,0),(6,56,91,'dr',525,'Invoice: Invoice/3',0,0,'0',0,0),(7,56,35,'cr',25,'Invoice: Invoice/3',0,0,'0',0,0),(8,56,70,'cr',500,'Invoice: Invoice/3',0,0,'0',0,0),(9,57,91,'cr',525,'Invoice Payment Received: Invoice/2 ',0,0,'0',0,0),(10,57,79,'dr',525,'Invoice Payment Received: Invoice/2 ',0,0,'0',0,0),(11,58,91,'cr',525,'Invoice Payment Received: Invoice/2 ',0,0,'0',0,0),(12,58,79,'dr',525,'Invoice Payment Received: Invoice/2 ',0,0,'0',0,0),(13,59,75,'dr',111.5,'Purchase Order: PURCHASE ORDER #1',0,0,'0',0,0),(14,59,27,'dr',3.875,'Purchase Order: PURCHASE ORDER #1',0,0,'0',0,0),(15,59,93,'cr',115.375,'Purchase Order: PURCHASE ORDER #1',0,0,'0',0,0),(16,60,93,'dr',10,'',0,0,'0',0,0),(17,60,77,'cr',10,'',0,0,'0',0,0),(18,61,18,'dr',111.5,'Invoice/1',0,0,'0',0,0),(19,61,75,'cr',111.5,'Invoice/1',0,0,'0',0,0),(20,62,91,'dr',220,'Invoice: Invoice/5',0,0,'0',0,0),(21,62,35,'cr',0,'Invoice: Invoice/5',0,0,'0',0,0),(22,62,70,'cr',220,'Invoice: Invoice/5',0,0,'0',0,0),(23,63,91,'dr',240,'Invoice: Invoice/7',0,0,'0',0,0),(24,63,35,'cr',0,'Invoice: Invoice/7',0,0,'0',0,0),(25,63,70,'cr',240,'Invoice: Invoice/7',0,0,'0',0,0),(26,64,91,'dr',200,'Invoice: Invoice/8',0,0,'0',0,0),(27,64,35,'cr',0,'Invoice: Invoice/8',0,0,'0',0,0),(28,64,70,'cr',200,'Invoice: Invoice/8',0,0,'0',0,0),(29,65,91,'dr',945,'Invoice: Invoice/9',0,0,'0',0,0),(30,65,35,'cr',45,'Invoice: Invoice/9',0,0,'0',0,0),(31,65,70,'cr',900,'Invoice: Invoice/9',0,0,'0',0,0),(32,66,91,'cr',500,'Invoice Payment Received: Invoice/9 ',0,0,'0',0,0),(33,66,79,'dr',500,'Invoice Payment Received: Invoice/9 ',0,0,'0',0,0),(34,67,91,'cr',445,'Invoice Payment Received: Invoice/9 ',0,0,'0',0,0),(35,67,81,'dr',445,'Invoice Payment Received: Invoice/9 ',0,0,'0',0,0);

--
-- Table structure for table `nizwa_packing_productsestimate_forms`
--

CREATE TABLE `nizwa_packing_productsestimate_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 `nizwa_packing_productsestimate_forms`
--


--
-- Table structure for table `nizwa_packing_productsestimate_items`
--

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

--
-- Dumping data for table `nizwa_packing_productsestimate_items`
--

INSERT INTO `nizwa_packing_productsestimate_items` VALUES (1,5,'closet','EEGGER',5,'SQM',60,300,2,1,0,0),(2,4,'wooden door','main door pivot type',1,'SQM',200,200,2,0,0,1),(3,4,'wooden door','main door pivot type',1,'SQM',200,200,2,1,0,0),(4,5,'closet','EEGGER',10,'SQM',60,600,3,0,0,0),(5,4,'wooden door','main door pivot type',3,'SQM',300,900,4,1,0,0);

--
-- Table structure for table `nizwa_packing_productsestimate_requests`
--

CREATE TABLE `nizwa_packing_productsestimate_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 `nizwa_packing_productsestimate_requests`
--


--
-- Table structure for table `nizwa_packing_productsestimates`
--

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

--
-- Dumping data for table `nizwa_packing_productsestimates`
--

INSERT INTO `nizwa_packing_productsestimates` VALUES (1,1,0,'2023-03-21','2023-03-28','',NULL,'draft',0,0,'before_tax',0,'percentage',0,0),(2,2,0,'2023-03-21','2023-04-19','',NULL,'accepted',0,0,'before_tax',0,'percentage',1,0),(3,2,0,'2023-09-07','2023-09-14','',NULL,'accepted',0,0,'before_tax',0,'percentage',0,0),(4,2,0,'2023-09-07','2023-09-14','',NULL,'accepted',0,0,'before_tax',0,'percentage',0,0);

--
-- Table structure for table `nizwa_packing_productsevents`
--

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

--
-- Dumping data for table `nizwa_packing_productsevents`
--


--
-- Table structure for table `nizwa_packing_productsexpense_categories`
--

CREATE TABLE `nizwa_packing_productsexpense_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_parent` int(11) NOT NULL,
  `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsexpense_categories`
--

INSERT INTO `nizwa_packing_productsexpense_categories` VALUES (1,57,'Ex Cat1',83,0);

--
-- Table structure for table `nizwa_packing_productsexpense_items`
--

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

--
-- Dumping data for table `nizwa_packing_productsexpense_items`
--


--
-- Table structure for table `nizwa_packing_productsexpenses`
--

CREATE TABLE `nizwa_packing_productsexpenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_date` date NOT NULL,
  `category_id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT 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',
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `client_id` int(11) NOT NULL DEFAULT '0',
  `status` varchar(50) 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',
  `bank` int(11) NOT NULL DEFAULT '0',
  `treasury` int(11) NOT NULL DEFAULT '0',
  `pt_cash` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsexpenses`
--


--
-- Table structure for table `nizwa_packing_productsexpires`
--

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

--
-- Dumping data for table `nizwa_packing_productsexpires`
--


--
-- Table structure for table `nizwa_packing_productsgeneral_files`
--

CREATE TABLE `nizwa_packing_productsgeneral_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 `nizwa_packing_productsgeneral_files`
--


--
-- Table structure for table `nizwa_packing_productshelp_articles`
--

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

--
-- Dumping data for table `nizwa_packing_productshelp_articles`
--

INSERT INTO `nizwa_packing_productshelp_articles` VALUES (1,'tea','<p>xcvxcvzxcvcxvcxzcvfdvdfsvdfsv</p>',1,1,'2023-01-17 13:23:02','active','a:0:{}',1,0);

--
-- Table structure for table `nizwa_packing_productshelp_categories`
--

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

--
-- Dumping data for table `nizwa_packing_productshelp_categories`
--

INSERT INTO `nizwa_packing_productshelp_categories` VALUES (1,'Cat','sdfsd','knowledge_base',0,'active',0);

--
-- Table structure for table `nizwa_packing_productsinternal_transactions`
--

CREATE TABLE `nizwa_packing_productsinternal_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',
  `bank` int(11) NOT NULL DEFAULT '0',
  `treasury` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `nizwa_packing_productsinternal_transactions`
--


--
-- Table structure for table `nizwa_packing_productsinvoice_items`
--

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

--
-- Dumping data for table `nizwa_packing_productsinvoice_items`
--

INSERT INTO `nizwa_packing_productsinvoice_items` VALUES (1,4,'wooden door','main door pivot type',5,'SQM',200,1000,NULL,0,2,1,0,0),(2,5,'closet','EEGGER',5,'SQM',60,300,NULL,0,3,1,0,0),(3,4,'wooden door','main door pivot type',1,'SQM',200,200,NULL,0,3,1,0,0),(4,6,'item RAW','',1,'PC',220,220,NULL,0,5,0,0,0),(5,7,'item product ','cvsdv',1,'PC',240,240,NULL,0,7,0,0,0),(6,4,'wooden door','main door pivot type',1,'SQM',200,200,NULL,0,8,0,0,0),(7,4,'wooden door','main door pivot type',3,'SQM',300,900,NULL,0,9,1,0,0);

--
-- Table structure for table `nizwa_packing_productsinvoice_payments`
--

CREATE TABLE `nizwa_packing_productsinvoice_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `files` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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',
  `bank` int(11) DEFAULT '0',
  `treasury` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsinvoice_payments`
--

INSERT INTO `nizwa_packing_productsinvoice_payments` VALUES (1,'a:0:{}',525,'2023-03-21',1,'2023-03-21','','','',0,'',2,'approved',0,NULL,57,0,1,NULL,79,'2023-03-21 10:50:29'),(2,'a:0:{}',525,'2023-03-21',1,'2023-03-21','','','',0,'',2,'approved',0,NULL,58,0,1,NULL,79,'2023-03-21 10:52:02'),(3,'a:0:{}',500,'2023-09-07',1,'2023-09-07','','','',0,'',9,'approved',0,NULL,66,0,1,NULL,79,'2023-09-07 13:04:58'),(4,'a:0:{}',445,'2023-09-07',4,'2023-09-07','','','',0,'',9,'approved',0,NULL,67,0,1,81,0,'2023-09-07 13:06:20');

--
-- Table structure for table `nizwa_packing_productsinvoices`
--

CREATE TABLE `nizwa_packing_productsinvoices` (
  `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,
  `files` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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',
  `confirm_status` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'not_confirmed',
  `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,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `sale_item` int(11) NOT NULL DEFAULT '0',
  `sale_account_id` int(11) NOT NULL DEFAULT '0',
  `sale_cost_account_id` int(11) NOT NULL DEFAULT '0',
  `sale_status` enum('Pending','Ready','In Progress','Finished') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsinvoices`
--

INSERT INTO `nizwa_packing_productsinvoices` VALUES (1,2,0,'2023-03-21','2023-04-20','','a:0:{}','',NULL,'draft','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'In Progress'),(2,2,0,'2023-03-21','2023-04-20','','a:0:{}','',NULL,'not_paid','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Ready'),(3,2,0,'2023-03-21','2023-04-20','','a:0:{}','',NULL,'draft','not_delivered','approved','not_confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending'),(4,2,1,'2023-05-14','2023-06-13','Note ','a:0:{}','',NULL,'draft','not_delivered','not_approved','not_confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,1,1,0,0,'Pending'),(5,2,1,'2023-05-14','2023-06-13','','a:0:{}','',NULL,'draft','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending'),(6,2,1,'2023-05-14','2023-06-13','','a:0:{}','',NULL,'draft','not_delivered','not_approved','not_confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending'),(7,2,1,'2023-05-14','2023-06-13','','a:0:{}','',NULL,'draft','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending'),(8,2,1,'2023-09-07','2023-10-07','','a:0:{}','',NULL,'draft','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending'),(9,2,0,'2023-09-07','2023-10-07','','a:0:{}','',NULL,'not_paid','not_delivered','approved','confirmed',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,1,0,0,'Pending');

--
-- Table structure for table `nizwa_packing_productsitem_categories`
--

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

--
-- Dumping data for table `nizwa_packing_productsitem_categories`
--

INSERT INTO `nizwa_packing_productsitem_categories` VALUES (37,'finish goods',0),(36,'accessories',0),(35,'adhesive',0),(34,'doors',0),(33,'wood',0),(32,'lumber',0);

--
-- Table structure for table `nizwa_packing_productsitem_uom`
--

CREATE TABLE `nizwa_packing_productsitem_uom` (
  `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`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsitem_uom`
--


--
-- Table structure for table `nizwa_packing_productsitems`
--

CREATE TABLE `nizwa_packing_productsitems` (
  `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',
  `raw_material` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsitems`
--

INSERT INTO `nizwa_packing_productsitems` VALUES (1,'ashwood 2\" kd','american','cft',15.5,19.5,32,'product',1,0),(2,'pu sanding sealer','paints  ','LTR',24,28,34,'product',1,0),(3,'body lock','door accessories','pcs',10,13,36,'product',1,0),(4,'wooden door','main door pivot type','SQM',100,200,34,'product',0,0),(5,'closet','EEGGER','SQM',30,60,37,'product',0,0),(6,'item RAW','','PC',200,220,36,'product',1,0),(7,'item product ','cvsdv','PC',220,240,36,'product',0,0);

--
-- Table structure for table `nizwa_packing_productsitems_levels`
--

CREATE TABLE `nizwa_packing_productsitems_levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsitems_levels`
--


--
-- Table structure for table `nizwa_packing_productsjob_orders`
--

CREATE TABLE `nizwa_packing_productsjob_orders` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `invoice_item_id` int(8) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `quantity` int(8) NOT NULL,
  `scheduled_start_date` date DEFAULT NULL,
  `expected_duration` int(8) DEFAULT NULL,
  `actual_duration` date DEFAULT NULL,
  `worksheet` text,
  `priority` enum('1','2','3','4','5') DEFAULT NULL,
  `stages` text,
  `current_stage` varchar(50) DEFAULT NULL,
  `operation_cost` int(8) DEFAULT NULL,
  `total_cost` int(8) DEFAULT NULL,
  `team_member` int(8) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(8) DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nizwa_packing_productsjob_orders`
--

INSERT INTO `nizwa_packing_productsjob_orders` VALUES (1,4,'2',5,'2023-03-21',5,'0000-00-00','a:0:{}','1',NULL,'In Progress',0,152,1,'2023-03-21 10:58:35',NULL,0),(2,6,'5',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-05-14 11:53:28',NULL,0),(3,7,'7',1,'0000-00-00',0,'0000-00-00','a:0:{}','1',NULL,'In Progress',5,1005,0,'2023-05-14 12:04:16',NULL,0),(4,4,'8',1,'2023-09-07',0,'2023-09-21','a:0:{}','1',NULL,'Finished',20,152,1,'2023-09-07 13:16:04',NULL,0),(5,4,'9',3,'2023-09-07',30,'2023-10-07','a:0:{}','1',NULL,'In Progress',100,232,0,'2023-09-07 13:09:14',NULL,0);

--
-- Table structure for table `nizwa_packing_productsjoborder_status`
--

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

--
-- Dumping data for table `nizwa_packing_productsjoborder_status`
--


--
-- Table structure for table `nizwa_packing_productslead_source`
--

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

--
-- Dumping data for table `nizwa_packing_productslead_source`
--


--
-- Table structure for table `nizwa_packing_productslead_status`
--

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

--
-- Dumping data for table `nizwa_packing_productslead_status`
--

INSERT INTO `nizwa_packing_productslead_status` VALUES (1,'cold','#2d9cdb',1,0),(2,'hot','#e74c3c',2,0),(3,'won','#83c340',3,0);

--
-- Table structure for table `nizwa_packing_productsleads`
--

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


--
-- Table structure for table `nizwa_packing_productsleave_applications`
--

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

--
-- Dumping data for table `nizwa_packing_productsleave_applications`
--


--
-- Table structure for table `nizwa_packing_productsleave_types`
--

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

--
-- Dumping data for table `nizwa_packing_productsleave_types`
--


--
-- Table structure for table `nizwa_packing_productsloans`
--

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

--
-- Dumping data for table `nizwa_packing_productsloans`
--


--
-- Table structure for table `nizwa_packing_productsmaterial_request`
--

CREATE TABLE `nizwa_packing_productsmaterial_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) DEFAULT '0',
  `material_request_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 `nizwa_packing_productsmaterial_request`
--

INSERT INTO `nizwa_packing_productsmaterial_request` VALUES (1,2,'2023-01-17',3,'','','draft','approved',0),(2,2,'2023-01-17',3,'','','draft','approved',0);

--
-- Table structure for table `nizwa_packing_productsmaterial_request_items`
--

CREATE TABLE `nizwa_packing_productsmaterial_request_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 DEFAULT NULL,
  `total` double DEFAULT NULL,
  `sort` int(11) NOT NULL DEFAULT '0',
  `material_request_id` int(11) DEFAULT 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 `nizwa_packing_productsmaterial_request_items`
--


--
-- Table structure for table `nizwa_packing_productsmaterial_request_payments`
--

CREATE TABLE `nizwa_packing_productsmaterial_request_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,
  `material_request_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 `nizwa_packing_productsmaterial_request_payments`
--


--
-- Table structure for table `nizwa_packing_productsmaterials_bill`
--

CREATE TABLE `nizwa_packing_productsmaterials_bill` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `item_id` int(8) NOT NULL,
  `quantity` int(8) NOT NULL,
  `cost` int(8) NOT NULL,
  `current_stock` float DEFAULT NULL,
  `job_id` int(8) NOT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nizwa_packing_productsmaterials_bill`
--

INSERT INTO `nizwa_packing_productsmaterials_bill` VALUES (5,1,5,78,20,1,0,'2023-03-21 10:58:35'),(6,3,3,30,5,1,0,'2023-03-21 10:58:35'),(7,2,1,24,2,1,0,'2023-03-21 10:58:35'),(8,6,5,1000,99,3,0,'2023-05-14 12:04:16'),(18,1,5,78,25,5,0,'2023-09-07 13:09:14'),(19,2,1,24,3,5,0,'2023-09-07 13:09:14'),(20,3,3,30,6,5,0,'2023-09-07 13:09:14'),(21,1,5,78,25,4,1,'2023-09-07 13:16:04'),(22,2,1,24,3,4,1,'2023-09-07 13:16:04'),(23,3,3,30,6,4,1,'2023-09-07 13:16:04');

--
-- Table structure for table `nizwa_packing_productsmessages`
--

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


--
-- Table structure for table `nizwa_packing_productsmilestones`
--

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


--
-- Table structure for table `nizwa_packing_productsnationality`
--

CREATE TABLE `nizwa_packing_productsnationality` (
  `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`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productsnationality`
--


--
-- Table structure for table `nizwa_packing_productsnotes`
--

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


--
-- Table structure for table `nizwa_packing_productsnotification_settings`
--

CREATE TABLE `nizwa_packing_productsnotification_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 `nizwa_packing_productsnotification_settings`
--

INSERT INTO `nizwa_packing_productsnotification_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 `nizwa_packing_productsnotifications`
--

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

--
-- Dumping data for table `nizwa_packing_productsnotifications`
--

INSERT INTO `nizwa_packing_productsnotifications` VALUES (1,1,'','2023-03-21 10:42:30','','','project_created',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(2,1,'','2023-03-21 11:20:27','','','project_task_created',1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(3,1,'','2023-03-21 11:20:41','','','project_task_updated',1,1,0,0,0,0,0,0,0,89,0,0,0,0,0,0,0,0,0,0,0),(4,1,'','2023-03-21 11:20:42','','','project_task_updated',1,1,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0),(5,1,'','2023-03-21 11:20:44','','','project_task_updated',1,1,0,0,0,0,0,0,0,91,0,0,0,0,0,0,0,0,0,0,0),(6,1,'','2023-03-21 11:20:45','','','project_task_updated',1,1,0,0,0,0,0,0,0,92,0,0,0,0,0,0,0,0,0,0,0),(7,1,'','2023-03-21 11:20:46','','','project_task_updated',1,1,0,0,0,0,0,0,0,93,0,0,0,0,0,0,0,0,0,0,0),(8,1,'','2023-03-21 11:20:55','','','project_task_updated',1,1,0,0,0,0,0,0,0,94,0,0,0,0,0,0,0,0,0,0,0),(9,1,'','2023-03-21 11:21:01','','','project_task_updated',1,1,0,0,0,0,0,0,0,95,0,0,0,0,0,0,0,0,0,0,0),(10,1,'','2023-03-21 11:21:04','','','project_task_updated',1,1,0,0,0,0,0,0,0,96,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `nizwa_packing_productspayment_methods`
--

CREATE TABLE `nizwa_packing_productspayment_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 `nizwa_packing_productspayment_methods`
--

INSERT INTO `nizwa_packing_productspayment_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 `nizwa_packing_productspaypal_ipn`
--

CREATE TABLE `nizwa_packing_productspaypal_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 `nizwa_packing_productspaypal_ipn`
--


--
-- Table structure for table `nizwa_packing_productspayroll`
--

CREATE TABLE `nizwa_packing_productspayroll` (
  `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',
  `payment_item_id` 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 `nizwa_packing_productspayroll`
--


--
-- Table structure for table `nizwa_packing_productspayroll_detail`
--

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

--
-- Dumping data for table `nizwa_packing_productspayroll_detail`
--


--
-- Table structure for table `nizwa_packing_productsposts`
--

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


--
-- Table structure for table `nizwa_packing_productsproforma_invoice_items`
--

CREATE TABLE `nizwa_packing_productsproforma_invoice_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `cost` double 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,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `old_id` int(11) DEFAULT '0',
  `tax_id` int(11) DEFAULT '0',
  `tax_id2` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsproforma_invoice_items`
--


--
-- Table structure for table `nizwa_packing_productsproforma_invoice_payments`
--

CREATE TABLE `nizwa_packing_productsproforma_invoice_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','bounce','deposited','refunded','cancelled','delayed','on_hold') 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,
  `files` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bank` int(11) 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 `nizwa_packing_productsproforma_invoice_payments`
--


--
-- Table structure for table `nizwa_packing_productsproforma_invoices`
--

CREATE TABLE `nizwa_packing_productsproforma_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quotation_id` int(11) NOT NULL,
  `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 DEFAULT NULL,
  `cancelled_at` datetime DEFAULT NULL,
  `cancelled_by` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `revised` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `old_project` int(11) DEFAULT '0',
  `old_invoice_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `old_quotation_id` int(11) DEFAULT '0',
  `department` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productsproforma_invoices`
--


--
-- Table structure for table `nizwa_packing_productsproject_comments`
--

CREATE TABLE `nizwa_packing_productsproject_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 `nizwa_packing_productsproject_comments`
--


--
-- Table structure for table `nizwa_packing_productsproject_files`
--

CREATE TABLE `nizwa_packing_productsproject_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 `nizwa_packing_productsproject_files`
--


--
-- Table structure for table `nizwa_packing_productsproject_members`
--

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

--
-- Dumping data for table `nizwa_packing_productsproject_members`
--

INSERT INTO `nizwa_packing_productsproject_members` VALUES (2,1,2,1,0),(3,1,3,1,0),(4,1,4,1,0),(5,1,5,1,0),(6,1,1,1,0);

--
-- Table structure for table `nizwa_packing_productsproject_settings`
--

CREATE TABLE `nizwa_packing_productsproject_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 `nizwa_packing_productsproject_settings`
--


--
-- Table structure for table `nizwa_packing_productsproject_time`
--

CREATE TABLE `nizwa_packing_productsproject_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 `nizwa_packing_productsproject_time`
--


--
-- Table structure for table `nizwa_packing_productsprojects`
--

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

INSERT INTO `nizwa_packing_productsprojects` VALUES (1,'Elegant Engraving','','2023-03-21','2023-06-08',2,'2023-03-21',1,'open','',525,'',2,NULL,0);

--
-- Table structure for table `nizwa_packing_productspurchase_order_items`
--

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

--
-- Dumping data for table `nizwa_packing_productspurchase_order_items`
--

INSERT INTO `nizwa_packing_productspurchase_order_items` VALUES (1,1,'ashwood 2\" kd','american',5,'cft',15.5,77.5,0,1,1,0,0),(2,2,'pu sanding sealer','paints  ',1,'LTR',24,24,0,1,0,0,0),(3,3,'body lock','door accessories',1,'pcs',10,10,0,1,0,0,0);

--
-- Table structure for table `nizwa_packing_productspurchase_order_payments`
--

CREATE TABLE `nizwa_packing_productspurchase_order_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `files` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `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',
  `bank` int(11) NOT NULL DEFAULT '0',
  `treasury` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `nizwa_packing_productspurchase_order_payments`
--

INSERT INTO `nizwa_packing_productspurchase_order_payments` VALUES (1,'a:0:{}',10,'2023-03-21',4,'2023-03-21','','','',0,'',1,'approved',0,60,0,1,77,0,'2023-03-21 11:14:48');

--
-- Table structure for table `nizwa_packing_productspurchase_orders`
--

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

--
-- Dumping data for table `nizwa_packing_productspurchase_orders`
--

INSERT INTO `nizwa_packing_productspurchase_orders` VALUES (1,5,'2023-03-21',0,'','','not_paid','approved',0);

--
-- Table structure for table `nizwa_packing_productspurchase_return_items`
--

CREATE TABLE `nizwa_packing_productspurchase_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 `nizwa_packing_productspurchase_return_items`
--


--
-- Table structure for table `nizwa_packing_productspurchase_returns`
--

CREATE TABLE `nizwa_packing_productspurchase_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 `nizwa_packing_productspurchase_returns`
--


--
-- Table structure for table `nizwa_packing_productsroles`
--

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

--
-- Dumping data for table `nizwa_packing_productsroles`
--

INSERT INTO `nizwa_packing_productsroles` VALUES (1,'o9i8p[o',NULL,0);

--
-- Table structure for table `nizwa_packing_productssalary_advance`
--

CREATE TABLE `nizwa_packing_productssalary_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 `nizwa_packing_productssalary_advance`
--


--
-- Table structure for table `nizwa_packing_productssale_return_items`
--

CREATE TABLE `nizwa_packing_productssale_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 `nizwa_packing_productssale_return_items`
--


--
-- Table structure for table `nizwa_packing_productssale_returns`
--

CREATE TABLE `nizwa_packing_productssale_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 `nizwa_packing_productssale_returns`
--


--
-- Table structure for table `nizwa_packing_productssaleorder_status`
--

CREATE TABLE `nizwa_packing_productssaleorder_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 `nizwa_packing_productssaleorder_status`
--

INSERT INTO `nizwa_packing_productssaleorder_status` VALUES (1,'Pending','pending','#F9A52D',0,0),(2,'Ready','ready','#1672B9',1,0),(3,'In Progress','in_progress','#00B393',2,0),(4,'Finished','finished','#aab7b7',3,0);

--
-- Table structure for table `nizwa_packing_productssales_items`
--

CREATE TABLE `nizwa_packing_productssales_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `sale_account_id` int(11) NOT NULL,
  `sale_cost_account_id` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nizwa_packing_productssales_items`
--

INSERT INTO `nizwa_packing_productssales_items` VALUES (1,'default',70,70,0);

--
-- Table structure for table `nizwa_packing_productssettings`
--

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

INSERT INTO `nizwa_packing_productssettings` 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','app',0),('attendance_password','94269935','app',0),('banks_accounts_parent','25','app',0),('cash_on_hand_accounts_parent','24','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),('clients_accounts_parent','19','app',0),('clients_parent','','app',0),('company_address','Alkhoudh, Muscat ','app',0),('company_email','nppoman@gmail.ocm','app',0),('company_name','NPP ','app',0),('company_phone','','app',0),('company_vat_number','','app',0),('company_website','teamway.om','app',0),('cost_of_goods_sold','62','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','61','app',0),('default_cash_on_hand','12','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','30','app',0),('default_git','75','app',0),('default_inventory','18','app',0),('default_sales','70','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('discount','60','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','1','app',0),('enable_push_notification','','app',0),('enable_recurring_option_for_tasks','1','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','#054d7f ','app',0),('estimate_logo','a:1:{s:9:\"file_name\";s:36:\"_file64a69d33d9a4f-estimate-logo.png\";}','app',0),('expenses_accounts_parent','56','app',0),('favicon','a:1:{s:9:\"file_name\";s:30:\"_file63da64bac8797-favicon.png\";}','app',0),('financial_year_end','2022-01-01','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','3','app',0),('initial_number_of_the_invoice','2','app',0),('invoice_color','#054d7f ','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_prefix','Invoice/','app',0),('item_purchase_code','53434654','app',0),('language','arabic','app',0),('leave_salary_expenses','4','app',0),('module_announcement','1','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','1','app',0),('module_lead','1','app',0),('module_leave','1','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','1','app',0),('module_todo','1','app',0),('no_of_decimals','2','app',0),('payable_cheques','43','app',0),('payable_EOS_benefits','15','app',0),('payable_job_security','9','app',0),('payable_leave_salaries','15','app',0),('payable_PASI','53','app',0),('payable_salaries','46','app',0),('petty_cash_parent','16','app',0),('project_reference_in_tickets','1','app',0),('project_task_deadline_overdue_reminder','','app',0),('project_task_deadline_pre_reminder','1','app',0),('project_task_reminder_on_the_day_of_deadline','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('receivable_cheques','21','app',0),('rows_per_page','100','app',0),('salary_advances','66','app',0),('salary_expenses','65','app',0),('scrollbar','native','app',0),('send_bcc_to','nppoman@gmail.com','app',0),('send_estimate_bcc_to','info@teamway.om','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','a:4:{s:9:\"file_name\";s:34:\"system_file63da64bacdca3-Manuf.jpg\";s:9:\"file_size\";s:4:\"6613\";s:7:\"file_id\";N;s:12:\"service_type\";N;}','app',0),('site_logo','a:1:{s:9:\"file_name\";s:32:\"_file63da64bac04ff-site-logo.png\";}','app',0),('suppliers_accounts_parent','37','app',0),('ticket_prefix','','app',0),('time_format','24_hours','app',0),('timezone','Asia/Muscat','app',0),('treasury_accounts_parent','12','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_39_dashboard','','user',0),('user_39_personal_language','english','user',0),('user_4_dashboard','','user',0),('user_43_dashboard','','user',0),('user_44_dashboard','','user',0),('user_45_dashboard','','user',0),('user_46_dashboard','','user',0),('user_47_dashboard','','user',0),('user_48_dashboard','','user',0),('user_48_personal_language','english','user',0),('user_49_dashboard','','user',0),('user_5_allowed_distance','100000000','user',0),('user_5_dashboard','','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_53_dashboard','','user',0),('user_54_dashboard','','user',0),('user_54_personal_language','english','user',0),('user_58_dashboard','','user',0),('user_6_dashboard','','user',0),('user_6_personal_language','english','user',0),('user_64_dashboard','','user',0),('user_65_dashboard','','user',0),('user_66_dashboard','','user',0),('user_69_dashboard','','user',0),('user_70_dashboard','','user',0),('user_72_dashboard','','user',0),('VAT_expense','21','app',0),('VAT_in','35','app',0),('VAT_out','27','app',0),('weekend','5,6','app',0);

--
-- Table structure for table `nizwa_packing_productsshipment_items`
--

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

--
-- Dumping data for table `nizwa_packing_productsshipment_items`
--

INSERT INTO `nizwa_packing_productsshipment_items` VALUES (1,1,1,2,0,1,0),(2,2,2,1,0,1,0),(3,3,3,1,0,1,0);

--
-- Table structure for table `nizwa_packing_productsshipments`
--

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

--
-- Dumping data for table `nizwa_packing_productsshipments`
--

INSERT INTO `nizwa_packing_productsshipments` VALUES (1,1,5,'2023-03-21','123','2023-03-21','222','2023-03-21','approved','',0);

--
-- Table structure for table `nizwa_packing_productssocial_links`
--

CREATE TABLE `nizwa_packing_productssocial_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 `nizwa_packing_productssocial_links`
--

INSERT INTO `nizwa_packing_productssocial_links` VALUES (44,44,'','','','','','','','','','','',0);

--
-- Table structure for table `nizwa_packing_productsstock_adjustments`
--

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

--
-- Dumping data for table `nizwa_packing_productsstock_adjustments`
--

INSERT INTO `nizwa_packing_productsstock_adjustments` VALUES (1,4,120,'',0),(2,6,100,'',0),(3,5,100,'',0),(4,9,-3,'',0),(5,11,50,'',0),(6,12,2,'',0),(7,26,100,'',0),(8,25,100,'',0),(9,3,5,'',0),(10,2,2,'',0),(11,1,20,'',0);

--
-- Table structure for table `nizwa_packing_productssuppliers`
--

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

--
-- Dumping data for table `nizwa_packing_productssuppliers`
--

INSERT INTO `nizwa_packing_productssuppliers` VALUES (5,'golden torch','ha','ff','','','','','','2023-03-21','','6665','','','','','',93,0,0),(4,'lumber world','eeee','sddff','','','','','','2023-03-21','','666','','','','','',92,0,0);

--
-- Table structure for table `nizwa_packing_productstask_status`
--

CREATE TABLE `nizwa_packing_productstask_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 `nizwa_packing_productstask_status`
--

INSERT INTO `nizwa_packing_productstask_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 `nizwa_packing_productstasks`
--

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

--
-- Dumping data for table `nizwa_packing_productstasks`
--

INSERT INTO `nizwa_packing_productstasks` VALUES (1,'design','',1,0,1,'2023-03-25','',1,'to_do',1,'2023-03-21','',10000000,0,1,'months',0,0,0,'2023-03-21',NULL,'0000-00-00',0,0);

--
-- Table structure for table `nizwa_packing_productstaxes`
--

CREATE TABLE `nizwa_packing_productstaxes` (
  `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=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nizwa_packing_productstaxes`
--

INSERT INTO `nizwa_packing_productstaxes` VALUES (1,'VAT (5%)',5,0),(2,'SPD- vat (3%)',3,1),(3,'SPD-Vat ( Nill) new agreement (0%)',0,1);

--
-- Table structure for table `nizwa_packing_productsteam`
--

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


--
-- Table structure for table `nizwa_packing_productsteam_member_job_info`
--

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

--
-- Dumping data for table `nizwa_packing_productsteam_member_job_info`
--


--
-- Table structure for table `nizwa_packing_productsticket_comments`
--

CREATE TABLE `nizwa_packing_productsticket_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 `nizwa_packing_productsticket_comments`
--


--
-- Table structure for table `nizwa_packing_productsticket_types`
--

CREATE TABLE `nizwa_packing_productsticket_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 `nizwa_packing_productsticket_types`
--

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

--
-- Table structure for table `nizwa_packing_productstickets`
--

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


--
-- Table structure for table `nizwa_packing_productsto_do`
--

CREATE TABLE `nizwa_packing_productsto_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 `nizwa_packing_productsto_do`
--


--
-- Table structure for table `nizwa_packing_productstransactions`
--

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

--
-- Dumping data for table `nizwa_packing_productstransactions`
--

INSERT INTO `nizwa_packing_productstransactions` VALUES (53,'2023-02-04','Automatic General Expense: Bank',0,NULL,0,0),(54,'2023-03-21','Invoice: AMI/1',0,NULL,0,0),(55,'2023-03-21','Invoice: Invoice/2',0,NULL,0,0),(56,'2023-03-21','Invoice: Invoice/3',0,NULL,0,0),(57,'2023-03-21','Invoice Payment Received: Invoice/2',0,NULL,0,0),(58,'2023-03-21','Invoice Payment Received: Invoice/2',0,NULL,0,0),(59,'2023-03-21','Purchase Order: PURCHASE ORDER #1',0,NULL,0,0),(60,'2023-03-21','Automatic Purchase Payment: PURCHASE ORDER #1',0,NULL,0,0),(61,'2023-03-21','Invoice Shipment : Invoice/1',0,NULL,0,0),(62,'2023-05-14','Invoice: Invoice/5',0,NULL,0,0),(63,'2023-05-14','Invoice: Invoice/7',0,NULL,0,0),(64,'2023-09-07','Invoice: Invoice/8',0,NULL,0,0),(65,'2023-09-07','Invoice: Invoice/9',0,NULL,0,0),(66,'2023-09-07','Invoice Payment Received: Invoice/9',0,NULL,0,0),(67,'2023-09-07','Invoice Payment Received: Invoice/9',0,NULL,0,0);

--
-- Table structure for table `nizwa_packing_productsusers`
--

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

--
-- Dumping data for table `nizwa_packing_productsusers`
--

INSERT INTO `nizwa_packing_productsusers` VALUES (1,'0','hamed','ghatrifi',-1,'staff',1,0,'admin@admin.com','e10adc3949ba59abbe56e057f20f883e','','active','2023-05-14 13:50:55',0,'2023-01-18 12:49:48',0,'Admin',0,NULL,'nppoman@gmail.com','','96761616','','2022-07-05','','male','',NULL,'',1,1,'2022-07-05 11:14:59','2023-09-11 12:18:13',80,81,82,'','0000-00-00','','0000-00-00',0,1,0);


