From e68627f0e43931e57f9feb92ef0ec79665fc25b9 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sun, 27 Feb 2022 13:04:49 +0100
Subject: Use JSON type in schema.

---
 schema.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index ca69ecd..4967797 100644
--- a/schema.sql
+++ b/schema.sql
@@ -223,7 +223,7 @@ create table if not exists games (
 	title_id text
 		references titles,
 	scenario text,
-	options text,
+	options json,
 	owner_id integer
 		references users,
 	ctime timestamp
@@ -248,7 +248,7 @@ create table if not exists game_state (
 			on delete cascade,
 	mtime timestamp,
 	active text,
-	state text
+	state json
 );
 
 create table if not exists game_chat (
@@ -283,7 +283,7 @@ create table if not exists game_replay (
 		default current_timestamp,
 	role text,
 	action text,
-	arguments text
+	arguments json
 );
 
 create index if not exists game_replay_idx on game_replay(game_id);
-- 
cgit v1.2.3