Revision 6933
Added by Matt Jones over 12 years ago
| upgrade-db-to-2.0.0-postgres.sql | ||
|---|---|---|
| 24 | 24 |
member_node VARCHAR(250), -- replication member node |
| 25 | 25 |
policy text, -- the policy (preferred, blocked, etc...TBD) |
| 26 | 26 |
CONSTRAINT systemMetadataReplicationPolicy_fk |
| 27 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
| 27 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE
|
|
| 28 | 28 |
); |
| 29 | 29 |
|
| 30 | 30 |
CREATE TABLE systemMetadataReplicationStatus ( |
| ... | ... | |
| 33 | 33 |
status VARCHAR(250), -- replication status |
| 34 | 34 |
date_verified TIMESTAMP, -- the date replication was verified |
| 35 | 35 |
CONSTRAINT systemMetadataReplicationStatus_fk |
| 36 |
FOREIGN KEY (guid) REFERENCES systemMetadata |
|
| 36 |
FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE
|
|
| 37 | 37 |
); |
| 38 | 38 |
|
| 39 | 39 |
/* |
Also available in: Unified diff
Added DOI generation to the 2.0.0 upgrade process. To succeed, this script must be run on a fresh 2.0.0 database, or on a 1.9.5 version database, as those are the only ways to get the needed foreign keys to be marked as deferrable. The identifier conversion must be turned on by setting correct properties in metacat.properties. See the comments in GenerateGlobalIdentifiers for details. By default, conversion is set to false in the properties file. If you want to convert an instance to use DOIs, be sure to set metacat.properties up BEFORE running through the Metacat configuration and database upgrade.