IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ng_exclude_indexes]') AND type in (N'U'))
DROP TABLE [dbo].[ng_exclude_indexes]
GO

CREATE TABLE [dbo].[ng_exclude_indexes](
	[table_name] [varchar](30) NOT NULL,
	[index_name] [varchar](36) NOT NULL,
	[created_by] [int] NOT NULL,
	[create_timestamp] [datetime] NOT NULL,
	[modified_by] [int] NOT NULL,
	[modify_timestamp] [datetime] NOT NULL,
	[row_timestamp] [timestamp] NOT NULL,
 CONSTRAINT [PK_ng_exclude_indexes] PRIMARY KEY CLUSTERED 
(
	[table_name] ASC,
	[index_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [NEXTGEN_CORE]
) ON [NEXTGEN_CORE]
GO

ALTER TABLE [dbo].[ng_exclude_indexes] ADD  CONSTRAINT [DFng_exclude_indexes_create_timestamp]  DEFAULT (getdate()) FOR [create_timestamp]
GO

ALTER TABLE [dbo].[ng_exclude_indexes] ADD  CONSTRAINT [DFng_exclude_indexes_modify_timestamp]  DEFAULT (getdate()) FOR [modify_timestamp]
GO
