PRAGMA foreign_keys=OFF;--> statement-breakpoint
CREATE TABLE `__new_pricing_profiles` (
	`code` text PRIMARY KEY NOT NULL,
	`factor_bp` integer NOT NULL,
	`base_price_cents` integer DEFAULT 22000 NOT NULL,
	`rate_per_cm_letter_cents` integer DEFAULT 450 NOT NULL,
	`professional_discount_bp` integer DEFAULT 1800 NOT NULL,
	`price_mode` text DEFAULT 'estimate' NOT NULL,
	`enabled` integer DEFAULT true NOT NULL,
	`version` integer DEFAULT 1 NOT NULL,
	`updated_at` integer NOT NULL
);
--> statement-breakpoint
INSERT INTO `__new_pricing_profiles`("code", "factor_bp", "base_price_cents", "rate_per_cm_letter_cents", "professional_discount_bp", "price_mode", "enabled", "version", "updated_at") SELECT "code", "factor_bp", 22000, 450, "professional_discount_bp", "price_mode", "enabled", 2, "updated_at" FROM `pricing_profiles`;--> statement-breakpoint
DROP TABLE `pricing_profiles`;--> statement-breakpoint
ALTER TABLE `__new_pricing_profiles` RENAME TO `pricing_profiles`;--> statement-breakpoint
PRAGMA foreign_keys=ON;--> statement-breakpoint
ALTER TABLE `quote_requests` ADD `letter_count` integer DEFAULT 1 NOT NULL;--> statement-breakpoint
ALTER TABLE `quote_requests` ADD `height_cm` integer DEFAULT 30 NOT NULL;