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.3 -r1.4
--- openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql	5 May 2003 01:21:05 -0000	1.3
+++ openacs-4/contrib/packages/general-comments/sql/postgresql/general-comments-create.sql	5 Jun 2003 00:49:52 -0000	1.4
@@ -13,25 +13,25 @@
 -- create a table to extend cr_items
 create table general_comments (
     comment_id  integer  constraint general_comments_comment_id_fk
-                references cr_revision (revision_id) on delete cascade 
+                references cr_revisions (revision_id) on delete cascade 
                 constraint general_comments_pk
                 primary key,
-    object_id   integer constraint general_comments_object_id_fk
+    related_object_id   integer constraint general_comments_object_id_fk
 	        references acs_objects (object_id) on delete cascade,
-    package_id  integer constraing general_comments_package_id_fk
+    package_id  integer constraint general_comments_package_id_fk
 		references apm_packages (package_id) on delete cascade
 );
 
 comment on table general_comments is '
     Extends the cr_revisions table to hold item level data.
 '; 
-comment on column general_comments.object_id is '
+comment on column general_comments.related_object_id is '
     The id of the object to associate message with
 ';
 -- unused catergory feature removed. Should be new categories package. DaveB
 
 -- create an index on foreign key constraint
-create index general_comments_object_id_idx on general_comments (object_id);
+create index general_comments_rel_object_id_idx on general_comments (related_object_id);
 
 create function inline_0 ()
 returns integer as '
