juddi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tcunn...@apache.org
Subject svn commit: r770333 - in /webservices/juddi/trunk/src/main/resources/juddi-sql: db2/ firebird/ informix/ ingres/ jdatastore/ mssql/ mysql/ oracle/ postgresql/ sybase/ totalxml/
Date Thu, 30 Apr 2009 17:25:28 GMT
Author: tcunning
Date: Thu Apr 30 17:25:28 2009
New Revision: 770333

URL: http://svn.apache.org/viewvc?rev=770333&view=rev
Log:
JUDDI-226
Change CURRENT_TIMESTAMP to db-specific syntax.

Modified:
    webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/firebird/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/informix/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/ingres/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/mssql/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/mysql/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/oracle/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/postgresql/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/sybase/create_database.sql
    webservices/juddi/trunk/src/main/resources/juddi-sql/totalxml/create_database.sql

Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql Thu Apr 30
17:25:28 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/trunk/src/main/resources/juddi-sql/firebird/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/firebird/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/firebird/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/firebird/create_database.sql Thu
Apr 30 17:25:28 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/trunk/src/main/resources/juddi-sql/informix/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/informix/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/informix/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/informix/create_database.sql Thu
Apr 30 17:25:28 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/trunk/src/main/resources/juddi-sql/ingres/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/ingres/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/ingres/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/ingres/create_database.sql Thu Apr
30 17:25:28 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/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql Thu
Apr 30 17:25:28 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/trunk/src/main/resources/juddi-sql/mssql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/mssql/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/mssql/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/mssql/create_database.sql Thu Apr
30 17:25:28 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/trunk/src/main/resources/juddi-sql/mysql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/mysql/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/mysql/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/mysql/create_database.sql Thu Apr
30 17:25:28 2009
@@ -669,7 +669,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',CURRENT_TIMESTAMP());
+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',CURDATE());
 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/trunk/src/main/resources/juddi-sql/oracle/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/oracle/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/oracle/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/oracle/create_database.sql Thu Apr
30 17:25:28 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/trunk/src/main/resources/juddi-sql/postgresql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/postgresql/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/postgresql/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/postgresql/create_database.sql Thu
Apr 30 17:25:28 2009
@@ -726,8 +726,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/trunk/src/main/resources/juddi-sql/sybase/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/sybase/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/sybase/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/sybase/create_database.sql Thu Apr
30 17:25:28 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/trunk/src/main/resources/juddi-sql/totalxml/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/totalxml/create_database.sql?rev=770333&r1=770332&r2=770333&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/totalxml/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/totalxml/create_database.sql Thu
Apr 30 17:25:28 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',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)



---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-cvs-help@ws.apache.org


Mime
View raw message