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

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

Revision: 239
          http://gemstracker.svn.sourceforge.net/gemstracker/?rev=239&view=rev
Author:   michieltcs
Date:     2011-11-19 17:59:24 +0000 (Sat, 19 Nov 2011)
Log Message:
-----------
Add table definition to store (failed) token attempts

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

Added: trunk/library/configs/db/tables/gems__token_attempts.10.sql
===================================================================
--- trunk/library/configs/db/tables/gems__token_attempts.10.sql	                        (rev 0)
+++ trunk/library/configs/db/tables/gems__token_attempts.10.sql	2011-11-19 17:59:24 UTC (rev 239)
@@ -0,0 +1,13 @@
+
+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_datetime timestamp not null,
+
+        PRIMARY KEY (gta_id_attempt)
+    )
+    ENGINE=InnoDB
+	AUTO_INCREMENT = 10000
+    CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
+

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