Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.28 -r1.29
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	7 Jun 2008 20:28:47 -0000	1.28
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	11 Apr 2011 01:08:27 -0000	1.29
@@ -10,26 +10,7 @@
 -- License.  Full text of the license is available from the GNU Project:
 -- http://www.fsf.org/copyleft/gpl.html
 
-----------------------------------
--- CMS datatypes
-----------------------------------
 
--- create ats datatypes for cms
-begin
-  insert into acs_datatypes
-    (datatype, max_n_values)
-  values
-    ('text', null);
-
-  insert into acs_datatypes
-    (datatype, max_n_values)
-  values
-    ('keyword', 1);
-
-end;
-/
-
-
 --------------------------------------------------------------
 -- MIME TYPES
 --------------------------------------------------------------
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-content-repository/sql/oracle/content-drop.sql	30 Sep 2003 12:10:01 -0000	1.3
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-drop.sql	11 Apr 2011 01:08:27 -0000	1.4
@@ -195,20 +195,5 @@
 drop table cr_mime_types ;
 
 
--- dropping ats datatypes for cms
-begin
 
-  delete from acs_datatypes where datatype in ('text');
 
-  delete from acs_datatypes where datatype in ('keyword');
-
-  delete from acs_datatypes where datatype in ('integer');
-
-commit;
-end;
-/
-show errors
-
-
-
-
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 -r1.3 -r1.4
--- openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql	27 Jul 2006 20:09:33 -0000	1.3
+++ openacs-4/packages/acs-content-repository/sql/oracle/types-create.sql	11 Apr 2011 01:08:27 -0000	1.4
@@ -283,6 +283,22 @@
    pretty_plural => 'Language'
  );
 
+ attr_id := content_type.create_attribute (
+   content_type   => 'content_revision',
+   attribute_name => 'item_id',
+   datatype => 'integer',
+   pretty_name => 'Item id',
+   pretty_plural => 'Item ids'
+ );
+
+ attr_id := content_type.create_attribute (
+   content_type   => 'content_revision',
+   attribute_name => 'content',
+   datatype => 'text',
+   pretty_name => 'content',
+   pretty_plural => 'content'
+ );
+
 end;
 /
 show errors
Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.7.0d3-5.7.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.7.0d3-5.7.0d4.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.7.0d3-5.7.0d4.sql	11 Apr 2011 01:08:27 -0000	1.1
@@ -0,0 +1,23 @@
+declare
+ attr_id	acs_attributes.attribute_id%TYPE;
+begin
+
+ attr_id := content_type.create_attribute (
+   content_type   => 'content_revision',
+   attribute_name => 'item_id',
+   datatype => 'integer',
+   pretty_name => 'Item id',
+   pretty_plural => 'Item ids'
+ );
+
+ attr_id := content_type.create_attribute (
+   content_type   => 'content_revision',
+   attribute_name => 'content',
+   datatype => 'text',
+   pretty_name => 'content',
+   pretty_plural => 'content'
+ );
+
+end;
+/
+show errors
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-drop.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-drop.sql	27 Sep 2001 22:48:16 -0000	1.4
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-drop.sql	11 Apr 2011 01:08:27 -0000	1.5
@@ -208,17 +208,3 @@
 drop table cr_mime_types ;
 
 
--- dropping ats datatypes for cms
-begin;
-
-  delete from acs_datatypes where datatype in ('text');
-
-  delete from acs_datatypes where datatype in ('keyword');
-
-  delete from acs_datatypes where datatype in ('integer');
-
-commit;
-
-
-
-