260d79fc99
- Added cancelPublicBooking handler to manage booking cancellations. - Updated public booking service to include cancellation logic. - Created cancelPublicBooking schema for input validation. - Modified public booking confirmation page to allow users to cancel their bookings. - Enhanced email service to send cancellation confirmation emails. - Made customerEmail field required in booking schemas and updated related components. - Updated API client to support cancellation requests. - Added migration to enforce non-nullable customer_email fields in the database.
17 lines
746 B
SQL
17 lines
746 B
SQL
/*
|
|
Warnings:
|
|
|
|
- Made the column `customer_email` on table `court_booking_logs` required. This step will fail if there are existing NULL values in that column.
|
|
- Made the column `customer_email` on table `court_bookings` required. This step will fail if there are existing NULL values in that column.
|
|
|
|
*/
|
|
-- Backfill existing NULL values with placeholder
|
|
UPDATE "court_booking_logs" SET "customer_email" = 'missing@playzer.app' WHERE "customer_email" IS NULL;
|
|
UPDATE "court_bookings" SET "customer_email" = 'missing@playzer.app' WHERE "customer_email" IS NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "court_booking_logs" ALTER COLUMN "customer_email" SET NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "court_bookings" ALTER COLUMN "customer_email" SET NOT NULL;
|