Revision 9217
Added by Jing Tao over 9 years ago
| src/upgrade-db-to-2.5.0-postgres.sql | ||
|---|---|---|
| 1 | 1 |
/* |
| 2 | 2 |
* Alter the system metadata table to suport seriesId |
| 3 | 3 |
*/ |
| 4 |
ALTER TABLE systemMetadata ADD COLUMN series_id text; |
|
| 4 |
ALTER TABLE systemMetadata ADD COLUMN series_id text, ADD COLUMN media_type text, ADD COLUMN file_name text;
|
|
| 5 | 5 |
|
| 6 | 6 |
/* |
| 7 | 7 |
* Add an entry for dataone schema v2 |
Also available in: Unified diff
Add the media_type and file_name columns.