DROP TABLE UserEmails;
DROP TABLE MyUser;

-- user is a reserved word in SQL, so cannot use as name of table
CREATE TABLE MyUser (
	userName  VARCHAR(12) PRIMARY KEY,
	password VARCHAR(20) NOT NULL,
	fullName VARCHAR(30) NOT NULL,
	isAdmin boolean NOT NULL DEFAULT False -- postgreSql specific datatype
);

CREATE TABLE UserEmails (
	userName VARCHAR(12) NOT NULL REFERENCES MyUser(userName),
	email VARCHAR(30) NOT NULL,
	CONSTRAINT UserEmails_PK PRIMARY KEY (userName,email)
);

INSERT INTO MyUser(userName,password,fullname,isAdmin) VALUES
	('okaram','abc123','Orlando Karam',true);

INSERT INTO MyUser(userName,password,fullname) VALUES
	('lcolli','bcd234','Lina Colli');
	
INSERT INTO UserEmails (userName,email) VALUES 
	('okaram','ok@ok.com');
INSERT INTO UserEmails (userName,email) VALUES 
	('okaram','ok@spsu.edu');
INSERT INTO UserEmails (userName,email) VALUES 
	('lcolli','lc@lc.com');