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