cvs: pear /DB/DB fbsql.php
| From: | Frank M. Kromann | Date: | Thu, 16 Dec 2004 18:39:04 +0000 |
| Subject: | cvs: pear /DB/DB fbsql.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-27498@lists.php.net to get a copy of this message | ||
fmk Thu Dec 16 13:39:04 2004 EDT
Modified files:
/pear/DB/DB fbsql.php
Log:
Better implementation. The select now selects tables from current scherma only
http://cvs.php.net/diff.php/pear/DB/DB/fbsql.php?r1=1.42&r2=1.43&ty=u
Index: pear/DB/DB/fbsql.php
diff -u pear/DB/DB/fbsql.php:1.42 pear/DB/DB/fbsql.php:1.43
--- pear/DB/DB/fbsql.php:1.42 Thu Dec 16 00:17:38 2004
+++ pear/DB/DB/fbsql.php Thu Dec 16 13:39:04 2004
@@ -17,7 +17,7 @@
// | Maintainer: Daniel Convissor <danielc@php.net> |
// +----------------------------------------------------------------------+
//
-// $Id: fbsql.php,v 1.42 2004/12/16 05:17:38 fmk Exp $
+// $Id: fbsql.php,v 1.43 2004/12/16 18:39:04 fmk Exp $
// XXX legend:
@@ -37,7 +37,7 @@
* extension.
*
* @package DB
- * @version $Id: fbsql.php,v 1.42 2004/12/16 05:17:38 fmk Exp $
+ * @version $Id: fbsql.php,v 1.43 2004/12/16 18:39:04 fmk Exp $
* @category Database
* @author Frank M. Kromann <frank@frontbase.com>
*/
@@ -637,7 +637,7 @@
{
switch ($type) {
case 'tables':
- return "select \"table_name\" from information_schema.tables where
\"table_type\"='BASE TABLE' AND \"schema_pk\">1";
+ return "select \"table_name\" from information_schema.tables t0,
information_schema.schemata t1 where t0.schema_pk=t1.schema_pk and
\"table_type\"='BASE TABLE' AND \"schema_name\"=current_schema";
default:
return null;
}