USE [EPushServer] GO /****** Object: Table [dbo].[DeviceCommands] Script Date: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceCommands]( [DeviceCommandId] [int] IDENTITY(101,1) NOT NULL, [Title] [nvarchar](255) NULL, [DeviceCommand] [nvarchar](4000) NULL, [SerialNumber] [nvarchar](255) NOT NULL, [Status] [nvarchar](255) NULL, [Type] [nvarchar](255) NULL, [CreationDate] [datetime] NULL, [ExecutionDate] [datetime] NULL, CONSTRAINT [PK_DeviceCommands] PRIMARY KEY CLUSTERED ( [DeviceCommandId] ASC, [SerialNumber] 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: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceErrorMessages]( [DeviceErrorMessageId] [int] IDENTITY(101,1) NOT NULL, [SerialNumber] [nvarchar](50) NOT NULL, [ErrorMessage] [nvarchar](500) NULL, [LogStream] [nvarchar](4000) NULL, [CreatedDate] [nvarchar](50) NULL, CONSTRAINT [PK_DeviceErrorMessages] PRIMARY KEY CLUSTERED ( [DeviceErrorMessageId] ASC, [SerialNumber] 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: 11/17/2015 2:23:42 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 ) ON [PRIMARY] GO /****** Object: Table [dbo].[DeviceLogs_Processed] Script Date: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceLogs_Processed]( [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 ) ON [PRIMARY] GO /****** Object: Table [dbo].[DeviceOperationLogs] Script Date: 11/17/2015 2:23:42 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] NOT NULL, [SerialNumber] [nvarchar](255) NOT NULL, CONSTRAINT [PK_DeviceOperationLogs] PRIMARY KEY CLUSTERED ( [DeviceOperationLogId] ASC, [DeviceOperationLogExecutedOn] ASC, [SerialNumber] 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: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DeviceOperationLogTypes]( [OperationLogTypeId] [int] NOT NULL, [OperationLogTypeCode] [int] NULL, [OperationLogTypeName] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[Devices] Script Date: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Devices]( [DeviceId] [int] IDENTITY(101,1) NOT NULL, [DeviceFName] [nvarchar](255) NOT NULL, [DeviceSName] [nvarchar](255) NOT NULL, [DeviceDirection] [nvarchar](255) NULL, [SerialNumber] [nvarchar](255) NOT 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, [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, [SerialNumber] 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: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Employees]( [EmployeeId] [int] IDENTITY(101,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] NULL, [ShiftGroupId] [int] NULL, [ShiftRosterId] [int] NULL, [LastModifiedBy] [nvarchar](50) NULL, CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED ( [EmployeeId] ASC, [EmployeeCodeInDevice] 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: 11/17/2015 2:23:42 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 ( [EmployeeId] ASC, [BioId] 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].[Users] Script Date: 11/17/2015 2:23:42 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [UserId] [int] IDENTITY(101,1) NOT NULL, [LoginName] [nvarchar](50) NOT NULL, [LoginPassword] [nvarchar](50) NOT 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 ( [LoginName] 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: 11/17/2015 2:23:42 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].[DeviceOperationLogs] ON INSERT [dbo].[DeviceOperationLogs] ([DeviceOperationLogId], [DeviceOperationLogCode], [DeviceOperationLogExecutedOn], [SerialNumber]) VALUES (1, 0, CAST(N'2015-08-24 14:36:27.000' AS DateTime), N'0426141601084') SET IDENTITY_INSERT [dbo].[DeviceOperationLogs] OFF 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].[Users] ON INSERT [dbo].[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, N'1', N'2015-08-25 17:59:38') 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')