Project

General

Profile

Revision 2769

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:

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