Experimental game upload added

[vchess.git] / server / db / create.sql

diff --git a/server/db/create.sql b/server/db/create.sql
index 7c361b4..56ae4f1 100644 (file)
--- a/server/db/create.sql
+++ b/server/db/create.sql
@@ -68,6 +68,8 @@ create table Games (
   rematchOffer character default '',
   deletedByWhite boolean,
   deletedByBlack boolean,
   rematchOffer character default '',
   deletedByWhite boolean,
   deletedByBlack boolean,

+  chatReadWhite datetime,
+  chatReadBlack datetime,

   foreign key (vid) references Variants(id),
   foreign key (white) references Users(id),
   foreign key (black) references Users(id)
   foreign key (vid) references Variants(id),
   foreign key (white) references Users(id),
   foreign key (black) references Users(id)