 );
 
 /**
+* Chronolology table gives a history of events on data
+* Modules: all 
+* Created : 28-Nov-2006 - chamindra@opensource.lk
+*/
+DROP TABLE IF EXISTS chronology;
+CREATE TABLE chronology(
+    log_uuid VARCHAR(60) NOT NULL, -- the log identifier
+    event_date DATETIME,           -- the date and time of the event
+    pgoc_uuid VARCHAR(60),         -- the entity uuid that this associates to
+    opt_cron_type VARCHAR(3),      -- type of event
+    module VARCHAR(10),             
+    action VARCHAR(10),            -- action
+    user_uuid VARCHAR(60), 
+    comments VARCHAR(100),         -- description of changes
+    details VARCHAR(200)           -- more detailed description of the changes
+); 
+    
+
+/**
 * Auditor log table 
 * Modules: dvr, mpr, 
 * Created : 21-Dec-2005 - janaka@opensource.lk

    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,

);

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