USE [master]
GO
CREATE DATABASE eSSLWebDownloader
GO 
USE [eSSLWebDownloader]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Users](
	[UserId] [int] IDENTITY(1,1) NOT NULL,
	[LoginName] [nvarchar](50) NOT NULL,
	[LoginPassword] [nvarchar](50) NULL,
	[RoleName] [nvarchar](255) NULL,
	[IsAdmin] [int] NOT NULL,
	[AccessI] [int] NOT NULL,
	[RecordStatus] [int] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_Users] ON
INSERT [dbo].[essl_Users] ([UserId], [LoginName], [LoginPassword], [RoleName], [IsAdmin], [AccessI], [RecordStatus], [C1], [C2], [C3], [C4], [C5], [C6], [C7]) VALUES (1, N'essl', N'79195F54068C15E0DC4AAFDC97740DFC', N'Admin', -1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[essl_Users] OFF
/****** Object:  Table [dbo].[essl_UserPermissions]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_UserPermissions](
	[UserPermissionId] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[PermissionId] [int] NOT NULL,
 CONSTRAINT [PK_UserPermissions] PRIMARY KEY CLUSTERED 
(
	[UserPermissionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_UserPermissions] ON
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (862, 114, 1)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (863, 114, 2)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (864, 114, 3)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (865, 114, 4)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (866, 114, 5)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (867, 114, 6)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (868, 114, 7)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (869, 114, 8)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (870, 114, 9)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (871, 114, 10)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (872, 114, 11)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (873, 114, 12)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (874, 114, 13)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (875, 114, 14)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (876, 114, 15)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (877, 114, 16)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (878, 114, 17)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (879, 114, 18)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (880, 114, 19)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (881, 114, 20)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (882, 114, 21)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (883, 114, 22)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (884, 114, 23)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (885, 114, 24)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (886, 114, 25)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (887, 114, 26)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (888, 114, 27)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (889, 114, 28)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (890, 114, 29)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (891, 114, 30)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (892, 114, 31)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (893, 114, 32)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (894, 114, 33)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (895, 114, 34)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (896, 114, 35)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (897, 114, 36)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (898, 114, 37)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (899, 114, 38)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (900, 114, 39)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (901, 114, 40)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (902, 114, 41)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (903, 114, 42)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (904, 114, 43)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (905, 114, 44)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (906, 114, 45)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (907, 114, 46)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (908, 114, 47)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (909, 114, 48)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (910, 114, 49)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (911, 114, 50)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (912, 114, 51)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (913, 114, 52)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (914, 114, 53)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (915, 114, 54)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (916, 114, 55)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (917, 114, 56)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (918, 114, 57)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (919, 114, 58)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (920, 114, 59)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (921, 114, 60)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (922, 114, 61)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (923, 114, 62)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (924, 114, 63)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (925, 114, 64)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (926, 114, 65)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (927, 114, 66)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (928, 114, 67)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (929, 114, 68)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (930, 114, 69)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (931, 114, 70)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (932, 114, 71)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (933, 114, 72)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (934, 114, 85)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (935, 114, 73)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (936, 114, 75)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (937, 114, 76)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (938, 114, 77)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (939, 114, 78)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (940, 114, 79)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (941, 114, 80)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (942, 114, 81)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (943, 114, 82)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (944, 114, 83)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (945, 114, 87)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1030, 113, 1)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1031, 113, 2)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1032, 113, 3)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1033, 113, 4)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1034, 113, 5)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1035, 113, 6)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1036, 113, 7)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1037, 113, 8)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1038, 113, 9)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1039, 113, 10)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1040, 113, 11)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1041, 113, 12)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1042, 113, 13)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1043, 113, 14)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1044, 113, 15)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1045, 113, 16)
GO
print 'Processed 100 total records'
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1046, 113, 17)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1047, 113, 18)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1048, 113, 19)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1049, 113, 20)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1050, 113, 21)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1051, 113, 22)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1052, 113, 23)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1053, 113, 24)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1054, 113, 25)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1055, 113, 26)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1056, 113, 27)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1057, 113, 28)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1058, 113, 29)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1059, 113, 30)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1060, 113, 31)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1061, 113, 32)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1062, 113, 33)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1063, 113, 34)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1064, 113, 35)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1065, 113, 36)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1066, 113, 37)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1067, 113, 38)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1068, 113, 39)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1069, 113, 40)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1070, 113, 41)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1071, 113, 42)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1072, 113, 43)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1073, 113, 44)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1074, 113, 45)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1075, 113, 46)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1076, 113, 47)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1077, 113, 48)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1078, 113, 49)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1079, 113, 50)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1080, 113, 51)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1081, 113, 52)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1082, 113, 53)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1083, 113, 54)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1084, 113, 55)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1085, 113, 56)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1086, 113, 57)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1087, 113, 58)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1088, 113, 59)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1089, 113, 60)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1090, 113, 61)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1091, 113, 62)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1092, 113, 63)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1093, 113, 64)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1094, 113, 65)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1095, 113, 66)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1096, 113, 67)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1097, 113, 68)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1098, 113, 69)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1099, 113, 70)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1100, 113, 71)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1101, 113, 72)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1102, 113, 85)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1103, 113, 73)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1104, 113, 75)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1105, 113, 76)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1106, 113, 77)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1107, 113, 78)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1108, 113, 79)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1109, 113, 80)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1110, 113, 81)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1111, 113, 82)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1112, 113, 83)
INSERT [dbo].[essl_UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1113, 113, 87)
SET IDENTITY_INSERT [dbo].[essl_UserPermissions] OFF
/****** Object:  Table [dbo].[essl_UserCompanies]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_UserCompanies](
	[UserCompanyId] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [int] NOT NULL,
	[CompanyId] [int] NOT NULL,
 CONSTRAINT [PK_UserCompanies] PRIMARY KEY CLUSTERED 
(
	[UserCompanyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_UserCompanies] ON
INSERT [dbo].[essl_UserCompanies] ([UserCompanyId], [UserId], [CompanyId]) VALUES (34, 1, 1)
SET IDENTITY_INSERT [dbo].[essl_UserCompanies] OFF
/****** Object:  Table [dbo].[essl_Permissions]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Permissions](
	[PermissionId] [int] NOT NULL,
	[Permission] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[PermissionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (1, N'Users')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (2, N'ViewUsers')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (3, N'AddUsers')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (4, N'EditUsers')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (5, N'DeleteUsers')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (6, N'MasterSettings')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (7, N'MailSettings')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (8, N'Companies')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (9, N'ViewCompanies')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (10, N'AddCompanies')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (11, N'EditCompanies')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (12, N'DeleteCompanies')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (13, N'Departments')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (14, N'ViewDepartments')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (15, N'AddDepartments')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (16, N'EditDepartments')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (17, N'DeleteDepartments')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (18, N'EmpCategories')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (19, N'ViewEmpCategories')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (20, N'AddEmpCategories')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (21, N'EditEmpCategories')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (22, N'DeleteEmpCategories')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (23, N'Shifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (24, N'ViewShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (25, N'AddShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (26, N'EditShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (27, N'DeleteShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (28, N'ShiftCalendars')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (29, N'ViewShiftCalendars')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (30, N'AddShiftCalendars')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (31, N'EditShiftCalendars')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (32, N'DeleteShiftCalendars')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (33, N'Holidays')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (34, N'ViewHolidays')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (35, N'AddHolidays')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (36, N'EditHolidays')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (37, N'DeleteHolidays')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (38, N'Employees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (39, N'ViewEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (40, N'AddEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (41, N'EditEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (42, N'DeleteEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (43, N'LeaveTypes')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (44, N'ViewLeaveTypes')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (45, N'AddLeaveTypes')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (46, N'EditLeaveTypes')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (47, N'DeleteLeaveTypes')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (48, N'DepartmentShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (49, N'ViewDepartmentShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (50, N'AddDepartmentShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (51, N'EditDepartmentShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (52, N'DeleteDepartmentShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (53, N'EmployeeShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (54, N'ViewEmployeeShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (55, N'AddEmployeeShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (56, N'EditEmployeeShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (57, N'DeleteEmployeeShifts')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (58, N'LeaveEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (59, N'ViewLeaveEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (60, N'AddLeaveEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (61, N'EditLeaveEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (62, N'DeleteLeaveEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (63, N'OutDoorEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (64, N'ViewOutDoorEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (65, N'AddOutDoorEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (66, N'EditOutDoorEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (67, N'DeleteOutDoorEntries')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (68, N'LogRecords')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (69, N'ViewLogRecords')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (70, N'AddLogRecords')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (71, N'EditLogRecords')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (72, N'DeleteLogRecords')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (73, N'OTRegister')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (74, N'LeaveSummary')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (75, N'AttendanceLogs')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (76, N'DeviceManagement')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (77, N'ImportEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (78, N'ExportEmployees')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (79, N'BackUpDatabase')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (80, N'BackupRestoreOldLogs')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (81, N'AttendanceRegister')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (82, N'GenerateReports')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (83, N'OnlineDownloader')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (84, N'VisitorManagement')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (85, N'ManageWorkCode')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (86, N'ManageCanteen')
INSERT [dbo].[essl_Permissions] ([PermissionId], [Permission]) VALUES (87, N'PayrollManagement')
/****** Object:  Table [dbo].[essl_ParallelDatabaseDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_ParallelDatabaseDetails](
	[IsParallelDatabaseDowload] [int] NULL,
	[DatabaseType] [nvarchar](255) NULL,
	[Service] [nvarchar](255) NULL,
	[Port] [nvarchar](255) NULL,
	[ServerName] [nvarchar](255) NULL,
	[DatabaseName] [nvarchar](255) NULL,
	[DatabaseUserName] [nvarchar](255) NULL,
	[DatabasePassword] [nvarchar](255) NULL,
	[TableName] [nvarchar](255) NULL,
	[EmployeeCode] [nvarchar](255) NULL,
	[LogDate] [nvarchar](255) NULL,
	[Direction] [nvarchar](255) NULL,
	[WorkCode] [nvarchar](255) NULL,
	[IsReservedField1] [int] NULL,
	[IsReservedField2] [int] NULL,
	[ReservedField1] [nvarchar](255) NULL,
	[ReservedField1Value] [nvarchar](255) NULL,
	[ReservedField2] [nvarchar](255) NULL,
	[ReservedField2Value] [nvarchar](255) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[essl_ParallelDatabaseDetails] ([IsParallelDatabaseDowload], [DatabaseType], [Service], [Port], [ServerName], [DatabaseName], [DatabaseUserName], [DatabasePassword], [TableName], [EmployeeCode], [LogDate], [Direction], [WorkCode], [IsReservedField1], [IsReservedField2], [ReservedField1], [ReservedField1Value], [ReservedField2], [ReservedField2Value]) VALUES (0, N'Oracle', N'XE', N'1521', N'Localhost', N'', N'UserName', N'rKWYgQrTCGc=', N'', N'', N'', N'', N'', 0, 0, N'', N'', N'', N'')
/****** Object:  Table [dbo].[essl_MasterSettings]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_MasterSettings](
	[MasterDetailsId] [int] IDENTITY(1,1) NOT NULL,
	[IsAlphaNumericEmployeeCode] [int] NOT NULL,
	[IsFixedShift] [int] NOT NULL,
	[ShiftBeginTime] [nvarchar](255) NULL,
	[ShiftEndTime] [nvarchar](255) NULL,
	[IsDeviceCodeSame] [int] NOT NULL,
	[AttendanceYearStartMonth] [nvarchar](255) NULL,
	[AttendanceYearStartDate] [nvarchar](255) NULL,
	[ExtraHourShiftExpires] [int] NULL,
	[LiecenceKey] [nvarchar](255) NULL,
	[PunchBeginDuration] [int] NULL,
	[Version] [nvarchar](50) NULL,
	[IsAutoBackUp] [int] NOT NULL,
	[AutoBackuppath] [nvarchar](255) NULL,
	[BackupDays] [int] NULL,
	[LastBackUpDate] [nvarchar](50) NULL,
	[MinDiffBetweenTwoPunch] [int] NULL,
	[IsAutoShift] [int] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
	[C8] [nvarchar](255) NULL,
	[C9] [nvarchar](255) NULL,
	[C10] [nvarchar](255) NULL,
	[C11] [nvarchar](255) NULL,
	[C12] [nvarchar](255) NULL,
	[C13] [nvarchar](255) NULL,
	[C14] [nvarchar](255) NULL,
	[C15] [nvarchar](255) NULL,
	[MemoLateEarlySubject] [nvarchar](4000) NULL,
	[MemoMissedPunchSubject] [nvarchar](4000) NULL,
	[MemoSignature] [nvarchar](4000) NULL,
	[MemoAbsentText] [nvarchar](4000) NULL,
	[MemoLateEarlyText] [nvarchar](4000) NULL,
	[MemoMissedPunchText] [nvarchar](4000) NULL,
	[MemoAbsentSubject] [nvarchar](2000) NULL,
	[EmployeePhotoPath] [nvarchar](255) NULL,
	[VisitorPhotoPath] [nvarchar](255) NULL,
	[VisitorFingerPrintPath] [nvarchar](255) NULL,
	[VehiclePhotoPath] [nvarchar](255) NULL,
	[IsAutoClearLogs] [int] NULL,
 CONSTRAINT [PK_MasterSettings] PRIMARY KEY CLUSTERED 
(
	[MasterDetailsId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_MasterSettings] ON
INSERT [dbo].[essl_MasterSettings] ([MasterDetailsId], [IsAlphaNumericEmployeeCode], [IsFixedShift], [ShiftBeginTime], [ShiftEndTime], [IsDeviceCodeSame], [AttendanceYearStartMonth], [AttendanceYearStartDate], [ExtraHourShiftExpires], [LiecenceKey], [PunchBeginDuration], [Version], [IsAutoBackUp], [AutoBackuppath], [BackupDays], [LastBackUpDate], [MinDiffBetweenTwoPunch], [IsAutoShift], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [C8], [C9], [C10], [C11], [C12], [C13], [C14], [C15], [MemoLateEarlySubject], [MemoMissedPunchSubject], [MemoSignature], [MemoAbsentText], [MemoLateEarlyText], [MemoMissedPunchText], [MemoAbsentSubject], [EmployeePhotoPath], [VisitorPhotoPath], [VisitorFingerPrintPath], [VehiclePhotoPath], [IsAutoClearLogs]) VALUES (1, -1, 0, N'00:00', N'00:00', -1, N'1', N'1', 240, N'RHaDei72FPexjR0894/G5iR/Lr2i3sJKKT4QKl+ADpiKMTujceTAnrNFwD5WmRV4RZHq3XJ068ZsNjdofY0jE9c7ZKFX4AKhXKFn9JwKiTcYBii94UaNbwMywgZzkv5Sm1jNx/+QBWD8oKCOP/OG+ufMgu13bM781aTp3SZgfjUuAQ/v9AuU8Mxx+kR0YWpu', 120, N'eTimeTrackLite 5.8', 0, N'', 1, N'2010-04-27', 0, 0, N'enterprise Software Solutions Lab(eSSL)', N'Bangalore', N' ', N' ', N'http://www.esslindia.com', N'ww', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'LATE-COMING/EARLY-GOING NOTICE/MEMO.', N'MISSED OUT PUNCH NOTICE/MEMO.', N'Administrator', N'It has been observed from the Attendance Record that you were Absent from the duty unauthorisedly i.e. without permission on below said attendance date. Please give an explanation to the Authorised person immediately.', N'It has been observed from the Attendance Record that you were  Coming Late or Going Early from the duty unauthorisedly i.e. without permission on below said attendance date. Please give an explanation to the Authorised person immediately.', N'It  has been observed from the Attendance Record that you are not punching properly which is resulting into Missed Out Punch records in our attendance reports. Kindly explain the reason and co-operate with us to know exact out punch.', N'ABSENTEEISM NOTICE/MEMO.', N'', N'', N'', N'', 0)
SET IDENTITY_INSERT [dbo].[essl_MasterSettings] OFF
/****** Object:  Table [dbo].[essl_EmployeesBio]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_EmployeesBio](
	[EmployeeBioId] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeId] [int] NOT NULL,
	[BioType] [nvarchar](50) NULL,
	[BioVersion] [nvarchar](50) NULL,
	[BioId] [int] NOT NULL,
	[Bio] [ntext] NULL,
 CONSTRAINT [PK_EmployeesBio] PRIMARY KEY CLUSTERED 
(
	[EmployeeBioId] 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].[essl_Employees]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Employees](
	[EmployeeId] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeName] [nvarchar](50) NOT NULL,
	[EmployeeCode] [nvarchar](50) NOT NULL,
	[StringCode] [nvarchar](50) NOT NULL,
	[NumericCode] [int] NOT NULL,
	[Gender] [nvarchar](255) NOT NULL,
	[CompanyId] [int] NOT NULL,
	[DepartmentId] [int] NOT NULL,
	[Designation] [nvarchar](255) NULL,
	[CategoryId] [int] NOT NULL,
	[DOJ] [datetime] NULL,
	[DOR] [datetime] NULL,
	[DOC] [datetime] NULL,
	[EmployeeCodeInDevice] [nvarchar](50) NOT NULL,
	[EmployeeRFIDNumber] [nvarchar](255) NULL,
	[EmployementType] [nvarchar](255) NOT NULL,
	[Status] [nvarchar](255) NOT NULL,
	[EmployeeDevicePassword] [nvarchar](50) NULL,
	[EmployeeDeviceGroup] [nvarchar](50) NULL,
	[FatherName] [nvarchar](255) NULL,
	[MotherName] [nvarchar](255) NULL,
	[ResidentialAddress] [nvarchar](255) NULL,
	[PermanentAddress] [nvarchar](255) NULL,
	[ContactNo] [nvarchar](255) NULL,
	[Email] [nvarchar](255) NULL,
	[DOB] [datetime] NULL,
	[PlaceOfBirth] [nvarchar](255) NULL,
	[Nomenee1] [nvarchar](255) NULL,
	[Nomenee2] [nvarchar](255) NULL,
	[Remarks] [ntext] NULL,
	[RecordStatus] [int] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
	[Location] [nvarchar](255) NULL,
	[BLOODGROUP] [nvarchar](255) NULL,
	[WorkPlace] [nvarchar](255) NULL,
	[ExtensionNo] [nvarchar](255) NULL,
	[LoginName] [nvarchar](255) NULL,
	[LoginPassword] [nvarchar](255) NULL,
	[Grade] [nvarchar](255) NULL,
	[Team] [nvarchar](255) NULL,
	[IsRecieveNotification] [int] NULL,
	[HolidayGroup] [int] NOT NULL,
	[ShiftGroupId] [int] NULL,
 CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED 
(
	[EmployeeId] 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].[essl_Devices]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Devices](
	[DeviceId] [int] IDENTITY(1,1) NOT NULL,
	[DeviceFName] [nvarchar](255) NOT NULL,
	[DeviceSName] [nvarchar](255) NOT NULL,
	[DeviceDirection] [nvarchar](255) NULL,
	[SerialNumber] [nvarchar](255) NULL,
	[ConnectionType] [nvarchar](255) NULL,
	[IpAddress] [nvarchar](255) NULL,
	[BaudRate] [nvarchar](255) NULL,
	[CommKey] [nvarchar](255) NOT NULL,
	[ComPort] [nvarchar](255) NULL,
	[LastLogDownloadDate] [datetime] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
	[TransactionStamp] [nvarchar](50) NULL,
	[OpStamp] [nvarchar](50) NULL,
	[LastPing] [datetime] NULL,
	[DeviceType] [nvarchar](255) NULL,
	[DownLoadType] [int] NULL,
	[TimeZone] [nvarchar](50) NULL,
 CONSTRAINT [PK_Devices] PRIMARY KEY CLUSTERED 
(
	[DeviceId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_Devices] ON
INSERT [dbo].[essl_Devices] ([DeviceId], [DeviceFName], [DeviceSName], [DeviceDirection], [SerialNumber], [ConnectionType], [IpAddress], [BaudRate], [CommKey], [ComPort], [LastLogDownloadDate], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [TransactionStamp], [OpStamp], [LastPing], [DeviceType], [DownLoadType], [TimeZone]) VALUES (1, N'Manual Entry(Attendance)', N'ME(Attendance)', N'inout', N'170000822023', N'Tcp/IP', N'', N'', N'0', N'', CAST(0x0000000000000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'0', CAST(0x0000000000000000 AS DateTime), N'Attendance', 1, NULL)
INSERT [dbo].[essl_Devices] ([DeviceId], [DeviceFName], [DeviceSName], [DeviceDirection], [SerialNumber], [ConnectionType], [IpAddress], [BaudRate], [CommKey], [ComPort], [LastLogDownloadDate], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [TransactionStamp], [OpStamp], [LastPing], [DeviceType], [DownLoadType], [TimeZone]) VALUES (2, N'Manual Entry(Canteen)', N'ME(Canteen)', N'inout', N'1700008220145', N'Tcp/IP', N'', N'', N'0', N'', CAST(0x0000000000000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'0', CAST(0x0000000000000000 AS DateTime), N'Canteen', 1, NULL)
INSERT [dbo].[essl_Devices] ([DeviceId], [DeviceFName], [DeviceSName], [DeviceDirection], [SerialNumber], [ConnectionType], [IpAddress], [BaudRate], [CommKey], [ComPort], [LastLogDownloadDate], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [TransactionStamp], [OpStamp], [LastPing], [DeviceType], [DownLoadType], [TimeZone]) VALUES (38, N'GPRS', N'GPRS', N'in', N'2881040200009', N'Tcp/IP', N'192.168.1.165', N'', N'0', N'', CAST(0x00009F92011CB4C4 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'0', CAST(0x00009F92011DA500 AS DateTime), N'Attendance', 1, N'330')
SET IDENTITY_INSERT [dbo].[essl_Devices] OFF
/****** Object:  Table [dbo].[essl_DeviceOperationLogTypes]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_DeviceOperationLogTypes](
	[OperationLogTypeId] [int] IDENTITY(1,1) NOT NULL,
	[OperationLogTypeCode] [int] NOT NULL,
	[OperationLogTypeName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_OperationCommands] PRIMARY KEY CLUSTERED 
(
	[OperationLogTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_DeviceOperationLogTypes] ON
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (1, 0, N'Power On')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (2, 1, N'Power Off')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (3, 2, N'The Authentication is Failed')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (4, 3, N'Alarm')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (5, 4, N'Enter into the Main Menu')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (6, 5, N'Change The Setting')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (7, 6, N'Enroll a FingerPrint')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (8, 7, N'Enroll a Password')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (9, 8, N'Enroll a HID Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (10, 9, N'Delete a User')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (11, 10, N'Delete a FingerPrint')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (12, 11, N'Delete a Password')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (13, 12, N'Delete a RFID Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (14, 13, N'Clear the Data')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (15, 14, N'Create a MF Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (16, 15, N'Enroll a MF Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (17, 16, N'Register  a MF Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (18, 17, N'Delete The Registration of MF Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (19, 18, N'Clear the MF Cards Content')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (20, 19, N'Move The Enroll Data into Card')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (21, 20, N'Copy The Data in The Card to The Machine')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (22, 21, N'Set The Time')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (23, 22, N'Factory Setting')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (24, 23, N'Delete The In And Out Record')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (25, 24, N'Clear The Administrator Privilege')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (26, 25, N'Modify The Setting of Access Control Group')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (27, 26, N'Modify The Setting Of User Access Control')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (28, 27, N'Modify The Time Field Of Access Control')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (29, 28, N'Modify The Setting Of Unclock Combination')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (30, 29, N'Unclock')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (31, 30, N'Enroll a User')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (32, 31, N'Change The Finger Prints Attribute')
INSERT [dbo].[essl_DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (33, 32, N'Duress Alarm')
SET IDENTITY_INSERT [dbo].[essl_DeviceOperationLogTypes] OFF
/****** Object:  Table [dbo].[essl_DeviceOperationLogs]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_DeviceOperationLogs](
	[DeviceOperationLogId] [int] IDENTITY(1,1) NOT NULL,
	[DeviceOperationLogCode] [int] NOT NULL,
	[DeviceOperationLogExecutedOn] [datetime] NOT NULL,
	[SerialNumber] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_DeviceOperationLogs] PRIMARY KEY CLUSTERED 
(
	[DeviceOperationLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[essl_DeviceLogs]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_DeviceLogs](
	[DeviceLogId] [int] IDENTITY(1,1) NOT NULL,
	[DownloadDate] [datetime] NULL,
	[DeviceId] [int] NOT NULL,
	[UserId] [nvarchar](50) NOT NULL,
	[LogDate] [datetime] NOT NULL,
	[Direction] [nvarchar](255) NULL,
	[AttDirection] [nvarchar](255) NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
	[WorkCode] [nvarchar](255) NULL,
 CONSTRAINT [PK_DeviceLogs] PRIMARY KEY CLUSTERED 
(
	[DeviceLogId] ASC,
	[UserId] ASC,
	[LogDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[essl_DeviceCommands]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_DeviceCommands](
	[DeviceCommandId] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](200) NOT NULL,
	[DeviceCommand] [nvarchar](4000) NOT NULL,
	[SerialNumber] [nvarchar](50) NOT NULL,
	[Status] [nvarchar](50) NOT NULL,
	[Type] [nvarchar](50) NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ExecutionDate] [datetime] NOT NULL,
 CONSTRAINT [PK_DeviceCommands] PRIMARY KEY CLUSTERED 
(
	[DeviceCommandId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[essl_Departments]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Departments](
	[DepartmentId] [int] IDENTITY(1,1) NOT NULL,
	[DepartmentFName] [nvarchar](50) NOT NULL,
	[DepartmentSName] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](50) NULL,
	[RecordStatus] [int] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
 CONSTRAINT [PK_Departments] PRIMARY KEY CLUSTERED 
(
	[DepartmentId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_Departments] ON
INSERT [dbo].[essl_Departments] ([DepartmentId], [DepartmentFName], [DepartmentSName], [Description], [RecordStatus], [C1], [C2], [C3], [C4], [C5], [C6], [C7]) VALUES (1, N'Default', N'Default', N'', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[essl_Departments] OFF
/****** Object:  Table [dbo].[essl_Companies]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Companies](
	[CompanyId] [int] IDENTITY(1,1) NOT NULL,
	[CompanyFName] [nvarchar](50) NOT NULL,
	[CompanySName] [nvarchar](50) NOT NULL,
	[CompanyAddress] [nvarchar](255) NULL,
	[CompanyIsVisible] [int] NOT NULL,
	[CompanyeMail] [nvarchar](255) NULL,
	[CompanyWebsite] [nvarchar](255) NULL,
	[RecordStatus] [int] NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
 CONSTRAINT [PK_Companies] PRIMARY KEY CLUSTERED 
(
	[CompanyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_Companies] ON
INSERT [dbo].[essl_Companies] ([CompanyId], [CompanyFName], [CompanySName], [CompanyAddress], [CompanyIsVisible], [CompanyeMail], [CompanyWebsite], [RecordStatus], [C1], [C2], [C3], [C4], [C5], [C6], [C7]) VALUES (1, N'Default', N'Default', N'', -1, N'jjjjjjj@FF.COM', N'ff', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[essl_Companies] OFF
/****** Object:  Table [dbo].[essl_Categories]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[essl_Categories](
	[CategoryId] [int] IDENTITY(1,1) NOT NULL,
	[CategoryFName] [nvarchar](50) NOT NULL,
	[CategorySName] [nvarchar](50) NOT NULL,
	[OTFormula] [nvarchar](50) NOT NULL,
	[MinOT] [nvarchar](50) NULL,
	[ConsiderFirstLastPunch] [int] NOT NULL,
	[GraceTime] [nvarchar](50) NULL,
	[ConsiderEarlyPunch] [int] NOT NULL,
	[ConsiderLatePunch] [int] NOT NULL,
	[SundayWeeklyOff] [int] NOT NULL,
	[SaturdayWeeklyOff] [int] NOT NULL,
	[WeeklyOff1] [nvarchar](50) NULL,
	[WeeklyOff2] [nvarchar](50) NULL,
	[WhichSaturday] [nvarchar](50) NULL,
	[CalculateHalfDay] [int] NOT NULL,
	[HalfDayMins] [nvarchar](50) NULL,
	[CalculateAbsentDay] [int] NOT NULL,
	[AbsentDayMins] [nvarchar](50) NULL,
	[TransferHPintoCompOff] [int] NOT NULL,
	[TransferWOPintoCompOff] [int] NOT NULL,
	[DeductBreakHours] [int] NOT NULL,
	[ForMissedPunch] [int] NOT NULL,
	[RecordStatus] [int] NOT NULL,
	[C1] [nvarchar](255) NULL,
	[C2] [nvarchar](255) NULL,
	[C3] [nvarchar](255) NULL,
	[C4] [nvarchar](255) NULL,
	[C5] [nvarchar](255) NULL,
	[C6] [nvarchar](255) NULL,
	[C7] [nvarchar](255) NULL,
	[MarkWOandHAsAbsent] [int] NULL,
	[MarkAsAbsentForLate] [int] NULL,
	[ContiousLateDay] [int] NULL,
	[AbsentDayType] [nvarchar](255) NULL,
	[MarkWOandHAsPreDayAbsent] [int] NULL,
	[EarlyGoingGraceTime] [nvarchar](255) NULL,
	[MaxOT] [nvarchar](255) NULL,
	[PCalculateHalfDay] [int] NULL,
	[PHalfDayMins] [nvarchar](255) NULL,
	[PCalculateAbsentDay] [int] NULL,
	[PAbsentDayMins] [nvarchar](255) NULL,
 CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED 
(
	[CategoryId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[essl_Categories] ON
INSERT [dbo].[essl_Categories] ([CategoryId], [CategoryFName], [CategorySName], [OTFormula], [MinOT], [ConsiderFirstLastPunch], [GraceTime], [ConsiderEarlyPunch], [ConsiderLatePunch], [SundayWeeklyOff], [SaturdayWeeklyOff], [WeeklyOff1], [WeeklyOff2], [WhichSaturday], [CalculateHalfDay], [HalfDayMins], [CalculateAbsentDay], [AbsentDayMins], [TransferHPintoCompOff], [TransferWOPintoCompOff], [DeductBreakHours], [ForMissedPunch], [RecordStatus], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [MarkWOandHAsAbsent], [MarkAsAbsentForLate], [ContiousLateDay], [AbsentDayType], [MarkWOandHAsPreDayAbsent], [EarlyGoingGraceTime], [MaxOT], [PCalculateHalfDay], [PHalfDayMins], [PCalculateAbsentDay], [PAbsentDayMins]) VALUES (1, N'Default', N'Default', N'OT Not Applicable', N'30', -1, N'15', -1, -1, -1, 0, N'0', N'6', N'', -1, N'240', -1, N'120', -1, -1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, N'', 0, NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[essl_Categories] OFF
/****** Object:  View [dbo].[vw_MultiShiftDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_MultiShiftDetails]
AS
SELECT     dbo.ExtraHourshift.*, dbo.Employees.EmployeeName AS EmployeeName, dbo.Employees.EmployeeCode AS EmployeeCode, 
                      Employees_1.EmployeeName AS OnBehalfEmployeeName, dbo.Employees.NumericCode, dbo.Employees.StringCode, 
                      Employees_1.EmployeeCode AS OnBehalfEmployeeCode, dbo.Companies.CompanyId, dbo.Companies.CompanyIsVisible
FROM         dbo.Employees INNER JOIN
                      dbo.ExtraHourshift ON dbo.Employees.EmployeeId = dbo.ExtraHourshift.EmployeeId INNER JOIN
                      dbo.Employees Employees_1 ON dbo.ExtraHourshift.OnBehalfEmployeeId = Employees_1.EmployeeId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId INNER JOIN
                      dbo.Companies Companies_1 ON Employees_1.CompanyId = Companies_1.CompanyId
WHERE     (dbo.Employees.RecordStatus = 1) AND (Employees_1.RecordStatus = 1)
GO
/****** Object:  View [dbo].[vw_HoidayDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_HoidayDetails]
AS
SELECT     TOP 100 PERCENT dbo.Holidays.HolidayId, dbo.Holidays.HolidayName, dbo.Holidays.HolidayDate, dbo.Holidays.Description, 
                      dbo.Holidays.CompanyId, dbo.Companies.CompanySName, dbo.Companies.CompanyIsVisible
FROM         dbo.Companies INNER JOIN
                      dbo.Holidays ON dbo.Companies.CompanyId = dbo.Holidays.CompanyId
ORDER BY dbo.Holidays.HolidayDate DESC
GO
/****** Object:  View [dbo].[vw_CompanyDepartmentShifts]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_CompanyDepartmentShifts]
AS
SELECT     dbo.Departments.DepartmentSName, dbo.Shifts.ShiftSName, dbo.Shifts.ShiftType, dbo.Companies.CompanySName, 
                      dbo.CompanyDepartmentShifts.FromDate, dbo.CompanyDepartmentShifts.ToDate, dbo.CompanyDepartmentShifts.CompanyDepartmentShiftId, 
                      dbo.CompanyDepartmentShifts.LastModifiedDate, dbo.Companies.CompanyId, dbo.Departments.DepartmentId, dbo.Shifts.ShiftId
FROM         dbo.Departments INNER JOIN
                      dbo.Shifts INNER JOIN
                      dbo.Companies INNER JOIN
                      dbo.CompanyDepartmentShifts ON dbo.Companies.CompanyId = dbo.CompanyDepartmentShifts.CompanyId ON 
                      dbo.Shifts.ShiftId = dbo.CompanyDepartmentShifts.ShiftId ON dbo.Departments.DepartmentId = dbo.CompanyDepartmentShifts.DepartmentId
WHERE     (dbo.Departments.RecordStatus = 1) AND (dbo.Companies.RecordStatus = 1)
GO
/****** Object:  View [dbo].[vw_SpecialEntries]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_SpecialEntries]
AS
SELECT     TOP 100 PERCENT dbo.SpecialEntries.FromDate, dbo.SpecialEntries.ToDate, dbo.SpecialEntries.SpecialType, dbo.SpecialEntries.SpecialEntryStatus, 
                      dbo.Employees.EmployeeName, dbo.SpecialEntries.SpecialEntryId, dbo.Employees.Designation, dbo.Categories.CategorySName, 
                      dbo.Companies.CompanySName, dbo.Departments.DepartmentSName, dbo.Employees.Status, dbo.Employees.NumericCode, 
                      dbo.Employees.StringCode, dbo.Employees.EmployeeCode, dbo.Employees.EmployementType, dbo.Companies.CompanyIsVisible, 
                      dbo.SpecialEntries.Duration, dbo.Companies.CompanyId, dbo.Departments.DepartmentId, dbo.Employees.EmployeeId, dbo.SpecialEntries.Remarks, 
                      dbo.SpecialEntries.IsApproved, dbo.SpecialEntries.BeginTime, dbo.SpecialEntries.EndTime
FROM         dbo.SpecialEntries INNER JOIN
                      dbo.Employees ON dbo.SpecialEntries.EmployeeId = dbo.Employees.EmployeeId INNER JOIN
                      dbo.Categories ON dbo.Employees.CategoryId = dbo.Categories.CategoryId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId INNER JOIN
                      dbo.Departments ON dbo.Employees.DepartmentId = dbo.Departments.DepartmentId
WHERE     (dbo.Employees.RecordStatus = 1)
ORDER BY dbo.SpecialEntries.FromDate DESC, dbo.SpecialEntries.ToDate DESC
GO
/****** Object:  View [dbo].[vw_LeaveEntries]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_LeaveEntries]
AS
SELECT     TOP 100 PERCENT dbo.LeaveEntries.LeaveEntryId, dbo.LeaveTypes.LeaveTypeSName, dbo.LeaveEntries.LeaveStatus, dbo.LeaveEntries.FromDate, 
                      dbo.LeaveEntries.ToDate, dbo.Employees.EmployeeName, dbo.Companies.CompanySName, dbo.Categories.CategorySName, 
                      dbo.Departments.DepartmentSName, dbo.Employees.Status, dbo.Employees.EmployeeCode, dbo.Employees.Designation, 
                      dbo.Employees.EmployementType, dbo.Companies.CompanyIsVisible, dbo.Companies.CompanyId, dbo.Employees.EmployeeId, 
                      dbo.Employees.RecordStatus, dbo.LeaveEntries.LeaveTypeId, dbo.Departments.DepartmentId, dbo.LeaveEntries.Remarks, 
                      dbo.LeaveEntries.IsApproved, dbo.Employees.StringCode, dbo.Employees.NumericCode
FROM         dbo.Employees INNER JOIN
                      dbo.LeaveEntries ON dbo.Employees.EmployeeId = dbo.LeaveEntries.EmployeeId INNER JOIN
                      dbo.LeaveTypes ON dbo.LeaveEntries.LeaveTypeId = dbo.LeaveTypes.LeaveTypeId INNER JOIN
                      dbo.Categories ON dbo.Employees.CategoryId = dbo.Categories.CategoryId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId INNER JOIN
                      dbo.Departments ON dbo.Employees.DepartmentId = dbo.Departments.DepartmentId
ORDER BY dbo.LeaveEntries.FromDate DESC, dbo.LeaveEntries.ToDate DESC
GO
/****** Object:  View [dbo].[vw_EmployeeShiftDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_EmployeeShiftDetails]
AS
SELECT     TOP 100 PERCENT dbo.EmployeeShift.EmployeeShiftId, dbo.EmployeeShift.Fromdate, dbo.EmployeeShift.Todate, dbo.Employees.EmployeeName, 
                      dbo.Shifts.ShiftSName, dbo.Departments.DepartmentSName, dbo.Companies.CompanySName, dbo.Categories.CategorySName, 
                      dbo.Employees.Designation, dbo.Employees.Status, dbo.Employees.EmployeeCode, dbo.Employees.NumericCode, dbo.Employees.StringCode, 
                      dbo.Employees.EmployementType, dbo.Companies.CompanyIsVisible, dbo.Shifts.ShiftType, dbo.Companies.CompanyId, dbo.Shifts.ShiftId, 
                      dbo.EmployeeShift.EmployeeId, dbo.Departments.DepartmentId
FROM         dbo.Employees INNER JOIN
                      dbo.EmployeeShift ON dbo.Employees.EmployeeId = dbo.EmployeeShift.EmployeeId INNER JOIN
                      dbo.Shifts ON dbo.EmployeeShift.ShiftId = dbo.Shifts.ShiftId INNER JOIN
                      dbo.Categories ON dbo.Employees.CategoryId = dbo.Categories.CategoryId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId INNER JOIN
                      dbo.Departments ON dbo.Employees.DepartmentId = dbo.Departments.DepartmentId
WHERE     (dbo.Employees.RecordStatus = 1)
ORDER BY dbo.EmployeeShift.Fromdate DESC, dbo.EmployeeShift.Todate DESC
GO
/****** Object:  View [dbo].[vw_EmployeeDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_EmployeeDetails]
AS
SELECT     TOP 100 PERCENT dbo.Employees.EmployeeCode, dbo.Employees.EmployeeName, dbo.Employees.EmployeeCodeInDevice, 
                      dbo.Companies.CompanySName, dbo.Departments.DepartmentSName, dbo.Employees.Designation, dbo.Categories.CategorySName, 
                      dbo.Employees.Status, dbo.Employees.EmployementType, dbo.Employees.Gender, dbo.Employees.DOJ, dbo.Employees.DOC, dbo.Employees.DOR, 
                      dbo.Employees.EmployeeId, dbo.Companies.CompanyIsVisible, dbo.Employees.RecordStatus, dbo.Companies.CompanyId, 
                      dbo.Departments.DepartmentId, dbo.Categories.CategoryId, dbo.Employees.EmployeeRFIDNumber, dbo.Employees.StringCode, 
                      dbo.Employees.NumericCode, dbo.Employees.StringCode AS Expr1, dbo.Employees.NumericCode AS Expr2, dbo.Employees.DOB, 
                      dbo.Employees.FatherName, dbo.Employees.MotherName, dbo.Employees.ResidentialAddress, dbo.Employees.ContactNo, dbo.Employees.Email, 
                      dbo.Employees.DOB AS Expr3, dbo.Employees.PlaceOfBirth, dbo.Employees.Nomenee1, dbo.Employees.Nomenee2, 
                      dbo.Employees.PermanentAddress, dbo.Employees.Remarks
FROM         dbo.Categories INNER JOIN
                      dbo.Departments INNER JOIN
                      dbo.Companies INNER JOIN
                      dbo.Employees ON dbo.Companies.CompanyId = dbo.Employees.CompanyId ON dbo.Departments.DepartmentId = dbo.Employees.DepartmentId ON 
                      dbo.Categories.CategoryId = dbo.Employees.CategoryId
ORDER BY dbo.Employees.EmployeeId
GO
/****** Object:  View [dbo].[vw_EmployeeAndCategoryDetails]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_EmployeeAndCategoryDetails]
AS
SELECT     dbo.Employees.EmployeeId, dbo.Employees.EmployeeCode, dbo.Employees.CategoryId, dbo.Categories.CategoryFName, 
                      dbo.Categories.CategorySName, dbo.Categories.OTFormula, dbo.Categories.MinOT, dbo.Categories.ConsiderFirstLastPunch, 
                      dbo.Categories.GraceTime, dbo.Categories.ConsiderEarlyPunch, dbo.Categories.ConsiderLatePunch, dbo.Categories.SundayWeeklyOff, 
                      dbo.Categories.SaturdayWeeklyOff, dbo.Categories.WhichSaturday, dbo.Categories.CalculateHalfDay, dbo.Categories.HalfDayMins, 
                      dbo.Categories.CalculateAbsentDay, dbo.Categories.AbsentDayMins, dbo.Categories.DeductBreakHours, dbo.Categories.RecordStatus, 
                      dbo.Categories.C1, dbo.Categories.C2, dbo.Categories.C3, dbo.Categories.C4, dbo.Categories.C5, dbo.Categories.C6, dbo.Categories.C7, 
                      dbo.Employees.DepartmentId, dbo.Categories.TransferHPintoCompOff, dbo.Categories.TransferWOPintoCompOff, dbo.Categories.ForMissedPunch, 
                      dbo.Employees.StringCode, dbo.Employees.NumericCode, dbo.Employees.DOJ, dbo.Employees.DOC, dbo.Employees.DOR, 
                      dbo.Companies.CompanyId, dbo.Employees.Status, dbo.Employees.EmployeeName
FROM         dbo.Employees INNER JOIN
                      dbo.Categories ON dbo.Employees.CategoryId = dbo.Categories.CategoryId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId
GO
/****** Object:  View [dbo].[vw_DeviceLogList]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_DeviceLogList]
AS
SELECT     TOP 100 PERCENT dbo.DeviceLogs.LogDate, dbo.DeviceLogs.DeviceLogId, dbo.Employees.EmployeeId, dbo.DeviceLogs.Direction, 
                      dbo.Devices.DeviceSName, dbo.Employees.EmployeeCode, dbo.Employees.EmployeeCodeInDevice, dbo.Employees.EmployeeName, 
                      dbo.Companies.CompanySName, dbo.Departments.DepartmentSName, dbo.Categories.CategorySName, dbo.Devices.DeviceId, 
                      dbo.Employees.StringCode, dbo.Employees.NumericCode, dbo.Companies.CompanyIsVisible, dbo.Employees.Status, dbo.Employees.Designation, 
                      dbo.Employees.EmployementType, dbo.Departments.DepartmentId, dbo.Companies.CompanyId, dbo.Categories.CategoryId, dbo.DeviceLogs.UserId, 
                      dbo.Employees.RecordStatus, dbo.DeviceLogs.AttDirection
FROM         dbo.DeviceLogs INNER JOIN
                      dbo.Devices ON dbo.DeviceLogs.DeviceId = dbo.Devices.DeviceId INNER JOIN
                      dbo.Employees INNER JOIN
                      dbo.Categories ON dbo.Employees.CategoryId = dbo.Categories.CategoryId INNER JOIN
                      dbo.Companies ON dbo.Employees.CompanyId = dbo.Companies.CompanyId INNER JOIN
                      dbo.Departments ON dbo.Employees.DepartmentId = dbo.Departments.DepartmentId ON 
                      dbo.DeviceLogs.UserId = dbo.Employees.EmployeeCodeInDevice
ORDER BY dbo.DeviceLogs.LogDate DESC
GO
/****** Object:  View [dbo].[vw_AttendanceLogs]    Script Date: 03/25/2013 11:02:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vw_AttendanceLogs]
AS
SELECT     dbo.Employees.EmployeeName, dbo.Employees.EmployeeCode, dbo.Employees.StringCode, dbo.Employees.NumericCode, dbo.Employees.Gender, 
                      dbo.Employees.Designation, dbo.Employees.DOJ, dbo.Employees.DOR, dbo.Employees.DOC, dbo.Employees.EmployementType, 
                      dbo.Employees.Status AS EmployeesStatus, dbo.Shifts.ShiftFName, dbo.Shifts.ShiftSName, dbo.Shifts.BeginTime, dbo.Shifts.EndTime, 
                      dbo.Shifts.Break1, dbo.Shifts.Break2, dbo.Shifts.Break1BeginTime, dbo.Shifts.Break2BeginTime, dbo.Shifts.Break1EndTime, 
                      dbo.Shifts.Break2EndTime, dbo.Departments.DepartmentId, dbo.Categories.CategoryId, dbo.Companies.CompanyId, dbo.Companies.CompanySName, 
                      dbo.Categories.CategorySName, dbo.Departments.DepartmentSName, dbo.AttendanceLogs.AttendanceLogId, dbo.AttendanceLogs.AttendanceDate, 
                      dbo.AttendanceLogs.EmployeeId, dbo.AttendanceLogs.InTime, dbo.AttendanceLogs.InDeviceId, dbo.AttendanceLogs.OutTime, 
                      dbo.AttendanceLogs.OutDeviceId, dbo.AttendanceLogs.Duration, dbo.AttendanceLogs.LateBy, dbo.AttendanceLogs.EarlyBy, 
                      dbo.AttendanceLogs.IsOnLeave, dbo.AttendanceLogs.LeaveType, dbo.AttendanceLogs.LeaveDuration, dbo.AttendanceLogs.WeeklyOff, 
                      dbo.AttendanceLogs.Holiday, dbo.AttendanceLogs.LeaveRemarks, dbo.AttendanceLogs.PunchRecords, dbo.AttendanceLogs.ShiftId, 
                      dbo.AttendanceLogs.Present, dbo.AttendanceLogs.Absent, dbo.AttendanceLogs.Status, dbo.AttendanceLogs.StatusCode, dbo.AttendanceLogs.P1Status, 
                      dbo.AttendanceLogs.P2Status, dbo.AttendanceLogs.P3Status, dbo.AttendanceLogs.IsonSpecialOff, dbo.AttendanceLogs.SpecialOffType, 
                      dbo.AttendanceLogs.SpecialOffRemark, dbo.AttendanceLogs.SpecialOffDuration, dbo.AttendanceLogs.OverTime, dbo.AttendanceLogs.OverTimeE, 
                      dbo.AttendanceLogs.MissedOutPunch, dbo.AttendanceLogs.MissedInPunch, dbo.AttendanceLogs.C1, dbo.AttendanceLogs.C3, dbo.AttendanceLogs.C2, 
                      dbo.AttendanceLogs.C4, dbo.AttendanceLogs.C5, dbo.AttendanceLogs.C7
FROM         dbo.Categories INNER JOIN
                      dbo.Departments INNER JOIN
                      dbo.Companies INNER JOIN
                      dbo.AttendanceLogs INNER JOIN
                      dbo.Employees ON dbo.AttendanceLogs.EmployeeId = dbo.Employees.EmployeeId ON dbo.Companies.CompanyId = dbo.Employees.CompanyId ON 
                      dbo.Departments.DepartmentId = dbo.Employees.DepartmentId ON dbo.Categories.CategoryId = dbo.Employees.CategoryId INNER JOIN
                      dbo.Shifts ON dbo.AttendanceLogs.ShiftId = dbo.Shifts.ShiftId
GO
/****** Object:  Default [DF_Users_RecordStatus]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Users] ADD  CONSTRAINT [DF_Users_RecordStatus]  DEFAULT (1) FOR [RecordStatus]
GO
/****** Object:  Default [DF_UserPermissions_UserId]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_UserPermissions] ADD  CONSTRAINT [DF_UserPermissions_UserId]  DEFAULT (0) FOR [UserId]
GO
/****** Object:  Default [DF_UserPermissions_PermissionId]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_UserPermissions] ADD  CONSTRAINT [DF_UserPermissions_PermissionId]  DEFAULT (0) FOR [PermissionId]
GO
/****** Object:  Default [DF_UserCompanies_UserId]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_UserCompanies] ADD  CONSTRAINT [DF_UserCompanies_UserId]  DEFAULT (0) FOR [UserId]
GO
/****** Object:  Default [DF_UserCompanies_CompanyId]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_UserCompanies] ADD  CONSTRAINT [DF_UserCompanies_CompanyId]  DEFAULT (0) FOR [CompanyId]
GO
/****** Object:  Default [DF_MasterSettings_LastBackUpDate]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_MasterSettings] ADD  CONSTRAINT [DF_MasterSettings_LastBackUpDate]  DEFAULT ('1900-01-01') FOR [LastBackUpDate]
GO
/****** Object:  Default [DF_MasterSettings_IsAutoShift]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_MasterSettings] ADD  CONSTRAINT [DF_MasterSettings_IsAutoShift]  DEFAULT (0) FOR [IsAutoShift]
GO
/****** Object:  Default [DF_Employees_DOJ]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_DOJ]  DEFAULT ('1900-01-01') FOR [DOJ]
GO
/****** Object:  Default [DF_Employees_DOR]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_DOR]  DEFAULT ('1900-01-01') FOR [DOR]
GO
/****** Object:  Default [DF_Employees_DOC]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_DOC]  DEFAULT ('1900-01-01') FOR [DOC]
GO
/****** Object:  Default [DF_Employees_EmployeeDevicePassword]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_EmployeeDevicePassword]  DEFAULT ('') FOR [EmployeeDevicePassword]
GO
/****** Object:  Default [DF_Employees_EmployeeDeviceGroup]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_EmployeeDeviceGroup]  DEFAULT (1) FOR [EmployeeDeviceGroup]
GO
/****** Object:  Default [DF_Employees_FatherName]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_FatherName]  DEFAULT ('') FOR [FatherName]
GO
/****** Object:  Default [DF_Employees_MotherName]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_MotherName]  DEFAULT ('') FOR [MotherName]
GO
/****** Object:  Default [DF_Employees_ResidentialAddress]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_ResidentialAddress]  DEFAULT ('') FOR [ResidentialAddress]
GO
/****** Object:  Default [DF_Employees_PermanentAddress]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_PermanentAddress]  DEFAULT ('') FOR [PermanentAddress]
GO
/****** Object:  Default [DF_Employees_ContactNo]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_ContactNo]  DEFAULT ('') FOR [ContactNo]
GO
/****** Object:  Default [DF_Employees_Email]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_Email]  DEFAULT ('') FOR [Email]
GO
/****** Object:  Default [DF_Employees_DOB]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_DOB]  DEFAULT ('1900-01-01') FOR [DOB]
GO
/****** Object:  Default [DF_Employees_PlaceOfBirth]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_PlaceOfBirth]  DEFAULT ('') FOR [PlaceOfBirth]
GO
/****** Object:  Default [DF_Employees_Nomenee1]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_Nomenee1]  DEFAULT ('') FOR [Nomenee1]
GO
/****** Object:  Default [DF_Employees_Nomenee2]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_Nomenee2]  DEFAULT ('') FOR [Nomenee2]
GO
/****** Object:  Default [DF_Employees_Remarks]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_Remarks]  DEFAULT ('') FOR [Remarks]
GO
/****** Object:  Default [DF_Employees_RecordStatus]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_RecordStatus]  DEFAULT (1) FOR [RecordStatus]
GO
/****** Object:  Default [DF_Employees_HolidayGroup]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Employees] ADD  CONSTRAINT [DF_Employees_HolidayGroup]  DEFAULT ((-1)) FOR [HolidayGroup]
GO
/****** Object:  Default [DF_Devices_CommKey]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Devices] ADD  CONSTRAINT [DF_Devices_CommKey]  DEFAULT (0) FOR [CommKey]
GO
/****** Object:  Default [DF_Devices_LastLogDownloadDate]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Devices] ADD  CONSTRAINT [DF_Devices_LastLogDownloadDate]  DEFAULT ('1900-01-01 00:00') FOR [LastLogDownloadDate]
GO
/****** Object:  Default [DF__Devices__Transac__703EA55A]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Devices] ADD  CONSTRAINT [DF__Devices__Transac__703EA55A]  DEFAULT ('0') FOR [TransactionStamp]
GO
/****** Object:  Default [DF_OperationCommandsContents_Remarks]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceOperationLogs] ADD  CONSTRAINT [DF_OperationCommandsContents_Remarks]  DEFAULT ('') FOR [SerialNumber]
GO
/****** Object:  Default [DF_DeviceCommands_Title]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_Title]  DEFAULT ('') FOR [Title]
GO
/****** Object:  Default [DF_DeviceCommands_DeviceCommand]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_DeviceCommand]  DEFAULT ('') FOR [DeviceCommand]
GO
/****** Object:  Default [DF_DeviceCommands_SerialNumber]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_SerialNumber]  DEFAULT ('') FOR [SerialNumber]
GO
/****** Object:  Default [DF_DeviceCommands_Status]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_Status]  DEFAULT ('') FOR [Status]
GO
/****** Object:  Default [DF_DeviceCommands_Type]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_Type]  DEFAULT ('') FOR [Type]
GO
/****** Object:  Default [DF_DeviceCommands_CreationDate]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_CreationDate]  DEFAULT (getdate()) FOR [CreationDate]
GO
/****** Object:  Default [DF_DeviceCommands_ExecutionDate]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_DeviceCommands] ADD  CONSTRAINT [DF_DeviceCommands_ExecutionDate]  DEFAULT ('1900-01-01 00:00:00.000') FOR [ExecutionDate]
GO
/****** Object:  Default [DF_Departments_RecordStatus]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Departments] ADD  CONSTRAINT [DF_Departments_RecordStatus]  DEFAULT (1) FOR [RecordStatus]
GO
/****** Object:  Default [DF_Companies_RecordStatus]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Companies] ADD  CONSTRAINT [DF_Companies_RecordStatus]  DEFAULT (1) FOR [RecordStatus]
GO
/****** Object:  Default [DF_Categories_RecordStatus]    Script Date: 03/25/2013 11:02:48 ******/
ALTER TABLE [dbo].[essl_Categories] ADD  CONSTRAINT [DF_Categories_RecordStatus]  DEFAULT (1) FOR [RecordStatus]
GO