jube-fork/Jube.Migrations/Baseline/AddCacheAbstractionTableIndex.cs

/* 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;
using FluentMigrator.Postgres;

namespace Jube.Migrations.Baseline
{
    [Migration(20220602122100)]
    public class AddCacheAbstractionTableIndex : Migration
    {
        public override void Up()
        {
            Create.Table("CacheAbstraction")
                .WithColumn("Id").AsInt64().PrimaryKey().Identity()
                .WithColumn("EntityAnalysisModelId").AsInt64().Nullable()
                .WithColumn("SearchKey").AsString().Nullable()
                .WithColumn("SearchValue").AsString().Nullable()
                .WithColumn("Name").AsString().Nullable()
                .WithColumn("Value").AsDouble().Nullable()
                .WithColumn("CreatedDate").AsDateTime2().Nullable();

            Create.Index().OnTable("CacheAbstraction")
                .OnColumn("EntityAnalysisModelId").Ascending()
                .OnColumn("SearchKey").Ascending()
                .OnColumn("SearchValue").Ascending()
                .OnColumn("Name").Ascending()
                .WithOptions().Include("Value").Include("Id");

            Create.Index().OnTable("CacheAbstraction")
                .OnColumn("EntityAnalysisModelId").Ascending()
                .OnColumn("CreatedDate").Ascending();
        }

        public override void Down()
        {
            Delete.Table("CacheSanction");
        }
    }
}