72 lines
2.6 KiB
SQL
72 lines
2.6 KiB
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to drop the column `apiBaseUrl` on the `discovery_configs` table. All the data in the column will be lost.
|
|
- You are about to drop the column `apiKey` on the `discovery_configs` table. All the data in the column will be lost.
|
|
- You are about to drop the column `modelName` on the `discovery_configs` table. All the data in the column will be lost.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE `discovery_configs` DROP COLUMN `apiBaseUrl`,
|
|
DROP COLUMN `apiKey`,
|
|
DROP COLUMN `modelName`,
|
|
ADD COLUMN `api_provider_id` INTEGER NULL;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE `skills` (
|
|
`id` INTEGER NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(100) NOT NULL,
|
|
`slug` VARCHAR(100) NOT NULL,
|
|
`category_id` INTEGER NOT NULL,
|
|
`description` TEXT NOT NULL,
|
|
`logo_url` VARCHAR(255) NULL,
|
|
`source_url` VARCHAR(255) NOT NULL,
|
|
`source_type` VARCHAR(20) NOT NULL DEFAULT 'github',
|
|
`features` JSON NULL,
|
|
`tags` JSON NULL,
|
|
`view_count` INTEGER NOT NULL DEFAULT 0,
|
|
`status` ENUM('draft', 'published') NOT NULL DEFAULT 'draft',
|
|
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updated_at` DATETIME(3) NOT NULL,
|
|
|
|
UNIQUE INDEX `skills_slug_key`(`slug`),
|
|
INDEX `skills_category_id_status_idx`(`category_id`, `status`),
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE `pending_skills` (
|
|
`id` INTEGER NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(100) NOT NULL,
|
|
`slug` VARCHAR(100) NULL,
|
|
`category_id` INTEGER NULL,
|
|
`description` TEXT NULL,
|
|
`logo_url` VARCHAR(255) NULL,
|
|
`source_url` VARCHAR(255) NULL,
|
|
`source_type` VARCHAR(20) NULL,
|
|
`features` JSON NULL,
|
|
`tags` JSON NULL,
|
|
`status` ENUM('pending', 'approved', 'rejected') NOT NULL DEFAULT 'pending',
|
|
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updated_at` DATETIME(3) NOT NULL,
|
|
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE `api_providers` (
|
|
`id` INTEGER NOT NULL AUTO_INCREMENT,
|
|
`name` VARCHAR(50) NOT NULL,
|
|
`baseUrl` VARCHAR(255) NOT NULL,
|
|
`apiKey` VARCHAR(255) NOT NULL,
|
|
`model` VARCHAR(100) NOT NULL,
|
|
`isDefault` BOOLEAN NOT NULL DEFAULT false,
|
|
`created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updated_at` DATETIME(3) NOT NULL,
|
|
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE `skills` ADD CONSTRAINT `skills_category_id_fkey` FOREIGN KEY (`category_id`) REFERENCES `categories`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
|