use master go CREATE DATABASE eBioserver GO USE [eBioserver] GO /****** Object: Table [dbo].[_MasterSettings] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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 CONSTRAINT [DF_MasterSettings_LastBackUpDate] DEFAULT ('1900-01-01'), [MinDiffBetweenTwoPunch] [int] NULL, [IsAutoShift] [int] NULL CONSTRAINT [DF_MasterSettings_IsAutoShift] DEFAULT ((0)), [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, [MemoHalfDayForLateEarlySubject] [nvarchar](4000) NULL, [MemoHalfDayForLateEarlyText] [nvarchar](4000) 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 /****** Object: Table [dbo].[DeviceCommands] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceCommands]( [DeviceCommandId] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](255) NULL, [DeviceCommand] [nvarchar](4000) NULL, [SerialNumber] [nvarchar](255) NULL, [Status] [nvarchar](255) NULL, [Type] [nvarchar](255) NULL, [CreationDate] [datetime] NULL, [ExecutionDate] [datetime] NULL, CONSTRAINT [DeviceCommands_PK] 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].[DeviceErrorMessages] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceErrorMessages]( [DeviceErrorMessageId] [int] IDENTITY(1,1) NOT NULL, [SerialNumber] [nvarchar](50) NULL, [ErrorMessage] [nvarchar](500) NULL, [LogStream] [nvarchar](4000) NULL, [CreatedDate] [nvarchar](50) NULL, CONSTRAINT [DeviceErrorMessages_PK] PRIMARY KEY CLUSTERED ( [DeviceErrorMessageId] 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].[DeviceLogs] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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].[DeviceOperationLogs] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceOperationLogs]( [DeviceOperationLogId] [int] IDENTITY(1,1) NOT NULL, [DeviceOperationLogCode] [int] NULL, [DeviceOperationLogExecutedOn] [datetime] NULL, [SerialNumber] [nvarchar](255) NULL, CONSTRAINT [DeviceOperationLogs_PK] 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].[DeviceOperationLogTypes] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceOperationLogTypes]( [OperationLogTypeId] [int] IDENTITY(1,1) NOT NULL, [OperationLogTypeCode] [int] NULL, [OperationLogTypeName] [nvarchar](255) NULL, CONSTRAINT [DeviceOperationLogTypes_PK] 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 /****** Object: Table [dbo].[Devices] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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 CONSTRAINT [DF_Devices_CommKey] DEFAULT (0), [ComPort] [nvarchar](255) NULL, [LastLogDownloadDate] [datetime] NULL CONSTRAINT [DF_Devices_LastLogDownloadDate] DEFAULT ('1900-01-01 00:00'), [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 DEFAULT ('0'), [LastPing] [datetime] NULL, [DeviceType] [nvarchar](255) NULL, [OpStamp] [nvarchar](255) NULL, [DownLoadType] [int] NULL, [Timezone] [nvarchar](50) NULL, [DeviceLocation] [nvarchar](50) NULL, [TimeOut] [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].[Devices] ON INSERT [dbo].[Devices] ([DeviceId], [DeviceFName], [DeviceSName], [DeviceDirection], [SerialNumber], [ConnectionType], [IpAddress], [BaudRate], [CommKey], [ComPort], [LastLogDownloadDate], [C1], [C2], [C3], [C4], [C5], [C6], [C7], [TransactionStamp], [LastPing], [DeviceType], [OpStamp], [DownLoadType], [Timezone], [DeviceLocation], [TimeOut]) VALUES (201, N'Test Device', N'TD', N'altinout', N'1', N'Tcp/IP', N'192.168.1.201', N'', N'0', N'', CAST(0x0000000000000000 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', CAST(0x0000000000000000 AS DateTime), N'Attendance', '0', 1, N'330', N'', N'300') SET IDENTITY_INSERT [dbo].[Devices] OFF GO /****** Object: Table [dbo].[DevicesStatus] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DevicesStatus]( [DeviceStatusId] [int] IDENTITY(1,1) NOT NULL, [DeviceId] [int] NULL, [DeviceStatus] [nvarchar](255) NULL, [LastDeviceStatusOn] [datetime] NULL, CONSTRAINT [DevicesStatus_PK] PRIMARY KEY CLUSTERED ( [DeviceStatusId] 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].[Employees] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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 CONSTRAINT [DF_Employees_DOJ] DEFAULT ('1900-01-01'), [DOR] [datetime] NULL CONSTRAINT [DF_Employees_DOR] DEFAULT ('1900-01-01'), [DOC] [datetime] NULL CONSTRAINT [DF_Employees_DOC] DEFAULT ('1900-01-01'), [EmployeeCodeInDevice] [nvarchar](50) NOT NULL, [EmployeeRFIDNumber] [nvarchar](255) NULL, [EmployementType] [nvarchar](255) NOT NULL, [Status] [nvarchar](255) NOT NULL, [EmployeeDevicePassword] [nvarchar](50) NULL CONSTRAINT [DF_Employees_EmployeeDevicePassword] DEFAULT (''), [EmployeeDeviceGroup] [nvarchar](50) NULL CONSTRAINT [DF_Employees_EmployeeDeviceGroup] DEFAULT (1), [FatherName] [nvarchar](255) NULL CONSTRAINT [DF_Employees_FatherName] DEFAULT (''), [MotherName] [nvarchar](255) NULL CONSTRAINT [DF_Employees_MotherName] DEFAULT (''), [ResidentialAddress] [nvarchar](255) NULL CONSTRAINT [DF_Employees_ResidentialAddress] DEFAULT (''), [PermanentAddress] [nvarchar](255) NULL CONSTRAINT [DF_Employees_PermanentAddress] DEFAULT (''), [ContactNo] [nvarchar](255) NULL CONSTRAINT [DF_Employees_ContactNo] DEFAULT (''), [Email] [nvarchar](255) NULL CONSTRAINT [DF_Employees_Email] DEFAULT (''), [DOB] [datetime] NULL CONSTRAINT [DF_Employees_DOB] DEFAULT ('1900-01-01'), [PlaceOfBirth] [nvarchar](255) NULL CONSTRAINT [DF_Employees_PlaceOfBirth] DEFAULT (''), [Nomenee1] [nvarchar](255) NULL CONSTRAINT [DF_Employees_Nomenee1] DEFAULT (''), [Nomenee2] [nvarchar](255) NULL CONSTRAINT [DF_Employees_Nomenee2] DEFAULT (''), [Remarks] [ntext] NULL CONSTRAINT [DF_Employees_Remarks] DEFAULT (''), [RecordStatus] [int] NULL CONSTRAINT [DF_Employees_RecordStatus] DEFAULT (1), [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] NULL, [ShiftGroupId] [int] NULL, [ShiftRosterId] [int] NULL, [LastModifiedBy] [nvarchar](50) 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].[EmployeesBio] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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].[ParallelAttLogExportDetails] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ParallelAttLogExportDetails]( [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, [DBPath] [nvarchar](255) NULL, [AttendanceDate] [nvarchar](255) NULL, [AttendanceDateFormat] [nvarchar](255) NULL, [EmployeeCode] [nvarchar](255) NULL, [Company] [nvarchar](255) NULL, [Category] [nvarchar](255) NULL, [Department] [nvarchar](255) NULL, [Designation] [nvarchar](255) NULL, [EmployementType] [nvarchar](255) NULL, [InDate] [nvarchar](255) NULL, [InDateFormat] [nvarchar](255) NULL, [InTime] [nvarchar](255) NULL, [InTimeFormat] [nvarchar](255) NULL, [InDevice] [nvarchar](255) NULL, [InLocation] [nvarchar](255) NULL, [OutDate] [nvarchar](255) NULL, [OutDateFormat] [nvarchar](255) NULL, [OutTime] [nvarchar](255) NULL, [OutTimeFormat] [nvarchar](255) NULL, [OutDevice] [nvarchar](255) NULL, [OutLocation] [nvarchar](255) NULL, [Status] [nvarchar](255) NULL, [StatusCode] [nvarchar](255) NULL, [Duration] [nvarchar](255) NULL, [LateBy] [nvarchar](255) NULL, [EarlyBy] [nvarchar](255) NULL, [OverTime] [nvarchar](255) NULL, [IsOnLeave] [nvarchar](255) NULL, [LeaveType] [nvarchar](255) NULL, [IsOnOD] [nvarchar](255) NULL, [ODDuration] [nvarchar](255) NULL, [PunchRecords] [nvarchar](255) NULL, [ShiftName] [nvarchar](255) NULL, [IsReservedField1] [int] NULL, [IsReservedField2] [int] NULL, [IsReservedField3] [int] NULL, [ReservedField1] [nvarchar](255) NULL, [ReservedField1Value] [nvarchar](255) NULL, [ReservedField2] [nvarchar](255) NULL, [ReservedField2Value] [nvarchar](255) NULL, [ReservedField3] [nvarchar](255) NULL, [ReservedField3Value] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[ParallelDatabaseDetails] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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, [LogTime] [nvarchar](255) NULL, [LogDateTime] [nvarchar](255) NULL, [LogTimeFormat] [nvarchar](255) NULL, [LogDateTimeFormat] [nvarchar](255) NULL, [LogDateFormat] [nvarchar](255) NULL, [InValue] [nvarchar](255) NULL, [OutValue] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Permissions] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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 /****** Object: Table [dbo].[UserPermissions] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserPermissions]( [UserPermissionId] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NOT NULL CONSTRAINT [DF_UserPermissions_UserId] DEFAULT (0), [PermissionId] [int] NOT NULL CONSTRAINT [DF_UserPermissions_PermissionId] DEFAULT (0), 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 /****** Object: Table [dbo].[Users] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[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 CONSTRAINT [DF_Users_RecordStatus] DEFAULT (1), [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 /****** Object: Table [dbo].[VerificationMode] Script Date: 7/15/2014 7:53:25 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[VerificationMode]( [VerifyMethodCode] [int] NULL, [VerifyMethodName] [nvarchar](max) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[MasterSettings] ON INSERT [dbo].[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], [MemoHalfDayForLateEarlySubject], [MemoHalfDayForLateEarlyText]) VALUES (1, -1, 0, N'00:00', N'00:00', -1, N'1', N'1', 240, N'uWlPuRaHsTW2vgpIq1Y3QmXREXFLRieTNvqRDWtYVmekIOeCI3cYpYjJtwT7EALRCQbkjat7GDevwuCsXyGVlt9intqcNgGhCvPaiG4slhN8qNXt19zU+tz/HZwgq1ea5w3YZWYuJaubhh/s8jhKMVt+6Ktt+P/HPr9y912VVlKZYOvzcow+4w==', 120, N'eTimeTrackLite 6.6', 0, N'', 1, N'2010-04-27', 5, -1, N'enterprise Software Solutions Lab(eSSL)', N'Bangalore', N' ', N' ', N'http://www.esslindia.com', NULL, NULL, N'', N'', N'', NULL, NULL, NULL, NULL, NULL, 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, N'HALF DAY FOR LATE-COMING/EARLY-GOING NOTICE/MEMO.', N'It has been observed from the Attendance Record that you were late coming/early going unauthorisedly i.e. without permission on below said attendance date. Hence, we have marked you as Half day.') SET IDENTITY_INSERT [dbo].[MasterSettings] OFF SET IDENTITY_INSERT [dbo].[DeviceOperationLogTypes] ON INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (1, 0, N'Power On') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (2, 1, N'Power Off') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (3, 2, N'The Authentication is Failed') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (4, 3, N'Alarm') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (5, 4, N'Enter into the Main Menu') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (6, 5, N'Change The Setting') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (7, 6, N'Enroll a FingerPrint') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (8, 7, N'Enroll a Password') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (9, 8, N'Enroll a HID Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (10, 9, N'Delete a User') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (11, 10, N'Delete a FingerPrint') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (12, 11, N'Delete a Password') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (13, 12, N'Delete a RFID Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (14, 13, N'Clear the Data') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (15, 14, N'Create a MF Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (16, 15, N'Enroll a MF Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (17, 16, N'Register a MF Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (18, 17, N'Delete The Registration of MF Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (19, 18, N'Clear the MF Cards Content') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (20, 19, N'Move The Enroll Data into Card') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (21, 20, N'Coyp The Data in The Card to The Machine') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (22, 21, N'Set The Time') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (23, 22, N'Factory Setting') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (24, 23, N'Delete The In And Out Record') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (25, 24, N'Clear The Administrator Privilege') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (26, 25, N'Modify The Setting of Access Control Group') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (27, 26, N'Modify The Setting Of User Access Control') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (28, 27, N'Modify The Time Field Of Access Control') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (29, 28, N'Modify The Setting Of Unclock Combination') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (30, 29, N'Unclock') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (31, 30, N'Enroll a User') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (32, 31, N'Change The Finger Prints Attribute') INSERT [dbo].[DeviceOperationLogTypes] ([OperationLogTypeId], [OperationLogTypeCode], [OperationLogTypeName]) VALUES (33, 32, N'Duress Alarm') SET IDENTITY_INSERT [dbo].[DeviceOperationLogTypes] OFF INSERT [dbo].[ParallelAttLogExportDetails] ([IsParallelDatabaseDowload], [DatabaseType], [Service], [Port], [ServerName], [DatabaseName], [DatabaseUserName], [DatabasePassword], [TableName], [DBPath], [AttendanceDate], [AttendanceDateFormat], [EmployeeCode], [Company], [Category], [Department], [Designation], [EmployementType], [InDate], [InDateFormat], [InTime], [InTimeFormat], [InDevice], [InLocation], [OutDate], [OutDateFormat], [OutTime], [OutTimeFormat], [OutDevice], [OutLocation], [Status], [StatusCode], [Duration], [LateBy], [EarlyBy], [OverTime], [IsOnLeave], [LeaveType], [IsOnOD], [ODDuration], [PunchRecords], [ShiftName], [IsReservedField1], [IsReservedField2], [IsReservedField3], [ReservedField1], [ReservedField1Value], [ReservedField2], [ReservedField2Value], [ReservedField3], [ReservedField3Value]) VALUES (0, N'Oracle', N'XE', N'1521', N'Localhost', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', N' ', 0, 0, 0, N' ', N' ', N' ', N' ', N' ', N' ') INSERT [dbo].[ParallelDatabaseDetails] ([IsParallelDatabaseDowload], [DatabaseType], [Service], [Port], [ServerName], [DatabaseName], [DatabaseUserName], [DatabasePassword], [TableName], [EmployeeCode], [LogDate], [Direction], [WorkCode], [IsReservedField1], [IsReservedField2], [ReservedField1], [ReservedField1Value], [ReservedField2], [ReservedField2Value], [LogTime], [LogDateTime], [LogTimeFormat], [LogDateTimeFormat], [LogDateFormat], [InValue], [OutValue]) VALUES (0, N'MS SQL Server', N'', N'', N'192.168.1.200', N'ParDB', N'sa', N'NgTub+nvAmI=', N'Devicelogs', N'Employeeid', N'LogDate', N'', N'', 0, 0, N'', N'', N'', N'', N'', N'', N'yyyy-MM-dd HH:mm:ss', N'yyyy-MM-dd HH:mm:ss', N'yyyy-MM-dd HH:mm:ss', N'in', N'out') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (1, N'Users') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (2, N'ViewUsers') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (3, N'AddUsers') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (4, N'EditUsers') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (5, N'DeleteUsers') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (76, N'DeviceManagement') INSERT [dbo].[Permissions] ([PermissionId], [Permission]) VALUES (77, N'Utilities') SET IDENTITY_INSERT [dbo].[UserPermissions] ON INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (947, 110, 1) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (948, 110, 2) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (949, 110, 3) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (950, 110, 4) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (951, 110, 5) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (952, 110, 6) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (953, 110, 7) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (954, 110, 8) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (955, 110, 9) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (956, 110, 10) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (957, 110, 11) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (958, 110, 12) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (959, 110, 13) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (960, 110, 14) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (961, 110, 15) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (962, 110, 16) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (963, 110, 17) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (964, 110, 18) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (965, 110, 19) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (966, 110, 20) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (967, 110, 21) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (968, 110, 22) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (969, 110, 23) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (970, 110, 24) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (971, 110, 25) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (972, 110, 26) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (973, 110, 27) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (974, 110, 28) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (975, 110, 29) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (976, 110, 30) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (977, 110, 31) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (978, 110, 32) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (979, 110, 33) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (980, 110, 34) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (981, 110, 35) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (982, 110, 36) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (983, 110, 37) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (984, 110, 38) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (985, 110, 39) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (986, 110, 40) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (987, 110, 41) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (988, 110, 42) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (989, 110, 43) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (990, 110, 44) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (991, 110, 45) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (992, 110, 46) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (993, 110, 47) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (994, 110, 48) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (995, 110, 49) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (996, 110, 50) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (997, 110, 51) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (998, 110, 52) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (999, 110, 53) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1000, 110, 54) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1001, 110, 55) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1002, 110, 56) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1003, 110, 57) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1004, 110, 58) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1005, 110, 59) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1006, 110, 60) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1007, 110, 61) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1008, 110, 62) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1009, 110, 63) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1010, 110, 64) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1011, 110, 65) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1012, 110, 66) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1013, 110, 67) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1014, 110, 68) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1015, 110, 69) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1016, 110, 70) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1017, 110, 71) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1018, 110, 72) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1019, 110, 85) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1020, 110, 73) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1021, 110, 75) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1022, 110, 76) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1023, 110, 77) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1024, 110, 78) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1025, 110, 79) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1026, 110, 80) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1027, 110, 81) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1028, 110, 82) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1029, 110, 83) INSERT [dbo].[UserPermissions] ([UserPermissionId], [UserId], [PermissionId]) VALUES (1030, 110, 87) SET IDENTITY_INSERT [dbo].[UserPermissions] OFF SET IDENTITY_INSERT [dbo].[Users] ON INSERT [dbo].[Users] ([UserId], [LoginName], [LoginPassword], [RoleName], [IsAdmin], [AccessI], [RecordStatus], [C1], [C2], [C3], [C4], [C5], [C6], [C7]) VALUES (110, N'essl', N'79195F54068C15E0DC4AAFDC97740DFC', N'Admin', -1, -1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL) SET IDENTITY_INSERT [dbo].[Users] OFF INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (0, N'VS_FP_OR_PW_OR_RF_OR_FACE') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (1, N'VS_FP') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (2, N'VS_PIN') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (3, N'VS_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (4, N'VS_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (5, N'VS_FP_OR_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (6, N'VS_FP_OR_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (7, N'VS_PW_OR_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (8, N'VS_PIN_AND_FP') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (9, N'VS_FP_AND_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (10, N'VS_FP_AND_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (11, N'VS_PW_AND_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (12, N'VS_FP_AND_PW_AND_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (13, N'VS_PIN_AND_FP_AND_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (14, N'VS_FP_AND_RF_OR_PIN') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (15, N'VS_FACE') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (16, N'VS_FACE_AND_FP') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (17, N'VS_FACE_AND_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (18, N'VS_FACE_AND_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (19, N'VS_FACE_AND_FP_AND_RF') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (20, N'VS_FACE_AND_FP_AND_PW') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (21, N'VS_OTHER') INSERT [dbo].[VerificationMode] ([VerifyMethodCode], [VerifyMethodName]) VALUES (22, N'VS_NUM')