-- Table structure for table `BinYdeedclient_groups`
--

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

--
-- Dumping data for table `BinYdeedclient_groups`
--

INSERT INTO `BinYdeedclient_groups` VALUES (1,'sohar industrial area',0),(2,'Sohar  port',0),(3,'Free Zone',0),(4,'Gala Industrial ',0),(5,'Rusayl Industrial Area',0);

--
-- Table structure for table `BinYdeedclients`
--

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

--
-- Dumping data for table `BinYdeedclients`
--

INSERT INTO `BinYdeedclients` VALUES (1,'Bin Ydeed Trading ','Sohar','','','','','2022-10-06','www.binydeed.com','99224522','','','1',0,0,0,0,0,0,'','0000-00-00','OM1100039942','',0,NULL,86,0,'sales@binydeed.com'),(2,'SOHAR ALUMINIUM COMPANY LLC','PO Box 80,Sohar Industrial Estate, PC 327, Sohar, Sultanate of Oman\n','','','','','2022-10-06','','96408797','','','1',0,0,0,0,0,0,'','0000-00-00','OM110000263X','',0,NULL,85,0,'HamedRashid.ALALAWI@sohar-aluminium.com'),(3,'National Plastic Factory LLC','P.O. Box: 371, Muttrah, PC:114, \nSultante of Oman','','','','','2022-10-08','','98153829','','','5',0,0,0,0,0,0,'','0000-00-00','OM1100013160','',0,NULL,94,0,'info@natonalplasticoman.com'),(4,'CASH CUSTOMER ','Mr. Faysal Liwa',NULL,NULL,NULL,NULL,'2022-10-11',NULL,'99776634',NULL,'','',0,0,0,0,0,0,'','0000-00-00',NULL,NULL,0,NULL,0,0,NULL);

--
-- Table structure for table `BinYdeedcontacts`
--

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

--
-- Dumping data for table `BinYdeedcontacts`
--


--
-- Table structure for table `BinYdeedcustom_field_values`
--

CREATE TABLE `BinYdeedcustom_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 `BinYdeedcustom_field_values`
--


--
-- Table structure for table `BinYdeedcustom_fields`
--

CREATE TABLE `BinYdeedcustom_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 `BinYdeedcustom_fields`
--


--
-- Table structure for table `BinYdeedcustom_widgets`
--

CREATE TABLE `BinYdeedcustom_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 `BinYdeedcustom_widgets`
--


--
-- Table structure for table `BinYdeeddashboards`
--

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


--
-- Table structure for table `BinYdeeddelivery_note_items`
--

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

--
-- Dumping data for table `BinYdeeddelivery_note_items`
--

INSERT INTO `BinYdeeddelivery_note_items` VALUES (1,15,17,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',2,'SET',65,130,0,1,0),(2,2,13,'Deestone','17.5/25 16PR D318 DEESTONE THAILAND TL',4,'SET',215,860,0,2,0),(3,4,14,'15.5/80/24 12PR D308 E4 EU TL','DEESTONE THAILAND ',7,'PCS',150,1500,0,2,0),(4,18,15,'DEESTONE THAILAND','600/9 10PR D306 EU DEESTONE THAILAND TTF',0,'SET',35,350,0,2,0),(5,43,23,'325/95R24 22PR BT666  TF','BOTO BTR',2,'SET',110.5,221,0,3,0),(6,42,24,'1200R24-20PR BT157 TF','BOTO BTR',4,'SET',105,420,0,3,0);

--
-- Table structure for table `BinYdeeddelivery_notes`
--

CREATE TABLE `BinYdeeddelivery_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 `BinYdeeddelivery_notes`
--

INSERT INTO `BinYdeeddelivery_notes` VALUES (1,8,3,0,'2022-10-10','Note: 5Ton Forklfit \n1. PAYMENT :30 Day Cerdit\n2. tyres price NOT including fitting.\n3. Delivery Terms: Delivery Terms: Immediately \n4. Validity for Quote: 7days\n5. WARRENTY : 1 Year against any manufacturing defects on pro rata basis\n','approved',1),(2,6,2,0,'2022-10-10','Srihari .K. Kulkarni','approved',1),(3,11,4,0,'2022-10-10','1. payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat','approved',0);

--
-- Table structure for table `BinYdeedemail_templates`
--

CREATE TABLE `BinYdeedemail_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 `BinYdeedemail_templates`
--


--
-- Table structure for table `BinYdeedenteries`
--

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

--
-- Dumping data for table `BinYdeedenteries`
--

INSERT INTO `BinYdeedenteries` VALUES (1,1,85,'dr',1128.75,'Invoice: INVOICE #3',0,0,'0',0,1),(2,1,26,'cr',53.75,'Invoice: INVOICE #3',0,0,'0',0,1),(3,1,26,'cr',1075,'Invoice: INVOICE #3',0,0,'0',0,1),(4,2,86,'dr',4961.25,'Invoice: INVOICE #5',0,0,'0',0,1),(5,2,26,'cr',236.25,'Invoice: INVOICE #5',0,0,'0',0,1),(6,2,26,'cr',4725,'Invoice: INVOICE #5',0,0,'0',0,1),(7,3,85,'cr',100,'Invoice Payment Received: INVOICE #6 test',0,0,'0',0,1),(8,3,26,'dr',100,'Invoice Payment Received: INVOICE #6 test',0,0,'0',0,1),(9,4,85,'cr',1500,'Invoice Payment Received: INVOICE #6 cheqeu received',0,0,'0',0,1),(10,4,900,'dr',1500,'Invoice Payment Received: INVOICE #6 cheqeu received',0,0,'0',0,1),(11,5,26,'dr',2710,'Sale Return: SALE RETURN #1',0,0,'0',0,0),(12,5,26,'dr',118,'Sale Return: SALE RETURN #1',0,0,'0',0,0),(13,5,85,'cr',2828,'Sale Return: SALE RETURN #1',0,0,'0',0,0),(14,6,85,'dr',2828,'Sale Return Refund: SALE RETURN #1 item no2\n',0,0,'0',0,0),(15,6,26,'cr',2828,'Sale Return Refund: SALE RETURN #1 item no2\n',0,0,'0',0,0),(16,7,26,'dr',673.05,'Invoice: INVOICE #11',0,0,'0',0,0),(17,7,26,'cr',32.05,'Invoice: INVOICE #11',0,0,'0',0,1),(18,7,26,'cr',641,'Invoice: INVOICE #11',0,0,'0',0,1),(19,8,26,'dr',0,'INVOICE #11',0,0,'0',0,0),(20,8,26,'cr',0,'INVOICE #11',0,0,'0',0,0),(21,7,9,'cr',100,'kljio',0,0,NULL,0,1),(22,9,26,'cr',673.05,'Invoice Payment Received: INVOICE #11 payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat',0,0,'0',0,0),(23,9,900,'dr',673.05,'Invoice Payment Received: INVOICE #11 payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat',0,0,'0',0,0),(24,10,26,'cr',673.05,'Invoice Payment Received: INVOICE #11 payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat',0,0,'0',0,0),(25,10,900,'dr',673.05,'Invoice Payment Received: INVOICE #11 payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat',0,0,'0',0,0);

--
-- Table structure for table `BinYdeedestimate_forms`
--

CREATE TABLE `BinYdeedestimate_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 `BinYdeedestimate_forms`
--


--
-- Table structure for table `BinYdeedestimate_items`
--

CREATE TABLE `BinYdeedestimate_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,
  `cost` double NOT NULL DEFAULT '0',
  `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=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BinYdeedestimate_items`
--

INSERT INTO `BinYdeedestimate_items` VALUES (1,2,'Deestone','17.5/25 16PR D318 DEESTONE THAILAND TL',4,'SET',215,0,860,1,1,0,0),(2,2,'Deestone','17.5/25 16PR D318 DEESTONE THAILAND TL',4,'SET',215,0,860,2,1,0,1),(3,4,'15.5/80/24 12PR D308 E4 EU TL','DEESTONE THAILAND ',10,'PCS',150,0,1500,1,1,0,0),(4,18,'DEESTONE THAILAND','600/9 10PR D306 EU DEESTONE THAILAND TTF',10,'SET',35,0,350,1,0,0,0),(5,15,'700/12 12PR D301 EU DEESTONE THAILAND TL','700/12 12PR D301 EU DEESTONE THAILAND TL',2,'SET',60,0,120,2,1,0,1),(6,18,'DEESTONE THAILAND','700/12 12PR D301 EU TTF',2,'SET',60,0,120,2,1,0,1),(7,18,'DEESTONE THAILAND','700/12 12PR D301 EU TTF',2,'SET',60,0,120,2,1,0,1),(8,15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',2,'SET',65,0,130,2,1,0,0),(9,4,'15.5/80/24 12PR D308 E4 EU TL ','DEESTONE THAILAND',1,'PCS',150,0,150,3,1,0,0),(10,8,'18.4/26 12PR D314 E4 EU TL','DEESTONE THAILAND',1,'PCS',175,0,175,3,1,0,0),(11,7,'DEESTONE THAILAND ','17.5/25 16PR D318 EU TL',1,'PCS',215,0,215,3,1,0,0),(12,18,'DEESTONE THAILAND ','600/9 10PR D306 EU TTF',10,'SET',35,0,350,3,1,0,0),(13,18,'DEESTONE THAILAND ','600/9 10PR D306 EU TTF',20,'SET',35,0,700,3,1,0,0),(14,3,'315/80R22.5 20PR BT168 TL ','BOTO CHINA',10,'PCS',75,0,750,3,1,0,0),(15,4,'15.5/80/24 12PR D308 E4 EU TL ','DEESTONE THAILAND',1,'PCS',150,0,150,4,1,0,0),(16,8,'18.4/26 12PR D314 E4 EU TL','DEESTONE THAILAND',1,'PCS',175,0,175,4,1,0,0),(17,7,'DEESTONE THAILAND ','17.5/25 16PR D318 EU TL',1,'PCS',215,0,215,4,1,0,0),(18,18,'DEESTONE THAILAND ','600/9 10PR D306 EU TTF',10,'SET',35,0,350,4,1,0,0),(19,18,'DEESTONE THAILAND ','600/9 10PR D306 EU TTF',20,'SET',35,0,700,4,1,0,0),(20,3,'315/80R22.5 20PR BT168 TL ','BOTO CHINA',10,'PCS',75,0,750,4,1,0,0);

--
-- Table structure for table `BinYdeedestimate_requests`
--

CREATE TABLE `BinYdeedestimate_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 `BinYdeedestimate_requests`
--


--
-- Table structure for table `BinYdeedestimates`
--

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

INSERT INTO `BinYdeedestimates` VALUES (1,2,0,'2022-10-07','2022-10-14','1. price with out fitting\n2. One Year warranty\n3. delivery immediately ',NULL,'accepted',0,0,'before_tax',0,'percentage',0,0),(2,3,0,'2022-10-07','2022-10-14','1. price with fitting\n2. One Year warranty\n3. delivery immediately ',NULL,'accepted',0,0,'before_tax',10,'fixed_amount',0,0),(3,3,0,'2022-10-10','2022-10-17','Note:10 Ton Forklfit \n1. PAYMENT :30 Day Cerdit\n2. tyres price NOT including fitting.\n3. Delivery Terms: Delivery Terms: Immediately \n4. Validity for Quote: 7days\n5. WARRENTY : 1 Year against any manufacturing defects on pro rata basis\n',NULL,'draft',0,0,'before_tax',0,'fixed_amount',0,0),(4,2,0,'2022-10-10','2022-10-17','Note:10 Ton Forklfit \n1. PAYMENT :30 Day Cerdit\n2. tyres price NOT including fitting.\n3. Delivery Terms: Delivery Terms: Immediately \n4. Validity for Quote: 7days\n5. WARRENTY : 1 Year against any manufacturing defects on pro rata basis\n',NULL,'draft',0,0,'before_tax',0,'fixed_amount',0,0);

--
-- Table structure for table `BinYdeedevents`
--

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

--
-- Dumping data for table `BinYdeedevents`
--


--
-- Table structure for table `BinYdeedexpense_categories`
--

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

--
-- Dumping data for table `BinYdeedexpense_categories`
--

INSERT INTO `BinYdeedexpense_categories` VALUES (1,'Electricity',80,0),(2,'Diesel ',87,0),(3,'Petroleum for Car',88,0),(4,'water',89,0),(5,'stationary',90,0),(6,'Salary',91,0),(7,'Travel Expense',92,0),(8,'Tools',93,0);

--
-- Table structure for table `BinYdeedexpenses`
--

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

--
-- Dumping data for table `BinYdeedexpenses`
--

INSERT INTO `BinYdeedexpenses` VALUES (1,'2022-10-08',3,'pet. for MG96198B',10,'bank','2022-10-08',NULL,'',0,0,'a:0:{}','',0,1,0,'draft',1,0,0,0);

--
-- Table structure for table `BinYdeedgeneral_files`
--

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

--
-- Dumping data for table `BinYdeedgeneral_files`
--

INSERT INTO `BinYdeedgeneral_files` VALUES (1,'_file633e5876cb984-cr_certificate-1166793--new.pdf',NULL,NULL,'Company CR',1027712,'2022-10-06 04:24:22',0,0,1,1,0);

--
-- Table structure for table `BinYdeedhelp_articles`
--

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

--
-- Dumping data for table `BinYdeedhelp_articles`
--


--
-- Table structure for table `BinYdeedhelp_categories`
--

CREATE TABLE `BinYdeedhelp_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 `BinYdeedhelp_categories`
--

INSERT INTO `BinYdeedhelp_categories` VALUES (1,'Electricity bill','Ele. for Romm No:15','knowledge_base',0,'active',0);

--
-- Table structure for table `BinYdeedinternal_transactions`
--

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

--
-- Dumping data for table `BinYdeedinternal_transactions`
--


--
-- Table structure for table `BinYdeedinvoice_items`
--

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

--
-- Dumping data for table `BinYdeedinvoice_items`
--

INSERT INTO `BinYdeedinvoice_items` VALUES (1,1,'315/80R22.5 20PR BT168 BOTO CHINA','315/80R22.5 20PR BT168 BOTO CHINA',10,'SET',75,0,750,0,1,0,0,1),(2,1,'315/80R22.5 20PR BT168 BOTO CHINA','315/80R22.5 20PR BT168 BOTO CHINA',50,'SET',75,0,3750,0,1,0,0,1),(3,1,'315/80R22.5 20PR BT168 BOTO CHINA','315/80R22.5 20PR BT168 BOTO CHINA',50,'SET',75,0,3750,0,1,0,0,1),(4,1,'315/80R22.5 20PR BT168 BOTO CHINA','315/80R22.5 20PR BT168 BOTO CHINA',10,'SET',75,0,750,0,2,0,0,0),(5,2,'Deestone','17.5/25 16PR D318 DEESTONE THAILAND TL',5,'SET',215,0,1075,0,3,0,0,0),(6,13,'300/15 20PR D301 EU DEESTONE THAILAND TL','',5,'SET',45,0,225,0,4,0,0,0),(7,14,'650/10 10PR D301 EU DEESTONE THAILAND TL','650/10 10PR D301 EU DEESTONE THAILAND TL',10,'SET',45,0,450,0,4,0,0,0),(8,13,'300/15 20PR D301 EU DEESTONE THAILAND TL','300/15 20PR D301 EU DEESTONE THAILAND TL',20,'SET',105,0,2100,0,4,0,0,0),(9,15,'700/12 12PR D301 EU DEESTONE THAILAND TL','700/12 12PR D301 EU DEESTONE THAILAND TL',10,'SET',70,0,700,0,4,0,0,0),(10,7,'17.5/15','',15,'SET',35,0,525,0,5,0,0,1),(11,7,'17.5/25 16PR D318 EU DEESTONE THAILAND TL','17.5/25 16PR D318 EU DEESTONE THAILAND TL',15,'PCS',215,0,3225,0,5,0,0,0),(12,4,'15.5/80/24 12PR D308 E4 EU TL','DEESTONE THAILAND ',10,'PCS',150,0,1500,0,5,0,0,0),(13,2,'Deestone','17.5/25 16PR D318 DEESTONE THAILAND TL',4,'SET',215,0,860,0,6,1,0,0),(14,4,'15.5/80/24 12PR D308 E4 EU TL','DEESTONE THAILAND ',10,'PCS',150,0,1500,0,6,1,0,0),(15,18,'DEESTONE THAILAND','600/9 10PR D306 EU DEESTONE THAILAND TTF',10,'SET',35,0,350,0,6,0,0,0),(16,15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',2,'SET',65,0,130,0,7,1,0,0),(17,15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',2,'SET',65,0,130,0,8,1,0,0),(18,3,'315/80R22.5 20PR BT168 TL ','BOTO CHINA',10,'PCS',75,0,750,0,9,0,0,0),(19,15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',100,'SET',60,0,6000,0,9,0,0,0),(20,18,'DEESTONE THAILAND ','600/9 10PR D306 EU TTF',10,'SET',35,0,350,0,9,0,0,0),(21,4,'15.5/80/24 12PR D308 E4 EU TL ','DEESTONE THAILAND',30,'PCS',150,0,4500,0,9,0,0,0),(22,15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ',2,'SET',65,0,130,0,10,1,0,0),(23,43,'325/95R24 22PR BT666  TF','BOTO BTR',2,'SET',110.5,0,221,0,11,0,0,0),(24,42,'1200R24-20PR BT157 TF','BOTO BTR',4,'SET',105,0,420,0,11,0,0,0);

--
-- Table structure for table `BinYdeedinvoice_payments`
--

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

--
-- Dumping data for table `BinYdeedinvoice_payments`
--

INSERT INTO `BinYdeedinvoice_payments` VALUES (1,1128.75,'2022-11-07',4,'2022-10-07','','','',0,'transfer to binydeed after one month',3,'draft',1,NULL,0,0,1,'2022-10-07 19:33:27'),(2,126.5,'2022-11-10',4,'2022-10-10','','','',0,'1. PAyment : 30 day Cerdit',8,'draft',0,NULL,0,0,1,'2022-10-10 07:38:46'),(3,100,'2022-10-10',1,'2022-10-10','','','',0,'test',6,'approved',0,NULL,3,0,1,'2022-10-10 08:21:40'),(4,1500,'2022-10-10',4,'2022-10-10','','','',0,'cheqeu received',6,'approved',0,NULL,4,0,1,'2022-10-10 08:22:22'),(5,673.05,'2022-10-11',4,'2022-10-11','','','',0,'payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat',11,'approved',0,NULL,10,0,1,'2022-10-11 05:14:17');

--
-- Table structure for table `BinYdeedinvoices`
--

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

--
-- Dumping data for table `BinYdeedinvoices`
--

INSERT INTO `BinYdeedinvoices` VALUES (1,1,0,'2022-10-06','2022-10-06','','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(2,2,0,'2022-10-06','2022-10-06','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,10,'fixed_amount','',NULL,0,0,0,1),(3,2,0,'2022-10-07','2022-10-07','1. Payment: 30 day credit\n2. Serial No: Noted','',NULL,'not_paid','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(4,1,0,'2022-10-08','2022-10-08','','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(5,1,0,'2022-10-08','2022-10-08','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(6,2,0,'2022-10-08','2022-10-08','hfg \nljklj\n;io;i','',NULL,'not_paid','delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(7,3,0,'2022-10-10','2022-11-10','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(8,3,0,'2022-10-10','2022-10-10','','',NULL,'not_paid','delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(9,3,0,'2022-10-10','2022-10-10','dsd','',NULL,'draft','not_delivered','not_approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'fixed_amount','',NULL,0,0,0,1),(10,3,0,'2022-10-10','2022-10-10','','',NULL,'draft','not_delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,1),(11,4,0,'2022-10-11','2022-10-11','Note:\n1. Serial No: 2111201256,2201308631,2201313864,2201313860\n1102208082,1112303077\n2. As Agree Tyres with out warranty\n3. payment transfer to Acc.\n0347023913120019\nBin Ydeed Trading \nBank Muscat','',NULL,'not_paid','delivered','approved',1,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0);

--
-- Table structure for table `BinYdeeditem_categories`
--

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

--
-- Dumping data for table `BinYdeeditem_categories`
--

INSERT INTO `BinYdeeditem_categories` VALUES (1,'BOTO OTR CHINA',0),(2,'BOTO BTR CHINA',0),(3,'DEESTONE THAILAND',0),(4,'DEESTONE OTR',0),(5,'ECOMASTER STD',0),(6,'ECOMASTER CLIP',0),(7,'Fitting',0),(8,'Used tyres',0),(9,'Rim',0),(10,'BOTO BTR',0),(11,'BOTO OTR',0);

--
-- Table structure for table `BinYdeeditems`
--

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

--
-- Dumping data for table `BinYdeeditems`
--

INSERT INTO `BinYdeeditems` VALUES (1,'315/80R22.5 20PR BT168 BOTO CHINA','315/80R22.5 20PR BT168 BOTO CHINA','SET',63,75,2,'service',1),(2,'DEESTONE','17.5/25 16PR D318 DEESTONE THAILAND TL','SET',170,215,4,'service',1),(3,'315/80R22.5 20PR BT168 TL ','BOTO CHINA','PCS',61,75,2,'service',0),(4,'15.5/80/24 12PR D308 E4 EU TL ','DEESTONE THAILAND','PCS',110,150,4,'service',0),(5,'1000/20 16PR D309 TTF','DEESTONE THAILAND ','SET',66.3,96,4,'service',0),(6,'15.5/25 12PR DL-2 E3/L3  TL','DEESTONE THAILAND','PCS',142,185,4,'service',0),(7,'17.5/25 16PR D318 EU TL','DEESTONE THAILAND ','PCS',170,215,4,'service',0),(8,'18.4/26 12PR D314 E4 EU TL','DEESTONE THAILAND','PCS',146,175,4,'service',0),(9,'1400/24 16PR D310 EU TL','DEESTONE THAILAND','pcs',141.5,165,4,'service',0),(10,'1600/25 32PR D313 EU TL','DEESTONE THAILAND','pcs',351,420,4,'service',0),(11,'20.5/25 20PR D313 EU TL ','DEESTONE THAILAND','pcs',274,350,4,'service',0),(12,'10/16.5 10PR D311 EU TL','DEESTONE THAILAND ','pcs',31,45,4,'service',0),(13,'300/15 20PR D301 EU TTF','DEESTONE THAILAND ','SET',71,105,3,'service',0),(14,'650/10 10PR D301 EU TTF','DEESTONE THAILAND ','SET',20,45,3,'service',0),(15,'700/12 12PR D301 EU TTF','DEESTONE THAILAND ','SET',30,60,3,'service',0),(16,'815/15(28/9/15) 14PR D301 EU TTF','DEESTONE THAILAND ','SET',39,72,3,'service',0),(17,'825/15 14PR D301 EU TTF','DEESTONE THAILAND ','SET',47,105,3,'service',0),(18,'600/9 10PR D306 EU TTF','DEESTONE THAILAND ','SET',20,35,3,'service',0),(19,'600/9  4.00 X STD treme Plus ','Ecomaster Sri lanka','PCS',24,45,5,'product',0),(20,'6.50-10  5.00 STD X treme Plus ','Ecomaster Sri lanka','PCS',33.3,75,5,'product',0),(21,'7.00-12/5.00  STD X treme Plus ','Ecomaster Sri lanka','PCS',44,105,5,'product',0),(22,'300-15 8.00 STD SOLID ','Ecomaster Sri lanka','PCS',104,195,5,'product',0),(23,'815/15(28/9/15)  7.00 X treme Plus ','ECOMASTER STD','PCS',57.6,110,5,'product',0),(24,'825/15 6.5 ECOMASTER','ECOMASTER STD','PCS',83.9,145,5,'product',0),(25,'900/20 6.5 ECOMASTER','ECOMASTER STD','PCS',129,195,5,'product',0),(26,'1200/20 8.5 ECOMASTER','ECOMASTER STD','PCS',200,350,5,'product',0),(27,'1000/20 8.5 ECOMASTER','ECOMASTER STD','PCS',152,250,5,'product',0),(28,'500/8 3.00 ECOMASTER','ECOMASTER CLIP','PCS',16.6,35,6,'product',0),(29,'16/6/8 .00 ECOMASTER','ECOMASTER CLIP','PCS',16.4,40,6,'product',0),(30,'140/55/9 4.00 ECOMASTER','ECOMASTER CLIP','PCS',20,40,6,'product',0),(31,'15-4-1/2-8 ECOMASTER','ECOMASTER CLIP','PCS',10.7,35,6,'product',0),(32,'18/7/8 4.33ECOMASTER','ECOMASTER CLIP','PCS',21,45,6,'product',0),(33,'600/9 4.0  X treme Plus ','ECOMASTER CLIP','PCS',25,55,6,'product',0),(34,'650/10 5.0  X treme Plus ','ECOMASTER CLIP','PCS',34.6,80,6,'product',0),(35,'300/15 8.00 ECOMASTER','ECOMASTER CLIP','PCS',107.3,200,6,'product',0),(36,'815/15  7.00  X treme Plus ','ECOMASTER CLIP','PCS',59.3,115,6,'product',0),(37,'7.00-12/5.00   X treme Plus ','ECOMASTER CLIP','PCS',45.7,105,6,'product',0),(38,'825/15  6.5 ECOMASTER','ECOMASTER CLIP','PCS',86.4,150,6,'product',0),(39,'27/10/12 7.0    ECOMASTER','ECOMASTER CLIP','PCS',73,115,6,'product',0),(40,'250/15 7.0    ECOMASTER','ECOMASTER CLIP','PCS',68,110,6,'product',0),(41,'1200R24-20PR BT168 TF','BOTO CHINA','SET',77,95,10,'product',0),(42,'1200R24-20PR BT157 TF','BOTO CHINA','SET',82,110,10,'product',0),(43,'325/95R24 22PR BT666  TF','BOTO CHINA','SET',88,115,10,'product',0),(44,'13R22.5 18PR BT168','BOTO CHINA','PCS',70,85,10,'product',0),(45,'315/80R22.5 20PR BT168','BOTO CHINA','PCS',62,75,10,'product',0),(46,'315/80R22.5 20PR BT968','BOTO CHINA','PCS',62,75,10,'product',0),(47,'825R16 18PR BT288','BOTO CHINA','SET',34,60,10,'product',0),(48,'385/65R22.5 BT215N','BOTO CHINA','PCS',72,85,10,'product',0),(49,'385/65R22.5 BT668','BOTO CHINA','PCS',67,85,10,'product',0),(50,'750R16 16PR BT288 TTF','BOTO CHINA','SET',30,38,10,'product',0),(51,'20.5R25** GCB5 E3/L3 TL','BOTO CHINA','SET',323,420,11,'product',0),(52,'23.5R25** GCB5 L3 TL','BOTO CHINA','SET',444,540,11,'product',0),(53,'26.5R25** GCB5 L3 TL ','BOTO CHINA','SET',613,740,11,'product',0),(54,'29.5R25** GCA1 E3/L3 TL','BOTO CHINA','PCS',830,1070,11,'product',0);

--
-- Table structure for table `BinYdeedlead_source`
--

CREATE TABLE `BinYdeedlead_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 `BinYdeedlead_source`
--


--
-- Table structure for table `BinYdeedlead_status`
--

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

--
-- Dumping data for table `BinYdeedlead_status`
--


--
-- Table structure for table `BinYdeedleads`
--

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


--
-- Table structure for table `BinYdeedleave_applications`
--

CREATE TABLE `BinYdeedleave_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 `BinYdeedleave_applications`
--


--
-- Table structure for table `BinYdeedleave_types`
--

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

--
-- Dumping data for table `BinYdeedleave_types`
--

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

--
-- Table structure for table `BinYdeedloans`
--

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


--
-- Table structure for table `BinYdeedmessages`
--

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

--
-- Dumping data for table `BinYdeedmessages`
--

INSERT INTO `BinYdeedmessages` VALUES (1,'hy','test','2022-10-06 15:00:54',1,2,'unread',0,0,'a:0:{}',''),(2,'system user','sales@binydeed.com\nosaosa20','2022-10-10 06:42:27',1,2,'unread',0,0,'a:0:{}','');

--
-- Table structure for table `BinYdeedmilestones`
--

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


--
-- Table structure for table `BinYdeednotes`
--

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


--
-- Table structure for table `BinYdeednotification_settings`
--

CREATE TABLE `BinYdeednotification_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 `BinYdeednotification_settings`
--

INSERT INTO `BinYdeednotification_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,'1','1','client_primary_contact,client_all_contacts',22,0),(43,'invoice_overdue_reminder','invoice',0,0,'','','',22,0),(44,'recurring_invoice_creation_reminder','invoice',1,0,'2','2','client_primary_contact',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 `BinYdeednotifications`
--

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

--
-- Dumping data for table `BinYdeednotifications`
--

INSERT INTO `BinYdeednotifications` VALUES (1,1,'','2022-09-28 12:05:09','','','project_created',1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `BinYdeedpayment_methods`
--

CREATE TABLE `BinYdeedpayment_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 `BinYdeedpayment_methods`
--

INSERT INTO `BinYdeedpayment_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 `BinYdeedpaypal_ipn`
--

CREATE TABLE `BinYdeedpaypal_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 `BinYdeedpaypal_ipn`
--


--
-- Table structure for table `BinYdeedpayroll`
--

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

--
-- Dumping data for table `BinYdeedpayroll`
--


--
-- Table structure for table `BinYdeedpayroll_detail`
--

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

--
-- Dumping data for table `BinYdeedpayroll_detail`
--


--
-- Table structure for table `BinYdeedposts`
--

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

--
-- Dumping data for table `BinYdeedposts`
--

INSERT INTO `BinYdeedposts` VALUES (1,1,'2022-10-06 14:54:06','Sohar Aluminium',0,'','a:1:{i:0;a:4:{s:9:\"file_name\";s:76:\"timeline_post_file633eec0e399ce-Sohar-Aluminium-CO-LLC.,PO-No_4500083929.PDF\";s:9:\"file_size\";s:5:\"41055\";s:7:\"file_id\";N;s:12:\"service_type\";N;}}',0);

--
-- Table structure for table `BinYdeedproject_comments`
--

CREATE TABLE `BinYdeedproject_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 `BinYdeedproject_comments`
--


--
-- Table structure for table `BinYdeedproject_files`
--

CREATE TABLE `BinYdeedproject_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 `BinYdeedproject_files`
--


--
-- Table structure for table `BinYdeedproject_members`
--

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

--
-- Dumping data for table `BinYdeedproject_members`
--


--
-- Table structure for table `BinYdeedproject_settings`
--

CREATE TABLE `BinYdeedproject_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 `BinYdeedproject_settings`
--


--
-- Table structure for table `BinYdeedproject_time`
--

CREATE TABLE `BinYdeedproject_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 `BinYdeedproject_time`
--


--
-- Table structure for table `BinYdeedprojects`
--

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

--
-- Dumping data for table `BinYdeedprojects`
--


--
-- Table structure for table `BinYdeedpurchase_order_items`
--

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

--
-- Dumping data for table `BinYdeedpurchase_order_items`
--


--
-- Table structure for table `BinYdeedpurchase_order_payments`
--

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

--
-- Dumping data for table `BinYdeedpurchase_order_payments`
--


--
-- Table structure for table `BinYdeedpurchase_orders`
--

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

--
-- Dumping data for table `BinYdeedpurchase_orders`
--


--
-- Table structure for table `BinYdeedpurchase_return_items`
--

CREATE TABLE `BinYdeedpurchase_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 `BinYdeedpurchase_return_items`
--


--
-- Table structure for table `BinYdeedpurchase_returns`
--

CREATE TABLE `BinYdeedpurchase_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 `BinYdeedpurchase_returns`
--


--
-- Table structure for table `BinYdeedroles`
--

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

--
-- Dumping data for table `BinYdeedroles`
--

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

--
-- Table structure for table `BinYdeedsalary_advance`
--

CREATE TABLE `BinYdeedsalary_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 `BinYdeedsalary_advance`
--


--
-- Table structure for table `BinYdeedsale_return_items`
--

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

--
-- Dumping data for table `BinYdeedsale_return_items`
--

INSERT INTO `BinYdeedsale_return_items` VALUES (1,1,2,13,4,0,0),(2,1,4,14,10,0,0),(3,1,18,15,10,0,0);

--
-- Table structure for table `BinYdeedsale_returns`
--

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

--
-- Dumping data for table `BinYdeedsale_returns`
--

INSERT INTO `BinYdeedsale_returns` VALUES (1,6,2,1,0,'2022-10-10','approved','item no2\n',0);

--
-- Table structure for table `BinYdeedsettings`
--

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

INSERT INTO `BinYdeedsettings` 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','BIN YDEED TRADING LLC','app',0),('attendance_password','94269935','app',0),('client_can_add_project_files','1','app',0),('client_can_comment_on_files','1','app',0),('client_can_comment_on_tasks','1','app',0),('client_can_create_projects','1','app',0),('client_can_create_tasks','1','app',0),('client_can_edit_tasks','1','app',0),('client_can_view_activity','1','app',0),('client_can_view_gantt','1','app',0),('client_can_view_milestones','1','app',0),('client_can_view_overview','1','app',0),('client_can_view_project_files','1','app',0),('client_can_view_tasks','1','app',0),('client_default_dashboard','','app',0),('client_message_own_contacts','1','app',0),('client_message_users','5','app',0),('company_address','Post Box No: 87, Postal Code: 322, Falaj algabail \nSuhar, Sultanate of Oman','app',0),('company_email','osama@binydeed.com','app',0),('company_name','BIN YDEED TRADING LLC','app',0),('company_phone','00968 - 91177342','app',0),('company_vat_number','OM1100039942','app',0),('company_website','www.binydeed.com','app',0),('currency_position','right','app',0),('currency_symbol','OMR','app',0),('date_format','d-m-Y','app',0),('decimal_separator','.','app',0),('default_bank','900','app',0),('default_currency','OMR','app',0),('default_due_date_after_billing_date','','app',0),('disable_client_login','1','app',0),('disable_client_signup','1','app',0),('email_protocol','','app',0),('email_sent_from_address','info@teamway.om','app',0),('email_sent_from_name','Teamway','app',0),('email_smtp_host','','app',0),('email_smtp_pass','','app',0),('email_smtp_port','','app',0),('email_smtp_security_type','none','app',0),('email_smtp_user','','app',0),('enable_attendance','','app',0),('enable_email_piping','','app',0),('enable_google_calendar_api','','app',0),('enable_push_notification','','app',0),('enable_rich_text_editor','0','app',0),('estimate_color','054d7f ','app',0),('estimate_logo','','app',0),('favicon','a:1:{s:9:\"file_name\";s:30:\"_file633930244afe1-favicon.png\";}','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','1','app',0),('initial_number_of_the_invoice','12','app',0),('invoice_color','054d7f ','app',0),('invoice_footer','<p><br></p>','app',0),('invoice_logo','','app',0),('invoice_prefix','','app',0),('item_purchase_code','53434654','app',0),('language','english','app',0),('module_announcement','1','app',0),('module_attendance','','app',0),('module_chat','1','app',0),('module_estimate','1','app',0),('module_estimate_request','','app',0),('module_event','1','app',0),('module_expense','1','app',0),('module_help','','app',0),('module_invoice','1','app',0),('module_knowledge_base','1','app',0),('module_lead','1','app',0),('module_leave','1','app',0),('module_message','1','app',0),('module_note','1','app',0),('module_project_timesheet','','app',0),('module_ticket','','app',0),('module_timeline','1','app',0),('module_todo','1','app',0),('no_of_decimals','2','app',0),('project_reference_in_tickets','1','app',0),('pusher_app_id','929038','app',0),('pusher_cluster','eu','app',0),('pusher_key','2cbc86a72bfa9a85b0e5','app',0),('pusher_secret','53077cbb420c5e79c8f6','app',0),('rows_per_page','100','app',0),('scrollbar','native','app',0),('send_bcc_to','','app',0),('send_estimate_bcc_to','','app',0),('show_background_image_in_signin_page','yes','app',0),('show_logo_in_signin_page','yes','app',0),('show_recent_ticket_comments_at_the_top','1','app',0),('signin_page_background','','app',0),('site_logo','a:1:{s:9:\"file_name\";s:32:\"_file633930244a6f5-site-logo.png\";}','app',0),('ticket_prefix','','app',0),('time_format','capital','app',0),('timezone','Asia/Muscat','app',0),('user_1_allowed_distance','100000','user',0),('user_1_dashboard','','user',0),('user_1_disable_push_notification','0','user',0),('user_1_hidden_topbar_menus','','user',0),('user_1_location','23.620058326708097,58.24233084570313','user',0),('user_1_notification_sound_volume','4','user',0),('user_1_personal_language','english','user',0),('user_10_dashboard','','user',0),('user_10_personal_language','english','user',0),('user_11_dashboard','','user',0),('user_2_dashboard','','user',0),('user_21_dashboard','','user',0),('user_21_personal_language','english','user',0),('user_23_dashboard','','user',0),('user_24_dashboard','','user',0),('user_24_personal_language','arabic','user',0),('user_25_dashboard','','user',0),('user_25_personal_language','english','user',0),('user_3_dashboard','','user',0),('user_4_dashboard','','user',0),('user_5_allowed_distance','100000000','user',0),('user_5_dashboard','6','user',0),('user_5_disable_push_notification','1','user',0),('user_5_hidden_topbar_menus','','user',0),('user_5_location','23.673522614041882,57.680654820312505','user',0),('user_5_notification_sound_volume','7','user',0),('user_5_personal_language','english','user',0),('user_6_dashboard','','user',0),('user_6_personal_language','english','user',0),('weekend','5','app',0);

--
-- Table structure for table `BinYdeedshipment_items`
--

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

--
-- Dumping data for table `BinYdeedshipment_items`
--


--
-- Table structure for table `BinYdeedshipments`
--

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

--
-- Dumping data for table `BinYdeedshipments`
--


--
-- Table structure for table `BinYdeedsocial_links`
--

CREATE TABLE `BinYdeedsocial_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 `BinYdeedsocial_links`
--


--
-- Table structure for table `BinYdeedstock_adjustments`
--

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

--
-- Dumping data for table `BinYdeedstock_adjustments`
--

INSERT INTO `BinYdeedstock_adjustments` VALUES (1,1,50,'old stock',0),(2,2,10,'',0),(3,6,9,'opening balance',0),(4,5,6,'Opening Balance ',0),(5,4,10,'Opening Balance ',0),(6,2,5,'Opening Balance ',0),(7,7,10,'',0),(8,8,8,'opening balance\n',0),(9,9,4,'opening balance\n',0),(10,10,2,'opening balance',0),(11,11,6,'',0),(12,12,67,'opening balance\n',0),(13,13,21,'opening balance \n',0),(14,15,9,'opening balance\n',0),(15,16,22,'opening balance ',0),(16,17,85,'opening balance',0),(17,18,10,'opening balance',0),(18,43,2,'',0),(19,42,22,'opening balance',0);

--
-- Table structure for table `BinYdeedsuppliers`
--

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

--
-- Dumping data for table `BinYdeedsuppliers`
--


--
-- Table structure for table `BinYdeedtask_status`
--

CREATE TABLE `BinYdeedtask_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 `BinYdeedtask_status`
--

INSERT INTO `BinYdeedtask_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 `BinYdeedtasks`
--

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

--
-- Dumping data for table `BinYdeedtasks`
--


--
-- Table structure for table `BinYdeedtaxes`
--

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

--
-- Dumping data for table `BinYdeedtaxes`
--

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

--
-- Table structure for table `BinYdeedteam`
--

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

--
-- Dumping data for table `BinYdeedteam`
--

INSERT INTO `BinYdeedteam` VALUES (1,'Osama','1',0),(2,'Latifa','2',0),(3,'Said','1',0);

--
-- Table structure for table `BinYdeedteam_member_job_info`
--

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

--
-- Dumping data for table `BinYdeedteam_member_job_info`
--

INSERT INTO `BinYdeedteam_member_job_info` VALUES (1,2,'0000-00-00',0,400,NULL,8,30,0,0,0,0,0,1,'bank_muscat','',''),(2,3,'0000-00-00',0,0,NULL,0,0,0,0,0,0,0,1,NULL,NULL,NULL);

--
-- Table structure for table `BinYdeedticket_comments`
--

CREATE TABLE `BinYdeedticket_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 `BinYdeedticket_comments`
--


--
-- Table structure for table `BinYdeedticket_types`
--

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

--
-- Dumping data for table `BinYdeedticket_types`
--


--
-- Table structure for table `BinYdeedtickets`
--

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


--
-- Table structure for table `BinYdeedto_do`
--

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

--
-- Dumping data for table `BinYdeedto_do`
--

INSERT INTO `BinYdeedto_do` VALUES (1,1,'2022-10-06 14:39:54','call stone world pay','','','done',NULL,0),(2,1,'2022-10-06 14:40:11','mohammed riaz','','','done',NULL,0),(3,1,'2022-10-08 06:56:14','new invoice for National plastic 600/15 Glift','','','to_do',NULL,0),(4,1,'2022-10-08 07:15:40','call Mohamed Riaz payment ','','','to_do',NULL,0),(5,1,'2022-10-08 07:15:48','stone world','','','to_do',NULL,0),(6,1,'2022-10-08 07:16:16','check the statement for Sohar Aluminium','','','to_do',NULL,0);

--
-- Table structure for table `BinYdeedtransactions`
--

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

--
-- Dumping data for table `BinYdeedtransactions`
--

INSERT INTO `BinYdeedtransactions` VALUES (1,'2022-10-07','Invoice: INVOICE #3',0,NULL,0,0),(2,'2022-10-08','Invoice: INVOICE #5',0,NULL,0,0),(3,'2022-10-10','Invoice Payment Received: INVOICE #6',0,NULL,0,0),(4,'2022-10-10','Invoice Payment Received: INVOICE #6',0,NULL,0,0),(5,'2022-10-10','Sale Return: SALE RETURN #1',0,NULL,0,0),(6,'2022-10-10','Sale Return Refund: SALE RETURN #1',0,NULL,0,0),(7,'2022-10-11','journal_entry',1,'',0,0),(8,'2022-10-11','Invoice Inventory: INVOICE #11',0,NULL,0,0),(9,'2022-10-11','Invoice Payment Received: INVOICE #11',0,NULL,0,1),(10,'2022-10-11','Invoice Payment Received: INVOICE #11',0,NULL,0,0);

--
-- Table structure for table `Creative_Knowledgee_Landaccounts`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landaccounts`
--

INSERT INTO `Creative_Knowledgee_Landaccounts` VALUES (1,'Assets','1',0,1,0,NULL,NULL,NULL,0),(2,'Liabilities','2',0,1,0,NULL,0,NULL,0),(3,'Equity','3',0,1,0,NULL,0,NULL,0),(4,'Expenses','4',0,1,0,NULL,0,NULL,0),(5,'Income','5',0,1,0,NULL,0,NULL,0),(6,'Others','6',0,1,0,NULL,0,NULL,0),(7,'Receviable','1-1',1,1,0,NULL,0,NULL,0),(8,'Bank and Cash','1-7',1,1,0,'',NULL,NULL,0),(9,'Current Assets','1-3',1,1,0,NULL,0,NULL,0),(10,'Non Current Assets','1-4',1,1,0,NULL,0,NULL,0),(11,'Prepayments','1-5',1,1,0,NULL,0,NULL,0),(12,'Fixed Assets','1-6',1,1,0,NULL,0,NULL,0),(13,'Payable','2-1',2,1,0,NULL,0,NULL,0),(14,'Credit Card','2-2',2,1,0,NULL,0,NULL,0),(15,'Current Liabilities','2-3',2,1,0,NULL,0,NULL,0),(18,'Non Current Liabilities','2-4',2,1,0,NULL,0,NULL,0),(19,'Equity','3-1',3,1,0,NULL,0,NULL,0),(20,'Current Year Earnings','3-2',3,1,0,NULL,0,NULL,0),(21,'Expenses','4-1',4,1,0,NULL,0,NULL,0),(22,'Depreciation','4-2',4,1,0,NULL,0,NULL,0),(23,'Cost of Revenue','4-3',4,1,0,NULL,0,NULL,0),(24,'Revenue','5-3',5,1,0,'',NULL,NULL,0),(25,'Other Income','5-2',5,1,0,NULL,0,NULL,0),(26,'Off Balance Sheet','6-1',6,1,0,NULL,0,NULL,0),(38,'Advance Payments','2-5',2,1,0,NULL,0,NULL,0),(77,'Retained Earnings A/c','3-2-1',20,0,0,'',0,'clients',0),(903,'1047 0401904 001','NBO ',8,0,0,'CK Land 001',NULL,NULL,0),(904,'Colossal Engineering and cont llc','1-1-1',7,0,0,NULL,0,NULL,0),(905,'Al Diar Real Estate, ghala accomodation','1-1-2',7,0,0,NULL,0,NULL,0),(906,'Hamptons, office rent','1-1-3',7,0,0,NULL,0,NULL,0),(907,'Wave Sohar Integrated LLC','2-1-1',13,0,0,NULL,0,NULL,0),(908,'Office Expenses','4-1-1',21,0,0,NULL,0,NULL,0),(909,'OBB Materials','4-1-2',21,0,0,NULL,0,NULL,0),(910,'OBB Subcon','4-1-3',21,0,0,NULL,0,NULL,0),(911,'NINFRA','2-1-2',13,0,0,NULL,0,NULL,0),(912,'Muna Noor','2-1-3',13,0,0,NULL,0,NULL,0),(913,'Golden International','2-1-4',13,0,0,NULL,0,NULL,0),(914,'Al Waqar International Trade','1-1-4',7,0,0,NULL,0,NULL,0),(915,'Al Jadarah Business Consultant','1-1-5',7,0,0,NULL,0,NULL,0),(916,'Audi Showroom','1-1-6',7,0,0,NULL,0,NULL,0),(917,'Al Fardan Motors LLC','1-1-7',7,0,0,NULL,0,NULL,0),(918,'Maserati Showroom','1-1-8',7,0,0,NULL,0,NULL,0),(919,'Al Dosari','1-1-9',7,0,0,NULL,0,NULL,0),(920,'Omantel Outdoor Sales Enterprise','1-1-10',7,0,0,NULL,0,NULL,0),(921,'Channels / Omantel Outdoor Sales HBB ','1-1-11',7,0,0,NULL,0,NULL,0),(922,'Sayed Faisal','1-1-12',7,0,0,NULL,0,NULL,0);

--
-- Table structure for table `Creative_Knowledgee_Landactivity_logs`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landactivity_logs`
--

INSERT INTO `Creative_Knowledgee_Landactivity_logs` VALUES (1,'2022-10-19 07:41:54',1,'created','clients','',1,NULL,'',0,'',0,0),(2,'2022-10-19 07:41:54',1,'updated','clients','',1,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:904;}}','',0,'',0,0),(3,'2022-10-19 07:43:50',1,'created','invoices','',1,NULL,'',0,'',0,0),(4,'2022-10-19 07:46:26',1,'created','clients','',2,NULL,'',0,'',0,0),(5,'2022-10-19 07:46:26',1,'updated','clients','',2,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:905;}}','',0,'',0,0),(6,'2022-10-19 07:47:07',1,'created','clients','',3,NULL,'',0,'',0,0),(7,'2022-10-19 07:47:07',1,'updated','clients','',3,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:906;}}','',0,'',0,0),(8,'2022-10-19 07:48:20',1,'updated','invoices','',1,'a:1:{s:6:\"labels\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:11:\"scrap items\";}}','',0,'',0,0),(9,'2022-10-19 07:51:17',1,'created','item_categories','',1,NULL,'',0,'',0,0),(10,'2022-10-19 07:51:39',1,'updated','item_categories','',1,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:5:\"scrap\";s:2:\"to\";s:14:\"scrap purchase\";}}','',0,'',0,0),(11,'2022-10-19 07:53:33',1,'created','suppliers','',1,NULL,'',0,'',0,0),(12,'2022-10-19 07:53:33',1,'updated','suppliers','',1,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:907;}}','',0,'',0,0),(13,'2022-10-19 07:55:54',1,'updated','suppliers','',1,'a:1:{s:12:\"company_name\";a:2:{s:4:\"from\";s:10:\"Sohar wave\";s:2:\"to\";s:25:\"Wave Sohar Integrated LLC\";}}','',0,'',0,0),(14,'2022-10-19 07:58:01',1,'created','purchase_orders','',1,NULL,'',0,'',0,0),(15,'2022-10-19 07:59:53',1,'created','items','',1,NULL,'',0,'',0,0),(16,'2022-10-19 08:00:33',1,'created','purchase_order_items','',1,NULL,'',0,'',0,0),(17,'2022-10-19 08:01:32',1,'created','purchase_order_payments','',1,NULL,'',0,'',0,0),(18,'2022-10-19 08:01:32',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),(19,'2022-10-19 08:04:41',1,'created','invoice_items','',1,NULL,'',0,'',0,0),(20,'2022-10-19 08:05:08',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),(21,'2022-10-19 08:09:06',1,'created','invoice_payments','',1,NULL,'',0,'',0,0),(22,'2022-10-19 08:09:06',1,'updated','invoices','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(23,'2022-10-19 08:09:17',1,'created','delivery_notes','',1,NULL,'',0,'',0,0),(24,'2022-10-19 08:09:17',1,'created','delivery_note_items','',1,NULL,'',0,'',0,0),(25,'2022-10-19 08:09:30',1,'updated','delivery_notes','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(26,'2022-10-19 08:09:30',1,'updated','invoices','',1,'a:1:{s:15:\"delivery_status\";a:2:{s:4:\"from\";s:13:\"not_delivered\";s:2:\"to\";s:9:\"delivered\";}}','',0,'',0,0),(27,'2022-10-19 08:10:25',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),(28,'2022-10-19 08:10:25',1,'updated','invoice_payments','',1,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:3;}}','',0,'',0,0),(29,'2022-10-19 08:11:13',1,'updated','invoice_payments','',1,'a:1:{s:21:\"cheque_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:4;}}','',0,'',0,0),(30,'2022-11-04 20:10:23',1,'deleted','suppliers','',1,NULL,'',0,NULL,NULL,0),(31,'2022-11-04 20:10:59',1,'deleted','items','',1,NULL,'',0,NULL,NULL,0),(32,'2022-11-04 20:11:34',1,'deleted','item_categories','',1,NULL,'',0,NULL,NULL,0),(33,'2022-11-04 20:11:44',1,'created','item_categories','',2,NULL,'',0,'',0,0),(34,'2022-11-04 20:11:58',1,'created','item_categories','',3,NULL,'',0,'',0,0),(35,'2022-11-04 20:12:16',1,'created','item_categories','',4,NULL,'',0,'',0,0),(36,'2022-11-04 20:12:53',1,'created','item_categories','',5,NULL,'',0,'',0,0),(37,'2022-11-04 20:13:18',1,'created','item_categories','',6,NULL,'',0,'',0,0),(38,'2022-11-04 20:13:53',1,'created','items','',2,NULL,'',0,'',0,0),(39,'2022-11-04 20:15:04',1,'created','items','',3,NULL,'',0,'',0,0),(40,'2022-11-04 20:15:47',1,'updated','items','',2,'a:3:{s:9:\"unit_type\";a:2:{s:4:\"from\";s:3:\"pcs\";s:2:\"to\";s:6:\"meters\";}s:4:\"rate\";a:2:{s:4:\"from\";s:3:\"4.2\";s:2:\"to\";s:5:\"0.770\";}s:4:\"cost\";a:2:{s:4:\"from\";s:3:\"4.2\";s:2:\"to\";s:5:\"0.770\";}}','',0,'',0,0),(41,'2022-11-04 20:16:47',1,'created','items','',4,NULL,'',0,'',0,0),(42,'2022-11-04 20:17:28',1,'created','items','',5,NULL,'',0,'',0,0),(43,'2022-11-04 20:17:38',1,'updated','items','',4,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:3:\"316\";s:2:\"to\";s:3:\"112\";}s:4:\"cost\";a:2:{s:4:\"from\";s:3:\"316\";s:2:\"to\";s:3:\"112\";}}','',0,'',0,0),(44,'2022-11-04 20:18:29',1,'created','items','',6,NULL,'',0,'',0,0),(45,'2022-11-04 20:18:57',1,'created','items','',7,NULL,'',0,'',0,0),(46,'2022-11-04 20:19:33',1,'created','items','',8,NULL,'',0,'',0,0),(47,'2022-11-04 20:20:10',1,'created','items','',9,NULL,'',0,'',0,0),(48,'2022-11-04 20:20:59',1,'created','items','',10,NULL,'',0,'',0,0),(49,'2022-11-04 20:21:34',1,'created','items','',11,NULL,'',0,'',0,0),(50,'2022-11-04 20:23:11',1,'created','items','',12,NULL,'',0,'',0,0),(51,'2022-11-04 20:23:37',1,'created','items','',13,NULL,'',0,'',0,0),(52,'2022-11-04 20:24:14',1,'created','items','',14,NULL,'',0,'',0,0),(53,'2022-11-04 20:24:23',1,'updated','items','',13,'a:2:{s:4:\"rate\";a:2:{s:4:\"from\";s:2:\"15\";s:2:\"to\";s:4:\"15.5\";}s:4:\"cost\";a:2:{s:4:\"from\";s:2:\"15\";s:2:\"to\";s:4:\"15.5\";}}','',0,'',0,0),(54,'2022-11-04 20:24:51',1,'created','items','',15,NULL,'',0,'',0,0),(55,'2022-11-04 20:25:29',1,'created','items','',16,NULL,'',0,'',0,0),(56,'2022-11-04 20:25:51',1,'created','items','',17,NULL,'',0,'',0,0),(57,'2022-11-04 20:26:29',1,'created','items','',18,NULL,'',0,'',0,0),(58,'2022-11-04 20:26:59',1,'created','items','',19,NULL,'',0,'',0,0),(59,'2022-11-04 20:27:25',1,'created','items','',20,NULL,'',0,'',0,0),(60,'2022-11-04 20:28:14',1,'created','items','',21,NULL,'',0,'',0,0),(61,'2022-11-04 20:28:39',1,'created','items','',22,NULL,'',0,'',0,0),(62,'2022-11-04 20:29:01',1,'deleted','item_categories','',5,NULL,'',0,NULL,NULL,0),(63,'2022-11-04 20:29:14',1,'updated','item_categories','',4,'a:1:{s:5:\"title\";a:2:{s:4:\"from\";s:7:\"Office \";s:2:\"to\";s:12:\"Office Items\";}}','',0,'',0,0),(64,'2022-11-04 20:29:25',1,'created','item_categories','',7,NULL,'',0,'',0,0),(65,'2022-11-04 20:29:57',1,'created','items','',23,NULL,'',0,'',0,0),(66,'2022-11-04 20:30:32',1,'created','items','',24,NULL,'',0,'',0,0),(67,'2022-11-04 20:31:00',1,'created','items','',25,NULL,'',0,'',0,0),(68,'2022-11-04 20:31:35',1,'created','items','',26,NULL,'',0,'',0,0),(69,'2022-11-04 20:32:35',1,'created','suppliers','',2,NULL,'',0,'',0,0),(70,'2022-11-04 20:32:35',1,'updated','suppliers','',2,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:911;}}','',0,'',0,0),(71,'2022-11-04 20:32:54',1,'created','suppliers','',3,NULL,'',0,'',0,0),(72,'2022-11-04 20:32:54',1,'updated','suppliers','',3,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:912;}}','',0,'',0,0),(73,'2022-11-04 20:33:29',1,'created','suppliers','',4,NULL,'',0,'',0,0),(74,'2022-11-04 20:33:29',1,'updated','suppliers','',4,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:913;}}','',0,'',0,0),(75,'2022-11-04 20:38:49',1,'created','clients','',4,NULL,'',0,'',0,0),(76,'2022-11-04 20:38:49',1,'updated','clients','',4,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:914;}}','',0,'',0,0),(77,'2022-11-04 20:40:11',1,'created','clients','',5,NULL,'',0,'',0,0),(78,'2022-11-04 20:40:11',1,'updated','clients','',5,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:915;}}','',0,'',0,0),(79,'2022-11-04 20:40:25',1,'updated','clients','',5,'a:1:{s:12:\"company_name\";a:2:{s:4:\"from\";s:4:\"AJBC\";s:2:\"to\";s:30:\"Al Jadarah Business Consultant\";}}','',0,'',0,0),(80,'2022-11-04 20:40:53',1,'created','clients','',6,NULL,'',0,'',0,0),(81,'2022-11-04 20:40:53',1,'updated','clients','',6,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:916;}}','',0,'',0,0),(82,'2022-11-04 20:41:07',1,'created','clients','',7,NULL,'',0,'',0,0),(83,'2022-11-04 20:41:07',1,'updated','clients','',7,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:917;}}','',0,'',0,0),(84,'2022-11-04 20:41:29',1,'created','clients','',8,NULL,'',0,'',0,0),(85,'2022-11-04 20:41:29',1,'updated','clients','',8,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:918;}}','',0,'',0,0),(86,'2022-11-04 20:43:51',1,'updated','clients','',8,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"4\";}}','',0,'',0,0),(87,'2022-11-04 20:43:57',1,'updated','clients','',7,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"4\";}}','',0,'',0,0),(88,'2022-11-04 20:44:03',1,'updated','clients','',6,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"4\";}}','',0,'',0,0),(89,'2022-11-04 20:44:30',1,'created','clients','',9,NULL,'',0,'',0,0),(90,'2022-11-04 20:44:30',1,'updated','clients','',9,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:919;}}','',0,'',0,0),(91,'2022-11-04 20:46:57',1,'updated','clients','',1,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"7\";}}','',0,'',0,0),(92,'2022-11-04 20:47:04',1,'updated','clients','',4,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:1:\"1\";s:2:\"to\";s:3:\"1,6\";}}','',0,'',0,0),(93,'2022-11-04 20:47:16',1,'updated','clients','',5,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:3:\"2,6\";}}','',0,'',0,0),(94,'2022-11-04 20:47:27',1,'updated','clients','',6,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";s:3:\"4,5\";}}','',0,'',0,0),(95,'2022-11-04 20:47:32',1,'updated','clients','',7,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";s:3:\"4,6\";}}','',0,'',0,0),(96,'2022-11-04 20:47:40',1,'updated','clients','',8,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";s:3:\"4,5\";}}','',0,'',0,0),(97,'2022-11-04 20:47:47',1,'updated','clients','',7,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:3:\"4,6\";s:2:\"to\";s:3:\"4,5\";}}','',0,'',0,0),(98,'2022-11-04 20:47:55',1,'updated','clients','',9,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"6\";}}','',0,'',0,0),(99,'2022-11-04 20:48:53',1,'created','clients','',10,NULL,'',0,'',0,0),(100,'2022-11-04 20:48:53',1,'updated','clients','',10,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:920;}}','',0,'',0,0),(101,'2022-11-04 20:49:21',1,'created','clients','',11,NULL,'',0,'',0,0),(102,'2022-11-04 20:49:21',1,'updated','clients','',11,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:921;}}','',0,'',0,0),(103,'2022-11-04 20:50:09',1,'updated','clients','',10,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"8\";}}','',0,'',0,0),(104,'2022-11-04 20:50:15',1,'updated','clients','',11,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"8\";}}','',0,'',0,0),(105,'2022-11-04 20:59:44',1,'created','clients','',12,NULL,'',0,'',0,0),(106,'2022-11-04 20:59:44',1,'updated','clients','',12,'a:1:{s:10:\"account_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:922;}}','',0,'',0,0),(107,'2022-11-04 20:59:51',1,'updated','clients','',12,'a:1:{s:9:\"group_ids\";a:2:{s:4:\"from\";s:0:\"\";s:2:\"to\";s:1:\"7\";}}','',0,'',0,0),(108,'2022-11-09 14:26:15',1,'created','contacts','',1,NULL,'',0,'',0,0),(109,'2022-11-09 14:26:41',1,'created','contacts','',2,NULL,'',0,'',0,0),(110,'2022-11-09 14:27:25',1,'created','contacts','',3,NULL,'',0,'',0,0),(111,'2022-11-09 14:28:31',1,'created','contacts','',4,NULL,'',0,'',0,0),(112,'2022-11-09 14:29:20',1,'created','contacts','',5,NULL,'',0,'',0,0),(113,'2022-11-09 14:29:52',1,'created','contacts','',6,NULL,'',0,'',0,0),(114,'2022-11-09 14:30:02',1,'updated','contacts','',2,'a:1:{s:4:\"name\";a:2:{s:4:\"from\";s:5:\"Dylan\";s:2:\"to\";s:12:\"Dylan D\'Cruz\";}}','',0,'',0,0),(115,'2022-11-09 14:38:43',1,'updated','invoice_payments','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(116,'2022-11-09 14:38:44',1,'updated','invoice_payments','',1,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"3\";s:2:\"to\";i:0;}}','',0,'',0,0),(117,'2022-11-09 14:38:44',1,'updated','invoice_payments','',1,'a:1:{s:21:\"cheque_transaction_id\";a:2:{s:4:\"from\";s:1:\"4\";s:2:\"to\";i:0;}}','',0,'',0,0),(118,'2022-11-09 14:43:06',1,'created','invoice_payments','',2,NULL,'',0,'',0,0),(119,'2022-11-09 14:46:18',1,'deleted','invoice_payments','',2,NULL,'',0,NULL,NULL,0),(120,'2022-11-09 14:46:19',1,'deleted','invoice_payments','',1,NULL,'',0,NULL,NULL,0),(121,'2022-11-09 14:51:37',1,'updated','delivery_notes','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:8:\"approved\";s:2:\"to\";s:5:\"draft\";}}','',0,'',0,0),(122,'2022-11-09 14:52:37',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:3:\"100\";s:2:\"to\";i:99;}}','',0,'',0,0),(123,'2022-11-09 14:52:38',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"99\";s:2:\"to\";i:98;}}','',0,'',0,0),(124,'2022-11-09 14:52:38',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"98\";s:2:\"to\";i:97;}}','',0,'',0,0),(125,'2022-11-09 14:52:38',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"97\";s:2:\"to\";i:96;}}','',0,'',0,0),(126,'2022-11-09 14:52:38',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"96\";s:2:\"to\";i:95;}}','',0,'',0,0),(127,'2022-11-09 14:52:39',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"95\";s:2:\"to\";i:94;}}','',0,'',0,0),(128,'2022-11-09 14:52:40',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"94\";s:2:\"to\";i:93;}}','',0,'',0,0),(129,'2022-11-09 14:52:40',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"93\";s:2:\"to\";i:92;}}','',0,'',0,0),(130,'2022-11-09 14:52:40',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"92\";s:2:\"to\";i:91;}}','',0,'',0,0),(131,'2022-11-09 14:52:40',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"91\";s:2:\"to\";i:90;}}','',0,'',0,0),(132,'2022-11-09 14:52:40',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"90\";s:2:\"to\";i:89;}}','',0,'',0,0),(133,'2022-11-09 14:52:46',1,'updated','delivery_note_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"89\";s:2:\"to\";s:1:\"0\";}}','',0,'',0,0),(134,'2022-11-09 14:53:13',1,'deleted','delivery_notes','',1,NULL,'',0,NULL,NULL,0),(135,'2022-11-14 07:41:10',1,'updated','clients','',7,'a:2:{s:12:\"company_name\";a:2:{s:4:\"from\";s:16:\"Ferrari Showroom\";s:2:\"to\";s:20:\"Al Fardan Motors LLC\";}s:5:\"phone\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:8:\"92541016\";}}','',0,'',0,0),(136,'2022-11-14 07:42:26',1,'created','estimates','',1,NULL,'',0,'',0,0),(137,'2022-11-28 11:45:45',1,'created','item_categories','',8,NULL,'',0,'',0,0),(138,'2022-11-28 11:45:56',1,'created','item_categories','',9,NULL,'',0,'',0,0),(139,'2022-11-28 11:46:05',1,'created','item_categories','',10,NULL,'',0,'',0,0),(140,'2022-11-28 11:46:29',1,'updated','items','',26,'a:1:{s:11:\"category_id\";a:2:{s:4:\"from\";s:1:\"7\";s:2:\"to\";s:1:\"8\";}}','',0,'',0,0),(141,'2022-11-28 11:46:53',1,'updated','items','',25,'a:3:{s:4:\"rate\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:2:\"10\";}s:4:\"cost\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";s:1:\"1\";}s:11:\"category_id\";a:2:{s:4:\"from\";s:1:\"7\";s:2:\"to\";s:1:\"8\";}}','',0,'',0,0),(142,'2022-11-28 11:47:22',1,'updated','items','',21,'a:1:{s:11:\"category_id\";a:2:{s:4:\"from\";s:1:\"2\";s:2:\"to\";s:2:\"10\";}}','',0,'',0,0),(143,'2022-11-28 11:48:13',1,'created','purchase_orders','',2,NULL,'',0,'',0,0),(144,'2022-11-28 11:49:41',1,'created','purchase_order_items','',2,NULL,'',0,'',0,0),(145,'2022-11-28 11:49:41',1,'created','items','',27,NULL,'',0,'',0,0),(146,'2022-11-28 11:50:04',1,'updated','purchase_orders','',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),(147,'2022-11-28 11:50:33',1,'created','purchase_order_payments','',2,NULL,'',0,'',0,0),(148,'2022-11-28 11:50:33',1,'updated','purchase_orders','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(149,'2022-11-28 11:50:39',1,'updated','purchase_order_payments','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(150,'2022-11-28 11:50:39',1,'updated','purchase_order_payments','',2,'a:1:{s:14:\"transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:8;}}','',0,'',0,0),(151,'2022-11-28 11:52:21',1,'created','shipments','',1,NULL,'',0,'',0,0),(152,'2022-11-28 11:52:21',1,'created','shipment_items','',1,NULL,'',0,'',0,0),(153,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"20\";s:2:\"to\";i:19;}}','',0,'',0,0),(154,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"19\";s:2:\"to\";i:18;}}','',0,'',0,0),(155,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"18\";s:2:\"to\";i:17;}}','',0,'',0,0),(156,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"17\";s:2:\"to\";i:16;}}','',0,'',0,0),(157,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"16\";s:2:\"to\";i:15;}}','',0,'',0,0),(158,'2022-11-28 11:52:52',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"15\";s:2:\"to\";i:14;}}','',0,'',0,0),(159,'2022-11-28 11:52:53',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"14\";s:2:\"to\";i:13;}}','',0,'',0,0),(160,'2022-11-28 11:52:53',1,'updated','shipment_items','',1,'a:1:{s:8:\"quantity\";a:2:{s:4:\"from\";s:2:\"13\";s:2:\"to\";i:12;}}','',0,'',0,0),(161,'2022-11-28 11:52:56',1,'updated','shipments','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";N;s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(162,'2022-11-28 11:56:53',1,'created','purchase_orders','',3,NULL,'',0,'',0,0),(163,'2022-11-28 11:57:06',1,'created','purchase_order_items','',3,NULL,'',0,'',0,0),(164,'2022-11-28 11:57:10',1,'updated','purchase_orders','',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),(165,'2022-11-28 11:57:27',1,'created','shipments','',2,NULL,'',0,'',0,0),(166,'2022-11-28 11:57:27',1,'created','shipment_items','',2,NULL,'',0,'',0,0),(167,'2022-11-28 11:57:32',1,'updated','shipments','',2,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";N;s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(168,'2022-11-28 11:59:32',1,'created','invoices','',2,NULL,'',0,'',0,0),(169,'2022-11-28 12:00:46',1,'created','invoices','',3,NULL,'',0,'',0,0),(170,'2022-11-28 12:01:02',1,'created','invoice_items','',2,NULL,'',0,'',0,0),(171,'2022-11-28 12:01:09',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),(172,'2022-11-28 12:01:25',1,'created','invoice_payments','',3,NULL,'',0,'',0,0),(173,'2022-11-28 12:01:25',1,'updated','invoices','',3,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"not_paid\";}}','',0,'',0,0),(174,'2022-11-28 12:01:32',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),(175,'2022-11-28 12:01:32',1,'updated','invoice_payments','',3,'a:1:{s:22:\"account_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:11;}}','',0,'',0,0),(176,'2022-11-28 12:02:22',1,'created','invoices','',4,NULL,'',0,'',0,0),(177,'2022-11-28 12:02:39',1,'created','invoice_items','',3,NULL,'',0,'',0,0),(178,'2022-11-28 12:02:44',1,'updated','invoices','',4,'a:1:{s:15:\"approval_status\";a:2:{s:4:\"from\";s:12:\"not_approved\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(179,'2022-11-28 12:02:54',1,'created','delivery_notes','',2,NULL,'',0,'',0,0),(180,'2022-11-28 12:02:54',1,'created','delivery_note_items','',2,NULL,'',0,'',0,0),(181,'2022-11-28 12:33:08',1,'created','expenses','',1,NULL,'',0,'',0,0),(182,'2022-11-28 12:33:15',1,'updated','expenses','',1,'a:1:{s:6:\"status\";a:2:{s:4:\"from\";s:5:\"draft\";s:2:\"to\";s:8:\"approved\";}}','',0,'',0,0),(183,'2022-11-28 12:33:15',1,'updated','expenses','',1,'a:1:{s:14:\"transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:14;}}','',0,'',0,0),(184,'2022-11-28 12:33:51',1,'updated','expenses','',1,'a:1:{s:21:\"cheque_transaction_id\";a:2:{s:4:\"from\";s:1:\"0\";s:2:\"to\";i:15;}}','',0,'',0,0);

--
-- Table structure for table `Creative_Knowledgee_Landannouncements`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landattendance`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landchecklist_items`
--

CREATE TABLE `Creative_Knowledgee_Landchecklist_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 `Creative_Knowledgee_Landchecklist_items`
--


--
-- Table structure for table `Creative_Knowledgee_Landci_sessions`
--

CREATE TABLE `Creative_Knowledgee_Landci_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 `Creative_Knowledgee_Landci_sessions`
--

INSERT INTO `Creative_Knowledgee_Landci_sessions` VALUES ('77a1c3d3864f4a45c6799ce29a5f39992c9f5e8a','5.37.196.127',1635758922,''),('3a1b4bf2c2672801d68e305e147faf79591ef00f','5.37.196.127',1635758943,''),('fea9b3d2c7f6d8db113d95ce4f4cfa05d75c5372','161.8.109.180',1666080779,_binary '__ci_last_regenerate|i:1666080083;user_id|s:1:\"1\";'),('ca77a476e06721e02fb13afd035d35f225147c37','161.8.109.180',1666080740,_binary '__ci_last_regenerate|i:1666080739;'),('4741bad088f97d14c21b1e98cdb3e2fe7f20e26b','134.0.185.109',1666082939,_binary '__ci_last_regenerate|i:1666082939;user_id|s:1:\"1\";'),('a9e95bd0c654d21eab1a2bef618561a375e50825','134.0.185.109',1666083418,_binary '__ci_last_regenerate|i:1666083418;user_id|s:1:\"1\";'),('88125e0c75f0b4a6499cde953fa848dd5b16fff5','134.0.185.109',1666083890,_binary '__ci_last_regenerate|i:1666083890;user_id|s:1:\"1\";'),('dc64cced6d83d6e2772fa90a77522cb16c292596','134.0.185.109',1666084322,_binary '__ci_last_regenerate|i:1666084322;user_id|s:1:\"1\";'),('1e186e5d8b0b6fa2d0f76e6f9e03137192f3ecc6','134.0.185.109',1666085656,_binary '__ci_last_regenerate|i:1666084322;user_id|s:1:\"1\";'),('b2fe7abdce60663c4a0fea7e1aa4ceac40641faf','134.0.185.109',1666164784,_binary '__ci_last_regenerate|i:1666164784;user_id|s:1:\"1\";'),('726877e3a2fdd1ca24c9db03df9d106158c81c06','134.0.185.109',1666165162,_binary '__ci_last_regenerate|i:1666165162;user_id|s:1:\"1\";'),('c6d29ac2dd68322095cfc414f1fd58a961087fcf','134.0.185.109',1666165481,_binary '__ci_last_regenerate|i:1666165481;user_id|s:1:\"1\";'),('dcdbe3ac04a3027722e96430a190a56c5f37e183','134.0.185.109',1666165869,_binary '__ci_last_regenerate|i:1666165869;user_id|s:1:\"1\";'),('44301a8d8f5bde0c39ddfdca05475e9e0b0e3e40','134.0.185.109',1666166228,_binary '__ci_last_regenerate|i:1666166228;user_id|s:1:\"1\";'),('957734070102be1d9dca9f0b6e0282802df91bd9','134.0.185.109',1666166531,_binary '__ci_last_regenerate|i:1666166531;user_id|s:1:\"1\";'),('e618e84a42cddea99a755150b5597c1a3c387a36','54.38.214.107',1666166492,_binary '__ci_last_regenerate|i:1666166492;'),('75fdc1a3443fe80bd316501870f7ebb9120301e3','134.0.185.109',1666166832,_binary '__ci_last_regenerate|i:1666166832;user_id|s:1:\"1\";'),('c1d13b1f8bd092976de84dc0f30510e0908bbcf8','134.0.185.109',1666167139,_binary '__ci_last_regenerate|i:1666167139;user_id|s:1:\"1\";'),('25a6fd645fb92835ba833945a540f0347f944187','54.38.214.107',1666166946,_binary '__ci_last_regenerate|i:1666166946;'),('1c1520af270c90d2ade72cfd7df64eeedf6f88eb','134.0.185.109',1666167497,_binary '__ci_last_regenerate|i:1666167496;user_id|s:1:\"1\";'),('44c604c34cfa69537b841b1efca4b209ccbd8cc6','134.0.185.109',1666168293,_binary '__ci_last_regenerate|i:1666168293;user_id|s:1:\"1\";'),('776ee6b3c821680ac399ea1a9453f274332a58dc','134.0.185.109',1666168708,_binary '__ci_last_regenerate|i:1666168708;user_id|s:1:\"1\";'),('f1d692097525d1a4fac2209274768851260a049d','134.0.185.109',1666172885,_binary '__ci_last_regenerate|i:1666172885;user_id|s:1:\"1\";'),('7b80565f7e6a6f14b32c284f0caaecca7baa4116','134.0.185.109',1666173371,_binary '__ci_last_regenerate|i:1666173371;user_id|s:1:\"1\";'),('a6df7d398838e5ae3e5f6e4221293023837ef79f','134.0.185.109',1666173679,_binary '__ci_last_regenerate|i:1666173679;user_id|s:1:\"1\";'),('84d160c4044bbee771f8d8b19496b1432aac5849','134.0.185.109',1666175187,_binary '__ci_last_regenerate|i:1666175187;user_id|s:1:\"1\";'),('ecdc502b1ff6c8be52eab684c31cb82e8a5e9b08','134.0.185.109',1666175516,_binary '__ci_last_regenerate|i:1666175187;user_id|s:1:\"1\";'),('5250d4b38f109eb97e6c0d097e6d272fe8b9ba46','5.32.220.103',1666781732,_binary '__ci_last_regenerate|i:1666781732;'),('b0ae11298b09e1c5c1d2b5d4ead3c022d7019cac','5.32.220.103',1666781733,_binary '__ci_last_regenerate|i:1666781733;'),('4a5a29561005e09c4da97d10366778f14bfbc4ae','134.0.178.157',1667466551,_binary '__ci_last_regenerate|i:1667462267;user_id|s:1:\"1\";'),('b6b41ec32ab4c286fa0018d408797a4cfac2cae5','62.61.184.179',1667590387,_binary '__ci_last_regenerate|i:1667590387;user_id|s:1:\"1\";'),('16062d720f04918006f04a40bbd2abc97333af0d','62.61.184.179',1667590688,_binary '__ci_last_regenerate|i:1667590688;user_id|s:1:\"1\";'),('4429dfd354a94956b26bc266f3fbcff469b182d1','62.61.184.179',1667591116,_binary '__ci_last_regenerate|i:1667591116;user_id|s:1:\"1\";'),('936a69093bf08fc6637322ae52aad4e89b634bde','62.61.184.179',1667591428,_binary '__ci_last_regenerate|i:1667591428;user_id|s:1:\"1\";'),('10900d86b83d61b98db31d54c23964a043113a2c','62.61.184.179',1667592043,_binary '__ci_last_regenerate|i:1667592043;user_id|s:1:\"1\";'),('00a1e1cf5ad21aef95ad717e0f74e5ef1a48c944','62.61.184.179',1667592418,_binary '__ci_last_regenerate|i:1667592418;user_id|s:1:\"1\";'),('92aa9a8d01bed52491de916cfb8bfc453e825b62','62.61.184.179',1667592801,_binary '__ci_last_regenerate|i:1667592801;user_id|s:1:\"1\";'),('de0ee4096e11043a18fcfb54f095a66d27c2acb6','62.61.184.179',1667593734,_binary '__ci_last_regenerate|i:1667593734;user_id|s:1:\"1\";'),('75c4cb3d5d773c79158e6219beef7b5cd5a4faf4','62.61.184.179',1667594035,_binary '__ci_last_regenerate|i:1667594035;user_id|s:1:\"1\";'),('3bef0fdfef64c47d3de58f7e0fadf88925c8148a','62.61.184.179',1667594514,_binary '__ci_last_regenerate|i:1667594514;user_id|s:1:\"1\";'),('3e6727fdd8fb16bd557de8e5ee139f06cdd55c47','62.61.184.179',1667594879,_binary '__ci_last_regenerate|i:1667594879;user_id|s:1:\"1\";'),('958ff600a51c4a6ff317fe060185c782bd89d22e','62.61.184.179',1667595521,_binary '__ci_last_regenerate|i:1667595521;user_id|s:1:\"1\";'),('cf202425699417329d8d54fc1d9d59c025490d4a','54.38.214.107',1667595136,_binary '__ci_last_regenerate|i:1667595136;'),('28d632e4f9a32a499c24d5763073383433af1bf6','54.38.214.107',1667595217,_binary '__ci_last_regenerate|i:1667595217;'),('75d5ad0ae7c88288d65e6c48fc70b27f23f5d23d','54.38.214.107',1667595224,_binary '__ci_last_regenerate|i:1667595224;'),('9eb6aebb5b929be2066d5a1222b7fededbf4b67f','54.38.214.107',1667595260,_binary '__ci_last_regenerate|i:1667595260;'),('c4886f56f1ef839a354121323c963b2d6419b8c5','54.38.214.107',1667595266,_binary '__ci_last_regenerate|i:1667595266;'),('36151dd84756cc51d44ea598e21b027b50f83fff','54.38.214.107',1667595311,_binary '__ci_last_regenerate|i:1667595311;'),('a092c960e5fce2bce8a3e4c889d9bf6e5f0e44b2','54.38.214.107',1667595412,_binary '__ci_last_regenerate|i:1667595411;'),('9c505064bc0083a2aa83cb1ab47b0d48e1244743','54.38.214.107',1667595451,_binary '__ci_last_regenerate|i:1667595451;'),('eb530bac91f9b8893588624b2ad53a637b31e013','54.38.214.107',1667595479,_binary '__ci_last_regenerate|i:1667595478;'),('d63b152ad487e572c6cbbe34f9cc2689de6a5fd6','62.61.184.179',1667595824,_binary '__ci_last_regenerate|i:1667595824;user_id|s:1:\"1\";'),('7bfe001577344ca25af4e3a37f66d6f2af804323','62.61.184.179',1667596113,_binary '__ci_last_regenerate|i:1667595824;user_id|s:1:\"1\";'),('e1d83c8797ef142bed02b7340480f26541bf08fa','5.21.230.132',1667797438,_binary '__ci_last_regenerate|i:1667797436;'),('35390080c1a031c9e12be18597f8dec14a4afcb9','94.176.18.34',1667797646,_binary '__ci_last_regenerate|i:1667797646;'),('584cade6999fb376bdef604f2e2f56856ff350e7','37.41.7.11',1667913551,_binary '__ci_last_regenerate|i:1667913551;user_id|s:1:\"1\";'),('372197a4847d699f5ffa71832c229c2f91f25e33','37.41.7.11',1667914060,_binary '__ci_last_regenerate|i:1667914060;user_id|s:1:\"1\";'),('064e62d9fcdfd9dfb666ed85ad4626659c43e8d3','37.41.7.11',1667914381,_binary '__ci_last_regenerate|i:1667914381;user_id|s:1:\"1\";'),('c0d6cf70623028081aeed8975a3abeaab91e9ff0','37.41.7.11',1667929358,_binary '__ci_last_regenerate|i:1667914381;user_id|s:1:\"1\";'),('2e9c6f5eb16e8fdb2fb04164b5291fdd17c58ca9','134.0.136.225',1668000411,_binary '__ci_last_regenerate|i:1668000411;user_id|s:1:\"1\";'),('90e6f510c45a50c2579b0ab90d18c4c6fdd1857a','134.0.136.225',1668003910,_binary '__ci_last_regenerate|i:1668003910;user_id|s:1:\"1\";'),('5d0037a78dc4c9b21d3e50bfdd019be6e1a86219','134.0.136.225',1668001820,_binary '__ci_last_regenerate|i:1668001820;user_id|s:1:\"1\";'),('87852c7a50b70f08cf7519ec8f27b06b0a7b6d45','134.0.136.225',1668001508,_binary '__ci_last_regenerate|i:1668001508;user_id|s:1:\"1\";'),('6dfea8adef3fca08fd00bc65ea0e9763cbbaae47','134.0.136.225',1668002439,_binary '__ci_last_regenerate|i:1668002439;user_id|s:1:\"1\";'),('c7debc215bba710b866712504a38d773b64b5c34','134.0.136.225',1668002126,_binary '__ci_last_regenerate|i:1668002126;user_id|s:1:\"1\";'),('c55ca8ec5ad95ea0935d5c116cd3b0c9f986990e','134.0.136.225',1668002921,_binary '__ci_last_regenerate|i:1668002921;user_id|s:1:\"1\";'),('f94f3660a4e5373c3ab2d97a5eb1f65b0b844d52','134.0.136.225',1668003231,_binary '__ci_last_regenerate|i:1668003231;user_id|s:1:\"1\";'),('0575889f2fb42c8f536d652ffc40c23a69b713e1','134.0.136.225',1668003534,_binary '__ci_last_regenerate|i:1668003534;user_id|s:1:\"1\";'),('a1a7a994a3157a8a44acfca9eeeef867702c99d6','134.0.136.225',1668005875,_binary '__ci_last_regenerate|i:1668005875;user_id|s:1:\"1\";'),('6c7e35e2ad276a3d282363a90a56e8c9d8e406c3','134.0.136.225',1668004221,_binary '__ci_last_regenerate|i:1668004221;user_id|s:1:\"1\";'),('adfa8e8b98c14afae2392b2e0aa3f3c843df2140','134.0.136.225',1668004579,_binary '__ci_last_regenerate|i:1668004578;user_id|s:1:\"1\";'),('553a582b2b61b27756ec71b30630526ffdd12387','54.38.214.107',1668004393,_binary '__ci_last_regenerate|i:1668004393;'),('c1600af717751335e76f5187fd3c9315ba645af1','54.38.214.107',1668004401,_binary '__ci_last_regenerate|i:1668004401;'),('2dc54f51154448a91d569dc3b5eee533380d085c','54.38.214.107',1668004491,_binary '__ci_last_regenerate|i:1668004490;'),('091e06f71f06ba2558c7f5678098b20f644ed98a','54.38.214.107',1668004498,_binary '__ci_last_regenerate|i:1668004498;'),('6365f4f236d8abcde880e3517ca460e938f5858d','134.0.136.225',1668005118,_binary '__ci_last_regenerate|i:1668005118;user_id|s:1:\"1\";'),('7f21c663b041c0a45ff28c7b6a9cc1e4579a3e05','54.38.214.107',1668004702,_binary '__ci_last_regenerate|i:1668004701;'),('bca959be661db0343fd2d40b94079162e18e2146','54.38.214.107',1668004986,_binary '__ci_last_regenerate|i:1668004986;'),('0baa9a69473ffabea3d4b7168303a25dbee3077f','134.0.136.225',1668005485,_binary '__ci_last_regenerate|i:1668005485;user_id|s:1:\"1\";'),('77075255b8ec9e1f3950c97c2a7ff2e5e353fb97','54.38.214.107',1668005142,_binary '__ci_last_regenerate|i:1668005142;'),('0868c23574f3ea5ab86db4dcacb13bf0b1f9adaa','134.0.136.225',1668013376,_binary '__ci_last_regenerate|i:1668005485;user_id|s:1:\"1\";'),('830b865931d234c64cc85b9c8458807857a433ab','134.0.136.225',1668006369,_binary '__ci_last_regenerate|i:1668006369;user_id|s:1:\"1\";'),('4b9dafe5e6b4823b79b692ab5fb838cceac04e6d','54.38.214.107',1668006171,_binary '__ci_last_regenerate|i:1668006171;'),('009f7b8e1ce0df021b19e8b9eca7a0ce9857d1d6','54.38.214.107',1668006175,_binary '__ci_last_regenerate|i:1668006174;'),('e7d0442db997c54d0c4b19cd87a6c3ddc81d635b','54.38.214.107',1668006195,_binary '__ci_last_regenerate|i:1668006195;'),('51d9222b7271070307d30c214c3462a1a9e8e7ed','134.0.136.225',1668006828,_binary '__ci_last_regenerate|i:1668006828;user_id|s:1:\"1\";'),('f741aa89430a545eba7be6520f10b08086f25a20','134.0.136.225',1668007264,_binary '__ci_last_regenerate|i:1668007264;user_id|s:1:\"1\";'),('fc6b51a0008ed68ee2d0a90c1658e03e243fb8e6','134.0.136.225',1668008079,_binary '__ci_last_regenerate|i:1668008079;user_id|s:1:\"1\";'),('1504406cedf9a54fc7b37f231f4c28b946fe925b','134.0.136.225',1668007623,_binary '__ci_last_regenerate|i:1668007623;user_id|s:1:\"1\";'),('f7acf9a59d3fe414edd047b7561ec8792d376c61','134.0.136.225',1668008455,_binary '__ci_last_regenerate|i:1668008455;user_id|s:1:\"1\";'),('b8b4a6bfd0d12d4ffcd0a607dc9f5541827486cb','134.0.136.225',1668018237,_binary '__ci_last_regenerate|i:1668008455;user_id|s:1:\"1\";'),('8066f42867fe61811d3e8a081ec8432fd7c81656','37.41.240.5',1668348610,_binary '__ci_last_regenerate|i:1668348610;user_id|s:1:\"1\";'),('5be85d6ac10ae3d64a780aa80204da3ea97646b6','37.41.240.5',1668348923,_binary '__ci_last_regenerate|i:1668348923;user_id|s:1:\"1\";'),('c0ba905522d44447ff4e69934ee805491b997ec2','37.41.240.5',1668349205,_binary '__ci_last_regenerate|i:1668348923;user_id|s:1:\"1\";'),('5b07b0d6cb9a3a4f28f91f4c3dd6e5f1145c9e86','5.32.241.73',1668408906,_binary '__ci_last_regenerate|i:1668408906;user_id|s:1:\"1\";'),('60efd4644368d761e7cf3e8ee336ef64768c5174','54.38.214.107',1668408855,_binary '__ci_last_regenerate|i:1668408855;'),('06c1d85bd5ce7e6dfbf55d8047091f3a0b1bc626','5.32.241.73',1668409790,_binary '__ci_last_regenerate|i:1668409790;user_id|s:1:\"1\";'),('070a33771c7e398c5444121c11d880e90ba576d1','5.32.241.73',1668411493,_binary '__ci_last_regenerate|i:1668411493;'),('89e7d426ce379aa4e32123b643f0920710ac2052','5.32.241.73',1668411895,_binary '__ci_last_regenerate|i:1668411895;user_id|s:1:\"1\";'),('c65b5936d4d5bc2e577706678b237479bf6be2f4','5.32.241.73',1668411896,_binary '__ci_last_regenerate|i:1668411895;'),('c531cbef14181ee0bae24b34822166785e68fe84','37.41.152.202',1669195738,_binary '__ci_last_regenerate|i:1669195738;user_id|s:1:\"1\";'),('8aa8fc6f2effc89923037e5e3ba5bb4346b484a1','37.41.152.202',1669195281,_binary '__ci_last_regenerate|i:1669195281;'),('a6601e9c918549b63374b771c099f2895889a305','37.41.152.202',1669195281,_binary '__ci_last_regenerate|i:1669195281;'),('933d118e2747f8d93e1c3c1ada55e996b09ea0c0','37.41.152.202',1669195282,_binary '__ci_last_regenerate|i:1669195282;'),('c43e685d2d886e266dc63a23b791a8cbd932ded5','37.41.152.202',1669195282,_binary '__ci_last_regenerate|i:1669195282;'),('c6db820318852d2b1d6b1e4e0a46353be9ab7eee','37.41.152.202',1669196488,_binary '__ci_last_regenerate|i:1669196488;user_id|s:1:\"1\";'),('4cacaee85b0b7bae165ef6edd9571f92f6f28c19','37.41.152.202',1669196947,_binary '__ci_last_regenerate|i:1669196947;user_id|s:1:\"1\";'),('a445cb0de141dfb9d0c457324073bc9ee6c8c59f','37.41.152.202',1669197254,_binary '__ci_last_regenerate|i:1669197254;user_id|s:1:\"1\";'),('afbacab042a3a0b3bf8a9799fa3204f8cb53d3fd','37.41.152.202',1669207310,_binary '__ci_last_regenerate|i:1669197254;user_id|s:1:\"1\";'),('600b02cbe13679f3e08aca9d9554b7bc3d9dc2fd','37.41.181.15',1669449908,_binary '__ci_last_regenerate|i:1669449908;user_id|s:1:\"1\";'),('530654eebc4f98aa9d442e97842994d39da8c78c','37.41.181.15',1669451704,_binary '__ci_last_regenerate|i:1669449908;user_id|s:1:\"1\";'),('87c518638f8a6f43af080807d1b53d39069d8858','62.61.187.122',1669543634,_binary '__ci_last_regenerate|i:1669543634;user_id|s:1:\"1\";'),('948060b16f6e128e7559e8f9ef5a998cdd3f8b42','62.61.187.122',1669553618,_binary '__ci_last_regenerate|i:1669543634;user_id|s:1:\"1\";'),('0e4051c8f57c8f81d177afd2953c45a6bce79fdd','62.61.187.122',1669618059,_binary '__ci_last_regenerate|i:1669618059;user_id|s:1:\"1\";'),('a1b45978b5759b1d64d6cbea43cc4c0e1287f691','62.61.187.122',1669620234,_binary '__ci_last_regenerate|i:1669618059;user_id|s:1:\"1\";'),('1a087fce2431413ac4c842883819e1daa94cac14','213.5.71.231',1669636077,_binary '__ci_last_regenerate|i:1669636077;user_id|s:1:\"1\";'),('507c19541b8c5a296972fd26cba95708cd63411f','213.5.71.231',1669636379,_binary '__ci_last_regenerate|i:1669636379;user_id|s:1:\"1\";'),('00b55972da2a50e38566d96ae640d6a4d0fef3f7','54.38.214.107',1669636233,_binary '__ci_last_regenerate|i:1669636233;'),('24c19eea044892266f8bc305c282f8c777b65074','213.5.71.231',1669636709,_binary '__ci_last_regenerate|i:1669636709;user_id|s:1:\"1\";'),('a2df5a4662e3b6785734b7d576fd142a2dfbaf75','213.5.71.231',1669637014,_binary '__ci_last_regenerate|i:1669637014;user_id|s:1:\"1\";'),('df2b24098cb97675ac1819aa6e5524960a218045','54.38.214.107',1669636885,_binary '__ci_last_regenerate|i:1669636885;'),('092cba4c7d03a2c0c79d2770195ea221f08bc188','213.5.71.231',1669637972,_binary '__ci_last_regenerate|i:1669637014;user_id|s:1:\"1\";'),('71fd93a7119df026a009c00738a62656b9e6bbd0','213.5.71.231',1669638463,_binary '__ci_last_regenerate|i:1669638463;user_id|s:1:\"1\";'),('4eb8f28de08741f45e0408079be336ee179a051e','213.5.71.231',1669638789,_binary '__ci_last_regenerate|i:1669638789;user_id|s:1:\"1\";'),('32d426ea94116e33932efdac31a17e2f17fee52f','213.5.71.231',1669639273,_binary '__ci_last_regenerate|i:1669638789;user_id|s:1:\"1\";'),('c11244f21f2101e1da5716ff65b572b24f6a4ca2','213.5.71.231',1669639283,''),('2dc775ac2f2e805da54c77e32aedadef1b454d55','198.16.70.52',1670085066,_binary '__ci_last_regenerate|i:1670075519;user_id|s:1:\"4\";');

--
-- Table structure for table `Creative_Knowledgee_Landclient_groups`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landclient_groups`
--

INSERT INTO `Creative_Knowledgee_Landclient_groups` VALUES (1,'Al Waqar International Trade',1),(2,'Al Jadarah Business Consultant',1),(3,'National Infrastructures LLC',1),(4,'Al Fardan Proprieties ',1),(5,'Interior Design',0),(6,'Telecom - OBB',0),(7,'Faisal Projects',0),(8,'Outdoor Sales',0);

--
-- Table structure for table `Creative_Knowledgee_Landclients`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landclients`
--

INSERT INTO `Creative_Knowledgee_Landclients` VALUES (1,'Colossal Engineering and cont llc','','','','','','2022-10-19','www.colossal-group.com','+96824507157','','','7',1,0,0,0,0,0,'','0000-00-00','','',0,NULL,904,0,''),(2,'Al Diar Real Estate, ghala accomodation','Mawalah','','','','','2022-10-19','','+96890400060','','','',1,0,0,0,0,0,'','0000-00-00','','',0,NULL,905,0,''),(3,'Hamptons, office rent','','','','','','2022-10-19','','+968','','','',1,0,0,0,0,0,'','0000-00-00','','',0,NULL,906,0,''),(4,'Al Waqar International Trade','','','','','','2022-11-04','','71510362','','','1,6',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,914,0,'virginia@fiberreach.net'),(5,'Al Jadarah Business Consultant','','','','','','2022-11-04','','98212123','','','2,6',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,915,0,''),(6,'Audi Showroom','','','','','','2022-11-04','','24500206','','','4,5',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,916,0,''),(7,'Al Fardan Motors LLC','','','','','','2022-11-04','','92541016','','','4,5',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,917,0,''),(8,'Maserati Showroom','','','','','','2022-11-04','','00','','','4,5',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,918,0,''),(9,'Al Dosari','','','','','','2022-11-04','','000','','','6',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,919,0,''),(10,'Omantel Outdoor Sales Enterprise','','','','','','2022-11-04','','0000','','','8',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,920,0,''),(11,'Channels / Omantel Outdoor Sales HBB ','','','','','','2022-11-04','','00000','','','8',0,0,0,0,0,0,'','0000-00-00','','',0,NULL,921,0,''),(12,'Sayed Faisal','','','','','','2022-11-04','','99811512','','','7',1,0,0,0,0,0,'','0000-00-00','','',0,NULL,922,0,'');

--
-- Table structure for table `Creative_Knowledgee_Landcontacts`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landcontacts`
--

INSERT INTO `Creative_Knowledgee_Landcontacts` VALUES (1,'Virginia Tica','','71510362','98212123','CEO','','2022-11-09',1,0),(2,'Dylan D\'Cruz','','98212123','71510362','Project Manager','','2022-11-09',1,0),(3,'Sayed Faisal','','99811512','95450418','Business Development Manager','','2022-11-09',1,0),(4,'Tabish Khan','','99170386','','Operations Manager','','2022-11-09',1,0),(5,'Saheel Govekar','','92051319','71741447','Sales Agent','','2022-11-09',1,0),(6,'Adil Al Bahri','','99559111','96056660','CFO','','2022-11-09',1,0);

--
-- Table structure for table `Creative_Knowledgee_Landcustom_field_values`
--

CREATE TABLE `Creative_Knowledgee_Landcustom_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 `Creative_Knowledgee_Landcustom_field_values`
--


--
-- Table structure for table `Creative_Knowledgee_Landcustom_fields`
--

CREATE TABLE `Creative_Knowledgee_Landcustom_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 `Creative_Knowledgee_Landcustom_fields`
--


--
-- Table structure for table `Creative_Knowledgee_Landcustom_widgets`
--

CREATE TABLE `Creative_Knowledgee_Landcustom_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 `Creative_Knowledgee_Landcustom_widgets`
--


--
-- Table structure for table `Creative_Knowledgee_Landdashboards`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landdelivery_note_items`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landdelivery_note_items`
--

INSERT INTO `Creative_Knowledgee_Landdelivery_note_items` VALUES (1,1,1,'Road Barrier','Second Hand Road Barriers',0,'pc',15,1500,0,1,0),(2,22,3,'Safety Barriers','',30,'nos',0,0,0,2,0);

--
-- Table structure for table `Creative_Knowledgee_Landdelivery_notes`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landdelivery_notes`
--

INSERT INTO `Creative_Knowledgee_Landdelivery_notes` VALUES (1,1,1,0,'2022-10-10','','draft',1),(2,4,4,6,'2022-11-28','','draft',0);

--
-- Table structure for table `Creative_Knowledgee_Landemail_templates`
--

CREATE TABLE `Creative_Knowledgee_Landemail_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 `Creative_Knowledgee_Landemail_templates`
--


--
-- Table structure for table `Creative_Knowledgee_Landenteries`
--

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

INSERT INTO `Creative_Knowledgee_Landenteries` VALUES (1,1,904,'dr',1500,'Invoice: INVOICE #1',0,0,'0',0,1),(2,1,26,'cr',0,'Invoice: INVOICE #1',0,0,'0',0,1),(3,1,26,'cr',1500,'Invoice: INVOICE #1',0,0,'0',0,1),(4,2,26,'dr',0,'INVOICE #1',0,0,'0',0,1),(5,2,26,'cr',0,'INVOICE #1',0,0,'0',0,1),(6,3,904,'cr',1500,'Invoice Payment Received: INVOICE #1 <br /> Due date: 2022-10-18<br /> Account: Bank Muscat<br /> Number: 04218263',0,0,'0',0,0),(7,3,26,'dr',1500,'Invoice Payment Received: INVOICE #1 <br /> Due date: 2022-10-18<br /> Account: Bank Muscat<br /> Number: 04218263',0,0,'0',0,0),(8,4,26,'cr',1500,'Due date: 2022-10-18<br /> Account: Bank Muscat<br /> Number: 04218263',0,0,'0',0,0),(9,4,903,'dr',1500,'Due date: 2022-10-18<br /> Account: Bank Muscat<br /> Number: 04218263',0,0,'0',0,0),(10,5,26,'dr',200,'ADVANCE SALARY FOR Tabish Khan',0,4,'0',1,1),(11,5,903,'cr',200,'ADVANCE SALARY FOR Tabish Khan',0,4,'0',1,1),(12,6,26,'dr',1500,'Correction of the Colossal Sales Invoice',0,3,NULL,0,1),(13,6,24,'cr',1500,'Correction of the Colossal Sales Invoice',0,3,NULL,0,1),(14,7,1,'dr',4000,'Purchase Order: PURCHASE ORDER #2',0,0,'0',0,0),(15,7,4,'dr',0,'Purchase Order: PURCHASE ORDER #2',0,0,'0',0,0),(16,7,913,'cr',4000,'Purchase Order: PURCHASE ORDER #2',0,0,'0',0,0),(17,8,913,'dr',4000,'',0,0,'0',0,0),(18,8,903,'cr',4000,'',0,0,'0',0,0),(19,9,1,'dr',315,'Purchase Order: PURCHASE ORDER #3',0,0,'0',0,0),(20,9,4,'dr',0,'Purchase Order: PURCHASE ORDER #3',0,0,'0',0,0),(21,9,913,'cr',315,'Purchase Order: PURCHASE ORDER #3',0,0,'0',0,0),(22,10,914,'dr',10,'Invoice: INVOICE #3',0,0,'0',0,0),(23,10,5,'cr',0,'Invoice: INVOICE #3',0,0,'0',0,0),(24,10,5,'cr',10,'Invoice: INVOICE #3',0,0,'0',0,0),(25,11,914,'cr',5,'Invoice Payment Received: INVOICE #3 ',0,0,'0',0,0),(26,11,903,'dr',5,'Invoice Payment Received: INVOICE #3 ',0,0,'0',0,0),(27,12,5,'cr',0,'Invoice: INVOICE #4',0,0,'0',0,0),(28,12,5,'cr',0,'Invoice: INVOICE #4',0,0,'0',0,0),(29,13,15,'dr',50,'فثسف',0,0,NULL,0,0),(30,13,26,'cr',50,'فثسف',0,0,NULL,0,0),(31,14,908,'dr',9523.81,'test<br /> Due date: 2022-11-28<br /> Account: 12<br /> Number: 122',0,0,'0',0,0),(32,14,4,'dr',476.19,'test<br /> Due date: 2022-11-28<br /> Account: 12<br /> Number: 122',0,0,'0',0,0),(33,14,2,'cr',10000,'test<br /> Due date: 2022-11-28<br /> Account: 12<br /> Number: 122',0,0,'0',0,0),(34,15,2,'dr',10000,'test',0,0,'0',0,0),(35,15,903,'cr',10000,'test',0,0,'0',0,0);

--
-- Table structure for table `Creative_Knowledgee_Landestimate_forms`
--

CREATE TABLE `Creative_Knowledgee_Landestimate_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 `Creative_Knowledgee_Landestimate_forms`
--


--
-- Table structure for table `Creative_Knowledgee_Landestimate_items`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landestimate_items`
--


--
-- Table structure for table `Creative_Knowledgee_Landestimate_requests`
--

CREATE TABLE `Creative_Knowledgee_Landestimate_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 `Creative_Knowledgee_Landestimate_requests`
--


--
-- Table structure for table `Creative_Knowledgee_Landestimates`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landestimates`
--

INSERT INTO `Creative_Knowledgee_Landestimates` VALUES (1,7,0,'2022-10-31','2022-11-15','Supply and Installation of Ceiling Light Fixtures at Ferrari Showroom',NULL,'draft',0,0,'before_tax',0,'percentage',0,0);

--
-- Table structure for table `Creative_Knowledgee_Landevents`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landevents`
--


--
-- Table structure for table `Creative_Knowledgee_Landexpense_categories`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landexpense_categories`
--

INSERT INTO `Creative_Knowledgee_Landexpense_categories` VALUES (1,'Office Expenses',908,0),(2,'OBB Materials',909,0),(3,'OBB Subcon',910,0);

--
-- Table structure for table `Creative_Knowledgee_Landexpenses`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landexpenses`
--

INSERT INTO `Creative_Knowledgee_Landexpenses` VALUES (1,'2022-11-28',1,'test',10000,'cheque','2022-11-28',NULL,'12',122,15,'a:0:{}','',0,1,0,'approved',1,0,14,0);

--
-- Table structure for table `Creative_Knowledgee_Landgeneral_files`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landgeneral_files`
--

INSERT INTO `Creative_Knowledgee_Landgeneral_files` VALUES (1,'_file634e6a3fc7984-CK-Land-CR.pdf',NULL,NULL,'CK Land CR',1091590,'2022-10-18 08:56:31',0,1,0,1,1),(2,'_file634fc8a9eb679-ckland_license_09_2023--1-.pdf',NULL,NULL,'',766565,'2022-10-19 09:51:37',0,1,0,1,1),(3,'_file634fc8a9ec0d3-ckland_license_09_2023--3-.pdf',NULL,NULL,'',766554,'2022-10-19 09:51:37',0,1,0,1,1),(4,'_file634fc8a9ec8df-ckland_license_09_2023--4-.pdf',NULL,NULL,'',769151,'2022-10-19 09:51:37',0,1,0,1,1),(5,'_file634fc8a9ed1c1-ckland_license_09_2023.pdf',NULL,NULL,'',766976,'2022-10-19 09:51:37',0,1,0,1,1),(6,'_file634fc8a9ed8c8-ckland_license_09_2023_2.pdf',NULL,NULL,'',768099,'2022-10-19 09:51:37',0,1,0,1,1);

--
-- Table structure for table `Creative_Knowledgee_Landhelp_articles`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landhelp_articles`
--


--
-- Table structure for table `Creative_Knowledgee_Landhelp_categories`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landhelp_categories`
--


--
-- Table structure for table `Creative_Knowledgee_Landinternal_transactions`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landinternal_transactions`
--


--
-- Table structure for table `Creative_Knowledgee_Landinvoice_items`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landinvoice_items`
--

INSERT INTO `Creative_Knowledgee_Landinvoice_items` VALUES (1,1,'Road Barrier','Second Hand Road Barriers',100,'pc',15,0,1500,0,1,0,0,0),(2,25,'Civil Telecom','',1,'L/S',10,0,10,0,3,0,0,0),(3,22,'Safety Barriers','',30,'nos',0,0,0,0,4,0,0,0);

--
-- Table structure for table `Creative_Knowledgee_Landinvoice_payments`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landinvoice_payments`
--

INSERT INTO `Creative_Knowledgee_Landinvoice_payments` VALUES (1,1500,'2022-10-19',5,'2022-10-18','','Bank Muscat','04218263',0,'',1,'draft',1,NULL,0,0,1,'2022-10-19 08:09:06'),(2,1500,'2022-10-19',5,'2022-10-19','Road Barriers Payment','0318-02450698-001','4218263',0,'',1,'draft',1,NULL,0,0,1,'2022-11-09 14:43:06'),(3,5,'2022-11-29',4,'2022-11-28','','','',0,'',3,'approved',0,NULL,11,0,1,'2022-11-28 12:01:25');

--
-- Table structure for table `Creative_Knowledgee_Landinvoices`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landinvoices`
--

INSERT INTO `Creative_Knowledgee_Landinvoices` VALUES (1,1,0,'2022-10-11','2022-10-18','Supply of Second hand Road barriers','scrap items',NULL,'not_paid','delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(2,4,6,'2022-11-28','2023-01-27','','',NULL,'draft','not_delivered','not_approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(3,4,6,'2022-11-28','2023-01-27','','',NULL,'not_paid','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0),(4,4,6,'2022-11-28','2023-01-27','','',NULL,'draft','not_delivered','approved',0,0,0,0,0,NULL,0,NULL,0,NULL,NULL,0,'percentage','before_tax',NULL,0,0,0,0);

--
-- Table structure for table `Creative_Knowledgee_Landitem_categories`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landitem_categories`
--

INSERT INTO `Creative_Knowledgee_Landitem_categories` VALUES (1,'scrap purchase',1),(2,'OBB Materials',0),(3,'Interior Design Materials ',0),(4,'Office Items',0),(5,'Ninfra Business',1),(6,'Scrap Resell',0),(7,'OBB Services',0),(8,'Telecome',0),(9,'Interior Design',0),(10,'Supplies',0);

--
-- Table structure for table `Creative_Knowledgee_Landitems`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landitems`
--

INSERT INTO `Creative_Knowledgee_Landitems` VALUES (1,'Road Barrier','Second Hand Road Barriers','pc',10.5,15,1,'product',1),(2,'110 MM Pipes','','meters',0.77,0.77,2,'product',0),(3,'25 MM Pipes','','meters',0.121,0.121,2,'product',0),(4,'Precast Chamber T4 with cover','','nos',112,112,2,'product',0),(5,'Precast Chamber T6 With Cover','','nos',195,195,2,'product',0),(6,'90º Bends','','nos',3.55,3.55,2,'product',0),(7,'45º Bends','','nos',3.55,3.55,2,'product',0),(8,'110 MM End Caps','','nos',0.6,0.6,2,'product',0),(9,'25 MM end caps','','nos',0.095,0.095,2,'product',0),(10,'Warning Tape','','Roll',25,25,2,'product',0),(11,'6 MM Rope','','Roll',9.5,9.5,2,'product',0),(12,'Splicing Closure Fibre - 24','','nos',15,15,2,'product',0),(13,'Splicing Closure Fibre - 48','','nos',15.5,15.5,2,'product',0),(14,'Splicing Closure Fibre - 72','','nos',17.5,17.5,2,'product',0),(15,'Splicing Closure Fibre - 96','','nos',18,18,2,'product',0),(16,'Splicing Closure Fibre - 144','','nos',21,21,2,'product',0),(17,'Splicing Closure Fibre - 288','','nos',38,38,2,'product',0),(18,'Coupler','Small Size','nos',0.5,0.5,2,'product',0),(19,'Protection Post','','nos',15,15,2,'product',0),(20,'FDH Base','','nos',52,52,2,'product',0),(21,'Safety Barriers','','nos',12,12,10,'product',0),(22,'Safety Barriers','','nos',10.5,15,6,'product',0),(23,'Splicing','','L/S',0,0,7,'service',0),(24,'Cable Pulling','','L/S',0,0,7,'service',0),(25,'Civil Telecom','','L/S',1,10,8,'service',0),(26,'HDD Services','','nos',25,25,8,'service',0),(27,'Pipes','test','',200,100,10,'product',0);

--
-- Table structure for table `Creative_Knowledgee_Landlead_source`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landlead_source`
--

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

--
-- Table structure for table `Creative_Knowledgee_Landlead_status`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landlead_status`
--

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

--
-- Table structure for table `Creative_Knowledgee_Landleads`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landleave_applications`
--

CREATE TABLE `Creative_Knowledgee_Landleave_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 `Creative_Knowledgee_Landleave_applications`
--


--
-- Table structure for table `Creative_Knowledgee_Landleave_types`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landleave_types`
--

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

--
-- Table structure for table `Creative_Knowledgee_Landloans`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landmessages`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landmilestones`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landnotes`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landnotification_settings`
--

CREATE TABLE `Creative_Knowledgee_Landnotification_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 `Creative_Knowledgee_Landnotification_settings`
--

INSERT INTO `Creative_Knowledgee_Landnotification_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 `Creative_Knowledgee_Landnotifications`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landnotifications`
--

INSERT INTO `Creative_Knowledgee_Landnotifications` VALUES (1,1,'','2022-11-04 20:52:16','5','','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,'','2022-11-04 20:53:37','5','','project_created',2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(3,1,'','2022-11-04 20:54:20','5','','project_created',3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(4,1,'','2022-11-04 20:55:11','5','','project_created',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(5,1,'','2022-11-04 20:56:51','5','','project_created',5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(6,1,'','2022-11-04 20:57:31','5','','project_created',6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(7,1,'','2022-11-04 20:57:59','5','','project_created',7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(8,1,'','2022-11-09 14:33:13','3,5','','project_created',8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(9,1,'','2022-11-09 14:34:50','3,5','','project_created',9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(10,1,'','2022-11-09 14:38:21','3,5','','project_created',10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1),(11,1,'','2022-11-09 15:02:51','3,5','','project_deleted',9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(12,1,'','2022-11-09 15:02:54','3,5','','project_deleted',8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(13,1,'','2022-11-09 15:03:15','3,5','','project_deleted',10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),(14,1,'','2022-11-14 06:54:15','3,5','','project_created',11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `Creative_Knowledgee_Landpayment_methods`
--

CREATE TABLE `Creative_Knowledgee_Landpayment_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 `Creative_Knowledgee_Landpayment_methods`
--

INSERT INTO `Creative_Knowledgee_Landpayment_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 `Creative_Knowledgee_Landpaypal_ipn`
--

CREATE TABLE `Creative_Knowledgee_Landpaypal_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 `Creative_Knowledgee_Landpaypal_ipn`
--


--
-- Table structure for table `Creative_Knowledgee_Landpayroll`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landpayroll`
--


--
-- Table structure for table `Creative_Knowledgee_Landpayroll_detail`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landpayroll_detail`
--


--
-- Table structure for table `Creative_Knowledgee_Landposts`
--

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


--
-- Table structure for table `Creative_Knowledgee_Landproject_comments`
--

CREATE TABLE `Creative_Knowledgee_Landproject_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 `Creative_Knowledgee_Landproject_comments`
--


--
-- Table structure for table `Creative_Knowledgee_Landproject_files`
--

CREATE TABLE `Creative_Knowledgee_Landproject_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 `Creative_Knowledgee_Landproject_files`
--


--
-- Table structure for table `Creative_Knowledgee_Landproject_members`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landproject_members`
--

INSERT INTO `Creative_Knowledgee_Landproject_members` VALUES (1,1,1,1,0),(2,1,2,1,0),(3,1,3,1,0),(4,1,4,1,0),(5,1,5,1,0),(6,1,6,1,0),(7,1,7,1,0),(8,1,8,1,0),(9,1,9,1,0),(10,1,10,1,0),(11,1,11,1,0);

--
-- Table structure for table `Creative_Knowledgee_Landproject_settings`
--

CREATE TABLE `Creative_Knowledgee_Landproject_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 `Creative_Knowledgee_Landproject_settings`
--


--
-- Table structure for table `Creative_Knowledgee_Landproject_time`
--

CREATE TABLE `Creative_Knowledgee_Landproject_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 `Creative_Knowledgee_Landproject_time`
--


--
-- Table structure for table `Creative_Knowledgee_Landprojects`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landprojects`
--

INSERT INTO `Creative_Knowledgee_Landprojects` VALUES (1,'Al Dosari - Barka','LPO of 300k\nProject Stopped due to lack of permission\nInvoice for the work completed','2022-09-01','2022-11-01',9,'2022-11-04',1,'canceled','Telecom - OBB',300000,'',0,NULL,0),(2,'Sohar - Ghusba','','2022-08-01','2022-10-01',4,'2022-11-04',1,'completed','Telecom - OBB',116000,'',0,NULL,0),(3,'Sohar - Main City','','2022-09-01','2022-11-03',4,'2022-11-04',1,'completed','Telecom - OBB',226000,'',0,NULL,0),(4,'Sohar - Zafaran','','2022-10-01','2022-12-01',4,'2022-11-04',1,'open','Telecom - OBB',250000,'',0,NULL,0),(5,'Al Hattat Office','','2022-11-15','2022-12-30',5,'2022-11-04',1,'open','Interior Design',50000,'',0,NULL,0),(6,'Buraimi','','2022-10-01','2022-11-30',4,'2022-11-04',1,'open','Telecom - OBB',146000,'',0,NULL,0),(7,'Saham','','2022-11-06','2022-12-30',4,'2022-11-04',1,'open','Telecom - OBB',100000,'',0,NULL,0),(8,'Barriers Scrap','Sell of Scrap Barriers','2022-10-19','2022-10-19',1,'2022-11-09',1,'completed','Faisal Projects',1500,'',0,NULL,1),(9,'Barriers Scrap','Sales of scrap barriers','2022-10-22','2022-10-22',1,'2022-11-09',1,'completed','Faisal Projects',900,'',0,NULL,1),(10,'Scrap Barriers','Selling of crap barriers','2022-10-19','2022-10-19',1,'2022-11-09',1,'completed','Faisal Projects',1500,'',0,NULL,1),(11,'Al Fardan- Ferrari Showroom','Stretch Ceiling lights for the showroom','2022-11-16','2022-12-08',7,'2022-11-14',1,'open','fitout,ceiling,Interior Design',4954.2,'',0,NULL,0);

--
-- Table structure for table `Creative_Knowledgee_Landpurchase_order_items`
--

CREATE TABLE `Creative_Knowledgee_Landpurchase_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 `Creative_Knowledgee_Landpurchase_order_items`
--

INSERT INTO `Creative_Knowledgee_Landpurchase_order_items` VALUES (1,1,'Road Barrier','Second Hand Road Barriers',100,'pc',10.5,1050,0,1,0,0,0),(2,0,'Pipes','test',20,'',200,4000,0,2,0,0,0),(3,22,'Safety Barriers','',30,'nos',10.5,315,0,3,0,0,0);

--
-- Table structure for table `Creative_Knowledgee_Landpurchase_order_payments`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landpurchase_order_payments`
--

INSERT INTO `Creative_Knowledgee_Landpurchase_order_payments` VALUES (1,1050,'2022-10-10',4,'2022-10-19','','','',0,'transferred to Yousuf',1,'draft',0,0,0,1,'2022-10-19 08:01:32'),(2,4000,'2022-11-29',4,'2022-11-28','','','',0,'',2,'approved',0,8,0,1,'2022-11-28 11:50:33');

--
-- Table structure for table `Creative_Knowledgee_Landpurchase_orders`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landpurchase_orders`
--

INSERT INTO `Creative_Knowledgee_Landpurchase_orders` VALUES (1,1,'2022-10-11',0,'scrap','Road Barriers','not_paid','not_approved',0),(2,4,'2022-11-28',0,'','','not_paid','approved',0),(3,4,'2022-11-28',6,'','','draft','approved',0);

--
-- Table structure for table `Creative_Knowledgee_Landpurchase_return_items`
--

CREATE TABLE `Creative_Knowledgee_Landpurchase_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 `Creative_Knowledgee_Landpurchase_return_items`
--


--
-- Table structure for table `Creative_Knowledgee_Landpurchase_returns`
--

CREATE TABLE `Creative_Knowledgee_Landpurchase_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 `Creative_Knowledgee_Landpurchase_returns`
--


--
-- Table structure for table `Creative_Knowledgee_Landroles`
--

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

--
-- Dumping data for table `Creative_Knowledgee_Landroles`
--

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

--
