easy2006.sql

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

SQL
1,606 行
字号
12345
CREATE TABLE [dbo].[PE_AdZone] (
	[ZoneID] [int] NOT NULL ,
	[ChannelID] [int] NULL ,
	[IncludeADID] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ZoneName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZoneJSName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZoneIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZoneType] [int] NULL ,
	[DefaultSetting] [bit] NOT NULL ,
	[ZoneSetting] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ZoneWidth] [int] NULL ,
	[ZoneHeight] [int] NULL ,
	[Active] [bit] NOT NULL ,
	[ShowType] [int] NULL ,
	[UpdateTime] [datetime] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Admin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdminName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Purview] [int] NOT NULL ,
	[RoleName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastLoginIP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastLoginTime] [datetime] NULL ,
	[LastLogoutTime] [datetime] NULL ,
	[LoginTimes] [int] NULL ,
	[RndPassword] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableMultiLogin] [bit] NOT NULL ,
	[AdminPurview_Article] [int] NULL ,
	[AdminPurview_Soft] [int] NULL ,
	[AdminPurview_Photo] [int] NULL ,
	[AdminPurview_GuestBook] [int] NULL ,
	[AdminPurview_Supply] [int] NULL ,
	[AdminPurview_House] [int] NULL ,
	[AdminPurview_Job] [int] NULL ,
	[AdminPurview_Shop] [int] NULL ,
	[AdminPurview_Others] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_View] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_Input] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_Check] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_Manage] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_House] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrClass_GuestBook] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Count_Add] [int] NULL ,
	[Count_Check] [int] NULL ,
	[Count_Reject] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Advertisement] (
	[ADID] [int] NOT NULL ,
	[UserID] [int] NULL ,
	[ZoneID] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ADType] [int] NULL ,
	[ADName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ImgUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ImgWidth] [int] NULL ,
	[ImgHeight] [int] NULL ,
	[FlashWmode] [int] NULL ,
	[ADIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkTarget] [int] NULL ,
	[LinkAlt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Priority] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Setting] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CountView] [bit] NOT NULL ,
	[Views] [int] NULL ,
	[CountClick] [bit] NOT NULL ,
	[Clicks] [int] NULL ,
	[Passed] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Announce] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[DateAndTime] [datetime] NULL ,
	[IsSelected] [bit] NOT NULL ,
	[ChannelID] [int] NULL ,
	[ShowType] [int] NULL ,
	[OutTime] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_AreaCollection] (
	[AreaID] [int] IDENTITY (1, 1) NOT NULL ,
	[AreaName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaFile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Code] [int] NULL ,
	[StringReplace] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[LableStart] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[LableEnd] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FilterProperty] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileType] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaPassed] [bit] NOT NULL ,
	[Type] [tinyint] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Article] (
	[ArticleID] [int] NOT NULL ,
	[ChannelID] [int] NOT NULL ,
	[ClassID] [int] NOT NULL ,
	[Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TitleIntact] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Subheading] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Editor] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Keyword] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Hits] [int] NOT NULL ,
	[CommentCount] [int] NULL ,
	[UpdateTime] [datetime] NOT NULL ,
	[CreateTime] [datetime] NULL ,
	[OnTop] [bit] NOT NULL ,
	[Elite] [bit] NOT NULL ,
	[Status] [int] NOT NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IncludePic] [int] NOT NULL ,
	[DefaultPicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[UploadFiles] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[InfoPoint] [int] NULL ,
	[PaginationType] [int] NULL ,
	[Deleted] [bit] NOT NULL ,
	[SkinID] [int] NULL ,
	[TemplateID] [int] NULL ,
	[Stars] [int] NULL ,
	[TitleFontColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitleFontType] [int] NULL ,
	[MaxCharPerPage] [int] NULL ,
	[ShowCommentLink] [bit] NOT NULL ,
	[Receive] [bit] NOT NULL ,
	[ReceiveUser] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Received] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[AutoReceiveTime] [int] NULL ,
	[ReceiveType] [int] NULL ,
	[Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PresentExp] [float] NULL ,
	[Copymoney] [money] NULL ,
	[IsPayed] [bit] NOT NULL ,
	[Beneficiary] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[PayDate] [datetime] NULL ,
	[VoteID] [int] NULL ,
	[InfoPurview] [int] NULL ,
	[arrGroupID] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeType] [int] NULL ,
	[PitchTime] [int] NULL ,
	[ReadTimes] [int] NULL ,
	[DividePercent] [int] NULL ,
	[BlogID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Author] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [smallint] NULL ,
	[AuthorName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Sex] [tinyint] NULL ,
	[BirthDay] [datetime] NULL ,
	[Photo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Intro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Company] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Department] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZipCode] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[QQ] [int] NULL ,
	[AuthorType] [smallint] NULL ,
	[LastUseTime] [datetime] NULL ,
	[Passed] [bit] NOT NULL ,
	[IsElite] [bit] NOT NULL ,
	[onTop] [bit] NOT NULL ,
	[Hits] [int] NULL ,
	[TemplateID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Bank] (
	[BankID] [int] NOT NULL ,
	[BankShortName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BankName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Accounts] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CardNum] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HolderName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BankIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[BankPic] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsDefault] [bit] NOT NULL ,
	[OrderID] [int] NULL ,
	[IsDisabled] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_BankrollItem] (
	[ItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClientID] [int] NULL ,
	[DateAndTime] [datetime] NULL ,
	[Money] [money] NULL ,
	[MoneyType] [int] NULL ,
	[CurrencyType] [int] NULL ,
	[eBankID] [int] NULL ,
	[Bank] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Income_PayOut] [int] NULL ,
	[OrderFormID] [int] NULL ,
	[PaymentID] [int] NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[LogTime] [datetime] NULL ,
	[Inputer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Card] (
	[CardID] [int] IDENTITY (1, 1) NOT NULL ,
	[CardType] [int] NULL ,
	[ProductID] [int] NULL ,
	[CardNum] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AgentName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Money] [money] NULL ,
	[ValidNum] [int] NULL ,
	[ValidUnit] [int] NULL ,
	[EndDate] [datetime] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UseTime] [datetime] NULL ,
	[CreateTime] [datetime] NULL ,
	[OrderFormItemID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_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 ,
	[OpenType] [int] NOT NULL ,
	[ChannelType] [int] NOT NULL ,
	[LinkUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ModuleType] [int] NULL ,
	[Disabled] [bit] NOT NULL ,
	[ShowName] [bit] NOT NULL ,
	[ShowNameOnPath] [bit] NOT NULL ,
	[ShowClassTreeGuide] [bit] NOT NULL ,
	[ShowSuspensionPoints] [bit] NOT NULL ,
	[CheckLevel] [int] NOT NULL ,
	[EnableUploadFile] [bit] NOT 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 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_City] (
	[AreaID] [int] IDENTITY (1, 1) NOT NULL ,
	[Country] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Province] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Area] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostCode] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaCode] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Class] (
	[ClassID] [int] NOT NULL ,
12345

easy2006.sql - 源码说明

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

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

⌨️ 快捷键说明

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