CREATE TABLE IF NOT EXISTS %tpl_prefix%userdata (
    id
        INTEGER UNSIGNED
        NOT NULL
        AUTO_INCREMENT,
    sessid  VARCHAR(64) NOT NULL,
    token   VARCHAR(40) NOT NULL,
    created INTEGER UNSIGNED NOT NULL,
    expires INTEGER UNSIGNED NOT NULL,
    flash   TINYINT(1) DEFAULT 0,
    clau    VARCHAR(90) NOT NULL,
    valor   BLOB DEFAULT NULL,
    PRIMARY KEY (id),
    KEY (sessid, token),
    UNIQUE KEY (sessid, token, clau)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;