added datetime,
uid integer,
vid integer,
+ nbPlayers integer,
foreign key (uid) references Users(id),
foreign key (vid) references Variants(id)
);
create table WillPlay (
cid integer,
uid integer,
- yes boolean,
foreign key (cid) references Challenges(id),
foreign key (uid) references Users(id)
);
id integer primary key,
vid integer,
fen varchar, --initial position
- score varchar,
+ score varchar default '*',
foreign key (vid) references Variants(id)
);