- id integer primary key,
- vid integer,
- fenStart varchar, --initial state
- fen varchar, --current state
- score varchar,
- mainTime integer,
- addTime integer,
- foreign key (vid) references Variants(id)
+ id integer primary key,
+ vid integer,
+ fenStart varchar, --initial state
+ fen varchar, --current state
+ white integer,
+ black integer,
+ 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),
+ foreign key (white) references Users(id),
+ foreign key (black) references Users(id)