RT 4.2.11, ticket#13852

[freeside.git] / rt / etc / upgrade / 4.1.5 / schema.Oracle

diff --git a/rt/etc/upgrade/4.1.5/schema.Oracle b/rt/etc/upgrade/4.1.5/schema.Oracle
new file mode 100644 (file)
index 0000000..648784d
--- /dev/null
+++ b/rt/etc/upgrade/4.1.5/schema.Oracle
@@ -0,0 +1,6 @@
+# Template column
+ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld;
+ALTER TABLE Scrips ADD Template VARCHAR2(200);
+UPDATE Scrips SET Template = CAST(TemplateOld AS varchar2(200));
+ALTER TABLE Scrips MODIFY Template VARCHAR2(200) NOT NULL;
+ALTER TABLE Scrips DROP COLUMN TemplateOld;