UuxejYB3

1DROP DATABASE IF EXISTS assignment3;
2CREATE DATABASE assignment3;
3USE assignment3;
4
5CREATE TABLE User (
6	userID INT(11) PRIMARY KEY AUTO_INCREMENT,
7	username VARCHAR(50) NOT NULL,
8    passcode VARCHAR(50) NOT NULL
9);
10
11CREATE TABLE SearchHistory (
12	searchID INT(11) PRIMARY KEY AUTO_INCREMENT,
13	FOREIGN KEY (username) REFERENCES User(username),
14    searchQuery VARCHAR(50) NOT NULL
15);