Revision 7360
Added by ben leinfelder almost 12 years ago
| doi_registration.sql | ||
|---|---|---|
| 413 | 413 |
set resourceType = 'Dataset/DATA' |
| 414 | 414 |
where objectFormat = 'BIN'; |
| 415 | 415 |
|
| 416 |
-- update the data file titles |
|
| 417 |
update doi_registration doi |
|
| 418 |
set title = 'Data file - ' || doc.docname |
|
| 419 |
from identifier id, xml_documents doc |
|
| 420 |
where doi.guid = id.guid |
|
| 421 |
and id.docid = doc.docid |
|
| 422 |
and id.rev = doc.rev |
|
| 423 |
and doi.resourceType = 'Dataset/DATA'; |
|
| 424 |
|
|
| 425 |
-- update the data file titles from revisions |
|
| 426 |
update doi_registration doi |
|
| 427 |
set title = 'Data file - ' || doc.docname |
|
| 428 |
from identifier id, xml_revisions doc |
|
| 429 |
where doi.guid = id.guid |
|
| 430 |
and id.docid = doc.docid |
|
| 431 |
and id.rev = doc.rev |
|
| 432 |
and doi.resourceType = 'Dataset/DATA'; |
|
| 433 |
|
|
| 416 | 434 |
-- update the objectFormat from SM table (will be subset) |
| 417 | 435 |
update doi_registration doi |
| 418 | 436 |
set objectFormat = sm.object_format |
Also available in: Unified diff
include more descriptive data file name for title of data records