protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropIndex(
name: "IX_Symbols_Name_ListingExchangeCode",
table: "Symbols");
migrationBuilder.BeforeSymbolsListingExchangeCodeChange();
migrationBuilder.AlterColumn <string>(
name: "ListingExchangeCode",
table: "Symbols",
maxLength: 10,
nullable: true,
oldClrType: typeof(string),
oldMaxLength: 10);
migrationBuilder.SetSymbolsListingExchangeCodeNullCollationToCaseSensitive();
migrationBuilder.AfterSymbolsListingExchangeCodeChange();
migrationBuilder.CreateIndex(
name: "IX_Symbols_Name_ListingExchangeCode",
table: "Symbols",
columns: new[] { "Name", "ListingExchangeCode" },
unique: true,
filter: "[ListingExchangeCode] IS NOT NULL");
}