Changeset 18007 for branches/version-2/html/install/sql/create_table_pgsql.sql

Timestamp:

2009/05/15 16:30:40 (14 years ago)

Author:

kajiwara

Message:

2.4.0 正式版のコミット。コミット内容の詳細はこちら（http://svn.ec-cube.net/open_trac/query?status=closed&milestone=EC-CUBE2.4.0）

File:

• branches/version-2/html/install/sql/create_table_pgsql.sql (modified) (3 diffs)

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

@@ -141 +141 @@
     mypage_tpl text,
     good_traded text,
-    message text
+    message text,
+    regular_holiday_ids text
 );
 
@@ -285 +286 @@
     comment5 text,
     comment6 text,
+    note text,
     file1 text,
     file2 text,
@@ -461 +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)
 );