|
|
puaiguoidc
发表于 2010-11-1 17:22:40
|
显示全部楼层
有些已经是[nvarchar]版主帮我看看这里那些要改成[nvarchar]啊
/****** 对象: Table [dbo].[wap_bbs] 脚本日期: 11/01/2010 17:20:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[wap_bbs](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[userid] [bigint] NULL CONSTRAINT [DF_wap_bbs_userid] DEFAULT (0),
[book_classid] [bigint] NULL CONSTRAINT [DF_wap_bbs_book_classid] DEFAULT (0),
[book_title] [nvarchar](50) NULL,
[book_author] [nvarchar](50) NULL,
[book_pub] [nvarchar](50) NULL,
[book_content] [ntext] NULL,
[book_re] [bigint] NULL CONSTRAINT [DF_wap_bbs_book_re] DEFAULT (0),
[book_click] [bigint] NULL CONSTRAINT [DF_wap_bbs_book_click] DEFAULT (0),
[book_date] [smalldatetime] NULL CONSTRAINT [DF_wap_bbs_book_date] DEFAULT (getdate()),
[book_good] [int] NULL CONSTRAINT [DF_wap_bbs_book_good] DEFAULT (0),
[book_top] [int] NULL CONSTRAINT [DF_wap_bbs_book_top] DEFAULT (0),
[sysid] [bigint] NULL CONSTRAINT [DF_wap_bbs_sysid] DEFAULT (0),
[reDate] [datetime] NULL CONSTRAINT [DF_wap_bbs_reDate] DEFAULT (getdate()),
[reShow] [int] NULL CONSTRAINT [DF_wap_bbs_reShow] DEFAULT (0),
[suport] [bigint] NULL CONSTRAINT [DF_wap_bbs_support] DEFAULT (0),
[oppose] [bigint] NULL CONSTRAINT [DF_wap_bbs_oppose] DEFAULT (0),
[topic] [bigint] NULL,
[islock] [smallint] NULL CONSTRAINT [DF_wap_bbs_islock] DEFAULT (0),
[isVote] [int] NULL,
[whylock] [nvarchar](200) NULL,
[sendMoney] [int] NULL,
[hasMoney] [int] NULL,
[isdown] [smallint] NULL,
CONSTRAINT [PK_wap_bbs] 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] |
|