jiang 33df25f22b fix(tasks): isolate worker execution scopes ...

Persist a required Server-owned execution scope and enforce it for listing, claiming, lease recovery and SCADA verification. Backfill existing tasks explicitly through migration 034 so local development workers no longer claim production tasks from the shared database.

2026-11-08 01:54:48 +08:00

..

create

refactor(db): retain scheme start time as text

2026-08-03 11:18:38 +08:00

drop

refactor(db): align project template schema

2026-08-03 10:39:31 +08:00

003_normalize_timestamp_columns.sql

refactor(db): retain scheme start time as text

2026-08-03 11:18:38 +08:00

004_metadata_auth_management.sql

fix(db): enforce metadata membership foreign keys

2026-08-06 20:32:57 +08:00

005_metadata_project_configuration.sql

feat(scada): add project monitoring replay

2026-11-04 14:27:21 +08:00

006_metadata_rbac_roles.sql

feat(server): add project RBAC and guarded workflows

2026-07-30 16:45:09 +08:00

008_workbench_alert_events.sql

feat(workbench): add runtime GIS and sample integrations

2026-09-22 10:44:31 +08:00

009_analysis_runtime_query_indexes.sql

feat(workbench): add runtime GIS and sample integrations

2026-09-22 10:44:31 +08:00

010_source_gis_inventory.sql

feat(workbench): add runtime GIS and sample integrations

2026-09-22 10:44:31 +08:00

011_workbench_work_orders.sql

feat(workbench): add dynamic task approval lifecycle

2026-09-24 16:36:12 +08:00

012_peripheral_demo_v2.sql

feat(workbench): add runtime GIS and sample integrations

2026-09-22 10:44:31 +08:00

013_fengxian_map_layers.sql

feat(workbench): add runtime GIS and sample integrations

2026-09-22 10:44:31 +08:00

014_operational_tasks.sql

feat(workbench): persist operational workflows and events

2026-09-24 04:19:02 +08:00

015_workbench_events_and_task_runs.sql

feat: extend operational investigation workflows

2026-10-30 17:30:19 +08:00

016_metadata_service_identities.sql

feat(workbench): persist operational workflows and events

2026-09-24 04:19:02 +08:00

017_workbench_schema_comments.sql

feat(db): add workbench schema comments

2026-09-24 10:33:12 +08:00

018_remove_synthetic_check_task_projections.sql

fix(workbench): remove synthetic check projections

2026-09-24 12:01:01 +08:00

019_operational_task_access_requests.sql

feat(workbench): add dynamic task approval lifecycle

2026-09-24 16:36:12 +08:00

020_prune_non_actionable_notifications.sql

feat(workbench): keep only actionable notifications

2026-09-24 15:18:18 +08:00

021_retire_workbench_work_orders.sql

feat(workbench): add dynamic task approval lifecycle

2026-09-24 16:36:12 +08:00

022_operational_notification_lifecycle.sql

feat(workbench): add dynamic task approval lifecycle

2026-09-24 16:36:12 +08:00

023_operational_task_progress.sql

feat(server): integrate MCP queries and investigation messaging

2026-10-19 18:46:58 +08:00

024_agent_messages.sql

feat(server): integrate MCP queries and investigation messaging

2026-10-19 18:46:58 +08:00

025_mcp_query_contexts.sql

feat(server): integrate MCP queries and investigation messaging

2026-10-19 18:46:58 +08:00

026_calculation_jobs.sql

feat(mcp): queue long-running calculations

2026-10-29 18:25:15 +08:00

027_calculation_job_lifecycle.sql

feat: extend operational investigation workflows

2026-10-30 17:30:19 +08:00

028_task_questions.sql

feat: extend operational investigation workflows

2026-10-30 17:30:19 +08:00

029_peripheral_work_orders_system_data.sql

feat: extend operational investigation workflows

2026-10-30 17:30:19 +08:00

030_operational_run_agent_ownership.sql

feat: extend operational investigation workflows

2026-10-30 17:30:19 +08:00

030_remove_calculation_queue_expiry.sql

feat(scada): add calibrated monitoring and incident recovery

2026-11-07 19:44:58 +08:00

031_scada_replays.sql

feat(scada): add project monitoring replay

2026-11-04 14:27:21 +08:00

033_metadata_project_settings.sql

feat(scada): add project monitoring replay

2026-11-04 14:27:21 +08:00

034_operational_task_execution_scope.sql

fix(tasks): isolate worker execution scopes

2026-11-08 01:54:48 +08:00