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


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


GO

-- ----------------------------
-- Records of AlarmCodeLevel
-- ----------------------------
INSERT INTO [dbo].[AlarmCodeLevel] ([ID], [Name]) VALUES (N'0', N'不显示')
GO
GO
INSERT INTO [dbo].[AlarmCodeLevel] ([ID], [Name]) VALUES (N'1', N'自动处理')
GO
GO
INSERT INTO [dbo].[AlarmCodeLevel] ([ID], [Name]) VALUES (N'2', N'用户处理')
GO
GO
INSERT INTO [dbo].[AlarmCodeLevel] ([ID], [Name]) VALUES (N'3', N'紧急置顶')
GO
GO

-- ----------------------------
-- Indexes structure for table AlarmCodeLevel
-- ----------------------------

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