كود:
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
ENDError
كود:
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 ده ميطلعش تاني
و ده الكويري اللي عملت بيه التابل كلها
كود:
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
التعديل الأخير: