Revision 9212
Added by Jing Tao over 9 years ago
| src/upgrade-db-to-2.5.0-postgres.sql | ||
|---|---|---|
| 4 | 4 |
ALTER TABLE systemMetadata ADD COLUMN series_id text; |
| 5 | 5 |
|
| 6 | 6 |
/* |
| 7 |
* Add an 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.