XfsYpCsF

1    public static void createPlayerTable(Statement s) throws SQLException {
2
3        String line = "";
4        String values[];
5
6        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));";
7        s.execute(create);
8
9        System.out.println("Player table created");