Models-Phi-8B/PHI.Data.Generator/AddKeywordCatalog.sql

34 lines
1.3 KiB
Transact-SQL

BEGIN TRANSACTION;
ALTER TABLE [dbo].[TrainingItem] ADD [KeywordId] int NULL;
CREATE TABLE [dbo].[Keyword] (
[Id] int NOT NULL IDENTITY,
[CategoryId] int NOT NULL,
[Value] nvarchar(450) NOT NULL,
CONSTRAINT [PK_Keyword] PRIMARY KEY ([Id]),
CONSTRAINT [FK_Keyword_Category_CategoryId] FOREIGN KEY ([CategoryId]) REFERENCES [dbo].[Category] ([Id]) ON DELETE NO ACTION
);
CREATE TABLE [dbo].[KeywordVariant] (
[Id] int NOT NULL IDENTITY,
[ParentId] int NOT NULL,
[Value] nvarchar(450) NOT NULL,
CONSTRAINT [PK_KeywordVariant] PRIMARY KEY ([Id]),
CONSTRAINT [FK_KeywordVariant_Keyword_ParentId] FOREIGN KEY ([ParentId]) REFERENCES [dbo].[Keyword] ([Id]) ON DELETE CASCADE
);
CREATE INDEX [IX_TrainingItem_KeywordId] ON [dbo].[TrainingItem] ([KeywordId]);
CREATE UNIQUE INDEX [IX_Keyword_CategoryId_Value] ON [dbo].[Keyword] ([CategoryId], [Value]);
CREATE UNIQUE INDEX [IX_KeywordVariant_ParentId_Value] ON [dbo].[KeywordVariant] ([ParentId], [Value]);
ALTER TABLE [dbo].[TrainingItem] ADD CONSTRAINT [FK_TrainingItem_Keyword_KeywordId] FOREIGN KEY ([KeywordId]) REFERENCES [dbo].[Keyword] ([Id]) ON DELETE NO ACTION;
INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
VALUES (N'20260727025048_AddKeywordCatalog', N'10.0.8');
COMMIT;
GO