X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=0fb74564bee402f0407d6e6af1c73ed75047be65;hb=c0b2760655298f07eb403da70307636e57b2813a;hp=56d4a2476d0f189c121393e4d598a7a66786b982;hpb=bebcc8d45532e67902175f69084a08040f06855f;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index 56d4a247..0fb74564 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -43,6 +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 create table Games ( id integer primary key, vid integer,