postgresql7.1
select b.bug_id,
b.project_id,
b.bug_number,
b.summary,
b.component_id,
b.creation_date,
to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
b.resolution,
b.user_agent,
b.found_in_version,
b.found_in_version,
b.fix_for_version,
b.fixed_in_version,
to_char(now(), 'fmMM/DDfm/YYYY') as now_pretty
from bt_bugs b
where b.bug_id = :bug_id
select bt_bug_revision__new (
null,
:bug_id,
:component_id,
:found_in_version,
:fix_for_version,
:fixed_in_version,
:resolution,
:user_agent,
:summary,
now(),
:creation_user,
:creation_ip
);
select current_timestamp