DROP TABLE members CASCADE;
CREATE TABLE members (
	login_id VARCHAR(50) PRIMARY KEY,
	passwd VARCHAR(50),
	full_name VARCHAR(50), 
	email VARCHAR(50)
);

INSERT INTO members (email, passwd, login_id, full_name) VALUES ('bobuser@localhost', 'bobPassword', 'bob', 'bob the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('user1@localhost', 'user1Password', 'userLogin1', 'user1 the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('user2@localhost', 'user2Password', 'userLogin2', 'user2 the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('user3@localhost', 'user3Password', 'userLogin3', 'user3 the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('user4@localhost', 'user4Password', 'userLogin4', 'user4 the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('user5@localhost', 'user5Password', 'userLogin5', 'user5 the target');
INSERT INTO members (email, passwd, login_id, full_name) VALUES ('hacker@localhost', 'hackerPassword', 'hackerLogin5', 'I am the hacker');

DROP TABLE address CASCADE;
CREATE TABLE address (
	login_id VARCHAR(50) REFERENCES members(login_id),
	line1 VARCHAR(50),
	line2 VARCHAR(50),
	city VARCHAR(50), 
	postalCode VARCHAR(6)
);

insert into address values ('bob', '1 maple street', '', 'Toronto', 'L5L1B6');
