20260727000001_team_brain.sql |
Team Brain v1 — tables, RLS, RPCs |
20260728000001_team_brain_memory.sql |
P0 — apply next — remember / FTS / list_recent |
20260728000002_team_brain_watch_notes.sql |
P1 — asserts memory RPCs exist (watch is CLI poll) |
20260729000001_team_brain_embeddings.sql |
P2 — pgvector(768), vector search, set_memory_embedding |
20260729000002_team_brain_security.sql |
PR review — unique members, stronger invites, updated_at trigger |
20260729000003_team_brain_sync_mode.sql |
Sync mode — remember merge-on-source_ref; list_recent includes updates; enables vector if missing |
20260729000004_team_brain_invite_hygiene.sql |
PR review — join_team omits invite; whoami invite only for admin |
20260802000001_team_brain_learning_kind.sql |
#30 — learning kind; remember accepts correction-loop learnings |
20260803000001_team_brain_memory_history.sql |
#34 — capture_revisions; archive on source_ref update; list_memory_history / restore_memory |
20260804000001_team_brain_realtime_broadcast.sql |
#31 — signal-only Realtime Broadcast on capture write; memory_broadcast_topic |
20260805000001_team_brain_roles_and_invites.sql |
#40 — viewer role; write gates; rotate_invite / set_member_role; join p_role |
20260806000001_team_brain_rate_limits.sql |
#32 — DB-level rate limiting for register_team / join_team; sliding window; monitoring view |
20260807000001_team_brain_aggregate_metrics.sql |
#35 — team_aggregate_metrics RPC (coverage + reuse; no bodies / no BRAIN.md) |
20260808000001_team_brain_full_push_and_semantic_hardening.sql |
#31 (full push) closeout + hardening — per-team broadcast_key; encrypted body_ct on the Broadcast payload; remember 20000-char body cap; restore_memory clears stale ciphertext |
20260809000001_fix_tb_anon_fingerprint_digest.sql |
Fix — tb_anon_fingerprint uses extensions.digest (Supabase search_path) |
20260908000001_team_brain_delete_permissions.sql |
Workshop governance — delete_memory tombstone + tb_require_delete; list_members (admin); read RPCs exclude tombstones |
20260908120001_team_brain_pending_review.sql |
#67 — redundant-memory guard + memory_pending_submissions; list_pending_memories / approve_pending_memory / reject_pending_memory |