Login   Register  
PHP Classes
elePHPant
Icontem

File: files/user_table.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 7 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)
);