Changeset 16779

Timestamp:

2007/11/09 22:30:20 (15 years ago)

Author:

adachi

Message:

#180 インストール直後に関連商品が表示されない不具合修正

Location:

branches/feature-module-update/html/install/sql

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• insert_data.sql (modified) (2 diffs)

branches/feature-module-update/html/install/sql/create_table_mysql.sql

@@ -407 +407 @@
 CREATE TABLE dtb_recommend_products (
     product_id int NOT NULL,
-    recommend_product_id int,
+    recommend_product_id int NOT NULL,
     rank int NOT NULL,
     comment text,

branches/feature-module-update/html/install/sql/create_table_pgsql.sql

@@ -407 +407 @@
 CREATE TABLE dtb_recommend_products (
     product_id int4 NOT NULL,
-    recommend_product_id serial NOT NULL,
+    recommend_product_id int4 NOT NULL,
     rank int4 NOT NULL,
     comment text,

branches/feature-module-update/html/install/sql/insert_data.sql

@@ -335 +335 @@
 VALUES (2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), now());
 
-INSERT INTO dtb_recommend_products (product_id,rank,comment,status,creator_id,create_date,update_date) VALUES (2, 4, 'お口直しに。', 0, 2, now(), now());
+INSERT INTO dtb_recommend_products (product_id, recommend_product_id, rank,comment,status,creator_id,create_date,update_date) VALUES (2, 1, 4, 'お口直しに。', 0, 2, now(), now());
 
 INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('味', NULL, 1, 2, now(), now(), 0, NULL);
@@ -804 +804 @@
 INSERT INTO mtb_constants VALUES ('TV_PRODUCTS_MAX','10',64,'TV連動商品最大登録数');
 INSERT INTO mtb_constants VALUES ('DEFAULT_PASSWORD','"UAhgGR3L"',65,'会員登録変更(マイページ)パスワード用');
-INSERT INTO mtb_constants VALUES ('RECOMMEND_PRODUCT_MAX','6',66,'おすすめ商品数');
+INSERT INTO mtb_constants VALUES ('dtbDUCT_MAX','6',66,'おすすめ商品数');
 INSERT INTO mtb_constants VALUES ('DELIV_ADDR_MAX','20',67,'別のお届け先最大登録数');
 INSERT INTO mtb_constants VALUES ('CUSTOMER_READING_MAX','30',68,'閲覧履歴保存数');