svnno****@sourc*****
svnno****@sourc*****
2007年 8月 26日 (日) 08:16:36 JST
Revision: 495
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=495
Author: shinsuke
Date: 2007-08-26 08:16:35 +0900 (Sun, 26 Aug 2007)
Log Message:
-----------
wrong primary key. added delivery class.
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 22:50:45 UTC (rev 494)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-25 23:16:35 UTC (rev 495)
@@ -462,10 +462,11 @@
CREATE TABLE delivery_method (
delivery_method_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
+ delivery_class varchar(128) NOT NULL,
sort_order int,
date_added TIMESTAMP,
last_modified TIMESTAMP,
- PRIMARY KEY (categories_id)
+ PRIMARY KEY (delivery_method_id)
);
--DROP TABLE delivery_method_description;