Revision 9211
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 (guid VARCHAR2(2000));
|
|
| 4 |
ALTER TABLE systemMetadata ADD (series_id VARCHAR2(2000));
|
|
| 5 | 5 |
|
| 6 | 6 |
/* |
| 7 |
* Insert the entry for dataone schema v2. |
|
| 8 |
*/ |
|
| 9 |
INSERT INTO xml_catalog (entry_type, public_id, system_id) |
|
| 10 |
VALUES ('Schema', 'http://ns.dataone.org/service/types/v2.0', '/schema/dataone/dataoneTypes_v2.0.xsd');
|
|
| 11 |
/* |
|
| 7 | 12 |
* update the database version |
| 8 | 13 |
*/ |
| 9 | 14 |
UPDATE db_version SET status=0; |
Also available in: Unified diff
Add the code to add dataone schema v2 in the xml_catalog table.
Fixed the bug the new column should be series_id rather than guid.