X-Git-Url: https://git.auder.net/?a=blobdiff_plain;ds=sidebyside;f=server%2Fdb%2Fcreate.sql;h=d18a3105ada0dc22b3b33b3a4e09e5fed85ab9ae;hb=5fde3a01497262862afc4cb4c9457d4e0ad69a4a;hp=a39307251f4a4f652752e347f1a8d76225dbbfd8;hpb=58e7b94e6e1a8d5721b9211b45c40e65fc13f600;p=vchess.git 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 );