Project

General

Profile

« Previous | Next » 

Revision 1589

Added by Jing Tao over 21 years ago

Change some comment and add code to drop xml_accesssubtree table.

View differences:

src/xmltables_postgres.sql
32 32 

  		




  33
  33
  
    
DROP TABLE xml_index;


  		




  34
  34
  
    
DROP TABLE xml_access;


  		




  
  35
  
    
DROP TABLE xml_accesssubtree;


  		




  35
  36
  
    
DROP TABLE xml_revisions;


  		




  36
  37
  
    
DROP TABLE xml_relation;


  		




  37
  38
  
    
DROP TABLE xml_documents;


  		




  ......




  242
  243
  
    
);


  		




  243
  244
  
    

  		




  244
  245
  
    
/* 


  		




  245
  
  
    
 * accessSubtree -- table to store access subtree info 


  		




  
  246
  
    
 * accesssubtree -- table to store access subtree info 


  		




  246
  247
  
    
 */


  		




  247
  248
  
    
CREATE TABLE xml_accesssubtree (


  		




  248
  249
  
    
	docid		VARCHAR(250),	-- the document id #


  		












  

    
      src/xmltables.sql
    
  





  37
  37
  
    

  		




  38
  38
  
    
DROP TABLE xml_index;


  		




  39
  39
  
    
DROP TABLE xml_access;


  		




  
  40
  
    
DROP TABLE xml_accesssubtree;


  		




  40
  41
  
    
DROP TABLE xml_revisions;


  		




  41
  42
  
    
DROP TABLE xml_relation;


  		




  42
  43
  
    
DROP TABLE xml_documents;


  		




  ......




  296
  297
  
    
/


  		




  297
  298
  
    

  		




  298
  299
  
    
/* 


  		




  299
  
  
    
 * accessSubtree -- table to store access subtree info 


  		




  
  300
  
    
 * accesssubtree -- table to store access subtree info 


  		




  300
  301
  
    
 */


  		




  301
  302
  
    
CREATE TABLE xml_accesssubtree (


  		




  302
  303
  
    
	docid		VARCHAR2(250),	-- the document id #


  		












  

    
      src/reviseformetacat13_postgres.sql
    
  





  21
  21
  
    
ALTER TABLE xml_access ADD endnodeid INT8;


  		




  22
  22
  
    

  		




  23
  23
  
    
/*


  		




  24
  
  
    
 * accessSubtree -- table to store access subtree info


  		




  
  24
  
    
 * accesssubtree -- table to store access subtree info


  		




  25
  25
  
    
 */


  		




  26
  26
  
    
CREATE TABLE xml_accesssubtree (


  		




  27
  27
  
    
        docid           VARCHAR(250),   -- the document id #


  		












Also available in:  Unified diff