Replace news by FAQ

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

diff --git a/server/db/create.sql b/server/db/create.sql
index 7c361b4..84b72b9 100644 (file)
--- a/server/db/create.sql
+++ b/server/db/create.sql
@@ -31,14 +31,6 @@ create table Problems (
   foreign key (vid) references Variants(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,
   added datetime,
 create table Challenges (
   id integer primary key,
   added datetime,


@@ -68,6 +60,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)