g0Tbqdjx

1USE [SRO_VT_ACCOUNT]
2GO
3/****** Object: Table [dbo].[SK_GameBang_IP] ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8CREATE TABLE [dbo].[SK_GameBang_IP](
9    [ip] [nchar](10) NULL,
10    [capacity] [nchar](10) NULL
11) ON [PRIMARY]
12GO
13
14DROP TABLE [dbo].[_PrivilegedIP]
15
16CREATE TABLE [dbo].[_PrivilegedIP](
17    [IP1] [tinyint] NOT NULL,
18    [IP2] [tinyint] NOT NULL,
19    [IP3] [tinyint] NOT NULL,
20    [IP4] [tinyint] NOT NULL,
21    [IP5] [tinyint] NOT NULL,
22    [IP6] [tinyint] NOT NULL,
23    [IP7] [tinyint] NOT NULL,
24    [IP8] [tinyint] NOT NULL
25) ON [PRIMARY]
26
27USE SRO_VT_SHARD
28/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] ******/
29SET ANSI_NULLS ON
30GO
31SET QUOTED_IDENTIFIER ON
32GO
33CREATE procedure [dbo].[_ExistsServiceOffRentItem]  
34as  
35  
36if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )  
37begin
38 return -1
39end
40GO