Inconsisted unconfirmed state in memory tables #1

[4miners]

When we have unconfirmed transactions of some type (for example VOTE) waiting in transaction pool and restart node - those transactions will be cleared from transaction pool, but their unconfirmed state will stay. That prevents to resend transaction (because it will not pass unconfirmed checks) and can cause other issues.

Solution:
We should reset unconfirmed tables to confirmed state on node start, query:

BEGIN;

DELETE FROM mem_accounts2u_delegates;
INSERT INTO mem_accounts2u_delegates ("accountId", "dependentId") SELECT "accountId", "dependentId" FROM mem_accounts2delegates;

DELETE FROM mem_accounts2u_multisignatures;
INSERT INTO mem_accounts2u_multisignatures ("accountId", "dependentId") SELECT "accountId", "dependentId" FROM mem_accounts2multisignatures;

COMMIT;