Difference between revisions of "WebsiteVisit Table"
Jump to navigation
Jump to search
(Created page with "This is how Truxton records website visits. <syntaxhighlight lang="SQL"> CREATE TABLE "WebsiteVisit" ( "ID" uuid NOT NULL, "URLTypeID" smallint, "URLID" bigint DEF...") |
|||
| Line 1: | Line 1: | ||
This is how Truxton records website visits. | This is how Truxton records website visits. | ||
| − | < | + | |
| − | CREATE TABLE "WebsiteVisit" ( | + | <source lang="SQL"> |
| − | + | CREATE TABLE "WebsiteVisit" | |
| − | + | ( | |
| − | + | "ID" uuid NOT NULL, | |
| − | + | "URLTypeID" smallint, | |
| − | + | "URLID" bigint DEFAULT 0 NOT NULL, | |
| − | + | "When" timestamp without time zone NOT NULL, | |
| − | + | "AccountID" bigint DEFAULT 0 NOT NULL, | |
| − | + | "WebsiteMethodID" smallint DEFAULT 0 NOT NULL, | |
| − | + | "FileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL, | |
| − | + | "MediaID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL, | |
| − | + | "LocalFilename" text DEFAULT ''::text NOT NULL, | |
| − | + | "Offset" bigint DEFAULT (-1) NOT NULL, | |
| + | "DomainID" bigint DEFAULT 0 NOT NULL, | ||
| + | "LocalFileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL | ||
); | ); | ||
| − | </ | + | </source> |
Revision as of 08:55, 8 December 2020
This is how Truxton records website visits.
CREATE TABLE "WebsiteVisit"
(
"ID" uuid NOT NULL,
"URLTypeID" smallint,
"URLID" bigint DEFAULT 0 NOT NULL,
"When" timestamp without time zone NOT NULL,
"AccountID" bigint DEFAULT 0 NOT NULL,
"WebsiteMethodID" smallint DEFAULT 0 NOT NULL,
"FileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
"MediaID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL,
"LocalFilename" text DEFAULT ''::text NOT NULL,
"Offset" bigint DEFAULT (-1) NOT NULL,
"DomainID" bigint DEFAULT 0 NOT NULL,
"LocalFileID" uuid DEFAULT '00000000-0000-0000-0000-000000000000'::uuid NOT NULL
);
