SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

title

TEXT

repo_id

INTEGER

owner_id

INTEGER

workflow_id

TEXT

index

INTEGER

trigger_user_id

INTEGER

schedule_id

INTEGER

ref

TEXT

commit_sha

TEXT

is_fork_pull_request

INTEGER

need_approval

INTEGER

approved_by

INTEGER

event

TEXT

event_payload

{"ref":"refs/heads/main","before":"06556f73ea74b431979b8b819de8e85358843b49","after":"4bda2cc02706e1c64d5cd23c233673a0b32d0a72","compare_url":"https://gitea.g-hi.com/pengzhiyu/IAM/compare/06556f73ea74b431979b8b819de8e85358843b49...4bda2cc02706e1c64d5cd23c233673a0b32d0a72","commits":[{"id":"4bda2cc02706e1c64d5cd23c233673a0b32d0a72","message":"test: 修复集成测试应用的关闭顺序\n\n测试类的临时数据库和 Redis 会先于缓存中的应用回收，后台任务可能继续访问已回收资源。\n\n实现内容：\n- 为 BaselineIT 和 AccountsIT 声明 AFTER_CLASS 关闭并接入测试探针\n- 在容器仍存活时核对连接池、Redis、调度任务及所属执行器结束状态\n- 增加正常、异常回调及未关闭资源反例，保留原故障恢复和安全断言\n- 记录本地归因、首次失败、最终定向结果与完整检查的启动阻塞\n\n验证：\n- Java 25 离线 test-compile（含 Spotless）通过\n- 最终定向 29 项及 Baseline 独立最后应用 7 项通过\n- 完整 clean verify：169 项单测通过；集成 422 项通过、1 项启动错误、74 项跳过\n- ProtocolConsistencyIT 第二个应用因端口绑定失败启动不成功，占用者尚未确证；完整门禁未通过，未重跑\n- F0 36 场景全部拒绝，消费、新凭据和刷新成功事件为零\n- git diff --check 和 37 个文档相对链接/锚点检查通过\n\n仅修改测试及任务文档；不改变产品合同，不作为候选冻结或性能验收通过的证明。\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/4bda2cc02706e1c64d5cd23c233673a0b32d0a72","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:50:19-07:00","added":["iam-server/src/test/java/com/iam/server/ContextLifecycleIT.java","iam-server/src/test/java/com/iam/server/TestContextShutdownProbe.java"],"removed":[],"modified":["docs/tasks/P12-auth-ingress-attribution-design.md","docs/tasks/P12-software-optimization.md","iam-server/src/test/java/com/iam/server/BaselineIT.java","iam-server/src/test/java/com/iam/server/accounts/AccountsIT.java"]},{"id":"b69ba6c8145d3b5bc8e67e37a9d2f26e8723222b","message":"feat(console): 合并控制台面向普通用户的文案改写\n\n控制台原先大量使用标识、版本、协议术语和后端状态原值，普通管理员难以理解。合并 feat/console-polish-next 分支，完成三个概览页重设计、导航改名，以及全部管理页面、个人中心、工作台与切换器的文案改写。\n\n实现内容：\n- 重新设计平台、企业、应用三个概览页，侧边栏模块按日常说法改名，并在 docs/console/design-system.md 记录新旧名称对照\n- 各管理页面改用日常说法，状态和角色显示中文，标识、版本、追踪编号收进默认收起的\"技术细节\"\n- 时间输入改用本地日期时间选择器，提交时仍为带时区的 ISO 时间；操作记录显示中文操作名称，并支持下拉筛选\n- \"秘密\"统一称\"密钥\"，\"机器客户端/服务主体\"称\"程序客户端/程序身份\"，\"IAM 会话\"称\"登录记录\"\n- 同步更新单元测试与验收脚本中的文案和定位，列表行增加 data-record-id 供脚本定位\n\n验证：\n- 分支上每批提交前运行 npm run check：format:check、lint、typecheck、build 通过，最后一次测试 203/203 通过\n- 各页面在浏览器中核对；程序接入详情、程序身份详情与启用新应用弹窗因演示环境缺数据或登录过期未核对\n- 验收脚本仅执行 node --check，未实际运行\n- 合并无冲突，main 上未单独重新运行检查\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/b69ba6c8145d3b5bc8e67e37a9d2f26e8723222b","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:34:48-07:00","added":["iam-admin-web/src/lib/audit-actions.ts","iam-admin-web/src/pages/AppOverview.tsx","iam-admin-web/src/pages/PlatformOverview.tsx","iam-admin-web/src/pages/TenantOverview.tsx","iam-admin-web/src/test/app-overview.test.tsx","iam-admin-web/src/test/platform-overview.test.tsx","iam-admin-web/src/test/tenant-overview.test.tsx"],"removed":[],"modified":["docs/console/design-system.md","iam-admin-web/scripts/acceptance-group-lifecycle.mjs","iam-admin-web/scripts/acceptance-p10-t01.mjs","iam-admin-web/scripts/acceptance-p10-t02.mjs","iam-admin-web/scripts/acceptance-p10-t03.mjs","iam-admin-web/scripts/acceptance-p10-t04.mjs","iam-admin-web/scripts/acceptance-p11-t04.mjs","iam-admin-web/scripts/acceptance-p11-t05.mjs","iam-admin-web/scripts/acceptance-p11-t07.mjs","iam-admin-web/scripts/acceptance-t02.mjs","iam-admin-web/scripts/acceptance-t03.mjs","iam-admin-web/scripts/acceptance-t04.mjs","iam-admin-web/scripts/acceptance-t05.mjs","iam-admin-web/scripts/acceptance-t06.mjs","iam-admin-web/scripts/acceptance.mjs","iam-admin-web/src/App.tsx","iam-admin-web/src/components/Layout.tsx","iam-admin-web/src/components/Management.tsx","iam-admin-web/src/data/pages.ts","iam-admin-web/src/lib/roles.ts","iam-admin-web/src/lib/t02-api.ts","iam-admin-web/src/lib/t04-api.ts","iam-admin-web/src/pages/EmailRecoveryPage.tsx","iam-admin-web/src/pages/HomePage.tsx","iam-admin-web/src/pages/PersonalPage.tsx","iam-admin-web/src/pages/ScopePages.tsx","iam-admin-web/src/pages/management/ApplicationAdmissionPage.tsx","iam-admin-web/src/pages/management/ApplicationContracts.tsx","iam-admin-web/src/pages/management/ApplicationLifecycle.tsx","iam-admin-web/src/pages/management/ApplicationShared.tsx","iam-admin-web/src/pages/management/ApplicationsPage.tsx","iam-admin-web/src/pages/management/AuditPage.tsx","iam-admin-web/src/pages/management/AuthorizationGuard.tsx","iam-admin-web/src/pages/management/AuthorizationShared.tsx","iam-admin-web/src/pages/management/BindingScopes.tsx","iam-admin-web/src/pages/management/BindingsPage.tsx","iam-admin-web/src/pages/management/DecisionCallersPage.tsx","iam-admin-web/src/pages/management/GroupsPage.tsx","iam-admin-web/src/pages/management/MachineClientsPage.tsx","iam-admin-web/src/pages/management/MachineContract.tsx","iam-admin-web/src/pages/management/MachineCredentials.tsx","iam-admin-web/src/pages/management/MembersPage.tsx","iam-admin-web/src/pages/management/OrganizationsPage.tsx","iam-admin-web/src/pages/management/PlatformPages.tsx","iam-admin-web/src/pages/management/RolesPage.tsx","iam-admin-web/src/pages/management/ServicePrincipalsPage.tsx","iam-admin-web/src/shell/ContextSwitcher.tsx","iam-admin-web/src/shell/ContextTrail.tsx","iam-admin-web/src/shell/NavRail.tsx","iam-admin-web/src/styles/components.css","iam-admin-web/src/styles/pages.css","iam-admin-web/src/test/application-lifecycle.test.tsx","iam-admin-web/src/test/application-management.test.tsx","iam-admin-web/src/test/audit.test.tsx","iam-admin-web/src/test/authorization-management.test.tsx","iam-admin-web/src/test/group-editor.test.tsx","iam-admin-web/src/test/machine-clients.test.tsx","iam-admin-web/src/test/machine-credentials.test.tsx","iam-admin-web/src/test/management-integration.test.tsx","iam-admin-web/src/test/personal.test.tsx","iam-admin-web/src/test/service-principals.test.tsx","iam-admin-web/src/test/sidebar.test.tsx"]},{"id":"9339f14f94e988b7a3d898f11daa506446d75c44","message":"feat(console): 改写工作台与企业切换器文案\n\n工作台和顶部切换器仍使用\"管理上下文\"\"平台总入口仅限平台管理员\"\"全员准入\"\"企业已启用/应用正常\"双徽标等说法，工作台还直接展示账号标识。改为日常说法，并与应用开通页的\"使用情况\"保持一致。\n\n实现内容：\n- 工作台说明改为说明顶部一直显示正在管理的企业和应用；平台入口锁定提示改为\"只有平台管理员可以进入\"，应用管理员入口改为\"进入应用接入\"\n- 右侧卡片改为\"我的账号\"，显示名字、平台管理身份、登录方式与\"这台电脑保存了什么\"，账号标识收进技术细节\n- 切换器标题改为\"切换企业或应用\"并改写说明；企业列表去掉恒为真的\"企业正常\"徽标，非正常状态显示中文状态\n- 应用列表改为\"应用（可选）\"，用 appUsage 的单个\"使用情况\"徽标替代企业关系与全局状态两个徽标，可进入的应用显示\"所有成员可用/仅指定成员可用\"；空状态、无权限与停用说明改写\n- 顶部路径的\"未选择管理上下文\"改为\"未选择企业\"，相关 aria-label 同步改写\n- 平台与应用无法进入时的说明改为日常说法，应用停用原因复用 appUsage\n- 删除已无引用的 relationLabel、applicationStatusLabel、accessPolicyLabel\n- 同步更新 acceptance.mjs 中切换器标题、应用分组、停用说明与无权限提示的定位\n\n验证：\n- npm run check：format:check、lint、typecheck、build 通过，测试 203/203 通过\n- 浏览器核对工作台与切换器（选择企业后未进入）\n- 验收脚本仅执行 node --check，未实际运行\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/9339f14f94e988b7a3d898f11daa506446d75c44","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:27:50-07:00","added":[],"removed":[],"modified":["iam-admin-web/scripts/acceptance.mjs","iam-admin-web/src/lib/roles.ts","iam-admin-web/src/pages/HomePage.tsx","iam-admin-web/src/pages/ScopePages.tsx","iam-admin-web/src/shell/ContextSwitcher.tsx","iam-admin-web/src/shell/ContextTrail.tsx"]},{"id":"74debf18dda59db91112b09eb5a93214a0e18c52","message":"feat(console): 改写个人中心文案并把会话称为登录记录\n\n个人中心原先使用\"IAM 会话\"\"最近协议活动\"\"绝对截止\"\"期限类别\"\"管理上下文\"等术语，每条会话都重复一段说明并直接展示编号。改为\"登录记录\"等日常说法，编号收进技术细节。\n\n实现内容：\n- \"IAM 登录会话\"改为\"登录记录\"，状态改为登录中/已过期/已退出/已失效；时间字段改为登录时间、最近使用、一直不用时自动退出于、最晚退出时间、登录有效期\n- 每条记录重复的说明合并到卡片说明中；登录编号收进技术细节；按钮改为\"退出当前登录\"\"退出这次登录\"\"确认退出\"\"刷新登录记录\"\n- 退出确认与成功提示改为\"登录\"说法，冲突与无权提示改写\n- \"我的身份\"改为\"我的账号\"，显示名字与平台管理身份，账号标识收进技术细节；\"我的企业\"去掉恒为真的\"企业正常/有效成员\"徽标与成员标识，改为\"你的身份：所有者/普通成员\"，按钮改为\"切换企业\"\n- 底部说明改为\"切换企业与退出登录有什么区别\"\n- 邮箱卡片中\"无法恢复丢失的全部 MFA 因素\"改为日常说明\n- 操作记录中的\"两步验证\"统一为与多因素验证页面一致的\"多因素验证\"\n- 同步更新 personal 测试与 acceptance-t05、acceptance-p11-t04/t05/t07 的按钮与标题定位（示例应用自身的\"退出当前 IAM 会话\"按钮未改）\n\n验证：\n- npm run check：format:check、lint、typecheck、build 通过，测试 203/203 通过\n- 浏览器核对个人中心各卡片与登录记录（未执行退出）\n- 验收脚本仅执行 node --check，未实际运行\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/74debf18dda59db91112b09eb5a93214a0e18c52","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:25:43-07:00","added":[],"removed":[],"modified":["iam-admin-web/scripts/acceptance-p11-t04.mjs","iam-admin-web/scripts/acceptance-p11-t05.mjs","iam-admin-web/scripts/acceptance-p11-t07.mjs","iam-admin-web/scripts/acceptance-t05.mjs","iam-admin-web/src/lib/audit-actions.ts","iam-admin-web/src/pages/EmailRecoveryPage.tsx","iam-admin-web/src/pages/PersonalPage.tsx","iam-admin-web/src/test/personal.test.tsx"]},{"id":"546f7184ef08dfa32fbd7610c8152fa6856d9ee4","message":"style(console): 格式化程序身份验收脚本中的负责人失效断言\n\n上一提交在运行 Prettier 之后又修改了 acceptance-p10-t01.mjs 的一行断言，导致该文件不符合 npm run format:check。\n\n实现内容：\n- 按 Prettier 规则折行负责人失效断言，不改变断言内容\n\n验证：\n- npx prettier --check scripts/acceptance-p10-t01.mjs：通过\n- node --check scripts/acceptance-p10-t01.mjs：通过；脚本未实际运行\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/546f7184ef08dfa32fbd7610c8152fa6856d9ee4","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:24:05-07:00","added":[],"removed":[],"modified":["iam-admin-web/scripts/acceptance-p10-t01.mjs"]}],"total_commits":0,"head_commit":{"id":"4bda2cc02706e1c64d5cd23c233673a0b32d0a72","message":"test: 修复集成测试应用的关闭顺序\n\n测试类的临时数据库和 Redis 会先于缓存中的应用回收，后台任务可能继续访问已回收资源。\n\n实现内容：\n- 为 BaselineIT 和 AccountsIT 声明 AFTER_CLASS 关闭并接入测试探针\n- 在容器仍存活时核对连接池、Redis、调度任务及所属执行器结束状态\n- 增加正常、异常回调及未关闭资源反例，保留原故障恢复和安全断言\n- 记录本地归因、首次失败、最终定向结果与完整检查的启动阻塞\n\n验证：\n- Java 25 离线 test-compile（含 Spotless）通过\n- 最终定向 29 项及 Baseline 独立最后应用 7 项通过\n- 完整 clean verify：169 项单测通过；集成 422 项通过、1 项启动错误、74 项跳过\n- ProtocolConsistencyIT 第二个应用因端口绑定失败启动不成功，占用者尚未确证；完整门禁未通过，未重跑\n- F0 36 场景全部拒绝，消费、新凭据和刷新成功事件为零\n- git diff --check 和 37 个文档相对链接/锚点检查通过\n\n仅修改测试及任务文档；不改变产品合同，不作为候选冻结或性能验收通过的证明。\n","url":"https://gitea.g-hi.com/pengzhiyu/IAM/commit/4bda2cc02706e1c64d5cd23c233673a0b32d0a72","author":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"committer":{"name":"starry","email":"gamebyteyu@gmail.com","username":""},"verification":null,"timestamp":"2026-10-11T08:50:19-07:00","added":["iam-server/src/test/java/com/iam/server/ContextLifecycleIT.java","iam-server/src/test/java/com/iam/server/TestContextShutdownProbe.java"],"removed":[],"modified":["docs/tasks/P12-auth-ingress-attribution-design.md","docs/tasks/P12-software-optimization.md","iam-server/src/test/java/com/iam/server/BaselineIT.java","iam-server/src/test/java/com/iam/server/accounts/AccountsIT.java"]},"repository":{"id":125,"owner":{"id":16,"login":"pengzhiyu","login_name":"","source_id":0,"full_name":"","email":"228834386@qq.com","avatar_url":"https://gitea.g-hi.com/avatar/bcd8cfbb58b96e4afa8ab5f6ac09cb16","html_url":"https://gitea.g-hi.com/pengzhiyu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-07-15T09:26:56+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"pengzhiyu"},"name":"IAM","full_name":"pengzhiyu/IAM","description":"Identity and Access Management(身份识别与访问管理)","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":99686,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/pengzhiyu/IAM/languages","html_url":"https://gitea.g-hi.com/pengzhiyu/IAM","url":"https://gitea.g-hi.com/api/v1/repos/pengzhiyu/IAM","link":"","ssh_url":"git@gitea.g-hi.com:pengzhiyu/IAM.git","clone_url":"https://gitea.g-hi.com/pengzhiyu/IAM.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":1,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-10-08T17:04:24+08:00","updated_at":"2026-10-10T17:57:55+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_code":true,"has_issues":true,"internal_tracker":{"enable_time_tracker":true,"allow_only_contributors_to_track_time":true,"enable_issue_dependencies":true},"has_wiki":true,"has_pull_requests":true,"has_projects":true,"projects_mode":"all","has_releases":true,"has_packages":true,"has_actions":true,"ignore_whitespace_conflicts":false,"allow_merge_commits":true,"allow_rebase":true,"allow_rebase_explicit":true,"allow_squash_merge":true,"allow_fast_forward_only_merge":true,"allow_rebase_update":true,"allow_manual_merge":false,"autodetect_manual_merge":false,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":true,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","topics":[],"licenses":[]},"pusher":{"id":16,"login":"pengzhiyu","login_name":"","source_id":0,"full_name":"","email":"16+pengzhiyu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/bcd8cfbb58b96e4afa8ab5f6ac09cb16","html_url":"https://gitea.g-hi.com/pengzhiyu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-07-15T09:26:56+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"pengzhiyu"},"sender":{"id":16,"login":"pengzhiyu","login_name":"","source_id":0,"full_name":"","email":"16+pengzhiyu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/bcd8cfbb58b96e4afa8ab5f6ac09cb16","html_url":"https://gitea.g-hi.com/pengzhiyu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-07-15T09:26:56+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"pengzhiyu"}}

TEXT

trigger_event

TEXT

status

INTEGER

version

INTEGER (default 0

started

INTEGER

stopped

INTEGER

previous_duration

INTEGER

created

INTEGER

updated

INTEGER

raw_concurrency

TEXT

concurrency_group

TEXT NOT NULL (default ''

concurrency_cancel

INTEGER NOT NULL (default FALSE

Update row 25576 in action_run