創(chuàng)建sys_authority表的sql語(yǔ)句
DROP TABLE IF EXISTS
sys_authority;
CREATE TABLE
sys_authority(
IDBIGINT(32) NOT NULL AUTO_INCREMENT,
AUTHORITY_NOVARCHAR(20) UNIQUE NOT NULL COMMENT '權(quán)限編號(hào)',
AUTHORITY_NAMEVARCHAR(50) COMMENT '權(quán)限名稱',
AUTHORITY_TYPEINT(11) DEFAULT 1 COMMENT '權(quán)限類型',
FATHER_AUTHORITYVARCHAR(32) COMMENT '父權(quán)限',
DATA_IDVARCHAR(32) COMMENT '數(shù)據(jù)ID',
DATA_NAMEVARCHAR(32) COMMENT '數(shù)據(jù)項(xiàng)名稱',
REMARKVARCHAR(256) DEFAULT '' COMMENT '權(quán)限描述',
PRIMARY KEY(ID)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
創(chuàng)建org_authority表的sql語(yǔ)句
DROP TABLE IF EXISTS
org_authority;
CREATE TABLE
org_authority(
IDBIGINT(32) NOT NULL AUTO_INCREMENT,
AUTHORITY_NOVARCHAR(20) UNIQUE NOT NULL COMMENT '權(quán)限編號(hào)',
AUTHORITY_NAMEVARCHAR(50) COMMENT '權(quán)限名稱',
ORG_IDVARCHAR(32) COMMENT '組織機(jī)構(gòu)編號(hào)',
ORG_NAMEVARCHAR(255) COMMENT '組織機(jī)構(gòu)名稱',
DATA_IDVARCHAR(32) COMMENT '數(shù)據(jù)ID',
DATA_NAMEVARCHAR(32) COMMENT '數(shù)據(jù)項(xiàng)名稱',
PRIMARY KEY(ID)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
創(chuàng)建tenant表的sql語(yǔ)句
DROP TABLE IF EXISTS
tenant;
CREATE TABLE
tenant(
IDBIGINT(32) NOT NULL AUTO_INCREMENT,
SOFTWARE_NAMEVARCHAR(32) NOT NULL COMMENT '軟件名稱',
TENANT_IDVARCHAR(25) COMMENT '租戶ID',
TENANT_NAMEVARCHAR(50) COMMENT '租戶名稱',
LOGOVARCHAR(255) COMMENT 'logo',
COPYRIGHT_INFOVARCHAR(255) COMMENT '版權(quán)信息',
PRIMARY KEY(ID)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
-- 基于ORBAC權(quán)限模型的表結(jié)構(gòu)
-- mysql
-- 權(quán)限表
CREATE TABLE sys_permissions
(
permission_id BIGINT PRIMARY KEY,
name VARCHAR(255) UNIQUE NOT NULL,
description VARCHAR(255) NOT NULL,
org_id BIGINT NOT NULL
);
-- 權(quán)限角色關(guān)系表
CREATE TABLE sys_permissions_roles
(
p2r_id BIGINT PRIMARY KEY,
permission_id BIGINT NOT NULL,
role_id BIGINT NOT NULL
);
DROP TABLE IF EXISTS sys_resources;
-- 資源表
CREATE TABLE sys_resources
(
resource_id BIGINT PRIMARY KEY,
type VARCHAR(255), -- 資源類型：URI、操作、文件梯捕、菜單等
value VARCHAR(255) UNIQUE NOT NULL, -- 資源內(nèi)容
description VARCHAR(255) NOT NULL ,-- 資源描述
org_id BIGINT NOT NULL
);
-- 資源權(quán)限關(guān)系表
CREATE TABLE sys_resources_permissions
(
r2p_id BIGINT PRIMARY KEY,
resource_id BIGINT NOT NULL,
permission_id BIGINT NOT NULL
);
