-- Add table to store turn time

CREATE TABLE IF NOT EXISTS games.turns (
 game_uid VARCHAR(20) REFERENCES games.games(game_uid),
 turn INT NOT NULL,
 turn_ts TIMESTAMP WITHOUT TIME ZONE NOT NULL,
 CONSTRAINT pk_turns PRIMARY KEY (game_uid, turn)
);
GRANT SELECT, INSERT, UPDATE ON games.turns TO freeorion;