Changeset 5302 for temp/trunk/html

Timestamp:

2006/09/21 17:16:26 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html

Files:

• admin/contents/csv_sql.php (modified) (2 diffs)
• admin/system/update.php (modified) (3 diffs)
• install/create_table_mysql.sql (modified) (previous)
• install/create_table_pgsql.sql (modified) (previous)

temp/trunk/html/admin/contents/csv_sql.php

@@ -330 +330 @@
         if (count($arrSqlData) > 0) {
             // ¥Ç¡¼¥¿¹¹¿·
-            $sql = "UPDATE dtb_csv_sql SET name = ?, sql = ?, update_date = now() WHERE sql_id = ? ";
+            $sql = "UPDATE dtb_csv_sql SET sql_name = ?, csv_sql = ?, update_date = now() WHERE sql_id = ? ";
             $arrVal= array($arrData['name'], $arrData['sql'], $sql_id);
         }else{
             // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
             $sql_id = "";
-            $sql = "INSERT INTO dtb_csv_sql (name, sql, create_date, update_date) values (?, ?, now(), now()) ";
+            $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
             $arrVal= array($arrData['name'], $arrData['sql']);
             
@@ -341 +341 @@
     }else{
         // ¥Ç¡¼¥¿¤Î¿·µ¬ºîÀ®
-        $sql = "INSERT INTO dtb_csv_sql (name, sql, create_date, update_date) values (?, ?, now(), now()) ";
+        $sql = "INSERT INTO dtb_csv_sql (sql_name, csv_sql, create_date, update_date) values (?, ?, now(), now()) ";
         $arrVal= array($arrData['name'], $arrData['sql']);
     }

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

@@ -142 +142 @@
                 $sqlval['main_php'] = $arrCSV[5];
                 $sqlval['extern_php'] = $arrCSV[6];
-                $sqlval['sql'] = $arrCSV[7];
+                $sqlval['install_sql'] = $arrCSV[7];
                 $sqlval['uninstall_sql'] = $arrCSV[8];              
                 $sqlval['other_files'] = $arrCSV[9];
@@ -169 +169 @@
     
     $objQuery = new SC_Query();
-    $arrRet = $objQuery->select("module_id, extern_php, other_files, sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
+    $arrRet = $objQuery->select("module_id, extern_php, other_files, install_sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
     $flg_ok = true; // ½èÍý¤ÎÀ®¸ùȽÄê
     
@@ -217 +217 @@
     
     $objQuery = new SC_Query();
-    $arrRet = $objQuery->select("module_id, extern_php, other_files, sql, uninstall_sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
+    $arrRet = $objQuery->select("module_id, extern_php, other_files, install_sql, uninstall_sql, latest_version", "dtb_update", "module_id = ?", array($_POST['module_id']));
     $flg_ok = true; // ½èÍý¤ÎÀ®¸ùȽÄê