svnno****@sourc*****
svnno****@sourc*****
2007年 8月 24日 (金) 22:07:31 JST
Revision: 482
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=pal&view=rev&rev=482
Author: shinsuke
Date: 2007-08-24 22:07:31 +0900 (Fri, 24 Aug 2007)
Log Message:
-----------
added portal id
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-24 12:20:45 UTC (rev 481)
+++ pompei/portlets/pompei-core/trunk/src/main/webapp/WEB-INF/db/create_table.sql 2007-08-24 13:07:31 UTC (rev 482)
@@ -139,6 +139,7 @@
CREATE TABLE customers (
customers_id int NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
+ customers_portal_id varchar(255) NOT NULL,
customers_gender char(1) NOT NULL,
customers_firstname varchar(32) NOT NULL,
customers_lastname varchar(32) NOT NULL,