highperfocused/multica
1
0
Fork 0
mirror of https://github.com/multica-ai/multica.git synced 2026-07-28 05:46:58 +02:00
Code Issues Packages Projects Releases Wiki Activity
Files
agent/lambda/44dba9ce
multica/server/migrations
History
Jiayuan 5552f96e4c fix(migrations): drop CHECK constraint before updating rows 
The UP migration tried to UPDATE status values while the old
constraint still only allowed 'in_review', causing a CHECK
violation. Reorder to: drop constraint → update rows → add new
constraint. Same fix applied to the DOWN migration.

Co-authored-by: multica-agent <github@multica.ai>
2026-05-02 08:04:47 +02:00
..
001_init.down.sql
…
001_init.up.sql
feat: rename issue status in_review to needs_review
2026-05-02 08:00:45 +02:00
002_agent_config.down.sql
…
002_agent_config.up.sql
…
003_task_context.down.sql
…
003_task_context.up.sql
…
004_agent_runtime_loop.down.sql
…
004_agent_runtime_loop.up.sql
…
005_daemon_pairing.down.sql
…
005_daemon_pairing.up.sql
…
006_workspace_context.down.sql
…
006_workspace_context.up.sql
…
007_drop_issue_repository.down.sql
refactor: remove repository field from issues
2026-03-24 18:12:06 +08:00
007_drop_issue_repository.up.sql
refactor: remove repository field from issues
2026-03-24 18:12:06 +08:00
008_structured_skills.down.sql
feat: structured skills system with meta skill runtime injection
2026-03-25 15:17:59 +08:00
008_structured_skills.up.sql
feat: structured skills system with meta skill runtime injection
2026-03-25 15:17:59 +08:00
009_verification_code.down.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
009_verification_code.up.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
010_verification_code_attempts.down.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
010_verification_code_attempts.up.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
011_personal_access_tokens.down.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
011_personal_access_tokens.up.sql
feat(auth): email verification login and personal access tokens
2026-03-26 14:32:30 +08:00
012_inbox_actor.down.sql
fix(db): renumber inbox_actor migration to resolve 009 conflict
2026-03-26 15:44:10 +08:00
012_inbox_actor.up.sql
fix(db): make inbox_actor migration idempotent
2026-03-26 17:17:23 +08:00
013_runtime_usage.down.sql
feat(runtimes): add Runtimes tab with usage tracking and connection test
2026-03-26 18:28:36 +08:00
013_runtime_usage.up.sql
feat(runtimes): add Runtimes tab with usage tracking and connection test
2026-03-26 18:28:36 +08:00
014_workspace_repos.down.sql
feat(workspace): add repos JSONB field for GitHub repository URLs
2026-03-27 15:49:30 +08:00
014_workspace_repos.up.sql
feat(workspace): add repos JSONB field for GitHub repository URLs
2026-03-27 15:49:30 +08:00
015_issue_subscriber.down.sql
feat(notifications): replace hardcoded inbox notifications with subscriber-driven model
2026-03-28 19:33:20 +08:00
015_issue_subscriber.up.sql
feat(notifications): replace hardcoded inbox notifications with subscriber-driven model
2026-03-28 19:33:20 +08:00
016_backfill_subscribers.down.sql
feat(notifications): replace hardcoded inbox notifications with subscriber-driven model
2026-03-28 19:33:20 +08:00
016_backfill_subscribers.up.sql
fix(notifications): address code review feedback
2026-03-28 20:24:07 +08:00
017_comment_parent_id.down.sql
feat(activity): unified activity timeline with comment reply support
2026-03-28 21:53:08 +08:00
017_comment_parent_id.up.sql
feat(activity): unified activity timeline with comment reply support
2026-03-28 21:53:08 +08:00
018_comment_parent_cascade.down.sql
fix(comments): cascade delete replies in DB when parent comment is deleted
2026-03-28 22:04:35 +08:00
018_comment_parent_cascade.up.sql
fix(comments): cascade delete replies in DB when parent comment is deleted
2026-03-28 22:04:35 +08:00
019_inbox_details.down.sql
feat(inbox): add priority/due_date notifications, structured details, and hover card
2026-03-29 00:22:17 +08:00
019_inbox_details.up.sql
feat(inbox): add priority/due_date notifications, structured details, and hover card
2026-03-29 00:22:17 +08:00
020_issue_number.down.sql
feat(issues): add human-readable issue identifiers (e.g. JIA-1)
2026-03-29 16:49:55 +08:00
020_issue_number.up.sql
feat(issues): add human-readable issue identifiers (e.g. JIA-1)
2026-03-29 16:49:55 +08:00
020_task_session.down.sql
feat(agent): add per-task session persistence for Claude Code resumption
2026-03-29 16:53:28 +08:00
020_task_session.up.sql
feat(agent): add per-task session persistence for Claude Code resumption
2026-03-29 16:53:28 +08:00
021_agent_instructions.down.sql
feat(agent): add instructions field for agent persona/identity
2026-03-29 17:01:07 +08:00
021_agent_instructions.up.sql
feat(agent): add instructions field for agent persona/identity
2026-03-29 17:01:07 +08:00
022_task_lifecycle_guards.down.sql
feat(tasks): add coalescing queue and task lifecycle guards
2026-03-29 17:52:35 +08:00
022_task_lifecycle_guards.up.sql
feat(tasks): add coalescing queue and task lifecycle guards
2026-03-29 17:52:35 +08:00
023_agent_concurrency_default.down.sql
fix(daemon): prevent stuck tasks from blocking queue and add concurrent execution
2026-03-30 03:08:52 +08:00
023_agent_concurrency_default.up.sql
fix(daemon): prevent stuck tasks from blocking queue and add concurrent execution
2026-03-30 03:08:52 +08:00
024_backfill_empty_issue_prefix.down.sql
fix(handler): set issue_prefix when auto-creating workspace on first login
2026-03-30 13:26:42 +08:00
024_backfill_empty_issue_prefix.up.sql
fix(handler): set issue_prefix when auto-creating workspace on first login
2026-03-30 13:26:42 +08:00
025_comment_workspace_id.down.sql
feat(api): strict workspace isolation + agent parity fixes
2026-03-30 16:49:13 +08:00
025_comment_workspace_id.up.sql
feat(api): strict workspace isolation + agent parity fixes
2026-03-30 16:49:13 +08:00
026_comment_reactions.down.sql
feat(reactions): add emoji reactions for comments and issue descriptions
2026-03-30 22:37:59 +08:00
026_comment_reactions.up.sql
feat(reactions): add emoji reactions for comments and issue descriptions
2026-03-30 22:37:59 +08:00
026_task_messages.down.sql
feat(agent): stream live agent output to issue detail page
2026-03-30 22:53:28 +08:00
026_task_messages.up.sql
feat(agent): stream live agent output to issue detail page
2026-03-30 22:53:28 +08:00
027_issue_reactions.down.sql
feat(reactions): add emoji reactions for comments and issue descriptions
2026-03-30 22:37:59 +08:00
027_issue_reactions.up.sql
feat(reactions): add emoji reactions for comments and issue descriptions
2026-03-30 22:37:59 +08:00
028_task_trigger_comment.down.sql
feat(agents): reply as thread instead of top-level comment (#205)
2026-03-31 13:48:39 +08:00
028_task_trigger_comment.up.sql
feat(agents): reply as thread instead of top-level comment (#205)
2026-03-31 13:48:39 +08:00
029_attachment.down.sql
feat(upload): add attachment table for tracking uploaded files
2026-03-31 15:29:41 +08:00
029_attachment.up.sql
feat(upload): add attachment table for tracking uploaded files
2026-03-31 15:29:41 +08:00
029_daemon_token.down.sql
fix(tests): merge main, renumber migration, fix execenv test assertions
2026-03-31 16:19:02 +08:00
029_daemon_token.up.sql
fix(tests): merge main, renumber migration, fix execenv test assertions
2026-03-31 16:19:02 +08:00
029_drop_daemon_pairing.down.sql
fix(auth): enforce auth on daemon API routes (#224)
2026-03-31 16:13:58 +08:00
029_drop_daemon_pairing.up.sql
fix(auth): enforce auth on daemon API routes (#224)
2026-03-31 16:13:58 +08:00
030_agent_default_private.down.sql
fix: merge main and renumber migration 028 → 030
2026-03-31 15:47:09 +08:00
030_agent_default_private.up.sql
fix: merge main and renumber migration 028 → 030
2026-03-31 15:47:09 +08:00
031_agent_archive.down.sql
feat(agent): replace hard delete with archive/restore (#346)
2026-04-02 17:33:52 +08:00
031_agent_archive.up.sql
feat(agent): replace hard delete with archive/restore (#346)
2026-04-02 17:33:52 +08:00
032_drop_agent_triggers.down.sql
refactor: remove agent triggers config field (#469)
2026-04-07 22:02:28 +08:00
032_drop_agent_triggers.up.sql
refactor: remove agent triggers config field (#469)
2026-04-07 22:02:28 +08:00
032_issue_search_index.down.sql
feat(search): implement full-text search for issues (#507)
2026-04-09 12:43:21 +08:00
032_issue_search_index.up.sql
fix(search): make pg_bigm migration graceful when extension unavailable
2026-04-09 14:00:03 +08:00
032_runtime_owner.down.sql
feat(runtime): add owner tracking, filtering, and delete (#535)
2026-04-09 13:38:46 +08:00
032_runtime_owner.up.sql
feat(runtime): add owner tracking, filtering, and delete (#535)
2026-04-09 13:38:46 +08:00
032_task_usage.down.sql
feat(usage): add per-task token usage tracking
2026-04-08 13:08:15 +08:00
032_task_usage.up.sql
feat(usage): add per-task token usage tracking
2026-04-08 13:08:15 +08:00
033_chat.down.sql
feat(chat): add agent chat feature (full stack)
2026-04-09 14:19:46 +08:00
033_chat.up.sql
fix(chat): add workspace scoping, error logging, and query cleanup
2026-04-09 17:18:14 +08:00
033_comment_search_index.down.sql
feat(search): implement full-text search for issues (#507)
2026-04-09 12:43:21 +08:00
033_comment_search_index.up.sql
fix(search): make pg_bigm migration graceful when extension unavailable
2026-04-09 14:00:03 +08:00
034_projects.down.sql
feat(projects): add Project entity with full-stack CRUD support (#552)
2026-04-09 14:59:16 +08:00
034_projects.up.sql
feat(projects): add Project entity with full-stack CRUD support (#552)
2026-04-09 14:59:16 +08:00
035_project_priority.down.sql
feat(projects): add priority attribute to projects (#565)
2026-04-09 16:31:05 +08:00
035_project_priority.up.sql
feat(projects): add priority attribute to projects (#565)
2026-04-09 16:31:05 +08:00
035_task_queue_issue_id_index.down.sql
feat(issues): display token usage per issue in detail sidebar (#581)
2026-04-10 14:34:32 +08:00
035_task_queue_issue_id_index.up.sql
feat(issues): display token usage per issue in detail sidebar (#581)
2026-04-10 14:34:32 +08:00
036_search_index_lower.down.sql
fix(search): LOWER/LIKE for pg_bigm 1.2 index compatibility (#621)
2026-04-10 14:29:00 +08:00
036_search_index_lower.up.sql
fix(search): LOWER/LIKE for pg_bigm 1.2 index compatibility (#621)
2026-04-10 14:29:00 +08:00
037_fix_pending_task_unique_index.down.sql
fix(db): relax pending task unique index to per-(issue, agent) (#637)
2026-04-10 16:21:20 +08:00
037_fix_pending_task_unique_index.up.sql
fix(db): relax pending task unique index to per-(issue, agent) (#637)
2026-04-10 16:21:20 +08:00
038_pinned_items.down.sql
feat: add pin to sidebar for issues and projects (#653)
2026-04-10 19:00:25 +08:00
038_pinned_items.up.sql
feat: add pin to sidebar for issues and projects (#653)
2026-04-10 19:00:25 +08:00
039_project_search_index.down.sql
feat(search): add project search support to Cmd+K search (#663)
2026-04-10 20:59:32 +08:00
039_project_search_index.up.sql
feat(search): add project search support to Cmd+K search (#663)
2026-04-10 20:59:32 +08:00
040_agent_custom_env.down.sql
feat(agent): support custom environment variables for router/proxy mode
2026-04-13 16:47:56 +08:00
040_agent_custom_env.up.sql
feat(agent): support custom environment variables for router/proxy mode
2026-04-13 16:47:56 +08:00
040_chat_unread_since.down.sql
feat(chat): redesign state, header, and unread tracking
2026-04-14 18:21:11 +08:00
040_chat_unread_since.up.sql
feat(chat): redesign state, header, and unread tracking
2026-04-14 18:21:11 +08:00
041_agent_custom_args.down.sql
feat(agent): add custom CLI arguments support (#986)
2026-04-15 14:58:53 +08:00
041_agent_custom_args.up.sql
feat(agent): add custom CLI arguments support (#986)
2026-04-15 14:58:53 +08:00
041_workspace_invitation.down.sql
feat(security): invitation acceptance flow for workspace members (#1019)
2026-04-15 00:01:18 +08:00
041_workspace_invitation.up.sql
feat(security): invitation acceptance flow for workspace members (#1019)
2026-04-15 00:01:18 +08:00
042_autopilot.down.sql
feat(autopilot): scheduled/triggered automations for AI agents (#1028)
2026-04-15 04:54:37 +08:00
042_autopilot.up.sql
feat(autopilot): scheduled/triggered automations for AI agents (#1028)
2026-04-15 04:54:37 +08:00
043_audit_reserved_slugs.down.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
043_audit_reserved_slugs.up.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
043_fix_orphaned_autopilot_runs.down.sql
refactor(autopilot): remove broken concurrency policies and fix multiple bugs (#1048)
2026-04-15 13:48:21 +08:00
043_fix_orphaned_autopilot_runs.up.sql
refactor(autopilot): remove broken concurrency policies and fix multiple bugs (#1048)
2026-04-15 13:48:21 +08:00
044_fix_workspace_fallback_slug.down.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
044_fix_workspace_fallback_slug.up.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
045_audit_dashboard_route_slugs.down.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
045_audit_dashboard_route_slugs.up.sql
Reapply "feat: workspace URL refactor v2 + rollback-safe compat layer (#1138)" (#1139) (#1141)
2026-04-16 13:16:35 +08:00
046_agent_mcp_config.down.sql
fix(agent): add per-agent mcp_config field to restore MCP access (#1168)
2026-04-18 01:35:22 +08:00
046_agent_mcp_config.up.sql
fix(agent): add per-agent mcp_config field to restore MCP access (#1168)
2026-04-18 01:35:22 +08:00
046_agent_unique_name.down.sql
fix(agent): return 409 on duplicate agent name (#1182)
2026-04-17 13:40:02 +08:00
046_agent_unique_name.up.sql
fix(agent): return 409 on duplicate agent name (#1182)
2026-04-17 13:40:02 +08:00
046_drop_runtime_usage.down.sql
refactor(runtime): derive runtime usage from task_usage only (#1167)
2026-04-16 18:54:12 +08:00
046_drop_runtime_usage.up.sql
refactor(runtime): derive runtime usage from task_usage only (#1167)
2026-04-16 18:54:12 +08:00
047_audit_extended_reserved_slugs.down.sql
fix(routing): rename /new-workspace to /workspaces/new + extend reserved slug list (#1188)
2026-04-16 21:21:20 +08:00
047_audit_extended_reserved_slugs.up.sql
fix(routing): rename /new-workspace to /workspaces/new + extend reserved slug list (#1188)
2026-04-16 21:21:20 +08:00
048_runtime_daemon_uuid.down.sql
feat(daemon): persistent UUID identity + legacy-id merge at register-time (#1220)
2026-04-17 15:10:38 +08:00
048_runtime_daemon_uuid.up.sql
feat(daemon): persistent UUID identity + legacy-id merge at register-time (#1220)
2026-04-17 15:10:38 +08:00
049_audit_legacy_reserved_slugs.down.sql
fix(slugs): audit admin/multica/new/www + reserve in slug list (MUL-972) (#1359)
2026-04-19 23:21:31 -07:00
049_audit_legacy_reserved_slugs.up.sql
fix(slugs): audit admin/multica/new/www + reserve in slug list (MUL-972) (#1359)
2026-04-19 23:21:31 -07:00
050_add_onboarded_at_to_users.down.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
050_add_onboarded_at_to_users.up.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
050_agent_model.down.sql
feat(agents): add per-agent model field with provider-aware dropdown (#1399)
2026-04-21 00:06:34 +08:00
050_agent_model.up.sql
feat(agents): add per-agent model field with provider-aware dropdown (#1399)
2026-04-21 00:06:34 +08:00
050_issue_first_executed_at.down.sql
feat(analytics): full PostHog pipeline + 6 funnel events (MUL-1122) (#1367)
2026-04-21 14:42:52 +08:00
050_issue_first_executed_at.up.sql
feat(analytics): full PostHog pipeline + 6 funnel events (MUL-1122) (#1367)
2026-04-21 14:42:52 +08:00
051_add_onboarding_state_to_users.down.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
051_add_onboarding_state_to_users.up.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
052_add_cloud_waitlist_to_users.down.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
052_add_cloud_waitlist_to_users.up.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
053_drop_orphan_onboarding_current_step.down.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
053_drop_orphan_onboarding_current_step.up.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
054_add_starter_content_state_to_users.down.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
054_add_starter_content_state_to_users.up.sql
feat(onboarding): redesigned flow + post-landing starter content opt-in (#1411)
2026-04-21 20:32:33 +08:00
055_task_lease_and_retry.down.sql
feat(server): orphan-task recovery + auto-retry + manual rerun (MUL-1128) (#1476)
2026-04-22 13:08:37 +08:00
055_task_lease_and_retry.up.sql
feat(server): orphan-task recovery + auto-retry + manual rerun (MUL-1128) (#1476)
2026-04-22 13:08:37 +08:00
056_audit_newly_reserved_slugs.down.sql
feat(slugs): reserve homepage + expand reserved slug list (MUL-961) (#1483)
2026-04-22 15:08:06 +08:00
056_audit_newly_reserved_slugs.up.sql
feat(slugs): reserve homepage + expand reserved slug list (MUL-961) (#1483)
2026-04-22 15:08:06 +08:00
057_feedback.down.sql
feat(feedback): in-app feedback flow + Help launcher (#1546)
2026-04-23 10:35:55 +08:00
057_feedback.up.sql
feat(feedback): in-app feedback flow + Help launcher (#1546)
2026-04-23 10:35:55 +08:00
058_drop_autopilot_priority_and_project_id.down.sql
feat(autopilot): redesign modal — simpler schema, consistent schedule UI (#1595)
2026-04-24 11:05:33 +08:00
058_drop_autopilot_priority_and_project_id.up.sql
feat(autopilot): redesign modal — simpler schema, consistent schedule UI (#1595)
2026-04-24 11:05:33 +08:00
059_label_timestamps.down.sql
feat(labels): ship issue labels (closes #1191) (#1233)
2026-04-27 14:23:42 +08:00
059_label_timestamps.up.sql
feat(labels): ship issue labels (closes #1191) (#1233)
2026-04-27 14:23:42 +08:00
060_agent_description_length.down.sql
feat(agent): presence v3 + execution log + trigger summary (#1823)
2026-04-29 14:50:58 +08:00
060_agent_description_length.up.sql
feat(agent): presence v3 + execution log + trigger summary (#1823)
2026-04-29 14:50:58 +08:00
060_issue_origin_quick_create.down.sql
feat: quick-create issue (async agent + inbox completion) (#1786)
2026-04-29 14:05:26 +08:00
060_issue_origin_quick_create.up.sql
feat: quick-create issue (async agent + inbox completion) (#1786)
2026-04-29 14:05:26 +08:00
061_task_trigger_summary.down.sql
feat(agent): presence v3 + execution log + trigger summary (#1823)
2026-04-29 14:50:58 +08:00
061_task_trigger_summary.up.sql
feat(agent): presence v3 + execution log + trigger summary (#1823)
2026-04-29 14:50:58 +08:00
062_chat_message_failure_reason.down.sql
feat(chat): presence v4 — status pill, failure bubble, elapsed timing (#1856)
2026-04-29 18:29:46 +08:00
062_chat_message_failure_reason.up.sql
feat(chat): presence v4 — status pill, failure bubble, elapsed timing (#1856)
2026-04-29 18:29:46 +08:00
063_chat_message_elapsed.down.sql
feat(chat): presence v4 — status pill, failure bubble, elapsed timing (#1856)
2026-04-29 18:29:46 +08:00
063_chat_message_elapsed.up.sql
feat(chat): presence v4 — status pill, failure bubble, elapsed timing (#1856)
2026-04-29 18:29:46 +08:00
064_notification_preference.down.sql
feat(inbox): add notification preferences to control inbox noise by event type (#1906)
2026-04-29 22:51:29 +02:00
064_notification_preference.up.sql
feat(inbox): add notification preferences to control inbox noise by event type (#1906)
2026-04-29 22:51:29 +02:00
065_backfill_onboarded_at.down.sql
fix(onboarding): decouple from workspace state and route invitees correctly (#1936)
2026-04-30 16:05:53 +08:00
065_backfill_onboarded_at.up.sql
fix(onboarding): decouple from workspace state and route invitees correctly (#1936)
2026-04-30 16:05:53 +08:00
065_project_resources.down.sql
feat(projects): typed project resources + agent runtime injection (#1926)
2026-04-30 14:00:43 +08:00
065_project_resources.up.sql
feat(projects): typed project resources + agent runtime injection (#1926)
2026-04-30 14:00:43 +08:00
066_force_fresh_session.down.sql
fix(task): rerun starts a fresh session, skip poisoned resume (#1928)
2026-04-30 14:17:53 +08:00
066_force_fresh_session.up.sql
fix(task): rerun starts a fresh session, skip poisoned resume (#1928)
2026-04-30 14:17:53 +08:00
067_task_queue_claim_candidate_index.down.sql
feat(daemon): Redis empty-claim fast path for /tasks/claim polling (#1860)
2026-04-30 15:50:05 +08:00
067_task_queue_claim_candidate_index.up.sql
feat(daemon): Redis empty-claim fast path for /tasks/claim polling (#1860)
2026-04-30 15:50:05 +08:00
068_rename_in_review_to_needs_review.down.sql
fix(migrations): drop CHECK constraint before updating rows
2026-05-02 08:04:47 +02:00
068_rename_in_review_to_needs_review.up.sql
fix(migrations): drop CHECK constraint before updating rows
2026-05-02 08:04:47 +02:00