/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80017
Source Host : localhost:3306
Source Schema : nb
Target Server Type : MySQL
Target Server Version : 80017
File Encoding : 65001
Date: 15/05/2025 17:57:59
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
– Table structure for admin
DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘用户名’,
password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘密码’,
real_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘真实姓名’,
contact_info varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘联系方式’,
role_id int(11) NOT NULL DEFAULT 2 COMMENT ‘角色ID(默认为管理员)’,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX username(username ASC) USING BTREE,
INDEX role_id(role_id ASC) USING BTREE,
CONSTRAINT admin_ibfk_1 FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘管理员表’ ROW_FORMAT = Dynamic;
– Records of admin
– Table structure for device
DROP TABLE IF EXISTS device;
CREATE TABLE device (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘设备名称’,
category_id int(11) NOT NULL COMMENT ‘分类ID’,
model varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘设备型号’,
status varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT ‘IN_STOCK’ COMMENT ‘设备状态(IN_STOCK, IN_USE, MAINTENANCE, SCRAPPED)’,
location varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘存放位置’,
quantity int(11) NULL DEFAULT 1 COMMENT ‘数量’,
purchase_date date NULL DEFAULT NULL COMMENT ‘采购日期’,
price decimal(10, 2) NULL DEFAULT NULL COMMENT ‘单价’,
description text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT ‘设备描述’,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
INDEX category_id(category_id ASC) USING BTREE,
CONSTRAINT device_ibfk_1 FOREIGN KEY (category_id) REFERENCES device_category (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘设备表’ ROW_FORMAT = Dynamic;
– Records of device
– Table structure for device_category
DROP TABLE IF EXISTS device_category;
CREATE TABLE device_category (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘分类名称’,
parent_id int(11) NULL DEFAULT NULL COMMENT ‘父分类ID,用于多级分类’,
description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘分类描述’,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX name(name ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘设备分类表’ ROW_FORMAT = Dynamic;
– Records of device_category
– Table structure for device_repair
DROP TABLE IF EXISTS device_repair;
CREATE TABLE device_repair (
id int(11) NOT NULL AUTO_INCREMENT,
device_id int(11) NOT NULL COMMENT ‘设备ID’,
apply_user_id int(11) NOT NULL COMMENT ‘申请用户ID’,
apply_user_type enum(‘regular_user’,‘admin’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘申请用户类型’,
apply_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘申请时间’,
description text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT ‘故障描述’,
status enum(‘PENDING’,‘APPROVED’,‘REJECTED’,‘COMPLETED’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT ‘PENDING’ COMMENT ‘状态’,
approve_operator_id int(11) NULL DEFAULT NULL COMMENT ‘审批人ID’,
approve_time datetime NULL DEFAULT NULL COMMENT ‘审批时间’,
repair_operator_id int(11) NULL DEFAULT NULL COMMENT ‘维修人员ID’,
repair_time datetime NULL DEFAULT NULL COMMENT ‘维修完成时间’,
cost decimal(10, 2) NULL DEFAULT NULL COMMENT ‘维修费用’,
remark varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id) USING BTREE,
INDEX device_id(device_id ASC) USING BTREE,
CONSTRAINT device_repair_ibfk_1 FOREIGN KEY (device_id) REFERENCES device (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘设备维修记录表’ ROW_FORMAT = Dynamic;
– Records of device_repair
– Table structure for device_scrap
DROP TABLE IF EXISTS device_scrap;
CREATE TABLE device_scrap (
id int(11) NOT NULL AUTO_INCREMENT,
device_id int(11) NOT NULL COMMENT ‘设备ID’,
apply_user_id int(11) NOT NULL COMMENT ‘申请用户ID’,
apply_user_type enum(‘regular_user’,‘admin’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘申请用户类型’,
apply_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘申请时间’,
reason varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘报废原因’,
status enum(‘PENDING’,‘APPROVED’,‘REJECTED’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT ‘PENDING’ COMMENT ‘状态’,
approve_operator_id int(11) NULL DEFAULT NULL COMMENT ‘审批人ID’,
approve_time datetime NULL DEFAULT NULL COMMENT ‘审批时间’,
scrap_time datetime NULL DEFAULT NULL COMMENT ‘报废时间’,
remark varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id) USING BTREE,
INDEX device_id(device_id ASC) USING BTREE,
CONSTRAINT device_scrap_ibfk_1 FOREIGN KEY (device_id) REFERENCES device (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘设备报废表’ ROW_FORMAT = Dynamic;
– Records of device_scrap
– Table structure for device_transfer
DROP TABLE IF EXISTS device_transfer;
CREATE TABLE device_transfer (
id int(11) NOT NULL AUTO_INCREMENT,
device_id int(11) NOT NULL COMMENT ‘设备ID’,
from_location varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘调出位置’,
to_location varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘调入位置’,
apply_user_id int(11) NOT NULL COMMENT ‘申请用户ID’,
apply_user_type enum(‘regular_user’,‘admin’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘申请用户类型’,
apply_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘申请时间’,
quantity int(11) NOT NULL COMMENT ‘调拨数量’,
status enum(‘PENDING’,‘APPROVED’,‘REJECTED’,‘COMPLETED’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT ‘PENDING’ COMMENT ‘状态’,
approve_operator_id int(11) NULL DEFAULT NULL COMMENT ‘审批人ID’,
approve_time datetime NULL DEFAULT NULL COMMENT ‘审批时间’,
transfer_time datetime NULL DEFAULT NULL COMMENT ‘调拨完成时间’,
remark varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id) USING BTREE,
INDEX device_id(device_id ASC) USING BTREE,
CONSTRAINT device_transfer_ibfk_1 FOREIGN KEY (device_id) REFERENCES device (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘设备调拨表’ ROW_FORMAT = Dynamic;
– Records of device_transfer
– Table structure for inbound_record
DROP TABLE IF EXISTS inbound_record;
CREATE TABLE inbound_record (
id int(11) NOT NULL AUTO_INCREMENT,
device_id int(11) NOT NULL COMMENT ‘设备ID’,
quantity int(11) NOT NULL COMMENT ‘入库数量’,
operator_id int(11) NOT NULL COMMENT ‘操作人ID’,
operator_type enum(‘regular_user’,‘admin’,‘manager’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘操作人类型’,
inbound_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘入库时间’,
remark varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘备注’,
status enum(‘PENDING’,‘APPROVED’,‘REJECTED’) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT ‘APPROVED’ COMMENT ‘状态(待审核/已通过/已拒绝)’,
audit_operator_id int(11) NULL DEFAULT NULL COMMENT ‘审核人ID’,
audit_time datetime NULL DEFAULT NULL COMMENT ‘审核时间’,
PRIMARY KEY (id) USING BTREE,
INDEX device_id(device_id ASC) USING BTREE,
CONSTRAINT inbound_record_ibfk_1 FOREIGN KEY (device_id) REFERENCES device (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘入库记录表’ ROW_FORMAT = Dynamic;
– Records of inbound_record
– Table structure for manager
DROP TABLE IF EXISTS manager;
CREATE TABLE manager (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘用户名’,
password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘密码’,
real_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘真实姓名’,
contact_info varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘联系方式’,
role_id int(11) NOT NULL DEFAULT 3 COMMENT ‘角色ID(默认为经理)’,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX username(username ASC) USING BTREE,
INDEX role_id(role_id ASC) USING BTREE,
CONSTRAINT manager_ibfk_1 FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘经理表’ ROW_FORMAT = Dynamic;
– Records of manager
– Table structure for permission
DROP TABLE IF EXISTS permission;
CREATE TABLE permission (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘权限名称’,
code varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘权限代码’,
description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘权限描述’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX code(code ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘权限表’ ROW_FORMAT = Dynamic;
– Records of permission
INSERT INTO permission VALUES (1, ‘login’, ‘user:login’, ‘用户登录’);
INSERT INTO permission VALUES (2, ‘logout’, ‘user:logout’, ‘用户退出’);
INSERT INTO permission VALUES (3, ‘edit_profile’, ‘user:edit-profile’, ‘修改个人信息’);
INSERT INTO permission VALUES (4, ‘view_records’, ‘record:view’, ‘查看出入库记录’);
INSERT INTO permission VALUES (5, ‘query_records’, ‘record:query’, ‘查询出入库记录’);
INSERT INTO permission VALUES (6, ‘inbound_device’, ‘device:inbound’, ‘设备入库’);
INSERT INTO permission VALUES (7, ‘apply_transfer’, ‘device:apply-transfer’, ‘申请设备调拨’);
INSERT INTO permission VALUES (8, ‘apply_repair’, ‘device:apply-repair’, ‘申请设备维修’);
INSERT INTO permission VALUES (9, ‘apply_scrap’, ‘device:apply-scrap’, ‘申请设备报废’);
INSERT INTO permission VALUES (10, ‘manage_users’, ‘user:manage’, ‘管理用户账号’);
INSERT INTO permission VALUES (11, ‘manage_categories’, ‘category:manage’, ‘管理设备分类’);
INSERT INTO permission VALUES (12, ‘manage_devices’, ‘device:manage’, ‘管理设备信息’);
INSERT INTO permission VALUES (13, ‘audit_records’, ‘record:audit’, ‘审核出入库记录’);
INSERT INTO permission VALUES (14, ‘approve_requests’, ‘request:approve’, ‘审批申请’);
INSERT INTO permission VALUES (20, ‘查询设备信息’, ‘device:query’, ‘普通用户查看仓库内设备的详细信息,包括库存数量、位置、状态等’);
INSERT INTO permission VALUES (25, ‘添加普通用户账号’, ‘user:add’, ‘管理员为仓库新增普通用户账号,分配初始权限’);
INSERT INTO permission VALUES (26, ‘管理仓库基本信息’, ‘warehouse:manage’, ‘管理员管理仓库的基本信息,如仓库容量、布局等’);
INSERT INTO permission VALUES (29, ‘管理出入库记录’, ‘record:manage’, ‘管理员管理出入库记录,包括审核、修改和删除操作’);
INSERT INTO permission VALUES (30, ‘审核设备入库’, ‘inbound:audit’, ‘管理员监督和审核设备的入库流程,确保操作的合规性’);
INSERT INTO permission VALUES (31, ‘查看设备库存数据’, ‘device:data:view’, ‘管理员查看设备的库存数据、上架数据等,为决策提供支持’);
INSERT INTO permission VALUES (32, ‘查看仓库运营数据’, ‘warehouse:data:view’, ‘管理员查看仓库的整体运营数据,如库存周转率、利用率等’);
INSERT INTO permission VALUES (33, ‘审批设备调拨’, ‘transfer:approve’, ‘管理员执行对普通用户的设备调拨审批工作’);
INSERT INTO permission VALUES (34, ‘审批设备维修’, ‘repair:approve’, ‘管理员执行对普通用户的设备维修审批工作’);
INSERT INTO permission VALUES (35, ‘审批设备报废’, ‘scrap:approve’, ‘管理员执行对普通用户的设备报废审批工作’);
INSERT INTO permission VALUES (36, ‘管理管理员账号’, ‘admin:manage’, ‘经理管理管理员账号,包括修改、删除等’);
INSERT INTO permission VALUES (37, ‘添加管理员账号’, ‘admin:add’, ‘经理为系统新增管理员账号,分配初始权限’);
INSERT INTO permission VALUES (38, ‘调整普通用户权限’, ‘user:permission:adjust’, ‘经理调整普通用户权限、账号审核等’);
– Table structure for regular_user
DROP TABLE IF EXISTS regular_user;
CREATE TABLE regular_user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘用户名’,
password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘密码’,
real_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘真实姓名’,
contact_info varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘联系方式’,
role_id int(11) NOT NULL DEFAULT 1 COMMENT ‘角色ID(默认为普通用户)’,
create_time datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间’,
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX username(username ASC) USING BTREE,
INDEX role_id(role_id ASC) USING BTREE,
CONSTRAINT regular_user_ibfk_1 FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘普通用户表’ ROW_FORMAT = Dynamic;
– Records of regular_user
– Table structure for role
DROP TABLE IF EXISTS role;
CREATE TABLE role (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT ‘角色名称(普通用户/管理员/经理)’,
description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT ‘角色描述’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘角色表’ ROW_FORMAT = Dynamic;
– Records of role
INSERT INTO role VALUES (1, ‘普通用户’, ‘负责日常出入库操作和记录管理’);
INSERT INTO role VALUES (2, ‘管理员’, ‘负责仓库整体运营和管理’);
INSERT INTO role VALUES (3, ‘经理’, ‘负责整个仓库管理系统的全局管理和监督’);
– Table structure for role_permission
DROP TABLE IF EXISTS role_permission;
CREATE TABLE role_permission (
role_id int(11) NOT NULL,
permission_id int(11) NOT NULL,
PRIMARY KEY (role_id, permission_id) USING BTREE,
INDEX permission_id(permission_id ASC) USING BTREE,
CONSTRAINT role_permission_ibfk_1 FOREIGN KEY (role_id) REFERENCES role (id) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT role_permission_ibfk_2 FOREIGN KEY (permission_id) REFERENCES permission (id) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = ‘角色权限关联表’ ROW_FORMAT = Dynamic;
– Records of role_permission
INSERT INTO role_permission VALUES (1, 3);
INSERT INTO role_permission VALUES (2, 3);
INSERT INTO role_permission VALUES (3, 3);
INSERT INTO role_permission VALUES (1, 4);
INSERT INTO role_permission VALUES (1, 5);
INSERT INTO role_permission VALUES (1, 6);
INSERT INTO role_permission VALUES (1, 7);
INSERT INTO role_permission VALUES (2, 7);
INSERT INTO role_permission VALUES (1, 8);
INSERT INTO role_permission VALUES (2, 8);
INSERT INTO role_permission VALUES (1, 9);
INSERT INTO role_permission VALUES (2, 9);
INSERT INTO role_permission VALUES (2, 10);
INSERT INTO role_permission VALUES (3, 10);
INSERT INTO role_permission VALUES (2, 11);
INSERT INTO role_permission VALUES (3, 11);
INSERT INTO role_permission VALUES (2, 12);
INSERT INTO role_permission VALUES (3, 12);
INSERT INTO role_permission VALUES (1, 20);
INSERT INTO role_permission VALUES (2, 25);
INSERT INTO role_permission VALUES (2, 26);
INSERT INTO role_permission VALUES (2, 29);
INSERT INTO role_permission VALUES (3, 29);
INSERT INTO role_permission VALUES (2, 30);
INSERT INTO role_permission VALUES (3, 30);
INSERT INTO role_permission VALUES (2, 31);
INSERT INTO role_permission VALUES (3, 31);
INSERT INTO role_permission VALUES (2, 32);
INSERT INTO role_permission VALUES (3, 32);
INSERT INTO role_permission VALUES (2, 33);
INSERT INTO role_permission VALUES (3, 33);
INSERT INTO role_permission VALUES (2, 34);
INSERT INTO role_permission VALUES (3, 34);
INSERT INTO role_permission VALUES (2, 35);
INSERT INTO role_permission VALUES (3, 35);
INSERT INTO role_permission VALUES (3, 36);
INSERT INTO role_permission VALUES (3, 37);
INSERT INTO role_permission VALUES (3, 38);
SET FOREIGN_KEY_CHECKS = 1;
根据这个表格 生成一个设备仓储管理系统 用vue java语言实现