ALARM/豪恩LHB9000管理软件/Navicat sql/AlarmCodeType.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:14
*/


-- ----------------------------
-- Table structure for AlarmCodeType
-- ----------------------------
DROP TABLE [dbo].[AlarmCodeType]
GO
CREATE TABLE [dbo].[AlarmCodeType] (
[ID] int NOT NULL ,
[Name] nvarchar(10) NULL 
)


GO

-- ----------------------------
-- Records of AlarmCodeType
-- ----------------------------
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'0', N'所有类型')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'1', N'IP探头')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'2', N'报警')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'3', N'编程')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'4', N'测试报告')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'5', N'撤布防')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'6', N'出入')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'7', N'错误')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'8', N'短信')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'9', N'故障')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'10', N'故障事件')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'11', N'恢复')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'12', N'火警')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'13', N'计划任务')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'14', N'监控')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'15', N'劫盗')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'16', N'紧急')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'17', N'旁路')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'18', N'窃盗')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'19', N'停用')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'20', N'系统')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'21', N'新新')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'22', N'遥控编程')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'23', N'用户')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'24', N'转发任务')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'25', N'状态')
GO
GO
INSERT INTO [dbo].[AlarmCodeType] ([ID], [Name]) VALUES (N'26', N'状态报告')
GO
GO

-- ----------------------------
-- Indexes structure for table AlarmCodeType
-- ----------------------------

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