2.12.6 から 2.13.0
SQL
CREATE TABLE dtb_tax_rule ( tax_rule_id INT NOT NULL, country_id INT NOT NULL DEFAULT 0, pref_id INT NOT NULL DEFAULT 0, product_id INT NOT NULL DEFAULT 0, product_class_id INT NOT NULL DEFAULT 0, calc_rule SMALLINT NOT NULL DEFAULT 1, tax_rate NUMERIC NOT NULL DEFAULT 5, tax_adjust NUMERIC NOT NULL DEFAULT 0, apply_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, member_id INT NOT NULL, del_flg SMALLINT NOT NULL DEFAULT 0, create_date TIMESTAMP NOT NULL, update_date TIMESTAMP NOT NULL, PRIMARY KEY (tax_rule_id) ); INSERT INTO dtb_tax_rule (tax_rule_id, apply_date, member_id, del_flg, create_date, update_date, calc_rule, tax_rate) VALUES (0, CURRENT_TIMESTAMP, 1, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, (SELECT tax_rule FROM dtb_baseinfo), (SELECT tax FROM dtb_baseinfo)); ALTER TABLE dtb_baseinfo ADD COLUMN zipcode text; ALTER TABLE dtb_baseinfo ADD COLUMN country_id INT; ALTER TABLE dtb_baseinfo ADD COLUMN law_zipcode text; ALTER TABLE dtb_baseinfo ADD COLUMN law_country_id INT; ALTER TABLE dtb_baseinfo DROP COLUMN tax; ALTER TABLE dtb_baseinfo DROP COLUMN tax_rule; ALTER TABLE dtb_baseinfo DROP COLUMN email05; ALTER TABLE dtb_customer ALTER COLUMN kana01 DROP NOT NULL; ALTER TABLE dtb_customer ALTER COLUMN kana02 DROP NOT NULL; ALTER TABLE dtb_customer ADD COLUMN company_name text; ALTER TABLE dtb_customer ADD COLUMN zipcode text; ALTER TABLE dtb_customer ADD COLUMN country_id INT; ALTER TABLE dtb_order ADD COLUMN order_company_name text; ALTER TABLE dtb_order ADD COLUMN order_zipcode text; ALTER TABLE dtb_order ADD COLUMN order_country_id INT; ALTER TABLE dtb_order_temp ADD COLUMN order_company_name text; ALTER TABLE dtb_order_temp ADD COLUMN order_zipcode text; ALTER TABLE dtb_order_temp ADD COLUMN order_country_id INT; ALTER TABLE dtb_shipping ADD COLUMN shipping_company_name text; ALTER TABLE dtb_shipping ADD COLUMN shipping_country_id INT; ALTER TABLE dtb_shipping ADD COLUMN shipping_zipcode text; ALTER TABLE dtb_other_deliv ADD COLUMN company_name text; ALTER TABLE dtb_other_deliv ADD COLUMN zipcode text; ALTER TABLE dtb_other_deliv ADD COLUMN country_id INT; ALTER TABLE dtb_order_detail ADD COLUMN tax_rate NUMERIC; ALTER TABLE dtb_order_detail ADD COLUMN tax_rule SMALLINT; ALTER TABLE dtb_pagelayout ADD COLUMN meta_robots text; CREATE TABLE mtb_country ( id INT, name text, rank INT NOT NULL, PRIMARY KEY (id) ); ALTER TABLE dtb_plugin_hookpoint ADD COLUMN use_flg SMALLINT NOT NULL DEFAULT 1; UPDATE dtb_kiyaku SET kiyaku_text = REPLACE(kiyaku_text, '本規約は、すべての会員に適用され、登録手続時および登録後にお守りいただく規約です。', '本規約は、全ての会員に適用され、登録手続時および登録後にお守りいただく規約です。') WHERE kiyaku_id = 1; UPDATE dtb_kiyaku SET kiyaku_text = REPLACE(kiyaku_text, 'パスワードを用いて当社に対して行われた意思表示は、会員本人の意思表示とみなし、そのために生じる支払等はすべて会員の責任となります。', 'パスワードを用いて当社に対して行われた意思表示は、会員本人の意思表示とみなし、そのために生じる支払等は全て会員の責任となります。') WHERE kiyaku_id = 2; DELETE FROM dtb_pagelayout WHERE (device_type_id, page_id, url, filename) = (1, 15, 'abouts/index.php', 'abouts/index'); UPDATE dtb_pagelayout SET meta_robots = 'noindex' WHERE filename IN ( 'cart/index', 'mypage/change', 'mypage/change_complete', 'mypage/delivery', 'mypage/favorite', 'mypage/history', 'mypage/index', 'mypage/login', 'mypage/refusal', 'mypage/refusal_complete', 'shopping/complete', 'shopping/confirm', 'shopping/deliv', 'shopping/index', 'shopping/multiple', 'shopping/payment', 'unsupported/index' ); INSERT INTO mtb_mobile_domain (id, name, rank) VALUES (8, 'emnet.ne.jp', 7); INSERT INTO mtb_mobile_domain (id, name, rank) VALUES (9, 'i.softbank.jp', 8); UPDATE mtb_constants SET name = 'DATA_REALDIR . "__default.php"' WHERE (id, name) = ('USER_DEF_PHP_REALFILE', 'USER_REALDIR . "__default.php"'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_LOG_REALFILE', 'DATA_REALDIR . "logs/plugin.log"', 148, 'プラグインログファイル'); UPDATE mtb_constants SET remarks = 'ダウンロードファイル登録可能拡張子(カンマ区切り)' WHERE (id, remarks) = ('DOWNLOAD_EXTENSION', 'ダウンロードファイル登録可能拡張子(カンマ区切り)"'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DEFAULT_COUNTRY_ID', 392, 1413, 'デフォルト国コード ISO_3166-1に準拠'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('USE_NORMALIZE_HOSTNAME', 'true', 1414, 'ホスト名を正規化するか (true:する false:しない)'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FORM_COUNTRY_ENABLE', 'false', 1414, '各種フォームで国の指定を有効にする(true:有効 false:無効)'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('OPTION_PRODUCT_TAX_RULE', '0', 1415, '商品ごとの税率設定(軽減税率対応 有効:1 無効:0) '); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('TAX_RULE_PRIORITY', '"product_id,product_class_id,pref_id,country_id"', 1416, '複数箇所の税率設定時における優先度設定。カンマ区切りスペース不可で記述。後に書いてあるキーに一致するほど優先される。デフォルト:''product_id,product_class_id,pref_id,country_id''(国>地域(県)>規格単位>商品単位)'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PENDING_ORDER_CANCEL_TIME', '900', 1417, '決済処理中ステータスのロールバックを行う時間の設定(秒) '); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PENDING_ORDER_CANCEL_FLAG', 'true', 1418, '決済処理中ステータスのロールバックをするか(true:する false:しない)'); INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('API_ENABLE_FLAG', 'false', 1419, 'API機能を有効にする(true:する false:しない)'); INSERT INTO mtb_country (id, name, rank) VALUES (352,'アイスランド',1); INSERT INTO mtb_country (id, name, rank) VALUES (372,'アイルランド',2); INSERT INTO mtb_country (id, name, rank) VALUES (31,'アゼルバイジャン',3); INSERT INTO mtb_country (id, name, rank) VALUES (4,'アフガニスタン',4); INSERT INTO mtb_country (id, name, rank) VALUES (840,'アメリカ合衆国',5); INSERT INTO mtb_country (id, name, rank) VALUES (850,'アメリカ領ヴァージン諸島',6); INSERT INTO mtb_country (id, name, rank) VALUES (16,'アメリカ領サモア',7); INSERT INTO mtb_country (id, name, rank) VALUES (784,'アラブ首長国連邦',8); INSERT INTO mtb_country (id, name, rank) VALUES (12,'アルジェリア',9); INSERT INTO mtb_country (id, name, rank) VALUES (32,'アルゼンチン',10); INSERT INTO mtb_country (id, name, rank) VALUES (533,'アルバ',11); INSERT INTO mtb_country (id, name, rank) VALUES (8,'アルバニア',12); INSERT INTO mtb_country (id, name, rank) VALUES (51,'アルメニア',13); INSERT INTO mtb_country (id, name, rank) VALUES (660,'アンギラ',14); INSERT INTO mtb_country (id, name, rank) VALUES (24,'アンゴラ',15); INSERT INTO mtb_country (id, name, rank) VALUES (28,'アンティグア・バーブーダ',16); INSERT INTO mtb_country (id, name, rank) VALUES (20,'アンドラ',17); INSERT INTO mtb_country (id, name, rank) VALUES (887,'イエメン',18); INSERT INTO mtb_country (id, name, rank) VALUES (826,'イギリス',19); INSERT INTO mtb_country (id, name, rank) VALUES (86,'イギリス領インド洋地域',20); INSERT INTO mtb_country (id, name, rank) VALUES (92,'イギリス領ヴァージン諸島',21); INSERT INTO mtb_country (id, name, rank) VALUES (376,'イスラエル',22); INSERT INTO mtb_country (id, name, rank) VALUES (380,'イタリア',23); INSERT INTO mtb_country (id, name, rank) VALUES (368,'イラク',24); INSERT INTO mtb_country (id, name, rank) VALUES (364,'イラン|イラン・イスラム共和国',25); INSERT INTO mtb_country (id, name, rank) VALUES (356,'インド',26); INSERT INTO mtb_country (id, name, rank) VALUES (360,'インドネシア',27); INSERT INTO mtb_country (id, name, rank) VALUES (876,'ウォリス・フツナ',28); INSERT INTO mtb_country (id, name, rank) VALUES (800,'ウガンダ',29); INSERT INTO mtb_country (id, name, rank) VALUES (804,'ウクライナ',30); INSERT INTO mtb_country (id, name, rank) VALUES (860,'ウズベキスタン',31); INSERT INTO mtb_country (id, name, rank) VALUES (858,'ウルグアイ',32); INSERT INTO mtb_country (id, name, rank) VALUES (218,'エクアドル',33); INSERT INTO mtb_country (id, name, rank) VALUES (818,'エジプト',34); INSERT INTO mtb_country (id, name, rank) VALUES (233,'エストニア',35); INSERT INTO mtb_country (id, name, rank) VALUES (231,'エチオピア',36); INSERT INTO mtb_country (id, name, rank) VALUES (232,'エリトリア',37); INSERT INTO mtb_country (id, name, rank) VALUES (222,'エルサルバドル',38); INSERT INTO mtb_country (id, name, rank) VALUES (36,'オーストラリア',39); INSERT INTO mtb_country (id, name, rank) VALUES (40,'オーストリア',40); INSERT INTO mtb_country (id, name, rank) VALUES (248,'オーランド諸島',41); INSERT INTO mtb_country (id, name, rank) VALUES (512,'オマーン',42); INSERT INTO mtb_country (id, name, rank) VALUES (528,'オランダ',43); INSERT INTO mtb_country (id, name, rank) VALUES (288,'ガーナ',44); INSERT INTO mtb_country (id, name, rank) VALUES (132,'カーボベルデ',45); INSERT INTO mtb_country (id, name, rank) VALUES (831,'ガーンジー',46); INSERT INTO mtb_country (id, name, rank) VALUES (328,'ガイアナ',47); INSERT INTO mtb_country (id, name, rank) VALUES (398,'カザフスタン',48); INSERT INTO mtb_country (id, name, rank) VALUES (634,'カタール',49); INSERT INTO mtb_country (id, name, rank) VALUES (581,'合衆国領有小離島',50); INSERT INTO mtb_country (id, name, rank) VALUES (124,'カナダ',51); INSERT INTO mtb_country (id, name, rank) VALUES (266,'ガボン',52); INSERT INTO mtb_country (id, name, rank) VALUES (120,'カメルーン',53); INSERT INTO mtb_country (id, name, rank) VALUES (270,'ガンビア',54); INSERT INTO mtb_country (id, name, rank) VALUES (116,'カンボジア',55); INSERT INTO mtb_country (id, name, rank) VALUES (580,'北マリアナ諸島',56); INSERT INTO mtb_country (id, name, rank) VALUES (324,'ギニア',57); INSERT INTO mtb_country (id, name, rank) VALUES (624,'ギニアビサウ',58); INSERT INTO mtb_country (id, name, rank) VALUES (196,'キプロス',59); INSERT INTO mtb_country (id, name, rank) VALUES (192,'キューバ',60); INSERT INTO mtb_country (id, name, rank) VALUES (531,'キュラソー島|キュラソー',61); INSERT INTO mtb_country (id, name, rank) VALUES (300,'ギリシャ',62); INSERT INTO mtb_country (id, name, rank) VALUES (296,'キリバス',63); INSERT INTO mtb_country (id, name, rank) VALUES (417,'キルギス',64); INSERT INTO mtb_country (id, name, rank) VALUES (320,'グアテマラ',65); INSERT INTO mtb_country (id, name, rank) VALUES (312,'グアドループ',66); INSERT INTO mtb_country (id, name, rank) VALUES (316,'グアム',67); INSERT INTO mtb_country (id, name, rank) VALUES (414,'クウェート',68); INSERT INTO mtb_country (id, name, rank) VALUES (184,'クック諸島',69); INSERT INTO mtb_country (id, name, rank) VALUES (304,'グリーンランド',70); INSERT INTO mtb_country (id, name, rank) VALUES (162,'クリスマス島 (オーストラリア)|クリスマス島',71); INSERT INTO mtb_country (id, name, rank) VALUES (268,'グルジア',72); INSERT INTO mtb_country (id, name, rank) VALUES (308,'グレナダ',73); INSERT INTO mtb_country (id, name, rank) VALUES (191,'クロアチア',74); INSERT INTO mtb_country (id, name, rank) VALUES (136,'ケイマン諸島',75); INSERT INTO mtb_country (id, name, rank) VALUES (404,'ケニア',76); INSERT INTO mtb_country (id, name, rank) VALUES (384,'コートジボワール',77); INSERT INTO mtb_country (id, name, rank) VALUES (166,'ココス諸島|ココス(キーリング)諸島',78); INSERT INTO mtb_country (id, name, rank) VALUES (188,'コスタリカ',79); INSERT INTO mtb_country (id, name, rank) VALUES (174,'コモロ',80); INSERT INTO mtb_country (id, name, rank) VALUES (170,'コロンビア',81); INSERT INTO mtb_country (id, name, rank) VALUES (178,'コンゴ共和国',82); INSERT INTO mtb_country (id, name, rank) VALUES (180,'コンゴ民主共和国',83); INSERT INTO mtb_country (id, name, rank) VALUES (682,'サウジアラビア',84); INSERT INTO mtb_country (id, name, rank) VALUES (239,'サウスジョージア・サウスサンドウィッチ諸島',85); INSERT INTO mtb_country (id, name, rank) VALUES (882,'サモア',86); INSERT INTO mtb_country (id, name, rank) VALUES (678,'サントメ・プリンシペ',87); INSERT INTO mtb_country (id, name, rank) VALUES (652,'サン・バルテルミー島|サン・バルテルミー',88); INSERT INTO mtb_country (id, name, rank) VALUES (894,'ザンビア',89); INSERT INTO mtb_country (id, name, rank) VALUES (666,'サンピエール島・ミクロン島',90); INSERT INTO mtb_country (id, name, rank) VALUES (674,'サンマリノ',91); INSERT INTO mtb_country (id, name, rank) VALUES (663,'サン・マルタン (西インド諸島)|サン・マルタン(フランス領)',92); INSERT INTO mtb_country (id, name, rank) VALUES (694,'シエラレオネ',93); INSERT INTO mtb_country (id, name, rank) VALUES (262,'ジブチ',94); INSERT INTO mtb_country (id, name, rank) VALUES (292,'ジブラルタル',95); INSERT INTO mtb_country (id, name, rank) VALUES (832,'ジャージー',96); INSERT INTO mtb_country (id, name, rank) VALUES (388,'ジャマイカ',97); INSERT INTO mtb_country (id, name, rank) VALUES (760,'シリア|シリア・アラブ共和国',98); INSERT INTO mtb_country (id, name, rank) VALUES (702,'シンガポール',99); INSERT INTO mtb_country (id, name, rank) VALUES (534,'シント・マールテン|シント・マールテン(オランダ領)',100); INSERT INTO mtb_country (id, name, rank) VALUES (716,'ジンバブエ',101); INSERT INTO mtb_country (id, name, rank) VALUES (756,'スイス',102); INSERT INTO mtb_country (id, name, rank) VALUES (752,'スウェーデン',103); INSERT INTO mtb_country (id, name, rank) VALUES (729,'スーダン',104); INSERT INTO mtb_country (id, name, rank) VALUES (744,'スヴァールバル諸島およびヤンマイエン島',105); INSERT INTO mtb_country (id, name, rank) VALUES (724,'スペイン',106); INSERT INTO mtb_country (id, name, rank) VALUES (740,'スリナム',107); INSERT INTO mtb_country (id, name, rank) VALUES (144,'スリランカ',108); INSERT INTO mtb_country (id, name, rank) VALUES (703,'スロバキア',109); INSERT INTO mtb_country (id, name, rank) VALUES (705,'スロベニア',110); INSERT INTO mtb_country (id, name, rank) VALUES (748,'スワジランド',111); INSERT INTO mtb_country (id, name, rank) VALUES (690,'セーシェル',112); INSERT INTO mtb_country (id, name, rank) VALUES (226,'赤道ギニア',113); INSERT INTO mtb_country (id, name, rank) VALUES (686,'セネガル',114); INSERT INTO mtb_country (id, name, rank) VALUES (688,'セルビア',115); INSERT INTO mtb_country (id, name, rank) VALUES (659,'セントクリストファー・ネイビス',116); INSERT INTO mtb_country (id, name, rank) VALUES (670,'セントビンセント・グレナディーン|セントビンセントおよびグレナディーン諸島',117); INSERT INTO mtb_country (id, name, rank) VALUES (654,'セントヘレナ・アセンションおよびトリスタンダクーニャ',118); INSERT INTO mtb_country (id, name, rank) VALUES (662,'セントルシア',119); INSERT INTO mtb_country (id, name, rank) VALUES (706,'ソマリア',120); INSERT INTO mtb_country (id, name, rank) VALUES (90,'ソロモン諸島',121); INSERT INTO mtb_country (id, name, rank) VALUES (796,'タークス・カイコス諸島',122); INSERT INTO mtb_country (id, name, rank) VALUES (764,'タイ王国|タイ',123); INSERT INTO mtb_country (id, name, rank) VALUES (410,'大韓民国',124); INSERT INTO mtb_country (id, name, rank) VALUES (158,'台湾',125); INSERT INTO mtb_country (id, name, rank) VALUES (762,'タジキスタン',126); INSERT INTO mtb_country (id, name, rank) VALUES (834,'タンザニア',127); INSERT INTO mtb_country (id, name, rank) VALUES (203,'チェコ',128); INSERT INTO mtb_country (id, name, rank) VALUES (148,'チャド',129); INSERT INTO mtb_country (id, name, rank) VALUES (140,'中央アフリカ共和国',130); INSERT INTO mtb_country (id, name, rank) VALUES (156,'中華人民共和国|中国',131); INSERT INTO mtb_country (id, name, rank) VALUES (788,'チュニジア',132); INSERT INTO mtb_country (id, name, rank) VALUES (408,'朝鮮民主主義人民共和国',133); INSERT INTO mtb_country (id, name, rank) VALUES (152,'チリ',134); INSERT INTO mtb_country (id, name, rank) VALUES (798,'ツバル',135); INSERT INTO mtb_country (id, name, rank) VALUES (208,'デンマーク',136); INSERT INTO mtb_country (id, name, rank) VALUES (276,'ドイツ',137); INSERT INTO mtb_country (id, name, rank) VALUES (768,'トーゴ',138); INSERT INTO mtb_country (id, name, rank) VALUES (772,'トケラウ',139); INSERT INTO mtb_country (id, name, rank) VALUES (214,'ドミニカ共和国',140); INSERT INTO mtb_country (id, name, rank) VALUES (212,'ドミニカ国',141); INSERT INTO mtb_country (id, name, rank) VALUES (780,'トリニダード・トバゴ',142); INSERT INTO mtb_country (id, name, rank) VALUES (795,'トルクメニスタン',143); INSERT INTO mtb_country (id, name, rank) VALUES (792,'トルコ',144); INSERT INTO mtb_country (id, name, rank) VALUES (776,'トンガ',145); INSERT INTO mtb_country (id, name, rank) VALUES (566,'ナイジェリア',146); INSERT INTO mtb_country (id, name, rank) VALUES (520,'ナウル',147); INSERT INTO mtb_country (id, name, rank) VALUES (516,'ナミビア',148); INSERT INTO mtb_country (id, name, rank) VALUES (10,'南極',149); INSERT INTO mtb_country (id, name, rank) VALUES (570,'ニウエ',150); INSERT INTO mtb_country (id, name, rank) VALUES (558,'ニカラグア',151); INSERT INTO mtb_country (id, name, rank) VALUES (562,'ニジェール',152); INSERT INTO mtb_country (id, name, rank) VALUES (392,'日本',153); INSERT INTO mtb_country (id, name, rank) VALUES (732,'西サハラ',154); INSERT INTO mtb_country (id, name, rank) VALUES (540,'ニューカレドニア',155); INSERT INTO mtb_country (id, name, rank) VALUES (554,'ニュージーランド',156); INSERT INTO mtb_country (id, name, rank) VALUES (524,'ネパール',157); INSERT INTO mtb_country (id, name, rank) VALUES (574,'ノーフォーク島',158); INSERT INTO mtb_country (id, name, rank) VALUES (578,'ノルウェー',159); INSERT INTO mtb_country (id, name, rank) VALUES (334,'ハード島とマクドナルド諸島',160); INSERT INTO mtb_country (id, name, rank) VALUES (48,'バーレーン',161); INSERT INTO mtb_country (id, name, rank) VALUES (332,'ハイチ',162); INSERT INTO mtb_country (id, name, rank) VALUES (586,'パキスタン',163); INSERT INTO mtb_country (id, name, rank) VALUES (336,'バチカン|バチカン市国',164); INSERT INTO mtb_country (id, name, rank) VALUES (591,'パナマ',165); INSERT INTO mtb_country (id, name, rank) VALUES (548,'バヌアツ',166); INSERT INTO mtb_country (id, name, rank) VALUES (44,'バハマ',167); INSERT INTO mtb_country (id, name, rank) VALUES (598,'パプアニューギニア',168); INSERT INTO mtb_country (id, name, rank) VALUES (60,'バミューダ諸島|バミューダ',169); INSERT INTO mtb_country (id, name, rank) VALUES (585,'パラオ',170); INSERT INTO mtb_country (id, name, rank) VALUES (600,'パラグアイ',171); INSERT INTO mtb_country (id, name, rank) VALUES (52,'バルバドス',172); INSERT INTO mtb_country (id, name, rank) VALUES (275,'パレスチナ',173); INSERT INTO mtb_country (id, name, rank) VALUES (348,'ハンガリー',174); INSERT INTO mtb_country (id, name, rank) VALUES (50,'バングラデシュ',175); INSERT INTO mtb_country (id, name, rank) VALUES (626,'東ティモール',176); INSERT INTO mtb_country (id, name, rank) VALUES (612,'ピトケアン諸島|ピトケアン',177); INSERT INTO mtb_country (id, name, rank) VALUES (242,'フィジー',178); INSERT INTO mtb_country (id, name, rank) VALUES (608,'フィリピン',179); INSERT INTO mtb_country (id, name, rank) VALUES (246,'フィンランド',180); INSERT INTO mtb_country (id, name, rank) VALUES (64,'ブータン',181); INSERT INTO mtb_country (id, name, rank) VALUES (74,'ブーベ島',182); INSERT INTO mtb_country (id, name, rank) VALUES (630,'プエルトリコ',183); INSERT INTO mtb_country (id, name, rank) VALUES (234,'フェロー諸島',184); INSERT INTO mtb_country (id, name, rank) VALUES (238,'フォークランド諸島|フォークランド(マルビナス)諸島',185); INSERT INTO mtb_country (id, name, rank) VALUES (76,'ブラジル',186); INSERT INTO mtb_country (id, name, rank) VALUES (250,'フランス',187); INSERT INTO mtb_country (id, name, rank) VALUES (254,'フランス領ギアナ',188); INSERT INTO mtb_country (id, name, rank) VALUES (258,'フランス領ポリネシア',189); INSERT INTO mtb_country (id, name, rank) VALUES (260,'フランス領南方・南極地域',190); INSERT INTO mtb_country (id, name, rank) VALUES (100,'ブルガリア',191); INSERT INTO mtb_country (id, name, rank) VALUES (854,'ブルキナファソ',192); INSERT INTO mtb_country (id, name, rank) VALUES (96,'ブルネイ|ブルネイ・ダルサラーム',193); INSERT INTO mtb_country (id, name, rank) VALUES (108,'ブルンジ',194); INSERT INTO mtb_country (id, name, rank) VALUES (704,'ベトナム',195); INSERT INTO mtb_country (id, name, rank) VALUES (204,'ベナン',196); INSERT INTO mtb_country (id, name, rank) VALUES (862,'ベネズエラ|ベネズエラ・ボリバル共和国',197); INSERT INTO mtb_country (id, name, rank) VALUES (112,'ベラルーシ',198); INSERT INTO mtb_country (id, name, rank) VALUES (84,'ベリーズ',199); INSERT INTO mtb_country (id, name, rank) VALUES (604,'ペルー',200); INSERT INTO mtb_country (id, name, rank) VALUES (56,'ベルギー',201); INSERT INTO mtb_country (id, name, rank) VALUES (616,'ポーランド',202); INSERT INTO mtb_country (id, name, rank) VALUES (70,'ボスニア・ヘルツェゴビナ',203); INSERT INTO mtb_country (id, name, rank) VALUES (72,'ボツワナ',204); INSERT INTO mtb_country (id, name, rank) VALUES (535,'BES諸島|ボネール、シント・ユースタティウスおよびサバ',205); INSERT INTO mtb_country (id, name, rank) VALUES (68,'ボリビア|ボリビア多民族国',206); INSERT INTO mtb_country (id, name, rank) VALUES (620,'ポルトガル',207); INSERT INTO mtb_country (id, name, rank) VALUES (344,'香港',208); INSERT INTO mtb_country (id, name, rank) VALUES (340,'ホンジュラス',209); INSERT INTO mtb_country (id, name, rank) VALUES (584,'マーシャル諸島',210); INSERT INTO mtb_country (id, name, rank) VALUES (446,'マカオ',211); INSERT INTO mtb_country (id, name, rank) VALUES (807,'マケドニア共和国|マケドニア旧ユーゴスラビア共和国',212); INSERT INTO mtb_country (id, name, rank) VALUES (450,'マダガスカル',213); INSERT INTO mtb_country (id, name, rank) VALUES (175,'マヨット',214); INSERT INTO mtb_country (id, name, rank) VALUES (454,'マラウイ',215); INSERT INTO mtb_country (id, name, rank) VALUES (466,'マリ共和国|マリ',216); INSERT INTO mtb_country (id, name, rank) VALUES (470,'マルタ',217); INSERT INTO mtb_country (id, name, rank) VALUES (474,'マルティニーク',218); INSERT INTO mtb_country (id, name, rank) VALUES (458,'マレーシア',219); INSERT INTO mtb_country (id, name, rank) VALUES (833,'マン島',220); INSERT INTO mtb_country (id, name, rank) VALUES (583,'ミクロネシア連邦',221); INSERT INTO mtb_country (id, name, rank) VALUES (710,'南アフリカ共和国|南アフリカ',222); INSERT INTO mtb_country (id, name, rank) VALUES (728,'南スーダン',223); INSERT INTO mtb_country (id, name, rank) VALUES (104,'ミャンマー',224); INSERT INTO mtb_country (id, name, rank) VALUES (484,'メキシコ',225); INSERT INTO mtb_country (id, name, rank) VALUES (480,'モーリシャス',226); INSERT INTO mtb_country (id, name, rank) VALUES (478,'モーリタニア',227); INSERT INTO mtb_country (id, name, rank) VALUES (508,'モザンビーク',228); INSERT INTO mtb_country (id, name, rank) VALUES (492,'モナコ',229); INSERT INTO mtb_country (id, name, rank) VALUES (462,'モルディブ',230); INSERT INTO mtb_country (id, name, rank) VALUES (498,'モルドバ|モルドバ共和国',231); INSERT INTO mtb_country (id, name, rank) VALUES (504,'モロッコ',232); INSERT INTO mtb_country (id, name, rank) VALUES (496,'モンゴル国|モンゴル',233); INSERT INTO mtb_country (id, name, rank) VALUES (499,'モンテネグロ',234); INSERT INTO mtb_country (id, name, rank) VALUES (500,'モントセラト',235); INSERT INTO mtb_country (id, name, rank) VALUES (400,'ヨルダン',236); INSERT INTO mtb_country (id, name, rank) VALUES (418,'ラオス|ラオス人民民主共和国',237); INSERT INTO mtb_country (id, name, rank) VALUES (428,'ラトビア',238); INSERT INTO mtb_country (id, name, rank) VALUES (440,'リトアニア',239); INSERT INTO mtb_country (id, name, rank) VALUES (434,'リビア',240); INSERT INTO mtb_country (id, name, rank) VALUES (438,'リヒテンシュタイン',241); INSERT INTO mtb_country (id, name, rank) VALUES (430,'リベリア',242); INSERT INTO mtb_country (id, name, rank) VALUES (642,'ルーマニア',243); INSERT INTO mtb_country (id, name, rank) VALUES (442,'ルクセンブルク',244); INSERT INTO mtb_country (id, name, rank) VALUES (646,'ルワンダ',245); INSERT INTO mtb_country (id, name, rank) VALUES (426,'レソト',246); INSERT INTO mtb_country (id, name, rank) VALUES (422,'レバノン',247); INSERT INTO mtb_country (id, name, rank) VALUES (638,'レユニオン',248); INSERT INTO mtb_country (id, name, rank) VALUES (643,'ロシア|ロシア連邦',249);
dtb_csv
現況のカスタマイズ状況を (CSV の差分などで) 確認し、対応を考える必要がある。SQL で更新せず、CSV でエクスポート・インポートする方が効率が良いケースもある。
このバージョンでの変更は下記の通り。
- csv_id = 1 は、変更なし。
- csv_id = 2 は、「会社名」(company_name) の追加と、それに伴う no, rank の増番。
- csv_id = 3 は、「会社名」(order_company_name) の追加と、それに伴う no, rank の増番。
- csv_id = 4 は、「投稿者URL」(reviewer_url) の追加と、それに伴う no, rank の増番。
- csv_id = 5 は、直接的な変更はないが、上述の影響を受けて no が増番する。
以下は、dtb_csv の差分検出の参考コード。(2.12.6 の標準との差を検出する意図。)
CREATE TABLE dtb_csv_vup_212_default ( no INT, csv_id INT NOT NULL, col text, disp_name text, rank INT, rw_flg SMALLINT DEFAULT 1, STATUS SMALLINT NOT NULL DEFAULT 1, mb_convert_kana_option text, size_const_type text, error_check_types text, PRIMARY KEY (no) ); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (1, 1, 'product_id', '商品ID', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (2, 1, 'product_class_id', '商品規格ID', 2, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (3, 1, 'parent_classcategory_id', '親規格分類ID', 3, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (4, 1, 'classcategory_id', '規格分類ID', 4, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (5, 1, 'parent_classcategory_name', '親規格分類名', 5, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (6, 1, 'classcategory_name', '規格分類名', 6, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (7, 1, 'maker_id', 'メーカーID', 7, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (9, 1, 'name', '商品名', 9, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (10, 1, 'status', '表示ステータス(公開・非公開)', 10, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (11, 1, 'comment1', 'メーカーURL(コメント1)', 11, 1, 1, 'KVa', 'URL_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,URL_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (12, 1, 'comment2', 'コメント2', 12, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (13, 1, 'comment3', '検索ワード(コメント3)', 13, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (14, 1, 'comment4', 'コメント4', 14, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (15, 1, 'comment5', 'コメント5', 15, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (16, 1, 'comment6', 'コメント6', 16, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (17, 1, 'note', '備考欄(SHOP専用)', 17, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (18, 1, 'main_list_comment', '一覧-メインコメント', 18, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (19, 1, 'main_list_image', '一覧-メイン画像', 19, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (20, 1, 'main_comment', '詳細-メインコメント', 20, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK,HTML_TAG_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (21, 1, 'main_image', '詳細-メイン画像', 21, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (22, 1, 'main_large_image', '詳細-メイン拡大画像 ', 22, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (23, 1, 'sub_title1', '詳細-サブタイトル(1)', 23, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (24, 1, 'sub_comment1', '詳細-サブコメント(1)', 24, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,HTML_TAG_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (25, 1, 'sub_image1', '詳細-サブ画像(1)', 25, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (26, 1, 'sub_large_image1', '詳細-サブ拡大画像(1)', 26, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (27, 1, 'sub_title2', '詳細-サブタイトル(2)', 27, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (28, 1, 'sub_comment2', '詳細-サブコメント(2)', 28, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (29, 1, 'sub_image2', '詳細-サブ画像(2)', 29, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (30, 1, 'sub_large_image2', '詳細-サブ拡大画像(2)', 30, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (31, 1, 'sub_title3', '詳細-サブタイトル(3)', 31, 1, 1, NULL, 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (32, 1, 'sub_comment3', '詳細-サブコメント(3)', 32, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (33, 1, 'sub_image3', '詳細-サブ画像(3)', 33, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (34, 1, 'sub_large_image3', '詳細-サブ拡大画像(3)', 34, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (35, 1, 'sub_title4', '詳細-サブタイトル(4)', 35, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (36, 1, 'sub_comment4', '詳細-サブコメント(4)', 36, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (37, 1, 'sub_image4', '詳細-サブ画像(4)', 37, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (38, 1, 'sub_large_image4', '詳細-サブ拡大画像(4)', 38, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (39, 1, 'sub_title5', '詳細-サブタイトル(5)', 39, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (40, 1, 'sub_comment5', '詳細-サブコメント(5)', 40, 1, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (41, 1, 'sub_image5', '詳細-サブ画像(5)', 41, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (42, 1, 'sub_large_image5', '詳細-サブ拡大画像(5)', 42, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (43, 1, 'deliv_date_id', '発送日目安ID', 43, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (44, 1, 'del_flg', '削除フラグ', 44, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (45, 1, 'product_type_id', '商品種別ID', 45, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (46, 1, 'product_code', '商品コード', 46, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (47, 1, 'stock', '在庫数', 47, 1, 1, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (48, 1, 'stock_unlimited', '在庫無制限フラグ', 48, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (49, 1, 'sale_limit', '販売制限数', 49, 1, 1, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (50, 1, 'price01', '通常価格', 50, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (51, 1, 'price02', '販売価格', 51, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (52, 1, 'deliv_fee', '送料', 52, 1, 1, 'n', 'PRICE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (53, 1, 'point_rate', 'ポイント付与率', 53, 1, 1, 'n', 'PERCENTAGE_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (54, 1, 'down_filename', 'ダウンロードファイル名', 54, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (55, 1, 'down_realfilename', 'ダウンロード実ファイル', 55, 1, 1, NULL, 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,DOWN_FILE_EXISTS'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'LTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (72, 2, 'customer_id', '会員ID', 1, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (73, 2, 'name01', 'お名前(姓)', 2, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (74, 2, 'name02', 'お名前(名)', 3, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (75, 2, 'kana01', 'お名前(フリガナ・姓)', 4, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (76, 2, 'kana02', 'お名前(フリガナ・名)', 5, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (77, 2, 'zip01', '郵便番号1', 6, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (78, 2, 'zip02', '郵便番号2', 7, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (79, 2, '(SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_customer.pref) as pref', '都道府県', 8, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (80, 2, 'addr01', '住所1', 9, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (81, 2, 'addr02', '住所2', 10, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (82, 2, 'email', 'E-MAIL', 11, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (83, 2, 'tel01', 'TEL1', 12, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (84, 2, 'tel02', 'TEL2', 13, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (85, 2, 'tel03', 'TEL3', 14, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (86, 2, 'fax01', 'FAX1', 15, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (87, 2, 'fax02', 'FAX2', 16, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (88, 2, 'fax03', 'FAX3', 17, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (89, 2, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = dtb_customer.sex) as sex', '性別', 18, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (90, 2, '(SELECT name FROM mtb_job WHERE mtb_job.id = dtb_customer.job) as job', '職業', 19, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (91, 2, 'birth', '誕生日', 20, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (92, 2, 'first_buy_date', '初回購入日', 21, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (93, 2, 'last_buy_date', '最終購入日', 22, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (94, 2, 'buy_times', '購入回数', 23, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (95, 2, 'point', 'ポイント残高', 24, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (96, 2, 'note', '備考', 25, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (97, 2, 'create_date', '登録日', 26, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, STATUS) VALUES (98, 2, 'update_date', '更新日', 27, 1); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (99, 3, 'order_id', '注文番号', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (100, 3, 'customer_id', '会員ID', 2, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (101, 3, 'message', '要望等', 3, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (102, 3, 'order_name01', 'お名前(姓)', 4, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (103, 3, 'order_name02', 'お名前(名)', 5, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (104, 3, 'order_kana01', 'お名前(フリガナ・姓)', 6, 1, 1, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (105, 3, 'order_kana02', 'お名前(フリガナ名)', 7, 1, 1, 'KVCa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (106, 3, 'order_email', 'メールアドレス', 8, 1, 1, 'a', 'null', 'NO_SPTAB,EMAIL_CHECK,EMAIL_CHAR_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (107, 3, 'order_tel01', '電話番号1', 9, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (108, 3, 'order_tel02', '電話番号2', 10, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (109, 3, 'order_tel03', '電話番号3', 11, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (110, 3, 'order_fax01', 'FAX1', 12, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (111, 3, 'order_fax02', 'FAX2', 13, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (112, 3, 'order_fax03', 'FAX3', 14, 1, 1, 'n', 'TEL_ITEM_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (113, 3, 'order_zip01', '郵便番号1', 15, 1, 1, 'n', 'ZIP01_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (114, 3, 'order_zip02', '郵便番号2', 16, 1, 1, 'n', 'ZIP02_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (116, 3, 'order_addr01', '住所1', 18, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (117, 3, 'order_addr02', '住所2', 19, 1, 1, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (118, 3, 'order_sex', '性別', 20, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (119, 3, 'order_birth', '生年月日', 21, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (120, 3, 'order_job', '職種', 22, 1, 1, 'n', 'INT_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (121, 3, 'subtotal', '小計', 38, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (122, 3, 'discount', '値引き', 39, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (123, 3, 'deliv_fee', '送料', 40, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (124, 3, 'charge', '手数料', 41, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (125, 3, 'use_point', '使用ポイント', 42, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (126, 3, 'add_point', '加算ポイント', 43, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (127, 3, 'tax', '税金', 44, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (128, 3, 'total', '合計', 45, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (129, 3, 'payment_total', 'お支払い合計', 46, 1, 1, 'n', 'PRICE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (130, 3, 'deliv_id', '配送業者ID', 47, 2, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (131, 3, 'payment_method', '支払い方法', 48, 2, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (132, 3, 'note', 'SHOPメモ', 50, 2, 1, 'KVa', 'LLTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (133, 3, 'status', '対応状況', 51, 1, 1, 'KVa', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (134, 3, 'create_date', '注文日時', 52, 1, 1, 'a', '', 'CHECK_DATE'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (135, 3, 'update_date', '更新日時', 53, 1, 1, 'a', '', 'CHECK_DATE'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (136, 3, 'commit_date', '発送完了日時', 54, 1, 1, 'a', '', 'CHECK_DATE'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (137, 3, 'device_type_id', '端末種別ID', 55, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (140, 4, 'B.name', '商品名', 1, 2, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (142, 4, 'A.create_date', '投稿日', 3, 1, 1, 'a', '', 'CHECK_DATE,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (143, 4, 'A.reviewer_name', '投稿者名', 4, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, 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, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (146, 4, 'A.title', 'タイトル', 7, 1, 1, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (147, 4, 'A.comment', 'コメント', 8, 1, 1, 'KVa', 'LTEXT_LEN', 'MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (148, 5, 'category_id', 'カテゴリID', 1, 3, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (149, 5, 'category_name', 'カテゴリ名', 2, 1, 1, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,EXIST_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (150, 5, 'parent_category_id', '親カテゴリID', 3, 1, 1, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (151, 5, 'level', '階層', NULL, 2, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (152, 5, 'rank', '表示ランク', NULL, 2, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); INSERT INTO dtb_csv_vup_212_default (no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types) VALUES (153, 5, 'del_flg', '削除フラグ', NULL, 1, 2, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); SELECT no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types FROM dtb_csv_vup_212_default ORDER BY csv_id, no; -- この出力を一旦退避 (dtb_csv_vup_212_default.csv) SELECT no, csv_id, col, disp_name, rank, rw_flg, STATUS, mb_convert_kana_option, size_const_type, error_check_types FROM dtb_csv ORDER BY csv_id, no; -- 出力を上と比較 (dtb_csv_current.csv) DROP TABLE dtb_csv_vup_212_default;
ファイル
多数。。。