boyue_jnpf/sql_init/PostgreSQL/Update/Update_PostgreSQL_0220.sql

update base_module set f_property_json = CONCAT(SUBSTR(f_property_json,1,length(f_property_json)-1), ',"webType":2}') where  f_type = 3 and f_category = 'Web' and f_property_json is not null and f_property_json not like '%webType%';