Revision 2769
Added by Matt Jones over 18 years ago
xmltables-postgres.sql | ||
---|---|---|
258 | 258 |
); |
259 | 259 |
|
260 | 260 |
/* |
261 |
* Table used as Unique ID generator for the uniqueid part of Accession# |
|
261 |
* Table used to store all document identifiers in metacat. Each identifier |
|
262 |
* consists of 4 subparts, an authority, namespace, object, and revision as |
|
263 |
* defined in the LSID specification. |
|
262 | 264 |
*/ |
263 |
CREATE SEQUENCE accession_number_id_seq; |
|
264 |
CREATE TABLE accession_number ( |
|
265 |
uniqueid INT8 default nextval('accession_number_id_seq') PRIMARY KEY, |
|
266 |
site_code VARCHAR(100), |
|
267 |
date_created DATE |
|
265 |
CREATE SEQUENCE identifier_id_seq; |
|
266 |
CREATE TABLE identifier ( |
|
267 |
id INT8 default nextval('identifier_id_seq') PRIMARY KEY, -- primary id |
|
268 |
authority VARCHAR(255), -- the authority issuing the identifier |
|
269 |
namespace VARCHAR(255), -- the namespace qualifying the identifier |
|
270 |
object VARCHAR(255), -- the local part of the identifier for a particular object |
|
271 |
revision VARCHAR(255) -- the revision part of the identifier |
|
268 | 272 |
); |
269 | 273 |
|
270 | 274 |
/* |
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.