Add database conversion for bridge types

1 files changed, 5 insertions, 2 deletions

diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql
index db9fd3c..05b7697 100644
--- a/server/migrations/20221008120534_init.up.sql
+++ b/server/migrations/20221008120534_init.up.sql
@@ -16,6 +16,11 @@ create table active_tables (
   id			     uuid primary key not null
 );
 
+create type player_position as enum ('west', 'north', 'east', 'south');
+create type suit as enum ('club', 'diamond', 'heart', 'spade');
+create domain rank smallint check (value between 2 and 14);
+
+-- TODO: Remove this.
 create table object_journal (
   id   	     			uuid not null,
   seq				bigint not null,
@@ -23,8 +28,6 @@ create table object_journal (
 );
 create unique index journal_entry on object_journal (id, seq);
 
-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),