DROP TABLE openid_users;
CREATE TABLE IF NOT EXISTS openid_users
(
    id          INTEGER PRIMARY KEY NOT NULL,
    name        TEXT                NOT NULL,
    application TEXT                NOT NULL,
    appkey     TEXT                NOT NULL,
    userid      INTEGER             NOT NULL,
    description TEXT                NOT NULL,
    created     TEXT                NOT NULL,
    lastaccess  TEXT                NOT NULL
);
CREATE UNIQUE INDEX idx_openid_app_name
ON openid_users (application,name);