Revision 5371
Added by berkley almost 14 years ago
| upgrade-db-to-1.10.0-oracle.sql | ||
|---|---|---|
| 1 | 1 |
DROP SEQUENCE identifier_id_seq; |
| 2 | 2 |
DROP TRIGGER identifier_before_insert; |
| 3 | 3 |
DROP TABLE identifier; |
| 4 |
DROP SEQUENCE systemMetadata_id_seq; |
|
| 5 |
DROP TRIGGER systemMetadata_before_insert; |
|
| 6 |
DROP TABLE systemMetadata; |
|
| 4 | 7 |
|
| 5 |
/* |
|
| 6 |
* Table used to store all document identifiers in metacat. Each identifier |
|
| 7 |
* has a globally unique, unconstrained string, which we will refer to as a |
|
| 8 |
* GUID, and a local metacat identifier, which consists of the docid |
|
| 9 |
* and revision fields. Each row maps one global identifier to the local |
|
| 10 |
* identifier (docid) used within metacat. |
|
| 11 |
*/ |
|
| 8 |
CREATE TABLE systemMetadata ( |
|
| 9 |
guid VARCHAR2(2000), -- the globally unique string identifier |
|
| 10 |
docid VARCHAR(250), -- the local document id # |
|
| 11 |
rev NUMBER(8) -- the revision part of the local identifier |
|
| 12 |
) |
|
| 13 |
|
|
| 12 | 14 |
CREATE TABLE identifier ( |
| 13 | 15 |
guid VARCHAR2(2000), -- the globally unique string identifier |
| 14 | 16 |
docid VARCHAR2(250), -- the local document id # |
Also available in: Unified diff
added systemMetadata table to the upgrade scripts