- timeControl varchar,
- created datetime, --used only for DB cleaning
- drawOffer character,
- foreign key (vid) references Variants(id)
+ cadence varchar,
+ randomness integer, --for rematch
+ created datetime,
+ drawOffer character default '',
+ rematchOffer character default '',
+ deletedByWhite boolean,
+ deletedByBlack boolean,
+ chatReadWhite datetime,
+ chatReadBlack datetime,
+ foreign key (vid) references Variants(id),
+ foreign key (white) references Users(id),
+ foreign key (black) references Users(id)