--- 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 default '*',
+ scoreMsg varchar,
+ cadence varchar,
+ randomness integer, --for rematch
+ created datetime,
+ drawOffer character default '',
+ rematchOffer character default '',
+ deletedByWhite boolean,
+ deletedByBlack boolean,
+ foreign key (vid) references Variants(id)