Revision 6923
Added by ben leinfelder about 11 years ago
| xmltables-postgres.sql | ||
|---|---|---|
| 207 | 207 |
*/ |
| 208 | 208 |
CREATE TABLE xml_access ( |
| 209 | 209 |
guid text, -- foreign key to system metadata |
| 210 |
accessfileid VARCHAR(250), -- the document id # for the access file
|
|
| 210 |
accessfileid text, -- the id for the access file
|
|
| 211 | 211 |
principal_name VARCHAR(100), -- name of user, group, etc. |
| 212 | 212 |
permission INT8, -- "read", "write", "all" |
| 213 | 213 |
perm_type VARCHAR(32), -- "allowed" or "denied" |
Also available in: Unified diff
use larger ("text") db field for guid in the xml_access.accessfileid column