Skip to content
This repository has been archived by the owner on Sep 28, 2021. It is now read-only.

Let transaction_cids.dst be null #70

Open
i-norden opened this issue Oct 23, 2020 · 0 comments
Open

Let transaction_cids.dst be null #70

i-norden opened this issue Oct 23, 2020 · 0 comments

Comments

@i-norden
Copy link
Collaborator

i-norden commented Oct 23, 2020

dst address is null in the case of a contract deployment, right now we are using a "0" representation of that 0x00000000000000000000 which is problematic for two reasons

  1. It takes up more space than NULL
  2. Sometimes the dst actually is 0x00000000000000000000 e.g. in the case of a burn transaction, and we want to be able to differentiate this

First,
UPDATE eth.transaction_cids SET dst = NULL WHERE dst = '0x00000000000000000000';

Then,
ALTER eth.transaction_cids ALTER COLUMN dst SET NOT NULL;

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant