mayi.sql导入错误,请高手指点!!
mayi.sql文件怎么导入到mssql中?是不是还缺少什么?请高手指点,谢谢!!
mayi.sql文件内容如下:
CREATE TABLE [dbo].[replys](
[replyid] [int] IDENTITY(1,1) NOT NULL,
[replyinfo] [text] NOT NULL,
[replyblogid] [int] NOT NULL,
[replyuser] [varchar](50) NOT NULL,
[replytime] [datetime] NOT NULL CONSTRAINT [DF_replys_replytime] DEFAULT (getdate()),
)
CREATE TABLE [dbo].[admins](
[adminid] [int] IDENTITY(1,1) NOT NULL,
[adminuser] [varchar](50) NOT NULL,
[adminpass] [varchar](50) NOT NULL,
[adminroles] [int] NOT NULL,
)
CREATE TABLE [dbo].[types](
[typeid] [int] IDENTITY(1,1) NOT NULL,
[typename] [varchar](50) NOT NULL,
[typeorder] [int] NOT NULL CONSTRAINT [DF_types_typeorder] DEFAULT ((0)),
)
CREATE TABLE [dbo].[blogs](
[blogid] [int] IDENTITY(1,1) NOT NULL,
[blogtitle] [varchar](100) NOT NULL,
[blogtypeid] [int] NOT NULL,
[bloginfo] [text] NOT NULL,
[blogupfile] [varchar](1000) NULL,
[bloghot] [int] NOT NULL CONSTRAINT [DF_blogs_bloghot] DEFAULT ((0)),
[blogreplysum] [int] NOT NULL CONSTRAINT [DF_blogs_blogreplysum] DEFAULT ((0)),
[bloguser] [varchar](50) NOT NULL,
[blogtime] [datetime] NOT NULL CONSTRAINT [DF_blogs_blogtime] DEFAULT (getdate()),
[blogor] [int] NULL CONSTRAINT [DF_blogs_blogor] DEFAULT ((0)),
)
CREATE TABLE [dbo].[users](
[userid] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](max) NOT NULL,
[userpass] [varchar](50) NOT NULL,
[useremail] [varchar](50) NOT NULL,
[usersite] [varchar](50) NOT NULL,
[userurl] [varchar](50) NOT NULL,
[usershow] [varchar](1000) NULL,
[usertime] [datetime] NOT NULL CONSTRAINT [DF_users_usertime] DEFAULT (getdate()),
[userip] [varchar](50) NOT NULL,
[useror] [int] NULL CONSTRAINT [DF_users_useror] DEFAULT ((1)),
)
CREATE TABLE [dbo].[sums](
[sumid] [int] IDENTITY(1,1) NOT NULL,
[sumuser] [int] NOT NULL CONSTRAINT [DF_sums_sumuser] DEFAULT ((0)),
[sumblog] [int] NOT NULL CONSTRAINT [DF_sums_sumblog] DEFAULT ((0)),
[sumreply] [int] NOT NULL CONSTRAINT [DF_sums_sumreply] DEFAULT ((0)),
[sumip] [int] NOT NULL CONSTRAINT [DF_sums_sumip] DEFAULT ((0))
)
CREATE TABLE [dbo].[urls](
[urlid] [int] IDENTITY(1,1) NOT NULL,
[urlsite] [varchar](50) NOT NULL,
[urltime] [datetime] NOT NULL,
)