score varchar,
timeControl varchar,
created datetime, --used only for DB cleaning
+ drawOffer boolean,
foreign key (vid) references Variants(id)
);
+create table Chats (
+ gid integer,
+ uid integer,
+);
+
-- Store informations about players in a corr game
create table Players (
gid integer,
create table Moves (
gid integer,
squares varchar, --description, appear/vanish/from/to
- message varchar,
played datetime, --when was this move played?
idx integer, --index of the move in the game
foreign key (gid) references Games(id)