USE [df2] GO /****** Object: Index [IX_EventCreateDT] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_EventCreateDT] ON [dbo].[Billing] ( [EventCreateDT] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_EventRefreshDT] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_EventRefreshDT] ON [dbo].[Billing] ( [EventRefreshDT] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_EventTypeID] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_EventTypeID] ON [dbo].[Billing] ( [EventTypeID] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_PeriodDT1] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_PeriodDT1] ON [dbo].[Billing] ( [PeriodDT1] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_PeriodDT2] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_PeriodDT2] ON [dbo].[Billing] ( [PeriodDT2] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_ProjectID] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_ProjectID] ON [dbo].[Billing] ( [ProjectID] ASC ) ON [PRIMARY] GO /****** Object: Index [IX_UserID] Script Date: 12/12/2007 09:28:48 ******/ CREATE NONCLUSTERED INDEX [IX_UserID] ON [dbo].[Billing] ( [UserID] ASC ) ON [PRIMARY] GO /****** Object: Index [PK_Billing] Script Date: 12/12/2007 09:28:48 ******/ ALTER TABLE [dbo].[Billing] ADD CONSTRAINT [PK_Billing] PRIMARY KEY CLUSTERED ( [ID] ASC ) ON [PRIMARY]