Project

General

Profile

« Previous | Next » 

Revision 560

Added by bojilova over 23 years ago

CREATE TABLE xml_access (
docid VARCHAR2, -- the document id #
principal_name VARCHAR2, -- name of user, group, etc.
permission NUMBER, -- "read", "write", "all"
perm_type VARCHAR2, -- "allowed" or "denied"
perm_order VARCHAR2 -- "allow first" or "deny first"
begin_time DATE, -- the time that permission begins
end_time DATE, -- the time that permission ends
ticket_count NUMBER, -- ticket counter for that permission
CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, permission, perm_type),
CONSTRAINT xml_access_ck CHECK (begin_time < end_time)
);

View differences:

xmltables.sql
125 125 
CREATE TABLE xml_access (
126 126 
	docid		VARCHAR2(250),	-- the document id #
127 127 
	principal_name	VARCHAR2(100),	-- name of user, group, etc.
128 
	principal_type	VARCHAR2(20),	-- like "user", "group", etc.
129 128 
	permission	NUMBER(1),	-- "read", "write", "all"
129 
	perm_type	VARCHAR2(32),	-- "allowed" or "denied"
130 
	perm_order	VARCHAR2(32)	-- "allow first" or "deny first"
130 131 
	begin_time	DATE,		-- the time that permission begins
131 132 
	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 
	ticket_count	NUMBER(5),	-- ticket counter for that permission
134 
   CONSTRAINT xml_access_pk UNIQUE (docid, principal_name, permission, perm_type),
136 135 
   CONSTRAINT xml_access_ck CHECK (begin_time < end_time)
137 136 
);
138 137 

  		












Also available in:  Unified diff