CREATE TABLE [Mir_ServerList] (
	[serverId] [int] IDENTITY (1, 1) NOT NULL ,
	[serverName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[serverIp] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverNameColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverVersion] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverIpColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverOpenTime] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverLine] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverDomain] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverState] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverSequence] [int] NULL ,
	[serverRentCompany] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRentCompanyUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRent] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRentCompanyTel] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRentCompanyMobile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRentCompanyLinkMan] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[serverRentStarDate] [smalldatetime] NULL ,
	[serverRentEndDate] [smalldatetime] NULL ,
	[deleted] [int] NOT NULL CONSTRAINT [DF_Mir_ServerList_deleted] DEFAULT (0),
	CONSTRAINT [PK_Mir_ServerList] PRIMARY KEY  CLUSTERED 
	(
		[serverId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_SaleItem_Sort] (
	[CategoryId] [int] IDENTITY (1, 1) NOT NULL ,
	[SaleItemSortName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SaleItemSortDescn] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SaleItemSortImage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Mir_SaleItem_Sort] PRIMARY KEY  CLUSTERED 
	(
		[CategoryId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_SaleItem_rollNews] (
	[newsContent] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[addTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_SaleItem_rollNews_addTime] DEFAULT (getdate())
) ON [PRIMARY]
GO



CREATE TABLE [Mir_SaleItem_huiKuanShuoMing] (
	[newsContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[createTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_SaleItem_huiKuanShuoMing_addTime] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_SaleItem] (
	[ItemId] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelId] [int] NULL ,
	[ClassId] [int] NULL ,
	[CategoryId] [int] NULL ,
	[taozhuangPrice] [int] NULL ,
	[taozhuangType] [int] NOT NULL CONSTRAINT [DF_Mir_SaleItem_taozhuangType] DEFAULT (0),
	[taozhuangName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[taozhuangLvl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[taozhuangImg] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[taozhuangProperty] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[clothName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bladeName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[fireName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[armetName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[necklaceName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bangleName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ringName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[waistbandName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[shoeName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[stoneName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[otherItemName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[clothPrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bladePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[firePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[armetPrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[necklacePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[banglePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ringPrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[waistbandPrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[shoePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[stonePrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[otherItemPrice] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[clothProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bladeProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[fireProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[armetProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[necklaceProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bangleProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ringProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[waistbandProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[shoeProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[stoneProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[otherItemProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Status] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpdateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_SaleItem_UpdateTime] DEFAULT (getdate()),
	[CreateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_SaleItem_CreateTime] DEFAULT (getdate()),
	CONSTRAINT [PK_Mir_SaleItem] PRIMARY KEY  CLUSTERED 
	(
		[ItemId]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



CREATE TABLE [Mir_Poll_Title] (
	[PollTitleId] [int] IDENTITY (1, 1) NOT NULL ,
	[PollTitleName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PollTitleDescn] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Mir_Poll_Title] PRIMARY KEY  CLUSTERED 
	(
		[PollTitleId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



CREATE TABLE [Mir_Poll] (
	[PollId] [int] IDENTITY (1, 1) NOT NULL ,
	[PollName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClickCount] [int] NULL ,
	[PollTitleId] [int] NULL ,
	CONSTRAINT [PK_Mir_Poll] PRIMARY KEY  CLUSTERED 
	(
		[PollId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_News_AutoContribute] (
	[NewsId] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelId] [int] NULL ,
	[ClassId] [int] NULL CONSTRAINT [DF_Mir_News_AutoContribute_ClassId] DEFAULT (0),
	[SpreadHead] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SubHead] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitlePicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitleFontColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DutyEditor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClickCount] [int] NULL CONSTRAINT [DF_Mir_News_AutoContribute_ClickCount] DEFAULT (0),
	[UpdateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_News_AutoContribute_UpdateTime] DEFAULT (getdate()),
	[CreateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_News_AutoContribute_CreateTime] DEFAULT (getdate()),
	[OnTop] [int] NOT NULL CONSTRAINT [DF_Mir_News_AutoContribute_OnTop] DEFAULT (0),
	[Elite] [int] NOT NULL CONSTRAINT [DF_Mir_News_AutoContribute_Elite] DEFAULT (0),
	[Deleted] [int] NOT NULL CONSTRAINT [DF_Mir_News_AutoContribute_Deleted] DEFAULT (0),
	[Status] [int] NOT NULL CONSTRAINT [DF_Mir_News_AutoContribute_Status] DEFAULT (0),
	CONSTRAINT [PK_Mir_News_AutoContribute] PRIMARY KEY  CLUSTERED 
	(
		[NewsId]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_News] (
	[NewsId] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelId] [int] NULL ,
	[ClassId] [int] NOT NULL CONSTRAINT [DF_Mir_News_ClassId] DEFAULT (0),
	[SpreadHead] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SubHead] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitlePicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitleFontColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DutyEditor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClickCount] [int] NOT NULL CONSTRAINT [DF_Mir_News_ClickCount] DEFAULT (0),
	[UpdateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_Mir_News_UpdateTime] DEFAULT (getdate()),
	[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_Mir_News_CreateTime] DEFAULT (getdate()),
	[OnTop] [int] NOT NULL CONSTRAINT [DF_Mir_News_OnTop] DEFAULT (0),
	[Elite] [int] NOT NULL CONSTRAINT [DF_Mir_News_Elite] DEFAULT (0),
	[Deleted] [int] NOT NULL CONSTRAINT [DF_Mir_News_Deleted] DEFAULT (0),
	[Status] [int] NOT NULL CONSTRAINT [DF_Mir_News_Status] DEFAULT (0),
	CONSTRAINT [PK_Mir_News] PRIMARY KEY  CLUSTERED 
	(
		[NewsId]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [Mir_Links] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[linkName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[linkAlt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[linkUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[linkImg] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[isImg] [int] NULL ,
	CONSTRAINT [PK_Mir_Links] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_Kefu] (
	[KefuId] [int] IDENTITY (1, 1) NOT NULL ,
	[KefuName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[KefuValue] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Mir_Kefu] PRIMARY KEY  CLUSTERED 
	(
		[KefuId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



CREATE TABLE [Mir_Gonggao_IndexPage] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[updateTime] [smalldatetime] NULL ,
	[createTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Gonggao_IndexPage_createTime] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_Fav_BBSpropagandize] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bbsPropagandize] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[updateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Fav_BBSpropagandize_updateTime] DEFAULT (getdate()),
	[addTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Fav_BBSpropagandize_addTime] DEFAULT (getdate()),
	CONSTRAINT [PK_Mir_Fav_BBSpropagandize] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_Fav] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[favoriteCategory] [int] NULL ,
	[favName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[favAddr] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[favIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[favStarLvl] [int] NULL ,
	[favIsTop] [int] NULL ,
	[favSequence] [int] NULL ,
	[favUserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[favUserPwd] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[addTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Fav_addTime] DEFAULT (getdate()),
	[updateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Fav_updateTime] DEFAULT (getdate()),
	CONSTRAINT [PK_Mir_Fav] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_dlq] (
	[dlqType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[dlqDownUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_Config] (
	[SiteName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SiteUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteCreateTime] [smalldatetime] NULL ,
	[SiteTitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[WebmasterEmail] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Keywords] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Description] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Copyright] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IndexPageNewsNum] [int] NULL ,
	[AdminDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestBook_ShowIP] [int] NULL ,
	[GuestBook_MaxPerPage] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableRss] [int] NULL ,
	[RssCodeType] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_Comment] (
	[CommentID] [int] IDENTITY (1, 1) NOT NULL ,
	[ModuleType] [int] NULL ,
	[InfoID] [int] NOT NULL ,
	[UserType] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Sex] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[OICQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MSN] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ICQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Homepage] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[WriteTime] [smalldatetime] NOT NULL CONSTRAINT [DF_Mir_Comment_WriteTime] DEFAULT (getdate()),
	[Score] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyTime] [smalldatetime] NULL ,
	[Passed] [int] NULL ,
	CONSTRAINT [PK_Mir_Comment] PRIMARY KEY  CLUSTERED 
	(
		[CommentID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [Mir_Class] (
	[ClassId] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelId] [int] NOT NULL CONSTRAINT [DF_Mir_Class_ChannelId] DEFAULT (0),
	[ClassName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassType] [int] NULL ,
	[OpenType] [int] NULL ,
	[ParentID] [int] NULL ,
	[ParentPath] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Depth] [int] NULL ,
	[RootID] [int] NULL ,
	[Child] [int] NULL ,
	[arrChildID] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PrevID] [int] NULL ,
	[NextID] [int] NULL ,
	[OrderId] [int] NOT NULL CONSTRAINT [DF_Mir_Class_OrderId] DEFAULT (0),
	[Tips] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Readme] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Keywords] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Description] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassPicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ParentDir] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SkinID] [int] NULL ,
	[TemplateID] [int] NULL ,
	[ShowOnTop] [int] NULL ,
	[ShowOnIndex] [int] NULL ,
	[IsElite] [int] NULL ,
	[EnableAdd] [int] NULL ,
	[EnableProtect] [int] NULL ,
	[MaxPerPage] [int] NULL ,
	[DefaultItemTemplate] [int] NULL ,
	[DefaultItemSkin] [int] NULL ,
	[ItemListOrderType] [int] NULL ,
	[ItemOpenType] [int] NULL ,
	[ItemCount] [int] NULL ,
	[ClassPurview] [tinyint] NULL ,
	[EnableComment] [int] NOT NULL CONSTRAINT [DF_Mir_Class_EnableComment] DEFAULT (0),
	[CheckComment] [int] NOT NULL CONSTRAINT [DF_Mir_Class_CheckComment] DEFAULT (0),
	[EnableTougao] [int] NOT NULL CONSTRAINT [DF_Mir_Class_EnableTougao] DEFAULT (0),
	[CheckTougao] [int] NOT NULL CONSTRAINT [DF_Mir_Class_CheckTougao] DEFAULT (0),
	CONSTRAINT [PK_Mir_Class] PRIMARY KEY  CLUSTERED 
	(
		[ClassId]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


CREATE TABLE [Mir_Channel] (
	[ChannelID] [int] NOT NULL ,
	[ChannelName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ChannelShortName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelItemUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReadMe] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Keywords] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Meta_Description] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelPicUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OrderID] [int] NOT NULL CONSTRAINT [DF_Mir_Channel_OrderID] DEFAULT (0),
	[OpenType] [int] NULL ,
	[ChannelType] [int] NULL ,
	[LinkUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Disabled] [int] NULL ,
	[ShowName] [int] NULL ,
	[ShowNameOnPath] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowClassTreeGuide] [int] NULL ,
	[ShowSuspensionPoints] [int] NULL ,
	[CheckLevel] [int] NULL ,
	[EnableUploadFile] [int] NULL ,
	[UploadDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MaxFileSize] [int] NULL ,
	[HitsOfHot] [int] NULL ,
	[DaysOfNew] [int] NULL ,
	[MaxPerLine] [int] NULL ,
	[UpFileType] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[DefaultSkinID] [int] NULL ,
	[Template_Index] [int] NULL ,
	[TopMenuType] [int] NULL ,
	[ClassGuideType] [int] NULL ,
	[UseCreateHTML] [int] NOT NULL ,
	[ItemCount] [int] NULL ,
	[ItemChecked] [int] NULL ,
	[CommentCount] [int] NULL ,
	[SpecialCount] [int] NULL ,
	[HitsCount] [int] NULL ,
	[StructureType] [int] NULL ,
	[ListFileType] [int] NULL ,
	[FileNameType] [int] NULL ,
	[AutoCreateType] [int] NULL ,
	[FileExt_Index] [int] NULL ,
	[FileExt_List] [int] NULL ,
	[FileExt_Item] [int] NULL ,
	[UpdatePages] [int] NULL ,
	[ChannelPurview] [int] NULL ,
	[arrGroupID] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[JS_SpecialNum] [int] NULL ,
	[AuthorInfoLen] [int] NULL ,
	[MaxPerPage_Index] [int] NULL ,
	[MaxPerPage_SearchResult] [int] NULL ,
	[MaxPerPage_New] [int] NULL ,
	[MaxPerPage_Hot] [int] NULL ,
	[MaxPerPage_Elite] [int] NULL ,
	[MaxPerPage_SpecialList] [int] NULL ,
	[MoneyPerKw] [money] NULL ,
	[TimingCreateSetting] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfReject] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfPassed] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Custom_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrEnabledTabs] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandChannelPoint] [int] NULL ,
	[Fields_Options] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Mir_Channel] PRIMARY KEY  CLUSTERED 
	(
		[ChannelID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



CREATE TABLE [Mir_Admin_role] (
	[id] [int] NOT NULL ,
	[adminRoleLvl] [int] NULL ,
	[adminRoleName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[adminRoleExplain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Mir_Admin_role] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



CREATE TABLE [Mir_Admin_loginLog] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[adminName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lastLoginIp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lastLoginTimeS] [smalldatetime] NULL CONSTRAINT [DF_Mir_Admin_loginLog_lastLoginTimeS] DEFAULT (getdate()),
	[lastLoginTimeC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[lastLogOutTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Admin_loginLog_lastLogOutTime] DEFAULT (getdate()),
	[isPassPhoto] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[isPass] [int] NULL ,
	CONSTRAINT [PK_Mir_Admin_loginLog] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO


CREATE TABLE [Mir_Admin] (
	[UserId] [int] IDENTITY (1, 1) NOT NULL ,
	[AdminName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AdminNameHash] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminPwd] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[UserQuestion] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserAnswer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserRoleLvl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableMultiLogin] [int] NULL ,
	[UpdateTime] [smalldatetime] NULL CONSTRAINT [DF_Mir_Admin_UpdateTime] DEFAULT (getdate()),
	[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_Mir_Admin_CreateTime] DEFAULT (getdate()),
	CONSTRAINT [PK_Mir_Admin] PRIMARY KEY  CLUSTERED 
	(
		[UserId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

CREATE TABLE [cms_site_counter] (
	[CountId] [bigint] IDENTITY (1, 1) NOT NULL ,
	[UrlReferrer] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Browser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClrVersion] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserHostAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_Mir_Site_Count_CreateTime] DEFAULT (getdate()),
	CONSTRAINT [PK_cms_site_count] PRIMARY KEY  CLUSTERED 
	(
		[CountId]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




