install/schemas/upgrade/migration/1.0-1.1-mysql.sql
changeset 377 bb3e6c3bd4f4
parent 354 979d99a0b00e
child 406 7468a663315f
--- 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,