Project

General

Profile

« Previous | Next » 

Revision 10

Added by Matt Jones over 25 years ago

new xml table structure

View differences:

src/xmltables.sql
22 22 
 */
23 23 
CREATE TABLE xml_elements (
24 24 
	nodeid		NUMBER(20),
25 
	parentnodeid	NUMBER(20),
25 26 
	nodename	VARCHAR2(2000),
26 27 
	nodedata	VARCHAR2(2000),
27 28 
	date_created	DATE,
28 29 
	date_updated	DATE,
29 
   CONSTRAINT xml_elements_pk PRIMARY KEY (nodeid)
30 
   CONSTRAINT xml_elements_pk PRIMARY KEY (nodeid),
31 
   CONSTRAINT xml_elements_parent_fk
32 
		FOREIGN KEY (parentnodeid) REFERENCES xml_elements
30 33 
);
31 34 

  		




  32
  35
  
    
/* 


  		












  

    
      xmltables.sql
    
  





  22
  22
  
    
 */


  		




  23
  23
  
    
CREATE TABLE xml_elements (


  		




  24
  24
  
    
	nodeid		NUMBER(20),


  		




  
  25
  
    
	parentnodeid	NUMBER(20),


  		




  25
  26
  
    
	nodename	VARCHAR2(2000),


  		




  26
  27
  
    
	nodedata	VARCHAR2(2000),


  		




  27
  28
  
    
	date_created	DATE,


  		




  28
  29
  
    
	date_updated	DATE,


  		




  29
  
  
    
   CONSTRAINT xml_elements_pk PRIMARY KEY (nodeid)


  		




  
  30
  
    
   CONSTRAINT xml_elements_pk PRIMARY KEY (nodeid),


  		




  
  31
  
    
   CONSTRAINT xml_elements_parent_fk 


  		




  
  32
  
    
		FOREIGN KEY (parentnodeid) REFERENCES xml_elements


  		




  30
  33
  
    
);


  		




  31
  34
  
    

  		




  32
  35
  
    
/* 


  		












  

    
      Makefile
    
  





  8
  8
  
    
		DBWriter.java \


  		




  9
  9
  
    
		DBElement.java


  		




  10
  10
  
    
		


  		




  11
  
  
    
	#java -classpath ".$(SEP)$(CPATH)" \


  		




  12
  
  
    
		#DBWriter DBElement.props ./book-order.xml


  		




  
  11
  
    
	#java -classpath "$(CPATH)" DBWriter DBElement.props file.xml username password


  		




  13
  12
  
    

  		




  14
  13
  
    
clean:


  		




  15
  14
  
    
	-rm -f *.class Log


  		












Also available in:  Unified diff