Page Comparison

update system_template set template_id = 'd10f1600-00db-4733-b4f5-858feb69103f' where name = 'SECURITY_MODULE';
do $$
    declare

do $$
    declare
        r record;
        ps   varchar[] := array ['READ', 'WRITE'];
        p    varchar;
        rrole recordvarchar;
    begin
        for r in select id FROM project where archive_initialized = true
            loop
                execute 'altercreate table if not exists ' || r.id || '.restriction add column if not exists is_predefined_for_suggestion boolean null';content_access_group
(
    _amid               uuid default uuid_generate_v4()  execute 'alternot tablenull
if exists ' || r.id || '.restriction alter columnunique,
name type varchar(1000)';  created           end loop; timestamp,
   end; $$

update system_template set template_id = 'ccff22f4-d532-4d1b-add5-5427d1044e09' where name = 'PARTICIPANT_MODULE';
do $$
    declare created_by          varchar,
    updated           r record; timestamp,
   begin updated_by        for r in selectvarchar,
id FROM project where archivesecurity_model_initializedname =varchar,
true    id         loop         uuid default uuid_generate_v1mc() not null
   execute 'alter table if exists 'primary || r.id || '.aktor_relasjon add column if not exists startdato varchar null';key,
    name                varchar(36)       execute 'alter table if exists ' || r.id || '.aktor_relasjon add column if not exists sluttdato varcharnot null';
        unique,
    description     execute 'alter table if existsvarchar
)';
 || r.id               execute 'alter table ' || r.id || '.aktorcontent_access_relasjongroup dropowner column if exists object_referenceto "archive-manager"';

            end loop;   execute 'create end; $$

do $$
    declare
 table if not exists ' || r.id || '.content_screening
(
    _amid  r record;         sql varchar;   uuid  begindefault uuid_generate_v4()   not null
       for runique,
in SELECT   created              timestamp,
    tc.table_schema,created_by           varchar,
    updated        tc.constraint_name,      timestamp,
    updated_by           tc.table_namevarchar,
    id                 kcu.column_name,  uuid default uuid_generate_v1mc() not null
        primary key,
     ccu.table_schema AS foreign_table_schema,cag_id               uuid        ccu.table_name AS foreign_table_name,                    not null
ccu.column_name AS foreign_column_name      constraint fk_ccb0a488_a9a9_4162_a149_494ab3ce7dd9
          FROM  references ' || r.id || '.content_access_group
            deferrable initially deferred,
 information_schema.table_constraints AS tc object_id            uuid             JOIN information_schema.key_column_usage AS kcu              not null,
    table_name_reference varchar          ON tc.constraint_name = kcu.constraint_name              not null,
    scope               AND tc.table_schema = kcu.table_schema varchar                           not null,
JOIN information_schema.constraint_column_usage AS ccu level                integer              ON ccu.constraint_name = tc.constraint_name          not null,
    parent_screening_id  uuid
        constraint fk_9a653aaa_aa8c_4bf9_a69a_9452f876aa75
      AND ccu.table_schema = tc.table_schema   references ' || r.id || '.content_screening
         WHERE tc.constraint_type = 'FOREIGNdeferrable KEY' and tc.table_schema in (select id from project where archive_initialized = true)initially deferred,
    field_names          varchar(2000)
)';
  loop                 sql :=execute 'alter table ' || r.table_schemaid || '.' || r.table_name ||' drop constraint if exists '|| r.constraint_name;content_screening owner to "archive-manager"';
                execute 'create index if not  -- raise notice '%', sql;
 exists index_b49d524e_8148_43aa_9615_b653e50bb633 on ' || r.id ||
              execute sql;         '.content_screening (object_id)';   end loop;        
 for r in select schemaname, tablename, indexname from pg_indexes where schemaname inend (selectloop;
id from project where archive_initialized = true) and indexname like 'index%'end;
$$

do $$
    declare
        r loop   record;
        ps   varchar[] := sql := 'drop index if exists ' || r.schemaname || '.' || r.indexname;array ['READ', 'WRITE'];
        p    varchar;
        role varchar;
        grp varchar;
        executei sql;int;
    begin
        for r in select id FROM project where archive_initialized = true
    -- raise notice '%', sql;
            end loop;
    end;
$$;