Last active
May 10, 2022 03:53
-
-
Save KhoiNguyenICT/7c0c8236d4a2446aa385c343a3c244cc to your computer and use it in GitHub Desktop.
SQLServerFTS.cs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using Microsoft.EntityFrameworkCore.Migrations; | |
| namespace Application.Api.Migrations | |
| { | |
| public partial class InitMetadataDatabase : Migration | |
| { | |
| protected override void Up(MigrationBuilder migrationBuilder) | |
| { | |
| migrationBuilder.Sql("CREATE FULLTEXT CATALOG FTS_Catalog WITH ACCENT_SENSITIVITY = OFF AS DEFAULT;", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[Storage] KEY INDEX [PK_Storage] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[Storage] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[Storage] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SecurityGroups] KEY INDEX [PK_SecurityGroups] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SecurityGroups] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SecurityGroups] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SecurityUsers] KEY INDEX [PK_SecurityUsers] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SecurityUsers] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SecurityUsers] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingActions] KEY INDEX [PK_SettingActions] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingActions] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingActions] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingComponents] KEY INDEX [PK_SettingComponents] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingComponents] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingComponents] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingFeatures] KEY INDEX [PK_SettingFeatures] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFeatures] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFeatures] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingFieldReferences] KEY INDEX [PK_SettingFieldReferences] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFieldReferences] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFieldReferences] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingFields] KEY INDEX [PK_SettingFields] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFields] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFields] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingFilters] KEY INDEX [PK_SettingFilters] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFilters] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingFilters] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingForms] KEY INDEX [PK_SettingForms] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingForms] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingForms] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingLayouts] KEY INDEX [PK_SettingLayouts] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingLayouts] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingLayouts] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingReports] KEY INDEX [PK_SettingReports] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingReports] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingReports] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingTables] KEY INDEX [PK_SettingTables] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingTables] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingTables] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[SettingViews] KEY INDEX [PK_SettingViews] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingViews] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[SettingViews] ENABLE", true); | |
| migrationBuilder.Sql($"CREATE FULLTEXT INDEX ON [dbo].[Tenants] KEY INDEX [PK_Tenants] ON ([FTS_Catalog]) WITH (CHANGE_TRACKING AUTO)", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[Tenants] ADD ([Data] LANGUAGE [Vietnamese])", true); | |
| migrationBuilder.Sql($"ALTER FULLTEXT INDEX ON [dbo].[Tenants] ENABLE", true); | |
| } | |
| protected override void Down(MigrationBuilder migrationBuilder) | |
| { | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment