babeldoc-devel

[paspes <pa...@us...>]

Update of /cvsroot/babeldoc/babeldoc/readme/sql/oracle
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv7966/readme/sql/oracle

Modified Files:
	journal-tables.sql 
Log Message:
modificació script creacio bd oracle

Index: journal-tables.sql
===================================================================
RCS file: /cvsroot/babeldoc/babeldoc/readme/sql/oracle/journal-tables.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** journal-tables.sql	24 Feb 2003 22:50:25 -0000	1.1.1.1
--- journal-tables.sql	30 Jan 2008 15:13:59 -0000	1.2
***************
*** 1,58 ****
! DROP TABLE JOURNAL CASCADE CONSTRAINTS ; 
  
! CREATE TABLE JOURNAL ( 
!   jrn_log_id    NUMBER        NOT NULL, 
!   jrn_log_step  NUMBER        NOT NULL, 
!   jrn_data      BLOB, 
    CONSTRAINT pk_journal
!   PRIMARY KEY ( jrn_log_id, jrn_log_step ) ) ; 
  
! DROP TABLE JOURNAL_DATA CASCADE CONSTRAINTS ; 
  
! CREATE TABLE JOURNAL_DATA ( 
!   jda_log_id    NUMBER        NOT NULL, 
!   jda_log_step  NUMBER        NOT NULL, 
!   jda_name      VARCHAR2 (255) NOT NULL, 
!   jda_value     VARCHAR2 (255), 
    CONSTRAINT pk_journal_data
!   PRIMARY KEY ( jda_log_id, jda_log_step, jda_name ) ) ; 
  
- DROP TABLE LOG CASCADE CONSTRAINTS ; 
  
! CREATE TABLE LOG ( 
!   log_id          NUMBER        NOT NULL, 
!   log_step        NUMBER        NOT NULL, 
!   log_operation   VARCHAR2 (30) NOT NULL, 
!   log_datetime    NUMBER        NOT NULL, 
!   log_other_data  VARCHAR2 (30), 
!   log_pipeline    VARCHAR2 (30), 
    log_additional  VARCHAR2 (2000),
    CONSTRAINT pk_log
!   PRIMARY KEY ( log_id, log_step ) ) ; 
! 
! DROP TABLE TABLE_KEY CASCADE CONSTRAINTS ; 
  
! CREATE TABLE TABLE_KEY ( 
!   key_table_name  VARCHAR2 (30) NOT NULL, 
!   key_val         NUMBER        NOT NULL, 
!   UNIQUE (key_table_name), 
    CONSTRAINT pk_table_key
!   PRIMARY KEY ( key_table_name ) ) ; 
! 
  DROP TABLE CONFIG CASCADE CONSTRAINTS ;
  CREATE TABLE CONFIG (
    cfg_name VARCHAR (30) NOT NULL,
    cfg_value VARCHAR (255) NOT NULL,
-   UNIQUE (cfg_name), 
    CONSTRAINT pk_config
    PRIMARY KEY ( cfg_name ) );
! 	
  DROP TABLE BABEL_USER CASCADE CONSTRAINTS;
! 
  CREATE TABLE BABEL_USER (
    user_name VARCHAR (30) NOT NULL,
    user_passwd VARCHAR (30) NOT NULL,
-   UNIQUE (user_name), 
    CONSTRAINT pk_user
    PRIMARY KEY ( user_name ) );
- 		
--- 1,59 ----
! DROP TABLE JOURNAL CASCADE CONSTRAINTS ;
  
!  CREATE TABLE JOURNAL (
!   jrn_log_id    NUMBER        NOT NULL,
!   jrn_log_step  NUMBER        NOT NULL,
!   jrn_data      BLOB,
    CONSTRAINT pk_journal
!   PRIMARY KEY ( jrn_log_id, jrn_log_step ) ) ;
  
! DROP TABLE JOURNAL_DATA CASCADE CONSTRAINTS ;
  
! 
! CREATE TABLE JOURNAL_DATA (
!   jda_log_id    NUMBER        NOT NULL,
!   jda_log_step  NUMBER        NOT NULL,
!   jda_name      VARCHAR2 (255) NOT NULL,
!   jda_value     VARCHAR2 (255),
    CONSTRAINT pk_journal_data
!   PRIMARY KEY ( jda_log_id, jda_log_step, jda_name ) ) ;
  
  
! DROP TABLE LOG CASCADE CONSTRAINTS ;
! 
! 
! CREATE TABLE LOG (
!   log_id          NUMBER        NOT NULL,
!   log_step        NUMBER        NOT NULL,
!   log_operation   VARCHAR2 (30) NOT NULL,
!   log_datetime    NUMBER        NOT NULL,
!   log_other_data  VARCHAR2 (30),
!   log_pipeline    VARCHAR2 (100),
    log_additional  VARCHAR2 (2000),
    CONSTRAINT pk_log
!   PRIMARY KEY ( log_id, log_step ) ) ;
  
! DROP TABLE TABLE_KEY CASCADE CONSTRAINTS ;
!  
! CREATE TABLE TABLE_KEY (
!   key_table_name  VARCHAR2 (30) NOT NULL,
!   key_val         NUMBER        NOT NULL,
    CONSTRAINT pk_table_key
!   PRIMARY KEY ( key_table_name ) ) ;
!  
  DROP TABLE CONFIG CASCADE CONSTRAINTS ;
+  
+  
  CREATE TABLE CONFIG (
    cfg_name VARCHAR (30) NOT NULL,
    cfg_value VARCHAR (255) NOT NULL,
    CONSTRAINT pk_config
    PRIMARY KEY ( cfg_name ) );
!  
  DROP TABLE BABEL_USER CASCADE CONSTRAINTS;
!  
  CREATE TABLE BABEL_USER (
    user_name VARCHAR (30) NOT NULL,
    user_passwd VARCHAR (30) NOT NULL,
    CONSTRAINT pk_user
    PRIMARY KEY ( user_name ) );