Drizzle: mail_archive_link Schema + Migration #277

New issue

Closed

opened 2026-05-14 22:33:40 +02:00 by admin-mrrm · 0 comments

admin-mrrm commented

2026-05-14 22:33:40 +02:00

Owner

Neue Tabelle in apps/api/src/modules/mail/mail.schema.ts (oder eigene Schema-Datei):

mail_archive_link:

id (uuid pk)
account_id (fk → mail_accounts)
folder (text)
message_uid (text)
paperless_document_id (int)
archived_at (timestamp)
unique index (account_id, folder, message_uid)

Migration via drizzle-kit generieren und committen.

Zweck: "bereits archiviert"-Indikator in Mail-Liste, ohne erneuten Paperless-Roundtrip.

Neue Tabelle in `apps/api/src/modules/mail/mail.schema.ts` (oder eigene Schema-Datei): `mail_archive_link`: - id (uuid pk) - account_id (fk → mail_accounts) - folder (text) - message_uid (text) - paperless_document_id (int) - archived_at (timestamp) - unique index (account_id, folder, message_uid) Migration via `drizzle-kit` generieren und committen. Zweck: "bereits archiviert"-Indikator in Mail-Liste, ohne erneuten Paperless-Roundtrip.