Index: branches/5.2.x/install/install_schema.sql =================================================================== diff -u -r14252 -r16834 --- branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 14252) +++ branches/5.2.x/install/install_schema.sql (.../install_schema.sql) (revision 16834) @@ -1,6 +1,6 @@ CREATE TABLE Posting ( PostingId int(11) NOT NULL AUTO_INCREMENT, - IPAddress varchar(255) NOT NULL DEFAULT '', + IPAddress varchar(50) NOT NULL DEFAULT '', PosterAlias varchar(255) NOT NULL DEFAULT '', Pending tinyint(4) NOT NULL DEFAULT '0', `Subject` varchar(255) DEFAULT NULL, @@ -172,7 +172,7 @@ GuestEmail varchar(255) NOT NULL DEFAULT '', CommentBody text, CreatedOn int(11) DEFAULT NULL, - UserIP varchar(255) NOT NULL DEFAULT '', + UserIP varchar(50) NOT NULL DEFAULT '', Priority int(11) NOT NULL DEFAULT '0', `Status` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (CommentId), @@ -189,10 +189,10 @@ PollId int(11) NOT NULL DEFAULT '0', AnswerId int(11) NOT NULL DEFAULT '0', CreatedById int(11) NOT NULL DEFAULT '-2', - UserIP varchar(255) NOT NULL DEFAULT '', + UserIP varchar(50) NOT NULL DEFAULT '', AnswerDate int(10) unsigned DEFAULT NULL, PRIMARY KEY (StatisticsId), KEY AnswerId (AnswerId,PollId), KEY CreatedById (CreatedById), KEY UserIP (UserIP) -); \ No newline at end of file +);