·您现在的位置: 云翼网络 >> 文章中心 >> 网站建设 >> 网站建设开发 >> ASP.NET网站开发 >> 我的网络兼职MVC项目开发-数据库
项目还在开发中。不少的模块还没有实现。参考网站:革西网络
我今天把创建数据库的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 GOView 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>