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

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/inc/db
In directory usw-pr-cvs1:/tmp/cvs-serv29408/inc/db

Modified Files:
	mysql.php oci8.php pgsql.php 
Log Message:
Added deleting of unused versions and components

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- mysql.php	3 Apr 2002 19:08:48 -0000	1.4
+++ mysql.php	4 Apr 2002 13:30:17 -0000	1.5
@@ -141,6 +141,16 @@
 		'left join '.TBL_AUTH_USER.' u on assigned_to = user_id %s '.
 		'group by assigned_to, u.email',
 	'join-where' => 'where',
+	'admin-list-components' => 'select c.component_id, component_name, '.
+		'c.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_COMPONENT.' c left join '.TBL_BUG.' b using(component_id) '.
+		'where c.project_id = %s '.
+		'group by c.component_id, c.component_name, c.created_date, c.active',
+	'admin-list-versions' => 'select v.version_id, version_name, '.
+		'v.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_VERSION.' v left join '.TBL_BUG.' b using(version_id) '.
+		'where v.project_id = %s '.
+		'group by v.version_id, v.version_name, v.created_date, v.active',
 	);
 
 ?>

Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- oci8.php	3 Apr 2002 19:08:48 -0000	1.3
+++ oci8.php	4 Apr 2002 13:30:17 -0000	1.4
@@ -145,6 +145,16 @@
 		'where b.assigned_to = u.user_id(+) %s '.
 		'group by assigned_to, u.email',
 	'join-where' => 'and',
+	'admin-list-components' => 'select c.component_id, component_name, '.
+		'c.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_COMPONENT.' c, '.TBL_BUG.' b '.
+		'where c.project_id = %s and c.component_id = b.component_id(+) '.
+		'group by c.component_id, c.component_name, c.created_date, c.active',
+	'admin-list-versions' => 'select v.version_id, version_name, '.
+		'v.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_VERSION.' v, '.TBL_BUG.' b '.
+		'where v.project_id = %s and v.version_id = b.version_id(+) '.
+		'group by v.version_id, v.version_name, v.created_date, v.active',
 	);
 	
 ?>

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- pgsql.php	3 Apr 2002 19:08:48 -0000	1.5
+++ pgsql.php	4 Apr 2002 13:30:17 -0000	1.6
@@ -141,6 +141,16 @@
 		'left join '.TBL_AUTH_USER.' u on assigned_to = user_id %s '.
 		'group by assigned_to, u.email',
 	'join-where' => 'where',
+	'admin-list-components' => 'select c.component_id, component_name, '.
+		'c.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_COMPONENT.' c left join '.TBL_BUG.' b using(component_id) '.
+		'where c.project_id = %s '.
+		'group by c.component_id, c.component_name, c.created_date, c.active',
+	'admin-list-versions' => 'select v.version_id, version_name, '.
+		'v.created_date, active, count(bug_id) as bug_count '.
+		'from '.TBL_VERSION.' v left join '.TBL_BUG.' b using(version_id) '.
+		'where v.project_id = %s '.
+		'group by v.version_id, v.version_name, v.created_date, v.active',
 	);
 
 ?>