summaryrefslogtreecommitdiff
path: root/tools/sql/schema.txt
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2021-11-07 18:47:37 +0100
committerTor Andersson <tor@ccxvii.net>2021-11-07 20:21:28 +0100
commit7777850fd868b6b24f64dcd6b5942cc6c4423c95 (patch)
tree726b848fff9226b9dbac4920046c6c8ccf72f355 /tools/sql/schema.txt
parent2fd3282e463f43b536facc5d6578acb5c3bbf95d (diff)
downloadserver-7777850fd868b6b24f64dcd6b5942cc6c4423c95.tar.gz
Add options to game setup.
Diffstat (limited to 'tools/sql/schema.txt')
-rw-r--r--tools/sql/schema.txt2
1 files changed, 2 insertions, 0 deletions
diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt
index 1623ec3..da77956 100644
--- a/tools/sql/schema.txt
+++ b/tools/sql/schema.txt
@@ -43,6 +43,7 @@ CREATE TABLE IF NOT EXISTS games (
game_id INTEGER PRIMARY KEY,
title_id TEXT,
scenario TEXT,
+ options TEXT,
owner_id INTEGER,
private BOOLEAN,
random BOOLEAN,
@@ -149,6 +150,7 @@ CREATE VIEW game_view AS
, games.title_id
, titles.title_name
, games.scenario
+ , games.options
, games.owner_id
, owner.name AS owner_name
, players.player_names