Index: openacs-4/packages/new-portal/sql/oracle/objects-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/objects-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/new-portal/sql/oracle/objects-create.sql	29 Mar 2002 18:48:28 -0000	1.5
+++ openacs-4/packages/new-portal/sql/oracle/objects-create.sql	1 Jul 2002 20:03:49 -0000	1.6
@@ -14,227 +14,229 @@
 --  details.
 --
 
+--
 -- The New Portal Package
--- copyright 2001, OpenForce, Inc.
--- distributed under the GNU GPL v2
 --
--- arjun@openforce.net
--- $Id$
+-- @author arjun@openforce.net
+-- @version $Id$
+--
 
 -- datasources
 begin  
-  acs_object_type.create_type ( 
-    supertype     => 'acs_object',
-    object_type   => 'portal_datasource',
-    pretty_name   => 'Portal Data Source',
-    pretty_plural => 'Portal Data Sources',
-    table_name    => 'PORTAL_DATASOURCES',
-    id_column     => 'DATASOURCE_ID',
-    package_name  => 'portal_datasource'
-  ); 
+    acs_object_type.create_type ( 
+        supertype     => 'acs_object',
+        object_type   => 'portal_datasource',
+        pretty_name   => 'Portal Data Source',
+        pretty_plural => 'Portal Data Sources',
+        table_name    => 'PORTAL_DATASOURCES',
+        id_column     => 'DATASOURCE_ID',
+        package_name  => 'portal_datasource'
+    ); 
 end;
 /
 show errors;
 
 -- datasource attributes
 declare 
- attr_id acs_attributes.attribute_id%TYPE; 
+    attr_id                         acs_attributes.attribute_id%TYPE; 
 begin
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_datasource', 
-    attribute_name => 'NAME', 
-    pretty_name    => 'Name', 
-    pretty_plural  => 'Names', 
-    datatype       => 'string' 
-  ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_datasource', 
-    attribute_name => 'DESCRIPTION', 
-    pretty_name    => 'Description', 
-    pretty_plural  => 'Descriptions', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_datasource', 
+        attribute_name => 'NAME', 
+        pretty_name    => 'Name', 
+        pretty_plural  => 'Names', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_datasource', 
-    attribute_name => 'CONTENT', 
-    pretty_name    => 'Content', 
-    pretty_plural  => 'Contents', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_datasource', 
+        attribute_name => 'DESCRIPTION', 
+        pretty_name    => 'Description', 
+        pretty_plural  => 'Descriptions', 
+        datatype       => 'string' 
+    ); 
+
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_datasource', 
+        attribute_name => 'CONTENT', 
+        pretty_name    => 'Content', 
+        pretty_plural  => 'Contents', 
+        datatype       => 'string' 
+    ); 
+
 end; 
 / 
 show errors;
 
-
-
 -- portal_layouts
 begin  
-  acs_object_type.create_type (
-    supertype     => 'acs_object',
-    object_type   => 'portal_layout',
-    pretty_name   => 'Portal Layout',
-    pretty_plural => 'Portal Layouts',
-    table_name    => 'PORTAL_LAYOUTS',
-    id_column     => 'LAYOUT_ID',
-    package_name  => 'portal_layout'
-  );
+    acs_object_type.create_type (
+        supertype     => 'acs_object',
+        object_type   => 'portal_layout',
+        pretty_name   => 'Portal Layout',
+        pretty_plural => 'Portal Layouts',
+        table_name    => 'PORTAL_LAYOUTS',
+        id_column     => 'LAYOUT_ID',
+        package_name  => 'portal_layout'
+    );
 end;
 /
 show errors;
 
 -- and its attributes
 declare 
- attr_id acs_attributes.attribute_id%TYPE; 
+    attr_id                         acs_attributes.attribute_id%TYPE; 
 begin
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_layout', 
-    attribute_name => 'NAME', 
-    pretty_name    => 'Name', 
-    pretty_plural  => 'Names', 
-    datatype       => 'string' 
-  ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_layout', 
-    attribute_name => 'DESCRIPTION', 
-    pretty_name    => 'Description', 
-    pretty_plural  => 'Descriptions', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_layout', 
+        attribute_name => 'NAME', 
+        pretty_name    => 'Name', 
+        pretty_plural  => 'Names', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_layout', 
-    attribute_name => 'TYPE', 
-    pretty_name    => 'Type', 
-    pretty_plural  => 'Types', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_layout', 
+        attribute_name => 'DESCRIPTION', 
+        pretty_name    => 'Description', 
+        pretty_plural  => 'Descriptions', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute (
-    object_type    => 'portal_layout',
-    attribute_name => 'FILENAME',
-    pretty_name    => 'Filename',
-    pretty_plural  => 'Filenames',
-    datatype       => 'string'
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_layout', 
+        attribute_name => 'TYPE', 
+        pretty_name    => 'Type', 
+        pretty_plural  => 'Types', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute (
-    object_type    => 'portal_layout',
-    attribute_name => 'resource_dir',
-    pretty_name    => 'Resource Directory',
-    pretty_plural  => 'Resource Directory',
-    datatype       => 'string'
-  ); 
+    attr_id := acs_attribute.create_attribute (
+        object_type    => 'portal_layout',
+        attribute_name => 'FILENAME',
+        pretty_name    => 'Filename',
+        pretty_plural  => 'Filenames',
+        datatype       => 'string'
+    ); 
+
+    attr_id := acs_attribute.create_attribute (
+        object_type    => 'portal_layout',
+        attribute_name => 'resource_dir',
+        pretty_name    => 'Resource Directory',
+        pretty_plural  => 'Resource Directory',
+        datatype       => 'string'
+    ); 
+
 end; 
 / 
 show errors;
 
 -- poratal_element_themes
 begin  
-  acs_object_type.create_type (
-    supertype     => 'acs_object',
-    object_type   => 'portal_element_theme',
-    pretty_name   => 'Portal Element Theme',
-    pretty_plural => 'Portal Element Themes',
-    table_name    => 'PORTAL_THEMES',
-    id_column     => 'THEME_ID',
-    package_name  => 'portal_themes'
-  );
+    acs_object_type.create_type (
+        supertype     => 'acs_object',
+        object_type   => 'portal_element_theme',
+        pretty_name   => 'Portal Element Theme',
+        pretty_plural => 'Portal Element Themes',
+        table_name    => 'PORTAL_THEMES',
+        id_column     => 'THEME_ID',
+        package_name  => 'portal_themes'
+    );
 end;
 /
 show errors;
 
 -- and its attributes
 declare 
- attr_id acs_attributes.attribute_id%TYPE; 
+    attr_id                         acs_attributes.attribute_id%TYPE; 
 begin
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_element_theme', 
-    attribute_name => 'NAME', 
-    pretty_name    => 'Name', 
-    pretty_plural  => 'Names', 
-    datatype       => 'string' 
-  ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_element_theme', 
-    attribute_name => 'DESCRIPTION', 
-    pretty_name    => 'Description', 
-    pretty_plural  => 'Descriptions', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_element_theme', 
+        attribute_name => 'NAME', 
+        pretty_name    => 'Name', 
+        pretty_plural  => 'Names', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal_element_theme', 
-    attribute_name => 'TYPE', 
-    pretty_name    => 'Type', 
-    pretty_plural  => 'Types', 
-    datatype       => 'string' 
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_element_theme', 
+        attribute_name => 'DESCRIPTION', 
+        pretty_name    => 'Description', 
+        pretty_plural  => 'Descriptions', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute (
-    object_type    => 'portal_element_theme',
-    attribute_name => 'FILENAME',
-    pretty_name    => 'Filename',
-    pretty_plural  => 'Filenames',
-    datatype       => 'string'
-  ); 
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal_element_theme', 
+        attribute_name => 'TYPE', 
+        pretty_name    => 'Type', 
+        pretty_plural  => 'Types', 
+        datatype       => 'string' 
+    ); 
 
-  attr_id := acs_attribute.create_attribute (
-    object_type    => 'portal_element_theme',
-    attribute_name => 'resource_dir',
-    pretty_name    => 'Resource Directory',
-    pretty_plural  => 'Resource Directory',
-    datatype       => 'string'
-  ); 
+    attr_id := acs_attribute.create_attribute (
+        object_type    => 'portal_element_theme',
+        attribute_name => 'FILENAME',
+        pretty_name    => 'Filename',
+        pretty_plural  => 'Filenames',
+        datatype       => 'string'
+    ); 
+
+    attr_id := acs_attribute.create_attribute (
+        object_type    => 'portal_element_theme',
+        attribute_name => 'resource_dir',
+        pretty_name    => 'Resource Directory',
+        pretty_plural  => 'Resource Directory',
+        datatype       => 'string'
+    ); 
+
 end; 
 / 
 show errors;
 
-
 -- portal
 begin  
-  acs_object_type.create_type ( 
-    supertype     => 'acs_object', 
-    object_type   => 'portal', 
-    pretty_name   => 'Portal', 
-    pretty_plural => 'Portals', 
-    table_name    => 'PORTALS', 
-    id_column     => 'PORTAL_ID',
-    package_name  => 'portal'
-  ); 
+    acs_object_type.create_type ( 
+        supertype     => 'acs_object', 
+        object_type   => 'portal', 
+        pretty_name   => 'Portal', 
+        pretty_plural => 'Portals', 
+        table_name    => 'PORTALS', 
+        id_column     => 'PORTAL_ID',
+        package_name  => 'portal'
+    ); 
 end;
 /
 show errors;
 
 declare 
- attr_id acs_attributes.attribute_id%TYPE; 
+    attr_id                         acs_attributes.attribute_id%TYPE; 
 begin
-  attr_id := acs_attribute.create_attribute ( 
-    object_type    => 'portal', 
-    attribute_name => 'NAME', 
-    pretty_name    => 'Name', 
-    pretty_plural  => 'Names', 
-    datatype       => 'string' 
-  );
+    attr_id := acs_attribute.create_attribute ( 
+        object_type    => 'portal', 
+        attribute_name => 'NAME', 
+        pretty_name    => 'Name', 
+        pretty_plural  => 'Names', 
+        datatype       => 'string' 
+    );
 end; 
 / 
 show errors;
 
-
 -- portal_page
 begin  
-  acs_object_type.create_type ( 
-    supertype     => 'acs_object', 
-    object_type   => 'portal_page', 
-    pretty_name   => 'Portal Page', 
-    pretty_plural => 'Portal Pages', 
-    table_name    => 'PORTAL_PAGES', 
-    id_column     => 'page_id',
-    package_name  => 'portal_page'
-  ); 
+    acs_object_type.create_type ( 
+        supertype     => 'acs_object', 
+        object_type   => 'portal_page', 
+        pretty_name   => 'Portal Page', 
+        pretty_plural => 'Portal Pages', 
+        table_name    => 'PORTAL_PAGES', 
+        id_column     => 'page_id',
+        package_name  => 'portal_page'
+    ); 
 end;
 /
 show errors;