[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.14,1.15 oci8.php,1.12,1.13 pgsql.php,1.19,1.20

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

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\'',