From 6c5df51ed4d6cd0adbab53df277102738fccc70d Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Thu, 5 Oct 2023 15:05:30 +0200 Subject: Add game "setups" for automated match making and tournaments. --- schema.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 04c613b..4c64ecd 100644 --- a/schema.sql +++ b/schema.sql @@ -198,6 +198,16 @@ create view player_rating_view as left join ratings using(title_id, user_id) ; +create table if not exists setups ( + setup_id integer primary key, + setup_name text, + title_id text, + player_count integer, + scenario text, + options text, + unique (title_id, player_count, scenario) +); + -- Friend and Block Lists -- create table if not exists contacts ( @@ -356,6 +366,7 @@ create table if not exists games ( pace integer default 0, is_private boolean default 0, is_random boolean default 0, + is_match boolean default 0, ctime datetime default current_timestamp, mtime datetime default current_timestamp, -- cgit v1.2.3