X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=75e1b1cd8cd17b47b51d04084f0f1a003e7dcfc5;hb=00f2759e16ec73fa1ecd0254a9c9018530d71892;hp=5f463bfc54bb10ffc5785bcf8b7b26cc691c1f21;hpb=9e76c73c4c4f403563e025968934f29b397b53b3;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
index 5f463bfc..75e1b1cd 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -36,6 +36,7 @@ create table Challenges (
 	added datetime,
 	uid integer,
 	vid integer,
+	nbPlayers integer,
 	foreign key (uid) references Users(id),
 	foreign key (vid) references Variants(id)
 );
@@ -44,7 +45,6 @@ create table Challenges (
 create table WillPlay (
 	cid integer,
 	uid integer,
-	yes boolean,
 	foreign key (cid) references Challenges(id),
 	foreign key (uid) references Users(id)
 );
@@ -53,7 +53,7 @@ create table Games (
 	id integer primary key,
 	vid integer,
 	fen varchar, --initial position
-	score varchar,
+	score varchar default '*',
 	foreign key (vid) references Variants(id)
 );