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 2013/05/15 21:53:56 UTC
svn commit: r1483048 - in /juddi/trunk/docs/db/ddl: README.txt db2.ddl
derby.ddl mysql.ddl mysql5.ddl mysql5InnoDB.ddl oracle9.ddl postgres.ddl
sqlserver.ddl sybase.ddl
Author: kstam
Date: Wed May 15 19:53:55 2013
New Revision: 1483048
URL: http://svn.apache.org/r1483048
Log:
regenerating ddls to reflect field lengths specified in the spec
Modified:
juddi/trunk/docs/db/ddl/README.txt
juddi/trunk/docs/db/ddl/db2.ddl
juddi/trunk/docs/db/ddl/derby.ddl
juddi/trunk/docs/db/ddl/mysql.ddl
juddi/trunk/docs/db/ddl/mysql5.ddl
juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl
juddi/trunk/docs/db/ddl/oracle9.ddl
juddi/trunk/docs/db/ddl/postgres.ddl
juddi/trunk/docs/db/ddl/sqlserver.ddl
juddi/trunk/docs/db/ddl/sybase.ddl
Modified: juddi/trunk/docs/db/ddl/README.txt
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/README.txt?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/README.txt (original)
+++ juddi/trunk/docs/db/ddl/README.txt Wed May 15 19:53:55 2013
@@ -26,7 +26,7 @@ Dialects can be found at https://www.hib
DB2Dialect
DerbyDialect
-MySQLDBDialect
+MySQLDialect
MySQL5InnoDBDialect
Oracle9Dialect
PostgreSQLDialect
Modified: juddi/trunk/docs/db/ddl/db2.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/db2.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/db2.ddl (original)
+++ juddi/trunk/docs/db/ddl/db2.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id bigint generated by default as identity,
sort_code varchar(10),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255),
- access_point_url varchar(4000),
+ access_point_url varchar(4096),
hosting_redirector varchar(255),
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id bigint generated by default as identity,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id bigint not null,
primary key (id)
);
create table j3_discovery_url (
id bigint generated by default as identity,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id bigint generated by default as identity,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255),
contact_id bigint not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id bigint generated by default as identity,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id bigint,
primary key (id)
);
create table j3_person_name (
id bigint generated by default as identity,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id bigint not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id bigint generated by default as identity,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id bigint generated by default as identity,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted smallint,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id bigint generated by default as identity,
- instance_parms varchar(512),
+ instance_parms varchar(8192),
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id bigint generated by default as identity,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/derby.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/derby.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/derby.ddl (original)
+++ juddi/trunk/docs/db/ddl/derby.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id bigint not null,
sort_code varchar(10),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255),
- access_point_url varchar(4000),
+ access_point_url varchar(4096),
hosting_redirector varchar(255),
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id bigint not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id bigint not null,
primary key (id)
);
create table j3_discovery_url (
id bigint not null,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id bigint not null,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255),
contact_id bigint not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id bigint not null,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id bigint,
primary key (id)
);
create table j3_person_name (
id bigint not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id bigint not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id bigint not null,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id bigint not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted smallint,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id bigint not null,
- instance_parms varchar(512),
+ instance_parms varchar(8192),
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id bigint not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/mysql.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/mysql.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/mysql.ddl (original)
+++ juddi/trunk/docs/db/ddl/mysql.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id bigint not null auto_increment,
sort_code varchar(10),
@@ -51,8 +36,8 @@
create table j3_binding_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -75,8 +60,8 @@
create table j3_business_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id bigint not null,
primary key (id)
);
create table j3_discovery_url (
id bigint not null auto_increment,
- url varchar(255) not null,
+ url longtext not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id bigint not null auto_increment,
- email_address varchar(255) not null,
+ email_address longtext not null,
use_type varchar(255),
contact_id bigint not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id bigint not null auto_increment,
descr longtext not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id bigint,
primary key (id)
);
create table j3_person_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id bigint not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id bigint not null auto_increment,
descr longtext not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted bit,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id bigint not null auto_increment,
- descr longtext not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/mysql5.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/mysql5.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/mysql5.ddl (original)
+++ juddi/trunk/docs/db/ddl/mysql5.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id bigint not null auto_increment,
sort_code varchar(10),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255),
- access_point_url varchar(4000),
+ access_point_url varchar(4096),
hosting_redirector varchar(255),
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id bigint not null,
primary key (id)
);
create table j3_discovery_url (
id bigint not null auto_increment,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id bigint not null auto_increment,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255),
contact_id bigint not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id bigint not null auto_increment,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id bigint,
primary key (id)
);
create table j3_person_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id bigint not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id bigint not null auto_increment,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted bit,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id bigint not null auto_increment,
- instance_parms varchar(512),
+ instance_parms varchar(8192),
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl (original)
+++ juddi/trunk/docs/db/ddl/mysql5InnoDB.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id bigint not null auto_increment,
sort_code varchar(10),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
) ENGINE=InnoDB;
create table j3_binding_template (
access_point_type varchar(255),
- access_point_url varchar(4000),
+ access_point_url varchar(4096),
hosting_redirector varchar(255),
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
) ENGINE=InnoDB;
@@ -97,7 +82,7 @@
create table j3_business_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id bigint not null,
primary key (id)
) ENGINE=InnoDB;
create table j3_discovery_url (
id bigint not null auto_increment,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id bigint not null auto_increment,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255),
contact_id bigint not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
) ENGINE=InnoDB;
create table j3_instance_details_doc_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
) ENGINE=InnoDB;
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id bigint not null auto_increment,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id bigint,
primary key (id)
) ENGINE=InnoDB;
create table j3_person_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id bigint not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id bigint not null auto_increment,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
) ENGINE=InnoDB;
create table j3_service_name (
id bigint not null auto_increment,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
) ENGINE=InnoDB;
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ ) ENGINE=InnoDB;
+
create table j3_tmodel (
deleted bit,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
) ENGINE=InnoDB;
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id bigint not null auto_increment,
- instance_parms varchar(512),
+ instance_parms varchar(8192),
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id bigint not null auto_increment,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id bigint not null,
primary key (id)
) ENGINE=InnoDB;
Modified: juddi/trunk/docs/db/ddl/oracle9.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/oracle9.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/oracle9.ddl (original)
+++ juddi/trunk/docs/db/ddl/oracle9.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id number(19,0) not null,
sort_code varchar2(10 char),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
entity_key varchar2(255 char) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar2(255 char),
- access_point_url varchar2(4000 char),
+ access_point_url long,
hosting_redirector varchar2(255 char),
entity_key varchar2(255 char) not null,
service_key varchar2(255 char) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
entity_key varchar2(255 char) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id number(19,0) not null,
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
name varchar2(255 char) not null,
entity_key varchar2(255 char) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
contact_id number(19,0) not null,
primary key (id)
);
create table j3_discovery_url (
id number(19,0) not null,
- url varchar2(255 char) not null,
+ url long not null,
use_type varchar2(255 char) not null,
entity_key varchar2(255 char) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id number(19,0) not null,
- email_address varchar2(255 char) not null,
+ email_address long not null,
use_type varchar2(255 char),
contact_id number(19,0) not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
tmodel_instance_info_id number(19,0) not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
tmodel_instance_info_id number(19,0) not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar2(255 char) not null,
+ client_name varchar2(255 char) not null,
custody_transfer_url varchar2(255 char) not null,
factory_initial varchar2(255 char),
factory_naming_provider varchar2(255 char),
factory_url_pkgs varchar2(255 char),
inquiry_url varchar2(255 char) not null,
juddi_api_url varchar2(255 char),
- manager_name varchar2(255 char) not null,
proxy_transport varchar2(255 char) not null,
publish_url varchar2(255 char) not null,
security_url varchar2(255 char) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id number(19,0) not null,
descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
overview_doc_id number(19,0),
primary key (id)
);
create table j3_person_name (
id number(19,0) not null,
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
name varchar2(255 char) not null,
contact_id number(19,0) not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id number(19,0) not null,
descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
entity_key varchar2(255 char) not null,
primary key (id)
);
create table j3_service_name (
id number(19,0) not null,
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
name varchar2(255 char) not null,
entity_key varchar2(255 char) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar2(255 char) not null,
+ tx_id varchar2(255 char) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted number(1,0),
- lang_code varchar2(5 char),
+ lang_code varchar2(26 char),
name varchar2(255 char) not null,
entity_key varchar2(255 char) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
entity_key varchar2(255 char) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id number(19,0) not null,
- instance_parms varchar2(512 char),
+ instance_parms long,
tmodel_key varchar2(255 char) not null,
entity_key varchar2(255 char) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id number(19,0) not null,
- descr varchar2(1024 char) not null,
- lang_code varchar2(5 char),
+ descr varchar2(255 char) not null,
+ lang_code varchar2(26 char),
tmodel_instance_info_id number(19,0) not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/postgres.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/postgres.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/postgres.ddl (original)
+++ juddi/trunk/docs/db/ddl/postgres.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id int8 not null,
sort_code varchar(10),
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255),
- access_point_url varchar(4000),
+ access_point_url varchar(4096),
hosting_redirector varchar(255),
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id int8 not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
contact_id int8 not null,
primary key (id)
);
create table j3_discovery_url (
id int8 not null,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id int8 not null,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255),
contact_id int8 not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id int8 not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id int8 not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255),
factory_naming_provider varchar(255),
factory_url_pkgs varchar(255),
inquiry_url varchar(255) not null,
juddi_api_url varchar(255),
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id int8 not null,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
overview_doc_id int8,
primary key (id)
);
create table j3_person_name (
id int8 not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
contact_id int8 not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id int8 not null,
descr varchar(1024) not null,
- lang_code varchar(5),
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id int8 not null,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted bool,
- lang_code varchar(5),
+ lang_code varchar(26),
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id int8 not null,
- instance_parms varchar(512),
+ instance_parms varchar(8192),
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id int8 not null,
- descr varchar(1024) not null,
- lang_code varchar(5),
+ descr varchar(255) not null,
+ lang_code varchar(26),
tmodel_instance_info_id int8 not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/sqlserver.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/sqlserver.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/sqlserver.ddl (original)
+++ juddi/trunk/docs/db/ddl/sqlserver.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id numeric(19,0) identity not null,
sort_code varchar(10) null,
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255) null,
- access_point_url varchar(4000) null,
+ access_point_url varchar(4096) null,
hosting_redirector varchar(255) null,
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
contact_id numeric(19,0) not null,
primary key (id)
);
create table j3_discovery_url (
id numeric(19,0) identity not null,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id numeric(19,0) identity not null,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255) null,
contact_id numeric(19,0) not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255) null,
factory_naming_provider varchar(255) null,
factory_url_pkgs varchar(255) null,
inquiry_url varchar(255) not null,
juddi_api_url varchar(255) null,
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id numeric(19,0) identity not null,
descr varchar(1024) not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
overview_doc_id numeric(19,0) null,
primary key (id)
);
create table j3_person_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
contact_id numeric(19,0) not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id numeric(19,0) identity not null,
descr varchar(1024) not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted tinyint null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id numeric(19,0) identity not null,
- instance_parms varchar(512) null,
+ instance_parms varchar(8192) null,
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
Modified: juddi/trunk/docs/db/ddl/sybase.ddl
URL: http://svn.apache.org/viewvc/juddi/trunk/docs/db/ddl/sybase.ddl?rev=1483048&r1=1483047&r2=1483048&view=diff
==============================================================================
--- juddi/trunk/docs/db/ddl/sybase.ddl (original)
+++ juddi/trunk/docs/db/ddl/sybase.ddl Wed May 15 19:53:55 2013
@@ -1,19 +1,4 @@
-<*
- * Copyright 2001-2009 The Apache Software Foundation.
- *
- * Licensed under the Apache License, Version 2.0 (the "License");
- * you may not use this file except in compliance with the License.
- * You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- *
- */
+
create table j3_address (
id numeric(19,0) identity not null,
sort_code varchar(10) null,
@@ -51,15 +36,15 @@
create table j3_binding_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
create table j3_binding_template (
access_point_type varchar(255) null,
- access_point_url varchar(4000) null,
+ access_point_url varchar(4096) null,
hosting_redirector varchar(255) null,
entity_key varchar(255) not null,
service_key varchar(255) not null,
@@ -75,8 +60,8 @@
create table j3_business_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
@@ -97,7 +82,7 @@
create table j3_business_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -145,15 +130,15 @@
create table j3_contact_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
contact_id numeric(19,0) not null,
primary key (id)
);
create table j3_discovery_url (
id numeric(19,0) identity not null,
- url varchar(255) not null,
+ url varchar(4096) not null,
use_type varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -161,7 +146,7 @@
create table j3_email (
id numeric(19,0) identity not null,
- email_address varchar(255) not null,
+ email_address varchar(4096) not null,
use_type varchar(255) null,
contact_id numeric(19,0) not null,
primary key (id)
@@ -169,16 +154,16 @@
create table j3_instance_details_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
create table j3_instance_details_doc_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
@@ -219,13 +204,13 @@
create table j3_node (
name varchar(255) not null,
+ client_name varchar(255) not null,
custody_transfer_url varchar(255) not null,
factory_initial varchar(255) null,
factory_naming_provider varchar(255) null,
factory_url_pkgs varchar(255) null,
inquiry_url varchar(255) not null,
juddi_api_url varchar(255) null,
- manager_name varchar(255) not null,
proxy_transport varchar(255) not null,
publish_url varchar(255) not null,
security_url varchar(255) not null,
@@ -261,14 +246,14 @@
create table j3_overview_doc_descr (
id numeric(19,0) identity not null,
descr varchar(1024) not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
overview_doc_id numeric(19,0) null,
primary key (id)
);
create table j3_person_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
contact_id numeric(19,0) not null,
primary key (id)
@@ -327,14 +312,14 @@
create table j3_service_descr (
id numeric(19,0) identity not null,
descr varchar(1024) not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
create table j3_service_name (
id numeric(19,0) identity not null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -427,9 +412,15 @@
primary key (id)
);
+ create table j3_temp_key (
+ entity_key varchar(255) not null,
+ tx_id varchar(255) not null,
+ primary key (entity_key, tx_id)
+ );
+
create table j3_tmodel (
deleted tinyint null,
- lang_code varchar(5) null,
+ lang_code varchar(26) null,
name varchar(255) not null,
entity_key varchar(255) not null,
primary key (entity_key)
@@ -444,8 +435,8 @@
create table j3_tmodel_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
entity_key varchar(255) not null,
primary key (id)
);
@@ -461,7 +452,7 @@
create table j3_tmodel_instance_info (
id numeric(19,0) identity not null,
- instance_parms varchar(512) null,
+ instance_parms varchar(8192) null,
tmodel_key varchar(255) not null,
entity_key varchar(255) not null,
primary key (id)
@@ -469,8 +460,8 @@
create table j3_tmodel_instance_info_descr (
id numeric(19,0) identity not null,
- descr varchar(1024) not null,
- lang_code varchar(5) null,
+ descr varchar(255) not null,
+ lang_code varchar(26) null,
tmodel_instance_info_id numeric(19,0) not null,
primary key (id)
);
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org