Revision 7353
Added by ben leinfelder over 11 years ago
| system_metadata_revisions.sql | ||
|---|---|---|
| 36 | 36 |
-- update them |
| 37 | 37 |
BEGIN; |
| 38 | 38 |
update systemmetadata sm |
| 39 |
set sm.archived = true
|
|
| 39 |
set archived = true |
|
| 40 | 40 |
from identifier id |
| 41 | 41 |
where sm.guid = id.guid |
| 42 | 42 |
and not exists (select * from xml_documents doc where doc.docid = id.docid and doc.rev = id.rev) |
Also available in: Unified diff
correct the update statement for setting archived flag on SM where document revision does not exist in the xml_documents table