r17994
リビジョン: 17994
作者: Seasoft
日時: 20:20:55, 2009年5月1日
メッセージ:
#451: order_id の日本語名称を「注文番号」に統一。
・「ご注文番号」の箇所は変更していません。
SQL
UPDATE dtb_csv
SET disp_name = '注文番号'
WHERE 0=0
AND csv_id = 4
AND col = 'order_id'
AND disp_name = '注文ID'
;
UPDATE dtb_table_comment
SET description = '注文番号'
WHERE 0=0
AND TABLE_NAME = 'dtb_mail_history'
AND column_name = 'order_id'
AND description = '注文ID'
;
UPDATE dtb_table_comment
SET description = '注文番号'
WHERE 0=0
AND TABLE_NAME = 'dtb_order'
AND column_name = 'order_id'
AND description = '注文ID'
;
UPDATE dtb_table_comment
SET description = '注文番号'
WHERE 0=0
AND TABLE_NAME = 'dtb_order_detail'
AND column_name = 'order_id'
AND description = '注文ID'
;
UPDATE dtb_csv
SET disp_name = '注文番号'
WHERE 0=0
AND csv_id = 3
AND col = 'order_id'
AND disp_name = '注文ID'
;
UPDATE dtb_csv
SET disp_name = '注文番号'
WHERE 0=0
AND csv_id = 4
AND col = 'order_id'
AND disp_name = '注文ID'
;