diff options
Diffstat (limited to 'server/migrations/20221008120534_init.up.sql')
| -rw-r--r-- | server/migrations/20221008120534_init.up.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql index 8c53bb8..e4b9eb1 100644 --- a/server/migrations/20221008120534_init.up.sql +++ b/server/migrations/20221008120534_init.up.sql @@ -16,6 +16,13 @@ create table active_tables ( id uuid primary key not null ); +create table table_journal ( + table_id uuid references active_tables(id) not null, + seq bigint not null, + payload jsonb +); +create unique index journal_entry on table_journal (table_id, seq); + create type player_position as enum ('west', 'north', 'east', 'south'); create table table_players ( |