X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=0fb74564bee402f0407d6e6af1c73ed75047be65;hp=56d4a2476d0f189c121393e4d598a7a66786b982;hb=c0b2760655298f07eb403da70307636e57b2813a;hpb=fd7aea36b8da702df87be3ed055f9a1f59c9f4da 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,