Log Table - Revision history

Sam at 11:28, 3 February 2024

2024-02-03T11:28:21Z

Sam at 09:38, 27 January 2024

2024-01-27T09:38:32Z

Sam: Created page with "This is where Truxton stores messages to be gathered to create the Load Log. CREATE TABLE "Log" ( "MediaID" uuid NOT NU..."

2022-07-25T14:26:12Z

Created page with "This is where Truxton stores messages to be gathered to create the Load Log. <source lang="SQL"> CREATE TABLE "Log" ( "MediaID" uuid NOT NU..."

New page

This is where Truxton stores messages to be gathered to [[Finished|create]] the [[Type_Load_Log|Load Log]].

<source lang="SQL">
CREATE TABLE "Log" (
"MediaID" uuid NOT NULL,
"When" timestamp without time zone NOT NULL,
"LogStringTypeID" integer DEFAULT 0 NOT NULL,
"LogStringSourceID" bigint DEFAULT 0 NOT NULL,
"ProcessID" integer DEFAULT 0 NOT NULL,
"ThreadID" integer DEFAULT 0 NOT NULL,
"LogStringClientID" bigint DEFAULT 0 NOT NULL,
"LogStringUserID" bigint DEFAULT 0 NOT NULL,
"LogStringMessageID" bigint DEFAULT 0 NOT NULL
);
</source>

@@ Line 19: / Line 19: @@
 ==<code>MediaID</code>==
 The globally unique identifier for the Media this message belongs.
-This corresponds to the <code>ID</code> column of the <code>[Media]</code> table.
+This corresponds to the <code>[ID]</code> column of the <code><nowiki>[</nowiki>[[Media Table|Media]]<nowiki>]</nowiki></code> table.
 ==<code>When</code>==
@@ Line 28: / Line 28: @@
 ==<code>LogStringSourceID</code>==
-The identifier for the source of the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table.
+The identifier for the source of the message.
 ==<code>ProcessID</code>==
@@ Line 34: / Line 35: @@
 ==<code>ThreadID</code>==
-The identifier for the thread that generated the message. This comes from the operating system on the machine that generated the message.
+The identifier for the thread that generated the message.
 ==<code>LogStringClientID</code>==
-The identifier of the client machine that generated the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table.
+The identifier of the client machine that generated the message.
 ==<code>LogStringUserID</code>==
-The identifier for the user that generated the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table.
+The identifier for the user that generated the message.
 ==<code>LogStringMessageID</code>==
-The text of the message. This corresponds to the <code>ID</code> column of the <code>[LogString]</code> table.
+The text of the message.

@@ Line 1: / Line 1: @@
 This is where Truxton stores messages to be gathered to [[Finished|create]] the [[Type_Load_Log|Load Log]].
 <source lang="SQL">
 CREATE TABLE "Log" (
@@ Line 14: / Line 15: @@
 );
 </source>