Page Comparison

update system_template set template_id = '61d2e7e4-2fe4-4d7e-83b6-236355a15660' 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
                execute format('alter table %s.aktor_struktur add column if not exists startdato varchar null', r.id);
                execute format('alter table %s.aktor_struktur add column if not exists sluttdato varchar null', r.id);
                execute format('alter table %s.alternativt_navn add column if not exists type varchar null', r.id);
            end loop;
    end; $$