358a56cc9a
- Extract database schema and migrations into @openreader/database - Extract startup and orchestration scripts into @openreader/bootstrap - Move compute-worker into packages/compute-worker - Remove runtime dependency on drizzle-kit - Update Dockerfile to deploy isolated packages without merging node_modules
5 lines
No EOL
445 B
SQL
5 lines
No EOL
445 B
SQL
ALTER TABLE "user_job_events" ADD CONSTRAINT "user_job_events_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action NOT VALID;--> statement-breakpoint
|
|
DELETE FROM "user_job_events" WHERE NOT EXISTS (
|
|
SELECT 1 FROM "user" WHERE "user"."id" = "user_job_events"."user_id"
|
|
);--> statement-breakpoint
|
|
ALTER TABLE "user_job_events" VALIDATE CONSTRAINT "user_job_events_user_id_user_id_fk"; |