data for places and to archive match points

[brisk.git] / sql / sql.d / 050-bin5.sql

diff --git a/sql/sql.d/050-bin5.sql b/sql/sql.d/050-bin5.sql
new file mode 100644 (file)
index 0000000..938d5d3
--- /dev/null
+++ b/sql/sql.d/050-bin5.sql
@@ -0,0 +1,25 @@
+--
+-- briskin5 (bin5) related tables
+--
+
+DROP TABLE #PFX#bin5_matches;
+CREATE TABLE #PFX#bin5_matches (
+       code   SERIAL PRIMARY KEY,
+       ttok   text UNIQUE,              -- token associated to the match
+       tidx   integer                   -- table index
+       );
+
+DROP TABLE #PFX#bin5_games;
+CREATE TABLE #PFX#bin5_games (
+       code   SERIAL PRIMARY KEY,
+       mcode  integer REFERENCES #PFX#bin5_matches (code) ON DELETE cascade ON UPDATE cascade,
+       tstamp timestamp                 -- end game time
+       );
+       
+DROP TABLE #PFX#bin5_points;
+CREATE TABLE #PFX#bin5_points (
+       gcode  integer REFERENCES #PFX#bin5_games (code) ON DELETE cascade ON UPDATE cascade,
+       ucode  integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade, 
+       pts    integer                   -- points                 
+       );
+