Differential D4853 Diff 17187 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 (19, now(), 'Work In Progress');			values (20, 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 143 Lines • ▼ Show 20 Lines
	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 (			create table origin_visit_stats (
	url text not null,			url text not null,
	visit_type text not null,			visit_type text not null,
	last_eventful timestamptz,			last_eventful timestamptz,
	last_uneventful timestamptz,			last_uneventful timestamptz,
	last_failed timestamptz,			last_failed timestamptz,
				last_snapshot bytea,

	primary key (url, visit_type)			primary key (url, visit_type)
	);			);

	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_snapshot is 'Last visit snapshot';