X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=b7b76c9b327ea9323c4565382c411dfbf1154a51;hp=21c7728b202071faab72d7b8437a3cc3f3dfa75f;hb=714680114508183fba2c07231dbe8f90b5631b81;hpb=8418f0d79395f40172b11d62eef8b83112f1d240 diff --git a/server/db/create.sql b/server/db/create.sql index 21c7728b..b7b76c9b 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -27,7 +27,7 @@ create table Challenges ( target integer, vid integer, fen varchar, - timeControl varchar, + cadence varchar, foreign key (uid) references Users(id), foreign key (vid) references Variants(id) ); @@ -39,8 +39,8 @@ create table Games ( fen varchar, --current state score varchar, scoreMsg varchar, - timeControl varchar, - created datetime, --used only for DB cleaning + cadence varchar, + created datetime, drawOffer character, foreign key (vid) references Variants(id) );