-- Modify permissions to include the cm_relate permission
declare
  v_exists integer;
begin
  select count(*) into v_exists from acs_privileges 
    where privilege = 'cm_admin';

  if v_exists > 0 then
    select count(*) into v_exists from acs_privileges 
      where privilege = 'cm_relate';

    if v_exists < 1 then
      acs_privilege.create_privilege('cm_relate', 'Relate Items', 'Relate Items'); 
      acs_privilege.add_child('cm_admin', 'cm_relate');
      update acs_privilege_hierarchy 
	set privilege = 'cm_relate'
      where privilege = 'cm_admin' 
	and child_privilege = 'cm_write';
    end if;
  end if;
end;
/
show errors

-- This parent_id column was not included in the cr_keywords table
-- for RC 0.  Ensure this column is there.

begin

  if not column_exists('cr_keywords', 'parent_id') then

    dbms_output.put_line('Adding PARENT_ID column to CR_KEYWORDS' || 
      ' and updating the parent id from the context id');

    execute immediate 'alter table cr_keywords add 
       parent_id      integer 
                      constraint cr_keywords_hier
                      references cr_keywords';

    execute immediate 'update cr_keywords set parent_id = (
                         select context_id from acs_objects 
                         where object_id = keyword_id)';

  end if;

end;
/
show errors

-- Drop the broken trigger, if any
begin
  execute immediate 'drop trigger cr_item_permission_tr';
exception when others then null;
end;
/
show errors

exec content_type.register_mime_type ('content_template', 'text/html');
exec content_type.register_mime_type ('content_template', 'text/plain');