--
-- /packages/acs-kernel/sql/acs-install.sql
--
-- Complete the install of the system by setting up some default URL mappings.
--
-- @author Bryan Quinn (bquinn@arsdigita.com
-- @creation-date 2000/10/01
-- @cvs-id $Id: acs-install.sql,v 1.3 2002/09/26 03:16:08 danw Exp $
--

declare
    kernel_id  apm_packages.package_id%TYPE;
    node_id    site_nodes.node_id%TYPE;
    main_site_id site_nodes.node_id%TYPE;
    admin_id	apm_packages.package_id%TYPE;
    workflow_id 	apm_packages.package_id%TYPE;
    docs_id    apm_packages.package_id%TYPE;
    api_doc_id apm_packages.package_id%TYPE;
    cr_id apm_packages.package_id%TYPE;
    schema_user   varchar2(100);
    jobnum        integer;
begin 
  kernel_id := apm_service.new(
		    package_key => 'acs-kernel',
		    instance_name => 'ACS Kernel',
                    context_id => acs.magic_object_id('default_context')
	       );
  commit;

  apm_package.enable(kernel_id);

  main_site_id := apm_service.new(
		    package_key => 'acs-subsite',
		    instance_name => 'Main Site',
                    context_id => acs.magic_object_id('default_context')
	       );
  apm_package.enable(main_site_id); 

  node_id := site_node.new (
    name => '',
    directory_p => 't',
    pattern_p => 't',
    object_id => main_site_id
  );

  acs_permission.grant_permission (
    object_id => main_site_id,
    grantee_id => acs.magic_object_id('the_public'),
    privilege => 'read'
  );

  admin_id := apm_service.new (
      instance_name => 'ACS Administration',
      package_key => 'acs-admin'
  );
  apm_package.enable(admin_id);

  node_id := site_node.new (
    parent_id => site_node.node_id('/'),
    name => 'acs-admin',
    directory_p => 't',
    pattern_p => 't',
    object_id => admin_id
  );


  cr_id := apm_service.new (
      instance_name => 'ACS Content Repository',
      package_key => 'acs-content-repository'
  );

  node_id := site_node.new (
    parent_id => site_node.node_id('/'),
    name => 'acs-content-repository',
    directory_p => 't',
    pattern_p => 't',
    object_id => cr_id
  );

  workflow_id := apm_service.new (
      instance_name => 'ACS Workflow',
      package_key => 'acs-workflow'
  );
  apm_package.enable(workflow_id);

  node_id := site_node.new (
    parent_id => site_node.node_id('/'),
    name => 'acs-workflow',
    directory_p => 't',
    pattern_p => 't',
    object_id => workflow_id
  );
  
  docs_id := apm_service.new (
      instance_name => 'ACS Core Documents',
      package_key => 'acs-core-docs',
      context_id => main_site_id
  );

  docs_id := site_node.new (
    parent_id => site_node.node_id('/'),
    name => 'doc',
    directory_p => 't',
    pattern_p => 't',
    object_id => docs_id
  );

  api_doc_id := apm_service.new (
      instance_name => 'ACS API Browser',
      package_key => 'acs-api-browser',
      context_id => main_site_id
  );

  apm_package.enable(api_doc_id);

  -- Set default permissions for ACS API Browser so 
  -- that only users logged in can view it

  update acs_objects
     set security_inherit_p = 'f'
   where object_id = api_doc_id;

  acs_permission.grant_permission (
    object_id => api_doc_id, 
    grantee_id => acs.magic_object_id ('registered_users'), 
    privilege => 'read'
  );

  api_doc_id := site_node.new (
    parent_id => site_node.node_id('/'),
    name => 'api-doc',
    directory_p => 't',
    pattern_p => 't',
    object_id => api_doc_id
  );

  select user into schema_user from dual;

  dbms_job.submit (
    jobnum,
    'dbms_stats.gather_schema_stats (''' || schema_user || ''', 10, cascade => true);',
    trunc(sysdate+1) + 4/24,
    'trunc(sysdate+1) + 4/24'
  );

  commit;
end;
/
show errors