Differential D18010 Diff 43321 resources/sql/autopatches/20170524.nuance.02.commandstatus.sql

Changeset View

Standalone View

				ALTER TABLE {$NAMESPACE}_nuance.nuance_itemcommand
				ADD status VARCHAR(64) NOT NULL;

				UPDATE {$NAMESPACE}_nuance.nuance_itemcommand
				SET status = 'done' WHERE status = '';