/****** Object:  Table [dbo].[MPV]    Script Date: 6/23/2016 2:02:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MPV](
	[INLEESTIJD] [int] NULL,
	[LOTNR] [char](10) NULL,
	[SYSTEEM] [int] NULL,
	[SEQ_NR] [int] NULL,
	[PEKSRT_1] [char](10) NULL,
	[PEKSRT_2] [char](10) NULL,
	[PEKSRT_1P] [int] NULL,
	[PEKSRT_2P] [int] NULL,
	[COKES_1] [char](15) NULL,
	[COKES_2] [char](15) NULL,
	[COKES_3] [char](15) NULL,
	[COKES_4] [char](15) NULL,
	[COKES_5] [char](15) NULL,
	[COKES_1P] [int] NULL,
	[COKES_2P] [int] NULL,
	[COKES_3P] [int] NULL,
	[COKES_4P] [int] NULL,
	[COKES_5P] [int] NULL,
	[VERD_COKES] [float] NULL,
	[VERD_REST] [int] NULL,
	[MOLENSTOF] [int] NULL,
	[FIJNE_REST] [int] NULL,
	[KORREL_1] [int] NULL,
	[KORREL_2] [int] NULL,
	[KORREL_3] [int] NULL,
	[KORREL_4] [int] NULL,
	[KORREL_5] [int] NULL,
	[PEK] [int] NULL,
	[GR_TOESLAG] [int] NULL,
	[DOORZET] [int] NULL,
	[VW_RPM] [float] NULL,
	[VW_RPM_AFW] [float] NULL,
	[VW_T] [int] NULL,
	[VW_T_REG] [int] NULL,
	[VW_T_AFK] [int] NULL,
	[BM_RPM] [float] NULL,
	[BM_RPM_AFW] [float] NULL,
	[K_KWT] [float] NULL,
	[K_KWT_REG] [float] NULL,
	[K_KWT_AFK] [float] NULL,
	[BM_T] [int] NULL,
	[BM_T_REG] [int] NULL,
	[BM_T_AFK] [int] NULL,
	[OM_RPM] [float] NULL,
	[OM_RPM_AFW] [float] NULL,
	[OM_T] [int] NULL,
	[OM_T_AFW] [int] NULL,
	[OM_T_REG] [int] NULL,
	[OM_T_AFK] [int] NULL,
	[VULGR] [int] NULL,
	[VULGR_AFW] [int] NULL,
	[BLAIN] [int] NULL,
	[BLAIN_AFW] [int] NULL,
	[WATERKOEL] [int] NULL,
	[PEK_T] [int] NULL,
	[PEK_T_REG] [int] NULL,
	[PEK_T_AFK] [int] NULL,
	[V_MACHINE] [char](3) NULL,
	[TIJD] [int] NULL,
	[TIJD_AFW] [int] NULL,
	[RPM_P_INST] [int] NULL,
	[RPM_P_AFW] [int] NULL,
	[BALG] [int] NULL,
	[BALG_AFW] [int] NULL,
	[TEMP] [int] NULL,
	[TEMP_AFW] [int] NULL,
	[TEMP_REG] [int] NULL,
	[TEMP_AFK] [int] NULL,
	[GEW] [int] NULL,
	[GEW_AFW] [int] NULL,
	[GEW_REG] [int] NULL,
	[GEW_AFK] [int] NULL,
	[HOOGTE] [int] NULL,
	[HOOGTE_AFW] [int] NULL,
	[HOOGTE_REG] [int] NULL,
	[HOOGTE_AFK] [int] NULL,
	[SG_FACT] [float] NULL,
	[SG] [float] NULL,
	[SG_AFK] [float] NULL,
	[SG_REG] [float] NULL,
	[OPM_1] [char](75) NULL,
	[OPM_2] [char](75) NULL,
	[OPM_3] [char](75) NULL,
	[OPM_4] [char](75) NULL,
	[OPM_5] [char](75) NULL,
	[OPM_6] [char](75) NULL,
	[OPM_7] [char](75) NULL,
	[OPM_8] [char](75) NULL,
	[OPM_9] [char](75) NULL,
	[OPM_10] [char](75) NULL,
	[OPM_11] [char](75) NULL,
	[SILO_1] [int] NULL,
	[SILO_2] [int] NULL,
	[SILO_3] [int] NULL,
	[SILO_4] [int] NULL,
	[SILO_5] [int] NULL,
	[CORR_1] [int] NULL,
	[CORR_2] [int] NULL,
	[CORR_3] [int] NULL,
	[CORR_4] [int] NULL,
	[CORR_5] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [_dta_index_MPV_4]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE CLUSTERED INDEX [_dta_index_MPV_4] ON [dbo].[MPV]
(
	[SYSTEEM] ASC,
	[LOTNR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [_dta_index_MPV_5]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE NONCLUSTERED INDEX [_dta_index_MPV_5] ON [dbo].[MPV]
(
	[SYSTEEM] ASC,
	[LOTNR] ASC
)
INCLUDE ( 	[BM_T],
	[BM_T_AFK]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [_dta_index_MPV_6]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE NONCLUSTERED INDEX [_dta_index_MPV_6] ON [dbo].[MPV]
(
	[SYSTEEM] ASC,
	[LOTNR] ASC
)
INCLUDE ( 	[K_KWT],
	[K_KWT_AFK]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [_dta_index_MPV_7]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE NONCLUSTERED INDEX [_dta_index_MPV_7] ON [dbo].[MPV]
(
	[SYSTEEM] ASC,
	[LOTNR] ASC
)
INCLUDE ( 	[K_KWT],
	[K_KWT_AFK],
	[BM_T],
	[BM_T_AFK]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [MPV_1]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE NONCLUSTERED INDEX [MPV_1] ON [dbo].[MPV]
(
	[INLEESTIJD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [MPV_2]    Script Date: 6/23/2016 2:02:33 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [MPV_2] ON [dbo].[MPV]
(
	[LOTNR] ASC,
	[SYSTEEM] 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