easy2006.sql

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

SQL
1,606 行
字号
12345
	[Position] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Operation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CompanyAddress] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[QQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ICQ] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[MSN] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Yahoo] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[UC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Aim] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[OfficePhone] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HomePhone] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[PHS] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Fax] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [nvarchar] (30) 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 ,
	[NativePlace] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Nation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Birthday] [datetime] NULL ,
	[IDCard] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Marriage] [tinyint] NULL ,
	[Family] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Income] [int] NULL ,
	[Education] [int] NULL ,
	[GraduateFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InterestsOfLife] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InterestsOfCulture] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InterestsOfAmusement] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InterestsOfSport] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[InterestsOfOther] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreateTime] [datetime] NULL ,
	[UpdateTime] [datetime] NULL ,
	[Owner] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_CopyFrom] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [smallint] NULL ,
	[SourceName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS 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 ,
	[Mail] [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 ,
	[ContacterName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SourceType] [smallint] NULL ,
	[Passed] [bit] NOT NULL ,
	[onTop] [bit] NOT NULL ,
	[IsElite] [bit] NOT NULL ,
	[Hits] [int] NULL ,
	[LastUseTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Country] (
	[CountryID] [int] IDENTITY (1, 1) NOT NULL ,
	[Country] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_DeliverCharge] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[DeliverTypeID] [int] NULL ,
	[AreaType] [int] NULL ,
	[arrArea] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Charge_Min] [money] NULL ,
	[Weight_Min] [float] NULL ,
	[ChargePerUnit] [money] NULL ,
	[WeightPerUnit] [float] NULL ,
	[Charge_Max] [money] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_DeliverItem] (
	[DeliverID] [int] IDENTITY (1, 1) NOT NULL ,
	[OrderFormID] [int] NULL ,
	[DeliverDate] [datetime] NULL ,
	[DeliverDirection] [int] NULL ,
	[HandlerName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ExpressCompany] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ExpressNumber] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Inputer] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Received] [bit] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_DeliverType] (
	[TypeID] [int] NOT NULL ,
	[TypeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Intro] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChargeType] [int] NULL ,
	[IsDefault] [bit] NOT NULL ,
	[IsDisabled] [bit] NOT NULL ,
	[OrderID] [int] NULL ,
	[ReleaseType] [int] NULL ,
	[MinMoney1] [money] NULL ,
	[ReleaseCharge] [money] NULL ,
	[MinMoney2] [money] NULL ,
	[MaxCharge] [money] NULL ,
	[MinMoney3] [money] NULL ,
	[Charge_Min] [money] NULL ,
	[Charge_Max] [money] NULL ,
	[Charge_Percent] [smallint] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Dictionary] (
	[FieldID] [int] IDENTITY (1, 1) NOT NULL ,
	[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TableName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FieldName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FieldValue] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_DownError] (
	[ErrorID] [int] NOT NULL ,
	[ChannelID] [int] NULL ,
	[InfoID] [int] NULL ,
	[UrlID] [int] NULL ,
	[ErrorTimes] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_DownServer] (
	[ServerID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [int] NULL ,
	[ServerName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServerUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServerLogo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[OrderID] [int] NULL ,
	[ShowType] [int] NULL ,
	[InfoPoint] [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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Equipment] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassroomID] [int] NULL ,
	[EquipmentName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EquipmentIntroduce] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[EquipmentSituation] [int] NULL ,
	[EquipmentValue] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Explain] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Favorite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserID] [int] NULL ,
	[ChannelID] [int] NULL ,
	[InfoID] [int] NULL ,
	[DateAndTime] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Field] (
	[FieldID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelID] [int] NULL ,
	[FieldName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LabelName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tips] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[FieldType] [int] NULL ,
	[DefaultValue] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Options] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EnableNull] [bit] NOT NULL ,
	[ShowOnForm] [bit] NOT NULL ,
	[FieldLevel] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Filters] (
	[FilterID] [int] IDENTITY (1, 1) NOT NULL ,
	[ItemID] [int] NULL ,
	[FilterName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FilterObject] [int] NULL ,
	[FilterType] [int] NULL ,
	[FilterContent] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FisString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FioString] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FilterRep] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Flag] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_Friend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[FriendName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[AddTime] [datetime] NULL ,
	[GroupID] [tinyint] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_FriendSite] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[KindID] [int] NULL ,
	[SpecialID] [int] NULL ,
	[LinkType] [int] NULL ,
	[SiteName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteIntro] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[LogoUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteAdmin] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteEmail] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SitePassword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stars] [int] NULL ,
	[Hits] [int] NULL ,
	[UpdateTime] [datetime] NULL ,
	[Elite] [bit] NOT NULL ,
	[Passed] [bit] NOT NULL ,
	[OrderID] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_FsKind] (
	[KindID] [int] NOT NULL ,
	[KindName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ReadMe] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[KindType] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_GuestBook] (
	[GuestID] [int] NOT NULL ,
	[KindID] [int] NULL ,
	[TopicID] [int] NULL ,
	[GuestMaxID] [int] NULL ,
	[GuestType] [int] NULL ,
	[GuestName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestSex] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestOicq] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestMsn] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestIcq] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestEmail] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestHomepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestImages] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestFace] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestIP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestTitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestDatetime] [datetime] NULL ,
	[Hits] [int] NULL ,
	[ReplyNum] [int] NULL ,
	[LastReplyContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[LastReplyGuest] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastReplyTime] [datetime] NULL ,
	[LastReplyTitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestReply] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestReplyAdmin] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[GuestReplyDatetime] [datetime] NULL ,
	[Quintessence] [int] NULL ,
	[GuestIsPassed] [bit] NOT NULL ,
	[GuestIsPrivate] [bit] NOT NULL ,
	[OnTop] [int] NULL ,
	[ReplyIsPrivate] [bit] NOT NULL ,
	[GuestContentLength] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_GuestKind] (
	[KindID] [int] NOT NULL ,
	[KindName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ReadMe] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[OrderID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_HistrolyNews] (
	[HistrolyNewsID] [int] IDENTITY (1, 1) NOT NULL ,
	[ItemID] [int] NULL ,
	[ChannelID] [int] NULL ,
	[ClassID] [int] NULL ,
	[ArticleID] [int] NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsCollecDate] [datetime] NULL ,
	[NewsUrl] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Result] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_HouseArea] (
	[AreaID] [int] NOT NULL ,
	[AreaName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PE_HouseCS] (
	[HouseID] [int] NOT NULL ,
	[ClassID] [int] NULL ,
	[ChannelID] [int] NULL ,
	[HouseSource] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseQuyu] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseDiZhi] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseXiangXiDiZhi] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseHuXing] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseMianJi] [real] NOT NULL ,
	[HouseChanQuan] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseJianCheng] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseLouCeng] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseChaoXiang] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HouseLeiXing] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
12345

easy2006.sql - 源码说明

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

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

⌨️ 快捷键说明

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