--Name:			Timothy Duke Perry
--Course Code:	INTN 2201
--Date:			2014-04-02

-- DROP'ping tables clear out any existing data

-- CREATE the table, note that id has to be unique, and you must have a name
CREATE TABLE users(
	id CHAR(20) PRIMARY KEY,
	password VARCHAR(15) NOT  NULL,
	first_name VARCHAR(20) NOT  NULL,
	last_name VARCHAR(30) NOT  NULL,
	email_address VARCHAR(255) NOT  NULL,
	enrol_date DATE NOT NULL,
	last_access DATE NOT NULL
);
INSERT INTO users(id, password, first_name, last_name, email_address, enrol_date, last_access) VALUES(
	'jdoe',
	'testpass',
	'John',
	'Doe',
	'jdoe@durhamcollege.ca',
	'2014-01-01',
	'2014-02-01');
