USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[SK_GameBang_IP] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SK_GameBang_IP](
    [ip] [nchar](10) NULL,
    [capacity] [nchar](10) NULL
) ON [PRIMARY]
GO

DROP TABLE [dbo].[_PrivilegedIP]

CREATE TABLE [dbo].[_PrivilegedIP](
    [IP1] [tinyint] NOT NULL,
    [IP2] [tinyint] NOT NULL,
    [IP3] [tinyint] NOT NULL,
    [IP4] [tinyint] NOT NULL,
    [IP5] [tinyint] NOT NULL,
    [IP6] [tinyint] NOT NULL,
    [IP7] [tinyint] NOT NULL,
    [IP8] [tinyint] NOT NULL
) ON [PRIMARY]

USE SRO_VT_SHARD
/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
 return -1
end
GO