From 5a65b3a653eb4a9ca62332fa65c8d352e6dc782f Mon Sep 17 00:00:00 2001
From: Michael Hunteman <michael@huntm.net>
Date: Sun, 20 Oct 2024 18:52:16 -0700
Subject: Use UUID

---
 server/schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'server/schema.sql')

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
-- 
cgit v1.2.3

