[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.6,1.7 oci8.php,1.5,1.6 pgsql.php,1.7,1.8

[Jirka P. <fi...@us...>]

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) '.