PHP Classes
elePHPant
Icontem

File: sql/postgresql.sql

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

 

Contents

Class file image Download
SET TIME ZONE 'UTC';

--
-- Table structure for table users
--

CREATE TABLE IF NOT EXISTS users (
	id SERIAL,
	username text NOT NULL,
	email text NOT NULL,
	password text NOT NULL,
	name text NOT NULL,
	created text NOT NULL,
	attempt text NOT NULL DEFAULT '0',
	PRIMARY KEY (id)
);

--
-- Table structure for table user_tokens
--

CREATE TABLE IF NOT EXISTS user_tokens (
	token text NOT NULL, -- 'The Unique Token Generated'
	uid integer NOT NULL, -- 'The User Id'
	requested text NOT NULL -- 'The Date when token was created'
);

--
-- Table structure for table user_devices
--

CREATE TABLE IF NOT EXISTS user_devices (
	id SERIAL,
	uid int NOT NULL, -- The user's ID
	token character(15) NOT NULL, -- A unique token for the user's device
	last_access text NOT NULL,
	PRIMARY KEY (id)
);