Project

General

Profile

« Previous | Next » 

Revision 616

Added by bojilova about 24 years ago

added db sequence accnum_uniqueid_seq needed for uniqueID part of Accession#
get rid of xml_acc_numbers table

View differences:

src/xmltables.sql
23 23
DROP SEQUENCE xml_catalog_id_seq;
24 24
DROP SEQUENCE xml_relation_id_seq;
25 25
DROP SEQUENCE xml_replication_id_seq;
26
DROP SEQUENCE accnum_uniqueid_seq;
26 27

  
27 28
DROP TRIGGER xml_revisions_before_insert;
28 29
DROP TRIGGER xml_catalog_before_insert;
......
220 221
CREATE INDEX xml_index_idx1 ON xml_index (path);
221 222

  
222 223
/* 
223
 * table to store unique Accession # for every document in 2 parts
224
 * Sequence to get uniqueID for Accession #
224 225
 */
225
CREATE TABLE xml_acc_numbers (
226
	global_name	VARCHAR2(32),	-- first part of acc #
227
	local_id	NUMBER(20),	-- second part - unique in global name
228
   CONSTRAINT xml_acc_numbers_pk PRIMARY KEY (global_name, local_id)
229
);
226
CREATE SEQUENCE accnum_uniqueid_seq;
230 227

  
231 228
CREATE TABLE xml_relation (
232 229
  relationid    NUMBER(20) PRIMARY KEY,  -- unique id

Also available in: Unified diff