ALTER TABLE Events ADD COLUMN remarks text ;
-#very old code..
+--#very old code..
ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL;
-# this are for pre-postgres support code..
+--# 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 CHANGE COLUMN Date event_when DATETIME ;
ALTER TABLE Events ADD INDEX lookuppt ( person_table);
+--# speeding up lookups.
ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id );