Revision 6122
Added by ben leinfelder almost 12 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 206 | 206 |
*/ |
| 207 | 207 |
CREATE TABLE xml_access ( |
| 208 | 208 |
docid VARCHAR(250), -- the document id # |
| 209 |
guid text, -- foreign key to system metadata |
|
| 209 | 210 |
accessfileid VARCHAR(250), -- the document id # for the access file |
| 210 | 211 |
principal_name VARCHAR(100), -- name of user, group, etc. |
| 211 | 212 |
permission INT8, -- "read", "write", "all" |
| ... | ... | |
| 226 | 227 |
CREATE INDEX xml_access_idx3 ON xml_access (perm_type); |
| 227 | 228 |
CREATE INDEX xml_access_idx4 ON xml_access (perm_order); |
| 228 | 229 |
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid); |
| 230 |
/* |
|
| 231 |
* ALTER TABLE xml_access ADD COLUMN guid text; |
|
| 232 |
*/ |
|
| 229 | 233 |
|
| 230 | 234 |
/* |
| 231 | 235 |
* Index of Nodes -- table to store precomputed paths through tree for |
Also available in: Unified diff
include GUID column for xml_access and related methods for storing/retrieving access rules