Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```CREATE DATABASE IF NOT EXISTS Project02;
- ```USE Project02;
- ```CREATE TABLE Game (
- ```GameID VARCHAR(32) NOT NULL PRIMARY KEY,
- ```GameDate DATETIME NOT NULL,
- ```Score1 VARCHAR(255) NOT NULL,
- ```Score2 VARCHAR(255) NOT NULL,
- ```Score3 VARCHAR(255) NOT NULL,
- ```ScoreDifference VARCHAR(255) NOT NULL,
- ```Stadium CHAR(64) NOT NULL,
- ```Location CHAR(64) NOT NULL
- ```);
- ```CREATE TABLE OpponentTeam (
- ```Name CHAR(64) NOT NULL PRIMARY KEY,
- ```Nickname CHAR(64),
- ```TeamOwner CHAR(64) NOT NULL,
- ```Town CHAR(64) NOT NULL
- ```);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement