Commit: e6700f9eeddc1b1a7c0573aa48e0082eb650881b Author: Peter Kokot <peterko...@gmail.com> Mon, 22 Oct 2018 11:45:22 +0200 Parents: 70d522f5a04da22c68ab62fbd8c63edf27f33987 Branches: master
Link: http://git.php.net/?p=web/bugs.git;a=commitdiff;h=e6700f9eeddc1b1a7c0573aa48e0082eb650881b Log: Change visitor_ip MySQL field type to varbinary(16) This now enables local installation more easily without manually adjusting the field. The new varbinary field has been recently updated in the code for reporting bugs and adding comments. Changed paths: M sql/bugs.sql Diff: diff --git a/sql/bugs.sql b/sql/bugs.sql index e7ad186..1180125 100644 --- a/sql/bugs.sql +++ b/sql/bugs.sql @@ -21,7 +21,7 @@ CREATE TABLE bugdb ( block_user_comment char(1) default 'N', cve_id varchar(15) default NULL, private char(1) default 'N', - visitor_ip int(10) unsigned NOT NULL, + visitor_ip varbinary(16) NOT NULL, PRIMARY KEY (id), KEY php_version (php_version(1)), KEY status (status), @@ -37,7 +37,7 @@ CREATE TABLE bugdb_comments ( ts datetime NOT NULL default CURRENT_TIMESTAMP, comment text NOT NULL, comment_type varchar(10) default 'comment', - visitor_ip int(8) UNSIGNED NOT NULL, + visitor_ip varbinary(16) NOT NULL, PRIMARY KEY (id), KEY bug (bug,id,ts), FULLTEXT KEY comment (comment) -- PHP Webmaster List Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php