Project

General

Profile

« Previous | Next » 

Revision 552

Added by berkley over 23 years ago

added support for server_location in the xml_revisions table.

View differences:

xmltables.sql
146 146
	doctitle	VARCHAR2(1000),	-- title of document if exists
147 147
	user_owner	VARCHAR2(100),
148 148
	user_updated	VARCHAR2(100),
149
  server_location NUMBER(20),
149 150
	date_created	DATE,
150 151
	date_updated	DATE,
151 152
   CONSTRAINT xml_revisions_pk PRIMARY KEY (revisionid),
153
   CONSTRAINT xml_revisions_rep_fk
154
    FOREIGN KEY (server_location) REFERENCES xml_replication,
152 155
   CONSTRAINT xml_revisions_root_fk 
153 156
		FOREIGN KEY (rootnodeid) REFERENCES xml_nodes
154 157
);

Also available in: Unified diff