Index: branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- branches/version-2_5-dev/html/install/sql/create_table_mysql.sql	(revision 20319)
+++ branches/version-2_5-dev/html/install/sql/create_table_mysql.sql	(revision 20351)
@@ -240,23 +240,5 @@
     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,
Index: branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql	(revision 20319)
+++ branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql	(revision 20351)
@@ -240,23 +240,5 @@
     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,
Index: branches/version-2_5-dev/html/install/sql/create_view.sql
===================================================================
--- branches/version-2_5-dev/html/install/sql/create_view.sql	(revision 20116)
+++ 	(revision )
@@ -1,96 +1,0 @@
-CREATE VIEW vw_products_allclass_detail AS
-    SELECT
-        dtb_products.product_id,
-        dtb_products."name",
-        dtb_products.maker_id,
-        dtb_products.status,
-        dtb_products.comment1,
-        dtb_products.comment2,
-        dtb_products.comment3,
-        dtb_products.comment4,
-        dtb_products.comment5,
-        dtb_products.comment6,
-        dtb_products.note,
-        dtb_products.main_list_comment,
-        dtb_products.main_list_image,
-        dtb_products.main_comment,
-        dtb_products.main_image,
-        dtb_products.main_large_image,
-        dtb_products.sub_title1,
-        dtb_products.sub_comment1,
-        dtb_products.sub_image1,
-        dtb_products.sub_large_image1,
-        dtb_products.sub_title2,
-        dtb_products.sub_comment2,
-        dtb_products.sub_image2,
-        dtb_products.sub_large_image2,
-        dtb_products.sub_title3,
-        dtb_products.sub_comment3,
-        dtb_products.sub_image3,
-        dtb_products.sub_large_image3,
-        dtb_products.sub_title4,
-        dtb_products.sub_comment4,
-        dtb_products.sub_image4,
-        dtb_products.sub_large_image4,
-        dtb_products.sub_title5,
-        dtb_products.sub_comment5,
-        dtb_products.sub_image5,
-        dtb_products.sub_large_image5,
-        dtb_products.sub_title6,
-        dtb_products.sub_comment6,
-        dtb_products.sub_image6,
-        dtb_products.sub_large_image6,
-        dtb_products.del_flg,
-        dtb_products.creator_id,
-        dtb_products.create_date,
-        dtb_products.update_date,
-        dtb_products.deliv_date_id,
-        T4.product_code_min,
-        T4.product_code_max,
-        T4.price01_min,
-        T4.price01_max,
-        T4.price02_min,
-        T4.price02_max,
-        T4.stock_min,
-        T4.stock_max,
-        T4.stock_unlimited_min,
-        T4.stock_unlimited_max,
-        T4.class_count
-    FROM
-        dtb_products
-        LEFT JOIN
-            (
-                SELECT
-                    product_id,
-                    MIN(product_code) AS product_code_min,
-                    MAX(product_code) AS product_code_max,
-                    MIN(price01) AS price01_min,
-                    MAX(price01) AS price01_max,
-                    MIN(price02) AS price02_min,
-                    MAX(price02) AS price02_max,
-                    MIN(stock) AS stock_min,
-                    MAX(stock) AS stock_max,
-                    MIN(stock_unlimited) AS stock_unlimited_min,
-                    MAX(stock_unlimited) AS stock_unlimited_max,
-                    COUNT(*) as class_count
-                FROM dtb_products_class
-                GROUP BY product_id
-            ) AS T4
-            ON dtb_products.product_id = T4.product_id
-;
-
-CREATE VIEW vw_products_allclass AS
-    SELECT
-        alldtl.*,
-        dtb_category.rank AS category_rank,
-        T2.category_id,
-        T2.rank AS product_rank
-    FROM
-        vw_products_allclass_detail AS alldtl
-        LEFT JOIN
-            dtb_product_categories AS T2
-            ON alldtl.product_id = T2.product_id
-        LEFT JOIN
-            dtb_category
-            ON T2.category_id = dtb_category.category_id
-;
Index: branches/version-2_5-dev/html/install/sql/drop_view.sql
===================================================================
--- branches/version-2_5-dev/html/install/sql/drop_view.sql	(revision 20116)
+++ 	(revision )
@@ -1,2 +1,0 @@
-DROP VIEW vw_products_allclass;
-DROP VIEW vw_products_allclass_detail;