·您现在的位置： 云翼网络 >> 文章中心 >> 网站建设 >> 网站建设开发 >> ASP.NET网站开发 >> 我的网络兼职MVC项目开发-数据库
- 你不知道的 页面编码，浏览器选择编码，get，post各种乱码由来
- 数据绑定控件再ASP.NET1.X和ASP.NET2.0的区别
- [.NET逆向].netIL指令速查（net破解必备）
- ubuntu15coreclr
- jQuery自制上传头像插件-附带Demo实例（ajaxfileupload.js第三弹）
- 2014-07-23利用ASP.NET自带控件实现单文件上传与下载
- [视频]Visual Studio 2005入门之Table
- FREETEXTBOX
- 学C#你应该熟练使用ILDasm和Reflector【带视频教程】
- RSS 文档中 language 标签中的可选值
- ASP.Net中的MD5加密
- C# 从excel里面复制的1万6千多条记录粘贴到FCKeditor里面，点保存的时候，保存不了，页面没有反应
- ASP.NET2.0下为GridView添加鼠标滑过（onmouseover、onmouseout）的行颜色高亮效果！
- C#实现对Word文件读写[转]
- asp.net 生成图片验证码
- ASP.NET页面刷新方法总结(转)
- Cheatsheet:201404.01~04.30
- IIS与ASP.NET中的线程池
- ASP.NET Session详解笔记
- [视频教程]Visual.Studio2005视频教程25.利用 T F S 进行团队协作开发
- 博文收录
- # 会员注册与登录模块
- VS2013的virtualpath在当前应用程序根的外部
- 【C#】OOP之继承那点事
- 你知道吗？.NET Framework 4.5 五个很棒的特性
- 20个最强的基于浏览器的在线代码编辑器
- 最受欢迎的ASP.NET的CMS下载
- 解决ASPX网页另类load两次
- 虚拟主机上asp.net运行权限不足问题及解决
- 分享我对 ASP.NET vNext 的一些感受，也许多年回过头看 So Easy！
我的网络兼职MVC项目开发-数据库
作者：佚名 ASP.NET网站开发编辑：admin 更新时间：2022-07-23
项目还在开发中。不少的模块还没有实现。参考网站：革西网络
我今天把创建数据库的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>
- 上一篇文章： 开始学习编程了……2015年九月七日……31岁的Me.
- 下一篇文章： VS2013自动注释插件
- ASP.NET 在 Windows Azure 环境中使用基于
- WCF回顾一、基本概念和应用场景
- 通过系统配置来提高ASP.NET应用程序的稳定性
- C# Datatable排序
- ASP.NET 2.0快速入门(14)：ASP.NET 2.0管理
- STMP发送邮件被当垃圾邮件处理的解决方法
- 关于线程的参数、“返回值”、及线程的中止