USE [GMS_ELISHA]
GO
/****** Object:  Table [dbo].[LoadHed]    Script Date: 28/01/2020 16:48:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoadHed](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[AccountName] [nvarchar](250) NULL,
	[LoadDate] [nvarchar](250) NULL,
	[LoadedQuantity] [nvarchar](250) NULL,
	[TruckNumber] [nvarchar](250) NULL,
	[DocNumber] [nvarchar](250) NULL,
	[SentDate] [nvarchar](250) NULL,
	[UnpackedQuantity] [nvarchar](250) NULL,
	[Status] [nvarchar](250) NULL,
	[DriverName] [nvarchar](250) NULL,
	[UnpackSite] [nvarchar](250) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[LoadRow]    Script Date: 28/01/2020 16:48:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoadRow](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Barcode] [nvarchar](250) NULL,
	[Quantity] [nvarchar](250) NULL,
	[Flag] [nvarchar](250) NULL,
	[DocNumber] [nvarchar](250) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UnpackHed]    Script Date: 28/01/2020 16:48:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UnpackHed](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[AccountName] [nvarchar](250) NULL,
	[LoadDate] [nvarchar](250) NULL,
	[LoadedQuantity] [nvarchar](250) NULL,
	[TruckNumber] [nvarchar](250) NULL,
	[DocNumber] [nvarchar](250) NULL,
	[SentDate] [nvarchar](250) NULL,
	[UnpackedQuantity] [nvarchar](250) NULL,
	[Status] [nvarchar](250) NULL,
	[DriverName] [nvarchar](250) NULL,
	[RecieverName] [nvarchar](250) NULL,
	[UnpackSite] [nvarchar](250) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UnpackRow]    Script Date: 28/01/2020 16:48:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UnpackRow](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Barcode] [nvarchar](250) NULL,
	[Quantity] [nvarchar](250) NULL,
	[Flag] [nvarchar](250) NULL,
	[DocNumber] [nvarchar](250) NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UserTBL]    Script Date: 28/01/2020 16:48:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserTBL](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](250) NULL,
	[UserPassword] [nvarchar](50) NULL,
	[UserNum] [nvarchar](50) NULL,
	[IsValid] [nvarchar](50) NULL,
	[IsManager] [nvarchar](50) NULL,
	[UserDepartement] [nvarchar](100) NULL
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[LoadHed] ON

INSERT [dbo].[LoadHed] ([id], [AccountName], [LoadDate], [LoadedQuantity], [TruckNumber], [DocNumber], [SentDate], [UnpackedQuantity], [Status], [DriverName], [UnpackSite]) VALUES (52, N'שינדרל - מרלוג', N'25/11/2018', N'4', N'5', N'52', N'25/11/2018', N'', N'2', N'איציק', N'הרצליה')
SET IDENTITY_INSERT [dbo].[LoadHed] OFF
SET IDENTITY_INSERT [dbo].[LoadRow] ON

INSERT [dbo].[LoadRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1262, N'8717447093961', N'1', N'0', N'52')
INSERT [dbo].[LoadRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1263, N'8717447056751', N'1', N'0', N'52')
INSERT [dbo].[LoadRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1264, N'47406142026', N'1', N'0', N'52')
INSERT [dbo].[LoadRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1265, N'3660730035795', N'1', N'0', N'52')
SET IDENTITY_INSERT [dbo].[LoadRow] OFF
SET IDENTITY_INSERT [dbo].[UnpackHed] ON

INSERT [dbo].[UnpackHed] ([id], [AccountName], [LoadDate], [LoadedQuantity], [TruckNumber], [DocNumber], [SentDate], [UnpackedQuantity], [Status], [DriverName], [RecieverName], [UnpackSite]) VALUES (1018, N'שינדרל - מרלוג', N'25/11/2018', N'4', N'5', N'1018', N'איציק', N'4', N'1', N'איציק', N'איציק', N'הרצליה')
SET IDENTITY_INSERT [dbo].[UnpackHed] OFF
SET IDENTITY_INSERT [dbo].[UnpackRow] ON

INSERT [dbo].[UnpackRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1073, N'8717447093961', N'1', N'1', N'1018')
INSERT [dbo].[UnpackRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1074, N'8717447056751', N'1', N'1', N'1018')
INSERT [dbo].[UnpackRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1075, N'47406142026', N'1', N'1', N'1018')
INSERT [dbo].[UnpackRow] ([id], [Barcode], [Quantity], [Flag], [DocNumber]) VALUES (1076, N'3660730035795', N'1', N'1', N'1018')
SET IDENTITY_INSERT [dbo].[UnpackRow] OFF
SET IDENTITY_INSERT [dbo].[UserTBL] ON

INSERT [dbo].[UserTBL] ([id], [UserName], [UserPassword], [UserNum], [IsValid], [IsManager], [UserDepartement]) VALUES (1, N'איציק', N'1', N'1', N'1', N'1', N'מנהל')
INSERT [dbo].[UserTBL] ([id], [UserName], [UserPassword], [UserNum], [IsValid], [IsManager], [UserDepartement]) VALUES (2, N'חיים', N'2', N'', N'1', N'0', N'')
SET IDENTITY_INSERT [dbo].[UserTBL] OFF