diff options
Diffstat (limited to 'server/migrations/20221008120534_init.up.sql')
-rw-r--r-- | server/migrations/20221008120534_init.up.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql index 729446c..8c53bb8 100644 --- a/server/migrations/20221008120534_init.up.sql +++ b/server/migrations/20221008120534_init.up.sql @@ -16,10 +16,12 @@ create table active_tables ( id uuid primary key not null ); +create type player_position as enum ('west', 'north', 'east', 'south'); + create table table_players ( active_tables_id uuid not null references active_tables (id), player_id varchar(64) not null references players (id), - position jsonb, + position player_position, primary key(active_tables_id, player_id, position) ); create unique index player_table on table_players (player_id); |