Differential D3289 Diff 11662 swh/scheduler/sql/30-swh-schema.sql

Changeset View

Standalone View

swh/scheduler/sql/30-swh-schema.sql

	Show First 20 Lines • Show All 120 Lines • ▼ Show 20 Lines
	);			);

	comment on table listers is 'Lister instances known to the origin visit scheduler';			comment on table listers is 'Lister instances known to the origin visit scheduler';
	comment on column listers.name is 'Name of the lister (e.g. github, gitlab, debian, ...)';			comment on column listers.name is 'Name of the lister (e.g. github, gitlab, debian, ...)';
	comment on column listers.instance_name is 'Name of the current instance of this lister (e.g. framagit, bitbucket, ...)';			comment on column listers.instance_name is 'Name of the current instance of this lister (e.g. framagit, bitbucket, ...)';
	comment on column listers.created is 'Timestamp at which the lister was originally created';			comment on column listers.created is 'Timestamp at which the lister was originally created';
	comment on column listers.current_state is 'Known current state of this lister';			comment on column listers.current_state is 'Known current state of this lister';
	comment on column listers.updated is 'Timestamp at which the lister state was last updated';			comment on column listers.updated is 'Timestamp at which the lister state was last updated';


				create table if not exists listed_origins (
				-- Basic information
				lister_id uuid not null references listers(id),
				url text not null,
				visit_type text not null,
				extra_loader_arguments jsonb not null,

				-- Whether this origin still exists or not
				enabled boolean not null,

				-- time-based information
				first_seen timestamptz not null default now(),
				last_seen timestamptz not null,

				-- potentially provided by the lister
				last_update timestamptz,

				primary key (lister_id, url, visit_type)
				);

				comment on table listed_origins is 'Origins known to the origin visit scheduler';
				comment on column listed_origins.lister_id is 'Lister instance which owns this origin';
				comment on column listed_origins.url is 'URL of the origin listed';
				comment on column listed_origins.visit_type is 'Type of the visit which should be scheduled for the given url';
				comment on column listed_origins.extra_loader_arguments is 'Extra arguments that should be passed to the loader for this origin';

				comment on column listed_origins.enabled is 'Whether this origin has been seen during the last listing, and visits should be scheduled.';
				comment on column listed_origins.first_seen is 'Time at which the origin was first seen by a lister';
				comment on column listed_origins.last_seen is 'Time at which the origin was last seen by the lister';

				comment on column listed_origins.last_update is 'Time of the last update to the origin recorded by the remote';