ممكن حد يفهمي حاجة بسيطة

[ahmedjak1993]

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefObjCommon] Script Date: 16/05/2019 06:57:26 ص ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefObjCommon](
[Service] [int] 1
[ID] [int] IDENTITY(0,1) 60269
[CodeName128] [varchar](129) ITEM_MALL_MRVIPER_GODBLESS_FIRE
[ObjName128] [varchar](129) ???? ???? ??? (???)
[OrgObjCodeName128] [varchar](129) xxx
[NameStrID128] [varchar](129) SN_ITEM_MALL_MRVIPER_GODBLESS_FIRE
[DescStrID128] [varchar](129) SN_ITEM_MALL_MRVIPER_GODBLESS_FIRE_TT_DESC
[CashItem] [tinyint] 1
[Bionic] [tinyint] 0
[TypeID1] [tinyint] 3
[TypeID2] [tinyint] 3
[TypeID3] [tinyint] 13
[TypeID4] [tinyint] 14
[DecayTime] [int] 180000
[Country] [tinyint] 3
[Rarity] [tinyint] 0
[CanTrade] [tinyint] 1
[CanSell] [tinyint] 0
[CanBuy] [tinyint] 0
[CanBorrow] [tinyint] 255
[CanDrop] [tinyint] 1
[CanPick] [tinyint] 1
[CanRepair] [tinyint] 0
[CanRevive] [tinyint] 0
[CanUse] [tinyint] 129
[CanThrow] [tinyint] 0
[Price] [int] 0
[CostRepair] [int] 0
[CostRevive] [int] 0
[CostBorrow] [int] 0
[KeepingFee] [int] 0
[SellPrice] [int] 0
[ReqLevelType1] [int] -1
[ReqLevel1] [tinyint] 0
[ReqLevelType2] [int] -1
[ReqLevel2] [tinyint] 0
[ReqLevelType3] [int] -1
[ReqLevel3] [tinyint] 0
[ReqLevelType4] [int] -1
[ReqLevel4] [tinyint] 0
[MaxContain] [int] -1
[RegionID] [smallint] 0
[Dir] [smallint] 0
[OffsetX] [smallint] 0
[OffsetY] [smallint] 0
[OffsetZ] [smallint] 0
[Speed1] [smallint] 0
[Speed2] [smallint] 0
[Scale] [int] 100
[BCHeight] [smallint] 0
[BCRadius] [smallint] 0
[EventID] [int] 0
[AssocFileObj128] [varchar](129) xxx
[AssocFileDrop128] [varchar](129) item\etc\drop_mall_scroll.bsr
[AssocFileIcon128] [varchar](129) Premium\etc\mall_change_name.ddj
[AssocFile1_128] [varchar](129) xxx
[AssocFile2_128] [varchar](129) xxx
[Link] [int] 2236380
CONSTRAINT [PK__RefObjCommon] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ده الفاضي


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefObjCommon] Script Date: 16/05/2019 08:16:15 ص ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefObjCommon](
[Service] [int] NOT NULL,
[ID] [int] IDENTITY(0,1) NOT NULL,
[CodeName128] [varchar](129) NOT NULL,
[ObjName128] [varchar](129) NOT NULL,
[OrgObjCodeName128] [varchar](129) NOT NULL,
[NameStrID128] [varchar](129) NOT NULL,
[DescStrID128] [varchar](129) NOT NULL,
[CashItem] [tinyint] NOT NULL,
[Bionic] [tinyint] NOT NULL,
[TypeID1] [tinyint] NOT NULL,
[TypeID2] [tinyint] NOT NULL,
[TypeID3] [tinyint] NOT NULL,
[TypeID4] [tinyint] NOT NULL,
[DecayTime] [int] NOT NULL,
[Country] [tinyint] NOT NULL,
[Rarity] [tinyint] NOT NULL,
[CanTrade] [tinyint] NOT NULL,
[CanSell] [tinyint] NOT NULL,
[CanBuy] [tinyint] NOT NULL,
[CanBorrow] [tinyint] NOT NULL,
[CanDrop] [tinyint] NOT NULL,
[CanPick] [tinyint] NOT NULL,
[CanRepair] [tinyint] NOT NULL,
[CanRevive] [tinyint] NOT NULL,
[CanUse] [tinyint] NOT NULL,
[CanThrow] [tinyint] NOT NULL,
[Price] [int] NOT NULL,
[CostRepair] [int] NOT NULL,
[CostRevive] [int] NOT NULL,
[CostBorrow] [int] NOT NULL,
[KeepingFee] [int] NOT NULL,
[SellPrice] [int] NOT NULL,
[ReqLevelType1] [int] NOT NULL,
[ReqLevel1] [tinyint] NOT NULL,
[ReqLevelType2] [int] NOT NULL,
[ReqLevel2] [tinyint] NOT NULL,
[ReqLevelType3] [int] NOT NULL,
[ReqLevel3] [tinyint] NOT NULL,
[ReqLevelType4] [int] NOT NULL,
[ReqLevel4] [tinyint] NOT NULL,
[MaxContain] [int] NOT NULL,
[RegionID] [smallint] NOT NULL,
[Dir] [smallint] NOT NULL,
[OffsetX] [smallint] NOT NULL,
[OffsetY] [smallint] NOT NULL,
[OffsetZ] [smallint] NOT NULL,
[Speed1] [smallint] NOT NULL,
[Speed2] [smallint] NOT NULL,
[Scale] [int] NOT NULL,
[BCHeight] [smallint] NOT NULL,
[BCRadius] [smallint] NOT NULL,
[EventID] [int] NOT NULL,
[AssocFileObj128] [varchar](129) NOT NULL,
[AssocFileDrop128] [varchar](129) NOT NULL,
[AssocFileIcon128] [varchar](129) NOT NULL,
[AssocFile1_128] [varchar](129) NOT NULL,
[AssocFile2_128] [varchar](129) NOT NULL,
[Link] [int] NOT NULL,
CONSTRAINT [PK__RefObjCommon] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كده صح ؟؟



تم الحل عن طريق موضوع الاخ

Developer

الموضوع
https://www.silkroad4arab.com/vb/showthread.php?t=487448



تسلم ايدك