[dataimport, migration] more fixes in the spirit of a6c32edabc8d: [entity, metadata] huuum, use resolvable url as cwuri... And fix existing ones. Closes #3390388

if repo.system_source.dbdriver == 'postgres':
    sql('ALTER TABLE appears ADD COLUMN weight float')
    sql('UPDATE appears SET weight=1.0 ')