92 lines
2.0 KiB
SQL
92 lines
2.0 KiB
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;
|