Differential D21598 Diff 51422 resources/sql/autopatches/20210309.auditors.01.status.sql

Changeset View

Standalone View

				UPDATE {$NAMESPACE}_repository.repository_auditrequest
				SET auditStatus = 'accepted' WHERE auditStatus = 'closed';

				DELETE FROM {$NAMESPACE}_repository.repository_auditrequest
				WHERE auditStatus IN ('', 'cc', 'audit-not-required');