Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/datamodifyrecord/DataModifyRecord.java =================================================================== diff -u -r33302 -r33538 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/datamodifyrecord/DataModifyRecord.java (.../DataModifyRecord.java) (revision 33302) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/entity/datamodifyrecord/DataModifyRecord.java (.../DataModifyRecord.java) (revision 33538) @@ -6,6 +6,7 @@ import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; +import javax.persistence.Lob; import org.hibernate.annotations.Cache; import org.hibernate.annotations.CacheConcurrencyStrategy; @@ -143,6 +144,7 @@ this.modifyType = modifyType; } + @Lob public String getOldValue() { return oldValue; } @@ -151,6 +153,7 @@ this.oldValue = oldValue; } + @Lob public String getNewValue() { return newValue; } Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_sqlserver.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_sqlserver.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_sqlserver.sql (revision 33538) @@ -0,0 +1,2 @@ +ALTER TABLE DataModifyRecord ALTER COLUMN oldValue text; +ALTER TABLE DataModifyRecord ALTER COLUMN newValue text; \ No newline at end of file Index: forgon-tools/src/main/java/com/forgon/Constants.java =================================================================== diff -u -r33515 -r33538 --- forgon-tools/src/main/java/com/forgon/Constants.java (.../Constants.java) (revision 33515) +++ forgon-tools/src/main/java/com/forgon/Constants.java (.../Constants.java) (revision 33538) @@ -27,7 +27,7 @@ "4.9.25","4.9.26","4.9.27","4.9.28","4.9.29","4.9.30","4.9.31","4.9.32","4.9.33","4.9.34","4.9.35","4.9.36","4.9.37","4.9.38","4.9.39","4.9.40","4.9.41","4.9.42","4.9.43","4.9.44", "4.9.45","4.9.46","4.9.47","4.9.48","4.9.49","4.9.50","4.9.51","4.9.52","4.9.53","4.9.54","4.9.55","4.9.56","4.9.57","4.9.58","4.9.59","4.9.60","4.9.61","4.9.62", "4.9.63","4.9.64","4.9.65","4.9.66","4.9.67","4.9.68","4.9.69","4.9.70","4.9.71","4.9.72","4.9.73","4.9.74","4.9.75","4.9.76","4.9.77","4.9.78","4.9.79","4.9.80","4.9.81","4.9.82","4.9.83","4.9.84","4.9.85", - "4.9.86","4.9.87","4.9.88","4.9.89"}; + "4.9.86","4.9.87","4.9.88","4.9.89","4.9.90"}; // 版本列表(4.0版本升级4.1版需要分两步:先从4.0升到4.1.0、然后从4.1.0升级4.1最新版本) /*public final static String[] SOFTWARE_VERSION_ARRAY = new String[] { Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_oracle.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_oracle.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.89_4.9.90_oracle.sql (revision 33538) @@ -0,0 +1,12 @@ +execute immediate 'alter table DataModifyRecord add (foo clob)'; +execute immediate 'update DataModifyRecord set foo = oldValue'; +execute immediate 'commit'; +execute immediate 'alter table DataModifyRecord drop column oldValue'; +execute immediate 'alter table DataModifyRecord rename column foo to oldValue'; +execute immediate 'commit'; +execute immediate 'alter table DataModifyRecord add (foo clob)'; +execute immediate 'update DataModifyRecord set foo = newValue'; +execute immediate 'commit'; +execute immediate 'alter table DataModifyRecord drop column newValue'; +execute immediate 'alter table DataModifyRecord rename column foo to newValue'; +execute immediate 'commit'; \ No newline at end of file