easy2006.sql

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

SQL
1,606 行
字号
12345
	[KeyStr] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[KeyScatterNum] [int] NULL ,
	[NewsPaingType] [int] NULL ,
	[NpsString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[NpoString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsPaingStr1] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsPaingStr2] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Flag] [bit] NOT NULL ,
	[PaginationType] [int] NULL ,
	[MaxCharPerPage] [int] NULL ,
	[InfoPoint] [int] NULL ,
	[OnTop] [bit] NOT NULL ,
	[Hot] [bit] NOT NULL ,
	[Elite] [bit] NOT NULL ,
	[Hits] [int] NOT NULL ,
	[Stars] [int] NULL ,
	[UpdateTime] [datetime] NOT NULL ,
	[SkinID] [int] NULL ,
	[TemplateID] [int] NULL ,
	[Script_IFRAME] [bit] NOT NULL ,
	[Script_OBJECT] [bit] NOT NULL ,
	[Script_SCRIPT] [bit] NOT NULL ,
	[Script_Div] [bit] NOT NULL ,
	[Script_CLASS] [bit] NOT NULL ,
	[Script_Span] [bit] NOT NULL ,
	[Script_IMG] [bit] NOT NULL ,
	[Script_FONT] [bit] NOT NULL ,
	[Script_A] [bit] NOT NULL ,
	[Script_HTML] [bit] NOT NULL ,
	[SaveFiles] [bit] NOT NULL ,
	[AddThumb] [bit] NOT NULL ,
	[AddWatermark] [bit] NOT NULL ,
	[CollecOrder] [int] NULL ,
	[Status] [int] NULL ,
	[CreateImmediate] [bit] NOT NULL ,
	[IncludePicYn] [bit] NOT NULL ,
	[DefaultPicYn] [bit] NOT NULL ,
	[NewsCollecDate] [datetime] NULL ,
	[CollectionNum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CollectionType] [int] NULL ,
	[UpDateType] [int] NULL ,
	[DateType] [int] NULL ,
	[DsString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DoString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowCommentLink] [bit] NOT NULL ,
	[Script_Table] [bit] NOT NULL ,
	[Script_Tr] [bit] NOT NULL ,
	[Script_Td] [bit] NOT NULL ,
	[PsString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PoString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PhsString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PhoString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IntroType] [int] NULL ,
	[IsString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IoString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IntroStr] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IntroNum] [int] NULL ,
	[IsField] [int] NULL ,
	[Field] [ntext] COLLATE Chinese_PRC_CI_AS 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 ,
	[SaveFlashUrlToFile] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_JobCategory] (
	[JobCategoryID] [int] NOT NULL ,
	[JobCategoryName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[OrderID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_JsFile] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [int] NULL ,
	[JsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[JsReadme] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[JsType] [int] NULL ,
	[ContentType] [int] NULL ,
	[JsFileName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Config] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_KeyLink] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [smallint] NULL ,
	[Source] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReplaceText] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[isUse] [tinyint] NULL ,
	[LinkType] [tinyint] NULL ,
	[OpenType] [tinyint] NULL ,
	[ReplaceType] [smallint] NULL ,
	[Priority] [smallint] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Label] (
	[LabelID] [int] IDENTITY (1, 1) NOT NULL ,
	[LabelName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LabelClass] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LabelType] [smallint] NULL ,
	[PageNum] [int] NULL ,
	[reFlashTime] [smallint] NULL ,
	[fieldlist] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LabelIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Priority] [int] NULL ,
	[LabelContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[AreaCollectionID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Log] (
	[LogID] [int] IDENTITY (1, 1) NOT NULL ,
	[LogType] [int] NULL ,
	[ChannelID] [int] NULL ,
	[LogTime] [datetime] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserIP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[LogContent] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ScriptName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostString] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Message] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sender] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[incept] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[flag] [int] NULL ,
	[sendtime] [datetime] NULL ,
	[delR] [int] NOT NULL ,
	[delS] [int] NOT NULL ,
	[isSend] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_NewKeys] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [smallint] NULL ,
	[KeyText] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hits] [int] NULL ,
	[LastUseTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_OrderForm] (
	[OrderFormID] [int] NOT NULL ,
	[OrderFormNum] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AgentName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClientID] [int] NULL ,
	[MoneyTotal] [money] NULL ,
	[MoneyGoods] [money] NULL ,
	[NeedInvoice] [bit] NOT NULL ,
	[InvoiceContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Invoiced] [bit] NOT NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MoneyReceipt] [money] NULL ,
	[BeginDate] [datetime] NULL ,
	[InputTime] [datetime] NULL ,
	[ContacterName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZipCode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PaymentType] [int] NULL ,
	[DeliverType] [int] NULL ,
	[Status] [int] NULL ,
	[DeliverStatus] [int] NULL ,
	[EnableDownload] [bit] NOT NULL ,
	[PresentMoney] [money] NULL ,
	[PresentPoint] [int] NULL ,
	[PresentExp] [int] NULL ,
	[Discount_Payment] [float] NULL ,
	[Charge_Deliver] [money] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_OrderFormItem] (
	[ItemID] [int] NOT NULL ,
	[OrderFormID] [int] NULL ,
	[ProductID] [int] NULL ,
	[SaleType] [int] NULL ,
	[Price_Original] [money] NULL ,
	[Price] [money] NULL ,
	[TruePrice] [money] NULL ,
	[Amount] [int] NULL ,
	[SubTotal] [money] NULL ,
	[BeginDate] [datetime] NULL ,
	[ServiceTerm] [int] NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[PresentMoney] [money] NULL ,
	[PresentPoint] [int] NULL ,
	[PresentExp] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Page] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageName] [nvarchar] (160) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PageIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PageUrl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageFileName] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageType] [smallint] NULL ,
	[PageContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[arrGroupID] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_PageClass] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [nvarchar] (160) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ClassType] [smallint] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Payment] (
	[PaymentID] [int] NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[OrderFormID] [int] NULL ,
	[PaymentNum] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[eBankID] [int] NULL ,
	[MoneyPay] [money] NULL ,
	[MoneyTrue] [money] NULL ,
	[PayTime] [datetime] NULL ,
	[Status] [int] NULL ,
	[eBankInfo] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_PaymentType] (
	[TypeID] [int] NOT NULL ,
	[TypeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Intro] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Discount] [float] NULL ,
	[IsDefault] [bit] NOT NULL ,
	[OrderID] [int] NULL ,
	[IsDisabled] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Photo] (
	[PhotoID] [int] NOT NULL ,
	[ChannelID] [int] NOT NULL ,
	[ClassID] [int] NOT NULL ,
	[PhotoName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Author] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Editor] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Keyword] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Hits] [int] NULL ,
	[DayHits] [int] NULL ,
	[WeekHits] [int] NULL ,
	[MonthHits] [int] NULL ,
	[CommentCount] [int] NULL ,
	[UpdateTime] [datetime] NULL ,
	[CreateTime] [datetime] NULL ,
	[PhotoThumb] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[PhotoUrl] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PhotoSize] [int] NULL ,
	[OnTop] [bit] NOT NULL ,
	[Elite] [bit] NOT NULL ,
	[Status] [int] NOT NULL ,
	[PhotoIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[InfoPoint] [int] NULL ,
	[Deleted] [bit] NOT NULL ,
	[Stars] [int] NULL ,
	[LastHitTime] [datetime] NULL ,
	[TemplateID] [int] NULL ,
	[SkinID] [int] NULL ,
	[VoteID] [int] NULL ,
	[PresentExp] [float] 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_Position] (
	[PositionID] [int] NOT NULL ,
	[JobCategoryID] [int] NULL ,
	[SubCompanyID] [int] NULL ,
	[WorkPlaceID] [int] NULL ,
	[ReleaseDate] [datetime] NULL ,
	[PositionName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PositionNum] [int] NULL ,
	[ValidDate] [int] NULL ,
	[PositionKeyword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PositionDescription] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DutyRequest] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PositionStatus] [int] NULL ,
	[SubCompanyName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Urgent] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_PositionSupplyInfo] (
	[PositionSupplyInfoID] [int] NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PositionID] [int] NULL ,
	[SubCompanyID] [int] NULL ,
	[WorkPlac
12345

easy2006.sql - 源码说明

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

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

⌨️ 快捷键说明

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