metacat/src/upgrade-db-to-2.5.0-postgres.sql @ 8836
1 | 8810 | leinfelder | /*
|
---|---|---|---|
2 | * Alter the system metadata table to suport seriesId
|
||
3 | */
|
||
4 | ALTER TABLE systemMetadata ADD COLUMN series_id text; |
||
5 | |||
6 | /*
|
||
7 | * update the database version
|
||
8 | */
|
||
9 | UPDATE db_version SET status=0; |
||
10 | |||
11 | INSERT INTO db_version (version, status, date_created) |
||
12 | VALUES ('2.5.0', 1, CURRENT_DATE); |