| |
24 |
24 |
for blog_entry in (select entry_id from pinds_blog_entries) loop |
| |
25 |
25 |
|
| |
26 |
26 |
for comment in (select comment_id from general_comments |
| |
27 |
27 |
where object_id = blog_entry.entry_id) loop |
| |
28 |
28 |
acs_message.del(comment.comment_id); |
| |
29 |
29 |
end loop; |
| |
30 |
30 |
|
| |
31 |
31 |
pinds_blog_entry.del(blog_entry.entry_id); |
| |
32 |
32 |
end loop; |
| |
33 |
33 |
|
| |
34 |
34 |
acs_object_type.drop_type('pinds_blog_entry', 't'); |
| |
35 |
35 |
|
| |
36 |
36 |
end; |
| |
37 |
37 |
/ |
| |
38 |
38 |
show errors |
| |
39 |
39 |
|
| |
40 |
40 |
|
| |
41 |
41 |
@@ lars-blogger-package-drop |
| |
42 |
42 |
|
| |
43 |
43 |
drop table pinds_blog_entries; |
| |
|
44 |
|
| |
|
45 |
@@ lars-blogger-categories-drop.sql |
