metacat/src/upgrade-db-to-2.0.5-postgres.sql @ 7422
| 1 | 7392 | leinfelder | /*
|
|---|---|---|---|
| 2 | * Alter the systemmetadata* table names for Oracle length restrictions
|
||
| 3 | */
|
||
| 4 | ALTER TABLE systemMetadataReplicationPolicy RENAME TO smReplicationPolicy; |
||
| 5 | ALTER TABLE systemMetadataReplicationStatus RENAME TO smReplicationStatus; |
||
| 6 | |||
| 7 | /*
|
||
| 8 | * update the database version
|
||
| 9 | */
|
||
| 10 | UPDATE db_version SET status=0; |
||
| 11 | |||
| 12 | INSERT INTO db_version (version, status, date_created) |
||
| 13 | VALUES ('2.0.5', 1, CURRENT_DATE); |