schema.mysql\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.mysql

blob: 03b54b5691fc7d00030cb7b48dd9deace2e53e28 (plain)

1
2

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