|
From: Benjamin C. <bc...@us...> - 2002-09-30 18:02:08
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv16724/inc/db Modified Files: mysql.php oci8.php pgsql.php Log Message: Fixing bug #615945 - Removing all remnants of database_version field. Index: mysql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v retrieving revision 1.14 retrieving revision 1.15 diff -u -r1.14 -r1.15 --- mysql.php 13 Sep 2002 19:33:17 -0000 1.14 +++ mysql.php 30 Sep 2002 18:02:06 -0000 1.15 @@ -31,9 +31,9 @@ '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 '. + '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 '. + 'group by d.database_id, database_name, sort_order '. 'order by %s %s', 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. 'count(bug_id) as bug_count from '.TBL_SITE. ' s left join '. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- oci8.php 13 Sep 2002 19:33:17 -0000 1.12 +++ oci8.php 30 Sep 2002 18:02:06 -0000 1.13 @@ -33,13 +33,13 @@ '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 '. + '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 '. + 'group by d.database_id, database_name, sort_order '. 'order by %s %s', - 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. - 'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG. + 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. + 'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG. 'where s.site_id = b.site_id(+) group by s.site_id, site_name, '. 'sort_order order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.19 retrieving revision 1.20 diff -u -r1.19 -r1.20 --- pgsql.php 13 Sep 2002 19:33:17 -0000 1.19 +++ pgsql.php 30 Sep 2002 18:02:06 -0000 1.20 @@ -32,19 +32,19 @@ '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 '. + '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 '. + 'group by d.database_id, database_name, 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) '. 'group by s.status_id, status_name, status_desc, sort_order '. 'order by %s %s', - 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. - 'count(bug_id) as bug_count from '.TBL_SITE. ' s left join '. - TBL_BUG.' using (site_id) group by s.site_id, site_name, sort_order '. - 'order by %s %s', + 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. + 'count(bug_id) as bug_count from '.TBL_SITE. ' s left join '. + TBL_BUG.' using (site_id) group by s.site_id, site_name, sort_order '. + 'order by %s %s', 'admin-user-groups' => 'select ug.group_id '. 'from '.TBL_USER_GROUP.' ug left join '.TBL_AUTH_GROUP.' g using (group_id) '. 'where user_id = %s and group_name <> \'User\'', |