summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.9.7/schema.Oracle
diff options
context:
space:
mode:
Diffstat (limited to 'rt/etc/upgrade/3.9.7/schema.Oracle')
-rw-r--r--rt/etc/upgrade/3.9.7/schema.Oracle16
1 files changed, 11 insertions, 5 deletions
diff --git a/rt/etc/upgrade/3.9.7/schema.Oracle b/rt/etc/upgrade/3.9.7/schema.Oracle
index 3c75c91..70b4a12 100644
--- a/rt/etc/upgrade/3.9.7/schema.Oracle
+++ b/rt/etc/upgrade/3.9.7/schema.Oracle
@@ -1,6 +1,12 @@
ALTER TABLE Users ADD AuthToken VARCHAR2(16) NULL;
-ALTER TABLE CustomFields ADD BasedOn NUMBER(11,0) NULL;
-ALTER TABLE CustomFields ADD RenderType VARCHAR2(64) NULL;
-ALTER TABLE CustomFields ADD ValuesClass VARCHAR2(64) NULL;
-ALTER TABLE Queues ADD SubjectTag VARCHAR2(120) NULL;
-ALTER TABLE Queues ADD Lifecycle VARCHAR2(32) NULL;
+
+ALTER TABLE CustomFields ADD(
+ BasedOn NUMBER(11,0) NULL,
+ RenderType VARCHAR2(64) NULL,
+ ValuesClass VARCHAR2(64) NULL
+);
+
+ALTER TABLE Queues ADD(
+ SubjectTag VARCHAR2(120) NULL,
+ Lifecycle VARCHAR2(32) NULL
+);