Changeset 17162 for branches/comu-ver2/html

Timestamp:

2008/03/17 22:54:44 (16 years ago)

Author:

Yammy

Message:

http://svn.ec-cube.net/open_trac/ticket/254
お気に入り商品登録機能 一式コミット

Location:

branches/comu-ver2/html

Files:

• install/sql/create_table_mysql.sql (modified) (1 diff)
• install/sql/create_table_pgsql.sql (modified) (1 diff)
• install/sql/insert_data.sql (modified) (1 diff)
• mypage/favorite.php (added)

branches/comu-ver2/html/install/sql/create_table_mysql.sql

@@ -461 +461 @@
     create_date datetime NOT NULL,
     update_date datetime NOT NULL
+) TYPE=InnoDB ;
+
+CREATE TABLE dtb_customer_favorite_products (
+    customer_id int NOT NULL,
+    product_id int NOT NULL,
+    create_date datetime NOT NULL,
+    update_date datetime NOT NULL,
 ) TYPE=InnoDB ;
 

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -461 +461 @@
     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/comu-ver2/html/install/sql/insert_data.sql

@@ -1114 +1114 @@
 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());