Changeset 21186 for branches/version-2_11-dev/test/createEcCubeData-v25.php

Timestamp:

2011/08/11 19:38:25 (15 years ago)

Author:

shutta

Message:

refs #800 (SQL標準関数を使用する)
CURRENT_TIMESTAMP を使用するように now() を置換。
r21185 のコミット漏れ。

File:

• branches/version-2_11-dev/test/createEcCubeData-v25.php (modified) (5 diffs)

branches/version-2_11-dev/test/createEcCubeData-v25.php

@@ -136 +136 @@
         // 全カテゴリ共通の値
         $sqlval['creator_id'] = 2;
-        $sqlval['create_date'] = "now()";
-        $sqlval['update_date'] = "now()";
+        $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
         $sqlval['del_flg'] = (string) "0";
 
@@ -253 +253 @@
             $sqlval['del_flg'] = (string) "0";
             $sqlval['creator_id'] = 2;
-            $sqlval['create_date'] = "now()";
-            $sqlval['update_date'] = "now()";
+            $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
+            $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
             $sqlval['deliv_date_id'] = 2;
             $this->objQuery->insert("dtb_products", $sqlval);
@@ -281 +281 @@
                               WHERE del_flg = 0) as x),";
         $sqlval['creator_id'] = 2;
-        $sqlval['create_date'] = "now()";
-        $sqlval['update_date'] = "now()";
+        $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
         $sqlval['del_flg'] = (string) "0";
         $this->objQuery->insert("dtb_class", $sqlval);
@@ -308 +308 @@
                                         AND class_id = %d) as x),", $class_id);
         $sqlval['creator_id'] = 2;
-        $sqlval['create_date'] = "now()";
-        $sqlval['update_date'] = "now()";
+        $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
         $sqlval['del_flg'] = (string) "0";
 
@@ -345 +345 @@
         $sqlval['point_rate'] = 10;
         $sqlval['creator_id'] = 2;
-        $sqlval['create_date'] = "now()";
-        $sqlval['update_date'] = "now()";
+        $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
         $sqlval['del_flg'] = 0;