Difference between revisions of "USBDevice Table"

From truxwiki.com
Jump to navigation Jump to search
(Created page with "This represents a <syntaxhighlight lang="SQL"> CREATE TABLE "USBDevice" ( "ID" uuid NOT NULL, "FileID" uuid NOT NULL, "MediaID" uuid NOT NULL, "Offset" bigint...")
 
Line 1: Line 1:
This represents a  
+
This represents a [https://en.wikipedia.org/wiki/USB USB] device found in the exploited media.
<syntaxhighlight lang="SQL">
+
 
CREATE TABLE "USBDevice" (
+
<source lang="SQL">
    "ID" uuid NOT NULL,
+
CREATE TABLE "USBDevice"
    "FileID" uuid NOT NULL,
+
(
    "MediaID" uuid NOT NULL,
+
  "ID" uuid NOT NULL,
    "Offset" bigint DEFAULT (-1) NOT NULL,
+
  "FileID" uuid NOT NULL,
    "PID" integer DEFAULT 0 NOT NULL,
+
  "MediaID" uuid NOT NULL,
    "VID" integer DEFAULT 0 NOT NULL,
+
  "Offset" bigint DEFAULT (-1) NOT NULL,
    "Revision" smallint DEFAULT 0 NOT NULL,
+
  "PID" integer DEFAULT 0 NOT NULL,
    "USBDeviceTypeID" integer DEFAULT 0 NOT NULL,
+
  "VID" integer DEFAULT 0 NOT NULL,
    "When" timestamp without time zone NOT NULL,
+
  "Revision" smallint DEFAULT 0 NOT NULL,
    "DeviceID" uuid NOT NULL
+
  "USBDeviceTypeID" integer DEFAULT 0 NOT NULL,
 +
  "When" timestamp without time zone NOT NULL,
 +
  "DeviceID" uuid NOT NULL
 
);
 
);
</syntaxhighlight>
+
</source>

Revision as of 08:54, 8 December 2020

This represents a USB device found in the exploited media.

CREATE TABLE "USBDevice"
(
  "ID" uuid NOT NULL,
  "FileID" uuid NOT NULL,
  "MediaID" uuid NOT NULL,
  "Offset" bigint DEFAULT (-1) NOT NULL,
  "PID" integer DEFAULT 0 NOT NULL,
  "VID" integer DEFAULT 0 NOT NULL,
  "Revision" smallint DEFAULT 0 NOT NULL,
  "USBDeviceTypeID" integer DEFAULT 0 NOT NULL,
  "When" timestamp without time zone NOT NULL,
  "DeviceID" uuid NOT NULL
);