Hikvision iVMS-4200 Installation on SQL Server
Sat Dec 02 2023 09:03:23 GMT+0000 (Coordinated Universal Time)
Saved by @Taimoor
USE [master] GO /****** Object: Database [Hikvision] Script Date: 3/30/2021 8:55:15 AM ******/ CREATE DATABASE [Hikvision] ON PRIMARY ( NAME = N'Hikvision', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Hikvision.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'Hikvision_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\Hikvision_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [Hikvision].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [Hikvision] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [Hikvision] SET ANSI_NULLS OFF GO ALTER DATABASE [Hikvision] SET ANSI_PADDING OFF GO ALTER DATABASE [Hikvision] SET ANSI_WARNINGS OFF GO ALTER DATABASE [Hikvision] SET ARITHABORT OFF GO ALTER DATABASE [Hikvision] SET AUTO_CLOSE OFF GO ALTER DATABASE [Hikvision] SET AUTO_SHRINK OFF GO ALTER DATABASE [Hikvision] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [Hikvision] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [Hikvision] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [Hikvision] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [Hikvision] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [Hikvision] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [Hikvision] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [Hikvision] SET DISABLE_BROKER GO ALTER DATABASE [Hikvision] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [Hikvision] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [Hikvision] SET TRUSTWORTHY OFF GO ALTER DATABASE [Hikvision] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [Hikvision] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [Hikvision] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [Hikvision] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [Hikvision] SET RECOVERY FULL GO ALTER DATABASE [Hikvision] SET MULTI_USER GO ALTER DATABASE [Hikvision] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [Hikvision] SET DB_CHAINING OFF GO EXEC sys.sp_db_vardecimal_storage_format N'Hikvision', N'ON' GO USE [Hikvision] GO /****** Object: User [hik] Script Date: 3/30/2021 8:55:15 AM ******/ CREATE USER [hik] FOR LOGIN [hik] WITH DEFAULT_SCHEMA=[dbo] GO sys.sp_addrolemember @rolename = N'db_owner', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_accessadmin', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_securityadmin', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_ddladmin', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_backupoperator', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_datareader', @membername = N'hik' GO sys.sp_addrolemember @rolename = N'db_datawriter', @membername = N'hik' GO /****** Object: Table [dbo].[attlog] Script Date: 3/30/2021 8:55:15 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[attlog]( [employeeID] [nvarchar](50) NULL, [authDateTime] [datetime] NULL, [authDate] [date] NULL, [authTime] [time](7) NULL, [direction] [nvarchar](50) NULL, [deviceName] [nvarchar](50) NULL, [deviceSN] [nvarchar](50) NULL, [personName] [nvarchar](50) NULL, [cardNo] [nvarchar](50) NULL, [serialNo] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO USE [master] GO ALTER DATABASE [Hikvision] SET READ_WRITE GO
Comments