Project

General

Profile

« Previous | Next » 

Revision 4

Added by Matt Jones about 25 years ago

constraint fixes to tables

View differences:

src/xmltables.sql
21 21 
	doctype		VARCHAR2(1000),
22 22 
	date_created	DATE,
23 23 
	date_updated	DATE,
24 
   PRIMARY KEY document_pk (docid),
25 
   FOREIGN KEY fk_root_node (rootnodeid) REFERENCES elements
24 
   CONSTRAINT document_pk PRIMARY KEY (docid),
25 
   CONSTRAINT fk_root_node FOREIGN KEY (rootnodeid) REFERENCES elements
26 26 
);
27 27 

  		




  28
  28
  
    
/* 


  		




  ......




  35
  35
  
    
	nodedata	VARCHAR2(2000),


  		




  36
  36
  
    
	date_created	DATE,


  		




  37
  37
  
    
	date_updated	DATE,


  		




  38
  
  
    
   PRIMARY KEY elements_pk (nodeid)


  		




  
  38
  
    
   CONSTRAINT elements_pk PRIMARY KEY (nodeid)


  		




  39
  39
  
    
);


  		




  40
  40
  
    

  		




  41
  41
  
    
/* 


  		




  ......




  50
  50
  
    
	attributevalue	VARCHAR2(2000),


  		




  51
  51
  
    
	date_created	DATE,


  		




  52
  52
  
    
	date_updated	DATE,


  		




  53
  
  
    
   PRIMARY KEY attributes_pk (attributeid),


  		




  54
  
  
    
   FOREIGN KEY fk_parent_node (nodeid) REFERENCES elements


  		




  
  53
  
    
   CONSTRAINT KEY (attributeid),


  		




  
  54
  
    
   CONSTRAINT fk_parent_node FOREIGN KEY (nodeid) REFERENCES elements


  		




  55
  55
  
    
);


  		












  

    
      xmltables.sql
    
  





  21
  21
  
    
	doctype		VARCHAR2(1000),


  		




  22
  22
  
    
	date_created	DATE,


  		




  23
  23
  
    
	date_updated	DATE,


  		




  24
  
  
    
   PRIMARY KEY document_pk (docid),


  		




  25
  
  
    
   FOREIGN KEY fk_root_node (rootnodeid) REFERENCES elements


  		




  
  24
  
    
   CONSTRAINT document_pk PRIMARY KEY (docid),


  		




  
  25
  
    
   CONSTRAINT fk_root_node FOREIGN KEY (rootnodeid) REFERENCES elements


  		




  26
  26
  
    
);


  		




  27
  27
  
    

  		




  28
  28
  
    
/* 


  		




  ......




  35
  35
  
    
	nodedata	VARCHAR2(2000),


  		




  36
  36
  
    
	date_created	DATE,


  		




  37
  37
  
    
	date_updated	DATE,


  		




  38
  
  
    
   PRIMARY KEY elements_pk (nodeid)


  		




  
  38
  
    
   CONSTRAINT elements_pk PRIMARY KEY (nodeid)


  		




  39
  39
  
    
);


  		




  40
  40
  
    

  		




  41
  41
  
    
/* 


  		




  ......




  50
  50
  
    
	attributevalue	VARCHAR2(2000),


  		




  51
  51
  
    
	date_created	DATE,


  		




  52
  52
  
    
	date_updated	DATE,


  		




  53
  
  
    
   PRIMARY KEY attributes_pk (attributeid),


  		




  54
  
  
    
   FOREIGN KEY fk_parent_node (nodeid) REFERENCES elements


  		




  
  53
  
    
   CONSTRAINT KEY (attributeid),


  		




  
  54
  
    
   CONSTRAINT fk_parent_node FOREIGN KEY (nodeid) REFERENCES elements


  		




  55
  55
  
    
);


  		












Also available in:  Unified diff