PHP Classes

File: tables.sql

Recommend this page to a friend!
  Classes of Mohamed Elbahja  >  PHP Secure Login Library  >  tables.sql  >  Download  
File: tables.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Secure Login Library
Login users and start sessions in a MySQL database
Author: By
Last change:
Date: 5 years ago
Size: 932 bytes
 

Contents

Class file image Download
--
-- Table structure for table `sls_forgot_password`
--

CREATE TABLE IF NOT EXISTS `sls_forgot_password` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sr_key` varchar(255) NOT NULL,
  `ex_time` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Table structure for table `sls_users`
--

CREATE TABLE IF NOT EXISTS `sls_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `is_verify` enum('0','1') NOT NULL,
  `first_name` varchar(20) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `gender` enum('male','female') NOT NULL,
  `password` varchar(255) NOT NULL,
  `sr_key` varchar(250) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
For more information send a message to info at phpclasses dot org.