Content Table - Revision history

Sam at 12:35, 29 January 2024

2024-01-29T12:35:20Z

Sam: /* Hash */

2024-01-25T10:26:16Z

Hash

Sam at 10:24, 25 January 2024

2024-01-25T10:24:10Z

Sam at 16:25, 24 January 2024

2024-01-24T16:25:00Z

Sam: Created page with "The `[Content]` table holds information about the location of contents. CREATE TABLE "Content" ( "Hash" uuid NOT NULL, "DepotID" uuid N..."

2023-02-20T12:38:18Z

Created page with "The <code>[Content]</code> table holds information about the location of contents. <source lang="SQL"> CREATE TABLE "Content" ( "Hash" uuid NOT NULL, "DepotID" uuid N..."

New page

The <code>[Content]</code> table holds information about the location of contents.

<source lang="SQL">
CREATE TABLE "Content" (
"Hash" uuid NOT NULL,
"DepotID" uuid NOT NULL,
"Offset" bigint DEFAULT 0 NOT NULL,
"Length" bigint DEFAULT 0 NOT NULL,
"IsContainer" boolean DEFAULT false NOT NULL,
"IsResident" boolean DEFAULT false NOT NULL
);
</source>

@@ Line 16: / Line 16: @@
 ==<code>Hash</code>==
 The hash of the contents of the file.
-This corresponds to the <code>HashID</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
+This corresponds to the <code>[HashID]</code> column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
 ==<code>DepotID</code>==
 The globally unique identifier for the depot that hold this content.
-This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[Depot Table|Depot]]<nowiki>]</nowiki></code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Depot Table|Depot]]<nowiki>]</nowiki></code> table.
 ==<code>Offset</code>==

@@ Line 16: / Line 16: @@
 ==<code>Hash</code>==
 The hash of the contents of the file.
 ==<code>DepotID</code>==

← Older revision		Revision as of 10:24, 25 January 2024
Line 12:		Line 12:
	);		);
	</source>		</source>
		+
		+	=Columns=
		+	==<code>Hash</code>==
		+	The hash of the contents of the file.
		+
		+	==<code>DepotID</code>==
		+	The globally unique identifier for the depot that hold this content.
		+	This corresponds to the <code>ID</code> column of the <code><nowiki>[</nowiki>[[Depot Table\|Depot]]<nowiki>]</nowiki></code> table.
		+
		+	==<code>Offset</code>==
		+	The offset into the depot where this content begins.
		+
		+	==<code>Length</code>==
		+	The number of bytes in this content.
		+
		+	==<code>IsContainer</code>==
		+	True if this content blob contains other content blobs contiguously.
		+
		+	==<code>IsResident</code>==
		+	True if this content exists contiguously within another content.