Project

General

Profile

Revision 2769

Added by Matt Jones about 15 years ago

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.

View differences:

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