2005.01-data.sql

cnForums是功能强大的论坛。开发语言c#,三层结构。模块设计很值得学习

/*=========================================================
USERS 
=========================================================*/
SET IDENTITY_INSERT forums_Users ON
print '创建匿名帐号'
IF EXISTS (SELECT UserID FROM forums_Users WHERE UserID = 0)
	DELETE forums_Users WHERE UserID = 0

INSERT INTO
	forums_Users
( 
	UserID, UserName, NickName, Password, PasswordFormat, Salt, PasswordQuestion, PasswordAnswer, Email, DateCreated, LastLogin, LastActivity, LastAction, UserAccountStatus, IsAnonymous
)
VALUES
(
	0, '', '匿名', '', 0, '', '', '', '', GetDate(), GetDate(), GetDate(), '', 1, 1
)

INSERT INTO
	forums_UserProfile
VALUES
(
	0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, GetDate()
)
SET IDENTITY_INSERT forums_Users OFF
GO

/*=========================================================
ROLES 
=========================================================*/
SET IDENTITY_INSERT forums_Roles ON
print '创建Everyone角色'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 0)
	DELETE forums_Roles WHERE RoleID = 0

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	0, 'Everyone', '不需要添加用户到该角色，该角色仅仅是作为权限隐射，所有的匿名用户和注册用户都属于该角色。'
)

print 'Creating special everyone role mapping...'
IF EXISTS (SELECT RoleID FROM forums_UsersInRoles WHERE UserID = 0)
	DELETE forums_UsersInRoles WHERE RoleID = 0

INSERT INTO forums_UsersInRoles VALUES (0,0)

print 'creating Global Administrators role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 1)
	DELETE forums_Roles WHERE RoleID = 1

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	1, 'Global Administrators', '享有论坛的最高权限，可以管理所有站点。'
)

print 'creating Site Administrators role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 2)
	DELETE forums_Roles WHERE RoleID = 2

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	2, 'Site Administrators', '指定站点的管理员。'
)

print 'creating Global Moderators role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 3)
	DELETE forums_Roles WHERE RoleID = 3

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	3, 'Global Moderators', '可以管理所有站点的版块和用户。'
)

print 'creating Site Moderators role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 4)
	DELETE forums_Roles WHERE RoleID = 4

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	4, 'Site Moderators', '可以管理指定站点的版块和用户。'
)

print 'creating Global Editors role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 5)
	DELETE forums_Roles WHERE RoleID = 5

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	5, 'Global Editors', '可以通过/驳回/编辑所有站点中需要审批版块的帖子。'
)

print 'creating Site Editors role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 6)
	DELETE forums_Roles WHERE RoleID = 6

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	6, 'Site Editors', '可以通过/驳回/编辑指定站点中需要审批版块的帖子。'
)

print 'creating Global Registered Users role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 7)
	DELETE forums_Roles WHERE RoleID = 7

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	7, 'Global Registered Users', '所有站点的注册用户自动属于该角色。'
)

print 'creating Registered Users role'
IF EXISTS (SELECT RoleID FROM forums_Roles WHERE RoleID = 8)
	DELETE forums_Roles WHERE RoleID = 8

INSERT INTO
	forums_Roles
(
	RoleID, Name, Description
)
VALUES
(
	8, 'Site Registered Users', '指定站点的注册用户自动属于该角色。'
)

print 'Reseeding the role table to allow space for future forum default roles'
DBCC CHECKIDENT( forums_Roles, RESEED, 10 )
GO
SET IDENTITY_INSERT forums_Roles OFF
GO

/*=========================================================
FORUM GROUPS 
=========================================================*/
SET IDENTITY_INSERT forums_ForumGroups ON
IF EXISTS( SELECT ForumGroupID from forums_ForumGroups where ForumGroupID = 1)
	DELETE forums_ForumGroups WHERE ForumGroupID = 1

INSERT INTO forums_ForumGroups 
	( ForumGroupID, [Name], [SortOrder])
VALUES 
	( 1, '管理员 / 版主 讨论组', 9999 )
SET IDENTITY_INSERT forums_ForumGroups OFF

GO

/*=========================================================
FORUMS
=========================================================*/
SET IDENTITY_INSERT forums_Forums ON
print 'creating private forum for Administrators'
IF EXISTS (SELECT ForumID FROM forums_Forums WHERE ForumID = 1)
	DELETE forums_Forums WHERE ForumID = 1

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
	(
		1, 1, 0, 1, '管理员专区', '仅管理员可见。', GetDate(), '', 0, 7, 1, 0, 0, 0x0, 0, 0, 0, 90, 0, 0, 0, '', 0, GetDate(), 0, 0, 1
	)

print 'creating private forum for Administrators'
IF EXISTS (SELECT ForumID FROM forums_Forums WHERE ForumID = 2)
	DELETE forums_Forums WHERE ForumID = 2

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
	(
		2, 1, 0, 1, '版主专区', '仅版主和管理员可见。', GetDate(), '', 0, 7, 2, 0, 0, 0x0, 0, 0, 0, 90, 0, 0, 0, '', 0, GetDate(), 0, 0, 1
	)

print 'creating problem reporting forum'
IF EXISTS (SELECT ForumID FROM forums_Forums WHERE ForumID = 3)
	DELETE forums_Forums WHERE ForumID = 3

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
	(
		3, 1, 0, 1, '帖子报告', '当用户报告问题时帖子保存在该版。', GetDate(), '', 0, 7, 3, 0, 0, 0x0, 0, 0, 1, 90, 0, 0, 0, '', 0, GetDate(), 0, 0, 1
	)

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