Changeset 4688 for temp/trunk

Timestamp:

2006/09/13 12:34:53 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/lib/slib.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -17 +17 @@
 function sfTabaleExists($table_name) {
     $objQuery = new SC_Query(); 
-    $sql = "SELECT
-                relname
-            FROM
-                pg_class
-            WHERE
-                (relkind = 'r' OR relkind = 'v') AND 
-                relname = ? 
-            GROUP BY
-                relname";
-    $arrRet = $objQuery->getAll($sql, array($table_name));
-    if(count($arrRet) > 0) {
-        $flg = true;
-    } else {
-        $flg = false;
-    }   
+    // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë
+    if (DB_TYPE == "pgsql") {
+        $sql = "SELECT
+                    relname
+                FROM
+                    pg_class
+                WHERE
+                    (relkind = 'r' OR relkind = 'v') AND 
+                    relname = ? 
+                GROUP BY
+                    relname";
+        $arrRet = $objQuery->getAll($sql, array($table_name));
+        if(count($arrRet) > 0) {
+            $flg = true;
+        } else {
+            $flg = false;
+        }   
+    }else if (DB_TYPE == "mysql") { 
+        $sql = "SHOW TABLE STATUS LIKE ?";
+        $arrRet = $objQuery->getAll($sql, array($table_name));
+        if(count($arrRet) > 0) {
+            $flg = true;
+        } else {
+            $flg = false;
+        }   
+    }
     return $flg;
 }