Differential D2457 Diff 8673 swh/scheduler/sql/30-swh-schema.sql

Changeset View

Standalone View

swh/scheduler/sql/30-swh-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 (14, now(), 'Work In Progress');			values (15, 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 82 Lines • ▼ Show 20 Lines
	comment on column task_run.metadata is 'Useful metadata for the given task run. '			comment on column task_run.metadata is 'Useful metadata for the given task run. '
	'For instance, the worker that took on the job, '			'For instance, the worker that took on the job, '
	'or the logs for the run.';			'or the logs for the run.';
	comment on column task_run.id is 'Task run identifier';			comment on column task_run.id is 'Task run identifier';
	comment on column task_run.task is 'References task table';			comment on column task_run.task is 'References task table';
	comment on column task_run.scheduled is 'Scheduled run time for task';			comment on column task_run.scheduled is 'Scheduled run time for task';
	comment on column task_run.started is 'Task starting time';			comment on column task_run.started is 'Task starting time';
	comment on column task_run.ended is 'Task ending time';			comment on column task_run.ended is 'Task ending time';