svnno****@sourc*****
svnno****@sourc*****
2007年 8月 26日 (日) 22:46:24 JST
Revision: 496
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=496
Author: shinsuke
Date: 2007-08-26 22:46:23 +0900 (Sun, 26 Aug 2007)
Log Message:
-----------
added foreign key for delivery_method
Modified Paths:
--------------
pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
-------------- next part --------------
Modified: pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql
===================================================================
--- pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-25 23:16:35 UTC (rev 495)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-26 13:46:23 UTC (rev 496)
@@ -599,3 +599,7 @@
ALTER TABLE products_attributes
ADD FOREIGN KEY (products_id)
REFERENCES products (products_id);
+ALTER TABLE delivery_method_description
+ ADD FOREIGN KEY (delivery_method_id)
+ REFERENCES delivery_method (delivery_method_id);
+