Experimental change: options replacing randomness (more general)

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

diff --git a/server/db/create.sql b/server/db/create.sql
index 533e0f2..248e597 100644 (file)
--- a/server/db/create.sql
+++ b/server/db/create.sql
@@ -3,7 +3,10 @@
 create table Variants (
   id integer primary key,
   name varchar unique,
 create table Variants (
   id integer primary key,
   name varchar unique,

-  description text
+  display varchar,
+  groupe integer,
+  description text,
+  noProblems boolean

 );
 
 create table Users (
 );
 
 create table Users (


@@ -15,7 +18,7 @@ create table Users (
   sessionToken varchar,
   created datetime,
   notify boolean,
   sessionToken varchar,
   created datetime,
   notify boolean,

-  newsRead datetime
+  bio text default ''

 );
 
 create table Problems (
 );
 
 create table Problems (


@@ -30,27 +33,25 @@ 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,
   uid integer,
   target integer,
   vid integer,
 create table Challenges (
   id integer primary key,
   added datetime,
   uid integer,
   target integer,
   vid integer,

-  randomness integer,
+  options varchar,

   fen varchar,
   cadence varchar,
   foreign key (uid) references Users(id),
   foreign key (vid) references Variants(id)
 );
 
   fen varchar,
   cadence varchar,
   foreign key (uid) references Users(id),
   foreign key (vid) references Variants(id)
 );
 

+create table GameStat (
+  vid integer,
+  total integer default 0,
+  foreign key (vid) references Variants(id)
+);
+

 create table Games (
   id integer primary key,
   vid integer,
 create table Games (
   id integer primary key,
   vid integer,


@@ -61,12 +62,14 @@ create table Games (
   score varchar default '*',
   scoreMsg varchar,
   cadence varchar,
   score varchar default '*',
   scoreMsg varchar,
   cadence varchar,

-  randomness integer, --for rematch
+  options varchar, --for rematch

   created datetime,
   drawOffer character default '',
   rematchOffer character default '',
   deletedByWhite boolean,
   deletedByBlack boolean,
   created datetime,
   drawOffer character default '',
   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)