xNightR00T File Manager

CREATE TABLE IF NOT EXISTS devbar_requests (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    page_id VARCHAR(64) NOT NULL,
    url_id INTEGER,
    status_code INTEGER,
    method VARCHAR(8) NOT NULL,
    start_time BIGINT,
    request_time INTEGER,
    is_primary_page INTEGER,
    peak_memory_usage INTEGER,
    data_size INTEGER NOT NULL,
    memory_limit INTEGER,
    http_raw_post_data MEDIUMBLOB,
    raw_output MEDIUMBLOB,
    response_headers MEDIUMBLOB,
    request_headers MEDIUMBLOB
) ENGINE=Innodb;

CREATE INDEX IDX_DEVBAR_REQUESTS_PAGE_ID on devbar_requests (page_id);
CREATE INDEX IDX_DEVBAR_REQUESTS_URL_ID on devbar_requests (url_id);

CREATE TABLE IF NOT EXISTS devbar_requests_urls (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    url_hash TINYBLOB NOT NULL,
    url VARCHAR(2048) NOT NULL
) ;
CREATE UNIQUE INDEX IDX_DEVBAR_REQUESTS_URLS_HASH on devbar_requests_urls (url_hash(40));

CREATE TABLE IF NOT EXISTS devbar_sql_queries (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    request_id INTEGER NOT NULL,
    prepared_statement_id INTEGER,
    resolved_statement MEDIUMTEXT,
    status INTEGER,
    rows_affected INTEGER,
    query_time INTEGER,
    error_message VARCHAR(1024),
    transaction_id INTEGER,
    file_name VARCHAR(1024),
    line_number INTEGER,
    backtrace_id INTEGER	
);

CREATE INDEX IDX_DEVBAR_SQL_QUERIES_REQUEST_ID on devbar_sql_queries(request_id);
CREATE INDEX IDX_DEVBAR_SQL_QUERIES_TRANSACTION_ID on devbar_sql_queries(transaction_id);
CREATE INDEX IDX_DEVBAR_SQL_QUERIES_STMT_ID on devbar_sql_queries(prepared_statement_id);
CREATE INDEX IDX_DEVBAR_SQL_QUERIES_BACKTRACE_ID on devbar_sql_queries(backtrace_id);

CREATE TABLE IF NOT EXISTS devbar_sql_statements (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    statement_hash TINYBLOB NOT NULL,
    prepared_statement VARCHAR(2048) NOT NULL,
    statement_explain VARCHAR(2048)
);
CREATE UNIQUE INDEX IDX_DEVBAR_SQL_STATEMENTS_HASH on devbar_sql_statements (statement_hash(40));

CREATE TABLE IF NOT EXISTS devbar_processing_breakdown (
    request_id INTEGER PRIMARY KEY,
    database_time INTEGER,
    network_time INTEGER,
    local_time INTEGER,
    php_time INTEGER
);
CREATE INDEX IDX_DEVBAR_PROCESSING_BREAKDOWN_REQUEST_ID on devbar_processing_breakdown(request_id);

CREATE TABLE IF NOT EXISTS devbar_user_agent (
    id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(64) NOT NULL,
    version VARCHAR(64),
    user_agent_string VARCHAR(128)
);

CREATE TABLE IF NOT EXISTS devbar_log_entries (
    id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    entry_time INTEGER,
    request_id INTEGER NOT NULL,
    type VARCHAR(32),
    message VARCHAR(2048),
    filename VARCHAR(1024),
    line INTEGER,
    silenced INTEGER,
    backtrace_id INTEGER,
    sequence_id integer not null
);

CREATE INDEX IDX_DEVBAR_LOG_ENTRIES_TYPE on devbar_log_entries(type);
CREATE INDEX IDX_DEVBAR_LOG_ENTRIES_REQUEST_ID on devbar_log_entries(request_id);
CREATE INDEX IDX_DEVBAR_LOG_ENTRIES_BACKTRACE_ID on devbar_log_entries(backtrace_id);
CREATE INDEX IDX_DEVBAR_LOG_ENTRIES_SEQ_ID on devbar_log_entries(sequence_id);

CREATE TABLE IF NOT EXISTS devbar_functions_stats (
    id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    request_id INTEGER NOT NULL DEFAULT 0,
    function_name  VARCHAR(512) NOT NULL DEFAULT "",
    function_scope VARCHAR(128) NOT NULL DEFAULT "",
    times_called INTEGER DEFAULT 0,
    time_exclusive INTEGER DEFAULT 0,
    time_inclusive INTEGER DEFAULT 0,
    filename VARCHAR(1024) NOT NULL DEFAULT "",
    line INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX IDX_DEVBAR_FUNCTIONS_STATS_REQUEST on devbar_functions_stats(request_id);

CREATE UNIQUE INDEX IDX_BROWSERS_DICTIONARY_UNIQUE on devbar_user_agent(name, version);

CREATE TABLE IF NOT EXISTS devbar_monitor_events (
    id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    request_id INTEGER NOT NULL DEFAULT 0,
    agg_key varchar(32) NOT NULL
);
CREATE UNIQUE INDEX IDX_DEVBAR_MONITOR_EVENTS on devbar_monitor_events(request_id, agg_key);

CREATE TABLE IF NOT EXISTS devbar_superglobals_data (
    id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    request_id INTEGER NOT NULL,
    sg_name varchar(16) NOT NULL,
    data MEDIUMBLOB,
    sample_type VARCHAR(16) NOT NULL
);
CREATE INDEX IDX_DEVBAR_SUPERGLOBALS_DATA_REQUEST_SG_NAME on devbar_superglobals_data(request_id, sg_name);

CREATE TABLE IF NOT EXISTS devbar_tokens (
                id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                token_id varchar(128) not null,
                allowed_hosts text,
                ttl integer default 0,
                base_url text,
                title varchar(255) default ''
                );
CREATE INDEX IDX_DEVBAR_DEVBAR_TOKENS_1 on devbar_tokens(token_id);

create table if not exists devbar_backtrace (
                id BIGINT not null primary key AUTO_INCREMENT,
                backtrace MEDIUMTEXT
                );

INSERT IGNORE INTO schema_properties VALUES('DEVBAR_SCHEMA_VERSION', '2019.0.0');

CREATE TABLE if not exists devbar_exceptions (
                id BIGINT not null primary key AUTO_INCREMENT,
                request_id INTEGER NOT NULL,
                created_at INTEGER NOT NULL,
                exception_text mediumtext,
                exception_code text,
                class_type text,
                file_name text,
                line_number integer default -1,
                backtrace_id INTEGER NOT NULL,
                sequence_id integer not null);

CREATE INDEX IDX_devbar_exceptions_1 on devbar_exceptions(request_id);
CREATE INDEX IDX_devbar_exceptions_2 on devbar_exceptions(backtrace_id);
CREATE INDEX IDX_devbar_exceptions_3 on devbar_exceptions(sequence_id);

create table if not exists devbar_user_data (
              id BIGINT not null primary key AUTO_INCREMENT,
              request_id integer not null,
              namespace varchar(255) default '',
              data_type varchar(255) default '',
              row_index varchar(255) default '',
              serialized_data MEDIUMBLOB);
CREATE INDEX IDX_devbar_user_data_1 on devbar_user_data(data_type);
CREATE INDEX IDX_devbar_user_data_2 on devbar_user_data(request_id);
CREATE INDEX IDX_devbar_user_data_3 on devbar_user_data(namespace);
CREATE INDEX IDX_devbar_user_data_4 on devbar_user_data(row_index);

create table if not exists devbar_extension_metadata (id BIGINT not null primary key AUTO_INCREMENT,
                                                      request_id INTEGER NOT NULL,
                                                      namespace varchar(255) default '', 
                                                      serialized_data MEDIUMBLOB);
CREATE INDEX IDX_devbar_extension_metadata_1 on devbar_extension_metadata(request_id);
CREATE INDEX IDX_devbar_extension_metadata_2 on devbar_extension_metadata(namespace);

CREATE TABLE IF NOT EXISTS devbar_access_tokens (id BIGINT not null primary key AUTO_INCREMENT,
                                                 name varchar(255) default '',
                                                 token varchar(255) default '', 
                                                 run_actions integer NOT NULL default 0,
                                                 inject  integer NOT NULL default 0,
                                                 allowed_hosts text,
                                                 base_url text,
                                                 ttl integer
                                                 );
CREATE INDEX IDX_devbar_access_tokens_1 on devbar_access_tokens(name);