CREATE TABLE session (
    id INT(11) NOT NULL PRIMARY KEY auto_increment,
    update_version INT(11) NOT NULL DEFAULT 0,
    cookie VARCHAR(64) NOT NULL,
    user INT(11),
    location VARCHAR(32),
    lastactivity TIMESTAMP NOT NULL,
    login TIMESTAMP NOT NULL,
    nextmfa INT(11) NOT NULL DEFAULT 1,
    FOREIGN KEY fk_session_user (user) REFERENCES user (id)
) ENGINE=InnoDB;

CREATE TABLE sessionalert (
    id INT(11) NOT NULL PRIMARY KEY auto_increment,
    update_version INT(11) NOT NULL DEFAULT 0,
    session INT(11) NOT NULL,
    type VARCHAR(10) NOT NULL,
    content BLOB,
    FOREIGN KEY fk_sessionalert_session (session) REFERENCES session (id)
) ENGINE=InnoDB;