Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_oracle.sql =================================================================== diff -u -r15628 -r15644 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_oracle.sql (.../4.4.1_4.4.2_oracle.sql) (revision 15628) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_oracle.sql (.../4.4.1_4.4.2_oracle.sql) (revision 15644) @@ -9,4 +9,9 @@ execute immediate 'update ReturnMaterialItem set settlementPrice1 = settlementPrice'; execute immediate 'commit'; execute immediate 'alter table ReturnMaterialItem drop column settlementPrice'; -execute immediate 'alter table ReturnMaterialItem rename column settlementPrice1 to settlementPrice'; \ No newline at end of file +execute immediate 'alter table ReturnMaterialItem rename column settlementPrice1 to settlementPrice'; + +execute immediate 'alter table satisfactionsurveytable modify depart varchar2(4000)'; +execute immediate 'alter table satisfactionsurveytable modify departcoding varchar2(4000)'; +execute immediate 'alter table satisfactionsurveytemplate modify readers varchar2(4000)'; +execute immediate 'alter table satisfactionsurveytemplate modify summary varchar2(2000)'; \ No newline at end of file Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_sqlserver.sql =================================================================== diff -u -r15628 -r15644 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_sqlserver.sql (.../4.4.1_4.4.2_sqlserver.sql) (revision 15628) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.4.1_4.4.2_sqlserver.sql (.../4.4.1_4.4.2_sqlserver.sql) (revision 15644) @@ -1,2 +1,7 @@ alter table dbo.ReturnGoodsItem alter column settlementPrice numeric(19,4); alter table dbo.ReturnMaterialItem alter column settlementPrice numeric(19,4); + +alter table satisfactionsurveytable ALTER COLUMN depart nvarchar(4000); +alter table satisfactionsurveytable ALTER COLUMN departcoding nvarchar(4000); +alter table satisfactionsurveytemplate ALTER COLUMN readers nvarchar(4000); +alter table satisfactionsurveytemplate ALTER COLUMN summary nvarchar(2000); \ No newline at end of file