Project

General

Profile

« Previous | Next » 

Revision 1530

Added by Jing Tao over 21 years ago

Add code to create a new table to store info about access block itself.

View differences:

src/xmltables.sql
295 295
END;                                   
296 296
/
297 297

  
298
/* 
299
 * accessSubtree -- table to store access subtree info 
300
 */
301
CREATE TABLE xml_accesssubtree (
302
	docid		VARCHAR2(250),	-- the document id #
303
  rev 		NUMBER(10) DEFAULT 1, --the revision number of the docume
304
  controllevel VARCHAR2(50), -- the level it control -- document or subtree
305
  subtreeid VARCHAR2(250), -- the subtree id 
306
	startnodeid	NUMBER(20),	-- the start node id of access subtree
307
  endnodeid NUMBER(20) -- the end node if of access subtree
308
);
309

  

Also available in: Unified diff