I am not sure what issue you had with the way it is from the SVN here:
http://code.google.com/p/projecteqem...tricted_aa.sql
It should be:
Code:
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
My guess is your tried sourcing it twice and got an error so you altered it to create a new field named "time" that is just a wasted field.
And no Mort, that is not your problem. Yours should be correct for that field at least. I think cknorth made a mistake somewhere and the SQL he posted is a field he made up as far as I can tell, so it isn't used.