SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

user_id

INTEGER

op_type

INTEGER

act_user_id

INTEGER

repo_id

INTEGER

comment_id

INTEGER

is_deleted

INTEGER NOT NULL (default 0

ref_name

TEXT

is_private

INTEGER NOT NULL (default 0

content

{"Commits":[{"Sha1":"79d594dd776b47b40e6329ed3f6cf53c2b18251f","Message":"fix(migrations): 修复7个迁移文件确保 shadow DB 全量回放零错误\n\n修复内容：\n1. 20260125000001_enable_pgvector_and_agent_groups\n   - 移除重复/冲突的索引定义，消除 shadow DB 回放时的语法冲突\n\n2. 20260126000000_sync_indexes_and_constraints\n   - 对索引创建语句进行幂等性保护（IF NOT EXISTS）\n   - 修复约束名称冲突问题\n\n3. 20260126000001_add_foreign_keys\n   - 将外键添加操作包裹在 DO 块内\n   - 检查列是否存在（如 parent_task_id）再添加外键，防止\"列不存在\"错误\n\n4. 20260214000002_expand_serial_number_sn_code_length\n   - 先 DROP 依赖视图 v_entitlements_expiring\n   - 执行 ALTER COLUMN sn_code TYPE VARCHAR(100)\n   - 重建视图，解决\"列被视图使用不能修改类型\"错误\n\n5. 20260215000003_migrate_bank_accounts_from_json\n   - 将迁移逻辑包裹在 DO 块内\n   - 检查 config_key 列是否存在后再执行，兼容 baseline 和 live DB 的列名差异\n\n6. 20260219000000_add_agent_audit_tables\n   - 在 CREATE TABLE agent_audit_logs 前添加条件 DROP\n   - 检查旧表标记列 action_type 存在时 DROP CASCADE，解决旧表无 status 列的问题\n\n7. 20260223000000_add_performance_indexes\n   - 将 idx_groupbuy_campaign_products_tenant_id_status 索引创建\n     包裹在 DO 块内，检查 status 列存在后再创建\n   - groupbuy_campaign_products 建表时未含 status 列，条件跳过\n\n验证：migrate deploy 在空数据库全量回放成功，\"All migrations have been successfully applied.\"\n","AuthorEmail":"laoluojuhai@users.noreply.github.com","AuthorName":"laoluojuhai","CommitterEmail":"laoluojuhai@users.noreply.github.com","CommitterName":"laoluojuhai","Timestamp":"2026-02-28T08:55:53+08:00"}],"HeadCommit":{"Sha1":"79d594dd776b47b40e6329ed3f6cf53c2b18251f","Message":"fix(migrations): 修复7个迁移文件确保 shadow DB 全量回放零错误\n\n修复内容：\n1. 20260125000001_enable_pgvector_and_agent_groups\n   - 移除重复/冲突的索引定义，消除 shadow DB 回放时的语法冲突\n\n2. 20260126000000_sync_indexes_and_constraints\n   - 对索引创建语句进行幂等性保护（IF NOT EXISTS）\n   - 修复约束名称冲突问题\n\n3. 20260126000001_add_foreign_keys\n   - 将外键添加操作包裹在 DO 块内\n   - 检查列是否存在（如 parent_task_id）再添加外键，防止\"列不存在\"错误\n\n4. 20260214000002_expand_serial_number_sn_code_length\n   - 先 DROP 依赖视图 v_entitlements_expiring\n   - 执行 ALTER COLUMN sn_code TYPE VARCHAR(100)\n   - 重建视图，解决\"列被视图使用不能修改类型\"错误\n\n5. 20260215000003_migrate_bank_accounts_from_json\n   - 将迁移逻辑包裹在 DO 块内\n   - 检查 config_key 列是否存在后再执行，兼容 baseline 和 live DB 的列名差异\n\n6. 20260219000000_add_agent_audit_tables\n   - 在 CREATE TABLE agent_audit_logs 前添加条件 DROP\n   - 检查旧表标记列 action_type 存在时 DROP CASCADE，解决旧表无 status 列的问题\n\n7. 20260223000000_add_performance_indexes\n   - 将 idx_groupbuy_campaign_products_tenant_id_status 索引创建\n     包裹在 DO 块内，检查 status 列存在后再创建\n   - groupbuy_campaign_products 建表时未含 status 列，条件跳过\n\n验证：migrate deploy 在空数据库全量回放成功，\"All migrations have been successfully applied.\"\n","AuthorEmail":"laoluojuhai@users.noreply.github.com","AuthorName":"laoluojuhai","CommitterEmail":"laoluojuhai@users.noreply.github.com","CommitterName":"laoluojuhai","Timestamp":"2026-02-28T08:55:53+08:00"},"CompareURL":"luoanwu/juhi-omni-knowledge-hub/compare/2186d56d658fcaab3ff5ca5880742254dc8c4545...79d594dd776b47b40e6329ed3f6cf53c2b18251f","Len":1}

TEXT

created_unix

INTEGER

Update row 146 in action