You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by tc...@apache.org on 2009/04/30 19:16:06 UTC
svn commit: r770329 - in
/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql: db2/
firebird/ informix/ ingres/ jdatastore/ mssql/ oracle/ sybase/
Author: tcunning
Date: Thu Apr 30 17:16:06 2009
New Revision: 770329
URL: http://svn.apache.org/viewvc?rev=770329&view=rev
Log:
JUDDI-226
Fix CURRENT_TIMESTAMP to db-specific syntax.
Modified:
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/db2/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/firebird/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/informix/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/ingres/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/jdatastore/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/mssql/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/oracle/create_database.sql
webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/sybase/create_database.sql
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/db2/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/db2/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/db2/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/db2/create_database.sql Thu Apr 30 17:16:06 2009
@@ -725,7 +725,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURRENT TIMESTAMP);
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/firebird/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/firebird/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/firebird/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/firebird/create_database.sql Thu Apr 30 17:16:06 2009
@@ -654,7 +654,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURRENT_DATE);
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/informix/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/informix/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/informix/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/informix/create_database.sql Thu Apr 30 17:16:06 2009
@@ -730,8 +730,8 @@
VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',3,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','wsdlSpec');
-- ** uddi-org:taxonomy_V2
-INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL)
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2');
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/ingres/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/ingres/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/ingres/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/ingres/create_database.sql Thu Apr 30 17:16:06 2009
@@ -725,8 +725,8 @@
VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',3,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','wsdlSpec');
-- ** uddi-org:taxonomy_V2
-INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',current_timestamp);
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL)
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2');
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/jdatastore/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/jdatastore/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/jdatastore/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/jdatastore/create_database.sql Thu Apr 30 17:16:06 2009
@@ -723,7 +723,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURRENT_DATE);
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/mssql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/mssql/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/mssql/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/mssql/create_database.sql Thu Apr 30 17:16:06 2009
@@ -724,7 +724,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',getDate());
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/oracle/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/oracle/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/oracle/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/oracle/create_database.sql Thu Apr 30 17:16:06 2009
@@ -777,7 +777,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',SYSDATE);
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
Modified: webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/sybase/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/sybase/create_database.sql?rev=770329&r1=770328&r2=770329&view=diff
==============================================================================
--- webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/sybase/create_database.sql (original)
+++ webservices/juddi/branches/juddi-2.0rc7/src/main/resources/juddi-sql/sybase/create_database.sql Thu Apr 30 17:16:06 2009
@@ -724,7 +724,7 @@
-- ** uddi-org:taxonomy_V2
INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
-VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',CURTIMESTAMP());
+VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A','Administrator','admin','jUDDI.org','uddi-org:taxonomy_v2','http://www.uddi.org/taxonomies/UDDI_Registry_tModels.htm#TaxV2',getDate());
INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
VALUES ('uuid:1E3E9CBC-F8CE-41ab-8F99-88326BAD324A',0,'en','UDDI Taxonomy API Version 2 - Core Specification');
INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-cvs-help@ws.apache.org