Revision 616
Added by bojilova over 23 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