Ticket priority (deprecated)

Ticket priorities are defined in the tColumnValue table.

You can change the priority names using the following SQL script, where you set the new priority name (@newValue) and the weight of the priority you are changing (@priority 1-5):

DECLARE @newValue varchar(30) = N'lowest';
DECLARE @priority int = 1;

UPDATE 
tColumnValue
SET 
mColumnValue = @newValue,
ColumnValueShort = @newValue
WHERE
liColumnId = (SELECT iColumnId FROM tColumn WHERE sTable = 'tHdTicket' AND sColumn = 'Priority') AND 
nOrder = @priority

note

Edit and run the script for each priority that is changed.