INSERT into doi (doi_id, doi, resource_type_id, resource_id, status)
SELECT nextval('doi_seq'),
concat('YOURPREFIX/YOURNAMESPACESEPARATOR-',currval('doi_seq')), 2, item_id, 7 FROM item
WHERE in_archive=true and item_id not in (select resource_id from doi where resource_type_id=2);