CREATE TABLE `cvs` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`slug` text NOT NULL,
	`locale` text NOT NULL,
	`code` text NOT NULL,
	`name` text NOT NULL,
	`photo` text,
	`bio` text,
	`country` text NOT NULL,
	`profession` text NOT NULL,
	`age` integer NOT NULL,
	`experience_years` integer DEFAULT 0 NOT NULL,
	`experience_note` text,
	`religion` text,
	`marital_status` text,
	`languages` text DEFAULT '[]' NOT NULL,
	`skills` text DEFAULT '[]' NOT NULL,
	`salary` integer,
	`status` text DEFAULT 'available' NOT NULL,
	`has_video` integer DEFAULT false NOT NULL,
	`featured` integer DEFAULT false NOT NULL,
	`created_at` integer NOT NULL,
	`updated_at` integer NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `cvs_slug_locale_unique` ON `cvs` (`slug`,`locale`);