1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
namespace Project_Unite.Migrations
{
using System;
using System.Data.Entity.Migrations;
public partial class cdelete : DbMigration
{
public override void Up()
{
//Cannot insert the value NULL into column 'Parent_Id', table 'aspnet-Project-Unite-20170315114859.dbo.ForumCategories'; column does not allow nulls. UPDATE fails.
//The statement has been terminated.
DropForeignKey("dbo.ACLForumPermissions", "Parent_Id", "dbo.ForumCategories");
DropForeignKey("dbo.ForumTopics", "Parent_Id", "dbo.ForumCategories");
DropForeignKey("dbo.ForumPosts", "Parent_Id", "dbo.ForumTopics");
DropForeignKey("dbo.ForumPostEdits", "Parent_Id", "dbo.ForumPosts");
DropForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts");
DropForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers");
DropForeignKey("dbo.ForumPollOptions", "Poll_Id", "dbo.ForumPolls");
DropForeignKey("dbo.ForumPollVotes", "Option_Id", "dbo.ForumPollOptions");
DropForeignKey("dbo.ForumPolls", "Parent_Id", "dbo.ForumTopics");
DropIndex("dbo.ForumCategories", new[] { "Parent_Id" });
DropIndex("dbo.ACLForumPermissions", new[] { "Parent_Id" });
DropIndex("dbo.ForumTopics", new[] { "Parent_Id" });
DropIndex("dbo.ForumPosts", new[] { "Parent_Id" });
DropIndex("dbo.ForumPostEdits", new[] { "Parent_Id" });
DropIndex("dbo.Likes", new[] { "Post_Id" });
DropIndex("dbo.Likes", new[] { "User_Id" });
DropIndex("dbo.ForumPollOptions", new[] { "Poll_Id" });
DropIndex("dbo.ForumPolls", new[] { "Parent_Id" });
DropIndex("dbo.ForumPollVotes", new[] { "Option_Id" });
AlterColumn("dbo.ForumCategories", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ACLForumPermissions", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumTopics", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumPosts", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumPostEdits", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.Likes", "Post_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.Likes", "User_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumPollOptions", "Poll_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumPolls", "Parent_Id", c => c.String(nullable: false, maxLength: 128));
AlterColumn("dbo.ForumPollVotes", "Option_Id", c => c.String(nullable: false, maxLength: 128));
CreateIndex("dbo.ForumCategories", "Parent_Id");
CreateIndex("dbo.ACLForumPermissions", "Parent_Id");
CreateIndex("dbo.ForumTopics", "Parent_Id");
CreateIndex("dbo.ForumPosts", "Parent_Id");
CreateIndex("dbo.ForumPostEdits", "Parent_Id");
CreateIndex("dbo.Likes", "Post_Id");
CreateIndex("dbo.Likes", "User_Id");
CreateIndex("dbo.ForumPollOptions", "Poll_Id");
CreateIndex("dbo.ForumPolls", "Parent_Id");
CreateIndex("dbo.ForumPollVotes", "Option_Id");
AddForeignKey("dbo.ACLForumPermissions", "Parent_Id", "dbo.ForumCategories", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumTopics", "Parent_Id", "dbo.ForumCategories", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumPosts", "Parent_Id", "dbo.ForumTopics", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumPostEdits", "Parent_Id", "dbo.ForumPosts", "Id", cascadeDelete: true);
AddForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts", "Id", cascadeDelete: true);
AddForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumPollOptions", "Poll_Id", "dbo.ForumPolls", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumPollVotes", "Option_Id", "dbo.ForumPollOptions", "Id", cascadeDelete: true);
AddForeignKey("dbo.ForumPolls", "Parent_Id", "dbo.ForumTopics", "Id", cascadeDelete: true);
}
public override void Down()
{
DropForeignKey("dbo.ForumPolls", "Parent_Id", "dbo.ForumTopics");
DropForeignKey("dbo.ForumPollVotes", "Option_Id", "dbo.ForumPollOptions");
DropForeignKey("dbo.ForumPollOptions", "Poll_Id", "dbo.ForumPolls");
DropForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers");
DropForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts");
DropForeignKey("dbo.ForumPostEdits", "Parent_Id", "dbo.ForumPosts");
DropForeignKey("dbo.ForumPosts", "Parent_Id", "dbo.ForumTopics");
DropForeignKey("dbo.ForumTopics", "Parent_Id", "dbo.ForumCategories");
DropForeignKey("dbo.ACLForumPermissions", "Parent_Id", "dbo.ForumCategories");
DropIndex("dbo.ForumPollVotes", new[] { "Option_Id" });
DropIndex("dbo.ForumPolls", new[] { "Parent_Id" });
DropIndex("dbo.ForumPollOptions", new[] { "Poll_Id" });
DropIndex("dbo.Likes", new[] { "User_Id" });
DropIndex("dbo.Likes", new[] { "Post_Id" });
DropIndex("dbo.ForumPostEdits", new[] { "Parent_Id" });
DropIndex("dbo.ForumPosts", new[] { "Parent_Id" });
DropIndex("dbo.ForumTopics", new[] { "Parent_Id" });
DropIndex("dbo.ACLForumPermissions", new[] { "Parent_Id" });
DropIndex("dbo.ForumCategories", new[] { "Parent_Id" });
AlterColumn("dbo.ForumPollVotes", "Option_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumPolls", "Parent_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumPollOptions", "Poll_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.Likes", "User_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.Likes", "Post_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumPostEdits", "Parent_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumPosts", "Parent_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumTopics", "Parent_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ACLForumPermissions", "Parent_Id", c => c.String(maxLength: 128));
AlterColumn("dbo.ForumCategories", "Parent_Id", c => c.String(maxLength: 128));
CreateIndex("dbo.ForumPollVotes", "Option_Id");
CreateIndex("dbo.ForumPolls", "Parent_Id");
CreateIndex("dbo.ForumPollOptions", "Poll_Id");
CreateIndex("dbo.Likes", "User_Id");
CreateIndex("dbo.Likes", "Post_Id");
CreateIndex("dbo.ForumPostEdits", "Parent_Id");
CreateIndex("dbo.ForumPosts", "Parent_Id");
CreateIndex("dbo.ForumTopics", "Parent_Id");
CreateIndex("dbo.ACLForumPermissions", "Parent_Id");
CreateIndex("dbo.ForumCategories", "Parent_Id");
AddForeignKey("dbo.ForumPolls", "Parent_Id", "dbo.ForumTopics", "Id");
AddForeignKey("dbo.ForumPollVotes", "Option_Id", "dbo.ForumPollOptions", "Id");
AddForeignKey("dbo.ForumPollOptions", "Poll_Id", "dbo.ForumPolls", "Id");
AddForeignKey("dbo.Likes", "User_Id", "dbo.AspNetUsers", "Id");
AddForeignKey("dbo.Likes", "Post_Id", "dbo.ForumPosts", "Id");
AddForeignKey("dbo.ForumPostEdits", "Parent_Id", "dbo.ForumPosts", "Id");
AddForeignKey("dbo.ForumPosts", "Parent_Id", "dbo.ForumTopics", "Id");
AddForeignKey("dbo.ForumTopics", "Parent_Id", "dbo.ForumCategories", "Id");
AddForeignKey("dbo.ACLForumPermissions", "Parent_Id", "dbo.ForumCategories", "Id");
}
}
}
|
