summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2022-02-27 13:04:49 +0100
committerTor Andersson <tor@ccxvii.net>2022-03-05 16:47:03 +0100
commite68627f0e43931e57f9feb92ef0ec79665fc25b9 (patch)
treed992bf68dc33dfa35469a4acba694a15ae75dc9d
parente14ef83261beba09b45baf27e2327be48176e4e3 (diff)
downloadserver-e68627f0e43931e57f9feb92ef0ec79665fc25b9.tar.gz
Use JSON type in schema.
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
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);