--- changes from 7.0.0
ALTER TABLE system_access_log add column impersonated char(1);

ALTER TABLE system_access_log add column access_ip varchar(256);
ALTER TABLE system_sql_log    add column access_ip varchar(256);
ALTER TABLE system_change_log add column access_ip varchar(256);

ALTER TABLE system_sql_log    add column transaction_id varchar(256);
ALTER TABLE system_change_log add column transaction_id varchar(256);

ALTER TABLE system_sql_log    add column log_trace text;
ALTER TABLE system_change_log add column log_trace text;

ALTER TABLE system_sql_log    add column session_id varchar(256);
ALTER TABLE system_change_log add column session_id varchar(256);

ALTER TABLE system_sql_log    add column php_sapi varchar(256);
ALTER TABLE system_change_log add column php_sapi varchar(256);

ALTER TABLE system_sql_log    add column class_name varchar(256);
ALTER TABLE system_change_log add column class_name varchar(256);

ALTER TABLE system_sql_log    add column request_id varchar(256);

CREATE TABLE system_request_log (
    id INTEGER PRIMARY KEY NOT NULL,
    endpoint varchar(4096),
    logdate varchar(256),
    log_year varchar(4),
    log_month varchar(2),
    log_day varchar(2),
    session_id varchar(256),
    login varchar(256),
    access_ip varchar(256),
    class_name varchar(256),
    http_host varchar(256),
    server_port varchar(256),
    request_uri text,
    request_method varchar(256),
    query_string text,
    request_headers text,
    request_body text,
    request_duration INT
);

ALTER TABLE system_access_log ADD COLUMN login_year varchar(4);
ALTER TABLE system_access_log ADD COLUMN login_month varchar(2);
ALTER TABLE system_access_log ADD COLUMN login_day varchar(2);

ALTER TABLE system_sql_log ADD COLUMN log_year varchar(4);
ALTER TABLE system_sql_log ADD COLUMN log_month varchar(2);
ALTER TABLE system_sql_log ADD COLUMN log_day varchar(2);

ALTER TABLE system_change_log ADD COLUMN log_year varchar(4);
ALTER TABLE system_change_log ADD COLUMN log_month varchar(2);
ALTER TABLE system_change_log ADD COLUMN log_day varchar(2);

--- changes from 7.4.0
ALTER TABLE system_access_log ADD COLUMN impersonated_by varchar(256);

CREATE TABLE system_access_notification_log (
    id INTEGER PRIMARY KEY NOT NULL,
    login varchar(256),
    email varchar(256),
    ip_address varchar(256),
    login_time varchar(256)
);

--- changes from 7.6.0
ALTER TABLE system_request_log ADD COLUMN class_method varchar(256);

--CREATE INDEX sys_change_log_login_idx ON system_change_log(login);
CREATE INDEX sys_change_log_date_idx ON system_change_log(logdate);
CREATE INDEX sys_change_log_year_idx ON system_change_log(log_year);
CREATE INDEX sys_change_log_month_idx ON system_change_log(log_month);
CREATE INDEX sys_change_log_day_idx ON system_change_log(log_day);
CREATE INDEX sys_change_log_class_idx ON system_change_log(class_name(100));
CREATE INDEX sys_change_log_table_idx ON system_change_log(tablename(100));

CREATE INDEX sys_sql_log_login_idx ON system_sql_log(login(100));
CREATE INDEX sys_sql_log_date_idx ON system_sql_log(logdate);
CREATE INDEX sys_sql_log_database_idx ON system_sql_log(database_name(100));
CREATE INDEX sys_sql_log_class_idx ON system_sql_log(class_name(100));
CREATE INDEX sys_sql_log_year_idx ON system_sql_log(log_year);
CREATE INDEX sys_sql_log_month_idx ON system_sql_log(log_month);
CREATE INDEX sys_sql_log_day_idx ON system_sql_log(log_day);

CREATE INDEX sys_access_log_login_idx ON system_access_log(login(100));
CREATE INDEX sys_access_log_year_idx ON system_access_log(login_year);
CREATE INDEX sys_access_log_month_idx ON system_access_log(login_month);
CREATE INDEX sys_access_log_day_idx ON system_access_log(login_day);

CREATE INDEX sys_request_log_login_idx ON system_request_log(login(100));
CREATE INDEX sys_request_log_date_idx ON system_request_log(logdate(100));
CREATE INDEX sys_request_log_year_idx ON system_request_log(log_year);
CREATE INDEX sys_request_log_month_idx ON system_request_log(log_month);
CREATE INDEX sys_request_log_day_idx ON system_request_log(log_day);
CREATE INDEX sys_request_log_class_idx ON system_request_log(class_name(100));
CREATE INDEX sys_request_log_method_idx ON system_request_log(class_method(100));

CREATE INDEX sys_access_notification_log_login_idx ON system_access_notification_log(login(100));
