PHP Classes
elePHPant
Icontem

File: sql/mysql.sql

Recommend this page to a friend!
  Classes of Subin Siby  >  Secure PHP Login System  >  sql/mysql.sql  >  Download  
File: sql/mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Secure PHP Login System
Register and login users using a database via PDO
Author: By
Last change: Replace spaces indentation with tabs
Date: 2 years ago
Size: 1,171 bytes
 

 

Contents

Class file image Download
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`username` varchar(10) NOT NULL,
	`email` tinytext NOT NULL,
	`password` varchar(255) NOT NULL,
	`name` varchar(30) NOT NULL,
	`created` datetime NOT NULL,
	`attempt` varchar(15) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Table structure for table `user_tokens`
--

CREATE TABLE IF NOT EXISTS `user_tokens` (
	`token` varchar(40) NOT NULL COMMENT 'The generated unique token',
	`uid` int(11) NOT NULL COMMENT 'The User ID',
	`requested` varchar(20) NOT NULL COMMENT 'The date when token was created'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `user_devices`
--

CREATE TABLE IF NOT EXISTS `user_devices` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`uid` int(11) NOT NULL COMMENT 'The user''s ID',
	`token` varchar(15) NOT NULL COMMENT 'A unique token for the user''s device',
	`last_access` varchar(20) NOT NULL,
	PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;