23 lines
575 B
MySQL
23 lines
575 B
MySQL
|
-- Truncate all Prisma-managed application tables in touchbase_test.
|
||
|
|
-- Used by `pnpm verify` to give Playwright a clean fixture-only DB state
|
||
|
|
-- without triggering Prisma's AI-invocation guard on `migrate reset`.
|
||
|
|
-- pg-boss tables (schema "pgboss") are intentionally left alone.
|
||
|
|
TRUNCATE TABLE
|
||
|
|
"AuditLog",
|
||
|
|
"Notification",
|
||
|
|
"Payment",
|
||
|
|
"Booking",
|
||
|
|
"AvailabilityOverride",
|
||
|
|
"WorkingHours",
|
||
|
|
"ServiceTherapist",
|
||
|
|
"Service",
|
||
|
|
"RoomBlock",
|
||
|
|
"RoomTag",
|
||
|
|
"Room",
|
||
|
|
"TherapistTag",
|
||
|
|
"Therapist",
|
||
|
|
"Customer",
|
||
|
|
"VerificationToken",
|
||
|
|
"User"
|
||
|
|
RESTART IDENTITY CASCADE;
|