Changeset 18787 for branches/version-2_5-dev/html/install/index.php
- Timestamp:
- 2010/08/18 15:12:25 (14 years ago)
- bzr:base-revision:
- ohkouchi@loop-az.jp-20100818034225-loyoujma8pjbxn2u
- bzr:committer:
- Kentaro Ohkouchi <ohkouchi@loop-az.jp>
- bzr:file-ids:
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/column_comment.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcolumn_comment.sql
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/drop_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_view.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql- bzr:mapping-version:
- v4
- bzr:merge:
ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9- bzr:repository-uuid:
- 1e3b908f-19a9-db11-a64c-001125224ba8
- bzr:revision-id:
- ohkouchi@loop-az.jp-20100818061207-vgzu2onofgbq0k0i
- bzr:revno:
- 2270
- bzr:revprop:branch-nick:
- branches/version-2_5-dev
- bzr:root:
- branches/version-2_5-dev
- bzr:text-parents:
html/install/index.php ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981
html/install/sql/drop_view.sql svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18777
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818033838-mjtat0sdmbsu0981- bzr:text-revisions:
html/install/index.php ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/column_comment.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_table.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/drop_view.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9
html/install/sql/insert_data.sql ohkouchi@loop-az.jp-20100818061055-lqje64n4qlsd2ke9- bzr:timestamp:
- 2010-08-18 15:12:07.440000057 +0900
- bzr:user-agent:
- bzr2.1.2+bzr-svn1.0.2
- svn:original-date:
- 2010-08-18T06:12:07.440000Z
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/index.php
r18786 r18787 124 124 $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; 125 125 126 /*127 lfAddTableは、バージョンアップ等で追加テーブルが発生した場合に実行する。128 (DB構成の下位互換のためスキップ時も強制)129 */130 // テーブルが存在しない場合に追加される。131 $objPage->arrErr = lfAddTable("dtb_session", $dsn); // セッション管理テーブル132 $objPage->arrErr = lfAddTable("dtb_module", $dsn); // モジュール管理テーブル133 $objPage->arrErr = lfAddTable("dtb_mobile_kara_mail", $dsn); // 空メール管理テーブル134 $objPage->arrErr = lfAddTable("dtb_mobile_ext_session_id", $dsn); // セッションID管理テーブル135 $objPage->arrErr = lfAddTable("dtb_site_control", $dsn); // サイト情報管理テーブル136 $objPage->arrErr = lfAddTable("dtb_trackback", $dsn); // トラックバック管理テーブル137 138 139 // カラムを追加140 lfAddColumn($dsn);141 142 // データを追加143 lfAddData($dsn);144 145 126 if(count($objPage->arrErr) == 0) { 146 127 // スキップする場合には次画面へ遷移 … … 221 202 } 222 203 $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; 223 224 // 追加テーブルがあれば削除する。225 lfDropTable("dtb_module", $dsn);226 lfDropTable("dtb_session", $dsn);227 lfDropTable("dtb_mobile_ext_session_id", $dsn);228 lfDropTable("dtb_mobile_kara_mail", $dsn);229 lfDropTable("dtb_site_control", $dsn);230 lfDropTable("dtb_trackback", $dsn);231 204 232 205 if ($arrRet['db_type'] == 'pgsql'){ … … 837 810 } 838 811 839 // テーブルの追加(既にテーブルが存在する場合は作成しない)840 function lfAddTable($table_name, $dsn) {841 global $objPage;842 global $objDb;843 $arrErr = array();844 if(!$objDb->sfTabaleExists($table_name, $dsn)) {845 list($db_type) = split(":", $dsn);846 $sql_path = "./sql/add/". $table_name . "_" .$db_type .".sql";847 $arrErr = lfExecuteSQL($sql_path, $dsn);848 if(count($arrErr) == 0) {849 $objPage->tpl_message.="○:追加テーブル($table_name)の作成に成功しました。<br>";850 } else {851 $objPage->tpl_message.="×:追加テーブル($table_name)の作成に失敗しました。<br>";852 }853 } else {854 $objPage->tpl_message.="○:追加テーブル($table_name)が確認されました。<br>";855 }856 857 return $arrErr;858 }859 860 812 // テーブルの削除(既にテーブルが存在する場合のみ削除する) 861 813 function lfDropTable($table_name, $dsn) { … … 878 830 } 879 831 return $arrErr; 880 }881 882 // カラムの追加(既にカラムが存在する場合は作成しない)883 function lfAddColumn($dsn) {884 global $objDBParam;885 global $objDb;886 887 // 受注テーブル888 $objDb->sfColumnExists("dtb_order", "memo01", "text", $dsn, true);889 $objDb->sfColumnExists("dtb_order", "memo02", "text", $dsn, true);890 $objDb->sfColumnExists("dtb_order", "memo03", "text", $dsn, true);891 $objDb->sfColumnExists("dtb_order", "memo04", "text", $dsn, true);892 $objDb->sfColumnExists("dtb_order", "memo05", "text", $dsn, true);893 $objDb->sfColumnExists("dtb_order", "memo06", "text", $dsn, true);894 $objDb->sfColumnExists("dtb_order", "memo07", "text", $dsn, true);895 $objDb->sfColumnExists("dtb_order", "memo08", "text", $dsn, true);896 $objDb->sfColumnExists("dtb_order", "memo09", "text", $dsn, true);897 $objDb->sfColumnExists("dtb_order", "memo10", "text", $dsn, true);898 899 // 受注一時テーブル900 $objDb->sfColumnExists("dtb_order_temp", "order_id", "text", $dsn, true);901 $objDb->sfColumnExists("dtb_order_temp", "memo01", "text", $dsn, true);902 $objDb->sfColumnExists("dtb_order_temp", "memo02", "text", $dsn, true);903 $objDb->sfColumnExists("dtb_order_temp", "memo03", "text", $dsn, true);904 $objDb->sfColumnExists("dtb_order_temp", "memo04", "text", $dsn, true);905 $objDb->sfColumnExists("dtb_order_temp", "memo05", "text", $dsn, true);906 $objDb->sfColumnExists("dtb_order_temp", "memo06", "text", $dsn, true);907 $objDb->sfColumnExists("dtb_order_temp", "memo07", "text", $dsn, true);908 $objDb->sfColumnExists("dtb_order_temp", "memo08", "text", $dsn, true);909 $objDb->sfColumnExists("dtb_order_temp", "memo09", "text", $dsn, true);910 $objDb->sfColumnExists("dtb_order_temp", "memo10", "text", $dsn, true);911 912 // 支払情報テーブル913 $objDb->sfColumnExists("dtb_payment", "charge_flg", "int2 default 1", $dsn, true);914 $objDb->sfColumnExists("dtb_payment", "rule_min", "numeric", $dsn, true);915 $objDb->sfColumnExists("dtb_payment", "upper_rule_max", "numeric", $dsn, true);916 $objDb->sfColumnExists("dtb_payment", "module_id", "int4", $dsn, true);917 $objDb->sfColumnExists("dtb_payment", "module_path", "text", $dsn, true);918 $objDb->sfColumnExists("dtb_payment", "memo01", "text", $dsn, true);919 $objDb->sfColumnExists("dtb_payment", "memo02", "text", $dsn, true);920 $objDb->sfColumnExists("dtb_payment", "memo03", "text", $dsn, true);921 $objDb->sfColumnExists("dtb_payment", "memo04", "text", $dsn, true);922 $objDb->sfColumnExists("dtb_payment", "memo05", "text", $dsn, true);923 $objDb->sfColumnExists("dtb_payment", "memo06", "text", $dsn, true);924 $objDb->sfColumnExists("dtb_payment", "memo07", "text", $dsn, true);925 $objDb->sfColumnExists("dtb_payment", "memo08", "text", $dsn, true);926 $objDb->sfColumnExists("dtb_payment", "memo09", "text", $dsn, true);927 $objDb->sfColumnExists("dtb_payment", "memo10", "text", $dsn, true);928 929 // 顧客930 $objDb->sfColumnExists("dtb_customer", "mailmaga_flg", "int2", $dsn, true);931 932 // インデックスの確認933 if (!$objDb->sfColumnExists("dtb_customer", "mobile_phone_id", "text", $dsn, true)) {934 // インデックスの追加935 $objDb->sfIndexExists("dtb_customer", "mobile_phone_id", "dtb_customer_mobile_phone_id_key", 64, $dsn, true);936 }937 938 // データの追加(既にデータが存在する場合は作成しない)939 function lfAddData($dsn) {940 global $objDb;941 // CSVテーブル942 if($objDb->sfTabaleExists('dtb_csv', $dsn)) {943 lfInsertCSVData(1,'category_id','カテゴリID',53,'now()','now()', $dsn);944 lfInsertCSVData(4,'order_id','注文番号',1,'now()','now()', $dsn);945 lfInsertCSVData(4,'customer_id','顧客ID',3,'now()','now()', $dsn);946 lfInsertCSVData(4,'message','要望等',4,'now()','now()', $dsn);947 lfInsertCSVData(4,'order_name01','顧客名1',5,'now()','now()', $dsn);948 lfInsertCSVData(4,'order_name02','顧客名2',6,'now()','now()', $dsn);949 lfInsertCSVData(4,'order_kana01','顧客名カナ1',7,'now()','now()', $dsn);950 lfInsertCSVData(4,'order_kana02','顧客名カナ2',8,'now()','now()', $dsn);951 lfInsertCSVData(4,'order_email','メールアドレス',9,'now()','now()', $dsn);952 lfInsertCSVData(4,'order_tel01','電話番号1',10,'now()','now()', $dsn);953 lfInsertCSVData(4,'order_tel02','電話番号2',11,'now()','now()', $dsn);954 lfInsertCSVData(4,'order_tel03','電話番号3',12,'now()','now()', $dsn);955 lfInsertCSVData(4,'order_fax01','FAX1',13,'now()','now()', $dsn);956 lfInsertCSVData(4,'order_fax02','FAX2',14,'now()','now()', $dsn);957 lfInsertCSVData(4,'order_fax03','FAX3',15,'now()','now()', $dsn);958 lfInsertCSVData(4,'order_zip01','郵便番号1',16,'now()','now()', $dsn);959 lfInsertCSVData(4,'order_zip02','郵便番号2',17,'now()','now()', $dsn);960 lfInsertCSVData(4,'order_pref','都道府県',18,'now()','now()', $dsn);961 lfInsertCSVData(4,'order_addr01','住所1',19,'now()','now()', $dsn);962 lfInsertCSVData(4,'order_addr02','住所2',20,'now()','now()', $dsn);963 lfInsertCSVData(4,'order_sex','性別',21,'now()','now()', $dsn);964 lfInsertCSVData(4,'order_birth','生年月日',22,'now()','now()', $dsn);965 lfInsertCSVData(4,'order_job','職種',23,'now()','now()', $dsn);966 lfInsertCSVData(4,'deliv_name01','お届け先名前',24,'now()','now()', $dsn);967 lfInsertCSVData(4,'deliv_name02','お届け先名前',25,'now()','now()', $dsn);968 lfInsertCSVData(4,'deliv_kana01','お届け先カナ',26,'now()','now()', $dsn);969 lfInsertCSVData(4,'deliv_kana02','お届け先カナ',27,'now()','now()', $dsn);970 lfInsertCSVData(4,'deliv_tel01','電話番号1',28,'now()','now()', $dsn);971 lfInsertCSVData(4,'deliv_tel02','電話番号2',29,'now()','now()', $dsn);972 lfInsertCSVData(4,'deliv_tel03','電話番号3',30,'now()','now()', $dsn);973 lfInsertCSVData(4,'deliv_fax01','FAX1',31,'now()','now()', $dsn);974 lfInsertCSVData(4,'deliv_fax02','FAX2',32,'now()','now()', $dsn);975 lfInsertCSVData(4,'deliv_fax03','FAX3',33,'now()','now()', $dsn);976 lfInsertCSVData(4,'deliv_zip01','郵便番号1',34,'now()','now()', $dsn);977 lfInsertCSVData(4,'deliv_zip02','郵便番号2',35,'now()','now()', $dsn);978 lfInsertCSVData(4,'deliv_pref','都道府県',36,'now()','now()', $dsn);979 lfInsertCSVData(4,'deliv_addr01','住所1',37,'now()','now()', $dsn);980 lfInsertCSVData(4,'deliv_addr02','住所2',38,'now()','now()', $dsn);981 lfInsertCSVData(4,'payment_total','お支払い合計',39,'now()','now()', $dsn);982 }983 }984 985 // CSVテーブルへのデータの追加986 function lfInsertCSVData($csv_id,$col,$disp_name,$rank,$create_date,$update_date, $dsn) {987 global $objDb;988 $sql = "insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) values($csv_id,'$col','$disp_name',$rank,$create_date,$update_date);";989 $objDb->sfDataExists("dtb_csv", "csv_id = ? AND col = ?", array($csv_id, $col), $dsn, $sql, true);990 832 } 991 833
Note: See TracChangeset
for help on using the changeset viewer.