X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=82c8659d528087a2b96fbcef78f5257f43fdade2;hb=b7cbbda10f16c2419f9a4d49e219fcface5e5658;hp=0251c176b6e1ab5422c3ce634b79b2343f2311e5;hpb=f41ce5806b989c06091a403d7e26ff3c457650c9;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index 0251c176..82c8659d 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -13,21 +13,10 @@ create table Users ( loginToken varchar, loginTime datetime, sessionToken varchar, + created datetime, notify boolean ); -create table Problems ( - id integer primary key, - added datetime, - uid integer, - vid integer, - fen varchar, - instructions text, - solution text, - foreign key (uid) references Users(id), - foreign key (vid) references Variants(id) -); - -- All the following tables are for correspondance play only -- (Live games are stored in browser) @@ -51,6 +40,8 @@ create table Games ( fen varchar, --current state score varchar, timeControl varchar, + created datetime, --used only for DB cleaning + drawOffer boolean, foreign key (vid) references Variants(id) ); @@ -69,7 +60,6 @@ create table Moves ( message varchar, played datetime, --when was this move played? idx integer, --index of the move in the game - color character, --required for e.g. Marseillais Chess foreign key (gid) references Games(id) );