Revision 749
Added by bojilova about 22 years ago
| xmltables.sql | ||
|---|---|---|
| 24 | 24 |
DROP SEQUENCE xml_relation_id_seq; |
| 25 | 25 |
DROP SEQUENCE xml_replication_id_seq; |
| 26 | 26 |
DROP SEQUENCE accnum_uniqueid_seq; |
| 27 |
DROP SEQUENCE xml_documents_id_seq; |
|
| 27 | 28 |
|
| 28 | 29 |
DROP TRIGGER xml_revisions_before_insert; |
| 29 | 30 |
DROP TRIGGER xml_catalog_before_insert; |
| ... | ... | |
| 146 | 147 |
); |
| 147 | 148 |
|
| 148 | 149 |
/* |
| 150 |
* Sequence to get uniqueID for Accession # |
|
| 151 |
*/ |
|
| 152 |
CREATE SEQUENCE xml_documents_id_seq; |
|
| 153 |
|
|
| 154 |
/* |
|
| 149 | 155 |
* Index of <docid,doctype> in xml_document |
| 150 | 156 |
*/ |
| 151 | 157 |
CREATE INDEX xml_documents_idx1 ON xml_documents (docid, doctype); |
| ... | ... | |
| 228 | 234 |
*/ |
| 229 | 235 |
CREATE INDEX xml_index_idx1 ON xml_index (path); |
| 230 | 236 |
|
| 231 |
/* |
|
| 232 |
* Sequence to get uniqueID for Accession # |
|
| 233 |
*/ |
|
| 234 |
CREATE SEQUENCE accnum_uniqueid_seq; |
|
| 235 |
|
|
| 236 | 237 |
CREATE TABLE xml_relation ( |
| 237 | 238 |
relationid NUMBER(20) PRIMARY KEY, -- unique id |
| 238 | 239 |
docid VARCHAR2(250), -- the docid of the package file |
Also available in: Unified diff
changed the db sequence name used for the accession# uniqueid
to xml_documents_id_seq.
All db sequences now are named of form <table_name>_id_seq