Revision 616
Added by bojilova almost 24 years ago
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
added db sequence accnum_uniqueid_seq needed for uniqueID part of Accession#
get rid of xml_acc_numbers table