diff options
| author | ivan <ivan> | 2009-12-31 13:16:41 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-12-31 13:16:41 +0000 |
| commit | b4b0c7e72d7eaee2fbfc7022022c9698323203dd (patch) | |
| tree | ba4cd21399e412c32fe3737eaa8478e3271509f9 /rt/etc/upgrade/3.7.3 | |
| parent | 2dfda73eeb3eae2d4f894099754794ef07d060dd (diff) | |
import rt 3.8.7
Diffstat (limited to 'rt/etc/upgrade/3.7.3')
| -rw-r--r-- | rt/etc/upgrade/3.7.3/schema.Oracle | 5 | ||||
| -rw-r--r-- | rt/etc/upgrade/3.7.3/schema.Pg | 1 | ||||
| -rw-r--r-- | rt/etc/upgrade/3.7.3/schema.mysql | 1 |
3 files changed, 7 insertions, 0 deletions
diff --git a/rt/etc/upgrade/3.7.3/schema.Oracle b/rt/etc/upgrade/3.7.3/schema.Oracle new file mode 100644 index 000000000..6136efae7 --- /dev/null +++ b/rt/etc/upgrade/3.7.3/schema.Oracle @@ -0,0 +1,5 @@ +alter table CustomFields add Pattern_TMP clob; +update CustomFields set Pattern_TMP = Pattern; +commit; +alter table CustomFields drop column Pattern; +alter table CustomFields rename column Pattern_TMP to Pattern; diff --git a/rt/etc/upgrade/3.7.3/schema.Pg b/rt/etc/upgrade/3.7.3/schema.Pg new file mode 100644 index 000000000..5d0312e92 --- /dev/null +++ b/rt/etc/upgrade/3.7.3/schema.Pg @@ -0,0 +1 @@ +ALTER TABLE customfields ALTER COLUMN pattern TYPE VARCHAR(65536); diff --git a/rt/etc/upgrade/3.7.3/schema.mysql b/rt/etc/upgrade/3.7.3/schema.mysql new file mode 100644 index 000000000..51c376d81 --- /dev/null +++ b/rt/etc/upgrade/3.7.3/schema.mysql @@ -0,0 +1 @@ +ALTER TABLE CustomFields CHANGE Pattern Pattern TEXT NULL; |