llm-router / apps /api /drizzle /0029_bumpy_brood.sql
ClaraSu's picture
Upload folder using huggingface_hub
0d611fc verified
Raw History Blame Contribute Delete
977 Bytes
CREATE TABLE "expense_visibility" (
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
"expense_id" uuid NOT NULL,
"user_id" uuid NOT NULL,
"created_at" timestamp with time zone DEFAULT now() NOT NULL,
CONSTRAINT "expense_visibility_expense_user_unique" UNIQUE("expense_id","user_id")
);
--> statement-breakpoint
ALTER TABLE "workspaces" ADD COLUMN "visibility_bypass_enabled" boolean DEFAULT true NOT NULL;--> statement-breakpoint
ALTER TABLE "expense_visibility" ADD CONSTRAINT "expense_visibility_expense_id_expenses_id_fk" FOREIGN KEY ("expense_id") REFERENCES "public"."expenses"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "expense_visibility" ADD CONSTRAINT "expense_visibility_user_id_users_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint
CREATE INDEX "expense_visibility_expense_idx" ON "expense_visibility" USING btree ("expense_id");