projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Some advances in challenge handling (server+client)
[vchess.git]
/
server
/
db
/
create.sql
diff --git
a/server/db/create.sql
b/server/db/create.sql
index
936992c
..
b98cfbb
100644
(file)
--- a/
server/db/create.sql
+++ b/
server/db/create.sql
@@
-38,15
+38,15
@@
create table Challenges (
vid integer,
nbPlayers integer,
fen varchar,
vid integer,
nbPlayers integer,
fen varchar,
- mainTime integer,
- addTime integer,
+ timeControl varchar,
foreign key (uid) references Users(id),
foreign key (vid) references Variants(id)
);
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 (
create table WillPlay (
- cid integer,
+ yes boolean,
+ cid integer,
uid integer,
foreign key (cid) references Challenges(id),
foreign key (uid) references Users(id)
uid integer,
foreign key (cid) references Challenges(id),
foreign key (uid) references Users(id)