|
From: Jirka P. <fi...@us...> - 2002-05-19 13:25:52
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv14181/phpbt/inc/db Modified Files: mysql.php oci8.php pgsql.php Log Message: Added query for listing databases. Index: mysql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v retrieving revision 1.6 retrieving revision 1.7 diff -u -r1.6 -r1.7 --- mysql.php 4 Apr 2002 13:54:03 -0000 1.6 +++ mysql.php 19 May 2002 13:25:48 -0000 1.7 @@ -1,5 +1,4 @@ <?php - $QUERY = array( 'admin-list-groups' => 'select ag.group_id, group_name, locked, '. 'count(ug.group_id) as count '. @@ -30,6 +29,11 @@ 'from '.TBL_SEVERITY. ' s left join '.TBL_BUG.' using (severity_id) '. 'group by s.severity_id, severity_name, severity_desc, severity_color, '. 'sort_order '. + 'order by %s %s', + 'admin-list-databases' => 'select d.database_id, database_name, '. + 'database_version, sort_order, count(bug_id) as bug_count '. + 'from '.TBL_DATABASE. ' d left join '.TBL_BUG.' using (database_id) '. + 'group by d.database_id, database_name, database_version, sort_order '. 'order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. 'sort_order, count(bug_id) as bug_count '. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- oci8.php 4 Apr 2002 13:54:03 -0000 1.5 +++ oci8.php 19 May 2002 13:25:48 -0000 1.6 @@ -32,6 +32,12 @@ 'group by s.severity_id, severity_name, severity_desc, severity_color, '. 'sort_order '. 'order by %s %s', + 'admin-list-databases' => 'select d.database_id, database_name, '. + 'database_version, sort_order, count(bug_id) as bug_count '. + 'from '.TBL_DATABASE.' d, '.TBL_BUG.' b '. + 'where d.database_id = b.database_id(+) '. + 'group by d.database_id, database_name, database_version, sort_order '. + 'order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. 'sort_order, count(bug_id) as bug_count '. 'from '.TBL_STATUS.' s, '.TBL_BUG.' b '. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.7 retrieving revision 1.8 diff -u -r1.7 -r1.8 --- pgsql.php 4 Apr 2002 13:54:03 -0000 1.7 +++ pgsql.php 19 May 2002 13:25:48 -0000 1.8 @@ -31,6 +31,11 @@ 'group by s.severity_id, severity_name, severity_desc, severity_color, '. 'sort_order '. 'order by %s %s', + 'admin-list-databases' => 'select d.database_id, database_name, '. + 'database_version, sort_order, count(bug_id) as bug_count '. + 'from '.TBL_DATABASE. ' d left join '.TBL_BUG.' using (database_id) '. + 'group by d.database_id, database_name, database_version, sort_order '. + 'order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. 'sort_order, count(bug_id) as bug_count '. 'from '.TBL_STATUS.' s left join '. TBL_BUG.' using (status_id) '. |