diff options
author | Tor Andersson <tor@ccxvii.net> | 2022-02-27 13:04:49 +0100 |
---|---|---|
committer | Tor Andersson <tor@ccxvii.net> | 2022-03-05 16:47:03 +0100 |
commit | e68627f0e43931e57f9feb92ef0ec79665fc25b9 (patch) | |
tree | d992bf68dc33dfa35469a4acba694a15ae75dc9d | |
parent | e14ef83261beba09b45baf27e2327be48176e4e3 (diff) | |
download | server-e68627f0e43931e57f9feb92ef0ec79665fc25b9.tar.gz |
Use JSON type in schema.
-rw-r--r-- | schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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); |