PHP Classes

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: Update of sql/mysql.sql
Date: 2 months ago
Size: 1,195 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', PRIMARY KEY (`token`) ) 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 ;