Add player positions to db

2 files changed, 5 insertions, 2 deletions

diff --git a/server/migrations/20221008120534_init.down.sql b/server/migrations/20221008120534_init.down.sql
index ec1abe4..385537a 100644
--- a/server/migrations/20221008120534_init.down.sql
+++ b/server/migrations/20221008120534_init.down.sql
@@ -1,5 +1,7 @@
 -- Add down migration script here
-drop table if exists players;
+begin;
 drop table if exists sessions;
 drop table if exists table_players;
 drop table if exists active_tables;
+drop table if exists players;
+commit;
diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql
index 6a46f84..729446c 100644
--- a/server/migrations/20221008120534_init.up.sql
+++ b/server/migrations/20221008120534_init.up.sql
@@ -19,6 +19,7 @@ create table active_tables (
 create table table_players (
   active_tables_id	     uuid not null references active_tables (id),
   player_id                  varchar(64) not null references players (id),
-  primary key(active_tables_id, player_id)
+  position		     jsonb,
+  primary key(active_tables_id, player_id, position)
 );
 create unique index player_table on table_players (player_id);