authenticvision / digitalsoul

MetaAnchor-Framework for self-hosting
MIT License
2 stars 0 forks source link

Baseline, assets join table and soft-delete #60

Closed pedrolucasp closed 11 months ago

pedrolucasp commented 11 months ago

This combines with #57 and the data migration script has been run.

Manual data migration is needed;

INSERT INTO assets_nfts (asset_id, nft_id, asset_type, assigned_by, assigned_at, active)
(
SELECT "A", "B", assets.asset_type, owner_id, assets.created_at, true  FROM "_AssetToNFT"
    INNER JOIN assets ON "_AssetToNFT"."A" = assets.id
    inner join contracts c on assets.contract_id = c.id
    inner join wallets w on c.owner_id = w.id 
)
;
tbergmueller commented 11 months ago