LegalServiceV1/SourceCode/V2/ContractService/ContractService.EntityFramework/Migrations/202101210739223_Update20210121002.cs

namespace ContractService.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class Update20210121002 : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.Cs_ClientOrganizations", "LawFirmNo", c => c.String(maxLength: 128));
            AddColumn("dbo.Ls_Lawyers", "LawFirmNo", c => c.String(maxLength: 128));
            AddColumn("dbo.Ls_Lawyers", "OrganizationNo", c => c.String(maxLength: 128));
            CreateIndex("dbo.Cs_ClientOrganizations", "LawFirmNo");
            CreateIndex("dbo.Ls_Lawyers", "LawFirmNo");
            CreateIndex("dbo.Ls_Lawyers", "OrganizationNo");
            AddForeignKey("dbo.Cs_ClientOrganizations", "LawFirmNo", "dbo.Ls_LawFirms", "Id");
            AddForeignKey("dbo.Ls_Lawyers", "LawFirmNo", "dbo.Ls_LawFirms", "Id");
            AddForeignKey("dbo.Ls_Lawyers", "OrganizationNo", "dbo.Cs_ClientOrganizations", "Id");
        }
        
        public override void Down()
        {
            DropForeignKey("dbo.Ls_Lawyers", "OrganizationNo", "dbo.Cs_ClientOrganizations");
            DropForeignKey("dbo.Ls_Lawyers", "LawFirmNo", "dbo.Ls_LawFirms");
            DropForeignKey("dbo.Cs_ClientOrganizations", "LawFirmNo", "dbo.Ls_LawFirms");
            DropIndex("dbo.Ls_Lawyers", new[] { "OrganizationNo" });
            DropIndex("dbo.Ls_Lawyers", new[] { "LawFirmNo" });
            DropIndex("dbo.Cs_ClientOrganizations", new[] { "LawFirmNo" });
            DropColumn("dbo.Ls_Lawyers", "OrganizationNo");
            DropColumn("dbo.Ls_Lawyers", "LawFirmNo");
            DropColumn("dbo.Cs_ClientOrganizations", "LawFirmNo");
        }
    }
}