PHP Classes

File: users.sql

Recommend this page to a friend!
  Classes of Dariusz   PHP Registration and Login   users.sql   Download  
File: users.sql
Role: Auxiliary data
Content type: text/plain
Description: Ready sql query to create user table in you MYSQL database
Class: PHP Registration and Login
Manage user registrations and authentication
Author: By
Last change:
Date: 9 years ago
Size: 456 bytes
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `users` (
	`id` 			int(11) 		NOT NULL AUTO_INCREMENT,
    `username` 		varchar(255)	NOT NULL,
    `password` 		varchar(255) 	NOT NULL,
    `sol` 			varchar(8) 		NOT NULL,
    `type` 			tinyint(1) 		NOT NULL DEFAULT "0",
    `blockade` 		tinyint(1) 		NOT NULL DEFAULT "0",
    `email`			varchar(128)	DEFAULT NULL,
    `token`			varchar(16)		NOT NULL,
    `token_activate`tinyint(1)		NOT NULL,
    PRIMARY KEY (`id`)
)