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