6rtryMWx

1String create = "create table IF NOT EXISTS Club(ClubName VARCHAR(20) NOT NULL, Address VARCHAR(40), DateFormed DATE, PRIMARY KEY(ClubName)) "; 
2
3 String create = "CREATE TABLE IF NOT EXISTS Player (PlayerName VARCHAR (20) NOT NULL, DateOfBirth DATE, FIDERating INT not null, check(FIDERating <=3000 AND FIDERating >= 800), FIDETitle VARCHAR(30), ClubName VARCHAR(30), PRIMARY KEY(PlayerName), FOREIGN KEY(ClubName) REFERENCES Club(ClubName));";
4
5String create = "CREATE TABLE IF NOT EXISTS Game (GameID VARCHAR(10), DatePlayed DATE, BoardNum INT, Score VARCHAR(3), MatchID VARCHAR(10), WhitePlayer VARCHAR(20), BlackPlayer VARCHAR(20), PRIMARY KEY(GameID), FOREIGN KEY(MatchID) REFERENCES TblMatch(MatchID));";
6
7String create = "CREATE TABLE IF NOT EXISTS TBLMatch(MatchID VARCHAR(10) PRIMARY KEY, MatchDate DATE, Venue VARCHAR(20), Score VARCHAR(3), WinningClub VARCHAR(20), LosingClub VARCHAR(20))";