Roo-Code/packages/db/drizzle/0003_good_sauron.sql
Matt Rubens 17ce731867
Prototype of a Roomote tab (#147)
Co-authored-by: cte <cestreich@gmail.com>
Co-authored-by: Roomote <chris@roocode.com>
Co-authored-by: John Richmond <5629+jr@users.noreply.github.com>
2025-07-07 10:52:18 -07:00

5 lines
No EOL
571 B
SQL

DELETE FROM "cloud_jobs";--> statement-breakpoint
ALTER TABLE "cloud_jobs" ADD COLUMN "organization_id" text NOT NULL;--> statement-breakpoint
ALTER TABLE "cloud_jobs" ADD CONSTRAINT "cloud_jobs_organization_id_organizations_id_fk" FOREIGN KEY ("organization_id") REFERENCES "public"."organizations"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "cloud_jobs_user_id_idx" ON "cloud_jobs" USING btree ("user_id");--> statement-breakpoint
CREATE INDEX "cloud_jobs_user_org_idx" ON "cloud_jobs" USING btree ("user_id","organization_id");