X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=sql%2Fevents.sql;h=7998e17328bc02e634afebab67a6425f6d4c5662;hp=222e6e820a1bc910d2f70ad6730bf1df7cfea646;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hpb=c7a3e29bde0e9721a91b77d4a55e668f8ec78b92

diff --git a/sql/events.sql b/sql/events.sql
index 222e6e82..7998e173 100644
--- a/sql/events.sql
+++ b/sql/events.sql
@@ -16,6 +16,7 @@ ALTER TABLE Events ADD COLUMN   on_id int(11) NOT NULL default 0;
 ALTER TABLE Events ADD COLUMN   on_table varchar(64) NOT NULL default '';
 ALTER TABLE Events ADD COLUMN   person_id int(11) NOT NULL default 0;
 ALTER TABLE Events ADD COLUMN   person_table varchar(64) NOT NULL default '';
+ALTER TABLE Events ADD COLUMN   dupe_id INT(11) NOT NULL DEFAULT 0;
 
 ALTER TABLE Events ADD COLUMN   remarks text ;
  
@@ -25,7 +26,7 @@ ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL;
 
 --# this are for pre-postgres support code..
 ALTER TABLE Events CHANGE COLUMN User person_name VARCHAR(128);
-ALTER TABLE Events RENAME COLUMN User TO person_name;
+-- ALTER TABLE Events RENAME COLUMN User TO person_name;
 ALTER TABLE Events CHANGE COLUMN Date event_when DATETIME ;
 ALTER TABLE Events CHANGE COLUMN Event action VARCHAR(32);
 ALTER TABLE Events CHANGE COLUMN Host ipaddr VARCHAR(16);
@@ -36,5 +37,27 @@ ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64);
 ALTER TABLE Events CHANGE COLUMN action action varchar(64)  default NULL;
 
 ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table);
+
+ALTER TABLE Events ADD INDEX lookup_person_id (person_id);
+
+-- #Keep for later use..
+
+-- ALTER TABLE Events CHANGE COLUMN person_name person_name VARCHAR(128) NOT NULL ;
+
+-- ALTER TABLE Events CHANGE COLUMN event_when event_when DATETIME NOT NULL ;
+
+-- ALTER TABLE Events CHANGE COLUMN action action VARCHAR(64) NOT NULL DEFAULT '';
+
+-- ALTER TABLE Events CHANGE COLUMN ipaddr ipaddr VARCHAR(16) NOT NULL DEFAULT '';
+
+-- ALTER TABLE Events CHANGE COLUMN on_id on_id INT(11) NOT NULL DEFAULT 0 ;
+
+-- ALTER TABLE Events CHANGE COLUMN on_table on_table VARCHAR(64) NOT NULL DEFAULT '';
+
+-- ALTER TABLE Events CHANGE COLUMN person_id person_id INT(11) NOT NULL DEFAULT 0 ;
+
+-- ALTER TABLE Events CHANGE COLUMN remarks remarks TEXT NOT NULL ;
+
+-- ALTER TABLE Events CHANGE COLUMN person_table person_table VARCHAR(64) NOT NULL DEFAULT '';
   
- 
\ No newline at end of file
+