X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=e14e9a0fd6650316350244fad8b3b2e4e4c5e317;hb=7ba4a5bc5b64e19a1e7f26aa232d5c50770d07ad;hp=a39307251f4a4f652752e347f1a8d76225dbbfd8;hpb=58e7b94e6e1a8d5721b9211b45c40e65fc13f600;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index a3930725..e14e9a0f 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -17,8 +17,25 @@ create table Users ( notify boolean ); --- All the following tables are for correspondance play only --- (Live games are stored in browser) +create table Problems ( + id integer primary key, + added datetime, + fen varchar, + uid integer, + vid integer, + instruction text, + solution text, + foreign key (uid) references Users(id), + foreign key (vid) references Variants(id) +); + +create table News ( + id integer primary key, + uid integer, + added datetime, + content text, + foreign key (uid) references Users(id) +); create table Challenges ( id integer primary key, @@ -26,8 +43,9 @@ create table Challenges ( uid integer, target integer, vid integer, + randomness integer, fen varchar, - timeControl varchar, + cadence varchar, foreign key (uid) references Users(id), foreign key (vid) references Variants(id) ); @@ -38,16 +56,16 @@ create table Games ( fenStart varchar, --initial state fen varchar, --current state score varchar, - timeControl varchar, - created datetime, --used only for DB cleaning - drawOffer boolean, + scoreMsg varchar, + cadence varchar, + created datetime, + drawOffer character, foreign key (vid) references Variants(id) ); create table Chats ( gid integer, name varchar, - sid varchar, msg varchar, added datetime );