X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=db%2Fcreate.sql;h=5f463bfc54bb10ffc5785bcf8b7b26cc691c1f21;hp=e94b84a3edce38bd821ad1eac2cd3d4e41b8a32c;hb=fd08ab2c5b8931bb8c95cf7e9f2f95122647f991;hpb=2305d34a3f2ab561c20b1fcb7349320145ac1f5c

diff --git a/db/create.sql b/db/create.sql
index e94b84a3..5f463bfc 100644
--- 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 (
+	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 (