气体检测系统

文件下载地址：http://106.14.213.225/files/

1、安装MsSqlServer2019

  

 

然后安装SSMS，双击SSMS-Setup-CHS.exe进行安装。 

 2、安装MsSqlServer2008R2数据库教程

打开SQL Server配置管理器，

 

3、自动化创建数据库脚本

 

USE [master]
GO
/****** Object:  Database [GasCheckAlarm]    Script Date: 11/25/2023 19:41:18 ******/
CREATE DATABASE [GasCheckAlarm] ON  PRIMARY 
( NAME = N'GasCheckAlarm', FILENAME = N'C:\GasCheckAlarm.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'GasCheckAlarm_log', FILENAME = N'C:\GasCheckAlarm_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [GasCheckAlarm] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [GasCheckAlarm].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [GasCheckAlarm] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [GasCheckAlarm] SET ANSI_NULLS OFF
GO
ALTER DATABASE [GasCheckAlarm] SET ANSI_PADDING OFF
GO
ALTER DATABASE [GasCheckAlarm] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [GasCheckAlarm] SET ARITHABORT OFF
GO
ALTER DATABASE [GasCheckAlarm] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [GasCheckAlarm] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [GasCheckAlarm] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [GasCheckAlarm] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [GasCheckAlarm] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [GasCheckAlarm] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [GasCheckAlarm] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [GasCheckAlarm] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [GasCheckAlarm] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [GasCheckAlarm] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [GasCheckAlarm] SET  DISABLE_BROKER
GO
ALTER DATABASE [GasCheckAlarm] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [GasCheckAlarm] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [GasCheckAlarm] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [GasCheckAlarm] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [GasCheckAlarm] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [GasCheckAlarm] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [GasCheckAlarm] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [GasCheckAlarm] SET  READ_WRITE
GO
ALTER DATABASE [GasCheckAlarm] SET RECOVERY FULL
GO
ALTER DATABASE [GasCheckAlarm] SET  MULTI_USER
GO
ALTER DATABASE [GasCheckAlarm] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [GasCheckAlarm] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'GasCheckAlarm', N'ON'
GO
USE [GasCheckAlarm]
GO
/****** Object:  Table [dbo].[Machine]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Machine](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [MailAddress] [nvarchar](10) NOT NULL,
    [MachineName] [nvarchar](50) NOT NULL,
    [FactoryID] [int] NOT NULL,
    [ProtocolType] [int] NOT NULL,
    [BaudRate] [int] NOT NULL,
    [PortName] [nvarchar](10) NULL,
 CONSTRAINT [PK_Machine] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[HistoryData]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HistoryData](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ProbeID] [int] NOT NULL,
    [CheckTime] [datetime] NOT NULL,
    [GasValue] [float] NOT NULL,
    [MachineID] [int] NOT NULL,
 CONSTRAINT [PK_HistoryData] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[GasTypes]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GasTypes](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [GasName] [nvarchar](50) NULL,
    [MinValue] [float] NULL,
    [MaxValue] [float] NULL,
 CONSTRAINT [PK_GasTypes] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[Factory]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Factory](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FactoryName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Factory] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[DeviceTag]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DeviceTag](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [TagName] [nvarchar](50) NOT NULL,
    [ParentID] [int] NOT NULL,
    [Position] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_DeviceTag] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[CameraHistory]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CameraHistory](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [AndroidID] [varchar](20) NULL,
    [TimeStamp] [int] NULL,
    [GasValues] [varchar](20) NULL,
 CONSTRAINT [PK_CameraHistory] PRIMARY KEY CLUSTERED 
(
    [ID] 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 ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Camera]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Camera](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [AndroidID] [varchar](20) NULL,
    [IP] [varchar](20) NULL,
    [Port] [varchar](5) NULL,
    [UserName] [varchar](10) NULL,
    [UserPwd] [varchar](15) NULL,
    [MachineAddress] [char](2) NULL,
    [GasInfos] [nvarchar](100) NULL,
    [GasValues] [varchar](20) NULL,
 CONSTRAINT [PK_Camera] PRIMARY KEY CLUSTERED 
(
    [ID] 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 ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'格式：气体1地址,气体1类型,气体1一级报警值,气体1二级报警值;.....' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Camera', @level2type=N'COLUMN',@level2name=N'GasInfos'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'气体值集合' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Camera', @level2type=N'COLUMN',@level2name=N'GasValues'
GO
/****** Object:  Table [dbo].[WaterSeal]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WaterSeal](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [Medium] [nvarchar](50) NULL,
    [Number] [nvarchar](15) NULL,
    [InstallPosition] [nvarchar](50) NULL,
    [Category] [nvarchar](15) NULL,
    [DesignPressure] [int] NOT NULL,
    [SerialNumber] [nvarchar](25) NULL,
 CONSTRAINT [PK_ShuiFeng] PRIMARY KEY CLUSTERED 
(
    [ID] 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: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Users](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [AccountName] [nvarchar](50) NOT NULL,
    [AccountPwd] [nvarchar](50) NOT NULL,
    [UserName] [nvarchar](50) NOT NULL,
    [UserNumber] [nvarchar](50) NULL,
    [Phone] [varchar](20) NULL,
    [Authority] [int] NOT NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
    [ID] 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 ANSI_PADDING OFF
GO
insert into Users values('admin','admin','admin',1,1,1)
GO
/****** Object:  Table [dbo].[Probe]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Probe](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [MailAddress] [nvarchar](10) NOT NULL,
    [ProbeName] [nvarchar](100) NOT NULL,
    [GasKind] [int] NOT NULL,
    [MachineID] [int] NOT NULL,
    [Pos3D] [nvarchar](60) NULL,
    [Pos2D] [nvarchar](60) NULL,
    [SerialNumber] [nvarchar](25) NULL,
    [TagName] [nvarchar](25) NULL,
    [CheckTime] [datetime] NULL,
    [GasValue] [float] NOT NULL,
 CONSTRAINT [PK_Probe] PRIMARY KEY CLUSTERED 
(
    [ID] 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].[PointCheck]    Script Date: 11/25/2023 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PointCheck](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [DeviceID] [int] NOT NULL,
    [DeviceName] [nvarchar](50) NOT NULL,
    [DeviceType] [int] NOT NULL,
    [UserName] [nvarchar](50) NOT NULL,
    [QrCodePath] [nvarchar](50) NULL,
    [CheckTime] [datetime] NOT NULL,
    [Description] [nvarchar](60) NULL,
    [Result] [nvarchar](60) NULL,
 CONSTRAINT [PK_PointCheck] PRIMARY KEY CLUSTERED 
(
    [ID] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0探头 1水封' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PointCheck', @level2type=N'COLUMN',@level2name=N'DeviceType'
GO
/****** Object:  Default [DF_Machine_BaudRate]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[Machine] ADD  CONSTRAINT [DF_Machine_BaudRate]  DEFAULT ((4800)) FOR [BaudRate]
GO
/****** Object:  Default [DF_HistoryData_CheckTime]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[HistoryData] ADD  CONSTRAINT [DF_HistoryData_CheckTime]  DEFAULT (getdate()) FOR [CheckTime]
GO
/****** Object:  Default [DF_HistoryData_GasValue]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[HistoryData] ADD  CONSTRAINT [DF_HistoryData_GasValue]  DEFAULT ((0)) FOR [GasValue]
GO
/****** Object:  Default [DF_GasTypes_MinValue]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[GasTypes] ADD  CONSTRAINT [DF_GasTypes_MinValue]  DEFAULT ((0)) FOR [MinValue]
GO
/****** Object:  Default [DF_GasTypes_MaxValue]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[GasTypes] ADD  CONSTRAINT [DF_GasTypes_MaxValue]  DEFAULT ((0)) FOR [MaxValue]
GO
/****** Object:  Default [DF_WaterSeal_DesignPressure]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[WaterSeal] ADD  CONSTRAINT [DF_WaterSeal_DesignPressure]  DEFAULT ((0)) FOR [DesignPressure]
GO
/****** Object:  Default [DF_Users_Authority]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF_Users_Authority]  DEFAULT ((0)) FOR [Authority]
GO
/****** Object:  Default [DF_Probe_CheckTime]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[Probe] ADD  CONSTRAINT [DF_Probe_CheckTime]  DEFAULT (getdate()) FOR [CheckTime]
GO
/****** Object:  Default [DF_Probe_GasValue]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[Probe] ADD  CONSTRAINT [DF_Probe_GasValue]  DEFAULT ((0)) FOR [GasValue]
GO
/****** Object:  Default [DF_PointCheck_CheckTime]    Script Date: 11/25/2023 19:41:19 ******/
ALTER TABLE [dbo].[PointCheck] ADD  CONSTRAINT [DF_PointCheck_CheckTime]  DEFAULT (getdate()) FOR [CheckTime]
GO