--- a/install/schemas/upgrade/migration/1.0-1.1-mysql.sql Sat Jan 26 11:51:19 2008 -0500
+++ b/install/schemas/upgrade/migration/1.0-1.1-mysql.sql Sat Jan 26 15:42:32 2008 -0500
@@ -13,6 +13,8 @@
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_lang smallint(5) NOT NULL;
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_has_avatar tinyint(1) NOT NULL;
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN avatar_type ENUM('jpg', 'png', 'gif') NOT NULL;
+ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_registration_ip varchar(39);
+ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN ip_address varchar(39);
CREATE TABLE {{TABLE_PREFIX}}lockout(
id int(12) NOT NULL auto_increment,