Project

General

Profile

« Previous | Next » 

Revision 2769

Added by Matt Jones over 18 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:

drop-postgres.sql
39 39 
DROP SEQUENCE xml_relation_id_seq;
40 40 
DROP SEQUENCE xml_replication_id_seq;
41 41 
DROP SEQUENCE xml_documents_id_seq;
42 
DROP SEQUENCE accession_number_id_seq;
42 
DROP SEQUENCE identifier_id_seq;
43 43 
DROP SEQUENCE access_log_id_seq;
44 44 
DROP SEQUENCE xml_queryresult_id_seq;
45 45 
DROP SEQUENCE xml_returnfield_id_seq;
......
55 55 
DROP TABLE xml_nodes_revisions;
56 56 
DROP TABLE xml_replication;
57 57 
DROP TABLE xml_catalog;
58 
DROP TABLE accession_number;
58 
DROP TABLE identifier;
59 59 
DROP TABLE access_log;
60 60 
DROP TABLE harvest_site_schedule;
61 61 
DROP TABLE harvest_detail_log;

Also available in: Unified diff