Changeset 20351

Timestamp:

2011/02/23 19:43:29 (13 years ago)

Author:

fukuda

Message:

viewイラネ、メールテンプレートのムダカラムイラネ。( ﾟдﾟ)､ﾍﾟｯ

Location:

branches/version-2_5-dev/html/install

Files:

• index.php (modified) (2 diffs)
• sql/create_table_mysql.sql (modified) (1 diff)
• sql/create_table_pgsql.sql (modified) (1 diff)
• sql/create_view.sql (deleted)
• sql/drop_view.sql (deleted)

branches/version-2_5-dev/html/install/index.php

@@ -151 +151 @@
     }
 
-    // ビューの作成
-    if(count($objPage->arrErr) == 0 and $arrRet['db_type'] == 'pgsql') {
-        // ビューの作成
-        $objPage->arrErr = lfExecuteSQL("./sql/create_view.sql", $dsn);
-        if(count($objPage->arrErr) == 0) {
-            $objPage->tpl_message.="○：ビューの作成に成功しました。<br>";
-        } else {
-            $objPage->tpl_message.="×：ビューの作成に失敗しました。<br>";
-        }
-    }
-
     // 初期データの作成
     if(count($objPage->arrErr) == 0) {
@@ -201 +190 @@
     }
     $dsn = $arrRet['db_type']."://".$arrRet['db_user'].":".$arrRet['db_password']."@".$arrRet['db_server'].":".$arrRet['db_port']."/".$arrRet['db_name'];
-
-    if ($arrRet['db_type'] == 'pgsql'){
-        // ビューの削除
-        $objPage->arrErr = lfExecuteSQL("./sql/drop_view.sql", $dsn, false);
-        if(count($objPage->arrErr) == 0) {
-            $objPage->tpl_message.="○：ビューの削除に成功しました。<br>";
-        } else {
-            $objPage->tpl_message.="×：ビューの削除に失敗しました。<br>";
-        }
-    }
 
     // テーブルの削除

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -240 +240 @@
     subject text,
     mail_method int,
-    header text,
     body text,
-    main_title text,
-    main_comment text,
-    main_product_id int,
-    sub_title text,
-    sub_comment text,
-    sub_product_id01 int,
-    sub_product_id02 int,
-    sub_product_id03 int,
-    sub_product_id04 int,
-    sub_product_id05 int,
-    sub_product_id06 int,
-    sub_product_id07 int,
-    sub_product_id08 int,
-    sub_product_id09 int,
-    sub_product_id10 int,
-    sub_product_id11 int,
-    sub_product_id12 int,
     del_flg smallint NOT NULL DEFAULT 0,
     creator_id int NOT NULL,

branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

@@ -240 +240 @@
     subject text,
     mail_method int,
-    header text,
     body text,
-    main_title text,
-    main_comment text,
-    main_product_id int,
-    sub_title text,
-    sub_comment text,
-    sub_product_id01 int,
-    sub_product_id02 int,
-    sub_product_id03 int,
-    sub_product_id04 int,
-    sub_product_id05 int,
-    sub_product_id06 int,
-    sub_product_id07 int,
-    sub_product_id08 int,
-    sub_product_id09 int,
-    sub_product_id10 int,
-    sub_product_id11 int,
-    sub_product_id12 int,
     del_flg smallint NOT NULL DEFAULT 0,
     creator_id int NOT NULL,