Revision 6209
Added by ben leinfelder about 13 years ago
xmltables-postgres.sql | ||
---|---|---|
222 | 222 |
subtreeid VARCHAR(32), |
223 | 223 |
startnodeid INT8, |
224 | 224 |
endnodeid INT8, |
225 |
CONSTRAINT xml_access_ck CHECK (begin_time < end_time), |
|
226 |
CONSTRAINT xml_access_accessfileid_fk |
|
227 |
FOREIGN KEY (accessfileid) REFERENCES xml_documents |
|
225 |
CONSTRAINT xml_access_ck CHECK (begin_time < end_time) |
|
228 | 226 |
); |
229 | 227 |
CREATE INDEX xml_access_idx1 ON xml_access (lower(principal_name)); |
230 | 228 |
CREATE INDEX xml_access_idx2 ON xml_access (permission); |
Also available in: Unified diff
merge changes from 1.9.5 branch for upgrade process (1.9.3->1.9.4->1.9.5)