Changeset 18521 for branches/version-2_4/html
- Timestamp:
- 2010/02/01 15:34:04 (14 years ago)
- Location:
- branches/version-2_4
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_4
- Property svn:mergeinfo changed
/branches/version-2_4-dev merged: 18472
- Property svn:mergeinfo changed
-
branches/version-2_4/html/install/index.php
r18165 r18521 1047 1047 lfInsertCSVData(4,'order_birth','生年月日',22,'now()','now()', $dsn); 1048 1048 lfInsertCSVData(4,'order_job','職種',23,'now()','now()', $dsn); 1049 lfInsertCSVData(4,'deliv_name01',' 配送先名前',24,'now()','now()', $dsn);1050 lfInsertCSVData(4,'deliv_name02',' 配送先名前',25,'now()','now()', $dsn);1051 lfInsertCSVData(4,'deliv_kana01',' 配送先カナ',26,'now()','now()', $dsn);1052 lfInsertCSVData(4,'deliv_kana02',' 配送先カナ',27,'now()','now()', $dsn);1049 lfInsertCSVData(4,'deliv_name01','お届け先名前',24,'now()','now()', $dsn); 1050 lfInsertCSVData(4,'deliv_name02','お届け先名前',25,'now()','now()', $dsn); 1051 lfInsertCSVData(4,'deliv_kana01','お届け先カナ',26,'now()','now()', $dsn); 1052 lfInsertCSVData(4,'deliv_kana02','お届け先カナ',27,'now()','now()', $dsn); 1053 1053 lfInsertCSVData(4,'deliv_tel01','電話番号1',28,'now()','now()', $dsn); 1054 1054 lfInsertCSVData(4,'deliv_tel02','電話番号2',29,'now()','now()', $dsn); -
branches/version-2_4/html/install/sql/column_comment.sql
r18115 r18521 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'); -
branches/version-2_4/html/install/sql/insert_data.sql
r18369 r18521 154 154 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_birth','生年月日',21,now(),now()); 155 155 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_job','職種',22,now(),now()); 156 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name01',' 配送先名前',23,now(),now());157 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name02',' 配送先名前',24,now(),now());158 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana01',' 配送先カナ',25,now(),now());159 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana02',' 配送先カナ',26,now(),now());156 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name01','お届け先名前',23,now(),now()); 157 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name02','お届け先名前',24,now(),now()); 158 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana01','お届け先カナ',25,now(),now()); 159 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana02','お届け先カナ',26,now(),now()); 160 160 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel01','電話番号1',27,now(),now()); 161 161 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel02','電話番号2',28,now(),now()); … … 179 179 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_total','お支払い合計',46,now(),now()); 180 180 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_method','支払い方法',47,now(),now()); 181 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_time',' 配送時間',48,now(),now());181 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_time','お届け時間',48,now(),now()); 182 182 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_no','配送伝票番号',49,now(),now()); 183 183 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'note','SHOPメモ',50,now(),now()); … … 208 208 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_birth','生年月日',22,now(),now()); 209 209 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_job','職種',23,now(),now()); 210 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name01',' 配送先名前',24,now(),now());211 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name02',' 配送先名前',25,now(),now());212 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana01',' 配送先カナ',26,now(),now());213 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana02',' 配送先カナ',27,now(),now());210 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name01','お届け先名前',24,now(),now()); 211 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name02','お届け先名前',25,now(),now()); 212 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana01','お届け先カナ',26,now(),now()); 213 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana02','お届け先カナ',27,now(),now()); 214 214 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_tel01','電話番号1',28,now(),now()); 215 215 insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_tel02','電話番号2',29,now(),now()); … … 943 943 INSERT INTO mtb_constants VALUES ('NAVI_PMAX','4',184,'ページ番号の最大表示個数'); 944 944 INSERT INTO mtb_constants VALUES ('PRODUCTSUB_MAX','5',185,'商品サブ情報最大数'); 945 INSERT INTO mtb_constants VALUES ('DELIVTIME_MAX','16',186,' 配送時間の最大表示数');945 INSERT INTO mtb_constants VALUES ('DELIVTIME_MAX','16',186,'お届け時間の最大表示数'); 946 946 INSERT INTO mtb_constants VALUES ('DELIVFEE_MAX','47',187,'配送料金の最大表示数'); 947 947 INSERT INTO mtb_constants VALUES ('STEXT_LEN','50',188,'短い項目の文字数(名前など)'); … … 998 998 INSERT INTO mtb_constants VALUES ('URL_SITE_TOP','URL_DIR . "index.php"',239,'サイトトップ'); 999 999 INSERT INTO mtb_constants VALUES ('URL_CART_TOP','URL_DIR . "cart/index.php"',240,'カートトップ'); 1000 INSERT INTO mtb_constants VALUES ('URL_DELIV_TOP','URL_DIR . "shopping/deliv.php"',241,' 配送時間設定');1000 INSERT INTO mtb_constants VALUES ('URL_DELIV_TOP','URL_DIR . "shopping/deliv.php"',241,'お届け時間設定'); 1001 1001 INSERT INTO mtb_constants VALUES ('URL_MYPAGE_TOP','SSL_URL . "mypage/login.php"',242,'Myページトップ'); 1002 1002 INSERT INTO mtb_constants VALUES ('URL_SHOP_CONFIRM','URL_DIR . "shopping/confirm.php"',243,'購入確認ページ'); … … 1029 1029 INSERT INTO mtb_constants VALUES ('BEST_MAX','5',270,'ベスト商品の最大登録数'); 1030 1030 INSERT INTO mtb_constants VALUES ('BEST_MIN','3',271,'ベスト商品の最小登録数(登録数が満たない場合は表示しない。)'); 1031 INSERT INTO mtb_constants VALUES ('DELIV_DATE_END_MAX','21',272,' 配達可能な日付以降のプルダウン表示最大日数');1031 INSERT INTO mtb_constants VALUES ('DELIV_DATE_END_MAX','21',272,'お届け可能な日付以降のプルダウン表示最大日数'); 1032 1032 INSERT INTO mtb_constants VALUES ('PURCHASE_CUSTOMER_REGIST','0',273,'購入時強制会員登録(1:有効 0:無効)'); 1033 1033 INSERT INTO mtb_constants VALUES ('RELATED_PRODUCTS_MAX','3',274,'この商品を買った人はこんな商品も買っています 表示件数'); -
branches/version-2_4/html/install/sql/table_comment.sql
r16437 r18521 1 1 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_baseinfo','基本情報'); 2 2 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_deliv','配送業者'); 3 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivtime',' 配送時間');3 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivtime','お届け時間'); 4 4 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_delivfee','配送料金'); 5 5 INSERT INTO dtb_table_comment(table_name,description) values ('dtb_payment','支払方法');
Note: See TracChangeset
for help on using the changeset viewer.