CREATE TABLE `commercial_quotes` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`request_type` text NOT NULL,
	`request_id` integer NOT NULL,
	`production_price_cents` integer NOT NULL,
	`delivery_price_cents` integer DEFAULT 0 NOT NULL,
	`installation_price_cents` integer DEFAULT 0 NOT NULL,
	`discount_cents` integer DEFAULT 0 NOT NULL,
	`notes` text,
	`validity_days` integer DEFAULT 30 NOT NULL,
	`updated_at` integer NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `commercial_quotes_request_unique` ON `commercial_quotes` (`request_type`,`request_id`);