juddi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From svi...@apache.org
Subject cvs commit: ws-juddi/sql/mysql README create_database.sql insert_publishers.sql
Date Sat, 29 May 2004 01:07:19 GMT
sviens      2004/05/28 18:07:19

  Modified:    sql/mysql README create_database.sql insert_publishers.sql
  Log:
  Updated jUDDI database setup for MySQL
  
  Revision  Changes    Path
  1.2       +94 -3     ws-juddi/sql/mysql/README
  
  Index: README
  ===================================================================
  RCS file: /home/cvs/ws-juddi/sql/mysql/README,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- README	30 Apr 2004 04:11:10 -0000	1.1
  +++ README	29 May 2004 01:07:19 -0000	1.2
  @@ -1,4 +1,95 @@
  -MySQL / jUDDI version 0.9rc1
  -
  -Author: Steve Viens
  +CREATE/CONFIGURE A MYSQL DATABASE FOR jUDDI
  +
  +jUDDI requires the use of a relational database (RDBMS) or 
  +lightweight directory access protocol (LDAP) server to store
  +the web services metadata it manages. This document will 
  +walk you through the process of setting up a MySQL database 
  +as the persistante storage for a jUDDI registry.
  +
  +This document assumes that you already have a MySQL server 
  +available and running. Visit the following web site to obtain 
  +a copy of MySQL and follow the installation instructions that 
  +accompany the version you're installing. Return to these 
  +instructions when your MySQL server is up and running.
  +
  +  http://dev.mysql.com/
  +
  +Now that you've got your MySQL server up and running the next
  +step is to create the jUDDI database, user and tables. To do 
  +this your going to pass the "create_database.sql" script to 
  +the "mysql" command line tool within a command shell (for 
  +windows users this is the "Command Prompt" window) and use 
  +the "mysql" command line tool as follows:
  +
  +  Windows Command Prompt:
  +
  +    mysql < {path}\create_database.sql
  +  
  +  Unix, Linux, Cygwin Shell:
  +  
  +    mysql < {path}/create_database.sql
  +
  +Where {path} is the the directory path where the 
  +create_databas.sql file can be found. It's no coincidence 
  +that this is also the directory where the file that you 
  +are now reading is located.
  +
  +Depending on your account priviledges you may be required 
  +to supply a user and password when running the above 
  +commands this can be done using the optional --user 
  +and --password options like this:
  +
  +  mysql --user=myname --password=mysecret < create_database.sql
  +
  +A complete overview of the "mysql" command-line tool can 
  +be found in section 8.3 of the MySQL Manual which can be 
  +viewed online at the following URL: 
  +
  +  http://dev.mysql.com/doc/mysql/en/index.html
  +
  +Now that we've got the jUDDI database and tables created 
  +it's time to insert some data. You'll notice there are 
  +two insert_xxx.sql in the mysql directory.
  +
  +  insert_publishers.sql
  +  
  +The "insert_publishers" table contains rows identifying 
  +UDDI publisher accounts. You should edit this file and add
  +a row for each person that wishes to have access to the 
  +UDDI publish functionality in your registry. Follow the 
  +example inser for a user named John Doe that's in this 
  +file when adding your publishers.
  +
  +  INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,ENABLED,ADMIN)
  +  VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
  +  
  +NOTE that while the PUBLISHER table includes several 
  +columns not shown above only thoses shown in the example 
  +insert statement are used by jUDDI.
  +
  +Once you've finished editing "insert_publishers.sql"
  +invoke the SQL with the "mysql" command line tool as 
  +follows:
  +
  +  From Windows Command Prompt:
  +
  +    mysql < {path}\insert_publishers.sql
  +  
  +  From Unix, Linux, Cygwin Shell:
  +  
  +    mysql < {path}/insert_publishers.sql
  +  
  +Again, depending on your MySQL installation your account
  +priveledges you may need to supply the --user and --password 
  +options to the mysql command line tool.
  +
  +If everything went well your MySQL database is now created
  +an account for accessing this database (via JDBC) is also 
  +created and the PUBLISHER and TMODEL tables have been loaded
  +
  +You're now ready to take the next step and configure a JDBC 
  +DataSource within your application server to access this MySQL
  +database.
  +
  +Steve Viens
   sviens@apache.org
  
  
  
  1.3       +551 -0    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.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- create_database.sql	28 May 2004 14:59:36 -0000	1.2
  +++ create_database.sql	29 May 2004 01:07:19 -0000	1.3
  @@ -2,3 +2,554 @@
   
   GRANT ALL ON juddi.* TO juddi@"%" IDENTIFIED BY "password";
   GRANT ALL ON juddi.* TO juddi@"localhost" IDENTIFIED BY "password";
  +
  +USE juddi;
  +
  +CREATE TABLE BUSINESS_ENTITY
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
  +  PUBLISHER_ID VARCHAR(20) NULL,
  +  OPERATOR VARCHAR(255) NOT NULL,
  +  LAST_UPDATE TIMESTAMP NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE BUSINESS_DESCR
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  BUSINESS_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE BUSINESS_CATEGORY
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CATEGORY_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(41) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE BUSINESS_IDENTIFIER
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  IDENTIFIER_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(41) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE BUSINESS_NAME
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  BUSINESS_NAME_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  NAME VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE CONTACT
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  USE_TYPE VARCHAR(255) NULL,
  +  PERSON_NAME VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE CONTACT_DESCR
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  CONTACT_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
  +  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
  +    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
  +);
  +
  +CREATE TABLE ADDRESS
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  ADDRESS_ID INT NOT NULL,
  +  USE_TYPE VARCHAR(255) NULL,
  +  SORT_CODE VARCHAR(10) NULL,
  +  TMODEL_KEY VARCHAR(41) NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
  +  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
  +    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
  +);
  +
  +CREATE TABLE ADDRESS_LINE
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  ADDRESS_ID INT NOT NULL,
  +  ADDRESS_LINE_ID INT NOT NULL,
  +  LINE VARCHAR(80) NOT NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
  +  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
  +    REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
  +);
  +
  +CREATE TABLE EMAIL
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  EMAIL_ID INT NOT NULL,
  +  USE_TYPE VARCHAR(255) NULL,
  +  EMAIL_ADDRESS VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
  +  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
  +    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
  +);
  +
  +CREATE TABLE PHONE
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  CONTACT_ID INT NOT NULL,
  +  PHONE_ID INT NOT NULL,
  +  USE_TYPE VARCHAR(255) NULL,
  +  PHONE_NUMBER VARCHAR(50) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
  +  FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
  +    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
  +);
  +
  +CREATE TABLE DISCOVERY_URL
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  DISCOVERY_URL_ID INT NOT NULL,
  +  USE_TYPE VARCHAR(255) NOT NULL,
  +  URL VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE BUSINESS_SERVICE
  +(
  +  BUSINESS_KEY VARCHAR(41) NOT NULL,
  +  SERVICE_KEY VARCHAR(41) NOT NULL,
  +  LAST_UPDATE TIMESTAMP NOT NULL,
  +  PRIMARY KEY (SERVICE_KEY),
  +  FOREIGN KEY (BUSINESS_KEY)
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
  +);
  +
  +CREATE TABLE SERVICE_DESCR
  +(
  +  SERVICE_KEY VARCHAR(41) NOT NULL,
  +  SERVICE_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
  +  FOREIGN KEY (SERVICE_KEY)
  +    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
  +);
  +
  +CREATE TABLE SERVICE_CATEGORY
  +(
  +  SERVICE_KEY VARCHAR(41) NOT NULL,
  +  CATEGORY_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(41) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
  +  FOREIGN KEY (SERVICE_KEY)
  +    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
  +);
  +
  +CREATE TABLE SERVICE_NAME
  +(
  +  SERVICE_KEY VARCHAR(41) NOT NULL,
  +  SERVICE_NAME_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  NAME VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
  +  FOREIGN KEY (SERVICE_KEY)
  +    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
  +);
  +
  +CREATE TABLE BINDING_TEMPLATE
  +(
  +  SERVICE_KEY VARCHAR(41) NOT NULL,
  +  BINDING_KEY VARCHAR(41) NOT NULL,
  +  ACCESS_POINT_TYPE VARCHAR(20) NULL,
  +  ACCESS_POINT_URL VARCHAR(255) NULL,
  +  HOSTING_REDIRECTOR VARCHAR(255) NULL,
  +  LAST_UPDATE TIMESTAMP NOT NULL,
  +  PRIMARY KEY (BINDING_KEY),
  +  FOREIGN KEY (SERVICE_KEY)
  +    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
  +);
  +
  +CREATE TABLE BINDING_CATEGORY
  +(
  +  BINDING_KEY VARCHAR(41) NOT NULL,
  +  CATEGORY_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(41) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BINDING_KEY,CATEGORY_ID),
  +  FOREIGN KEY (BINDING_KEY)
  +    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
  +);
  +
  +CREATE TABLE BINDING_DESCR
  +(
  +  BINDING_KEY VARCHAR(41) NOT NULL,
  +  BINDING_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
  +  FOREIGN KEY (BINDING_KEY)
  +    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
  +);
  +
  +CREATE TABLE TMODEL_INSTANCE_INFO
  +(
  +  BINDING_KEY VARCHAR(41) NOT NULL,
  +  TMODEL_INSTANCE_INFO_ID INT NOT NULL,
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  OVERVIEW_URL VARCHAR(255) NULL,
  +  INSTANCE_PARMS VARCHAR(255) NULL,
  +  PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
  +  FOREIGN KEY (BINDING_KEY)
  +    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
  +);
  +
  +CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
  +(
  +  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,
  +  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)
  +    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
  +);
  +
  +CREATE TABLE INSTANCE_DETAILS_DESCR
  +(
  +  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,
  +  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)
  +    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
  +);
  +
  +CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
  +(
  +  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,
  +  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)
  +    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
  +);
  +
  +CREATE TABLE TMODEL
  +(
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  AUTHORIZED_NAME VARCHAR(255) NOT NULL,
  +  PUBLISHER_ID VARCHAR(20) NULL,
  +  OPERATOR VARCHAR(255) NOT NULL,
  +  NAME VARCHAR(255) NOT NULL,
  +  OVERVIEW_URL VARCHAR(255) NULL,
  +  DELETED VARCHAR(5) NULL,
  +  LAST_UPDATE TIMESTAMP NOT NULL,
  +  PRIMARY KEY (TMODEL_KEY)
  +);
  +
  +CREATE TABLE TMODEL_DESCR
  +(
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  TMODEL_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
  +  FOREIGN KEY (TMODEL_KEY)
  +    REFERENCES TMODEL (TMODEL_KEY)
  +);
  +
  +CREATE TABLE TMODEL_CATEGORY
  +(
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  CATEGORY_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(255) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
  +  FOREIGN KEY (TMODEL_KEY)
  +    REFERENCES TMODEL (TMODEL_KEY)
  +);
  +
  +CREATE TABLE TMODEL_IDENTIFIER
  +(
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  IDENTIFIER_ID INT NOT NULL,
  +  TMODEL_KEY_REF VARCHAR(255) NULL,
  +  KEY_NAME VARCHAR(255) NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
  +  FOREIGN KEY (TMODEL_KEY)
  +    REFERENCES TMODEL (TMODEL_KEY)
  +);
  +
  +CREATE TABLE TMODEL_DOC_DESCR
  +(
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  TMODEL_DOC_DESCR_ID INT NOT NULL,
  +  LANG_CODE VARCHAR(2) NULL,
  +  DESCR VARCHAR(255) NOT NULL,
  +  PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
  +  FOREIGN KEY (TMODEL_KEY)
  +    REFERENCES TMODEL (TMODEL_KEY)
  +);
  +
  +CREATE TABLE PUBLISHER_ASSERTION
  +(
  +  FROM_KEY VARCHAR(41) NOT NULL,
  +  TO_KEY VARCHAR(41) NOT NULL,
  +  TMODEL_KEY VARCHAR(41) NOT NULL,
  +  KEY_NAME VARCHAR(255) NOT NULL,
  +  KEY_VALUE VARCHAR(255) NOT NULL,
  +  FROM_CHECK VARCHAR(5) NOT NULL,
  +  TO_CHECK VARCHAR(5) NOT NULL,
  +  FOREIGN KEY (FROM_KEY) 
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
  +  FOREIGN KEY (TO_KEY) 
  +    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY) 
  +);
  +
  +CREATE TABLE PUBLISHER
  +(
  +  PUBLISHER_ID VARCHAR(20) NOT NULL,
  +  PUBLISHER_NAME VARCHAR(255) NOT NULL,
  +  LAST_NAME VARCHAR(150) NULL,
  +  FIRST_NAME VARCHAR(100) NULL,
  +  MIDDLE_INIT VARCHAR(5) NULL,
  +  WORK_PHONE VARCHAR(50) NULL,
  +  MOBILE_PHONE VARCHAR(50) NULL,
  +  PAGER VARCHAR(50) NULL,
  +  EMAIL_ADDRESS VARCHAR(255) NULL,
  +  ADMIN VARCHAR(5) NULL,
  +  ENABLED VARCHAR(5) NULL,
  +  PRIMARY KEY (PUBLISHER_ID)
  +);
  +
  +CREATE TABLE AUTH_TOKEN
  +(
  +  AUTH_TOKEN VARCHAR(51) NOT NULL,
  +  PUBLISHER_ID VARCHAR(20) NOT NULL,
  +  PUBLISHER_NAME VARCHAR(255) NOT NULL,
  +  CREATED TIMESTAMP NOT NULL,
  +  LAST_USED TIMESTAMP NOT NULL,
  +  NUMBER_OF_USES INT NOT NULL,
  +  TOKEN_STATE INT NOT NULL,
  +  PRIMARY KEY (AUTH_TOKEN)
  +);
  +
  +CREATE TABLE MONITOR
  +(
  +  REMOTE_HOST VARCHAR(51) NOT NULL,
  +  REQUEST_URI VARCHAR(255) NOT NULL,
  +  CALLED_FUNCTION VARCHAR(51) NOT NULL,
  +  UDDI_VERSION VARCHAR(51) NOT NULL,
  +  LOG_TIME DATETIME NOT NULL,
  +  AUTH_TOKEN VARCHAR(51) NULL, 
  +  FAULT VARCHAR(255) NULL
  +);
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type Taxonomy');
  + 
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to categorize
Service Descriptions.');
  + 
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  + 
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product Taxonomy: UNSPSC (Version
3.1)');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel defines the UNSPSC
product taxonomy.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product Taxonomy: UNSPSC (Version
7.3)');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel defines Version
7.3 of the UNSPSC product taxonomy.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business Taxonomy: NAICS(1997
Release)');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel defines the NAICS
industry taxonomy.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997 and 3166-2:1998.
Codes for names of countries and their subdivisions. Part 1: Country codes. Part 2:Country
subdivision codes.');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to categorize
entries by geographic location.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy consisting
of namespace identifiers and the keywords associated with the namespaces');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel defines an unidentified
taxonomy.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a businessEntity
that owns the tagged data.');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel indicates the businessEntity
that published or owns the tagged tModel. Used with tModels to establish an "owned" relationship
with a registered businessEntity.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set classifications
of businessEntity relationships');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is used to describe
business relationships. Used in the publisher assertion messages.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for categorizing the
businessEntity of an operator of a registry.');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked value set is used
to identify UDDI operators.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier system used to
point (using UDDI keys) to the tModel (or businessEntity) that is the logical replacement
for the one in which isReplacedBy is used');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a checked value set.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun&Bradstreet D-U-N-SŪ
Number');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is used for the
Dun&Bradstreet D-U-N-SŪ Number identifier.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
  +
  +INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
  +VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas',NULL);
  +
  +INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry Suppliers');
  +
  +INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
  +VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is used for the
Thomas Register supplier identifier codes.');
  +
  +INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
  +VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier');
  +
  +
  
  
  
  1.2       +6 -2      ws-juddi/sql/mysql/insert_publishers.sql
  
  Index: insert_publishers.sql
  ===================================================================
  RCS file: /home/cvs/ws-juddi/sql/mysql/insert_publishers.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- insert_publishers.sql	30 Apr 2004 04:11:10 -0000	1.1
  +++ insert_publishers.sql	29 May 2004 01:07:19 -0000	1.2
  @@ -1,2 +1,6 @@
  -INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,ENABLED,ADMIN)
  -VALUES ('jdoe','John Doe','true','true');
  +USE juddi;
  +
  +-- *** SAMPLE PUBLISHER ***
  +-- INSERT INTO PUBLISHER (PUBLISHER_ID,PUBLISHER_NAME,EMAIL_ADDRESS,ENABLED,ADMIN)
  +-- VALUES ('jdoe','John Doe','john.doe@apache.org','true','true');
  +
  
  
  

Mime
View raw message