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) --- .../Migrations/201703181945337_posting.cs | 36 ++++++++++++++++++++++ 1 file changed, 36 insertions(+) create mode 100644 Project-Unite/Migrations/201703181945337_posting.cs (limited to 'Project-Unite/Migrations/201703181945337_posting.cs') diff --git a/Project-Unite/Migrations/201703181945337_posting.cs b/Project-Unite/Migrations/201703181945337_posting.cs new file mode 100644 index 0000000..32d4a70 --- /dev/null +++ b/Project-Unite/Migrations/201703181945337_posting.cs @@ -0,0 +1,36 @@ +namespace Project_Unite.Migrations +{ + using System; + using System.Data.Entity.Migrations; + + public partial class posting : DbMigration + { + public override void Up() + { + AddColumn("dbo.ForumPosts", "Parent", c => c.String(nullable: false)); + AddColumn("dbo.ForumPostEdits", "Parent", c => c.String(nullable: false)); + AddColumn("dbo.Likes", "User", c => c.String(nullable: false)); + AddColumn("dbo.Likes", "Post", c => c.String(nullable: false)); + } + + public override void Down() + { + AddColumn("dbo.Likes", "User_Id", c => c.String(nullable: false, maxLength: 128)); + AddColumn("dbo.Likes", "Post_Id", c => c.String(nullable: false, maxLength: 128)); + AddColumn("dbo.ForumPostEdits", "Parent_Id", c => c.String(nullable: false, maxLength: 128)); + AddColumn("dbo.ForumPosts", "Parent_Id", c => c.String(nullable: false, maxLength: 128)); + DropColumn("dbo.Likes", "Post"); + DropColumn("dbo.Likes", "User"); + DropColumn("dbo.ForumPostEdits", "Parent"); + DropColumn("dbo.ForumPosts", "Parent"); + CreateIndex("dbo.Likes", "User_Id"); + CreateIndex("dbo.Likes", "Post_Id"); + CreateIndex("dbo.ForumPostEdits", "Parent_Id"); + CreateIndex("dbo.ForumPosts", "Parent_Id"); + AddForeignKey("dbo.ForumPosts", "Parent_Id", "dbo.ForumTopics", "Id", cascadeDelete: true); + AddForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers", "Id", cascadeDelete: true); + AddForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts", "Id", cascadeDelete: true); + AddForeignKey("dbo.ForumPostEdits", "Parent_Id", "dbo.ForumPosts", "Id", cascadeDelete: true); + } + } +} -- cgit v1.2.3