Index: openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-drop.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-drop.sql	29 Sep 2003 08:05:42 -0000	1.5
+++ openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-drop.sql	8 Dec 2003 05:10:23 -0000	1.6
@@ -12,17 +12,8 @@
 create function inline_0 ()
 returns integer as '
 declare
-	comment_rec			record;
 	entry_rec			record;
 begin
-    -- iterate through all comments on entries
-	for comment_rec in select gc.comment_id 
-	                     from general_comments gc,
-	                          pinds_blog_entries e
-                         where gc.object_id = e.entry_id loop
-		perform acs_message__delete(comment_rec.comment_id);
-	end loop;
-
 	-- iterate through all entries
 	for entry_rec in select entry_id from pinds_blog_entries loop
 		perform pinds_blog_entry__delete( entry_rec.entry_id );
@@ -49,16 +40,17 @@
 
 drop function pinds_blog_entry__title (integer);
 drop function pinds_blog_entry__new(
-    integer,      -- entry_id
-    integer,      -- package_id
-    varchar,      -- title
-    varchar,      -- title_url
-    varchar,      -- content
-    varchar,      -- content_format
-    timestamptz,  -- entry_date
-    char,         -- draft_p
-    integer,      -- creation_user
-    varchar       -- creation_ip
+    integer,     -- entry_id
+    integer,     -- package_id
+    varchar,     -- title
+    varchar,     -- title_url
+    integer,     -- category_id
+    varchar,     -- content
+    varchar,     -- content_format
+    timestamptz, -- entry_date
+    char,        -- draft_p
+    integer,     -- creation_user
+    varchar      -- creation_ip
 );
 drop function pinds_blog_entry__delete (integer);