diff options
author | Tor Andersson <tor@ccxvii.net> | 2022-09-11 00:27:54 +0200 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2022-10-05 17:36:50 +0200 |
commit | 9bc6ff25186537ef0e07b0ff559a35c6d629ad31 (patch) | |
tree | 165e788141020ddcbcb83ed1f064b3ab2ca0efeb /schema.sql | |
parent | 5071f6bfa5d4dc1ea50c9b889b5a8ff457a08cfb (diff) | |
download | server-9bc6ff25186537ef0e07b0ff559a35c6d629ad31.tar.gz |
Set affinity of json columns back to "text".
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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); |