Differential D2448 Diff 8656 swh/scheduler/sql/30-swh-schema.sql

Changeset View

Standalone View

	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 (13, now(), 'Work In Progress');			values (14, 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 91 Lines • Show Last 20 Lines