オープンソースの販売サイト構築ソフト EC-CUBE についてのメモ。

2.11系から2.12系

  • 2.11.5 から 2.12.1
  • PostgreSQL (EnterpriseDB 9.1.2.2) 及び MySQL 5.5.16 環境で試し、適用後に下記が行える事を確認した。
    • プラグインのインストール
    • 会員登録
    • 購入手続き

SQL (DDL)

木構造の削除に伴うテーブル構造の変更とデータ変換

ALTER TABLE dtb_products_class ADD COLUMN classcategory_id1 INT NOT NULL DEFAULT 0;
ALTER TABLE dtb_products_class ADD COLUMN classcategory_id2 INT NOT NULL DEFAULT 0;
 
-- MySQL は下記も追加する (設定によっては、WHERE でキー指定の無い UPDATE を実行できないため)
-- SET SQL_SAFE_UPDATES = 0;
 
UPDATE dtb_products_class
SET
    classcategory_id1 = COALESCE(
        (
            SELECT classcategory_id
            FROM dtb_class_combination
            WHERE class_combination_id = dtb_products_class.class_combination_id
        )
        ,0
    )
;
 
UPDATE dtb_products_class
SET
    classcategory_id2 = COALESCE(
        (
            SELECT classcategory_id
            FROM dtb_class_combination
            WHERE class_combination_id =
                (
                    SELECT parent_class_combination_id
                    FROM dtb_class_combination
                    WHERE class_combination_id = dtb_products_class.class_combination_id
                )
        )
        ,0
    )
;
 
ALTER TABLE dtb_products_class DROP COLUMN class_combination_id;
DROP TABLE dtb_class_combination;

シーケンス

本来は PRAE::MDB2 を経由して作成するべきものであり、SQL で作成するのは望ましくないが…

PostgreSQL 用

DROP SEQUENCE dtb_class_combination_class_combination_id_seq;
CREATE SEQUENCE dtb_plugin_plugin_id_seq;
CREATE SEQUENCE dtb_plugin_hookpoint_plugin_hookpoint_id_seq;
CREATE SEQUENCE dtb_api_config_api_config_id_seq;
CREATE SEQUENCE dtb_api_account_api_account_id_seq;

MySQL 用

DROP TABLE dtb_class_combination_class_combination_id_seq;
CREATE TABLE dtb_plugin_plugin_id_seq (
    `sequence` INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`sequence`)
);
CREATE TABLE dtb_plugin_hookpoint_plugin_hookpoint_id_seq (
    `sequence` INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`sequence`)
);
CREATE TABLE dtb_api_config_api_config_id_seq (
    `sequence` INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`sequence`)
);
CREATE TABLE dtb_api_account_api_account_id_seq (
    `sequence` INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`sequence`)
);

-- ■ dtb_ownersstore_settings
-- PostgreSQL 用
ALTER TABLE dtb_ownersstore_settings ADD PRIMARY KEY (public_key);
-- MySQL 用
ALTER TABLE dtb_ownersstore_settings ADD PRIMARY KEY (public_key(64));
 
-- ■ mtb_zip
ALTER TABLE mtb_zip DROP COLUMN code;
ALTER TABLE mtb_zip DROP COLUMN old_zipcode;
ALTER TABLE mtb_zip DROP COLUMN state_kana;
ALTER TABLE mtb_zip DROP COLUMN city_kana;
ALTER TABLE mtb_zip DROP COLUMN town_kana;
ALTER TABLE mtb_zip DROP COLUMN flg1;
ALTER TABLE mtb_zip DROP COLUMN flg2;
ALTER TABLE mtb_zip DROP COLUMN flg3;
ALTER TABLE mtb_zip DROP COLUMN flg4;
ALTER TABLE mtb_zip DROP COLUMN flg5;
ALTER TABLE mtb_zip DROP COLUMN flg6;
ALTER TABLE mtb_zip ADD COLUMN zip_id INT; -- 列順相違あり
ALTER TABLE mtb_zip ADD PRIMARY KEY (zip_id);
 
-- ■ dtb_baseinfo
ALTER TABLE dtb_baseinfo ADD COLUMN id INT;
UPDATE dtb_baseinfo SET id = 1;
ALTER TABLE dtb_baseinfo ADD PRIMARY KEY (id);
 
-- ■ dtb_payment_options
-- 列順変更は無視
-- PostgreSQL 用
ALTER TABLE dtb_payment_options DROP CONSTRAINT dtb_payment_options_pkey;
-- MySQL 用
ALTER TABLE dtb_payment_options DROP PRIMARY KEY;
-- 共通
ALTER TABLE dtb_payment_options ADD PRIMARY KEY (deliv_id, payment_id);
 
-- ■ dtb_payment
-- PostgreSQL 用
ALTER TABLE dtb_payment RENAME rule TO rule_max;
-- MySQL 用
ALTER TABLE dtb_payment CHANGE rule rule_max NUMERIC;
 
-- ■ dtb_mailtemplate
ALTER TABLE dtb_mailtemplate ADD PRIMARY KEY (template_id);
 
-- ■ dtb_send_customer
-- PostgreSQL 用
ALTER TABLE dtb_send_customer ALTER customer_id SET NOT NULL;
-- MySQL 用
ALTER TABLE dtb_send_customer MODIFY customer_id INT NOT NULL;
 
-- ■ dtb_recommend_products
ALTER TABLE dtb_recommend_products ADD PRIMARY KEY (product_id, recommend_product_id);
 
-- ■ dtb_category_count
ALTER TABLE dtb_category_count ADD PRIMARY KEY (category_id);
 
-- ■ dtb_category_total_count
ALTER TABLE dtb_category_total_count ADD PRIMARY KEY (category_id);
 
-- ■ dtb_customer
-- PostgreSQL 用
ALTER TABLE dtb_customer ALTER point SET NOT NULL;
-- MySQL 用
ALTER TABLE dtb_customer MODIFY point NUMERIC NOT NULL DEFAULT 0;
 
-- ■ dtb_order
-- PostgreSQL 用
ALTER TABLE dtb_order ALTER discount SET NOT NULL;
ALTER TABLE dtb_order ALTER discount SET DEFAULT 0;
ALTER TABLE dtb_order ALTER use_point SET NOT NULL;
ALTER TABLE dtb_order ALTER use_point SET DEFAULT 0;
ALTER TABLE dtb_order ALTER add_point SET NOT NULL;
ALTER TABLE dtb_order ALTER add_point SET DEFAULT 0;
ALTER TABLE dtb_order ALTER birth_point SET NOT NULL;
-- MySQL 用
ALTER TABLE dtb_order MODIFY discount NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order MODIFY use_point NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order MODIFY add_point NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order MODIFY birth_point NUMERIC NOT NULL DEFAULT 0;
 
-- ■ dtb_order_temp
/* 行重複発生時の対処案 (運用実績あり)
CREATE TABLE tmp_dtb_order_temp
SELECT DISTINCT * 
FROM dtb_order_temp;
 
TRUNCATE dtb_order_temp;
 
INSERT INTO dtb_order_temp
SELECT *
FROM tmp_dtb_order_temp;
 
DROP TABLE tmp_dtb_order_temp;
*/
/* キー複発生時の対処案 (未運用)
-- 下記を DELETE 文に加工する。
SELECT order_temp_id
FROM dtb_order_temp
WHERE EXISTS(SELECT * FROM dtb_order_temp sub WHERE order_temp_id = dtb_order_temp.order_temp_id AND update_date > dtb_order_temp.update_date)
*/
-- PostgreSQL 用
ALTER TABLE dtb_order_temp ALTER discount SET NOT NULL;
ALTER TABLE dtb_order_temp ALTER discount SET DEFAULT 0;
ALTER TABLE dtb_order_temp ALTER use_point SET NOT NULL;
ALTER TABLE dtb_order_temp ALTER use_point SET DEFAULT 0;
ALTER TABLE dtb_order_temp ALTER add_point SET NOT NULL;
ALTER TABLE dtb_order_temp ALTER add_point SET DEFAULT 0;
ALTER TABLE dtb_order_temp ALTER birth_point SET NOT NULL;
ALTER TABLE dtb_order_temp ADD PRIMARY KEY (order_temp_id);
-- MySQL 用
ALTER TABLE dtb_order_temp MODIFY discount NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order_temp MODIFY use_point NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order_temp MODIFY add_point NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order_temp MODIFY birth_point NUMERIC NOT NULL DEFAULT 0;
ALTER TABLE dtb_order_temp ADD PRIMARY KEY (order_temp_id(64));
 
-- ■ dtb_shipping
ALTER TABLE dtb_shipping DROP deliv_id;
 
-- ■ dtb_other_deliv
ALTER TABLE dtb_other_deliv ADD COLUMN fax01 text;
ALTER TABLE dtb_other_deliv ADD COLUMN fax02 text;
ALTER TABLE dtb_other_deliv ADD COLUMN fax03 text;
 
-- ■ dtb_order_detail
-- PostgreSQL 用
ALTER TABLE dtb_order_detail ALTER point_rate SET NOT NULL;
ALTER TABLE dtb_order_detail ALTER point_rate SET DEFAULT 0;
-- MySQL 用
ALTER TABLE dtb_order_detail MODIFY point_rate NUMERIC NOT NULL DEFAULT 0;
 
-- ■ dtb_bloc
ALTER TABLE dtb_bloc ADD COLUMN plugin_id INT;
 
-- ■ dtb_blocposition
-- PostgreSQL 用
ALTER TABLE dtb_blocposition ALTER COLUMN target_id SET NOT NULL;
ALTER TABLE dtb_blocposition ALTER COLUMN bloc_id SET NOT NULL;
-- MySQL 用
ALTER TABLE dtb_blocposition MODIFY COLUMN target_id INT NOT NULL;
ALTER TABLE dtb_blocposition MODIFY COLUMN bloc_id INT NOT NULL;
 
-- ■ dtb_maker_count
ALTER TABLE dtb_maker_count ADD PRIMARY KEY (maker_id);
 
-- ■ mtb_class
DROP TABLE mtb_class;
 
-- ■ mtb_customer_order_status
CREATE TABLE mtb_customer_order_status (
    id SMALLINT,
    name text,
    rank SMALLINT NOT NULL DEFAULT 0,
    PRIMARY KEY (id)
);
 
-- ■ dtb_mobile_ext_session_id
-- PostgreSQL 用
ALTER TABLE dtb_mobile_ext_session_id ADD PRIMARY KEY (session_id);
-- MySQL 用
ALTER TABLE dtb_mobile_ext_session_id ADD PRIMARY KEY (session_id(255));
 
-- ■ dtb_module
ALTER TABLE dtb_module ADD PRIMARY KEY (module_id);
 
-- ■ dtb_plugin
-- データなきことを確認
SELECT * FROM dtb_plugin;
-- テーブル削除
DROP TABLE dtb_plugin;
-- テーブル作成
CREATE TABLE dtb_plugin (
    plugin_id INT NOT NULL,
    plugin_name text NOT NULL,
    plugin_code text NOT NULL,
    class_name text NOT NULL,
    author text,
    author_site_url text,
    plugin_site_url text,
    plugin_version text,
    compliant_version text,
    plugin_description text,
    priority INT NOT NULL DEFAULT 0,
    enable SMALLINT NOT NULL DEFAULT 0,
    free_field1 text,
    free_field2 text,
    free_field3 text,
    free_field4 text,
    create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_date TIMESTAMP NOT NULL,
    PRIMARY KEY (plugin_id)
);
 
-- ■ dtb_plugin_hookpoint
CREATE TABLE dtb_plugin_hookpoint (
    plugin_hookpoint_id INT NOT NULL,
    plugin_id INT NOT NULL,
    hook_point text NOT NULL,
    callback text,
    create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_date TIMESTAMP NOT NULL,
    PRIMARY KEY (plugin_hookpoint_id)
);
 
-- ■ dtb_api_config
CREATE TABLE dtb_api_config (
    api_config_id INT NOT NULL,
    operation_name text NOT NULL,
    operation_description text,
    auth_types text NOT NULL,
    enable SMALLINT NOT NULL DEFAULT 0,
    is_log SMALLINT NOT NULL DEFAULT 0,
    sub_data text,
    del_flg SMALLINT NOT NULL DEFAULT 0,
    create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_date TIMESTAMP NOT NULL,
    PRIMARY KEY (api_config_id)
);
 
-- ■ dtb_api_account
CREATE TABLE dtb_api_account (
    api_account_id INT NOT NULL,
    api_access_key text NOT NULL,
    api_secret_key text NOT NULL,
    enable SMALLINT NOT NULL DEFAULT 0,
    del_flg SMALLINT NOT NULL DEFAULT 0,
    create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_date TIMESTAMP NOT NULL,
    PRIMARY KEY (api_account_id)
);

インデックス・カラム型変更

PostgreSQL のみ。

DROP INDEX dtb_products_class_product_id_key;

MySQL のみ。

ALTER TABLE dtb_bkup DROP PRIMARY KEY;
ALTER TABLE `dtb_bkup` CHANGE `bkup_name` `bkup_name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_bkup` ADD PRIMARY KEY ( `bkup_name`(255) ) ;
 
ALTER TABLE dtb_bloc DROP INDEX device_type_id;
ALTER TABLE `dtb_bloc` CHANGE `filename` `filename` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_bloc` ADD UNIQUE device_type_id ( `device_type_id` , `filename`(255) ) ;
 
ALTER TABLE dtb_customer DROP INDEX secret_key;
ALTER TABLE `dtb_customer` CHANGE `secret_key` `secret_key` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_customer` ADD UNIQUE secret_key ( `secret_key`(255) ) ;
 
ALTER TABLE dtb_index_list DROP PRIMARY KEY;
ALTER TABLE `dtb_index_list` CHANGE `table_name` `table_name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_index_list` CHANGE `column_name` `column_name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_index_list` ADD PRIMARY KEY (`table_name`(255),`column_name`(255)) ;
 
ALTER TABLE `dtb_products_class` CHANGE `point_rate` `point_rate` DECIMAL( 10, 0 ) NOT NULL DEFAULT '0';
ALTER TABLE `dtb_products_class` ADD UNIQUE `product_id` (`product_id`,`classcategory_id1`,`classcategory_id2`);
 
ALTER TABLE dtb_session DROP PRIMARY KEY;
ALTER TABLE `dtb_session` CHANGE `sess_id` `sess_id` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_session` ADD PRIMARY KEY ( `sess_id`(255) ) ;
 
ALTER TABLE dtb_templates DROP PRIMARY KEY;
ALTER TABLE `dtb_templates` CHANGE `template_code` `template_code` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `dtb_templates` ADD PRIMARY KEY ( `template_code`(255) ) ;
 
ALTER TABLE mtb_constants DROP PRIMARY KEY;
ALTER TABLE `mtb_constants` ADD PRIMARY KEY (`id`(255)) ;
 
ALTER TABLE mtb_permission DROP PRIMARY KEY;
ALTER TABLE `mtb_permission` ADD PRIMARY KEY (`id`(255)) ;
 
ALTER TABLE dtb_customer DROP INDEX dtb_customer_mobile_phone_id_key;
ALTER TABLE `dtb_customer` ADD INDEX dtb_customer_mobile_phone_id_key ( `mobile_phone_id`(255) ) ;
 
ALTER TABLE `dtb_mobile_ext_session_id` DROP INDEX `dtb_mobile_ext_session_id_param_key_key`;
ALTER TABLE `dtb_mobile_ext_session_id` DROP INDEX `dtb_mobile_ext_session_id_param_value_key`;
ALTER TABLE `dtb_mobile_ext_session_id` DROP INDEX `dtb_mobile_ext_session_id_url_key`;
ALTER TABLE `dtb_mobile_ext_session_id` ADD INDEX `dtb_mobile_ext_session_id_param_key_key` (`param_key`(255));
ALTER TABLE `dtb_mobile_ext_session_id` ADD INDEX `dtb_mobile_ext_session_id_param_value_key` (`param_value`(255));
ALTER TABLE `dtb_mobile_ext_session_id` ADD INDEX `dtb_mobile_ext_session_id_url_key` (`url`(255));

SQL (DML)

dtb_csv

まずは、設定変更済みの箇所を特定する。該当箇所は、後から手動でマージする。(設定変更の移行が不要な場合、いきなり削除・挿入で良い。)

DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (1, 1, 'product_id', '商品ID', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (2, 1, 'product_class_id', '商品規格ID', 2, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (3, 1, 'parent_class_combination_id', '親規格組合わせID', 3, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (4, 1, 'class_combination_id', '規格組合わせID', 4, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (5, 1, 'parent_classcategory_id', '親規格分類ID', 5, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (6, 1, 'classcategory_id', '規格分類ID', 6, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (7, 1, 'parent_classcategory_name', '親規格分類名', 7, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (8, 1, 'classcategory_name', '規格分類名', 8, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (9, 1, 'maker_id', 'メーカーID', 9, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (10, 1, '(SELECT name as maker_name FROM dtb_maker WHERE prdcls.maker_id = dtb_maker.maker_id) as maker_name', 'メーカー名', 10, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (11, 1, 'name', '商品名', 11, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (12, 1, 'status', '表示ステータス(公開・非公開)', 12, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (13, 1, 'comment1', 'メーカーURL(コメント1)', 13, 1, 1, 'KVa', 'URL_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,URL_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (14, 1, 'comment2', 'コメント2', 14, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (15, 1, 'comment3', '検索ワード(コメント3)', 15, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (16, 1, 'comment4', 'コメント4', 16, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (17, 1, 'comment5', 'コメント5', 17, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (18, 1, 'comment6', 'コメント6', 18, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (19, 1, 'note', '備考欄(SHOP専用)', 19, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (20, 1, 'main_list_comment', '一覧-メインコメント', 20, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (21, 1, 'main_list_image', '一覧-メイン画像', 21, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (22, 1, 'main_comment', '詳細-メインコメント', 22, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK,HTML_TAG_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (23, 1, 'main_image', '詳細-メイン画像', 23, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (24, 1, 'main_large_image', '詳細-メイン拡大画像 ', 24, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (25, 1, 'sub_title1', '詳細-サブタイトル(1)', 25, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (26, 1, 'sub_comment1', '詳細-サブコメント(1)', 26, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,HTML_TAG_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (27, 1, 'sub_image1', '詳細-サブ画像(1)', 27, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (28, 1, 'sub_large_image1', '詳細-サブ拡大画像(1)', 28, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (29, 1, 'sub_title2', '詳細-サブタイトル(2)', 29, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (30, 1, 'sub_comment2', '詳細-サブコメント(2)', 30, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (31, 1, 'sub_image2', '詳細-サブ画像(2)', 31, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (32, 1, 'sub_large_image2', '詳細-サブ拡大画像(2)', 32, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (33, 1, 'sub_title3', '詳細-サブタイトル(3)', 33, 1, 1, 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (34, 1, 'sub_comment3', '詳細-サブコメント(3)', 34, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (35, 1, 'sub_image3', '詳細-サブ画像(3)', 35, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (36, 1, 'sub_large_image3', '詳細-サブ拡大画像(3)', 36, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (37, 1, 'sub_title4', '詳細-サブタイトル(4)', 37, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (38, 1, 'sub_comment4', '詳細-サブコメント(4)', 38, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (39, 1, 'sub_image4', '詳細-サブ画像(4)', 39, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (40, 1, 'sub_large_image4', '詳細-サブ拡大画像(4)', 40, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (41, 1, 'sub_title5', '詳細-サブタイトル(5)', 41, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (42, 1, 'sub_comment5', '詳細-サブコメント(5)', 42, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (43, 1, 'sub_image5', '詳細-サブ画像(5)', 43, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (44, 1, 'sub_large_image5', '詳細-サブ拡大画像(5)', 44, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (45, 1, 'deliv_date_id', '発送日目安ID', 45, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (46, 1, 'del_flg', '削除フラグ', 46, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (47, 1, 'product_type_id', '商品種別ID', 47, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (48, 1, 'product_code', '商品コード', 48, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (49, 1, 'stock', '在庫数', 49, 1, 1, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (50, 1, 'stock_unlimited', '在庫無制限フラグ', 50, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (51, 1, 'sale_limit', '購入制限数', 51, 1, 1, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (52, 1, 'price01', '通常価格', 52, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (53, 1, 'price02', '販売価格', 53, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (54, 1, 'deliv_fee', '送料', 54, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (55, 1, 'point_rate', 'ポイント付与率', 55, 1, 1, 'n', 'PERCENTAGE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (56, 1, 'down_filename', 'ダウンロードファイル名', 56, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, size_const_type, error_check_types) = (57, 1, 'down_realfilename', 'ダウンロード実ファイル', 57, 1, 1, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,DOWN_FILE_EXISTS') AND mb_convert_kana_option IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (70, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT product_status_id FROM dtb_product_status WHERE dtb_product_status.product_id = prdcls.product_id and del_flg = 0 ORDER BY dtb_product_status.product_status_id), '','')) as product_statuses', '商品ステータス', 70, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (71, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT name FROM dtb_product_status LEFT JOIN mtb_status ON  dtb_product_status.product_status_id = mtb_status.id  WHERE dtb_product_status.product_id = prdcls.product_id and del_flg = 0 ORDER BY dtb_product_status.product_status_id), '','')) as product_status_names', '商品ステータス名', 71, 2, 1, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (72, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT category_id FROM dtb_product_categories WHERE dtb_product_categories.product_id = prdcls.product_id ORDER BY dtb_product_categories.rank), '','')) as category_ids', 'カテゴリID', 72, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (73, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT category_name FROM dtb_product_categories LEFT JOIN dtb_category ON dtb_product_categories.category_id = dtb_category.category_id WHERE dtb_product_categories.product_id = prdcls.product_id ORDER BY dtb_product_categories.rank), '','')) as category_names', 'カテゴリ名', 73, 2, 1, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (76, 2, 'customer_id', '顧客ID', 1, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (77, 2, 'name01', 'お名前(姓)', 2, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (78, 2, 'name02', 'お名前(名)', 3, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (79, 2, 'kana01', 'お名前(フリガナ・姓)', 4, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (80, 2, 'kana02', 'お名前(フリガナ・名)', 5, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (81, 2, 'zip01', '郵便番号1', 6, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (82, 2, 'zip02', '郵便番号2', 7, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (83, 2, '(SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_customer.pref) as pref', '都道府県', 8, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (84, 2, 'addr01', '住所1', 9, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (85, 2, 'addr02', '住所2', 10, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (86, 2, 'email', 'E-MAIL', 11, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (87, 2, 'tel01', 'TEL1', 12, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (88, 2, 'tel02', 'TEL2', 13, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (89, 2, 'tel03', 'TEL3', 14, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (90, 2, 'fax01', 'FAX1', 15, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (91, 2, 'fax02', 'FAX2', 16, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (92, 2, 'fax03', 'FAX3', 17, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (93, 2, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = dtb_customer.sex) as sex', '性別', 18, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (94, 2, '(SELECT name FROM mtb_job WHERE mtb_job.id = dtb_customer.job) as job', '職業', 19, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (95, 2, 'birth', '誕生日', 20, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (96, 2, 'first_buy_date', '初回購入日', 21, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (97, 2, 'last_buy_date', '最終購入日', 22, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (98, 2, 'buy_times', '購入回数', 23, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (99, 2, 'point', 'ポイント残高', 24, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (100, 2, 'note', '備考', 25, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (101, 2, 'create_date', '登録日', 26, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, STATUS) = (102, 2, 'update_date', '更新日', 27, 1);
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (103, 3, 'order_id', '注文番号', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (104, 3, 'customer_id', '顧客ID', 2, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (105, 3, 'message', '要望等', 3, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (106, 3, 'order_name01', 'お名前(姓)', 4, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (107, 3, 'order_name02', 'お名前(名)', 5, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (108, 3, 'order_kana01', 'お名前(フリガナ・姓)', 6, 1, 1, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (109, 3, 'order_kana02', 'お名前(フリガナ名)', 7, 1, 1, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (110, 3, 'order_email', 'メールアドレス', 8, 1, 1, 'a', 'null', 'NO_SPTAB,EMAIL_CHECK,EMAIL_CHAR_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (111, 3, 'order_tel01', '電話番号1', 9, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (112, 3, 'order_tel02', '電話番号2', 10, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (113, 3, 'order_tel03', '電話番号3', 11, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (114, 3, 'order_fax01', 'FAX1', 12, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (115, 3, 'order_fax02', 'FAX2', 13, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (116, 3, 'order_fax03', 'FAX3', 14, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (117, 3, 'order_zip01', '郵便番号1', 15, 1, 1, 'n', 'ZIP01_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (118, 3, 'order_zip02', '郵便番号2', 16, 1, 1, 'n', 'ZIP02_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (119, 3, '(SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_order.order_pref) as pref', '都道府県', 17, 2, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (120, 3, 'order_addr01', '住所1', 18, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (121, 3, 'order_addr02', '住所2', 19, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (122, 3, 'order_sex', '性別', 20, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (123, 3, 'order_birth', '生年月日', 21, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (124, 3, 'order_job', '職種', 22, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (140, 3, 'subtotal', '小計', 38, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (141, 3, 'discount', '値引き', 39, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (142, 3, 'deliv_fee', '送料', 40, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (143, 3, 'charge', '手数料', 41, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (144, 3, 'use_point', '使用ポイント', 42, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (145, 3, 'add_point', '加算ポイント', 43, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (146, 3, 'tax', '税金', 44, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (147, 3, 'total', '合計', 45, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (148, 3, 'payment_total', 'お支払い合計', 46, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (149, 3, 'deliv_id', '配送業者ID', 47, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (150, 3, 'payment_method', '支払い方法', 48, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (152, 3, 'note', 'SHOPメモ', 50, 2, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (153, 3, 'status', '対応状況', 51, 1, 1, 'KVa', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (154, 3, 'create_date', '注文日時', 52, 1, 1, 'a', '', 'CHECK_DATE');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (155, 3, 'update_date', '更新日時', 53, 1, 1, 'a', '', 'CHECK_DATE');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (156, 3, 'commit_date', '発送完了日時', 54, 1, 1, 'a', '', 'CHECK_DATE');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (157, 3, 'device_type_id', '端末種別ID', 55, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (158, 3, '(SELECT COUNT(shipping_id) as shipping_target_num FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_num', '配送先数', 56, 1, 1, 'n', 'INT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (159, 3, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT shipping_id FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id), '','')) as shipping_ids', '配送情報ID', 57, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (180, 4, 'B.name', '商品名', 1, 2, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (181, 4, '(SELECT name FROM mtb_disp WHERE mtb_disp.id = A.status) as status', 'レビュー表示', 2, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (182, 4, 'A.create_date', '投稿日', 3, 1, 1, 'a', '', 'CHECK_DATE,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (183, 4, 'A.reviewer_name', '投稿者名', 4, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (184, 4, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = A.sex) as sex', '性別', 5, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (185, 4, '(SELECT name FROM mtb_recommend WHERE mtb_recommend.id = A.recommend_level) as recommend_level', 'おすすめレベル', 6, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (186, 4, 'A.title', 'タイトル', 7, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (187, 4, 'A.comment', 'コメント', 8, 1, 1, 'KVa', 'LTEXT_LEN', 'MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (195, 5, 'category_id', 'カテゴリID', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (196, 5, 'category_name', 'カテゴリ名', 2, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (197, 5, 'parent_category_id', '親カテゴリID', 3, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (198, 5, 'level', '階層', 2, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK') AND rank IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (199, 5, 'rank', '表示ランク', 2, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK') AND rank IS NULL;
DELETE FROM dtb_csv WHERE (no, csv_id, col, disp_name, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) = (200, 5, 'del_flg', '削除フラグ', 1, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK') AND rank IS NULL;
SELECT * FROM dtb_csv;

続いて、削除・挿入。

DELETE FROM dtb_csv WHERE csv_id = 1;
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (1, 1, 'product_id', '商品ID', 1, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (2, 1, 'product_class_id', '商品規格ID', 2, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (3, 1, 'parent_classcategory_id', '親規格分類ID', 3, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (4, 1, 'classcategory_id', '規格分類ID', 4, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (5, 1, 'parent_classcategory_name', '親規格分類名', 5, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (6, 1, 'classcategory_name', '規格分類名', 6, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (7, 1, 'maker_id', 'メーカーID', 7, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (8, 1, '(SELECT name as maker_name FROM dtb_maker WHERE prdcls.maker_id = dtb_maker.maker_id) as maker_name', 'メーカー名', 8, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (9, 1, 'name', '商品名', 9, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (10, 1, 'status', '表示ステータス(公開・非公開)', 10, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (11, 1, 'comment1', 'メーカーURL(コメント1)', 11, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'URL_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,URL_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (12, 1, 'comment2', 'コメント2', 12, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (13, 1, 'comment3', '検索ワード(コメント3)', 13, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (14, 1, 'comment4', 'コメント4', 14, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (15, 1, 'comment5', 'コメント5', 15, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (16, 1, 'comment6', 'コメント6', 16, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (17, 1, 'note', '備考欄(SHOP専用)', 17, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (18, 1, 'main_list_comment', '一覧-メインコメント', 18, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (19, 1, 'main_list_image', '一覧-メイン画像', 19, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (20, 1, 'main_comment', '詳細-メインコメント', 20, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK,HTML_TAG_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (21, 1, 'main_image', '詳細-メイン画像', 21, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (22, 1, 'main_large_image', '詳細-メイン拡大画像 ', 22, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (23, 1, 'sub_title1', '詳細-サブタイトル(1)', 23, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (24, 1, 'sub_comment1', '詳細-サブコメント(1)', 24, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,HTML_TAG_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (25, 1, 'sub_image1', '詳細-サブ画像(1)', 25, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (26, 1, 'sub_large_image1', '詳細-サブ拡大画像(1)', 26, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (27, 1, 'sub_title2', '詳細-サブタイトル(2)', 27, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (28, 1, 'sub_comment2', '詳細-サブコメント(2)', 28, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (29, 1, 'sub_image2', '詳細-サブ画像(2)', 29, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (30, 1, 'sub_large_image2', '詳細-サブ拡大画像(2)', 30, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (31, 1, 'sub_title3', '詳細-サブタイトル(3)', 31, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (32, 1, 'sub_comment3', '詳細-サブコメント(3)', 32, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (33, 1, 'sub_image3', '詳細-サブ画像(3)', 33, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (34, 1, 'sub_large_image3', '詳細-サブ拡大画像(3)', 34, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (35, 1, 'sub_title4', '詳細-サブタイトル(4)', 35, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (36, 1, 'sub_comment4', '詳細-サブコメント(4)', 36, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (37, 1, 'sub_image4', '詳細-サブ画像(4)', 37, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (38, 1, 'sub_large_image4', '詳細-サブ拡大画像(4)', 38, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (39, 1, 'sub_title5', '詳細-サブタイトル(5)', 39, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (40, 1, 'sub_comment5', '詳細-サブコメント(5)', 40, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (41, 1, 'sub_image5', '詳細-サブ画像(5)', 41, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (42, 1, 'sub_large_image5', '詳細-サブ拡大画像(5)', 42, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (43, 1, 'deliv_date_id', '発送日目安ID', 43, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (44, 1, 'del_flg', '削除フラグ', 44, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (45, 1, 'product_type_id', '商品種別ID', 45, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (46, 1, 'product_code', '商品コード', 46, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (47, 1, 'stock', '在庫数', 47, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (48, 1, 'stock_unlimited', '在庫無制限フラグ', 48, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (49, 1, 'sale_limit', '販売制限数', 49, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (50, 1, 'price01', '通常価格', 50, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (51, 1, 'price02', '販売価格', 51, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (52, 1, 'deliv_fee', '送料', 52, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (53, 1, 'point_rate', 'ポイント付与率', 53, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PERCENTAGE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (54, 1, 'down_filename', 'ダウンロードファイル名', 54, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (55, 1, 'down_realfilename', 'ダウンロード実ファイル', 55, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,DOWN_FILE_EXISTS');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 0) AS recommend_product_id1', '関連商品ID(1)', 56, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 0) AS recommend_comment1', '関連商品コメント(1)', 57, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 1) AS recommend_product_id2', '関連商品ID(2)', 58, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 1) AS recommend_comment2', '関連商品コメント(2)', 59, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 2) AS recommend_product_id3', '関連商品ID(3)', 60, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 2) AS recommend_comment3', '関連商品コメント(3)', 61, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 3) AS recommend_product_id4', '関連商品ID(4)', 62, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 3) AS recommend_comment4', '関連商品コメント(4)', 63, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 4) AS recommend_product_id5', '関連商品ID(5)', 64, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 4) AS recommend_comment5', '関連商品コメント(5)', 65, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 5) AS recommend_product_id6', '関連商品ID(6)', 66, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) 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 5) AS recommend_comment6', '関連商品コメント(6)', 67, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (68, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT product_status_id FROM dtb_product_status WHERE dtb_product_status.product_id = prdcls.product_id and del_flg = 0 ORDER BY dtb_product_status.product_status_id), '','')) as product_statuses', '商品ステータス', 68, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (69, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT name FROM dtb_product_status LEFT JOIN mtb_status ON  dtb_product_status.product_status_id = mtb_status.id  WHERE dtb_product_status.product_id = prdcls.product_id and del_flg = 0 ORDER BY dtb_product_status.product_status_id), '','')) as product_status_names', '商品ステータス名', 69, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (70, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT category_id FROM dtb_product_categories WHERE dtb_product_categories.product_id = prdcls.product_id ORDER BY dtb_product_categories.rank), '','')) as category_ids', 'カテゴリID', 70, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (71, 1, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT category_name FROM dtb_product_categories LEFT JOIN dtb_category ON dtb_product_categories.category_id = dtb_category.category_id WHERE dtb_product_categories.product_id = prdcls.product_id ORDER BY dtb_product_categories.rank), '','')) as category_names', 'カテゴリ名', 71, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
 
-- コンテンツ管理>CSV出力設定>会員管理
DELETE FROM dtb_csv WHERE csv_id = 2;
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (72, 2, 'customer_id', '会員ID', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (73, 2, 'name01', 'お名前(姓)', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (74, 2, 'name02', 'お名前(名)', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (75, 2, 'kana01', 'お名前(フリガナ・姓)', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (76, 2, 'kana02', 'お名前(フリガナ・名)', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (77, 2, 'zip01', '郵便番号1', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (78, 2, 'zip02', '郵便番号2', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (79, 2, '(SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_customer.pref) as pref', '都道府県', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (80, 2, 'addr01', '住所1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (81, 2, 'addr02', '住所2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (82, 2, 'email', 'E-MAIL', 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (83, 2, 'tel01', 'TEL1', 12, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (84, 2, 'tel02', 'TEL2', 13, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (85, 2, 'tel03', 'TEL3', 14, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (86, 2, 'fax01', 'FAX1', 15, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (87, 2, 'fax02', 'FAX2', 16, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (88, 2, 'fax03', 'FAX3', 17, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (89, 2, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = dtb_customer.sex) as sex', '性別', 18, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (90, 2, '(SELECT name FROM mtb_job WHERE mtb_job.id = dtb_customer.job) as job', '職業', 19, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (91, 2, 'birth', '誕生日', 20, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (92, 2, 'first_buy_date', '初回購入日', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (93, 2, 'last_buy_date', '最終購入日', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (94, 2, 'buy_times', '購入回数', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (95, 2, 'point', 'ポイント残高', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (96, 2, 'note', '備考', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (97, 2, 'create_date', '登録日', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, STATUS, create_date, update_date) VALUES (98, 2, 'update_date', '更新日', 27, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 
-- コンテンツ管理>CSV出力設定>受注管理
DELETE FROM dtb_csv WHERE csv_id = 3;
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (99, 3, 'order_id', '注文番号', 1, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (100, 3, 'customer_id', '会員ID', 2, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (101, 3, 'message', '要望等', 3, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (102, 3, 'order_name01', 'お名前(姓)', 4, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (103, 3, 'order_name02', 'お名前(名)', 5, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (104, 3, 'order_kana01', 'お名前(フリガナ・姓)', 6, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (105, 3, 'order_kana02', 'お名前(フリガナ名)', 7, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (106, 3, 'order_email', 'メールアドレス', 8, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', 'null', 'NO_SPTAB,EMAIL_CHECK,EMAIL_CHAR_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (107, 3, 'order_tel01', '電話番号1', 9, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (108, 3, 'order_tel02', '電話番号2', 10, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (109, 3, 'order_tel03', '電話番号3', 11, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (110, 3, 'order_fax01', 'FAX1', 12, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (111, 3, 'order_fax02', 'FAX2', 13, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (112, 3, 'order_fax03', 'FAX3', 14, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (113, 3, 'order_zip01', '郵便番号1', 15, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'ZIP01_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (114, 3, 'order_zip02', '郵便番号2', 16, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'ZIP02_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (115, 3, '(SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_order.order_pref) as pref', '都道府県', 17, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (116, 3, 'order_addr01', '住所1', 18, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (117, 3, 'order_addr02', '住所2', 19, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (118, 3, 'order_sex', '性別', 20, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (119, 3, 'order_birth', '生年月日', 21, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (120, 3, 'order_job', '職種', 22, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (121, 3, 'subtotal', '小計', 38, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (122, 3, 'discount', '値引き', 39, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (123, 3, 'deliv_fee', '送料', 40, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (124, 3, 'charge', '手数料', 41, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (125, 3, 'use_point', '使用ポイント', 42, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (126, 3, 'add_point', '加算ポイント', 43, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (127, 3, 'tax', '税金', 44, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (128, 3, 'total', '合計', 45, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (129, 3, 'payment_total', 'お支払い合計', 46, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (130, 3, 'deliv_id', '配送業者ID', 47, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (131, 3, 'payment_method', '支払い方法', 48, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (132, 3, 'note', 'SHOPメモ', 50, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (133, 3, 'status', '対応状況', 51, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (134, 3, 'create_date', '注文日時', 52, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (135, 3, 'update_date', '更新日時', 53, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (136, 3, 'commit_date', '発送完了日時', 54, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (137, 3, 'device_type_id', '端末種別ID', 55, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (138, 3, '(SELECT COUNT(shipping_id) as shipping_target_num FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_num', '配送先数', 56, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (139, 3, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT shipping_id FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id), '','')) as shipping_ids', '配送情報ID', 57, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
 
-- コンテンツ管理>CSV出力設定>レビュー
DELETE FROM dtb_csv WHERE csv_id = 4;
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (140, 4, 'B.name', '商品名', 1, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (141, 4, '(SELECT name FROM mtb_disp WHERE mtb_disp.id = A.status) as status', 'レビュー表示', 2, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (142, 4, 'A.create_date', '投稿日', 3, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (143, 4, 'A.reviewer_name', '投稿者名', 4, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (144, 4, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = A.sex) as sex', '性別', 5, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (145, 4, '(SELECT name FROM mtb_recommend WHERE mtb_recommend.id = A.recommend_level) as recommend_level', 'おすすめレベル', 6, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (146, 4, 'A.title', 'タイトル', 7, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (147, 4, 'A.comment', 'コメント', 8, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LTEXT_LEN', 'MAX_LENGTH_CHECK');
 
-- コンテンツ管理>CSV出力設定>カテゴリ
DELETE FROM dtb_csv WHERE csv_id = 5;
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (148, 5, 'category_id', 'カテゴリID', 1, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (149, 5, 'category_name', 'カテゴリ名', 2, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (150, 5, 'parent_category_id', '親カテゴリID', 3, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (151, 5, 'level', '階層', NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (152, 5, 'rank', '表示ランク', NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, STATUS, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (153, 5, 'del_flg', '削除フラグ', NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');

mtb_customer_order_status

INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (7, '注文未完了', 0);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (1, '注文受付', 1);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (2, '入金待ち', 2);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (6, '注文受付', 3);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (3, 'キャンセル', 4);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (4, '注文受付', 5);
INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (5, '発送済み', 6);

mtb_constants

まずは、設定変更済みの箇所を特定する。該当箇所は、後から手動でマージする。(設定変更の移行が不要な場合、いきなり削除・挿入で良い。)

DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SAMPLE_ADDRESS1', '"市区町村名 (例:千代田区神田神保町)"', 1, 'フロント表示関連');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SAMPLE_ADDRESS2', '"番地・ビル名 (例:1-3-5)"', 2, 'フロント表示関連');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_DIR', '"user_data/"', 3, 'ユーザファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_REALDIR', 'HTML_REALDIR . USER_DIR', 4, 'ユーザファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_INC_REALDIR', 'USER_REALDIR . "include/"', 5, 'ユーザインクルードファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ZIP_DSN', 'DEFAULT_DSN', 8, '郵便番号専用DB');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_URL', 'HTTP_URL . USER_DIR', 9, 'ユーザー作成ページ等');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('AUTH_TYPE', '"HMAC"', 10, '認証方式');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_TEMPLATE_DIR', '"templates/"', 16, 'テンプレートファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_PACKAGE_DIR', '"packages/"', 17, 'テンプレートファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_TEMPLATE_REALDIR', 'USER_REALDIR . USER_PACKAGE_DIR', 18, 'テンプレートファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEMPLATE_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_template/"', 19, 'テンプレートファイル一時保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USER_DEF_PHP_REALFILE', 'USER_REALDIR . "__default.php"', 20, 'ユーザー作成画面のデフォルトPHPファイル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEF_LAYOUT', '"products/list.php"', 21, 'その他画面のデフォルトページレイアウト');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MODULE_DIR', '"downloads/module/"', 22, 'ダウンロードモジュール保存ディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MODULE_REALDIR', 'DATA_REALDIR . MODULE_DIR', 23, 'ダウンロードモジュール保存ディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAX_LIFETIME', '7200', 26, 'DBセッションの有効期限(秒)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MASTER_DATA_REALDIR', 'DATA_REALDIR . "cache/"', 27, 'マスターデータキャッシュディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UPDATE_HTTP', '"http://sv01.ec-cube.net/info/index.php"', 28, 'アップデート管理用ファイル格納場所');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UPDATE_CSV_LINE_MAX', '4096', 29, 'アップデート管理用CSV1行辺りの最大文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UPDATE_CSV_COL_MAX', '13', 30, 'アップデート管理用CSVカラム数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MODULE_CSV_COL_MAX', '16', 31, 'モジュール管理用CSVカラム数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CHAR_CODE', '"UTF-8"', 39, '文字コード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LOCALE', '"ja_JP.UTF-8"', 40, 'ロケール設定');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ECCUBE_PAYMENT', '"EC-CUBE"', 41, '決済モジュール付与文言');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PEAR_DB_DEBUG', '9', 42, 'PEAR::DBのデバッグモード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PEAR_DB_PERSISTENT', 'false', 43, 'PEAR::DBの持続的接続オプション');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LOAD_BATCH_PASS', '3600', 44, 'バッチを実行する最短の間隔(秒)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CLOSE_DAY', '31', 45, '締め日の指定(末日の場合は、31を指定してください。)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('FAVORITE_ERROR', '13', 46, '一般サイトエラー');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('GRAPH_REALDIR', 'HTML_REALDIR . "upload/graph_image/"', 49, 'グラフ格納ディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('GRAPH_URLPATH', 'ROOT_URLPATH . "upload/graph_image/"', 50, 'グラフURL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('GRAPH_PIE_MAX', '10', 51, '円グラフ最大表示数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('GRAPH_LABEL_MAX', '40', 52, 'グラフのラベルの文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('BAT_ORDER_AGE', '70', 54, '何歳まで集計の対象とするか');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PRODUCTS_TOTAL_MAX', '15', 55, '商品集計で何位まで表示するか');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEFAULT_PRODUCT_DISP', '2', 56, '1:公開 2:非公開');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIV_FREE_AMOUNT', '0', 57, '送料無料購入数量 (0の場合は、いくつ買っても無料にならない)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('INPUT_DELIV_FEE', '1', 58, '配送料の設定画面表示(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OPTION_PRODUCT_DELIV_FEE', '0', 59, '商品ごとの送料設定(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OPTION_DELIV_FEE', '1', 60, '配送業者ごとの配送料を加算する(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OPTION_RECOMMEND', '1', 61, 'おすすめ商品登録(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OPTION_CLASS_REGIST', '1', 62, '商品規格登録(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEFAULT_PASSWORD', '"******"', 66, '会員登録変更(マイページ)パスワード用');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIV_ADDR_MAX', '20', 67, '別のお届け先最大登録数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_STATUS_MAX', '50', 70, '対応状況管理画面の一覧表示件数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('REVIEW_REGIST_MAX', '5', 71, 'フロントレビュー書き込み最大数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEBUG_MODE', 'false', 72, 'デバッグモード(true:sfPrintRやDBのエラーメッセージ、ログレベルがDebugのログを出力する、false:出力しない)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_ID', '"1"', 73, '管理ユーザID(メンテナンス用表示されない。)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CUSTOMER_CONFIRM_MAIL', 'false', 74, '会員登録時に仮会員確認メールを送信するか (true:仮会員、false:本会員)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LOGIN_FRAME', '"login_frame.tpl"', 77, 'ログイン画面フレーム');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAIN_FRAME', '"main_frame.tpl"', 78, '管理画面フレーム');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SITE_FRAME', '"site_frame.tpl"', 79, '一般サイト画面フレーム');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CERT_STRING', '"7WDhcBTF"', 80, '認証文字列');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('BIRTH_YEAR', '1901', 83, '生年月日登録開始年');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('RELEASE_YEAR', '2005', 84, '本システムの稼働開始年');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CREDIT_ADD_YEAR', '10', 85, 'クレジットカードの期限+何年');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PARENT_CAT_MAX', '12', 86, '親カテゴリのカテゴリIDの最大数 (これ以下は親カテゴリとする。)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NUMBER_MAX', '1000000000', 87, 'GET値変更などのいたずらを防ぐため最大数制限を設ける。');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('POINT_RULE', '2', 88, 'ポイントの計算ルール(1:四捨五入、2:切り捨て、3:切り上げ)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('POINT_VALUE', '1', 89, '1ポイント当たりの値段(円)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_MODE', '0', 90, '管理モード 1:有効 0:無効(納品時)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DAILY_BATCH_MODE', 'false', 91, '売上集計バッチモード(true:バッチで集計する ※要cron設定、false:リアルタイムで集計する)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAX_LOG_QUANTITY', '5', 92, 'ログファイル最大数(ログテーション)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAX_LOG_SIZE', '"1000000"', 93, '1つのログファイルに保存する最大容量(byte)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TRANSACTION_ID_NAME', '"transactionid"', 94, 'トランザクションID の名前');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('FORGOT_MAIL', '0', 95, 'パスワード忘れの確認メールを送付するか否か。(0:送信しない、1:送信する)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('HTML_TEMPLATE_SUB_MAX', '12', 96, '登録できるサブ商品の数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LINE_LIMIT_SIZE', '60', 97, '文字数が多すぎるときに強制改行するサイズ(半角)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('BIRTH_MONTH_POINT', '0', 98, '誕生日月ポイント');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LARGE_IMAGE_WIDTH', '500', 110, '拡大画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LARGE_IMAGE_HEIGHT', '500', 111, '拡大画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMALL_IMAGE_WIDTH', '130', 112, '一覧画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMALL_IMAGE_HEIGHT', '130', 113, '一覧画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NORMAL_IMAGE_WIDTH', '260', 114, '通常画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NORMAL_IMAGE_HEIGHT', '260', 115, '通常画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NORMAL_SUBIMAGE_WIDTH', '200', 116, '通常サブ画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NORMAL_SUBIMAGE_HEIGHT', '200', 117, '通常サブ画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LARGE_SUBIMAGE_WIDTH', '500', 118, '拡大サブ画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LARGE_SUBIMAGE_HEIGHT', '500', 119, '拡大サブ画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DISP_IMAGE_WIDTH', '65', 120, '一覧表示画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DISP_IMAGE_HEIGHT', '65', 121, '一覧表示画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OTHER_IMAGE1_WIDTH', '500', 122, 'その他の画像1');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OTHER_IMAGE1_HEIGHT', '500', 123, 'その他の画像1');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('HTMLMAIL_IMAGE_WIDTH', '110', 124, 'HTMLメールテンプレートメール担当画像横');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('HTMLMAIL_IMAGE_HEIGHT', '120', 125, 'HTMLメールテンプレートメール担当画像縦');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_SIZE', '1000', 126, '画像サイズ制限(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_SIZE', '2000', 127, 'CSVサイズ制限(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_LINE_MAX', '10000', 128, 'CSVアップロード1行あたりの最大文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PDF_SIZE', '5000', 129, 'PDFサイズ制限(KB):商品詳細ファイル等');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('FILE_SIZE', '10000', 130, 'ファイル管理画面アップ制限(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEMPLATE_SIZE', '10000', 131, 'アップできるテンプレートファイル制限(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LEVEL_MAX', '5', 132, 'カテゴリの最大階層');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CATEGORY_MAX', '1000', 133, '最大カテゴリ登録数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_TITLE', '"EC-CUBE 管理機能"', 134, '管理機能タイトル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SELECT_RGB', '"#ffffdf"', 135, '編集時強調表示色');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DISABLED_RGB', '"#C9C9C9"', 136, '入力項目無効時の表示色');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ERR_COLOR', '"#ffe8e8"', 137, 'エラー時表示色');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CATEGORY_HEAD', '">"', 138, '親カテゴリ表示文字');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('START_BIRTH_YEAR', '1970', 139, '生年月日初期選択年');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NORMAL_PRICE_TITLE', '"通常価格"', 140, '価格名称');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SALE_PRICE_TITLE', '"販売価格"', 141, '価格名称');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LOG_REALFILE', 'DATA_REALDIR . "logs/site.log"', 142, 'ログファイル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CUSTOMER_LOG_REALFILE', 'DATA_REALDIR . "logs/customer.log"', 143, '会員ログイン ログファイル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_image/"', 150, '画像一時保存');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_SAVE_REALDIR', 'HTML_REALDIR . "upload/save_image/"', 151, '画像保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_TEMP_URLPATH', 'ROOT_URLPATH . "upload/temp_image/"', 152, '画像一時保存URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_SAVE_URLPATH', 'ROOT_URLPATH . "upload/save_image/"', 153, '画像保存先URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_TEMP_RSS_URL', 'HTTP_URL . "upload/temp_image/"', 154, 'RSS用画像一時保存URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_SAVE_RSS_URL', 'HTTP_URL . "upload/save_image/"', 155, 'RSS用画像保存先URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_TEMP_REALDIR', 'DATA_REALDIR . "upload/csv/"', 156, 'エンコードCSVの一時保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NO_IMAGE_REALDIR', 'USER_TEMPLATE_REALDIR . "img/picture/img_blank.gif"', 158, '画像がない場合に表示');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_SYSTEM_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "system/" . DIR_INDEX_PATH', 159, 'システム管理トップ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_CLASS_REGIST_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "products/class.php"', 160, '規格登録');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('INPUT_ZIP_URLPATH', 'ROOT_URLPATH . "input_zip.php"', 161, '郵便番号入力');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_DELIVERY_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "basis/delivery.php"', 162, '配送業者登録');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_PAYMENT_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "basis/payment.php"', 163, '支払い方法登録');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_HOME_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "home.php"', 165, 'ホーム');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_LOGIN_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . DIR_INDEX_PATH', 166, 'ログインページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_PRODUCTS_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "products/" . DIR_INDEX_PATH', 167, '商品検索ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_ORDER_EDIT_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/edit.php"', 168, '注文編集ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_ORDER_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/" . DIR_INDEX_PATH', 169, '注文編集ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_ORDER_MAIL_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/mail.php"', 170, '注文編集ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_LOGOUT_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "logout.php"', 171, 'ログアウトページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SUCCESS', '0', 176, 'アクセス成功');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MEMBER_PMAX', '10', 182, 'メンバー管理ページ表示行数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SEARCH_PMAX', '10', 183, '検索ページ表示行数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NAVI_PMAX', '4', 184, 'ページ番号の最大表示数量');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PRODUCTSUB_MAX', '5', 185, '商品サブ情報最大数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIVTIME_MAX', '16', 186, 'お届け時間の最大表示数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIVFEE_MAX', '47', 187, '配送料金の最大表示数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('STEXT_LEN', '50', 188, '短い項目の文字数 (名前など)');
DELETE FROM mtb_constants WHERE (id, name, rank) = ('SMTEXT_LEN', '100', 189) AND remarks IS NULL;
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MTEXT_LEN', '200', 190, '長い項目の文字数 (住所など)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MLTEXT_LEN', '1000', 191, '長中文の文字数 (問い合わせなど)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LTEXT_LEN', '3000', 192, '長文の文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('LLTEXT_LEN', '99999', 193, '超長文の文字数 (メルマガなど)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('URL_LEN', '1024', 194, 'URLの文字長');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ID_MAX_LEN', 'STEXT_LEN', 195, '管理画面用:ID・パスワードの文字数制限');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ID_MIN_LEN', '4', 196, '管理画面用:ID・パスワードの文字数制限');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PRICE_LEN', '8', 197, '金額桁数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PERCENTAGE_LEN', '3', 198, '率桁数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('AMOUNT_LEN', '6', 199, '在庫数、販売制限数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ZIP01_LEN', '3', 200, '郵便番号1');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ZIP02_LEN', '4', 201, '郵便番号2');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEL_ITEM_LEN', '6', 202, '電話番号各項目制限');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEL_LEN', '12', 203, '電話番号総数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PASSWORD_MIN_LEN', '4', 204, 'フロント画面用:パスワードの最小文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PASSWORD_MAX_LEN', 'STEXT_LEN', 205, 'フロント画面用:パスワードの最大文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('INT_LEN', '9', 206, '検査数値用桁数(INT)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CREDIT_NO_LEN', '4', 207, 'クレジットカードの文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SEARCH_CATEGORY_LEN', '18', 208, '検索カテゴリ最大表示文字数(byte)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('FILE_NAME_LEN', '10', 209, 'ファイル名表示文字数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('COOKIE_EXPIRE', '365', 212, 'クッキー保持期限(日)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SEPA_CATNAVI', '" > "', 235, 'カテゴリ区切り文字');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SEPA_CATLIST', '" | "', 236, 'カテゴリ区切り文字');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SHOPPING_URL', 'HTTPS_URL . "shopping/" . DIR_INDEX_PATH', 237, '会員情報入力');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ENTRY_URL', 'HTTPS_URL . "entry/" . DIR_INDEX_PATH', 238, '会員登録ページTOP');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TOP_URLPATH', 'ROOT_URLPATH . DIR_INDEX_PATH', 239, 'サイトトップ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CART_URLPATH', 'ROOT_URLPATH . "cart/" . DIR_INDEX_PATH', 240, 'カートトップ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIV_URLPATH', 'ROOT_URLPATH . "shopping/deliv.php"', 241, 'お届け先設定');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MULTIPLE_URLPATH', 'ROOT_URLPATH . "shopping/multiple.php"', 242, '複数お届け先設定');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('URL_MYPAGE_TOP', 'HTTPS_URL . "mypage/login.php"', 243, 'Myページトップ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SHOPPING_CONFIRM_URLPATH', 'ROOT_URLPATH . "shopping/confirm.php"', 244, '購入確認ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SHOPPING_PAYMENT_URLPATH', 'ROOT_URLPATH . "shopping/payment.php"', 245, 'お支払い方法選択ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SHOPPING_COMPLETE_URLPATH', 'ROOT_URLPATH . "shopping/complete.php"', 246, '購入完了画面');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SHOPPING_MODULE_URLPATH', 'ROOT_URLPATH . "shopping/load_payment_module.php"', 249, 'モジュール追加用画面');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('P_DETAIL_URLPATH', 'ROOT_URLPATH . "products/detail.php?product_id="', 253, '商品詳細(HTML出力)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MYPAGE_DELIVADDR_URLPATH', 'ROOT_URLPATH . "mypage/delivery.php"', 254, 'マイページお届け先URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAIL_TYPE_PC', '1', 255, 'メールアドレス種別');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAIL_TYPE_MOBILE', '2', 256, 'メールアドレス種別');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ADMIN_NEWS_STARTYEAR', '2005', 264, '新着情報管理画面 開始年(西暦) ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ENTRY_CUSTOMER_TEMP_SUBJECT', '"会員仮登録が完了いたしました。"', 265, '会員登録');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ENTRY_CUSTOMER_REGIST_SUBJECT', '"本会員登録が完了いたしました。"', 266, '会員登録');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ENTRY_LIMIT_HOUR', '1', 267, '再入会制限時間 (単位: 時間)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('RECOMMEND_PRODUCT_MAX', '6', 268, '関連商品表示数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('RECOMMEND_NUM', '8', 269, 'おすすめ商品表示数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DELIV_DATE_END_MAX', '21', 272, 'お届け可能日以降のプルダウン表示最大日数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PURCHASE_CUSTOMER_REGIST', '0', 273, '購入時強制会員登録(1:有効 0:無効)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CV_PAYMENT_LIMIT', '14', 275, '支払期限');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('REVIEW_ALLOW_URL', '0', 277, '商品レビューでURL書き込みを許可するか否か');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MAIL_BACKEND', '"smtp"', 285, 'Pear::Mail バックエンド:mail|smtp|sendmail');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMTP_HOST', '"127.0.0.1"', 287, 'SMTPサーバー');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMTP_PORT', '"25"', 288, 'SMTPポート');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UPDATE_SEND_SITE_INFO', 'false', 289, 'アップデート時にサイト情報を送出するか');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USE_POINT', 'true', 290, 'ポイントを利用するか(true:利用する、false:利用しない) (false は一部対応)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('NOSTOCK_HIDDEN', 'false', 291, '在庫無し商品の非表示(true:非表示、false:表示)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('USE_MOBILE', 'true', 292, 'モバイルサイトを利用するか(true:利用する、false:利用しない) (false は一部対応)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEFAULT_TEMPLATE_NAME', '"default"', 300, 'デフォルトテンプレート名(PC)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_DEFAULT_TEMPLATE_NAME', '"mobile"', 301, 'デフォルトテンプレート名(モバイル)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMARTPHONE_DEFAULT_TEMPLATE_NAME', '"sphone"', 302, 'デフォルトテンプレート名(スマートフォン)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEMPLATE_NAME', '"default"', 303, 'テンプレート名');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_TEMPLATE_NAME', '"mobile"', 304, 'モバイルテンプレート名');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMARTPHONE_TEMPLATE_NAME', '"sphone"', 305, 'スマートフォンテンプレート名');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMARTY_TEMPLATES_REALDIR', ' DATA_REALDIR . "Smarty/templates/"', 306, 'SMARTYテンプレート');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . TEMPLATE_NAME . "/"', 307, 'SMARTYテンプレート(PC)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TEMPLATE_ADMIN_REALDIR', 'SMARTY_TEMPLATES_REALDIR . "admin/"', 308, 'SMARTYテンプレート(管理機能)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . TEMPLATE_NAME . "/"', 309, 'SMARTYコンパイル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('COMPILE_ADMIN_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/admin/"', 310, 'SMARTYコンパイル(管理機能)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('BLOC_DIR', '"frontparts/bloc/"', 311, 'ブロックファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . MOBILE_TEMPLATE_NAME . "/"', 312, 'SMARTYテンプレート(mobile)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . MOBILE_TEMPLATE_NAME . "/"', 313, 'SMARTYコンパイル(mobile)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMARTPHONE_TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . SMARTPHONE_TEMPLATE_NAME . "/"', 314, 'SMARTYテンプレート(smart phone)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SMARTPHONE_COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . SMARTPHONE_TEMPLATE_NAME . "/"', 315, 'SMARTYコンパイル(smartphone)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('RFC_COMPLIANT_EMAIL_CHECK', 'false', 401, 'EメールアドレスチェックをRFC準拠にするか(true:準拠する、false:準拠しない)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SESSION_LIFETIME', '1800', 402, 'モバイルサイトのセッションの存続時間 (秒)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_IMAGE_REALDIR', 'HTML_REALDIR . "upload/mobile_image/"', 408, '携帯電話向け変換画像保存ディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_IMAGE_URLPATH', 'ROOT_URLPATH . "upload/mobile_image/"', 409, '携帯電話向け変換画像保存ディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_TOP_URLPATH', 'ROOT_URLPATH . DIR_INDEX_PATH', 410, 'モバイルURL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_CART_URLPATH', 'ROOT_URLPATH . "cart/" . DIR_INDEX_PATH', 411, 'カートトップ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SHOPPING_URL', 'HTTPS_URL . "shopping/" . DIR_INDEX_PATH', 412, '会員情報入力');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SHOPPING_CONFIRM_URLPATH', 'ROOT_URLPATH . "shopping/confirm.php"', 413, '購入確認ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SHOPPING_PAYMENT_URLPATH', 'ROOT_URLPATH . "shopping/payment.php"', 414, 'お支払い方法選択ページ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_P_DETAIL_URLPATH', 'ROOT_URLPATH . "products/detail.php?product_id="', 415, '商品詳細(HTML出力)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SHOPPING_COMPLETE_URLPATH', 'ROOT_URLPATH . "shopping/complete.php"', 416, '購入完了画面');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('MOBILE_SHOPPING_MODULE_URLPATH', 'ROOT_URLPATH . "shopping/load_payment_module.php"', 417, 'モジュール追加用画面');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SESSION_KEEP_METHOD', '"useCookie"', 418, 'セッション維持方法:useCookie|useRequest');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SESSION_LIFETIME', '1800', 419, 'セッションの存続時間 (秒)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_URL', '"http://store.ec-cube.net/"', 500, 'オーナーズストアURL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_SSLURL', '"https://store.ec-cube.net/"', 501, 'オーナーズストアURL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_LOG_REALFILE', 'DATA_REALDIR . "logs/ownersstore.log"', 502, 'オーナーズストアログパス');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_STATUS_ERROR', '"ERROR"', 503, 'オーナーズストア通信ステータス');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_STATUS_SUCCESS', '"SUCCESS"', 504, 'オーナーズストア通信ステータス');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_UNKNOWN', '"1000"', 505, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_INVALID_PARAM', '"1001"', 506, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_NO_CUSTOMER', '"1002"', 507, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_WRONG_URL_PASS', '"1003"', 508, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_NO_PRODUCTS', '"1004"', 509, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_NO_DL_DATA', '"1005"', 510, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_DL_DATA_OPEN', '"1006"', 511, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_DLLOG_AUTH', '"1007"', 512, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_ADMIN_AUTH', '"2001"', 513, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_HTTP_REQ', '"2002"', 514, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_HTTP_RESP', '"2003"', 515, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_FAILED_JSON_PARSE', '"2004"', 516, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_NO_KEY', '"2005"', 517, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_INVALID_ACCESS', '"2006"', 518, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_INVALID_PARAM', '"2007"', 519, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_AUTOUP_DISABLE', '"2008"', 520, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_PERMISSION', '"2009"', 521, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OSTORE_E_C_BATCH_ERR', '"2010"', 522, 'オーナーズストア通信エラーコード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('OPTION_FAVOFITE_PRODUCT', '1', 523, 'お気に入り商品登録(有効:1 無効:0)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('IMAGE_RENAME', 'true', 525, '画像リネーム設定 (商品画像のみ) (true:リネームする、false:リネームしない)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_DIR', '"plugins/"', 600, 'プラグインディレクトリ');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_REALDIR', 'USER_REALDIR . PLUGIN_DIR', 601, 'プラグイン保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_URL', 'USER_URL . PLUGIN_DIR', 602, 'プラグイン URL');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWNLOAD_DAYS_LEN', '3', 700, '日数桁数');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWNLOAD_EXTENSION', '"zip,lzh,jpg,jpeg,gif,png,mp3,pdf,csv"', 701, 'ダウンロードファイル登録可能拡張子(カンマ区切り)"');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWN_SIZE', '50000', 702, 'ダウンロード販売ファイル用サイズ制限(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEFAULT_PRODUCT_DOWN', '1', 703, '1:実商品 2:ダウンロード');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWN_TEMP_REALDIR', 'DATA_REALDIR . "download/temp/"', 704, 'ダウンロードファイル一時保存');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWN_SAVE_REALDIR', 'DATA_REALDIR . "download/save/"', 705, 'ダウンロードファイル保存先');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWNFILE_NOT_FOUND', '22', 706, 'ダウンロードファイル存在エラー');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ONLINE_PAYMENT', '"1"', 707, 'ダウンロード販売機能用オンライン決済payment_id(カンマ区切り)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DOWNLOAD_BLOCK', '1024', 708, 'ダウンロード販売機能 ダウンロードファイル読み込みバイト(KB)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_NEW', '1', 800, '新規注文');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_PAY_WAIT', '2', 801, '入金待ち');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_PRE_END', '6', 802, '入金済み');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_CANCEL', '3', 803, 'キャンセル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_BACK_ORDER', '4', 804, '取り寄せ中');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_DELIV', '5', 805, '発送済み');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ORDER_PENDING', '7', 806, '決済処理中');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PRODUCT_TYPE_NORMAL', '1', 900, '通常商品');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PRODUCT_TYPE_DOWNLOAD', '2', 901, 'ダウンロード商品');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SQL_QUERY_LOG_MODE', '1', 1000, 'SQLログを取得するフラグ(1:表示, 0:非表示)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('SQL_QUERY_LOG_MIN_EXEC_TIME', '2', 1001, 'SQLログを取得する時間設定(設定値以上かかった場合に取得)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PAGE_DISPLAY_TIME_LOG_MODE', '1', 1002, 'ページ表示時間のログを取得するフラグ(1:表示, 0:非表示)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PAGE_DISPLAY_TIME_LOG_MIN_EXEC_TIME', '2', 1003, 'ページ表示時間のログを取得する時間設定(設定値以上かかった場合に取得)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEVICE_TYPE_MOBILE', '1', 1100, '端末種別: モバイル');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEVICE_TYPE_SMARTPHONE', '2', 1101, '端末種別: スマートフォン');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEVICE_TYPE_PC', '10', 1102, '端末種別: PC');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('DEVICE_TYPE_ADMIN', '99', 1103, '端末種別: 管理画面');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_UNUSED', '0', 1200, '配置ID: 未使用');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_LEFT', '1', 1201, '配置ID: LeftNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_MAIN_HEAD', '2', 1202, '配置ID: MainHead');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_RIGHT', '3', 1203, '配置ID: RightNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_MAIN_FOOT', '4', 1204, '配置ID: MainFoot');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_TOP', '5', 1205, '配置ID: TopNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_BOTTOM', '6', 1206, '配置ID: BottomNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_HEAD', '7', 1207, '配置ID: HeadNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_HEAD_TOP', '8', 1208, '配置ID: HeadTopNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_FOOTER_BOTTOM', '9', 1209, '配置ID: FooterBottomNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('TARGET_ID_HEADER_INTERNAL', '10', 1210, '配置ID: HeaderInternalNavi');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_COLUMN_STATUS_FLG_ENABLE', '1', 1211, 'CSV入出力列設定有効無効フラグ: 有効');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_COLUMN_STATUS_FLG_DISABLE', '2', 1212, 'CSV入出力列設定有効無効フラグ: 無効');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_COLUMN_RW_FLG_READ_WRITE', '1', 1213, 'CSV入出力列設定読み書きフラグ: 読み書き可能');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_COLUMN_RW_FLG_READ_ONLY', '2', 1214, 'CSV入出力列設定読み書きフラグ: 読み込みのみ可能');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('CSV_COLUMN_RW_FLG_KEY_FIELD', '3', 1215, 'CSV入出力列設定読み書きフラグ: キー列');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UNLIMITED_FLG_UNLIMITED', '"1"', 1216, '無制限フラグ: 無制限');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('UNLIMITED_FLG_LIMITED', '"0"', 1217, '無制限フラグ: 制限有り');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ECCUBE_INFO', 'true', 1218, ' EC-CUBE更新情報取得 (true:取得する false:取得しない)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('HTTP_REQUEST_TIMEOUT', '"5"', 1219, '外部サイトHTTP取得タイムアウト時間(秒)');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_STATUS_UPLOADED', '"1"', 1220, 'プラグインの状態:アップロード済み');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_STATUS_INSTALLED', '"2"', 1221, 'プラグインの状態:インストール済み');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_ENABLE_TRUE', '"1"', 1222, 'プラグイン有効/無効:有効');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('PLUGIN_ENABLE_FALSE', '"2"', 1223, 'プラグイン有効/無効:無効');
DELETE FROM mtb_constants WHERE (id, name, rank, remarks) = ('ZIP_DOWNLOAD_URL', '"http://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip"', 1224, '郵便番号CSVのZIPアーカイブファイルの取得元');
SELECT * FROM mtb_constants;

続いて、削除・挿入

DELETE FROM mtb_constants;
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SAMPLE_ADDRESS1', '"市区町村名 (例:千代田区神田神保町)"', 1, 'フロント表示関連');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SAMPLE_ADDRESS2', '"番地・ビル名 (例:1-3-5)"', 2, 'フロント表示関連');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_DIR', '"user_data/"', 3, 'ユーザファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_REALDIR', 'HTML_REALDIR . USER_DIR', 4, 'ユーザファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_URL', 'HTTP_URL . USER_DIR', 9, 'ユーザー作成ページ等');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('AUTH_TYPE', '"HMAC"', 10, '認証方式');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_PACKAGE_DIR', '"packages/"', 17, 'テンプレートファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_TEMPLATE_REALDIR', 'USER_REALDIR . USER_PACKAGE_DIR', 18, 'テンプレートファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEMPLATE_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_template/"', 19, 'テンプレートファイル一時保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USER_DEF_PHP_REALFILE', 'USER_REALDIR . "__default.php"', 20, 'ユーザー作成画面のデフォルトPHPファイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MODULE_DIR', '"downloads/module/"', 22, 'ダウンロードモジュール保存ディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MODULE_REALDIR', 'DATA_REALDIR . MODULE_DIR', 23, 'ダウンロードモジュール保存ディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MAX_LIFETIME', '7200', 26, 'DBセッションの有効期限(秒)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MASTER_DATA_REALDIR', 'DATA_REALDIR . "cache/"', 27, 'マスターデータキャッシュディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('UPDATE_HTTP', '"http://www.ec-cube.net/info/index.php"', 28, 'アップデート管理用ファイル格納場所');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CHAR_CODE', '"UTF-8"', 39, '文字コード');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOCALE', '"ja_JP.UTF-8"', 40, 'ロケール設定');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ECCUBE_PAYMENT', '"EC-CUBE"', 41, '決済モジュール付与文言');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PEAR_DB_DEBUG', '0', 42, 'PEAR::DBのデバッグモード');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PEAR_DB_PERSISTENT', 'false', 43, 'PEAR::DBの持続的接続オプション');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CLOSE_DAY', '31', 45, '締め日の指定(末日の場合は、31を指定してください。)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FAVORITE_ERROR', '13', 46, '一般サイトエラー');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('GRAPH_REALDIR', 'HTML_REALDIR . "upload/graph_image/"', 49, 'グラフ格納ディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('GRAPH_URLPATH', 'ROOT_URLPATH . "upload/graph_image/"', 50, 'グラフURL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('GRAPH_PIE_MAX', '10', 51, '円グラフ最大表示数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('GRAPH_LABEL_MAX', '40', 52, 'グラフのラベルの文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PRODUCTS_TOTAL_MAX', '15', 55, '商品集計で何位まで表示するか');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_PRODUCT_DISP', '2', 56, '1:公開 2:非公開');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIV_FREE_AMOUNT', '0', 57, '送料無料購入数量 (0の場合は、いくつ買っても無料にならない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('INPUT_DELIV_FEE', '1', 58, '配送料の設定画面表示(有効:1 無効:0)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_PRODUCT_DELIV_FEE', '0', 59, '商品ごとの送料設定(有効:1 無効:0)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_DELIV_FEE', '1', 60, '配送業者ごとの配送料を加算する(有効:1 無効:0)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_RECOMMEND', '1', 61, 'おすすめ商品登録(有効:1 無効:0)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_CLASS_REGIST', '1', 62, '商品規格登録(有効:1 無効:0)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_PASSWORD', '"******"', 66, '会員登録変更(マイページ)パスワード用');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIV_ADDR_MAX', '20', 67, '別のお届け先最大登録数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_STATUS_MAX', '50', 70, '対応状況管理画面の一覧表示件数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('REVIEW_REGIST_MAX', '5', 71, 'フロントレビュー書き込み最大数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEBUG_MODE', 'false', 72, 'デバッグモード(true:sfPrintRやDBのエラーメッセージ、ログレベルがDebugのログを出力する、false:出力しない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USE_VERBOSE_LOG', 'DEBUG_MODE', 73, 'ログを冗長とするか(true:利用する、false:利用しない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_ID', '"1"', 74, '管理ユーザID(メンテナンス用表示されない。)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CUSTOMER_CONFIRM_MAIL', 'false', 75, '会員登録時に仮会員確認メールを送信するか (true:仮会員、false:本会員)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOGIN_FRAME', '"login_frame.tpl"', 77, 'ログイン画面フレーム');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MAIN_FRAME', '"main_frame.tpl"', 78, '管理画面フレーム');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SITE_FRAME', '"site_frame.tpl"', 79, '一般サイト画面フレーム');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CERT_STRING', '"7WDhcBTF"', 80, '認証文字列');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('BIRTH_YEAR', '1901', 83, '生年月日登録開始年');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('RELEASE_YEAR', '2005', 84, '本システムの稼働開始年'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CREDIT_ADD_YEAR', '10', 85, 'クレジットカードの期限+何年');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('POINT_RULE', '2', 88, 'ポイントの計算ルール(1:四捨五入、2:切り捨て、3:切り上げ)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('POINT_VALUE', '1', 89, '1ポイント当たりの値段(円)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_MODE', '0', 90, '管理モード 1:有効 0:無効(納品時)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MAX_LOG_QUANTITY', '5', 92, 'ログファイル最大数(ログテーション)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MAX_LOG_SIZE', '"1000000"', 93, '1つのログファイルに保存する最大容量(byte)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TRANSACTION_ID_NAME', '"transactionid"', 94, 'トランザクションID の名前');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FORGOT_MAIL', '0', 95, 'パスワード忘れの確認メールを送付するか否か。(0:送信しない、1:送信する)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('BIRTH_MONTH_POINT', '0', 98, '誕生日月ポイント');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LARGE_IMAGE_WIDTH', '500', 110, '拡大画像横');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LARGE_IMAGE_HEIGHT', '500', 111, '拡大画像縦');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMALL_IMAGE_WIDTH', '130', 112, '一覧画像横');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMALL_IMAGE_HEIGHT', '130', 113, '一覧画像縦');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NORMAL_IMAGE_WIDTH', '260', 114, '通常画像横');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NORMAL_IMAGE_HEIGHT', '260', 115, '通常画像縦');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NORMAL_SUBIMAGE_WIDTH', '200', 116, '通常サブ画像横');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NORMAL_SUBIMAGE_HEIGHT', '200', 117, '通常サブ画像縦');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LARGE_SUBIMAGE_WIDTH', '500', 118, '拡大サブ画像横');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LARGE_SUBIMAGE_HEIGHT', '500', 119, '拡大サブ画像縦');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_SIZE', '1000', 126, '画像サイズ制限(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CSV_SIZE', '2000', 127, 'CSVサイズ制限(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CSV_LINE_MAX', '10000', 128, 'CSVアップロード1行あたりの最大文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FILE_SIZE', '10000', 130, 'ファイル管理画面アップ制限(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEMPLATE_SIZE', '10000', 131, 'アップできるテンプレートファイル制限(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LEVEL_MAX', '5', 132, 'カテゴリの最大階層');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CATEGORY_MAX', '1000', 133, '最大カテゴリ登録数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_TITLE', '"EC-CUBE 管理機能"', 134, '管理機能タイトル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SELECT_RGB', '"#ffffdf"', 135, '編集時強調表示色');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DISABLED_RGB', '"#C9C9C9"', 136, '入力項目無効時の表示色');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ERR_COLOR', '"#ffe8e8"', 137, 'エラー時表示色');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CATEGORY_HEAD', '">"', 138, '親カテゴリ表示文字');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('START_BIRTH_YEAR', '1970', 139, '生年月日初期選択年');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NORMAL_PRICE_TITLE', '"通常価格"', 140, '価格名称');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SALE_PRICE_TITLE', '"販売価格"', 141, '価格名称');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOG_REALFILE', 'DATA_REALDIR . "logs/site.log"', 142, '標準ログファイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CUSTOMER_LOG_REALFILE', 'DATA_REALDIR . "logs/customer.log"', 143, '会員ログイン ログファイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_LOG_REALFILE', 'DATA_REALDIR . "logs/admin.log"', 144, '管理機能ログファイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEBUG_LOG_REALFILE', '""', 145, 'デバッグログファイル(未入力:標準ログファイル・管理画面ログファイル)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ERROR_LOG_REALFILE', 'DATA_REALDIR . "logs/error.log"', 146, 'エラーログファイル(未入力:標準ログファイル・管理画面ログファイル)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DB_LOG_REALFILE', 'DATA_REALDIR . "logs/db.log"', 147, 'DBログファイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_image/"', 150, '画像一時保存');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_SAVE_REALDIR', 'HTML_REALDIR . "upload/save_image/"', 151, '画像保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_TEMP_URLPATH', 'ROOT_URLPATH . "upload/temp_image/"', 152, '画像一時保存URL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_SAVE_URLPATH', 'ROOT_URLPATH . "upload/save_image/"', 153, '画像保存先URL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_TEMP_RSS_URL', 'HTTP_URL . "upload/temp_image/"', 154, 'RSS用画像一時保存URL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_SAVE_RSS_URL', 'HTTP_URL . "upload/save_image/"', 155, 'RSS用画像保存先URL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CSV_TEMP_REALDIR', 'DATA_REALDIR . "upload/csv/"', 156, 'エンコードCSVの一時保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NO_IMAGE_REALFILE', 'USER_TEMPLATE_REALDIR . "default/img/picture/img_blank.gif"', 158, '画像がない場合に表示');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_SYSTEM_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "system/" . DIR_INDEX_PATH', 159, 'システム管理トップ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('INPUT_ZIP_URLPATH', 'ROOT_URLPATH . "input_zip.php"', 161, '郵便番号入力');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_HOME_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "home.php"', 165, 'ホーム');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_LOGIN_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . DIR_INDEX_PATH', 166, 'ログインページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_PRODUCTS_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "products/" . DIR_INDEX_PATH', 167, '商品検索ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_ORDER_EDIT_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/edit.php"', 168, '注文編集ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_ORDER_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/" . DIR_INDEX_PATH', 169, '注文編集ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_ORDER_MAIL_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "order/mail.php"', 170, '注文編集ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_LOGOUT_URLPATH', 'ROOT_URLPATH . ADMIN_DIR . "logout.php"', 171, 'ログアウトページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MEMBER_PMAX', '10', 182, 'メンバー管理ページ表示行数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SEARCH_PMAX', '10', 183, '検索ページ表示行数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NAVI_PMAX', '4', 184, 'ページ番号の最大表示数量');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PRODUCTSUB_MAX', '5', 185, '商品サブ情報最大数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIVTIME_MAX', '16', 186, 'お届け時間の最大表示数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIVFEE_MAX', '47', 187, '配送料金の最大表示数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('STEXT_LEN', '50', 188, '短い項目の文字数 (名前など)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMTEXT_LEN', '100', 189, NULL);
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MTEXT_LEN', '200', 190, '長い項目の文字数 (住所など)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MLTEXT_LEN', '1000', 191, '長中文の文字数 (問い合わせなど)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LTEXT_LEN', '3000', 192, '長文の文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LLTEXT_LEN', '99999', 193, '超長文の文字数 (メルマガなど)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('URL_LEN', '1024', 194, 'URLの文字長');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ID_MAX_LEN', 'STEXT_LEN', 195, '管理画面用:ID・パスワードの最大文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ID_MIN_LEN', '4', 196, '管理画面用:ID・パスワードの最小文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PRICE_LEN', '8', 197, '金額桁数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PERCENTAGE_LEN', '3', 198, '率桁数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('AMOUNT_LEN', '6', 199, '在庫数、販売制限数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ZIP01_LEN', '3', 200, '郵便番号1');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ZIP02_LEN', '4', 201, '郵便番号2');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEL_ITEM_LEN', '6', 202, '電話番号各項目制限');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEL_LEN', '12', 203, '電話番号総数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PASSWORD_MIN_LEN', '4', 204, 'フロント画面用:パスワードの最小文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PASSWORD_MAX_LEN', 'STEXT_LEN', 205, 'フロント画面用:パスワードの最大文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('INT_LEN', '9', 206, '検査数値用桁数(INT)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CREDIT_NO_LEN', '4', 207, 'クレジットカードの文字数 (*モジュールで使用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SEARCH_CATEGORY_LEN', '18', 208, '検索カテゴリ最大表示文字数(byte)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FILE_NAME_LEN', '10', 209, 'ファイル名表示文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('COOKIE_EXPIRE', '365', 212, 'クッキー保持期限(日)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SEPA_CATNAVI', '" > "', 235, 'カテゴリ区切り文字');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SHOPPING_URL', 'HTTPS_URL . "shopping/" . DIR_INDEX_PATH', 237, '会員情報入力');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ENTRY_URL', 'HTTPS_URL . "entry/" . DIR_INDEX_PATH', 238, '会員登録ページTOP');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TOP_URLPATH', 'ROOT_URLPATH . DIR_INDEX_PATH', 239, 'サイトトップ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CART_URLPATH', 'ROOT_URLPATH . "cart/" . DIR_INDEX_PATH', 240, 'カートトップ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIV_URLPATH', 'ROOT_URLPATH . "shopping/deliv.php"', 241, 'お届け先設定');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MULTIPLE_URLPATH', 'ROOT_URLPATH . "shopping/multiple.php"', 242, '複数お届け先設定');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SHOPPING_CONFIRM_URLPATH', 'ROOT_URLPATH . "shopping/confirm.php"', 244, '購入確認ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SHOPPING_PAYMENT_URLPATH', 'ROOT_URLPATH . "shopping/payment.php"', 245, 'お支払い方法選択ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SHOPPING_COMPLETE_URLPATH', 'ROOT_URLPATH . "shopping/complete.php"', 246, '購入完了画面');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SHOPPING_MODULE_URLPATH', 'ROOT_URLPATH . "shopping/load_payment_module.php"', 249, 'モジュール追加用画面');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('P_DETAIL_URLPATH', 'ROOT_URLPATH . "products/detail.php?product_id="', 253, '商品詳細(HTML出力)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_DELIVADDR_URLPATH', 'ROOT_URLPATH . "mypage/delivery.php"', 254, 'マイページお届け先URL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ADMIN_NEWS_STARTYEAR', '2005', 264, '新着情報管理画面 開始年(西暦) ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ENTRY_LIMIT_HOUR', '1', 267, '再入会制限時間 (単位: 時間)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('RECOMMEND_PRODUCT_MAX', '6', 268, '関連商品表示数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('RECOMMEND_NUM', '8', 269, 'おすすめ商品表示数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DELIV_DATE_END_MAX', '21', 272, 'お届け可能日以降のプルダウン表示最大日数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('CV_PAYMENT_LIMIT', '14', 275, '支払期限 (*モジュールで使用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('REVIEW_ALLOW_URL', '0', 277, '商品レビューでURL書き込みを許可するか否か');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('UPDATE_SEND_SITE_INFO', 'false', 289, 'アップデート時にサイト情報を送出するか');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USE_POINT', 'true', 290, 'ポイントを利用するか(true:利用する、false:利用しない) (false は一部対応)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('NOSTOCK_HIDDEN', 'false', 291, '在庫無し商品の非表示(true:非表示、false:表示)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USE_MOBILE', 'true', 292, 'モバイルサイトを利用するか(true:利用する、false:利用しない) (false は一部対応) (*モジュールで使用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USE_MULTIPLE_SHIPPING', 'true', 293, '複数配送先指定機能を利用するか(true:利用する、false:利用しない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SLTEXT_LEN', '500', 294, '短文の文字数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_TEMPLATE_NAME', '"default"', 300, 'デフォルトテンプレート名(PC)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_DEFAULT_TEMPLATE_NAME', '"mobile"', 301, 'デフォルトテンプレート名(モバイル)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTPHONE_DEFAULT_TEMPLATE_NAME', '"sphone"', 302, 'デフォルトテンプレート名(スマートフォン)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEMPLATE_NAME', '"default"', 303, 'テンプレート名');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_TEMPLATE_NAME', '"mobile"', 304, 'モバイルテンプレート名');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTPHONE_TEMPLATE_NAME', '"sphone"', 305, 'スマートフォンテンプレート名');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTY_TEMPLATES_REALDIR', ' DATA_REALDIR . "Smarty/templates/"', 306, 'SMARTYテンプレート');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . TEMPLATE_NAME . "/"', 307, 'SMARTYテンプレート(PC)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TEMPLATE_ADMIN_REALDIR', 'SMARTY_TEMPLATES_REALDIR . "admin/"', 308, 'SMARTYテンプレート(管理機能)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . TEMPLATE_NAME . "/"', 309, 'SMARTYコンパイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('COMPILE_ADMIN_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/admin/"', 310, 'SMARTYコンパイル(管理機能)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('BLOC_DIR', '"frontparts/bloc/"', 311, 'ブロックファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . MOBILE_TEMPLATE_NAME . "/"', 312, 'SMARTYテンプレート(mobile)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . MOBILE_TEMPLATE_NAME . "/"', 313, 'SMARTYコンパイル(mobile)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTPHONE_TEMPLATE_REALDIR', 'SMARTY_TEMPLATES_REALDIR . SMARTPHONE_TEMPLATE_NAME . "/"', 314, 'SMARTYテンプレート(smart phone)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTPHONE_COMPILE_REALDIR', 'DATA_REALDIR . "Smarty/templates_c/" . SMARTPHONE_TEMPLATE_NAME . "/"', 315, 'SMARTYコンパイル(smartphone)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('RFC_COMPLIANT_EMAIL_CHECK', 'false', 401, 'EメールアドレスチェックをRFC準拠にするか(true:準拠する、false:準拠しない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_SESSION_LIFETIME', '1800', 402, 'モバイルサイトのセッションの存続時間 (秒)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_IMAGE_REALDIR', 'HTML_REALDIR . "upload/mobile_image/"', 408, '携帯電話向け変換画像保存ディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_IMAGE_URLPATH', 'ROOT_URLPATH . "upload/mobile_image/"', 409, '携帯電話向け変換画像保存ディレクトリ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_TOP_URLPATH', 'ROOT_URLPATH . DIR_INDEX_PATH', 410, 'モバイルURL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_CART_URLPATH', 'ROOT_URLPATH . "cart/" . DIR_INDEX_PATH', 411, 'カートトップ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_SHOPPING_CONFIRM_URLPATH', 'ROOT_URLPATH . "shopping/confirm.php"', 413, '購入確認ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_SHOPPING_PAYMENT_URLPATH', 'ROOT_URLPATH . "shopping/payment.php"', 414, 'お支払い方法選択ページ');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_P_DETAIL_URLPATH', 'ROOT_URLPATH . "products/detail.php?product_id="', 415, '商品詳細(HTML出力)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_SHOPPING_COMPLETE_URLPATH', 'ROOT_URLPATH . "shopping/complete.php"', 416, '購入完了画面 (*モジュールで使用)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SESSION_KEEP_METHOD', '"useCookie"', 418, 'セッション維持方法:"useCookie"|"useRequest"');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SESSION_LIFETIME', '1800', 419, 'セッションの存続時間 (秒)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OSTORE_URL', '"http://www.ec-cube.net/"', 500, 'オーナーズストアURL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OSTORE_SSLURL', '"https://www.ec-cube.net/"', 501, 'オーナーズストアURL');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OSTORE_LOG_REALFILE', 'DATA_REALDIR . "logs/ownersstore.log"', 502, 'オーナーズストアログパス');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_FAVORITE_PRODUCT', '1', 523, 'お気に入り商品登録(有効:1 無効:0)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('IMAGE_RENAME', 'true', 525, '画像リネーム設定 (商品画像のみ) (true:リネームする、false:リネームしない)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_DIR', '"plugins/"', 600, '(2.11用)プラグインディレクトリ(モジュールで使用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_REALDIR', 'USER_REALDIR . PLUGIN_DIR', 601, '(2.11用)プラグイン保存先(モジュールで使用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_UPLOAD_REALDIR', 'DATA_REALDIR . "downloads/plugin/"', 604, 'プラグイン保存先ディレクトリ'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_HTML_REALDIR', 'HTML_REALDIR . "plugin/"', 605, 'プラグイン保存先ディレクトリ(html)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_plugin/"', 608, 'プラグインファイル一時保存先'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_EXTENSION', '"tar,tar.gz"', 611, 'プラグインファイル登録可能拡張子(カンマ区切り)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOADS_TEMP_PLUGIN_UPDATE_DIR', 'DATA_REALDIR . "downloads/tmp/plugin_update/"', 612, 'プラグイン一時展開用ディレクトリ(アップデート用)'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOADS_TEMP_PLUGIN_INSTALL_DIR', 'DATA_REALDIR . "downloads/tmp/plugin_install/"', 613, 'プラグイン一時展開用ディレクトリ(インストール用)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_HTML_URLPATH', 'ROOT_URLPATH . "plugin/"', 614, 'プラグインURL'); 
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOAD_DAYS_LEN', '3', 700, '日数桁数');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOAD_EXTENSION', '"zip,lzh,jpg,jpeg,gif,png,mp3,pdf,csv"', 701, 'ダウンロードファイル登録可能拡張子(カンマ区切り)"');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWN_SIZE', '50000', 702, 'ダウンロード販売ファイル用サイズ制限(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_PRODUCT_DOWN', '1', 703, '1:実商品 2:ダウンロード');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWN_TEMP_REALDIR', 'DATA_REALDIR . "download/temp/"', 704, 'ダウンロードファイル一時保存');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWN_SAVE_REALDIR', 'DATA_REALDIR . "download/save/"', 705, 'ダウンロードファイル保存先');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOAD_BLOCK', '1024', 708, 'ダウンロード販売機能 ダウンロードファイル読み込みバイト(KB)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_NEW', '1', 800, '新規注文');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_PAY_WAIT', '2', 801, '入金待ち');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_PRE_END', '6', 802, '入金済み');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_CANCEL', '3', 803, 'キャンセル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_BACK_ORDER', '4', 804, '取り寄せ中');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_DELIV', '5', 805, '発送済み');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ORDER_PENDING', '7', 806, '決済処理中');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PRODUCT_TYPE_NORMAL', '1', 900, '通常商品');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PRODUCT_TYPE_DOWNLOAD', '2', 901, 'ダウンロード商品');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SQL_QUERY_LOG_MODE', '1', 1000, 'DBログの記録モード (0:記録しない, 1:遅延時のみ記録する, 2:常に記録する)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SQL_QUERY_LOG_MIN_EXEC_TIME', '2', 1001, 'DBログで遅延とみなす実行時間(秒)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PAGE_DISPLAY_TIME_LOG_MODE', '1', 1002, 'ページ表示時間のログを取得するフラグ(1:表示, 0:非表示)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PAGE_DISPLAY_TIME_LOG_MIN_EXEC_TIME', '2', 1003, 'ページ表示時間のログを取得する時間設定(設定値以上かかった場合に取得)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEVICE_TYPE_MOBILE', '1', 1100, '端末種別: モバイル');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEVICE_TYPE_SMARTPHONE', '2', 1101, '端末種別: スマートフォン');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEVICE_TYPE_PC', '10', 1102, '端末種別: PC');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEVICE_TYPE_ADMIN', '99', 1103, '端末種別: 管理画面');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ECCUBE_INFO', 'true', 1218, 'EC-CUBE更新情報取得 (true:取得する false:取得しない)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('HTTP_REQUEST_TIMEOUT', '"5"', 1219, '外部サイトHTTP取得タイムアウト時間(秒)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ZIP_DOWNLOAD_URL', '"http://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip"', 1224, '郵便番号CSVのZIPアーカイブファイルの取得元');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('HOOK_POINT_PREPROCESS', '"LC_Page_preProcess"', 1301, 'フックポイント(プレプロセス)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('HOOK_POINT_PROCESS', '"LC_Page_process"', 1302, 'フックポイント(プロセス)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_ACTIVATE_FLAG', 'true', 1303, 'プラグインのロード可否フラグ)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTY_FORCE_COMPILE_MODE', 'false', 1401, 'SMARTYコンパイルモード');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('LOGIN_RETRY_INTERVAL', '0', 1411, 'ログイン失敗時の遅延時間(秒)(ブルートフォースアタック対策)');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_ORDER_STATUS_DISP_FLAG', 'true', 1412, 'MYページ:ご注文状況表示フラグ');

DELETE FROM mtb_allowed_tag
WHERE name LIKE '/%'
;

管理機能

  • 「システム設定>パラメータ設定」画面にて、[この内容で登録する]ボタンを押下。

キャッシュ削除

data/cache/mtb_*.serial を削除。

ファイル

差分で対応するのは非現実的。2.12.1 のソースをベースにカスタマイズを再適用するのが妥当。

削除:
  data/Smarty/templates/admin/ownersstore/index.tpl
  data/Smarty/templates/admin/plugin/
  data/Smarty/templates/admin/plugin/index.tpl
  data/Smarty/templates/admin/plugin/install.tpl
  data/Smarty/templates/admin/plugin/subnavi.tpl
  data/Smarty/templates/admin/plugin/uninstall.tpl
  data/Smarty/templates/admin/system/plugin.tpl
  data/Smarty/templates/default/frontparts/bloc/footer_bottom.tpl
  data/Smarty/templates/default/frontparts/bloc/footer_top.tpl
  data/Smarty/templates/default/frontparts/bloc/head.tpl
  data/Smarty/templates/default/frontparts/bloc/header_bottom.tpl
  data/Smarty/templates/default/frontparts/bloc/header_inner.tpl
  data/Smarty/templates/default/frontparts/bloc/header_top.tpl
  data/Smarty/templates/default/frontparts/bloc/left.tpl
  data/Smarty/templates/default/frontparts/bloc/main_bottom.tpl
  data/Smarty/templates/default/frontparts/bloc/main_top.tpl
  data/Smarty/templates/default/frontparts/bloc/right.tpl
  data/Smarty/templates/mobile/mail_templates/customer_mail.tpl
  data/Smarty/templates/mobile/mail_templates/customer_regist_mail.tpl
  data/Smarty/templates/mobile/mail_templates/mailmagazine_cancel.tpl
  data/Smarty/templates/mobile/mail_templates/mailmagazine_regist.tpl
  data/Smarty/templates/sphone/mypage/error.tpl
  data/Smarty/templates/sphone/mypage/mail_view.tpl
  data/class/SC_Plugin.php
  data/class/SC_UserView.php
  data/class/batch/SC_Batch.php
  data/class/graph/SC_GraphBar.php
  data/class/graph/SC_GraphBase.php
  data/class/graph/SC_GraphLine.php
  data/class/graph/SC_GraphPie.php
  data/class/module/
  data/class/module/SC_Module.php
  data/class/module/SC_Module_Payment.php
  data/class/pages/admin/plugin/
  data/class/pages/admin/plugin/LC_Page_Admin_Plugin.php
  data/class/pages/admin/plugin/LC_Page_Admin_Plugin_Install.php
  data/class/pages/admin/plugin/LC_Page_Admin_Plugin_Uninstall.php
  data/class/pages/admin/system/LC_Page_Admin_System_Plugin.php
  data/class/session/
  data/class/session/SC_SessionFactory.php
  data/class/session/sessionfactory/
  data/class/session/sessionfactory/SC_SessionFactory_UseCookie.php
  data/class/session/sessionfactory/SC_SessionFactory_UseRequest.php
  data/class_extends/SC_Plugin_Ex.php
  data/class_extends/SC_UserView_Ex.php
  data/class_extends/page_extends/admin/plugin/
  data/class_extends/page_extends/admin/plugin/LC_Page_Admin_Plugin_Ex.php
  data/class_extends/page_extends/admin/plugin/LC_Page_Admin_Plugin_Install_Ex.php
  data/class_extends/page_extends/admin/plugin/LC_Page_Admin_Plugin_Uninstall_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Plugin_Ex.php
  data/module/SOAP/example/
  data/module/SOAP/example/attachment.php
  data/module/SOAP/example/client.php
  data/module/SOAP/example/com_client.php
  data/module/SOAP/example/disco_server.php
  data/module/SOAP/example/email_client.php
  data/module/SOAP/example/email_gateway.php
  data/module/SOAP/example/email_pop_gateway.php
  data/module/SOAP/example/email_pop_server.php
  data/module/SOAP/example/email_server.php
  data/module/SOAP/example/example_server.php
  data/module/SOAP/example/example_types.php
  data/module/SOAP/example/server.php
  data/module/SOAP/example/server2.php
  data/module/SOAP/example/smtp.php
  data/module/SOAP/example/stockquote.php
  data/module/SOAP/example/tcp_client.php
  data/module/SOAP/example/tcp_daemon.pl
  data/module/SOAP/example/tcp_server.php
  data/module/SOAP/example/wsdl_client.php
  data/module/SOAP/package.xml
  data/module/SOAP/tools/
  data/module/SOAP/tools/genproxy.php
  data/plugin/
  data/require_classes.php
  data/require_safe.php
  html/admin/plugin/
  html/admin/plugin/index.php
  html/admin/plugin/install.php
  html/admin/plugin/uninstall.php
  html/admin/system/plugin.php
  html/handle_error.php
  html/install/batch/
  html/install/batch/move_mailmaga_data.php
  html/user_data/packages/sphone/css/images/
  html/user_data/packages/sphone/css/images/ajax-loader.png
  html/user_data/packages/sphone/css/images/form-check-off.png
  html/user_data/packages/sphone/css/images/form-check-on.png
  html/user_data/packages/sphone/css/images/form-radio-off.png
  html/user_data/packages/sphone/css/images/form-radio-on.png
  html/user_data/packages/sphone/css/images/icon-search-black.png
  html/user_data/packages/sphone/css/images/icon_delete.png
  html/user_data/packages/sphone/css/images/icons-18-black.png
  html/user_data/packages/sphone/css/images/icons-18-white.png
  html/user_data/packages/sphone/css/images/icons-36-black.png
  html/user_data/packages/sphone/css/images/icons-36-white.png
  html/user_data/packages/sphone/css/jquery.mobile-1.0a3.css
  html/user_data/packages/sphone/css/set.css
  html/user_data/packages/sphone/js/images/
  html/user_data/packages/sphone/js/images/ajax-loader.png
  html/user_data/packages/sphone/js/images/form-check-off.png
  html/user_data/packages/sphone/js/images/form-check-on.png
  html/user_data/packages/sphone/js/images/form-radio-off.png
  html/user_data/packages/sphone/js/images/form-radio-on.png
  html/user_data/packages/sphone/js/images/icon-search-black.png
  html/user_data/packages/sphone/js/images/icons-18-black.png
  html/user_data/packages/sphone/js/images/icons-18-white.png
  html/user_data/packages/sphone/js/images/icons-36-black.png
  html/user_data/packages/sphone/js/images/icons-36-white.png
  html/user_data/packages/sphone/js/jquery-1.5.2.min.js
  html/user_data/packages/sphone/js/jquery.mobile-1.0a3.min.js
  html/user_data/plugins/
  html/user_data/plugins/google_analytics/
  html/user_data/plugins/google_analytics/admin/
  html/user_data/plugins/google_analytics/admin/index.php
  html/user_data/plugins/google_analytics/classes/
  html/user_data/plugins/google_analytics/classes/pages/
  html/user_data/plugins/google_analytics/classes/pages/LC_Page_Admin_GoogleAnalytics.php
  html/user_data/plugins/google_analytics/classes/pages/LC_Page_FrontParts_Bloc_GoogleAnalytics.php
  html/user_data/plugins/google_analytics/classes/pages/ga_config.php
  html/user_data/plugins/google_analytics/ga.php
  html/user_data/plugins/google_analytics/plugin_info.php
  html/user_data/plugins/google_analytics/require.php
  html/user_data/plugins/google_analytics/sql/
  html/user_data/plugins/google_analytics/sql/install.sql
  html/user_data/plugins/google_analytics/sql/uninstall.sql
  html/user_data/plugins/google_analytics/tpl/
  html/user_data/plugins/google_analytics/tpl/admin/
  html/user_data/plugins/google_analytics/tpl/admin/index.tpl
  html/user_data/plugins/google_analytics/tpl/ga.tpl
  html/user_data/plugins/plugins.xml
  html/user_data/plugins/recommend/
  html/user_data/plugins/recommend/admin/
  html/user_data/plugins/recommend/admin/index.php
  html/user_data/plugins/recommend/bloc.php
  html/user_data/plugins/recommend/classes/
  html/user_data/plugins/recommend/classes/LC_Page_Admin_Plugin_Recommend.php
  html/user_data/plugins/recommend/classes/LC_Page_FrontParts_Bloc_Recommend.php
  html/user_data/plugins/recommend/img/
  html/user_data/plugins/recommend/img/title_recommend.png
  html/user_data/plugins/recommend/plugin_info.php
  html/user_data/plugins/recommend/require.php
  html/user_data/plugins/recommend/sql/
  html/user_data/plugins/recommend/sql/install.sql
  html/user_data/plugins/recommend/sql/uninstall.sql
  html/user_data/plugins/recommend/tpl/
  html/user_data/plugins/recommend/tpl/admin/
  html/user_data/plugins/recommend/tpl/admin/index.tpl
  html/user_data/plugins/recommend/tpl/bloc.tpl
追加:
  data/Smarty/templates/admin/ownersstore/module.tpl
  data/Smarty/templates/admin/ownersstore/plugin.tpl
  data/class/SC_Batch.php
  data/class/SC_ClassAutoloader.php
  data/class/SC_SessionFactory.php
  data/class/api/
  data/class/api/SC_Api_Abstract.php
  data/class/api/SC_Api_Operation.php
  data/class/api/SC_Api_Utils.php
  data/class/api/operations/
  data/class/api/operations/AddrFromZip.php
  data/class/api/operations/BrowseNodeLookup.php
  data/class/api/operations/CartAdd.php
  data/class/api/operations/CartClear.php
  data/class/api/operations/CartCreate.php
  data/class/api/operations/CartGet.php
  data/class/api/operations/CartModify.php
  data/class/api/operations/Default.php
  data/class/api/operations/GetVersion.php
  data/class/api/operations/ItemLookup.php
  data/class/api/operations/ItemSearch.php
  data/class/graph/SC_Graph_Bar.php
  data/class/graph/SC_Graph_Base.php
  data/class/graph/SC_Graph_Line.php
  data/class/graph/SC_Graph_Pie.php
  data/class/helper/SC_Helper_FPDI.php
  data/class/helper/SC_Helper_HandleError.php
  data/class/helper/SC_Helper_Transform.php
  data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Module.php
  data/class/pages/api/
  data/class/pages/api/LC_Page_Api.php
  data/class/pages/api/LC_Page_Api_Json.php
  data/class/pages/api/LC_Page_Api_Php.php
  data/class/pages/api/LC_Page_Api_Xml.php
  data/class/plugin/
  data/class/plugin/SC_Plugin_Base.php
  data/class/plugin/SC_Plugin_Util.php
  data/class/sessionfactory/
  data/class/sessionfactory/SC_SessionFactory_UseCookie.php
  data/class/sessionfactory/SC_SessionFactory_UseRequest.php
  data/class_extends/SC_Batch_Ex.php
  data/class_extends/SC_ClassAutoloader_Ex.php
  data/class_extends/SC_Fpdf_Ex.php
  data/class_extends/SC_SessionFactory_Ex.php
  data/class_extends/api_extends/
  data/class_extends/api_extends/SC_Api_Abstract_Ex.php
  data/class_extends/api_extends/SC_Api_Operation_Ex.php
  data/class_extends/api_extends/SC_Api_Utils_Ex.php
  data/class_extends/api_extends/operations/
  data/class_extends/api_extends/operations/AddrFromZip.php
  data/class_extends/api_extends/operations/BrowseNodeLookup.php
  data/class_extends/api_extends/operations/CartAdd_Ex.php
  data/class_extends/api_extends/operations/CartClear.php
  data/class_extends/api_extends/operations/CartCreate.php
  data/class_extends/api_extends/operations/CartGet.php
  data/class_extends/api_extends/operations/CartModify.php
  data/class_extends/api_extends/operations/Default_Ex.php
  data/class_extends/api_extends/operations/GetVersion_Ex.php
  data/class_extends/api_extends/operations/ItemLookup.php
  data/class_extends/api_extends/operations/ItemSearch.php
  data/class_extends/batch_extends/
  data/class_extends/batch_extends/SC_Batch_Update_Ex.php
  data/class_extends/graph_extends/
  data/class_extends/graph_extends/SC_Graph_Bar_Ex.php
  data/class_extends/graph_extends/SC_Graph_Base_Ex.php
  data/class_extends/graph_extends/SC_Graph_Line_Ex.php
  data/class_extends/graph_extends/SC_Graph_Pie_Ex.php
  data/class_extends/helper_extends/SC_Helper_FPDI_Ex.php
  data/class_extends/helper_extends/SC_Helper_HandleError_Ex.php
  data/class_extends/helper_extends/SC_Helper_Transform_Ex.php
  data/class_extends/page_extends/admin/ownersstore/LC_Page_Admin_OwnersStore_Module_Ex.php
  data/class_extends/page_extends/api/
  data/class_extends/page_extends/api/LC_Page_Api_Ex.php
  data/class_extends/page_extends/api/LC_Page_Api_Json_Ex.php
  data/class_extends/page_extends/api/LC_Page_Api_Php_Ex.php
  data/class_extends/page_extends/api/LC_Page_Api_Xml_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_DownLoad_Ex.php
  data/class_extends/plugin_extends/
  data/class_extends/plugin_extends/SC_Plugin_Util_Ex.php
  data/class_extends/sessionfactory_extends/
  data/class_extends/sessionfactory_extends/SC_SessionFactory_UseCookie_Ex.php
  data/class_extends/sessionfactory_extends/SC_SessionFactory_UseRequest_Ex.php
  data/downloads/api/
  data/downloads/plugin/
  data/downloads/tmp/plugin_install/
  data/downloads/tmp/plugin_update/
  data/module/Archive/
  data/module/Archive/Tar.php
  data/module/PEAR5.php
  data/module/SOAP/Server/TCP/
  data/module/SOAP/Server/TCP/Handler.php
  data/module/SOAP/Transport/TEST.php
  data/module/XML/
  data/module/XML/Parser/
  data/module/XML/Parser.php
  data/module/XML/Parser/Simple.php
  data/module/XML/Serializer.php
  data/module/XML/Unserializer.php
  data/module/XML/Util.php
  html/admin/load_plugin_config.php
  html/admin/ownersstore/module.php
  html/api/
  html/api/index.php
  html/api/json.php
  html/api/php.php
  html/api/xml.php
  html/plugin/
  html/upload/temp_plugin/
  html/user_data/packages/admin/css/reset.css
  html/user_data/packages/admin/img/common/favicon.ico
  html/user_data/packages/default/img/common/favicon.ico
  html/user_data/packages/sphone/css/reset.css
  html/user_data/packages/sphone/img/common/favicon.ico
  html/user_data/packages/sphone/js/jquery-1.6.4.min.js
  html/user_data/packages/sphone/js/jquery.mobile/
  html/user_data/packages/sphone/js/jquery.mobile/images/
  html/user_data/packages/sphone/js/jquery.mobile/images/ajax-loader.png
  html/user_data/packages/sphone/js/jquery.mobile/images/icons-18-black.png
  html/user_data/packages/sphone/js/jquery.mobile/images/icons-18-white.png
  html/user_data/packages/sphone/js/jquery.mobile/images/icons-36-black.png
  html/user_data/packages/sphone/js/jquery.mobile/images/icons-36-white.png
  html/user_data/packages/sphone/js/jquery.mobile/jquery.mobile-1.0.1.min.css
  html/user_data/packages/sphone/js/jquery.mobile/jquery.mobile-1.0.1.min.js
  test/api_test.php
  test/createEcCubeCustomerData-v25.php
変更:
  data/Smarty/templates/admin/admin_popup_footer.tpl
  data/Smarty/templates/admin/admin_popup_header.tpl
  data/Smarty/templates/admin/adminparts/form_customer_search.tpl
  data/Smarty/templates/admin/basis/delivery.tpl
  data/Smarty/templates/admin/basis/delivery_input.tpl
  data/Smarty/templates/admin/basis/holiday.tpl
  data/Smarty/templates/admin/basis/index.tpl
  data/Smarty/templates/admin/basis/kiyaku.tpl
  data/Smarty/templates/admin/basis/mail.tpl
  data/Smarty/templates/admin/basis/payment.tpl
  data/Smarty/templates/admin/basis/payment_input.tpl
  data/Smarty/templates/admin/basis/point.tpl
  data/Smarty/templates/admin/basis/seo.tpl
  data/Smarty/templates/admin/basis/subnavi.tpl
  data/Smarty/templates/admin/basis/tradelaw.tpl
  data/Smarty/templates/admin/basis/zip_install.tpl
  data/Smarty/templates/admin/contents/csv.tpl
  data/Smarty/templates/admin/contents/csv_sql.tpl
  data/Smarty/templates/admin/contents/csv_sql_view.tpl
  data/Smarty/templates/admin/contents/file_manager.tpl
  data/Smarty/templates/admin/contents/index.tpl
  data/Smarty/templates/admin/contents/recommend.tpl
  data/Smarty/templates/admin/contents/recommend_search.tpl
  data/Smarty/templates/admin/contents/subnavi.tpl
  data/Smarty/templates/admin/css/contents.tpl
  data/Smarty/templates/admin/customer/edit.tpl
  data/Smarty/templates/admin/customer/edit_complete.tpl
  data/Smarty/templates/admin/customer/edit_confirm.tpl
  data/Smarty/templates/admin/customer/index.tpl
  data/Smarty/templates/admin/customer/search_customer.tpl
  data/Smarty/templates/admin/customer/subnavi.tpl
  data/Smarty/templates/admin/design/bloc.tpl
  data/Smarty/templates/admin/design/css.tpl
  data/Smarty/templates/admin/design/header.tpl
  data/Smarty/templates/admin/design/main_edit.tpl
  data/Smarty/templates/admin/design/subnavi.tpl
  data/Smarty/templates/admin/design/template.tpl
  data/Smarty/templates/admin/design/up_down.tpl
  data/Smarty/templates/admin/home.tpl
  data/Smarty/templates/admin/login.tpl
  data/Smarty/templates/admin/login_error.tpl
  data/Smarty/templates/admin/login_frame.tpl
  data/Smarty/templates/admin/mail/history.tpl
  data/Smarty/templates/admin/mail/index.tpl
  data/Smarty/templates/admin/mail/input.tpl
  data/Smarty/templates/admin/mail/input_confirm.tpl
  data/Smarty/templates/admin/mail/preview.tpl
  data/Smarty/templates/admin/mail/query.tpl
  data/Smarty/templates/admin/mail/subnavi.tpl
  data/Smarty/templates/admin/mail/template.tpl
  data/Smarty/templates/admin/mail/template_complete.tpl
  data/Smarty/templates/admin/mail/template_input.tpl
  data/Smarty/templates/admin/main_frame.tpl
  data/Smarty/templates/admin/order/disp.tpl
  data/Smarty/templates/admin/order/edit.tpl
  data/Smarty/templates/admin/order/index.tpl
  data/Smarty/templates/admin/order/mail.tpl
  data/Smarty/templates/admin/order/mail_confirm.tpl
  data/Smarty/templates/admin/order/mail_view.tpl
  data/Smarty/templates/admin/order/multiple.tpl
  data/Smarty/templates/admin/order/pdf_input.tpl
  data/Smarty/templates/admin/order/product_select.tpl
  data/Smarty/templates/admin/order/status.tpl
  data/Smarty/templates/admin/order/subnavi.tpl
  data/Smarty/templates/admin/ownersstore/log.tpl
  data/Smarty/templates/admin/ownersstore/log_detail.tpl
  data/Smarty/templates/admin/ownersstore/products_list.tpl
  data/Smarty/templates/admin/ownersstore/settings.tpl
  data/Smarty/templates/admin/ownersstore/subnavi.tpl
  data/Smarty/templates/admin/products/category.tpl
  data/Smarty/templates/admin/products/class.tpl
  data/Smarty/templates/admin/products/classcategory.tpl
  data/Smarty/templates/admin/products/complete.tpl
  data/Smarty/templates/admin/products/confirm.tpl
  data/Smarty/templates/admin/products/index.tpl
  data/Smarty/templates/admin/products/maker.tpl
  data/Smarty/templates/admin/products/product.tpl
  data/Smarty/templates/admin/products/product_class.tpl
  data/Smarty/templates/admin/products/product_class_complete.tpl
  data/Smarty/templates/admin/products/product_class_confirm.tpl
  data/Smarty/templates/admin/products/product_rank.tpl
  data/Smarty/templates/admin/products/product_select.tpl
  data/Smarty/templates/admin/products/review.tpl
  data/Smarty/templates/admin/products/review_edit.tpl
  data/Smarty/templates/admin/products/subnavi.tpl
  data/Smarty/templates/admin/products/upload_csv.tpl
  data/Smarty/templates/admin/products/upload_csv_category.tpl
  data/Smarty/templates/admin/products/upload_csv_category_complete.tpl
  data/Smarty/templates/admin/products/upload_csv_complete.tpl
  data/Smarty/templates/admin/system/adminarea.tpl
  data/Smarty/templates/admin/system/bkup.tpl
  data/Smarty/templates/admin/system/editdb.tpl
  data/Smarty/templates/admin/system/index.tpl
  data/Smarty/templates/admin/system/input.tpl
  data/Smarty/templates/admin/system/log.tpl
  data/Smarty/templates/admin/system/masterdata.tpl
  data/Smarty/templates/admin/system/parameter.tpl
  data/Smarty/templates/admin/system/subnavi.tpl
  data/Smarty/templates/admin/system/system.tpl
  data/Smarty/templates/admin/total/index.tpl
  data/Smarty/templates/admin/total/page_age.tpl
  data/Smarty/templates/admin/total/page_job.tpl
  data/Smarty/templates/admin/total/page_member.tpl
  data/Smarty/templates/admin/total/page_products.tpl
  data/Smarty/templates/admin/total/page_term.tpl
  data/Smarty/templates/admin/total/subnavi.tpl
  data/Smarty/templates/admin/total/subtitle.tpl
  data/Smarty/templates/default/abouts/index.tpl
  data/Smarty/templates/default/cart/index.tpl
  data/Smarty/templates/default/contact/complete.tpl
  data/Smarty/templates/default/contact/confirm.tpl
  data/Smarty/templates/default/contact/index.tpl
  data/Smarty/templates/default/entry/complete.tpl
  data/Smarty/templates/default/entry/confirm.tpl
  data/Smarty/templates/default/entry/index.tpl
  data/Smarty/templates/default/entry/kiyaku.tpl
  data/Smarty/templates/default/error.tpl
  data/Smarty/templates/default/footer.tpl
  data/Smarty/templates/default/forgot/complete.tpl
  data/Smarty/templates/default/forgot/index.tpl
  data/Smarty/templates/default/forgot/secret.tpl
  data/Smarty/templates/default/frontparts/bloc/calendar.tpl
  data/Smarty/templates/default/frontparts/bloc/cart.tpl
  data/Smarty/templates/default/frontparts/bloc/category.tpl
  data/Smarty/templates/default/frontparts/bloc/guide.tpl
  data/Smarty/templates/default/frontparts/bloc/login.tpl
  data/Smarty/templates/default/frontparts/bloc/login_header.tpl
  data/Smarty/templates/default/frontparts/bloc/news.tpl
  data/Smarty/templates/default/frontparts/bloc/recommend.tpl
  data/Smarty/templates/default/frontparts/bloc/search_products.tpl
  data/Smarty/templates/default/frontparts/form_personal_input.tpl
  data/Smarty/templates/default/frontparts/search_zero.tpl
  data/Smarty/templates/default/guide/privacy.tpl
  data/Smarty/templates/default/header.tpl
  data/Smarty/templates/default/index.tpl
  data/Smarty/templates/default/input_zip.tpl
  data/Smarty/templates/default/mail_templates/contact_mail.tpl
  data/Smarty/templates/default/mail_templates/customer_mail.tpl
  data/Smarty/templates/default/mail_templates/customer_regist_mail.tpl
  data/Smarty/templates/default/mail_templates/forgot_mail.tpl
  data/Smarty/templates/default/mail_templates/mail_title.tpl
  data/Smarty/templates/default/mail_templates/order_mail.tpl
  data/Smarty/templates/default/mypage/change.tpl
  data/Smarty/templates/default/mypage/change_complete.tpl
  data/Smarty/templates/default/mypage/change_confirm.tpl
  data/Smarty/templates/default/mypage/delivery.tpl
  data/Smarty/templates/default/mypage/delivery_addr.tpl
  data/Smarty/templates/default/mypage/error.tpl
  data/Smarty/templates/default/mypage/favorite.tpl
  data/Smarty/templates/default/mypage/history.tpl
  data/Smarty/templates/default/mypage/index.tpl
  data/Smarty/templates/default/mypage/login.tpl
  data/Smarty/templates/default/mypage/navi.tpl
  data/Smarty/templates/default/mypage/refusal.tpl
  data/Smarty/templates/default/mypage/refusal_complete.tpl
  data/Smarty/templates/default/mypage/refusal_confirm.tpl
  data/Smarty/templates/default/order/index.tpl
  data/Smarty/templates/default/popup_footer.tpl
  data/Smarty/templates/default/popup_header.tpl
  data/Smarty/templates/default/products/detail.tpl
  data/Smarty/templates/default/products/list.tpl
  data/Smarty/templates/default/products/review.tpl
  data/Smarty/templates/default/products/review_complete.tpl
  data/Smarty/templates/default/products/review_confirm.tpl
  data/Smarty/templates/default/regist/complete.tpl
  data/Smarty/templates/default/rss/index.tpl
  data/Smarty/templates/default/rss/products.tpl
  data/Smarty/templates/default/shopping/complete.tpl
  data/Smarty/templates/default/shopping/confirm.tpl
  data/Smarty/templates/default/shopping/deliv.tpl
  data/Smarty/templates/default/shopping/index.tpl
  data/Smarty/templates/default/shopping/multiple.tpl
  data/Smarty/templates/default/shopping/nonmember_input.tpl
  data/Smarty/templates/default/shopping/payment.tpl
  data/Smarty/templates/default/site_frame.tpl
  data/Smarty/templates/default/site_main.tpl
  data/Smarty/templates/mobile/cart/index.tpl
  data/Smarty/templates/mobile/contact/index.tpl
  data/Smarty/templates/mobile/entry/complete.tpl
  data/Smarty/templates/mobile/entry/confirm.tpl
  data/Smarty/templates/mobile/entry/email_mobile.tpl
  data/Smarty/templates/mobile/entry/email_mobile_complete.tpl
  data/Smarty/templates/mobile/entry/index.tpl
  data/Smarty/templates/mobile/entry/kiyaku.tpl
  data/Smarty/templates/mobile/error.tpl
  data/Smarty/templates/mobile/footer.tpl
  data/Smarty/templates/mobile/forgot/complete.tpl
  data/Smarty/templates/mobile/forgot/index.tpl
  data/Smarty/templates/mobile/forgot/secret.tpl
  data/Smarty/templates/mobile/frontparts/bloc/category.tpl
  data/Smarty/templates/mobile/frontparts/bloc/news.tpl
  data/Smarty/templates/mobile/frontparts/bloc/recommend.tpl
  data/Smarty/templates/mobile/frontparts/bloc/site_logo.tpl
  data/Smarty/templates/mobile/guide/about.tpl
  data/Smarty/templates/mobile/guide/charge.tpl
  data/Smarty/templates/mobile/guide/index.tpl
  data/Smarty/templates/mobile/guide/kiyaku.tpl
  data/Smarty/templates/mobile/guide/privacy.tpl
  data/Smarty/templates/mobile/guide/usage.tpl
  data/Smarty/templates/mobile/header.tpl
  data/Smarty/templates/mobile/index.tpl
  data/Smarty/templates/mobile/mail_templates/mail_title.tpl
  data/Smarty/templates/mobile/mail_templates/order_mail.tpl
  data/Smarty/templates/mobile/mypage/change.tpl
  data/Smarty/templates/mobile/mypage/change_complete.tpl
  data/Smarty/templates/mobile/mypage/change_confirm.tpl
  data/Smarty/templates/mobile/mypage/delivery_addr.tpl
  data/Smarty/templates/mobile/mypage/history.tpl
  data/Smarty/templates/mobile/mypage/index.tpl
  data/Smarty/templates/mobile/mypage/login.tpl
  data/Smarty/templates/mobile/mypage/refusal.tpl
  data/Smarty/templates/mobile/mypage/refusal_complete.tpl
  data/Smarty/templates/mobile/order/index.tpl
  data/Smarty/templates/mobile/products/category_list.tpl
  data/Smarty/templates/mobile/products/detail.tpl
  data/Smarty/templates/mobile/products/list.tpl
  data/Smarty/templates/mobile/products/search.tpl
  data/Smarty/templates/mobile/products/select_find1.tpl
  data/Smarty/templates/mobile/products/select_find2.tpl
  data/Smarty/templates/mobile/products/select_item.tpl
  data/Smarty/templates/mobile/regist/complete.tpl
  data/Smarty/templates/mobile/regist/error.tpl
  data/Smarty/templates/mobile/shopping/complete.tpl
  data/Smarty/templates/mobile/shopping/confirm.tpl
  data/Smarty/templates/mobile/shopping/deliv.tpl
  data/Smarty/templates/mobile/shopping/index.tpl
  data/Smarty/templates/mobile/shopping/multiple.tpl
  data/Smarty/templates/mobile/shopping/payment.tpl
  data/Smarty/templates/mobile/shopping/select_deliv.tpl
  data/Smarty/templates/mobile/site_frame.tpl
  data/Smarty/templates/mobile/site_main.tpl
  data/Smarty/templates/mobile/unsupported/index.tpl
  data/Smarty/templates/sphone/abouts/index.tpl
  data/Smarty/templates/sphone/cart/index.tpl
  data/Smarty/templates/sphone/contact/complete.tpl
  data/Smarty/templates/sphone/contact/confirm.tpl
  data/Smarty/templates/sphone/contact/index.tpl
  data/Smarty/templates/sphone/entry/complete.tpl
  data/Smarty/templates/sphone/entry/confirm.tpl
  data/Smarty/templates/sphone/entry/index.tpl
  data/Smarty/templates/sphone/entry/kiyaku.tpl
  data/Smarty/templates/sphone/error.tpl
  data/Smarty/templates/sphone/footer.tpl
  data/Smarty/templates/sphone/forgot/complete.tpl
  data/Smarty/templates/sphone/forgot/index.tpl
  data/Smarty/templates/sphone/forgot/secret.tpl
  data/Smarty/templates/sphone/frontparts/bloc/category.tpl
  data/Smarty/templates/sphone/frontparts/bloc/login.tpl
  data/Smarty/templates/sphone/frontparts/bloc/login_footer.tpl
  data/Smarty/templates/sphone/frontparts/bloc/login_header.tpl
  data/Smarty/templates/sphone/frontparts/bloc/navi_footer.tpl
  data/Smarty/templates/sphone/frontparts/bloc/navi_header.tpl
  data/Smarty/templates/sphone/frontparts/bloc/news.tpl
  data/Smarty/templates/sphone/frontparts/bloc/recommend.tpl
  data/Smarty/templates/sphone/frontparts/form_personal_input.tpl
  data/Smarty/templates/sphone/frontparts/search_zero.tpl
  data/Smarty/templates/sphone/guide/privacy.tpl
  data/Smarty/templates/sphone/header.tpl
  data/Smarty/templates/sphone/index.tpl
  data/Smarty/templates/sphone/mypage/change.tpl
  data/Smarty/templates/sphone/mypage/change_complete.tpl
  data/Smarty/templates/sphone/mypage/change_confirm.tpl
  data/Smarty/templates/sphone/mypage/delivery.tpl
  data/Smarty/templates/sphone/mypage/delivery_addr.tpl
  data/Smarty/templates/sphone/mypage/favorite.tpl
  data/Smarty/templates/sphone/mypage/history.tpl
  data/Smarty/templates/sphone/mypage/index.tpl
  data/Smarty/templates/sphone/mypage/login.tpl
  data/Smarty/templates/sphone/mypage/navi.tpl
  data/Smarty/templates/sphone/mypage/refusal.tpl
  data/Smarty/templates/sphone/mypage/refusal_complete.tpl
  data/Smarty/templates/sphone/mypage/refusal_confirm.tpl
  data/Smarty/templates/sphone/order/index.tpl
  data/Smarty/templates/sphone/popup_footer.tpl
  data/Smarty/templates/sphone/popup_header.tpl
  data/Smarty/templates/sphone/products/detail.tpl
  data/Smarty/templates/sphone/products/list.tpl
  data/Smarty/templates/sphone/products/review.tpl
  data/Smarty/templates/sphone/products/review_complete.tpl
  data/Smarty/templates/sphone/products/review_confirm.tpl
  data/Smarty/templates/sphone/regist/complete.tpl
  data/Smarty/templates/sphone/shopping/complete.tpl
  data/Smarty/templates/sphone/shopping/confirm.tpl
  data/Smarty/templates/sphone/shopping/deliv.tpl
  data/Smarty/templates/sphone/shopping/index.tpl
  data/Smarty/templates/sphone/shopping/multiple.tpl
  data/Smarty/templates/sphone/shopping/nonmember_input.tpl
  data/Smarty/templates/sphone/shopping/payment.tpl
  data/Smarty/templates/sphone/site_frame.tpl
  data/Smarty/templates/sphone/site_main.tpl
  data/app_initial.php
  data/class/SC_AdminView.php
  data/class/SC_CartSession.php
  data/class/SC_CheckError.php
  data/class/SC_Cookie.php
  data/class/SC_Customer.php
  data/class/SC_CustomerList.php
  data/class/SC_Date.php
  data/class/SC_Display.php
  data/class/SC_FormParam.php
  data/class/SC_Fpdf.php
  data/class/SC_Image.php
  data/class/SC_Initial.php
  data/class/SC_InstallView.php
  data/class/SC_MobileEmoji.php
  data/class/SC_MobileImage.php
  data/class/SC_MobileUserAgent.php
  data/class/SC_MobileView.php
  data/class/SC_PageNavi.php
  data/class/SC_Product.php
  data/class/SC_Query.php
  data/class/SC_Response.php
  data/class/SC_SelectSql.php
  data/class/SC_SendMail.php
  data/class/SC_Session.php
  data/class/SC_SiteSession.php
  data/class/SC_SiteView.php
  data/class/SC_SmartphoneUserAgent.php
  data/class/SC_SmartphoneView.php
  data/class/SC_UploadFile.php
  data/class/SC_View.php
  data/class/batch/SC_Batch_Update.php
  data/class/db/SC_DB_DBFactory.php
  data/class/db/SC_DB_MasterData.php
  data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
  data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php
  data/class/helper/SC_Helper_CSV.php
  data/class/helper/SC_Helper_Customer.php
  data/class/helper/SC_Helper_DB.php
  data/class/helper/SC_Helper_FileManager.php
  data/class/helper/SC_Helper_Mail.php
  data/class/helper/SC_Helper_Mobile.php
  data/class/helper/SC_Helper_PageLayout.php
  data/class/helper/SC_Helper_Plugin.php
  data/class/helper/SC_Helper_Purchase.php
  data/class/helper/SC_Helper_Session.php
  data/class/pages/LC_Page.php
  data/class/pages/LC_Page_Index.php
  data/class/pages/LC_Page_InputZip.php
  data/class/pages/LC_Page_ResizeImage.php
  data/class/pages/LC_Page_Sitemap.php
  data/class/pages/abouts/LC_Page_Abouts.php
  data/class/pages/admin/LC_Page_Admin.php
  data/class/pages/admin/LC_Page_Admin_Home.php
  data/class/pages/admin/LC_Page_Admin_Index.php
  data/class/pages/admin/LC_Page_Admin_Logout.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_DeliveryInput.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_PaymentInput.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php
  data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_CSV.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_FileManager.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_FileView.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php
  data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
  data/class/pages/admin/customer/LC_Page_Admin_Customer.php
  data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php
  data/class/pages/admin/customer/LC_Page_Admin_Customer_SearchCustomer.php
  data/class/pages/admin/design/LC_Page_Admin_Design.php
  data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php
  data/class/pages/admin/design/LC_Page_Admin_Design_CSS.php
  data/class/pages/admin/design/LC_Page_Admin_Design_Header.php
  data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php
  data/class/pages/admin/design/LC_Page_Admin_Design_Template.php
  data/class/pages/admin/design/LC_Page_Admin_Design_UpDown.php
  data/class/pages/admin/mail/LC_Page_Admin_Mail.php
  data/class/pages/admin/mail/LC_Page_Admin_Mail_History.php
  data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php
  data/class/pages/admin/mail/LC_Page_Admin_Mail_Template.php
  data/class/pages/admin/mail/LC_Page_Admin_Mail_TemplateInput.php
  data/class/pages/admin/order/LC_Page_Admin_Order.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Disp.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Mail.php
  data/class/pages/admin/order/LC_Page_Admin_Order_MailView.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Multiple.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php
  data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php
  data/class/pages/admin/order/LC_Page_Admin_Order_Status.php
  data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore.php
  data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Log.php
  data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Settings.php
  data/class/pages/admin/products/LC_Page_Admin_Products.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Category.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Class.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ClassCategory.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Maker.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Product.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php
  data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
  data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php
  data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php
  data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php
  data/class/pages/admin/system/LC_Page_Admin_System.php
  data/class/pages/admin/system/LC_Page_Admin_System_AdminArea.php
  data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php
  data/class/pages/admin/system/LC_Page_Admin_System_Delete.php
  data/class/pages/admin/system/LC_Page_Admin_System_Editdb.php
  data/class/pages/admin/system/LC_Page_Admin_System_Input.php
  data/class/pages/admin/system/LC_Page_Admin_System_Log.php
  data/class/pages/admin/system/LC_Page_Admin_System_Masterdata.php
  data/class/pages/admin/system/LC_Page_Admin_System_Parameter.php
  data/class/pages/admin/system/LC_Page_Admin_System_Rank.php
  data/class/pages/admin/system/LC_Page_Admin_System_System.php
  data/class/pages/admin/total/LC_Page_Admin_Total.php
  data/class/pages/cart/LC_Page_Cart.php
  data/class/pages/contact/LC_Page_Contact.php
  data/class/pages/contact/LC_Page_Contact_Complete.php
  data/class/pages/entry/LC_Page_Entry.php
  data/class/pages/entry/LC_Page_Entry_Complete.php
  data/class/pages/entry/LC_Page_Entry_EmailMobile.php
  data/class/pages/entry/LC_Page_Entry_Kiyaku.php
  data/class/pages/error/LC_Page_Error.php
  data/class/pages/error/LC_Page_Error_DispError.php
  data/class/pages/error/LC_Page_Error_SystemError.php
  data/class/pages/forgot/LC_Page_Forgot.php
  data/class/pages/frontparts/LC_Page_FrontParts_LoginCheck.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Cart.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Login.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_LoginFooter.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_LoginHeader.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_NaviFooter.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_NaviHeader.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php
  data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_SearchProducts.php
  data/class/pages/guide/LC_Page_Guide.php
  data/class/pages/guide/LC_Page_Guide_About.php
  data/class/pages/guide/LC_Page_Guide_Charge.php
  data/class/pages/guide/LC_Page_Guide_Kiyaku.php
  data/class/pages/guide/LC_Page_Guide_Privacy.php
  data/class/pages/guide/LC_Page_Guide_Usage.php
  data/class/pages/mypage/LC_Page_AbstractMypage.php
  data/class/pages/mypage/LC_Page_Mypage.php
  data/class/pages/mypage/LC_Page_Mypage_Change.php
  data/class/pages/mypage/LC_Page_Mypage_ChangeComplete.php
  data/class/pages/mypage/LC_Page_Mypage_Delivery.php
  data/class/pages/mypage/LC_Page_Mypage_DeliveryAddr.php
  data/class/pages/mypage/LC_Page_Mypage_DownLoad.php
  data/class/pages/mypage/LC_Page_Mypage_Favorite.php
  data/class/pages/mypage/LC_Page_Mypage_History.php
  data/class/pages/mypage/LC_Page_Mypage_Login.php
  data/class/pages/mypage/LC_Page_Mypage_MailView.php
  data/class/pages/mypage/LC_Page_Mypage_Order.php
  data/class/pages/mypage/LC_Page_Mypage_Refusal.php
  data/class/pages/mypage/LC_Page_Mypage_RefusalComplete.php
  data/class/pages/order/LC_Page_Order.php
  data/class/pages/preview/LC_Page_Preview.php
  data/class/pages/products/LC_Page_Products_CategoryList.php
  data/class/pages/products/LC_Page_Products_Detail.php
  data/class/pages/products/LC_Page_Products_List.php
  data/class/pages/products/LC_Page_Products_Review.php
  data/class/pages/products/LC_Page_Products_ReviewComplete.php
  data/class/pages/products/LC_Page_Products_Search.php
  data/class/pages/regist/LC_Page_Regist.php
  data/class/pages/regist/LC_Page_Regist_Complete.php
  data/class/pages/rss/LC_Page_Rss.php
  data/class/pages/rss/LC_Page_Rss_Products.php
  data/class/pages/shopping/LC_Page_Shopping.php
  data/class/pages/shopping/LC_Page_Shopping_Complete.php
  data/class/pages/shopping/LC_Page_Shopping_Confirm.php
  data/class/pages/shopping/LC_Page_Shopping_Deliv.php
  data/class/pages/shopping/LC_Page_Shopping_LoadPaymentModule.php
  data/class/pages/shopping/LC_Page_Shopping_Multiple.php
  data/class/pages/shopping/LC_Page_Shopping_Payment.php
  data/class/pages/unsupported/LC_Page_Unsupported.php
  data/class/pages/upgrade/LC_Page_Upgrade_Base.php
  data/class/pages/upgrade/LC_Page_Upgrade_Download.php
  data/class/pages/upgrade/LC_Page_Upgrade_ProductsList.php
  data/class/pages/upgrade/LC_Page_Upgrade_SiteCheck.php
  data/class/pages/upgrade/helper/LC_Upgrade_Helper_Json.php
  data/class/pages/upgrade/helper/LC_Upgrade_Helper_Log.php
  data/class/util/GC_Utils.php
  data/class/util/SC_Utils.php
  data/class_extends/SC_AdminView_Ex.php
  data/class_extends/SC_CartSession_Ex.php
  data/class_extends/SC_CheckError_Ex.php
  data/class_extends/SC_Cookie_Ex.php
  data/class_extends/SC_CustomerList_Ex.php
  data/class_extends/SC_Customer_Ex.php
  data/class_extends/SC_Date_Ex.php
  data/class_extends/SC_FormParam_Ex.php
  data/class_extends/SC_Image_Ex.php
  data/class_extends/SC_Initial_Ex.php
  data/class_extends/SC_InstallView_Ex.php
  data/class_extends/SC_MobileEmoji_Ex.php
  data/class_extends/SC_MobileImage_Ex.php
  data/class_extends/SC_MobileUserAgent_Ex.php
  data/class_extends/SC_MobileView_Ex.php
  data/class_extends/SC_PageNavi_Ex.php
  data/class_extends/SC_Product_Ex.php
  data/class_extends/SC_Query_Ex.php
  data/class_extends/SC_SelectSql_Ex.php
  data/class_extends/SC_SendMail_Ex.php
  data/class_extends/SC_Session_Ex.php
  data/class_extends/SC_SiteSession_Ex.php
  data/class_extends/SC_SiteView_Ex.php
  data/class_extends/SC_SmartphoneUserAgent_Ex.php
  data/class_extends/SC_SmartphoneView_Ex.php
  data/class_extends/SC_UploadFile_Ex.php
  data/class_extends/SC_View_Ex.php
  data/class_extends/db_extends/SC_DB_DBFactory_Ex.php
  data/class_extends/db_extends/SC_DB_MasterData_Ex.php
  data/class_extends/db_extends/dbfactory/SC_DB_DBFactory_MYSQL_Ex.php
  data/class_extends/db_extends/dbfactory/SC_DB_DBFactory_PGSQL_Ex.php
  data/class_extends/helper_extends/SC_Helper_CSV_Ex.php
  data/class_extends/helper_extends/SC_Helper_Customer_Ex.php
  data/class_extends/helper_extends/SC_Helper_DB_Ex.php
  data/class_extends/helper_extends/SC_Helper_FileManager_Ex.php
  data/class_extends/helper_extends/SC_Helper_Mail_Ex.php
  data/class_extends/helper_extends/SC_Helper_Mobile_Ex.php
  data/class_extends/helper_extends/SC_Helper_PageLayout_Ex.php
  data/class_extends/helper_extends/SC_Helper_Plugin_Ex.php
  data/class_extends/helper_extends/SC_Helper_Purchase_Ex.php
  data/class_extends/helper_extends/SC_Helper_Session_Ex.php
  data/class_extends/page_extends/LC_Page_Ex.php
  data/class_extends/page_extends/LC_Page_Index_Ex.php
  data/class_extends/page_extends/LC_Page_InputZip_Ex.php
  data/class_extends/page_extends/LC_Page_Redirect_Ex.php
  data/class_extends/page_extends/LC_Page_ResizeImage_Ex.php
  data/class_extends/page_extends/LC_Page_Sitemap_Ex.php
  data/class_extends/page_extends/abouts/LC_Page_Abouts_Ex.php
  data/class_extends/page_extends/admin/LC_Page_Admin_Ex.php
  data/class_extends/page_extends/admin/LC_Page_Admin_Home_Ex.php
  data/class_extends/page_extends/admin/LC_Page_Admin_Index_Ex.php
  data/class_extends/page_extends/admin/LC_Page_Admin_Login_Ex.php
  data/class_extends/page_extends/admin/LC_Page_Admin_Logout_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_DeliveryInput_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Delivery_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Holiday_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Kiyaku_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Mail_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_PaymentInput_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Payment_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Point_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Seo_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_Tradelaw_Ex.php
  data/class_extends/page_extends/admin/basis/LC_Page_Admin_Basis_ZipInstall_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_CSV_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_CsvSql_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_FileManager_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_FileView_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_RecommendSearch_Ex.php
  data/class_extends/page_extends/admin/contents/LC_Page_Admin_Contents_Recommend_Ex.php
  data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Customer_Ex.php
  data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Edit_Ex.php
  data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_Ex.php
  data/class_extends/page_extends/admin/customer/LC_Page_Admin_Customer_SearchCustomer_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_Bloc_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_CSS_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_Header_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_MainEdit_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_Template_Ex.php
  data/class_extends/page_extends/admin/design/LC_Page_Admin_Design_UpDown_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_History_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_Preview_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_Sendmail_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_TemplateInput_Ex.php
  data/class_extends/page_extends/admin/mail/LC_Page_Admin_Mail_Template_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Disp_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Edit_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_MailView_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Mail_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Multiple_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Pdf_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_ProductSelect_Ex.php
  data/class_extends/page_extends/admin/order/LC_Page_Admin_Order_Status_Ex.php
  data/class_extends/page_extends/admin/ownersstore/LC_Page_Admin_OwnersStore_Ex.php
  data/class_extends/page_extends/admin/ownersstore/LC_Page_Admin_OwnersStore_Log_Ex.php
  data/class_extends/page_extends/admin/ownersstore/LC_Page_Admin_OwnersStore_Settings_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Category_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ClassCategory_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Class_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Maker_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductClass_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductRank_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductSelect_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Product_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ReviewEdit_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Review_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSVCategory_Ex.php
  data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSV_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_AdminArea_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Bkup_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Delete_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Editdb_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Input_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Log_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Masterdata_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Parameter_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_Rank_Ex.php
  data/class_extends/page_extends/admin/system/LC_Page_Admin_System_System_Ex.php
  data/class_extends/page_extends/admin/total/LC_Page_Admin_Total_Ex.php
  data/class_extends/page_extends/cart/LC_Page_Cart_Ex.php
  data/class_extends/page_extends/contact/LC_Page_Contact_Complete_Ex.php
  data/class_extends/page_extends/contact/LC_Page_Contact_Ex.php
  data/class_extends/page_extends/entry/LC_Page_Entry_Complete_Ex.php
  data/class_extends/page_extends/entry/LC_Page_Entry_EmailMobile_Ex.php
  data/class_extends/page_extends/entry/LC_Page_Entry_Ex.php
  data/class_extends/page_extends/entry/LC_Page_Entry_Kiyaku_Ex.php
  data/class_extends/page_extends/entry/LC_Page_Entry_New_Ex.php
  data/class_extends/page_extends/error/LC_Page_Error_DispError_Ex.php
  data/class_extends/page_extends/error/LC_Page_Error_Ex.php
  data/class_extends/page_extends/error/LC_Page_Error_SystemError_Ex.php
  data/class_extends/page_extends/forgot/LC_Page_Forgot_Ex.php
  data/class_extends/page_extends/frontparts/LC_Page_FrontParts_LoginCheck_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Cart_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Category_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_LoginFooter_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_LoginHeader_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Login_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_NaviFooter_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_NaviHeader_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_News_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend_Ex.php
  data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_SearchProducts_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_About_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Charge_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Kiyaku_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Order_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Privacy_Ex.php
  data/class_extends/page_extends/guide/LC_Page_Guide_Usage_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_AbstractMypage_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_ChangeComplete_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Change_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_DeliveryAddr_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Delivery_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Favorite_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_HistoryDetail_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_History_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Login_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_MailView_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Order_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_RefusalComplete_Ex.php
  data/class_extends/page_extends/mypage/LC_Page_Mypage_Refusal_Ex.php
  data/class_extends/page_extends/order/LC_Page_Order_Ex.php
  data/class_extends/page_extends/preview/LC_Page_Preview_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_CategoryList_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_Detail_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_List_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_ReviewComplete_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_Review_Ex.php
  data/class_extends/page_extends/products/LC_Page_Products_Search_Ex.php
  data/class_extends/page_extends/regist/LC_Page_Regist_Complete_Ex.php
  data/class_extends/page_extends/regist/LC_Page_Regist_Ex.php
  data/class_extends/page_extends/rss/LC_Page_Rss_Ex.php
  data/class_extends/page_extends/rss/LC_Page_Rss_Products_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Complete_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Confirm_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_DelivAddr_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Deliv_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_LoadPaymentModule_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Multiple_Ex.php
  data/class_extends/page_extends/shopping/LC_Page_Shopping_Payment_Ex.php
  data/class_extends/page_extends/unsupported/LC_Page_Unsupported_Ex.php
  data/class_extends/util_extends/GC_Utils_Ex.php
  data/class_extends/util_extends/SC_Utils_Ex.php
  data/downloads/KEN_ALL.CSV
  data/include/image_converter.inc
  data/include/mobile_emoji_map_docomo.inc
  data/include/mobile_emoji_map_ezweb.inc
  data/include/mobile_emoji_map_softbank.inc
  data/module/Net/UserAgent/Mobile.php
  data/module/PEAR.php
  data/module/Request.php
  data/module/SOAP/Base.php
  data/module/SOAP/Client.php
  data/module/SOAP/Disco.php
  data/module/SOAP/Fault.php
  data/module/SOAP/Parser.php
  data/module/SOAP/Server.php
  data/module/SOAP/Server/Email.php
  data/module/SOAP/Server/Email_Gateway.php
  data/module/SOAP/Server/TCP.php
  data/module/SOAP/Transport.php
  data/module/SOAP/Transport/HTTP.php
  data/module/SOAP/Transport/SMTP.php
  data/module/SOAP/Type/dateTime.php
  data/module/SOAP/Type/duration.php
  data/module/SOAP/Value.php
  data/module/SOAP/WSDL.php
  data/module/Tar.php
  data/module/fpdi/filters/FilterASCII85_FPDI.php
  data/module/fpdi/filters/FilterLZW_FPDI.php
  data/module/fpdi/fpdi.php
  data/module/fpdi/fpdi2tcpdf_bridge.php
  data/module/fpdi/fpdi_pdf_parser.php
  data/module/fpdi/japanese.php
  data/module/fpdi/pdf_context.php
  data/mtb_constants_init.php
  data/require_base.php
  data/require_compat.php
  data/require_plugin.php
  data/smarty_extends/block.marquee.php
  data/smarty_extends/function.from_to.php
  data/smarty_extends/function.html_checkboxes_ex.php
  data/smarty_extends/function.html_radios_ex.php
  data/smarty_extends/modifier.nl2br_html.php
  data/smarty_extends/modifier.numeric_emoji.php
  data/smarty_extends/modifier.script_escape.php
  html/abouts/index.php
  html/admin/basis/delivery.php
  html/admin/basis/delivery_input.php
  html/admin/basis/holiday.php
  html/admin/basis/index.php
  html/admin/basis/kiyaku.php
  html/admin/basis/mail.php
  html/admin/basis/payment.php
  html/admin/basis/payment_input.php
  html/admin/basis/point.php
  html/admin/basis/seo.php
  html/admin/basis/tradelaw.php
  html/admin/basis/zip_install.php
  html/admin/contents/csv.php
  html/admin/contents/csv_sql.php
  html/admin/contents/file_manager.php
  html/admin/contents/file_view.php
  html/admin/contents/index.php
  html/admin/contents/recommend.php
  html/admin/contents/recommend_search.php
  html/admin/css/common.css
  html/admin/css/install.css
  html/admin/customer/edit.php
  html/admin/customer/index.php
  html/admin/customer/search_customer.php
  html/admin/design/bloc.php
  html/admin/design/css.php
  html/admin/design/header.php
  html/admin/design/index.php
  html/admin/design/main_edit.php
  html/admin/design/template.php
  html/admin/design/up_down.php
  html/admin/home.php
  html/admin/index.php
  html/admin/load_module_config.php
  html/admin/logout.php
  html/admin/mail/history.php
  html/admin/mail/index.php
  html/admin/mail/preview.php
  html/admin/mail/template.php
  html/admin/mail/template_input.php
  html/admin/order/disp.php
  html/admin/order/edit.php
  html/admin/order/index.php
  html/admin/order/mail.php
  html/admin/order/mail_view.php
  html/admin/order/multiple.php
  html/admin/order/pdf.php
  html/admin/order/product_select.php
  html/admin/order/status.php
  html/admin/ownersstore/index.php
  html/admin/ownersstore/log.php
  html/admin/ownersstore/settings.php
  html/admin/products/category.php
  html/admin/products/class.php
  html/admin/products/classcategory.php
  html/admin/products/index.php
  html/admin/products/maker.php
  html/admin/products/product.php
  html/admin/products/product_class.php
  html/admin/products/product_rank.php
  html/admin/products/product_select.php
  html/admin/products/review.php
  html/admin/products/review_edit.php
  html/admin/products/upload_csv.php
  html/admin/products/upload_csv_category.php
  html/admin/require.php
  html/admin/system/adminarea.php
  html/admin/system/bkup.php
  html/admin/system/delete.php
  html/admin/system/editdb.php
  html/admin/system/index.php
  html/admin/system/input.php
  html/admin/system/log.php
  html/admin/system/masterdata.php
  html/admin/system/parameter.php
  html/admin/system/rank.php
  html/admin/system/system.php
  html/admin/total/index.php
  html/cart/index.php
  html/contact/complete.php
  html/contact/index.php
  html/define.php
  html/entry/complete.php
  html/entry/email_mobile.php
  html/entry/index.php
  html/entry/kiyaku.php
  html/error.php
  html/forgot/index.php
  html/frontparts/bloc/calendar.php
  html/frontparts/bloc/cart.php
  html/frontparts/bloc/category.php
  html/frontparts/bloc/login.php
  html/frontparts/bloc/login_footer.php
  html/frontparts/bloc/login_header.php
  html/frontparts/bloc/navi_footer.php
  html/frontparts/bloc/navi_header.php
  html/frontparts/bloc/news.php
  html/frontparts/bloc/recommend.php
  html/frontparts/bloc/search_products.php
  html/frontparts/login_check.php
  html/guide/about.php
  html/guide/charge.php
  html/guide/index.php
  html/guide/kiyaku.php
  html/guide/privacy.php
  html/guide/usage.php
  html/index.php
  html/input_zip.php
  html/install/css/admin_contents.css
  html/install/index.php
  html/install/sql/create_table_mysql.sql
  html/install/sql/create_table_pgsql.sql
  html/install/sql/drop_table.sql
  html/install/sql/insert_data.sql
  html/install/templates/agreement.tpl
  html/install/templates/complete.tpl
  html/install/templates/install_frame.tpl
  html/install/templates/step0.tpl
  html/install/templates/step0_1.tpl
  html/install/templates/step1.tpl
  html/install/templates/step2.tpl
  html/install/templates/step3.tpl
  html/install/templates/step4.tpl
  html/install/templates/welcome.tpl
  html/js/css.js
  html/js/jquery.facebox/facebox.js
  html/js/navi.js
  html/js/products.js
  html/js/site.js
  html/js/win_op.js
  html/mypage/change.php
  html/mypage/change_complete.php
  html/mypage/delivery.php
  html/mypage/delivery_addr.php
  html/mypage/download.php
  html/mypage/favorite.php
  html/mypage/history.php
  html/mypage/history_detail.php
  html/mypage/index.php
  html/mypage/login.php
  html/mypage/mail_view.php
  html/mypage/order.php
  html/mypage/refusal.php
  html/mypage/refusal_complete.php
  html/order/index.php
  html/preview/index.php
  html/products/category_list.php
  html/products/detail.php
  html/products/list.php
  html/products/review.php
  html/products/review_complete.php
  html/products/search.php
  html/regist/complete.php
  html/regist/index.php
  html/require.php
  html/resize_image.php
  html/rss/index.php
  html/rss/product.php
  html/shopping/complete.php
  html/shopping/confirm.php
  html/shopping/deliv.php
  html/shopping/index.php
  html/shopping/load_payment_module.php
  html/shopping/multiple.php
  html/shopping/payment.php
  html/sitemap.php
  html/unsupported/index.php
  html/upgrade/index.php
  html/user_data/packages/admin/css/admin_contents.css
  html/user_data/packages/admin/css/admin_file_manager.css
  html/user_data/packages/admin/css/thickbox.css
  html/user_data/packages/admin/js/admin.js
  html/user_data/packages/admin/js/breadcrumbs.js
  html/user_data/packages/admin/js/file_manager.js
  html/user_data/packages/admin/js/layout_design.js
  html/user_data/packages/admin/js/ownersstore.js.php
  html/user_data/packages/default/css/bloc.css
  html/user_data/packages/default/css/bloc_alpha.css
  html/user_data/packages/default/css/common.css
  html/user_data/packages/default/css/contents.css
  html/user_data/packages/default/css/popup.css
  html/user_data/packages/default/css/print.css
  html/user_data/packages/default/css/reset.css
  html/user_data/packages/default/css/table.css
  html/user_data/packages/sphone/css/block.css
  html/user_data/packages/sphone/css/button.css
  html/user_data/packages/sphone/css/common.css
  html/user_data/packages/sphone/css/contents.css
  html/user_data/packages/sphone/css/import.css
  html/user_data/packages/sphone/css/jqm.css
  html/user_data/packages/sphone/css/mypage.css
  html/user_data/packages/sphone/css/popup.css
  html/user_data/packages/sphone/css/products.css
  html/user_data/packages/sphone/js/config.js
  html/user_data/packages/sphone/js/favorite.js
  html/user_data/packages/sphone/js/jquery.autoResizeTextAreaQ-0.1.js
  html/user_data/packages/sphone/js/jquery.flickslide.js
  test/TestSuite.php
  test/class/SC_DbConn_Test.php
  test/class/SC_Query_Test.php
  test/class/db/DB_AllTests.php
  test/class/db/SC_DB_DBFactory_Test.php
  test/class/db/SC_DB_MasterData_Test.php
  test/class/helper/Helper_AllTests.php
  test/class/helper/SC_Helper_DB_Test.php
  test/class/helper/SC_Helper_Purchase_Test.php
  test/class/helper/SC_Helper_Session_Test.php
  test/class/page/LC_Page_Admin_Products_ProductClass_Test.php
  test/class/page/LC_Page_Test.php
  test/class/page/Page_AllTests.php
  test/class/page/shopping/LC_Page_Shopping_LoadPaymentModule_Test.php
  test/class/util/SC_Utils_Test.php
  test/class/util/Util_AllTests.php
  test/createEcCubeData-v25.php
  test/require.php
アップデート/2.12/2.11_2.12.txt · 最終更新: 2014/04/22 22:06 by seasoft
© 2008-2020 Seasoft.