X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=3cfcbae3557c5cab281bab22bbdbec8666acfaa6;hp=0fb74564bee402f0407d6e6af1c73ed75047be65;hb=92a523d1a74cbabcfd7d6ade45f25fa622815f0b;hpb=cf742aaf8995ca8be8fc1f2751e4cf28de5d69b6 diff --git a/server/db/create.sql b/server/db/create.sql index 0fb74564..3cfcbae3 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -43,7 +43,7 @@ create table Challenges ( foreign key (vid) references Variants(id) ); --- NOTE: no need for a "created" field, it's deduce from first move playing time +-- NOTE: no need for a "created" field, it's deduced from first move playing time create table Games ( id integer primary key, vid integer, @@ -59,7 +59,6 @@ create table Players ( gid integer, uid integer, color character, - rtime integer, --remaining time in milliseconds foreign key (gid) references Games(id), foreign key (uid) references Users(id) );