DROP TABLE score IF EXISTS;
--create
create table score (
	score_id INT primary key auto_increment NOT null,
	accuracy INT,
	timer INT,
	wpm INT,
	prompt_id INT NOT NULL,
	uname VARCHAR(50),
	Foreign Key(uname) REFERENCES user(username) ON DELETE SET NULL,
	Foreign Key(prompt_id) REFERENCES prompt(prompt_id)
);

INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (1, 99, 55, 70, 2,'maltofts0');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (2, 79, 29, 100, 1,'maltofts0');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (3, 65, 49, 85, 3,'bmaccardle1');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (4, 84, 65, 30, 1,'tquan2');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (5, 87, 75, 73, 1,'ahearsey4');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (6, 96, 58, 65, 2,'zprandi3');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (7, 91, 39, 99, 5,'ahearsey4');
INSERT INTO score (score_id, accuracy, timer, wpm,prompt_id, name) VALUES (8, 91, 39, 99, 5,'ahearsey4');