Add game "setups" for automated match making and tournaments.

1 files changed, 11 insertions, 0 deletions

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,