xNightR00T File Manager

CREATE TABLE IF NOT EXISTS GUI_AVAILABLE_LOGS (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	FILEPATH VARCHAR,
	DIRECTIVE VARCHAR,
	ENABLED INTEGER DEFAULT 1
);

CREATE TABLE IF NOT EXISTS GUI_USERS (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	PASSWORD VARCHAR NOT NULL,
	ROLE VARCHAR NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_LDAP_GROUPS (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	LDAP_GROUP VARCHAR NOT NULL,
	LINK_TYPE INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_WEBAPI_KEYS (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	HASH VARCHAR NOT NULL,
	USERNAME VARCHAR NOT NULL,
	CREATION_TIME INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_METADATA (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	DATA VARCHAR NOT NULL,
	CDATE INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_SNAPSHOTS (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	TYPE INTEGER DEFAULT 0,
	DATA BLOB NOT NULL,
	CREATION_TIME INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_LIBRARY_UPDATES (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	VERSION VARCHAR NOT NULL,
	EXTRA_DATA VARCHAR(1024),
	CREATION_TIME INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_PLUGIN_UPDATES (
	ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	NAME VARCHAR NOT NULL,
	VERSION VARCHAR NOT NULL,
	EXTRA_DATA VARCHAR(1024),
	CREATION_TIME INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL
);

CREATE TABLE IF NOT EXISTS GUI_FILTERS (id INTEGER PRIMARY KEY AUTOINCREMENT ,filter_type VARCHAR NOT NULL, name VARCHAR, data TEXT, custom INTEGER DEFAULT 0);

CREATE TABLE IF NOT EXISTS GUI_ACL_ROLES (role_id INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , role_name VARCHAR, role_parent INTEGER);

CREATE TABLE IF NOT EXISTS GUI_ACL_RESOURCES (resource_id INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , resource_name VARCHAR NOT NULL );

CREATE TABLE IF NOT EXISTS GUI_ACL_PRIVILEGES (role_id INTEGER NOT NULL , resource_id INTEGER NOT NULL , allow VARCHAR);


INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('codetracing', '/usr/local/zend/var/log/codetracing.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('datacache', '/usr/local/zend/var/log/datacache.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('deployment', '/usr/local/zend/var/log/deployment.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('jobqueue', '/usr/local/zend/var/log/jobqueue.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('jqd', '/usr/local/zend/var/log/jqd.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('monitor', '/usr/local/zend/var/log/monitor.log',NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('monitor_node', '/usr/local/zend/var/log/monitor_node.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('statsd', '/usr/local/zend/var/log/statsd.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('monitor_ui', '/usr/local/zend/var/log/monitor_ui.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('pagecache', '/usr/local/zend/var/log/pagecache.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('php', NULL,'error_log');
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('sc', '/usr/local/zend/var/log/sc.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('scd', '/usr/local/zend/var/log/scd.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('statistics', '/usr/local/zend/var/log/statistics.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('utils', '/usr/local/zend/var/log/utils.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zdd', '/usr/local/zend/var/log/zdd.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zem', '/usr/local/zend/var/log/zem.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zsd', '/usr/local/zend/var/log/zsd.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('access', '/usr/local/zend/var/log/access.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('error', '/usr/local/zend/var/log/error.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zend_server_ui', '/usr/local/zend/gui/lighttpd/logs/zend_server_ui.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zs-error', '/usr/local/zend/gui/lighttpd/logs/php.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zs_create_databases', '/usr/local/zend/var/log/zs_create_databases.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zray', '/usr/local/zend/var/log/zray.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zs_maintenance', '/usr/local/zend/var/log/zs_maintenance.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('url_insight', '/usr/local/zend/var/log/url_insight.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('url_insight_daemon', '/usr/local/zend/var/log/url_insight_daemon.log', NULL);
INSERT OR IGNORE INTO GUI_AVAILABLE_LOGS (NAME, FILEPATH, DIRECTIVE) VALUES ('zend_server_js', '/usr/local/zend/var/log/zend_server_js.log', NULL);

INSERT OR REPLACE into GUI_METADATA (NAME, DATA) values('gui_schema_version', '2019.0.0');

INSERT OR IGNORE into GUI_WEBAPI_KEYS (NAME, HASH, USERNAME, CREATION_TIME) values('zend-zsd', LOWER(HEX(RANDOM())), 'System Key', '1292428752');

INSERT OR IGNORE INTO GUI_FILTERS VALUES(1,'issue','Performance Issues','{"eventTypes":["function-slow-exec","request-slow-exec"]}',0);
INSERT OR IGNORE INTO GUI_FILTERS VALUES(2,'issue','Errors Issues','{"eventTypes":["function-error","zend-error","java-exception","jq-job-exec-error","tracer-write-file-fail","jq-job-logical-failure","custom"]}',0);
INSERT OR IGNORE INTO GUI_FILTERS VALUES(3,'issue','Resources Issues','{"eventTypes":["request-large-mem-usage","request-relative-large-out-size","jq-job-exec-delay"]}',0);
INSERT OR IGNORE INTO GUI_FILTERS VALUES(4,'job','Failed Jobs','{"status":["Logical failure", "Job timeout", "Backend not responding", "Target not found", "Runtime error", "Failed to start", "Failed predecessor", "Aborted"]}',0);
INSERT OR IGNORE INTO GUI_FILTERS VALUES(5,'job','Successful Jobs','{"status":["Completed", "Successful"]}',0);
INSERT OR IGNORE INTO GUI_FILTERS VALUES(6,'job','Active Jobs','{"status":["Running","Scheduled","Waiting"]}',0);

CREATE UNIQUE INDEX IF NOT EXISTS USERS_IDX1 ON GUI_USERS(NAME);
CREATE UNIQUE INDEX IF NOT EXISTS SNAPSHOTS_IDX1 ON GUI_SNAPSHOTS(NAME);
CREATE UNIQUE INDEX IF NOT EXISTS WEBAPI_KEYS_IDX1 ON GUI_WEBAPI_KEYS(NAME);
CREATE UNIQUE INDEX IF NOT EXISTS METADATA_IDX1 ON GUI_METADATA(NAME);
CREATE UNIQUE INDEX IF NOT EXISTS LIBRARY_UPDATES_IDX1 ON GUI_LIBRARY_UPDATES(NAME);
CREATE UNIQUE INDEX IF NOT EXISTS unique_logs on GUI_AVAILABLE_LOGS (NAME);
CREATE UNIQUE INDEX IF NOT EXISTS FILTERNAME_IDX1 ON GUI_FILTERS(name, filter_type);