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:

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