Project

General

Profile

« Previous | Next » 

Revision 575

Added by berkley almost 24 years ago

added revision number tracking support to xml_documents and xml_revisions. Also added an updated flag as a replacement for date based replication handling.

View differences:

xmltables.sql
104 104 
	user_owner	VARCHAR2(100),	-- the user owned the document
105 105 
	user_updated	VARCHAR2(100),	-- the user updated the document
106 106 
  server_location NUMBER(20), -- the server on which this document resides
107 
  rev NUMBER(10) DEFAULT 1,  --the revision number of the document
107 108 
	date_created	DATE,
108 109 
	date_updated	DATE,
109 110 
	public_access	NUMBER(1) DEFAULT 1, -- flag for public access
111 
  updated NUMBER(1) DEFAULT 0,
110 112 
   CONSTRAINT xml_documents_pk PRIMARY KEY (docid),
111 113 
   CONSTRAINT xml_documents_rep_fk
112 114 
    FOREIGN KEY (server_location) REFERENCES xml_replication,
......
149 151 
	user_owner	VARCHAR2(100),
150 152 
	user_updated	VARCHAR2(100),
151 153 
	server_location NUMBER(20),
154 
  rev NUMBER(10),
152 155 
	date_created	DATE,
153 156 
	date_updated	DATE,
154 157 
   CONSTRAINT xml_revisions_pk PRIMARY KEY (revisionid),

Also available in: Unified diff