程序源码 猎人游戏门户整站系统_lr（ASP.NET源码）.rar

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] [nv