Difference between revisions of "ExpandedFile Table"

From truxwiki.com
Jump to navigation Jump to search
Line 3: Line 3:
 
This allows you to make intelligent decisions about reprocessing files with a newer version of an existing ETL.
 
This allows you to make intelligent decisions about reprocessing files with a newer version of an existing ETL.
  
<syntaxhighlight lang="SQL">
+
<source lang="SQL">
CREATE TABLE "ExpandedFile" (
+
CREATE TABLE "ExpandedFile"
    "FileID" uuid NOT NULL,
+
(
    "HashID" uuid NOT NULL,
+
  "FileID" uuid NOT NULL,
    "Expander" bigint DEFAULT 0 NOT NULL,
+
  "HashID" uuid NOT NULL,
    "Version" bigint DEFAULT 0 NOT NULL
+
  "Expander" bigint DEFAULT 0 NOT NULL,
 +
  "Version" bigint DEFAULT 0 NOT NULL
 
);
 
);
</syntaxhighlight>
+
</source>

Revision as of 08:52, 8 December 2020

The [ExpandedFile] table is used to record which exploitation methods were performed on a file. Truxton tracks which version of ETLs were used to expand/exploit a file. This allows you to make intelligent decisions about reprocessing files with a newer version of an existing ETL.

CREATE TABLE "ExpandedFile"
(
  "FileID" uuid NOT NULL,
  "HashID" uuid NOT NULL,
  "Expander" bigint DEFAULT 0 NOT NULL,
  "Version" bigint DEFAULT 0 NOT NULL
);