CREATE TABLE `cv_languages` (
	`cv_id` integer NOT NULL,
	`language_id` integer NOT NULL,
	PRIMARY KEY(`cv_id`, `language_id`),
	FOREIGN KEY (`cv_id`) REFERENCES `cvs`(`id`) ON UPDATE no action ON DELETE cascade,
	FOREIGN KEY (`language_id`) REFERENCES `languages`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE TABLE `cv_skills` (
	`cv_id` integer NOT NULL,
	`skill_id` integer NOT NULL,
	PRIMARY KEY(`cv_id`, `skill_id`),
	FOREIGN KEY (`cv_id`) REFERENCES `cvs`(`id`) ON UPDATE no action ON DELETE cascade,
	FOREIGN KEY (`skill_id`) REFERENCES `skills`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE TABLE `languages` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`locale` text NOT NULL,
	`name` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `languages_locale_name_unique` ON `languages` (`locale`,`name`);--> statement-breakpoint
CREATE TABLE `skills` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`locale` text NOT NULL,
	`name` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `skills_locale_name_unique` ON `skills` (`locale`,`name`);--> statement-breakpoint
ALTER TABLE `cvs` DROP COLUMN `code`;--> statement-breakpoint
ALTER TABLE `cvs` DROP COLUMN `languages`;--> statement-breakpoint
ALTER TABLE `cvs` DROP COLUMN `skills`;--> statement-breakpoint
ALTER TABLE `cvs` DROP COLUMN `status`;