if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_BoardTopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DXBBS_BoardTopicProc]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_BoardTopTopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DXBBS_BoardTopTopicProc]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_CommonProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DXBBS_CommonProc]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_TopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DXBBS_TopicProc]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_Advertisement]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[$TablePrefix_Forum_Advertisement]
CREATE TABLE [dbo].[$TablePrefix_Forum_Advertisement](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Title] [nchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[IsUsing] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Advertisement_IsUsing] DEFAULT ((0)),
[Orders] [int] NULL,
[AddTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Advertisement_AddTime] DEFAULT (getdate()),
CONSTRAINT [PK_$TablePrefix_Forum_Advertisement] PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_Board]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[$TablePrefix_Forum_Board]
CREATE TABLE [dbo].[$TablePrefix_Forum_Board](
[ID] [int] NOT NULL,
[FatherID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_FatherID] DEFAULT ((0)),
[FatherPath] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Depth] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_Depth] DEFAULT ((0)),
[RootID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_RootID] DEFAULT ((0)),
[ChildNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildNum] DEFAULT ((0)),
[Orders] [int] NULL,
[ChildOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildOrderType] DEFAULT ((0)),
[ChildLineNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildLineNum] DEFAULT ((0)),
[BoardName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[AllowTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_AllowTopic] DEFAULT ((0)),
[ShowType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ShowType] DEFAULT ((0)),
[NeedConfirm] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_NeedConfirm] DEFAULT ((0)),
[Locked] [int] NULL,
[TitleColor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[BoardRule] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Master] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[MasterID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Photo] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,
[Logo] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[TopicCount] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TopicCount] DEFAULT ((0)),
[TotalTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TotalTopic] DEFAULT ((0)),
[TotalReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TotalReply] DEFAULT ((0)),
[TodayTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TodayTopic] DEFAULT ((0)),
[TodayReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TodayReply] DEFAULT ((0)),
[ActiveBoardID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveBoardID] DEFAULT ((0)),
[ActiveTopicID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveTopicID] DEFAULT ((0)),
[ActiveTopicTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ActiveUser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ActiveUserID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveUserID] DEFAULT ((0)),
[ActiveTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveTime] DEFAULT (getdate()),
[LevelID] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[TeamID] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[PowerType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_PowerType] DEFAULT ((0)),
[TopicOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TopicOrderType] DEFAULT ((0)),
[TopicPerPage] [int] NULL,
[ReplyPerPage] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ReplyPerPage] DEFAULT ((0)),
[TemplateID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TemplateID] DEFAULT ((0)),
[SkinID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_SkinID] DEFAULT ((0)),
[AddTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_AddTime] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_BoardRecycle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[$TablePrefix_Forum_BoardRecycle]
CREATE TABLE [dbo].[$TablePrefix_Forum_BoardRecycle](
[ID] [int] NOT NULL,
[FatherID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_FatherID] DEFAULT ((0)),
[FatherPath] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Depth] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_Depth] DEFAULT ((0)),
[RootID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_RootID] DEFAULT ((0)),
[ChildNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildNum] DEFAULT ((0)),
[Orders] [int] NULL,
[ChildOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildOrderType] DEFAULT ((0)),
[ChildLineNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildLineNum] DEFAULT ((0)),
[BoardName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[AllowTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_AllowTopic] DEFAULT ((0)),
[ShowType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ShowType] DEFAULT ((0)),
[NeedConfirm] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_NeedConfirm] DEFAULT ((0)),
[Locked] [int] NULL,
[TitleColor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[BoardRule] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Master] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[MasterID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Photo] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,
[Logo] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[TopicCount] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TopicCount] DEFAULT ((0)),
[TotalTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TotalTopic] DEFAULT ((0)),
[TotalReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TotalReply] DEFAULT ((0)),
[TodayTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TodayTopic] DEFAULT ((0)),
[TodayReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TodayReply] DEFAULT ((0)),
[ActiveBoardID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveBoardID] DEFAULT ((0)),
[ActiveTopicID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveTopicID] DEFAULT ((0)),
[ActiveTopicTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ActiveUser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ActiveUserID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveUserID] DEFAULT ((0)),
[ActiveTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveTime] DEFAULT (getdate()),
[LevelID] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[TeamID] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[PowerType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_PowerType] DEFAULT ((0)),
[TopicOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TopicOrderType]
没有合适的资源?快使用搜索试试~ 我知道了~
大侠论坛8.1
共498个文件
gif:220个
ascx:114个
aspx:103个
需积分: 3 28 下载量 126 浏览量
2007-11-23
22:48:34
上传
评论
收藏 1.06MB RAR 举报
温馨提示
大侠论坛8.1,学习ASP.NET编程。
资源详情
资源评论
资源推荐
收起资源包目录
大侠论坛8.1 (498个子文件)
ControlPanel.ascx 38KB
Admin_TemplateEdit.ascx 28KB
Team.ascx 20KB
Admin_ConfigAll.ascx 17KB
PostEdit.ascx 15KB
Admin_LevelAdd.ascx 14KB
Admin_UserSearch.ascx 11KB
Admin_UserAdd.ascx 11KB
Admin_Left.ascx 10KB
Admin_ConfigSecurity.ascx 10KB
Admin_BoardRightAdd.ascx 10KB
Board.ascx 9KB
Admin_BoardAdd.ascx 9KB
Topic.ascx 8KB
Admin_ConfigPoint.ascx 8KB
Admin_TopicSearch.ascx 8KB
Admin_MessageSend.ascx 7KB
TopicEdit.ascx 6KB
Post.ascx 6KB
BoardNews.ascx 6KB
Admin_ConfigUpload.ascx 5KB
Reply.ascx 5KB
Register.ascx 5KB
Index.ascx 5KB
BoardLog.ascx 5KB
Admin_User.ascx 5KB
Admin_MenuAdd.ascx 4KB
Search.ascx 4KB
Admin_UserRecycle.ascx 4KB
Admin_Topic.ascx 4KB
Admin_TopicConfirm.ascx 4KB
Admin_ConfigPicture.ascx 4KB
Admin_TopicRecycle.ascx 4KB
Admin_Message.ascx 4KB
Admin_Skin.ascx 4KB
Admin_Team.ascx 4KB
Admin_Link.ascx 3KB
Admin_Group.ascx 3KB
Admin_Menu.ascx 3KB
Admin_Face.ascx 3KB
Admin_Emote.ascx 3KB
Admin_Advertisement.ascx 3KB
Admin_UploadFile.ascx 3KB
Admin_Template.ascx 3KB
ShowVote.ascx 3KB
Admin_ReplyRecycle.ascx 3KB
Admin_Log.ascx 3KB
Admin_UploadFace.ascx 3KB
Admin_Level.ascx 3KB
Admin_BoardRecycle.ascx 3KB
Admin_TeamAdd.ascx 3KB
Admin_IP.ascx 3KB
Admin_Replace.ascx 3KB
ForumTopic.ascx 3KB
Admin_News.ascx 3KB
Admin_LogView.ascx 3KB
Information.ascx 3KB
BoardRepeater.ascx 3KB
Admin_TopicMove.ascx 3KB
Login.ascx 2KB
Members.ascx 2KB
ForgetPassword.ascx 2KB
Admin_LinkAdd.ascx 2KB
Admin_RefreshCache.ascx 2KB
Admin_FaceAdd.ascx 2KB
Admin_EmoteAdd.ascx 2KB
Left.ascx 2KB
Admin_TopicDel.ascx 2KB
Admin_Board.ascx 2KB
Frame.ascx 2KB
Admin_GroupAdd.ascx 2KB
Admin_NewsAdd.ascx 2KB
SendMessage.ascx 2KB
UserPanel.ascx 2KB
ForumPager.ascx 2KB
UserFace.ascx 2KB
Admin_SkinAdd.ascx 2KB
Admin_ReplaceAdd.ascx 2KB
Admin_AdvertisementAdd.ascx 1KB
Admin_BoardRight.ascx 1KB
Admin_UserRename.ascx 1KB
Admin_IPAdd.ascx 1KB
Admin_TemplateAdd.ascx 1KB
Admin_History.ascx 1KB
UserOnline.ascx 1KB
PostEditMenu.ascx 1KB
VoteView.ascx 1KB
LoginForm.ascx 1KB
GroupList.ascx 1KB
MessageView.ascx 1KB
Admin_Index.ascx 1KB
MasterPage.ascx 971B
NewsView.ascx 949B
AdminMasterPage.ascx 818B
Admin_MessageView.ascx 787B
IsOnline.ascx 780B
Possition.ascx 760B
ForumNews.ascx 693B
Admin_TemplatePage.ascx 669B
Admin_CSS.ascx 661B
共 498 条
- 1
- 2
- 3
- 4
- 5
wilsonmiao
- 粉丝: 0
- 资源: 15
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0