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


-- ----------------------------
-- Table structure for Role
-- ----------------------------
DROP TABLE [dbo].[Role]
GO
CREATE TABLE [dbo].[Role] (
[ID] uniqueidentifier NOT NULL DEFAULT (newid()) ROWGUIDCOL ,
[Name] nvarchar(50) NOT NULL ,
[RoleNo] int NULL ,
[Remark] nvarchar(100) NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'Role', 
'COLUMN', N'RoleNo')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'角色编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Role'
, @level2type = 'COLUMN', @level2name = N'RoleNo'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'角色编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Role'
, @level2type = 'COLUMN', @level2name = N'RoleNo'
GO

-- ----------------------------
-- Records of Role
-- ----------------------------
INSERT INTO [dbo].[Role] ([ID], [Name], [RoleNo], [Remark]) VALUES (N'374B45EE-4406-498D-8BB3-1B5248A362CF', N'系统管理员', N'100001', null)
GO
GO
INSERT INTO [dbo].[Role] ([ID], [Name], [RoleNo], [Remark]) VALUES (N'98538F59-2064-4AB9-9F33-59CE3EF84B78', N'安装员', N'100002', null)
GO
GO
INSERT INTO [dbo].[Role] ([ID], [Name], [RoleNo], [Remark]) VALUES (N'14B06CC9-B5A4-46AB-9769-7F405B618677', N'普通操作员', N'100004', null)
GO
GO
INSERT INTO [dbo].[Role] ([ID], [Name], [RoleNo], [Remark]) VALUES (N'E176DE4C-EBF3-4DBA-9B48-B38F7522B7C1', N'值班员', N'100005', null)
GO
GO

-- ----------------------------
-- Indexes structure for table Role
-- ----------------------------

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