namespace HealthchoiceMVC.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class _20191029 : DbMigration
    {
        public override void Up()
        {
            DropForeignKey("dbo.PersonAddress", "PersonAddressType_PersonAddressTypeId", "dbo.PersonAddressType");
            DropForeignKey("dbo.PersonAddress", "PersonId_PersonId", "dbo.Person");
            DropIndex("dbo.PersonAddress", new[] { "PersonAddressType_PersonAddressTypeId" });
            DropIndex("dbo.PersonAddress", new[] { "PersonId_PersonId" });
            AddColumn("dbo.PersonAddress", "PersonId", c => c.Int(nullable: false));
            AddColumn("dbo.PersonAddress", "PersonAddressTypeId", c => c.Int(nullable: false));
            AddColumn("dbo.PersonAddress", "PostalCode", c => c.String(nullable: false, maxLength: 250));
            DropColumn("dbo.PersonAddress", "PostalCodeS");
            DropColumn("dbo.PersonAddress", "PersonAddressType_PersonAddressTypeId");
            DropColumn("dbo.PersonAddress", "PersonId_PersonId");
        }
        
        public override void Down()
        {
            AddColumn("dbo.PersonAddress", "PersonId_PersonId", c => c.Int(nullable: false));
            AddColumn("dbo.PersonAddress", "PersonAddressType_PersonAddressTypeId", c => c.Int(nullable: false));
            AddColumn("dbo.PersonAddress", "PostalCodeS", c => c.String(nullable: false, maxLength: 250));
            DropColumn("dbo.PersonAddress", "PostalCode");
            DropColumn("dbo.PersonAddress", "PersonAddressTypeId");
            DropColumn("dbo.PersonAddress", "PersonId");
            CreateIndex("dbo.PersonAddress", "PersonId_PersonId");
            CreateIndex("dbo.PersonAddress", "PersonAddressType_PersonAddressTypeId");
            AddForeignKey("dbo.PersonAddress", "PersonId_PersonId", "dbo.Person", "PersonId", cascadeDelete: true);
            AddForeignKey("dbo.PersonAddress", "PersonAddressType_PersonAddressTypeId", "dbo.PersonAddressType", "PersonAddressTypeId", cascadeDelete: true);
        }
    }
}