Changeset 19742


Ignore:
Timestamp:
2010/12/18 20:04:49 (12 years ago)
Author:
AMUAMU
Message:

#657 (CSVダウンロードの改善） のうち商品CSVダウンロードの修正。
#781 (規格のデータベースを木構造に) の影響により機能していなかった商品ＣＳＶダウンロード機能の修正。
#823 (商品種別によってカートを分ける) や #792 (ダウンロード販売機能) による影響部分も修正。

Location:
branches/version-2_5-dev
Files:
7 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_5-dev/data/class/SC_Product.php

    r19740 r19742  
    716716 
    717717    /** 
     718     * 商品規格詳細の SQL を取得する. 
     719     * 
     720     * MEMO: 2.4系 vw_product_classに相当(?)するイメージ 
     721     * 
     722     * @param string $where 商品詳細の WHERE 句 
     723     * @return string 商品規格詳細の SQL 
     724     */ 
     725    function prdclsSQL($where = "") { 
     726        $whereCause = ""; 
     727        if (!SC_Utils_Ex::isBlank($where)) { 
     728            $whereCause = " WHERE " . $where; 
     729        } 
     730        $sql = <<< __EOS__ 
     731        ( 
     732             SELECT dtb_products.*, 
     733                    dtb_products_class.product_class_id, 
     734                    dtb_products_class.class_combination_id, 
     735                    dtb_products_class.product_type_id, 
     736                    dtb_products_class.product_code, 
     737                    dtb_products_class.stock, 
     738                    dtb_products_class.stock_unlimited, 
     739                    dtb_products_class.sale_limit, 
     740                    dtb_products_class.price01, 
     741                    dtb_products_class.price02, 
     742                    dtb_products_class.deliv_fee, 
     743                    dtb_products_class.point_rate, 
     744                    dtb_products_class.down_filename, 
     745                    dtb_products_class.down_realfilename, 
     746                    dtb_class_combination.parent_class_combination_id, 
     747                    dtb_class_combination.classcategory_id, 
     748                    dtb_class_combination.level as classlevel, 
     749                    Tpcm.classcategory_id as parent_classcategory_id, 
     750                    Tpcm.level as parent_classlevel, 
     751                    Tcc1.class_id as class_id, 
     752                    Tcc1.name as classcategory_name, 
     753                    Tcc2.class_id as parent_class_id, 
     754                    Tcc2.name as parent_classcategory_name 
     755             FROM dtb_products 
     756                 LEFT JOIN dtb_products_class 
     757                     ON dtb_products.product_id = dtb_products_class.product_id 
     758                 LEFT JOIN dtb_class_combination 
     759                     ON dtb_products_class.class_combination_id = dtb_class_combination.class_combination_id 
     760                 LEFT JOIN dtb_class_combination as Tpcm 
     761                     ON dtb_class_combination.parent_class_combination_id = Tpcm.class_combination_id 
     762                 LEFT JOIN dtb_classcategory as Tcc1 
     763                     ON dtb_class_combination.classcategory_id = Tcc1.classcategory_id 
     764                 LEFT JOIN dtb_classcategory as Tcc2 
     765                     ON Tpcm.classcategory_id = Tcc2.classcategory_id 
     766        ) as prdcls 
     767__EOS__; 
     768        return $sql; 
     769    } 
     770     
     771    /** 
    718772     * 商品規格ID1、2に紐づいた,product_class_idを取得する. 
    719773     * 

  • branches/version-2_5-dev/data/class/SC_Query.php

    r19732 r19742  
    216216        return $this->query($str, $arrval); 
    217217    } 
     218     
     219    /** 
     220     * クエリを実行し、結果行毎にコールバック関数を適用する 
     221     * 
     222     * @param callback $function コールバック先 
     223     * @param string $sql SQL クエリ 
     224     * @param array $arrVal プリペアドステートメントの実行時に使用される配列。配列の要素数は、クエリ内のプレースホルダの数と同じでなければなりません。  
     225     * @param integer $fetchmode 使用するフェッチモード。デフォルトは DB_FETCHMODE_ASSOC。 
     226     * @return boolean 結果 
     227     */ 
     228    function doCallbackAll($cbFunc, $sql, $arrval = array(), $fetchmode = MDB2_FETCHMODE_ASSOC) { 
     229 
     230        $sql = $this->dbFactory->sfChangeMySQL($sql); 
     231 
     232        $sth =& $this->prepare($sql); 
     233        if (PEAR::isError($sth) && $this->force_run) { 
     234            return; 
     235        } 
     236 
     237        $affected =& $this->execute($sth, $arrval); 
     238        if (PEAR::isError($affected) && $this->force_run) { 
     239            return; 
     240        } 
     241         
     242        while($data = $affected->fetchRow($fetchmode)) { 
     243            $result = call_user_func($cbFunc, &$data); 
     244            if($result === false) { 
     245                break; 
     246            } 
     247        } 
     248        $sth->free(); 
     249        return $result; 
     250    } 
    218251 
    219252    /** 

  • branches/version-2_5-dev/data/class/helper/SC_Helper_CSV.php

    r19730 r19742  
    120120        $data = $objCSV->lfGetCSV("dtb_order", $where, $option, $arrval, $arrCsvOutputCols, $arrCsvOutputConvs); 
    121121    } 
     122     
     123    //  CSV作成 コールバック関数 
     124    function cbOutputProductCSV($data) { 
     125        $line = $this->sfArrayToCSV($data); 
     126        $line = mb_convert_encoding($line, 'SJIS-Win'); 
     127        $line .= "\r\n"; 
     128        fwrite($this->fpOutput, $line); 
     129        return true; 
     130    } 
    122131 
    123132    // CSVを送信する。(商品) 
    124     function sfDownloadProductsCsv($where, $arrval, $order) { 
     133    function sfDownloadProductsCsv($where, $arrval, $order, $is_download = false) { 
    125134 
    126135        // CSV出力タイトル行の作成 
    … …  
    131140        $objQuery = new SC_Query(); 
    132141        $objQuery->setOrder($order); 
    133  
    134         /* 
    135          * FIXME 
    136          * パフォーマンスが出ないため, 
    137          * SC_Product::getProductsClassByProductIds() を使用した実装に変更 
    138          */ 
    139         $dataRows = $objQuery->select( 
    140              SC_Utils_Ex::sfGetCommaList($arrOutputCols, true, array('category_id')) 
    141             ,'vw_product_class AS prdcls' 
    142             ,$where 
    143             ,$arrval 
    144         ); 
    145          
    146         // 規格分類名一覧 
    147         if (in_array('classcategory_id1', $arrOutputCols) || in_array('classcategory_id2', $arrOutputCols)) { 
    148             $objDb = new SC_Helper_DB_Ex(); 
    149             $arrClassCatName = $objDb->sfGetIDValueList("dtb_classcategory", "classcategory_id", "name"); 
    150         } 
    151  
    152         $outputArray = array(); 
    153          
    154         // ヘッダ行 
    155         $outputArray[] = $arrOutput['disp_name']; 
    156          
    157         $objQuery = new SC_Query(); 
    158         // データ行 
    159         foreach ($dataRows as $row) { 
    160             // 規格名1 
    161             if (in_array('classcategory_id1', $arrOutputCols)) { 
    162                 $row['classcategory_id1'] = $arrClassCatName[$row['classcategory_id1']]; 
    163             } 
    164  
    165             // 規格名2 
    166             if (in_array('classcategory_id2', $arrOutputCols)) { 
    167                 $row['classcategory_id2'] = $arrClassCatName[$row['classcategory_id2']]; 
    168             } 
    169  
    170             // カテゴリID 
    171             if (in_array('category_id', $arrOutputCols)) { 
    172                 $row['category_id'] = $objQuery->getCol( 
    173                     "category_id", 
    174                     "dtb_product_categories", 
    175                     "product_id = ?", 
    176                     array($row['product_id']) 
    177                 ); 
    178             } 
    179  
    180             $outputArray[] = $row; 
    181         } 
    182          
    183         // CSVを送信する。 
    184         #$this->lfDownloadCsv($outputArray); 
    185         return $this->lfGetCsv2($outputArray); 
    186          
    187         // 成功終了 
    188         #return true; 
     142         
     143        $objProduct = new SC_Product(); 
     144        $cols = SC_Utils_Ex::sfGetCommaList($arrOutputCols, true); 
     145        $sql = $objQuery->getSql($cols, $objProduct->prdclsSQL(),$where); 
     146        $header = $this->sfArrayToCSV($arrOutput['disp_name']); 
     147        $header = mb_convert_encoding($header, 'SJIS-Win'); 
     148        $header .= "\r\n"; 
     149         
     150        //テンポラリファイル作成 
     151        // TODO: パフォーマンス向上には、ストリームを使うようにすると良い 
     152        //  環境要件がバージョン5.1以上になったら使うように変えても良いかと 
     153        //  fopen('php://temp/maxmemory:'. (5*1024*1024), 'r+'); 
     154        $tmp_filename = tempnam(CSV_TEMP_DIR, 'product_csv'); 
     155        $this->fpOutput = fopen($tmp_filename, "w+"); 
     156 
     157        fwrite($this->fpOutput, $header); 
     158 
     159        $objQuery->doCallbackAll(array(&$this, 'cbOutputProductCSV'), $sql, $arrval); 
     160 
     161        fclose($this->fpOutput); 
     162 
     163        if($is_download) { 
     164            // CSVを送信する。 
     165            $this->lfDownloadCSVFile($tmp_filename,"product_"); 
     166            $res = true; 
     167        }else{ 
     168            $res = SC_Utils_Ex::sfReadFile($tmp_filename); 
     169        } 
     170         
     171        //テンポラリファイル削除 
     172        unlink($tmp_filename); 
     173        return $res; 
    189174    } 
    190175 
    … …  
    498483        } 
    499484    } 
     485     
     486    /** 
     487     * CSVファイルを送信する。 
     488     */ 
     489    function lfDownloadCSVFile($filepath, $prefix = "") { 
     490        $file_name = $prefix . date("YmdHis") . ".csv"; 
     491         
     492        /* HTTPヘッダの出力 */ 
     493        Header("Content-disposition: attachment; filename=${file_name}"); 
     494        Header("Content-type: application/octet-stream; name=${file_name}"); 
     495        Header("Cache-Control: "); 
     496        Header("Pragma: "); 
     497         
     498        /* データを出力 */ 
     499        // file_get_contentsはメモリマッピングも自動的に使ってくれるので高速＆省メモリ 
     500        echo file_get_contents($filepath); 
     501    } 
    500502 
    501503    /** 

  • branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r19670 r19742  
    250250 
    251251                        // CSVを送信する。正常終了の場合、終了。 
    252                         list($fime_name, $data) = $objCSV->sfDownloadProductsCsv($where, $arrval, $order); 
    253                         $this->sendResponseCSV($fime_name, $data); 
     252                        $objCSV->sfDownloadProductsCsv($where, $arrval, $order, true); 
     253                        // FIXME: sendResponseに渡した方が良いのか？ 
     254//                        $data = $objCSV->sfDownloadProductsCsv($where, $arrval, $order); 
     255//                        $this->sendResponseCSV($fime_name, $data); 
    254256                        exit; 
    255257                        break; 

  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r19740 r19742  
    831831    disp_name text, 
    832832    rank int, 
     833    rw_flg smallint DEFAULT 1, 
    833834    status smallint NOT NULL DEFAULT 1, 
    834835    create_date datetime NOT NULL, 

  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r19740 r19742  
    833833    disp_name text, 
    834834    rank int, 
     835    rw_flg smallint DEFAULT 1, 
    835836    status smallint NOT NULL DEFAULT 1, 
    836837    create_date timestamp NOT NULL DEFAULT now(), 

  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r19740 r19742  
    170170INSERT INTO dtb_classcategory (classcategory_id, name, class_id, rank, creator_id, create_date, update_date, del_flg) VALUES (0, NULL, 0, 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    171171 
    172 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (1, 1, 'product_id', '商品ID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    173 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (2, 1, 'product_class_id', '規格ID', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    174 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (3, 1, 'classcategory_id1', '規格名1', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    175 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (4, 1, 'classcategory_id2', '規格名2', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    176 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (5, 1, 'name', '商品名', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    177 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (6, 1, 'status', '公開フラグ', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    178 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (7, 1, 'product_flag', '商品ステータス', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    179 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (8, 1, 'product_code', '商品コード', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    180 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (9, 1, 'price01', '通常価格', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    181 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (10, 1, 'price02', '販売価格', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    182 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (11, 1, 'stock', '在庫数', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    183 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (12, 1, 'deliv_fee', '送料', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    184 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (13, 1, 'point_rate', 'ポイント付与率', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    185 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (14, 1, 'sale_limit', '購入制限', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    186 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (15, 1, 'comment1', 'メーカーURL', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    187 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (16, 1, 'comment3', '検索ワード', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    188 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (17, 1, 'note', '備考欄(SHOP専用)', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    189 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (18, 1, 'main_list_comment', '一覧-メインコメント', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    190 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (19, 1, 'main_list_image', '一覧-メイン画像', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    191 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (20, 1, 'main_comment', '詳細-メインコメント', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    192 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (21, 1, 'main_image', '詳細-メイン画像', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    193 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (22, 1, 'main_large_image', '詳細-メイン拡大画像 ', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    194 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (25, 1, 'sub_title1', '詳細-サブタイトル(1)', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    195 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (26, 1, 'sub_comment1', '詳細-サブコメント(1)', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    196 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (27, 1, 'sub_image1', '詳細-サブ画像(1)', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    197 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (28, 1, 'sub_large_image1', '詳細-サブ拡大画像(1)', 28, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    198 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (29, 1, 'sub_title2', '詳細-サブタイトル(2)', 29, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    199 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (30, 1, 'sub_comment2', '詳細-サブコメント(2)', 30, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    200 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (31, 1, 'sub_image2', '詳細-サブ画像(2)', 31, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    201 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (32, 1, 'sub_large_image2', '詳細-サブ拡大画像(2)', 32, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    202 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (33, 1, 'sub_title3', '詳細-サブタイトル(3)', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    203 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (34, 1, 'sub_comment3', '詳細-サブコメント(3)', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    204 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (35, 1, 'sub_image3', '詳細-サブ画像(3)', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    205 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (36, 1, 'sub_large_image3', '詳細-サブ拡大画像(3)', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    206 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (37, 1, 'sub_title4', '詳細-サブタイトル(4)', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    207 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (38, 1, 'sub_comment4', '詳細-サブコメント(4)', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    208 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (39, 1, 'sub_image4', '詳細-サブ画像(4)', 39, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    209 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (40, 1, 'sub_large_image4', '詳細-サブ拡大画像(4)', 40, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    210 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (41, 1, 'sub_title5', '詳細-サブタイトル(5)', 41, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    211 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (42, 1, 'sub_comment5', '詳細-サブコメント(5)', 42, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    212 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (43, 1, 'sub_image5', '詳細-サブ画像(5)', 43, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    213 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (44, 1, 'sub_large_image5', '詳細-サブ拡大画像(5)', 44, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    214 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (45, 1, 'deliv_date_id', '発送日目安', 45, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    215 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (46, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 0) AS recommend_product_id1', '関連商品(1)', 46, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    216 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (47, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 0) AS recommend_comment1', '関連商品コメント(1)', 47, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    217 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (48, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 1) AS recommend_product_id2', '関連商品(2)', 48, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    218 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (49, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 1) AS recommend_comment2', '関連商品コメント(2)', 49, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    219 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (50, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 2) AS recommend_product_id3', '関連商品(3)', 50, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    220 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (51, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 2) AS recommend_comment3', '関連商品コメント(3)', 51, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    221 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (52, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 3) AS recommend_product_id4', '関連商品(4)', 52, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    222 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (53, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 3) AS recommend_comment4', '関連商品コメント(4)', 53, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    223 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (54, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 4) AS recommend_product_id5', '関連商品(5)', 54, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    224 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (55, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 4) AS recommend_comment5', '関連商品コメント(5)', 55, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    225 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (56, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 5) AS recommend_product_id6', '関連商品(6)', 56, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    226 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (57, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 5) AS recommend_comment6', '関連商品コメント(6)', 57, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    227 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (58, 1, 'category_id', 'カテゴリID', 58, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    228 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (59, 1, 'down', '実商品・ダウンロード', 59, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    229 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (60, 1, 'down_filename', 'ダウンロードファイル名', 60, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    230 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (61, 1, 'down_realfilename', 'ダウンロード商品用ファイルアップロード', 61, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    231 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (62, 2, 'customer_id', '顧客ID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    232 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (63, 2, 'name01', 'お名前(姓)', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    233 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (64, 2, 'name02', 'お名前(名)', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    234 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (65, 2, 'kana01', 'お名前(フリガナ・姓)', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    235 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (66, 2, 'kana02', 'お名前(フリガナ・名)', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    236 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (67, 2, 'zip01', '郵便番号1', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    237 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (68, 2, 'zip02', '郵便番号2', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    238 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (69, 2, 'pref', '都道府県', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    239 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (70, 2, 'addr01', '住所1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    240 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (71, 2, 'addr02', '住所2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    241 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (72, 2, 'email', 'E-MAIL', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    242 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (73, 2, 'tel01', 'TEL1', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    243 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (74, 2, 'tel02', 'TEL2', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    244 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (75, 2, 'tel03', 'TEL3', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    245 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (76, 2, 'fax01', 'FAX1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    246 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (77, 2, 'fax02', 'FAX2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    247 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (78, 2, 'fax03', 'FAX3', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    248 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (79, 2, 'sex', '性別', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    249 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (80, 2, 'job', '職業', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    250 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (81, 2, 'birth', '誕生日', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    251 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (82, 2, 'first_buy_date', '初回購入日', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    252 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (83, 2, 'last_buy_date', '最終購入日', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    253 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (84, 2, 'buy_times', '購入回数', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    254 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (85, 2, 'point', 'ポイント残高', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    255 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (86, 2, 'note', '備考', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    256 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (87, 2, 'create_date', '登録日', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    257 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (88, 2, 'update_date', '更新日', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    258 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (89, 3, 'order_id', '注文番号', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    259 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (90, 3, 'customer_id', '顧客ID', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    260 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (91, 3, 'message', '要望等', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    261 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (92, 3, 'order_name01', '顧客名(姓)', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    262 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (93, 3, 'order_name02', '顧客名(名)', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    263 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (94, 3, 'order_kana01', '顧客名(フリガナ・姓)', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    264 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (95, 3, 'order_kana02', '顧客名(フリガナ・名)', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    265 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (96, 3, 'order_email', 'メールアドレス', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    266 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (97, 3, 'order_tel01', '電話番号1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    267 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (98, 3, 'order_tel02', '電話番号2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    268 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (99, 3, 'order_tel03', '電話番号3', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    269 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (100, 3, 'order_fax01', 'FAX1', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    270 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (101, 3, 'order_fax02', 'FAX2', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    271 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (102, 3, 'order_fax03', 'FAX3', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    272 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (103, 3, 'order_zip01', '郵便番号1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    273 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (104, 3, 'order_zip02', '郵便番号2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    274 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (105, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    275 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (106, 3, 'order_addr01', '住所1', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    276 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (107, 3, 'order_addr02', '住所2', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    277 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (108, 3, 'order_sex', '性別', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    278 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (109, 3, 'order_birth', '生年月日', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    279 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (110, 3, 'order_job', '職種', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    280 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (111, 3, 'deliv_name01', 'お届け先名前(姓)', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    281 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (112, 3, 'deliv_name02', 'お届け先名前(名)', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    282 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (113, 3, 'deliv_kana01', 'お届け先(フリガナ・姓)', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    283 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (114, 3, 'deliv_kana02', 'お届け先(フリガナ・名)', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    284 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (115, 3, 'deliv_tel01', '電話番号1', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    285 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (116, 3, 'deliv_tel02', '電話番号2', 28, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    286 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (117, 3, 'deliv_tel03', '電話番号3', 29, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    287 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (118, 3, 'deliv_fax01', 'FAX1', 30, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    288 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (119, 3, 'deliv_fax02', 'FAX2', 31, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    289 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (120, 3, 'deliv_fax03', 'FAX3', 32, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    290 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (121, 3, 'deliv_zip01', '郵便番号1', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    291 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (122, 3, 'deliv_zip02', '郵便番号2', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    292 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (123, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    293 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (124, 3, 'deliv_addr01', '住所1', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    294 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (125, 3, 'deliv_addr02', '住所2', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    295 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (126, 3, 'subtotal', '小計', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    296 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (127, 3, 'discount', '値引き', 39, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    297 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (128, 3, 'deliv_fee', '送料', 40, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    298 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (129, 3, 'charge', '手数料', 41, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    299 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (130, 3, 'use_point', '使用ポイント', 42, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    300 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (131, 3, 'add_point', '加算ポイント', 43, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    301 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (132, 3, 'tax', '税金', 44, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    302 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (133, 3, 'total', '合計', 45, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    303 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (134, 3, 'payment_total', 'お支払い合計', 46, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    304 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (135, 3, 'payment_method', '支払い方法', 47, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    305 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (136, 3, 'deliv_time', 'お届け時間', 48, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    306 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (137, 3, 'deliv_no', '配送伝票番号', 49, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    307 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (138, 3, 'note', 'SHOPメモ', 50, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    308 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (139, 3, 'status', '対応状況', 51, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    309 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (140, 3, 'create_date', '注文日時', 52, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    310 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (141, 3, 'update_date', '更新日時', 53, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    311 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (142, 3, 'deliv_date', 'お届け指定日', 54, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    312 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (143, 4, 'order_id', '注文番号', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    313 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (144, 4, 'customer_id', '顧客ID', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    314 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (145, 4, 'message', '要望等', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    315 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (146, 4, 'order_name01', '顧客名1', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    316 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (147, 4, 'order_name02', '顧客名2', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    317 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (148, 4, 'order_kana01', '顧客名カナ1', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    318 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (149, 4, 'order_kana02', '顧客名カナ2', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    319 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (150, 4, 'order_email', 'メールアドレス', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    320 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (151, 4, 'order_tel01', '電話番号1', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    321 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (152, 4, 'order_tel02', '電話番号2', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    322 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (153, 4, 'order_tel03', '電話番号3', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    323 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (154, 4, 'order_fax01', 'FAX1', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    324 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (155, 4, 'order_fax02', 'FAX2', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    325 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (156, 4, 'order_fax03', 'FAX3', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    326 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (157, 4, 'order_zip01', '郵便番号1', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    327 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (158, 4, 'order_zip02', '郵便番号2', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    328 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (159, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    329 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (160, 4, 'order_addr01', '住所1', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    330 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (161, 4, 'order_addr02', '住所2', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    331 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (162, 4, 'order_sex', '性別', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    332 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (163, 4, 'order_birth', '生年月日', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    333 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (164, 4, 'order_job', '職種', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    334 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (165, 4, 'deliv_name01', 'お届け先名前', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    335 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (166, 4, 'deliv_name02', 'お届け先名前', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    336 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (167, 4, 'deliv_kana01', 'お届け先カナ', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    337 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (168, 4, 'deliv_kana02', 'お届け先カナ', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    338 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (169, 4, 'deliv_tel01', '電話番号1', 28, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    339 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (170, 4, 'deliv_tel02', '電話番号2', 29, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    340 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (171, 4, 'deliv_tel03', '電話番号3', 30, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    341 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (172, 4, 'deliv_fax01', 'FAX1', 31, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    342 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (173, 4, 'deliv_fax02', 'FAX2', 32, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    343 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (174, 4, 'deliv_fax03', 'FAX3', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    344 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (175, 4, 'deliv_zip01', '郵便番号1', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    345 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (176, 4, 'deliv_zip02', '郵便番号2', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    346 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (177, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    347 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (178, 4, 'deliv_addr01', '住所1', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    348 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (179, 4, 'deliv_addr02', '住所2', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    349 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (180, 4, 'payment_total', 'お支払い合計', 39, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    350 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (181, 5, 'category_id', 'カテゴリID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    351 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (182, 5, 'category_name', 'カテゴリ名', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    352 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (183, 5, 'parent_category_id', '親カテゴリID', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    353 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (184, 5, 'level', '階層', NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    354 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (185, 5, 'rank', '表示ランク', NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     172INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (1, 1, 'product_id', '商品ID', 1, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     173INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (2, 1, 'product_class_id', '商品規格ID', 2, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     174INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (3, 1, 'parent_class_combination_id', '親規格組合わせID', 3, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     175INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (4, 1, 'class_combination_id', '規格組合わせID', 4, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     176INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (5, 1, 'parent_classcategory_id', '親規格分類ID', 5, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     177INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (6, 1, 'classcategory_id', '規格分類ID', 6, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     178INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (7, 1, 'parent_classcategory_name', '親規格分類名', 7, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     179INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (8, 1, 'classcategory_name', '規格分類名', 8, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     180INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (9, 1, 'maker_id', 'メーカーID', 9, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     181INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (10, 1, '(SELECT name as maker_name FROM dtb_maker WHERE prdcls.maker_id = dtb_maker.maker_id) as maker_name', 'メーカー名', 10, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     182INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (11, 1, 'name', '商品名', 11, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     183INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (12, 1, 'status', '表示ステータス(公開・非公開)', 12, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     184INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (13, 1, 'comment1', 'メーカーURL(コメント1)', 13, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     185INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (14, 1, 'comment2', 'コメント2', 14, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     186INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (15, 1, 'comment3', '検索ワード(コメント3)', 15, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     187INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (16, 1, 'comment4', 'コメント4', 16, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     188INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (17, 1, 'comment5', 'コメント5', 17, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     189INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (18, 1, 'comment6', 'コメント6', 18, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     190INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (19, 1, 'note', '備考欄(SHOP専用)', 19, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     191INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (20, 1, 'main_list_comment', '一覧-メインコメント', 20, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     192INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (21, 1, 'main_list_image', '一覧-メイン画像', 21, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     193INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (22, 1, 'main_comment', '詳細-メインコメント', 22, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     194INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (23, 1, 'main_image', '詳細-メイン画像', 23, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     195INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (24, 1, 'main_large_image', '詳細-メイン拡大画像 ', 24, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     196INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (25, 1, 'sub_title1', '詳細-サブタイトル(1)', 25, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     197INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (26, 1, 'sub_comment1', '詳細-サブコメント(1)', 26, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     198INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (27, 1, 'sub_image1', '詳細-サブ画像(1)', 27, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     199INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (28, 1, 'sub_large_image1', '詳細-サブ拡大画像(1)', 28, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     200INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (29, 1, 'sub_title2', '詳細-サブタイトル(2)', 29, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     201INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (30, 1, 'sub_comment2', '詳細-サブコメント(2)', 30, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     202INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (31, 1, 'sub_image2', '詳細-サブ画像(2)', 31, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     203INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (32, 1, 'sub_large_image2', '詳細-サブ拡大画像(2)', 32, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     204INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (33, 1, 'sub_title3', '詳細-サブタイトル(3)', 33, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     205INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (34, 1, 'sub_comment3', '詳細-サブコメント(3)', 34, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     206INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (35, 1, 'sub_image3', '詳細-サブ画像(3)', 35, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     207INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (36, 1, 'sub_large_image3', '詳細-サブ拡大画像(3)', 36, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     208INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (37, 1, 'sub_title4', '詳細-サブタイトル(4)', 37, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     209INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (38, 1, 'sub_comment4', '詳細-サブコメント(4)', 38, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     210INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (39, 1, 'sub_image4', '詳細-サブ画像(4)', 39, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     211INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (40, 1, 'sub_large_image4', '詳細-サブ拡大画像(4)', 40, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     212INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (41, 1, 'sub_title5', '詳細-サブタイトル(5)', 41, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     213INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (42, 1, 'sub_comment5', '詳細-サブコメント(5)', 42, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     214INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (43, 1, 'sub_image5', '詳細-サブ画像(5)', 43, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     215INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (44, 1, 'sub_large_image5', '詳細-サブ拡大画像(5)', 44, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     216INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (45, 1, 'deliv_date_id', '発送日目安', 45, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     217INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (46, 1, 'del_flg', '削除フラグ', 46, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     218INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (47, 1, 'product_type_id', '商品種別ID', 47, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     219INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (48, 1, 'product_code', '商品コード', 48, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     220INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (49, 1, 'stock', '在庫数', 49, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     221INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (50, 1, 'stock_unlimited', '在庫無制限フラグ', 50, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     222INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (51, 1, 'sale_limit', '購入制限数', 51, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     223INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (52, 1, 'price01', '通常価格', 52, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     224INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (53, 1, 'price02', '販売価格', 53, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     225INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (54, 1, 'deliv_fee', '送料', 54, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     226INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (55, 1, 'point_rate', 'ポイント付与率', 55, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     227INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (56, 1, 'down_filename', 'ダウンロードファイル名', 56, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     228INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (57, 1, 'down_realfilename', 'ダウンロード実ファイル', 57, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     229INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (58, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 0) AS recommend_product_id1', '関連商品ID(1)', 58, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     230INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (59, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 0) AS recommend_comment1', '関連商品コメント(1)', 59, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     231INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (60, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 1) AS recommend_product_id2', '関連商品ID(2)', 60, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     232INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (61, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 1) AS recommend_comment2', '関連商品コメント(2)', 61, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     233INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (62, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 2) AS recommend_product_id3', '関連商品ID(3)', 62, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     234INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (63, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 2) AS recommend_comment3', '関連商品コメント(3)', 63, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     235INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (64, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 3) AS recommend_product_id4', '関連商品ID(4)', 64, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     236INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (65, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 3) AS recommend_comment4', '関連商品コメント(4)', 65, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     237INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (66, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 4) AS recommend_product_id5', '関連商品ID(5)', 66, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     238INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (67, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 4) AS recommend_comment5', '関連商品コメント(5)', 67, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     239INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (68, 1, '(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 5) AS recommend_product_id6', '関連商品ID(6)', 68, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     240INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date) VALUES (69, 1, '(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY rank DESC, recommend_product_id DESC limit 1 offset 5) AS recommend_comment6', '関連商品コメント(6)', 69, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     241 
     242INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (70, 2, 'customer_id', '顧客ID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     243INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (71, 2, 'name01', 'お名前(姓)', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     244INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (72, 2, 'name02', 'お名前(名)', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     245INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (73, 2, 'kana01', 'お名前(フリガナ・姓)', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     246INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (74, 2, 'kana02', 'お名前(フリガナ・名)', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     247INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (75, 2, 'zip01', '郵便番号1', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     248INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (76, 2, 'zip02', '郵便番号2', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     249INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (77, 2, 'pref', '都道府県', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     250INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (78, 2, 'addr01', '住所1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     251INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (79, 2, 'addr02', '住所2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     252INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (80, 2, 'email', 'E-MAIL', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     253INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (81, 2, 'tel01', 'TEL1', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     254INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (82, 2, 'tel02', 'TEL2', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     255INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (83, 2, 'tel03', 'TEL3', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     256INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (84, 2, 'fax01', 'FAX1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     257INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (85, 2, 'fax02', 'FAX2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     258INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (86, 2, 'fax03', 'FAX3', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     259INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (87, 2, 'sex', '性別', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     260INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (88, 2, 'job', '職業', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     261INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (89, 2, 'birth', '誕生日', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     262INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (90, 2, 'first_buy_date', '初回購入日', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     263INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (91, 2, 'last_buy_date', '最終購入日', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     264INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (92, 2, 'buy_times', '購入回数', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     265INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (93, 2, 'point', 'ポイント残高', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     266INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (94, 2, 'note', '備考', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     267INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (95, 2, 'create_date', '登録日', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     268INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (96, 2, 'update_date', '更新日', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     269INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (97, 3, 'order_id', '注文番号', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     270INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (98, 3, 'customer_id', '顧客ID', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     271INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (99, 3, 'message', '要望等', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     272INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (100, 3, 'order_name01', '顧客名(姓)', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     273INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (101, 3, 'order_name02', '顧客名(名)', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     274INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (102, 3, 'order_kana01', '顧客名(フリガナ・姓)', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     275INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (103, 3, 'order_kana02', '顧客名(フリガナ・名)', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     276INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (104, 3, 'order_email', 'メールアドレス', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     277INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (105, 3, 'order_tel01', '電話番号1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     278INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (106, 3, 'order_tel02', '電話番号2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     279INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (107, 3, 'order_tel03', '電話番号3', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     280INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (108, 3, 'order_fax01', 'FAX1', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     281INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (109, 3, 'order_fax02', 'FAX2', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     282INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (110, 3, 'order_fax03', 'FAX3', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     283INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (111, 3, 'order_zip01', '郵便番号1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     284INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (112, 3, 'order_zip02', '郵便番号2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     285INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (113, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     286INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (114, 3, 'order_addr01', '住所1', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     287INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (115, 3, 'order_addr02', '住所2', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     288INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (116, 3, 'order_sex', '性別', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     289INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (117, 3, 'order_birth', '生年月日', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     290INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (118, 3, 'order_job', '職種', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     291INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (119, 3, 'deliv_name01', 'お届け先名前(姓)', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     292INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (120, 3, 'deliv_name02', 'お届け先名前(名)', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     293INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (121, 3, 'deliv_kana01', 'お届け先(フリガナ・姓)', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     294INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (122, 3, 'deliv_kana02', 'お届け先(フリガナ・名)', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     295INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (123, 3, 'deliv_tel01', '電話番号1', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     296INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (124, 3, 'deliv_tel02', '電話番号2', 28, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     297INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (125, 3, 'deliv_tel03', '電話番号3', 29, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     298INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (126, 3, 'deliv_fax01', 'FAX1', 30, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     299INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (127, 3, 'deliv_fax02', 'FAX2', 31, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     300INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (128, 3, 'deliv_fax03', 'FAX3', 32, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     301INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (129, 3, 'deliv_zip01', '郵便番号1', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     302INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (130, 3, 'deliv_zip02', '郵便番号2', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     303INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (131, 3, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     304INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (132, 3, 'deliv_addr01', '住所1', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     305INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (133, 3, 'deliv_addr02', '住所2', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     306INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (134, 3, 'subtotal', '小計', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     307INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (135, 3, 'discount', '値引き', 39, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     308INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (136, 3, 'deliv_fee', '送料', 40, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     309INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (137, 3, 'charge', '手数料', 41, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     310INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (138, 3, 'use_point', '使用ポイント', 42, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     311INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (139, 3, 'add_point', '加算ポイント', 43, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     312INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (140, 3, 'tax', '税金', 44, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     313INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (141, 3, 'total', '合計', 45, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     314INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (142, 3, 'payment_total', 'お支払い合計', 46, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     315INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (143, 3, 'payment_method', '支払い方法', 47, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     316INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (144, 3, 'deliv_time', 'お届け時間', 48, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     317INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (145, 3, 'deliv_no', '配送伝票番号', 49, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     318INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (146, 3, 'note', 'SHOPメモ', 50, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     319INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (147, 3, 'status', '対応状況', 51, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     320INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (148, 3, 'create_date', '注文日時', 52, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     321INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (149, 3, 'update_date', '更新日時', 53, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     322INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (150, 3, 'deliv_date', 'お届け指定日', 54, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     323INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (151, 4, 'order_id', '注文番号', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     324INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (152, 4, 'customer_id', '顧客ID', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     325INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (153, 4, 'message', '要望等', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     326INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (154, 4, 'order_name01', '顧客名1', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     327INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (155, 4, 'order_name02', '顧客名2', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     328INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (156, 4, 'order_kana01', '顧客名カナ1', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     329INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (157, 4, 'order_kana02', '顧客名カナ2', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     330INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (158, 4, 'order_email', 'メールアドレス', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     331INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (159, 4, 'order_tel01', '電話番号1', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     332INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (160, 4, 'order_tel02', '電話番号2', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     333INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (161, 4, 'order_tel03', '電話番号3', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     334INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (162, 4, 'order_fax01', 'FAX1', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     335INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (163, 4, 'order_fax02', 'FAX2', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     336INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (164, 4, 'order_fax03', 'FAX3', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     337INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (165, 4, 'order_zip01', '郵便番号1', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     338INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (166, 4, 'order_zip02', '郵便番号2', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     339INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (167, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.order_pref)', '都道府県', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     340INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (168, 4, 'order_addr01', '住所1', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     341INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (169, 4, 'order_addr02', '住所2', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     342INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (170, 4, 'order_sex', '性別', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     343INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (171, 4, 'order_birth', '生年月日', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     344INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (172, 4, 'order_job', '職種', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     345INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (173, 4, 'deliv_name01', 'お届け先名前', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     346INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (174, 4, 'deliv_name02', 'お届け先名前', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     347INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (175, 4, 'deliv_kana01', 'お届け先カナ', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     348INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (176, 4, 'deliv_kana02', 'お届け先カナ', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     349INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (177, 4, 'deliv_tel01', '電話番号1', 28, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     350INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (178, 4, 'deliv_tel02', '電話番号2', 29, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     351INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (179, 4, 'deliv_tel03', '電話番号3', 30, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     352INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (180, 4, 'deliv_fax01', 'FAX1', 31, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     353INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (181, 4, 'deliv_fax02', 'FAX2', 32, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     354INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (182, 4, 'deliv_fax03', 'FAX3', 33, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     355INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (183, 4, 'deliv_zip01', '郵便番号1', 34, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     356INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (184, 4, 'deliv_zip02', '郵便番号2', 35, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     357INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (185, 4, '(SELECT pref_name FROM mtb_pref WHERE pref_id = dtb_order.deliv_pref)', '都道府県', 36, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     358INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (186, 4, 'deliv_addr01', '住所1', 37, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     359INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (187, 4, 'deliv_addr02', '住所2', 38, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     360INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (188, 4, 'payment_total', 'お支払い合計', 39, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     361INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (189, 5, 'category_id', 'カテゴリID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     362INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (190, 5, 'category_name', 'カテゴリ名', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     363INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (191, 5, 'parent_category_id', '親カテゴリID', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     364INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (192, 5, 'level', '階層', NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     365INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (193, 5, 'rank', '表示ランク', NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    355366 
    356367INSERT INTO dtb_deliv (deliv_id, product_type_id, name, service_name, confirm_url, rank, status, del_flg, creator_id, create_date, update_date) VALUES (1, 1, 'サンプル業者', 'サンプル業者', NULL, 1, 1, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
Note: See TracChangeset for help on using the changeset viewer.