From 5a65b3a653eb4a9ca62332fa65c8d352e6dc782f Mon Sep 17 00:00:00 2001 From: Michael Hunteman 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