CREATE TABLE "business_types" (
	"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
	"name_he" text NOT NULL,
	"name_en" text NOT NULL,
	"sort_order" integer DEFAULT 0 NOT NULL,
	"is_active" boolean DEFAULT true NOT NULL,
	"created_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
ALTER TABLE "deal_translations" ADD COLUMN "title_source_hash" text DEFAULT '' NOT NULL;--> statement-breakpoint
ALTER TABLE "deal_translations" ADD COLUMN "description_source_hash" text DEFAULT '' NOT NULL;--> statement-breakpoint
ALTER TABLE "deal_translations" ADD COLUMN "special_instructions_source_hash" text;--> statement-breakpoint
ALTER TABLE "vendors" ADD COLUMN "business_type_id" uuid;--> statement-breakpoint
ALTER TABLE "vendors" ADD CONSTRAINT "vendors_business_type_id_business_types_id_fk" FOREIGN KEY ("business_type_id") REFERENCES "public"."business_types"("id") ON DELETE set null ON UPDATE no action;