1.57.0 - Asta7 Core

Tasks:

https://stiftelsenasta.atlassian.net/browse/AAM-1213

https://stiftelsenasta.atlassian.net/browse/AAM-1211

Bugs:

https://stiftelsenasta.atlassian.net/browse/AAM-1220

Scripts:

AAM-1213

update public.field set feature = null where feature = 0 or feature = 2;
update public.field set feature = 0 where feature = 1;
update public.field set feature = feature - 2 where feature is not null and feature > 2;



// here the following projectId is the projectId of noark4 projects
update {projectId}.dokversjon set vefilref = concat(velagrenh, '/', vefilref)
                        where velagrenh not like '%/';

update {projectId}.dokversjon set vefilref = concat(velagrenh, vefilref)
where velagrenh like '%/';

How to upgrade:

Download and extract Asta7 1.57.0
Go to asta7 directory and run the following script
run the last two quires manually for each noark4 project id.
Do not run the upgrade script more than once.