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

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

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

Modified Files:
	mysql.php 
Log Message:
Adding some columns (versions, database ...). Ben, please check it and make changes to pgsql file. I will then make changes to oci8 file. And of course I will add columns to other queries not only this one. Later.


Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- mysql.php	19 May 2002 13:25:48 -0000	1.7
+++ mysql.php	30 May 2002 15:04:22 -0000	1.8
@@ -126,7 +126,10 @@
 		'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '.
 		'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id '.
 		'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '.
-		'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id, '.
+		'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id '.
+		'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '.
+		'left join '.TBL_VERSION.' version2 on b.to_be_closed_in_version_id = version2.version_id '.
+		'left join '.TBL_VERSION.' version3 on b.closed_in_version_id = version3.version_id, '.
 		TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '.
 		TBL_VERSION.' version, '.TBL_COMPONENT.' component, '.TBL_PROJECT.' project '.
 		'where b.severity_id = severity.severity_id '.