Changeset 18562 for trunk/html/install/sql/column_comment.sql
- Timestamp:
- 2010/02/12 18:46:50 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/html/install/sql/column_comment.sql
r18177 r18562 66 66 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_deliv','update_date','更新日時'); 67 67 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','deliv_id','配送ID'); 68 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id',' 配送時間ID');69 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time',' 配送時間');68 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time_id','お届け時間ID'); 69 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivtime','time','お届け時間'); 70 70 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','deliv_id','配送ID'); 71 71 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_delivfee','fee_id','配送料金ID'); … … 399 399 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_birth','生年月日'); 400 400 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','order_job','職種'); 401 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01',' 配送先名前');402 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02',' 配送先名前');403 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01',' 配送先カナ');404 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02',' 配送先カナ');401 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name01','お届け先名前'); 402 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_name02','お届け先名前'); 403 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana01','お届け先カナ'); 404 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_kana02','お届け先カナ'); 405 405 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel01','電話番号1'); 406 406 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_tel02','電話番号2'); … … 427 427 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','payment_method','支払い方法'); 428 428 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_id','配送業者ID'); 429 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id',' 配送時間ID');430 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time',' 配送時間');429 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time_id','お届け時間ID'); 430 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_time','お届け時間'); 431 431 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_no','配送伝票番号'); 432 432 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','note','SHOPメモ'); … … 439 439 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','commit_date','発送済みステータスに変更した日'); 440 440 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','del_flg ','0:既定、1:削除'); 441 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date',' 配達日');441 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','deliv_date','お届け日'); 442 442 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','conveni_data','コンビニ決済情報'); 443 443 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order','cell01','携帯電話番号1'); … … 466 466 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_birth','生年月日'); 467 467 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','order_job','職種'); 468 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01',' 配送先名前');469 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02',' 配送先名前');470 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01',' 配送先カナ');471 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02',' 配送先カナ');468 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name01','お届け先名前'); 469 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_name02','お届け先名前'); 470 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana01','お届け先カナ'); 471 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_kana02','お届け先カナ'); 472 472 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel01','電話番号1'); 473 473 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_tel02','電話番号2'); … … 494 494 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','payment_method','支払い方法(文字列)'); 495 495 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_id','配送業者ID'); 496 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id',' 配送時間ID');497 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time',' 配送時間(文字列)');496 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time_id','お届け時間ID'); 497 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_time','お届け時間(文字列)'); 498 498 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_no','配送伝票番号'); 499 499 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','note','SHOPメモ'); … … 508 508 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','update_date','更新日時'); 509 509 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','del_flg ','0:既定、1:削除'); 510 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date',' 配達日');510 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','deliv_date','お届け日'); 511 511 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','conveni_data','コンビニ決済情報'); 512 512 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_order_temp','cell01','携帯電話番号1'); … … 515 515 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','other_deliv_id','別のお届け先ID'); 516 516 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','customer_id','顧客ID'); 517 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01',' 配送先名前');518 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02',' 配送先名前');519 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01',' 配送先カナ');520 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02',' 配送先カナ');517 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name01','お届け先名前'); 518 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','name02','お届け先名前'); 519 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana01','お届け先カナ'); 520 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','kana02','お届け先カナ'); 521 521 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip01','郵便番号1'); 522 522 INSERT INTO dtb_table_comment(table_name,column_name,description) values ('dtb_other_deliv','zip02','郵便番号2');
Note: See TracChangeset
for help on using the changeset viewer.