You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by ks...@apache.org on 2007/10/22 20:57:18 UTC
svn commit: r587196 - in /webservices/juddi/trunk: ./
src/main/resources/juddi-sql/daffodildb/ src/main/resources/juddi-sql/db2/
src/main/resources/juddi-sql/derby/ src/main/resources/juddi-sql/firebird/
src/main/resources/juddi-sql/hsqldb/ src/main/re...
Author: kstam
Date: Mon Oct 22 11:57:15 2007
New Revision: 587196
URL: http://svn.apache.org/viewvc?rev=587196&view=rev
Log:
JUDDI-117 increasing the max size of the ACCESS_POINT_URL field.
Modified:
webservices/juddi/trunk/ (props changed)
webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/derby/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/firebird/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/hsqldb/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/informix/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/jdatastore/create_database.sql
webservices/juddi/trunk/src/main/resources/juddi-sql/mysql/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
Propchange: webservices/juddi/trunk/
------------------------------------------------------------------------------
--- svn:ignore (original)
+++ svn:ignore Mon Oct 22 11:57:15 2007
@@ -3,3 +3,4 @@
.classpath
.project
target
+.settings
Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql?rev=587196&r1=587195&r2=587196&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql Mon Oct 22 11:57:15 2007
@@ -193,7 +193,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) ,
- ACCESS_POINT_URL VARCHAR(255) ,
+ ACCESS_POINT_URL VARCHAR(2000) ,
HOSTING_REDIRECTOR VARCHAR(255) ,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
@@ -221,7 +221,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) ,
- ACCESS_POINT_URL VARCHAR(255) ,
+ ACCESS_POINT_URL VARCHAR(2000) ,
HOSTING_REDIRECTOR VARCHAR(255) ,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/derby/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/derby/create_database.sql?rev=587196&r1=587195&r2=587196&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/derby/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/derby/create_database.sql Mon Oct 22 11:57:15 2007
@@ -189,7 +189,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) ,
- ACCESS_POINT_URL VARCHAR(255) ,
+ ACCESS_POINT_URL VARCHAR(2000) ,
HOSTING_REDIRECTOR VARCHAR(255) ,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -59,7 +59,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20),
- ACCESS_POINT_URL VARCHAR(255),
+ ACCESS_POINT_URL VARCHAR(2000),
HOSTING_REDIRECTOR VARCHAR(255),
LAST_UPDATE TIMESTAMP NOT NULL
);
Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/hsqldb/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/hsqldb/create_database.sql?rev=587196&r1=587195&r2=587196&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/hsqldb/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/hsqldb/create_database.sql Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
(
@@ -220,7 +220,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
- ACCESS_POINT_URL VARCHAR(255) NULL,
+ ACCESS_POINT_URL VARCHAR(2000) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,36 +1,36 @@
database juddi;
---DROP TABLE BUSINESS_DESCR;
---DROP TABLE BUSINESS_CATEGORY;
---DROP TABLE BUSINESS_IDENTIFIER;
---DROP TABLE BUSINESS_NAME;
---DROP TABLE DISCOVERY_URL;
---DROP TABLE ADDRESS_LINE;
---DROP TABLE ADDRESS;
---DROP TABLE PHONE;
---DROP TABLE EMAIL;
---DROP TABLE CONTACT_DESCR;
---DROP TABLE CONTACT;
---DROP TABLE SERVICE_DESCR;
---DROP TABLE SERVICE_CATEGORY;
---DROP TABLE SERVICE_NAME;
---DROP TABLE BINDING_DESCR;
---DROP TABLE BINDING_CATEGORY;
---DROP TABLE INSTANCE_DETAILS_DESCR;
---DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
---DROP TABLE TMODEL_CATEGORY;
---DROP TABLE TMODEL_DESCR;
---DROP TABLE TMODEL_DOC_DESCR;
---DROP TABLE TMODEL_IDENTIFIER;
---DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
---DROP TABLE TMODEL_INSTANCE_INFO;
---DROP TABLE PUBLISHER_ASSERTION;
---DROP TABLE TMODEL;
---DROP TABLE BINDING_TEMPLATE;
---DROP TABLE BUSINESS_SERVICE;
---DROP TABLE BUSINESS_ENTITY;
---DROP TABLE PUBLISHER;
---DROP TABLE AUTH_TOKEN;
+--DROP TABLE ${prefix}BUSINESS_DESCR;
+--DROP TABLE ${prefix}BUSINESS_CATEGORY;
+--DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+--DROP TABLE ${prefix}BUSINESS_NAME;
+--DROP TABLE ${prefix}DISCOVERY_URL;
+--DROP TABLE ${prefix}ADDRESS_LINE;
+--DROP TABLE ${prefix}ADDRESS;
+--DROP TABLE ${prefix}PHONE;
+--DROP TABLE ${prefix}EMAIL;
+--DROP TABLE ${prefix}CONTACT_DESCR;
+--DROP TABLE ${prefix}CONTACT;
+--DROP TABLE ${prefix}SERVICE_DESCR;
+--DROP TABLE ${prefix}SERVICE_CATEGORY;
+--DROP TABLE ${prefix}SERVICE_NAME;
+--DROP TABLE ${prefix}BINDING_DESCR;
+--DROP TABLE ${prefix}BINDING_CATEGORY;
+--DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+--DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+--DROP TABLE ${prefix}TMODEL_CATEGORY;
+--DROP TABLE ${prefix}TMODEL_DESCR;
+--DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+--DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+--DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+--DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+--DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+--DROP TABLE ${prefix}TMODEL;
+--DROP TABLE ${prefix}BINDING_TEMPLATE;
+--DROP TABLE ${prefix}BUSINESS_SERVICE;
+--DROP TABLE ${prefix}BUSINESS_ENTITY;
+--DROP TABLE ${prefix}PUBLISHER;
+--DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
@@ -223,7 +223,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) ,
- ACCESS_POINT_URL VARCHAR(255) ,
+ ACCESS_POINT_URL LVARCHAR(2000) ,
HOSTING_REDIRECTOR VARCHAR(255) ,
LAST_UPDATE DATETIME YEAR TO FRACTION DEFAULT CURRENT NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
(
@@ -220,7 +220,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
- ACCESS_POINT_URL VARCHAR(255) NULL,
+ ACCESS_POINT_URL VARCHAR(2000) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -189,7 +189,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
- ACCESS_POINT_URL VARCHAR(255) NULL,
+ ACCESS_POINT_URL VARCHAR(2000) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
(
@@ -235,7 +235,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
- ACCESS_POINT_URL VARCHAR(255) NULL,
+ ACCESS_POINT_URL VARCHAR(2000) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL DEFAULT now(),
CONSTRAINT FK_BINDING_TEMPLATE_01 FOREIGN KEY (SERVICE_KEY)
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
(
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=587196&r1=587195&r2=587196&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 Mon Oct 22 11:57:15 2007
@@ -1,34 +1,34 @@
--- DROP TABLE BUSINESS_DESCR;
--- DROP TABLE BUSINESS_CATEGORY;
--- DROP TABLE BUSINESS_IDENTIFIER;
--- DROP TABLE BUSINESS_NAME;
--- DROP TABLE DISCOVERY_URL;
--- DROP TABLE ADDRESS_LINE;
--- DROP TABLE ADDRESS;
--- DROP TABLE PHONE;
--- DROP TABLE EMAIL;
--- DROP TABLE CONTACT_DESCR;
--- DROP TABLE CONTACT;
--- DROP TABLE SERVICE_DESCR;
--- DROP TABLE SERVICE_CATEGORY;
--- DROP TABLE SERVICE_NAME;
--- DROP TABLE BINDING_DESCR;
--- DROP TABLE BINDING_CATEGORY;
--- DROP TABLE INSTANCE_DETAILS_DESCR;
--- DROP TABLE INSTANCE_DETAILS_DOC_DESCR;
--- DROP TABLE TMODEL_CATEGORY;
--- DROP TABLE TMODEL_DESCR;
--- DROP TABLE TMODEL_DOC_DESCR;
--- DROP TABLE TMODEL_IDENTIFIER;
--- DROP TABLE TMODEL_INSTANCE_INFO_DESCR;
--- DROP TABLE TMODEL_INSTANCE_INFO;
--- DROP TABLE PUBLISHER_ASSERTION;
--- DROP TABLE TMODEL;
--- DROP TABLE BINDING_TEMPLATE;
--- DROP TABLE BUSINESS_SERVICE;
--- DROP TABLE BUSINESS_ENTITY;
--- DROP TABLE PUBLISHER;
--- DROP TABLE AUTH_TOKEN;
+-- DROP TABLE ${prefix}BUSINESS_DESCR;
+-- DROP TABLE ${prefix}BUSINESS_CATEGORY;
+-- DROP TABLE ${prefix}BUSINESS_IDENTIFIER;
+-- DROP TABLE ${prefix}BUSINESS_NAME;
+-- DROP TABLE ${prefix}DISCOVERY_URL;
+-- DROP TABLE ${prefix}ADDRESS_LINE;
+-- DROP TABLE ${prefix}ADDRESS;
+-- DROP TABLE ${prefix}PHONE;
+-- DROP TABLE ${prefix}EMAIL;
+-- DROP TABLE ${prefix}CONTACT_DESCR;
+-- DROP TABLE ${prefix}CONTACT;
+-- DROP TABLE ${prefix}SERVICE_DESCR;
+-- DROP TABLE ${prefix}SERVICE_CATEGORY;
+-- DROP TABLE ${prefix}SERVICE_NAME;
+-- DROP TABLE ${prefix}BINDING_DESCR;
+-- DROP TABLE ${prefix}BINDING_CATEGORY;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DESCR;
+-- DROP TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_CATEGORY;
+-- DROP TABLE ${prefix}TMODEL_DESCR;
+-- DROP TABLE ${prefix}TMODEL_DOC_DESCR;
+-- DROP TABLE ${prefix}TMODEL_IDENTIFIER;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR;
+-- DROP TABLE ${prefix}TMODEL_INSTANCE_INFO;
+-- DROP TABLE ${prefix}PUBLISHER_ASSERTION;
+-- DROP TABLE ${prefix}TMODEL;
+-- DROP TABLE ${prefix}BINDING_TEMPLATE;
+-- DROP TABLE ${prefix}BUSINESS_SERVICE;
+-- DROP TABLE ${prefix}BUSINESS_ENTITY;
+-- DROP TABLE ${prefix}PUBLISHER;
+-- DROP TABLE ${prefix}AUTH_TOKEN;
CREATE TABLE ${prefix}BUSINESS_ENTITY
(
@@ -220,7 +220,7 @@
SERVICE_KEY VARCHAR(41) NOT NULL,
BINDING_KEY VARCHAR(41) NOT NULL,
ACCESS_POINT_TYPE VARCHAR(20) NULL,
- ACCESS_POINT_URL VARCHAR(255) NULL,
+ ACCESS_POINT_URL VARCHAR(2000) NULL,
HOSTING_REDIRECTOR VARCHAR(255) NULL,
LAST_UPDATE TIMESTAMP NOT NULL,
PRIMARY KEY (BINDING_KEY),
---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-cvs-help@ws.apache.org