/****** Object: Table [dbo].[WEEKRAP_TABLE] Script Date: 01/20/2015 16:36:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WEEKRAP_TABLE]( [FLTIME] [datetime] NULL, [TIME_A_DOY] [char](15) NULL, [TIME_DATETIME] [char](40) NULL, [PLC1_FT641_Qtot1] [decimal](15, 0) NULL, [PLC1_FT501_Qtot1] [decimal](15, 0) NULL, [PLC1_FT501_Qtot3] [decimal](15, 0) NULL, [PLC1_FT501_Qtot4] [decimal](15, 0) NULL ) ON [PRIMARY] GO /****** Object: Index [WEEKRAP_TABLE_1] Script Date: 01/20/2015 16:36:56 ******/ CREATE UNIQUE NONCLUSTERED INDEX [WEEKRAP_TABLE_1] ON [dbo].[WEEKRAP_TABLE] ( [FLTIME] 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