- id integer primary key,
- added datetime,
- uid integer,
- vid integer,
- nbPlayers integer,
- fen varchar,
- mainTime integer,
- addTime integer,
- foreign key (uid) references Users(id),
- foreign key (vid) references Variants(id)
-);
-
--- Store informations about players who accept a challenge
-create table WillPlay (
- cid integer,
- uid integer,
- foreign key (cid) references Challenges(id),
- foreign key (uid) references Users(id)
+ id integer primary key,
+ added datetime,
+ uid integer,
+ target integer,
+ vid integer,
+ fen varchar,
+ timeControl varchar,
+ foreign key (uid) references Users(id),
+ foreign key (vid) references Variants(id)