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


-- ----------------------------
-- Table structure for ZoneInfo
-- ----------------------------
DROP TABLE [dbo].[ZoneInfo]
GO
CREATE TABLE [dbo].[ZoneInfo] (
[ID] uniqueidentifier NOT NULL DEFAULT (newid()) ROWGUIDCOL ,
[ZoneNo] int NOT NULL DEFAULT ((0)) ,
[Name] nvarchar(50) NOT NULL ,
[ZoneType] int NULL ,
[ActiveType] int NULL DEFAULT ((0)) ,
[AreaID] int NULL ,
[DevID] uniqueidentifier NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'ZoneInfo', 
'COLUMN', N'ZoneType')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'0:基本分区防区；1：键盘防区'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZoneInfo'
, @level2type = 'COLUMN', @level2name = N'ZoneType'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'0:基本分区防区；1：键盘防区'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZoneInfo'
, @level2type = 'COLUMN', @level2name = N'ZoneType'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'ZoneInfo', 
'COLUMN', N'DevID')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'所属主机'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZoneInfo'
, @level2type = 'COLUMN', @level2name = N'DevID'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'所属主机'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZoneInfo'
, @level2type = 'COLUMN', @level2name = N'DevID'
GO

-- ----------------------------
-- Records of ZoneInfo
-- ----------------------------

-- ----------------------------
-- Indexes structure for table ZoneInfo
-- ----------------------------

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

-- ----------------------------
-- Uniques structure for table ZoneInfo
-- ----------------------------
ALTER TABLE [dbo].[ZoneInfo] ADD UNIQUE ([ZoneNo] ASC, [ZoneType] ASC, [AreaID] ASC, [DevID] ASC)
GO