public override void Up()
{
DropForeignKey("dbo.Account", "User_Id", "dbo.User");
DropIndex("dbo.Account", new[] { "User_Id" });
// SqlCE doesn't support renaming
//RenameColumn(table: "dbo.Account", name: "User_Id", newName: "UserId");
AddColumn("dbo.Account", "UserId", c => c.Guid(nullable: false));
Sql("UPDATE Account SET UserId = User_Id");
DropColumn("dbo.Account", "User_Id");
DropPrimaryKey("dbo.Account");
AlterColumn("dbo.Account", "UserId", c => c.Guid(nullable: false));
AddPrimaryKey("dbo.Account", new[] { "UserId", "Type" });
CreateIndex("dbo.Account", "UserId");
AddForeignKey("dbo.Account", "UserId", "dbo.User", "Id", cascadeDelete: true);
DropColumn("dbo.Account", "Id");
}