129 lines
2.7 KiB
SQL
129 lines
2.7 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,
|
|
fee0 INTEGER,
|
|
fee1 INTEGER,
|
|
fee2 INTEGER,
|
|
fee3 INTEGER,
|
|
fee4 INTEGER,
|
|
fee5 INTEGER,
|
|
fee6 INTEGER,
|
|
fee7 INTEGER,
|
|
fee8 INTEGER,
|
|
fee9 INTEGER,
|
|
fee10 INTEGER,
|
|
fee11 INTEGER,
|
|
fee12 INTEGER,
|
|
fee13 INTEGER,
|
|
fee14 INTEGER,
|
|
fee15 INTEGER,
|
|
fee16 INTEGER,
|
|
fee17 INTEGER,
|
|
fee18 INTEGER,
|
|
fee19 INTEGER,
|
|
fee20 INTEGER,
|
|
fee21 INTEGER,
|
|
fee22 INTEGER,
|
|
fee23 INTEGER,
|
|
fee24 INTEGER,
|
|
fee25 INTEGER,
|
|
fee26 INTEGER,
|
|
fee27 INTEGER,
|
|
fee28 INTEGER,
|
|
fee29 INTEGER,
|
|
fee30 INTEGER,
|
|
fee31 INTEGER,
|
|
fee32 INTEGER,
|
|
fee33 INTEGER,
|
|
fee34 INTEGER,
|
|
fee35 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,
|
|
cnt26, cnt27, cnt28, cnt29, cnt30, cnt31, cnt32, cnt33, cnt34, cnt35,
|
|
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,
|
|
size26, size27, size28, size29, size30, size31, size32, size33, size34, size35,
|
|
fee0)
|
|
SELECT * from oldmempool;
|
|
DROP TABLE oldmempool;
|
|
COMMIT;
|