From 6c5df51ed4d6cd0adbab53df277102738fccc70d Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
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

