X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=82c8659d528087a2b96fbcef78f5257f43fdade2;hb=b7cbbda10f16c2419f9a4d49e219fcface5e5658;hp=a8c8d687452e8d06d881d953ab3e5eb2eed0acb8;hpb=d431028c73d41a22636130bd6aff562762eaf2bb;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index a8c8d687..82c8659d 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -13,6 +13,7 @@ create table Users ( loginToken varchar, loginTime datetime, sessionToken varchar, + created datetime, notify boolean ); @@ -40,6 +41,7 @@ create table Games ( score varchar, timeControl varchar, created datetime, --used only for DB cleaning + drawOffer boolean, foreign key (vid) references Variants(id) );