Differential D4838 Diff 17176 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 (18, now(), 'Work In Progress');			values (19, now(), 'Work In Progress');
				vlorentzUnsubmitted Not Done Inline Actions thx :) vlorentz: thx :)

	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 136 Lines • ▼ Show 20 Lines

	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.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.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_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';			comment on column listed_origins.last_update is 'Time of the last update to the origin recorded by the remote';

	comment on column listed_origins.last_scheduled is 'Time when this origin was scheduled to be visited last';			comment on column listed_origins.last_scheduled is 'Time when this origin was scheduled to be visited last';

				create table origin_visit_stats (
				url text not null,
				visit_type text not null,
				last_eventful timestamptz,
				last_uneventful timestamptz,
				last_failed timestamptz,

				primary key (url, visit_type)
				);

				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.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_failed is 'Date of the last failed event';