create table contacts (
  name                     varchar(100),
  phone                    varchar(30),
  email                    varchar(255) not null,
  category                 enum('shareholder','web','other'),
  active                   enum('Y','N'),

  record_num               int unsigned not null auto_increment,
  primary key(record_num)
);


create table users (
  userid                   varchar(50) not null,
  password                 varchar(100) not null,
  first_name               varchar(100),
  last_name                varchar(100),
  email                    varchar(200),
  type                     enum('admin','staff','pac','parent'),
  status                   enum('pending','active','inactive','deleted'),
  last_login               datetime,

  record_num               int unsigned not null auto_increment,

  primary key(record_num),
  unique (userid)
);