### The ordering of the tables is very important since we create
### foriegn key constraints. 

TABLENAME contact
company_name text NOT NULL default ''
first  text NOT NULL default ''
middle text NOT NULL default ''
last text NOT NULL default ''
email  text NOT NULL default ''
work_phone text NOT NULL default ''
home_phone text NOT NULL default ''
address_1 text NOT NULL default '',
address_2 text NOT NULL default ''
address_3 text NOT NULL default ''
city text NOT NULL default ''
state text NOT NULL default ''
zip text NOT NULL default ''
country text NOT NULL default ''

TABLENAME users
username text NOT NULL default '',
password  text NOT NULL default '',
user_type int4 not null default 1
contact_id int4 not null default 0

  #### These are the classes anybody can make up. 
  #### contact_id refers to the contact person, or the teacher. 
TABLENAME class
time text not null default ''
title text not null default ''
description text not null default ''
users_id int4 not null default 0

  ### Just need two things, the contact id and the class id. 
TABLENAME students
users_id int4 not null default 0
class_id int4 not null default 0