ALARM/豪恩LHB9000管理软件/Navicat sql/AlarmPreResult.sql

/*
Navicat SQL Server Data Transfer

Source Server         : 9000
Source Server Version : 105000
Source Host           : .\sqlexpress:1433
Source Database       : LHBMS
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2021-05-11 15:28:44
*/


-- ----------------------------
-- Table structure for AlarmPreResult
-- ----------------------------
DROP TABLE [dbo].[AlarmPreResult]
GO
CREATE TABLE [dbo].[AlarmPreResult] (
[ID] int NOT NULL IDENTITY(1,1) ,
[SetType] int NULL ,
[Result] nvarchar(50) NULL 
)


GO
DBCC CHECKIDENT(N'[dbo].[AlarmPreResult]', RESEED, 11)
GO

-- ----------------------------
-- Records of AlarmPreResult
-- ----------------------------
SET IDENTITY_INSERT [dbo].[AlarmPreResult] ON
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'1', N'1', N'去现场勘察')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'2', N'1', N'通知相关人员')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'5', N'1', N'报110')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'6', N'3', N'误报')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'7', N'2', N'处理完成')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'8', N'2', N'交给警察处理')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'9', N'3', N'小区保安')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'10', N'3', N'派出所')
GO
GO
INSERT INTO [dbo].[AlarmPreResult] ([ID], [SetType], [Result]) VALUES (N'11', N'3', N'市公安局')
GO
GO
SET IDENTITY_INSERT [dbo].[AlarmPreResult] OFF
GO

-- ----------------------------
-- Indexes structure for table AlarmPreResult
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table AlarmPreResult
-- ----------------------------
ALTER TABLE [dbo].[AlarmPreResult] ADD PRIMARY KEY ([ID])
GO