[Gemstracker-svn] SF.net SVN: gemstracker:[242] trunk/library/configs/db/tables/ gems__token_attempts.10.sql

[<gem...@li...>]

Revision: 242
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=242&view=rev
Author:   michieltcs
Date:     2011-11-19 18:12:07 +0000 (Sat, 19 Nov 2011)
Log Message:
-----------
IP address column should be varchar

Modified Paths:
--------------
    trunk/library/configs/db/tables/gems__token_attempts.10.sql

Modified: trunk/library/configs/db/tables/gems__token_attempts.10.sql
===================================================================
--- trunk/library/configs/db/tables/gems__token_attempts.10.sql	2011-11-19 18:03:30 UTC (rev 241)
+++ trunk/library/configs/db/tables/gems__token_attempts.10.sql	2011-11-19 18:12:07 UTC (rev 242)
@@ -2,7 +2,7 @@
 CREATE TABLE if not exists gems__token_attempts (
         gta_id_attempt bigint unsigned not null auto_increment,
         gta_id_token varchar(9) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' not null,
-        gta_ip_address int(11) unsigned not null,
+        gta_ip_address varchar(64) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' not null,
         gta_datetime timestamp not null default current_timestamp,
 
         PRIMARY KEY (gta_id_attempt)

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.