Implement DbJournal

1 files changed, 4 insertions, 4 deletions

diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql
index e4b9eb1..db9fd3c 100644
--- a/server/migrations/20221008120534_init.up.sql
+++ b/server/migrations/20221008120534_init.up.sql
@@ -16,12 +16,12 @@ create table active_tables (
   id			     uuid primary key not null
 );
 
-create table table_journal (
-  table_id			uuid references active_tables(id) not null,
+create table object_journal (
+  id   	     			uuid not null,
   seq				bigint not null,
-  payload			jsonb
+  payload			jsonb not null
 );
-create unique index journal_entry on table_journal (table_id, seq);
+create unique index journal_entry on object_journal (id, seq);
 
 create type player_position as enum ('west', 'north', 'east', 'south');