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 2005/03/02 12:13:55 UTC
cvs commit: ws-juddi/sql/oracle create_database.sql
sviens 2005/03/02 03:13:55
Modified: sql/jdatastore create_database.sql
sql/totalxml create_database.sql
sql/sybase create_database.sql
sql/mysql create_database.sql
sql/db2 create_database.sql
sql/firebird create_database.sql
sql/postgresql create_database.sql
sql/hsqldb create_database.sql
sql/oracle create_database.sql
Log:
Extended the size of all LANG_CODE columns to 5 characters (from 2) to accomodate 5-character language codes such as 'en-US'.
Revision Changes Path
1.4 +11 -11 ws-juddi/sql/jdatastore/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/jdatastore/create_database.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- create_database.sql 2 Mar 2005 02:52:28 -0000 1.3
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.4
@@ -47,7 +47,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -82,7 +82,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -105,7 +105,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -188,7 +188,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -211,7 +211,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -247,7 +247,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -271,7 +271,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -283,7 +283,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -295,7 +295,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -319,7 +319,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -354,7 +354,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.3 +11 -11 ws-juddi/sql/totalxml/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/totalxml/create_database.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create_database.sql 2 Mar 2005 02:52:28 -0000 1.2
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.3
@@ -45,7 +45,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -80,7 +80,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -103,7 +103,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -186,7 +186,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -209,7 +209,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -245,7 +245,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -269,7 +269,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -281,7 +281,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -293,7 +293,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -317,7 +317,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -352,7 +352,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.3 +11 -11 ws-juddi/sql/sybase/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/sybase/create_database.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create_database.sql 2 Mar 2005 02:52:28 -0000 1.2
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.3
@@ -45,7 +45,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -80,7 +80,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -103,7 +103,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -186,7 +186,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -209,7 +209,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -245,7 +245,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -269,7 +269,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -281,7 +281,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -293,7 +293,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -317,7 +317,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -352,7 +352,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.6 +11 -11 ws-juddi/sql/mysql/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/mysql/create_database.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- create_database.sql 2 Mar 2005 02:52:28 -0000 1.5
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.6
@@ -19,7 +19,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -54,7 +54,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -77,7 +77,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -160,7 +160,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -183,7 +183,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -219,7 +219,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -243,7 +243,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -255,7 +255,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -267,7 +267,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -291,7 +291,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -326,7 +326,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.3 +11 -11 ws-juddi/sql/db2/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/db2/create_database.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create_database.sql 2 Mar 2005 02:52:28 -0000 1.2
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.3
@@ -46,7 +46,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -81,7 +81,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -104,7 +104,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -187,7 +187,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -210,7 +210,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) ,
+ LANG_CODE VARCHAR(5) ,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -246,7 +246,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -270,7 +270,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -282,7 +282,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -294,7 +294,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -318,7 +318,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -353,7 +353,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.3 +11 -11 ws-juddi/sql/firebird/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/firebird/create_database.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create_database.sql 2 Mar 2005 02:52:29 -0000 1.2
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.3
@@ -50,7 +50,7 @@
CREATE TABLE BINDING_DESCR (
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -77,7 +77,7 @@
CREATE TABLE BUSINESS_DESCR (
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -103,7 +103,7 @@
CREATE TABLE BUSINESS_NAME (
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
NAME VARCHAR(255) NOT NULL
);
@@ -127,7 +127,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INTEGER NOT NULL,
CONTACT_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -153,7 +153,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
INSTANCE_DETAILS_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -162,7 +162,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -219,7 +219,7 @@
CREATE TABLE SERVICE_DESCR (
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -227,7 +227,7 @@
CREATE TABLE SERVICE_NAME (
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
NAME VARCHAR(255) NOT NULL
);
@@ -256,7 +256,7 @@
CREATE TABLE TMODEL_DESCR (
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -264,7 +264,7 @@
CREATE TABLE TMODEL_DOC_DESCR (
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
@@ -291,7 +291,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INTEGER NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INTEGER NOT NULL,
- LANG_CODE VARCHAR(2),
+ LANG_CODE VARCHAR(5),
DESCR VARCHAR(255) NOT NULL
);
1.4 +11 -11 ws-juddi/sql/postgresql/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/postgresql/create_database.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- create_database.sql 2 Mar 2005 02:52:29 -0000 1.3
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.4
@@ -45,7 +45,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_BUS_DESCR_01 FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
@@ -83,7 +83,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
CONSTRAINT FK_BUS_NAME_01 FOREIGN KEY (BUSINESS_KEY)
REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
@@ -108,7 +108,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_CONTACT_DESCR_01 FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
@@ -198,7 +198,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_SERVICE_DESCR_01 FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
@@ -223,7 +223,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
CONSTRAINT FK_SERVICE_NAME_01 FOREIGN KEY (SERVICE_KEY)
REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
@@ -263,7 +263,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_BINDING_DESCR_01 FOREIGN KEY (BINDING_KEY)
REFERENCES BINDING_TEMPLATE (BINDING_KEY)
@@ -289,7 +289,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_TMODEL_INSTANCE_INFO_DESCR_01 FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -302,7 +302,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_INSTANCE_DETAILS_DESCR_01 FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -315,7 +315,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_INSTANCE_DETAILS_DOC_DESCR_01 FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -340,7 +340,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_TMODEL_DESCR_01 FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
@@ -378,7 +378,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
CONSTRAINT FK_TMODEL_DOC_DESCR_01 FOREIGN KEY (TMODEL_KEY)
REFERENCES TMODEL (TMODEL_KEY)
1.3 +11 -11 ws-juddi/sql/hsqldb/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/hsqldb/create_database.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- create_database.sql 2 Mar 2005 02:52:29 -0000 1.2
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.3
@@ -45,7 +45,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -80,7 +80,7 @@
(
BUSINESS_KEY VARCHAR(41) NOT NULL,
BUSINESS_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
FOREIGN KEY (BUSINESS_KEY)
@@ -103,7 +103,7 @@
BUSINESS_KEY VARCHAR(41) NOT NULL,
CONTACT_ID INT NOT NULL,
CONTACT_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
@@ -186,7 +186,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -209,7 +209,7 @@
(
SERVICE_KEY VARCHAR(41) NOT NULL,
SERVICE_NAME_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
NAME VARCHAR(255) NOT NULL,
PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
FOREIGN KEY (SERVICE_KEY)
@@ -245,7 +245,7 @@
(
BINDING_KEY VARCHAR(41) NOT NULL,
BINDING_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
FOREIGN KEY (BINDING_KEY)
@@ -269,7 +269,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -281,7 +281,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -293,7 +293,7 @@
BINDING_KEY VARCHAR(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID INT NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
@@ -317,7 +317,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
@@ -352,7 +352,7 @@
(
TMODEL_KEY VARCHAR(41) NOT NULL,
TMODEL_DOC_DESCR_ID INT NOT NULL,
- LANG_CODE VARCHAR(2) NULL,
+ LANG_CODE VARCHAR(5) NULL,
DESCR VARCHAR(255) NOT NULL,
PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
FOREIGN KEY (TMODEL_KEY)
1.4 +11 -11 ws-juddi/sql/oracle/create_database.sql
Index: create_database.sql
===================================================================
RCS file: /home/cvs/ws-juddi/sql/oracle/create_database.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- create_database.sql 2 Mar 2005 02:52:29 -0000 1.3
+++ create_database.sql 2 Mar 2005 11:13:54 -0000 1.4
@@ -46,7 +46,7 @@
(
BUSINESS_KEY VARCHAR2(41) NOT NULL,
BUSINESS_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -78,7 +78,7 @@
(
BUSINESS_KEY VARCHAR2(41) NOT NULL,
BUSINESS_NAME_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
NAME VARCHAR2(255) NOT NULL
);
@@ -99,7 +99,7 @@
BUSINESS_KEY VARCHAR2(41) NOT NULL,
CONTACT_ID NUMBER(10) NOT NULL,
CONTACT_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -177,7 +177,7 @@
(
SERVICE_KEY VARCHAR2(41) NOT NULL,
SERVICE_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -198,7 +198,7 @@
(
SERVICE_KEY VARCHAR2(41) NOT NULL,
SERVICE_NAME_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
NAME VARCHAR2(255) NOT NULL
);
@@ -220,7 +220,7 @@
(
BINDING_KEY VARCHAR2(41) NOT NULL,
BINDING_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL,
FOREIGN KEY (BINDING_KEY)
REFERENCES BINDING_TEMPLATE (BINDING_KEY)
@@ -257,7 +257,7 @@
BINDING_KEY VARCHAR2(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID NUMBER(10) NOT NULL,
TMODEL_INSTANCE_INFO_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL,
FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY, TMODEL_INSTANCE_INFO_ID)
@@ -271,7 +271,7 @@
BINDING_KEY VARCHAR2(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID NUMBER(10) NOT NULL,
INSTANCE_DETAILS_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -283,7 +283,7 @@
BINDING_KEY VARCHAR2(41) NOT NULL,
TMODEL_INSTANCE_INFO_ID NUMBER(10) NOT NULL,
INSTANCE_DETAILS_DOC_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -308,7 +308,7 @@
(
TMODEL_KEY VARCHAR2(41) NOT NULL,
TMODEL_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);
@@ -340,7 +340,7 @@
(
TMODEL_KEY VARCHAR2(41) NOT NULL,
TMODEL_DOC_DESCR_ID NUMBER(10) NOT NULL,
- LANG_CODE VARCHAR2(2) NULL,
+ LANG_CODE VARCHAR2(5) NULL,
DESCR VARCHAR2(255) NOT NULL
);