Difference between revisions of "USBDevice Table"
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. |
| − | < | + | |
| − | CREATE TABLE "USBDevice" ( | + | <source lang="SQL"> |
| − | + | 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 | ||
); | ); | ||
| − | </ | + | </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
);