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)
);
-- Store informations about players in a corr game
create table Players (
+ gid integer,
uid integer,
color character,
- gid integer,
- foreign key (uid) references Users(id),
- foreign key (gid) references Games(id)
+ foreign key (gid) references Games(id),
+ foreign key (uid) references Users(id)
);
create table Moves (