Changes between Version 4 and Version 5 of AdvancedDatabaseDevelopment

Timestamp:

05/28/26 04:31:55 (6 hours ago)

Author:

181201

Comment:

--

AdvancedDatabaseDevelopment

@@ -81 +81 @@
   END IF;
 
-  -- Block reviews for bookings that arent completed
-  IF v_booking_status <> 'Completed' THEN
-    RAISE EXCEPTION 'Cannot leave a review for a booking that is % (Must be Completed)', v_booking_status;
+  -- Block reviews for bookings that arent completed or reviewed
+  IF v_booking_status NOT IN ('Completed', 'Reviewed') THEN
+    RAISE EXCEPTION 'Cannot leave a review for a booking that is % (Must be Completed or Reviewed)', v_booking_status;
   END IF;
 
@@ -198 +198 @@
 SELECT cron.schedule('petsitter_expire_bookings', '0 * * * *', $$CALL project.petsitter_job_expire_pending_bookings();$$);
 }}}
+
+'''Constraints Update'''
+{{{
+ALTER TABLE project.bookings DROP CONSTRAINT IF EXISTS bookings_status_check;
+ALTER TABLE project.bookings ADD CONSTRAINT bookings_status_check CHECK (status IN ('Pending', 'Confirmed', 'Completed', 'Canceled', 'Expired', 'Reviewed', 'Rejected'));
+}}}