Project

General

Profile

« Previous | Next » 

Revision 1620

Added by Jing Tao over 21 years ago

Add a foreign key constrain in xml_accesssubtree table.

View differences:

src/xmltables_postgres.sql
251 251
  controllevel VARCHAR(50), -- the level it control -- document or subtree
252 252
  subtreeid VARCHAR(250), -- the subtree id 
253 253
	startnodeid	INT8,	-- the start node id of access subtree
254
  endnodeid INT8 -- the end node if of access subtree
254
  endnodeid INT8, -- the end node if of access subtree
255
  CONSTRAINT xml_accesssubtree_docid_fk 
256
		FOREIGN KEY (docid) REFERENCES xml_documents
255 257
);
256 258

  

Also available in: Unified diff