项目还在开发中。不少的模块还没有实现。参考网站：革西网络
我今天把创建数据库的sql语句给贴出来，大家生成之后修改一下web.config试试看。
表在设计上也有不妥的地方，先这样吧。
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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[BannerInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[CarInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[CoOperation] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[EducationInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[EntertainmentInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[FashionInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[FinanceInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[GexiInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[GexiList] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[HistoryInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[HotWorld] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[HouseInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[ImgSpecial] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[ImgSpecialInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[ImgWorld] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[NewsInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[NoticeInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[PriceInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[ReviewInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[SearchDetails] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[SoulInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[TechInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[TravelInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO/****** Object: Table [dbo].[UserInfo] Script Date: 2015/9/7 16:40:56 ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE 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]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ImgSpecialInfo] WITH CHECK ADD CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial] FOREIGN KEY([SpecialTypeId])
REFERENCES [dbo].[ImgSpecial] ([Id])
GO
ALTER TABLE [dbo].[ImgSpecialInfo] CHECK CONSTRAINT [FK_ImgSpecialInfo_ImgSpecial]
GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
EXEC 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'GO
USE [master]
GO
ALTER DATABASE [gexi] SET READ_WRITE
GO
View Code
把web.config中加密的部分修改一下，修改成本地数据库连接即可:
<appSettings>
<add key="ConStr" value="Data Source=.;Initial Catalog=gexi;Persist Security Info=True;UserID=gexi;Password=123456" />
<add key="GexinetUrl" value="http://www.gexinet.com" />
</appSettings>
