Index: openacs-4/packages/acs-kernel/sql/acs-install.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/Attic/acs-install.sql,v
diff -u -N
--- openacs-4/packages/acs-kernel/sql/acs-install.sql	13 Mar 2001 22:59:26 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,119 +0,0 @@
---
--- /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.1 2001/03/13 22:59:26 ben 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;
-    docs_id    apm_packages.package_id%TYPE;
-    api_doc_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
-  );
-  
-  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