Differential D3080 Diff 10970 swh/storage/sql/20-swh-enums.sql

Changeset View

Standalone View

	Show All 9 Lines

	create type object_type as enum ('content', 'directory', 'revision', 'release', 'snapshot');			create type object_type as enum ('content', 'directory', 'revision', 'release', 'snapshot');
	comment on type object_type is 'Data object types stored in data model';			comment on type object_type is 'Data object types stored in data model';

	create type snapshot_target as enum ('content', 'directory', 'revision', 'release', 'snapshot', 'alias');			create type snapshot_target as enum ('content', 'directory', 'revision', 'release', 'snapshot', 'alias');
	comment on type snapshot_target is 'Types of targets for snapshot branches';			comment on type snapshot_target is 'Types of targets for snapshot branches';

	create type origin_visit_state as enum (			create type origin_visit_state as enum (
				'created',
	'ongoing',			'ongoing',
	'full',			'full',
	'partial'			'partial'
	);			);
	comment on type origin_visit_state IS 'Possible visit status';			comment on type origin_visit_state IS 'Possible origin visit values';