You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by sv...@apache.org on 2006/06/28 22:02:36 UTC

svn commit: r417862 - in /webservices/juddi/trunk/sql: daffodildb/ db2/ derby/ firebird/ hsqldb/ informix/ jdatastore/ mysql/ oracle/ postgresql/ sybase/ totalxml/

Author: sviens
Date: Wed Jun 28 13:02:34 2006
New Revision: 417862

URL: http://svn.apache.org/viewvc?rev=417862&view=rev
Log:
Updated MAX_XXX column names to coincide with the attribute and variable names used in the Java source.

Modified:
    webservices/juddi/trunk/sql/daffodildb/create_database.sql
    webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql
    webservices/juddi/trunk/sql/db2/create_database.sql
    webservices/juddi/trunk/sql/db2/insert_publishers.sql
    webservices/juddi/trunk/sql/derby/create_database.sql
    webservices/juddi/trunk/sql/derby/insert_publishers.sql
    webservices/juddi/trunk/sql/firebird/create_database.sql
    webservices/juddi/trunk/sql/firebird/insert_publishers.sql
    webservices/juddi/trunk/sql/hsqldb/create_database.sql
    webservices/juddi/trunk/sql/hsqldb/insert_publishers.sql
    webservices/juddi/trunk/sql/informix/create_database.sql
    webservices/juddi/trunk/sql/informix/insert_publishers.sql
    webservices/juddi/trunk/sql/jdatastore/create_database.sql
    webservices/juddi/trunk/sql/jdatastore/insert_publishers.sql
    webservices/juddi/trunk/sql/mysql/create_database.sql
    webservices/juddi/trunk/sql/mysql/insert_publishers.sql
    webservices/juddi/trunk/sql/oracle/create_database.sql
    webservices/juddi/trunk/sql/oracle/insert_publishers.sql
    webservices/juddi/trunk/sql/postgresql/create_database.sql
    webservices/juddi/trunk/sql/postgresql/insert_publishers.sql
    webservices/juddi/trunk/sql/sybase/create_database.sql
    webservices/juddi/trunk/sql/sybase/insert_publishers.sql
    webservices/juddi/trunk/sql/totalxml/create_database.sql
    webservices/juddi/trunk/sql/totalxml/insert_publishers.sql

Modified: webservices/juddi/trunk/sql/daffodildb/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/daffodildb/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/daffodildb/create_database.sql (original)
+++ webservices/juddi/trunk/sql/daffodildb/create_database.sql Wed Jun 28 13:02:34 2006
@@ -354,8 +354,8 @@
   IS_ADMIN VARCHAR(5) ,
   IS_ENABLED VARCHAR(5) ,
   MAX_BUSINESSES INT NULL,
-  MAX_SERVICES INT NULL,
-  MAX_BINDINGS INT NULL,
+  MAX_SERVICES_PER_BUSINESS INT NULL,
+  MAX_BINDINGS_PER_SERVICE INT NULL,
   MAX_TMODELS INT NULL,
   PRIMARY KEY (PUBLISHER_ID)
 )

Modified: webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql Wed Jun 28 13:02:34 2006
@@ -1,3 +1,3 @@
 -- *** SAMPLE PUBLISHER ***
--- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES,MAX_BINDINGS,MAX_TMODELS)
+-- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES_PER_BUSINESS,MAX_BINDINGS_PER_SERVICE,MAX_TMODELS)
 -- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/db2/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/db2/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/db2/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/db2/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/derby/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/derby/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/derby/create_database.sql (original)
+++ webservices/juddi/trunk/sql/derby/create_database.sql Wed Jun 28 13:02:34 2006
@@ -382,8 +382,8 @@
   IS_ADMIN VARCHAR(5),
   IS_ENABLED VARCHAR(5),
   MAX_BUSINESSES INT NULL,
-  MAX_SERVICES INT NULL,
-  MAX_BINDINGS INT NULL,
+  MAX_SERVICES_PER_BUSINESS INT NULL,
+  MAX_BINDINGS_PER_SERVICE INT NULL,
   MAX_TMODELS INT NULL,
   PRIMARY KEY (PUBLISHER_ID)
 );

Modified: webservices/juddi/trunk/sql/derby/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/derby/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/derby/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/derby/insert_publishers.sql Wed Jun 28 13:02:34 2006
@@ -1,5 +1,5 @@
 USE juddi;
 
 -- *** SAMPLE PUBLISHER ***
--- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES,MAX_BINDINGS,MAX_TMODELS)
+-- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES_PER_BUSINESS,MAX_BINDINGS_PER_SERVICE,MAX_TMODELS)
 -- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/firebird/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/firebird/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/firebird/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/firebird/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/hsqldb/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/hsqldb/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/hsqldb/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/hsqldb/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/informix/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/informix/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/informix/create_database.sql (original)
+++ webservices/juddi/trunk/sql/informix/create_database.sql Wed Jun 28 13:02:34 2006
@@ -384,8 +384,8 @@
   IS_ADMIN VARCHAR(5),
   IS_ENABLED VARCHAR(5),
   MAX_BUSINESSES INT NULL,
-  MAX_SERVICES INT NULL,
-  MAX_BINDINGS INT NULL,
+  MAX_SERVICES_PER_BUSINESS INT NULL,
+  MAX_BINDINGS_PER_SERVICE INT NULL,
   MAX_TMODELS INT NULL,
   PRIMARY KEY (PUBLISHER_ID)
 );

Modified: webservices/juddi/trunk/sql/informix/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/informix/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/informix/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/informix/insert_publishers.sql Wed Jun 28 13:02:34 2006
@@ -1,5 +1,5 @@
 database juddi;
 
 -- *** SAMPLE PUBLISHER ***
-INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES,MAX_BINDINGS,MAX_TMODELS)
+INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN,MAX_BUSINESSES,MAX_SERVICES_PER_BUSINESS,MAX_BINDINGS_PER_SERVICE,MAX_TMODELS)
  VALUES ('juddi','Lichun Zhu','zhu19@uwindsor.ca','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/jdatastore/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/jdatastore/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/jdatastore/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/jdatastore/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/mysql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/mysql/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/mysql/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/mysql/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/oracle/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/oracle/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/oracle/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/oracle/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/postgresql/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/postgresql/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/postgresql/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/postgresql/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/sybase/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/sybase/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/sybase/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/sybase/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/totalxml/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/totalxml/create_database.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.

Modified: webservices/juddi/trunk/sql/totalxml/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/totalxml/insert_publishers.sql?rev=417862&r1=417861&r2=417862&view=diff
==============================================================================
Binary files - no diff available.



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