projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
RT 4.0.13
[freeside.git]
/
rt
/
etc
/
upgrade
/
4.0.13
/
schema.mysql
diff --git a/rt/etc/upgrade/4.0.13/schema.mysql
b/rt/etc/upgrade/4.0.13/schema.mysql
new file mode 100644
(file)
index 0000000..
03b54b5
--- /dev/null
+++ b/
rt/etc/upgrade/4.0.13/schema.mysql
@@ -0,0
+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';