Changeset 17931 for branches/version-2_4/html/install

Timestamp:

2009/03/25 21:53:25 (17 years ago)

Author:

kishida

Message:

お気に入り商品機能

Location:

branches/version-2_4/html/install/sql

Files:

• add/create_table_mysql.sql (added)
• create_table_mysql.sql (deleted)
• create_table_pgsql.sql (modified) (1 diff)
• drop_table.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

branches/version-2_4/html/install/sql/create_table_pgsql.sql

@@ -463 +463 @@
     create_date timestamp NOT NULL,
     update_date timestamp NOT NULL DEFAULT NOW()
+);
+
+CREATE TABLE dtb_customer_favorite_products (
+    customer_id int4 NOT NULL,
+    product_id int4 NOT NULL,
+    create_date timestamp NOT NULL DEFAULT now(),
+    update_date timestamp NOT NULL DEFAULT now(),
+    PRIMARY KEY (customer_id, product_id)
 );
 

branches/version-2_4/html/install/sql/drop_table.sql

@@ -93 +93 @@
 DROP TABLE mtb_ownersstore_ips;
 DROP TABLE dtb_holiday;
+DROP TABLE dtb_customer_favorite_products;

branches/version-2_4/html/install/sql/insert_data.sql

@@ -1109 +1109 @@
 INSERT INTO mtb_constants VALUES ('OSTORE_E_C_PERMISSION', '"2009"', 521, 'オーナーズストア通信エラーコード');
 INSERT INTO mtb_constants VALUES ('OSTORE_E_C_BATCH_ERR', '"2010"', 522, 'オーナーズストア通信エラーコード');
+INSERT INTO mtb_constants VALUES ('OPTION_FAVOFITE_PRODUCT','1',523,'お気に入り商品登録(有効:1 無効:0)');
 
 INSERT INTO dtb_module (module_id,module_code,module_name,update_date,create_date)values(0,0,'patch',now(),now());