From 9bc6ff25186537ef0e07b0ff559a35c6d629ad31 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sun, 11 Sep 2022 00:27:54 +0200
Subject: Set affinity of json columns back to "text".

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

(limited to 'schema.sql')

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

