github.com/0xPolygon/supernets2-node@v0.0.0-20230711153321-2fe574524eaa/db/migrations/pool/0005.sql (about)

     1  -- +migrate Up
     2  UPDATE pool.transaction 
     3  SET ip = '' WHERE ip IS NULL;
     4  ALTER TABLE pool.transaction
     5  ALTER COLUMN ip SET NOT NULL;
     6  ALTER TABLE pool.transaction
     7  ALTER COLUMN ip SET DEFAULT '';
     8  
     9  -- +migrate Down
    10  ALTER TABLE pool.transaction
    11  ALTER COLUMN ip DROP NOT NULL;
    12  ALTER TABLE pool.transaction
    13  ALTER COLUMN ip DROP DEFAULT;