X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=56d4a2476d0f189c121393e4d598a7a66786b982;hp=e5cbfd7e54b29b3ef0cf058c0153178a07f3424e;hb=bebcc8d45532e67902175f69084a08040f06855f;hpb=6e3a7e26d57f60480b08abed7441963674a79b18 diff --git a/server/db/create.sql b/server/db/create.sql index e5cbfd7e..56d4a247 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -29,7 +29,7 @@ create table Problems ( ); -- All the following tables are for correspondance play only --- (Live games are stored only in browsers) +-- (Live games are stored in browser) create table Challenges ( id integer primary key, @@ -49,8 +49,7 @@ create table Games ( fenStart varchar, --initial state fen varchar, --current state score varchar, - mainTime integer, - addTime integer, + timeControl varchar, foreign key (vid) references Variants(id) );