24 lines
7.5 KiB
SQL
24 lines
7.5 KiB
SQL
-- M11b-3/M11b-4 pbl_runtime_ext 广播/轮询端点权限种子（8 条，逐条显式，无通配符）
|
||
-- 由 scripts/m11b34_rbac_seed.py 生成，幂等（id 为 path/role 的 md5 派生）
|
||
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_450b1b77dc9b1beb7a06a9b0f0fca', '/pbl_runtime_ext/api/pbl_runtime_event_append.dspy', 'pbl_runtime_event_append', '运行时事件追加（单事务事件+状态写入） | M11b-2 | role=logined | 契约 pbl_runtime_event_append → pbl_runtime_ext/api.py::api_pbl_runtime_event_append → scripts/load_path.py PATHS[0]', 'api', 'pbl_runtime_ext', '运行时事件追加（单事务事件+状态写入）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_58d7b9596b19d722759a7973ad50d', '/pbl_runtime_ext/api/pbl_runtime_event_poll.dspy', 'pbl_runtime_event_poll', '运行时事件 3s 轮询兜底拉取 | M11b-4 | role=logined | 契约 pbl_runtime_event_poll → pbl_runtime_ext/api.py::api_pbl_runtime_event_poll → scripts/load_path.py PATHS[1]', 'api', 'pbl_runtime_ext', '运行时事件 3s 轮询兜底拉取', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_0d3922b6801b0ed20b946590f1ba9', '/pbl_runtime_ext/api/pbl_entity_state_get.dspy', 'pbl_entity_state_get', '实体状态读取（服务端权威 state_version） | M11b-4 | role=logined | 契约 pbl_entity_state_get → pbl_runtime_ext/api.py::api_pbl_entity_state_get → scripts/load_path.py PATHS[2]', 'api', 'pbl_runtime_ext', '实体状态读取（服务端权威 state_version）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_56a266cb31f203815239c7b25c5f1', '/pbl_runtime_ext/api/pbl_entity_state_apply.dspy', 'pbl_entity_state_apply', '实体状态变更申请（客户端禁写 state_version） | M11b-2 | role=logined | 契约 pbl_entity_state_apply → pbl_runtime_ext/api.py::api_pbl_entity_state_apply → scripts/load_path.py PATHS[3]', 'api', 'pbl_runtime_ext', '实体状态变更申请（客户端禁写 state_version）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_fbe9adbe519a2c38a7a23c48f9cc3', '/pbl_runtime_ext/api/pbl_world_broadcast.dspy', 'pbl_world_broadcast', '服务端世界广播（提交后广播 ≤300ms） | M11b-3 | role=logined | 契约 pbl_world_broadcast → pbl_runtime_ext/api.py::api_pbl_world_broadcast → scripts/load_path.py PATHS[4]', 'api', 'pbl_runtime_ext', '服务端世界广播（提交后广播 ≤300ms）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_5ca8286318bbbbd7cd270080a7753', '/pbl_runtime_ext/api/pbl_session_member_add.dspy', 'pbl_session_member_add', '会话成员加入（广播订阅名单维护） | M11b-3 | role=logined | 契约 pbl_session_member_add → pbl_runtime_ext/api.py::api_pbl_session_member_add → scripts/load_path.py PATHS[5]', 'api', 'pbl_runtime_ext', '会话成员加入（广播订阅名单维护）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_ad04e35c34433e171ac69800fe736', '/pbl_runtime_ext/api/pbl_runtime_broadcast_pull.dspy', 'pbl_runtime_broadcast_pull', '广播增量拉取（3s 轮询兜底） | M11b-4 | role=logined | 契约 pbl_runtime_broadcast_pull → pbl_runtime_ext/api.py::api_pbl_runtime_broadcast_pull → scripts/load_path.py PATHS[6]', 'api', 'pbl_runtime_ext', '广播增量拉取（3s 轮询兜底）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
INSERT INTO `permission` (`id`, `path`, `name`, `description`, `ptype`, `parentid`, `title`, `icon`) VALUES ('rp_abddb912040e109aef26528c6bb61', '/pbl_runtime_ext/api/pbl_runtime_broadcast_stats.dspy', 'pbl_runtime_broadcast_stats', '广播时延统计（裁决/广播/端到端指标） | M11b-4 | role=logined | 契约 pbl_runtime_broadcast_stats → pbl_runtime_ext/api.py::api_pbl_runtime_broadcast_stats → scripts/load_path.py PATHS[7]', 'api', 'pbl_runtime_ext', '广播时延统计（裁决/广播/端到端指标）', 'api') ON DUPLICATE KEY UPDATE `path`=VALUES(`path`), `name`=VALUES(`name`), `description`=VALUES(`description`), `ptype`=VALUES(`ptype`), `parentid`=VALUES(`parentid`), `title`=VALUES(`title`), `icon`=VALUES(`icon`);
|
||
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_0365a6a1679328328a337aaae4ce4', 'logined', 'rp_450b1b77dc9b1beb7a06a9b0f0fca') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_e601324f76b0703166ae853124b62', 'logined', 'rp_58d7b9596b19d722759a7973ad50d') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_54e96ce003e48250e153e0cea47f5', 'logined', 'rp_0d3922b6801b0ed20b946590f1ba9') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_119eac70d6411625f72a05b94a1f0', 'logined', 'rp_56a266cb31f203815239c7b25c5f1') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_9cd4cf0eec4378e78a751d0b900c6', 'logined', 'rp_fbe9adbe519a2c38a7a23c48f9cc3') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_824b636853f523ee9c5c3af35d8a9', 'logined', 'rp_5ca8286318bbbbd7cd270080a7753') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_0047385267d96c7d6b519b68c68be', 'logined', 'rp_ad04e35c34433e171ac69800fe736') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
INSERT INTO `rolepermission` (`id`, `roleid`, `permid`) VALUES ('rr_85058b3d449dc86c47380293a2f45', 'logined', 'rp_abddb912040e109aef26528c6bb61') ON DUPLICATE KEY UPDATE `permid`=VALUES(`permid`);
|
||
|
||
-- 校验：应为 8 条 permission + 8 条 rolepermission
|
||
SELECT COUNT(1) AS perm_cnt FROM `permission` WHERE `path` LIKE '/pbl\_runtime\_ext/api/%';
|