#
# File: create_users.sql
#
# SQL for creating a users table
#
# (c) 2003 ComputerTorture.com
#


CREATE TABLE users (
  id int(11) NOT NULL auto_increment,

  email varchar(100) NOT NULL default '',
  password varchar(30) default '' NOT NULL,

  title enum('Dr','Mr','Mrs','Miss','Ms','Sir','Master','Rt. Hon') default NULL,
  initials varchar(10) default NULL,
  forename varchar(30) default '' NOT NULL,
  surname varchar(40) default '' NOT NULL,
  organisation varchar(50) default '' NOT NULL,

  enabled enum('yes','no') NOT NULL default 'yes',
  superuser enum('yes','no') NOT NULL default 'no',

  last_login_time            DATETIME,
  session_key                varchar(50) NOT NULL,

  UNIQUE(email),

  PRIMARY KEY  (id)
) TYPE=MyISAM;