|
From: Jirka P. <fi...@us...> - 2002-06-26 13:49:38
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv10850/phpbt/inc/db Modified Files: pgsql.php Log Message: Database independency nightmare bugfix. Not tested. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.12 retrieving revision 1.13 diff -u -r1.12 -r1.13 --- pgsql.php 26 Jun 2002 12:30:43 -0000 1.12 +++ pgsql.php 26 Jun 2002 13:49:34 -0000 1.13 @@ -135,8 +135,8 @@ '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_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '. - 'left join '.TBL_VERSION.' on version2 b.to_be_closed_in_version_id = version2.version_id '. - 'left join '.TBL_VERSION.' on version3 b.closed_id_version_id = version3.version_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_id_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 '. |