RBAC建表语句（mysql）

---

– 用户表

---

DROP TABLE IF EXISTS sys_user;
CREATE TABLE sys_user (
user_id bigint(20) NOT NULL,
dept_id bigint(20) NOT NULL COMMENT ‘部门’,
job varchar(50) NOT NULL COMMENT ‘职务’,
user_name varchar(20) NOT NULL COMMENT ‘用户名’,
password varchar(20) DEFAULT NULL COMMENT ‘密码’,
status int(10) DEFAULT NULL COMMENT ‘状态’
PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘用户表’;

---

– 部门表

---

DROP TABLE IF EXISTS sys_dept;
CREATE TABLE sys_dept (
dept_id bigint(20) NOT NULL,
company_id bigint(20) NOT NULL COMMENT ‘公司’,
dept_name varchar(20) NOT NULL COMMENT ‘部门名称’,
remark varchar(20) DEFAULT NULL COMMENT ‘说明’
PRIMARY KEY (dept_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘部门表’;

---

– 公司表

---

DROP TABLE IF EXISTS sys_company;
CREATE TABLE sys_company (
company_id bigint(20) NOT NULL,
company_name varchar(20) NOT NULL COMMENT ‘公司名称’,
company_leader varchar(20) NOT NULL COMMENT ‘负责人’,
address varchar(20) NOT NULL COMMENT ‘公司地址’,
postal varchar(20) NOT NULL COMMENT ‘邮编’,