|
From: Benjamin C. <bc...@us...> - 2002-04-04 15:55:35
|
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', ); ?> |