شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
01-12-2019, 05:14 PM | #1 | ||||||||||||
|
كود:
USE [SRO_VT_LOG] ---- Warrior Skills Scroll ---------------------------------- Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0) IF (@ItemRefID = 41806) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1 END END END END ---- Dagger Skills Scroll ---------------------------------- IF (@ItemRefID = 41807) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1 END END END END ---- Wizard Skills Scroll ---------------------------------- IF (@ItemRefID = 41805) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1 End END END End ---- Warlock Skills Scroll ---------------------------------- IF (@ItemRefID = 41810) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1 End END End End -- Bard Skills Scroll ------------------------------- IF (@ItemRefID = 41809) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1 End END End End -- Claric Skills Scroll --------------------------------- IF (@ItemRefID = 41808) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1 End End End END ---- Bicheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41800) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1 End END End End ---- Heuksal Skills Scroll ---------------------------------- IF (@ItemRefID = 41799) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1 End END END End ---- Pacheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41798) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1 End END End End ---- Cold Skills Scroll ------------------------------- IF (@ItemRefID = 41803) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1 End End End End ---- Lightning Skills Scroll ------------------------------------- IF (@ItemRefID = 41802) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1 End End End End ---- Fire Skills Scroll -------------------------------- IF (@ItemRefID = 41801) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1 End End End End ---- Force Skills Scroll --------------------------------- IF (@ItemRefID = 41804) -- RefObjCommon ID Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1 End End End END كود:
Msg 137, Level 15, State 2, Line 5 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 6 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 7 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 14 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 16 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 17 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 18 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 25 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 32 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 34 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 35 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 36 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 43 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 50 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 52 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 53 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 54 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 61 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 68 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 70 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 71 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 72 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 80 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 87 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 89 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 91 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 99 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 106 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 108 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 109 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 110 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 117 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 124 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 126 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 127 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 128 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 136 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 143 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 145 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 146 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 147 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 155 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 162 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 164 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 165 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 166 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 174 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 181 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 183 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 184 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 185 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 193 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 200 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 202 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 203 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 204 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 212 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 219 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 221 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 222 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 223 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 231 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 238 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 240 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 241 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 242 Must declare the scalar variable "@CharID". انا بستخدم SQL Server 2008 R2 Express يا ريت لو حد يقولي ايه الغلط اللي في الـ Procedure عشان اصلحه و الـError ده ميطلعش تاني |
||||||||||||
التعديل الأخير تم بواسطة iRock ; 02-12-2019 الساعة 01:15 AM
|
01-12-2019, 08:08 PM | #2 | ||||||||||||
|
ايوه عايز ايه برده ؟
|
||||||||||||
|
02-12-2019, 01:16 AM | #3 | ||||||||||||
|
عايز اعرف الError ده اصلحه ازاي
|
||||||||||||
|
02-12-2019, 06:46 PM | #4 | ||||||||||||
|
شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه + هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه |
||||||||||||
|
02-12-2019, 09:56 PM | #5 | |||||||||||||
|
اقتباس:
عملت التابل بالquery ده كود:
USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsBard] Script Date: 6/12/2017 12:17:19 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsBard]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsBicheon] Script Date: 6/12/2017 12:17:34 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsBicheon]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsClaric] Script Date: 6/12/2017 12:17:48 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsClaric]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsCold] Script Date: 6/12/2017 12:17:58 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsCold]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsFire] Script Date: 6/12/2017 12:18:08 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsFire]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsForce] Script Date: 6/12/2017 12:18:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsForce]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsHeuksal] Script Date: 6/12/2017 12:18:39 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsHeuksal]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsLightning] Script Date: 6/12/2017 12:18:49 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsLightning]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsPacheon] Script Date: 6/12/2017 12:18:58 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsPacheon]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsRogue] Script Date: 6/12/2017 12:19:07 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsRogue]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsRogue] PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWarlock] Script Date: 6/12/2017 12:19:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWarlock]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWarrior] Script Date: 6/12/2017 12:19:26 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWarrior]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsWarrior] PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWizard] Script Date: 6/12/2017 12:19:34 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWizard]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsWizard] PRIMARY KEY CLUSTERED ( [SkillID] 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] GO SET ANSI_PADDING OFF GO |
|||||||||||||
|
03-12-2019, 10:42 PM | #6 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|