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/oracle create_tables.sql
Date Sat, 01 May 2004 02:11:14 GMT
sviens      2004/04/30 19:11:14

  Modified:    sql/oracle create_tables.sql
  Log:
  Added MONITOR table (was missing)
  
  Revision  Changes    Path
  1.3       +11 -0     ws-juddi/sql/oracle/create_tables.sql
  
  Index: create_tables.sql
  ===================================================================
  RCS file: /home/cvs/ws-juddi/sql/oracle/create_tables.sql,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- create_tables.sql	1 May 2004 01:01:57 -0000	1.2
  +++ create_tables.sql	1 May 2004 02:11:14 -0000	1.3
  @@ -354,6 +354,17 @@
   
   ALTER TABLE AUTH_TOKEN ADD ( PRIMARY KEY (AUTH_TOKEN) );
   
  +CREATE TABLE MONITOR
  +(
  +  REMOTE_HOST VARCHAR2(51) NOT NULL,
  +  REQUEST_URI VARCHAR2(255) NOT NULL,
  +  CALLED_FUNCTION VARCHAR2(51) NOT NULL,
  +  UDDI_VERSION VARCHAR2(51) NOT NULL,
  +  LOG_TIME TIMESTAMP NOT NULL,
  +  AUTH_TOKEN VARCHAR2(51) NULL, 
  +  FAULT VARCHAR2(255) NULL
  +);
  +
   ALTER TABLE BUSINESS_DESCR ADD ( FOREIGN KEY (BUSINESS_KEY) REFERENCES BUSINESS_ENTITY);
   
   ALTER TABLE BUSINESS_CATEGORY ADD ( FOREIGN KEY (BUSINESS_KEY)
  
  
  

Mime
View raw message