USE [GunzDB]
GO
/****** Object: Table [dbo].[IPCountryCode] Script Date: 02/21/2007 18:30:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[IPCountryCode](
[CountryCode3] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IPTo] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPFrom] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_IPCountryCode] PRIMARY KEY CLUSTERED
(
[CountryCode3] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
USE [GunzDB]
GO
USE [GunzDB]
GO
/****** Object: Table [dbo].[BlockCountryCode] Script Date: 02/21/2007 18:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BlockCountryCode](
[Code ] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: StoredProcedure [dbo].[spIPFltGetBlockCountryCodeList] Script Date: 02/21/2007 18:26:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spIPFltGetBlockCountryCodeList]
AS
BEGIN
SELECT * FROM BlockCountryCode(NOLOCK)
END
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spIPFltGetCustomIP] Script Date: 02/21/2007 18:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spIPFltGetCustomIP]
AS
BEGIN
SELECT * FROM BlockCountryCode(NOLOCK)
END
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spIPFltGetCustomIPList] Script Date: 02/21/2007 18:27:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spIPFltGetCustomIPList]
AS
BEGIN
SELECT * FROM BlockCountryCode(NOLOCK)
END
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spIPFltGetIPtoCountry] Script Date: 02/21/2007 18:27:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spIPFltGetIPtoCountry]
AS
BEGIN
SELECT * FROM BlockCountryCode(NOLOCK)
END
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spGetIPCountryCode] Script Date: 02/21/2007 18:29:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetIPCountryCode]
AS
BEGIN
SELECT CountryCode3, IPTo, IPFrom
FROM IPCountryCode
ORDER BY CountryCode3
END
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spGetIPtoCountryList] Script Date: 02/21/2007 18:29:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryList]
AS
BEGIN
SELECT * FROM BlockCountryCode(NOLOCK)
END
