Login   Register  
PHP Classes
elePHPant
Icontem

File: database.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Andy Dixon  >  PHP SMS Authentication  >  database.sql  >  Download  
File: database.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL
Class: PHP SMS Authentication
Authenticate users once using codes sent via SMS
Author: By
Last change:
Date: 2013-08-02 00:43
Size: 814 bytes
 

Contents

Class file image Download 
DROP TABLE IF EXISTS `authProviderUsers`;
CREATE TABLE `authProviderUsers` (`id` int(11) NOT NULL AUTO_INCREMENT,`apuid` int(20) NOT NULL COMMENT 'Users Foreign id',`secret` varchar(255) NOT NULL COMMENT 'User secret for the request package',`enabled` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `authRequests`;
CREATE TABLE `authRequests` (`id` int(11) NOT NULL AUTO_INCREMENT,`authProviderId` int(11) NOT NULL COMMENT 'Users Foreign id',`username` varchar(128) NOT NULL,`password` varchar(128) NOT NULL,`unixtime` int(11) NOT NULL,`valid` int(11) NOT NULL,`used` int(11) NOT NULL,
PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO `authProviderUsers` VALUES (1,1327804,'parsnip123',1);