Revision 646
Added by bojilova almost 24 years ago
| src/xmltables.sql | ||
|---|---|---|
| 136 | 136 |
begin_time DATE, -- the time that permission begins |
| 137 | 137 |
end_time DATE, -- the time that permission ends |
| 138 | 138 |
ticket_count NUMBER(5), -- ticket counter for that permission |
| 139 |
CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, permission, perm_type), |
|
| 139 |
CONSTRAINT xml_access_pk UNIQUE |
|
| 140 |
(docid, accessfileid, principal_name, permission, perm_type), |
|
| 140 | 141 |
CONSTRAINT xml_access_ck CHECK (begin_time < end_time) |
| 141 | 142 |
); |
| 142 | 143 |
|
Also available in: Unified diff
included "accessfileid" attr in the unique constraint