Drizzle: Schema für MailAccounts, Folders, Messages #103

New issue

Closed

opened 2026-04-26 23:00:56 +02:00 by admin-mrrm · 0 comments

admin-mrrm commented

2026-04-26 23:00:56 +02:00

Owner

Ziel

DB-Schema für IMAP-Daten anlegen.

Tables

mail_accounts: id, user_id, label, host, port, tls, username, encrypted_password, created_at
mail_folders: id, account_id, name, delimiter, flags, uid_validity
mail_messages_cache: id, folder_id, uid, subject, from, to, date, flags, body_text, body_html, fetched_at

Akzeptanzkriterien

Drizzle-Schema-Dateien im shared-db-Package
Migration generiert und ausführbar
Indexes auf (account_id, folder_id, uid)

## Ziel DB-Schema für IMAP-Daten anlegen. ## Tables - `mail_accounts`: id, user_id, label, host, port, tls, username, encrypted_password, created_at - `mail_folders`: id, account_id, name, delimiter, flags, uid_validity - `mail_messages_cache`: id, folder_id, uid, subject, from, to, date, flags, body_text, body_html, fetched_at ## Akzeptanzkriterien - [ ] Drizzle-Schema-Dateien im shared-db-Package - [ ] Migration generiert und ausführbar - [ ] Indexes auf (account_id, folder_id, uid)