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 16:38:36 UTC

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

Author: sviens
Date: Wed Jun 28 07:38:35 2006
New Revision: 417765

URL: http://svn.apache.org/viewvc?rev=417765&view=rev
Log:
Adding maximum publisher values for business entities, services, bindings and tmodels.

Modified:
    webservices/juddi/trunk/sql/daffodildb/create_database.sql
    webservices/juddi/trunk/sql/daffodildb/insert_publishers.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/insert_publishers.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/insert_publishers.sql
    webservices/juddi/trunk/sql/mysql/insert_publishers.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/insert_publishers.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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/daffodildb/create_database.sql (original)
+++ webservices/juddi/trunk/sql/daffodildb/create_database.sql Wed Jun 28 07:38:35 2006
@@ -353,6 +353,10 @@
   EMAIL_ADDRESS VARCHAR(255) ,
   IS_ADMIN VARCHAR(5) ,
   IS_ENABLED VARCHAR(5) ,
+  MAX_BUSINESSES INT NULL,
+  MAX_SERVICES INT NULL,
+  MAX_BINDINGS 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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/daffodildb/insert_publishers.sql Wed Jun 28 07:38:35 2006
@@ -1,3 +1,3 @@
 -- *** SAMPLE PUBLISHER ***
 -- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN)
--- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
+-- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/db2/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/db2/insert_publishers.sql?rev=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/derby/create_database.sql (original)
+++ webservices/juddi/trunk/sql/derby/create_database.sql Wed Jun 28 07:38:35 2006
@@ -381,6 +381,10 @@
   EMAIL_ADDRESS VARCHAR(255),
   IS_ADMIN VARCHAR(5),
   IS_ENABLED VARCHAR(5),
+  MAX_BUSINESSES INT NULL,
+  MAX_SERVICES INT NULL,
+  MAX_BINDINGS 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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/derby/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/derby/insert_publishers.sql Wed Jun 28 07:38:35 2006
@@ -2,4 +2,4 @@
 
 -- *** SAMPLE PUBLISHER ***
 -- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN)
--- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
+-- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/firebird/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/firebird/insert_publishers.sql?rev=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/informix/create_database.sql (original)
+++ webservices/juddi/trunk/sql/informix/create_database.sql Wed Jun 28 07:38:35 2006
@@ -383,6 +383,10 @@
   EMAIL_ADDRESS VARCHAR(255),
   IS_ADMIN VARCHAR(5),
   IS_ENABLED VARCHAR(5),
+  MAX_BUSINESSES INT NULL,
+  MAX_SERVICES INT NULL,
+  MAX_BINDINGS 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=417765&r1=417764&r2=417765&view=diff
==============================================================================
--- webservices/juddi/trunk/sql/informix/insert_publishers.sql (original)
+++ webservices/juddi/trunk/sql/informix/insert_publishers.sql Wed Jun 28 07:38:35 2006
@@ -2,4 +2,4 @@
 
 -- *** SAMPLE PUBLISHER ***
 INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,IS_ENABLED,IS_ADMIN)
- VALUES ('juddi','Lichun Zhu','zhu19@uwindsor.ca','true','true');
+ VALUES ('juddi','Lichun Zhu','zhu19@uwindsor.ca','true','true',25,20,10,100);

Modified: webservices/juddi/trunk/sql/jdatastore/insert_publishers.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/sql/jdatastore/insert_publishers.sql?rev=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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=417765&r1=417764&r2=417765&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