Skip to main content

max / goingson

365 B · 10 lines History Blame Raw
1 CREATE TABLE IF NOT EXISTS imap_folder_sync_state (
2 email_account_id TEXT NOT NULL,
3 folder_name TEXT NOT NULL,
4 uid_validity INTEGER NOT NULL,
5 last_seen_uid INTEGER NOT NULL DEFAULT 0,
6 updated_at TEXT NOT NULL,
7 PRIMARY KEY (email_account_id, folder_name),
8 FOREIGN KEY (email_account_id) REFERENCES email_accounts(id) ON DELETE CASCADE
9 );
10