update address standardization for cust_location changes

[freeside.git] / rt / etc / upgrade / 3.9.7 / schema.mysql

diff --git a/rt/etc/upgrade/3.9.7/schema.mysql b/rt/etc/upgrade/3.9.7/schema.mysql
new file mode 100644 (file)
index 0000000..4cbed6c
--- /dev/null
+++ b/rt/etc/upgrade/3.9.7/schema.mysql
@@ -0,0 +1,6 @@
+ALTER TABLE Users ADD COLUMN AuthToken VARCHAR(16) CHARACTER SET ascii NULL;
+ALTER TABLE CustomFields ADD COLUMN BasedOn INTEGER NULL,
+    ADD COLUMN RenderType VARCHAR(64) NULL,
+    ADD COLUMN ValuesClass VARCHAR(64) CHARACTER SET ascii NULL;
+ALTER TABLE Queues ADD COLUMN SubjectTag VARCHAR(120) NULL,
+    ADD COLUMN Lifecycle VARCHAR(32) NULL;