CREATE TABLE `client_reviews` (
	`id` int unsigned AUTO_INCREMENT NOT NULL,
	`client_name` varchar(255) NOT NULL,
	`review_text` text NOT NULL,
	`star_rating` int unsigned NOT NULL DEFAULT 5,
	`is_active` boolean NOT NULL DEFAULT true,
	`sort_order` int unsigned NOT NULL DEFAULT 0,
	`created_at` timestamp NOT NULL DEFAULT (now()),
	`updated_at` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `client_reviews_id` PRIMARY KEY(`id`)
);
--> statement-breakpoint
CREATE INDEX `client_reviews_active_sort_idx` ON `client_reviews` (`is_active`,`sort_order`);