Differential D4880 Diff 17357 swh/scheduler/sql/30-schema.sql

Changeset View

Standalone View

swh/scheduler/sql/30-schema.sql

	create table dbversion			create table dbversion
	(			(
	version int primary key,			version int primary key,
	release timestamptz not null,			release timestamptz not null,
	description text not null			description text not null
	);			);

	comment on table dbversion is 'Schema update tracking';			comment on table dbversion is 'Schema update tracking';
	comment on column dbversion.version is 'SQL schema version';			comment on column dbversion.version is 'SQL schema version';
	comment on column dbversion.release is 'Version deployment timestamp';			comment on column dbversion.release is 'Version deployment timestamp';
	comment on column dbversion.description is 'Version description';			comment on column dbversion.description is 'Version description';

	insert into dbversion (version, release, description)			insert into dbversion (version, release, description)
	values (23, now(), 'Work In Progress');			values (24, now(), 'Work In Progress');

	create table task_type (			create table task_type (
	type text primary key,			type text primary key,
	description text not null,			description text not null,
	backend_name text not null,			backend_name text not null,
	default_interval interval,			default_interval interval,
	min_interval interval,			min_interval interval,
	max_interval interval,			max_interval interval,
	▲ Show 20 Lines • Show All 156 Lines • ▼ Show 20 Lines

	comment on column origin_visit_stats.url is 'Origin URL';			comment on column origin_visit_stats.url is 'Origin URL';
	comment on column origin_visit_stats.visit_type is 'Type of the visit for the given url';			comment on column origin_visit_stats.visit_type is 'Type of the visit for the given url';
	comment on column origin_visit_stats.last_eventful is 'Date of the last eventful event';			comment on column origin_visit_stats.last_eventful is 'Date of the last eventful event';
	comment on column origin_visit_stats.last_uneventful is 'Date of the last uneventful event';			comment on column origin_visit_stats.last_uneventful is 'Date of the last uneventful event';
	comment on column origin_visit_stats.last_failed is 'Date of the last failed event';			comment on column origin_visit_stats.last_failed is 'Date of the last failed event';
	comment on column origin_visit_stats.last_notfound is 'Date of the last notfound event';			comment on column origin_visit_stats.last_notfound is 'Date of the last notfound event';
	comment on column origin_visit_stats.last_snapshot is 'sha1_git of the last visit snapshot';			comment on column origin_visit_stats.last_snapshot is 'sha1_git of the last visit snapshot';


				create table scheduler_metrics (
				lister_id uuid not null references listers(id),
				visit_type text not null,
				last_update timestamptz not null,
				origins_known int not null default 0,
				origins_enabled int not null default 0,
				origins_never_visited int not null default 0,
				origins_with_pending_changes int not null default 0,

				primary key (lister_id, visit_type)
				);

				douarddaUnsubmitted Not Done Inline Actions see comment on `24.sql` douardda: see comment on `24.sql`
				comment on table scheduler_metrics is 'Cache of per-lister metrics for the scheduler, collated between the listed_origins and origin_visit_stats tables.';
				comment on column scheduler_metrics.lister_id is 'Lister instance on which metrics have been aggregated';
				comment on column scheduler_metrics.visit_type is 'Visit type on which metrics have been aggregated';
				comment on column scheduler_metrics.last_update is 'Last update of these metrics';
				comment on column scheduler_metrics.origins_known is 'Number of known (enabled or disabled) origins';
				comment on column scheduler_metrics.origins_enabled is 'Number of origins that were present in the latest listing';
				douarddaUnsubmitted Not Done Inline Actions see comment on `24.sql` douardda: see comment on `24.sql`
				comment on column scheduler_metrics.origins_never_visited is 'Number of origins that have never been visited';
				comment on column scheduler_metrics.origins_with_pending_changes is 'Number of enabled origins with known activity since our last visit';