Task 16: Extend Drizzle schema with outbox table
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 78/100
- Issue type
- Feature
- Clarity
- Clearly specified
- Activity status
- Quiet
- Tech stack
- bun, typescript
- Domain
- database
Research direction
Update src/lib/db/schema.ts with the specified outbox table and index. Run bunx drizzle-kit generate --name=add-outbox and inspect the generated 0002_add_outbox.sql. Done means the schema includes all listed columns, the pending-by-account index is present, and the migration SQL matches the change.
Written by the indexing model from the issue text.
Description
Add outbox table to src/lib/db/schema.ts. Columns: id, provider, account_email, operation, payload_json, change_key_expected, provider_event_id, status, retry_count, error_message, error_code, last_attempt_at, created_at, updated_at. Index outbox_pending_by_account_idx on (status, provider, account_email).
Run bunx drizzle-kit generate --name=add-outbox → 0002_add_outbox.sql. Verify migration SQL.
Plan §Task 16.
- Dominant language
- TypeScript
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from swissonid/zero-line
-
Difficulty 1/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
-
Difficulty 1/5 Under an hour Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
All issues in swissonid/zero-line
Similar issues
-
calcite-components needs triage refactor
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
Esri/calcite-design-system#15203 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 91/100
-
community first-timers-only good first issue hacktoberfest help wanted low hanging fruit up-for-grabs
Difficulty 1/5 Under an hour Newbie friendliness 95/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Automattic/studio#4908 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 90/100