X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=8f3daa84884caaa23e3c370a301df12aba2c330d;hb=afde76668963c4d0d96002fcae2ebabb9acf81e4;hp=b7b76c9b327ea9323c4565382c411dfbf1154a51;hpb=714680114508183fba2c07231dbe8f90b5631b81;p=vchess.git diff --git a/server/db/create.sql b/server/db/create.sql index b7b76c9b..8f3daa84 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,6 +43,7 @@ create table Challenges ( uid integer, target integer, vid integer, + randomness integer, fen varchar, cadence varchar, foreign key (uid) references Users(id), @@ -37,11 +55,15 @@ create table Games ( vid integer, fenStart varchar, --initial state fen varchar, --current state - score varchar, + score varchar default '*', scoreMsg varchar, cadence varchar, + randomness integer, --for rematch created datetime, - drawOffer character, + drawOffer character default '', + rematchOffer character default '', + deletedByWhite boolean, + deletedByBlack boolean, foreign key (vid) references Variants(id) );