SET ANSI_NULLS ON
GO
SET ANSI_PADDING OFF
GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[FuelSell]') AND name = N'IX_FuelSell_By_AccountNumber')
CREATE NONCLUSTERED INDEX [IX_FuelSell_By_AccountNumber] ON [dbo].[FuelSell] 
(
	[AccountNumber] ASC
)
WHERE ([AccountNumber] IS NOT NULL)
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[FuelSell]    Script Date: 10/22/2015 12:13:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FuelSell]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[FuelSell](
	[RID] [int] NOT NULL,
	[SellID] [int] NOT NULL,
	.....
	[AccountNumber] [int] NULL,
	[SecondAccountNumber] [int] NULL,
 CONSTRAINT [PK_FuelSell] PRIMARY KEY CLUSTERED 
(
	[RID] ASC,
	[SellID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO

SET ANSI_PADDING OFF

/****** Object:  Table [dbo].[FuelSell]    Script Date: 10/22/2015 12:13:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FuelSell]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[FuelSell](
	[RID] [int] NOT NULL,
	[SellID] [int] NOT NULL,
	[AfsID] [smallint] NOT NULL,
	
	[AccountNumber] [int] NULL,
	[SecondAccountNumber] [int] NULL,
 CONSTRAINT [PK_FuelSell] PRIMARY KEY CLUSTERED 
(
	[RID] ASC,
	[SellID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING OFF  --<<<-----------------------
GO

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[FuelSell]') AND name = N'IX_FuelSell_By_AccountNumber')
CREATE NONCLUSTERED INDEX [IX_FuelSell_By_AccountNumber] ON [dbo].[FuelSell] 
(
	[AccountNumber] ASC
)
WHERE ([AccountNumber] IS NOT NULL)
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[CouponSeries]    Script Date: 10/22/2015 12:13:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CouponSeries]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CouponSeries](
	[SeriesID] [int] NOT NULL,
	[CouponCode] [int] NOT NULL,
	[ProductCode] [int] NOT NULL,
	[Series] [varchar](10) NOT NULL,
	[Nominal] [int] NOT NULL,
 CONSTRAINT [PK_CouponSeries] PRIMARY KEY CLUSTERED 
(
	[SeriesID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[CouponSeries]') AND name = N'IX_CouponSeriesByCouponCodeAndSeries')
CREATE UNIQUE NONCLUSTERED INDEX [IX_CouponSeriesByCouponCodeAndSeries] ON [dbo].[CouponSeries] 
(
	[CouponCode] ASC,
	[Series] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

...
WHERE ([AccountNumber] IS NOT NULL)
...