Context Navigation

← Previous Change
Next Change →

column_comment.sql

Timestamp:

2010/08/19 19:48:04 (14 years ago)

Author:

nanasess

bzr:base-revision:

ohkouchi@loop-az.jp-20100818061207-vgzu2onofgbq0k0i

bzr:committer:

Kentaro Ohkouchi <ohkouchi@loop-az.jp>

bzr:file-ids:

data/class/SC_Query.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Query.php
data/class/helper/SC_Helper_Mail.php 15618@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mail.php
data/class/helper/SC_Helper_Mobile.php 15277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mobile.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php 15336@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fbasis%2FLC_Page_Admin_Basis_Control.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php 15297@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fbasis%2FLC_Page_Admin_Basis_Delivery_Input.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php 17073@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fadmin%2Fbasis%2FLC_Page_Admin_Basis_Holiday.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php 15329@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fbasis%2FLC_Page_Admin_Basis_Kiyaku.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php 15304@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fbasis%2FLC_Page_Admin_Basis_Payment_Input.php
data/class/pages/admin/contents/LC_Page_Admin_Contents.php 15659@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php 16449@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_CsvSql.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php 15660@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_Recommend.php
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php 15687@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_Bloc.php
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php 15682@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_MainEdit.php
data/class/pages/admin/mail/LC_Page_Admin_Mail.php 15640@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail.php
data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php 15594@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Forder%2FLC_Page_Admin_Order_Edit.php
data/class/pages/admin/products/LC_Page_Admin_Products_Category.php 15518@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Category.php
data/class/pages/admin/products/LC_Page_Admin_Products_Class.php 15481@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Class.php
data/class/pages/admin/products/LC_Page_Admin_Products_ClassCategory.php 15486@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ClassCategory.php
data/class/pages/admin/products/LC_Page_Admin_Products_Maker.php 17263@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Maker.php
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php 15342@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Product.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 15559@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductClass.php
data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 15472@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_UploadCSV.php
data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php 17194@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_UploadCSVCategory.php
data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php 16251@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System_Bkup.php
data/class/pages/admin/system/LC_Page_Admin_System_Input.php 15602@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System_Input.php
data/class/pages/entry/LC_Page_Entry.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fentry%2FLC_Page_Entry.php
data/class/pages/mypage/LC_Page_Mypage_DeliveryAddr.php 16093@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_DeliveryAddr.php
data/class/pages/products/LC_Page_Products_Review.php 15173@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Review.php
data/class/pages/shopping/LC_Page_Shopping_Complete.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Complete.php
data/class/pages/shopping/LC_Page_Shopping_Confirm.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Confirm.php
data/class/pages/shopping/LC_Page_Shopping_DelivAddr.php 16386@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_DelivAddr.php
data/class/pages/tb/LC_Page_TrackBack.php 16472@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Ftb%2FLC_Page_TrackBack.php
data/class/pages/upgrade/LC_Page_Upgrade_Download.php 16459@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fupgrade%2FLC_Page_Upgrade_Download.php
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/column_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcolumn_comment.sql
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
html/install/sql/table_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Ftable_comment.sql

bzr:mapping-version:

bzr:repository-uuid:

1e3b908f-19a9-db11-a64c-001125224ba8

bzr:revision-id:

ohkouchi@loop-az.jp-20100819104758-beubop5hq0pwdqhx

bzr:revno:

2271

bzr:revprop:branch-nick:

branches/version-2_5-dev

bzr:root:

branches/version-2_5-dev

bzr:text-parents:

data/class/SC_Query.php ohkouchi@loop-az.jp-20100812103342-5fc7rp06997dbg6e
data/class/helper/SC_Helper_Mail.php ohkouchi@loop-az.jp-20100623032937-dhwktuevjyk0jv13
data/class/helper/SC_Helper_Mobile.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/contents/LC_Page_Admin_Contents.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/admin/mail/LC_Page_Admin_Mail.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/products/LC_Page_Admin_Products_Category.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/products/LC_Page_Admin_Products_Class.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/products/LC_Page_Admin_Products_ClassCategory.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/products/LC_Page_Admin_Products_Maker.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18782
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/system/LC_Page_Admin_System_Input.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/entry/LC_Page_Entry.php ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
data/class/pages/mypage/LC_Page_Mypage_DeliveryAddr.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/products/LC_Page_Products_Review.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/shopping/LC_Page_Shopping_Complete.php ohkouchi@loop-az.jp-20100804045224-nsulc26bh1ttqfrb
data/class/pages/shopping/LC_Page_Shopping_Confirm.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
data/class/pages/shopping/LC_Page_Shopping_DelivAddr.php ohkouchi@loop-az.jp-20100803084717-9sbbuk4o59x5sio4
data/class/pages/tb/LC_Page_TrackBack.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/upgrade/LC_Page_Upgrade_Download.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
html/install/index.php ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/table_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981

bzr:timestamp:

2010-08-19 19:47:58.180000067 +0900

bzr:user-agent:

bzr2.1.2+bzr-svn1.0.2

svn:original-date:

2010-08-19T10:47:58.180000Z

Message:

シーケンス値の出力に SC_Query::nextVal() を使用するよう修正(#780)

インストーラでシーケンスの生成/削除を行うよう修正
html/install/sql/insert_data.sql を, シーケンス値を含めたものに修正
PostgreSQL の serial 型を int 型に修正
MySQL で auto_increment を使用しないように修正
シーケンスIDを使用するテーブルへの INSERT を行っている個所で, 事前にシーケンス値を取得するよう修正
FIXME data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php を要改修

File:

: 1 edited

branches/version-2_5-dev/html/install/sql/column_comment.sql (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed

branches/version-2_5-dev/html/install/sql/column_comment.sql

-                      r18787
+                      r18788
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_name','会社名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','company_kana','会社名（カナ）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax01','FAX番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax02','FAX番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','fax03','FAX番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','business_hour','店舗営業時間');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_company','販売業者(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_manager','運営責任者(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip01','郵便番号1(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_zip02','郵便番号2(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_pref','都道府県(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr01','住所1(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_addr02','住所2(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel01','電話番号1(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel02','電話番号2(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_tel03','電話番号3(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax01','FAX番号1(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax02','FAX番号2(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_fax03','FAX番号3(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_email','メールアドレス(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_url','URL(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term01','商品代金以外の必要料金(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term02','注文方法(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term03','支払方法(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term04','支払期限(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term05','引き渡し時期(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term06','返品・交換について(特定商取引)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term07','予備');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term08','予備');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term09','予備');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','law_term10','予備');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax','消費税');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','tax_rule','1:四捨五入　2：切捨て　3:切り上げ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email01','受注情報受付メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email02','問い合わせ受付メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email03','送信エラー受付メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email04','メール送信元メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','email05','メルマガ送信元メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','free_rule','送料・手数料無料条件(円以上)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_name','店名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_kana','店名(カナ)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','shop_name_eng','店名(英語表記)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','point_rate','ポイント付与率');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','welcome_point','会員登録時付与ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','top_tpl','topのテンプレートファイル番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','product_tpl','商品一覧のテンプレートファイル番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','detail_tpl','商品詳細のテンプレートファイル番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','mypage_tpl','MYページのテンプレートファイル番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','downloadable_days','ダウンロード可能日数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_baseinfo','downloadable_days_unlimited','ダウンロード可能日数制限（1:日数制限無し)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','deliv_id','配送業者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','name','配送業者名（ヤマト運輸）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','service_name','名称（クロネコヤマト）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','confirm_url','伝票確認URL');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','status','1:有効 2:無効');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','del_flg','0:既定 1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','creator_id','作成者の管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','お届け時間ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','お届け時間');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee','配送料金');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_id','支払いID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_method','支払い方法');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','charge','手数料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rule','利用条件(円以上)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','deliv_id','指定無しの場合:0(配送業者）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','note','備考');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','fix','固定:1　自由設定:2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','status','1:有効 2:無効');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','del_flg','0:既定 1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','payment_image','支払い方法表示用ロゴ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_payment','upper_rule','利用条件(円以下)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','template_id','テンプレートID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','subject','メールタイトル');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','header','ヘッダー文書');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','footer','フッター文書');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','creator_id','作成した管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','del_flg','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailtemplate','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','template_id','テンプレートID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','subject','件名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','charge_image','メール担当写真');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','mail_method','1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','header','ヘッダーテキスト');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','body','本文（テキスト登録用）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_title','メインのタイトル（HTMLメール専用）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_comment','メインのコメント（HTMLメール専用）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','main_product_id','メインの商品ID（HTMLメール専用）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_title','サブタイトル');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_comment','サブコメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id01','サブ商品ID1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id02','サブ商品ID2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id03','サブ商品ID3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id04','サブ商品ID4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id05','サブ商品ID5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id06','サブ商品ID6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id07','サブ商品ID7');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id08','サブ商品ID8');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id09','サブ商品ID9');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id10','サブ商品ID10');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id11','サブ商品ID11');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','sub_product_id12','サブ商品ID12');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','del_flg','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mailmaga_template','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_id','配信ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','mail_method','1:テキスト 2:HTML');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','subject','メール件名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','body','メール内容');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','send_count','送信数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','complete_count','送信完了数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','start_date','送信開始');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','end_date','送信停止');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','search_data','検索条件');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','del_flg','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_history','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','customer_id','顧客ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_id','配信履歴ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','email','送信先メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','name','名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_send_customer','send_flag','1:送信済み　2:送信失敗');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','name','商品名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_fee','商品送料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sale_limit','購入制限数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','category_id','商品カテゴリー');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','rank','表示ランク');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','status','1:表示、2:非表示、3:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','product_flag','"1:NEW 2:お勧め 3:注目 4:限定"');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','point_rate','ポイント付与率');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment1','コメント1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment2','コメント2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment3','コメント3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment4','コメント4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment5','コメント5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','comment6','コメント6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file1','アップロードファイル1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file2','アップロードファイル2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file3','アップロードファイル3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file4','アップロードファイル4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file5','アップロードファイル5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','file6','アップロードファイル6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_comment','メイン一覧コメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_list_image','メイン一覧画像');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_comment','メインコメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_image','メイン画像');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','main_large_image','メイン拡大画像');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title1','サブタイトル1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment1','サブコメント1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image1','サブ通常画像1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image1','サブ拡大画像1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title2','サブタイトル2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment2','サブコメント2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image2','サブ通常画像2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image2','サブ拡大画像2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title3','サブタイトル3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment3','サブコメント3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image3','サブ通常画像3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image3','サブ拡大画像3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title4','サブタイトル4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment4','サブコメント4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image4','サブ通常画像4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image4','サブ拡大画像4');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title5','サブタイトル5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment5','サブコメント5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image5','サブ通常画像5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image5','サブ拡大画像5');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_title6','サブタイトル6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_comment6','サブコメント6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_image6','サブ通常画像6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','sub_large_image6','サブ拡大画像6');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','del_flg','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products','deliv_date_id','発送日目安(conf.php参照)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_class_id','商品規格ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id1','規格分類ID1(規格なしの場合0)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','classcategory_id2','規格分類ID2（規格なしの場合:0)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','product_code','商品コード');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock','在庫数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','stock_unlimited','在庫制限（1:無制限)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','sale_limit','販売制限');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price01','通常価格');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','price02','販売価格');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','status','状態（表示:1、非表示:2）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_products_class','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','class_id','規格ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','name','規格名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','status','状態');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_class','product_id','null：マスタ登録データ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','classcategory_id','規格分類ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','name','規格分類名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','class_id','規格ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','status','状態');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_classcategory','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_id','分類ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','category_name','分類名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','parent_category_id','rootの場合:0');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','level','階層');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','creator_id','作成者の管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_order','購入件数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','member','会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','nonmember','非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men','男性');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women','女性');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_member','男性会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','men_nonmember','男性非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_member','女性会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','women_nonmember','女性非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total','購入合計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','total_average','購入平均');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','order_date','購入日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','create_date','集計日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','year','年');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','month','月');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','day','日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','wday','曜日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_day','日別用キー');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_month','月別用キー');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_year','年別用キー');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily','key_wday','曜日別用キー');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_order','購入件数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','member','会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','nonmember','非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men','男性');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women','女性');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_member','男性会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','men_nonmember','男性非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_member','女性会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','women_nonmember','女性非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total','購入合計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','total_average','購入平均');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','hour','購入時間');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','order_date','購入日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_order_daily_hour','create_date','集計日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','recommend_product_id','リコメンド商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','comment','コメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','status','0:手動登録、1:自動登録');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_recommend_products','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','review_id','レビューID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_name','投稿者名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','reviewer_url','投稿者URL');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','sex','男性:1、女性:2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','customer_id','会員ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','recommend_level','おすすめレベル');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','title','題名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','comment','コメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','status','1:表示 2:非表示 3:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','creator_id','作成者の管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_review','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','reading_product_id','閲覧商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','customer_id','会員ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_reading','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','category_id','分類ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','product_count','商品数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_count','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','category_id','分類ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','product_count','商品数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_category_total_count','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_id','新着ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_date','表示日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_comment','コメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','news_url','URL');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','link_method','1:内部リンク 2:外部リンク（別ウィンドウで）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_news','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','best_id','注文ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','category_id','カテゴリID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','rank','順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','title','見出し');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','comment','コメント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','creator_id','作成者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_best_products','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_id','送信ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','order_id','注文番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','send_date','送信日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','template_id','メールテンプレートID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','creator_id','管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','subject','件名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_mail_history','mail_body','本文');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','customer_id','顧客ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name01','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','name02','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana01','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','kana02','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email','メール');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','email_mobile','携帯メール');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax01','FAX1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax02','FAX2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','fax03','FAX3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','sex','1:男　2:女');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','job','職業');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','birth','誕生日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','password','パスワード');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder','パスワード質問');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','reminder_answer','パスワード答え');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','secret_key','暗号化顧客ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','first_buy_date','初回購入');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','last_buy_date','最終購入');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_times','購入回数');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','buy_total','購入累計金額');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','point','ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','note','SHOPメモ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','status','1:仮登録 2:登録 3:停止 4:非会員');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell01','携帯電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell02','携帯電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','cell03','携帯電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer','mobile_phone_id','携帯端末ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','email','メールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','mail_flag','1:HTML 2:TEXT 3:希望しない(停止)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','temp_id','一時ＩＤ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','end_flag','0:未処理 1:処理済');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','update_date','更新日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_customer_mail_temp','create_data','作成日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_id','注文番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_temp_id','注文一時ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','customer_id','顧客ID(非会員の場合は、0)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','message','要望等');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name01','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_name02','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana01','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_kana02','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_email','受注時のメールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax01','FAX1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax02','FAX2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_fax03','FAX3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_sex','性別(1:男性、2:女性)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax01','FAX1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax02','FAX2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fax03','FAX3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','subtotal','小計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','discount','値引き');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_fee','送料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','charge','手数料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','use_point','使用ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','add_point','加算ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','birth_point','お誕生日ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','tax','税金');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','total','合計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_total','お支払い合計(ポイント差し引き合計)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_id','支払い方法ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','お届け時間ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','お届け時間');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','loan_result','ローン受付結果');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_result','クレジット受付結果');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','credit_msg','クレジット受付メッセージ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','お届け日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell02','携帯電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell03','携帯電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_temp_id','注文一時ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','customer_id','顧客ID(非会員の場合は、0)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','message','要望等');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name01','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_name02','顧客名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana01','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_kana02','顧客名カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_email','受注時のメールアドレス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax01','FAX1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax02','FAX2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_fax03','FAX3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_sex','性別(1:男性、2:女性)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax01','FAX1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax02','FAX2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fax03','FAX3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','subtotal','小計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','discount','値引き');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_fee','送料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','charge','手数料');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','use_point','使用ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','add_point','加算ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','birth_point','お誕生日ポイント');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','tax','税金');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','total','合計');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_total','お支払い合計(ポイント差し引き合計)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_id','支払い方法ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法（文字列）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','お届け時間ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','お届け時間（文字列）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','mail_flag','メルマガ希望');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','status','1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_check','1:別のお届け先を指定している場合');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','point_check','1:ポイントを使用する。2:ポイントを使用しない。');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','loan_result','ローン受付結果');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_result','クレジット受付結果');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','credit_msg','クレジット受付メッセージ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','お届け日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell02','携帯電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell03','携帯電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','お届け先名前');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','お届け先カナ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','pref','都道府県');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr01','住所1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','addr02','住所2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel01','電話番号1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel02','電話番号2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','tel03','電話番号3');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','order_id','注文番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_id','商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id1','規格分類ID1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_id2','規格分類ID2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_name','商品名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','product_code','商品コード');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name1','規格名1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','classcategory_name2','規格名2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','price','価格');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','quantity','数量');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_detail','point_rate','ポイント付与率');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_id','都道府県ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','pref_name','都道府県名');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('mtb_pref','rank','表示順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','member_id','管理者ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','name','管理者名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','department','部門');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_id','ログインID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','password','パスワード');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','authority','権限');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','rank','順位');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','work','稼働:1、非稼働:2');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','del_flg','削除フラグ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','creator_id','作成者');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','update_date','更新日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','create_date','作成日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_member','login_date','ログイン日');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','product_id','この商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','relate_product_id','こんな商品ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','customer_id','顧客ID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bat_relate_products','create_date','集計日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_id','ページID 0はプレビュー用データ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','page_name','ページ名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','url','ページURL PKEY1');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','php_dir','PHPファイル保存先');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','tpl_dir','テンプレートファイル保存先');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','filename','ファイル名（拡張子なし）');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','header_chk','ヘッダー使用チェック　1：使用、2：未使用');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','footer_chk','フッター使用チェック　1：使用、2：未使用');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','edit_flg','削除、ページ名称、URL等を編集可能か否かのFLG　1：編集可、2：編集不可');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','author','メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','description','メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','keyword','メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_url','このデータに対して更新を行ったページ');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_pagelayout','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_id','ブロックID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','bloc_name','ブロック名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','tpl_path','テンプレートファイルのパス');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','filename','ファイル名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_bloc','php_path','include PHPで使用する場合にはphpのパスも保存する');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','page_id','ページID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','target_id','ターゲットID 1：レフトナビ 2：ライトナビ 3：イン画面上部 4：メイン画面下部');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_id','ブロックID');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_blocposition','bloc_row','ブロックIDを配置する順番');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','no','連番');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','csv_id','CSVID　1.商品マスタ、2.顧客マスタ、3.受注');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','col','出力カラム');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','disp_name','出力名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','rank','出力順序');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','status','出力有無 1.出力、2.未出力');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','create_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv','update_date','更新日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql_id','SQL番号');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','name','名称');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','sql','SQL文');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','update_date','作成日時');
+INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_csv_sql','create_date','更新日時');
+INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_ext_session_id', 'セッションID管理');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'session_id', 'セッションID');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_key', 'パラメータ名');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'param_value', 'パラメータ値');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'url', 'URL');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_ext_session_id', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (table_name, description) VALUES ('dtb_mobile_kara_mail', '空メール管理');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'kara_mail_id', '空メール管理ID');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'session_id', 'セッションID');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'token', 'トークン');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'next_url', '次ページURL');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'email', 'メールアドレス');
+INSERT INTO dtb_table_comment (table_name, column_name, description) VALUES ('dtb_mobile_kara_mail', 'receive_date', '受信日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (1, 'dtb_baseinfo', 'company_name', '会社名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (2, 'dtb_baseinfo', 'company_kana', '会社名（カナ）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (3, 'dtb_baseinfo', 'zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (4, 'dtb_baseinfo', 'zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (5, 'dtb_baseinfo', 'pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (6, 'dtb_baseinfo', 'addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (7, 'dtb_baseinfo', 'addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (8, 'dtb_baseinfo', 'tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (9, 'dtb_baseinfo', 'tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (10, 'dtb_baseinfo', 'tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (11, 'dtb_baseinfo', 'fax01', 'FAX番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (12, 'dtb_baseinfo', 'fax02', 'FAX番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (13, 'dtb_baseinfo', 'fax03', 'FAX番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (14, 'dtb_baseinfo', 'business_hour', '店舗営業時間');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (15, 'dtb_baseinfo', 'law_company', '販売業者(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (16, 'dtb_baseinfo', 'law_manager', '運営責任者(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (17, 'dtb_baseinfo', 'law_zip01', '郵便番号1(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (18, 'dtb_baseinfo', 'law_zip02', '郵便番号2(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (19, 'dtb_baseinfo', 'law_pref', '都道府県(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (20, 'dtb_baseinfo', 'law_addr01', '住所1(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (21, 'dtb_baseinfo', 'law_addr02', '住所2(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (22, 'dtb_baseinfo', 'law_tel01', '電話番号1(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (23, 'dtb_baseinfo', 'law_tel02', '電話番号2(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (24, 'dtb_baseinfo', 'law_tel03', '電話番号3(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (25, 'dtb_baseinfo', 'law_fax01', 'FAX番号1(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (26, 'dtb_baseinfo', 'law_fax02', 'FAX番号2(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (27, 'dtb_baseinfo', 'law_fax03', 'FAX番号3(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (28, 'dtb_baseinfo', 'law_email', 'メールアドレス(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (29, 'dtb_baseinfo', 'law_url', 'URL(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (30, 'dtb_baseinfo', 'law_term01', '商品代金以外の必要料金(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (31, 'dtb_baseinfo', 'law_term02', '注文方法(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (32, 'dtb_baseinfo', 'law_term03', '支払方法(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (33, 'dtb_baseinfo', 'law_term04', '支払期限(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (34, 'dtb_baseinfo', 'law_term05', '引き渡し時期(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (35, 'dtb_baseinfo', 'law_term06', '返品・交換について(特定商取引)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (36, 'dtb_baseinfo', 'law_term07', '予備');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (37, 'dtb_baseinfo', 'law_term08', '予備');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (38, 'dtb_baseinfo', 'law_term09', '予備');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (39, 'dtb_baseinfo', 'law_term10', '予備');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (40, 'dtb_baseinfo', 'tax', '消費税');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (41, 'dtb_baseinfo', 'tax_rule', '1:四捨五入　2：切捨て　3:切り上げ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (42, 'dtb_baseinfo', 'email01', '受注情報受付メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (43, 'dtb_baseinfo', 'email02', '問い合わせ受付メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (44, 'dtb_baseinfo', 'email03', '送信エラー受付メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (45, 'dtb_baseinfo', 'email04', 'メール送信元メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (46, 'dtb_baseinfo', 'email05', 'メルマガ送信元メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (47, 'dtb_baseinfo', 'free_rule', '送料・手数料無料条件(円以上)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (48, 'dtb_baseinfo', 'shop_name', '店名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (49, 'dtb_baseinfo', 'shop_kana', '店名(カナ)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (50, 'dtb_baseinfo', 'shop_name_eng', '店名(英語表記)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (51, 'dtb_baseinfo', 'point_rate', 'ポイント付与率');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (52, 'dtb_baseinfo', 'welcome_point', '会員登録時付与ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (53, 'dtb_baseinfo', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (54, 'dtb_baseinfo', 'top_tpl', 'topのテンプレートファイル番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (55, 'dtb_baseinfo', 'product_tpl', '商品一覧のテンプレートファイル番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (56, 'dtb_baseinfo', 'detail_tpl', '商品詳細のテンプレートファイル番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (57, 'dtb_baseinfo', 'mypage_tpl', 'MYページのテンプレートファイル番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (58, 'dtb_baseinfo', 'downloadable_days', 'ダウンロード可能日数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (59, 'dtb_baseinfo', 'downloadable_days_unlimited', 'ダウンロード可能日数制限（1:日数制限無し)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (60, 'dtb_deliv', 'deliv_id', '配送業者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (61, 'dtb_deliv', 'name', '配送業者名（ヤマト運輸）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (62, 'dtb_deliv', 'service_name', '名称（クロネコヤマト）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (63, 'dtb_deliv', 'confirm_url', '伝票確認URL');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (64, 'dtb_deliv', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (65, 'dtb_deliv', 'status', '1:有効 2:無効');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (66, 'dtb_deliv', 'del_flg', '0:既定 1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (67, 'dtb_deliv', 'creator_id', '作成者の管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (68, 'dtb_deliv', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (69, 'dtb_deliv', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (70, 'dtb_delivtime', 'deliv_id', '配送ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (71, 'dtb_delivtime', 'time_id', 'お届け時間ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (72, 'dtb_delivtime', 'time', 'お届け時間');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (73, 'dtb_delivfee', 'deliv_id', '配送ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (74, 'dtb_delivfee', 'fee_id', '配送料金ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (75, 'dtb_delivfee', 'fee', '配送料金');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (76, 'dtb_payment', 'payment_id', '支払いID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (77, 'dtb_payment', 'payment_method', '支払い方法');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (78, 'dtb_payment', 'charge', '手数料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (79, 'dtb_payment', 'rule', '利用条件(円以上)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (80, 'dtb_payment', 'deliv_id', '指定無しの場合:0(配送業者）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (81, 'dtb_payment', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (82, 'dtb_payment', 'note', '備考');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (83, 'dtb_payment', 'fix', '固定:1　自由設定:2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (84, 'dtb_payment', 'status', '1:有効 2:無効');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (85, 'dtb_payment', 'del_flg', '0:既定 1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (86, 'dtb_payment', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (87, 'dtb_payment', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (88, 'dtb_payment', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (89, 'dtb_payment', 'payment_image', '支払い方法表示用ロゴ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (90, 'dtb_payment', 'upper_rule', '利用条件(円以下)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (91, 'dtb_mailtemplate', 'template_id', 'テンプレートID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (92, 'dtb_mailtemplate', 'subject', 'メールタイトル');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (93, 'dtb_mailtemplate', 'header', 'ヘッダー文書');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (94, 'dtb_mailtemplate', 'footer', 'フッター文書');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (95, 'dtb_mailtemplate', 'creator_id', '作成した管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (96, 'dtb_mailtemplate', 'del_flg', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (97, 'dtb_mailtemplate', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (98, 'dtb_mailtemplate', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (99, 'dtb_mailmaga_template', 'template_id', 'テンプレートID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (414, 'dtb_order', 'deliv_pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (100, 'dtb_mailmaga_template', 'subject', '件名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (101, 'dtb_mailmaga_template', 'charge_image', 'メール担当写真');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (102, 'dtb_mailmaga_template', 'mail_method', '1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (103, 'dtb_mailmaga_template', 'header', 'ヘッダーテキスト');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (104, 'dtb_mailmaga_template', 'body', '本文（テキスト登録用）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (105, 'dtb_mailmaga_template', 'main_title', 'メインのタイトル（HTMLメール専用）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (106, 'dtb_mailmaga_template', 'main_comment', 'メインのコメント（HTMLメール専用）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (107, 'dtb_mailmaga_template', 'main_product_id', 'メインの商品ID（HTMLメール専用）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (108, 'dtb_mailmaga_template', 'sub_title', 'サブタイトル');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (109, 'dtb_mailmaga_template', 'sub_comment', 'サブコメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (110, 'dtb_mailmaga_template', 'sub_product_id01', 'サブ商品ID1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (111, 'dtb_mailmaga_template', 'sub_product_id02', 'サブ商品ID2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (112, 'dtb_mailmaga_template', 'sub_product_id03', 'サブ商品ID3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (113, 'dtb_mailmaga_template', 'sub_product_id04', 'サブ商品ID4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (114, 'dtb_mailmaga_template', 'sub_product_id05', 'サブ商品ID5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (115, 'dtb_mailmaga_template', 'sub_product_id06', 'サブ商品ID6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (116, 'dtb_mailmaga_template', 'sub_product_id07', 'サブ商品ID7');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (117, 'dtb_mailmaga_template', 'sub_product_id08', 'サブ商品ID8');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (118, 'dtb_mailmaga_template', 'sub_product_id09', 'サブ商品ID9');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (119, 'dtb_mailmaga_template', 'sub_product_id10', 'サブ商品ID10');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (120, 'dtb_mailmaga_template', 'sub_product_id11', 'サブ商品ID11');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (121, 'dtb_mailmaga_template', 'sub_product_id12', 'サブ商品ID12');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (122, 'dtb_mailmaga_template', 'del_flg', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (123, 'dtb_mailmaga_template', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (124, 'dtb_mailmaga_template', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (125, 'dtb_mailmaga_template', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (126, 'dtb_send_history', 'send_id', '配信ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (127, 'dtb_send_history', 'mail_method', '1:テキスト 2:HTML');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (128, 'dtb_send_history', 'subject', 'メール件名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (129, 'dtb_send_history', 'body', 'メール内容');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (130, 'dtb_send_history', 'send_count', '送信数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (131, 'dtb_send_history', 'complete_count', '送信完了数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (132, 'dtb_send_history', 'start_date', '送信開始');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (133, 'dtb_send_history', 'end_date', '送信停止');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (134, 'dtb_send_history', 'search_data', '検索条件');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (135, 'dtb_send_history', 'del_flg', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (136, 'dtb_send_history', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (137, 'dtb_send_history', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (138, 'dtb_send_history', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (139, 'dtb_send_customer', 'customer_id', '顧客ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (140, 'dtb_send_customer', 'send_id', '配信履歴ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (141, 'dtb_send_customer', 'email', '送信先メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (142, 'dtb_send_customer', 'name', '名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (143, 'dtb_send_customer', 'send_flag', '1:送信済み　2:送信失敗');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (144, 'dtb_products', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (145, 'dtb_products', 'name', '商品名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (146, 'dtb_products', 'deliv_fee', '商品送料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (147, 'dtb_products', 'sale_limit', '購入制限数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (148, 'dtb_products', 'category_id', '商品カテゴリー');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (149, 'dtb_products', 'rank', '表示ランク');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (150, 'dtb_products', 'status', '1:表示、2:非表示、3:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (151, 'dtb_products', 'product_flag', '"1:NEW 2:お勧め 3:注目 4:限定"');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (152, 'dtb_products', 'point_rate', 'ポイント付与率');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (153, 'dtb_products', 'comment1', 'コメント1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (154, 'dtb_products', 'comment2', 'コメント2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (155, 'dtb_products', 'comment3', 'コメント3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (156, 'dtb_products', 'comment4', 'コメント4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (157, 'dtb_products', 'comment5', 'コメント5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (158, 'dtb_products', 'comment6', 'コメント6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (159, 'dtb_products', 'file1', 'アップロードファイル1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (160, 'dtb_products', 'file2', 'アップロードファイル2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (161, 'dtb_products', 'file3', 'アップロードファイル3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (162, 'dtb_products', 'file4', 'アップロードファイル4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (163, 'dtb_products', 'file5', 'アップロードファイル5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (164, 'dtb_products', 'file6', 'アップロードファイル6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (165, 'dtb_products', 'main_list_comment', 'メイン一覧コメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (166, 'dtb_products', 'main_list_image', 'メイン一覧画像');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (167, 'dtb_products', 'main_comment', 'メインコメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (168, 'dtb_products', 'main_image', 'メイン画像');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (169, 'dtb_products', 'main_large_image', 'メイン拡大画像');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (170, 'dtb_products', 'sub_title1', 'サブタイトル1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (171, 'dtb_products', 'sub_comment1', 'サブコメント1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (172, 'dtb_products', 'sub_image1', 'サブ通常画像1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (173, 'dtb_products', 'sub_large_image1', 'サブ拡大画像1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (174, 'dtb_products', 'sub_title2', 'サブタイトル2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (175, 'dtb_products', 'sub_comment2', 'サブコメント2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (176, 'dtb_products', 'sub_image2', 'サブ通常画像2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (177, 'dtb_products', 'sub_large_image2', 'サブ拡大画像2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (178, 'dtb_products', 'sub_title3', 'サブタイトル3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (179, 'dtb_products', 'sub_comment3', 'サブコメント3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (180, 'dtb_products', 'sub_image3', 'サブ通常画像3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (181, 'dtb_products', 'sub_large_image3', 'サブ拡大画像3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (182, 'dtb_products', 'sub_title4', 'サブタイトル4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (183, 'dtb_products', 'sub_comment4', 'サブコメント4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (184, 'dtb_products', 'sub_image4', 'サブ通常画像4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (185, 'dtb_products', 'sub_large_image4', 'サブ拡大画像4');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (186, 'dtb_products', 'sub_title5', 'サブタイトル5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (187, 'dtb_products', 'sub_comment5', 'サブコメント5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (188, 'dtb_products', 'sub_image5', 'サブ通常画像5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (189, 'dtb_products', 'sub_large_image5', 'サブ拡大画像5');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (190, 'dtb_products', 'sub_title6', 'サブタイトル6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (191, 'dtb_products', 'sub_comment6', 'サブコメント6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (192, 'dtb_products', 'sub_image6', 'サブ通常画像6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (193, 'dtb_products', 'sub_large_image6', 'サブ拡大画像6');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (194, 'dtb_products', 'del_flg', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (195, 'dtb_products', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (196, 'dtb_products', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (197, 'dtb_products', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (198, 'dtb_products', 'deliv_date_id', '発送日目安(conf.php参照)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (199, 'dtb_products_class', 'product_class_id', '商品規格ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (200, 'dtb_products_class', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (201, 'dtb_products_class', 'classcategory_id1', '規格分類ID1(規格なしの場合0)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (202, 'dtb_products_class', 'classcategory_id2', '規格分類ID2（規格なしの場合:0)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (203, 'dtb_products_class', 'product_code', '商品コード');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (204, 'dtb_products_class', 'stock', '在庫数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (205, 'dtb_products_class', 'stock_unlimited', '在庫制限（1:無制限)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (206, 'dtb_products_class', 'sale_limit', '販売制限');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (207, 'dtb_products_class', 'price01', '通常価格');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (208, 'dtb_products_class', 'price02', '販売価格');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (209, 'dtb_products_class', 'status', '状態（表示:1、非表示:2）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (210, 'dtb_products_class', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (211, 'dtb_products_class', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (212, 'dtb_products_class', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (213, 'dtb_class', 'class_id', '規格ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (214, 'dtb_class', 'name', '規格名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (215, 'dtb_class', 'status', '状態');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (216, 'dtb_class', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (217, 'dtb_class', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (218, 'dtb_class', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (219, 'dtb_class', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (220, 'dtb_class', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (221, 'dtb_class', 'product_id', 'null：マスタ登録データ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (222, 'dtb_classcategory', 'classcategory_id', '規格分類ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (223, 'dtb_classcategory', 'name', '規格分類名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (224, 'dtb_classcategory', 'class_id', '規格ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (225, 'dtb_classcategory', 'status', '状態');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (226, 'dtb_classcategory', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (227, 'dtb_classcategory', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (228, 'dtb_classcategory', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (229, 'dtb_classcategory', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (230, 'dtb_classcategory', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (231, 'dtb_category', 'category_id', '分類ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (232, 'dtb_category', 'category_name', '分類名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (233, 'dtb_category', 'parent_category_id', 'rootの場合:0');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (234, 'dtb_category', 'level', '階層');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (235, 'dtb_category', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (236, 'dtb_category', 'creator_id', '作成者の管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (237, 'dtb_category', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (238, 'dtb_category', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (239, 'dtb_category', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (240, 'dtb_bat_order_daily', 'total_order', '購入件数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (241, 'dtb_bat_order_daily', 'member', '会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (242, 'dtb_bat_order_daily', 'nonmember', '非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (243, 'dtb_bat_order_daily', 'men', '男性');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (244, 'dtb_bat_order_daily', 'women', '女性');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (245, 'dtb_bat_order_daily', 'men_member', '男性会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (246, 'dtb_bat_order_daily', 'men_nonmember', '男性非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (247, 'dtb_bat_order_daily', 'women_member', '女性会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (248, 'dtb_bat_order_daily', 'women_nonmember', '女性非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (249, 'dtb_bat_order_daily', 'total', '購入合計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (250, 'dtb_bat_order_daily', 'total_average', '購入平均');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (251, 'dtb_bat_order_daily', 'order_date', '購入日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (252, 'dtb_bat_order_daily', 'create_date', '集計日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (253, 'dtb_bat_order_daily', 'year', '年');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (254, 'dtb_bat_order_daily', 'month', '月');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (255, 'dtb_bat_order_daily', 'day', '日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (256, 'dtb_bat_order_daily', 'wday', '曜日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (257, 'dtb_bat_order_daily', 'key_day', '日別用キー');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (258, 'dtb_bat_order_daily', 'key_month', '月別用キー');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (259, 'dtb_bat_order_daily', 'key_year', '年別用キー');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (260, 'dtb_bat_order_daily', 'key_wday', '曜日別用キー');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (261, 'dtb_bat_order_daily_hour', 'total_order', '購入件数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (262, 'dtb_bat_order_daily_hour', 'member', '会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (263, 'dtb_bat_order_daily_hour', 'nonmember', '非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (264, 'dtb_bat_order_daily_hour', 'men', '男性');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (265, 'dtb_bat_order_daily_hour', 'women', '女性');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (266, 'dtb_bat_order_daily_hour', 'men_member', '男性会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (267, 'dtb_bat_order_daily_hour', 'men_nonmember', '男性非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (268, 'dtb_bat_order_daily_hour', 'women_member', '女性会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (269, 'dtb_bat_order_daily_hour', 'women_nonmember', '女性非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (270, 'dtb_bat_order_daily_hour', 'total', '購入合計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (271, 'dtb_bat_order_daily_hour', 'total_average', '購入平均');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (272, 'dtb_bat_order_daily_hour', 'hour', '購入時間');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (273, 'dtb_bat_order_daily_hour', 'order_date', '購入日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (274, 'dtb_bat_order_daily_hour', 'create_date', '集計日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (275, 'dtb_recommend_products', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (276, 'dtb_recommend_products', 'recommend_product_id', 'リコメンド商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (277, 'dtb_recommend_products', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (278, 'dtb_recommend_products', 'comment', 'コメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (279, 'dtb_recommend_products', 'status', '0:手動登録、1:自動登録');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (280, 'dtb_recommend_products', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (281, 'dtb_recommend_products', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (282, 'dtb_recommend_products', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (283, 'dtb_review', 'review_id', 'レビューID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (284, 'dtb_review', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (285, 'dtb_review', 'reviewer_name', '投稿者名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (286, 'dtb_review', 'reviewer_url', '投稿者URL');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (287, 'dtb_review', 'sex', '男性:1、女性:2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (288, 'dtb_review', 'customer_id', '会員ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (289, 'dtb_review', 'recommend_level', 'おすすめレベル');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (290, 'dtb_review', 'title', '題名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (291, 'dtb_review', 'comment', 'コメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (292, 'dtb_review', 'status', '1:表示 2:非表示 3:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (293, 'dtb_review', 'creator_id', '作成者の管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (294, 'dtb_review', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (295, 'dtb_review', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (296, 'dtb_review', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (297, 'dtb_customer_reading', 'reading_product_id', '閲覧商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (298, 'dtb_customer_reading', 'customer_id', '会員ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (299, 'dtb_customer_reading', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (300, 'dtb_customer_reading', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (301, 'dtb_category_count', 'category_id', '分類ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (415, 'dtb_order', 'deliv_addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (302, 'dtb_category_count', 'product_count', '商品数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (303, 'dtb_category_count', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (304, 'dtb_category_total_count', 'category_id', '分類ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (305, 'dtb_category_total_count', 'product_count', '商品数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (306, 'dtb_category_total_count', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (307, 'dtb_news', 'news_id', '新着ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (308, 'dtb_news', 'news_date', '表示日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (309, 'dtb_news', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (310, 'dtb_news', 'news_comment', 'コメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (311, 'dtb_news', 'news_url', 'URL');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (312, 'dtb_news', 'link_method', '1:内部リンク 2:外部リンク（別ウィンドウで）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (313, 'dtb_news', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (314, 'dtb_news', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (315, 'dtb_news', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (316, 'dtb_news', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (317, 'dtb_best_products', 'best_id', '注文ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (318, 'dtb_best_products', 'category_id', 'カテゴリID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (319, 'dtb_best_products', 'rank', '順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (320, 'dtb_best_products', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (321, 'dtb_best_products', 'title', '見出し');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (322, 'dtb_best_products', 'comment', 'コメント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (323, 'dtb_best_products', 'creator_id', '作成者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (324, 'dtb_best_products', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (325, 'dtb_best_products', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (326, 'dtb_best_products', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (327, 'dtb_mail_history', 'send_id', '送信ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (328, 'dtb_mail_history', 'order_id', '注文番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (329, 'dtb_mail_history', 'send_date', '送信日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (330, 'dtb_mail_history', 'template_id', 'メールテンプレートID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (331, 'dtb_mail_history', 'creator_id', '管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (332, 'dtb_mail_history', 'subject', '件名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (333, 'dtb_mail_history', 'mail_body', '本文');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (334, 'dtb_customer', 'customer_id', '顧客ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (335, 'dtb_customer', 'name01', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (336, 'dtb_customer', 'name02', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (337, 'dtb_customer', 'kana01', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (338, 'dtb_customer', 'kana02', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (339, 'dtb_customer', 'zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (340, 'dtb_customer', 'zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (341, 'dtb_customer', 'pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (342, 'dtb_customer', 'addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (343, 'dtb_customer', 'addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (344, 'dtb_customer', 'email', 'メール');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (345, 'dtb_customer', 'email_mobile', '携帯メール');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (346, 'dtb_customer', 'tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (347, 'dtb_customer', 'tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (348, 'dtb_customer', 'tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (349, 'dtb_customer', 'fax01', 'FAX1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (350, 'dtb_customer', 'fax02', 'FAX2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (351, 'dtb_customer', 'fax03', 'FAX3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (352, 'dtb_customer', 'sex', '1:男　2:女');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (353, 'dtb_customer', 'job', '職業');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (354, 'dtb_customer', 'birth', '誕生日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (355, 'dtb_customer', 'password', 'パスワード');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (356, 'dtb_customer', 'reminder', 'パスワード質問');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (357, 'dtb_customer', 'reminder_answer', 'パスワード答え');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (358, 'dtb_customer', 'secret_key', '暗号化顧客ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (359, 'dtb_customer', 'first_buy_date', '初回購入');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (360, 'dtb_customer', 'last_buy_date', '最終購入');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (361, 'dtb_customer', 'buy_times', '購入回数');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (362, 'dtb_customer', 'buy_total', '購入累計金額');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (363, 'dtb_customer', 'point', 'ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (364, 'dtb_customer', 'note', 'SHOPメモ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (365, 'dtb_customer', 'status', '1:仮登録 2:登録 3:停止 4:非会員');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (366, 'dtb_customer', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (367, 'dtb_customer', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (368, 'dtb_customer', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (369, 'dtb_customer', 'cell01', '携帯電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (370, 'dtb_customer', 'cell02', '携帯電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (371, 'dtb_customer', 'cell03', '携帯電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (372, 'dtb_customer', 'mobile_phone_id', '携帯端末ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (373, 'dtb_customer_mail_temp', 'email', 'メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (374, 'dtb_customer_mail_temp', 'mail_flag', '1:HTML 2:TEXT 3:希望しない(停止)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (375, 'dtb_customer_mail_temp', 'temp_id', '一時ＩＤ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (376, 'dtb_customer_mail_temp', 'end_flag', '0:未処理 1:処理済');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (377, 'dtb_customer_mail_temp', 'update_date', '更新日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (378, 'dtb_customer_mail_temp', 'create_data', '作成日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (379, 'dtb_order', 'order_id', '注文番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (380, 'dtb_order', 'order_temp_id', '注文一時ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (381, 'dtb_order', 'customer_id', '顧客ID(非会員の場合は、0)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (382, 'dtb_order', 'message', '要望等');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (383, 'dtb_order', 'order_name01', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (384, 'dtb_order', 'order_name02', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (385, 'dtb_order', 'order_kana01', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (386, 'dtb_order', 'order_kana02', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (387, 'dtb_order', 'order_email', '受注時のメールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (388, 'dtb_order', 'order_tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (389, 'dtb_order', 'order_tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (390, 'dtb_order', 'order_tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (391, 'dtb_order', 'order_fax01', 'FAX1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (392, 'dtb_order', 'order_fax02', 'FAX2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (393, 'dtb_order', 'order_fax03', 'FAX3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (394, 'dtb_order', 'order_zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (395, 'dtb_order', 'order_zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (396, 'dtb_order', 'order_pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (397, 'dtb_order', 'order_addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (398, 'dtb_order', 'order_addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (399, 'dtb_order', 'order_sex', '性別(1:男性、2:女性)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (400, 'dtb_order', 'order_birth', '生年月日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (401, 'dtb_order', 'order_job', '職種');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (402, 'dtb_order', 'deliv_name01', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (403, 'dtb_order', 'deliv_name02', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (404, 'dtb_order', 'deliv_kana01', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (405, 'dtb_order', 'deliv_kana02', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (406, 'dtb_order', 'deliv_tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (407, 'dtb_order', 'deliv_tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (408, 'dtb_order', 'deliv_tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (409, 'dtb_order', 'deliv_fax01', 'FAX1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (410, 'dtb_order', 'deliv_fax02', 'FAX2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (411, 'dtb_order', 'deliv_fax03', 'FAX3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (412, 'dtb_order', 'deliv_zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (413, 'dtb_order', 'deliv_zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (416, 'dtb_order', 'deliv_addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (417, 'dtb_order', 'subtotal', '小計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (418, 'dtb_order', 'discount', '値引き');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (419, 'dtb_order', 'deliv_fee', '送料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (420, 'dtb_order', 'charge', '手数料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (421, 'dtb_order', 'use_point', '使用ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (422, 'dtb_order', 'add_point', '加算ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (423, 'dtb_order', 'birth_point', 'お誕生日ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (424, 'dtb_order', 'tax', '税金');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (425, 'dtb_order', 'total', '合計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (426, 'dtb_order', 'payment_total', 'お支払い合計(ポイント差し引き合計)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (427, 'dtb_order', 'payment_id', '支払い方法ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (428, 'dtb_order', 'payment_method', '支払い方法');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (429, 'dtb_order', 'deliv_id', '配送業者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (430, 'dtb_order', 'deliv_time_id', 'お届け時間ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (431, 'dtb_order', 'deliv_time', 'お届け時間');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (432, 'dtb_order', 'deliv_no', '配送伝票番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (433, 'dtb_order', 'note', 'SHOPメモ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (434, 'dtb_order', 'status', '1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (435, 'dtb_order', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (436, 'dtb_order', 'loan_result', 'ローン受付結果');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (437, 'dtb_order', 'credit_result', 'クレジット受付結果');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (438, 'dtb_order', 'credit_msg', 'クレジット受付メッセージ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (439, 'dtb_order', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (440, 'dtb_order', 'commit_date', '発送済みステータスに変更した日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (441, 'dtb_order', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (442, 'dtb_order', 'deliv_date', 'お届け日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (443, 'dtb_order', 'conveni_data', 'コンビニ決済情報');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (444, 'dtb_order', 'cell01', '携帯電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (445, 'dtb_order', 'cell02', '携帯電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (446, 'dtb_order', 'cell03', '携帯電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (447, 'dtb_order_temp', 'order_temp_id', '注文一時ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (448, 'dtb_order_temp', 'customer_id', '顧客ID(非会員の場合は、0)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (449, 'dtb_order_temp', 'message', '要望等');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (450, 'dtb_order_temp', 'order_name01', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (451, 'dtb_order_temp', 'order_name02', '顧客名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (452, 'dtb_order_temp', 'order_kana01', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (453, 'dtb_order_temp', 'order_kana02', '顧客名カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (454, 'dtb_order_temp', 'order_email', '受注時のメールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (455, 'dtb_order_temp', 'order_tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (456, 'dtb_order_temp', 'order_tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (457, 'dtb_order_temp', 'order_tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (458, 'dtb_order_temp', 'order_fax01', 'FAX1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (459, 'dtb_order_temp', 'order_fax02', 'FAX2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (460, 'dtb_order_temp', 'order_fax03', 'FAX3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (461, 'dtb_order_temp', 'order_zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (462, 'dtb_order_temp', 'order_zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (463, 'dtb_order_temp', 'order_pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (464, 'dtb_order_temp', 'order_addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (465, 'dtb_order_temp', 'order_addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (466, 'dtb_order_temp', 'order_sex', '性別(1:男性、2:女性)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (467, 'dtb_order_temp', 'order_birth', '生年月日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (468, 'dtb_order_temp', 'order_job', '職種');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (469, 'dtb_order_temp', 'deliv_name01', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (470, 'dtb_order_temp', 'deliv_name02', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (471, 'dtb_order_temp', 'deliv_kana01', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (472, 'dtb_order_temp', 'deliv_kana02', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (473, 'dtb_order_temp', 'deliv_tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (474, 'dtb_order_temp', 'deliv_tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (475, 'dtb_order_temp', 'deliv_tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (476, 'dtb_order_temp', 'deliv_fax01', 'FAX1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (477, 'dtb_order_temp', 'deliv_fax02', 'FAX2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (478, 'dtb_order_temp', 'deliv_fax03', 'FAX3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (479, 'dtb_order_temp', 'deliv_zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (480, 'dtb_order_temp', 'deliv_zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (481, 'dtb_order_temp', 'deliv_pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (482, 'dtb_order_temp', 'deliv_addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (483, 'dtb_order_temp', 'deliv_addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (484, 'dtb_order_temp', 'subtotal', '小計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (485, 'dtb_order_temp', 'discount', '値引き');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (486, 'dtb_order_temp', 'deliv_fee', '送料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (487, 'dtb_order_temp', 'charge', '手数料');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (488, 'dtb_order_temp', 'use_point', '使用ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (489, 'dtb_order_temp', 'add_point', '加算ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (490, 'dtb_order_temp', 'birth_point', 'お誕生日ポイント');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (491, 'dtb_order_temp', 'tax', '税金');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (492, 'dtb_order_temp', 'total', '合計');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (493, 'dtb_order_temp', 'payment_total', 'お支払い合計(ポイント差し引き合計)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (494, 'dtb_order_temp', 'payment_id', '支払い方法ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (495, 'dtb_order_temp', 'payment_method', '支払い方法（文字列）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (496, 'dtb_order_temp', 'deliv_id', '配送業者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (497, 'dtb_order_temp', 'deliv_time_id', 'お届け時間ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (498, 'dtb_order_temp', 'deliv_time', 'お届け時間（文字列）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (499, 'dtb_order_temp', 'deliv_no', '配送伝票番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (500, 'dtb_order_temp', 'note', 'SHOPメモ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (501, 'dtb_order_temp', 'mail_flag', 'メルマガ希望');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (502, 'dtb_order_temp', 'status', '1:対応中 2:キャンセル 3:取り寄せ中 4:発送済み');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (503, 'dtb_order_temp', 'deliv_check', '1:別のお届け先を指定している場合');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (504, 'dtb_order_temp', 'point_check', '1:ポイントを使用する。2:ポイントを使用しない。');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (505, 'dtb_order_temp', 'loan_result', 'ローン受付結果');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (506, 'dtb_order_temp', 'credit_result', 'クレジット受付結果');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (507, 'dtb_order_temp', 'credit_msg', 'クレジット受付メッセージ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (508, 'dtb_order_temp', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (509, 'dtb_order_temp', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (510, 'dtb_order_temp', 'del_flg ', '0:既定、1:削除');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (511, 'dtb_order_temp', 'deliv_date', 'お届け日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (512, 'dtb_order_temp', 'conveni_data', 'コンビニ決済情報');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (513, 'dtb_order_temp', 'cell01', '携帯電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (514, 'dtb_order_temp', 'cell02', '携帯電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (515, 'dtb_order_temp', 'cell03', '携帯電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (516, 'dtb_other_deliv', 'other_deliv_id', '別のお届け先ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (517, 'dtb_other_deliv', 'customer_id', '顧客ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (518, 'dtb_other_deliv', 'name01', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (519, 'dtb_other_deliv', 'name02', 'お届け先名前');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (520, 'dtb_other_deliv', 'kana01', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (521, 'dtb_other_deliv', 'kana02', 'お届け先カナ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (522, 'dtb_other_deliv', 'zip01', '郵便番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (523, 'dtb_other_deliv', 'zip02', '郵便番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (524, 'dtb_other_deliv', 'pref', '都道府県');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (525, 'dtb_other_deliv', 'addr01', '住所1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (526, 'dtb_other_deliv', 'addr02', '住所2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (527, 'dtb_other_deliv', 'tel01', '電話番号1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (528, 'dtb_other_deliv', 'tel02', '電話番号2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (529, 'dtb_other_deliv', 'tel03', '電話番号3');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (530, 'dtb_order_detail', 'order_id', '注文番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (531, 'dtb_order_detail', 'product_id', '商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (532, 'dtb_order_detail', 'classcategory_id1', '規格分類ID1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (533, 'dtb_order_detail', 'classcategory_id2', '規格分類ID2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (534, 'dtb_order_detail', 'product_name', '商品名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (535, 'dtb_order_detail', 'product_code', '商品コード');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (536, 'dtb_order_detail', 'classcategory_name1', '規格名1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (537, 'dtb_order_detail', 'classcategory_name2', '規格名2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (538, 'dtb_order_detail', 'price', '価格');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (539, 'dtb_order_detail', 'quantity', '数量');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (540, 'dtb_order_detail', 'point_rate', 'ポイント付与率');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (541, 'mtb_pref', 'pref_id', '都道府県ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (542, 'mtb_pref', 'pref_name', '都道府県名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (543, 'mtb_pref', 'rank', '表示順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (544, 'dtb_member', 'member_id', '管理者ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (545, 'dtb_member', 'name', '管理者名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (546, 'dtb_member', 'department', '部門');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (547, 'dtb_member', 'login_id', 'ログインID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (548, 'dtb_member', 'password', 'パスワード');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (549, 'dtb_member', 'authority', '権限');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (550, 'dtb_member', 'rank', '順位');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (551, 'dtb_member', 'work', '稼働:1、非稼働:2');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (552, 'dtb_member', 'del_flg', '削除フラグ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (553, 'dtb_member', 'creator_id', '作成者');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (554, 'dtb_member', 'update_date', '更新日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (555, 'dtb_member', 'create_date', '作成日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (556, 'dtb_member', 'login_date', 'ログイン日');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (557, 'dtb_bat_relate_products', 'product_id', 'この商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (558, 'dtb_bat_relate_products', 'relate_product_id', 'こんな商品ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (559, 'dtb_bat_relate_products', 'customer_id', '顧客ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (560, 'dtb_bat_relate_products', 'create_date', '集計日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (561, 'dtb_pagelayout', 'page_id', 'ページID 0はプレビュー用データ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (562, 'dtb_pagelayout', 'page_name', 'ページ名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (563, 'dtb_pagelayout', 'url', 'ページURL PKEY1');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (564, 'dtb_pagelayout', 'php_dir', 'PHPファイル保存先');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (565, 'dtb_pagelayout', 'tpl_dir', 'テンプレートファイル保存先');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (566, 'dtb_pagelayout', 'filename', 'ファイル名（拡張子なし）');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (567, 'dtb_pagelayout', 'header_chk', 'ヘッダー使用チェック　1：使用、2：未使用');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (568, 'dtb_pagelayout', 'footer_chk', 'フッター使用チェック　1：使用、2：未使用');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (569, 'dtb_pagelayout', 'edit_flg', '削除、ページ名称、URL等を編集可能か否かのFLG　1：編集可、2：編集不可');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (570, 'dtb_pagelayout', 'author', 'メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (571, 'dtb_pagelayout', 'description', 'メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (572, 'dtb_pagelayout', 'keyword', 'メタタグ(SEO管理用)');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (573, 'dtb_pagelayout', 'update_url', 'このデータに対して更新を行ったページ');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (574, 'dtb_pagelayout', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (575, 'dtb_pagelayout', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (576, 'dtb_bloc', 'bloc_id', 'ブロックID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (577, 'dtb_bloc', 'bloc_name', 'ブロック名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (578, 'dtb_bloc', 'tpl_path', 'テンプレートファイルのパス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (579, 'dtb_bloc', 'filename', 'ファイル名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (580, 'dtb_bloc', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (581, 'dtb_bloc', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (582, 'dtb_bloc', 'php_path', 'include PHPで使用する場合にはphpのパスも保存する');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (583, 'dtb_blocposition', 'page_id', 'ページID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (584, 'dtb_blocposition', 'target_id', 'ターゲットID 1：レフトナビ 2：ライトナビ 3：イン画面上部 4：メイン画面下部');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (585, 'dtb_blocposition', 'bloc_id', 'ブロックID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (586, 'dtb_blocposition', 'bloc_row', 'ブロックIDを配置する順番');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (587, 'dtb_csv', 'no', '連番');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (588, 'dtb_csv', 'csv_id', 'CSVID　1.商品マスタ、2.顧客マスタ、3.受注');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (589, 'dtb_csv', 'col', '出力カラム');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (590, 'dtb_csv', 'disp_name', '出力名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (591, 'dtb_csv', 'rank', '出力順序');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (592, 'dtb_csv', 'status', '出力有無 1.出力、2.未出力');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (593, 'dtb_csv', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (594, 'dtb_csv', 'update_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (595, 'dtb_csv_sql', 'sql_id', 'SQL番号');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (596, 'dtb_csv_sql', 'name', '名称');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (597, 'dtb_csv_sql', 'sql', 'SQL文');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (598, 'dtb_csv_sql', 'update_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (599, 'dtb_csv_sql', 'create_date', '更新日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (601, 'dtb_mobile_ext_session_id', 'session_id', 'セッションID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (602, 'dtb_mobile_ext_session_id', 'param_key', 'パラメータ名');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (603, 'dtb_mobile_ext_session_id', 'param_value', 'パラメータ値');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (604, 'dtb_mobile_ext_session_id', 'url', 'URL');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (605, 'dtb_mobile_ext_session_id', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (607, 'dtb_mobile_kara_mail', 'kara_mail_id', '空メール管理ID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (608, 'dtb_mobile_kara_mail', 'session_id', 'セッションID');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (609, 'dtb_mobile_kara_mail', 'token', 'トークン');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (610, 'dtb_mobile_kara_mail', 'next_url', '次ページURL');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (611, 'dtb_mobile_kara_mail', 'create_date', '作成日時');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (612, 'dtb_mobile_kara_mail', 'email', 'メールアドレス');
+INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (613, 'dtb_mobile_kara_mail', 'receive_date', '受信日時');

Note: See TracChangeset for help on using the changeset viewer.

Context Navigation

Changeset 18788 for branches/version-2_5-dev/html/install/sql/column_comment.sql

Legend:

branches/version-2_5-dev/html/install/sql/column_comment.sql

Download in other formats: