xNightR00T File Manager

-- -----------------------------------------------------
-- Table `client`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_client` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `session_key` VARCHAR(45) NULL,
  `app_id` VARCHAR(45) NULL,
  `browser_name` VARCHAR(45) NULL,
  -- `browser_version` VARCHAR(255) NULL,
  `user_agent` VARCHAR(45) NULL,
  `language` VARCHAR(45) NULL,
  `time_zone` VARCHAR(45) NULL,
  `is_mobile` INTEGER NULL,
  `os_name` VARCHAR(45) NULL,
  `os_version` VARCHAR(45) NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);


-- -----------------------------------------------------
-- Table `view_page`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_page_view` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `client_id` INT NULL,
  `code` VARCHAR(45) NULL,
  `host` VARCHAR(255) NULL,
  `protocol` VARCHAR(45) NULL,
  `port` INT NULL,
  `path` VARCHAR(255) NULL,
  `start_time` INTEGER NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);


-- -----------------------------------------------------
-- Table `js_error`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_js_error` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `page_view_id` INT NULL,
  `msg` TEXT(255) NULL,
  `line` INT NULL,
  `col` INT NULL,
  `time` INTEGER NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);


-- -----------------------------------------------------
-- Table `page_perfomance`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_page_perfomance` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `page_view_id` INT NULL,
  `name` VARCHAR(255) NULL,
  `type` VARCHAR(255) NULL,
  `start_time` INTEGER NULL,
  `duration` INT NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);


-- -----------------------------------------------------
-- Table `ajax_perfomance`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_ajax_perfomance` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `page_view_id` INT NULL,
  `name` VARCHAR(255) NULL,
  `method` VARCHAR(45) NULL,
  `start_time` INTEGER NULL,
  `duration` INT NULL,
  `status` INT UNSIGNED NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);


-- -----------------------------------------------------
-- Table `assets_perfomance`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `browser_assets_perfomance` (
  `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  `page_view_id` INT NULL,
  `name` VARCHAR(255) NULL,
  `type` VARCHAR(255) NULL,
  `start_time` INTEGER NULL,
  `duration` INT NULL,
  `status` INT UNSIGNED NULL,
  `created_at` INTEGER NULL,
  `updated_at` INTEGER NULL
);

-- -----------------------------------------------------
-- Table `browser_metadata`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS browser_metadata (
	id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	`key` VARCHAR NOT NULL,
	`value` VARCHAR NOT NULL,
	cdate INTEGER DEFAULT CURRENT_TIMESTAMP NOT NULL
);