X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=248e5970335f473c1084b02ce374e743e4d4bdce;hb=7a0c1b7e33a346195caebfdfa6489e7c6d0457e6;hp=e26b03b98903bc55bb142006c9302f14ff0d6b5b;hpb=eaa5ad3e93b761fefb16b32071be0b439761f843;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index e26b03b9..248e5970 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -39,7 +39,7 @@ create table Challenges ( uid integer, target integer, vid integer, - randomness integer, + options varchar, fen varchar, cadence varchar, foreign key (uid) references Users(id), @@ -62,7 +62,7 @@ create table Games ( score varchar default '*', scoreMsg varchar, cadence varchar, - randomness integer, --for rematch + options varchar, --for rematch created datetime, drawOffer character default '', rematchOffer character default '',