6xyxqY47

1```CREATE DATABASE IF NOT EXISTS Project02;
2```USE Project02;
3```CREATE TABLE Game (
4```GameID VARCHAR(32) NOT NULL PRIMARY KEY,
5```GameDate DATETIME NOT NULL,
6```Score1 VARCHAR(255) NOT NULL,
7```Score2 VARCHAR(255) NOT NULL,
8```Score3 VARCHAR(255) NOT NULL,
9```ScoreDifference VARCHAR(255) NOT NULL,
10```Stadium CHAR(64) NOT NULL,
11```Location CHAR(64) NOT NULL
12```);
13```CREATE TABLE OpponentTeam (
14```Name CHAR(64) NOT NULL PRIMARY KEY,
15```Nickname CHAR(64),
16```TeamOwner CHAR(64) NOT NULL,
17```Town CHAR(64) NOT NULL
18```);