From cdc61eb4ea5309769ad4db84d92594e4dc3dff67 Mon Sep 17 00:00:00 2001 From: Michael Date: Mon, 20 Mar 2017 16:45:17 -0400 Subject: Initial commit (azure deploy test) --- Project-Unite/Migrations/201703161854009_app.cs | 40 +++++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 Project-Unite/Migrations/201703161854009_app.cs (limited to 'Project-Unite/Migrations/201703161854009_app.cs') diff --git a/Project-Unite/Migrations/201703161854009_app.cs b/Project-Unite/Migrations/201703161854009_app.cs new file mode 100644 index 0000000..f10f443 --- /dev/null +++ b/Project-Unite/Migrations/201703161854009_app.cs @@ -0,0 +1,40 @@ +namespace Project_Unite.Migrations +{ + using System; + using System.Data.Entity.Migrations; + + public partial class app : DbMigration + { + public override void Up() + { + //Column names in each table must be unique. Column name 'Parent_Id' in table 'dbo.ACLForumPermissions' is specified more than once. + //Cannot drop the table 'dbo.ACLForumPermissionForumCategories', because it does not exist or you do not have permission. + + + DropForeignKey("dbo.ACLForumPermissionForumCategories", "ACLForumPermission_Id", "dbo.ACLForumPermissions"); + DropForeignKey("dbo.ACLForumPermissionForumCategories", "ForumCategory_Id", "dbo.ForumCategories"); + DropIndex("dbo.ACLForumPermissionForumCategories", new[] { "ACLForumPermission_Id" }); + DropIndex("dbo.ACLForumPermissionForumCategories", new[] { "ForumCategory_Id" }); + } + + public override void Down() + { + CreateTable( + "dbo.ACLForumPermissionForumCategories", + c => new + { + ACLForumPermission_Id = c.String(nullable: false, maxLength: 128), + ForumCategory_Id = c.String(nullable: false, maxLength: 128), + }) + .PrimaryKey(t => new { t.ACLForumPermission_Id, t.ForumCategory_Id }); + + DropForeignKey("dbo.ACLForumPermissions", "Parent_Id", "dbo.ForumCategories"); + DropIndex("dbo.ACLForumPermissions", new[] { "Parent_Id" }); + DropColumn("dbo.ACLForumPermissions", "Parent_Id"); + CreateIndex("dbo.ACLForumPermissionForumCategories", "ForumCategory_Id"); + CreateIndex("dbo.ACLForumPermissionForumCategories", "ACLForumPermission_Id"); + AddForeignKey("dbo.ACLForumPermissionForumCategories", "ForumCategory_Id", "dbo.ForumCategories", "Id", cascadeDelete: true); + AddForeignKey("dbo.ACLForumPermissionForumCategories", "ACLForumPermission_Id", "dbo.ACLForumPermissions", "Id", cascadeDelete: true); + } + } +} -- cgit v1.2.3