Changeset 18115 for branches/version-2_4/html

Timestamp:

2009/06/15 20:24:30 (15 years ago)

Author:

kajiwara

Message:

#451 order_id の日本語名称を「注文番号」に統一。

Location:

branches/version-2_4/html/install

Files:

• index.php (modified) (1 diff)
• sql/column_comment.sql (modified) (4 diffs)
• sql/insert_data.sql (modified) (2 diffs)

branches/version-2_4/html/install/index.php

@@ -1018 +1018 @@
     if($objDb->sfTabaleExists('dtb_csv', $dsn)) {
         lfInsertCSVData(1,'category_id','カテゴリID',53,'now()','now()', $dsn);
-        lfInsertCSVData(4,'order_id','注文ID',1,'now()','now()', $dsn);
+        lfInsertCSVData(4,'order_id','注文番号',1,'now()','now()', $dsn);
         lfInsertCSVData(4,'campaign_id','キャンペーンID',2,'now()','now()', $dsn);
         lfInsertCSVData(4,'customer_id','顧客ID',3,'now()','now()', $dsn);

branches/version-2_4/html/install/sql/column_comment.sql

@@ -314 +314 @@
 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','best_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','順位');
@@ -325 +325 @@
 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','注文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');
@@ -376 +376 @@
 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','注文ID');
+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)');
@@ -527 +527 @@
 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','注文ID');
+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');

branches/version-2_4/html/install/sql/insert_data.sql

@@ -132 +132 @@
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'create_date','登録日',26,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'update_date','更新日',27,now(),now());
-insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_id','注文ID',1,now(),now());
+insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_id','注文番号',1,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'customer_id','顧客ID',2,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'message','要望等',3,now(),now());
@@ -185 +185 @@
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'create_date','注文日時',52,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'update_date','更新日時',53,now(),now());
-insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_id','注文ID',1,now(),now());
+insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_id','注文番号',1,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'campaign_id','キャンペーンID',2,now(),now());
 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'customer_id','顧客ID',3,now(),now());