__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW45000_POSTDATA_UGBUPD-10398.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__


UPDATE CI_PORTAL_ZONE SET ZONE_HEIGHT_FLG = 'CNLT' WHERE ZONE_HEIGHT_FLG = 'CNTL'
/

UPDATE CI_PORTAL_ZONE SET ZONE_HEIGHT_FLG = 'CNLT', ZONE_MAX_HEIGHT_PCT = 100 WHERE ZONE_HEIGHT_FLG = 'FULL'
/

UPDATE CI_PORTAL_ZONE SET ZONE_HEIGHT_FLG = 'CNLT', ZONE_MAX_HEIGHT_PCT = 50 WHERE ZONE_HEIGHT_FLG = 'HALF'
/

UPDATE CI_PORTAL_ZONE SET ZONE_HEIGHT_FLG = 'CNLT' WHERE ZONE_HEIGHT_FLG = 'CONT' AND ZONE_MAX_HEIGHT_PCT > 0
/