PHP Classes

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: Update of sql/postgresql.sql
Date: 4 months ago
Size: 794 bytes


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) );