X-Git-Url: https://git.auder.net/?a=blobdiff_plain;ds=sidebyside;f=server%2Fdb%2Fcreate.sql;h=b98cfbb0753f9766f862367341feb76f587a5335;hb=052d17ea6e199533cefb11f1ef51020b55cb1382;hp=936992ce3289d0130dc627ef2eb081bb2a7f0014;hpb=8ef2edfa55bb960cfdebe99c99f781173d8da913;p=vchess.git

diff --git a/server/db/create.sql b/server/db/create.sql
index 936992ce..b98cfbb0 100644
--- a/server/db/create.sql
+++ b/server/db/create.sql
@@ -38,15 +38,15 @@ create table Challenges (
 	vid integer,
 	nbPlayers integer,
 	fen varchar,
-	mainTime integer,
-	addTime integer,
+	timeControl varchar,
 	foreign key (uid) references Users(id),
 	foreign key (vid) references Variants(id)
 );
 
--- Store informations about players who accept a challenge
+-- Store informations about players who (potentially) accept a challenge
 create table WillPlay (
-	cid integer,
+	yes boolean,
+  cid integer,
 	uid integer,
 	foreign key (cid) references Challenges(id),
 	foreign key (uid) references Users(id)