| | |
|---|
| | | INSERT INTO `SYSTEM_ROLE_PERMISSION` (`ROLE_ID`, `PERMISSION_ID`, `CREATE_TIME`, `UPDATE_TIME`, `CREATE_USER`, `UPDATE_USER`, `DELETED`) |
|---|
| | | SELECT r.`ID`, p.`ID`, CURRENT_TIMESTAMP, NULL, 1, NULL, 0 |
|---|
| | | FROM `SYSTEM_ROLE` r |
|---|
| | | INNER JOIN `SYSTEM_PERMISSION` p ON p.`CODE` = 'business:ywelectricalactions:query' AND p.`DELETED` = 0 |
|---|
| | | INNER JOIN `SYSTEM_PERMISSION` p ON p.`CODE` IN ('business:ywelectricalactions:query', 'business:ywelectricalactions:queryResult') AND p.`DELETED` = 0 |
|---|
| | | WHERE r.`DELETED` = 0 AND (r.`CODE` = 'admin' OR r.`NAME` = '管理员') |
|---|
| | | AND NOT EXISTS ( |
|---|
| | | SELECT 1 FROM `SYSTEM_ROLE_PERMISSION` rp |
|---|
