PHP Classes

File: files/user_table.sql

Recommend this page to a friend!
  Classes of Giulio Bai   User Manager   files/user_table.sql   Download  
File: files/user_table.sql
Role: Auxiliary data
Content type: text/plain
Description: MySQL user table creation
Class: User Manager
Manage and authenticate registered users
Author: By
Last change:
Date: 17 years ago
Size: 435 bytes
 

Contents

Class file image Download 
CREATE TABLE users (

  userid int(11) NOT NULL auto_increment,
  username varchar(50) NOT NULL,
  password varchar(40) NOT NULL,
  email varchar(255) NOT NULL,
  admin int(4) default 1,
  realname varchar(255) default NULL,
  gender varchar(40) NOT NULL,
  website varchar(255) default NULL,
  city varchar(255) default NULL,
  im varchar(255) default " ; ; ; ",
  profile text default NULL,

  PRIMARY KEY  (userid)
);