Changeset 20351
- Timestamp:
- 2011/02/23 19:43:29 (13 years ago)
- Location:
- branches/version-2_5-dev/html/install
- Files:
-
- 2 deleted
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/index.php
r20320 r20351 151 151 } 152 152 153 // ビューの作成154 if(count($objPage->arrErr) == 0 and $arrRet['db_type'] == 'pgsql') {155 // ビューの作成156 $objPage->arrErr = lfExecuteSQL("./sql/create_view.sql", $dsn);157 if(count($objPage->arrErr) == 0) {158 $objPage->tpl_message.="○:ビューの作成に成功しました。<br>";159 } else {160 $objPage->tpl_message.="×:ビューの作成に失敗しました。<br>";161 }162 }163 164 153 // 初期データの作成 165 154 if(count($objPage->arrErr) == 0) { … … 201 190 } 202 191 $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name']; 203 204 if ($arrRet['db_type'] == 'pgsql'){205 // ビューの削除206 $objPage->arrErr = lfExecuteSQL("./sql/drop_view.sql", $dsn, false);207 if(count($objPage->arrErr) == 0) {208 $objPage->tpl_message.="○:ビューの削除に成功しました。<br>";209 } else {210 $objPage->tpl_message.="×:ビューの削除に失敗しました。<br>";211 }212 }213 192 214 193 // テーブルの削除 -
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r20319 r20351 240 240 subject text, 241 241 mail_method int, 242 header text,243 242 body text, 244 main_title text,245 main_comment text,246 main_product_id int,247 sub_title text,248 sub_comment text,249 sub_product_id01 int,250 sub_product_id02 int,251 sub_product_id03 int,252 sub_product_id04 int,253 sub_product_id05 int,254 sub_product_id06 int,255 sub_product_id07 int,256 sub_product_id08 int,257 sub_product_id09 int,258 sub_product_id10 int,259 sub_product_id11 int,260 sub_product_id12 int,261 243 del_flg smallint NOT NULL DEFAULT 0, 262 244 creator_id int NOT NULL, -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r20319 r20351 240 240 subject text, 241 241 mail_method int, 242 header text,243 242 body text, 244 main_title text,245 main_comment text,246 main_product_id int,247 sub_title text,248 sub_comment text,249 sub_product_id01 int,250 sub_product_id02 int,251 sub_product_id03 int,252 sub_product_id04 int,253 sub_product_id05 int,254 sub_product_id06 int,255 sub_product_id07 int,256 sub_product_id08 int,257 sub_product_id09 int,258 sub_product_id10 int,259 sub_product_id11 int,260 sub_product_id12 int,261 243 del_flg smallint NOT NULL DEFAULT 0, 262 244 creator_id int NOT NULL,
Note: See TracChangeset
for help on using the changeset viewer.