PHP Classes
elePHPant
Icontem

File: sql/sqlite.sql

Recommend this page to a friend!
  Classes of Subin Siby  >  Secure PHP Login System  >  sql/sqlite.sql  >  Download  
File: sql/sqlite.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: 745 bytes
 

 

Contents

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

CREATE TABLE IF NOT EXISTS `users` (
	`id` INTEGER PRIMARY KEY AUTOINCREMENT,
	`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'
);

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

CREATE TABLE IF NOT EXISTS `user_tokens` (
	`token` varchar(40) NOT NULL,
	`uid` INTEGER NOT NULL,
	`requested` varchar(20) NOT NULL
);

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

CREATE TABLE IF NOT EXISTS `user_devices` (
	`id` INTEGER PRIMARY KEY AUTOINCREMENT,
	`uid` INTEGER NOT NULL,
	`token` varchar(15) NOT NULL,
	`last_access` varchar(20) NOT NULL
);