Revision 2423
Added by Jing Tao over 19 years ago
| src/upgrade-db-to-1.5.sql | ||
|---|---|---|
| 80 | 80 |
* table. The package type in xml_relation table will be eml200 rather than eml201. |
| 81 | 81 |
* The bug was fixed and we need a sql command to fix exsited records |
| 82 | 82 |
*/ |
| 83 |
UPDATE xml_relation SET packagetype='eml://ecoinformatics.org/eml-2.0.1' |
|
| 84 |
WHERE xml_relation.docid=xml_documents.docid AND xml_documents.doctype LIKE 'eml://ecoinformatics.org/eml-2.0.1';
|
|
| 83 |
UPDATE xml_relation SET packagetype='eml://ecoinformatics.org/eml-2.0.1'
|
|
| 84 |
WHERE docid IN (SELECT docid from xml_documents WHERE doctype LIKE 'eml://ecoinformatics.org/eml-2.0.1');
|
|
| 85 | 85 |
|
Also available in: Unified diff
Modify the update for xml_relation.