Page Comparison

Highlights:

...

Bug fixes:

Stories:

Tasks:

Breaking changes:

1. Upload SECURITY_MODULE, PARTICIPANT_MODULE from develop branch.

2. Run the sql from the sql fix section.

3. Delete old SECURITY_MODULE, PARTICIPANT_MODULE.

SQL Fixes:

• Code Block

  update system_template set template_id = '4196c9da-5cab-4f49-a076-4da414edc896' where name = 'PARTICIPANT_MODULE'; update system_template set template_id = '2193fab6-b06e-4ba4-ae87-54477dfd3cda' where name = 'SECURITY_MODULE'; do $$ declare r record; sql varchar; begin for r in select id from project where archive_initialized = true loop sql := 'alter table if exists ' || r.id || '.object_restriction alter column object_reference type uuid using object_reference::uuid'; execute sql; Begin sql := 'ALTER TABLE ' || r.id || '.aktor_relasjon add column object_reference varchar'; execute sql; EXCEPTION WHEN duplicate_column THEN RAISE NOTICE 'column <column_name> already exists in <table_name>.'; END; sql := 'update ' || r.id || '.aktor_relasjon set object_reference=objekt_id'; -- raise notice '%s',sql; execute sql; sql := 'alter table if exists ' || r.id || '.aktor_relasjon alter column object_reference type uuid using object_reference::uuid'; execute sql; sql := 'ALTER TABLE ' || r.id || '.aktor_relasjon drop column objekt_id'; execute sql; end loop; end; $$

How to Upgrade

1. Upload the latest SECURITY_MODULE and PARTICIPANT_MODULE templates in your current version (most likely 1.39) of Asta7.

2. Upgrade to 1.40.0

3. Go to the asta7 directory and run the following script

4. Delete the old SECURITY_MODULE and PARTICIPANT_MODULE templates.
5. Reindex all the projects.

Configuration: