Project

General

Profile

Revision 1421

Added by Jing Tao over 18 years ago

Modify postgres access table.

View differences:

xmltables_postgres.sql
183 183
	begin_time DATE,		-- the time that permission begins
184 184
	end_time DATE,		-- the time that permission ends
185 185
	ticket_count INT8,		-- ticket counter for that permission
186
  subtreeid VARCHAR(32),
187
  startnodeid INT8,
188
  endnodeid INT8,
186 189
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time),
187 190
   CONSTRAINT xml_access_accessfileid_fk 
188 191
		FOREIGN KEY (accessfileid) REFERENCES xml_documents

Also available in: Unified diff