--
-- Host: localhost    Database: unhlsims
-- ------------------------------------------------------


--
-- Table structure for table `adhoc_configs`
--

CREATE TABLE `adhoc_configs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `option` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `adhoc_configs`
--

INSERT INTO `adhoc_configs` VALUES (1,'Report',1),(2,'ULIN',1),(3,'Clinician_UI',2);

--
-- Table structure for table `asset_mgts`
--

CREATE TABLE `asset_mgts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `asset_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `asset_category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `serial_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `manufacturer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `department` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cost` int(11) NOT NULL,
  `funder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date_of_delivery` date NOT NULL,
  `installation_date` date NOT NULL,
  `warranty_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `useful_life` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `disposal_date` date NOT NULL,
  `method_of_disposal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `repair_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `service_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comments` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_mgts`
--


--
-- Table structure for table `assigned_roles`
--

CREATE TABLE `assigned_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `assigned_roles_user_id_foreign` (`user_id`),
  KEY `assigned_roles_role_id_foreign` (`role_id`),
  CONSTRAINT `assigned_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `assigned_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `assigned_roles`
--

INSERT INTO `assigned_roles` VALUES (1,1,1),(2,1,1),(3,2,1),(4,1,1),(5,2,1),(7,1,1),(8,2,1),(12,1,1),(13,2,1),(15,1,1),(16,2,1),(18,3,1),(19,1,1),(20,2,1),(21,3,1),(22,1,1),(23,2,1),(24,2,2),(25,2,3),(26,3,1),(27,2,1),(28,2,2),(29,2,3),(30,3,1),(31,5,1);

--
-- Table structure for table `commodities`
--

CREATE TABLE `commodities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fundmanager_id` int(10) unsigned NOT NULL,
  `store` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `stores_id` int(10) unsigned NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `pack_size` int(11) NOT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `metric_id` int(10) unsigned NOT NULL,
  `category_id` int(10) unsigned NOT NULL,
  `min_level` int(11) NOT NULL,
  `max_level` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `available` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `commodities_metric_id_foreign` (`metric_id`),
  CONSTRAINT `commodities_metric_id_foreign` FOREIGN KEY (`metric_id`) REFERENCES `metrics` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `commodities`
--

INSERT INTO `commodities` VALUES (1,'cobas 881212',0,'',1,'',96,'llll',1,1,0,0,NULL,'2018-01-30 12:01:31','2018-01-30 12:01:31',NULL),(2,'Abbott RealTime HIV-1 Control Kit',0,'',1,'',5,'Abbott RealTime HIV-1 Control Kit',2,2,2,4,NULL,'2018-02-01 08:00:27','2018-02-01 08:00:27',NULL),(3,'Bulk mLysis DNA Buffer',0,'',2,'',90,'jasda',2,2,2,4,NULL,'2018-03-10 06:35:49','2018-03-10 06:35:49',NULL),(4,'Cobas omni Lysis Reagent',0,'',2,'',5,'jasdad',2,2,2,4,NULL,'2018-03-10 08:52:06','2018-03-10 08:52:06',NULL),(5,'Milk',0,'',2,'',8,'milk',1,1,2,4,NULL,'2018-03-10 08:53:42','2018-03-10 08:53:42',NULL),(6,'cake',0,'',1,'',89,'asdads',2,2,4,8,NULL,'2018-03-15 10:00:40','2018-03-15 10:00:40',NULL),(7,'butter',0,'',2,'',90,'jjad',2,2,9,18,NULL,'2018-03-15 11:12:02','2018-03-15 11:12:02',NULL),(8,'kiwi',0,'',2,'',90,'kj',2,2,8,9,NULL,'2018-03-15 11:28:07','2018-03-15 11:28:07',NULL),(9,'Nile',0,'',2,'',9,'-',2,2,4,8,NULL,'2018-03-21 14:55:35','2018-03-21 14:55:35',NULL),(10,'tusker',0,'',2,'',25,'-',2,2,4,8,NULL,'2018-03-21 15:26:54','2018-03-21 15:26:54',NULL),(11,'smirnoff',0,'',2,'',25,'-',2,2,3,6,NULL,'2018-03-21 16:41:41','2018-03-21 16:41:41',NULL),(12,'vodka',0,'',2,'',50,'-',2,2,3,6,NULL,'2018-03-22 19:38:32','2018-03-22 19:38:32',NULL),(13,'jameson',0,'',2,'',15,'whiskey',1,2,2,4,NULL,'2018-05-18 17:58:54','2018-05-18 17:58:54',NULL),(14,'huawei y52',0,'',2,'',98,'mobile phone',2,2,9,9,NULL,'2018-05-21 07:22:30','2018-05-21 07:22:30',NULL),(15,'dell laptops',0,'',2,'',1,'-',2,2,1,1,NULL,'2018-06-02 12:33:48','2018-06-02 12:33:48',NULL),(16,'pamper',0,'',2,'',9,'baby diapers',2,2,9,9,NULL,'2018-07-24 07:36:37','2018-07-24 07:36:37',NULL);

--
-- Table structure for table `commodity_categories`
--

CREATE TABLE `commodity_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `commodity_categories`
--

INSERT INTO `commodity_categories` VALUES (1,'garage3',NULL,'2018-01-30 11:59:59','2018-01-30 11:59:59'),(2,'ABBOT REAGENTS',NULL,'2018-02-01 07:33:42','2018-02-01 07:33:42');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `delivery_note`
--

CREATE TABLE `delivery_note` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deliverer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `purchase_form` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `commodity_id` int(10) unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `delivery_note` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `delivery_note`
--


--
-- Table structure for table `department_heads`
--

CREATE TABLE `department_heads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `department` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `department_heads`
--

INSERT INTO `department_heads` VALUES (1,'Kasule Daniel','benbyron24@gmail.com','male','9','2018-05-08 15:32:31','2018-05-08 15:32:31',NULL),(2,'Kasule Daniel','benbyron24@gmail.com','male','9','2018-05-08 15:33:05','2018-05-08 15:33:05',NULL),(3,'Kasule Daniel','benbyron24@gmail.com','male','9','2018-05-08 15:33:57','2018-05-08 15:33:57',NULL),(4,'Aidah Namakula','naidarayaan@gmail.com','female','4','2018-05-08 15:41:21','2018-05-08 15:41:21',NULL);

--
-- Table structure for table `dept_requisition`
--

CREATE TABLE `dept_requisition` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL,
  `quantity` int(11) NOT NULL,
  `department` int(11) NOT NULL,
  `requested_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `requestor_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dept_requisition`
--


--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `district`
--


--
-- Table structure for table `external_dump`
--

CREATE TABLE `external_dump` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lab_no` int(11) NOT NULL,
  `parent_lab_no` int(11) NOT NULL,
  `test_id` int(11) DEFAULT NULL,
  `requesting_clinician` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `investigation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provisional_diagnosis` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_date` timestamp NULL DEFAULT NULL,
  `order_stage` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `result` text COLLATE utf8_unicode_ci,
  `result_returned` int(11) DEFAULT NULL,
  `patient_visit_number` int(11) DEFAULT NULL,
  `patient_id` int(11) NOT NULL,
  `full_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dob` datetime DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cost` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `receipt_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `receipt_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `waiver_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `system_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `external_dump_lab_no_unique` (`lab_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `external_dump`
--


--
-- Table structure for table `external_users`
--

CREATE TABLE `external_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `internal_user_id` int(10) unsigned NOT NULL,
  `external_user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `external_users_internal_user_id_unique` (`internal_user_id`),
  CONSTRAINT `external_users_internal_user_id_foreign` FOREIGN KEY (`internal_user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `external_users`
--


--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `facilities`
--


--
-- Table structure for table `facility_request`
--

CREATE TABLE `facility_request` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` int(10) unsigned NOT NULL,
  `facility_id` int(10) unsigned NOT NULL,
  `commodity_id` int(10) unsigned NOT NULL,
  `quantity` int(11) NOT NULL,
  `requested_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `request_status_id` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `incharge` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `incharge_mail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `requestor_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `facility_request`
--

INSERT INTO `facility_request` VALUES (1,57,2,6,100,'Benson Okello',1,NULL,'2018-06-01 00:20:30','2018-06-01 00:27:04',NULL,NULL,'benbyron24@gmail.com'),(2,9,44,3,123,'Jeff Anguyo',0,NULL,'2018-06-01 00:28:04','2018-06-01 00:28:04',NULL,NULL,'geoflen@gmail.com'),(3,58,3,13,1,'Jeff Anguyo',0,NULL,'2018-06-01 00:36:15','2018-06-01 00:36:15','isa kalyango','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(4,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:41:53','2018-06-01 00:41:53','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(5,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:42:53','2018-06-01 00:42:53','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(6,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:43:51','2018-06-01 00:43:51','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(7,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:44:11','2018-06-01 00:44:11','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(8,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:44:41','2018-06-01 00:44:41','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(9,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:44:51','2018-06-01 00:44:51','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(10,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:45:56','2018-06-01 00:45:56','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(11,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:47:54','2018-06-01 00:47:54','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(12,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:48:21','2018-06-01 00:48:21','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(13,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:49:08','2018-06-01 00:49:08','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(14,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:56:16','2018-06-01 00:56:16','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(15,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 00:56:56','2018-06-01 00:56:56','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(16,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:02:29','2018-06-01 01:02:29','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(17,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:03:04','2018-06-01 01:03:04','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(18,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:03:29','2018-06-01 01:03:29','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(19,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:03:43','2018-06-01 01:03:43','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(20,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:04:21','2018-06-01 01:04:21','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(21,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:04:34','2018-06-01 01:04:34','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(22,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:04:44','2018-06-01 01:04:44','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(23,7,36,9,25,'Jeff Anguyo',0,NULL,'2018-06-01 01:05:50','2018-06-01 01:05:50','juma Kareem','okello.benson@utamu.ac.ug','geoflen@gmail.com'),(24,57,2,2,5,'Benson Okello',0,NULL,'2018-07-20 10:01:04','2018-07-20 10:01:04','Julius Opoka','julio@gmail.com','benbyron24@gmail.com');

--
-- Table structure for table `fund_managers`
--

CREATE TABLE `fund_managers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contact_person` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fund_sources` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `normal_working_hours` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `weekend_working_hours` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `holiday_working_hours` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `delivery_schedule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fund_managers`
--

INSERT INTO `fund_managers` VALUES (1,'MILD MAY','Emmanuel Omony','pepfar','omony.emmanuel@mildmay.org','0785262623','7:00-5:00pm','8-2pm','7:00-5:00pm','4-5 times','butabika');

--
-- Table structure for table `fund_sources`
--

CREATE TABLE `fund_sources` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fund_sources`
--


--
-- Table structure for table `goods_received`
--

CREATE TABLE `goods_received` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goods_received`
--


--
-- Table structure for table `goods_recieveds`
--

CREATE TABLE `goods_recieveds` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_of_receipt` date NOT NULL,
  `supplier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `serial_number` int(11) NOT NULL,
  `delivery_note_number` int(11) NOT NULL,
  `invoice_number` int(11) NOT NULL,
  `delivered_at` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vehicle_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `base_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry` date NOT NULL,
  `quantity` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `cost` int(11) NOT NULL,
  `produced_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `verified_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `received_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `Signature` text COLLATE utf8_unicode_ci NOT NULL,
  `Designation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `goods_recieveds`
--


--
-- Table structure for table `hubs`
--

CREATE TABLE `hubs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `district_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `hubs`
--


--
-- Table structure for table `ict_equipment_breakdown`
--

CREATE TABLE `ict_equipment_breakdown` (
  `breakdown_type` int(11) NOT NULL,
  `reported_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `breakdown_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ict_equipment_breakdown`
--


--
-- Table structure for table `ict_equipment_inventory`
--

CREATE TABLE `ict_equipment_inventory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `serial_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `location` int(11) NOT NULL,
  `procurement_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `purchase_date` datetime NOT NULL,
  `delivery_date` datetime NOT NULL,
  `verification_date` datetime NOT NULL,
  `installation_date` datetime NOT NULL,
  `spare_parts` tinyint(1) NOT NULL,
  `warranty` int(11) NOT NULL,
  `life_span` int(11) NOT NULL,
  `service_frequency` tinyint(1) NOT NULL,
  `service_contract` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ict_equipment_inventory`
--


--
-- Table structure for table `ict_equipment_maintenace`
--

CREATE TABLE `ict_equipment_maintenace` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `equipment_id` int(10) unsigned NOT NULL,
  `last_service_date` datetime NOT NULL,
  `next_service_date` datetime NOT NULL,
  `serviced_by_name` text COLLATE utf8_unicode_ci NOT NULL,
  `serviced_by_contact` text COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `ict_equipment_maintenace_equipment_id_foreign` (`equipment_id`),
  CONSTRAINT `ict_equipment_maintenace_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `ict_equipment_inventory` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ict_equipment_maintenace`
--


--
-- Table structure for table `ict_equipment_supplier`
--

CREATE TABLE `ict_equipment_supplier` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ict_equipment_supplier`
--


--
-- Table structure for table `inhouse_requisition`
--

CREATE TABLE `inhouse_requisition` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL,
  `department` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `requested_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `requestor_email` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `approved_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_status_id` int(10) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `issue_unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `incharge` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `folio_number` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `incharge_mail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `issued_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rejected_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `inhouse_requisition`
--

INSERT INTO `inhouse_requisition` VALUES (1,1,'3',9,'Admin','','0',1,NULL,'2018-01-30 12:13:28','2018-01-31 16:28:55',NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'0',87,'Admin','','0',1,NULL,'2018-01-30 12:16:21','2018-01-31 16:28:45',NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'5',234,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-30 12:46:33','2018-01-30 12:47:02',NULL,NULL,NULL,NULL,NULL,NULL),(4,1,'2',90,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-30 13:15:43','2018-01-30 13:19:09',NULL,NULL,NULL,NULL,NULL,NULL),(5,1,'2',99,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-30 13:15:52','2018-01-30 13:23:13',NULL,NULL,NULL,NULL,NULL,NULL),(6,1,'0',88,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-30 13:26:59','2018-01-30 13:27:07',NULL,NULL,NULL,NULL,NULL,NULL),(7,1,'0',87,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-30 13:37:40','2018-01-30 15:11:10',NULL,NULL,NULL,NULL,NULL,NULL),(8,1,'2',99,'Jeff Anguyo','geoflen@gmail.com','0',2,NULL,'2018-01-30 13:40:46','2018-01-30 13:40:57',NULL,NULL,NULL,NULL,NULL,NULL),(9,1,'6',87,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-01-31 18:54:58','2018-02-01 08:18:53',NULL,NULL,NULL,NULL,NULL,NULL),(10,2,'6',3,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-02-01 08:10:23','2018-02-01 08:18:48',NULL,NULL,NULL,NULL,NULL,NULL),(11,2,'0',12,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-02-02 19:08:12','2018-02-02 19:08:22',NULL,NULL,NULL,NULL,NULL,NULL),(12,2,'1',12,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',4,NULL,'2018-02-02 19:11:02','2018-07-24 08:50:51',NULL,NULL,NULL,NULL,NULL,NULL),(13,2,'9',9,'Admin','','Benson Okello',3,NULL,'2018-03-14 06:05:55','2018-06-02 11:51:43',NULL,NULL,NULL,NULL,'Benson Okello',NULL),(14,2,'9',9,'Admin','','Benson Okello',3,NULL,'2018-03-14 06:07:06','2018-06-02 11:50:40',NULL,NULL,NULL,NULL,'Benson Okello',NULL),(15,2,'9',9,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-03-14 06:07:35','2018-04-09 16:18:54',NULL,NULL,NULL,NULL,NULL,NULL),(16,3,'9',9,'Benson Okello','benbyron24@gmail.com','1',1,NULL,'2018-03-14 06:07:52','2018-05-05 13:59:31',NULL,NULL,NULL,NULL,NULL,NULL),(17,3,'9',9,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:08:33','2018-05-05 13:54:18',NULL,NULL,NULL,NULL,NULL,NULL),(18,3,'9',9,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',4,NULL,'2018-03-14 06:09:26','2018-07-23 18:31:55',NULL,NULL,NULL,NULL,NULL,NULL),(19,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:09:49','2018-05-05 13:16:26',NULL,NULL,NULL,NULL,NULL,NULL),(20,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:11:06','2018-05-05 13:05:07',NULL,NULL,NULL,NULL,NULL,NULL),(21,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:14:43','2018-04-10 18:52:09',NULL,NULL,NULL,NULL,NULL,NULL),(22,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:15:25','2018-03-27 13:44:57',NULL,NULL,NULL,NULL,NULL,NULL),(23,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 06:15:47','2018-03-24 11:59:51',NULL,NULL,NULL,NULL,NULL,NULL),(24,1,'1',5,'Admin','','Benson Okello',3,NULL,'2018-03-14 13:38:20','2018-06-02 11:39:23',NULL,NULL,NULL,NULL,'Benson Okello',NULL),(25,5,'3',7,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 13:39:19','2018-03-24 12:00:12',NULL,NULL,NULL,NULL,NULL,NULL),(26,1,'3',8,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-14 13:40:04','2018-03-16 08:20:48',NULL,NULL,NULL,NULL,NULL,NULL),(27,1,'3',8,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-03-14 13:42:01','2018-03-16 08:20:38',NULL,NULL,NULL,NULL,NULL,NULL),(28,2,'0',5,'Benson Okello','benbyron24@gmail.com','0',2,NULL,'2018-03-14 13:52:05','2018-03-14 18:17:17',NULL,NULL,NULL,NULL,NULL,NULL),(29,3,'5',6,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:21:49','2018-06-02 11:38:01',NULL,NULL,NULL,NULL,'Benson Okello',NULL),(30,2,'1',30,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:38:27','2018-06-02 11:42:19','pc','0',NULL,NULL,'Benson Okello',NULL),(31,2,'2',89,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:42:49','2018-06-02 11:41:52','Pack','0',NULL,NULL,'Benson Okello',NULL),(32,2,'0',8,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:45:33','2018-06-02 11:41:06','pack','0','toc',NULL,'Benson Okello',NULL),(33,2,'0',9,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:54:48','2018-06-02 11:44:12',NULL,'0','ppppp',NULL,'Benson Okello',NULL),(34,2,'0',991,'Admin','','Benson Okello',3,NULL,'2018-03-16 08:55:25','2018-06-02 11:29:48','2','0','kasdasd',NULL,'Benson Okello',NULL),(35,6,'5',50,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-16 09:12:49','2018-03-16 09:14:35','2','0','-',NULL,NULL,NULL),(36,2,'11',9,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-03-24 11:59:33','2018-03-24 12:00:02','2','0','-',NULL,NULL,NULL),(37,2,'0',9,'Admin','','0',2,NULL,'2018-03-27 13:33:21','2018-04-10 16:56:48','2','0','-',NULL,NULL,NULL),(38,3,'2',9,'Admin','','Benson Okello',3,NULL,'2018-04-04 10:55:46','2018-06-02 11:29:30','2','0','-',NULL,'Benson Okello',NULL),(39,9,'5',100,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-04-04 10:56:48','2018-04-04 10:57:03','2','0','-',NULL,NULL,NULL),(40,7,'11',23,'Jeff Anguyo','geoflen@gmail.com','Benson Okello',3,NULL,'2018-04-04 10:57:40','2018-06-02 11:25:39','1','0','-----',NULL,'Benson Okello',NULL),(41,6,'6',90,'Benson Okello','benbyron24@gmail.com','0',1,NULL,'2018-04-04 10:58:14','2018-04-04 10:58:25','1','0','-',NULL,NULL,NULL),(42,8,'0',10,'Admin','','Benson Okello',3,NULL,'2018-04-09 07:00:10','2018-06-02 11:25:07','2','0','122333',NULL,'Benson Okello',NULL),(43,2,'1',150000,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-05-05 15:00:08','2018-05-05 15:00:08','2','0','okello','benbyron24@gmail.com',NULL,NULL),(44,2,'1',150000,'Benson Okello','benbyron24@gmail.com',NULL,2,NULL,'2018-05-05 15:02:27','2018-07-24 09:14:35','2','0','okello','benbyron24@gmail.com',NULL,'Jeff Anguyo'),(45,2,'1',150000,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-05-05 15:04:39','2018-07-24 09:12:11','2','0','okello1234',NULL,NULL,NULL),(46,2,'1',150000,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',4,NULL,'2018-05-05 15:05:18','2018-07-24 09:13:55','2','0','okello1234','benbyron24@gmail.com',NULL,NULL),(47,2,'1',150000,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-05-05 15:06:39','2018-05-05 15:06:39','2','0','okello1234','benbyron24@gmail.com',NULL,NULL),(48,2,'1',150000,'Benson Okello','benbyron24@gmail.com','Admin',1,NULL,'2018-05-05 15:07:02','2018-05-05 19:02:16','2','0','okello1234','benbyron24@gmail.com',NULL,NULL),(49,3,'2',90000,'Benson Okello','benbyron24@gmail.com','Admin',1,NULL,'2018-05-05 15:09:53','2018-05-05 18:55:42','2','0','kayemba123','okello.benson@utamu.ac.ug',NULL,NULL),(50,9,'5',25,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',3,NULL,'2018-05-08 15:53:48','2018-06-02 11:30:57','2','0','peter','benbyron24@gmail.com','Jeff Anguyo',NULL),(51,11,'9',25,'Benson Okello','benbyron24@gmail.com',NULL,2,NULL,'2018-05-08 15:57:09','2018-05-25 14:29:50','2','1','otema','okello.benson@utamu.ac.ug',NULL,NULL),(52,3,'0',10,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-05-25 14:28:31','2018-05-25 14:29:20','2','1','-','ashraf.kasujja@medicalaccess.co.ug',NULL,NULL),(53,2,'0',90,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-06-04 06:34:15','2018-06-04 06:34:15','2','4','-','benbyron24@gmail.com',NULL,NULL),(54,2,'0',90,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-06-04 06:34:24','2018-06-04 06:34:24','2','4','-','benbyron24@gmail.com',NULL,NULL),(55,2,'0',90,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-06-04 06:35:15','2018-06-04 06:35:15','2','4','-','benbyron24@gmail.com',NULL,NULL),(56,2,'0',90,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-06-04 07:20:26','2018-06-04 07:20:26','2','4','-','benbyron24@gmail.com',NULL,NULL),(57,2,'0',90,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-04 07:22:36','2018-07-24 09:07:17','2','4','-','benbyron24@gmail.com',NULL,NULL),(58,2,'0',90,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-04 07:23:33','2018-07-24 09:08:11','2','4','-','benbyron24@gmail.com',NULL,NULL),(59,2,'0',90,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-04 07:23:41','2018-07-24 09:08:56','2','4','-','benbyron24@gmail.com',NULL,NULL),(60,6,'0',5,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-05 09:12:05','2018-07-24 09:10:03','2','4','13','benbyron24@gmail.com',NULL,NULL),(61,6,'0',5,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-05 09:13:15','2018-07-24 09:01:36','2','4','13','benbyron24@gmail.com',NULL,NULL),(62,6,'0',5,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-05 09:13:53','2018-07-24 08:55:48','2','4','13','benbyron24@gmail.com',NULL,NULL),(63,6,'0',5,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',4,NULL,'2018-06-05 09:14:07','2018-07-24 09:03:09','2','4','13','benbyron24@gmail.com',NULL,NULL),(64,6,'0',5,'Benson Okello','benbyron24@gmail.com',NULL,0,'2018-06-05 09:21:05','2018-06-05 09:14:36','2018-06-05 09:21:05','2','4','13','benbyron24@gmail.com',NULL,NULL),(65,6,'0',5,'Benson Okello','benbyron24@gmail.com',NULL,0,'2018-06-05 09:20:03','2018-06-05 09:14:48','2018-06-05 09:20:03','2','4','13','benbyron24@gmail.com',NULL,NULL),(66,6,'0',5,'Benson Okello','benbyron24@gmail.com',NULL,0,'2018-06-05 09:19:34','2018-06-05 09:15:03','2018-06-05 09:19:34','2','4','13','benbyron24@gmail.com',NULL,NULL),(67,3,'1',12,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',1,NULL,'2018-06-05 09:26:11','2018-07-24 08:51:12','2','2','9991','benbyron24@gmail.com',NULL,NULL),(71,4,'0',89,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',4,NULL,'2018-07-20 11:22:48','2018-07-24 09:02:25','1','0','12',NULL,NULL,NULL),(72,12,'4',67,'Benson Okello','benbyron24@gmail.com','Jeff Anguyo',3,NULL,'2018-07-23 17:52:26','2018-07-24 09:02:47','1','2','123',NULL,'Jeff Anguyo',NULL),(73,2,'0',700,'admin','okello.benson@utamu.ac.ug','Benson Okello',3,NULL,'2018-07-25 08:46:37','2018-07-25 08:48:22','2','1','1234455',NULL,'Benson Okello',NULL),(74,2,'0',45,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-07-25 09:36:41','2018-07-25 09:36:41','2','0','asd',NULL,NULL,NULL),(75,2,'6',450,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-07-25 09:58:15','2018-07-25 09:58:15','2','0','asd10091',NULL,NULL,NULL),(76,2,'4',900,'Benson Okello','benbyron24@gmail.com',NULL,0,NULL,'2018-07-25 17:15:51','2018-07-25 17:15:51','2','0','8913','',NULL,NULL);

--
-- Table structure for table `instruments`
--

CREATE TABLE `instruments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hostname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `driver_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `instruments`
--


--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `purchase_form` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `delivery_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `delivery_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `items_delivered` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `invoice_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `invoice_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `invoice`
--


--
-- Table structure for table `issues`
--

CREATE TABLE `issues` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `receipt_id` int(10) unsigned NOT NULL,
  `topup_request_id` int(10) unsigned NOT NULL,
  `quantity_issued` int(11) NOT NULL,
  `issued_to` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `remarks` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `issues_topup_request_id_foreign` (`topup_request_id`),
  KEY `issues_receipt_id_foreign` (`receipt_id`),
  KEY `issues_issued_to_foreign` (`issued_to`),
  KEY `issues_user_id_foreign` (`user_id`),
  CONSTRAINT `issues_issued_to_foreign` FOREIGN KEY (`issued_to`) REFERENCES `users` (`id`),
  CONSTRAINT `issues_receipt_id_foreign` FOREIGN KEY (`receipt_id`) REFERENCES `receipts` (`id`),
  CONSTRAINT `issues_topup_request_id_foreign` FOREIGN KEY (`topup_request_id`) REFERENCES `topup_requests` (`id`),
  CONSTRAINT `issues_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `issues`
--


--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `items`
--


--
-- Table structure for table `jeff`
--

CREATE TABLE `jeff` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `jeff`
--

INSERT INTO `jeff` VALUES (1,'2200000480068240119100','2200000480068240119100','02/27/2018','2200000480068240119100','02/27/2018','2200000480068240119100','02/28/2018',89,10,10,10,15,'2018-02-20 17:47:11','2018-02-20 17:47:11'),(2,'2200000480068240119100','2200000480068240119100','02/28/2018','2200000480068240119100','02/27/2018','23','02/27/2018',90,10,10,10,3,'2018-02-20 18:00:44','2018-02-20 18:00:44');

--
-- Table structure for table `kush`
--

CREATE TABLE `kush` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `kush`
--


--
-- Table structure for table `lab_consumables`
--

CREATE TABLE `lab_consumables` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lab_consumables`
--


--
-- Table structure for table `lab_reagents`
--

CREATE TABLE `lab_reagents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lab_reagents`
--


--
-- Table structure for table `lena`
--

CREATE TABLE `lena` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lena`
--


--
-- Table structure for table `local_purchase_order`
--

CREATE TABLE `local_purchase_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `local_purchase_order`
--


--
-- Table structure for table `m3`
--

CREATE TABLE `m3` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `m3`
--


--
-- Table structure for table `measure_types`
--

CREATE TABLE `measure_types` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `measure_types_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `measure_types`
--


--
-- Table structure for table `measures`
--

CREATE TABLE `measures` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `measure_type_id` int(10) unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `unit` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `measures_measure_type_id_foreign` (`measure_type_id`),
  CONSTRAINT `measures_measure_type_id_foreign` FOREIGN KEY (`measure_type_id`) REFERENCES `measure_types` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `measures`
--


--
-- Table structure for table `mechanical_breakdown`
--

CREATE TABLE `mechanical_breakdown` (
  `breakdown_type` int(11) NOT NULL,
  `reported_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `breakdown_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mechanical_breakdown`
--


--
-- Table structure for table `mechanical_inventory`
--

CREATE TABLE `mechanical_inventory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `serial_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `location` int(11) NOT NULL,
  `procurement_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `equipment_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `equipment_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(10) unsigned NOT NULL,
  `quantity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `manufacture_date` date NOT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `purchase_date` datetime NOT NULL,
  `delivery_date` datetime NOT NULL,
  `verification_date` datetime NOT NULL,
  `installation_date` datetime NOT NULL,
  `spare_parts` tinyint(1) NOT NULL,
  `warranty` int(11) NOT NULL,
  `life_span` int(11) NOT NULL,
  `service_frequency` tinyint(1) NOT NULL,
  `service_contract` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mechanical_inventory`
--


--
-- Table structure for table `mechanical_maintenace`
--

CREATE TABLE `mechanical_maintenace` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mechanical_equipment_id` int(10) unsigned NOT NULL,
  `last_service_date` datetime NOT NULL,
  `next_service_date` datetime NOT NULL,
  `serviced_by_name` text COLLATE utf8_unicode_ci NOT NULL,
  `serviced_by_contact` text COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `mechanical_maintenace_mechanical_equipment_id_foreign` (`mechanical_equipment_id`),
  CONSTRAINT `mechanical_maintenace_mechanical_equipment_id_foreign` FOREIGN KEY (`mechanical_equipment_id`) REFERENCES `mechanical_inventory` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mechanical_maintenace`
--


--
-- Table structure for table `mechanical_supplier`
--

CREATE TABLE `mechanical_supplier` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mechanical_supplier`
--


--
-- Table structure for table `meghan`
--

CREATE TABLE `meghan` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `meghan`
--


--
-- Table structure for table `metrics`
--

CREATE TABLE `metrics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `metrics`
--

INSERT INTO `metrics` VALUES (1,'Liter','',NULL,'2018-01-30 12:00:09','2018-01-30 12:00:09'),(2,'BUNDLE','asaa',NULL,'2018-02-01 07:34:21','2018-02-01 07:34:21');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES ('2014_07_24_082711_CreatekBLIStables',1),('2014_09_02_114206_entrust_setup_tables',1),('2014_10_09_162222_externaldumptable',1),('2015_02_27_084341_createInventoryTables',1),('2016_07_26_095319_create_unhls_financial_years_table',1),('2016_08_31_135348_create_unhls_stockcard',1),('2016_08_31_135420_create_unhls_stockrequisition',1),('2016_09_28_091952_create_unhls_warehouse',1),('2016_09_28_095327_create_unhls_staff',1),('2016_10_13_170615_create_unhls_equipment_suppliers_table',1),('2017_01_16_103507_create_equipment_inventory_table',1),('2017_01_16_103533_create_equipment_maintenance_table',1),('2017_01_16_103546_create_equipment_breakdown_table',1),('2017_05_21_174153_create_goods_recieveds_table',1),('2017_05_22_091824_create_requistions_table',1),('2017_05_25_131728_updateUNHLSBreakdown',1),('2017_06_15_182541_create_asset_mgts_table',1),('2017_06_16_063134_create_supplychainmgts_table',1),('2017_06_19_094902_update_equipment_inventory_table',1),('2017_06_19_111831_update_equipment_breakdown_table',1),('2017_06_19_115028_update_unhls_stockcard_table',1),('2017_06_20_043838_alter_stockcard_table',1),('2017_06_27_155020_items',1),('2017_09_17_192003_create_transport',1),('2017_09_17_192003_create_transportandfleets',1),('2017_10_04_122912_create_order_tables',1),('2017_10_11_174805_create_requisitions',1),('2017_10_11_174857_create_commodity_categories',1),('2017_10_14_172614_create_dept_requisition',1),('2017_10_27_121731_create_lab_consumables',1),('2017_10_27_121737_create_office_supplies',1),('2017_10_27_121953_create_lab_reagents',1),('2017_11_08_212313_create_store_section',1),('2017_11_15_145717_create_documents',1),('2017_11_22_120746_create_asset_mgt_tables',1),('2017_12_18_110812_create_biomedical',1),('2017_12_19_184019_create_countries',1),('2018_01_08_082351_create_district',1),('2018_01_08_172241_create_facility_request',1),('2018_01_09_083731_create_hubs',1),('2018_02_09_084504_create_abbott_tables',2),('2018_02_21_132315_create_unhls_departments',3),('2017_10_15_122554_adhoc_configs_table',4),('2018_05_08_171914_create_department_heads',5);

--
-- Table structure for table `office_supplies`
--

CREATE TABLE `office_supplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `office_supplies`
--


--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `commodity_id` int(10) unsigned NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fund_manager_id` int(10) unsigned NOT NULL,
  `fund_source_id` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `unit_cost` int(10) unsigned NOT NULL,
  `total_cost` int(10) unsigned NOT NULL,
  `due_date` date NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `approved_by` int(10) unsigned NOT NULL,
  `metric_id` int(10) unsigned NOT NULL,
  `order_status_id` int(10) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,NULL,2,NULL,1,1,1,50,10000,0,'2018-06-17',2,0,2,0,NULL,'2018-05-18 15:46:59','2018-05-18 15:46:59');

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_foreign` (`permission_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,5,1),(6,6,1),(7,7,1),(8,8,1),(9,9,1),(10,10,1),(11,11,1),(12,12,1),(13,13,1),(14,14,1),(15,15,1),(16,16,1),(17,17,1),(18,18,1),(19,19,1),(20,20,1),(21,21,1),(22,22,1),(23,23,1),(24,24,1),(25,25,1),(26,26,1),(27,27,1),(28,28,1),(29,1,1),(30,2,1),(31,3,1),(32,4,1),(33,5,1),(34,6,1),(35,7,1),(36,8,1),(37,9,1),(38,9,2),(39,10,1),(40,11,1),(41,12,1),(42,13,1),(43,14,1),(44,15,1),(45,16,1),(46,17,1),(47,18,1),(48,19,1),(49,20,1),(50,21,1),(51,22,1),(52,23,1),(53,24,1),(54,25,1),(55,26,1),(56,27,1),(57,28,1);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'can_manage_inhouse_requisition','Manage inhouse requisitions','2018-01-30 11:58:49','2018-01-30 11:58:49'),(2,'ict_dept','Heads ICT Dept','2018-01-30 11:58:49','2018-01-30 11:58:49'),(3,'lab_manager','Heads Laboratory','2018-01-30 11:58:49','2018-01-30 11:58:49'),(4,'vl_head','Heads VL lab','2018-01-30 11:58:49','2018-01-30 11:58:49'),(5,'eid_head','Heads EID lab','2018-01-30 11:58:49','2018-01-30 11:58:49'),(6,'Microbiology_head','Heads Microbiology','2018-01-30 11:58:49','2018-01-30 11:58:49'),(7,'sample_reception_head','Heads Sample Reception','2018-01-30 11:58:49','2018-01-30 11:58:49'),(8,'data_head','Heads Data','2018-01-30 11:58:49','2018-01-30 11:58:49'),(9,'stores_head','Heads Stores','2018-01-30 11:58:49','2018-01-30 11:58:49'),(10,'manage_users','Can manage users','2018-01-30 11:58:49','2018-01-30 11:58:49'),(11,'view_reports','Can view reports','2018-01-30 11:58:49','2018-01-30 11:58:49'),(12,'manage_inventory','Can manage inventory','2018-01-30 11:58:49','2018-01-30 11:58:49'),(13,'request_topup','Can request top-up','2018-01-30 11:58:49','2018-01-30 11:58:49'),(14,'assetmgt','Can manage Assets','2018-01-30 11:58:49','2018-01-30 11:58:49'),(15,'handle_invoice','Can manage Documents','2018-01-30 11:58:49','2018-01-30 11:58:49'),(16,'manage_biomed_assets','Can manage Bio-medical assets','2018-01-30 11:58:49','2018-01-30 11:58:49'),(17,'manage_ict_assets','Can manage ICT assets','2018-01-30 11:58:49','2018-01-30 11:58:49'),(18,'manage_transport_and_fleet','Can manage Transport & Fleet assets','2018-01-30 11:58:49','2018-01-30 11:58:49'),(19,'handle_dept_requests','Manage Department Requests','2018-01-30 11:58:49','2018-01-30 11:58:49'),(20,'manage_commodities','Manage Store Commodities','2018-01-30 11:58:49','2018-01-30 11:58:49'),(21,'manage_stock_card','Manage Stock Card','2018-01-30 11:58:49','2018-01-30 11:58:49'),(22,'place_unhls_order','Can Place UNHLS Store Orders','2018-01-30 11:58:49','2018-01-30 11:58:49'),(23,'view_stock_reports','View Stock Reports','2018-01-30 11:58:49','2018-01-30 11:58:49'),(24,'log_biomed_breakdown','Can Log Bio-medical breakdown','2018-01-30 11:58:49','2018-01-30 11:58:49'),(25,'manage_facility_request','Manage Facility Request','2018-01-30 11:58:49','2018-01-30 11:58:49'),(26,'manage_fund_managers','Manage Fund Managers','2018-01-30 11:58:49','2018-01-30 11:58:49'),(27,'manage_hubs_and_facilities','Manage Hubs & Facilities','2018-01-30 11:58:49','2018-01-30 11:58:49'),(28,'approve_request','Reject or Approve','2018-01-30 11:58:49','2018-01-30 11:58:49');

--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `batch_no` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `expiry_date` date NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `receipts_commodity_id_foreign` (`commodity_id`),
  KEY `receipts_supplier_id_foreign` (`supplier_id`),
  KEY `receipts_user_id_foreign` (`user_id`),
  CONSTRAINT `receipts_commodity_id_foreign` FOREIGN KEY (`commodity_id`) REFERENCES `commodities` (`id`),
  CONSTRAINT `receipts_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`),
  CONSTRAINT `receipts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `receipts`
--


--
-- Table structure for table `rejection_reasons`
--

CREATE TABLE `rejection_reasons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reason` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rejection_reasons`
--


--
-- Table structure for table `requisitions`
--

CREATE TABLE `requisitions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `requisitions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Superadministrator',NULL,'2018-01-30 11:58:49','2018-01-30 11:58:49'),(2,'Stores Manager',NULL,'2018-01-30 11:58:49','2018-01-30 11:58:49'),(3,'Stores Assistant',NULL,'2018-01-30 11:58:49','2018-01-30 11:58:49');

--
-- Table structure for table `samuel`
--

CREATE TABLE `samuel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `samuel`
--


--
-- Table structure for table `store_section`
--

CREATE TABLE `store_section` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `capacity` float(8,2) NOT NULL,
  `width` float(8,2) NOT NULL,
  `height` float(8,2) NOT NULL,
  `length` float(8,2) NOT NULL,
  `min_temp` float(8,2) NOT NULL,
  `max_temp` float(8,2) NOT NULL,
  `created_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `store_section`
--

INSERT INTO `store_section` VALUES (1,'VL section',100.00,0.00,0.00,0.00,7.00,10.00,'Admin','2018-01-30 12:00:44','2018-01-30 12:00:44'),(2,'EID Section',1000.00,0.00,0.00,0.00,8.00,20.00,'Jeff Anguyo','2018-02-01 07:35:53','2018-02-01 07:35:53');

--
-- Table structure for table `sula`
--

CREATE TABLE `sula` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sula`
--


--
-- Table structure for table `supplier_evaluation`
--

CREATE TABLE `supplier_evaluation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `supplier_evaluation`
--


--
-- Table structure for table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phone_no` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `physical_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` VALUES (1,'NMS','','','',NULL,'2018-01-30 12:00:20','2018-01-30 12:00:20'),(2,'MAUL','0414237707','maul@gmail.com','jinja',NULL,'2018-02-01 07:34:48','2018-02-01 07:34:48'),(3,'Okello\'s List','0414237707','benbyron24@gmail.com','none',NULL,'2018-05-30 10:39:24','2018-05-30 10:39:24');

--
-- Table structure for table `supplychainmgts`
--

CREATE TABLE `supplychainmgts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `supplychainmgts`
--


--
-- Table structure for table `tadeo`
--

CREATE TABLE `tadeo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tadeo`
--


--
-- Table structure for table `topup_requests`
--

CREATE TABLE `topup_requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL,
  `test_category_id` int(10) unsigned NOT NULL,
  `order_quantity` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `remarks` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `topup_requests_commodity_id_foreign` (`commodity_id`),
  KEY `topup_requests_user_id_foreign` (`user_id`),
  CONSTRAINT `topup_requests_commodity_id_foreign` FOREIGN KEY (`commodity_id`) REFERENCES `commodities` (`id`),
  CONSTRAINT `topup_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `topup_requests`
--


--
-- Table structure for table `transport`
--

CREATE TABLE `transport` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `engine_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `chasis_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `engine_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `funder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `manufacturer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vehicle_state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `warranty_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `registered_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `transport_registration_number_unique` (`registration_number`),
  UNIQUE KEY `transport_engine_number_unique` (`engine_number`),
  UNIQUE KEY `transport_chasis_number_unique` (`chasis_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transport`
--


--
-- Table structure for table `transportandfleets`
--

CREATE TABLE `transportandfleets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `engine_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `chasis_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `engine_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `funder` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `manufacturer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vehicle_state` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `warranty_details` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `transportandfleets_registration_number_unique` (`registration_number`),
  UNIQUE KEY `transportandfleets_engine_number_unique` (`engine_number`),
  UNIQUE KEY `transportandfleets_chasis_number_unique` (`chasis_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transportandfleets`
--


--
-- Table structure for table `unhls_departments`
--

CREATE TABLE `unhls_departments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_departments`
--

INSERT INTO `unhls_departments` VALUES (1,'Operations','2018-10-09 21:00:00','2018-10-09 21:00:00'),(2,'ICT','2018-10-09 21:00:00','2018-10-09 21:00:00');

--
-- Table structure for table `unhls_districts`
--

CREATE TABLE `unhls_districts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_districts`
--

INSERT INTO `unhls_districts` VALUES (1,'Kampala','2018-01-30 11:58:48','2018-01-30 11:58:48'),(2,'Buikwe','2018-01-30 11:58:48','2018-01-30 11:58:48'),(3,'Bukomansimbi','2018-01-30 11:58:48','2018-01-30 11:58:48'),(4,'Butambala','2018-01-30 11:58:48','2018-01-30 11:58:48'),(5,'Buvuma','2018-01-30 11:58:48','2018-01-30 11:58:48'),(6,'Gomba','2018-01-30 11:58:48','2018-01-30 11:58:48'),(7,'Kalangala','2018-01-30 11:58:48','2018-01-30 11:58:48'),(8,'Kalungu','2018-01-30 11:58:48','2018-01-30 11:58:48'),(9,'Kayunga','2018-01-30 11:58:48','2018-01-30 11:58:48'),(10,'Kiboga','2018-01-30 11:58:48','2018-01-30 11:58:48'),(11,'Kyankwanzi','2018-01-30 11:58:48','2018-01-30 11:58:48'),(12,'Luweero','2018-01-30 11:58:48','2018-01-30 11:58:48'),(13,'Lwengo','2018-01-30 11:58:48','2018-01-30 11:58:48'),(14,'Lyantonde','2018-01-30 11:58:48','2018-01-30 11:58:48'),(15,'Masaka','2018-01-30 11:58:48','2018-01-30 11:58:48'),(16,'Mityana','2018-01-30 11:58:48','2018-01-30 11:58:48'),(17,'Mpigi','2018-01-30 11:58:48','2018-01-30 11:58:48'),(18,'Mubende','2018-01-30 11:58:48','2018-01-30 11:58:48'),(19,'Mukono','2018-01-30 11:58:48','2018-01-30 11:58:48'),(20,'Nakaseke','2018-01-30 11:58:48','2018-01-30 11:58:48'),(21,'Nakasongola','2018-01-30 11:58:48','2018-01-30 11:58:48'),(22,'Rakai','2018-01-30 11:58:48','2018-01-30 11:58:48'),(23,'Ssembabule','2018-01-30 11:58:48','2018-01-30 11:58:48'),(24,'Wakiso','2018-01-30 11:58:48','2018-01-30 11:58:48'),(25,'Amuria','2018-01-30 11:58:48','2018-01-30 11:58:48'),(26,'Budaka','2018-01-30 11:58:48','2018-01-30 11:58:48'),(27,'Bududa','2018-01-30 11:58:48','2018-01-30 11:58:48'),(28,'Bugiri','2018-01-30 11:58:48','2018-01-30 11:58:48'),(29,'Bukedea','2018-01-30 11:58:48','2018-01-30 11:58:48'),(30,'Bukwa','2018-01-30 11:58:48','2018-01-30 11:58:48'),(31,'Bulambuli','2018-01-30 11:58:49','2018-01-30 11:58:49'),(32,'Busia','2018-01-30 11:58:49','2018-01-30 11:58:49'),(33,'Butaleja','2018-01-30 11:58:49','2018-01-30 11:58:49'),(34,'Buyende','2018-01-30 11:58:49','2018-01-30 11:58:49'),(35,'Iganga','2018-01-30 11:58:49','2018-01-30 11:58:49'),(36,'Jinja','2018-01-30 11:58:49','2018-01-30 11:58:49'),(37,'Kaberamaido','2018-01-30 11:58:49','2018-01-30 11:58:49'),(38,'Kaliro','2018-01-30 11:58:49','2018-01-30 11:58:49'),(39,'Kamuli','2018-01-30 11:58:49','2018-01-30 11:58:49'),(40,'Kapchorwa','2018-01-30 11:58:49','2018-01-30 11:58:49'),(41,'Katakwi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(42,'Kibuku','2018-01-30 11:58:49','2018-01-30 11:58:49'),(43,'Kumi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(44,'Kween','2018-01-30 11:58:49','2018-01-30 11:58:49'),(45,'Luuka','2018-01-30 11:58:49','2018-01-30 11:58:49'),(46,'Manafwa','2018-01-30 11:58:49','2018-01-30 11:58:49'),(47,'Mayuge','2018-01-30 11:58:49','2018-01-30 11:58:49'),(48,'Mbale','2018-01-30 11:58:49','2018-01-30 11:58:49'),(49,'Namayingo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(50,'Namutumba','2018-01-30 11:58:49','2018-01-30 11:58:49'),(51,'Ngora','2018-01-30 11:58:49','2018-01-30 11:58:49'),(52,'Pallisa','2018-01-30 11:58:49','2018-01-30 11:58:49'),(53,'Serere','2018-01-30 11:58:49','2018-01-30 11:58:49'),(54,'Sironko','2018-01-30 11:58:49','2018-01-30 11:58:49'),(55,'Soroti','2018-01-30 11:58:49','2018-01-30 11:58:49'),(56,'Tororo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(57,'Abim','2018-01-30 11:58:49','2018-01-30 11:58:49'),(58,'Adjumani','2018-01-30 11:58:49','2018-01-30 11:58:49'),(59,'Agago','2018-01-30 11:58:49','2018-01-30 11:58:49'),(60,'Alebtong','2018-01-30 11:58:49','2018-01-30 11:58:49'),(61,'Amolatar','2018-01-30 11:58:49','2018-01-30 11:58:49'),(62,'Amudat','2018-01-30 11:58:49','2018-01-30 11:58:49'),(63,'Amuru','2018-01-30 11:58:49','2018-01-30 11:58:49'),(64,'Apac','2018-01-30 11:58:49','2018-01-30 11:58:49'),(65,'Arua','2018-01-30 11:58:49','2018-01-30 11:58:49'),(66,'Dokolo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(67,'Gulu','2018-01-30 11:58:49','2018-01-30 11:58:49'),(68,'Kaabong','2018-01-30 11:58:49','2018-01-30 11:58:49'),(69,'Kitgum','2018-01-30 11:58:49','2018-01-30 11:58:49'),(70,'Koboko','2018-01-30 11:58:49','2018-01-30 11:58:49'),(71,'Kole','2018-01-30 11:58:49','2018-01-30 11:58:49'),(72,'Kotido','2018-01-30 11:58:49','2018-01-30 11:58:49'),(73,'Lamwo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(74,'Lira','2018-01-30 11:58:49','2018-01-30 11:58:49'),(75,'Maracha','2018-01-30 11:58:49','2018-01-30 11:58:49'),(76,'Moroto','2018-01-30 11:58:49','2018-01-30 11:58:49'),(77,'Moyo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(78,'Nakapiripirit','2018-01-30 11:58:49','2018-01-30 11:58:49'),(79,'Napak','2018-01-30 11:58:49','2018-01-30 11:58:49'),(80,'Nebbi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(81,'Nwoya','2018-01-30 11:58:49','2018-01-30 11:58:49'),(82,'Otuke','2018-01-30 11:58:49','2018-01-30 11:58:49'),(83,'Oyam','2018-01-30 11:58:49','2018-01-30 11:58:49'),(84,'Pader','2018-01-30 11:58:49','2018-01-30 11:58:49'),(85,'Yumbe','2018-01-30 11:58:49','2018-01-30 11:58:49'),(86,'Zombo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(87,'Buhweju','2018-01-30 11:58:49','2018-01-30 11:58:49'),(88,'Buliisa','2018-01-30 11:58:49','2018-01-30 11:58:49'),(89,'Bundibugyo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(90,'Bushenyi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(91,'Hoima','2018-01-30 11:58:49','2018-01-30 11:58:49'),(92,'Ibanda','2018-01-30 11:58:49','2018-01-30 11:58:49'),(93,'Isingiro','2018-01-30 11:58:49','2018-01-30 11:58:49'),(94,'Kabale','2018-01-30 11:58:49','2018-01-30 11:58:49'),(95,'Kabarole','2018-01-30 11:58:49','2018-01-30 11:58:49'),(96,'Kamwenge','2018-01-30 11:58:49','2018-01-30 11:58:49'),(97,'Kanungu','2018-01-30 11:58:49','2018-01-30 11:58:49'),(98,'Kasese','2018-01-30 11:58:49','2018-01-30 11:58:49'),(99,'Kibaale','2018-01-30 11:58:49','2018-01-30 11:58:49'),(100,'Kiruhura','2018-01-30 11:58:49','2018-01-30 11:58:49'),(101,'Kiryandongo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(102,'Kisoro','2018-01-30 11:58:49','2018-01-30 11:58:49'),(103,'Kyegegwa','2018-01-30 11:58:49','2018-01-30 11:58:49'),(104,'Kyenjojo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(105,'Masindi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(106,'Mbarara','2018-01-30 11:58:49','2018-01-30 11:58:49'),(107,'Mitooma','2018-01-30 11:58:49','2018-01-30 11:58:49'),(108,'Ntoroko','2018-01-30 11:58:49','2018-01-30 11:58:49'),(109,'Ntungamo','2018-01-30 11:58:49','2018-01-30 11:58:49'),(110,'Rubirizi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(111,'Rukungiri','2018-01-30 11:58:49','2018-01-30 11:58:49'),(112,'Sheema','2018-01-30 11:58:49','2018-01-30 11:58:49'),(113,'Omoro','2018-01-30 11:58:49','2018-01-30 11:58:49'),(114,'Kagadi','2018-01-30 11:58:49','2018-01-30 11:58:49'),(115,'Kakumiro','2018-01-30 11:58:49','2018-01-30 11:58:49'),(116,'Rubanda','2018-01-30 11:58:49','2018-01-30 11:58:49'),(117,'Bukwo','2018-01-30 11:58:49','2018-01-30 11:58:49');

--
-- Table structure for table `unhls_equipment_breakdown`
--

CREATE TABLE `unhls_equipment_breakdown` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` int(10) unsigned NOT NULL,
  `facility_id` int(10) unsigned NOT NULL,
  `year_id` int(10) unsigned NOT NULL,
  `equipment_id` int(10) unsigned NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `action_taken` text COLLATE utf8_unicode_ci NOT NULL,
  `hsd_request` text COLLATE utf8_unicode_ci NOT NULL,
  `in_charge_id` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `report_date` datetime DEFAULT NULL,
  `restored_by` int(11) DEFAULT NULL,
  `restore_date` datetime DEFAULT NULL,
  `comment` longtext COLLATE utf8_unicode_ci,
  `breakdown_type` int(11) NOT NULL,
  `reported_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `breakdown_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unhls_equipment_breakdown_district_id_foreign` (`district_id`),
  KEY `unhls_equipment_breakdown_facility_id_foreign` (`facility_id`),
  KEY `unhls_equipment_breakdown_year_id_foreign` (`year_id`),
  KEY `unhls_equipment_breakdown_equipment_id_foreign` (`equipment_id`),
  CONSTRAINT `unhls_equipment_breakdown_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `unhls_districts` (`id`),
  CONSTRAINT `unhls_equipment_breakdown_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `unhls_equipment_inventory` (`id`),
  CONSTRAINT `unhls_equipment_breakdown_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `unhls_facilities` (`id`),
  CONSTRAINT `unhls_equipment_breakdown_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `unhls_financial_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_equipment_breakdown`
--


--
-- Table structure for table `unhls_equipment_inventory`
--

CREATE TABLE `unhls_equipment_inventory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` int(10) unsigned NOT NULL,
  `facility_id` int(10) unsigned NOT NULL,
  `year_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `serial_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` int(11) NOT NULL,
  `procurement_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `purchase_date` datetime NOT NULL,
  `delivery_date` datetime NOT NULL,
  `verification_date` datetime NOT NULL,
  `installation_date` datetime NOT NULL,
  `spare_parts` tinyint(1) NOT NULL,
  `warranty` int(11) NOT NULL,
  `life_span` int(11) NOT NULL,
  `service_frequency` tinyint(1) NOT NULL,
  `service_contract` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `supplier_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `unhls_equipment_inventory_district_id_foreign` (`district_id`),
  KEY `unhls_equipment_inventory_facility_id_foreign` (`facility_id`),
  KEY `unhls_equipment_inventory_year_id_foreign` (`year_id`),
  KEY `unhls_equipment_inventory_supplier_id_foreign` (`supplier_id`),
  CONSTRAINT `unhls_equipment_inventory_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `unhls_districts` (`id`),
  CONSTRAINT `unhls_equipment_inventory_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `unhls_facilities` (`id`),
  CONSTRAINT `unhls_equipment_inventory_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `unhls_equipment_suppliers` (`id`),
  CONSTRAINT `unhls_equipment_inventory_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `unhls_financial_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_equipment_inventory`
--


--
-- Table structure for table `unhls_equipment_maintenance`
--

CREATE TABLE `unhls_equipment_maintenance` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` int(10) unsigned NOT NULL,
  `facility_id` int(10) unsigned NOT NULL,
  `year_id` int(10) unsigned NOT NULL,
  `equipment_id` int(10) unsigned NOT NULL,
  `last_service_date` datetime NOT NULL,
  `next_service_date` datetime NOT NULL,
  `serviced_by_name` text COLLATE utf8_unicode_ci NOT NULL,
  `serviced_by_contact` text COLLATE utf8_unicode_ci NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `unhls_equipment_maintenance_district_id_foreign` (`district_id`),
  KEY `unhls_equipment_maintenance_facility_id_foreign` (`facility_id`),
  KEY `unhls_equipment_maintenance_year_id_foreign` (`year_id`),
  KEY `unhls_equipment_maintenance_equipment_id_foreign` (`equipment_id`),
  CONSTRAINT `unhls_equipment_maintenance_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `unhls_districts` (`id`),
  CONSTRAINT `unhls_equipment_maintenance_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `unhls_equipment_inventory` (`id`),
  CONSTRAINT `unhls_equipment_maintenance_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `unhls_facilities` (`id`),
  CONSTRAINT `unhls_equipment_maintenance_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `unhls_financial_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_equipment_maintenance`
--


--
-- Table structure for table `unhls_equipment_suppliers`
--

CREATE TABLE `unhls_equipment_suppliers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_equipment_suppliers`
--


--
-- Table structure for table `unhls_facilities`
--

CREATE TABLE `unhls_facilities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `district_id` int(10) unsigned NOT NULL,
  `level_id` int(10) unsigned NOT NULL,
  `ownership_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `unhls_facilities_level_id_foreign` (`level_id`),
  KEY `unhls_facilities_district_id_foreign` (`district_id`),
  KEY `unhls_facilities_ownership_id_foreign` (`ownership_id`),
  CONSTRAINT `unhls_facilities_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `unhls_districts` (`id`),
  CONSTRAINT `unhls_facilities_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `unhls_facility_level` (`id`),
  CONSTRAINT `unhls_facilities_ownership_id_foreign` FOREIGN KEY (`ownership_id`) REFERENCES `unhls_facility_ownership` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_facilities`
--

INSERT INTO `unhls_facilities` VALUES (1,'LBK1','UNHLS/CPHL Main Stores',1,1,1,'2018-01-30 11:58:49','2018-01-30 11:58:49'),(2,'-','Abim HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(3,'-','Adjumani   HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(4,'-','Alebtong HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(5,'-','Amolatar HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(6,'-','Amuria HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(7,'-','Anaka HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(8,'-','Apac HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(9,'-','Arua REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(10,'-','Atiak HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(11,'-','Atutur HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(12,'-','Budadiri HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(13,'-','Bugiri HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(14,'-','Buliisa Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(15,'-','Bumanya HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(16,'-','Bundibugyo Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(17,'-','Bushenyi HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(18,'-','Busolwe HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(19,'-','Buvuma HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(20,'-','Buyinja  HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(21,'-','Dokolo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(22,'-','Entebbe HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(23,'-','Fort Portal Regional Referral Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(24,'-','Gombe HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(25,'-','Gulu Regional Referal Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(26,'-','Hoima REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(27,'-','Iganga HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(28,'-','Itojo HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(29,'-','Jinja Regional Ref HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(30,'-','Kaabong HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(31,'-','Kabale REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(32,'-','Kaberamaido HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(33,'-','Kagadi HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(34,'-','Kagando HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(35,'-','Kakindo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(36,'-','Kalangala HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(37,'-','Kalongo Ambrosoli Memorial HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(38,'-','Kamuli HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(39,'-','Kanungu HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(40,'-','Kapchorwa HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(41,'-','Kassanda HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(42,'-','Katakwi General Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(43,'-','Kawolo HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(44,'-','Kayunga Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(45,'-','Kazo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(46,'-','Kiboga HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(47,'-','Kidera HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(48,'-','Kigandalo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(49,'-','Kilembe HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(50,'-','Kiryandongo HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(51,'-','Kisoro HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(52,'-','Kitagata HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(53,'-','Kitgum HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(54,'-','Koboko Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(55,'-','Kotido HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(56,'-','Kyegegwa HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(57,'-','Kyenjojo Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(58,'-','Lalogi HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(59,'-','Lira REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(60,'-','Luwero HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(61,'-','Lwengo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(62,'-','Lyantonde HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(63,'-','Maddu HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(64,'-','Madi-Opei HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(65,'-','Masafu General Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(66,'-','Masaka REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(67,'-','Masindi HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(68,'-','Matany HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(69,'-','Mbale REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(70,'-','Mbarara REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(71,'-','Mityana HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(72,'-','Moroto Regional Refferal HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(73,'-','Moyo HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(74,'-','Mpigi   HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(75,'-','Mubende RR HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(76,'-','Mukono  T.C. HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(77,'-','Nakasongola HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(78,'-','Namokora HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(79,'-','Nebbi Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(80,'-','Ngoma HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(81,'-','Ngora Gvt HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(82,'-','Ntwetwe HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(83,'-','Pajule HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(84,'-','Pallisa HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(85,'-','Rakai HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(86,'-','Rhino Camp HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(87,'-','Ruhoko HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(88,'-','Rukunyu HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(89,'-','Rukunyu HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(90,'-','Rushere Community HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(91,'-','Rwekubo HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(92,'-','Serere HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(93,'-','Soroti REGIONAL REF HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(94,'-','Ssembabule HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(95,'-','St. Karolii Lwanga Nyakibale HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(96,'-','Tokora HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(97,'-','Tororo General HOSPITAL',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(98,'-','Wakiso HC IV',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(99,'-','Warr  HC III',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21'),(100,'-','Yumbe Hospital',1,1,1,'2018-04-17 06:05:21','2018-04-17 06:05:21');

--
-- Table structure for table `unhls_facility_level`
--

CREATE TABLE `unhls_facility_level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `level` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_facility_level`
--

INSERT INTO `unhls_facility_level` VALUES (1,'Public NRH','2018-01-30 11:58:49','2018-01-30 11:58:49'),(2,'Public RRH','2018-01-30 11:58:49','2018-01-30 11:58:49'),(3,'Public GH','2018-01-30 11:58:49','2018-01-30 11:58:49'),(4,'Public HCIV','2018-01-30 11:58:49','2018-01-30 11:58:49'),(5,'Public HCIII','2018-01-30 11:58:49','2018-01-30 11:58:49'),(6,'Hospital','2018-01-30 11:58:49','2018-01-30 11:58:49');

--
-- Table structure for table `unhls_facility_ownership`
--

CREATE TABLE `unhls_facility_ownership` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `owner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_facility_ownership`
--

INSERT INTO `unhls_facility_ownership` VALUES (1,'Public','2018-01-30 11:58:49','2018-01-30 11:58:49'),(2,'PFP','2018-01-30 11:58:49','2018-01-30 11:58:49'),(3,'PNFP','2018-01-30 11:58:49','2018-01-30 11:58:49'),(4,'Other','2018-01-30 11:58:49','2018-01-30 11:58:49');

--
-- Table structure for table `unhls_financial_years`
--

CREATE TABLE `unhls_financial_years` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_financial_years`
--


--
-- Table structure for table `unhls_staff`
--

CREATE TABLE `unhls_staff` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `facility_id` int(10) unsigned NOT NULL,
  `firstName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lastName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `unhls_staff_facility_id_foreign` (`facility_id`),
  CONSTRAINT `unhls_staff_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `unhls_facilities` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_staff`
--


--
-- Table structure for table `unhls_stockcard`
--

CREATE TABLE `unhls_stockcard` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `commodity_id` int(10) unsigned NOT NULL,
  `to_from` int(11) NOT NULL,
  `to_from_type` int(11) NOT NULL,
  `barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `voucher_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity` int(11) NOT NULL,
  `action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiry_date` datetime NOT NULL,
  `received_date` datetime NOT NULL,
  `initials` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remarks` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `balance` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `transaction_date` datetime DEFAULT NULL,
  `quantity_in` int(11) DEFAULT NULL,
  `quantity_out` int(11) DEFAULT NULL,
  `department` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opening_balance` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `unhls_stockcard_commodity_id_foreign` (`commodity_id`),
  CONSTRAINT `unhls_stockcard_commodity_id_foreign` FOREIGN KEY (`commodity_id`) REFERENCES `commodities` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_stockcard`
--

INSERT INTO `unhls_stockcard` VALUES (1,2,2,2,'lkdlad','asda',0,'I','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','kim','',1000,'2018-07-24 11:31:47','2018-07-24 11:31:47','2018-07-24 00:00:00',0,NULL,NULL,1000),(2,2,2,5,'asdad','aasd',0,'O','asda','2018-07-24 00:00:00','0000-00-00 00:00:00','ji','',995,'2018-07-24 11:32:27','2018-07-24 11:32:27','2018-07-24 00:00:00',NULL,5,NULL,0),(3,2,2,2,'asdasd','asd',0,'I','asda','2018-07-24 00:00:00','0000-00-00 00:00:00','kpo','',1015,'2018-07-24 11:32:57','2018-07-24 11:32:57','2018-07-24 00:00:00',20,NULL,NULL,0),(4,2,2,5,'lasdads','asd',0,'O','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','kpa','',1010,'2018-07-24 12:13:23','2018-07-24 12:13:23','2018-07-24 00:00:00',NULL,5,NULL,0),(5,3,1,2,'lasd','asd',0,'I','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','pppa','',1500,'2018-07-24 12:15:15','2018-07-24 12:15:15','2018-07-24 00:00:00',0,NULL,NULL,1500),(6,3,2,5,'kkakda','dad',0,'O','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','mop','',900,'2018-07-24 12:15:35','2018-07-24 12:15:35','2018-07-24 00:00:00',NULL,600,NULL,0),(7,10,2,2,'ppoasd','ada',0,'I','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','kjas','',0,'2018-07-24 12:34:42','2018-07-24 12:34:42','2018-07-24 00:00:00',0,NULL,NULL,0),(8,10,2,2,'ad','asd',0,'I','asd','2018-07-24 00:00:00','0000-00-00 00:00:00','kpa','',100,'2018-07-24 12:35:12','2018-07-24 12:35:12','2018-07-24 00:00:00',0,NULL,NULL,100),(9,10,2,5,'asda','adad',0,'O','asda','2018-07-24 00:00:00','0000-00-00 00:00:00','llla','',62,'2018-07-24 12:41:54','2018-07-24 12:41:54','2018-07-24 00:00:00',NULL,38,NULL,0),(10,10,2,5,'00ase','sdasd',0,'O','asd','2018-07-25 00:00:00','0000-00-00 00:00:00','me','',10,'2018-07-24 21:18:57','2018-07-24 21:18:57','2018-07-25 00:00:00',NULL,52,NULL,0),(11,2,2,5,'asdasda','asdas',0,'O','asda','2018-07-25 00:00:00','0000-00-00 00:00:00','peter','',910,'2018-07-24 21:52:05','2018-07-24 21:52:05','2018-07-25 00:00:00',NULL,100,NULL,0),(12,8,2,2,'lpla','lpp',0,'I','lpl','2018-07-25 00:00:00','0000-00-00 00:00:00','peter','',570,'2018-07-25 08:10:08','2018-07-25 08:10:08','2018-07-25 00:00:00',0,NULL,NULL,570),(13,8,2,5,'lsad','asd',0,'O','asd','2018-07-25 00:00:00','0000-00-00 00:00:00','posd','',270,'2018-07-25 08:43:53','2018-07-25 08:43:53','2018-07-25 00:00:00',NULL,300,NULL,0),(14,2,2,5,'kda','fsd',0,'O','sdas','2018-07-25 00:00:00','0000-00-00 00:00:00','laskdas','',820,'2018-07-25 08:48:48','2018-07-25 08:48:48','2018-07-25 00:00:00',NULL,90,NULL,0);

--
-- Table structure for table `unhls_stockrequisition`
--

CREATE TABLE `unhls_stockrequisition` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `district_id` int(10) unsigned NOT NULL,
  `facility_id` int(10) unsigned NOT NULL,
  `year_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `issued_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `voucher_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity_required` int(11) NOT NULL,
  `quantity_issued` int(11) NOT NULL,
  `issue_date` datetime NOT NULL,
  `remarks` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `unhls_stockrequisition_district_id_foreign` (`district_id`),
  KEY `unhls_stockrequisition_facility_id_foreign` (`facility_id`),
  KEY `unhls_stockrequisition_year_id_foreign` (`year_id`),
  KEY `unhls_stockrequisition_item_id_foreign` (`item_id`),
  CONSTRAINT `unhls_stockrequisition_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `unhls_districts` (`id`),
  CONSTRAINT `unhls_stockrequisition_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `unhls_facilities` (`id`),
  CONSTRAINT `unhls_stockrequisition_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `commodities` (`id`),
  CONSTRAINT `unhls_stockrequisition_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `unhls_financial_years` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_stockrequisition`
--


--
-- Table structure for table `unhls_warehouse`
--

CREATE TABLE `unhls_warehouse` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `unhls_warehouse`
--


--
-- Table structure for table `victor`
--

CREATE TABLE `victor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amplification_barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amplification_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `control_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_lot_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `calibrator_expiry` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_of_samples` int(11) NOT NULL,
  `failed_runs` int(11) NOT NULL,
  `passed_runs` int(11) NOT NULL,
  `dummy_runs` int(11) NOT NULL,
  `control_runs` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `victor`
--



