Project

General

Profile

« Previous | Next » 

Revision 1603

Added by Jing Tao over 21 years ago

Change a unique key of relation table.

View differences:

reviseformetacat13.sql
29 29 
        startnodeid     NUMBER(20),     -- the start node id of access subtree
30 30 
  endnodeid NUMBER(20) -- the end node if of access subtree
31 31 
);
32 

  		




  
  33
  
    
/*


  		




  
  34
  
    
 * Drop the constrain in xml_relation table for (subject, relationship, object)


  		




  
  35
  
    
 * Add the new constrain in xml_relation table for (docid, subject, relationship, object)


  		




  
  36
  
    
 */


  		




  
  37
  
    
ALTER TABLE xml_relation DROP CONSTRAINT xml_relation_uk;


  		




  
  38
  
    
ALTER TABLE xml_relation ADD  CONSTRAINT xml_relation_uk UNIQUE (docid, subject, relationship, object); 


  		












Also available in:  Unified diff