我的网络兼职MVC项目开发-数据库

CREATE TABLE [dbo].[AdminInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [UserName] [varchar](50) NULL,    [Pwd] [varchar](50) NULL, CONSTRAINT [PK_AdminInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[BannerInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[BannerInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [varchar](50) NULL,    [KeyWord] [varchar](200) NULL,    [Abstract] [varchar](500) NULL,    [BannerContent] [ntext] NULL,    [ImgName] [varchar](200) NULL,    [ImgDec] [varchar](200) NULL,    [BannerUrl] [varchar](200) NULL,    [BannerRank] [int] NULL,    [BannerSource] [varchar](50) NULL,    [BannerAuthor] [varchar](50) NULL,    [BannerAddTime] [datetime] NULL,    [Ichecksign] [int] NULL,    [UrlOrBanner] [int] NULL,    [BannerType] [int] NULL, CONSTRAINT [PK_BannerInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[CarInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[CarInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [CarTypeId] [int] NULL,    [CarTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_CarInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[CoOperation]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Cooperation](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Name] [varchar](50) NULL,    [Url] [varchar](100) NULL,    [ImgInfo] [varchar](100) NULL,    [ImgDec] [varchar](100) NULL,    [Ichecksign] [int] NULL,    [AddTime] [datetime] NULL,    [TypeId] [int] NULL,    [ContentInfo] [ntext] NULL, CONSTRAINT [PK_Cooperation] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[EducationInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[EducationInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [EducationTypeId] [int] NULL,    [EducationTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_EducationInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[EntertainmentInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[EntertainmentInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [EntertainmentTypeId] [int] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_EntertainmentInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[FashionInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[FashionInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [FashionTypeId] [int] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_FashionInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[FinanceInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[FinanceInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [FinanceTypeId] [int] NULL,    [FinanceTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_FinanceInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[GexiInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING OFFGOCREATE TABLE [dbo].[GexiInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [SourceUrl] [varchar](200) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [NewsTypeId] [int] NULL,    [NewsTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL, CONSTRAINT [PK_GexiInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[GexiList]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[GexiList](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Name] [varchar](50) NULL,    [Profession] [varchar](200) NULL,    [Reason] [varchar](200) NULL,    [Motto] [varchar](200) NULL,    [ContentInfo] [ntext] NULL,    [KeyWord] [varchar](200) NULL,    [Abstract] [varchar](200) NULL,    [AddTime] [datetime] NULL,    [Ichecksign] [int] NULL,    [ImgName] [varchar](200) NULL,    [ImgDec] [varchar](200) NULL,    [UserRank] [int] NULL, CONSTRAINT [PK_GexiList] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[HistoryInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HistoryInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [HistoryTypeId] [int] NULL,    [HistoryTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_HistoryInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[HotWorld]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HotWorld](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Name] [varchar](50) NULL,    [AddTime] [datetime] NULL,    [Ichecksign] [int] NULL,    [InfoDec] [varchar](50) NULL, CONSTRAINT [PK_HotWorld] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[HouseInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HouseInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [HouseTypeId] [int] NULL,    [HouseTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_HouseInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[ImgSpecial]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgSpecial](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [varchar](50) NULL,    [KeyWord] [varchar](50) NULL,    [Summary] [varchar](50) NULL,    [Source] [varchar](50) NULL,    [Author] [varchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [varchar](50) NULL,    [ImgDec] [varchar](50) NULL,    [IsHotSpot] [int] NULL, CONSTRAINT [PK_ImgSpecial] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[ImgSpecialInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgSpecialInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [varchar](50) NULL,    [KeyWord] [varchar](50) NULL,    [Summary] [varchar](50) NULL,    [SpecialTypeId] [int] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [varchar](50) NULL,    [ImgDec] [varchar](50) NULL,    [Time] [datetime] NULL, CONSTRAINT [PK_ImgSpecialInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[ImgWorld]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ImgWorld](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [varchar](50) NULL,    [KeyWord] [varchar](50) NULL,    [Summary] [varchar](50) NULL,    [Source] [varchar](50) NULL,    [Author] [varchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [varchar](50) NULL,    [ImgDec] [varchar](50) NULL,    [IsHotSpot] [int] NULL, CONSTRAINT [PK_ImgWorld] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[NewsInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[NewsInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](1000) NULL,    [Source] [nvarchar](50) NULL,    [SourceUrl] [varchar](200) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [NewsInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [NewsTypeId] [int] NULL,    [NewsTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL CONSTRAINT [DF_NewsInfo_IsDelete]  DEFAULT ((1)),    [Sort] [int] NULL CONSTRAINT [DF_NewsInfo_Sort]  DEFAULT ((0)),    [ImgInfo] [nvarchar](500) NULL,    [ImgDec] [nvarchar](500) NULL,    [Price] [int] NULL CONSTRAINT [DF_NewsInfo_Price]  DEFAULT ((0)),    [Review] [int] NULL CONSTRAINT [DF_NewsInfo_Review]  DEFAULT ((0)),    [CreatUserId] [varchar](50) NULL,    [CheckState] [int] NULL CONSTRAINT [DF_NewsInfo_CheckState]  DEFAULT ((1)), CONSTRAINT [PK_NewsInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[NoticeInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[NoticeInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [varchar](200) NULL,    [KeyWord] [varchar](200) NULL,    [Summary] [varchar](200) NULL,    [Author] [varchar](200) NULL,    [AddTime] [datetime] NULL,    [Ichecksign] [int] NULL,    [IsHotSpot] [int] NULL,    [ContentInfo] [ntext] NULL,    [Hits] [int] NULL,    [NoticeTypeId] [int] NULL, CONSTRAINT [PK_Notice] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[PriceInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[PriceInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [NewsTypeId] [int] NULL,    [NewsId] [int] NULL,    [UserId] [int] NULL,    [IsDelete] [int] NULL,    [Time] [datetime] NULL,    [Ip] [varchar](50) NULL, CONSTRAINT [PK_PriceInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[ReviewInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[ReviewInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [NewsTypeId] [int] NULL,    [NewsId] [int] NULL,    [UserId] [int] NULL,    [ContentInfo] [varchar](300) NULL,    [Support] [int] NULL,    [Against] [int] NULL,    [IsDelete] [int] NULL,    [Time] [datetime] NULL,    [Ip] [varchar](50) NULL, CONSTRAINT [PK_ReviewInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[SearchDetails]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[SearchDetails](    [Id] [uniqueidentifier] NOT NULL,    [KeyWords] [nvarchar](50) NULL,    [SearchDateTime] [datetime] NULL,    [IP] [varchar](50) NULL, CONSTRAINT [PK_SearchDetails] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[SoulInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[SoulInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [SoulTypeId] [int] NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Review] [int] NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_SoulInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[TechInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TechInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [SourceUrl] [varchar](200) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [TechTypeId] [int] NULL,    [TechTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [Price] [int] NULL,    [Review] [int] NULL, CONSTRAINT [PK_TechInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[TravelInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[TravelInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [Title] [nvarchar](80) NULL,    [KeyWord] [nvarchar](80) NULL,    [Summary] [nvarchar](500) NULL,    [Source] [nvarchar](50) NULL,    [Author] [nvarchar](50) NULL,    [Time] [datetime] NULL,    [Hits] [int] NULL,    [ContentInfo] [ntext] NULL,    [IsHotSpot] [int] NULL,    [TravelTypeId] [int] NULL,    [TravelTypeName] [nvarchar](50) NULL,    [IsDelete] [int] NULL,    [Sort] [int] NULL,    [ImgInfo] [nvarchar](50) NULL,    [ImgDec] [nvarchar](50) NULL,    [SourceUrl] [varchar](200) NULL, CONSTRAINT [PK_TravelInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[UserInfo]    Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[UserInfo](    [Id] [int] IDENTITY(1,1) NOT NULL,    [UserName] [varchar](50) NULL,    [UserPwd] [varchar](50) NULL,    [UserEmail] [varchar](50) NULL,    [UserTel] [varchar](50) NULL,    [UserNickname] [varchar](50) NULL,    [UserSex] [varchar](50) NULL,    [UserQQ] [varchar](50) NULL,    [UserHometown] [varchar](50) NULL,    [UserGrade] [int] NULL,    [UserFraction] [int] NULL,    [UserPassNo] [varchar](50) NULL,    [Ichecksign] [int] NULL CONSTRAINT [DF_UserInfo_Ichecksign]  DEFAULT ((1)),    [UserState] [int] NULL,    [UserImg] [varchar](50) NULL,    [AddTime] [datetime] NULL,    [IsAuthentication] [int] NULL,    [Realname] [varchar](50) NULL,    [IdentityId] [varchar](50) NULL,    [BankId] [int] NULL,    [BankNum] [varchar](50) NULL,    [BankName] [varchar](50) NULL,    [AlipayNum] [varchar](50) NULL, CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[ImgSpecialInfo]  WITH CHECK ADD  CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial] FOREIGN KEY([SpecialTypeId])REFERENCES [dbo].[ImgSpecial] ([Id])GOALTER TABLE [dbo].[ImgSpecialInfo] CHECK CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial]GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'合作方式1：合作 2友链' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cooperation', @level2type=N'COLUMN',@level2name=N'TypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'革西光荣榜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Name'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Profession'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入榜理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Reason'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'座右铭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Motto'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具体信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ContentInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简介' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'Abstract'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ImgName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像介绍alt' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GexiList', @level2type=N'COLUMN',@level2name=N'ImgDec'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片专题（看图说话）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ImgSpecial', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片专题（子表）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ImgSpecialInfo', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Title'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'KeyWord'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'摘要' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Summary'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Source'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Author'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发表时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Time'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点击量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Hits'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否是热点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'IsHotSpot'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻类型编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsTypeId'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻类型名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'NewsTypeName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'IsDelete'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新闻排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'Sort'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'ImgInfo'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'NewsInfo', @level2type=N'COLUMN',@level2name=N'ImgDec'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'Id'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'搜索的词' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'KeyWords'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'搜索词的时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'SearchDateTime'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'网站编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SearchDetails', @level2type=N'COLUMN',@level2name=N'IP'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserName'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserPwd'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserEmail'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserTel'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'昵称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserNickname'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserSex'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'qq' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserQQ'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'籍贯' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserHometown'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'等级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserGrade'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'积分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserFraction'GOEXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通行证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserInfo', @level2type=N'COLUMN',@level2name=N'UserPassNo'GOUSE [master]GOALTER DATABASE [gexi] SET  READ_WRITE GO