SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Image](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[Image] [varbinary](max) NULL,
	[InfoID] [bigint] NOT NULL,
 CONSTRAINT [PK_Image] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Info]    Script Date: 30.10.2018 12:27:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Info](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Field_1] [nvarchar](max) NULL,
	[Field_2] [datetime2](7) NOT NULL,
	[Field_3] [datetime2](7) NOT NULL,
	[Field_4ID] [int] NOT NULL,
	[Field_5] [nvarchar](max) NULL,
	[Field_6Id] [int] NOT NULL,
	[Field_7] [nvarchar](13) NULL,
	[Field_8] [int] NOT NULL,
	[Field_9] [nvarchar](max) NULL,
	[Field_10] [int] NOT NULL,
	[Field_11] [int] NOT NULL,
 CONSTRAINT [PK_Info] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Index [IX_Image_InfoID]    Script Date: 30.10.2018 12:27:54 ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Image_InfoID] ON [dbo].[Image]
(
	[InfoID] 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
SET ANSI_PADDING ON
GO

/****** Object:  Index [IX_Info_Field_2_Field_7_Field_4ID]    Script Date: 30.10.2018 12:27:54 ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Info_Field_2_Field_7_Field_4ID] ON [dbo].[Info]
(
	[Field_2] ASC,
	[Field_7] ASC,
	[Field_4ID] ASC
)
WHERE ([Field_7] IS NOT NULL)
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

/****** Object:  Index [IX_Info_Field_4ID]    Script Date: 30.10.2018 12:27:54 ******/
CREATE NONCLUSTERED INDEX [IX_Info_Field_4ID] ON [dbo].[Info]
(
	[Field_4ID] 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 [IX_Info_Field_4ID_Field_3]    Script Date: 30.10.2018 12:27:54 ******/
CREATE NONCLUSTERED INDEX [IX_Info_Field_4ID_Field_3] ON [dbo].[Info]
(
	[Field_4ID] ASC,
	[Field_3] ASC
)
INCLUDE ( 	[ID],
	[Field_2],
	[Field_7],
	[Field_8]) 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 [IX_Info_Field_7]    Script Date: 30.10.2018 12:27:54 ******/
CREATE NONCLUSTERED INDEX [IX_Info_Field_7] ON [dbo].[Info]
(
	[Field_7] ASC
)
INCLUDE ( 	[ID]) 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 [NonClusteredIndex-20180913-142646]    Script Date: 30.10.2018 12:27:54 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20180913-142646] ON [dbo].[TiInHour]
(
	[Field_4ID] ASC,
	[Hour] ASC
)
INCLUDE ( 	[ID],
	[Count],
	[ElapsedTimeSum],
	[Loaded]) 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:  StoredProcedure [dbo].[InsertInfo]    Script Date: 30.10.2018 12:27:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[InsertInfo]
	@Field_1 nvarchar(250),
	@Field_2 datetime2(7),
	@Field_3 datetime2(7),
	@Field_4ID int,
	@Field_5 nvarchar(40),
	@Field_6Id int,
	@Field_7 nvarchar(13),
	@Field_8 int,
	@Image varbinary(MAX),
	@Field_10 int,
	@Field_11 int
AS  
INSERT INTO Info ([Field_1]
      ,[Field_2]
      ,[Field_3]
      ,[Field_4ID]
      ,[Field_5]
      ,[Field_6Id]
      ,[Field_7]
      ,[Field_8]
      ,[Field_10]
      ,[Field_11]) 
	  OUTPUT INSERTED.ID
	  VALUES
	  ( @Field_1
      ,@Field_2
      ,@Field_3
      ,@Field_4ID
      ,@Field_5
      ,@Field_6Id
      ,@Field_7
      ,@Field_8
      ,@Field_10
      ,@Field_11)

INSERT INTO Image 
	([Image], [InfoID]) VALUES (@Image, SCOPE_IDENTITY())
GO