43u9hVLJ

1--DROPPING tables to clear out any existing data 
2DROP TABLE IF EXISTS users;
3
4CREATE TABLE users(
5    id VARCHAR(20) PRIMARY KEY,
6    password VARCHAR(15)NOT NULL,
7    first_name VARCHAR(20)NOT NULL,
8    last_name VARCHAR(30) NOT NULL,
9    email_address VARCHAR(255) NOT NULL,
10    enrol_date DATE NOT NULL,
11    last_access DATE NOT NULL
12);
13
14INSERT INTO users(id, password, first_name, last_name, email_address, enrol_date)
15    'jdoe',
16    'testpass',
17    'John',
18    'Doe',
19    'jdoe@durhamcollege.ca',
20    '2019-1-1'
21    '2019-2-1');
22INSERT INTO users(id, password, first_name, last_name, email_address, enrol_date)
23    'dslotegraaf',
24    'deanna1999',
25    'Deanna',
26    'Slotegraaf',
27    'deanna.slotegraaf@dcmail.ca',
28    '2019-3-1',
29    '2019-3-1');
30INSERT INTO users(id, password, first_name, last_name, email_address, enrol_date)
31    'jbrown', 
32    'jellybean',
33    'Jane',
34    'Brown',
35    'jane.brown@dcmail.ca',
36    '2019-3-1',
37    '2019-3-1');