Index: /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql (revision 21840)
+++ /branches/version-2_12-dev/html/install/sql/create_table_mysql.sql (revision 21908)
@@ -393,5 +393,5 @@
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
update_date timestamp NOT NULL,
- PRIMARY KEY (recommend_product_id)
+ PRIMARY KEY (product_id, recommend_product_id)
);
Index: /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql (revision 21840)
+++ /branches/version-2_12-dev/html/install/sql/create_table_pgsql.sql (revision 21908)
@@ -393,5 +393,5 @@
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
update_date timestamp NOT NULL,
- PRIMARY KEY (recommend_product_id)
+ PRIMARY KEY (product_id, recommend_product_id)
);