version-005.sql 288 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13

--
-- Create ContactTable for autocompletion contacts. Data is migrated in vala upgrade hooks.
--

CREATE TABLE ContactTable (
    id INTEGER PRIMARY KEY,
    normalized_email TEXT NOT NULL,
    real_name TEXT,
    email TEXT UNIQUE NOT NULL,
    highest_importance INTEGER NOT NULL
);