db_query.txt

CREATE TABLE Account(
    ID INT NOT NULL AUTO_INCREMENT,
    Username VARCHAR(255),
    Password VARCHAR(255),
    PRIMARY KEY(ID)
);

CREATE TABLE Game(
    ID INT NOT NULL AUTO_INCREMENT,
    Player1 INT NOT NULL,
    Player2 INT NOT NULL,
    TurnNumber INT,
    PlayerTurn INT,
    NextSquare INT,
    Winner INT,
    LastUpdate DATETIME,
    PRIMARY KEY(ID),
    FOREIGN KEY(Player1) REFERENCES Account(ID),
    FOREIGN KEY(Player2) REFERENCES Account(ID),
    FOREIGN KEY(PlayerTurn) REFERENCES Account(ID)
);

CREATE TABLE Square(
    ID INT NOT NULL AUTO_INCREMENT,
    GameID INT NOT NULL,
    LocalOrder INT NOT NULL,
    Owner INT,
    PRIMARY KEY(ID),
    FOREIGN KEY(GameID) REFERENCES Game(ID)
);

CREATE TABLE Cell(
    ID INT NOT NULL AUTO_INCREMENT,
    SquareID INT NOT NULL,
    GameID INT NOT NULL,
    LocalOrder INT NOT NULL,
    Owner INT,
    TurnNumber INT,
    PRIMARY KEY(ID),
    FOREIGN KEY (SquareID) REFERENCES Square(ID),
    FOREIGN KEY (GameID) REFERENCES Game(ID)
);