| |
1 |
|
<?xml version="1.0"?> |
| |
2 |
|
|
| |
3 |
|
<queryset> |
| |
4 |
|
<rdbms><type>postgresql</type><version>7.1</version></rdbms> |
| |
5 |
|
|
| |
6 |
|
<fullquery name="general_comment_new.insert_comment"> |
| |
7 |
|
<querytext> |
| |
8 |
|
select acs_message__new ( |
| |
9 |
|
:comment_id, -- 1 p_message_id |
| |
10 |
|
NULL, -- 2 p_reply_to |
| |
11 |
|
current_timestamp, -- 3 p_sent_date |
| |
12 |
|
NULL, -- 4 p_sender |
| |
13 |
|
:rfc822_id, -- 5 p_rfc822_id |
| |
14 |
|
:title, -- 6 p_title |
| |
15 |
|
NULL, -- 7 p_description |
| |
16 |
|
:comment_mime_type, -- 8 p_mime_type |
| |
17 |
|
NULL, -- 9 p_text |
| |
18 |
|
NULL, -- empty_blob(), -- 10 p_data |
| |
19 |
|
-4, -- 11 p_parent_id |
| |
20 |
|
:context_id, -- 12 p_context_id |
| |
21 |
|
:user_id, -- 13 p_creation_user |
| |
22 |
|
:creation_ip, -- 14 p_creation_ip |
| |
23 |
|
'acs_message', -- 15 p_object_type |
| |
24 |
|
:is_live -- 16 p_is_live |
| |
25 |
|
) |
| |
26 |
|
</querytext> |
| |
27 |
|
</fullquery> |
| |
28 |
|
|
| |
29 |
|
<fullquery name="general_comment_new.set_content"> |
| |
30 |
|
<querytext> |
| |
31 |
|
|
| |
32 |
|
update cr_revisions |
| |
33 |
|
set content = :content |
| |
34 |
|
where revision_id = :revision_id |
| |
35 |
|
|
| |
36 |
|
</querytext> |
| |
37 |
|
</fullquery> |
| |
38 |
|
|
| |
39 |
|
</queryset> |
