audit_trail.h Source File

00001 #ifndef __AUDIT_TRAIL_H
00002 #define __AUDIT_TRAIL_H
00003 /*-------------------------------------------------------------------------
00004  * Copyright (c) 2000-2002 Kenneth W. Sodemann (stuffle@charter.net)
00005  *-------------------------------------------------------------------------
00006  * $Id: audit_trail.h,v 1.7 2002/01/30 00:40:02 stuffle Exp $
00007  *
00008  * This program is free software; you can redistribute it and/or modify
00009  * it under the terms of the GNU General Public License as published by
00010  * the Free Software Foundation; either version 2 of the License, or
00011  * (at your option) any later version.
00012  *
00013  * This program is distributed in the hope that it will be useful,
00014  * but WITHOUT ANY WARRANTY; without even the implied warranty of
00015  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
00016  * GNU General Public License for more details.
00017  *
00018  * You should have received a copy of the GNU General Public License
00019  * along with this program; if not, write to
00020  * Free Software Foundation, Inc.
00021  * 59 Temple Place, Suite 330 
00022  * Boston, MA  02111-1307  USA
00023  *-------------------------------------------------------------------------
00024  */
00076 #define SELECT_AUDIT_TRAIL "\
00077 SELECT at.the_date || ' - Status changed from ' || stat1.name || \
00078        ' to ' || stat2.name || ' by ' || at.login_id \
00079   FROM audit_trail at, status stat1, status stat2 \
00080  WHERE stat1.status_num = at.prev_state \
00081    AND stat2.status_num = at.new_state \
00082    AND at.prev_state <> at.new_state \
00083    AND at.problem_num = %d \
00084  UNION \
00085 SELECT at.the_date || ' - Severity changed from ' || sevr1.name || \
00086        ' to ' || sevr2.name || ' by ' || at.login_id \
00087   FROM audit_trail at, severity sevr1, severity sevr2 \
00088  WHERE sevr1.severity_num = at.prev_sevr \
00089    AND sevr2.severity_num = at.new_sevr \
00090    AND at.prev_sevr <> at.new_sevr \
00091    AND at.problem_num = %d \
00092  ORDER BY 1 "
00093 
00094 
00095 #define PR_SUBMIT_DATE_QUERY "\
00096 SELECT creation_date || ' - Problem report submitted by ' || submitter_id \
00097   FROM problem_report \
00098  WHERE problem_num = %d "
00099 
00100 #endif