1.46.0 - Asta7 Core
- Ashrafuzzaman Purno
Owned by Ashrafuzzaman Purno
Highlights:
https://stiftelsenasta.atlassian.net/browse/AAM-1125
Tasks:
https://stiftelsenasta.atlassian.net/browse/AAM-1125
https://stiftelsenasta.atlassian.net/browse/AAM-1128
SQL Fixes:
For AAM-1128
update system_template set template_id = 'b75c51c9-3262-4d3c-9daf-a31a8ff42a2e' where name = 'PARTICIPANT_MODULE';
do $$
declare
r record;
sql varchar;
begin
for r in select id from project where archive_initialized = true and exists (select project_id from project_system_template where project_id = id and template_name = 'PARTICIPANT_MODULE')
loop
Begin
sql := 'ALTER TABLE ' || r.id || '.aktor_fil add column referansefilnavn varchar';
execute sql;
EXCEPTION
WHEN duplicate_column THEN RAISE NOTICE 'column already exists.';
END;
execute format('create table if not exists %s.aktor_url
(
_amid uuid default uuid_generate_v4() not null
unique,
created timestamp,
created_by varchar,
updated timestamp,
updated_by varchar,
id uuid default uuid_generate_v1mc() not null
primary key,
fk_aktor uuid not null
constraint fk_0683436c_29e3_4233_a33b_791d76dddb60
references %s.aktor
deferrable initially deferred,
url varchar not null,
tittel varchar,
beskrivelse varchar,
referansefilnavn varchar
)', r.id, r.id);
execute format('alter table %s.aktor_url owner to "archive-manager"', r.id);
execute format('create index if not exists index_0683436c_29e3_4233_a33b_791d76dddb60 on %s.aktor_url (fk_aktor)', r.id);
end loop;
end; $$How to upgrade
Upload the latest PARTICIPANT_MODULE template
Upgrade to 1.46
Go to the asta7 directory and run the following script
4. Delete the old PARTICIPANT_MODULE template
Configuration:
Â