projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Some advances. TODO: test board.js, and then game.js, and then implement room.js
[vchess.git]
/
db
/
create.sql
diff --git
a/db/create.sql
b/db/create.sql
index
e94b84a
..
5f463bf
100644
(file)
--- a/
db/create.sql
+++ b/
db/create.sql
@@
-59,11
+59,11
@@
create table Games (
-- Store informations about players in a corr game
create table Players (
-- Store informations about players in a corr game
create table Players (
+ gid integer,
uid integer,
color character,
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 (
);
create table Moves (