Index: openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/sql/postgresql/Attic/general-comments-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql	5 Jun 2003 00:49:52 -0000	1.4
+++ openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql	7 Jul 2003 00:55:23 -0000	1.5
@@ -13,7 +13,7 @@
 -- create a table to extend cr_items
 create table general_comments (
     comment_id  integer  constraint general_comments_comment_id_fk
-                references cr_revisions (revision_id) on delete cascade 
+                references cr_items (item_id) on delete cascade 
                 constraint general_comments_pk
                 primary key,
     related_object_id   integer constraint general_comments_object_id_fk
@@ -23,7 +23,7 @@
 );
 
 comment on table general_comments is '
-    Extends the cr_revisions table to hold item level data.
+    Extends the cr_items table to hold item level data.
 '; 
 comment on column general_comments.related_object_id is '
     The id of the object to associate message with
@@ -105,12 +105,12 @@
 
 select content_type__create_type (
         'general_comment',        -- content_type
-	'content_revision',         -- supertype
+	'content_item',         -- supertype
 	'General Comment',       -- pretty_name
 	'General Comments',      -- pretty_plural
 	'general_comments',            -- table_name
 	'comment_id',              -- id_column
-	'content_revision__revision_name'  -- name_method
+	'content_item__name'  -- name_method
 );
 
 
