summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2022-09-11 00:27:54 +0200
committerTor Andersson <tor@ccxvii.net>2022-10-05 17:36:50 +0200
commit9bc6ff25186537ef0e07b0ff559a35c6d629ad31 (patch)
tree165e788141020ddcbcb83ed1f064b3ab2ca0efeb /schema.sql
parent5071f6bfa5d4dc1ea50c9b889b5a8ff457a08cfb (diff)
downloadserver-9bc6ff25186537ef0e07b0ff559a35c6d629ad31.tar.gz
Set affinity of json columns back to "text".
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
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);