namespace HealthchoiceMVC.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class _20190910b : DbMigration
    {
        public override void Up()
        {
            DropForeignKey("dbo.PersonPersonType", "PersonId", "dbo.Person");
            DropForeignKey("dbo.PersonPersonType", "PersonTypeId", "dbo.PersonType");
            DropForeignKey("dbo.PracticePerson", "PersonPersonTypeId", "dbo.PersonPersonType");
            DropIndex("dbo.PersonPersonType", new[] { "PersonId" });
            DropIndex("dbo.PersonPersonType", new[] { "PersonTypeId" });
            DropIndex("dbo.PracticePerson", new[] { "PersonPersonTypeId" });
            AddColumn("dbo.PersonType", "Person_PersonId", c => c.Int());
            AddColumn("dbo.PracticePerson", "PersonId", c => c.Int(nullable: false));
            AddColumn("dbo.PracticePerson", "PersonTypeId", c => c.Int(nullable: false));
            CreateIndex("dbo.PersonType", "Person_PersonId");
            CreateIndex("dbo.PracticePerson", "PersonTypeId");
            AddForeignKey("dbo.PersonType", "Person_PersonId", "dbo.Person", "PersonId");
            AddForeignKey("dbo.PracticePerson", "PersonTypeId", "dbo.PersonType", "PersonTypeId", cascadeDelete: true);
            DropColumn("dbo.PracticePerson", "PersonPersonTypeId");
            DropTable("dbo.PersonPersonType");
        }
        
        public override void Down()
        {
            CreateTable(
                "dbo.PersonPersonType",
                c => new
                    {
                        PersonPersonTypeId = c.Int(nullable: false, identity: true),
                        PersonId = c.Int(nullable: false),
                        PersonTypeId = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.PersonPersonTypeId);
            
            AddColumn("dbo.PracticePerson", "PersonPersonTypeId", c => c.Int(nullable: false));
            DropForeignKey("dbo.PracticePerson", "PersonTypeId", "dbo.PersonType");
            DropForeignKey("dbo.PersonType", "Person_PersonId", "dbo.Person");
            DropIndex("dbo.PracticePerson", new[] { "PersonTypeId" });
            DropIndex("dbo.PersonType", new[] { "Person_PersonId" });
            DropColumn("dbo.PracticePerson", "PersonTypeId");
            DropColumn("dbo.PracticePerson", "PersonId");
            DropColumn("dbo.PersonType", "Person_PersonId");
            CreateIndex("dbo.PracticePerson", "PersonPersonTypeId");
            CreateIndex("dbo.PersonPersonType", "PersonTypeId");
            CreateIndex("dbo.PersonPersonType", "PersonId");
            AddForeignKey("dbo.PracticePerson", "PersonPersonTypeId", "dbo.PersonPersonType", "PersonPersonTypeId", cascadeDelete: true);
            AddForeignKey("dbo.PersonPersonType", "PersonTypeId", "dbo.PersonType", "PersonTypeId", cascadeDelete: true);
            AddForeignKey("dbo.PersonPersonType", "PersonId", "dbo.Person", "PersonId", cascadeDelete: true);
        }
    }
}