max / goingson

228 B · 6 lines History Blame Raw

1	-- Add is_archived column to emails table (SQLite)
2	ALTER TABLE emails ADD COLUMN is_archived INTEGER NOT NULL DEFAULT 0;
3
4	-- Create index for filtering archived emails
5	CREATE INDEX idx_emails_is_archived ON emails(is_archived);
6