summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/4.0.12
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2013-06-04 00:16:28 -0700
committerIvan Kohler <ivan@freeside.biz>2013-06-04 00:16:28 -0700
commit7588a4ac90a9b07c08a3107cd1107d773be1c991 (patch)
tree55b8bedb5f899e705da0ba7f608267943bf89e94 /rt/etc/upgrade/4.0.12
parent98d2b25256055abb0dfcb9f586b434474fa97afd (diff)
RT 4.0.13
Diffstat (limited to 'rt/etc/upgrade/4.0.12')
-rw-r--r--rt/etc/upgrade/4.0.12/schema.Oracle1
-rw-r--r--rt/etc/upgrade/4.0.12/schema.Pg1
-rw-r--r--rt/etc/upgrade/4.0.12/schema.mysql1
3 files changed, 3 insertions, 0 deletions
diff --git a/rt/etc/upgrade/4.0.12/schema.Oracle b/rt/etc/upgrade/4.0.12/schema.Oracle
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.Oracle
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');
diff --git a/rt/etc/upgrade/4.0.12/schema.Pg b/rt/etc/upgrade/4.0.12/schema.Pg
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.Pg
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');
diff --git a/rt/etc/upgrade/4.0.12/schema.mysql b/rt/etc/upgrade/4.0.12/schema.mysql
new file mode 100644
index 000000000..4d2c375bb
--- /dev/null
+++ b/rt/etc/upgrade/4.0.12/schema.mysql
@@ -0,0 +1 @@
+UPDATE Tickets SET Type = LOWER(Type) WHERE LOWER(Type) IN ('ticket', 'approval', 'reminder');