Index: openacs-4/contrib/packages/general-comments/sql/oracle/general-comments-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/sql/oracle/Attic/general-comments-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/general-comments/sql/oracle/general-comments-create.sql	19 Jun 2003 18:04:03 -0000	1.2
+++ openacs-4/contrib/packages/general-comments/sql/oracle/general-comments-create.sql	12 Mar 2004 15:19:14 -0000	1.3
@@ -12,12 +12,12 @@
 -- 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
 	        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
 );
 
@@ -88,15 +88,15 @@
 -- create general comment type as subtype of cr_revision
 begin
 
-select content_type.create_type (
+    content_type.create_type (
         content_type => 'general_comment',
-	supertype => 'content_revision',
-	pretty_name => 'General Comment',
-	pretty_plural => 'General Comments',
-	table_name => 'general_comments',
-	id_column => 'comment_id',
-	name_method => 'content_revision.revision_name'
-);
+	    supertype => 'content_revision',
+        pretty_name => 'General Comment',
+	    pretty_plural => 'General Comments',
+	    table_name => 'general_comments',
+	    id_column => 'comment_id',
+	    name_method => 'content_revision.revision_name'
+    );
 
 end;
 /