     parent_id VARCHAR(60) DEFAULT NULL, -- parent location id
  --   search_id VARCHAR(20), -- a heirarchical id expressing the heirarachy
     opt_location_type VARCHAR(10), -- location type taken from field_opts
+    name VARCHAR(100) NOT NULL,
+    iso_code VARCHAR(20),
+    description TEXT,
+    PRIMARY KEY (loc_uuid),
+    FOREIGN KEY (parent_id) REFERENCES location(loc_uuid)
+);
+
+/**
+* Details on the location of an entity (person, camp, organization)
+* Modules: dvr, mpr, or, cr, rms, gis 
+* Last changed: 27-OCT-2005 - ravindra@opensource.lk  
+*/
+DROP TABLE IF EXISTS location_details;
+CREATE TABLE location_details ( 
+    poc_uuid VARCHAR(60) NOT NULL, -- this can be a person, camp or organization location
+    location_id VARCHAR(60), -- This gives country,province,district,town - based on l10n 
     name VARCHAR(100) NOT NULL,
     iso_code VARCHAR(20),
     description TEXT,

);

/**
* Auditor log table 
* Modules: dvr, mpr, 
* Created : 21-Dec-2005 - janaka@opensource.lk

);

DROP TABLE IF EXISTS person_camp;
DROP TABLE IF EXISTS configlist;
CREATE TABLE configlist(
	description TEXT NOT NULL,
