--
-- 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                 
       );

