max / goingson

337 B · 6 lines History Blame Raw

1	-- Implicit contacts: auto-created when sending to a new address.
2	-- Not shown in the contacts UI; appear in autocomplete only.
3	-- Promoted to explicit (is_implicit = 0) when user saves them.
4	ALTER TABLE contacts ADD COLUMN is_implicit INTEGER NOT NULL DEFAULT 0;
5	CREATE INDEX idx_contacts_is_implicit ON contacts(user_id, is_implicit);
6