From 2d9d37bd5e4770a05cae780f2113266f3fdd0915 Mon Sep 17 00:00:00 2001
From: Kjetil Orbekk <kj@orbekk.com>
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

