Changeset 19854 for branches/version-2_5-dev/html
- Timestamp:
- 2011/01/08 03:11:29 (13 years ago)
- Location:
- branches/version-2_5-dev/html/install
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/index.php
r19808 r19854 32 32 $INSTALL_DIR = realpath(dirname( __FILE__)); 33 33 require_once(DATA_REALDIR . "module/Request.php"); 34 require_once(DATA_REALDIR . "install.php"); 34 35 35 36 define("INSTALL_LOG", "./temp/install.log"); … … 112 113 // 設定ファイルの生成 113 114 lfMakeConfigFile(); 114 $objPage = lfDispStep3($objPage); 115 if(!renameAdminDir($objWebParam->getValue('admin_dir'))){ 116 $objPage->arrErr["all"] .= "管理者ディレクトリのリネームに失敗しました。権限を確認してください。"; 117 $objPage = lfDispStep2($objPage); 118 }else{ 119 $objPage = lfDispStep3($objPage); 120 } 115 121 } else { 116 122 $objPage = lfDispStep2($objPage); … … 399 405 DATA_REALDIR . "downloads/", 400 406 DATA_REALDIR . "upload/", 407 HTML_REALDIR . "admin/" 401 408 ); 402 409 … … 646 653 } 647 654 } 655 656 //管理画面のディレクトリ名を取得(再インストール時) 657 if(defined("ADMIN_DIR")){ 658 $admin_dir = ADMIN_DIR; 659 } 648 660 649 661 $objWebParam->addParam("店名", "shop_name", MTEXT_LEN, "", array("EXIST_CHECK","MAX_LENGTH_CHECK"), $shop_name); … … 651 663 $objWebParam->addParam("管理者:ログインID", "login_id", ID_MAX_LEN, "", array("EXIST_CHECK","SPTAB_CHECK", "ALNUM_CHECK")); 652 664 $objWebParam->addParam("管理者:パスワード", "login_pass", ID_MAX_LEN, "", array("EXIST_CHECK","SPTAB_CHECK", "ALNUM_CHECK")); 665 $objWebParam->addParam("管理画面:ディレクトリ", "admin_dir", ID_MAX_LEN, "a", array("EXIST_CHECK","SPTAB_CHECK", "ALNUM_CHECK"),$admin_dir); 666 $objWebParam->addParam("管理画面:SSL制限", "admin_force_ssl", 1, "n", array("SPTAB_CHECK", "NUM_CHECK","MAX_LENGTH_CHECK")); 667 $objWebParam->addParam("管理画面:IP制限", "admin_allow_hosts", LTEXT_LEN, "an", array("IP_CHECK","MAX_LENGTH_CHECK")); 653 668 $objWebParam->addParam("URL(通常)", "normal_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $normal_url); 654 669 $objWebParam->addParam("URL(セキュア)", "secure_url", MTEXT_LEN, "", array("EXIST_CHECK","URL_CHECK","MAX_LENGTH_CHECK"), $secure_url); … … 721 736 722 737 // パスワードのチェック 723 $objErr->doFunc( array("管理者:パスワード",'login_pass', ID_MIN_LEN ,ID_MAX_LEN) ,array("SPTAB_CHECK" ,"NUM_RANGE_CHECK" ));738 $objErr->doFunc( array("管理者:パスワード",'login_pass',PASSWORD_LEN1 ,PASSWORD_LEN2 ) ,array("SPTAB_CHECK" ,"NUM_RANGE_CHECK" )); 724 739 725 740 return $objErr->arrErr; … … 902 917 903 918 $filepath = DATA_REALDIR . "install.php"; 904 919 920 //管理画面SSL制限 921 $force_ssl = FALSE; 922 if($objWebParam->getValue('admin_force_ssl') == 1){ 923 $force_ssl = TRUE; 924 } 925 //管理画面IP制限 926 $allow_hosts = array(); 927 $hosts = $objWebParam->getValue('admin_allow_hosts'); 928 if(!empty($hosts)){ 929 $hosts = str_replace("\r","",$hosts); 930 if(strpos("\n",$hosts) === false){ 931 $hosts .= "\n"; 932 } 933 $hosts = explode("\n",$hosts); 934 foreach($hosts as $key=>$host){ 935 $host = trim($host); 936 if(strlen($host) >= 8) { 937 $allow_hosts[] = $host; 938 } 939 } 940 } 905 941 $config_data = 906 942 "<?php\n". … … 916 952 " define ('DB_NAME', '" . $objDBParam->getValue('db_name') . "');\n" . 917 953 " define ('DB_PORT', '" . $objDBParam->getValue('db_port') . "');\n" . 918 "?>"; 954 " define ('ADMIN_DIR', '" . $objWebParam->getValue('admin_dir') . "/');\n" . 955 " define ('ADMIN_FORCE_SSL', " . $force_ssl . ");\n"; 956 if(count($allow_hosts) > 0){ 957 $config_data .= " define ('ADMIN_ALLOW_HOSTS', '".serialize($allow_hosts)."');\n"; 958 } 959 $config_data .= "?>"; 919 960 920 961 if($fp = fopen($filepath,"w")) { … … 988 1029 array("dtb_trackback", "trackback_id")); 989 1030 } 1031 1032 1033 /** 1034 * 管理画面のディレクトリ名の変更 1035 * 1036 * @param string 設定する管理画面のディレクトリ名 1037 */ 1038 function renameAdminDir($admin_dir){ 1039 $old_dir = "admin/"; 1040 if(defined("ADMIN_DIR")){ 1041 $old_dir = ADMIN_DIR; 1042 } 1043 if(!rename(HTML_REALDIR.$old_dir,HTML_REALDIR.$admin_dir)){ 1044 return FALSE; 1045 } 1046 if(!rename(USER_TEMPLATE_REALDIR.$old_dir,USER_TEMPLATE_REALDIR.$admin_dir)){ 1047 return FALSE; 1048 } 1049 return TRUE; 1050 } 990 1051 ?> -
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r19808 r19854 9 9 update_date timestamp NOT NULL, 10 10 PRIMARY KEY (log_id) 11 ) TYPE=InnoDB;11 ) ENGINE=InnoDB; 12 12 13 13 CREATE TABLE dtb_ownersstore_settings ( 14 14 public_key text 15 ) TYPE=InnoDB;15 ) ENGINE=InnoDB; 16 16 17 17 CREATE TABLE dtb_kiyaku ( … … 25 25 del_flg smallint NOT NULL DEFAULT 0, 26 26 PRIMARY KEY (kiyaku_id) 27 ) TYPE=InnoDB;27 ) ENGINE=InnoDB; 28 28 29 29 CREATE TABLE dtb_holiday ( … … 38 38 del_flg smallint NOT NULL DEFAULT 0, 39 39 PRIMARY KEY (holiday_id) 40 ) TYPE=InnoDB;40 ) ENGINE=InnoDB; 41 41 42 42 CREATE TABLE mtb_zip ( … … 56 56 flg5 text, 57 57 flg6 text 58 ) TYPE=InnoDB;58 ) ENGINE=InnoDB; 59 59 60 60 CREATE TABLE dtb_bat_order_daily_age ( … … 67 67 order_date datetime, 68 68 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 69 ) TYPE=InnoDB;69 ) ENGINE=InnoDB; 70 70 71 71 CREATE TABLE dtb_update ( … … 85 85 release_date datetime NOT NULL, 86 86 PRIMARY KEY (module_id) 87 ) TYPE=InnoDB;87 ) ENGINE=InnoDB; 88 88 89 89 CREATE TABLE dtb_baseinfo ( … … 152 152 downloadable_days numeric DEFAULT 30, 153 153 downloadable_days_unlimited smallint 154 ) TYPE=InnoDB;154 ) ENGINE=InnoDB; 155 155 156 156 CREATE TABLE dtb_deliv ( … … 167 167 update_date timestamp NOT NULL, 168 168 PRIMARY KEY (deliv_id) 169 ) TYPE=InnoDB;169 ) ENGINE=InnoDB; 170 170 171 171 CREATE TABLE dtb_delivtime ( … … 174 174 deliv_time text NOT NULL, 175 175 PRIMARY KEY (deliv_id, time_id) 176 ) TYPE=InnoDB;176 ) ENGINE=InnoDB; 177 177 178 178 CREATE TABLE dtb_delivfee ( … … 182 182 pref smallint, 183 183 PRIMARY KEY (deliv_id, fee_id) 184 ) TYPE=InnoDB;184 ) ENGINE=InnoDB; 185 185 186 186 CREATE TABLE dtb_payment ( … … 215 215 memo10 text, 216 216 PRIMARY KEY (payment_id) 217 ) TYPE=InnoDB;217 ) ENGINE=InnoDB; 218 218 219 219 CREATE TABLE dtb_payment_options ( … … 222 222 rank int, 223 223 PRIMARY KEY(product_class_id, payment_id) 224 ) TYPE=InnoDB;224 ) ENGINE=InnoDB; 225 225 226 226 CREATE TABLE dtb_mailtemplate ( … … 233 233 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 234 234 update_date timestamp NOT NULL 235 ) TYPE=InnoDB;235 ) ENGINE=InnoDB; 236 236 237 237 CREATE TABLE dtb_send_history ( … … 250 250 update_date timestamp NOT NULL, 251 251 PRIMARY KEY (send_id) 252 ) TYPE=InnoDB;252 ) ENGINE=InnoDB; 253 253 254 254 CREATE TABLE dtb_send_customer ( … … 259 259 send_flag smallint, 260 260 PRIMARY KEY (send_id, customer_id) 261 ) TYPE=InnoDB;261 ) ENGINE=InnoDB; 262 262 263 263 CREATE TABLE dtb_products ( … … 308 308 deliv_date_id int, 309 309 PRIMARY KEY (product_id) 310 ) TYPE=InnoDB;310 ) ENGINE=InnoDB; 311 311 312 312 CREATE TABLE dtb_products_class ( … … 330 330 del_flg smallint NOT NULL DEFAULT 0, 331 331 PRIMARY KEY (product_class_id) 332 ) TYPE=InnoDB;332 ) ENGINE=InnoDB; 333 333 334 334 CREATE TABLE dtb_class ( … … 341 341 del_flg smallint NOT NULL DEFAULT 0, 342 342 PRIMARY KEY (class_id) 343 ) TYPE=InnoDB;343 ) ENGINE=InnoDB; 344 344 345 345 CREATE TABLE dtb_classcategory ( … … 353 353 del_flg smallint NOT NULL DEFAULT 0, 354 354 PRIMARY KEY (classcategory_id) 355 ) TYPE=InnoDB;355 ) ENGINE=InnoDB; 356 356 357 357 CREATE TABLE dtb_class_combination ( … … 361 361 level int, 362 362 PRIMARY KEY(class_combination_id) 363 ) TYPE=InnoDB;363 ) ENGINE=InnoDB; 364 364 365 365 CREATE TABLE dtb_category ( … … 374 374 del_flg smallint NOT NULL DEFAULT 0, 375 375 PRIMARY KEY (category_id) 376 ) TYPE=InnoDB;376 ) ENGINE=InnoDB; 377 377 378 378 CREATE TABLE dtb_product_categories ( … … 381 381 rank int NOT NULL, 382 382 PRIMARY KEY(product_id, category_id) 383 ) TYPE=InnoDB;383 ) ENGINE=InnoDB; 384 384 385 385 CREATE TABLE dtb_product_status ( … … 391 391 del_flg smallint NOT NULL DEFAULT 0, 392 392 PRIMARY KEY(product_status_id, product_id) 393 ) TYPE=InnoDB;393 ) ENGINE=InnoDB; 394 394 395 395 CREATE TABLE dtb_bat_order_daily ( … … 415 415 key_year text NOT NULL, 416 416 key_wday text NOT NULL 417 ) TYPE=InnoDB;417 ) ENGINE=InnoDB; 418 418 419 419 CREATE TABLE dtb_bat_order_daily_hour ( … … 432 432 order_date datetime, 433 433 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 434 ) TYPE=InnoDB;434 ) ENGINE=InnoDB; 435 435 436 436 CREATE TABLE dtb_recommend_products ( … … 443 443 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 444 444 update_date timestamp NOT NULL 445 ) TYPE=InnoDB;445 ) ENGINE=InnoDB; 446 446 447 447 CREATE TABLE dtb_review ( … … 461 461 del_flg smallint NOT NULL DEFAULT 0, 462 462 PRIMARY KEY (review_id) 463 ) TYPE=InnoDB;463 ) ENGINE=InnoDB; 464 464 465 465 CREATE TABLE dtb_customer_favorite_products ( … … 468 468 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 469 469 update_date timestamp NOT NULL 470 ) TYPE=InnoDB;470 ) ENGINE=InnoDB; 471 471 472 472 CREATE TABLE dtb_category_count ( … … 474 474 product_count int NOT NULL, 475 475 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 476 ) TYPE=InnoDB;476 ) ENGINE=InnoDB; 477 477 478 478 CREATE TABLE dtb_category_total_count ( … … 480 480 product_count int, 481 481 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 482 ) TYPE=InnoDB;482 ) ENGINE=InnoDB; 483 483 484 484 CREATE TABLE dtb_news ( … … 496 496 del_flg smallint NOT NULL DEFAULT 0, 497 497 PRIMARY KEY (news_id) 498 ) TYPE=InnoDB;498 ) ENGINE=InnoDB; 499 499 500 500 CREATE TABLE dtb_best_products ( … … 510 510 del_flg smallint NOT NULL DEFAULT 0, 511 511 PRIMARY KEY (best_id) 512 ) TYPE=InnoDB;512 ) ENGINE=InnoDB; 513 513 514 514 CREATE TABLE dtb_mail_history ( … … 521 521 mail_body text, 522 522 PRIMARY KEY (send_id) 523 ) TYPE=InnoDB;523 ) ENGINE=InnoDB; 524 524 525 525 CREATE TABLE dtb_customer ( … … 562 562 mailmaga_flg smallint, 563 563 PRIMARY KEY (customer_id) 564 ) TYPE=InnoDB;564 ) ENGINE=InnoDB; 565 565 566 566 CREATE TABLE dtb_order ( … … 639 639 memo10 text, 640 640 PRIMARY KEY (order_id) 641 ) TYPE=InnoDB;641 ) ENGINE=InnoDB; 642 642 643 643 CREATE TABLE dtb_order_temp ( … … 717 717 memo10 text, 718 718 session text 719 ) TYPE=InnoDB;719 ) ENGINE=InnoDB; 720 720 721 721 CREATE TABLE dtb_other_deliv ( … … 735 735 tel03 text, 736 736 PRIMARY KEY (other_deliv_id) 737 ) TYPE=InnoDB;737 ) ENGINE=InnoDB; 738 738 739 739 CREATE TABLE dtb_order_detail ( … … 748 748 quantity numeric, 749 749 point_rate numeric 750 ) TYPE=InnoDB;750 ) ENGINE=InnoDB; 751 751 752 752 CREATE TABLE dtb_member ( … … 765 765 login_date datetime, 766 766 PRIMARY KEY (member_id) 767 ) TYPE=InnoDB;767 ) ENGINE=InnoDB; 768 768 769 769 CREATE TABLE dtb_bat_relate_products ( … … 772 772 customer_id int, 773 773 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 774 ) TYPE=InnoDB;774 ) ENGINE=InnoDB; 775 775 776 776 CREATE TABLE dtb_pagelayout ( … … 792 792 update_date timestamp NOT NULL, 793 793 PRIMARY KEY (device_type_id, page_id) 794 ) TYPE=InnoDB;794 ) ENGINE=InnoDB; 795 795 796 796 CREATE TABLE dtb_bloc ( … … 806 806 PRIMARY KEY (device_type_id, bloc_id), 807 807 UNIQUE (device_type_id, filename) 808 ) TYPE=InnoDB;808 ) ENGINE=InnoDB; 809 809 810 810 CREATE TABLE dtb_blocposition ( … … 816 816 anywhere smallint DEFAULT 0 NOT NULL, 817 817 PRIMARY KEY (device_type_id, page_id, target_id, bloc_id) 818 ) TYPE=InnoDB;818 ) ENGINE=InnoDB; 819 819 820 820 CREATE TABLE dtb_csv ( … … 832 832 error_check_types text, 833 833 PRIMARY KEY (no) 834 ) TYPE=InnoDB;834 ) ENGINE=InnoDB; 835 835 836 836 CREATE TABLE dtb_csv_sql ( … … 841 841 update_date timestamp NOT NULL, 842 842 PRIMARY KEY (sql_id) 843 ) TYPE=InnoDB;843 ) ENGINE=InnoDB; 844 844 845 845 CREATE TABLE dtb_templates ( … … 849 849 update_date timestamp NOT NULL, 850 850 PRIMARY KEY (template_code) 851 ) TYPE=InnoDB;851 ) ENGINE=InnoDB; 852 852 853 853 CREATE TABLE dtb_table_comment ( … … 857 857 description text, 858 858 PRIMARY KEY (id) 859 ) TYPE=InnoDB;859 ) ENGINE=InnoDB; 860 860 861 861 CREATE TABLE dtb_maker ( … … 868 868 del_flg smallint NOT NULL DEFAULT 0, 869 869 PRIMARY KEY (maker_id) 870 ) TYPE=InnoDB;870 ) ENGINE=InnoDB; 871 871 872 872 CREATE TABLE dtb_maker_count ( … … 874 874 product_count int NOT NULL, 875 875 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 876 ) TYPE=InnoDB;876 ) ENGINE=InnoDB; 877 877 878 878 CREATE TABLE mtb_pref ( … … 881 881 rank smallint NOT NULL DEFAULT 0, 882 882 PRIMARY KEY (id) 883 ) TYPE=InnoDB;883 ) ENGINE=InnoDB; 884 884 885 885 CREATE TABLE mtb_permission ( … … 888 888 rank smallint NOT NULL DEFAULT 0, 889 889 PRIMARY KEY (id(32)) 890 ) TYPE=InnoDB;890 ) ENGINE=InnoDB; 891 891 892 892 CREATE TABLE mtb_disable_logout ( … … 895 895 rank smallint NOT NULL DEFAULT 0, 896 896 PRIMARY KEY (id) 897 ) TYPE=InnoDB;897 ) ENGINE=InnoDB; 898 898 899 899 CREATE TABLE mtb_authority ( … … 902 902 rank smallint NOT NULL DEFAULT 0, 903 903 PRIMARY KEY (id) 904 ) TYPE=InnoDB;904 ) ENGINE=InnoDB; 905 905 906 906 CREATE TABLE mtb_work ( … … 909 909 rank smallint NOT NULL DEFAULT 0, 910 910 PRIMARY KEY (id) 911 ) TYPE=InnoDB;911 ) ENGINE=InnoDB; 912 912 913 913 CREATE TABLE mtb_disp ( … … 916 916 rank smallint NOT NULL DEFAULT 0, 917 917 PRIMARY KEY (id) 918 ) TYPE=InnoDB;918 ) ENGINE=InnoDB; 919 919 920 920 CREATE TABLE mtb_class ( … … 923 923 rank smallint NOT NULL DEFAULT 0, 924 924 PRIMARY KEY (id) 925 ) TYPE=InnoDB;925 ) ENGINE=InnoDB; 926 926 927 927 CREATE TABLE mtb_status ( … … 930 930 rank smallint NOT NULL DEFAULT 0, 931 931 PRIMARY KEY (id) 932 ) TYPE=InnoDB;932 ) ENGINE=InnoDB; 933 933 934 934 CREATE TABLE mtb_status_image ( … … 937 937 rank smallint NOT NULL DEFAULT 0, 938 938 PRIMARY KEY (id) 939 ) TYPE=InnoDB;939 ) ENGINE=InnoDB; 940 940 941 941 CREATE TABLE mtb_allowed_tag ( … … 944 944 rank smallint NOT NULL DEFAULT 0, 945 945 PRIMARY KEY (id) 946 ) TYPE=InnoDB;946 ) ENGINE=InnoDB; 947 947 948 948 CREATE TABLE mtb_page_max ( … … 951 951 rank smallint NOT NULL DEFAULT 0, 952 952 PRIMARY KEY (id) 953 ) TYPE=InnoDB;953 ) ENGINE=InnoDB; 954 954 955 955 CREATE TABLE mtb_magazine_type ( … … 958 958 rank smallint NOT NULL DEFAULT 0, 959 959 PRIMARY KEY (id) 960 ) TYPE=InnoDB;960 ) ENGINE=InnoDB; 961 961 962 962 CREATE TABLE mtb_mail_magazine_type ( … … 965 965 rank smallint NOT NULL DEFAULT 0, 966 966 PRIMARY KEY (id) 967 ) TYPE=InnoDB;967 ) ENGINE=InnoDB; 968 968 969 969 CREATE TABLE mtb_recommend ( … … 972 972 rank smallint NOT NULL DEFAULT 0, 973 973 PRIMARY KEY (id) 974 ) TYPE=InnoDB;974 ) ENGINE=InnoDB; 975 975 976 976 CREATE TABLE mtb_taxrule ( … … 979 979 rank smallint NOT NULL DEFAULT 0, 980 980 PRIMARY KEY (id) 981 ) TYPE=InnoDB;981 ) ENGINE=InnoDB; 982 982 983 983 CREATE TABLE mtb_mail_template ( … … 986 986 rank smallint NOT NULL DEFAULT 0, 987 987 PRIMARY KEY (id) 988 ) TYPE=InnoDB;988 ) ENGINE=InnoDB; 989 989 990 990 CREATE TABLE mtb_mail_tpl_path ( … … 993 993 rank smallint NOT NULL DEFAULT 0, 994 994 PRIMARY KEY (id) 995 ) TYPE=InnoDB;995 ) ENGINE=InnoDB; 996 996 997 997 CREATE TABLE mtb_job ( … … 1000 1000 rank smallint NOT NULL DEFAULT 0, 1001 1001 PRIMARY KEY (id) 1002 ) TYPE=InnoDB;1002 ) ENGINE=InnoDB; 1003 1003 1004 1004 CREATE TABLE mtb_reminder ( … … 1007 1007 rank smallint NOT NULL DEFAULT 0, 1008 1008 PRIMARY KEY (id) 1009 ) TYPE=InnoDB;1009 ) ENGINE=InnoDB; 1010 1010 1011 1011 CREATE TABLE mtb_sex ( … … 1014 1014 rank smallint NOT NULL DEFAULT 0, 1015 1015 PRIMARY KEY (id) 1016 ) TYPE=InnoDB;1016 ) ENGINE=InnoDB; 1017 1017 1018 1018 CREATE TABLE mtb_page_rows ( … … 1021 1021 rank smallint NOT NULL DEFAULT 0, 1022 1022 PRIMARY KEY (id) 1023 ) TYPE=InnoDB;1023 ) ENGINE=InnoDB; 1024 1024 1025 1025 CREATE TABLE mtb_mail_type ( … … 1028 1028 rank smallint NOT NULL DEFAULT 0, 1029 1029 PRIMARY KEY (id) 1030 ) TYPE=InnoDB;1030 ) ENGINE=InnoDB; 1031 1031 1032 1032 CREATE TABLE mtb_order_status ( … … 1035 1035 rank smallint NOT NULL DEFAULT 0, 1036 1036 PRIMARY KEY (id) 1037 ) TYPE=InnoDB;1037 ) ENGINE=InnoDB; 1038 1038 1039 1039 CREATE TABLE mtb_product_status_color ( … … 1042 1042 rank smallint NOT NULL DEFAULT 0, 1043 1043 PRIMARY KEY (id) 1044 ) TYPE=InnoDB;1044 ) ENGINE=InnoDB; 1045 1045 1046 1046 CREATE TABLE mtb_order_status_color ( … … 1049 1049 rank smallint NOT NULL DEFAULT 0, 1050 1050 PRIMARY KEY (id) 1051 ) TYPE=InnoDB;1051 ) ENGINE=InnoDB; 1052 1052 1053 1053 CREATE TABLE mtb_wday ( … … 1056 1056 rank smallint NOT NULL DEFAULT 0, 1057 1057 PRIMARY KEY (id) 1058 ) TYPE=InnoDB;1058 ) ENGINE=InnoDB; 1059 1059 1060 1060 CREATE TABLE mtb_delivery_date ( … … 1063 1063 rank smallint NOT NULL DEFAULT 0, 1064 1064 PRIMARY KEY (id) 1065 ) TYPE=InnoDB;1065 ) ENGINE=InnoDB; 1066 1066 1067 1067 CREATE TABLE mtb_product_list_max ( … … 1070 1070 rank smallint NOT NULL DEFAULT 0, 1071 1071 PRIMARY KEY (id) 1072 ) TYPE=InnoDB;1072 ) ENGINE=InnoDB; 1073 1073 1074 1074 CREATE TABLE mtb_convenience ( … … 1077 1077 rank smallint NOT NULL DEFAULT 0, 1078 1078 PRIMARY KEY (id) 1079 ) TYPE=InnoDB;1079 ) ENGINE=InnoDB; 1080 1080 1081 1081 CREATE TABLE mtb_conveni_message ( … … 1084 1084 rank smallint NOT NULL DEFAULT 0, 1085 1085 PRIMARY KEY (id) 1086 ) TYPE=InnoDB;1086 ) ENGINE=InnoDB; 1087 1087 1088 1088 CREATE TABLE mtb_db ( … … 1091 1091 rank smallint NOT NULL DEFAULT 0, 1092 1092 PRIMARY KEY (id) 1093 ) TYPE=InnoDB;1093 ) ENGINE=InnoDB; 1094 1094 1095 1095 CREATE TABLE mtb_target ( … … 1098 1098 rank smallint NOT NULL DEFAULT 0, 1099 1099 PRIMARY KEY (id) 1100 ) TYPE=InnoDB;1100 ) ENGINE=InnoDB; 1101 1101 1102 1102 CREATE TABLE mtb_review_deny_url ( … … 1105 1105 rank smallint NOT NULL DEFAULT 0, 1106 1106 PRIMARY KEY (id) 1107 ) TYPE=InnoDB;1107 ) ENGINE=InnoDB; 1108 1108 1109 1109 CREATE TABLE mtb_track_back_status ( … … 1112 1112 rank smallint NOT NULL DEFAULT 0, 1113 1113 PRIMARY KEY (id) 1114 ) TYPE=InnoDB;1114 ) ENGINE=InnoDB; 1115 1115 1116 1116 CREATE TABLE mtb_site_control_track_back ( … … 1119 1119 rank smallint NOT NULL DEFAULT 0, 1120 1120 PRIMARY KEY (id) 1121 ) TYPE=InnoDB;1121 ) ENGINE=InnoDB; 1122 1122 1123 1123 CREATE TABLE mtb_site_control_affiliate ( … … 1126 1126 rank smallint NOT NULL DEFAULT 0, 1127 1127 PRIMARY KEY (id) 1128 ) TYPE=InnoDB;1128 ) ENGINE=InnoDB; 1129 1129 1130 1130 CREATE TABLE mtb_mobile_domain ( … … 1133 1133 rank smallint NOT NULL DEFAULT 0, 1134 1134 PRIMARY KEY (id) 1135 ) TYPE=InnoDB;1135 ) ENGINE=InnoDB; 1136 1136 1137 1137 CREATE TABLE mtb_ownersstore_err ( … … 1140 1140 rank smallint NOT NULL DEFAULT 0, 1141 1141 PRIMARY KEY (id) 1142 ) TYPE=InnoDB;1142 ) ENGINE=InnoDB; 1143 1143 1144 1144 CREATE TABLE mtb_ownersstore_ips ( … … 1147 1147 rank smallint NOT NULL DEFAULT 0, 1148 1148 PRIMARY KEY (id) 1149 ) TYPE=InnoDB;1149 ) ENGINE=InnoDB; 1150 1150 1151 1151 CREATE TABLE mtb_constants ( … … 1155 1155 remarks text, 1156 1156 PRIMARY KEY (id(64)) 1157 ) TYPE=InnoDB;1157 ) ENGINE=InnoDB; 1158 1158 1159 1159 CREATE TABLE mtb_product_type ( … … 1162 1162 rank smallint NOT NULL, 1163 1163 PRIMARY KEY (id) 1164 ) TYPE=InnoDB;1164 ) ENGINE=InnoDB; 1165 1165 1166 1166 CREATE TABLE mtb_device_type ( … … 1169 1169 rank smallint NOT NULL, 1170 1170 PRIMARY KEY (id) 1171 ) TYPE=InnoDB;1171 ) ENGINE=InnoDB; 1172 1172 1173 1173 CREATE TABLE dtb_mobile_ext_session_id ( … … 1198 1198 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1199 1199 update_date timestamp NOT NULL 1200 ) TYPE=InnoDB;1200 ) ENGINE=InnoDB; 1201 1201 1202 1202 CREATE TABLE dtb_session ( … … 1206 1206 update_date timestamp NOT NULL, 1207 1207 PRIMARY KEY (sess_id) 1208 ) TYPE=InnoDB;1208 ) ENGINE=InnoDB; 1209 1209 1210 1210 CREATE TABLE dtb_site_control ( … … 1218 1218 update_date timestamp NOT NULL, 1219 1219 PRIMARY KEY (control_id) 1220 ) TYPE=InnoDB;1220 ) ENGINE=InnoDB; 1221 1221 1222 1222 CREATE TABLE dtb_trackback ( … … 1232 1232 update_date timestamp NOT NULL, 1233 1233 PRIMARY KEY (trackback_id) 1234 ) TYPE=InnoDB;1234 ) ENGINE=InnoDB; 1235 1235 1236 1236 CREATE TABLE dtb_bkup ( … … 1239 1239 create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 1240 1240 PRIMARY KEY (bkup_name) 1241 ) TYPE=InnoDB;1241 ) ENGINE=InnoDB; 1242 1242 1243 1243 CREATE TABLE dtb_plugin ( … … 1250 1250 update_date timestamp NOT NULL, 1251 1251 PRIMARY KEY (plugin_id) 1252 ) TYPE=InnoDB;1252 ) ENGINE=InnoDB; 1253 1253 1254 1254 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64)); … … 1270 1270 recommend_comment text, 1271 1271 PRIMARY KEY (table_name, column_name) 1272 ) TYPE=InnoDB;1272 ) ENGINE=InnoDB; -
branches/version-2_5-dev/html/install/templates/step1.tpl
r19821 r19854 66 66 <!--{assign var=key value="login_pass"}--> 67 67 <span class="red"><span class="fs12n"><!--{$arrErr[$key]}--></span></span> 68 <input type="password" name="<!--{$key}-->" value="<!--{$arrForm[$key].value|escape}-->" maxlength="<!--{$ arrForm[$key].length}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->;" size="40" class="box40" />68 <input type="password" name="<!--{$key}-->" value="<!--{$arrForm[$key].value|escape}-->" maxlength="<!--{$smarty.const.ID_MAX_LEN}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->;" size="40" class="box40" /> 69 69 <br><span class="fs10">※管理機能にログインするためのパスワードです。</span> 70 </td> 71 </tr> 72 <tr> 73 <td bgcolor="#f2f1ec" width="150"><span class="fs12n">管理画面:ディレクトリ</span><br/><span class="fs10">半角英数字<!--{$smarty.const.ID_MIN_LEN}-->~<!--{$smarty.const.ID_MAX_LEN}-->文字</span></td> 74 <td bgcolor="#ffffff" width="332"> 75 <!--{assign var=key value="admin_dir"}--> 76 <span class="red"><span class="fs12n"><!--{$arrErr[$key]}--></span></span> 77 <input type="text" name="<!--{$key}-->" value="<!--{$arrForm[$key].value|escape|default:admin}-->" maxlength="<!--{$arrForm[$key].length}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->;" size="40" class="box40" /> 78 <br><span class="fs10">※管理画面のディレクトリ名です。https://[ホスト名].[ドメイン名]/[ショップディレクトリ]/[管理画面]/で管理画面にアクセスする場合の[管理画面]の部分。</span> 79 </td> 80 </tr> 81 <tr> 82 <td bgcolor="#f2f1ec" width="150"><span class="fs12n">管理画面:SSL制限</span><br/><span class="fs10"></td> 83 <td bgcolor="#ffffff" width="332"> 84 <!--{assign var=key value="admin_force_ssl"}--> 85 <span class="red"><span class="fs12n"><!--{$arrErr[$key]}--></span></span> 86 <input type="checkbox" name="<!--{$key}-->" id="<!--{$key}-->" value="1" <!--{if $arrForm[$key].value == 1}-->checked="checked"<!--{/if}--> /><label for="<!--{$key}-->" style="<!--{$arrErr[$key]|sfGetErrorColor}-->;" class="fs12n">SSLを強制する。</label> 87 <br><span class="fs10">※管理画面へのアクセスをSSL経由(https)の接続に制限します。</span> 88 </td> 89 </tr> 90 <tr> 91 <td bgcolor="#f2f1ec" width="150"><span class="fs12n">管理画面:IP制限</span><br/><span class="fs10"></td> 92 <td bgcolor="#ffffff" width="332"> 93 <!--{assign var=key value="admin_allow_hosts"}--> 94 <span class="red fs12n"><!--{$arrErr[$key]}--></span> 95 <span class="fs10">※管理画面へのアクセスを特定のIPアドレスからの接続のみに制限します。アクセスを許可するIPアドレスを1行づつ入力してください。何も入力しない場合は全てを許可します。</span><br /> 96 <textarea name="<!--{$key}-->" class="fs12n box40"><!--{$arrForm[$key].value|escape}--></textarea> 70 97 </td> 71 98 </tr>
Note: See TracChangeset
for help on using the changeset viewer.