sqlserver_data.sql

LiteBlaster 是一款基于 .NET Framework 原创的 ASP.NET 论坛系统。后台程序库采用 C#/VB.NET 编写

INSERT INTO [EPGain] ([Login],[CustomTitle],[CustomFace],[PostTopic],[ReplyTopic],[PostRestrictedPost],[MakeOwnTopicStriking],[RemoveOwnPost],[BestTopic],[BestAnswer],[PostVote],[JoinVote],[UploadFile],[DownloadFile],[SendMessage]) VALUES 
  (0,-5,-10,3,1,-2,-3,-3,10,5,-2,1,1,-1,0);

INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (6,N'管理员',-2147483648,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (5,N'超级版主',-2147483648,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (4,N'版主',-2147483648,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (3,N'VIP',-2147483648,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (2,N'内部成员',-2147483648,1,1,1,1,1,1,0,0,1,1,0,0,0,0,0,1,1,1,0,0,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (0,N'游客',-2147483648,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'初出茅庐',-2147483648,0,0,1,1,1,1,0,0,1,1,0,0,0,0,0,1,1,1,0,0,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'寻经问道',20,0,0,1,1,1,1,0,0,1,1,0,0,1,0,0,1,1,1,0,0,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'尝试推理',50,0,0,1,1,1,1,0,1,1,1,0,0,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'初露锋芒',100,0,0,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'推理优胜',200,0,1,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'少年侦探',300,0,1,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'破案能手',400,0,1,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'荣誉勋章得主',600,0,1,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'名侦探',1000,1,1,1,1,1,1,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'推理大师',2000,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'FBI特邀顾问',3500,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'贡献卓越',5500,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'福尔摩斯转世',8000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'位列仙班',11000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);
INSERT INTO [Groups] ([Type],[Title],[MinEP],[CanCustomTitle],[CanCustomFace],[CanListBoards],[CanListTopics],[CanListPosts],[CanPostTopics],[CanMoveOwnTopics],[CanMakeOwnTopicsStriking],[CanReplyTopics],[CanEditOwnPosts],[CanReadRestrictedPosts],[CanPostRestrictedPosts],[CanEnterMoods],[CanEnterCodes],[CanPostVotes],[CanJoinVotes],[CanBookmark],[CanViewUserInfo],[CanViewIP],[CanUploadFiles],[CanDownloadFiles],[CanSendMessages]) VALUES 
  (1,N'返璞归真',15000,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1);

INSERT INTO [Help] ([ParentID],[Title],[Body]) VALUES 
  (0,N'用户维护',NULL);
INSERT INTO [Help] ([ParentID],[Title],[Body]) VALUES 
  (0,N'论坛使用',NULL);