--
-- Host: localhost    Database: unhlsimsproduction
-- ------------------------------------------------------


--
-- 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=9 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,3,4),(4,4,4),(5,1,1),(6,2,5),(7,3,4),(8,4,4);

--
-- 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,
  `store_section` varchar(100) COLLATE utf8_unicode_ci 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',
  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=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `commodities` VALUES (1,'K-tips',0,'','3','',432,' Molecular, COBAS AMPLIPREP K-tips, 12 racks x 36 ',1,12,100,300,NULL,'2017-12-18 14:40:27','2017-12-20 07:23:15'),(2,'WASH RGT ',0,'','3','',5,' Molecular, KIT CAP-G/CTM WASH RGT 5.1L IVD, 5.1L (100 tests) ',5,12,234,702,NULL,'2017-12-18 14:40:59','2017-12-20 07:23:43'),(3,'HIV-1 QUAL',0,'','3','',48,' Molecular, KIT CAP-G/CTM HIV-1 QUAL 48T RUO, 48 tests ',2,12,426,1278,NULL,'2017-12-18 14:41:34','2017-12-20 07:42:43'),(4,'COBAS AMPLIPREP Flapless SPU',0,'','3','',288,' Molecular, COBAS AMPLIPREP Flapless SPU, 12 racks x 24 ',1,12,106,318,NULL,'2017-12-18 14:42:06','2017-12-20 07:24:07'),(5,'Cobas Ampliprep S tubes (input)',0,'','3','',288,' Molecular, Cobas Ampliprep S tubes (input), 12 racks x 24 ',1,12,134,402,NULL,'2017-12-18 14:42:41','2017-12-20 07:24:33'),(6,'KIT CAP-G/CTM SPECIMEN PRE-EXTRACT RUO',0,'','3','',350,' Molecular, KIT CAP-G/CTM SPECIMEN PRE-EXTRACT RUO, 5 x 75ml (350) tests) ',3,12,72,216,NULL,'2017-12-18 14:43:23','2017-12-20 07:25:05'),(7,'Cobas TaqMan K Tubes',0,'','3','',1152,' Molecular, Cobas TaqMan K Tubes, 12 x 96 ',1,12,44,132,NULL,'2017-12-18 14:43:56','2017-12-20 07:25:32'),(8,'EID Lab Consumable Bundle ',0,'','3','',960,' Molecular, CAP-CTM Lab Consumable Bundle ',4,12,6,18,NULL,'2017-12-18 14:44:24','2017-12-20 07:50:35'),(9,'DBS Sample collection Bandles (50) tests single use whatman 903 paper',0,'','3','',50,' Molecular, DBS Sample collection Bandles (50) tests single use whatman 903 paper ',2,12,0,0,NULL,'2017-12-18 14:44:57','2017-12-18 14:44:57'),(10,'COBAS AMPLIPREP K-tips, 12 racks x 36',0,'','1','',432,'Molecular, COBAS AMPLIPREP K-tips, 12 racks x 36',1,13,0,0,NULL,'2017-12-18 14:45:36','2017-12-18 14:45:36'),(11,'KIT CAP-G/CTM WASH RGT 5.1L IVD 5.1L (100 tests)',0,'','1','',5,'Molecular, KIT CAP-G/CTM WASH RGT 5.1L IVD 5.1L (100 tests)',5,13,0,0,NULL,'2017-12-18 14:46:06','2017-12-18 14:46:06'),(12,'KIT CAP-G/CTM HIV-1 V2.0 EXPT-IVD 48 tests',0,'','1','',48,'Molecular, KIT CAP-G/CTM HIV-1 V2.0 EXPT-IVD 48 tests',2,13,0,0,NULL,'2017-12-18 14:46:32','2017-12-18 14:46:32'),(13,' COBAS AMPLIPREP Flapless SPU 12 racks x 24',0,'','1','',288,'Molecular, COBAS AMPLIPREP Flapless SPU 12 racks x 24',1,13,0,0,NULL,'2017-12-18 14:46:59','2017-12-18 14:46:59'),(14,' Cobas Ampliprep S tubes (input) 12 racks x 24',0,'','1','',288,'Molecular, Cobas Ampliprep S tubes (input) 12 racks x 24',1,13,0,0,NULL,'2017-12-18 14:47:46','2017-12-18 14:47:46'),(15,' Cobas TaqMan K Tubes 12 x 96',0,'','1','',1152,'Molecular, Cobas TaqMan K Tubes 12 x 96',1,13,0,0,NULL,'2017-12-18 14:48:09','2017-12-18 14:48:09'),(16,'abs',0,'','1','',3,'asas',5,14,11,121,NULL,'2017-12-18 14:40:27','2017-12-18 14:40:27'),(17,'Cobas omni Specimen Diluent',0,'','3','',4,'Molecular, Cobas omni Specimen Diluent',5,14,46,138,NULL,'2017-12-18 14:49:43','2017-12-20 06:57:46'),(18,'Cobas omni Lysis Reagent',0,'','3','',4,'Molecular, Cobas omni Lysis Reagent',5,14,40,60,NULL,'2017-12-18 14:50:17','2017-12-20 07:05:22'),(19,'Cobas omni Wash Reagent',0,'','3','',1,'Molecular, Cobas omni Wash Reagent',5,14,118,354,NULL,'2017-12-18 14:50:39','2017-12-20 07:05:53'),(20,'Cobas omni Pipette Tips',0,'','1','',16,'Molecular, Cobas omni Pipette Tips',2,14,64,192,NULL,'2017-12-18 14:55:00','2017-12-20 07:06:14'),(21,'Cobas omni Processing Plate',0,'','1','',32,'Molecular, Cobas omni Processing Plate',1,14,34,102,NULL,'2017-12-18 14:55:38','2017-12-20 07:06:46'),(22,'Cobas® NHP Negative Control Kit',0,'','1','',16,'Molecular, Cobas® NHP Negative Control Kit',2,14,54,162,NULL,'2017-12-18 14:56:05','2017-12-20 07:09:03'),(23,'Cobas omni MGP Reagent',0,'','1','',1,'Molecular, Cobas omni MGP Reagent',2,14,170,510,NULL,'2017-12-18 14:56:26','2017-12-20 06:29:47'),(24,'Cobas omni Amplification Plate',0,'','1','',3072,'Molecular, Cobas omni Amplification Plate',2,14,32,96,NULL,'2017-12-18 14:57:00','2017-12-20 06:35:41'),(25,'KIT COBAS 6800/8800 HIV 96T CE-IVD',0,'','1','',96,'Molecular, KIT COBAS 6800/8800 HIV 96T CE-IVD',2,14,486,1458,NULL,'2017-12-18 14:57:27','2017-12-20 07:35:46'),(26,'KIT COBAS 6800/8800 HxV RMC CE-IVD',0,'','1','',8,'Molecular, KIT COBAS 6800/8800 HxV RMC CE-IVD',6,14,0,0,NULL,'2017-12-18 14:57:48','2017-12-18 14:57:48'),(27,'Solid Waste Bag Set of 200',0,'','1','',200,'Molecular, Solid Waste Bag Set of 200',1,14,24,72,NULL,'2017-12-18 14:58:14','2017-12-20 06:28:50'),(28,'Cobas omni secondary SS Tubes (17x75)',0,'','1','',200,'Molecular, Cobas omni secondary SS Tubes (17x75)',1,14,22,66,NULL,'2017-12-18 14:58:45','2017-12-19 12:46:52'),(29,'PBS Buffer ',0,'','1','',500,'Molecular, PBS Buffer ',1,14,0,0,NULL,'2017-12-18 14:59:11','2017-12-18 14:59:11'),(30,'Abbott RealTime HIV-1 Amplification Reagent Kit',0,'','1','',96,'Molecular, Abbott RealTime HIV-1 Amplification Reagent Kit, 1 pack with 4 boxes x 24 tests',2,15,1110,3330,NULL,'2017-12-18 15:03:23','2017-12-20 06:36:53'),(31,'bbott RealTime HIV-1 Control Kit',0,'','1','',768,'Molecular, Abbott RealTime HIV-1 Control Kit ,1 pack with 8 Neg, 8 Pos, and 8 low-controls',2,15,126,378,NULL,'2017-12-18 15:03:53','2017-12-20 06:37:30'),(32,'Abbott RealTime HIV-1 Calibrator Kit',0,'','1','',1,'Molecular, Abbott RealTime HIV-1 Calibrator Kit',2,15,0,0,NULL,'2017-12-18 15:04:17','2017-12-18 15:04:17'),(33,'Abbott mSample Preparation System DNA',0,'','1','',96,'Molecular, Abbott mSample Preparation System DNA, 1 box of 4 x 24 preps',2,15,514,1542,NULL,'2017-12-18 15:04:47','2017-12-20 06:39:13'),(34,'Bulk mLysis DNA Buffer (for DBS processing only)',0,'','1','',210,'Molecular, Bulk mLysis DNA Buffer (for DBS processing only), 210 mL bottle',3,15,800,2400,NULL,'2017-12-18 15:05:16','2017-12-20 06:41:13'),(35,'200 mL Reagent Vessels ',0,'','1','',90,'Molecular, 200 mL Reagent Vessels ',1,15,56,168,NULL,'2017-12-18 15:05:42','2017-12-20 06:55:12'),(36,'Abbott Optical Adhesive Covers  ',0,'','1','',100,'Molecular, Abbott Optical Adhesive Covers  ',1,15,14,49,NULL,'2017-12-18 15:06:07','2017-12-20 07:11:52'),(37,'Abbott 96-Deep-Well Plate',0,'','1','',32,'Molecular, Abbott 96-Deep-Well Plate',1,15,100,300,NULL,'2017-12-18 15:06:27','2017-12-20 07:12:16'),(38,'Abbott 96-Well Optical Reaction Plate',0,'','1','',20,'Molecular, Abbott 96-Well Optical Reaction Plate ',1,15,50,150,NULL,'2017-12-18 15:06:52','2017-12-20 07:12:56'),(39,'Saarstedt  Master Mix Tube ',0,'','1','',150,'Molecular, Saarstedt  Master Mix Tube ',1,15,388,1164,NULL,'2017-12-18 15:07:15','2017-12-20 07:15:16'),(40,' Saarstedt 5 mL Reaction Vessels ',0,'','1','',2000,'Molecular, Saarstedt 5 mL Reaction Vessels ',3,15,52,156,NULL,'2017-12-18 15:07:38','2017-12-20 07:18:50'),(41,'1000 µL Tecan Disposable Tips',0,'','1','',2304,'Molecular, 1000 µL Tecan Disposable Tips, Pack with 12 boxes, 96 tips per box',1,15,380,1140,NULL,'2017-12-18 15:08:10','2017-12-20 07:16:00'),(42,'200 µL Tecan Disposable Tips',0,'','1','',2304,'Molecular, 200 µL Tecan Disposable Tips, Pack with 12 boxes, 96 tips per box',1,15,48,144,NULL,'2017-12-18 15:08:37','2017-12-20 06:56:43'),(43,' m2000 RealTime PCR, Biohazard bag, 32 x 34in, Orange, 27 Gallon, 50 Pcs',0,'','1','',50,'Molecular, Molecular, m2000 RealTime PCR, Biohazard bag, 32 x 34in, Orange, 27 Gallon, 50 Pcs',1,15,0,0,NULL,'2017-12-18 15:09:21','2017-12-18 15:09:21'),(44,'DBS collect kit VL W-stickers',0,'','1','',50,'Molecular, DBS collect kit VL W-stickers, 50 tests Single use ',2,15,0,0,NULL,'2017-12-18 15:09:50','2017-12-18 15:09:50'),(45,'Laboratory Consumables Bundle for Automated Assay (Abbot)',0,'','1','',960,'Molecular, Laboratory Consumables Bundle for Automated Assay (Abbot)',4,15,60,180,NULL,'2017-12-18 15:10:22','2017-12-20 07:17:29'),(46,'Absolute ethanol, 2 Litre bottle',0,'','1','',2,'Molecular, Absolute ethanol, 2 Litre bottle',5,15,100,300,NULL,'2017-12-18 15:10:45','2017-12-20 07:27:05'),(47,'VIRAL LOAD DBS KIT',0,'','1','',25,'VIRAL LOAD DBS KITS',4,0,0,0,NULL,'2017-12-20 08:44:19','2017-12-20 08:44:19');

--
-- 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=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `commodity_categories` VALUES (1,'SPECIMEN COLLECTION MATERIALS',NULL,'2017-12-18 14:30:48','2017-12-18 14:30:48'),(2,'REGISTERS',NULL,'2017-12-18 14:30:54','2017-12-18 14:30:54'),(3,'STATIONERY',NULL,'2017-12-18 14:31:01','2017-12-18 14:31:01'),(4,'ROCHE/EID CONSUMABLES',NULL,'2017-12-18 14:31:07','2017-12-18 14:31:07'),(5,'ROCHE REAGENTS',NULL,'2017-12-18 14:31:15','2017-12-18 14:31:15'),(6,'EID REAGENTS',NULL,'2017-12-18 14:31:22','2017-12-18 14:31:22'),(7,'ABBOT REAGENTS',NULL,'2017-12-18 14:31:29','2017-12-18 14:31:29'),(8,'GENERAL LABORATORY COMMODITIES',NULL,'2017-12-18 14:31:34','2017-12-18 14:31:34'),(9,'STATIONERY PRINTED',NULL,'2017-12-18 14:31:39','2017-12-18 14:31:39'),(10,'TONNERS',NULL,'2017-12-18 14:31:44','2017-12-18 14:31:44'),(11,'MACHINE CONSUMABLES',NULL,'2017-12-18 14:31:50','2017-12-18 14:31:50'),(12,'Cobas TaqMan CAP/CTM-EID',NULL,'2017-12-18 14:38:35','2017-12-18 14:38:35'),(13,'Cobas TaqMan CAP/CTM-VL',NULL,'2017-12-18 14:38:44','2017-12-18 14:38:44'),(14,'ROCHE 8800',NULL,'2017-12-18 14:38:55','2017-12-18 14:38:55'),(15,'Abbott Equipment',NULL,'2017-12-18 14:39:06','2017-12-18 14:39:06');

--
-- 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 AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `countries` VALUES (1,'Afghanistan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(2,'Aland Islands (Finland)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(3,'Albania','2017-12-19 19:44:56','2017-12-19 19:44:56'),(4,'Algeria','2017-12-19 19:44:56','2017-12-19 19:44:56'),(5,'American Samoa (USA)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(6,'Andorra','2017-12-19 19:44:56','2017-12-19 19:44:56'),(7,'Angola','2017-12-19 19:44:56','2017-12-19 19:44:56'),(8,'Anguilla (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(9,'Antigua and Barbuda','2017-12-19 19:44:56','2017-12-19 19:44:56'),(10,'Argentina','2017-12-19 19:44:56','2017-12-19 19:44:56'),(11,'Armenia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(12,'Aruba (Netherlands)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(13,'Australia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(14,'Austria','2017-12-19 19:44:56','2017-12-19 19:44:56'),(15,'Azerbaijan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(16,'Bahamas','2017-12-19 19:44:56','2017-12-19 19:44:56'),(17,'Bahrain','2017-12-19 19:44:56','2017-12-19 19:44:56'),(18,'Bangladesh','2017-12-19 19:44:56','2017-12-19 19:44:56'),(19,'Barbados','2017-12-19 19:44:56','2017-12-19 19:44:56'),(20,'Belarus','2017-12-19 19:44:56','2017-12-19 19:44:56'),(21,'Belgium','2017-12-19 19:44:56','2017-12-19 19:44:56'),(22,'Belize','2017-12-19 19:44:56','2017-12-19 19:44:56'),(23,'Benin','2017-12-19 19:44:56','2017-12-19 19:44:56'),(24,'Bermuda (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(25,'Bhutan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(26,'Bolivia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(27,'Bosnia and Herzegovina','2017-12-19 19:44:56','2017-12-19 19:44:56'),(28,'Botswana','2017-12-19 19:44:56','2017-12-19 19:44:56'),(29,'Brazil','2017-12-19 19:44:56','2017-12-19 19:44:56'),(30,'British Virgin Islands (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(31,'Brunei','2017-12-19 19:44:56','2017-12-19 19:44:56'),(32,'Bulgaria','2017-12-19 19:44:56','2017-12-19 19:44:56'),(33,'Burkina Faso','2017-12-19 19:44:56','2017-12-19 19:44:56'),(34,'Burma','2017-12-19 19:44:56','2017-12-19 19:44:56'),(35,'Burundi','2017-12-19 19:44:56','2017-12-19 19:44:56'),(36,'Cambodia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(37,'Cameroon','2017-12-19 19:44:56','2017-12-19 19:44:56'),(38,'Canada','2017-12-19 19:44:56','2017-12-19 19:44:56'),(39,'Cape Verde','2017-12-19 19:44:56','2017-12-19 19:44:56'),(40,'Caribbean Netherlands (Netherlands)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(41,'Cayman Islands (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(42,'Central African Republic','2017-12-19 19:44:56','2017-12-19 19:44:56'),(43,'Chad','2017-12-19 19:44:56','2017-12-19 19:44:56'),(44,'Chile','2017-12-19 19:44:56','2017-12-19 19:44:56'),(45,'China','2017-12-19 19:44:56','2017-12-19 19:44:56'),(46,'Christmas Island (Australia)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(47,'Cocos (Keeling) Islands (Australia)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(48,'Colombia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(49,'Comoros','2017-12-19 19:44:56','2017-12-19 19:44:56'),(50,'Cook Islands (NZ)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(51,'Costa Rica','2017-12-19 19:44:56','2017-12-19 19:44:56'),(52,'Croatia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(53,'Cuba','2017-12-19 19:44:56','2017-12-19 19:44:56'),(54,'Curacao (Netherlands)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(55,'Cyprus','2017-12-19 19:44:56','2017-12-19 19:44:56'),(56,'Czech Republic','2017-12-19 19:44:56','2017-12-19 19:44:56'),(57,'Democratic Republic of the Congo','2017-12-19 19:44:56','2017-12-19 19:44:56'),(58,'Denmark','2017-12-19 19:44:56','2017-12-19 19:44:56'),(59,'Djibouti','2017-12-19 19:44:56','2017-12-19 19:44:56'),(60,'Dominica','2017-12-19 19:44:56','2017-12-19 19:44:56'),(61,'Dominican Republic','2017-12-19 19:44:56','2017-12-19 19:44:56'),(62,'Ecuador','2017-12-19 19:44:56','2017-12-19 19:44:56'),(63,'Egypt','2017-12-19 19:44:56','2017-12-19 19:44:56'),(64,'El Salvador','2017-12-19 19:44:56','2017-12-19 19:44:56'),(65,'Equatorial Guinea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(66,'Eritrea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(67,'Estonia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(68,'Ethiopia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(69,'Falkland Islands (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(70,'Faroe Islands (Denmark)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(71,'Federated States of Micronesia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(72,'Fiji','2017-12-19 19:44:56','2017-12-19 19:44:56'),(73,'Finland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(74,'France','2017-12-19 19:44:56','2017-12-19 19:44:56'),(75,'French Guiana (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(76,'French Polynesia (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(77,'Gabon','2017-12-19 19:44:56','2017-12-19 19:44:56'),(78,'Gambia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(79,'Georgia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(80,'Germany','2017-12-19 19:44:56','2017-12-19 19:44:56'),(81,'Ghana','2017-12-19 19:44:56','2017-12-19 19:44:56'),(82,'Gibraltar (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(83,'Greece','2017-12-19 19:44:56','2017-12-19 19:44:56'),(84,'Greenland (Denmark)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(85,'Grenada','2017-12-19 19:44:56','2017-12-19 19:44:56'),(86,'Guadeloupe (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(87,'Guam (USA)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(88,'Guatemala','2017-12-19 19:44:56','2017-12-19 19:44:56'),(89,'Guernsey (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(90,'Guinea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(91,'Guinea-Bissau','2017-12-19 19:44:56','2017-12-19 19:44:56'),(92,'Guyana','2017-12-19 19:44:56','2017-12-19 19:44:56'),(93,'Haiti','2017-12-19 19:44:56','2017-12-19 19:44:56'),(94,'Honduras','2017-12-19 19:44:56','2017-12-19 19:44:56'),(95,'Hong Kong (China)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(96,'Hungary','2017-12-19 19:44:56','2017-12-19 19:44:56'),(97,'Iceland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(98,'India','2017-12-19 19:44:56','2017-12-19 19:44:56'),(99,'Indonesia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(100,'Iran','2017-12-19 19:44:56','2017-12-19 19:44:56'),(101,'Iraq','2017-12-19 19:44:56','2017-12-19 19:44:56'),(102,'Ireland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(103,'Isle of Man (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(104,'Israel','2017-12-19 19:44:56','2017-12-19 19:44:56'),(105,'Italy','2017-12-19 19:44:56','2017-12-19 19:44:56'),(106,'Ivory Coast','2017-12-19 19:44:56','2017-12-19 19:44:56'),(107,'Jamaica','2017-12-19 19:44:56','2017-12-19 19:44:56'),(108,'Japan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(109,'Jersey (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(110,'Jordan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(111,'Kazakhstan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(112,'Kenya','2017-12-19 19:44:56','2017-12-19 19:44:56'),(113,'Kiribati','2017-12-19 19:44:56','2017-12-19 19:44:56'),(114,'Kosovo','2017-12-19 19:44:56','2017-12-19 19:44:56'),(115,'Kuwait','2017-12-19 19:44:56','2017-12-19 19:44:56'),(116,'Kyrgyzstan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(117,'Laos','2017-12-19 19:44:56','2017-12-19 19:44:56'),(118,'Latvia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(119,'Lebanon','2017-12-19 19:44:56','2017-12-19 19:44:56'),(120,'Lesotho','2017-12-19 19:44:56','2017-12-19 19:44:56'),(121,'Liberia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(122,'Libya','2017-12-19 19:44:56','2017-12-19 19:44:56'),(123,'Liechtenstein','2017-12-19 19:44:56','2017-12-19 19:44:56'),(124,'Lithuania','2017-12-19 19:44:56','2017-12-19 19:44:56'),(125,'Luxembourg','2017-12-19 19:44:56','2017-12-19 19:44:56'),(126,'Macau (China)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(127,'Macedonia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(128,'Madagascar','2017-12-19 19:44:56','2017-12-19 19:44:56'),(129,'Malawi','2017-12-19 19:44:56','2017-12-19 19:44:56'),(130,'Malaysia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(131,'Maldives','2017-12-19 19:44:56','2017-12-19 19:44:56'),(132,'Mali','2017-12-19 19:44:56','2017-12-19 19:44:56'),(133,'Malta','2017-12-19 19:44:56','2017-12-19 19:44:56'),(134,'Marshall Islands','2017-12-19 19:44:56','2017-12-19 19:44:56'),(135,'Martinique (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(136,'Mauritania','2017-12-19 19:44:56','2017-12-19 19:44:56'),(137,'Mauritius','2017-12-19 19:44:56','2017-12-19 19:44:56'),(138,'Mayotte (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(139,'Mexico','2017-12-19 19:44:56','2017-12-19 19:44:56'),(140,'Moldov','2017-12-19 19:44:56','2017-12-19 19:44:56'),(141,'Monaco','2017-12-19 19:44:56','2017-12-19 19:44:56'),(142,'Mongolia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(143,'Montenegro','2017-12-19 19:44:56','2017-12-19 19:44:56'),(144,'Montserrat (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(145,'Morocco','2017-12-19 19:44:56','2017-12-19 19:44:56'),(146,'Mozambique','2017-12-19 19:44:56','2017-12-19 19:44:56'),(147,'Namibia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(148,'Nauru','2017-12-19 19:44:56','2017-12-19 19:44:56'),(149,'Nepal','2017-12-19 19:44:56','2017-12-19 19:44:56'),(150,'Netherlands','2017-12-19 19:44:56','2017-12-19 19:44:56'),(151,'New Caledonia (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(152,'New Zealand','2017-12-19 19:44:56','2017-12-19 19:44:56'),(153,'Nicaragua','2017-12-19 19:44:56','2017-12-19 19:44:56'),(154,'Niger','2017-12-19 19:44:56','2017-12-19 19:44:56'),(155,'Nigeria','2017-12-19 19:44:56','2017-12-19 19:44:56'),(156,'Niue (NZ)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(157,'Norfolk Island (Australia)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(158,'North Korea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(159,'Northern Mariana Islands (USA)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(160,'Norway','2017-12-19 19:44:56','2017-12-19 19:44:56'),(161,'Oman','2017-12-19 19:44:56','2017-12-19 19:44:56'),(162,'Pakistan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(163,'Palau','2017-12-19 19:44:56','2017-12-19 19:44:56'),(164,'Palestine','2017-12-19 19:44:56','2017-12-19 19:44:56'),(165,'Panama','2017-12-19 19:44:56','2017-12-19 19:44:56'),(166,'Papua New Guinea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(167,'Paraguay','2017-12-19 19:44:56','2017-12-19 19:44:56'),(168,'Peru','2017-12-19 19:44:56','2017-12-19 19:44:56'),(169,'Philippines','2017-12-19 19:44:56','2017-12-19 19:44:56'),(170,'Pitcairn Islands (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(171,'Poland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(172,'Portugal','2017-12-19 19:44:56','2017-12-19 19:44:56'),(173,'Puerto Rico','2017-12-19 19:44:56','2017-12-19 19:44:56'),(174,'Qatar','2017-12-19 19:44:56','2017-12-19 19:44:56'),(175,'Republic of the Congo','2017-12-19 19:44:56','2017-12-19 19:44:56'),(176,'Reunion (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(177,'Romania','2017-12-19 19:44:56','2017-12-19 19:44:56'),(178,'Russia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(179,'Rwanda','2017-12-19 19:44:56','2017-12-19 19:44:56'),(180,'Saint Barthelemy (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(181,'Saint Helena, Ascension and Tristan da Cunha (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(182,'Saint Kitts and Nevis','2017-12-19 19:44:56','2017-12-19 19:44:56'),(183,'Saint Lucia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(184,'Saint Martin (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(185,'Saint Pierre and Miquelon (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(186,'Saint Vincent and the Grenadines','2017-12-19 19:44:56','2017-12-19 19:44:56'),(187,'Samoa','2017-12-19 19:44:56','2017-12-19 19:44:56'),(188,'San Marino','2017-12-19 19:44:56','2017-12-19 19:44:56'),(189,'Sao Tom and Principe','2017-12-19 19:44:56','2017-12-19 19:44:56'),(190,'Saudi Arabia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(191,'Senegal','2017-12-19 19:44:56','2017-12-19 19:44:56'),(192,'Serbia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(193,'Seychelles','2017-12-19 19:44:56','2017-12-19 19:44:56'),(194,'Sierra Leone','2017-12-19 19:44:56','2017-12-19 19:44:56'),(195,'Singapore','2017-12-19 19:44:56','2017-12-19 19:44:56'),(196,'Sint Maarten (Netherlands)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(197,'Slovakia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(198,'Slovenia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(199,'Solomon Islands','2017-12-19 19:44:56','2017-12-19 19:44:56'),(200,'Somalia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(201,'South Africa','2017-12-19 19:44:56','2017-12-19 19:44:56'),(202,'South Korea','2017-12-19 19:44:56','2017-12-19 19:44:56'),(203,'South Sudan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(204,'Spain','2017-12-19 19:44:56','2017-12-19 19:44:56'),(205,'Sri Lanka','2017-12-19 19:44:56','2017-12-19 19:44:56'),(206,'Sudan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(207,'Suriname','2017-12-19 19:44:56','2017-12-19 19:44:56'),(208,'Svalbard and Jan Mayen (Norway)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(209,'Swaziland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(210,'Sweden','2017-12-19 19:44:56','2017-12-19 19:44:56'),(211,'Switzerland','2017-12-19 19:44:56','2017-12-19 19:44:56'),(212,'Syria','2017-12-19 19:44:56','2017-12-19 19:44:56'),(213,'Taiwan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(214,'Tajikistan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(215,'Tanzania','2017-12-19 19:44:56','2017-12-19 19:44:56'),(216,'Thailand','2017-12-19 19:44:56','2017-12-19 19:44:56'),(217,'Timor-Leste','2017-12-19 19:44:56','2017-12-19 19:44:56'),(218,'Togo','2017-12-19 19:44:56','2017-12-19 19:44:56'),(219,'Tokelau (NZ)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(220,'Tonga','2017-12-19 19:44:56','2017-12-19 19:44:56'),(221,'Trinidad and Tobago','2017-12-19 19:44:56','2017-12-19 19:44:56'),(222,'Tunisia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(223,'Turkey','2017-12-19 19:44:56','2017-12-19 19:44:56'),(224,'Turkmenistan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(225,'Turks and Caicos Islands (UK)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(226,'Tuvalu','2017-12-19 19:44:56','2017-12-19 19:44:56'),(227,'Uganda','2017-12-19 19:44:56','2017-12-19 19:44:56'),(228,'Ukraine','2017-12-19 19:44:56','2017-12-19 19:44:56'),(229,'United Arab Emirates','2017-12-19 19:44:56','2017-12-19 19:44:56'),(230,'United Kingdom','2017-12-19 19:44:56','2017-12-19 19:44:56'),(231,'United States','2017-12-19 19:44:56','2017-12-19 19:44:56'),(232,'United States Virgin Islands (USA)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(233,'Uruguay','2017-12-19 19:44:56','2017-12-19 19:44:56'),(234,'Uzbekistan','2017-12-19 19:44:56','2017-12-19 19:44:56'),(235,'Vanuatu','2017-12-19 19:44:56','2017-12-19 19:44:56'),(236,'Vatican City','2017-12-19 19:44:56','2017-12-19 19:44:56'),(237,'Venezuela','2017-12-19 19:44:56','2017-12-19 19:44:56'),(238,'Vietnam','2017-12-19 19:44:56','2017-12-19 19:44:56'),(239,'Wallis and Futuna (France)','2017-12-19 19:44:56','2017-12-19 19:44:56'),(240,'Western Sahara','2017-12-19 19:44:56','2017-12-19 19:44:56'),(241,'Yemen','2017-12-19 19:44:56','2017-12-19 19:44:56'),(242,'Zambia','2017-12-19 19:44:56','2017-12-19 19:44:56'),(243,'Zimbabwe','2017-12-19 19:44:56','2017-12-19 19:44:56');

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

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


--
-- 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 `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,
  `approved_by` int(10) unsigned NOT 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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `inhouse_requisition` VALUES (1,1,'6',5,'Admin',0,0,NULL,'2017-12-18 15:31:39','2017-12-18 15:31:39');

--
-- 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 `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 `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 `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,
  `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',
  `equipment_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `equipment_status` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `quantity` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `manufacture_date` date DEFAULT NULL,
  `comment` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `mechanical_inventory` VALUES (1,'centrifudge','asdjakds','asdadsadajksd',2,3,'0','2017-12-19 00:00:00','2017-12-19 00:00:00','2017-12-19 00:00:00','2017-12-19 00:00:00',1,0,4,0,1,'2017-12-19 09:00:43','2017-12-19 09:00:43',NULL,NULL,NULL,NULL,NULL,NULL),(2,'cobas 881212','asdad','lasdkaldkls',2,0,'0','2017-12-19 00:00:00','2017-12-19 00:00:00','2017-12-19 00:00:00','2017-12-19 00:00:00',1,0,3,0,1,'2017-12-19 20:14:41','2017-12-19 20:14:41','Cobas-8800',NULL,1,NULL,'2017-12-19','');

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

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

INSERT INTO `mechanical_supplier` VALUES (2,'Medisell','0785262623','ben@am.com','jkj','2017-12-19 08:43:01','2017-12-19 09:01:38');

--
-- 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=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `metrics` VALUES (1,'PCS','',NULL,'2017-12-18 14:32:24','2017-12-18 14:32:24'),(2,'TEST','',NULL,'2017-12-18 14:32:30','2017-12-18 14:32:30'),(3,'ML','',NULL,'2017-12-18 14:32:37','2017-12-18 14:32:37'),(4,'BUNDLE','',NULL,'2017-12-18 14:32:43','2017-12-18 14:32:43'),(5,'L','',NULL,'2017-12-18 14:32:57','2017-12-18 14:32:57'),(6,'RUNS','',NULL,'2017-12-18 14:33:10','2017-12-18 14:33:10');

--
-- 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',2);

--
-- 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- 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=69 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,1,1),(17,2,1),(18,3,1),(19,4,1),(20,5,1),(21,6,1),(22,7,1),(23,8,1),(24,9,1),(25,10,1),(26,11,1),(27,12,1),(28,13,1),(29,14,1),(30,14,4),(31,15,1),(32,1,1),(33,2,1),(34,3,1),(35,4,1),(36,5,1),(37,6,1),(38,7,1),(39,8,1),(40,9,1),(41,10,1),(42,11,1),(43,12,1),(44,13,1),(45,14,1),(46,14,4),(47,15,1),(48,20,5),(49,21,5),(50,1,1),(51,2,1),(52,3,1),(53,4,1),(54,5,1),(55,6,1),(56,7,1),(57,8,1),(58,9,1),(59,10,1),(60,11,1),(61,12,1),(62,12,5),(63,13,1),(64,14,1),(65,14,4),(66,15,1),(67,20,5),(68,21,5);

--
-- 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','2017-12-18 14:20:07','2017-12-18 14:20:07'),(2,'ict_dept','Heads ICT Dept','2017-12-18 14:20:07','2017-12-18 14:20:07'),(3,'lab_manager','Heads Laboratory','2017-12-18 14:20:07','2017-12-18 14:20:07'),(4,'vl_head','Heads VL lab','2017-12-18 14:20:07','2017-12-18 14:20:07'),(5,'eid_head','Heads EID lab','2017-12-18 14:20:07','2017-12-18 14:20:07'),(6,'Microbiology_head','Heads Microbiology','2017-12-18 14:20:07','2017-12-18 14:20:07'),(7,'sample_reception_head','Heads Sample Reception','2017-12-18 14:20:07','2017-12-18 14:20:07'),(8,'data_head','Heads Data','2017-12-18 14:20:07','2017-12-18 14:20:07'),(9,'stores_head','Heads Stores','2017-12-18 14:20:07','2017-12-18 14:20:07'),(10,'manage_users','Can manage users','2017-12-18 14:20:07','2017-12-18 14:20:07'),(11,'view_reports','Can view reports','2017-12-18 14:20:07','2017-12-18 14:20:07'),(12,'manage_inventory','Can manage inventory','2017-12-18 14:20:07','2017-12-18 14:20:07'),(13,'request_topup','Can request top-up','2017-12-18 14:20:07','2017-12-18 14:20:07'),(14,'assetmgt','Can manage Assets','2017-12-18 14:20:07','2017-12-18 14:20:07'),(15,'can_handle_invoice','Can manage Documents','2017-12-18 14:20:07','2017-12-18 14:20:07'),(16,'manage_biomed_assets','Can manage Bio-medical assets','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'manage_ict_assets','Can manage ICT assets','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'manage_transport_assets','Manage Transport & Fleet assets','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'handle_dept_requests','Manage Department Requests','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'manage_commodities','Manage Store Commodities','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'manage_stock_card','Manage Stock Card','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'place_unhls_order','Can Place UNHLS Store Orders','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'view_stock_reports','View Stock Reports','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'log_biomed_breakdown','Can Log Bio-medical breakdown','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'log_ict_breakdown','Can Log ICT breakdown','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'manage_hubs_and_facilities','Manage Hubs & Facilities','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'manage_fund_managers','Manage Fund Managers','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'manage_facility_request','Manage Facility Request','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- 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 `requistions`
--

CREATE TABLE `requistions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `voucher_no` int(11) NOT NULL,
  `voucher_date` date NOT NULL,
  `unit` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `incharge_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `folio_number` int(11) NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `issue_unit` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `quantity_required` int(11) NOT NULL,
  `quantity_issued` int(11) NOT NULL,
  `unit_cost` int(11) NOT NULL,
  `total_issued` int(11) NOT NULL,
  `grand_total` int(11) NOT NULL,
  `authorized_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `received_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `Signature` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `issue_date` date NOT NULL,
  `stock_card_date` date 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 `requistions`
--


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

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

INSERT INTO `roles` VALUES (1,'Superadministrator',NULL,'2017-12-18 14:20:07','2017-12-18 14:20:07'),(2,'Stores Manager',NULL,'2017-12-18 14:20:07','2017-12-18 14:20:07'),(3,'Stores Assistant',NULL,'2017-12-18 14:20:07','2017-12-18 14:20:07'),(4,'Bio-Medical Engineer','','2017-12-19 08:32:16','2017-12-19 08:32:16'),(5,'Logistics Assistant','','2017-12-19 08:32:48','2017-12-19 08:32:48');

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

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

INSERT INTO `store_section` VALUES (1,'VL section',0.00,0.00,0.00,0.00,18.00,30.00,'Admin','2017-12-18 14:34:52','2017-12-18 14:34:52'),(2,'Cold Chain',0.00,0.00,0.00,0.00,4.00,8.00,'Admin','2017-12-18 14:35:07','2017-12-18 14:35:07'),(3,'EID Section',0.00,0.00,0.00,0.00,18.00,30.00,'Admin','2017-12-18 14:35:24','2017-12-18 14:35:24');

--
-- 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,'JMS','0','','',NULL,'2017-12-18 14:33:41','2017-12-18 14:33:41'),(2,'MAUL','0414237707','gerald.sebulime@medicalaccess.co.ug','',NULL,'2017-12-18 14:34:06','2017-12-18 14:34:06'),(3,'NMS','0','','',NULL,'2017-12-18 15:11:54','2017-12-18 15:11:54');

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

--
-- 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=2 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,'2017-12-18 14:20:07','2017-12-18 14:20:07');

--
-- 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','2017-12-18 14:20:07','2017-12-18 14:20:07'),(2,'Public RRH','2017-12-18 14:20:07','2017-12-18 14:20:07'),(3,'Public GH','2017-12-18 14:20:07','2017-12-18 14:20:07'),(4,'Public HCIV','2017-12-18 14:20:07','2017-12-18 14:20:07'),(5,'Public HCIII','2017-12-18 14:20:07','2017-12-18 14:20:07'),(6,'Hospital','2017-12-18 14:20:07','2017-12-18 14:20:07');

--
-- 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','2017-12-18 14:20:07','2017-12-18 14:20:07'),(2,'PFP','2017-12-18 14:20:07','2017-12-18 14:20:07'),(3,'PNFP','2017-12-18 14:20:07','2017-12-18 14:20:07'),(4,'Other','2017-12-18 14:20:07','2017-12-18 14:20:07');

--
-- 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,
  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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `unhls_stockcard` VALUES (1,13,2,2,'mkkkjjkjkjkjkjjkjjkj','7677yyyy',0,'I','ghhgg6666','2017-12-20 00:00:00','0000-00-00 00:00:00','IG','',100,'2017-12-20 07:41:28','2017-12-20 07:41:28','2017-12-20 00:00:00',100,NULL),(2,13,1,2,'UUYYUYYUY','uiuuuu',0,'I','4554rrr','2017-12-20 00:00:00','0000-00-00 00:00:00','IT','',150,'2017-12-20 07:42:11','2017-12-20 07:42:11','2017-12-20 00:00:00',50,NULL),(3,13,1,3,'mkkkjjkjkjkjkjjkjjkj','JJHJHJ',0,'O','JKJJKJJ','0000-00-00 00:00:00','0000-00-00 00:00:00','BO','',100,'2017-12-20 07:45:03','2017-12-20 07:45:03','2017-12-20 00:00:00',NULL,50);

--
-- 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`
--



