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

blob: 6ab70204ebecebb87bc338c82d1a8b91c4d0665d (plain)

1
2

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