Project

General

Profile

« Previous | Next » 

Revision 10

Added by Matt Jones almost 25 years ago

new xml table structure

View differences:

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
  
    
/* 


  		












Also available in:  Unified diff