Revision 2769
Added by Matt Jones over 18 years ago
| upgrade-db-to-1.6-postgres.sql | ||
|---|---|---|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 | 26 |
/* |
| 27 |
* Changes to the tables for handling identifiers. Old table no longer needed, |
|
| 28 |
* new identifier table to be used to support LSIDs. |
|
| 29 |
*/ |
|
| 30 |
DROP TABLE accession_number; |
|
| 31 |
DROP SEQUENCE accession_number_id_seq; |
|
| 32 |
|
|
| 33 |
/* |
|
| 34 |
* Table used to store all document identifiers in metacat. Each identifier |
|
| 35 |
* consists of 4 subparts, an authority, namespace, object, and revision as |
|
| 36 |
* defined in the LSID specification. |
|
| 37 |
*/ |
|
| 38 |
CREATE SEQUENCE identifier_id_seq; |
|
| 39 |
CREATE TABLE identifier ( |
|
| 40 |
id INT8 default nextval('identifier_id_seq') PRIMARY KEY, -- primary id
|
|
| 41 |
authority VARCHAR(255), -- the authority issuing the identifier |
|
| 42 |
namespace VARCHAR(255), -- the namespace qualifying the identifier |
|
| 43 |
object VARCHAR(255), -- the local part of the identifier for a particular object |
|
| 44 |
revision VARCHAR(255) -- the revision part of the identifier |
|
| 45 |
); |
|
| 46 |
|
|
| 47 |
/* |
|
| 27 | 48 |
* Table for indexing the paths specified the administrator in metacat.properties |
| 28 | 49 |
*/ |
| 29 | 50 |
|
Also available in: Unified diff
New SQL tables and db upgrade scripts that define a new table stucture for identifiers and delete the previously unused accession_number table. This is in anticipation of supporting LSID identifiers. Currently these tables are unused by the servlet but are in place for discussion.