Changeset 5677 for temp/trunk/html/admin/system

Timestamp:

2006/09/25 11:26:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/system/bkup.php (modified) (2 diffs)

temp/trunk/html/admin/system/bkup.php

@@ -146 +146 @@
         if ($val != "dtb_bkup") {
             // ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ
-            $arrColumnList = lfGetColumnList($val);
+            $arrAutoInc = lfGetAutoIncrement($val);
             
-            sfprintr($arrColumnList);
+            sfprintr($arrAutoInc);
             
             // Á´¥Ç¡¼¥¿¤ò¼èÆÀ
@@ -246 +246 @@
 }
 
-// ¥Æ¡¼¥Ö¥ë¹½À®¤ò¼èÆÀ¤¹¤ë
-function lfGetColumnList($table_name){
+// ¼«Æ°ºÎÈÖ·¿Ãͤò¼èÆÀ¤¹¤ë
+function lfGetAutoIncrement($table_name){
     $objQuery = new SC_Query();
 
     if(DB_TYPE == "pgsql"){
-        $sql = "SELECT 
-                    a.attname, t.typname, a.attnotnull, d.adsrc as defval, a.atttypmod, a.attnum as fldnum, e.description 
-                FROM 
-                    pg_class c,
-                    pg_type t,
-                    pg_attribute a left join pg_attrdef d on (a.attrelid=d.adrelid and a.attnum=d.adnum)
-                                   left join pg_description e on (a.attrelid=e.objoid and a.attnum=e.objsubid)
-                WHERE (c.relname=?) AND (c.oid=a.attrelid) AND (a.atttypid=t.oid) AND a.attnum > 0
-                ORDER BY fldnum";
+        $sql = "SELECT
+                    ci.relname,
+                    i.indkey
+                FROM
+                    pg_index i,
+                    pg_class c,
+                    pg_class ci
+                WHERE
+                    i.indrelid = c.oid AND
+                    i.indexrelid = ci.oid AND
+                    c.relname = ?
+                ";
         $arrRet = $objQuery->getAll($sql, array($table_name));
     }
     
-    return sfswaparray($arrRet);
+    return $arrRet;
 
 }