-ALTER TABLE Events ADD COLUMN person_name varchar(128) default NULL;
+ALTER TABLE Events ADD COLUMN person_name varchar(128) NOT NULL default '';
ALTER TABLE Events ADD COLUMN event_when DATETIME default NULL;
ALTER TABLE Events ADD COLUMN action varchar(64) NOT NULL default '' ;
--# 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);
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);
-
\ No newline at end of file
+
+
\ No newline at end of file