Files
jube-fork/Jube.Migrations/Baseline/AddExhaustiveSearchInstanceTrialInstanceVariablePrescriptionHistogramTableIndex.cs
Richard ChurchmanandGitHub a500c37e36 Merge pull request #88
Refactors startup and DI, implements a local LRU cache to reduce Redis load, introduces high-performance dictionaries, and optimizes Invoke routing for parallelism. Includes Redis and library upgrades, schema migrations, logging improvements, and overall code cleanup for better performance, readability, and maintainabilit
2025-10-29 16:09:20 +02:00

41 lines
1.9 KiB
C#

/* Copyright (C) 2022-present Jube Holdings Limited.
*
* This file is part of Jube™ software.
*
* Jube™ is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License
* as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
* Jube™ is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
* of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.
* You should have received a copy of the GNU Affero General Public License along with Jube™. If not,
* see <https://www.gnu.org/licenses/>.
*/
using FluentMigrator;
namespace Jube.Migrations.Baseline
{
[Migration(20220429125002)]
public class AddExhaustiveSearchInstancePromotedTrialInstanceVariableHistogramTableIndex : Migration
{
public override void Up()
{
Create.Table("ExhaustiveSearchInstancePromotedTrialInstanceVariableHistogram")
.WithColumn("Id").AsInt32().PrimaryKey().Identity()
.WithColumn("ExhaustiveSearchInstancePromotedTrialInstanceVariableId").AsInt32().Nullable()
.WithColumn("BinIndex").AsInt32().Nullable()
.WithColumn("BinRangeStart").AsDouble().Nullable()
.WithColumn("BinRangeEnd").AsDouble().Nullable()
.WithColumn("Frequency").AsInt32();
Create.Index("IX_Truncated_Name_ESITIVPH_ESITIVP")
.OnTable("ExhaustiveSearchInstancePromotedTrialInstanceVariableHistogram")
.OnColumn("ExhaustiveSearchInstancePromotedTrialInstanceVariableId");
}
public override void Down()
{
Delete.Table("ExhaustiveSearchInstancePromotedTrialInstanceVariableHistogram");
}
}
}