Revision 5371
Added by berkley about 14 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 61 | 61 |
DROP TABLE xml_replication; |
| 62 | 62 |
DROP TABLE xml_catalog; |
| 63 | 63 |
DROP TABLE identifier; |
| 64 |
DROP TABLE systemMetadata; |
|
| 64 | 65 |
DROP TABLE access_log; |
| 65 | 66 |
DROP TABLE harvest_site_schedule; |
| 66 | 67 |
DROP TABLE harvest_detail_log; |
| ... | ... | |
| 393 | 394 |
/ |
| 394 | 395 |
|
| 395 | 396 |
/* |
| 397 |
* Table used to store all document identifiers for system metadata objects |
|
| 398 |
* similar restraints to identifier. Cannot use identifier table for this |
|
| 399 |
* purpose because then you have to worry about whether you insert the |
|
| 400 |
* data first or the systemMetadata first. |
|
| 401 |
*/ |
|
| 402 |
CREATE TABLE systemMetadata ( |
|
| 403 |
guid VARCHAR2(2000), -- the globally unique string identifier |
|
| 404 |
docid VARCHAR(250), -- the local document id # |
|
| 405 |
rev NUMBER(8) -- the revision part of the local identifier |
|
| 406 |
) |
|
| 407 |
|
|
| 408 |
/* |
|
| 396 | 409 |
* Table used to store all document identifiers in metacat. Each identifier |
| 397 | 410 |
* has a globally unique, unconstrained string, which we will refer to as a |
| 398 | 411 |
* GUID, and a local metacat identifier, which consists of the docid |
Also available in: Unified diff
added systemMetadata table to the upgrade scripts