X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=248e5970335f473c1084b02ce374e743e4d4bdce;hp=e26b03b98903bc55bb142006c9302f14ff0d6b5b;hb=eb2d61de8d569470fa329a484efe9bab420b2b82;hpb=d807470f965d4d60a7fe6e1320ac7dfd3f0ea03f 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 '',