File: database.sql

Recommend this page to a friend!
  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: 7 years ago
Size: 814 bytes


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,

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

For more information send a message to info at phpclasses dot org.