/****** Object: Table [dbo].[K_SYS1] Script Date: 14-3-2018 15:30:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[K_SYS1]( [FL_SECTIME] [int] NOT NULL, [LEEG] [float] NULL, [DATUM_TIJD] [char](19) NULL, [LOTNUMMER] [char](10) NULL, [M_IST] [float] NULL, [M_SOLL] [float] NULL, [M_RCP] [float] NULL, [W_IST_1] [float] NULL, [W_SOLL_1] [float] NULL, [FL_SOLL_1] [float] NULL, [W_VF_1] [float] NULL, [W_OMW_1] [float] NULL, [W_IST_2] [float] NULL, [W_SOLL_2] [float] NULL, [FL_SOLL_2] [float] NULL, [W_VF_2] [float] NULL, [W_OMW_2] [float] NULL, [W_IST_3] [float] NULL, [W_SOLL_3] [float] NULL, [FL_SOLL_3] [float] NULL, [W_VF_3] [float] NULL, [W_KME_3] [float] NULL, [W_IST_4] [float] NULL, [W_SOLL_4] [float] NULL, [FL_SOLL_4] [float] NULL, [W_VF_4] [float] NULL, [W_KME_4] [float] NULL, [W_IST_5] [float] NULL, [W_SOLL_5] [float] NULL, [FL_SOLL_5] [float] NULL, [W_VF_5] [float] NULL, [W_KME_5] [float] NULL, [W_IST_6] [float] NULL, [W_SOLL_6] [float] NULL, [FL_SOLL_6] [float] NULL, [W_VF_6] [float] NULL, [W_KME_6] [float] NULL, [W_IST_7] [float] NULL, [W_SOLL_7] [float] NULL, [FL_SOLL_7] [float] NULL, [W_VF_7] [float] NULL, [W_KME_7] [float] NULL, [W_IST_8] [float] NULL, [W_SOLL_8] [float] NULL, [FL_SOLL_8] [float] NULL, [W_VF_8] [float] NULL, [W_IST_9] [float] NULL, [W_SOLL_9] [float] NULL, [FL_SOLL_9] [float] NULL, [W_VF_9] [float] NULL, [W_KME_9] [float] NULL, [W_IST_10] [float] NULL, [W_SOLL_10] [float] NULL, [FL_SOLL_10] [float] NULL, [W_VF_10] [float] NULL, [W_KME_10] [float] NULL, [W_IST_11] [float] NULL, [W_SOLL_11] [float] NULL, [W_IST_12] [float] NULL, [W_SOLL_12] [float] NULL, [SOLL_PITCH] [float] NULL, [IST_PITCH] [float] NULL, [SCHK_PITCH] [float] NULL, [IST_PITCHM] [float] NULL ) ON [PRIMARY] GO /****** Object: Index [K_SYS1_1] Script Date: 14-3-2018 15:30:27 ******/ CREATE UNIQUE CLUSTERED INDEX [K_SYS1_1] ON [dbo].[K_SYS1] ( [FL_SECTIME] DESC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = ON, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO