Revision 7364
Added by ben leinfelder almost 12 years ago
| doi_registration.sql | ||
|---|---|---|
| 407 | 407 |
|
| 408 | 408 |
--update resourceType |
| 409 | 409 |
update doi_registration |
| 410 |
set resourceType = 'Dataset/METADATA';
|
|
| 410 |
set resourceType = 'Dataset/metadata';
|
|
| 411 | 411 |
|
| 412 | 412 |
update doi_registration |
| 413 |
set resourceType = 'Dataset/DATA'
|
|
| 413 |
set resourceType = 'Dataset/data'
|
|
| 414 | 414 |
where objectFormat = 'BIN'; |
| 415 | 415 |
|
| 416 | 416 |
-- update the data file titles |
| ... | ... | |
| 420 | 420 |
where doi.guid = id.guid |
| 421 | 421 |
and id.docid = doc.docid |
| 422 | 422 |
and id.rev = doc.rev |
| 423 |
and doi.resourceType = 'Dataset/DATA';
|
|
| 423 |
and doi.resourceType = 'Dataset/data';
|
|
| 424 | 424 |
|
| 425 | 425 |
-- update the data file titles from revisions |
| 426 | 426 |
update doi_registration doi |
| ... | ... | |
| 429 | 429 |
where doi.guid = id.guid |
| 430 | 430 |
and id.docid = doc.docid |
| 431 | 431 |
and id.rev = doc.rev |
| 432 |
and doi.resourceType = 'Dataset/DATA';
|
|
| 432 |
and doi.resourceType = 'Dataset/data';
|
|
| 433 | 433 |
|
| 434 | 434 |
-- update the objectFormat from SM table (will be subset) |
| 435 | 435 |
update doi_registration doi |
Also available in: Unified diff
use lowercase 'metadata' and 'data' for the resourceType