Ignore:
Timestamp:
2007/11/09 22:30:20 (16 years ago)
Author:
adachi
Message:

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

Location:
branches/feature-module-update/html/install/sql
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/html/install/sql/create_table_mysql.sql

    r16664 r16779  
    407407CREATE TABLE dtb_recommend_products ( 
    408408    product_id int NOT NULL, 
    409     recommend_product_id int, 
     409    recommend_product_id int NOT NULL, 
    410410    rank int NOT NULL, 
    411411    comment text, 
  • branches/feature-module-update/html/install/sql/create_table_pgsql.sql

    r16664 r16779  
    407407CREATE TABLE dtb_recommend_products ( 
    408408    product_id int4 NOT NULL, 
    409     recommend_product_id serial NOT NULL, 
     409    recommend_product_id int4 NOT NULL, 
    410410    rank int4 NOT NULL, 
    411411    comment text, 
  • branches/feature-module-update/html/install/sql/insert_data.sql

    r16775 r16779  
    335335VALUES (2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), now()); 
    336336 
    337 INSERT INTO dtb_recommend_products (product_id,rank,comment,status,creator_id,create_date,update_date) VALUES (2, 4, 'お口直しに。', 0, 2, now(), now()); 
     337INSERT 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()); 
    338338 
    339339INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('味', NULL, 1, 2, now(), now(), 0, NULL); 
     
    804804INSERT INTO mtb_constants VALUES ('TV_PRODUCTS_MAX','10',64,'TV連動商品最大登録数'); 
    805805INSERT INTO mtb_constants VALUES ('DEFAULT_PASSWORD','"UAhgGR3L"',65,'会員登録変更(マイページ)パスワード用'); 
    806 INSERT INTO mtb_constants VALUES ('RECOMMEND_PRODUCT_MAX','6',66,'おすすめ商品数'); 
     806INSERT INTO mtb_constants VALUES ('dtbDUCT_MAX','6',66,'おすすめ商品数'); 
    807807INSERT INTO mtb_constants VALUES ('DELIV_ADDR_MAX','20',67,'別のお届け先最大登録数'); 
    808808INSERT INTO mtb_constants VALUES ('CUSTOMER_READING_MAX','30',68,'閲覧履歴保存数'); 
Note: See TracChangeset for help on using the changeset viewer.