2021XHFK/西湖防控/script.sql

USE [master]
GO
/****** Object:  Database [HT20210416-005]    Script Date: 05/20/2021 19:22:30 ******/
CREATE DATABASE [HT20210416-005] ON  PRIMARY 
( NAME = N'CCJQ_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HT20210416-005.mdf' , SIZE = 4736KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
 LOG ON 
( NAME = N'CCJQ_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HT20210416-005_log.ldf' , SIZE = 1024KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [HT20210416-005] SET COMPATIBILITY_LEVEL = 80
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [HT20210416-005].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [HT20210416-005] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [HT20210416-005] SET ANSI_NULLS OFF
GO
ALTER DATABASE [HT20210416-005] SET ANSI_PADDING OFF
GO
ALTER DATABASE [HT20210416-005] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [HT20210416-005] SET ARITHABORT OFF
GO
ALTER DATABASE [HT20210416-005] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [HT20210416-005] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [HT20210416-005] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [HT20210416-005] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [HT20210416-005] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [HT20210416-005] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [HT20210416-005] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [HT20210416-005] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [HT20210416-005] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [HT20210416-005] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [HT20210416-005] SET  DISABLE_BROKER
GO
ALTER DATABASE [HT20210416-005] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [HT20210416-005] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [HT20210416-005] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [HT20210416-005] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [HT20210416-005] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [HT20210416-005] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [HT20210416-005] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [HT20210416-005] SET  READ_WRITE
GO
ALTER DATABASE [HT20210416-005] SET RECOVERY SIMPLE
GO
ALTER DATABASE [HT20210416-005] SET  MULTI_USER
GO
ALTER DATABASE [HT20210416-005] SET PAGE_VERIFY TORN_PAGE_DETECTION
GO
ALTER DATABASE [HT20210416-005] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'HT20210416-005', N'ON'
GO
USE [HT20210416-005]
GO
/****** Object:  Table [dbo].[周期类别]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[周期类别](
	[周期类别编号] [char](1) NOT NULL,
	[周期类别名称] [varchar](256) NULL,
 CONSTRAINT [PK_周期类别] PRIMARY KEY CLUSTERED 
(
	[周期类别编号] 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.月度
   2.季度
   3.年度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'周期类别'
GO
INSERT [dbo].[周期类别] ([周期类别编号], [周期类别名称]) VALUES (N'1', N'月')
INSERT [dbo].[周期类别] ([周期类别编号], [周期类别名称]) VALUES (N'2', N'季')
INSERT [dbo].[周期类别] ([周期类别编号], [周期类别名称]) VALUES (N'3', N'年')
/****** Object:  Table [dbo].[整理数据规则]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[整理数据规则](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[源设备ID] [varchar](50) NOT NULL,
	[源表名] [varchar](50) NOT NULL,
	[源表列名] [varchar](50) NOT NULL,
	[目的设备ID] [varchar](50) NOT NULL,
	[目的表名] [varchar](50) NOT NULL,
	[目的模板表] [varchar](50) NULL,
	[目的表列名] [varchar](50) NOT NULL,
	[数据类型] [varchar](50) NOT NULL,
	[整理数据间隔] [varchar](50) NOT NULL,
	[整理数据延时] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[整理数据规则] ON
INSERT [dbo].[整理数据规则] ([ID], [源设备ID], [源表名], [源表列名], [目的设备ID], [目的表名], [目的模板表], [目的表列名], [数据类型], [整理数据间隔], [整理数据延时]) VALUES (1, N'150', N'历史记录_000150_2017', N'设备状态,通讯状态,数据来源,压力,电池电压', N'151', N'历史记录_000151_2017', NULL, N'设备状态,通讯状态,数据来源,压力,电池电压', N'日', N'30', N'2')
SET IDENTITY_INSERT [dbo].[整理数据规则] OFF
/****** Object:  Table [dbo].[用水记录表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用水记录表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[用水户ID] [int] NOT NULL,
	[用户卡号] [varchar](50) NOT NULL,
	[卡序列号] [varchar](50) NOT NULL,
	[记录来源] [varchar](50) NULL,
	[开泵时间] [datetime] NOT NULL,
	[开泵卡剩余水量] [numeric](18, 1) NOT NULL,
	[开泵卡剩余电量] [numeric](18, 1) NOT NULL,
	[关泵时间] [datetime] NOT NULL,
	[关泵卡剩余水量] [numeric](18, 1) NOT NULL,
	[关泵卡剩余电量] [numeric](18, 1) NOT NULL,
	[灌溉时长] [numeric](18, 0) NULL,
	[本次用水量] [numeric](18, 1) NOT NULL,
	[本次用电量] [numeric](18, 1) NOT NULL,
	[年累计用水量] [numeric](18, 1) NOT NULL,
	[年累计用电量] [numeric](18, 1) NOT NULL,
	[年可开采量] [numeric](18, 1) NOT NULL,
	[年剩余可开采量] [numeric](18, 1) NOT NULL,
 CONSTRAINT [PK_用水记录] 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].[用水计划]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用水计划](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[类别] [varchar](50) NULL,
	[所属ID] [varchar](50) NULL,
	[年] [varchar](50) NULL,
	[日期类型] [varchar](50) NULL,
	[计划用量] [varchar](500) NULL,
	[开始时间] [varchar](50) NULL,
	[监测量] [varchar](50) NULL,
	[操作员ID] [varchar](50) NULL,
	[创建时间] [datetime] NULL,
 CONSTRAINT [PK_用水计划] 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].[用水户定额]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[用水户定额](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用水户ID] [int] NOT NULL,
	[年份] [int] NOT NULL,
	[单位定额ID] [int] NULL,
	[面积] [numeric](18, 2) NULL,
	[定额] [numeric](18, 1) NULL,
 CONSTRAINT [PK_用水户定额] 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].[用水户]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用水户](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[管理ID] [int] NOT NULL,
	[户号] [varchar](50) NOT NULL,
	[状态] [varchar](50) NOT NULL,
	[水价ID] [int] NOT NULL,
	[电价ID] [int] NOT NULL,
	[累计购水金额] [numeric](18, 2) NOT NULL,
	[累计购电金额] [numeric](18, 2) NOT NULL,
	[累计购水量] [numeric](18, 1) NULL,
	[累计购电量] [numeric](18, 1) NULL,
	[累计用水量] [numeric](18, 1) NULL,
	[累计用电量] [numeric](18, 1) NULL,
	[年累计购水量] [numeric](18, 1) NULL,
	[年累计购电量] [numeric](18, 1) NULL,
	[最后用水时间] [varchar](50) NOT NULL,
	[详细信息] [varchar](5000) NULL,
 CONSTRAINT [PK_用水户] 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].[用户信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户名] [varchar](50) NOT NULL,
	[密码] [varchar](50) NOT NULL,
	[角色ID] [int] NOT NULL,
	[管理ID] [int] NOT NULL,
	[注册时间] [datetime] NULL,
	[所属地] [varchar](50) NULL,
	[上次登录时间] [datetime] NULL,
	[自定义测点] [varchar](20) NULL,
	[地图配置] [varchar](200) NULL,
	[操作密码] [varchar](50) NULL,
	[密码错误次数] [int] NULL,
	[锁定时间] [datetime] NULL,
 CONSTRAINT [PK_用户信息] 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
SET IDENTITY_INSERT [dbo].[用户信息] ON
INSERT [dbo].[用户信息] ([ID], [用户名], [密码], [角色ID], [管理ID], [注册时间], [所属地], [上次登录时间], [自定义测点], [地图配置], [操作密码], [密码错误次数], [锁定时间]) VALUES (1, N'data86', N'Data86@', 1, 1, CAST(0x00009EED00000000 AS DateTime), N'', CAST(0x0000ABB200BDAB78 AS DateTime), N'否', NULL, NULL, NULL, NULL)
INSERT [dbo].[用户信息] ([ID], [用户名], [密码], [角色ID], [管理ID], [注册时间], [所属地], [上次登录时间], [自定义测点], [地图配置], [操作密码], [密码错误次数], [锁定时间]) VALUES (2, N'admin', N'123', 2, 1, CAST(0x00009EED00000000 AS DateTime), N'', CAST(0x0000ACA600E64F60 AS DateTime), N'否', N'经度:118.202278,纬度:39.713083,缩放级别:13', N'123456', 0, CAST(0x0000000000000000 AS DateTime))
SET IDENTITY_INSERT [dbo].[用户信息] OFF
/****** Object:  Table [dbo].[用户级别]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户级别](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[级别名称] [varchar](50) NOT NULL,
 CONSTRAINT [PK_用户级别] 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
SET IDENTITY_INSERT [dbo].[用户级别] ON
INSERT [dbo].[用户级别] ([ID], [级别名称]) VALUES (1, N'data86')
INSERT [dbo].[用户级别] ([ID], [级别名称]) VALUES (2, N'admin')
INSERT [dbo].[用户级别] ([ID], [级别名称]) VALUES (3, N'市级')
INSERT [dbo].[用户级别] ([ID], [级别名称]) VALUES (4, N'区级')
INSERT [dbo].[用户级别] ([ID], [级别名称]) VALUES (5, N'单位级')
SET IDENTITY_INSERT [dbo].[用户级别] OFF
/****** Object:  Table [dbo].[用户辅助字段]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户辅助字段](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[字段名] [varchar](50) NOT NULL,
	[字段类型] [varchar](100) NOT NULL,
	[是否必填] [varchar](50) NOT NULL,
	[字段提示] [varchar](50) NULL,
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
SET IDENTITY_INSERT [dbo].[用户辅助字段] ON
INSERT [dbo].[用户辅助字段] ([ID], [字段名], [字段类型], [是否必填], [字段提示]) VALUES (1, N'工程类型', N'CDB工程信息-ID-工程信息', N'是', NULL)
INSERT [dbo].[用户辅助字段] ([ID], [字段名], [字段类型], [是否必填], [字段提示]) VALUES (2, N'编号', N'T', N'否', NULL)
INSERT [dbo].[用户辅助字段] ([ID], [字段名], [字段类型], [是否必填], [字段提示]) VALUES (3, N'层面编号', N'C表层-中层-底层-其他', N'否', NULL)
SET IDENTITY_INSERT [dbo].[用户辅助字段] OFF
/****** Object:  Table [dbo].[用户辅助信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户辅助信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户ID] [int] NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[值] [varchar](500) NULL,
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
SET IDENTITY_INSERT [dbo].[用户辅助信息] ON
INSERT [dbo].[用户辅助信息] ([ID], [用户ID], [名称], [值]) VALUES (1, 2, N'工程类型', N'1')
INSERT [dbo].[用户辅助信息] ([ID], [用户ID], [名称], [值]) VALUES (2, 2, N'编号', N'')
INSERT [dbo].[用户辅助信息] ([ID], [用户ID], [名称], [值]) VALUES (3, 2, N'层面编号', N'')
SET IDENTITY_INSERT [dbo].[用户辅助信息] OFF
/****** Object:  Table [dbo].[用户登录记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户登录记录](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[记录时间] [datetime] NOT NULL,
	[用户ID] [int] NOT NULL,
	[登录信息] [varchar](50) NOT NULL,
 CONSTRAINT [PK_用户登录记录] 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
SET IDENTITY_INSERT [dbo].[用户登录记录] ON
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (1, CAST(0x0000AC960091FD70 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (2, CAST(0x0000AC96009266E8 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (3, CAST(0x0000AC960092EB54 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (4, CAST(0x0000AC9600938D0C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (5, CAST(0x0000AC960093F1D4 AS DateTime), 2, N'登出,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (6, CAST(0x0000AC96009421E0 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (7, CAST(0x0000AC960094DFB8 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (8, CAST(0x0000AC9600979A28 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (9, CAST(0x0000AC960098E6F8 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (10, CAST(0x0000AC9600990B4C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (11, CAST(0x0000AC9600E570B8 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (12, CAST(0x0000AC9600EAA074 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (13, CAST(0x0000AC9600F017AC AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (14, CAST(0x0000AC9600F3A3E0 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (15, CAST(0x0000AC9600F77664 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (16, CAST(0x0000AC9600F7C290 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (17, CAST(0x0000ACA00095AF24 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (18, CAST(0x0000ACA000997140 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (19, CAST(0x0000ACA000A96E9C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (20, CAST(0x0000ACA000B3B578 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (21, CAST(0x0000ACA000B3F970 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (22, CAST(0x0000ACA000B44218 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (23, CAST(0x0000ACA000B4ED30 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (24, CAST(0x0000ACA000B5B594 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (25, CAST(0x0000ACA000B5FBE4 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (26, CAST(0x0000ACA000B66B38 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (27, CAST(0x0000ACA000B6C0C4 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (28, CAST(0x0000ACA000B70CF0 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (29, CAST(0x0000ACA000B70E1C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (30, CAST(0x0000ACA000B73E28 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (31, CAST(0x0000ACA000B7B22C AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (32, CAST(0x0000ACA000B86C80 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (33, CAST(0x0000ACA000BD6C30 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (34, CAST(0x0000ACA000BD9FC0 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (35, CAST(0x0000ACA000BF5E3C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (36, CAST(0x0000ACA000BF98D4 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (37, CAST(0x0000ACA000BFBF80 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (38, CAST(0x0000ACA000C07E84 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (39, CAST(0x0000ACA000C2F628 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (40, CAST(0x0000ACA000C30A14 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (41, CAST(0x0000ACA000E9226C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (42, CAST(0x0000ACA0011BC938 AS DateTime), 2, N'登入,IP:10.1.1.2')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (43, CAST(0x0000ACA1008ECA4C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (44, CAST(0x0000ACA2009DFCEC AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (45, CAST(0x0000ACA200A88B44 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (46, CAST(0x0000ACA200AA5C80 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (47, CAST(0x0000ACA200AE19EC AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (48, CAST(0x0000ACA200B0E71C AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (49, CAST(0x0000ACA2012104AC AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (50, CAST(0x0000ACA600AB2D18 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (51, CAST(0x0000ACA600AC93B0 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (52, CAST(0x0000ACA600E399A0 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (53, CAST(0x0000ACA600E42AF0 AS DateTime), 2, N'登入,IP:::1')
INSERT [dbo].[用户登录记录] ([ID], [记录时间], [用户ID], [登录信息]) VALUES (54, CAST(0x0000ACA600E64F60 AS DateTime), 2, N'登入,IP:::1')
SET IDENTITY_INSERT [dbo].[用户登录记录] OFF
/****** Object:  Table [dbo].[用户测点关系]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户测点关系](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户ID] [int] NOT NULL,
	[设备ID] [varchar](50) NULL,
	[管理ID] [varchar](50) NULL,
 CONSTRAINT [PK_用户测点关系] 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].[用户操作类型]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[用户操作类型](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[操作名称] [varchar](50) NOT NULL
) ON [PRIMARY]
SET ANSI_PADDING ON
ALTER TABLE [dbo].[用户操作类型] ADD [是否显示] [varchar](10) NULL
ALTER TABLE [dbo].[用户操作类型] ADD  CONSTRAINT [PK_用户操作类型] 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]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[用户操作类型] ON
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (1, N'即时刷新', N'是')
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (2, N'读取参数', N'是')
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (3, N'设置参数', N'是')
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (4, N'控制设备', N'是')
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (24, N'新建操作员', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (25, N'修改操作员', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (26, N'删除操作员', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (27, N'新建设备', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (28, N'修改设备', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (29, N'删除设备', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (34, N'新建管理', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (35, N'修改管理', NULL)
INSERT [dbo].[用户操作类型] ([ID], [操作名称], [是否显示]) VALUES (36, N'删除管理', NULL)
SET IDENTITY_INSERT [dbo].[用户操作类型] OFF
/****** Object:  Table [dbo].[用户操作记录模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户操作记录模板](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户ID] [int] NOT NULL,
	[记录时间] [datetime] NOT NULL,
	[设备ID] [int] NOT NULL,
	[操作类型ID] [int] NOT NULL,
	[操作描述] [varchar](2000) NOT NULL,
 CONSTRAINT [PK_用户操作记录模板] 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].[用户操作记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[用户操作记录](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户ID] [int] NULL,
	[记录时间] [datetime] NULL,
	[设备ID] [int] NULL,
	[操作类型ID] [int] NULL,
	[操作描述] [varchar](2000) NULL,
 CONSTRAINT [PK_用户操作记录] 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
SET IDENTITY_INSERT [dbo].[用户操作记录] ON
INSERT [dbo].[用户操作记录] ([ID], [用户ID], [记录时间], [设备ID], [操作类型ID], [操作描述]) VALUES (1, 2, CAST(0x0000ACA000B41464 AS DateTime), 0, 25, N'修改操作员成功')
INSERT [dbo].[用户操作记录] ([ID], [用户ID], [记录时间], [设备ID], [操作类型ID], [操作描述]) VALUES (2, 2, CAST(0x0000ACA2009E7B7C AS DateTime), 4, 4, N'控DO1开阀;执行结果:成功')
SET IDENTITY_INSERT [dbo].[用户操作记录] OFF
/****** Object:  Table [dbo].[系统信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[系统信息](
	[系统名称] [varchar](50) NULL,
	[数据库版本] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[系统信息] ([系统名称], [数据库版本]) VALUES (N'远程监测系统', N'10.2.0')
/****** Object:  Table [dbo].[系统参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[系统参数](
	[ID] [int] NOT NULL,
	[参数名称] [varchar](100) NOT NULL,
	[参数值] [varchar](200) NOT NULL,
 CONSTRAINT [PK_系统参数] PRIMARY KEY NONCLUSTERED 
(
	[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' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'系统参数'
GO
INSERT [dbo].[系统参数] ([ID], [参数名称], [参数值]) VALUES (1, N'周期明细编号', N'1')
/****** Object:  Table [dbo].[文件目录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[文件目录](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[目录名称] [varchar](50) NOT NULL,
	[文件数量] [int] NULL,
	[上级目录ID] [int] NOT NULL,
	[创建用户ID] [varchar](50) NULL,
	[创建时间] [datetime] NULL,
	[是否私有] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[文件列表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[文件列表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[文件名称] [varchar](50) NOT NULL,
	[文件长度] [varchar](50) NOT NULL,
	[文件类型] [varchar](50) NULL,
	[目录索引] [int] NOT NULL,
	[上传用户] [int] NOT NULL,
	[上传时间] [datetime] NOT NULL,
	[下载次数] [int] NULL,
	[是否私有] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[通讯设备]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[通讯设备](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[设备地址] [varchar](50) NULL,
	[设备协议] [varchar](50) NULL,
	[设备协议参数] [varchar](50) NULL,
	[是否轮询] [varchar](50) NULL,
	[轮询间隔] [varchar](50) NULL,
	[是否启用] [varchar](50) NOT NULL,
 CONSTRAINT [PK_通讯设备] 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
SET IDENTITY_INSERT [dbo].[通讯设备] ON
INSERT [dbo].[通讯设备] ([ID], [名称], [设备地址], [设备协议], [设备协议参数], [是否轮询], [轮询间隔], [是否启用]) VALUES (5, N'测点1_控制器', N'101', N'CD_PSController', N'1', N'是', N'120', N'是')
INSERT [dbo].[通讯设备] ([ID], [名称], [设备地址], [设备协议], [设备协议参数], [是否轮询], [轮询间隔], [是否启用]) VALUES (6, N'测点2_控制器', N'101', N'CD_PSController', N'1', N'是', N'120', N'是')
INSERT [dbo].[通讯设备] ([ID], [名称], [设备地址], [设备协议], [设备协议参数], [是否轮询], [轮询间隔], [是否启用]) VALUES (7, N'测点3_控制器', N'101', N'CD_PSController', N'1', N'是', N'120', N'是')
INSERT [dbo].[通讯设备] ([ID], [名称], [设备地址], [设备协议], [设备协议参数], [是否轮询], [轮询间隔], [是否启用]) VALUES (8, N'测点4_控制器', N'101', N'CD_PSController', N'1', N'是', N'120', N'是')
SET IDENTITY_INSERT [dbo].[通讯设备] OFF
/****** Object:  Table [dbo].[通讯参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[通讯参数](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[模板ID] [int] NULL,
	[量名称] [varchar](50) NULL,
	[量种类] [varchar](50) NULL,
	[量类型] [varchar](50) NULL,
	[子站索引] [varchar](50) NULL,
	[数据起始索引] [int] NULL,
	[转换方式] [varchar](50) NULL,
	[转换方式参数] [varchar](200) NULL,
	[开关量预设值] [varchar](50) NULL,
	[开关量描述] [varchar](50) NULL,
	[开关量颜色] [varchar](50) NULL,
	[是否报警] [varchar](50) NULL,
	[报警条件] [varchar](50) NULL,
	[衍生表达式] [varchar](2000) NULL,
	[模拟量小数位数] [int] NULL,
	[模拟量系数] [decimal](10, 4) NULL,
	[模拟量单位] [varchar](50) NULL,
	[是否显示] [varchar](50) NULL,
	[变化方式] [varchar](50) NULL,
	[顺序号] [int] NULL,
	[所在控件名] [varchar](50) NULL,
 CONSTRAINT [PK_通讯参数] PRIMARY KEY NONCLUSTERED 
(
	[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
SET IDENTITY_INSERT [dbo].[通讯参数] ON
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (1, 1, N'预留水位', N'基础量', N'模拟量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, CAST(0.0100 AS Decimal(10, 4)), N'm', N'是', N'波动量', NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (2, 1, N'实测水位', N'基础量', N'模拟量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, CAST(0.0100 AS Decimal(10, 4)), N'm', N'是', N'波动量', NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (3, 1, N'基准水位', N'基础量', N'模拟量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, CAST(0.0100 AS Decimal(10, 4)), N'm', N'是', N'波动量', NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (4, 1, N'信号强度', N'基础量', N'模拟量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(1.0000 AS Decimal(10, 4)), NULL, N'是', N'波动量', NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (5, 1, N'电池电压', N'基础量', N'模拟量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, CAST(0.0100 AS Decimal(10, 4)), N'V', N'是', N'波动量', NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (6, 1, N'模拟量水位故障', N'基础量', N'开关量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(1.0000 AS Decimal(10, 4)), NULL, N'是', NULL, NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (7, 1, N'箱门开关', N'基础量', N'开关量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(1.0000 AS Decimal(10, 4)), NULL, N'是', NULL, NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (8, 1, N'水位计故障', N'基础量', N'开关量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(1.0000 AS Decimal(10, 4)), NULL, N'是', NULL, NULL, NULL)
INSERT [dbo].[通讯参数] ([Id], [模板ID], [量名称], [量种类], [量类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [开关量预设值], [开关量描述], [开关量颜色], [是否报警], [报警条件], [衍生表达式], [模拟量小数位数], [模拟量系数], [模拟量单位], [是否显示], [变化方式], [顺序号], [所在控件名]) VALUES (9, 1, N'电池电压下限报警', N'基础量', N'开关量', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(1.0000 AS Decimal(10, 4)), NULL, N'是', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[通讯参数] OFF
/****** Object:  Table [dbo].[水资源费]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[水资源费](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL,
	[一阶价格] [numeric](18, 2) NOT NULL,
	[一阶水量] [numeric](18, 2) NOT NULL,
	[二阶价格] [numeric](18, 2) NOT NULL,
	[二阶水量] [numeric](18, 2) NOT NULL,
	[三阶价格] [numeric](18, 2) NOT NULL,
	[三阶水量] [numeric](18, 2) NOT NULL,
	[生效日期] [datetime] NOT NULL,
	[失效日期] [datetime] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[水资源_远程监控]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水资源_远程监控](
	[序号] [int] IDENTITY(1,1) NOT NULL,
	[取水单位名称] [varchar](50) NOT NULL,
	[SIM卡号码] [varchar](50) NULL,
	[最新采用时间] [varchar](50) NULL,
	[表具读数] [decimal](18, 2) NULL,
	[取水系数] [decimal](18, 2) NULL,
	[取水流量] [decimal](18, 2) NULL,
	[本月用水量] [decimal](18, 2) NULL,
	[总用水量] [decimal](18, 2) NULL,
	[取水状态] [varchar](50) NULL,
	[供电状态] [varchar](50) NULL,
	[门状态] [varchar](50) NULL,
	[图像监控] [varchar](50) NULL,
 CONSTRAINT [PK_远程监控] PRIMARY KEY CLUSTERED 
(
	[序号] 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].[水资源_用水计划]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水资源_用水计划](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[Tag] [varchar](50) NULL,
	[Year] [varchar](50) NULL,
	[Type] [varchar](50) NULL,
	[Plan] [varchar](500) NULL,
	[Start] [varchar](50) NULL,
	[DeviceName] [varchar](50) NULL,
	[Monitor] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[水资源_取水单位基本信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水资源_取水单位基本信息](
	[序号] [int] IDENTITY(1,1) NOT NULL,
	[取水单位名称] [varchar](50) NOT NULL,
	[单位地址] [varchar](50) NULL,
	[管理人员] [varchar](50) NULL,
	[联系电话] [varchar](50) NULL,
	[取水许可证号] [varchar](50) NULL,
	[申请年取水量] [int] NULL,
	[取水口地理位置] [varchar](50) NULL,
	[取水口编码] [varchar](50) NULL,
	[SIM卡号码] [varchar](50) NULL,
	[计量设备] [varchar](50) NULL,
	[取水系数] [decimal](18, 2) NULL,
	[费率] [decimal](18, 2) NULL,
	[采集方式] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[水源类型]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水源类型](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
 CONSTRAINT [PK_水源类型] 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].[水权回购价格]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水权回购价格](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[价格] [numeric](18, 2) NULL,
	[开始实施日期] [datetime] NULL,
	[设置时间] [datetime] NULL,
	[取水用途ID] [int] NOT NULL,
 CONSTRAINT [PK_水权回购价格] 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
SET IDENTITY_INSERT [dbo].[水权回购价格] ON
INSERT [dbo].[水权回购价格] ([ID], [名称], [价格], [开始实施日期], [设置时间], [取水用途ID]) VALUES (1, N'AAA', CAST(1.00 AS Numeric(18, 2)), CAST(0x0000A7C900000000 AS DateTime), CAST(0x0000A7CB00000000 AS DateTime), 1)
SET IDENTITY_INSERT [dbo].[水权回购价格] OFF
/****** Object:  Table [dbo].[水价表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[水价表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[类型] [int] NOT NULL,
	[设置时间] [datetime] NULL,
 CONSTRAINT [PK_水价表] 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].[数据通道]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[数据通道](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[通道类型] [varchar](50) NULL,
	[通道参数] [varchar](50) NULL,
	[是否需要服务支持] [varchar](50) NULL,
	[通道服务类型] [varchar](50) NULL,
	[通道服务参数] [varchar](50) NULL,
 CONSTRAINT [PK_数据通道] 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
SET IDENTITY_INSERT [dbo].[数据通道] ON
INSERT [dbo].[数据通道] ([ID], [通道类型], [通道参数], [是否需要服务支持], [通道服务类型], [通道服务参数]) VALUES (138, N'DC_TCP_FromServer', N'', N'是', N'DS_TCP_Server', N'60001')
SET IDENTITY_INSERT [dbo].[数据通道] OFF
/****** Object:  Table [dbo].[数据来源]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[数据来源](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[数据来源] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[数据来源] ON
INSERT [dbo].[数据来源] ([ID], [数据来源]) VALUES (1, N'定期存储')
INSERT [dbo].[数据来源] ([ID], [数据来源]) VALUES (2, N'历史记录')
SET IDENTITY_INSERT [dbo].[数据来源] OFF
/****** Object:  Table [dbo].[数据卡资费]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[数据卡资费](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[资费] [numeric](18, 2) NULL,
	[周期] [numeric](18, 0) NULL,
	[描述] [varchar](50) NULL,
 CONSTRAINT [PK_数据卡资费] 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].[数据卡信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[数据卡信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SIM卡号] [varchar](50) NULL,
	[手机卡号] [varchar](50) NOT NULL,
	[资费标准] [int] NOT NULL,
	[充值时间] [datetime] NULL,
	[充值金额] [numeric](18, 2) NULL,
	[充值人] [varchar](50) NULL,
	[累计充值金额] [numeric](18, 2) NULL,
	[当前余额] [numeric](18, 2) NULL,
	[管理ID] [varchar](50) NULL,
	[设备ID] [varchar](50) NULL,
	[是否删除] [varchar](50) NULL,
	[扣费时间] [datetime] NULL,
 CONSTRAINT [PK_数据卡信息] 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].[数据卡充值记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[数据卡充值记录](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[数据卡ID] [int] NULL,
	[充值时间] [datetime] NULL,
	[充值金额] [numeric](18, 2) NULL,
	[充值人] [varchar](50) NULL,
	[操作员ID] [int] NULL,
 CONSTRAINT [PK_数据卡充值记录] 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].[售水年结算记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[售水年结算记录](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用水户ID] [int] NOT NULL,
	[计量方式ID] [int] NOT NULL,
	[结算年份] [int] NOT NULL,
	[年分配水权] [numeric](18, 2) NOT NULL,
	[年用水量] [numeric](18, 2) NOT NULL,
	[年剩余水权] [numeric](18, 2) NULL,
	[水权回购单价] [numeric](18, 2) NULL,
	[年剩余水权总价] [numeric](18, 2) NULL,
	[年购水金额] [numeric](18, 2) NULL,
	[年用水金额] [numeric](18, 2) NULL,
	[卡内余额] [numeric](18, 2) NOT NULL,
	[年总结余] [numeric](18, 2) NULL,
	[售水金额] [numeric](18, 2) NULL,
	[退款金额] [numeric](18, 2) NULL,
	[操作员ID] [int] NOT NULL,
	[操作时间] [datetime] NOT NULL,
	[结算人] [varchar](50) NOT NULL,
	[备注] [varchar](50) NULL,
	[计费详细] [varchar](500) NULL,
	[售水记录ID] [int] NULL,
 CONSTRAINT [PK_售水年结算记录] 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].[售水记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[售水记录](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[用水户ID] [int] NOT NULL,
	[购水设备ID] [int] NOT NULL,
	[水资源费ID] [int] NOT NULL,
	[计费方式ID] [int] NOT NULL,
	[计量方式ID] [int] NOT NULL,
	[售水方式ID] [int] NOT NULL,
	[售水金额] [numeric](18, 2) NOT NULL,
	[售出水量] [numeric](18, 1) NOT NULL,
	[售电金额] [numeric](18, 2) NOT NULL,
	[售出电量] [numeric](18, 1) NOT NULL,
	[应收金额] [numeric](18, 2) NULL,
	[实收金额] [numeric](18, 2) NULL,
	[售水时间] [datetime] NOT NULL,
	[操作员ID] [int] NOT NULL,
	[购水人] [varchar](50) NOT NULL,
	[备注] [varchar](50) NULL,
	[详细信息] [varchar](500) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[售水方式]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[售水方式](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[视频]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[视频](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[管理ID] [int] NULL,
	[名称] [varchar](50) NULL,
	[IP地址] [varchar](500) NULL,
	[端口号] [int] NULL,
	[视频通道] [int] NULL,
	[用户名] [varchar](50) NULL,
	[密码] [varchar](50) NULL,
	[音频通道] [int] NULL,
	[是否定焦] [varchar](50) NULL,
	[启用音频] [varchar](50) NULL,
	[设备序列号] [varchar](50) NULL,
	[视频厂家] [varchar](50) NULL,
	[码流类型] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[事件记录模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[事件记录模板](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[事件类型] [varchar](50) NOT NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
 CONSTRAINT [PK_事件记录模板] 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].[事件记录参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[事件记录参数](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[模板ID] [int] NULL,
	[事件类型] [varchar](50) NOT NULL,
	[量名称] [varchar](50) NULL,
	[量种类] [varchar](50) NULL,
	[量类型] [varchar](50) NULL,
	[子站索引] [varchar](50) NULL,
	[数据起始索引] [int] NULL,
	[转换方式] [varchar](50) NULL,
	[转换方式参数] [varchar](200) NULL,
	[开关量预设值] [varchar](50) NULL,
	[开关量描述] [varchar](50) NULL,
	[开关量颜色] [varchar](50) NULL,
	[是否报警] [varchar](50) NULL,
	[报警条件] [varchar](50) NULL,
	[衍生表达式] [varchar](2000) NULL,
	[模拟量小数位数] [int] NULL,
	[模拟量系数] [decimal](18, 2) NULL,
	[模拟量单位] [varchar](50) NULL,
	[是否显示] [varchar](50) NULL,
	[变化方式] [varchar](50) NULL,
	[顺序号] [int] NULL,
	[所在控件名] [varchar](50) NULL,
 CONSTRAINT [PK_事件记录参数] 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].[时段水价表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[时段水价表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[水价ID] [int] NOT NULL,
	[阶梯数量] [int] NOT NULL,
	[阶梯类型] [varchar](50) NOT NULL,
	[起始时间] [varchar](50) NULL,
	[结束时间] [varchar](50) NULL,
	[一阶水量] [decimal](18, 2) NULL,
	[一阶价格] [decimal](18, 3) NULL,
	[二阶水量] [decimal](18, 2) NULL,
	[二阶价格] [decimal](18, 3) NULL,
	[三阶水量] [decimal](18, 2) NULL,
	[三阶价格] [decimal](18, 3) NULL,
	[四阶水量] [decimal](18, 2) NULL,
	[四阶价格] [decimal](18, 3) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[设备信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[设备信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[用户站类型] [varchar](50) NULL,
	[用户站参数] [varchar](50) NULL,
	[管理ID] [varchar](50) NULL,
	[通讯设备ID] [varchar](50) NULL,
	[传输设备ID] [varchar](50) NULL,
	[数据采集方式] [int] NULL,
	[是否启用] [varchar](50) NOT NULL,
	[衍生相关量] [varchar](5000) NULL,
	[显示量] [varchar](500) NULL,
 CONSTRAINT [PK_设备信息] 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
SET IDENTITY_INSERT [dbo].[设备信息] ON
INSERT [dbo].[设备信息] ([ID], [名称], [用户站类型], [用户站参数], [管理ID], [通讯设备ID], [传输设备ID], [数据采集方式], [是否启用], [衍生相关量], [显示量]) VALUES (4, N'测点1', N'US_Common', N'1', N'3', N'5', N'4', 0, N'是', N'', N'')
INSERT [dbo].[设备信息] ([ID], [名称], [用户站类型], [用户站参数], [管理ID], [通讯设备ID], [传输设备ID], [数据采集方式], [是否启用], [衍生相关量], [显示量]) VALUES (5, N'测点2', N'US_Common', N'1', N'3', N'6', N'5', 0, N'是', N'', N'')
INSERT [dbo].[设备信息] ([ID], [名称], [用户站类型], [用户站参数], [管理ID], [通讯设备ID], [传输设备ID], [数据采集方式], [是否启用], [衍生相关量], [显示量]) VALUES (6, N'测点3', N'US_Common', N'1', N'3', N'7', N'6', 0, N'是', N'', N'')
INSERT [dbo].[设备信息] ([ID], [名称], [用户站类型], [用户站参数], [管理ID], [通讯设备ID], [传输设备ID], [数据采集方式], [是否启用], [衍生相关量], [显示量]) VALUES (7, N'测点4', N'US_Common', N'1', N'3', N'8', N'7', 0, N'是', N'', N'')
SET IDENTITY_INSERT [dbo].[设备信息] OFF
/****** Object:  Table [dbo].[设备图片]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[设备图片](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[图片索引] [varchar](50) NOT NULL,
	[图片] [image] NOT NULL,
	[备注] [varchar](500) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[设备辅助信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[设备辅助信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[值] [varchar](500) NULL,
 CONSTRAINT [PK_设备辅助信息] 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].[设备参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[设备参数](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL,
	[用户站类型] [varchar](50) NULL,
	[子站索引] [varchar](50) NULL,
	[数据起始索引] [varchar](50) NULL,
	[转换方式] [varchar](50) NULL,
	[转换方式参数] [varchar](200) NULL,
	[系数] [decimal](18, 3) NULL,
	[最小值] [decimal](18, 0) NULL,
	[最大值] [decimal](18, 0) NULL,
	[单位] [varchar](50) NULL,
	[是否显示] [varchar](50) NULL,
 CONSTRAINT [PK_设备参数] 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
SET IDENTITY_INSERT [dbo].[设备参数] ON
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (1, N'海拔高度', N'1', NULL, NULL, N'int', N'4', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (2, N'电池电压下限', N'1', NULL, NULL, N'ushort', N'2', CAST(0.100 AS Decimal(18, 3)), NULL, NULL, N'V', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (3, N'DI采集间隔', N'1', NULL, NULL, N'ushort', N'2', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N'ms', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (4, N'清空历史记录', N'1', NULL, NULL, N'ushort', N'2', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, NULL, N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (5, N'模拟量水位量程', N'1', NULL, NULL, N'ushort', N'2', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (6, N'模拟量水位最小值', N'1', NULL, NULL, N'ushort', N'2', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (7, N'模拟量水位上限报警', N'1', NULL, NULL, N'ushort', N'2', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (8, N'模拟量水位下限报警', N'1', NULL, NULL, N'ushort', N'2', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (9, N'模拟量水位零点', N'1', NULL, NULL, N'ushort', N'2', CAST(0.001 AS Decimal(18, 3)), NULL, NULL, N'mA', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (10, N'模拟量水位满度', N'1', NULL, NULL, N'ushort', N'2', CAST(0.001 AS Decimal(18, 3)), NULL, NULL, N'mA', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (11, N'模拟量水位偏移量', N'1', NULL, NULL, N'ushort', N'2', CAST(0.010 AS Decimal(18, 3)), NULL, NULL, N'm', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (12, N'模拟量采集间隔', N'1', NULL, NULL, N'uint', N'4', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N's', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (13, N'存储间隔间隔', N'1', NULL, NULL, N'uint', N'4', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N's', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (14, N'历史记录上报间隔', N'1', NULL, NULL, N'uint', N'4', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N's', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (15, N'实时数上报间隔', N'1', NULL, NULL, N'uint', N'4', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N's', N'是')
INSERT [dbo].[设备参数] ([ID], [名称], [用户站类型], [子站索引], [数据起始索引], [转换方式], [转换方式参数], [系数], [最小值], [最大值], [单位], [是否显示]) VALUES (16, N'水位计采集间隔', N'1', NULL, NULL, N'uint', N'4', CAST(1.000 AS Decimal(18, 3)), NULL, NULL, N's', N'是')
SET IDENTITY_INSERT [dbo].[设备参数] OFF
/****** Object:  Table [dbo].[权限列表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[权限列表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[权限名称] [varchar](50) NOT NULL,
	[权限说明] [varchar](2000) NULL,
 CONSTRAINT [PK_权限列表] 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
SET IDENTITY_INSERT [dbo].[权限列表] ON
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (3, N'操作员编辑', N'是否允许编辑登录名、角色名称及所属单位')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (6, N'修改密码', N'是否允许操作员修改自己的密码')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (9, N'角色高级', N'是否允许用户修改角色和权限的高级设置')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (12, N'地图编辑', N'是否允许编辑测点在地图上的位置')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (13, N'用户编辑', N'修改登录名称、修改角色以及所属单位')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (14, N'单位编辑', N'添加、删除测点以及管理辅助信息')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (15, N'控制权限', N'是否允许控制现场设备')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (16, N'参数权限', N'是否允许设置、读取现场设备的参数')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (17, N'界面设置', N'是否允许用户改变界面显示风格')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (18, N'视频管理', N'是否允许用户查看和操作视频')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (19, N'测点编辑', N'是否允许用户编辑测点')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (20, N'拍照权限', N'是否允许用户拍照')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (22, N'退出系统', N'是否允许用户退出系统')
INSERT [dbo].[权限列表] ([ID], [权限名称], [权限说明]) VALUES (23, N'个人设置', NULL)
SET IDENTITY_INSERT [dbo].[权限列表] OFF
/****** Object:  Table [dbo].[全局状态]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[全局状态](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[数据来源] [varchar](10) NOT NULL,
	[预留水位] [numeric](18, 2) NULL,
	[实测水位] [numeric](18, 2) NULL,
	[基准水位] [numeric](18, 2) NULL,
	[信号强度] [numeric](18, 0) NULL,
	[电池电压] [numeric](18, 2) NULL,
	[模拟量水位故障] [varchar](50) NULL,
	[箱门开关] [varchar](50) NULL,
	[水位计故障] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[全局状态] ON
INSERT [dbo].[全局状态] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (1, 4, CAST(0x0000AD2E013EC12C AS DateTime), CAST(0x0000AD2E008F109C AS DateTime), N'全部中断', N'全部中断', N'实时数据', CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0 AS Numeric(18, 0)), CAST(0.00 AS Numeric(18, 2)), N'0', N'0', N'0', N'0')
INSERT [dbo].[全局状态] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (2, 5, CAST(0x0000AD2E013EC12C AS DateTime), CAST(0x0000AD2E008F109C AS DateTime), N'全部中断', N'全部中断', N'实时数据', CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0 AS Numeric(18, 0)), CAST(0.00 AS Numeric(18, 2)), N'0', N'0', N'0', N'0')
INSERT [dbo].[全局状态] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (3, 6, CAST(0x0000AD2E013EC12C AS DateTime), CAST(0x0000AD2E008F109C AS DateTime), N'全部中断', N'全部中断', N'实时数据', CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0 AS Numeric(18, 0)), CAST(0.00 AS Numeric(18, 2)), N'0', N'0', N'0', N'0')
INSERT [dbo].[全局状态] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (4, 7, CAST(0x0000AD2E013EC12C AS DateTime), CAST(0x0000AD2E008F109C AS DateTime), N'全部中断', N'全部中断', N'实时数据', CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0 AS Numeric(18, 0)), CAST(0.00 AS Numeric(18, 2)), N'0', N'0', N'0', N'0')
SET IDENTITY_INSERT [dbo].[全局状态] OFF
/****** Object:  Table [dbo].[配置信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[配置信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[标识子列] [varchar](50) NULL,
	[数据标识] [varchar](50) NULL,
	[显示名称] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[配置信息] ON
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (1, N'用户站类型', N'US_Common', N'水源井监控')
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (2, N'传输协议', N'无协议', N'ADSL协议')
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (3, N'用户站参数', N'1', N'水源井监控')
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (5, N'设备协议', N'CD_PSController', N'控制器')
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (6, N'设备协议参数', N'1', N'水源井监控')
INSERT [dbo].[配置信息] ([ID], [标识子列], [数据标识], [显示名称]) VALUES (7, N'传输协议', N'平升协议', N'GPRS协议')
SET IDENTITY_INSERT [dbo].[配置信息] OFF
/****** Object:  Table [dbo].[模板信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[模板信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[协议类型] [varchar](50) NULL,
	[协议名称] [varchar](50) NULL,
	[模板名称] [varchar](50) NULL,
	[用户站参数] [varchar](10) NULL,
	[子设备] [varchar](50) NULL,
	[可支持的模板ID] [varchar](50) NULL,
	[地址说明] [varchar](50) NULL,
	[远程操作窗体] [varchar](50) NULL,
	[辅助信息描述] [varchar](500) NULL,
 CONSTRAINT [PK_模板信息] 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
SET IDENTITY_INSERT [dbo].[模板信息] ON
INSERT [dbo].[模板信息] ([ID], [协议类型], [协议名称], [模板名称], [用户站参数], [子设备], [可支持的模板ID], [地址说明], [远程操作窗体], [辅助信息描述]) VALUES (12, N'传输设备', N'平升协议', N'平升协议', NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[模板信息] ([ID], [协议类型], [协议名称], [模板名称], [用户站参数], [子设备], [可支持的模板ID], [地址说明], [远程操作窗体], [辅助信息描述]) VALUES (37, N'用户站', N'US_Common', N'控制器', N'1', N'控制器', N'', NULL, NULL, NULL)
INSERT [dbo].[模板信息] ([ID], [协议类型], [协议名称], [模板名称], [用户站参数], [子设备], [可支持的模板ID], [地址说明], [远程操作窗体], [辅助信息描述]) VALUES (53, N'通讯设备', N'CD_PSController', N'控制器', N'1', NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[模板信息] OFF
/****** Object:  Table [dbo].[联系人]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[联系人](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[卡号] [varchar](50) NULL,
	[姓名] [varchar](50) NULL,
	[年龄] [varchar](50) NULL,
	[地址] [varchar](50) NULL,
	[组] [varchar](50) NULL,
	[备注] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[联系人] ON
INSERT [dbo].[联系人] ([ID], [卡号], [姓名], [年龄], [地址], [组], [备注]) VALUES (1, N'15690458845', N'xiaotiantain', N'23', N'', N'xiao', N'')
SET IDENTITY_INSERT [dbo].[联系人] OFF
/****** Object:  Table [dbo].[历史记录模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[历史记录模板](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[数据来源] [varchar](10) NOT NULL,
	[预留水位] [numeric](18, 2) NULL,
	[实测水位] [numeric](18, 2) NULL,
	[基准水位] [numeric](18, 2) NULL,
	[信号强度] [numeric](18, 0) NULL,
	[电池电压] [numeric](18, 2) NULL,
	[模拟量水位故障] [varchar](50) NULL,
	[箱门开关] [varchar](50) NULL,
	[水位计故障] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL,
 CONSTRAINT [PK_历史记录模板] 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].[历史记录_000004_2021]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[历史记录_000004_2021](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[数据来源] [varchar](10) NOT NULL,
	[预留水位] [numeric](18, 2) NULL,
	[实测水位] [numeric](18, 2) NULL,
	[基准水位] [numeric](18, 2) NULL,
	[信号强度] [numeric](18, 0) NULL,
	[电池电压] [numeric](18, 2) NULL,
	[模拟量水位故障] [varchar](50) NULL,
	[箱门开关] [varchar](50) NULL,
	[水位计故障] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [采集时间] ON [dbo].[历史记录_000004_2021] 
(
	[采集时间] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[历史记录_000004_2021] ON
INSERT [dbo].[历史记录_000004_2021] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (1, 4, CAST(0x0000AD17009BA168 AS DateTime), CAST(0x0000AD1700A4CB80 AS DateTime), N'全部正常', N'全部正常', N'历史记录', CAST(6.55 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(11 AS Numeric(18, 0)), CAST(11.27 AS Numeric(18, 2)), N'报警', N'正常', N'报警', N'报警')
INSERT [dbo].[历史记录_000004_2021] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (2, 4, CAST(0x0000AD17009BA168 AS DateTime), CAST(0x0000AD17009B2E90 AS DateTime), N'全部正常', N'全部正常', N'历史记录', CAST(6.55 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(17 AS Numeric(18, 0)), CAST(11.27 AS Numeric(18, 2)), N'报警', N'正常', N'报警', N'报警')
SET IDENTITY_INSERT [dbo].[历史记录_000004_2021] OFF
/****** Object:  Table [dbo].[控制参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[控制参数](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NULL,
	[用户站类型] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[角色信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[角色信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[角色名称] [varchar](50) NOT NULL,
	[角色描述] [varchar](500) NULL,
	[创建时间] [datetime] NULL,
 CONSTRAINT [PK_角色信息] 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
SET IDENTITY_INSERT [dbo].[角色信息] ON
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (1, N'开发人员', NULL, NULL)
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (2, N'总管理员', N'总管理员', NULL)
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (3, N'分管理员1', N'', NULL)
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (4, N'浏览用户', N'', NULL)
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (15, N'test1', N'非', CAST(0x0000AA56008B05D8 AS DateTime))
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (19, N'测试', N'', CAST(0x0000AA7300A84878 AS DateTime))
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (20, N'测试2', N'123', CAST(0x0000AA7600E26440 AS DateTime))
INSERT [dbo].[角色信息] ([ID], [角色名称], [角色描述], [创建时间]) VALUES (21, N'test2', N'新建测试角色', CAST(0x0000AA77009A99BC AS DateTime))
SET IDENTITY_INSERT [dbo].[角色信息] OFF
/****** Object:  Table [dbo].[角色权限关系]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[角色权限关系](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[角色ID] [int] NOT NULL,
	[权限ID] [int] NOT NULL,
	[权限值] [varchar](50) NOT NULL,
 CONSTRAINT [PK_角色权限关系] 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
SET IDENTITY_INSERT [dbo].[角色权限关系] ON
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (27, 1, 3, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (30, 1, 6, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (33, 1, 9, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (36, 2, 3, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (39, 2, 6, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (42, 2, 9, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (45, 3, 3, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (48, 3, 6, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (51, 3, 9, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (54, 4, 3, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (57, 4, 6, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (60, 4, 9, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (70, 1, 12, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (71, 1, 13, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (72, 1, 14, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (73, 1, 15, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (74, 1, 16, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (75, 1, 17, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (76, 1, 18, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (77, 1, 19, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (78, 1, 20, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (79, 2, 12, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (80, 2, 13, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (81, 2, 14, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (82, 2, 15, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (83, 2, 16, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (84, 2, 17, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (85, 2, 18, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (86, 2, 19, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (87, 2, 20, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (89, 2, 22, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (90, 1, 22, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (91, 3, 12, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (92, 3, 13, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (93, 3, 14, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (94, 3, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (95, 3, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (96, 3, 17, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (97, 3, 18, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (98, 3, 19, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (99, 3, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (100, 3, 22, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (101, 4, 12, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (102, 4, 13, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (103, 4, 14, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (104, 4, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (105, 4, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (106, 4, 17, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (107, 4, 18, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (108, 4, 19, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (109, 4, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (110, 4, 22, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (111, 1, 23, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (114, 2, 23, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (121, 3, 23, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (122, 4, 23, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (133, 15, 9, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (134, 15, 13, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (135, 15, 14, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (136, 15, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (137, 15, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (138, 15, 18, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (139, 15, 19, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (140, 15, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (141, 15, 23, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (151, 19, 9, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (152, 19, 13, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (153, 19, 14, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (154, 19, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (155, 19, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (156, 19, 18, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (157, 19, 19, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (158, 19, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (159, 19, 23, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (160, 20, 9, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (161, 20, 13, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (162, 20, 14, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (163, 20, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (164, 20, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (165, 20, 18, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (166, 20, 19, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (167, 20, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (168, 20, 23, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (169, 21, 9, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (170, 21, 13, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (171, 21, 14, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (172, 21, 15, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (173, 21, 16, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (174, 21, 18, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (175, 21, 19, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (176, 21, 20, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (177, 21, 23, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (178, 21, 6, N'0')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (215, 19, 6, N'1')
INSERT [dbo].[角色权限关系] ([ID], [角色ID], [权限ID], [权限值]) VALUES (226, 20, 6, N'1')
SET IDENTITY_INSERT [dbo].[角色权限关系] OFF
/****** Object:  Table [dbo].[角色菜单关系表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[角色菜单关系表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[角色ID] [int] NOT NULL,
	[菜单ID] [int] NOT NULL,
 CONSTRAINT [PK_角色菜单关系表] 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 IDENTITY_INSERT [dbo].[角色菜单关系表] ON
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (760, 1, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (761, 1, 59)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (762, 1, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (763, 1, 60)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (764, 1, 8)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (765, 1, 3)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (766, 1, 9)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (767, 1, 32)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (768, 1, 10)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (769, 1, 11)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (770, 1, 12)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (771, 1, 19)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (772, 1, 45)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (773, 1, 49)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (774, 1, 51)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (775, 1, 47)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (776, 1, 52)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (777, 1, 53)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (778, 1, 4)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (779, 1, 57)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (780, 1, 35)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (781, 1, 37)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (782, 1, 58)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (783, 1, 43)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (784, 1, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (785, 1, 56)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (786, 1, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (787, 1, 23)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (788, 1, 36)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (789, 1, 34)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (790, 1, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1073, 15, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1074, 15, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1075, 15, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1076, 15, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1077, 15, 56)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1078, 15, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1804, 4, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1857, 19, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1858, 19, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1859, 19, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1862, 21, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1863, 21, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1864, 21, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1865, 21, 8)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1866, 21, 45)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1867, 21, 49)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1868, 21, 19)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1869, 21, 47)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1870, 21, 52)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1871, 21, 53)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1872, 21, 3)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1873, 21, 9)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1874, 21, 10)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1875, 21, 11)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1876, 21, 12)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1877, 21, 4)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1878, 21, 57)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1879, 21, 35)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1880, 21, 37)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1881, 21, 43)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1882, 21, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1883, 21, 56)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1884, 21, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1885, 21, 23)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1886, 21, 36)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1887, 21, 34)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1892, 1, 67)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1981, 20, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1982, 20, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1983, 20, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1984, 20, 8)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1985, 3, 64)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1986, 3, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1987, 3, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1988, 3, 8)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1989, 3, 47)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1990, 3, 52)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1991, 3, 53)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1992, 3, 3)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1993, 3, 9)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1994, 3, 10)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1995, 3, 11)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1996, 3, 45)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1997, 3, 49)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1998, 3, 19)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (1999, 3, 4)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2000, 3, 57)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2001, 3, 35)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2002, 3, 37)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2003, 3, 43)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2004, 3, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2005, 3, 56)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2006, 3, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2007, 3, 23)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2008, 3, 36)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2009, 3, 34)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2010, 3, 76)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2280, 1, 78)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2382, 2, 64)
GO
print 'Processed 100 total records'
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2383, 2, 1)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2384, 2, 71)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2385, 2, 7)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2386, 2, 3)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2387, 2, 9)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2388, 2, 10)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2389, 2, 11)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2390, 2, 12)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2391, 2, 4)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2392, 2, 57)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2393, 2, 35)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2394, 2, 37)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2395, 2, 43)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2396, 2, 6)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2397, 2, 56)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2398, 2, 15)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2399, 2, 23)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2400, 2, 36)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2401, 2, 34)
INSERT [dbo].[角色菜单关系表] ([ID], [角色ID], [菜单ID]) VALUES (2402, 2, 68)
SET IDENTITY_INSERT [dbo].[角色菜单关系表] OFF
/****** Object:  Table [dbo].[价格类型]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[价格类型](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
 CONSTRAINT [PK_价格种类] 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].[计量方式]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[计量方式](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[计费方式]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[计费方式](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[级别信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[级别信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[级别名称] [varchar](50) NOT NULL,
	[级别描述] [varchar](200) NULL,
	[显示别名] [varchar](50) NULL,
 CONSTRAINT [PK_级别信息] 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
SET IDENTITY_INSERT [dbo].[级别信息] ON
INSERT [dbo].[级别信息] ([ID], [级别名称], [级别描述], [显示别名]) VALUES (1, N'系统', NULL, N'系统')
INSERT [dbo].[级别信息] ([ID], [级别名称], [级别描述], [显示别名]) VALUES (5, N'城市', NULL, N'城市')
INSERT [dbo].[级别信息] ([ID], [级别名称], [级别描述], [显示别名]) VALUES (6, N'区县', NULL, N'区域')
INSERT [dbo].[级别信息] ([ID], [级别名称], [级别描述], [显示别名]) VALUES (8, N'设备', NULL, N'测站')
SET IDENTITY_INSERT [dbo].[级别信息] OFF
/****** Object:  Table [dbo].[换表类型]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[换表类型](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[换表类型] [varchar](50) NULL,
 CONSTRAINT [PK_换表类型] PRIMARY KEY NONCLUSTERED 
(
	[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
SET IDENTITY_INSERT [dbo].[换表类型] ON
INSERT [dbo].[换表类型] ([ID], [换表类型]) VALUES (1, N'更换水表')
INSERT [dbo].[换表类型] ([ID], [换表类型]) VALUES (2, N'水表满度')
SET IDENTITY_INSERT [dbo].[换表类型] OFF
/****** Object:  Table [dbo].[换表记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[换表记录](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[记录时间] [datetime] NOT NULL,
	[旧表停用时间] [datetime] NOT NULL,
	[旧表指数] [numeric](18, 2) NOT NULL,
	[补偿值] [numeric](18, 2) NOT NULL,
	[新表启用时间] [datetime] NOT NULL,
	[新表指数] [numeric](18, 2) NOT NULL,
	[换表类型ID] [int] NOT NULL,
	[换表原因] [varchar](200) NULL,
	[换表人员] [varchar](50) NULL,
	[更新记录] [varchar](50) NULL,
	[更新方式] [varchar](50) NULL,
	[操作员ID] [int] NOT NULL,
	[有效性] [varchar](50) NULL,
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].[管理信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[管理信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[级别ID] [int] NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[上级ID] [int] NOT NULL,
	[级别描述] [nvarchar](1000) NULL,
 CONSTRAINT [PK_管理信息] 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
SET IDENTITY_INSERT [dbo].[管理信息] ON
INSERT [dbo].[管理信息] ([ID], [级别ID], [名称], [上级ID], [级别描述]) VALUES (1, 1, N'远程监测管理平台', 0, NULL)
INSERT [dbo].[管理信息] ([ID], [级别ID], [名称], [上级ID], [级别描述]) VALUES (2, 5, N'xx市', 1, NULL)
INSERT [dbo].[管理信息] ([ID], [级别ID], [名称], [上级ID], [级别描述]) VALUES (3, 6, N'xx区', 2, NULL)
SET IDENTITY_INSERT [dbo].[管理信息] OFF
/****** Object:  Table [dbo].[管理辅助信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[管理辅助信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[管理ID] [int] NOT NULL,
	[名称] [varchar](50) NULL,
	[值] [varchar](50) NULL,
 CONSTRAINT [PK_级别辅助信息] 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].[购水设备]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[购水设备](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL,
	[设备ID] [int] NOT NULL,
	[水资源费ID] [int] NOT NULL,
	[计费方式ID] [int] NOT NULL,
	[计量方式ID] [int] NOT NULL,
	[售水方式ID] [int] NOT NULL,
	[设备主板号] [nvarchar](50) NOT NULL,
	[水表倍率] [int] NOT NULL,
	[报警下限] [numeric](18, 2) NOT NULL,
	[初始计费值] [numeric](18, 2) NOT NULL,
	[累计购水量] [numeric](18, 2) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[工程信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[工程信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[工程信息] [varchar](50) NOT NULL,
 CONSTRAINT [PK_工程信息] 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
SET IDENTITY_INSERT [dbo].[工程信息] ON
INSERT [dbo].[工程信息] ([ID], [工程信息]) VALUES (1, N'分组1')
INSERT [dbo].[工程信息] ([ID], [工程信息]) VALUES (2, N'分组2')
INSERT [dbo].[工程信息] ([ID], [工程信息]) VALUES (3, N'分组3')
SET IDENTITY_INSERT [dbo].[工程信息] OFF
/****** Object:  Table [dbo].[个人显示规则]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[个人显示规则](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[模板ID] [int] NULL,
	[设置类型] [varchar](50) NULL,
	[操作员] [varchar](50) NULL,
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
SET IDENTITY_INSERT [dbo].[个人显示规则] ON
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (1, N'默认', 0, N'实时列表', N'default')
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (2, N'默认', 0, N'历史记录', N'default')
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (5, N'默认', 0, N'报表统计', N'default')
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (6, N'默认', 0, N'测点信息', N'default')
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (7, N'默认', 0, N'事件记录', N'default')
INSERT [dbo].[个人显示规则] ([id], [名称], [模板ID], [设置类型], [操作员]) VALUES (9, N'默认', 0, N'地图实时列表', N'default')
SET IDENTITY_INSERT [dbo].[个人显示规则] OFF
/****** Object:  Table [dbo].[个人显示参数]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[个人显示参数](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[规则ID] [varchar](50) NULL,
	[量名称] [varchar](50) NULL,
	[是否显示] [char](2) NULL,
	[顺序号] [int] NULL,
	[是否冻结] [varchar](50) NULL,
	[量类型] [varchar](50) NULL,
	[对齐方式] [varchar](50) NULL,
	[是否排序] [varchar](50) NULL,
	[组名] [varchar](50) NULL,
	[显示名称] [varchar](50) NULL,
	[列宽] [varchar](50) NULL,
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
SET IDENTITY_INSERT [dbo].[个人显示参数] ON
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (423, N'2', N'单位名称', N'是', 0, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (424, N'2', N'设备名称', N'是', 1, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (425, N'2', N'通讯状态', N'是', 2, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (426, N'2', N'设备状态', N'是', 3, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (427, N'2', N'记录时间', N'是', 4, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (428, N'2', N'采集时间', N'是', 5, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (429, N'2', N'数据来源', N'是', 6, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (430, N'2', N'信号强度', N'是', 7, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (431, N'2', N'电源电压', N'是', 8, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (432, N'2', N'水位1', N'是', 9, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (433, N'2', N'水位2', N'是', 10, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (434, N'2', N'压力', N'是', 11, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (435, N'2', N'水位1断线报警', N'否', 12, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (436, N'2', N'水位2断线报警', N'否', 13, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (437, N'2', N'门开关', N'是', 14, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (438, N'2', N'电源监测', N'是', 15, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (439, N'2', N'电源电压下限报警', N'否', 16, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (440, N'2', N'电源电压下下限报警', N'否', 17, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (441, N'2', N'压力断线报警', N'否', 18, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (442, N'2', N'水位1上限报警', N'否', 19, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (443, N'2', N'水位1下限报警', N'否', 20, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (444, N'2', N'水位2上限报警', N'否', 21, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (445, N'2', N'水位2下限报警', N'否', 22, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (446, N'2', N'压力上限报警', N'否', 23, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (447, N'2', N'压力下限报警', N'否', 24, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (448, N'2', N'水位计1状态', N'是', 25, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (449, N'2', N'水位计2状态', N'是', 26, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (450, N'2', N'压力计状态', N'是', 27, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (451, N'2', N'电源状态', N'是', 28, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (452, N'2', N'真实经度', N'否', 29, N'否', N'测点信息', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (453, N'2', N'真实纬度', N'否', 30, N'否', N'测点信息', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (454, N'2', N'安装时间', N'否', 31, N'否', N'测点信息', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (455, N'2', N'安装位置', N'否', 32, N'否', N'测点信息', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (456, N'2', N'手机卡号', N'是', 33, N'否', N'测点信息', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (457, N'1', N'单位名称', N'否', 0, N'否', N'通讯参数', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (458, N'1', N'设备名称', N'是', 1, N'否', N'通讯参数', N'center', N'否', N'', N'测点名称', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (459, N'1', N'通讯状态', N'是', 2, N'否', N'通讯参数', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (460, N'1', N'设备状态', N'是', 3, N'否', N'通讯参数', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (461, N'1', N'更新时间', N'是', 4, N'否', N'通讯参数', N'center', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (462, N'1', N'消毒装置空高', N'是', 5, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (463, N'1', N'消毒装置水位', N'是', 6, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (464, N'1', N'清水池空高', N'否', 7, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (465, N'1', N'清水池水位', N'是', 8, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (466, N'1', N'电源电压', N'是', 9, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (467, N'1', N'吸水池空高', N'是', 10, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (468, N'1', N'吸水池水位', N'是', 11, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (469, N'1', N'平升水位计水位', N'是', 12, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (470, N'1', N'一号压力', N'是', 13, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (471, N'1', N'二号压力', N'是', 14, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (472, N'1', N'浊度', N'是', 15, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (473, N'1', N'余氯', N'是', 16, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (474, N'1', N'表1瞬时流量', N'是', 17, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (475, N'1', N'表1正累计', N'是', 18, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (476, N'1', N'表1负累计', N'是', 19, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (477, N'1', N'表1净累计', N'是', 20, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (478, N'1', N'表2瞬时流量', N'是', 21, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (479, N'1', N'表2正累计', N'是', 22, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (480, N'1', N'表2负累计', N'是', 23, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (481, N'1', N'表2净累计', N'是', 24, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (482, N'1', N'门开关', N'是', 25, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (483, N'1', N'真实经度', N'否', 26, N'否', N'测点信息', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (484, N'1', N'电池电压下限报警', N'是', 27, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (485, N'1', N'真实纬度', N'否', 28, N'否', N'测点信息', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (486, N'1', N'电池电压下下限报警', N'是', 29, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (487, N'1', N'安装时间', N'否', 30, N'否', N'测点信息', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (488, N'1', N'消毒装置水位计断线报警', N'是', 31, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (489, N'1', N'消毒装置水位上限报警', N'是', 32, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (490, N'1', N'消毒装置水位下限报警', N'是', 33, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (491, N'1', N'安装位置', N'否', 34, N'否', N'测点信息', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (492, N'1', N'手机卡号', N'否', 35, N'否', N'测点信息', N'left', N'否', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (493, N'1', N'清水池水位计断线报警', N'是', 36, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (494, N'1', N'清水池水位上限报警', N'是', 37, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (495, N'1', N'清水池水位下限报警', N'是', 38, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (496, N'1', N'吸水井水位计断线报警', N'是', 39, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (497, N'1', N'吸水井水位上限报警', N'是', 40, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (498, N'1', N'吸水井水位下限报警', N'是', 41, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (499, N'1', N'浊度分析仪断线报警', N'是', 42, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (500, N'1', N'浊度上限报警', N'是', 43, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (501, N'1', N'浊度下限报警', N'是', 44, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (502, N'1', N'余氯分析仪断线报警', N'是', 45, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (503, N'1', N'余氯上限报警', N'是', 46, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (504, N'1', N'余氯下限报警', N'是', 47, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (505, N'1', N'海峰表1通讯报警', N'是', 48, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (506, N'1', N'海峰表2通讯报警', N'是', 49, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (507, N'1', N'平升水位计通讯报警', N'是', 50, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (508, N'1', N'一号压力变送器通讯报警', N'是', 51, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (509, N'1', N'二号压力变送器通讯报警', N'是', 52, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (510, N'1', N'平升水位计水位上限报警', N'是', 53, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
INSERT [dbo].[个人显示参数] ([id], [规则ID], [量名称], [是否显示], [顺序号], [是否冻结], [量类型], [对齐方式], [是否排序], [组名], [显示名称], [列宽]) VALUES (511, N'1', N'平升水位计水位下限报警', N'是', 54, N'否', N'通讯参数', N'left', N'是', N'', N'', NULL)
SET IDENTITY_INSERT [dbo].[个人显示参数] OFF
/****** Object:  Table [dbo].[个人设置]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[个人设置](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NULL,
	[模板ID] [int] NULL,
	[设置类型] [varchar](50) NULL,
	[设置规则] [varchar](200) NULL,
	[操作员] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[个人设置] ON
INSERT [dbo].[个人设置] ([id], [名称], [模板ID], [设置类型], [设置规则], [操作员]) VALUES (1, N'默认', 1, N'实时列表', N'011111111111111111111', N'default')
INSERT [dbo].[个人设置] ([id], [名称], [模板ID], [设置类型], [设置规则], [操作员]) VALUES (2, N'默认', 1, N'历史查询', N'0111111111111111111111', N'default')
INSERT [dbo].[个人设置] ([id], [名称], [模板ID], [设置类型], [设置规则], [操作员]) VALUES (3, N'默认', 2, N'实时列表', N'011111111111110', N'default')
INSERT [dbo].[个人设置] ([id], [名称], [模板ID], [设置类型], [设置规则], [操作员]) VALUES (4, N'默认', 2, N'历史查询', N'01111101111111000', N'default')
SET IDENTITY_INSERT [dbo].[个人设置] OFF
/****** Object:  Table [dbo].[分区信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[分区信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[编号] [varchar](10) NULL,
	[名称] [varchar](50) NULL,
	[上级分区ID] [int] NULL,
	[分区模板ID] [int] NULL,
	[地图范围] [text] NULL,
	[范围描述] [varchar](50) NULL,
	[净流入水量公式] [text] NULL,
 CONSTRAINT [PK_分区信息] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[分区模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[分区模板](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[模板名称] [varchar](50) NULL,
	[总表支持模板ID] [varchar](50) NULL,
	[总表支持量名称] [varchar](50) NULL,
	[分表支持模板ID] [varchar](50) NULL,
	[分表支持量名称] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[分区和管理关系表]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[分区和管理关系表](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[分区ID] [int] NULL,
	[管理ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[分区分表信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[分区分表信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[分区ID] [int] NULL,
	[表类型] [varchar](10) NULL,
	[设备ID] [int] NULL,
	[量名称] [varchar](20) NULL,
 CONSTRAINT [PK_分区分表信息] 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].[发送结果]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[发送结果](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[手机号] [varchar](50) NULL,
	[发送结果] [varchar](50) NULL,
	[发送内容] [varchar](50) NULL,
	[发送时间] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[发卡原因]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[发卡原因](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[单位性质]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[单位性质](
	[ID] [int] NOT NULL,
	[名称] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[单位性质] ([ID], [名称]) VALUES (2, N'工业')
INSERT [dbo].[单位性质] ([ID], [名称]) VALUES (3, N'居民生活')
INSERT [dbo].[单位性质] ([ID], [名称]) VALUES (4, N'行政')
INSERT [dbo].[单位性质] ([ID], [名称]) VALUES (5, N'服务')
INSERT [dbo].[单位性质] ([ID], [名称]) VALUES (6, N'特服')
/****** Object:  Table [dbo].[单位定额]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[单位定额](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[定额方式ID] [int] NOT NULL,
	[单位定额] [numeric](18, 1) NOT NULL,
 CONSTRAINT [PK_单位定额] 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].[传输设备]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[传输设备](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[传输协议] [varchar](50) NULL,
	[传输协议参数] [varchar](50) NULL,
	[数据通道ID] [int] NULL,
	[是否启用] [varchar](50) NOT NULL,
 CONSTRAINT [PK_传输设备] 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
SET IDENTITY_INSERT [dbo].[传输设备] ON
INSERT [dbo].[传输设备] ([ID], [传输协议], [传输协议参数], [数据通道ID], [是否启用]) VALUES (4, N'平升协议', N'13811122201,1', 138, N'是')
INSERT [dbo].[传输设备] ([ID], [传输协议], [传输协议参数], [数据通道ID], [是否启用]) VALUES (5, N'平升协议', N'13811122202,1', 138, N'是')
INSERT [dbo].[传输设备] ([ID], [传输协议], [传输协议参数], [数据通道ID], [是否启用]) VALUES (6, N'平升协议', N'13811122203,1', 138, N'是')
INSERT [dbo].[传输设备] ([ID], [传输协议], [传输协议参数], [数据通道ID], [是否启用]) VALUES (7, N'平升协议', N'13811122204,1', 138, N'是')
SET IDENTITY_INSERT [dbo].[传输设备] OFF
/****** Object:  Table [dbo].[查询设置]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[查询设置](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[操作员ID] [varchar](50) NULL,
	[列选择] [varchar](5000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[册本信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[册本信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[册本号] [varchar](50) NOT NULL,
	[管理ID] [int] NOT NULL,
	[建立时间] [datetime] NOT NULL,
	[更换时间] [datetime] NULL,
 CONSTRAINT [PK_册本信息] 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].[菜单项管理]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[菜单项管理](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[父菜单ID] [int] NOT NULL,
	[菜单名称] [varchar](20) NOT NULL,
	[入口URL] [varchar](100) NULL,
	[顺序号] [int] NOT NULL,
	[相关文件] [varchar](200) NULL,
	[是否启用] [varchar](50) NULL,
 CONSTRAINT [PK_Menu] 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
SET IDENTITY_INSERT [dbo].[菜单项管理] ON
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (1, 0, N'实时监测', N'DataMonitor/MonitorList.html', 2, N'el-icon-ps-shishijiance', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (3, 0, N'数据查询', N'DataQuery/DataQuery.html', 5, N'el-icon-ps-shujuchaxun', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (4, 0, N'统计分析', N'DataReport/PeriodReport.html', 7, N'el-icon-ps-tongjifenxi', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (5, 111, N'数据图表', N'DataChart/PeriodChart.aspx', 9, N'PurviewMgmt.html', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (6, 0, N'系统设置', N'SystemAdmin/MonitorManager.html', 8, N'el-icon-ps-xitongshezhi', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (7, 1, N'实时数据', N'DataMonitor/MonitorList.html', 2, N'el-icon-ps-msnui-analyse', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (8, 111, N'电子地图-谷歌', N'GlobalView/GMap.html', 3, N'el-icon-ps-ditu', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (9, 3, N'历史数据查询', N'DataQuery/HistoryDataQuery.html', 1, N'el-icon-ps-lishishuju', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (10, 3, N'报警数据查询', N'DataQuery/AlarmDataQueryForTrace.html', 2, N'el-icon-ps-real-time-alarm', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (11, 3, N'操作记录查询', N'DataQuery/OperateQuery.html', 3, N'tu1217', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (12, 3, N'登录查询', N'DataQuery/LoginRecords.html', 4, N'LoginRecords.html', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (13, 400, N'户充值统计', N'DataReport/UserRechargeStatistic.html', 1, N'tu0306', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (14, 400, N'村充值统计', N'DataReport/VillageRechargeStatistic.html', 2, N'tu0306', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (15, 6, N'操作员管理', N'WebAdmin/OperatorManager.html', 1, N'tu0625', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (19, 45, N'照片查询', N'DataQuery/AlarmPhotoQuery.html', 5, N'tu0805', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (21, 5, N'通用曲线', N'DataChart/MonitorParamsCompareChart.html', 1, NULL, NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (23, 6, N'区域管理', N'SystemAdmin/AreaManager.html', 2, N'tu1605', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (26, 400, N'户用水统计', N'DataReport/UserWaterStatistic.html', 3, N'tuwater', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (27, 400, N'村用水统计', N'DataReport/VillageWaterStatistic.html', 4, N'tuwater', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (29, 33, N'用水户管理', N'SystemAdmin/WaterUserManager.html', 4, N'tu1911', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (30, 33, N'价格管理', N'SystemAdmin/PriceManager.html', 5, N'tu1814', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (31, 33, N'作物管理', N'SystemAdmin/CropManager.html', 5, N'tu1705', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (33, 112, N'信息管理', NULL, 6, N'信息管理.png', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (34, 6, N'个人设置', N'SystemAdmin/PersonalOption.html', 4, N'tu0625', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (35, 4, N'通用报表', N'DataReport/CommonReport.html', 7, N'tu1305', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (36, 6, N'测点管理', N'SystemAdmin/MonitorManager.html', 3, N'tu1112', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (37, 4, N'曲线分析', N'DataChart/CommonChart.html', 8, N'tu1405', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (38, 33, N'用水计划', N'SaleWater/WaterPlan.html', 6, N'tuwater', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (39, 400, N'水资源报表', N'DataReport/SiShui_QuaterChargeReport.html', 5, N'tuwater', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (42, 400, N'企业报表', N'EnterpriseReport/SummaryReport.html', 6, N'tu1705', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (43, 4, N'对比曲线', N'DataChart/SingleDeviceChart.html', 9, N'tu1505', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (45, 0, N'图像管理', N'BDMap.html', 6, N'el-icon-ps-tuxiangguanli', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (47, 0, N'视频管理', N'bdmap.html', 4, N'el-icon-ps-shipinguanli', N'否')
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (49, 45, N'图像监测', N'DataMonitor/ImageMonitorList.html', 1, N'tu0805', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (52, 47, N'视频管理', N'SystemAdmin/VideoInfoManager.html', 1, N'el-icon-ps-shipinguanli', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (53, 47, N'视频查询-直播', N'DataMonitor/VideoParamMonitorListLive.html', 2, N'el-icon-ps-shishishipinjiankong', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (56, 6, N'角色管理', N'WebAdmin/RoleRightManager.html', 0, N'tu1911', N'是')
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (57, 4, N'汇总报表', N'DataReport/SummaryReport.html', 1, N'tu1305', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (64, 0, N'首页', N'SystemAdmin/MonitorInfo.html', 1, N'el-icon-ps-zhandiangaikuang', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (67, 333, N'事件查询', N'DataQuery/EventDataQuery.html', 5, NULL, NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (68, 1, N'百度地图', N'GlobalView/BDMap.html', 4, N'el-icon-ps-ditu', NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (71, 1, N'实时曲线', N'DataMonitor/MonitorChartList.html', 1, NULL, NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (76, 47, N'视频查询-控件', N'DataMonitor/VideoParamMonitorList.html', 3, NULL, NULL)
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (77, 1, N'视频测试', N'Interface/123.html', 8, NULL, N'否')
INSERT [dbo].[菜单项管理] ([ID], [父菜单ID], [菜单名称], [入口URL], [顺序号], [相关文件], [是否启用]) VALUES (80, 0, N'系统概况', N'SystemAdmin/SystemGeneralSituation.html', 1, N'el-icon-ps-shishishipinjiankong', NULL)
SET IDENTITY_INSERT [dbo].[菜单项管理] OFF
/****** Object:  Table [dbo].[菜单权限关系]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[菜单权限关系](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[菜单ID] [int] NULL,
	[权限ID] [int] NULL,
	[权限别名] [varchar](50) NULL,
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
SET IDENTITY_INSERT [dbo].[菜单权限关系] ON
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (1, 7, 15, N'控制')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (2, 7, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (3, 7, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (4, 8, 15, N'控制')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (5, 8, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (6, 8, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (7, 15, 13, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (8, 17, 19, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (9, 23, 14, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (10, 34, 23, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (11, 36, 19, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (12, 45, 15, N'控制')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (13, 45, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (14, 45, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (15, 47, 15, N'控制')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (16, 47, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (17, 47, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (18, 49, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (19, 52, 18, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (20, 53, 15, N'控制')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (21, 53, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (22, 53, 20, N'拍照')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (23, 54, 16, N'读设参')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (24, 56, 9, N'编辑')
INSERT [dbo].[菜单权限关系] ([ID], [菜单ID], [权限ID], [权限别名]) VALUES (25, 15, 6, N'修改密码')
SET IDENTITY_INSERT [dbo].[菜单权限关系] OFF
/****** Object:  Table [dbo].[表具信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[表具信息](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[名称] [varchar](50) NOT NULL,
	[类型] [varchar](50) NOT NULL,
	[水表口径] [int] NOT NULL,
	[型号] [varchar](50) NOT NULL,
	[常用流量] [decimal](18, 2) NOT NULL,
	[分界流量] [decimal](18, 2) NOT NULL,
	[过载流量] [decimal](18, 2) NOT NULL,
	[最小流量] [decimal](18, 2) NOT NULL,
	[最大示值] [decimal](18, 2) NOT NULL,
	[过载压力损失] [decimal](18, 2) NULL,
	[生产厂家] [varchar](200) NULL,
	[厂家电话] [varchar](15) NULL,
	[备注] [varchar](500) NULL,
 CONSTRAINT [PK_表具信息] 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
SET IDENTITY_INSERT [dbo].[表具信息] ON
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (1, N'天津旋翼式DN80', N'旋翼式', 80, N'旋翼式DN80', CAST(30.00 AS Decimal(18, 2)), CAST(6.00 AS Decimal(18, 2)), CAST(60.00 AS Decimal(18, 2)), CAST(0.90 AS Decimal(18, 2)), CAST(99999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'天津仪表有限公司', N'', N'天津水表厂')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (2, N'天津旋翼式DN100', N'旋翼式', 100, N'旋翼式DN100', CAST(50.00 AS Decimal(18, 2)), CAST(10.00 AS Decimal(18, 2)), CAST(100.00 AS Decimal(18, 2)), CAST(1.50 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'天津仪表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (3, N'天津旋翼式DN150', N'旋翼式', 150, N'旋翼式DN150', CAST(100.00 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(200.00 AS Decimal(18, 2)), CAST(3.00 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'天津仪表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (4, N'真兰垂直螺翼式DN80', N'垂直螺翼式', 80, N'垂直螺翼式DN80', CAST(55.00 AS Decimal(18, 2)), CAST(3.00 AS Decimal(18, 2)), CAST(80.00 AS Decimal(18, 2)), CAST(0.60 AS Decimal(18, 2)), CAST(999999.00 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'福州真兰水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (5, N'真兰垂直螺翼式DN100', N'垂直螺翼式', 100, N'垂直螺翼式DN100', CAST(80.00 AS Decimal(18, 2)), CAST(4.50 AS Decimal(18, 2)), CAST(120.00 AS Decimal(18, 2)), CAST(0.70 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'福州真兰水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (6, N'真兰垂直螺翼式DN150', N'垂直螺翼式', 150, N'垂直螺翼式DN150', CAST(200.00 AS Decimal(18, 2)), CAST(9.00 AS Decimal(18, 2)), CAST(300.00 AS Decimal(18, 2)), CAST(1.50 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'福州真兰水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (7, N'连利垂直螺翼式DN80', N'垂直螺翼式', 80, N'垂直螺翼式DN80', CAST(40.00 AS Decimal(18, 2)), CAST(8.00 AS Decimal(18, 2)), CAST(80.00 AS Decimal(18, 2)), CAST(1.20 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'连利水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (8, N'连利垂直螺翼式DN100', N'旋翼式', 100, N'垂直螺翼式DN100', CAST(60.00 AS Decimal(18, 2)), CAST(12.00 AS Decimal(18, 2)), CAST(120.00 AS Decimal(18, 2)), CAST(1.80 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'连利水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (9, N'连利垂直螺翼式DN150', N'旋翼式', 150, N'垂直螺翼式DN150', CAST(150.00 AS Decimal(18, 2)), CAST(30.00 AS Decimal(18, 2)), CAST(300.00 AS Decimal(18, 2)), CAST(4.50 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'连利水表有限公司', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (10, N'郑州旋翼式DN40', N'旋翼式', 40, N'旋翼式DN40', CAST(10.00 AS Decimal(18, 2)), CAST(0.80 AS Decimal(18, 2)), CAST(20.00 AS Decimal(18, 2)), CAST(0.20 AS Decimal(18, 2)), CAST(999999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'郑州水表厂', N'', N'')
INSERT [dbo].[表具信息] ([ID], [名称], [类型], [水表口径], [型号], [常用流量], [分界流量], [过载流量], [最小流量], [最大示值], [过载压力损失], [生产厂家], [厂家电话], [备注]) VALUES (11, N'郑州旋翼式DN50', N'旋翼式', 50, N'旋翼式DN50', CAST(15.00 AS Decimal(18, 2)), CAST(1.50 AS Decimal(18, 2)), CAST(30.00 AS Decimal(18, 2)), CAST(0.40 AS Decimal(18, 2)), CAST(99999.99 AS Decimal(18, 2)), CAST(0.10 AS Decimal(18, 2)), N'郑州水表厂', N'', N'')
SET IDENTITY_INSERT [dbo].[表具信息] OFF
/****** Object:  Table [dbo].[报警图片模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[报警图片模板](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[时间] [datetime] NULL,
	[图片] [image] NULL,
	[照片来源] [varchar](50) NULL,
 CONSTRAINT [PK_报警图片模板] 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] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[报警设置]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[报警设置](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NOT NULL,
	[规则名称] [varchar](50) NOT NULL,
	[量名称] [varchar](50) NOT NULL,
	[量类型] [varchar](10) NOT NULL,
	[正常值] [varchar](50) NULL,
	[报警值] [varchar](50) NULL,
	[结束值] [varchar](50) NULL,
	[变化方式] [varchar](50) NOT NULL,
	[描述信息] [varchar](200) NOT NULL,
	[报警周期] [int] NOT NULL,
	[报警次数] [int] NOT NULL,
	[报警解除次数] [int] NOT NULL,
	[变化量] [int] NOT NULL,
	[记录类型] [varchar](50) NULL,
 CONSTRAINT [PK_报警设置] 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].[报警类别]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[报警类别](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[用户站参数] [varchar](50) NULL,
	[量名称] [varchar](50) NULL,
	[规则名称] [varchar](50) NULL,
	[量类型] [varchar](50) NULL,
	[正常值] [varchar](50) NULL,
	[报警值] [varchar](50) NULL,
	[结束值] [varchar](50) NULL,
	[变化方式] [varchar](50) NULL,
	[描述信息] [varchar](200) NULL,
	[报警周期] [int] NULL,
	[报警次数] [int] NULL,
	[报警解除次数] [int] NULL,
	[变化量] [int] NULL,
	[记录类型] [varchar](50) NULL,
	[级别] [varchar](50) NULL,
	[背景色] [varchar](50) NULL,
	[前景色] [varchar](50) NULL,
	[是否启用] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[报警类别] ON
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (14, N'1', N'水位1下限报警', N'水位1下限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位1下限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (2, N'1', N'通讯状态', N'通讯状态', N'状态量', N'全部正常', N'全部中断', NULL, N'ValueChanged', N'设备离线|连续[时间]离线', 1, 1, 1, 0, N'', NULL, NULL, NULL, 1)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (7, N'1', N'水位1断线报警', N'水位1断线报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位1断线报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (8, N'1', N'水位2断线报警', N'水位2断线报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位2断线报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (9, N'1', N'门开关', N'门开关', N'开关量', NULL, N'门开', NULL, N'EqualNew', N'门开关|连续[时间]门开', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (10, N'1', N'电源电压下限报警', N'电源电压下限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'电源电压下限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (11, N'1', N'压力断线报警', N'压力断线报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'压力断线报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (13, N'1', N'水位1上限报警', N'水位1上限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位1上限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (15, N'1', N'水位2上限报警', N'水位2上限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位2上限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (16, N'1', N'水位2下限报警', N'水位2下限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'水位2下限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (17, N'1', N'压力上限报警', N'压力上限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'压力上限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (18, N'1', N'压力下限报警', N'压力下限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'压力下限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
INSERT [dbo].[报警类别] ([ID], [用户站参数], [量名称], [规则名称], [量类型], [正常值], [报警值], [结束值], [变化方式], [描述信息], [报警周期], [报警次数], [报警解除次数], [变化量], [记录类型], [级别], [背景色], [前景色], [是否启用]) VALUES (19, N'1', N'电源电压下下限报警', N'电源电压下下限报警', N'开关量', NULL, N'报警', NULL, N'EqualNew', N'电源电压下下限报警|连续[时间]报警', 1, 1, 1, 0, N'全部', N'#32CD32', N'#FF8C00', NULL, NULL)
SET IDENTITY_INSERT [dbo].[报警类别] OFF
/****** Object:  Table [dbo].[报警快照模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[报警快照模板](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[电源电压] [numeric](18, 2) NULL,
	[消毒装置空高] [numeric](18, 2) NULL,
	[消毒装置水位] [numeric](18, 2) NULL,
	[清水池空高] [numeric](18, 2) NULL,
	[清水池水位] [numeric](18, 2) NULL,
	[吸水池空高] [numeric](18, 2) NULL,
	[吸水池水位] [numeric](18, 2) NULL,
	[浊度] [numeric](18, 2) NULL,
	[余氯] [numeric](18, 2) NULL,
	[表1瞬时流量] [numeric](18, 2) NULL,
	[表1正累计] [numeric](18, 0) NULL,
	[表1负累计] [numeric](18, 0) NULL,
	[表1净累计] [numeric](18, 0) NULL,
	[表2瞬时流量] [numeric](18, 2) NULL,
	[表2正累计] [numeric](18, 0) NULL,
	[表2负累计] [numeric](18, 0) NULL,
	[表2净累计] [numeric](18, 0) NULL,
	[平升水位计水位] [numeric](18, 3) NULL,
	[一号压力] [numeric](18, 0) NULL,
	[二号压力] [numeric](18, 0) NULL,
	[门开关] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL,
	[电池电压下下限报警] [varchar](50) NULL,
	[消毒装置水位计断线报警] [varchar](50) NULL,
	[消毒装置水位上限报警] [varchar](50) NULL,
	[消毒装置水位下限报警] [varchar](50) NULL,
	[清水池水位计断线报警] [varchar](50) NULL,
	[清水池水位上限报警] [varchar](50) NULL,
	[清水池水位下限报警] [varchar](50) NULL,
	[吸水井水位计断线报警] [varchar](50) NULL,
	[吸水井水位上限报警] [varchar](50) NULL,
	[吸水井水位下限报警] [varchar](50) NULL,
	[浊度分析仪断线报警] [varchar](50) NULL,
	[浊度上限报警] [varchar](50) NULL,
	[浊度下限报警] [varchar](50) NULL,
	[余氯分析仪断线报警] [varchar](50) NULL,
	[余氯上限报警] [varchar](50) NULL,
	[余氯下限报警] [varchar](50) NULL,
	[海峰表1通讯报警] [varchar](50) NULL,
	[海峰表2通讯报警] [varchar](50) NULL,
	[平升水位计通讯报警] [varchar](50) NULL,
	[一号压力变送器通讯报警] [varchar](50) NULL,
	[二号压力变送器通讯报警] [varchar](50) NULL,
	[平升水位计水位上限报警] [varchar](50) NULL,
	[平升水位计水位下限报警] [varchar](50) NULL,
 CONSTRAINT [PK_报警快照模板] 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].[报警记录模板]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[报警记录模板](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[变化类型] [varchar](50) NULL,
	[变化描述] [varchar](50) NULL,
	[数据来源] [varchar](50) NULL,
	[预留水位] [numeric](18, 2) NULL,
	[实测水位] [numeric](18, 2) NULL,
	[基准水位] [numeric](18, 2) NULL,
	[信号强度] [numeric](18, 0) NULL,
	[电池电压] [numeric](18, 2) NULL,
	[模拟量水位故障] [varchar](50) NULL,
	[箱门开关] [varchar](50) NULL,
	[水位计故障] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL,
 CONSTRAINT [PK_报警记录模板] 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].[IC卡状态]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IC卡状态](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IC卡信息]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IC卡信息](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[内部编号] [nvarchar](50) NOT NULL,
	[印刷编号] [nvarchar](50) NULL,
	[建卡日期] [datetime] NOT NULL,
	[IC卡类型ID] [int] NOT NULL,
	[购水设备ID数组] [nvarchar](50) NULL,
	[IC卡状态ID] [int] NOT NULL,
	[持卡人名称] [nvarchar](50) NULL,
	[单位名称] [nvarchar](50) NULL,
	[用水户ID] [int] NOT NULL,
	[用户卡号] [int] NULL,
 CONSTRAINT [PK_IC卡信息] 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].[IC卡类型]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IC卡类型](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[名称] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[IC卡发卡记录]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[IC卡发卡记录](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[发卡原因ID] [int] NOT NULL,
	[IC卡信息ID] [int] NOT NULL,
	[发卡日期] [datetime] NOT NULL,
 CONSTRAINT [PK_IC卡发卡记录] 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].[最后状态]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[最后状态](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[设备ID] [int] NULL,
	[记录时间] [datetime] NOT NULL,
	[采集时间] [datetime] NOT NULL,
	[设备状态] [varchar](10) NOT NULL,
	[通讯状态] [varchar](10) NOT NULL,
	[数据来源] [varchar](10) NOT NULL,
	[预留水位] [numeric](18, 2) NULL,
	[实测水位] [numeric](18, 2) NULL,
	[基准水位] [numeric](18, 2) NULL,
	[信号强度] [numeric](18, 0) NULL,
	[电池电压] [numeric](18, 2) NULL,
	[模拟量水位故障] [varchar](50) NULL,
	[箱门开关] [varchar](50) NULL,
	[水位计故障] [varchar](50) NULL,
	[电池电压下限报警] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[最后状态] ON
INSERT [dbo].[最后状态] ([id], [设备ID], [记录时间], [采集时间], [设备状态], [通讯状态], [数据来源], [预留水位], [实测水位], [基准水位], [信号强度], [电池电压], [模拟量水位故障], [箱门开关], [水位计故障], [电池电压下限报警]) VALUES (1, 4, CAST(0x0000AD1900FBA900 AS DateTime), CAST(0x0000AD1900FBA900 AS DateTime), N'全部正常', N'全部正常', N'历史记录', CAST(6.55 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(0.00 AS Numeric(18, 2)), CAST(12 AS Numeric(18, 0)), CAST(11.26 AS Numeric(18, 2)), N'报警', N'正常', N'报警', N'报警')
SET IDENTITY_INSERT [dbo].[最后状态] OFF
/****** Object:  Table [dbo].[周期明细]    Script Date: 05/20/2021 19:22:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[周期明细](
	[ID] [int] NOT NULL,
	[名称] [varchar](256) NULL,
	[周期类别编号] [char](1) NULL,
	[开始时间] [varchar](20) NULL,
	[结束时间] [varchar](20) NULL,
 CONSTRAINT [PK_周期明细] 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.年周期.3.10-1 00:00:00 .10-1 00:00:00
   大于等于起始，小于结束
   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'周期明细'
GO
INSERT [dbo].[周期明细] ([ID], [名称], [周期类别编号], [开始时间], [结束时间]) VALUES (1, N'年', N'3', N'10-01', N'10-01')
/****** Object:  View [dbo].[VIEW_用户登录记录]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_用户登录记录]
AS
SELECT TOP 100 PERCENT dbo.用户登录记录.用户ID, dbo.用户信息.用户名, 
      dbo.用户登录记录.记录时间, dbo.用户登录记录.登录信息
FROM dbo.用户登录记录 INNER JOIN
      dbo.用户信息 ON dbo.用户登录记录.用户ID = dbo.用户信息.ID
ORDER BY dbo.用户登录记录.用户ID, dbo.用户登录记录.记录时间
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1[50] 2[25] 3) )"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1 [56] 4 [18] 2))"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "用户登录记录"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 116
               Right = 173
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "用户信息"
            Begin Extent = 
               Top = 6
               Left = 211
               Bottom = 116
               Right = 364
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      RowHeights = 240
      Begin ColumnWidths = 5
         Width = 284
         Width = 1440
         Width = 1440
         Width = 1440
         Width = 1440
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 2010
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_用户登录记录'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_用户登录记录'
GO
/****** Object:  View [dbo].[VIEW_用户操作记录]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_用户操作记录]
AS
SELECT     dbo.用户操作记录.用户ID, dbo.用户信息.用户名, dbo.用户操作记录.设备ID, dbo.设备信息.名称 AS 设备名称, dbo.用户操作记录.记录时间, 
                      dbo.用户操作类型.操作名称, dbo.用户操作记录.操作描述
FROM         dbo.用户操作记录 INNER JOIN
                      dbo.用户信息 ON dbo.用户操作记录.用户ID = dbo.用户信息.ID INNER JOIN
                      dbo.用户操作类型 ON dbo.用户操作记录.操作类型ID = dbo.用户操作类型.ID LEFT OUTER JOIN
                      dbo.设备信息 ON dbo.用户操作记录.设备ID = dbo.设备信息.ID
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "用户操作记录"
            Begin Extent = 
               Top = 71
               Left = 13
               Bottom = 190
               Right = 161
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "用户信息"
            Begin Extent = 
               Top = 0
               Left = 245
               Bottom = 119
               Right = 406
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "设备信息"
            Begin Extent = 
               Top = 53
               Left = 496
               Bottom = 172
               Right = 657
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "用户操作类型"
            Begin Extent = 
               Top = 180
               Left = 206
               Bottom = 269
               Right = 348
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_用户操作记录'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_用户操作记录'
GO
/****** Object:  View [dbo].[VIEW_售水记录]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_售水记录]
AS
SELECT dbo.水资源费.名称 AS 水价模板名称, dbo.计费方式.名称 AS 计费方式, 
      dbo.计量方式.名称 AS 计量方式, dbo.售水方式.名称 AS 售水方式, dbo.售水记录.Id, 
      dbo.售水记录.购水设备ID, dbo.售水记录.售水金额, dbo.售水记录.售出水量, 
      dbo.售水记录.售水时间, dbo.售水记录.操作员ID, dbo.售水记录.购水人, 
      dbo.售水记录.备注
FROM dbo.水资源费 INNER JOIN
      dbo.购水设备 ON dbo.水资源费.Id = dbo.购水设备.水资源费ID INNER JOIN
      dbo.售水方式 ON dbo.购水设备.售水方式ID = dbo.售水方式.Id INNER JOIN
      dbo.计量方式 ON dbo.购水设备.计量方式ID = dbo.计量方式.Id INNER JOIN
      dbo.计费方式 ON dbo.购水设备.计费方式ID = dbo.计费方式.Id INNER JOIN
      dbo.售水记录 ON dbo.水资源费.Id = dbo.售水记录.水资源费ID AND 
      dbo.购水设备.Id = dbo.售水记录.购水设备ID AND 
      dbo.售水方式.Id = dbo.售水记录.售水方式ID AND 
      dbo.计量方式.Id = dbo.售水记录.计量方式ID AND 
      dbo.计费方式.Id = dbo.售水记录.计费方式ID
GO
/****** Object:  View [dbo].[VIEW_管理信息]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_管理信息]
AS
SELECT dbo.管理信息.ID, dbo.管理信息.名称, dbo.管理信息.上级ID, dbo.管理信息.级别ID, 
      dbo.级别信息.级别名称, dbo.级别信息.级别描述
FROM dbo.级别信息 INNER JOIN
      dbo.管理信息 ON dbo.级别信息.ID = dbo.管理信息.级别ID
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[20] 2[10] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1[50] 2[25] 3) )"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1 [56] 4 [18] 2))"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "级别信息"
            Begin Extent = 
               Top = 6
               Left = 211
               Bottom = 116
               Right = 346
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "管理信息"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 112
               Right = 173
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      RowHeights = 240
      Begin ColumnWidths = 7
         Width = 284
         Width = 1440
         Width = 1440
         Width = 1440
         Width = 1440
         Width = 1440
         Width = 1440
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_管理信息'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'VIEW_管理信息'
GO
/****** Object:  View [dbo].[VIEW_购水设备]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_购水设备]
AS
SELECT dbo.购水设备.Id, dbo.购水设备.设备ID, dbo.购水设备.设备主板号, 
      dbo.计费方式.名称 AS 计费方式, dbo.计量方式.名称 AS 计量方式, 
      dbo.售水方式.名称 AS 售水方式, dbo.购水设备.初始计费值, dbo.购水设备.报警下限, 
      dbo.购水设备.水表倍率, dbo.购水设备.名称, dbo.购水设备.累计购水量, 
      dbo.水资源费.名称 AS 水价模板名称
FROM dbo.购水设备 INNER JOIN
      dbo.计费方式 ON dbo.购水设备.计费方式ID = dbo.计费方式.Id INNER JOIN
      dbo.计量方式 ON dbo.购水设备.计量方式ID = dbo.计量方式.Id INNER JOIN
      dbo.售水方式 ON dbo.购水设备.售水方式ID = dbo.售水方式.Id INNER JOIN
      dbo.水资源费 ON dbo.购水设备.水资源费ID = dbo.水资源费.Id
GO
/****** Object:  View [dbo].[VIEW_发卡记录]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_发卡记录]
AS
SELECT dbo.IC卡发卡记录.Id, dbo.IC卡发卡记录.IC卡信息ID, dbo.IC卡发卡记录.发卡日期, 
      dbo.发卡原因.名称 AS 发卡原因
FROM dbo.IC卡发卡记录 INNER JOIN
      dbo.发卡原因 ON dbo.IC卡发卡记录.发卡原因ID = dbo.发卡原因.Id
GO
/****** Object:  View [dbo].[VIEW_IC卡管理]    Script Date: 05/20/2021 19:22:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_IC卡管理]
AS
SELECT dbo.IC卡信息.Id AS ID, dbo.IC卡信息.内部编号, dbo.IC卡信息.印刷编号, 
      dbo.IC卡信息.建卡日期, dbo.IC卡类型.名称 AS IC卡类型, 
      dbo.IC卡状态.名称 AS IC卡状态, dbo.IC卡信息.购水设备ID数组, 
      dbo.IC卡信息.持卡人名称, dbo.IC卡信息.单位名称
FROM dbo.IC卡信息 INNER JOIN
      dbo.IC卡状态 ON dbo.IC卡信息.IC卡状态ID = dbo.IC卡状态.Id INNER JOIN
      dbo.IC卡类型 ON dbo.IC卡信息.IC卡类型ID = dbo.IC卡类型.Id
GO
/****** Object:  Default [DF_通讯设备_是否启用]    Script Date: 05/20/2021 19:22:32 ******/
ALTER TABLE [dbo].[通讯设备] ADD  CONSTRAINT [DF_通讯设备_是否启用]  DEFAULT ('是') FOR [是否启用]
GO
/****** Object:  Default [DF_数据卡信息_是否删除]    Script Date: 05/20/2021 19:22:32 ******/
ALTER TABLE [dbo].[数据卡信息] ADD  CONSTRAINT [DF_数据卡信息_是否删除]  DEFAULT ('否') FOR [是否删除]
GO
/****** Object:  Default [DF_设备信息_数据采集方式]    Script Date: 05/20/2021 19:22:32 ******/
ALTER TABLE [dbo].[设备信息] ADD  CONSTRAINT [DF_设备信息_数据采集方式]  DEFAULT (0) FOR [数据采集方式]
GO
/****** Object:  Default [DF_传输设备_是否启用]    Script Date: 05/20/2021 19:22:32 ******/
ALTER TABLE [dbo].[传输设备] ADD  CONSTRAINT [DF_传输设备_是否启用]  DEFAULT ('是') FOR [是否启用]
GO
/****** Object:  ForeignKey [FK_周期明细_REFERENCE_周期类别]    Script Date: 05/20/2021 19:22:32 ******/
ALTER TABLE [dbo].[周期明细]  WITH CHECK ADD  CONSTRAINT [FK_周期明细_REFERENCE_周期类别] FOREIGN KEY([周期类别编号])
REFERENCES [dbo].[周期类别] ([周期类别编号])
GO
ALTER TABLE [dbo].[周期明细] CHECK CONSTRAINT [FK_周期明细_REFERENCE_周期类别]
GO