
 
create table prompt (
  prompt_id INT primary key auto_increment NOT null,
	language VARCHAR(100),
	length VARCHAR(50),
	code VARCHAR(50)
);

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

insert into prompt(prompt_id, language, length, code) VALUES ('1','python','short', "# This program adds two numbers

num1 = 1.5
num2 = 6.3

# Add two numbers
sum = num1 + num2");

insert into prompt(prompt_id, language, length, code) VALUES ('2','python','med', "# Store input numbers
num1 = input('Enter first number: ')
num2 = input
('Enter second number: ')

# Add two numbers
sum = float(num1) + float(num2)

# Display the sum
print('The sum of {0} and {1} is {2}'.format(num1, num2, sum))");
