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) --- .../201703161150361_voting-system-forums.cs | 61 ++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 Project-Unite/Migrations/201703161150361_voting-system-forums.cs (limited to 'Project-Unite/Migrations/201703161150361_voting-system-forums.cs') diff --git a/Project-Unite/Migrations/201703161150361_voting-system-forums.cs b/Project-Unite/Migrations/201703161150361_voting-system-forums.cs new file mode 100644 index 0000000..62240fb --- /dev/null +++ b/Project-Unite/Migrations/201703161150361_voting-system-forums.cs @@ -0,0 +1,61 @@ +namespace Project_Unite.Migrations +{ + using System; + using System.Data.Entity.Migrations; + + public partial class votingsystemforums : DbMigration + { + public override void Up() + { + CreateTable( + "dbo.ForumPostEdits", + c => new + { + Id = c.String(nullable: false, maxLength: 128), + UserId = c.String(), + EditReason = c.String(), + PreviousState = c.String(), + EditedAt = c.DateTime(nullable: false), + ForumPost_Id = c.String(maxLength: 128), + }) + .PrimaryKey(t => t.Id) + .ForeignKey("dbo.ForumPosts", t => t.ForumPost_Id) + .Index(t => t.ForumPost_Id); + + CreateTable( + "dbo.Likes", + c => new + { + Id = c.String(nullable: false, maxLength: 128), + Post_Id = c.String(maxLength: 128), + User_Id = c.String(maxLength: 128), + }) + .PrimaryKey(t => t.Id) + .ForeignKey("dbo.ForumPosts", t => t.Post_Id) + .ForeignKey("dbo.AspNetUsers", t => t.User_Id) + .Index(t => t.Post_Id) + .Index(t => t.User_Id); + + AddColumn("dbo.ForumTopics", "Votes", c => c.Int(nullable: false)); + AddColumn("dbo.ForumTopics", "StartedAt", c => c.DateTime(nullable: false)); + AddColumn("dbo.ForumPosts", "PostedAt", c => c.DateTime(nullable: false)); + AddColumn("dbo.AspNetRoles", "CanDeleteForumCategories", c => c.Boolean()); + } + + public override void Down() + { + DropForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers"); + DropForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts"); + DropForeignKey("dbo.ForumPostEdits", "ForumPost_Id", "dbo.ForumPosts"); + DropIndex("dbo.Likes", new[] { "User_Id" }); + DropIndex("dbo.Likes", new[] { "Post_Id" }); + DropIndex("dbo.ForumPostEdits", new[] { "ForumPost_Id" }); + DropColumn("dbo.AspNetRoles", "CanDeleteForumCategories"); + DropColumn("dbo.ForumPosts", "PostedAt"); + DropColumn("dbo.ForumTopics", "StartedAt"); + DropColumn("dbo.ForumTopics", "Votes"); + DropTable("dbo.Likes"); + DropTable("dbo.ForumPostEdits"); + } + } +} -- cgit v1.2.3