Difference between revisions of "FileType Table"
Jump to navigation
Jump to search
(Created page with "The <code>[FileType]</code> table holds the information about a type of file. <source lang="SQL"> CREATE TABLE "FileType" ( "ID" smallint DEFAULT 0 NOT NULL, "ShortName"...") |
|||
| Line 1: | Line 1: | ||
The <code>[FileType]</code> table holds the information about a type of file. | The <code>[FileType]</code> table holds the information about a type of file. | ||
| + | =SQL= | ||
<source lang="SQL"> | <source lang="SQL"> | ||
CREATE TABLE "FileType" ( | CREATE TABLE "FileType" ( | ||
Revision as of 12:29, 24 January 2024
The [FileType] table holds the information about a type of file.
SQL
CREATE TABLE "FileType" (
"ID" smallint DEFAULT 0 NOT NULL,
"ShortName" text DEFAULT ''::text NOT NULL,
"LongName" text DEFAULT ''::text NOT NULL,
"Extension" text DEFAULT ''::text NOT NULL,
"MIME" text DEFAULT ''::text NOT NULL,
"ParentFileTypeID" smallint DEFAULT 0 NOT NULL,
"Carve" boolean DEFAULT false NOT NULL,
"Capabilities" text DEFAULT ''::text NOT NULL,
"Details" text DEFAULT ''::text NOT NULL,
"MinimumCarveFileSize" bigint DEFAULT 0 NOT NULL,
"MaximumCarveFileSize" bigint DEFAULT 0 NOT NULL,
"AverageFileSize" bigint DEFAULT 0 NOT NULL
);
