X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fcreate.sql;h=d18a3105ada0dc22b3b33b3a4e09e5fed85ab9ae;hp=a39307251f4a4f652752e347f1a8d76225dbbfd8;hb=dcd68c4108412f45b8ce119ae80ce8f6e296800b;hpb=050ae3b58673dfa1ed41bf78d935fe95ec9e74c5 diff --git a/server/db/create.sql b/server/db/create.sql index a3930725..d18a3105 100644 --- a/server/db/create.sql +++ b/server/db/create.sql @@ -38,6 +38,7 @@ create table Games ( fenStart varchar, --initial state fen varchar, --current state score varchar, + scoreMsg varchar, timeControl varchar, created datetime, --used only for DB cleaning drawOffer boolean, @@ -47,7 +48,6 @@ create table Games ( create table Chats ( gid integer, name varchar, - sid varchar, msg varchar, added datetime );