Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  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. ```);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement