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


-- ----------------------------
-- Table structure for Permission
-- ----------------------------
DROP TABLE [dbo].[Permission]
GO
CREATE TABLE [dbo].[Permission] (
[RoleNo] nvarchar(50) NOT NULL ,
[ModuleNo] nvarchar(50) NOT NULL ,
[PeAdd] bit NULL ,
[PeDelete] bit NULL ,
[PeUpdate] bit NULL ,
[PeQuery] bit NULL 
)


GO

-- ----------------------------
-- Records of Permission
-- ----------------------------

-- ----------------------------
-- Indexes structure for table Permission
-- ----------------------------

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