altertable.sql

BEGIN TRANSACTION;
ALTER TABLE mempool RENAME to oldmempool;

CREATE TABLE mempool (
    time INTEGER NOT NULL,
    cnt0 INTEGER,
    cnt1 INTEGER,
    cnt2 INTEGER,
    cnt3 INTEGER,
    cnt4 INTEGER,
    cnt5 INTEGER,
    cnt6 INTEGER,
    cnt7 INTEGER,
    cnt8 INTEGER,
    cnt9 INTEGER,
    cnt10 INTEGER,
    cnt11 INTEGER,
    cnt12 INTEGER,
    cnt13 INTEGER,
    cnt14 INTEGER,
    cnt15 INTEGER,
    cnt16 INTEGER,
    cnt17 INTEGER,
    cnt18 INTEGER,
    cnt19 INTEGER,
    cnt20 INTEGER,
    cnt21 INTEGER,
    cnt22 INTEGER,
    cnt23 INTEGER,
    cnt24 INTEGER,
    cnt25 INTEGER,
    cnt26 INTEGER,
    cnt27 INTEGER,
    cnt28 INTEGER,
    cnt29 INTEGER,
    cnt30 INTEGER,
    cnt31 INTEGER,
    cnt32 INTEGER,
    cnt33 INTEGER,
    cnt34 INTEGER,
    cnt35 INTEGER,
    size0 INTEGER,
    size1 INTEGER,
    size2 INTEGER,
    size3 INTEGER,
    size4 INTEGER,
    size5 INTEGER,
    size6 INTEGER,
    size7 INTEGER,
    size8 INTEGER,
    size9 INTEGER,
    size10 INTEGER,
    size11 INTEGER,
    size12 INTEGER,
    size13 INTEGER,
    size14 INTEGER,
    size15 INTEGER,
    size16 INTEGER,
    size17 INTEGER,
    size18 INTEGER,
    size19 INTEGER,
    size20 INTEGER,
    size21 INTEGER,
    size22 INTEGER,
    size23 INTEGER,
    size24 INTEGER,
    size25 INTEGER,
    size26 INTEGER,
    size27 INTEGER,
    size28 INTEGER,
    size29 INTEGER,
    size30 INTEGER,
    size31 INTEGER,
    size32 INTEGER,
    size33 INTEGER,
    size34 INTEGER,
    size35 INTEGER,
    fee INTEGER
);

INSERT INTO mempool (time,
   cnt0, cnt1, cnt2, cnt3, cnt4, cnt5, cnt6, cnt7, cnt8, cnt9,
   cnt10, cnt11, cnt12, cnt13, cnt14, cnt15, cnt16, cnt17, cnt18, cnt19,
   cnt20, cnt21, cnt22, cnt23, cnt24, cnt25,
   size0, size1, size2, size3, size4, size5, size6, size7, size8, size9,
   size10, size11, size12, size13, size14, size15, size16, size17, size18, size19,
   size20, size21, size22, size23, size24, size25,
   fee)
  SELECT * from oldmempool;
DROP TABLE oldmempool;
COMMIT;