schema.Pg\4.0.13\upgrade\etc\rt - freeside.git - Freeside billing, trouble ticketing, network monitoring and provisioning

index : freeside.git

Freeside billing, trouble ticketing, network monitoring and provisioning

Git T. F. Source

summary refs log tree commit diff

path: root/rt/etc/upgrade/4.0.13/schema.Pg

blob: 8283f52598819bd35bbbfda7f128423a78c0fa9c (plain)

1
2

UPDATE Tickets SET Subject = REPLACE(Subject,E'\n',''), Status = LOWER(Status);
UPDATE Transactions SET OldValue = LOWER(OldValue), NewValue = LOWER(NewValue) WHERE Type = 'Status' AND Field = 'Status';