How to change DB schema.

[kyonRay]

I have issues for testing blockscout on my own blockchain.

And I noticed that ‘nonce’ field in transaction is int4[10] in blockscout DB schema, so it have a small available numberic range limit on ‘nonce’ field.

Unfortunately, my own blockchain will used uint64 units for ‘nonce’ field in transaction. So when I test blockscout on my blockchain, it turns out this error:

updated_at: ~U[2024-11-25 01:26:21.834453Z]}]\n\nException:\n\n** (DBConnection.EncodeError) Postgrex expected an integer in -2147483648..2147483647, got 3855436859. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly.\n

Can I change DB schema easily?

[kyonRay]

For more information, the response of eth_getBlockByNumber is below:

{
    "id": 1,
    "jsonrpc": "2.0",
    "result": {
        "difficulty": "0x0",
        "extraData": "0x",
        "gasLimit": "0x1c9c380",
        "gasUsed": "0x5f2c7",
        "hash": "0xded7dbd7c6b7d0f45c929d523bb9a7d35c6107657f49465f769019098f1d2d4e",
        "miner": "0x0000000000000000000000000000000000000000",
        "nonce": "0x0000000000000000",
        "number": "0x1b3",
        "parentHash": "0xb98f1392e7225a9036157a2c69800c2405f23c1fd630be4e6abbc07a3fe48f6c",
        "receiptsRoot": "0x3618c550a1a72d941b43ecd45dde4066899c1b2c2a679ce36f2ea934300fa030",
        "size": "0xffff",
        "stateRoot": "0x5bcc87ddc139fe57e6e07c9664861c95d6d5a4ea00a2dfd3489bd59d8c119858",
        "timestamp": "0x19349407af1",
        "totalDifficulty": "0x0",
        "transactions": [
            {
                "blockHash": "0xded7dbd7c6b7d0f45c929d523bb9a7d35c6107657f49465f769019098f1d2d4e",
                "blockNumber": "0x1b3",
                "chainId": "0x4ee8",
                "from": "0x0b3ddCa6d4e461Ff8c9294036018205D98f1182e",
                "gas": "0x2dc6c0",
                "gasPrice": "0x5208",
                "hash": "0xa36db15385464a13e5998a2872087f0ef7bd18ce96656f9bce40f140727d3ae0",
                "input": "0x6080604052348015600e575f80fd5b506040516019906055565b604051809103905ff0801580156031573d5f803e3d5ffd5b505f80546001600160a01b0319166001600160a01b03929092169190911790556062565b6104b080613e9483390190565b613e258061006f5f395ff3fe608060405234801561000f575f80fd5b506004361061009b575f3560e01c8063bed34bba11610063578063bed34bba1461015c578063c7933ed61461017f578063ce7e51e314610192578063e430da77146101a5578063eec31042146101b8575f80fd5b8063098df9b31461009f5780636c8c46bc146100c857806390423abd146100f3578063ac5d37231461011b578063b3e8b0ac1461013c575b5f80fd5b6100b26100ad366004610fa5565b6101c0565b6040516100bf9190610ff5565b60405180910390f35b6100db6100d63660046110b8565b6103f3565b6040516001600160a01b0390911681526020016100bf565b6100db610101366004610fa5565b60016020525f90815260409020546001600160a01b031681565b61012e61012936600461114d565b6105f9565b6040519081526020016100bf565b61014f61014a366004611217565b6106b4565b6040516100bf9190611277565b61016f61016a3660046112c3565b6107ce565b60405190151581526020016100bf565b61014f61018d366004610fa5565b610826565b6100b26101a0366004611319565b610987565b6100db6101b336600461114d565b610a8d565b61014f610cc6565b604051606082811b6bffffffffffffffffffffffff19166020830152905f9060340160408051601f19818403018152828201909152601082526f181899199a1a9b1b9c1cb0b131b232b360811b602083015280519092505f90610224906002611344565b61022f90600261135b565b67ffffffffffffffff81111561024757610247611007565b6040519080825280601f01601f191660200182016040528015610271576020820181803683370190505b509050600360fc1b815f8151811061028b5761028b61136e565b60200101906001600160f81b03191690815f1a905350600f60fb1b816001815181106102b9576102b961136e565b60200101906001600160f81b03191690815f1a9053505f5b83518110156103ea578260048583815181106102ef576102ef61136e565b016020015182516001600160f81b031990911690911c60f81c9081106103175761031761136e565b01602001516001600160f81b03191682610332836002611344565b61033d90600261135b565b8151811061034d5761034d61136e565b60200101906001600160f81b03191690815f1a905350828482815181106103765761037661136e565b602091010151815160f89190911c600f169081106103965761039661136e565b01602001516001600160f81b031916826103b1836002611344565b6103bc90600361135b565b815181106103cc576103cc61136e565b60200101906001600160f81b03191690815f1a9053506001016102d1565b50949350505050565b5f8054604051630bb7c8fd60e31b81526001600160a01b03878116600483015290911690635dbe47e890602401602060405180830381865afa15801561043b573d5f803e3d5ffd5b505050506040513d601f19601f8201168201806040525081019061045f9190611382565b610511575f54604051630a3b0a4f60e01b81526001600160a01b03878116600483015290911690630a3b0a4f906024015f604051808303815f87803b1580156104a6575f80fd5b505af11580156104b8573d5f803e3d5ffd5b505050506040516104c890610f74565b604051809103905ff0801580156104e1573d5f803e3d5ffd5b506001600160a01b038681165f90815260016020526040902080546001600160a01b031916929091169190911790555b5f8585858560405161052290610f81565b61052f94939291906113a1565b604051809103905ff080158015610548573d5f803e3d5ffd5b506001600160a01b038781165f9081526001602052604090819020549051630a3b0a4f60e01b815283831660048201529293501690630a3b0a4f906024015f604051808303815f87803b15801561059d575f80fd5b505af11580156105af573d5f803e3d5ffd5b50506040516001600160a01b03841681527f2f9dc77fe24e01fd64df482be5de909cbbe59872d75c92be9594861ec6046ed79250602001905060405180910390a195945050505050565b5f8181805b82518110156106ac575f83828151811061061a5761061a61136e565b016020015160f81c905060308110801590610639575060398160ff1611155b61067e5760405162461bcd60e51b815260206004820152601160248201527024b73b30b634b21031b430b930b1ba32b960791b60448201526064015b60405180910390fd5b610689603082611431565b60ff1661069784600a611344565b6106a1919061135b565b9250506001016105fe565b509392505050565b60605f825184516106c5919061135b565b67ffffffffffffffff8111156106dd576106dd611007565b604051908082528060200260200182016040528015610706578160200160208202803683370190505b5090505f5b8451811015610760578481815181106107265761072661136e565b60200260200101518282815181106107405761074061136e565b6001600160a01b039092166020928302919091019091015260010161070b565b505f5b83518110156107c45783818151811061077e5761077e61136e565b602002602001015182828751610794919061135b565b815181106107a4576107a461136e565b6001600160a01b0390921660209283029190910190910152600101610763565b5090505b92915050565b5f816040516020016107e0919061144a565b6040516020818303038152906040528051906020012083604051602001610807919061144a565b6040516020818303038152906040528051906020012014905092915050565b5f54604051630bb7c8fd60e31b81526001600160a01b0383811660048301526060921690635dbe47e890602401602060405180830381865afa15801561086e573d5f803e3d5ffd5b505050506040513d601f19601f820116820180604052508101906108929190611382565b61090f5760405162461bcd60e51b815260206004820152604260248201527f49737375657220646f6573206e6f742065786973742c20706c6561736520636860448201527f65636b2074686520697373756572206164647265737320697320636f727265636064820152613a1760f11b608482015260a401610675565b6001600160a01b038083165f908152600160205260408082205481516353ed514360e01b815291519316926353ed5143926004808401939192918290030181865afa158015610960573d5f803e3d5ffd5b505050506040513d5f823e601f3d908101601f191682016040526107c89190810190611460565b6060815f036109ad5750506040805180820190915260018152600360fc1b602082015290565b815f5b81156109d657806109c0816114ea565b91506109cf9050600a83611516565b91506109b0565b5f8167ffffffffffffffff8111156109f0576109f0611007565b6040519080825280601f01601f191660200182016040528015610a1a576020820181803683370190505b5090505b8415610a855781610a2e81611529565b9250610a3d9050600a8661153e565b610a4890603061135b565b60f81b818381518110610a5d57610a5d61136e565b60200101906001600160f81b03191690815f1a905350610a7e600a86611516565b9450610a1e565b949350505050565b80515f908290602a14610adb5760405162461bcd60e51b8152602060048201526016602482015275092dcecc2d8d2c840c2c8c8e4cae6e640d8cadccee8d60531b6044820152606401610675565b600360fc1b6001600160f81b031916815f81518110610afc57610afc61136e565b01602001516001600160f81b031916148015610b7e5750600f60fb1b6001600160f81b03191681600181518110610b3557610b3561136e565b01602001516001600160f81b0319161480610b7e5750600b60fb1b6001600160f81b03191681600181518110610b6d57610b6d61136e565b01602001516001600160f81b031916145b610bc35760405162461bcd60e51b8152602060048201526016602482015275125b9d985b1a59081859191c995cdcc8199bdc9b585d60521b6044820152606401610675565b5f60025b82518110156106ac575f838281518110610be357610be361136e565b016020015160f81c905060308110801590610c02575060398160ff1611155b15610c3157610c12603082611431565b60ff16610c20846010611551565b610c2a9190611583565b9250610cbd565b60418160ff1610158015610c49575060468160ff1611155b15610c5957610c12603782611431565b60618160ff1610158015610c71575060668160ff1611155b15610c8157610c12605782611431565b60405162461bcd60e51b815260206004820152601160248201527024b73b30b634b21031b430b930b1ba32b960791b6044820152606401610675565b50600101610bc7565b60608060015b5f8054906101000a90046001600160a01b03166001600160a01b031663949d225d6040518163ffffffff1660e01b8152600401602060405180830381865afa158015610d1a573d5f803e3d5ffd5b505050506040513d601f19601f82011682018060405250810190610d3e91906115aa565b8111610f6e57805f03610e52575f8054604051634a83e9cd60e11b815260048101849052600192916001600160a01b031690639507d39a90602401602060405180830381865afa158015610d94573d5f803e3d5ffd5b505050506040513d601f19601f82011682018060405250810190610db891906115c1565b6001600160a01b03166001600160a01b031681526020019081526020015f205f9054906101000a90046001600160a01b03166001600160a01b03166353ed51436040518163ffffffff1660e01b81526004015f60405180830381865afa158015610e24573d5f803e3d5ffd5b505050506040513d5f823e601f3d908101601f19168201604052610e4b9190810190611460565b9150610f5c565b5f8054604051634a83e9cd60e11b815260048101849052610f599285926001926001600160a01b0390911690639507d39a90602401602060405180830381865afa158015610ea2573d5f803e3d5ffd5b505050506040513d601f19601f82011682018060405250810190610ec691906115c1565b6001600160a01b03166001600160a01b031681526020019081526020015f205f9054906101000a90046001600160a01b03166001600160a01b03166353ed51436040518163ffffffff1660e01b81526004015f60405180830381865afa158015610f32573d5f803e3d5ffd5b505050506040513d5f823e601f3d908101601f1916820160405261014a9190810190611460565b91505b80610f66816114ea565b915050610ccc565b50919050565b6104b0806115dd83390190565b61236380611a8d83390190565b6001600160a01b0381168114610fa2575f80fd5b50565b5f60208284031215610fb5575f80fd5b8135610fc081610f8e565b9392505050565b5f81518084528060208401602086015e5f602082860101526020601f19601f83011685010191505092915050565b602081525f610fc06020830184610fc7565b634e487b7160e01b5f52604160045260245ffd5b604051601f8201601f1916810167ffffffffffffffff8111828210171561104457611044611007565b604052919050565b5f82601f83011261105b575f80fd5b813567ffffffffffffffff81111561107557611075611007565b611088601f8201601f191660200161101b565b81815284602083860101111561109c575f80fd5b816020850160208301375f918101602001919091529392505050565b5f805f80608085870312156110cb575f80fd5b84356110d681610f8e565b9350602085013567ffffffffffffffff808211156110f2575f80fd5b6110fe8883890161104c565b94506040870135915080821115611113575f80fd5b61111f8883890161104c565b93506060870135915080821115611134575f80fd5b506111418782880161104c565b91505092959194509250565b5f6020828403121561115d575f80fd5b813567ffffffffffffffff811115611173575f80fd5b610a858482850161104c565b5f67ffffffffffffffff82111561119857611198611007565b5060051b60200190565b5f82601f8301126111b1575f80fd5b813560206111c66111c18361117f565b61101b565b8083825260208201915060208460051b8701019350868411156111e7575f80fd5b602086015b8481101561120c5780356111ff81610f8e565b83529183019183016111ec565b509695505050505050565b5f8060408385031215611228575f80fd5b823567ffffffffffffffff8082111561123f575f80fd5b61124b868387016111a2565b93506020850135915080821115611260575f80fd5b5061126d858286016111a2565b9150509250929050565b602080825282518282018190525f9190848201906040850190845b818110156112b75783516001600160a01b031683529284019291840191600101611292565b50909695505050505050565b5f80604083850312156112d4575f80fd5b823567ffffffffffffffff808211156112eb575f80fd5b6112f78683870161104c565b9350602085013591508082111561130c575f80fd5b5061126d8582860161104c565b5f60208284031215611329575f80fd5b5035919050565b634e487b7160e01b5f52601160045260245ffd5b80820281158282048414176107c8576107c8611330565b808201808211156107c8576107c8611330565b634e487b7160e01b5f52603260045260245ffd5b5f60208284031215611392575f80fd5b81518015158114610fc0575f80fd5b60c080825260059082015264185dd85c9960da1b60e082015261010060208201819052600390820152621055d160ea1b6101208201526001600160a01b0385166040820152610140606082018190525f906113fe81840187610fc7565b905082810360808401526114128186610fc7565b905082810360a08401526114268185610fc7565b979650505050505050565b60ff82811682821603908111156107c8576107c8611330565b5f82518060208501845e5f920191825250919050565b5f6020808385031215611471575f80fd5b825167ffffffffffffffff811115611487575f80fd5b8301601f81018513611497575f80fd5b80516114a56111c18261117f565b81815260059190911b820183019083810190878311156114c3575f80fd5b928401925b828410156114265783516114db81610f8e565b825292840192908401906114c8565b5f600182016114fb576114fb611330565b5060010190565b634e487b7160e01b5f52601260045260245ffd5b5f8261152457611524611502565b500490565b5f8161153757611537611330565b505f190190565b5f8261154c5761154c611502565b500690565b6001600160a01b0382811682821681810283169291811582850482141761157a5761157a611330565b50505092915050565b6001600160a01b038181168382160190808211156115a3576115a3611330565b5092915050565b5f602082840312156115ba575f80fd5b5051919050565b5f602082840312156115d1575f80fd5b8151610fc081610f8e56fe60806040525f80553480156011575f80fd5b506104918061001f5f395ff3fe608060405234801561000f575f80fd5b5060043610610060575f3560e01c80630a3b0a4f1461006457806329092d0e1461007957806353ed51431461008c5780635dbe47e8146100aa578063949d225d146100e45780639507d39a146100f4575b5f80fd5b610077610072366004610349565b61011f565b005b610077610087366004610349565b61018f565b610094610222565b6040516100a19190610376565b60405180910390f35b6100d46100b8366004610349565b6001600160a01b03165f90815260026020526040902054151590565b60405190151581526020016100a1565b5f546040519081526020016100a1565b6101076101023660046103c2565b6102dd565b6040516001600160a01b0390911681526020016100a1565b6001600160a01b0381165f908152600260205260409020541561013f5750565b5f8054908061014d836103ed565b90915550505f8054815260016020908152604080832080546001600160a01b039095166001600160a01b03199095168517905582549383526002909152902055565b6001600160a01b0381165f908152600260205260409020546101ae5750565b5f80548152600160208181526040808420546001600160a01b0386811680875260028086528488208054808a5297875285892080546001600160a01b0319169490951693841790945582885290945291852084905591845290839055825490928061021883610405565b9190505550505050565b60605f805467ffffffffffffffff81111561023f5761023f61041a565b604051908082528060200260200182016040528015610268578160200160208202803683370190505b50905060015b5f5481116102d7575f818152600160208190526040909120546001600160a01b031690839061029d908461042e565b815181106102ad576102ad610447565b6001600160a01b0390921660209283029190910190910152806102cf816103ed565b91505061026e565b50919050565b5f80821180156102ee57505f548211155b61032e5760405162461bcd60e51b815260206004820152600d60248201526c092dcecc2d8d2c840d2dcc8caf609b1b604482015260640160405180910390fd5b505f908152600160205260409020546001600160a01b031690565b5f60208284031215610359575f80fd5b81356001600160a01b038116811461036f575f80fd5b9392505050565b602080825282518282018190525f9190848201906040850190845b818110156103b65783516001600160a01b031683529284019291840191600101610391565b50909695505050505050565b5f602082840312156103d2575f80fd5b5035919050565b634e487b7160e01b5f52601160045260245ffd5b5f600182016103fe576103fe6103d9565b5060010190565b5f81610413576104136103d9565b505f190190565b634e487b7160e01b5f52604160045260245ffd5b81810381811115610441576104416103d9565b92915050565b634e487b7160e01b5f52603260045260245ffdfea26469706673582212200e40c54371c44c19d4e6360267a8161e16e3115ae651f833166134fae0db490064736f6c63430008190033608060405234801561000f575f80fd5b5060405161236338038061236383398101604081905261002e91610286565b85855f61003b83826103e1565b50600161004882826103e1565b50505061006161005c6100a060201b60201c565b6100a4565b600a61006d84826103e1565b50600b61007a83826103e1565b50600c61008782826103e1565b5042600d55610095846100f5565b5050505050506104a0565b3390565b600780546001600160a01b038381166001600160a01b0319831681179093556040519116919082907f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e0905f90a35050565b6100fd610173565b6001600160a01b0381166101675760405162461bcd60e51b815260206004820152602660248201527f4f776e61626c653a206e6577206f776e657220697320746865207a65726f206160448201526564647265737360d01b60648201526084015b60405180910390fd5b610170816100a4565b50565b6007546001600160a01b031633146101cd5760405162461bcd60e51b815260206004820181905260248201527f4f776e61626c653a2063616c6c6572206973206e6f7420746865206f776e6572604482015260640161015e565b565b634e487b7160e01b5f52604160045260245ffd5b5f82601f8301126101f2575f80fd5b81516001600160401b038082111561020c5761020c6101cf565b604051601f8301601f19908116603f01168101908282118183101715610234576102346101cf565b8160405283815286602085880101111561024c575f80fd5b8360208701602083015e5f602085830101528094505050505092915050565b80516001600160a01b0381168114610281575f80fd5b919050565b5f805f805f8060c0878903121561029b575f80fd5b86516001600160401b03808211156102b1575f80fd5b6102bd8a838b016101e3565b975060208901519150808211156102d2575f80fd5b6102de8a838b016101e3565b96506102ec60408a0161026b565b95506060890151915080821115610301575f80fd5b61030d8a838b016101e3565b94506080890151915080821115610322575f80fd5b61032e8a838b016101e3565b935060a0890151915080821115610343575f80fd5b5061035089828a016101e3565b9150509295509295509295565b600181811c9082168061037157607f821691505b60208210810361038f57634e487b7160e01b5f52602260045260245ffd5b50919050565b601f8211156103dc57805f5260205f20601f840160051c810160208510156103ba5750805b601f840160051c820191505b818110156103d9575f81556001016103c6565b50505b505050565b81516001600160401b038111156103fa576103fa6101cf565b61040e81610408845461035d565b84610395565b602080601f831160018114610441575f841561042a5750858301515b5f19600386901b1c1916600185901b178555610498565b5f85815260208120601f198616915b8281101561046f57888601518255948401946001909101908401610450565b508582101561048c57878501515f19600388901b60f8161c191681555b505060018460011b0185555b505050505050565b611eb6806104ad5f395ff3fe608060405234801561000f575f80fd5b50600436106101a0575f3560e01c80638191745f116100f3578063b935319d11610093578063e985e9c51161006e578063e985e9c514610348578063eb195d4614610383578063f2fde38b14610396578063fd74b299146103a9575f80fd5b8063b935319d14610318578063c293e60214610320578063c87b56dd14610335575f80fd5b8063a22cb465116100ce578063a22cb465146102d7578063b7f5eeb0146102ea578063b87f0404146102fd578063b88d4fde14610305575f80fd5b80638191745f146102b65780638da5cb5b146102be57806395d89b41146102cf575f80fd5b806342842e0e1161015e5780636352211e116101395780636352211e146102755780636646847a1461028857806370a082311461029b578063715018a6146102ae575f80fd5b806342842e0e146102465780634b6e7d781461025957806354a9ddd914610262575f80fd5b8062d2c779146101a457806301ffc9a7146101bb57806306fdde03146101de578063081812fc146101f3578063095ea7b31461021e57806323b872dd14610233575b5f80fd5b6009545b6040519081526020015b60405180910390f35b6101ce6101c936600461175b565b6103bc565b60405190151581526020016101b2565b6101e66103cc565b6040516101b291906117a4565b6102066102013660046117b6565b61045b565b6040516001600160a01b0390911681526020016101b2565b61023161022c3660046117e8565b610480565b005b610231610241366004611810565b610599565b610231610254366004611810565b6105ca565b6101a8600d5481565b6101e66102703660046117b6565b6105e4565b6102066102833660046117b6565b610614565b6101a86102963660046118f0565b610673565b6101a86102a936600461194e565b61071e565b6102316107a2565b6101e66107b5565b6007546001600160a01b0316610206565b6101e6610841565b6102316102e5366004611974565b610850565b6102316102f83660046117b6565b61085f565b6101e66108a1565b6102316103133660046119a9565b6108ae565b6101e66108e6565b6103286108f3565b6040516101b29190611a20565b6101e66103433660046117b6565b610948565b6101ce610356366004611a63565b6001600160a01b039182165f90815260056020908152604080832093909416825291909152205460ff1690565b6101ce610391366004611a63565b610953565b6102316103a436600461194e565b6109c7565b6101e66103b7366004611a63565b610a3d565b5f6103c682610aac565b92915050565b60605f80546103da90611a8b565b80601f016020809104026020016040519081016040528092919081815260200182805461040690611a8b565b80156104515780601f1061042857610100808354040283529160200191610451565b820191905f5260205f20905b81548152906001019060200180831161043457829003601f168201915b5050505050905090565b5f61046582610ad0565b505f908152600460205260409020546001600160a01b031690565b5f61048a82610614565b9050806001600160a01b0316836001600160a01b0316036104fc5760405162461bcd60e51b815260206004820152602160248201527f4552433732313a20617070726f76616c20746f2063757272656e74206f776e656044820152603960f91b60648201526084015b60405180910390fd5b336001600160a01b038216148061051857506105188133610356565b61058a5760405162461bcd60e51b815260206004820152603d60248201527f4552433732313a20617070726f76652063616c6c6572206973206e6f7420746f60448201527f6b656e206f776e6572206f7220617070726f76656420666f7220616c6c00000060648201526084016104f3565b6105948383610b20565b505050565b6105a33382610b8d565b6105bf5760405162461bcd60e51b81526004016104f390611ac3565b610594838383610c09565b61059483838360405180602001604052805f8152506108ae565b60606105ef82610d6b565b61060b5760405162461bcd60e51b81526004016104f390611b10565b6103c682610948565b5f818152600260205260408120546001600160a01b0316806103c65760405162461bcd60e51b8152602060048201526018602482015277115490cdcc8c4e881a5b9d985b1a59081d1bdad95b88125160421b60448201526064016104f3565b5f61067c610d87565b5f61068660085490565b90506106928382610de1565b61069c8185610f4d565b600980546001810182555f919091527f6e1540171b6c0c960b71a7020d9f60077f6af931a8bbf590da0223dacf75c7af018190556106de600880546001019055565b7f50c5c39fe4f489128a7a09cdb1676c98f63cf28379298acb7ce770137df70291818560405161070f929190611b6d565b60405180910390a19392505050565b5f6001600160a01b0382166107875760405162461bcd60e51b815260206004820152602960248201527f4552433732313a2061646472657373207a65726f206973206e6f7420612076616044820152683634b21037bbb732b960b91b60648201526084016104f3565b506001600160a01b03165f9081526003602052604090205490565b6107aa610d87565b6107b35f611008565b565b600b80546107c290611a8b565b80601f01602080910402602001604051908101604052809291908181526020018280546107ee90611a8b565b80156108395780601f1061081057610100808354040283529160200191610839565b820191905f5260205f20905b81548152906001019060200180831161081c57829003601f168201915b505050505081565b6060600180546103da90611a8b565b61085b338383611059565b5050565b610867610d87565b61087081610d6b565b61088c5760405162461bcd60e51b81526004016104f390611b10565b61089581611126565b61089e8161112f565b50565b600a80546107c290611a8b565b6108b83383610b8d565b6108d45760405162461bcd60e51b81526004016104f390611ac3565b6108e0848484846111d4565b50505050565b600c80546107c290611a8b565b6060600980548060200260200160405190810160405280929190818152602001828054801561045157602002820191905f5260205f20905b81548152602001906001019080831161092b575050505050905090565b60606103c682611207565b604051631830003560e21b81526001600160a01b0382811660048301525f9184918216906360c000d490602401602060405180830381865afa15801561099b573d5f803e3d5ffd5b505050506040513d601f19601f820116820180604052508101906109bf9190611b85565b949350505050565b6109cf610d87565b6001600160a01b038116610a345760405162461bcd60e51b815260206004820152602660248201527f4f776e61626c653a206e6577206f776e657220697320746865207a65726f206160448201526564647265737360d01b60648201526084016104f3565b61089e81611008565b6040516303f6189560e11b81526001600160a01b03828116600483015260609184918216906307ec312a906024015f60405180830381865afa158015610a85573d5f803e3d5ffd5b505050506040513d5f823e601f3d908101601f191682016040526109bf9190810190611ba0565b5f6001600160e01b03198216632483248360e11b14806103c657506103c682611309565b610ad981610d6b565b61089e5760405162461bcd60e51b8152602060048201526018602482015277115490cdcc8c4e881a5b9d985b1a59081d1bdad95b88125160421b60448201526064016104f3565b5f81815260046020526040902080546001600160a01b0319166001600160a01b0384169081179091558190610b5482610614565b6001600160a01b03167f8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b92560405160405180910390a45050565b5f80610b9883610614565b9050806001600160a01b0316846001600160a01b03161480610bde57506001600160a01b038082165f9081526005602090815260408083209388168352929052205460ff165b806109bf5750836001600160a01b0316610bf78461045b565b6001600160a01b031614949350505050565b826001600160a01b0316610c1c82610614565b6001600160a01b031614610c425760405162461bcd60e51b81526004016104f390611c15565b6001600160a01b038216610ca45760405162461bcd60e51b8152602060048201526024808201527f4552433732313a207472616e7366657220746f20746865207a65726f206164646044820152637265737360e01b60648201526084016104f3565b826001600160a01b0316610cb782610614565b6001600160a01b031614610cdd5760405162461bcd60e51b81526004016104f390611c15565b5f81815260046020908152604080832080546001600160a01b03199081169091556001600160a01b038781168086526003855283862080545f1901905590871680865283862080546001019055868652600290945282852080549092168417909155905184937fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef91a4505050565b5f908152600260205260409020546001600160a01b0316151590565b6007546001600160a01b031633146107b35760405162461bcd60e51b815260206004820181905260248201527f4f776e61626c653a2063616c6c6572206973206e6f7420746865206f776e657260448201526064016104f3565b6001600160a01b038216610e375760405162461bcd60e51b815260206004820181905260248201527f4552433732313a206d696e7420746f20746865207a65726f206164647265737360448201526064016104f3565b610e4081610d6b565b15610e8d5760405162461bcd60e51b815260206004820152601c60248201527f4552433732313a20746f6b656e20616c7265616479206d696e7465640000000060448201526064016104f3565b610e9681610d6b565b15610ee35760405162461bcd60e51b815260206004820152601c60248201527f4552433732313a20746f6b656e20616c7265616479206d696e7465640000000060448201526064016104f3565b6001600160a01b0382165f81815260036020908152604080832080546001019055848352600290915280822080546001600160a01b0319168417905551839291907fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef908290a45050565b610f5682610d6b565b610fb95760405162461bcd60e51b815260206004820152602e60248201527f45524337323155524953746f726167653a2055524920736574206f66206e6f6e60448201526d32bc34b9ba32b73a103a37b5b2b760911b60648201526084016104f3565b5f828152600660205260409020610fd08282611ca5565b506040518281527ff8e1a15aba9398e019f0b49df1a4fde98ee17ae345cb5f6b5e2c27f5033e8ce79060200160405180910390a15050565b600780546001600160a01b038381166001600160a01b0319831681179093556040519116919082907f8be0079c531659141344cd1fd0a4f28419497f9722a3daafe3b4186f6b6457e0905f90a35050565b816001600160a01b0316836001600160a01b0316036110ba5760405162461bcd60e51b815260206004820152601960248201527f4552433732313a20617070726f766520746f2063616c6c65720000000000000060448201526064016104f3565b6001600160a01b038381165f81815260056020908152604080832094871680845294825291829020805460ff191686151590811790915591519182527f17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31910160405180910390a3505050565b61089e81611358565b5f5b60095481101561085b57816009828154811061114f5761114f611d65565b905f5260205f200154036111cc576009805461116d90600190611d79565b8154811061117d5761117d611d65565b905f5260205f2001546009828154811061119957611199611d65565b5f9182526020909120015560098054806111b5576111b5611d98565b600190038181905f5260205f20015f905590555050565b600101611131565b6111df848484610c09565b6111eb84848484611396565b6108e05760405162461bcd60e51b81526004016104f390611dac565b606061121282610ad0565b5f828152600660205260408120805461122a90611a8b565b80601f016020809104026020016040519081016040528092919081815260200182805461125690611a8b565b80156112a15780601f10611278576101008083540402835291602001916112a1565b820191905f5260205f20905b81548152906001019060200180831161128457829003601f168201915b505050505090505f6112bd60408051602081019091525f815290565b905080515f036112ce575092915050565b8151156113005780826040516020016112e8929190611e15565b60405160208183030381529060405292505050919050565b6109bf84611493565b5f6001600160e01b031982166380ac58cd60e01b148061133957506001600160e01b03198216635b5e139f60e01b145b806103c657506301ffc9a760e01b6001600160e01b03198316146103c6565b61136181611503565b5f818152600660205260409020805461137990611a8b565b15905061089e575f81815260066020526040812061089e916116fc565b5f6001600160a01b0384163b1561148857604051630a85bd0160e11b81526001600160a01b0385169063150b7a02906113d9903390899088908890600401611e29565b6020604051808303815f875af1925050508015611413575060408051601f3d908101601f1916820190925261141091810190611e65565b60015b61146e573d808015611440576040519150601f19603f3d011682016040523d82523d5f602084013e611445565b606091505b5080515f036114665760405162461bcd60e51b81526004016104f390611dac565b805181602001fd5b6001600160e01b031916630a85bd0160e11b1490506109bf565b506001949350505050565b606061149e82610ad0565b5f6114b360408051602081019091525f815290565b90505f8151116114d15760405180602001604052805f8152506114fc565b806114db84611595565b6040516020016114ec929190611e15565b6040516020818303038152906040525b9392505050565b5f61150d82610614565b905061151882610614565b5f83815260046020908152604080832080546001600160a01b03199081169091556001600160a01b0385168085526003845282852080545f190190558785526002909352818420805490911690555192935084927fddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef908390a45050565b60605f6115a183611625565b60010190505f8167ffffffffffffffff8111156115c0576115c0611849565b6040519080825280601f01601f1916602001820160405280156115ea576020820181803683370190505b5090508181016020015b5f19016f181899199a1a9b1b9c1cb0b131b232b360811b600a86061a8153600a85049450846115f457509392505050565b5f8072184f03e93ff9f4daa797ed6e38ed64bf6a1f0160401b83106116635772184f03e93ff9f4daa797ed6e38ed64bf6a1f0160401b830492506040015b6d04ee2d6d415b85acef8100000000831061168f576d04ee2d6d415b85acef8100000000830492506020015b662386f26fc1000083106116ad57662386f26fc10000830492506010015b6305f5e10083106116c5576305f5e100830492506008015b61271083106116d957612710830492506004015b606483106116eb576064830492506002015b600a83106103c65760010192915050565b50805461170890611a8b565b5f825580601f10611717575050565b601f0160209004905f5260205f209081019061089e91905b80821115611742575f815560010161172f565b5090565b6001600160e01b03198116811461089e575f80fd5b5f6020828403121561176b575f80fd5b81356114fc81611746565b5f81518084528060208401602086015e5f602082860101526020601f19601f83011685010191505092915050565b602081525f6114fc6020830184611776565b5f602082840312156117c6575f80fd5b5035919050565b80356001600160a01b03811681146117e3575f80fd5b919050565b5f80604083850312156117f9575f80fd5b611802836117cd565b946020939093013593505050565b5f805f60608486031215611822575f80fd5b61182b846117cd565b9250611839602085016117cd565b9150604084013590509250925092565b634e487b7160e01b5f52604160045260245ffd5b604051601f8201601f1916810167ffffffffffffffff8111828210171561188657611886611849565b604052919050565b5f67ffffffffffffffff8211156118a7576118a7611849565b50601f01601f191660200190565b5f6118c76118c28461188e565b61185d565b90508281528383830111156118da575f80fd5b828260208301375f602084830101529392505050565b5f8060408385031215611901575f80fd5b823567ffffffffffffffff811115611917575f80fd5b8301601f81018513611927575f80fd5b611936858235602084016118b5565b925050611945602084016117cd565b90509250929050565b5f6020828403121561195e575f80fd5b6114fc826117cd565b801515811461089e575f80fd5b5f8060408385031215611985575f80fd5b61198e836117cd565b9150602083013561199e81611967565b809150509250929050565b5f805f80608085870312156119bc575f80fd5b6119c5856117cd565b93506119d3602086016117cd565b925060408501359150606085013567ffffffffffffffff8111156119f5575f80fd5b8501601f81018713611a05575f80fd5b611a14878235602084016118b5565b91505092959194509250565b602080825282518282018190525f9190848201906040850190845b81811015611a5757835183529284019291840191600101611a3b565b50909695505050505050565b5f8060408385031215611a74575f80fd5b611a7d836117cd565b9150611945602084016117cd565b600181811c90821680611a9f57607f821691505b602082108103611abd57634e487b7160e01b5f52602260045260245ffd5b50919050565b6020808252602d908201527f4552433732313a2063616c6c6572206973206e6f7420746f6b656e206f776e6560408201526c1c881bdc88185c1c1c9bdd9959609a1b606082015260800190565b6020808252603b908201527f417761726420646f6573206e6f742065786973742c20706c656173652063686560408201527f636b2074686520746f6b656e20494420697320636f72726563742e0000000000606082015260800190565b828152604060208201525f6109bf6040830184611776565b5f60208284031215611b95575f80fd5b81516114fc81611967565b5f60208284031215611bb0575f80fd5b815167ffffffffffffffff811115611bc6575f80fd5b8201601f81018413611bd6575f80fd5b8051611be46118c28261188e565b818152856020838501011115611bf8575f80fd5b8160208401602083015e5f91810160200191909152949350505050565b60208082526025908201527f4552433732313a207472616e736665722066726f6d20696e636f72726563742060408201526437bbb732b960d91b606082015260800190565b601f82111561059457805f5260205f20601f840160051c81016020851015611c7f5750805b601f840160051c820191505b81811015611c9e575f8155600101611c8b565b5050505050565b815167ffffffffffffffff811115611cbf57611cbf611849565b611cd381611ccd8454611a8b565b84611c5a565b602080601f831160018114611d06575f8415611cef5750858301515b5f19600386901b1c1916600185901b178555611d5d565b5f85815260208120601f198616915b82811015611d3457888601518255948401946001909101908401611d15565b5085821015611d5157878501515f19600388901b60f8161c191681555b505060018460011b0185555b505050505050565b634e487b7160e01b5f52603260045260245ffd5b818103818111156103c657634e487b7160e01b5f52601160045260245ffd5b634e487b7160e01b5f52603160045260245ffd5b60208082526032908201527f4552433732313a207472616e7366657220746f206e6f6e20455243373231526560408201527131b2b4bb32b91034b6b83632b6b2b73a32b960711b606082015260800190565b5f81518060208401855e5f93019283525090919050565b5f6109bf611e238386611dfe565b84611dfe565b6001600160a01b03858116825284166020820152604081018390526080606082018190525f90611e5b90830184611776565b9695505050505050565b5f60208284031215611e75575f80fd5b81516114fc8161174656fea2646970667358221220f2fbfdff28f70150e4706ca3e8b43ecee346e6206a36bed62262f2538b9158e464736f6c63430008190033a26469706673582212208b588a02fe79f44fd751f7f75fd89e973c2f5be0c8b6af1086358eaf4003105964736f6c6343000819003360806040525f80553480156011575f80fd5b506104918061001f5f395ff3fe608060405234801561000f575f80fd5b5060043610610060575f3560e01c80630a3b0a4f1461006457806329092d0e1461007957806353ed51431461008c5780635dbe47e8146100aa578063949d225d146100e45780639507d39a146100f4575b5f80fd5b610077610072366004610349565b61011f565b005b610077610087366004610349565b61018f565b610094610222565b6040516100a19190610376565b60405180910390f35b6100d46100b8366004610349565b6001600160a01b03165f90815260026020526040902054151590565b60405190151581526020016100a1565b5f546040519081526020016100a1565b6101076101023660046103c2565b6102dd565b6040516001600160a01b0390911681526020016100a1565b6001600160a01b0381165f908152600260205260409020541561013f5750565b5f8054908061014d836103ed565b90915550505f8054815260016020908152604080832080546001600160a01b039095166001600160a01b03199095168517905582549383526002909152902055565b6001600160a01b0381165f908152600260205260409020546101ae5750565b5f80548152600160208181526040808420546001600160a01b0386811680875260028086528488208054808a5297875285892080546001600160a01b0319169490951693841790945582885290945291852084905591845290839055825490928061021883610405565b9190505550505050565b60605f805467ffffffffffffffff81111561023f5761023f61041a565b604051908082528060200260200182016040528015610268578160200160208202803683370190505b50905060015b5f5481116102d7575f818152600160208190526040909120546001600160a01b031690839061029d908461042e565b815181106102ad576102ad610447565b6001600160a01b0390921660209283029190910190910152806102cf816103ed565b91505061026e565b50919050565b5f80821180156102ee57505f548211155b61032e5760405162461bcd60e51b815260206004820152600d60248201526c092dcecc2d8d2c840d2dcc8caf609b1b604482015260640160405180910390fd5b505f908152600160205260409020546001600160a01b031690565b5f60208284031215610359575f80fd5b81356001600160a01b038116811461036f575f80fd5b9392505050565b602080825282518282018190525f9190848201906040850190845b818110156103b65783516001600160a01b031683529284019291840191600101610391565b50909695505050505050565b5f602082840312156103d2575f80fd5b5035919050565b634e487b7160e01b5f52601160045260245ffd5b5f600182016103fe576103fe6103d9565b5060010190565b5f81610413576104136103d9565b505f190190565b634e487b7160e01b5f52604160045260245ffd5b81810381811115610441576104416103d9565b92915050565b634e487b7160e01b5f52603260045260245ffdfea26469706673582212200e40c54371c44c19d4e6360267a8161e16e3115ae651f833166134fae0db490064736f6c63430008190033",
                "nonce": "0xe5cd4c3b",
                "r": "0xceba0a5592589bbaeca5395655cde4fd2390c834f5c10787fe7132d7a7f8fe38",
                "s": "0x4941e5a1a27b089777e1514f0eeb804317f7ff25b9c02ad751c43655c90c76ca",
                "to": null,
                "transactionIndex": "0x0",
                "type": "0x0",
                "v": "0x0",
                "value": "0x0"
            }
        ],
        "transactionsRoot": "0xa36db15385464a13e5998a2872087f0ef7bd18ce96656f9bce40f140727d3ae0",
        "uncles": []
    }
}

[kyonRay]

After my researching, this PR is perfect match to my request. And it is easy to change DB schema in Docker Deployment Mode, blockscout nice work!

#4712