Project

General

Profile

« Previous | Next » 

Revision 556

Added by bojilova over 23 years ago

added ticket_counter and deny attributes to xml_access table

View differences:

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