奇迹人物技能快捷不保存解决

heyman      44阅读

一下2种方法,都是使用sql的查询分析器,查询一下即可

【方法1】

USE [MuOnline]
GO
DROP TABLE [dbo].[OptionData];
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[OptionData](

[Name] [varchar](10) NOT NULL,

[GameOption] [int] NULL,

[Qkey] [int] NULL,

[Wkey] [int] NULL,

[Ekey] [int] NULL,

[ChatWindow] [int] NULL,

[Rkey] [int] NULL,

[QWERLevel] [int] NULL,

[Skillkey] [binary](10) NUll
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

【方法2】

CREATE TABLE [dbo].[OptionData] (

[Name] [varchar] (10) COLLATE Chinese_PRC_CS_AS_KS_WS NOT NULL ,

[SkillKey] [binary] (10) NULL ,

[GameOption] [tinyint] NULL ,

[Qkey] [tinyint] NULL ,

[Wkey] [tinyint] NULL ,

[Ekey] [tinyint] NULL ,

[ChatWindow] [tinyint] NULL ,

[RKey] [tinyint] NULL ,

[QWERLevel] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OptionData_test] (

[Name] [varchar] (10) COLLATE Korean_Wansung_CS_AS NOT NULL ,

[SkillKey] [binary] (10) NULL ,

[GameOption] [tinyint] NULL ,

[Qkey] [tinyint] NULL ,

[Wkey] [tinyint] NULL ,

[Ekey] [tinyint] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[OptionData] WITH NOCHECK ADD

CONSTRAINT [PK_OptionData] PRIMARY KEY CLUSTERED

(

[Name]

) ON [PRIMARY]
GO

ALTER TABLE [dbo].[OptionData_test] WITH NOCHECK ADD

CONSTRAINT [PK_OptionData_test] PRIMARY KEY CLUSTERED

(

[Name]

) ON [PRIMARY]
GO

ALTER TABLE [dbo].[OptionData] ADD

CONSTRAINT [DF__OptionDat__ChatW__74AE54BC] DEFAULT (255) FOR [ChatWindow],

CONSTRAINT [DF__OptionData__RKey__457442E6] DEFAULT (0) FOR [RKey],

CONSTRAINT [DF__OptionDat__QWERL__4668671F] DEFAULT (0) FOR [QWERLevel]
GO

======================
OptionData

OptionData_test

PK_OptionData

PK_OptionData_test
先删这四个表..再执行上面的语句

奇迹 mu 技能
   44阅读
目前尚无回复
登录 后发表评论