jasperreports-server-ce/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-6.4.0-7....

11 lines
316 B
SQL
Executable File

--
--
-- 6.4.0 to 7.1.0
--
-- This is a placeholder file for the js-upgrade-samedb.sh/bat script
--
-- Change column type from "varchar(100)" to "varchar(255)"
ALTER TABLE JIReportJobParameter ALTER COLUMN parameter_name TYPE varchar(255);
ALTER TABLE JIReportJobParameter ALTER COLUMN parameter_name SET NOT NULL;