[Svn-src-all:2777] [version-2_12-dev 21676] #1718 (カテゴリブロックのカテゴリが多重表示される場合がある)

[Seasoft]

Subversion committed to /home/svn/open 21676
http://svn.ec-cube.net/open_trac/changeset/21676
┌────────────────────────────┐
│更新者　:  Seasoft                                      │
│更新日時:  2012-03-26 14:30:52 +0900 (月, 26  3月 2012)│
└────────────────────────────┘

Log:
--------------------------------------------------------
#1718 (カテゴリブロックのカテゴリが多重表示される場合がある)

Changed:                      [U:修正，A:追加，D:削除]
--------------------------------------------------------
U   branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql

変更: branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	2012-03-26 04:37:42 UTC (rev 21675)
+++ branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql	2012-03-26 05:30:52 UTC (rev 21676)
@@ -418,13 +418,15 @@
 CREATE TABLE dtb_category_count (
     category_id int NOT NULL,
     product_count int NOT NULL,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY (category_id)
 );
 
 CREATE TABLE dtb_category_total_count (
     category_id int NOT NULL,
     product_count int,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY (category_id)
 );
 
 CREATE TABLE dtb_news (