-- Sign-in with an external account (hub spec §5.1.2, #106): which

-- provider subject is which account, and the login name there.

CREATE TABLE account_logins (

    provider    TEXT NOT NULL,

    subject     TEXT NOT NULL,

    account_id  INTEGER NOT NULL REFERENCES accounts(id) ON DELETE CASCADE,

    login       TEXT NOT NULL DEFAULT '',

    linked_ms   INTEGER NOT NULL,

    PRIMARY KEY (provider, subject)

);

CREATE INDEX account_logins_by_account ON account_logins (account_id);