audit.sql

Java的框架

USE PRRM;

CREATE TABLE IF NOT EXISTS SESSION_LOG (
    SESSION_ID VARCHAR(255) NOT NULL PRIMARY KEY,
    USERNAME VARCHAR(20) NOT NULL,
    LOGIN_TIME DATETIME,
    LOGOUT_TIME DATETIME,
    IP_ADDR VARCHAR(255) NOT NULL,
    USER_AGENT VARCHAR(255) 
) 	ENGINE=INNODB
;