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
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/new-portal/sql/oracle/objects-create.sql	28 Sep 2001 00:54:30 -0000	1.1
@@ -0,0 +1,208 @@
+-- The New Portal Package
+-- copyright 2001, OpenForce, Inc.
+-- distributed under the GNU GPL v2
+--
+-- arjun@openforce.net
+-- $Id: objects-create.sql,v 1.1 2001/09/28 00:54:30 oracle Exp $
+
+-- 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'
+  ); 
+end;
+/
+show errors;
+
+-- datasource attributes
+declare 
+ 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 => '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_layouts',
+    pretty_name   => 'Portal Layouts',
+    pretty_plural => 'Portal Layouts',
+    table_name    => 'PORTAL_LAYOUTS',
+    id_column     => 'LAYOUT_ID',
+    package_name  => 'portal_layouts'
+  );
+end;
+/
+show errors;
+
+-- and its attributes
+declare 
+ attr_id acs_attributes.attribute_id%TYPE; 
+begin
+  attr_id := acs_attribute.create_attribute ( 
+    object_type    => 'portal_layouts', 
+    attribute_name => 'NAME', 
+    pretty_name    => 'Name', 
+    pretty_plural  => 'Names', 
+    datatype       => 'string' 
+  ); 
+
+  attr_id := acs_attribute.create_attribute ( 
+    object_type    => 'portal_layouts', 
+    attribute_name => 'DESCRIPTION', 
+    pretty_name    => 'Description', 
+    pretty_plural  => 'Descriptions', 
+    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 => '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_themes',
+    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; 
+begin
+  attr_id := acs_attribute.create_attribute ( 
+    object_type    => 'portal_element_themes', 
+    attribute_name => 'NAME', 
+    pretty_name    => 'Name', 
+    pretty_plural  => 'Names', 
+    datatype       => 'string' 
+  ); 
+
+  attr_id := acs_attribute.create_attribute ( 
+    object_type    => 'portal_element_themes', 
+    attribute_name => 'DESCRIPTION', 
+    pretty_name    => 'Description', 
+    pretty_plural  => 'Descriptions', 
+    datatype       => 'string' 
+  ); 
+
+  attr_id := acs_attribute.create_attribute ( 
+    object_type    => 'portal_element_themes', 
+    attribute_name => 'TYPE', 
+    pretty_name    => 'Type', 
+    pretty_plural  => 'Types', 
+    datatype       => 'string' 
+  ); 
+
+  attr_id := acs_attribute.create_attribute (
+    object_type    => 'portal_element_themes',
+    attribute_name => 'FILENAME',
+    pretty_name    => 'Filename',
+    pretty_plural  => 'Filenames',
+    datatype       => 'string'
+  ); 
+
+  attr_id := acs_attribute.create_attribute (
+    object_type    => 'portal_element_themes',
+    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'
+  ); 
+end;
+/
+show errors;
+
+declare 
+ 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' 
+  );
+end; 
+/ 
+show errors;
Index: openacs-4/packages/new-portal/sql/oracle/portal-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/new-portal/sql/oracle/Attic/portal-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/new-portal/sql/oracle/portal-create.sql	26 Sep 2001 23:52:19 -0000	1.1
+++ openacs-4/packages/new-portal/sql/oracle/portal-create.sql	28 Sep 2001 00:55:12 -0000	1.2
@@ -5,7 +5,8 @@
 --
 --
 -- arjun@openforce.net
--- started Sept. 26, 2001
+-- $Id$
 --
 
 @portal-core-create.sql
+@objects-create.sql