/****** Object: Table [dbo].[TREND_TABLE] Script Date: 12/09/2015 15:30:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TREND_TABLE]( [FLTIME] [int] NULL, [PLC1_FT501_Meetw] [float] NULL, [PLC1_FT641_Meetw] [float] NULL, [PLC1_LT601_Meetw] [float] NULL, [PLC1_LT602_Meetw] [float] NULL, [PLC1_P501_Meetw] [float] NULL, [PLC1_P502_Meetw] [float] NULL, [PLC1_P503_Meetw] [float] NULL, [PLC1_P501_MeetwI] [float] NULL, [PLC1_P502_MeetwI] [float] NULL, [PLC1_P503_MeetwI] [float] NULL, [PLC1_PT501_Meetw] [float] NULL, [PLC1_PIC50001_MeetwStuur] [float] NULL, [PLC1_PT502_Meetw] [float] NULL, [PLC1_PT641_Meetw] [float] NULL, [PLC1_PT642_Meetw] [float] NULL, [PLC1_QT501_Meetw] [float] NULL, [PLC1_QT641_Meetw] [float] NULL, [PLC1_XV641_Meetw] [float] NULL, [PLC1_FT501_Verpompt] [float] NULL, [PLC1_FT501_Doorgeleverd] [float] NULL, [PLC1_Kelderinhoud_Meetw] [float] NULL, [PLC1_TS_PROG_ProdGew] [float] NULL, [PLC1_HOST_TS_VerwDeb] [float] NULL ) ON [PRIMARY] GO /****** Object: Index [TREND_TABLE_1] Script Date: 12/09/2015 15:30:25 ******/ CREATE UNIQUE CLUSTERED INDEX [TREND_TABLE_1] ON [dbo].[TREND_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