r18235

Author: Seasoft
Date: 9:49:37, 2009年7月25日
Message:
  * #516(受注管理の編集画面でお届け日を編集可能に)を実装
  * 語句統一(フロント機能PCサイトを基準とした)
    * お届け日 ← 配達日、配送日
    * お届け時間 ← 配送時間、配達時間
    * お届け先 ← 配送先
  * コメントの誤りを修正

SQL

未テスト

UPDATE dtb_csv
SET disp_name = 'お届け先名前'
WHERE (csv_id,col) = (3,'deliv_name01')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先名前'
WHERE (csv_id,col) = (3,'deliv_name02')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先カナ'
WHERE (csv_id,col) = (3,'deliv_kana01')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先カナ'
WHERE (csv_id,col) = (3,'deliv_kana02')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け時間'
WHERE (csv_id,col) = (3,'deliv_time')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先名前'
WHERE (csv_id,col) = (4,'deliv_name01')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先名前'
WHERE (csv_id,col) = (4,'deliv_name02')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先カナ'
WHERE (csv_id,col) = (4,'deliv_kana01')
;
 
UPDATE dtb_csv
SET disp_name = 'お届け先カナ'
WHERE (csv_id,col) = (4,'deliv_kana02')
;
 
UPDATE mtb_constants
SET remarks = 'お届け時間の最大表示数'
WHERE id = 'DELIVTIME_MAX'
;
 
UPDATE mtb_constants
SET remarks = 'お届け先設定'
WHERE id = 'URL_DELIV_TOP'
;
 
UPDATE mtb_constants
SET remarks = 'お届け可能日以降のプルダウン表示最大日数'
WHERE id = 'DELIV_DATE_END_MAX'
;
 
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_delivtime','time_id');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_delivtime','time');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_name01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_name02');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_kana01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_kana02');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_time_id');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_time');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order','deliv_date');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_name01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_name02');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_kana01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_kana02');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_time_id');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_time');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_order_temp','deliv_date');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_other_deliv','name01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_other_deliv','name02');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_other_deliv','kana01');
DELETE FROM dtb_table_comment WHERE (TABLE_NAME,column_name) = ('dtb_other_deliv','kana02');
 
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_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_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_date','お届け日');
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_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_date','お届け日');
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','お届け先カナ');
 
DELETE FROM dtb_table_comment WHERE column_name IS NULL AND TABLE_NAME = 'dtb_delivtime';
 
INSERT INTO dtb_table_comment (TABLE_NAME,description) VALUES ('dtb_delivtime','お届け時間');

管理機能

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

目次

r18235

SQL

管理機能