回收站误删恢复.sql

来自「cnForums是功能强大的论坛。开发语言c#,三层结构。模块设计很值得学习」· SQL 代码 · 共 24 行

SET IDENTITY_INSERT forums_Forums ON

print '创建 回收站'
IF EXISTS (SELECT ForumID FROM forums_Forums WHERE ForumID = 4)
	DELETE forums_Forums WHERE ForumID = 4

INSERT INTO 
	forums_Forums
	(
		ForumID, IsActive, ParentID, ForumGroupID, Name, Description, DateCreated, Url, IsModerated, DaysToView, SortOrder, TotalPosts, TotalThreads, DisplayMask, EnablePostStatistics, EnableAutoDelete, EnableAnonymousPosting, AutoDeleteThreshold, MostRecentPostID, MostRecentThreadID, MostRecentThreadReplies, MostRecentPostAuthor, MostRecentPostAuthorID, MostRecentPostDate, PostsToModerate, ForumType, IsSearchable
	)
VALUES
	(
		4, 1, 2, 1, '回收站', '所有被删除的帖子都可以在这里找到。', GetDate(), '', 0, 7, 4, 0, 0, 0x0, 0, 0, 0, 90, 0, 0, 0, '', 0, GetDate(), 0, 0, 1
	)
SET IDENTITY_INSERT forums_Forums OFF
INSERT INTO forums_ForumPermissions VALUES (4, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2)
INSERT INTO forums_ForumPermissions VALUES (4, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
INSERT INTO forums_ForumPermissions VALUES (4, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
INSERT INTO forums_ForumPermissions VALUES (4, 3, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1)
INSERT INTO forums_ForumPermissions VALUES (4, 4, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1)
INSERT INTO forums_ForumPermissions VALUES (4, 5, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1)
INSERT INTO forums_ForumPermissions VALUES (4, 6, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1)