if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ITEM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ITEM]
GO
CREATE TABLE [dbo].[ITEM] (
[Num] [int] NOT NULL ,
[strName] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Kind] [tinyint] NOT NULL ,
[Slot] [tinyint] NOT NULL ,
[Race] [tinyint] NOT NULL ,
[Class] [tinyint] NOT NULL ,
[Damage] [smallint] NOT NULL ,
[Delay] [smallint] NOT NULL ,
[Range] [smallint] NOT NULL ,
[Weight] [smallint] NOT NULL ,
[Duration] [smallint] NOT NULL ,
[BuyPrice] [int] NOT NULL ,
[SellPrice] [int] NOT NULL ,
[Ac] [smallint] NOT NULL ,
[Countable] [tinyint] NOT NULL ,
[Effect1] [int] NOT NULL ,
[Effect2] [int] NOT NULL ,
[ReqLevel] [tinyint] NOT NULL ,
[ReqLevelMax] [tinyint] NOT NULL ,
[ReqRank] [tinyint] NOT NULL ,
[ReqTitle] [tinyint] NOT NULL ,
[ReqStr] [tinyint] NOT NULL ,
[ReqSta] [tinyint] NOT NULL ,
[ReqDex] [tinyint] NOT NULL ,
[ReqIntel] [tinyint] NOT NULL ,
[ReqCha] [tinyint] NOT NULL ,
[SellingGroup] [tinyint] NOT NULL ,
[ItemType] [tinyint] NOT NULL ,
[Hitrate] [smallint] NOT NULL ,
[Evasionrate] [smallint] NOT NULL ,
[DaggerAc] [smallint] NOT NULL ,
[SwordAc] [smallint] NOT NULL ,
[MaceAc] [smallint] NOT NULL ,
[AxeAc] [smallint] NOT NULL ,
[SpearAc] [smallint] NOT NULL ,
[BowAc] [smallint] NOT NULL ,
[FireDamage] [tinyint] NOT NULL ,
[IceDamage] [tinyint] NOT NULL ,
[LightningDamage] [tinyint] NOT NULL ,
[PoisonDamage] [tinyint] NOT NULL ,
[HPDrain] [tinyint] NOT NULL ,
[MPDamage] [tinyint] NOT NULL ,
[MPDrain] [tinyint] NOT NULL ,
[MirrorDamage] [tinyint] NOT NULL ,
[Droprate] [tinyint] NOT NULL ,
[StrB] [smallint] NOT NULL ,
[StaB] [smallint] NOT NULL ,
[DexB] [smallint] NOT NULL ,
[IntelB] [smallint] NOT NULL ,
[ChaB] [smallint] NOT NULL ,
[MaxHpB] [smallint] NOT NULL ,
[MaxMpB] [smallint] NOT NULL ,
[FireR] [smallint] NOT NULL ,
[ColdR] [smallint] NOT NULL ,
[LightningR] [smallint] NOT NULL ,
[MagicR] [smallint] NOT NULL ,
[PoisonR] [smallint] NOT NULL ,
[CurseR] [smallint] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MAGIC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MAGIC]
GO
CREATE TABLE [dbo].[MAGIC] (
[MagicNum] [int] NOT NULL ,
[EnName] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[KrName] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Description] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[BeforeAction] [tinyint] NULL ,
[TargetAction] [tinyint] NULL ,
[SelfEffect] [tinyint] NULL ,
[FlyingEffect] [tinyint] NULL ,
[TargetEffect] [smallint] NULL ,
[Moral] [tinyint] NULL ,
[SkillLevel] [smallint] NULL ,
[Skill] [smallint] NULL ,
[Msp] [smallint] NULL ,
[HP] [smallint] NULL ,
[ItemGroup] [tinyint] NULL ,
[UseItem] [int] NULL ,
[CastTime] [tinyint] NULL ,
[ReCastTime] [tinyint] NULL ,
[SuccessRate] [tinyint] NULL ,
[Type1] [tinyint] NULL ,
[Type2] [tinyint] NULL ,
[Range] [smallint] NULL ,
[Etc] [tinyint] NULL ,
[Event] [int] NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VERSION]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VERSION]
GO
CREATE TABLE [dbo].[VERSION] (
[version] [smallint] NULL ,
[filename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[compname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hisversion] [smallint] NULL
) ON [PRIMARY]
GO
回复楼主的信息。
实在不清楚的，你可以加我QQ：945552950 |
[/img] [img]
[/img]
[/img]
