USBDevice Table

From truxwiki.com
Revision as of 15:55, 21 May 2020 by Sam (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This represents a

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
);