-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathlocation.sql
More file actions
68 lines (65 loc) · 25.9 KB
/
location.sql
File metadata and controls
68 lines (65 loc) · 25.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
--
-- Table structure for table `location`
--
set foreign_key_checks=0;
DROP TABLE IF EXISTS `location`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `location` (
`location_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) DEFAULT NULL,
`address1` varchar(255) DEFAULT NULL,
`address2` varchar(255) DEFAULT NULL,
`city_village` varchar(255) DEFAULT NULL,
`state_province` varchar(255) DEFAULT NULL,
`postal_code` varchar(50) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
`latitude` varchar(50) DEFAULT NULL,
`longitude` varchar(50) DEFAULT NULL,
`creator` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL,
`county_district` varchar(255) DEFAULT NULL,
`address3` varchar(255) DEFAULT NULL,
`address4` varchar(255) DEFAULT NULL,
`address5` varchar(255) DEFAULT NULL,
`address6` varchar(255) DEFAULT NULL,
`retired` tinyint(1) NOT NULL DEFAULT '0',
`retired_by` int(11) DEFAULT NULL,
`date_retired` datetime DEFAULT NULL,
`retire_reason` varchar(255) DEFAULT NULL,
`parent_location` int(11) DEFAULT NULL,
`uuid` char(38) NOT NULL,
`changed_by` int(11) DEFAULT NULL,
`date_changed` datetime DEFAULT NULL,
`address7` varchar(255) DEFAULT NULL,
`address8` varchar(255) DEFAULT NULL,
`address9` varchar(255) DEFAULT NULL,
`address10` varchar(255) DEFAULT NULL,
`address11` varchar(255) DEFAULT NULL,
`address12` varchar(255) DEFAULT NULL,
`address13` varchar(255) DEFAULT NULL,
`address14` varchar(255) DEFAULT NULL,
`address15` varchar(255) DEFAULT NULL,
PRIMARY KEY (`location_id`),
UNIQUE KEY `location_uuid_index` (`uuid`),
KEY `name_of_location` (`name`),
KEY `location_retired_status` (`retired`),
KEY `user_who_created_location` (`creator`),
KEY `user_who_retired_location` (`retired_by`),
KEY `parent_location` (`parent_location`),
KEY `location_changed_by` (`changed_by`),
CONSTRAINT `location_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
CONSTRAINT `parent_location` FOREIGN KEY (`parent_location`) REFERENCES `location` (`location_id`),
CONSTRAINT `user_who_created_location` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
CONSTRAINT `user_who_retired_location` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `location`
--
LOCK TABLES `location` WRITE;
/*!40000 ALTER TABLE `location` DISABLE KEYS */;
INSERT INTO `location` VALUES (1,'Unknown Location',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2005-09-22 00:00:00',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:50','Not applicable in Lesotho',NULL,'8d6c993e-c2cc-11de-8d13-0010c6dffd0f',4,'2018-04-12 06:23:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Ganiyari','Ganiyari hospital',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 00:00:00',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',NULL,'c1e42932-3f10-11e4-adec-0800271c1b75',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'Subcenter 2 (SEM)','Subcenter 2 (SEM)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 00:00:00',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:24:27','Not applicable in Lesotho',NULL,'c1e4950f-3f10-11e4-adec-0800271c1b75',4,'2018-04-12 06:24:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Subcenter 3 (SIV)','Subcenter 3 (SIV)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 00:00:00',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:24:11','Not applicable in Lesotho',NULL,'c1ebb8db-3f10-11e4-adec-0800271c1b75',4,'2018-04-12 06:24:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Subcenter 1 (BAM)','Subcenter 1 (BAM)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 00:00:00',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:32','Not applicable in Lesotho',NULL,'c1f25be5-3f10-11e4-adec-0800271c1b75',4,'2018-04-12 06:23:32',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Registration Desk','Registration Desk at Botha-Bothe Hospital',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 14:34:18',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-13 11:20:46','no longer needed, control will be provided via roles',15,'c5854fd7-3f12-11e4-adec-0800271c1b75',4,'2018-04-13 11:20:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'OPD-1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2014-09-18 14:34:18',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',2,'c58e12ed-3f12-11e4-adec-0800271c1b75',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'General Ward','General Ward',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-24 18:30:22',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',2,'baf7bd38-d225-11e4-9c67-080027b662ec',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'General Ward Room 1','1st Floor of General Ward',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-24 18:30:22',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',9,'baf83667-d225-11e4-9c67-080027b662ec',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Labour Ward','General Ward',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-24 18:30:22',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',2,'bb0e512e-d225-11e4-9c67-080027b662ec',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Labour Ward - 1','1st Floor of General Ward',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-03-24 18:30:22',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',11,'bb0eb071-d225-11e4-9c67-080027b662ec',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'General Ward - Room 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2015-11-02 05:47:24',NULL,NULL,NULL,NULL,NULL,1,4,'2018-04-12 06:23:04','Not applicable in Lesotho',9,'e48fb2b3-d490-11e5-b193-0800270d80ce',4,'2018-04-12 06:23:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'Botha-Bothe Hospital','Botha-Bothe Hospital',NULL,'BOTHA-BOTHE','PHAPHAMA','BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-01-24 14:09:28',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'9a2b997b-9204-474f-b447-e603f3235460',4,'2018-04-12 06:25:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Paballong ART Clinic','ART Clinic in Botha-Bothe Hopsital',NULL,'BOTHA-BOTHE','PHAPHAMA','BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-01-24 14:15:32',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,15,'b7f7c86b-8975-4281-8890-c0f68c942dbf',4,'2018-04-12 06:26:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Paballong TB Clinic','Paballong TB Clinic',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-01-24 14:21:29',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,15,'d2908f90-db10-4bc7-a1d2-ecff8f060368',4,'2018-05-02 19:39:16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'MCH Clinic Botha-Bothe Hospital','MCH Clinic Botha-Bothe Hospital',NULL,'BOTHA-BOTHE','PHAPHAMA','BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-05-02 19:41:50',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,15,'f1df083c-81de-4d5a-8966-96605f6d3d88',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Muela Site HC',NULL,NULL,'MOTETE','MUELA MORENENG','BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-06-22 14:39:57',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'da0effb5-2ee5-449c-a76d-5227d3193d7c',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'St Paul HC',NULL,NULL,'HOLOLO',NULL,'BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-06-22 14:44:31',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'a0a3bec5-ef1f-4291-99be-7d8d0f9447b9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'St Josephs HOSP',NULL,NULL,'MAAMA','ST. JOSEPH\'S','MASERU',NULL,NULL,NULL,NULL,4,'2018-06-22 14:47:45',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'f8461e51-097a-4f48-82cc-64a756d04abe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'Thusong ART Clinic',NULL,NULL,'MAAMA','ST. JOSEPH\'S','MASERU',NULL,NULL,NULL,NULL,4,'2018-06-22 14:49:17',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,21,'95c1a4dc-7d2e-4720-9c56-7f2f77a3c74b',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'MCH Clinic St Josephs HOSP',NULL,NULL,'MAAMA','ST. JOSEPH\'S','MASERU',NULL,NULL,NULL,NULL,4,'2018-06-22 14:57:31',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,21,'f0c02197-d816-4d4a-8915-0b187e463a45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'TB Clinic St Josephs HOSP',NULL,NULL,'MAAMA','ST. JOSEPH\'S','MASERU',NULL,NULL,NULL,NULL,4,'2018-06-22 14:58:16',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,21,'c1b3e9ce-aa72-4a2a-b879-f1d6df4d6a61',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'Nazareth HC','Nazareth HC',NULL,'MACHACHE','NAZARETH','MASERU',NULL,NULL,NULL,NULL,4,'2018-07-17 21:48:10',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2265f740-775c-442f-bee7-b98994607109',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Ha-Tlali HC','Ha-Tlali HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-07-17 21:53:27',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'1fccbe5b-2b19-4adb-92fd-1e6d9780e1b6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'Domicilliary HC','Domicilliary HC',NULL,'STADIUM AREA','STADIUM AREA','MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:12:27',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'5a71e719-c035-4ac8-87f6-a0ad7ee75474',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'TB Clinic Domicilliary HC','TB Clinic Domicilliary HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:14:04',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,27,'f12fb900-6f4a-4404-9406-205d8a93b66a',4,'2018-08-08 12:21:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'ART Clinic Domicilliary HC','ART Clinic Domicilliary HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:14:43',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,27,'1103a754-33b2-45f0-9869-1d629f37f550',4,'2018-08-08 12:22:25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'MCH Domicilliary HC','MCH Domicilliary HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:15:15',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,27,'791260c2-b2c1-40cb-b2c6-bb0dc8a3b79d',4,'2018-08-08 12:23:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Men Clinic Domicilliary HC','Men Clinic Domicilliary HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:15:46',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,27,'e1031e98-d3bd-41b8-8426-d032209e11e5',4,'2018-08-08 12:23:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'Queen Elizabeth II HC','Queen Elizabeth II HC',NULL,'MASERU',NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:19:08',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'9123211a-6781-417c-b390-3341764e83a3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'TB Clinic Queen Elizabeth II HC','TB Clinic Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:24:45',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'cf9ba3aa-658e-4c23-90e6-eefcde4aae7f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'ART Clinic Queen Elizabeth II HC','ART Clinic Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:25:53',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'61fa6016-d3ef-4267-ab23-7338b35ccbd7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'MCH Queen Elizabeth II HC','MCH Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:26:32',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'c84b7e6f-f4c5-4886-b727-b9d3c852c6da',4,'2018-08-08 12:28:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'Adolescent Queen Elizabeth II HC','Adolescent Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:27:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'e3d4d000-03b0-4a6f-a791-309d4f5cb9a2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'Men Clinic Queen Elizabeth II HC','Men Clinic Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:28:59',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'bed70c3e-4e3a-4383-b9f5-e561a998bd5d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'Bophelong Queen Elizabeth II HC','Bophelong Queen Elizabeth II HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:29:44',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,32,'809872ad-1a2d-4aca-9388-de897a9acee3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'Thamae HC','Thamae HC',NULL,'MASERU',NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:33:21',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'49ce8cfc-d827-4a16-95a6-531614faa838',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'TB Clinic Thamae HC','TB Clinic Thamae HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:36:11',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,39,'fd3d67ba-7099-4a18-ac49-301088117105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'ART Clinic Thamae HC','ART Clinic Thamae HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:37:52',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,39,'15c94552-fa19-4c0e-9a4d-3830f4396c0b',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'MCH Thamae HC','MCH Thamae HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:38:36',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,39,'baba81d0-5a11-4482-a58c-07c03a3e5024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'RLDF HC','RLDF HC',NULL,'THABA-BOSIU','HA LEQELE','MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:40:15',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'75ca439b-1c19-4971-874c-cf7b2e51a65b',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'TB Clinic RLDF HC','TB Clinic RLDF HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:41:18',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,43,'ce2fc495-e828-459c-822b-c45efcdc628a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'ART Clinic RLDF HC','ART Clinic RLDF HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:42:02',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,43,'37559f97-b324-4afa-8f79-133246b2e29a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'MCH RLDF HC','MCH RLDF HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:43:39',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,43,'04e7930c-5990-4855-b7d8-2201fcf01c4a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'Men Clinic RLDF HC','Men Clinic RLDF HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:44:24',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,43,'e153857c-f2bb-459c-b187-75efb09a7958',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'Maseru SDA HC','Maseru SDA HC',NULL,'MASERU','ST. JAMES','MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:49:07',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2e570922-8320-4a84-8e6a-12a326b6917c',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'Men Clinic Maseru SDA HC','Men Clinic Maseru SDA HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:50:26',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,48,'335fdb3f-a675-4800-b6e8-e8f8acdd2ee8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'TB/ART Clinic Maseru SDA HC','TB/ART Clinic Maseru SDA HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:51:18',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,48,'2e2e8395-88c2-465a-a174-abc8a9b48666',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'Seboche HC','Seboche HC',NULL,'QALO',NULL,'BOTHA-BOTHE',NULL,NULL,NULL,NULL,4,'2018-08-08 12:54:06',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'b7d8dd7b-2afb-4bec-9d9e-97f70466b6a6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'TB Clinic Seboche HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:54:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,51,'2857547d-193b-45c5-b39e-85c3753667ec',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'ART Clinic Seboche HC','ART Clinic Seboche HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:55:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,51,'532806c4-f92f-429e-9c67-b831ac67972d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'MCH Seboche HC','MCH Seboche HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:56:20',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,51,'d1b202b1-3291-47e0-8e2c-204025576466',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'Paki HC','Paki HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 12:57:57',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'f3439e69-755d-4f02-8827-9cecaf5febd3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'MCH Paki HC','MCH Paki HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:58:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,55,'800f24e6-7b2c-400b-a46c-509744791b1f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'TB/ART Clinic Paki HC','TB/ART Clinic Paki HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 12:59:53',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,55,'d7a513be-c043-44c2-b493-6c1d208abfcc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'Loretto HC','Loretto HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:01:20',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'fe57a05a-6aa6-41ff-b6fd-a6af0c5ec223',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'TB Clinic Loretto HC','TB Clinic Loretto HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:02:27',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,58,'d5a97e85-d56a-4422-9a9e-376ab8f7e503',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'ART Clinic Loretto HC','ART Clinic Loretto HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:03:03',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,58,'807f0cda-0a40-4fb1-b0d6-d296a1218745',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'Adolescent Loretto HC','Adolescent Loretto HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:03:43',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,58,'729510e8-ca14-440f-9295-cd11b0e88737',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'PMTCT Clinic Loretto HC','PMTCT Clinic Loretto HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:04:29',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,58,'d8d77874-b61e-4532-9947-7ea6a1e3d169',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'Scott Mission HOSP','Scott Mission HOSP',NULL,'MATSIENG','MORIJA','MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:05:57',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'2961e34b-4755-4f20-b4bb-ae75e1fedc00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'TB Clinic Scott Mission HOSP','TB Clinic Scott Mission HOSP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:06:51',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,63,'42a70677-4419-449f-9ea5-0573a400440a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'ART Clinic Scott Mission HOSP','ART Clinic Scott Mission HOSP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:07:51',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,63,'30144390-6f4e-46b6-a814-e6fb5fd46035',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'MCH Scott Mission HOSP','MCH Scott Mission HOSP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:08:35',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,63,'17e1ed47-5048-499d-8472-a64b88bdcd43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'Adolescent Scott Mission HOSP','Adolescent Scott Mission HOSP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:09:51',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,63,'cf369f45-c3c9-4b57-b3e0-0a392b60bbc3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'Men Clinic Scott Mission HOSP','Men Clinic Scott Mission HOSP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:13:53',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,63,'da960fb1-4763-41ae-aa9c-d18d8b14d7a0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'St Leonard HC','St Leonard HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:14:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'280c6ad5-6cd6-4a34-bfdd-978c48773144',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'MCH St Leonard HC','MCH St Leonard HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:16:46',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,69,'8d156642-13eb-4796-9fa7-72c7d75b7fbc',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'Adolescent St Leonard HC','Adolescent St Leonard HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:22:12',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,69,'1eeca3c7-5c46-4e81-ae8c-126060fdad0c',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'TB/ART St Leonard HC','TB/ART St Leonard HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:24:01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,69,'77f80f85-5980-4f5d-b019-5620dbc9ce6a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'PMTCT St Leonard HC','PMTCT St Leonard HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:25:06',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,69,'cc9af646-e160-4edd-9952-d60dccbf108e',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'Matsineg HC','Matsineg HC',NULL,'MATSIENG','MATSIENG','MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:26:01',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'a345ed9d-6491-428c-a65c-6d3d514e9ec0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'TB Clinic Matsieng HC','TB Clinic Matsieng HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:26:40',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,74,'1a40a257-b958-4813-902f-7f077829aec0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'ART Clinic Matsieng HC','ART Clinic Matsieng HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:27:31',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,74,'a34ccd6c-5714-4e7d-a360-7a8606c994d4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'MCH Matsieng HC','MCH Matsieng HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:30:42',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,74,'195fb590-4fff-4de5-8f9e-b5f0a5e40d69',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'Thaba Bosiu HC','Thaba Bosiu HC',NULL,'THABA-BOSIU',NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:33:09',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'699f0b02-47db-4a97-9752-a9a6b622ad82',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'MCH Thaba Bosiu HC','MCH Thaba Bosiu HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:35:12',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,78,'d8b6ef62-1a58-4ba9-ab13-7f34499e7fda',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'TB/ART Clinic Thamae HC','TB/ART Clinic Thamae HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:36:17',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,78,'983560fe-71de-478c-bdc4-0d841494d219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'St Barnabas HC (Masite)','St Barnabas HC (Masite)',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:37:48',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'cbe9ffa8-e9fa-423c-8f35-a130fbf93d5f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'MCH St Barnabas HC (Masite)','MCH St Barnabas HC (Masite)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:38:49',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,81,'eb11ac5c-f877-4669-b891-7916f8a85ea6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'TB/ART Clinic St Barnabas HC (Masite)','TB/ART Clinic St Barnabas HC (Masite)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:39:59',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,81,'f955e344-934b-485b-952e-e35393f001c0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'Fatima/Ramabanta HC','Fatima/Ramabanta HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:40:53',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'ef64926c-93da-4acd-bf12-5d983cc9259b',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'MCH Fatima/Ramabanta HC','MCH Fatima/Ramabanta HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:41:45',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,84,'21db0342-ba90-45b4-a6b2-94bc3558016a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'TB/ART Clinic Fatima/Ramabanta HC','TB/ART Clinic Fatima/Ramabanta HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:42:40',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,84,'2fe31e6d-3181-4264-82f5-bafe389b6b12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'St Leo HC','St Leo HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:43:18',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'973e8ee1-6057-485f-99fb-cc1204d6d641',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'MCH St Leo HC','MCH St Leo HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:43:59',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,87,'3a9a52aa-c1e3-4dbe-9362-93fcb041e4e1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'TB/ART Clinic St Leo HC','TB/ART Clinic St Leo HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:44:48',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,87,'5ede6657-55cb-4504-9ffb-25ce1fbe4267',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'Semonkong HC','Semonkong HC',NULL,NULL,NULL,'MASERU',NULL,NULL,NULL,NULL,4,'2018-08-08 13:45:47',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,'dc120eea-788b-4872-8303-abcbc0cf0c27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'MCH Semonkong HC','MCH Semonkong HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:47:08',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,90,'ce82cc9c-ab11-446a-b89c-47a7f46b9071',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'TB/ART Clinic Semonkong HC','TB/ART Clinic Semonkong HC',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'2018-08-08 13:47:58',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,90,'3ad22695-9b35-4286-b445-52e7dd77cc4a',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `location` ENABLE KEYS */;
UNLOCK TABLES;