PHP Classes

File: examples/users.sql

Recommend this page to a friend!
  Classes of Oleg Zorin  >  PHP User Login class  >  examples/users.sql  >  Download  
File: examples/users.sql
Role: Auxiliary data
Content type: text/plain
Description: Test sql user table dump
Class: PHP User Login class
Register, login and recover users in a database
Author: By
Last change:
Date: 5 years ago
Size: 406 bytes
 

Contents

Class file image Download 
CREATE TABLE `users` (
  `userID` int(11) NOT NULL,
  `login` varchar(30) NOT NULL,
  `password` char(64) NOT NULL,
  `session_key` char(32) DEFAULT NULL,
  `group` tinyint(4) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `mail` varchar(30) DEFAULT NULL
) DEFAULT CHARSET=utf8;

ALTER TABLE `users`
  ADD PRIMARY KEY (`userID`);

ALTER TABLE `users`
  MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;
For more information send a message to info at phpclasses dot org.