Index: openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql 28 Aug 2003 09:41:38 -0000 1.2 +++ openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql 27 Jul 2006 20:09:33 -0000 1.3 @@ -306,15 +306,15 @@ attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_child_rel', attribute_name => 'parent_id', - datatype => 'text', + datatype => 'integer', pretty_name => 'Parent ID', pretty_plural => 'Parent IDs' ); attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_child_rel', attribute_name => 'child_id', - datatype => 'text', + datatype => 'integer', pretty_name => 'Child ID', pretty_plural => 'Child IDs' ); @@ -330,7 +330,7 @@ attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_child_rel', attribute_name => 'order_n', - datatype => 'text', + datatype => 'integer', pretty_name => 'Sort Order', pretty_plural => 'Sort Orders' ); @@ -348,15 +348,15 @@ attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_rel', attribute_name => 'item_id', - datatype => 'text', + datatype => 'integer', pretty_name => 'Item ID', pretty_plural => 'Item IDs' ); attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_rel', attribute_name => 'related_object_id', - datatype => 'text', + datatype => 'integer', pretty_name => 'Related Object ID', pretty_plural => 'Related Object IDs' ); @@ -372,7 +372,7 @@ attr_id := acs_attribute.create_attribute ( object_type => 'cr_item_rel', attribute_name => 'order_n', - datatype => 'text', + datatype => 'integer', pretty_name => 'Sort Order', pretty_plural => 'Sort Orders' ); Index: openacs-4/packages/acs-content-repository/sql/postgresql/types-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/types-create.sql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/acs-content-repository/sql/postgresql/types-create.sql 8 Dec 2001 01:17:59 -0000 1.5 +++ openacs-4/packages/acs-content-repository/sql/postgresql/types-create.sql 27 Jul 2006 20:09:34 -0000 1.6 @@ -398,7 +398,7 @@ select acs_attribute__create_attribute ( 'cr_item_child_rel', 'parent_id', - 'text', + 'integer', 'Parent ID', 'Parent IDs', null, @@ -414,7 +414,7 @@ select acs_attribute__create_attribute ( 'cr_item_child_rel', 'child_id', - 'text', + 'integer', 'Child ID', 'Child IDs', null, @@ -446,7 +446,7 @@ select acs_attribute__create_attribute ( 'cr_item_child_rel', 'order_n', - 'text', + 'integer', 'Sort Order', 'Sort Orders', null, @@ -475,7 +475,7 @@ select acs_attribute__create_attribute ( 'cr_item_rel', 'item_id', - 'text', + 'integer', 'Item ID', 'Item IDs', null, @@ -491,7 +491,7 @@ select acs_attribute__create_attribute ( 'cr_item_rel', 'related_object_id', - 'text', + 'integer', 'Related Object ID', 'Related Object IDs', null, @@ -523,7 +523,7 @@ select acs_attribute__create_attribute ( 'cr_item_rel', 'order_n', - 'text', + 'integer', 'Sort Order', 'Sort Orders', null, Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v diff -u -N -r1.34 -r1.35 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 23 Feb 2005 10:07:00 -0000 1.34 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 27 Jul 2006 20:09:34 -0000 1.35 @@ -106,46 +106,6 @@ pretty_plural => 'Package Keys' ); - attr_id := acs_attribute.create_attribute( - object_type => 'apm_package', - attribute_name => 'package_uri', - datatype => 'string', - pretty_name => 'Package URI', - pretty_plural => 'Package URIs' - ); - - attr_id := acs_attribute.create_attribute( - object_type => 'apm_package', - attribute_name => 'spec_file_path', - datatype => 'string', - pretty_name => 'Specification File Path', - pretty_plural => 'Specification File Paths' - ); - - attr_id := acs_attribute.create_attribute( - object_type => 'apm_package', - attribute_name => 'spec_file_mtime', - datatype => 'number', - pretty_name => 'Specification File Modified Time', - pretty_plural => 'Specification File Modified Times' - ); - - attr_id := acs_attribute.create_attribute( - object_type => 'apm_package', - attribute_name => 'singleton_p', - datatype => 'boolean', - pretty_name => 'Singleton', - pretty_plural => 'Singletons' - ); - - attr_id := acs_attribute.create_attribute( - object_type => 'apm_package', - attribute_name => 'initial_install_p', - datatype => 'boolean', - pretty_name => 'Initial Install', - pretty_plural => 'Initial Installs' - ); - end; / show errors; @@ -454,7 +414,7 @@ attr_id := acs_attribute.create_attribute( object_type => 'apm_package_version', attribute_name => 'enabled_p', - datatype => 'string', + datatype => 'boolean', pretty_name => 'Enabled', pretty_plural => 'Enabled' ); @@ -470,7 +430,7 @@ attr_id := acs_attribute.create_attribute( object_type => 'apm_package_version', attribute_name => 'deactivation_date', - datatype => 'string', + datatype => 'date', pretty_name => 'Deactivation Date', pretty_plural => 'Deactivation Dates' ); @@ -723,7 +683,7 @@ attr_id := acs_attribute.create_attribute( object_type => 'apm_parameter', attribute_name => 'max_n_values', - datatype => 'string', + datatype => 'integer', pretty_name => 'Maximum Number of Values', pretty_plural => 'Maximum Number of Values Settings', default_value => 1 Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -N -r1.62 -r1.63 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 4 Jun 2006 00:45:38 -0000 1.62 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 27 Jul 2006 20:09:34 -0000 1.63 @@ -123,86 +123,6 @@ ''f'' ); - attr_id := acs_attribute__create_attribute ( - ''apm_package'', - ''package_uri'', - ''string'', - ''Package URI'', - ''Package URIs'', - null, - null, - null, - 1, - 1, - null, - ''type_specific'', - ''f'' - ); - - attr_id := acs_attribute__create_attribute ( - ''apm_package'', - ''spec_file_path'', - ''string'', - ''Specification File Path'', - ''Specification File Paths'', - null, - null, - null, - 1, - 1, - null, - ''type_specific'', - ''f'' - ); - - attr_id := acs_attribute__create_attribute ( - ''apm_package'', - ''spec_file_mtime'', - ''number'', - ''Specification File Modified Time'', - ''Specification File Modified Times'', - null, - null, - null, - 1, - 1, - null, - ''type_specific'', - ''f'' - ); - - attr_id := acs_attribute__create_attribute ( - ''apm_package'', - ''initial_install_p'', - ''boolean'', - ''Initial Install'', - ''Initial Installs'', - null, - null, - null, - 1, - 1, - null, - ''type_specific'', - ''f'' - ); - - attr_id := acs_attribute__create_attribute ( - ''apm_package'', - ''singleton_p'', - ''boolean'', - ''Singleton'', - ''Singletons'', - null, - null, - null, - 1, - 1, - null, - ''type_specific'', - ''f'' - ); - return 0; end;' language 'plpgsql'; @@ -585,7 +505,7 @@ attr_id := acs_attribute__create_attribute ( ''apm_package_version'', ''enabled_p'', - ''string'', + ''boolean'', ''Enabled'', ''Enabled'', null, @@ -617,7 +537,7 @@ attr_id := acs_attribute__create_attribute ( ''apm_package_version'', ''deactivation_date'', - ''string'', + ''date'', ''Deactivation Date'', ''Deactivation Dates'', null, @@ -945,7 +865,7 @@ attr_id := acs_attribute__create_attribute ( ''apm_parameter'', ''max_n_values'', - ''string'', + ''integer'', ''Maximum Number of Values'', ''Maximum Number of Values Settings'', null,