Free Table - Revision history

Sam at 11:25, 3 February 2024

2024-02-03T11:25:29Z

Sam: /* EndingOffset */

2024-01-27T09:19:48Z

EndingOffset

Sam at 16:09, 24 January 2024

2024-01-24T16:09:23Z

Sam: Created page with "These are the tags that can be used in Truxton. CREATE TABLE "Free" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NULL, "MediaOffset" bigint DEFAUL..."

2024-01-24T16:02:42Z

Created page with "These are the tags that can be used in Truxton. <source lang="SQL"> CREATE TABLE "Free" ( "ID" uuid NOT NULL, "MediaID" uuid NOT NULL, "MediaOffset" bigint DEFAUL..."

New page

These are the tags that can be used in Truxton.

<source lang="SQL">
CREATE TABLE "Free" (
"ID" uuid NOT NULL,
"MediaID" uuid NOT NULL,
"MediaOffset" bigint DEFAULT 0 NOT NULL,
"DepotID" uuid NOT NULL,
"Offset" bigint DEFAULT 0 NOT NULL,
"Length" bigint DEFAULT 0 NOT NULL,
"EndingOffset" bigint DEFAULT 0 NOT NULL,
"FileID" uuid NOT NULL
);
</source>

@@ Line 20: / Line 20: @@
 ==<code>MediaID</code>==
-The globally unique identifier of the media from whence this free space chunk came. This corresponds to the ID column of the <code>[Media]</code> table.
+The globally unique identifier of the media from whence this free space chunk came.
 ==<code>MediaOffset</code>==
@@ Line 26: / Line 27: @@
 ==<code>DepotID</code>==
-The globally unique identifier for the depot where the free space is stored. This corresponds to the ID column of the <code><nowiki>[</nowiki>[[Depot Table|Depot]]<nowiki>]</nowiki></code> table.
+The globally unique identifier for the depot where the free space is stored.
 ==<code>Offset</code>==
@@ Line 35: / Line 37: @@
 ==<code>EndingOffset</code>==
-The last valid depot offset of the data in this block. It should be equal to <code>Offset</code> + <code>Length</code> - 1.
+The last valid depot offset of the data in this block. It should be equal to <code>[Offset]</code> + <code>[Length]</code> - 1.
 ==<code>FileID</code>==
-The globally unique identifier of the file this free space came from. Happens when disk image files are found in loaded Media. This corresponds to the ID column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.
+The globally unique identifier of the file this free space came from.

@@ Line 35: / Line 35: @@
 ==<code>EndingOffset</code>==
-The last valid depot offset of the data in this block. It should be equal to Offset + Length - 1.
+The last valid depot offset of the data in this block. It should be equal to <code>Offset</code> + <code>Length</code> - 1.
 ==<code>FileID</code>==
 The globally unique identifier of the file this free space came from. Happens when disk image files are found in loaded Media. This corresponds to the ID column of the <code><nowiki>[</nowiki>[[File Table|File]]<nowiki>]</nowiki></code> table.

@@ Line 1: / Line 1: @@
-These are the tags that can be used in Truxton.
+This table holds information about the unused space on a piece of media.
 <source lang="SQL">
 CREATE TABLE "Free" (
@@ Line 13: / Line 14: @@
 );
 </source>