PHP Classes

MySQL Table Def

Recommend this page to a friend!

      multiOTP PHP class  >  All threads  >  MySQL Table Def  >  (Un) Subscribe thread alerts  
Subject:MySQL Table Def
Summary:anyone can show me table definitions
Messages:4
Author:tri
Date:2011-11-12 15:15:10
Update:2013-06-14 17:05:48
 

  1. MySQL Table Def   Reply   Report abuse  
Picture of tri tri - 2011-11-12 15:15:11
anyone can show me table definitions of users,token,and log table structure
used in this class ?.
thanks alot anyway.

  2. Re: MySQL Table Def   Reply   Report abuse  
Picture of moog moog - 2011-11-22 10:31:46 - In reply to message 1 from tri
I'm looking for this answer too ^^

  3. Re: MySQL Table Def - Found   Reply   Report abuse  
Picture of moog moog - 2011-12-28 08:45:22 - In reply to message 2 from moog
Hi, I received an email from Sysco:
« Here is the file. This part of MySQL has been proposed by another member of the community, but it is possible that it changes a little. »

Enjoy,


CREATE TABLE IF NOT EXISTS `multiotp_logs` (
`datetime` datetime default NULL,
`user` varchar(50) default NULL,
`logentry` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `multiotp_tokens` (
`encryption_hash` varchar(32) default NULL,
`token_id` varchar(50) default NULL,
`manufacturer` varchar(50) default NULL,
`token_serial` varchar(50) default NULL,
`issuer` varchar(50) default NULL,
`key_algorithm` varchar(50) default NULL,
`algorithm` varchar(50) default NULL,
`otp` varchar(10) default NULL,
`format` varchar(40) default NULL,
`number_of_digits` int(3) default NULL,
`last_event` int(10) default NULL,
`delta_time` int(10) default NULL,
`time_interval` int(10) default NULL,
`token_seed` varchar(64) default NULL COMMENT 'encrypted',
`last_update` int(10) default NULL,
KEY `pKey` (`token_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `multiotp_users` (
`encryption_hash` varchar(32) default NULL,
`user` varchar(50) default NULL,
`user_pin` varchar(50) default NULL COMMENT 'encrypted',
`email` varchar(200) default NULL,
`algorithm` varchar(4) default NULL,
`time_interval` tinyint(3) default NULL,
`number_of_digits` tinyint(3) default NULL,
`request_prefix_pin` tinyint(1) default NULL,
`generic_user_with_user_in_otp` tinyint(1) default NULL,
`last_login` int(10) default NULL,
`last_event` int(10) default NULL,
`last_error` int(10) default NULL,
`delta_time` int(10) default NULL,
`key_id` varchar(50) default NULL,
`token_seed` varchar(64) default NULL COMMENT 'encrypted',
`error_counter` int(10) default NULL,
`locked` tinyint(1) default NULL,
`last_update` int(10) default NULL,
KEY `pKey` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

  4. Re: MySQL Table Def   Reply   Report abuse  
Picture of André Liechti André Liechti - 2013-06-14 17:05:48 - In reply to message 3 from moog
Hello,

The last beta version of multiOTP is now including a FULL support of MySQL, including the database creation !

To download, have a look on www.multiotp.net, on the left side.

Regards,

André