easy2006.sql

来自「江西旅行网整站源码下载 希望对大家有用 经过测试 安全可用」· SQL 代码 · 共 1,606 行 · 第 1/5 页

SQL
1,606 行
字号
12345
	[ChannelID] [int] NOT NULL ,
	[ClassName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassType] [int] NOT NULL ,
	[OpenType] [int] NOT NULL ,
	[ParentID] [int] NOT NULL ,
	[ParentPath] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Depth] [int] NOT NULL ,
	[RootID] [int] NOT NULL ,
	[Child] [int] NOT NULL ,
	[arrChildID] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PrevID] [int] NOT NULL ,
	[NextID] [int] NOT NULL ,
	[OrderID] [int] NOT NULL ,
	[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] [bit] NOT NULL ,
	[ShowOnIndex] [bit] NOT NULL ,
	[IsElite] [bit] NOT NULL ,
	[EnableAdd] [bit] NOT NULL ,
	[EnableProtect] [bit] NOT NULL ,
	[MaxPerPage] [int] NULL ,
	[DefaultItemTemplate] [int] NULL ,
	[DefaultItemSkin] [int] NULL ,
	[ItemListOrderType] [int] NULL ,
	[ItemOpenType] [int] NULL ,
	[ItemCount] [int] NULL ,
	[ClassPurview] [tinyint] NULL ,
	[EnableComment] [bit] NOT NULL ,
	[CheckComment] [bit] NOT NULL ,
	[PresentExp] [float] NULL ,
	[DefaultItemPoint] [float] NULL ,
	[DefaultItemChargeType] [int] NULL ,
	[DefaultItemPitchTime] [int] NULL ,
	[DefaultItemReadTimes] [int] NULL ,
	[DefaultItemDividePercent] [int] NULL ,
	[Custom_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandClassPoint] [int] NULL ,
	[ReleaseClassPoint] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Classroom] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FatherID] [int] NULL ,
	[ClassroomName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassroomIntroduce] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Client] (
	[ClientID] [int] NOT NULL ,
	[ParentID] [int] NULL ,
	[ClientNum] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClientType] [int] NULL ,
	[ClientName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShortedForm] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area] [int] NULL ,
	[ClientField] [int] NULL ,
	[ValueLevel] [int] NULL ,
	[CreditLevel] [int] NULL ,
	[Importance] [int] NULL ,
	[ConnectionLevel] [int] NULL ,
	[GroupID] [int] NULL ,
	[SourceType] [int] NULL ,
	[PhaseType] [int] NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[VisitTimes] [int] NULL ,
	[ServiceTimes] [int] NULL ,
	[ComplainTimes] [int] NULL ,
	[LastVisitTime] [datetime] NULL ,
	[LastServiceTime] [datetime] NULL ,
	[LastComplainTime] [datetime] NULL ,
	[CreateTime] [datetime] NULL ,
	[UpdateTime] [datetime] NULL ,
	[Owner] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Balance] [money] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_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] [datetime] NOT NULL ,
	[Score] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplyTime] [datetime] NULL ,
	[Passed] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Company] (
	[CompanyID] [int] NOT NULL ,
	[ClientID] [int] NULL ,
	[CompanyName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Province] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZipCode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[BankOfDeposit] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BankAccount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TaxNum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[StatusInField] [int] NULL ,
	[CompanySize] [int] NULL ,
	[BusinessScope] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[AnnualSales] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManagementForms] [int] NULL ,
	[RegisteredCapital] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CompanyIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CompamyPic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_ComplainItem] (
	[ItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClientID] [int] NULL ,
	[ContacterID] [int] NULL ,
	[ComplainType] [int] NULL ,
	[ComplainMode] [int] NULL ,
	[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FirstReceiver] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DateAndTime] [datetime] NULL ,
	[MagnitudeOfExigence] [int] NULL ,
	[Process] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Processor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Result] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EndTime] [datetime] NULL ,
	[Feedback] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ConfirmTime] [datetime] NULL ,
	[ConfirmCaller] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ConfirmScore] [int] NULL ,
	[ConfirmFeedback] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Status] [int] NULL ,
	[CurrentOwner] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Config] (
	[SiteName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InstallDir] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[LogoUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[WebmasterName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[WebmasterEmail] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Copyright] [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 ,
	[SiteKey] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowSiteChannel] [bit] NOT NULL ,
	[ShowAdminLogin] [bit] NOT NULL ,
	[EnableSaveRemote] [bit] NOT NULL ,
	[EnableLinkReg] [bit] NOT NULL ,
	[EnableCountFriendSiteHits] [bit] NOT NULL ,
	[EnableSoftKey] [bit] NOT NULL ,
	[objName_FSO] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ADDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AnnounceCookieTime] [int] NULL ,
	[HitsOfHot] [int] NULL ,
	[FileExt_SiteIndex] [int] NULL ,
	[FileExt_SiteSpecial] [int] NULL ,
	[SiteUrlType] [int] NULL ,
	[Modules] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[LockIPType] [int] NOT NULL ,
	[LockIP] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableUserReg] [bit] NOT NULL ,
	[EmailCheckReg] [bit] NOT NULL ,
	[AdminCheckReg] [bit] NOT NULL ,
	[EnableMultiRegPerEmail] [bit] NOT NULL ,
	[UserNameLimit] [int] NULL ,
	[UserNameMax] [int] NULL ,
	[UserName_RegDisabled] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[RegFields_MustFill] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableCheckCodeOfLogin] [bit] NOT NULL ,
	[EnableCheckCodeOfReg] [bit] NOT NULL ,
	[EnableQAofReg] [bit] NOT NULL ,
	[QAofReg] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PresentExp] [float] NULL ,
	[PresentMoney] [float] NULL ,
	[PresentPoint] [int] NULL ,
	[PresentValidNum] [int] NULL ,
	[PresentValidUnit] [int] NULL ,
	[MoneyExchangePoint] [float] NULL ,
	[MoneyExchangeValidDay] [float] NULL ,
	[UserExpExchangePoint] [float] NULL ,
	[UserExpExchangeValidDay] [float] NULL ,
	[PresentExpPerLogin] [int] NULL ,
	[PresentExpPerElite] [int] NULL ,
	[PointName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PointUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfRegCheck] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MailObject] [int] NULL ,
	[MailServer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MailServerUserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MailServerPassWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MailDomain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PhotoObject] [int] NULL ,
	[Thumb_DefaultWidth] [int] NULL ,
	[Thumb_DefaultHeight] [int] NULL ,
	[Thumb_Arithmetic] [int] NULL ,
	[Watermark_Type] [int] NULL ,
	[Watermark_Text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Watermark_Text_FontName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Watermark_Text_FontSize] [int] NULL ,
	[Watermark_Text_FontColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Watermark_Text_Bold] [bit] NOT NULL ,
	[Watermark_Images_FileName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Watermark_Images_Transparence] [int] NULL ,
	[Watermark_Images_BackgroundColor] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Watermark_Position_X] [int] NULL ,
	[Watermark_Position_Y] [int] NULL ,
	[Watermark_Position] [int] NULL ,
	[SearchInterval] [int] NULL ,
	[SearchResultNum] [int] NULL ,
	[MaxPerPage_SearchResult] [int] NULL ,
	[SearchContent] [bit] NOT NULL ,
	[EnableGuestBuy] [bit] NOT NULL ,
	[IncludeTax] [bit] NOT NULL ,
	[TaxRate] [int] NULL ,
	[PayOnlineProvider] [int] NULL ,
	[PayOnlineShopID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PayOnlineKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PayOnlineRate] [real] NULL ,
	[PayOnlinePlusPoundage] [bit] NOT NULL ,
	[Prefix_OrderFormNum] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Prefix_PaymentNum] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostCode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfOrderConfirm] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfOrderConfirm] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfSendCard] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfSendCard] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfReceiptMoney] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfReceiptMoney] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfRefund] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfRefund] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfInvoice] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfInvoice] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MessageOfDeliver] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailOfDeliver] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestBook_EnableVisitor] [bit] NOT NULL ,
	[GuestBookCheck] [bit] NOT NULL ,
	[GuestBook_EnableManageRubbish] [bit] NOT NULL ,
	[GuestBook_ManageRubbish] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestBook_ShowIP] [bit] NOT NULL ,
	[GuestBook_IsAssignSort] [bit] NOT NULL ,
	[GuestBook_MaxPerPage] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableRss] [bit] NOT NULL ,
	[RssCodeType] [bit] NOT NULL ,
	[EnableWap] [bit] NOT NULL ,
	[WapLogo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableWapPl] [bit] NOT NULL ,
	[ShowWapAppendix] [bit] NOT NULL ,
	[ShowWapShop] [bit] NOT NULL ,
	[ShowWapManage] [bit] NOT NULL ,
	[DatabaseVersion] [float] NULL ,
	[Timing_SetDate] [int] NULL ,
	[Timing_SetDay] [int] NULL ,
	[Timing_SetWeekday] [int] NULL ,
	[Timing_Time] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Timing_Date] [datetime] NULL ,
	[Timing_CollectionItemID] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Timing_AreaCollection] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Timing_Breakpoint] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IsCustom_Content] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_ConsumeLog] (
	[LogID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ModuleType] [int] NULL ,
	[InfoID] [int] NULL ,
	[Point] [real] NULL ,
	[LogTime] [datetime] NULL ,
	[Times] [int] NULL ,
	[Income_PayOut] [int] NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Contacter] (
	[ContacterID] [int] NOT NULL ,
	[ClientID] [int] NULL ,
	[ParentID] [int] NULL ,
	[UserType] [tinyint] NULL ,
	[TrueName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [smallint] NULL ,
	[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Company] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
12345

easy2006.sql - 源码说明

本页面展示了「江西旅行网整站源码下载 希望对大家有用 经过测试 安全可用」中的 easy2006.sql 源码文件，采用 SQL 编程语言编写，共 1,606 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与旅行相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?