Revision 556
Added by bojilova over 24 years ago
src/xmltables.sql | ||
---|---|---|
124 | 124 |
*/ |
125 | 125 |
CREATE TABLE xml_access ( |
126 | 126 |
docid VARCHAR2(250), -- the document id # |
127 |
principal_name VARCHAR2(100), -- name of user, user group, etc.
|
|
127 |
principal_name VARCHAR2(100), -- name of user, group, etc. |
|
128 | 128 |
principal_type VARCHAR2(20), -- like "user", "group", etc. |
129 |
access_type NUMBER(1), -- "read", "write", "all" |
|
130 |
begin_time DATE, -- the time that access permission begins |
|
131 |
end_time DATE, -- the time that access permission ends |
|
132 |
CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, principal_type, access_type, begin_time), |
|
129 |
permission NUMBER(1), -- "read", "write", "all" |
|
130 |
begin_time DATE, -- the time that permission begins |
|
131 |
end_time DATE, -- the time that permission ends |
|
132 |
ticket_counter NUMBER(5), -- ticket counter for that permission |
|
133 |
deny NUMBER(1), -- flag to deny that permission |
|
134 |
CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, principal_type, |
|
135 |
permission, begin_time, end_time, ticket_counter), |
|
133 | 136 |
CONSTRAINT xml_access_ck CHECK (begin_time < end_time) |
134 | 137 |
); |
135 | 138 |
|
... | ... | |
146 | 149 |
doctitle VARCHAR2(1000), -- title of document if exists |
147 | 150 |
user_owner VARCHAR2(100), |
148 | 151 |
user_updated VARCHAR2(100), |
149 |
server_location NUMBER(20),
|
|
152 |
server_location NUMBER(20),
|
|
150 | 153 |
date_created DATE, |
151 | 154 |
date_updated DATE, |
152 | 155 |
CONSTRAINT xml_revisions_pk PRIMARY KEY (revisionid), |
Also available in: Unified diff
added ticket_counter and deny attributes to xml_access table