Use UUID

1 files changed, 4 insertions, 4 deletions

diff --git a/server/schema.sql b/server/schema.sql
index 809d8c9..44881c8 100644
--- a/server/schema.sql
+++ b/server/schema.sql
@@ -1,21 +1,21 @@
 create table guest (
-    id serial PRIMARY KEY,
+    id uuid primary key default gen_random_uuid(),
     first_name varchar(64),
     last_name varchar(64),
-    attendance varchar(8) DEFAULT 'no' NOT NULL,
+    attendance varchar(8) not null,
     email varchar(64),
     message varchar(128),
     party_size integer
 );
 
 create table party (
-    guest_id integer NOT NULL references guest(id) ON DELETE CASCADE,
+    guest_id uuid not null references guest(id) on delete cascade,
     first_name varchar(64),
     last_name varchar(64)
 );
 
 create table admin (
-    id serial PRIMARY KEY,
+    id uuid primary key default gen_random_uuid(),
     username varchar(64),
     password varchar(64)
 )
\ No newline at end of file