Package Exports

nestjs-admin-module

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (nestjs-admin-module) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

admin modules

所有的关系表

用户表
角色表
权限表
菜单表
用户角色表
角色权限表
角色菜单表

创建所有的表

# 用户表
CREATE TABLE `admin_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `is_super` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Imobile` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
# 角色表
CREATE TABLE `admin_role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
# 权限表
CREATE TABLE `admin_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` enum('get','post','put','delete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'get' COMMENT 'url方法',
  `uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求的url',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
# 菜单表
CREATE TABLE `admin_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
# 用户角色表
CREATE TABLE `admin_user_role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL,
  `role_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Iuser_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

# 角色权限表
CREATE TABLE `admin_role_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `role_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Irole_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

# 角色菜单表
CREATE TABLE `admin_role_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ctime` int NOT NULL DEFAULT '0',
  `mtime` int NOT NULL DEFAULT '0',
  `dtime` int NOT NULL DEFAULT '0',
  `role_id` int NOT NULL,
  `menu_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Irole_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

nestjs-admin-module