--- Store informations about players who (potentially) accept a challenge
-create table WillPlay (
- yes boolean,
- cid integer,
- uid integer,
- foreign key (cid) references Challenges(id),
- foreign key (uid) references Users(id)
+create table Games (
+ id integer primary key,
+ vid integer,
+ fenStart varchar, --initial state
+ fen varchar, --current state
+ score varchar,
+ scoreMsg varchar,
+ timeControl varchar,
+ created datetime, --used only for DB cleaning
+ drawOffer character,
+ foreign key (vid) references Variants(id)