fix: add migration for schedules CHECK constraint to include 'interval'

[threepointone]

Fixes #1061

The cf_agents_schedules table's CHECK constraint on type only allowed ('scheduled', 'delayed', 'cron'). DOs created before the interval scheduling feature would hit CHECK constraint failed when trying to use scheduleEvery() or keepAlive().

Changes

Migration (packages/agents/src/index.ts)

• Added migration that detects the old CHECK constraint via sqlite_master and recreates the table with 'interval' included, preserving all existing data
• Added defensive DROP TABLE IF EXISTS cf_agents_schedules_new to handle any leftover temp table
• Added execution_started_at and retry_options to the CREATE TABLE IF NOT EXISTS so new DOs get the full schema upfront

Tests (packages/agents/src/tests/migration.test.ts)
8 test cases covering:

1. Old CHECK constraint rejects type='interval' (reproduces the bug)
2. Migration updates constraint to allow 'interval'
3. Migration preserves existing row data
4. Migration updates DDL in sqlite_master
5. Intermediate state — columns exist but old CHECK (most common real-world path)
6. Leftover _new table from partial migration
7. All schedule types (scheduled, delayed, cron) survive migration
8. Idempotency — safe to run twice

[changeset-bot]

🦋 Changeset detected

Latest commit: 990bde8

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 1 package

Name	Type
agents	Patch

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

[pkg-pr-new]

Open in StackBlitz

npm i https://pkg.pr.new/agents@1063

npm i https://pkg.pr.new/@cloudflare/ai-chat@1063

npm i https://pkg.pr.new/@cloudflare/codemode@1063

npm i https://pkg.pr.new/hono-agents@1063

commit: 326d0ef