From 2d9d37bd5e4770a05cae780f2113266f3fdd0915 Mon Sep 17 00:00:00 2001 From: Kjetil Orbekk Date: Sat, 15 Oct 2022 09:34:44 -0400 Subject: Add table creation --- server/migrations/20221008120534_init.up.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'server/migrations/20221008120534_init.up.sql') 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); -- cgit v1.2.3