text: -- PRAGMA page_size=1024;
  -- PRAGMA encoding='UTF-8';
  -- PRAGMA auto_vacuum=NONE;
  -- PRAGMA max_page_count=1073741823;
  
  BEGIN TRANSACTION;
  
  -- Table  addresses
  DROP TABLE IF EXISTS addresses;
  CREATE TABLE addresses(
                        address TEXT UNIQUE,
                        options INTEGER,
                        block_index INTEGER);
  -- Triggers and indices on  addresses
  CREATE TRIGGER _addresses_delete BEFORE DELETE ON addresses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO addresses(rowid,address,options,block_index) VALUES('||old.rowid||','||quote(old.address)||','||quote(old.options)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _addresses_insert AFTER INSERT ON addresses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM addresses WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _addresses_update AFTER UPDATE ON addresses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE addresses SET address='||quote(old.address)||',options='||quote(old.options)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX addresses_idx ON addresses (address);
  
  -- Table  assets
  DROP TABLE IF EXISTS assets;
  CREATE TABLE assets(
                        asset_id TEXT UNIQUE,
                        asset_name TEXT UNIQUE,
                        block_index INTEGER,
                        asset_longname TEXT);
  INSERT INTO assets VALUES('0','UNO',NULL,NULL);
  INSERT INTO assets VALUES('1','XUP',NULL,NULL);
  INSERT INTO assets VALUES('18279','BBBB',310005,NULL);
  INSERT INTO assets VALUES('18280','BBBC',310006,NULL);
  -- Triggers and indices on  assets
  CREATE TRIGGER _assets_delete BEFORE DELETE ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO assets(rowid,asset_id,asset_name,block_index,asset_longname) VALUES('||old.rowid||','||quote(old.asset_id)||','||quote(old.asset_name)||','||quote(old.block_index)||','||quote(old.asset_longname)||')');
                              END;
  CREATE TRIGGER _assets_insert AFTER INSERT ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM assets WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _assets_update AFTER UPDATE ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE assets SET asset_id='||quote(old.asset_id)||',asset_name='||quote(old.asset_name)||',block_index='||quote(old.block_index)||',asset_longname='||quote(old.asset_longname)||' WHERE rowid='||old.rowid);
                              END;
  CREATE UNIQUE INDEX asset_longname_idx ON assets(asset_longname);
  CREATE INDEX id_idx ON assets (asset_id);
  CREATE INDEX name_idx ON assets (asset_name);
  
  -- Table  balances
  DROP TABLE IF EXISTS balances;
  CREATE TABLE balances(
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER);
  INSERT INTO balances VALUES('2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',149849426438);
  INSERT INTO balances VALUES('2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50420824);
  INSERT INTO balances VALUES('2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',996000000);
  INSERT INTO balances VALUES('2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',89474);
  INSERT INTO balances VALUES('2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000);
  INSERT INTO balances VALUES('2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10526);
  -- Triggers and indices on  balances
  CREATE TRIGGER _balances_delete BEFORE DELETE ON balances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO balances(rowid,address,asset,quantity) VALUES('||old.rowid||','||quote(old.address)||','||quote(old.asset)||','||quote(old.quantity)||')');
                              END;
  CREATE TRIGGER _balances_insert AFTER INSERT ON balances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM balances WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _balances_update AFTER UPDATE ON balances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE balances SET address='||quote(old.address)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX address_asset_idx ON balances (address, asset);
  
  -- Table  bet_expirations
  DROP TABLE IF EXISTS bet_expirations;
  CREATE TABLE bet_expirations(
                        bet_index INTEGER PRIMARY KEY,
                        bet_hash TEXT UNIQUE,
                        source TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index),
                        FOREIGN KEY (bet_index, bet_hash) REFERENCES bets(tx_index, tx_hash));
  INSERT INTO bet_expirations VALUES(13,'44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310023);
  -- Triggers and indices on  bet_expirations
  CREATE TRIGGER _bet_expirations_delete BEFORE DELETE ON bet_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO bet_expirations(rowid,bet_index,bet_hash,source,block_index) VALUES('||old.rowid||','||quote(old.bet_index)||','||quote(old.bet_hash)||','||quote(old.source)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _bet_expirations_insert AFTER INSERT ON bet_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM bet_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _bet_expirations_update AFTER UPDATE ON bet_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE bet_expirations SET bet_index='||quote(old.bet_index)||',bet_hash='||quote(old.bet_hash)||',source='||quote(old.source)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  bet_match_expirations
  DROP TABLE IF EXISTS bet_match_expirations;
  CREATE TABLE bet_match_expirations(
                        bet_match_id TEXT PRIMARY KEY,
                        tx0_address TEXT,
                        tx1_address TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (bet_match_id) REFERENCES bet_matches(id),
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  -- Triggers and indices on  bet_match_expirations
  CREATE TRIGGER _bet_match_expirations_delete BEFORE DELETE ON bet_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO bet_match_expirations(rowid,bet_match_id,tx0_address,tx1_address,block_index) VALUES('||old.rowid||','||quote(old.bet_match_id)||','||quote(old.tx0_address)||','||quote(old.tx1_address)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _bet_match_expirations_insert AFTER INSERT ON bet_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM bet_match_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _bet_match_expirations_update AFTER UPDATE ON bet_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE bet_match_expirations SET bet_match_id='||quote(old.bet_match_id)||',tx0_address='||quote(old.tx0_address)||',tx1_address='||quote(old.tx1_address)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  bet_match_resolutions
  DROP TABLE IF EXISTS bet_match_resolutions;
  CREATE TABLE bet_match_resolutions(
                        bet_match_id TEXT PRIMARY KEY,
                        bet_match_type_id INTEGER,
                        block_index INTEGER,
                        winner TEXT,
                        settled BOOL,
                        bull_credit INTEGER,
                        bear_credit INTEGER,
                        escrow_less_fee INTEGER,
                        fee INTEGER,
                        FOREIGN KEY (bet_match_id) REFERENCES bet_matches(id),
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  INSERT INTO bet_match_resolutions VALUES('44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12',1,310018,'0',0,59137500,NULL,NULL,3112500);
  INSERT INTO bet_match_resolutions VALUES('3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572',1,310019,'1',159300000,315700000,NULL,NULL,25000000);
  INSERT INTO bet_match_resolutions VALUES('674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9',5,310020,NULL,NULL,NULL,'NotEqual',1330000000,70000000);
  -- Triggers and indices on  bet_match_resolutions
  CREATE TRIGGER _bet_match_resolutions_delete BEFORE DELETE ON bet_match_resolutions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO bet_match_resolutions(rowid,bet_match_id,bet_match_type_id,block_index,winner,settled,bull_credit,bear_credit,escrow_less_fee,fee) VALUES('||old.rowid||','||quote(old.bet_match_id)||','||quote(old.bet_match_type_id)||','||quote(old.block_index)||','||quote(old.winner)||','||quote(old.settled)||','||quote(old.bull_credit)||','||quote(old.bear_credit)||','||quote(old.escrow_less_fee)||','||quote(old.fee)||')');
                              END;
  CREATE TRIGGER _bet_match_resolutions_insert AFTER INSERT ON bet_match_resolutions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM bet_match_resolutions WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _bet_match_resolutions_update AFTER UPDATE ON bet_match_resolutions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE bet_match_resolutions SET bet_match_id='||quote(old.bet_match_id)||',bet_match_type_id='||quote(old.bet_match_type_id)||',block_index='||quote(old.block_index)||',winner='||quote(old.winner)||',settled='||quote(old.settled)||',bull_credit='||quote(old.bull_credit)||',bear_credit='||quote(old.bear_credit)||',escrow_less_fee='||quote(old.escrow_less_fee)||',fee='||quote(old.fee)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  bet_matches
  DROP TABLE IF EXISTS bet_matches;
  CREATE TABLE bet_matches(
                        id TEXT PRIMARY KEY,
                        tx0_index INTEGER,
                        tx0_hash TEXT,
                        tx0_address TEXT,
                        tx1_index INTEGER,
                        tx1_hash TEXT,
                        tx1_address TEXT,
                        tx0_bet_type INTEGER,
                        tx1_bet_type INTEGER,
                        feed_address TEXT,
                        initial_value INTEGER,
                        deadline INTEGER,
                        target_value REAL,
                        leverage INTEGER,
                        forward_quantity INTEGER,
                        backward_quantity INTEGER,
                        tx0_block_index INTEGER,
                        tx1_block_index INTEGER,
                        block_index INTEGER,
                        tx0_expiration INTEGER,
                        tx1_expiration INTEGER,
                        match_expire_index INTEGER,
                        fee_fraction_int INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx0_index, tx0_hash, tx0_block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        FOREIGN KEY (tx1_index, tx1_hash, tx1_block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO bet_matches VALUES('44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12',13,'44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',14,'08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',100,1388000100,0.0,15120,41500000,20750000,310012,310013,310013,10,10,310022,99999999,'settled: liquidated for bear');
  INSERT INTO bet_matches VALUES('3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572',15,'3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',16,'75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',100,1388000100,0.0,5040,150000000,350000000,310014,310015,310015,10,10,310024,99999999,'settled');
  INSERT INTO bet_matches VALUES('674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9',17,'674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',18,'4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',2,3,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',100,1388000200,1.0,5040,750000000,650000000,310016,310017,310017,10,10,310026,99999999,'settled: for notequal');
  -- Triggers and indices on  bet_matches
  CREATE TRIGGER _bet_matches_delete BEFORE DELETE ON bet_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO bet_matches(rowid,id,tx0_index,tx0_hash,tx0_address,tx1_index,tx1_hash,tx1_address,tx0_bet_type,tx1_bet_type,feed_address,initial_value,deadline,target_value,leverage,forward_quantity,backward_quantity,tx0_block_index,tx1_block_index,block_index,tx0_expiration,tx1_expiration,match_expire_index,fee_fraction_int,status) VALUES('||old.rowid||','||quote(old.id)||','||quote(old.tx0_index)||','||quote(old.tx0_hash)||','||quote(old.tx0_address)||','||quote(old.tx1_index)||','||quote(old.tx1_hash)||','||quote(old.tx1_address)||','||quote(old.tx0_bet_type)||','||quote(old.tx1_bet_type)||','||quote(old.feed_address)||','||quote(old.initial_value)||','||quote(old.deadline)||','||quote(old.target_value)||','||quote(old.leverage)||','||quote(old.forward_quantity)||','||quote(old.backward_quantity)||','||quote(old.tx0_block_index)||','||quote(old.tx1_block_index)||','||quote(old.block_index)||','||quote(old.tx0_expiration)||','||quote(old.tx1_expiration)||','||quote(old.match_expire_index)||','||quote(old.fee_fraction_int)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _bet_matches_insert AFTER INSERT ON bet_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM bet_matches WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _bet_matches_update AFTER UPDATE ON bet_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE bet_matches SET id='||quote(old.id)||',tx0_index='||quote(old.tx0_index)||',tx0_hash='||quote(old.tx0_hash)||',tx0_address='||quote(old.tx0_address)||',tx1_index='||quote(old.tx1_index)||',tx1_hash='||quote(old.tx1_hash)||',tx1_address='||quote(old.tx1_address)||',tx0_bet_type='||quote(old.tx0_bet_type)||',tx1_bet_type='||quote(old.tx1_bet_type)||',feed_address='||quote(old.feed_address)||',initial_value='||quote(old.initial_value)||',deadline='||quote(old.deadline)||',target_value='||quote(old.target_value)||',leverage='||quote(old.leverage)||',forward_quantity='||quote(old.forward_quantity)||',backward_quantity='||quote(old.backward_quantity)||',tx0_block_index='||quote(old.tx0_block_index)||',tx1_block_index='||quote(old.tx1_block_index)||',block_index='||quote(old.block_index)||',tx0_expiration='||quote(old.tx0_expiration)||',tx1_expiration='||quote(old.tx1_expiration)||',match_expire_index='||quote(old.match_expire_index)||',fee_fraction_int='||quote(old.fee_fraction_int)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX valid_feed_idx ON bet_matches (feed_address, status);
  
  -- Table  bets
  DROP TABLE IF EXISTS bets;
  CREATE TABLE bets(
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        feed_address TEXT,
                        bet_type INTEGER,
                        deadline INTEGER,
                        wager_quantity INTEGER,
                        wager_remaining INTEGER,
                        counterwager_quantity INTEGER,
                        counterwager_remaining INTEGER,
                        target_value REAL,
                        leverage INTEGER,
                        expiration INTEGER,
                        expire_index INTEGER,
                        fee_fraction_int INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        PRIMARY KEY (tx_index, tx_hash));
  INSERT INTO bets VALUES(13,'44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b',310012,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1388000100,50000000,8500000,25000000,4250000,0.0,15120,10,310022,99999999,'expired');
  INSERT INTO bets VALUES(14,'08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12',310013,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1,1388000100,25000000,4250000,41500000,0,0.0,15120,10,310023,99999999,'filled');
  INSERT INTO bets VALUES(15,'3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68',310014,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1388000100,150000000,0,350000000,0,0.0,5040,10,310024,99999999,'filled');
  INSERT INTO bets VALUES(16,'75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572',310015,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1,1388000100,350000000,0,150000000,0,0.0,5040,10,310025,99999999,'filled');
  INSERT INTO bets VALUES(17,'674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644',310016,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',2,1388000200,750000000,0,650000000,0,1.0,5040,10,310026,99999999,'filled');
  INSERT INTO bets VALUES(18,'4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9',310017,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',3,1388000200,650000000,0,750000000,0,1.0,5040,10,310027,99999999,'filled');
  -- Triggers and indices on  bets
  CREATE TRIGGER _bets_delete BEFORE DELETE ON bets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO bets(rowid,tx_index,tx_hash,block_index,source,feed_address,bet_type,deadline,wager_quantity,wager_remaining,counterwager_quantity,counterwager_remaining,target_value,leverage,expiration,expire_index,fee_fraction_int,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.feed_address)||','||quote(old.bet_type)||','||quote(old.deadline)||','||quote(old.wager_quantity)||','||quote(old.wager_remaining)||','||quote(old.counterwager_quantity)||','||quote(old.counterwager_remaining)||','||quote(old.target_value)||','||quote(old.leverage)||','||quote(old.expiration)||','||quote(old.expire_index)||','||quote(old.fee_fraction_int)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _bets_insert AFTER INSERT ON bets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM bets WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _bets_update AFTER UPDATE ON bets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE bets SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',feed_address='||quote(old.feed_address)||',bet_type='||quote(old.bet_type)||',deadline='||quote(old.deadline)||',wager_quantity='||quote(old.wager_quantity)||',wager_remaining='||quote(old.wager_remaining)||',counterwager_quantity='||quote(old.counterwager_quantity)||',counterwager_remaining='||quote(old.counterwager_remaining)||',target_value='||quote(old.target_value)||',leverage='||quote(old.leverage)||',expiration='||quote(old.expiration)||',expire_index='||quote(old.expire_index)||',fee_fraction_int='||quote(old.fee_fraction_int)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX feed_valid_bettype_idx ON bets (feed_address, status, bet_type);
  
  -- Table  blocks
  DROP TABLE IF EXISTS blocks;
  CREATE TABLE blocks(
                        block_index INTEGER UNIQUE,
                        block_hash TEXT UNIQUE,
                        block_time INTEGER,
                        previous_block_hash TEXT UNIQUE,
                        difficulty INTEGER, ledger_hash TEXT, txlist_hash TEXT, messages_hash TEXT,
                        PRIMARY KEY (block_index, block_hash));
  INSERT INTO blocks VALUES(309999,'8b3bef249cb3b0fa23a4936c1249b6bd41daeadc848c8d2e409ea1cbc10adfe7',309999000,NULL,NULL,'63f0fef31d02da85fa779e9a0e1b585b1a6a4e59e14564249e288e074e91c223','63f0fef31d02da85fa779e9a0e1b585b1a6a4e59e14564249e288e074e91c223','63f0fef31d02da85fa779e9a0e1b585b1a6a4e59e14564249e288e074e91c223');
  INSERT INTO blocks VALUES(310000,'505d8d82c4ced7daddef7ed0b05ba12ecc664176887b938ef56c6af276f3b30c',310000000,NULL,NULL,'a16ae7423db132c887ae41cc33b7fa48a0cc6571d5a49e0963be25ec8a9769b4','b8fb4fb649dd315851564165b076d636e5a85e043d59c11877bdccced38f1b3e','29e22217189ee2195a2889917cb7e650739d075d153652d3ce2cb57aa583746a');
  INSERT INTO blocks VALUES(310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,NULL,NULL,'0cda5c4a26f0b23d5b948142dcd226b2718c57c9c6a481250128a7a1c8ad30dc','3d8351ee76ca6095a663ac6f73ca9c69f583a423bf6ee7e80f3cf3a5fa7686e3','d2348511a51eab4e6998e0f8fdbd3320c93a33c628ca1449d3a90b62e4f6490a');
  INSERT INTO blocks VALUES(310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,NULL,NULL,'657c31576766cf1f8a699a14e6c7493498673f1948bea1be4f639247f4d52d53','57ad70e6408a9ef5998f087cc78ef0b92e55350a6abe943e1b8c81cfd23ea99d','63db0136dc6e23546656f1c9343430fe0451686c85d574564046f2aba8f682bc');
  INSERT INTO blocks VALUES(310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,NULL,NULL,'e11e7eeb21ff539c27324c94a407dc6f04c739f3ed9841f9f661bf4441e4d847','e9f393c9e75962af59b7d467cd99c4120fefda5274101b7c940c607a505ff656','f32bfed6fe1015cae4993ed7cc62c314264cc03f6e68339a97ad8f640e51fd5c');
  INSERT INTO blocks VALUES(310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,NULL,NULL,'2742a3e99eed62c09d9ecdaf501aa69b0d0b21fc092ca061448d5016957f35e0','5f65a652c524e543dad0e4f28628c3a517f2b0bcdd94b8e56c612299cf1c694f','8a857d90a208b911c6acda7ace837421a75fa65db54dba33145c9602720d398a');
  INSERT INTO blocks VALUES(310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,NULL,NULL,'49f526a56f21491c797e8e2559f722ded6f6990b1f69c55dc38791d8d30f4048','e102530532364d1fdb89a1ed3a57ee4140a667c5f5609b662d0a7180e6c491d2','5d2a01d92ece91f3cc63a0f7ca62dd02d8414eb252cc5dcdf1400a6e51d2b521');
  INSERT INTO blocks VALUES(310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,NULL,NULL,'78787c4c9537fc4db5d1dc7d31d4fab6b445d57021aab1a38d4bd6a9404713c5','804e0b50957b0c3c6fd068fd725cf11a089f46642a7560b0ea0373a9fbfd0c06','7e5c5b83cd0a4cfce12c1c7f56621489c9b2f33cdab706ee7d2a23e19bc16dd4');
  INSERT INTO blocks VALUES(310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,NULL,NULL,'5cc2599b63007433426c220c59a777b5c37b1165595f2ba239c3ce578c8055ab','df02aff4e5f00749cd828b4d9b1c915f5d462cfd32ef8689c31b369e2926d793','8feb75ff7563b01378d4214c07d88a6ae8575b25be2ca933c80366a7abb9765e');
  INSERT INTO blocks VALUES(310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,NULL,NULL,'9550db622e679ff3d63d814f9ffa743d57eb12491b213ef6474617a6c738c3fa','a67e4a72d7031c18318fc90e46c9918fc1d1aec3118155e991e34974d25809fb','033289b29d1433aa08cd7f5839304035f83fdea70b4b3f988af21cabd464630f');
  INSERT INTO blocks VALUES(310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,NULL,NULL,'08c005dd5bae7f21ca27803d75318ac4b968c6d4dd2c275ef284c03fea43b189','bbc31edaec3cab0582059cb42360c2f4643b2d17ba5582d6c094eec270477298','712f9c6f1ced53ad55706d12b9c8ad26366d1c95fc888c1350309fb646c5914e');
  INSERT INTO blocks VALUES(310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,NULL,NULL,'07f48634d06e6be1d800e068cd213a648517fe167ed89c355d9db966897ed7b0','9d7ba3c2711c68fcde94bb80676c0cedc1041445a3716a189e56f16246dd9241','2a0b2b021ecdda9cfa1facef22780a51a351753c78f7b1606f6a33c40a114d03');
  INSERT INTO blocks VALUES(310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,NULL,NULL,'8d0be0b3731bdd0d611e81b48efa6c706a983990f31bc563d57893f705b73aa7','2bbbfdb0bc4f2d2581c2f9c1349127d545d0c137b94223ed9ca9985e9eec6ba8','e190c68a08b85415071ebd7be5a5f552e5c658620c3bf492cc7174c0eb55a704');
  INSERT INTO blocks VALUES(310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,NULL,NULL,'e3de05180536ad40eb9007f19ccb819fee0586cb9e7c414dc560e506ae5c09b7','10c0af7d079a3247f17ea074f1e26db5e6f144a7ae8cc7775cf7acf075835dc7','c8e6a98f974fab801b45ec51cc8f077efa95f56f16bffbe2c144563a61648bc8');
  INSERT INTO blocks VALUES(310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,NULL,NULL,'e521556db091cc726fb38cbebfd10923e37dab652c51dca73a646fe5bd81bb96','317de66d42acf21c650ff0ba03552d53b36b618044b5f0581beabffdf053de98','42825b93aeed6be04e7097bd66125820c373f7603042ef3f3a21eae80ecdede4');
  INSERT INTO blocks VALUES(310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,NULL,NULL,'1cd6d92fbbca9266135a35f20a4328d510c8d209ba6161dc8c9e9bfa69032c57','b4d87c4fa900e051f0f77cac88d6736e16b1708dbfb84dec208b8586aa2ab00c','ae9feaad125b7aaaa86eea2919c629be12a4d2c776647081be35bf62f4bbbc30');
  INSERT INTO blocks VALUES(310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,NULL,NULL,'62759ea6d5070225bd30253a42b6c68fdaf2c4165b1b221b8e7bdddeb26e9737','27708efefad6f050e1b29dbf0c70a215cc97dad38753475449b1ba29ad6bfe7d','94ffe5415587dbe3253009dbb86fb5e7c3cc4016c3f9476f84a5b9c9e9873ccd');
  INSERT INTO blocks VALUES(310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,NULL,NULL,'f9fc0dd4d98ac5e06e4f9673cf5678f9fc264cda23172e24427b833331b73c33','cde400342c4b54aba15e9f7158e2efa3cbcc5d34d486e8f1d5f9ca5eb5cdb90f','28dfe3cb0c3d1969983e23c9d8d5301ca643a0462eff664f106034b320159002');
  INSERT INTO blocks VALUES(310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,NULL,NULL,'4a355b8e80a902030f384f58700d05da9a6efaae3f3ce0b1a056dc1250d9ec63','802dd7efdcd53c30cb0400ecdedc3f11530c4fd0c67239863ee31ef318217538','ab1e11e333c78d11d317cc1efc56384582587fa7a94707e3c9b7f2e421f62e83');
  INSERT INTO blocks VALUES(310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,NULL,NULL,'57aee8f9c9b63342ceeea3a3162998e9034a3d624d6d85b19782943ce170cef5','8825b355f948cbd408f237051b136a65ca8bc9c9eea96e5e5b96079f8fe68238','a38c893c8f1e67785a59174e91092b5d80a80abc08221f5329ac740fa1ff93d3');
  INSERT INTO blocks VALUES(310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,NULL,NULL,'d11f94528a9e0034365e4388ee455f02102d2024c65e1428cdee28b6e5aa7e1c','751c0e335abecfa25b8f3a8d5a92b8fbf030503fda632e2a1a8c56188699ebed','445292488d3abd5af6136c4e494e37068ab2b0cfd20af8a92f220acc158d4503');
  INSERT INTO blocks VALUES(310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,NULL,NULL,'4397f5568bfcf8cc90d1e72b7c61e7cc6905a0d9d3b3890c33e2afb464a25fb9','1f5ea74c90fccfd8d57c9d0d69e6120e9d834dc4bd7bf3055f1824d7b3023a1c','7b32e229ce7092b4bb8ef4f2081ff4f7309bdb39a89b052d921703d39544fce2');
  INSERT INTO blocks VALUES(310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,NULL,NULL,'16b7018344f7a97695eb17dc5921c4955b3f8cf4d9e70bd8628041c4033886b9','ff40fa96d3cf20f2b2ff3cfd9917d30f774c146d7f32c3e21caf17fd7310ceac','f5c4a01265af08d6d046f9fbacf3f3ea91ea36fff9300d489e2cd58d1effd497');
  INSERT INTO blocks VALUES(310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,NULL,NULL,'c3c26212677f4aed4614b653f1e5da509f962c29502d22c84c1c5522bca0dcf5','a679ec429c049a6a49d2f8723a4670fd571a60ca9857c5e95d1ce13094620d5d','72f64c8df3c10ab1dca5d7a60b10e2c25639a863c89eede9835159702997b145');
  INSERT INTO blocks VALUES(310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,NULL,NULL,'420b753d9e2a4ae5c00cf65efccb9a657d2daeb19159075d1671a076d8c1ade1','f0f05f6873612f7db442f9d4e91c1960f54748a96e5d55f10c32eb3862d9da13','fd1c358668bd56b1eacbd28884cbf04ecfe564877483b5bb7c7aafd2e4bf047a');
  INSERT INTO blocks VALUES(310024,'b03042b4e18a222b4c8d1e9e1970d93e6e2a2d41686d227ff8ecf0a839223dc5',310024000,NULL,NULL,'786e9c043df5025bb8d123322e2dd9cba30cc433ff90a44b7b7036369565835b','152764518b05cfddf93f2406a4ec705e05655318e7700d3835d22074a60e1382','c8f8ee885bd7ed9c381aab961a1670bad4cdb0f144340354a39ce6ffeee459b6');
  INSERT INTO blocks VALUES(310025,'a872e560766832cc3b4f7f222228cb6db882ce3c54f6459f62c71d5cd6e90666',310025000,NULL,NULL,'1a2e0585eb1a7f608b4ca4b1d252f555f87e7f16fff124ed869285ec17643059','df89eee2900dad7b067b77f083995f0310d5823831d42cec93de0ac50207e682','598efab2674de1b356a8049b578478ed3f4ebf19e665c1d37d6d6267a380a114');
  INSERT INTO blocks VALUES(310026,'6c96350f6f2f05810f19a689de235eff975338587194a36a70dfd0fcd490941a',310026000,NULL,NULL,'44a1f10e2df25328c38e20c36029bff557c7a93784030ece591406df9c71ebd6','aa02a74098170bbb8739cfef0e3173fbe1b6c8c39ea03789d86006648391b169','a3545c7418cf07c97d68a94df56d8ab7db2fcda48bd20be96803e7daebc8d869');
  INSERT INTO blocks VALUES(310027,'d7acfac66df393c4482a14c189742c0571b89442eb7f817b34415a560445699e',310027000,NULL,NULL,'093f82c2b8e108242edc6dad72e5878700b9c33606c359e673bdfe65341db64a','62ca643090c76fa01ce6cf44b21e2addd859383083d39736f64b1b9e87ebdb37','b9ebc76db14ac6b57d30b6213fd7c04dcb4f39adffee5bb962aa9d79b9880ea7');
  INSERT INTO blocks VALUES(310028,'02409fcf8fa06dafcb7f11e38593181d9c42cc9d5e2ddc304d098f990bd9530b',310028000,NULL,NULL,'efac93e04f7cd9d3b1c0af3da102c29b50d940b4b5687fb0061b3b6e169290f6','4588c39fcc3d792c828a1ebe9b960ba26ceafbcb76dfe9ba8477124c9a64bace','0e2c1fb076452ac431ff36673f1ce35857de858a471a5dd96096722c8233d925');
  INSERT INTO blocks VALUES(310029,'3c739fa8b40c118d5547ea356ee8d10ee2898871907643ec02e5db9d00f03cc6',310029000,NULL,NULL,'1fa464e853787685a588de6dab287456de7a0efdcd76052a41ddaf5e2f85a648','b277558ad6ba95eaacd5429df1b8c574442fae5611bef798a6e379398e80f896','51b3a809bf3f091e8e647b8d3ec00d782a661f70351384ade7508b3f05c067c2');
  INSERT INTO blocks VALUES(310030,'d5071cddedf89765ee0fd58f209c1c7d669ba8ea66200a57587da8b189b9e4f5',310030000,NULL,NULL,'fee866f1cf6e5f83010b97e0e9d88b54ce43fdf45e89081ba3b2fe07b62434fc','da97716c3fe85623b897b40969a060408ed1b0baf43b94b57f8f1f60cc60a21e','29492868ddcaf0e1426bfc96fdcf3ff226786c44484b3db46c1aa2610737ad24');
  INSERT INTO blocks VALUES(310031,'0b02b10f41380fff27c543ea8891ecb845bf7a003ac5c87e15932aff3bfcf689',310031000,NULL,NULL,'11ed526c46610698e7a4f102ae91755a541d668750ec3bc10decd0c1709d1115','b33308238932a5e990eec65d68b9c85e000e8b415fdf9ac854341fda985777e6','ed7a7aab9ae15ae2574bf122732c6ecbee0a3d1273c4ba6f56505112d9bd406d');
  INSERT INTO blocks VALUES(310032,'66346be81e6ba04544f2ae643b76c2b7b1383f038fc2636e02e49dc7ec144074',310032000,NULL,NULL,'7930e5a2c6150df64dfd995801aec68ce11df292e206f08f7ff20eda9ca2d017','ceff744404eb4e264ed87bc5a0383a74b106abf58d93f5a241d905a2511d31b6','82cc1e421150eaa06c41c052139b1c27c745227ff0939742049cb49b940e1229');
  INSERT INTO blocks VALUES(310033,'999c65df9661f73e8c01f1da1afda09ac16788b72834f0ff5ea3d1464afb4707',310033000,NULL,NULL,'c5834a54b3ad7f9fdbb18a87c8cefe867eff2ba1ae5bff238a3a041431d0afdd','04ca39b1e5bae08454823abf193fa8b6a7f340c65f0f2227117bd9a06053d37b','0b9411bd364363edb2fd25df4c9e5e1ac53062ef6ff783b9960c8a662270cd15');
  INSERT INTO blocks VALUES(310034,'f552edd2e0a648230f3668e72ddf0ddfb1e8ac0f4c190f91b89c1a8c2e357208',310034000,NULL,NULL,'5a4b3f29cb1554ae8f670955df4dde45fdcc57623a50ca7d8f2c78ad79186a7a','fb0303408499c6c350fdecbb8170993dda6394a35e5744b80d3cbadf5373bcc6','fe5c12e08dbf6e1b45400970b99d017f25b31916ca72830e5801dcfc71a77987');
  INSERT INTO blocks VALUES(310035,'a13cbb016f3044207a46967a4ba1c87dab411f78c55c1179f2336653c2726ae2',310035000,NULL,NULL,'b81834ed9e92514fe7d277378be72e1f81043a615a4b67cb67dbcf97e3c3b43e','04f5d7c6f22e175de424d8dd0ec8e7ba0be83829de699c7ab34dbe7c8907c74c','94c1261ef38a623e940f67c763723dd30410a292d808317119c6aa8e4a54dbde');
  INSERT INTO blocks VALUES(310036,'158648a98f1e1bd1875584ce8449eb15a4e91a99a923bbb24c4210135cef0c76',310036000,NULL,NULL,'736adff04611f10a4e384b5d5c44651bdf037c0caeb8dda5bedbbc6d18d04ca2','1838c4dde6271683953d8c28f345cf857438a549796ace10dcd95ff577f4c76c','6fb4e02810201d385388433e534a6d3eb147d085ced4f1d82b3c207b1b2b6d9e');
  INSERT INTO blocks VALUES(310037,'563acfd6d991ce256d5655de2e9429975c8dceeb221e76d5ec6e9e24a2c27c07',310037000,NULL,NULL,'34d49fb14a7ec85ebd02ffe04768f5aa7382ed0ac7f9ae903e71567dc5d9ab67','9712dab4f78c6514fff6ffe8dfd012f50d7e85bb30bd7b6078e235e3766e5c23','29ff27c1d66f7c4a531af18ff8b97c24cec9f7f0c1012a138369575523ee227c');
  INSERT INTO blocks VALUES(310038,'b44b4cad12431c32df27940e18d51f63897c7472b70950d18454edfd640490b2',310038000,NULL,NULL,'9bfc3bf0ed35dd256f0df04c813dab9dd818238163e6b01842e18815971e7010','155aa04c676193e731e66466265c7dc889c444eacfbd3067b10f2192bdcf0660','f5f9ef6481899446a83eee4a4aa6134898e62dd55b7aa3265473e0a1cdea7416');
  INSERT INTO blocks VALUES(310039,'5fa1ae9c5e8a599247458987b006ad3a57f686df1f7cc240bf119e911b56c347',310039000,NULL,NULL,'da7a63f22053d1713c805684d14695c31670eaf848bf23eee3331e679744f291','acd4e587e1ff4fe6f023793ed279f49528e3f6b3746ee116432f57f86d2141b0','ad6a4d39f86bdd4a66c77f757cf1030b9055416523fd3b82edffa84d9c40c294');
  INSERT INTO blocks VALUES(310040,'7200ded406675453eadddfbb2d14c2a4526c7dc2b5de14bd48b29243df5e1aa3',310040000,NULL,NULL,'ddb485115b64342bcb172cc3e77b20effb1294e635459119b59179f3b6a87d66','3166c77868258ffe4a298464a7de002338c1b9180bed2b7b6b92eb29b2db9da3','d4bec62ad76a556c82fafd354e2cff92cf20532381d17bfdc47224a0aa4405aa');
  INSERT INTO blocks VALUES(310041,'5db592ff9ba5fac1e030cf22d6c13b70d330ba397f415340086ee7357143b359',310041000,NULL,NULL,'b58d05ae5f282f7904c7a759ae5624194b5cb091f43f05d738cb4002a999c26d','165527c83164f81e549984af8397c31df040dedc3808d506b77568ac5d63af60','eccc50a840997546f4bbf2c5691be225f8b52ef8ed158912b11db162254b6d0c');
  INSERT INTO blocks VALUES(310042,'826fd4701ef2824e9559b069517cd3cb990aff6a4690830f78fc845ab77fa3e4',310042000,NULL,NULL,'c18e1989fccd8bc7168ebf2acc035c224a9010b428b81c814683b0ce1e244113','2634e5e0d4b869288cef4f132c69ef037754f9c847f58f2a43e9767da4714d97','dfac0e9e787e566deddd6cc834b173fec58ceb9ad85ed26b47005ffb5cfbf3a9');
  INSERT INTO blocks VALUES(310043,'2254a12ada208f1dd57bc17547ecaf3c44720323c47bc7d4b1262477cb7f3c51',310043000,NULL,NULL,'1a935492fce6a168d9aafd24246bba6f5615f53a47311549059b21adc6a67154','3faf8dc8d1460619bb9e74875550df14a19628ce7d3c0e466ac10e1acf79d785','ab543dfd963298b1879ccaba815112da073451304946c337e7c71baa9301d702');
  INSERT INTO blocks VALUES(310044,'3346d24118d8af0b3c6bcc42f8b85792e7a2e7036ebf6e4c25f4f6723c78e46b',310044000,NULL,NULL,'536611cb3cb3005f8c4ffc5b8ed8271734448b5d6f49bd47eb0456bc4ee207e4','1c216bb1260cc537636aba1dc0f97879abd10b54c1cfe2addaebb2855b89a886','72a71d7d05b574f26c90e2dc4d42adca678b541518010ae2f735b17b6f621503');
  INSERT INTO blocks VALUES(310045,'7bba0ab243839e91ad1a45a762bf074011f8a9883074d68203c6d1b46fffde98',310045000,NULL,NULL,'ebbeea29c073c61dad3e091302cd945a9926741db0dc6a918792c4c01b8cc30c','4a3ee7ecfef91572383c4a06f164cd4304e891cc5776867799fcc806c87ac6fc','021f5739c8a46280d5578fa6d76dab63bb521bafee792f04a4d8ed34fab43f62');
  INSERT INTO blocks VALUES(310046,'47db6788c38f2d6d712764979e41346b55e78cbb4969e0ef5c4336faf18993a6',310046000,NULL,NULL,'d9baff8bec82f3c29f1fa69c9ddd456f1867f33a55d1648605ea7109270d8e07','424998bde43db2db76959e12f2b2a18d92f3a18505b4ca43f6a6a21c59227950','b81aa5d4896d06e990244db2755b060f2ba431af73b4129bbdd3ffc54f15d4ce');
  INSERT INTO blocks VALUES(310047,'a9ccabcc2a098a7d25e4ab8bda7c4e66807eefa42e29890dcd88149a10de7075',310047000,NULL,NULL,'09ad4a6bb3f671e6ac6d595bcbfb82371cc41f35c309142678eb5b7df97a5de5','08c7a43a87ecb1f2d4db879c576d42265b938ae146d606677d9de4f0c9103039','34dbf7d72872b04cd458501d3aa0746cb9b35b27cb4d251b3b45afe6b90a92fd');
  INSERT INTO blocks VALUES(310048,'610bf3935a85b05a98556c55493c6de45bed4d7b3b6c8553a984718765796309',310048000,NULL,NULL,'208200708851a32b0ffaecade58f78f8ba7d5820457c582d5ca127e16fec0952','1e812a4029d16f0a60f34c1e201d43f970c2d42ac74bc6cf1e64232d2ba07538','1778b98fc6b9cc4a4d4dc496323ae78a5dd61b910028cc4fe55f4462ccec8280');
  INSERT INTO blocks VALUES(310049,'4ad2761923ad49ad2b283b640f1832522a2a5d6964486b21591b71df6b33be3c',310049000,NULL,NULL,'9d1a7335d989bb73b0363bc88da6dd82c0fbaf064b1d70708b0aa2f6a8a9958b','44a33bfd0a9c9b650a64197a2b0ab342373a34b03b43f4bb91385052210a0418','f788888439a1c02b1fd010464f5646d219fa874fe098b4025be9471fe19fa0d4');
  INSERT INTO blocks VALUES(310050,'8cfeb60a14a4cec6e9be13d699694d49007d82a31065a17890383e262071e348',310050000,NULL,NULL,'2fd9039e49fcbb070315defae275bed858cfbb539bc4db8f2ec5f5ff6d69ea25','0bf8dff78ddd86f736e4c10b66080c590ac82ec7aab87006d0d3fd5fddc6c7e8','b3e0cc571c83c01b5fc71586f63d406cfc22d10b1c1c302245210a76f44c1902');
  INSERT INTO blocks VALUES(310051,'b53c90385dd808306601350920c6af4beb717518493fd23b5c730eea078f33e6',310051000,NULL,NULL,'2e97864865a020b04ed60b22c347d9dbebce5d00abce86c2b3a5054a3184699b','1ddedf5101dc520775c61c73000150adabed385e201c04fdcc814870aa3fb036','048f54bc433772bb2ef9b440a5e33e5a1f749a3dfdbde9907f02fe83d3e03f46');
  INSERT INTO blocks VALUES(310052,'0acdacf4e4b6fca756479cb055191b367b1fa433aa558956f5f08fa5b7b394e2',310052000,NULL,NULL,'f6a8e9f4cde78fbf6c9a5ea176312116f3813f2c0bcaee6c92f3beb13a8c3899','9c308536749ecfe35414252367f6d68b842acc7905f2737fae80cdbc76223506','657bc671c69a9ae92027c4296d73ac77f091597fada9bca779f995134a4b6996');
  INSERT INTO blocks VALUES(310053,'68348f01b6dc49b2cb30fe92ac43e527aa90d859093d3bf7cd695c64d2ef744f',310053000,NULL,NULL,'1d84e4657febaa291b4873d808d9ab433370227976196fd6436a65839c3575d1','ea53a531412104a500f7777a1281a1865e131e35cd6ff6b07c708c6b1b5db43b','36d8c93305b597ae53cda8813592700780d3f627870e295fd1b200683157b077');
  INSERT INTO blocks VALUES(310054,'a8b5f253df293037e49b998675620d5477445c51d5ec66596e023282bb9cd305',310054000,NULL,NULL,'083f6b773191caaf1844f47c53077e8724e100d0b46461ddaa642b88d5265c9a','d5d229022718ce473ba646317f5d0e97b9578c7120229fffc41635610daffe47','324690c95f7be2985dca6c1dda23a10ff4758f2d5f02bcdb10851b60cdbd7b6b');
  INSERT INTO blocks VALUES(310055,'4b069152e2dc82e96ed8a3c3547c162e8c3aceeb2a4ac07972f8321a535b9356',310055000,NULL,NULL,'b1302087b804fc5753df5a4d8aaf8626e80ff99b429f52fed97767b051c24e8c','61676027fe3cd657040a248007a8fb16eb08dee3dc28fb16eabd5c648df835fa','37c43a4a262ba1107ab8fea848c68bbd6622384ea7fe676f0b9c53d19ecbcdb6');
  INSERT INTO blocks VALUES(310056,'7603eaed418971b745256742f9d2ba70b2c2b2f69f61de6cc70e61ce0336f9d3',310056000,NULL,NULL,'956c9ca0b51eaba7343703a165eb96d5947fc764457ef3dde5ca90c18d3b2f3d','8c1d4744e43b6cc21cc041af33349cddcec980fe740f1776564bbb9d5068ee23','c02ee1975e98d7c9cb34bc5010602233d66e7fab5c9ecdafffd2014821cee5a3');
  INSERT INTO blocks VALUES(310057,'4a5fdc84f2d66ecb6ee3e3646aad20751ce8694e64e348d3c8aab09d33a3e411',310057000,NULL,NULL,'e86cae3e73aa13e8498a98de335ed0cbdb7899b24e91839bbf0f50aa22355ecb','522c293ddc948650e5b0c22e956ed3e1c0de804fa68d5d308399acac4377dd28','20bb812c1f31b47419a3ad05db36828a74208e922ca222b9c5668a9592070544');
  INSERT INTO blocks VALUES(310058,'a6eef3089896f0cae0bfe9423392e45c48f4efe4310b14d8cfbdb1fea613635f',310058000,NULL,NULL,'54bd5e4fc1bc17df27f9e6f22b5e1facd82229a877e09ec0136f878f2da81344','160a607ad9174c65f27367dc9f8626402d14c2193af90d9e41a3105d8dc05ca5','e69a4d8c0dd9df4ccf1b4ff412f9cca4970d345f1d3d75caf153d407d4ece35c');
  INSERT INTO blocks VALUES(310059,'ab505de874c43f97c90be1c26a769e6c5cb140405c993b4a6cc7afc795f156a9',310059000,NULL,NULL,'1403832427d4c482b0d2d925e08a72fe37f5aaa6af73e74f601f7e22fdad7662','63eac72bb92a30b6525211612a1c40610dbd1c4e2748b596bbffe168ea576cc6','15815b72f90d80e58ef76f1452f7a52cc7f86acf443ff8cc99c57d2a4d93a19a');
  INSERT INTO blocks VALUES(310060,'974ad5fbef621e0a38eab811608dc9afaf10c8ecc85fed913075ba1a145e889b',310060000,NULL,NULL,'7b08f124a953d0e5511b0698d3314f5ec71ebba77b94c4d236ff9738d5a587e8','01890f7c4932de0cbad12db5797333551ef9e8efcd4196ef66098d94460134e6','64f0803bd6631cb0107e9d1e38ae9d56d07fea300653dab84d1a840c2c77a7f7');
  INSERT INTO blocks VALUES(310061,'35d267d21ad386e7b7632292af1c422b0310dde7ca49a82f9577525a29c138cf',310061000,NULL,NULL,'1de158dfd18413618b9800236a2aa265d2fab497b09a839be408da8871b0960a','27b39e701ca30ee796e407d1ad18e9dee4965870f96d5d095e483d9d7f4dec5d','740f44c46a141ab36092d50ffe4335618564ee86b7a5f80dc05f0586ad1bb63c');
  INSERT INTO blocks VALUES(310062,'b31a0054145319ef9de8c1cb19df5bcf4dc8a1ece20053aa494e5d3a00a2852f',310062000,NULL,NULL,'aa4be540bad6cd762a02b77856c3d6a737d90245e71f61b63a426573bffb3a4a','4cebabac55d075f4895e1556e74ebd87efe80e90b3705083020f46c9351f4228','4929c78a9d202aac03bf85a3e450fb1a00b6234c8cc75967e2a40bb2f52acb97');
  INSERT INTO blocks VALUES(310063,'0cbcbcd5b7f2dc288e3a34eab3d4212463a5a56e886804fb4f9f1cf929eadebe',310063000,NULL,NULL,'49edce8190c2480fe3c6b3df7c7c5f13d34f67c3aef3b2aa12eaea603153aa83','5916716daf44996899cca05282527b5e3b4327bede3c1191c35758802dfe90a2','6e80724ce47f9df8bd2f278a074daceb47fb658bfce00d7b49e29ad959761bb0');
  INSERT INTO blocks VALUES(310064,'e2db8065a195e85cde9ddb868a17d39893a60fb2b1255aa5f0c88729de7cbf30',310064000,NULL,NULL,'a2a8c9946cf45490858deb15c8f277ec545854dfc02dc9d248a684c0c3544d6e','ca04e3d8a596180b134770ed2f868cb8ddc826be9a1ff8adb7b7d502ef72e279','6ea4ec35f9a7f14dc449b7e6367bb42eac5bd24a41ef309aaec4ab3130e0da3f');
  INSERT INTO blocks VALUES(310065,'8a7bc7a77c831ac4fd11b8a9d22d1b6a0661b07cef05c2e600c7fb683b861d2a',310065000,NULL,NULL,'ca1e5d385fd9cec1184d28095a6f4a2ec2914d40cc016309fe322dbb335cf2c3','6bf60bdad2e88fe236287447ca91e03e802c188209f4525e0c39d54e34c00cdb','72a42bc063004207a83bfc04f154bcbd3176d3d3f9d7e91c72bff9fdce604b50');
  INSERT INTO blocks VALUES(310066,'b6959be51eb084747d301f7ccaf9e75f2292c9404633b1532e3692659939430d',310066000,NULL,NULL,'73519f53874cc8cbe9052bf8dd18c590e0a4bd5bdc2a286c4930e8cfd006a993','c777779b79d22bea24211c8dd2dabc77b6587f32b93427f74de9d075b9af0749','3d093ff9badeef100b26303cd9b9e87a65ffb8a75c9b14ea5ac53bc7f3f5735b');
  INSERT INTO blocks VALUES(310067,'8b08eae98d7193c9c01863fac6effb9162bda010daeacf9e0347112f233b8577',310067000,NULL,NULL,'5de09a95e36480de84f9d3c8db3e18b7bf5145f8b6ee6bde57b5c3de11274cbd','e323cc0632bd007c468c22b6d8b1e9d1d2fb1801cedf074542bf5e30473f5085','d561b007d7149b41c7647bf248bc2a9edf147119e694b581f18ca69d403d0925');
  INSERT INTO blocks VALUES(310068,'9280e7297ef6313341bc81787a36acfc9af58f83a415afff5e3154f126cf52b5',310068000,NULL,NULL,'be6a452931358d500eda0fd2aa3a91b86483fa847a7bf350f23d33d85712592e','dac02ac01a7cdeda193a1e9c67130b245903c994ee35a1076bd5c4f70e7938eb','fc3920458640eb2b9f6767770a6d2e6d40e868a223d684feaee19ec0d66e24fd');
  INSERT INTO blocks VALUES(310069,'486351f0655bf594ffaab1980cff17353b640b63e9c27239109addece189a6f7',310069000,NULL,NULL,'5940a47dfa1a1c8bc1e51f1e64100cd0604c74197c88b39f6f7a9d5b763a0b56','acbe463d047989e333688eec3ac6ea8a714295b46bd5941d34d9f870e59b478e','4d379658a33656e957410e5e551491c39cfd5129c3a4b0ac330b191376e58d01');
  INSERT INTO blocks VALUES(310070,'8739e99f4dee8bebf1332f37f49a125348b40b93b74fe35579dd52bfba4fa7e5',310070000,NULL,NULL,'6aebe68545207e7cc81d68c3aca801f0b39e276ac86e8e0130d5029eefb60e2e','fac718dec32de0113e5367c49ca9aa3a65dc8c642c065d84add8930e76f89dc2','faa263073b5d409eb4559be9024e3c5f35a1a65d591deed369d5fe0689ca9703');
  INSERT INTO blocks VALUES(310071,'7a099aa1bba0ead577f1e44f35263a1f115ed6a868c98d4dd71609072ae7f80b',310071000,NULL,NULL,'d005aff752907b93e2dfe442896c8976203f0139fb67cda3ea1936aea495e008','50d09df37c56842331b8bf7ea11d8fae65a2e89a10cffb90d404dffc638c2021','1fba4a34677ed81ad5c9b2e4e5be4efcf08c46c7dc8b446638db0c7528d42fa3');
  INSERT INTO blocks VALUES(310072,'7b17ecedc07552551b8129e068ae67cb176ca766ea3f6df74b597a94e3a7fc8a',310072000,NULL,NULL,'781f0ebe67964c25640f0bf5624e08cda546dbbb6648bd6e8d9f280c7f075f7c','79e3dd5c8c2248a7df858251114914018cb3857cab22d1386c02431144c7476e','a88330538f58ba1e1ba63c805f8b90e16016df58a462dc956523fb4e521d6583');
  INSERT INTO blocks VALUES(310073,'ee0fe3cc9b3a48a2746b6090b63b442b97ea6055d48edcf4b2288396764c6943',310073000,NULL,NULL,'83b5e1ca76fda895b144e8c03cda5fc3d18f6324b5413fd74923e51a94ccc53a','98d8b47e93cf2febf5aa3f1d9cffc62db81fc9c2c2617b2d19d8d0a752be4c36','a24d04858ba03081e2879cfcd2e3917fd55874549e3b885dca56980b18814266');
  INSERT INTO blocks VALUES(310074,'ceab38dfde01f711a187601731ad575d67cfe0b7dbc61dcd4f15baaef72089fb',310074000,NULL,NULL,'4293be396327c0aa3c56c77a9152068cc32612692c76ba94e8961c59a9ad780f','9f8040bb1ae80db6f688dd33c22e232aa93ebdaef05a6a1d39c892fb92792f02','bba2b1acfec2fbe985270270b7bdeb79ea9284aa8c028062b7ef772c719291af');
  INSERT INTO blocks VALUES(310075,'ef547198c6e36d829f117cfd7077ccde45158e3c545152225fa24dba7a26847b',310075000,NULL,NULL,'d08b93b609f1766534cb0c30502350b9e4ccc4a885ebff7633e9e5c5b52d8e90','2b6379742f7931f79a9e635d1e77a73b038ce7284185554a940680923c3b669b','94a2bf137ebb50ce7e81365da2ec01d52743d3145511c91ceb2a381e2e4dc5d8');
  INSERT INTO blocks VALUES(310076,'3b0499c2e8e8f0252c7288d4ecf66efc426ca37aad3524424d14c8bc6f8b0d92',310076000,NULL,NULL,'06c72d219df429f2873af74b6250f3d12996cce14496d151bf8bd4cf819532e4','f4e198e822161dec5d4b0fa731095a5ecc43c1481055ecfd576ad1a6a7a9c414','d17c0ed0e2952a7cc4dd87daa7849cff0c28d04f2227f18477bc2621a18fa711');
  INSERT INTO blocks VALUES(310077,'d2adeefa9024ab3ff2822bc36acf19b6c647cea118cf15b86c6bc00c3322e7dd',310077000,NULL,NULL,'0ff019cc4b9b8a394aad1b9f8f579fd5c4cc48a846e4fe71ab2f45226cec5a1e','5f2aefda912b814c493c6803e24d81ca54c3c19e15dc87f2a288a5cee5acfbed','2ac8e37638223e80995972eecf08e860f8cf544339eb138eaf7b2ef6c20bdd67');
  INSERT INTO blocks VALUES(310078,'f6c17115ef0efe489c562bcda4615892b4d4b39db0c9791fe193d4922bd82cd6',310078000,NULL,NULL,'6ea40a02464725d0ba45b9969bdbb7529ae5e3ca794ae00abf4783bfc9667104','c4342fdd4ef024f8c707ce29ef69165b39f1be83ceced319759720f0fe21fad8','4b741723413227cfe2d70f0922497dfd2012cb4727d1b81bbc38b9ec44ec310d');
  INSERT INTO blocks VALUES(310079,'f2fbd2074d804e631db44cb0fb2e1db3fdc367e439c21ffc40d73104c4d7069c',310079000,NULL,NULL,'076abf036bd51c47525fe4e638dbad403a8a1667a5b7c2f81ffc2a70e79b80a8','96b310bf0ae4ef2ce6a9a3dbab73ad2a69e96cd48efbf9085ce4f9fb5fb0ee96','8ac5c0fad3f3ecadbd10089ebaffaf3c3ad6388300145b386d1ab8a9b0ba7be9');
  INSERT INTO blocks VALUES(310080,'42943b914d9c367000a78b78a544cc4b84b1df838aadde33fe730964a89a3a6c',310080000,NULL,NULL,'8cc2e62f7b3ae2c89977ee9e31acacff38f944d00a978e9b0e48678487cdbe27','72bb783e61790691179e62643ce86792914697ad132ee524fee212f2d33e8087','18e851c3742a6bf0d7d3c3c702cbb7d35229a88d0c6e70e35d975bc464bfc717');
  INSERT INTO blocks VALUES(310081,'6554f9d307976249e7b7e260e08046b3b55d318f8b6af627fed5be3063f123c4',310081000,NULL,NULL,'ec86fa6786b598b091121fc2001650bc04668d26d88805efff7271312c76a373','0bb9fabea98c5e4f720030e030f77b3960033385fedc9357954a2f23c829245c','3e7ab881b3557f286f21f0865366b66a998ef69de3c8caeca8cfebcebe3e0cb2');
  INSERT INTO blocks VALUES(310082,'4f1ef91b1dcd575f8ac2e66a67715500cbca154bd6f3b8148bb7015a6aa6c644',310082000,NULL,NULL,'6b720db96b2d10816e5022ab8c61fafba49cc6bf484909fb500295451e61f768','0f9ea91fe4e2c012042724e34866c5000d26ca5bd3717107ed91555f554b86b7','57ebbda7e3b0403c74a96be905cc7594f81716b016248d26d6cfce4d5ab9d39c');
  INSERT INTO blocks VALUES(310083,'9b1f6fd6ff9b0dc4e37603cfb0625f49067c775b99e12492afd85392d3c8d850',310083000,NULL,NULL,'d8c6fabb9b9dff0f1f3ba35e75c08be55dc4ded8dcf54e51f0cd857625b87dc8','0f56427ebb8b63957f4c1d70ecdbd51f3d1c89f76416bc290003ec3cc2629d49','89f055098bd851d7a8c208d974c7ea77e518fc2531516fb903a32cd213243914');
  INSERT INTO blocks VALUES(310084,'1e0972523e80306441b9f4157f171716199f1428db2e818a7f7817ccdc8859e3',310084000,NULL,NULL,'eba03194b13ca764dbfbb86f86d16841df4486f12c26a214f7f1020468b52d27','71837daf0d464712caa10bf1c02f30e0c5402aac19c92fa91ca1db7c8f84e87f','db7f921ea738b26042bc46f5f75ca81dc0383c1e804dada7ccd5ab91f1853c48');
  INSERT INTO blocks VALUES(310085,'c5b6e9581831e3bc5848cd7630c499bca26d9ece5156d36579bdb72d54817e34',310085000,NULL,NULL,'d7fa8085722edc91ea5cb907e439649533e32ad5429b52bc10463629719af5ab','0e5f52a95be1dac079a0600eb868a73c21d7c8e8e6855c425c9fb7ce7ca62cd6','af550dd1718191cc5b371da3b82d16e923206aef67124c1b2589413a17ff2521');
  INSERT INTO blocks VALUES(310086,'080c1dc55a4ecf4824cf9840602498cfc35b5f84099f50b71b45cb63834c7a78',310086000,NULL,NULL,'e84e0b26a5a67af1bca0cdadadea17b52b79f160d8acc0281289de1c70bef248','17fb8ba3aac1556cdaf6bbf962365d971aa632e95f8b5c179dc279c23189cfd9','0e22415d87f2b2f372c5c15cbca66d2e71b2e77599d17c7a5121d3382653baf6');
  INSERT INTO blocks VALUES(310087,'4ec8cb1c38b22904e8087a034a6406b896eff4dd28e7620601c6bddf82e2738c',310087000,NULL,NULL,'ac3522ba0e8278bac956b5f9d7af271424f8e4eff23d57d2a5ff88416dd02ff4','991a948d60c61b5d6acc02951bce9aaa8fc026e571921ba99a54e5d97e682a37','d7543b97499bf697edd957f1e8c2b6b3154b39dfe43aaa81372cbeade846f65f');
  INSERT INTO blocks VALUES(310088,'e945c815c433cbddd0bf8e66c5c23b51072483492acda98f5c2c201020a8c5b3',310088000,NULL,NULL,'86255a3e32e6c7a96d0f0a6e7815d61d9a970272f1df38bb0c29ee9f2051f2e4','a5a61748cb2fa9409efed49ca201e29fd3e4f7754c74ea1a86fb69942cc7d190','032c011448424f293eaa52a9af6ef9e80a9e69c92695da7e5408af872d30e784');
  INSERT INTO blocks VALUES(310089,'0382437f895ef3e7e38bf025fd4f606fd44d4bbd6aea71dbdc4ed11a7cd46f33',310089000,NULL,NULL,'9694fd19263381693133a47584432de876ef1e0a32060d52c8db96811ff7d09e','35a0939d03abeaa805e638daf023a92bad989a97a4ad9f1e311ba5c10e64fa59','474806edb8674281118f48c6b5677d4bbf59b7c9f7329764732771030ebda0d0');
  INSERT INTO blocks VALUES(310090,'b756db71dc037b5a4582de354a3347371267d31ebda453e152f0a13bb2fae969',310090000,NULL,NULL,'3cb1b469cc6627cbed3f0db1a00370d5c95edf9940f8a4c9406fc78076640d90','d02844061e67847d5b58f10de3e12fb5543d60ea104928c20889d0d5e3dd2fe8','5c460bb70667372516cc3ba1fd33082a123db9e155c71622d647a84886cb9c7c');
  INSERT INTO blocks VALUES(310091,'734a9aa485f36399d5efb74f3b9c47f8b5f6fd68c9967f134b14cfe7e2d7583c',310091000,NULL,NULL,'cac7cc49c1d632aef2e9bcb3456f60df2ff11110c4e9980989ce0f2d8a5835e1','4e37c6cb4c778d2f849b4798ccbd1942af059051270de489d4266924a703e53b','2b7d94a10eaa2883d0860d6c73710a8307e87f54bb6cf1d82639651a40c258ef');
  INSERT INTO blocks VALUES(310092,'56386beb65f9228740d4ad43a1c575645f6daf59e0dd9f22551c59215b5e8c3d',310092000,NULL,NULL,'1614a317b1144c7f08fb2785bf468bb299b9f19450331b7fdfebd510fa07e574','db44cdcb38fd9653ca8ee1a72a5024c8d54c993b59d434c370b20835c60bf504','2a37c7edf18f6ab0a6e28bc978d17feb36ee296fcf9b53a57347c1c2833fd0fc');
  INSERT INTO blocks VALUES(310093,'a74a2425f2f4be24bb5f715173e6756649e1cbf1b064aeb1ef60e0b94b418ddc',310093000,NULL,NULL,'631d42f4b3fb091a4c67f737bc2da60b8bf9820d27c758f5b9453b40813c5bc5','aad64c92a4de5c942193c7448a37c4112798c0d5e23f091fbec82e8b3b2b9747','4b8cc648099185ea0061c15d8e3810eaeaf6fadf4d5e424c1d5fc057dc98da9b');
  INSERT INTO blocks VALUES(310094,'2a8f976f20c4e89ff01071915ac96ee35192d54df3a246bf61fd4a0cccfb5b23',310094000,NULL,NULL,'2b3f460da72fc0a9b3a720abca80bff0c44654287de69567c43c62a5557144bf','8dd1e79d95296e1a931740d0dc6109b72a4f7eb05f8fcfbc325751b08347961e','1acdcc0092f47d1039f5791a476432f8fb18365f36fc1f49446292a0a89f1d5a');
  INSERT INTO blocks VALUES(310095,'bed0fa40c9981223fb40b3be8124ca619edc9dd34d0c907369477ea92e5d2cd2',310095000,NULL,NULL,'db62bf94ddb276cf55ddfe73f8023e760788647910807adff6e0672ce1d5e23d','e130340fe094c2e1ea313f73ec63a3f8622bb0f3bcaee3f2ac6d615d24869521','ad66de69d26ea7c3c1819706f20b7c677c73b3c3987d9797d5b2efb0c167b877');
  INSERT INTO blocks VALUES(310096,'306aeec3db435fabffdf88c2f26ee83caa4c2426375a33daa2be041dbd27ea2f',310096000,NULL,NULL,'1c427808f1eb1972df57b51eea9f3405d3d63a1d58c5a3faba616d7160e3a264','e19a19a26bf0b3092d87dd5e24bcbbfee514d1a25401a026a4e8485e92c187c3','322f4a63e0d57a69498abeb47d3114c5f362975666faee3230929e1c5d646d60');
  INSERT INTO blocks VALUES(310097,'13e8e16e67c7cdcc80d477491e554b43744f90e8e1a9728439a11fab42cefadf',310097000,NULL,NULL,'cd28b5ac0f80f8815467663c1e90b15ffe46ce067a1b2ce004b0d371cb0ceb16','3d987da5850f190e930b0b282a00c86d86fd3db640c0cb5c32fe704c197135b2','1b1ad1fc9515afd756871e7793ea44627d228924cbce882d2e97dbed154e98a7');
  INSERT INTO blocks VALUES(310098,'ca5bca4b5ec4fa6183e05176abe921cff884c4e20910fab55b603cef48dc3bca',310098000,NULL,NULL,'69adfbe756c116e395fb3a5170b57210ac2721b07144b3d7a35c4327f28e28c9','e729db125384db60646578da27354ff5c4e81d089268decec9c62356b7f173e0','99345fba31a1da3374502f15bcac36d36959376fcb5e60cea54211828015e7c9');
  INSERT INTO blocks VALUES(310099,'3c4c2279cd7de0add5ec469648a845875495a7d54ebfb5b012dcc5a197b7992a',310099000,NULL,NULL,'d50cb66a25a410db360cdf749b5d10932410b5e37c3e5d3d834a65b5671dcca6','9ec378057e383c451ca260757489dd36da9660b18f4202e9051736d6f979f0ad','7f1e7ebdb1d2a52ab47a16f28e50c2b856be48e5dc9e575b9a50c5cc5f98e07d');
  INSERT INTO blocks VALUES(310100,'96925c05b3c7c80c716f5bef68d161c71d044252c766ca0e3f17f255764242cb',310100000,NULL,NULL,'384f8d2eda5f1b7b8273ef149ac37fcaa9ae51865fd57bd348339579b8a078eb','fbbc180a2e56c6f8440b2930a01a16820aefc4f463e42717e238cd74be66217a','2c63eab89b59c98ed99f1165bcd965ab9c10ccd639267206c8981fa5d7eff145');
  INSERT INTO blocks VALUES(310101,'369472409995ca1a2ebecbad6bf9dab38c378ab1e67e1bdf13d4ce1346731cd6',310101000,NULL,NULL,'5eff25450225c71f85f34466d6e359001eed8f05ea5042e7d65c30ccfeb6098f','24349767075b38124a94fd480dd5f4c5b7ff491676d7161d58dd6987a9c1075c','40efdec5807a456c18d7ea6197f62fe7a32d76b67ee6aff5f0eb5386a965e8c3');
  -- Triggers and indices on  blocks
  CREATE INDEX block_index_idx ON blocks (block_index);
  CREATE INDEX index_hash_idx ON blocks (block_index, block_hash);
  
  -- Table  broadcasts
  DROP TABLE IF EXISTS broadcasts;
  CREATE TABLE broadcasts(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        timestamp INTEGER,
                        value REAL,
                        fee_fraction_int INTEGER,
                        text TEXT,
                        locked BOOL,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO broadcasts VALUES(12,'fb70fe2fe539e5ed1950885c3385ecb01d27ccfd583c6dff94006b3a55866e72',310011,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000000,100.0,99999999,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(19,'3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452',310018,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000050,99.86166,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(20,'f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f',310019,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000101,100.343,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(21,'63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3',310020,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000201,2.0,5000000,'Unit Test',0,'valid');
  -- Triggers and indices on  broadcasts
  CREATE TRIGGER _broadcasts_delete BEFORE DELETE ON broadcasts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO broadcasts(rowid,tx_index,tx_hash,block_index,source,timestamp,value,fee_fraction_int,text,locked,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.timestamp)||','||quote(old.value)||','||quote(old.fee_fraction_int)||','||quote(old.text)||','||quote(old.locked)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _broadcasts_insert AFTER INSERT ON broadcasts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM broadcasts WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _broadcasts_update AFTER UPDATE ON broadcasts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE broadcasts SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',timestamp='||quote(old.timestamp)||',value='||quote(old.value)||',fee_fraction_int='||quote(old.fee_fraction_int)||',text='||quote(old.text)||',locked='||quote(old.locked)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX status_source_idx ON broadcasts (status, source);
  CREATE INDEX status_source_index_idx ON broadcasts (status, source, tx_index);
  CREATE INDEX timestamp_idx ON broadcasts (timestamp);
  
  -- Table  btcpays
  DROP TABLE IF EXISTS btcpays;
  CREATE TABLE btcpays(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        destination TEXT,
                        btc_amount INTEGER,
                        order_match_id TEXT,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO btcpays VALUES(5,'f307fdf5e231e05f9e9ecf23e5fc8bfff87951b223575840690b3f8bb502ad0f',310004,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',50000000,'82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1','valid');
  -- Triggers and indices on  btcpays
  CREATE TRIGGER _btcpays_delete BEFORE DELETE ON btcpays BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO btcpays(rowid,tx_index,tx_hash,block_index,source,destination,btc_amount,order_match_id,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.destination)||','||quote(old.btc_amount)||','||quote(old.order_match_id)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _btcpays_insert AFTER INSERT ON btcpays BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM btcpays WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _btcpays_update AFTER UPDATE ON btcpays BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE btcpays SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',destination='||quote(old.destination)||',btc_amount='||quote(old.btc_amount)||',order_match_id='||quote(old.order_match_id)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  burns
  DROP TABLE IF EXISTS burns;
  CREATE TABLE burns(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        burned INTEGER,
                        earned INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO burns VALUES(1,'5fde1c728d8d00aaa1b5f8dae963ceb4fd30c415eb0b8a982ba2d8d676fec0bb',310000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',62000000,93000000000,'valid');
  INSERT INTO burns VALUES(23,'df080a76ceb263201901bc23c85c3e8dce4eca0e72c873131adaf2f46820e9f1',310022,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',38000000,56999887262,'valid');
  -- Triggers and indices on  burns
  CREATE TRIGGER _burns_delete BEFORE DELETE ON burns BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO burns(rowid,tx_index,tx_hash,block_index,source,burned,earned,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.burned)||','||quote(old.earned)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _burns_insert AFTER INSERT ON burns BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM burns WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _burns_update AFTER UPDATE ON burns BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE burns SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',burned='||quote(old.burned)||',earned='||quote(old.earned)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  cancels
  DROP TABLE IF EXISTS cancels;
  CREATE TABLE cancels(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        offer_hash TEXT,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  cancels
  CREATE TRIGGER _cancels_delete BEFORE DELETE ON cancels BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO cancels(rowid,tx_index,tx_hash,block_index,source,offer_hash,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.offer_hash)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _cancels_insert AFTER INSERT ON cancels BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM cancels WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _cancels_update AFTER UPDATE ON cancels BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE cancels SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',offer_hash='||quote(old.offer_hash)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX cancels_block_index_idx ON cancels (block_index);
  
  -- Table  credits
  DROP TABLE IF EXISTS credits;
  CREATE TABLE credits(
                        block_index INTEGER,
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER,
                        calling_function TEXT,
                        event TEXT,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  INSERT INTO credits VALUES(310000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',93000000000,'burn','5fde1c728d8d00aaa1b5f8dae963ceb4fd30c415eb0b8a982ba2d8d676fec0bb');
  INSERT INTO credits VALUES(310001,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'send','63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc');
  INSERT INTO credits VALUES(310004,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',100000000,'btcpay','f307fdf5e231e05f9e9ecf23e5fc8bfff87951b223575840690b3f8bb502ad0f');
  INSERT INTO credits VALUES(310005,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',1000000000,'issuance','ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975');
  INSERT INTO credits VALUES(310006,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',100000,'issuance','b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06');
  INSERT INTO credits VALUES(310007,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'send','cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab');
  INSERT INTO credits VALUES(310008,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'send','0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89');
  INSERT INTO credits VALUES(310009,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',24,'dividend','4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3');
  INSERT INTO credits VALUES(310010,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',420800,'dividend','2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7');
  INSERT INTO credits VALUES(310013,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',4250000,'filled','08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12');
  INSERT INTO credits VALUES(310014,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',5000000,'cancel order','371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1');
  INSERT INTO credits VALUES(310015,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572');
  INSERT INTO credits VALUES(310015,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572');
  INSERT INTO credits VALUES(310017,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9');
  INSERT INTO credits VALUES(310017,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9');
  INSERT INTO credits VALUES(310018,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',59137500,'bet settled: liquidated for bear','3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452');
  INSERT INTO credits VALUES(310018,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',3112500,'feed fee','3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452');
  INSERT INTO credits VALUES(310019,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',159300000,'bet settled','f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f');
  INSERT INTO credits VALUES(310019,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',315700000,'bet settled','f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f');
  INSERT INTO credits VALUES(310019,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',25000000,'feed fee','f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f');
  INSERT INTO credits VALUES(310020,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',1330000000,'bet settled: for notequal','63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3');
  INSERT INTO credits VALUES(310020,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',70000000,'feed fee','63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3');
  INSERT INTO credits VALUES(310022,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',56999887262,'burn','df080a76ceb263201901bc23c85c3e8dce4eca0e72c873131adaf2f46820e9f1');
  INSERT INTO credits VALUES(310023,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',8500000,'recredit wager remaining','44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b');
  INSERT INTO credits VALUES(310023,'2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10000,'send','ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca');
  INSERT INTO credits VALUES(310032,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',50000000,'cancel order','dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41');
  -- Triggers and indices on  credits
  CREATE TRIGGER _credits_delete BEFORE DELETE ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO credits(rowid,block_index,address,asset,quantity,calling_function,event) VALUES('||old.rowid||','||quote(old.block_index)||','||quote(old.address)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.calling_function)||','||quote(old.event)||')');
                              END;
  CREATE TRIGGER _credits_insert AFTER INSERT ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM credits WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _credits_update AFTER UPDATE ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE credits SET block_index='||quote(old.block_index)||',address='||quote(old.address)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',calling_function='||quote(old.calling_function)||',event='||quote(old.event)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  debits
  DROP TABLE IF EXISTS debits;
  CREATE TABLE debits(
                        block_index INTEGER,
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER,
                        action TEXT,
                        event TEXT,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  INSERT INTO debits VALUES(310001,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'send','63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc');
  INSERT INTO debits VALUES(310003,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',105000000,'open order','371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1');
  INSERT INTO debits VALUES(310005,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'issuance fee','ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975');
  INSERT INTO debits VALUES(310006,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'issuance fee','b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06');
  INSERT INTO debits VALUES(310007,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'send','cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab');
  INSERT INTO debits VALUES(310008,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'send','0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89');
  INSERT INTO debits VALUES(310009,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',24,'dividend','4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3');
  INSERT INTO debits VALUES(310009,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',20000,'dividend fee','4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3');
  INSERT INTO debits VALUES(310010,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',420800,'dividend','2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7');
  INSERT INTO debits VALUES(310010,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',20000,'dividend fee','2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7');
  INSERT INTO debits VALUES(310012,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'bet','44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b');
  INSERT INTO debits VALUES(310013,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',25000000,'bet','08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12');
  INSERT INTO debits VALUES(310014,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',150000000,'bet','3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68');
  INSERT INTO debits VALUES(310015,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',350000000,'bet','75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572');
  INSERT INTO debits VALUES(310016,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',750000000,'bet','674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644');
  INSERT INTO debits VALUES(310017,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',650000000,'bet','4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9');
  INSERT INTO debits VALUES(310021,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',50000000,'open order','dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41');
  INSERT INTO debits VALUES(310023,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10000,'send','ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca');
  -- Triggers and indices on  debits
  CREATE TRIGGER _debits_delete BEFORE DELETE ON debits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO debits(rowid,block_index,address,asset,quantity,action,event) VALUES('||old.rowid||','||quote(old.block_index)||','||quote(old.address)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.action)||','||quote(old.event)||')');
                              END;
  CREATE TRIGGER _debits_insert AFTER INSERT ON debits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM debits WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _debits_update AFTER UPDATE ON debits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE debits SET block_index='||quote(old.block_index)||',address='||quote(old.address)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',action='||quote(old.action)||',event='||quote(old.event)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX address_idx ON debits (address);
  CREATE INDEX asset_idx ON debits (asset);
  
  -- Table  destructions
  DROP TABLE IF EXISTS destructions;
  CREATE TABLE destructions(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        asset INTEGER,
                        quantity INTEGER,
                        tag TEXT,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  destructions
  CREATE TRIGGER _destructions_delete BEFORE DELETE ON destructions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO destructions(rowid,tx_index,tx_hash,block_index,source,asset,quantity,tag,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.tag)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _destructions_insert AFTER INSERT ON destructions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM destructions WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _destructions_update AFTER UPDATE ON destructions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE destructions SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',tag='||quote(old.tag)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX status_idx ON destructions (status);
  
  -- Table  dispensers
  DROP TABLE IF EXISTS dispensers;
  CREATE TABLE dispensers(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        asset TEXT,
                        give_quantity INTEGER,
                        escrow_quantity INTEGER,
                        satoshirate INTEGER,
                        status INTEGER,
                        give_remaining INTEGER,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  dispensers
  CREATE TRIGGER _dispensers_delete BEFORE DELETE ON dispensers BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO dispensers(rowid,tx_index,tx_hash,block_index,source,asset,give_quantity,escrow_quantity,satoshirate,status,give_remaining) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.asset)||','||quote(old.give_quantity)||','||quote(old.escrow_quantity)||','||quote(old.satoshirate)||','||quote(old.status)||','||quote(old.give_remaining)||')');
                              END;
  CREATE TRIGGER _dispensers_insert AFTER INSERT ON dispensers BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM dispensers WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _dispensers_update AFTER UPDATE ON dispensers BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE dispensers SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',asset='||quote(old.asset)||',give_quantity='||quote(old.give_quantity)||',escrow_quantity='||quote(old.escrow_quantity)||',satoshirate='||quote(old.satoshirate)||',status='||quote(old.status)||',give_remaining='||quote(old.give_remaining)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  dispenses
  DROP TABLE IF EXISTS dispenses;
  CREATE TABLE dispenses(
                        tx_index INTEGER,
                        dispense_index INTEGER,
                        tx_hash TEXT,
                        block_index INTEGER,
                        source TEXT,
                        destination TEXT,
                        asset TEXT,
                        dispense_quantity INTEGER,
                        dispenser_tx_hash TEXT,
                        PRIMARY KEY (tx_index, dispense_index, source, destination),
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  dispenses
  CREATE TRIGGER _dispenses_delete BEFORE DELETE ON dispenses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO dispenses(rowid,tx_index,dispense_index,tx_hash,block_index,source,destination,asset,dispense_quantity,dispenser_tx_hash) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.dispense_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.destination)||','||quote(old.asset)||','||quote(old.dispense_quantity)||','||quote(old.dispenser_tx_hash)||')');
                              END;
  CREATE TRIGGER _dispenses_insert AFTER INSERT ON dispenses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM dispenses WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _dispenses_update AFTER UPDATE ON dispenses BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE dispenses SET tx_index='||quote(old.tx_index)||',dispense_index='||quote(old.dispense_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',destination='||quote(old.destination)||',asset='||quote(old.asset)||',dispense_quantity='||quote(old.dispense_quantity)||',dispenser_tx_hash='||quote(old.dispenser_tx_hash)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  dividends
  DROP TABLE IF EXISTS dividends;
  CREATE TABLE dividends(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        asset TEXT,
                        dividend_asset TEXT,
                        quantity_per_unit INTEGER,
                        fee_paid INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO dividends VALUES(10,'4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3',310009,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB','XUP',600,20000,'valid');
  INSERT INTO dividends VALUES(11,'2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7',310010,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC','XUP',800,20000,'valid');
  -- Triggers and indices on  dividends
  CREATE TRIGGER _dividends_delete BEFORE DELETE ON dividends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO dividends(rowid,tx_index,tx_hash,block_index,source,asset,dividend_asset,quantity_per_unit,fee_paid,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.asset)||','||quote(old.dividend_asset)||','||quote(old.quantity_per_unit)||','||quote(old.fee_paid)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _dividends_insert AFTER INSERT ON dividends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM dividends WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _dividends_update AFTER UPDATE ON dividends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE dividends SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',asset='||quote(old.asset)||',dividend_asset='||quote(old.dividend_asset)||',quantity_per_unit='||quote(old.quantity_per_unit)||',fee_paid='||quote(old.fee_paid)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  issuances
  DROP TABLE IF EXISTS issuances;
  CREATE TABLE "issuances"(
                                tx_index INTEGER,
                                tx_hash TEXT,
                                msg_index INTEGER DEFAULT 0,
                                block_index INTEGER,
                                asset TEXT,
                                quantity INTEGER,
                                divisible BOOL,
                                source TEXT,
                                issuer TEXT,
                                transfer BOOL,
                                callable BOOL,
                                call_date INTEGER,
                                call_price REAL,
                                description TEXT,
                                fee_paid INTEGER,
                                locked BOOL,
                                status TEXT,
                                asset_longname TEXT,
                                PRIMARY KEY (tx_index, msg_index),
                                FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                                UNIQUE (tx_hash, msg_index));
  INSERT INTO issuances VALUES(6,'ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975',0,310005,'BBBB',1000000000,1,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,0,0,0.0,'',50000000,0,'valid',NULL);
  INSERT INTO issuances VALUES(7,'b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06',0,310006,'BBBC',100000,0,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,0,0,0.0,'foobar',50000000,0,'valid',NULL);
  -- Triggers and indices on  issuances
  CREATE TRIGGER _issuances_delete BEFORE DELETE ON issuances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO issuances(rowid,tx_index,tx_hash,msg_index,block_index,asset,quantity,divisible,source,issuer,transfer,callable,call_date,call_price,description,fee_paid,locked,status,asset_longname) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.msg_index)||','||quote(old.block_index)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.divisible)||','||quote(old.source)||','||quote(old.issuer)||','||quote(old.transfer)||','||quote(old.callable)||','||quote(old.call_date)||','||quote(old.call_price)||','||quote(old.description)||','||quote(old.fee_paid)||','||quote(old.locked)||','||quote(old.status)||','||quote(old.asset_longname)||')');
                              END;
  CREATE TRIGGER _issuances_insert AFTER INSERT ON issuances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM issuances WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _issuances_update AFTER UPDATE ON issuances BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE issuances SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',msg_index='||quote(old.msg_index)||',block_index='||quote(old.block_index)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',divisible='||quote(old.divisible)||',source='||quote(old.source)||',issuer='||quote(old.issuer)||',transfer='||quote(old.transfer)||',callable='||quote(old.callable)||',call_date='||quote(old.call_date)||',call_price='||quote(old.call_price)||',description='||quote(old.description)||',fee_paid='||quote(old.fee_paid)||',locked='||quote(old.locked)||',status='||quote(old.status)||',asset_longname='||quote(old.asset_longname)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX valid_asset_idx ON issuances (asset, status);
  
  -- Table  mempool
  DROP TABLE IF EXISTS mempool;
  CREATE TABLE mempool(
                        tx_hash TEXT,
                        command TEXT,
                        category TEXT,
                        bindings TEXT,
                        timestamp INTEGER);
  
  -- Table  messages
  DROP TABLE IF EXISTS messages;
  CREATE TABLE messages(
                        message_index INTEGER PRIMARY KEY,
                        block_index INTEGER,
                        command TEXT,
                        category TEXT,
                        bindings TEXT,
                        timestamp INTEGER);
  INSERT INTO messages VALUES(0,310000,'insert','credits','{"action": "burn", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310000, "event": "5fde1c728d8d00aaa1b5f8dae963ceb4fd30c415eb0b8a982ba2d8d676fec0bb", "quantity": 93000000000}',0);
  INSERT INTO messages VALUES(1,310000,'insert','burns','{"block_index": 310000, "burned": 62000000, "earned": 93000000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "5fde1c728d8d00aaa1b5f8dae963ceb4fd30c415eb0b8a982ba2d8d676fec0bb", "tx_index": 1}',0);
  INSERT INTO messages VALUES(2,310001,'insert','debits','{"action": "send", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310001, "event": "63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(3,310001,'insert','credits','{"action": "send", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310001, "event": "63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(4,310001,'insert','sends','{"asset": "XUP", "block_index": 310001, "destination": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 50000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc", "tx_index": 2}',0);
  INSERT INTO messages VALUES(5,310002,'insert','orders','{"block_index": 310002, "expiration": 10, "expire_index": 310012, "fee_provided": 1000000, "fee_provided_remaining": 1000000, "fee_required": 0, "fee_required_remaining": 0, "get_asset": "XUP", "get_quantity": 100000000, "get_remaining": 100000000, "give_asset": "BTC", "give_quantity": 50000000, "give_remaining": 50000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e", "tx_index": 3}',0);
  INSERT INTO messages VALUES(6,310003,'insert','debits','{"action": "open order", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310003, "event": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "quantity": 105000000}',0);
  INSERT INTO messages VALUES(7,310003,'insert','orders','{"block_index": 310003, "expiration": 10, "expire_index": 310013, "fee_provided": 6800, "fee_provided_remaining": 6800, "fee_required": 900000, "fee_required_remaining": 900000, "get_asset": "BTC", "get_quantity": 50000000, "get_remaining": 50000000, "give_asset": "XUP", "give_quantity": 105000000, "give_remaining": 105000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "tx_index": 4}',0);
  INSERT INTO messages VALUES(8,310003,'update','orders','{"fee_provided_remaining": 142858, "fee_required_remaining": 0, "get_remaining": 0, "give_remaining": 0, "status": "open", "tx_hash": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e"}',0);
  INSERT INTO messages VALUES(9,310003,'update','orders','{"fee_provided_remaining": 6800, "fee_required_remaining": 42858, "get_remaining": 0, "give_remaining": 5000000, "status": "open", "tx_hash": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1"}',0);
  INSERT INTO messages VALUES(10,310003,'insert','order_matches','{"backward_asset": "XUP", "backward_quantity": 100000000, "block_index": 310003, "fee_paid": 857142, "forward_asset": "BTC", "forward_quantity": 50000000, "id": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "match_expire_index": 310023, "status": "pending", "tx0_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_block_index": 310002, "tx0_expiration": 10, "tx0_hash": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e", "tx0_index": 3, "tx1_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_block_index": 310003, "tx1_expiration": 10, "tx1_hash": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "tx1_index": 4}',0);
  INSERT INTO messages VALUES(11,310004,'insert','credits','{"action": "btcpay", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310004, "event": "f307fdf5e231e05f9e9ecf23e5fc8bfff87951b223575840690b3f8bb502ad0f", "quantity": 100000000}',0);
  INSERT INTO messages VALUES(12,310004,'update','order_matches','{"order_match_id": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "status": "completed"}',0);
  INSERT INTO messages VALUES(13,310004,'insert','btcpays','{"block_index": 310004, "btc_amount": 50000000, "destination": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "order_match_id": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "f307fdf5e231e05f9e9ecf23e5fc8bfff87951b223575840690b3f8bb502ad0f", "tx_index": 5}',0);
  INSERT INTO messages VALUES(14,310005,'insert','debits','{"action": "issuance fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310005, "event": "ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(15,310005,'insert','issuances','{"asset": "BBBB", "asset_longname": null, "block_index": 310005, "call_date": 0, "call_price": 0.0, "callable": false, "description": "", "divisible": true, "fee_paid": 50000000, "issuer": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "locked": false, "quantity": 1000000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "transfer": false, "tx_hash": "ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975", "tx_index": 6}',0);
  INSERT INTO messages VALUES(16,310005,'insert','credits','{"action": "issuance", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310005, "event": "ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975", "quantity": 1000000000}',0);
  INSERT INTO messages VALUES(17,310006,'insert','debits','{"action": "issuance fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310006, "event": "b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(18,310006,'insert','issuances','{"asset": "BBBC", "asset_longname": null, "block_index": 310006, "call_date": 0, "call_price": 0.0, "callable": false, "description": "foobar", "divisible": false, "fee_paid": 50000000, "issuer": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "locked": false, "quantity": 100000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "transfer": false, "tx_hash": "b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06", "tx_index": 7}',0);
  INSERT INTO messages VALUES(19,310006,'insert','credits','{"action": "issuance", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310006, "event": "b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06", "quantity": 100000}',0);
  INSERT INTO messages VALUES(20,310007,'insert','debits','{"action": "send", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310007, "event": "cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(21,310007,'insert','credits','{"action": "send", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310007, "event": "cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(22,310007,'insert','sends','{"asset": "BBBB", "block_index": 310007, "destination": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 4000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab", "tx_index": 8}',0);
  INSERT INTO messages VALUES(23,310008,'insert','debits','{"action": "send", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310008, "event": "0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89", "quantity": 526}',0);
  INSERT INTO messages VALUES(24,310008,'insert','credits','{"action": "send", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310008, "event": "0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89", "quantity": 526}',0);
  INSERT INTO messages VALUES(25,310008,'insert','sends','{"asset": "BBBC", "block_index": 310008, "destination": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 526, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89", "tx_index": 9}',0);
  INSERT INTO messages VALUES(26,310009,'insert','debits','{"action": "dividend", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3", "quantity": 24}',0);
  INSERT INTO messages VALUES(27,310009,'insert','debits','{"action": "dividend fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3", "quantity": 20000}',0);
  INSERT INTO messages VALUES(28,310009,'insert','credits','{"action": "dividend", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3", "quantity": 24}',0);
  INSERT INTO messages VALUES(29,310009,'insert','dividends','{"asset": "BBBB", "block_index": 310009, "dividend_asset": "XUP", "fee_paid": 20000, "quantity_per_unit": 600, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3", "tx_index": 10}',0);
  INSERT INTO messages VALUES(30,310010,'insert','debits','{"action": "dividend", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7", "quantity": 420800}',0);
  INSERT INTO messages VALUES(31,310010,'insert','debits','{"action": "dividend fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7", "quantity": 20000}',0);
  INSERT INTO messages VALUES(32,310010,'insert','credits','{"action": "dividend", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7", "quantity": 420800}',0);
  INSERT INTO messages VALUES(33,310010,'insert','dividends','{"asset": "BBBC", "block_index": 310010, "dividend_asset": "XUP", "fee_paid": 20000, "quantity_per_unit": 800, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7", "tx_index": 11}',0);
  INSERT INTO messages VALUES(34,310011,'insert','broadcasts','{"block_index": 310011, "fee_fraction_int": 99999999, "locked": false, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000000, "tx_hash": "fb70fe2fe539e5ed1950885c3385ecb01d27ccfd583c6dff94006b3a55866e72", "tx_index": 12, "value": 100.0}',0);
  INSERT INTO messages VALUES(35,310012,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310012, "event": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(36,310012,'insert','bets','{"bet_type": 0, "block_index": 310012, "counterwager_quantity": 25000000, "counterwager_remaining": 25000000, "deadline": 1388000100, "expiration": 10, "expire_index": 310022, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 15120, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "tx_index": 13, "wager_quantity": 50000000, "wager_remaining": 50000000}',0);
  INSERT INTO messages VALUES(37,310013,'update','orders','{"status": "expired", "tx_hash": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e"}',0);
  INSERT INTO messages VALUES(38,310013,'insert','order_expirations','{"block_index": 310013, "order_hash": "82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e", "order_index": 3, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(39,310013,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310013, "event": "08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "quantity": 25000000}',0);
  INSERT INTO messages VALUES(40,310013,'insert','bets','{"bet_type": 1, "block_index": 310013, "counterwager_quantity": 41500000, "counterwager_remaining": 41500000, "deadline": 1388000100, "expiration": 10, "expire_index": 310023, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 15120, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "tx_index": 14, "wager_quantity": 25000000, "wager_remaining": 25000000}',0);
  INSERT INTO messages VALUES(41,310013,'update','bets','{"counterwager_remaining": 4250000, "status": "open", "tx_hash": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "wager_remaining": 8500000}',0);
  INSERT INTO messages VALUES(42,310013,'insert','credits','{"action": "filled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310013, "event": "08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "quantity": 4250000}',0);
  INSERT INTO messages VALUES(43,310013,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "wager_remaining": 4250000}',0);
  INSERT INTO messages VALUES(44,310013,'insert','bet_matches','{"backward_quantity": 20750000, "block_index": 310013, "deadline": 1388000100, "fee_fraction_int": 99999999, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 41500000, "id": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "initial_value": 100.0, "leverage": 15120, "match_expire_index": 310022, "status": "pending", "target_value": 0.0, "tx0_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 0, "tx0_block_index": 310012, "tx0_expiration": 10, "tx0_hash": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "tx0_index": 13, "tx1_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 1, "tx1_block_index": 310013, "tx1_expiration": 10, "tx1_hash": "08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "tx1_index": 14}',0);
  INSERT INTO messages VALUES(45,310014,'update','orders','{"status": "expired", "tx_hash": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1"}',0);
  INSERT INTO messages VALUES(46,310014,'insert','credits','{"action": "cancel order", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310014, "event": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "quantity": 5000000}',0);
  INSERT INTO messages VALUES(47,310014,'insert','order_expirations','{"block_index": 310014, "order_hash": "371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1", "order_index": 4, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(48,310014,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310014, "event": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68", "quantity": 150000000}',0);
  INSERT INTO messages VALUES(49,310014,'insert','bets','{"bet_type": 0, "block_index": 310014, "counterwager_quantity": 350000000, "counterwager_remaining": 350000000, "deadline": 1388000100, "expiration": 10, "expire_index": 310024, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68", "tx_index": 15, "wager_quantity": 150000000, "wager_remaining": 150000000}',0);
  INSERT INTO messages VALUES(50,310015,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "quantity": 350000000}',0);
  INSERT INTO messages VALUES(51,310015,'insert','bets','{"bet_type": 1, "block_index": 310015, "counterwager_quantity": 150000000, "counterwager_remaining": 150000000, "deadline": 1388000100, "expiration": 10, "expire_index": 310025, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "tx_index": 16, "wager_quantity": 350000000, "wager_remaining": 350000000}',0);
  INSERT INTO messages VALUES(52,310015,'insert','credits','{"action": "filled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "quantity": 0}',0);
  INSERT INTO messages VALUES(53,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(54,310015,'insert','credits','{"action": "filled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "quantity": 0}',0);
  INSERT INTO messages VALUES(55,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(56,310015,'insert','bet_matches','{"backward_quantity": 350000000, "block_index": 310015, "deadline": 1388000100, "fee_fraction_int": 99999999, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 150000000, "id": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310024, "status": "pending", "target_value": 0.0, "tx0_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 0, "tx0_block_index": 310014, "tx0_expiration": 10, "tx0_hash": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68", "tx0_index": 15, "tx1_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 1, "tx1_block_index": 310015, "tx1_expiration": 10, "tx1_hash": "75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "tx1_index": 16}',0);
  INSERT INTO messages VALUES(57,310016,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310016, "event": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644", "quantity": 750000000}',0);
  INSERT INTO messages VALUES(58,310016,'insert','bets','{"bet_type": 2, "block_index": 310016, "counterwager_quantity": 650000000, "counterwager_remaining": 650000000, "deadline": 1388000200, "expiration": 10, "expire_index": 310026, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 1.0, "tx_hash": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644", "tx_index": 17, "wager_quantity": 750000000, "wager_remaining": 750000000}',0);
  INSERT INTO messages VALUES(59,310017,'insert','debits','{"action": "bet", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "quantity": 650000000}',0);
  INSERT INTO messages VALUES(60,310017,'insert','bets','{"bet_type": 3, "block_index": 310017, "counterwager_quantity": 750000000, "counterwager_remaining": 750000000, "deadline": 1388000200, "expiration": 10, "expire_index": 310027, "fee_fraction_int": 99999999.0, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 1.0, "tx_hash": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "tx_index": 18, "wager_quantity": 650000000, "wager_remaining": 650000000}',0);
  INSERT INTO messages VALUES(61,310017,'insert','credits','{"action": "filled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "quantity": 0}',0);
  INSERT INTO messages VALUES(62,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(63,310017,'insert','credits','{"action": "filled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "quantity": 0}',0);
  INSERT INTO messages VALUES(64,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(65,310017,'insert','bet_matches','{"backward_quantity": 650000000, "block_index": 310017, "deadline": 1388000200, "fee_fraction_int": 99999999, "feed_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 750000000, "id": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310026, "status": "pending", "target_value": 1.0, "tx0_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 2, "tx0_block_index": 310016, "tx0_expiration": 10, "tx0_hash": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644", "tx0_index": 17, "tx1_address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 3, "tx1_block_index": 310017, "tx1_expiration": 10, "tx1_hash": "4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "tx1_index": 18}',0);
  INSERT INTO messages VALUES(66,310018,'insert','broadcasts','{"block_index": 310018, "fee_fraction_int": 5000000, "locked": false, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000050, "tx_hash": "3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452", "tx_index": 19, "value": 99.86166}',0);
  INSERT INTO messages VALUES(67,310018,'insert','credits','{"action": "bet settled: liquidated for bear", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310018, "event": "3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452", "quantity": 59137500}',0);
  INSERT INTO messages VALUES(68,310018,'insert','credits','{"action": "feed fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310018, "event": "3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452", "quantity": 3112500}',0);
  INSERT INTO messages VALUES(69,310018,'insert','bet_match_resolutions','{"bear_credit": 59137500, "bet_match_id": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "bet_match_type_id": 1, "block_index": 310018, "bull_credit": 0, "escrow_less_fee": null, "fee": 3112500, "settled": false, "winner": null}',0);
  INSERT INTO messages VALUES(70,310018,'update','bet_matches','{"bet_match_id": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12", "status": "settled: liquidated for bear"}',0);
  INSERT INTO messages VALUES(71,310019,'insert','broadcasts','{"block_index": 310019, "fee_fraction_int": 5000000, "locked": false, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000101, "tx_hash": "f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f", "tx_index": 20, "value": 100.343}',0);
  INSERT INTO messages VALUES(72,310019,'insert','credits','{"action": "bet settled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f", "quantity": 159300000}',0);
  INSERT INTO messages VALUES(73,310019,'insert','credits','{"action": "bet settled", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f", "quantity": 315700000}',0);
  INSERT INTO messages VALUES(74,310019,'insert','credits','{"action": "feed fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f", "quantity": 25000000}',0);
  INSERT INTO messages VALUES(75,310019,'insert','bet_match_resolutions','{"bear_credit": 315700000, "bet_match_id": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "bet_match_type_id": 1, "block_index": 310019, "bull_credit": 159300000, "escrow_less_fee": null, "fee": 25000000, "settled": true, "winner": null}',0);
  INSERT INTO messages VALUES(76,310019,'update','bet_matches','{"bet_match_id": "3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572", "status": "settled"}',0);
  INSERT INTO messages VALUES(77,310020,'insert','broadcasts','{"block_index": 310020, "fee_fraction_int": 5000000, "locked": false, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000201, "tx_hash": "63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3", "tx_index": 21, "value": 2.0}',0);
  INSERT INTO messages VALUES(78,310020,'insert','credits','{"action": "bet settled: for notequal", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310020, "event": "63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3", "quantity": 1330000000}',0);
  INSERT INTO messages VALUES(79,310020,'insert','credits','{"action": "feed fee", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310020, "event": "63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3", "quantity": 70000000}',0);
  INSERT INTO messages VALUES(80,310020,'insert','bet_match_resolutions','{"bear_credit": null, "bet_match_id": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "bet_match_type_id": 5, "block_index": 310020, "bull_credit": null, "escrow_less_fee": 1330000000, "fee": 70000000, "settled": null, "winner": "NotEqual"}',0);
  INSERT INTO messages VALUES(81,310020,'update','bet_matches','{"bet_match_id": "674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9", "status": "settled: for notequal"}',0);
  INSERT INTO messages VALUES(82,310021,'insert','debits','{"action": "open order", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310021, "event": "dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(83,310021,'insert','orders','{"block_index": 310021, "expiration": 10, "expire_index": 310031, "fee_provided": 6800, "fee_provided_remaining": 6800, "fee_required": 0, "fee_required_remaining": 0, "get_asset": "XUP", "get_quantity": 50000000, "get_remaining": 50000000, "give_asset": "BBBB", "give_quantity": 50000000, "give_remaining": 50000000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41", "tx_index": 22}',0);
  INSERT INTO messages VALUES(84,310022,'insert','credits','{"action": "burn", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310022, "event": "df080a76ceb263201901bc23c85c3e8dce4eca0e72c873131adaf2f46820e9f1", "quantity": 56999887262}',0);
  INSERT INTO messages VALUES(85,310022,'insert','burns','{"block_index": 310022, "burned": 38000000, "earned": 56999887262, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "df080a76ceb263201901bc23c85c3e8dce4eca0e72c873131adaf2f46820e9f1", "tx_index": 23}',0);
  INSERT INTO messages VALUES(86,310023,'update','bets','{"status": "expired", "tx_hash": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b"}',0);
  INSERT INTO messages VALUES(87,310023,'insert','credits','{"action": "recredit wager remaining", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310023, "event": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "quantity": 8500000}',0);
  INSERT INTO messages VALUES(88,310023,'insert','bet_expirations','{"bet_hash": "44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b", "bet_index": 13, "block_index": 310023, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(89,310023,'insert','debits','{"action": "send", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310023, "event": "ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca", "quantity": 10000}',0);
  INSERT INTO messages VALUES(90,310023,'insert','credits','{"action": "send", "address": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310023, "event": "ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca", "quantity": 10000}',0);
  INSERT INTO messages VALUES(91,310023,'insert','sends','{"asset": "BBBC", "block_index": 310023, "destination": "2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 10000, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca", "tx_index": 24}',0);
  INSERT INTO messages VALUES(92,310032,'update','orders','{"status": "expired", "tx_hash": "dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41"}',0);
  INSERT INTO messages VALUES(93,310032,'insert','credits','{"action": "cancel order", "address": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310032, "event": "dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(94,310032,'insert','order_expirations','{"block_index": 310032, "order_hash": "dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41", "order_index": 22, "source": "2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  -- Triggers and indices on  messages
  CREATE INDEX block_index_message_index_idx ON messages (block_index, message_index);
  
  -- Table  order_expirations
  DROP TABLE IF EXISTS order_expirations;
  CREATE TABLE order_expirations(
                        order_index INTEGER PRIMARY KEY,
                        order_hash TEXT UNIQUE,
                        source TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index),
                        FOREIGN KEY (order_index, order_hash) REFERENCES orders(tx_index, tx_hash));
  INSERT INTO order_expirations VALUES(3,'82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310013);
  INSERT INTO order_expirations VALUES(4,'371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310014);
  INSERT INTO order_expirations VALUES(22,'dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310032);
  -- Triggers and indices on  order_expirations
  CREATE TRIGGER _order_expirations_delete BEFORE DELETE ON order_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO order_expirations(rowid,order_index,order_hash,source,block_index) VALUES('||old.rowid||','||quote(old.order_index)||','||quote(old.order_hash)||','||quote(old.source)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _order_expirations_insert AFTER INSERT ON order_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM order_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _order_expirations_update AFTER UPDATE ON order_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE order_expirations SET order_index='||quote(old.order_index)||',order_hash='||quote(old.order_hash)||',source='||quote(old.source)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  order_match_expirations
  DROP TABLE IF EXISTS order_match_expirations;
  CREATE TABLE order_match_expirations(
                        order_match_id TEXT PRIMARY KEY,
                        tx0_address TEXT,
                        tx1_address TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (order_match_id) REFERENCES order_matches(id),
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  -- Triggers and indices on  order_match_expirations
  CREATE TRIGGER _order_match_expirations_delete BEFORE DELETE ON order_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO order_match_expirations(rowid,order_match_id,tx0_address,tx1_address,block_index) VALUES('||old.rowid||','||quote(old.order_match_id)||','||quote(old.tx0_address)||','||quote(old.tx1_address)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _order_match_expirations_insert AFTER INSERT ON order_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM order_match_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _order_match_expirations_update AFTER UPDATE ON order_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE order_match_expirations SET order_match_id='||quote(old.order_match_id)||',tx0_address='||quote(old.tx0_address)||',tx1_address='||quote(old.tx1_address)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  order_matches
  DROP TABLE IF EXISTS order_matches;
  CREATE TABLE order_matches(
                        id TEXT PRIMARY KEY,
                        tx0_index INTEGER,
                        tx0_hash TEXT,
                        tx0_address TEXT,
                        tx1_index INTEGER,
                        tx1_hash TEXT,
                        tx1_address TEXT,
                        forward_asset TEXT,
                        forward_quantity INTEGER,
                        backward_asset TEXT,
                        backward_quantity INTEGER,
                        tx0_block_index INTEGER,
                        tx1_block_index INTEGER,
                        block_index INTEGER,
                        tx0_expiration INTEGER,
                        tx1_expiration INTEGER,
                        match_expire_index INTEGER,
                        fee_paid INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx0_index, tx0_hash, tx0_block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        FOREIGN KEY (tx1_index, tx1_hash, tx1_block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO order_matches VALUES('82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1',3,'82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',4,'371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UNO',50000000,'XUP',100000000,310002,310003,310003,10,10,310023,857142,'completed');
  -- Triggers and indices on  order_matches
  CREATE TRIGGER _order_matches_delete BEFORE DELETE ON order_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO order_matches(rowid,id,tx0_index,tx0_hash,tx0_address,tx1_index,tx1_hash,tx1_address,forward_asset,forward_quantity,backward_asset,backward_quantity,tx0_block_index,tx1_block_index,block_index,tx0_expiration,tx1_expiration,match_expire_index,fee_paid,status) VALUES('||old.rowid||','||quote(old.id)||','||quote(old.tx0_index)||','||quote(old.tx0_hash)||','||quote(old.tx0_address)||','||quote(old.tx1_index)||','||quote(old.tx1_hash)||','||quote(old.tx1_address)||','||quote(old.forward_asset)||','||quote(old.forward_quantity)||','||quote(old.backward_asset)||','||quote(old.backward_quantity)||','||quote(old.tx0_block_index)||','||quote(old.tx1_block_index)||','||quote(old.block_index)||','||quote(old.tx0_expiration)||','||quote(old.tx1_expiration)||','||quote(old.match_expire_index)||','||quote(old.fee_paid)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _order_matches_insert AFTER INSERT ON order_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM order_matches WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _order_matches_update AFTER UPDATE ON order_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE order_matches SET id='||quote(old.id)||',tx0_index='||quote(old.tx0_index)||',tx0_hash='||quote(old.tx0_hash)||',tx0_address='||quote(old.tx0_address)||',tx1_index='||quote(old.tx1_index)||',tx1_hash='||quote(old.tx1_hash)||',tx1_address='||quote(old.tx1_address)||',forward_asset='||quote(old.forward_asset)||',forward_quantity='||quote(old.forward_quantity)||',backward_asset='||quote(old.backward_asset)||',backward_quantity='||quote(old.backward_quantity)||',tx0_block_index='||quote(old.tx0_block_index)||',tx1_block_index='||quote(old.tx1_block_index)||',block_index='||quote(old.block_index)||',tx0_expiration='||quote(old.tx0_expiration)||',tx1_expiration='||quote(old.tx1_expiration)||',match_expire_index='||quote(old.match_expire_index)||',fee_paid='||quote(old.fee_paid)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX backward_status_idx ON order_matches (backward_asset, status);
  CREATE INDEX forward_status_idx ON order_matches (forward_asset, status);
  CREATE INDEX match_expire_idx ON order_matches (status, match_expire_index);
  CREATE INDEX tx0_address_idx ON order_matches (tx0_address);
  CREATE INDEX tx1_address_idx ON order_matches (tx1_address);
  
  -- Table  orders
  DROP TABLE IF EXISTS orders;
  CREATE TABLE orders(
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        give_asset TEXT,
                        give_quantity INTEGER,
                        give_remaining INTEGER,
                        get_asset TEXT,
                        get_quantity INTEGER,
                        get_remaining INTEGER,
                        expiration INTEGER,
                        expire_index INTEGER,
                        fee_required INTEGER,
                        fee_required_remaining INTEGER,
                        fee_provided INTEGER,
                        fee_provided_remaining INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        PRIMARY KEY (tx_index, tx_hash));
  INSERT INTO orders VALUES(3,'82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e',310002,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UNO',50000000,0,'XUP',100000000,0,10,310012,0,0,1000000,142858,'expired');
  INSERT INTO orders VALUES(4,'371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1',310003,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',105000000,5000000,'UNO',50000000,0,10,310013,900000,42858,6800,6800,'expired');
  INSERT INTO orders VALUES(22,'dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41',310021,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',50000000,50000000,'XUP',50000000,50000000,10,310031,0,0,6800,6800,'expired');
  -- Triggers and indices on  orders
  CREATE TRIGGER _orders_delete BEFORE DELETE ON orders BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO orders(rowid,tx_index,tx_hash,block_index,source,give_asset,give_quantity,give_remaining,get_asset,get_quantity,get_remaining,expiration,expire_index,fee_required,fee_required_remaining,fee_provided,fee_provided_remaining,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.give_asset)||','||quote(old.give_quantity)||','||quote(old.give_remaining)||','||quote(old.get_asset)||','||quote(old.get_quantity)||','||quote(old.get_remaining)||','||quote(old.expiration)||','||quote(old.expire_index)||','||quote(old.fee_required)||','||quote(old.fee_required_remaining)||','||quote(old.fee_provided)||','||quote(old.fee_provided_remaining)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _orders_insert AFTER INSERT ON orders BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM orders WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _orders_update AFTER UPDATE ON orders BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE orders SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',give_asset='||quote(old.give_asset)||',give_quantity='||quote(old.give_quantity)||',give_remaining='||quote(old.give_remaining)||',get_asset='||quote(old.get_asset)||',get_quantity='||quote(old.get_quantity)||',get_remaining='||quote(old.get_remaining)||',expiration='||quote(old.expiration)||',expire_index='||quote(old.expire_index)||',fee_required='||quote(old.fee_required)||',fee_required_remaining='||quote(old.fee_required_remaining)||',fee_provided='||quote(old.fee_provided)||',fee_provided_remaining='||quote(old.fee_provided_remaining)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX expire_idx ON orders (expire_index, status);
  CREATE INDEX give_asset_idx ON orders (give_asset);
  CREATE INDEX give_get_status_idx ON orders (get_asset, give_asset, status);
  CREATE INDEX give_status_idx ON orders (give_asset, status);
  CREATE INDEX source_give_status_idx ON orders (source, give_asset, status);
  
  -- Table  rps
  DROP TABLE IF EXISTS rps;
  CREATE TABLE rps(
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        possible_moves INTEGER,
                        wager INTEGER,
                        move_random_hash TEXT,
                        expiration INTEGER,
                        expire_index INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        PRIMARY KEY (tx_index, tx_hash));
  -- Triggers and indices on  rps
  CREATE TRIGGER _rps_delete BEFORE DELETE ON rps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO rps(rowid,tx_index,tx_hash,block_index,source,possible_moves,wager,move_random_hash,expiration,expire_index,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.possible_moves)||','||quote(old.wager)||','||quote(old.move_random_hash)||','||quote(old.expiration)||','||quote(old.expire_index)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _rps_insert AFTER INSERT ON rps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM rps WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _rps_update AFTER UPDATE ON rps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE rps SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',possible_moves='||quote(old.possible_moves)||',wager='||quote(old.wager)||',move_random_hash='||quote(old.move_random_hash)||',expiration='||quote(old.expiration)||',expire_index='||quote(old.expire_index)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX matching_idx ON rps (wager, possible_moves);
  
  -- Table  rps_expirations
  DROP TABLE IF EXISTS rps_expirations;
  CREATE TABLE rps_expirations(
                        rps_index INTEGER PRIMARY KEY,
                        rps_hash TEXT UNIQUE,
                        source TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index),
                        FOREIGN KEY (rps_index, rps_hash) REFERENCES rps(tx_index, tx_hash));
  -- Triggers and indices on  rps_expirations
  CREATE TRIGGER _rps_expirations_delete BEFORE DELETE ON rps_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO rps_expirations(rowid,rps_index,rps_hash,source,block_index) VALUES('||old.rowid||','||quote(old.rps_index)||','||quote(old.rps_hash)||','||quote(old.source)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _rps_expirations_insert AFTER INSERT ON rps_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM rps_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _rps_expirations_update AFTER UPDATE ON rps_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE rps_expirations SET rps_index='||quote(old.rps_index)||',rps_hash='||quote(old.rps_hash)||',source='||quote(old.source)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  rps_match_expirations
  DROP TABLE IF EXISTS rps_match_expirations;
  CREATE TABLE rps_match_expirations(
                        rps_match_id TEXT PRIMARY KEY,
                        tx0_address TEXT,
                        tx1_address TEXT,
                        block_index INTEGER,
                        FOREIGN KEY (rps_match_id) REFERENCES rps_matches(id),
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  -- Triggers and indices on  rps_match_expirations
  CREATE TRIGGER _rps_match_expirations_delete BEFORE DELETE ON rps_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO rps_match_expirations(rowid,rps_match_id,tx0_address,tx1_address,block_index) VALUES('||old.rowid||','||quote(old.rps_match_id)||','||quote(old.tx0_address)||','||quote(old.tx1_address)||','||quote(old.block_index)||')');
                              END;
  CREATE TRIGGER _rps_match_expirations_insert AFTER INSERT ON rps_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM rps_match_expirations WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _rps_match_expirations_update AFTER UPDATE ON rps_match_expirations BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE rps_match_expirations SET rps_match_id='||quote(old.rps_match_id)||',tx0_address='||quote(old.tx0_address)||',tx1_address='||quote(old.tx1_address)||',block_index='||quote(old.block_index)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  rps_matches
  DROP TABLE IF EXISTS rps_matches;
  CREATE TABLE rps_matches(
                        id TEXT PRIMARY KEY,
                        tx0_index INTEGER,
                        tx0_hash TEXT,
                        tx0_address TEXT,
                        tx1_index INTEGER,
                        tx1_hash TEXT,
                        tx1_address TEXT,
                        tx0_move_random_hash TEXT,
                        tx1_move_random_hash TEXT,
                        wager INTEGER,
                        possible_moves INTEGER,
                        tx0_block_index INTEGER,
                        tx1_block_index INTEGER,
                        block_index INTEGER,
                        tx0_expiration INTEGER,
                        tx1_expiration INTEGER,
                        match_expire_index INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx0_index, tx0_hash, tx0_block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                        FOREIGN KEY (tx1_index, tx1_hash, tx1_block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  rps_matches
  CREATE TRIGGER _rps_matches_delete BEFORE DELETE ON rps_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO rps_matches(rowid,id,tx0_index,tx0_hash,tx0_address,tx1_index,tx1_hash,tx1_address,tx0_move_random_hash,tx1_move_random_hash,wager,possible_moves,tx0_block_index,tx1_block_index,block_index,tx0_expiration,tx1_expiration,match_expire_index,status) VALUES('||old.rowid||','||quote(old.id)||','||quote(old.tx0_index)||','||quote(old.tx0_hash)||','||quote(old.tx0_address)||','||quote(old.tx1_index)||','||quote(old.tx1_hash)||','||quote(old.tx1_address)||','||quote(old.tx0_move_random_hash)||','||quote(old.tx1_move_random_hash)||','||quote(old.wager)||','||quote(old.possible_moves)||','||quote(old.tx0_block_index)||','||quote(old.tx1_block_index)||','||quote(old.block_index)||','||quote(old.tx0_expiration)||','||quote(old.tx1_expiration)||','||quote(old.match_expire_index)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _rps_matches_insert AFTER INSERT ON rps_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM rps_matches WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _rps_matches_update AFTER UPDATE ON rps_matches BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE rps_matches SET id='||quote(old.id)||',tx0_index='||quote(old.tx0_index)||',tx0_hash='||quote(old.tx0_hash)||',tx0_address='||quote(old.tx0_address)||',tx1_index='||quote(old.tx1_index)||',tx1_hash='||quote(old.tx1_hash)||',tx1_address='||quote(old.tx1_address)||',tx0_move_random_hash='||quote(old.tx0_move_random_hash)||',tx1_move_random_hash='||quote(old.tx1_move_random_hash)||',wager='||quote(old.wager)||',possible_moves='||quote(old.possible_moves)||',tx0_block_index='||quote(old.tx0_block_index)||',tx1_block_index='||quote(old.tx1_block_index)||',block_index='||quote(old.block_index)||',tx0_expiration='||quote(old.tx0_expiration)||',tx1_expiration='||quote(old.tx1_expiration)||',match_expire_index='||quote(old.match_expire_index)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX rps_match_expire_idx ON rps_matches (status, match_expire_index);
  CREATE INDEX rps_tx0_address_idx ON rps_matches (tx0_address);
  CREATE INDEX rps_tx1_address_idx ON rps_matches (tx1_address);
  
  -- Table  rpsresolves
  DROP TABLE IF EXISTS rpsresolves;
  CREATE TABLE rpsresolves(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        move INTEGER,
                        random TEXT,
                        rps_match_id TEXT,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  rpsresolves
  CREATE TRIGGER _rpsresolves_delete BEFORE DELETE ON rpsresolves BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO rpsresolves(rowid,tx_index,tx_hash,block_index,source,move,random,rps_match_id,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.move)||','||quote(old.random)||','||quote(old.rps_match_id)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _rpsresolves_insert AFTER INSERT ON rpsresolves BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM rpsresolves WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _rpsresolves_update AFTER UPDATE ON rpsresolves BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE rpsresolves SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',move='||quote(old.move)||',random='||quote(old.random)||',rps_match_id='||quote(old.rps_match_id)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX rps_match_id_idx ON rpsresolves (rps_match_id);
  
  -- Table  sends
  DROP TABLE IF EXISTS sends;
  CREATE TABLE "sends"(
                                tx_index INTEGER,
                                tx_hash TEXT,
                                block_index INTEGER,
                                source TEXT,
                                destination TEXT,
                                asset TEXT,
                                quantity INTEGER,
                                status TEXT,
                                msg_index INTEGER DEFAULT 0, memo BLOB,
                                PRIMARY KEY (tx_index, msg_index),
                                FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index),
                                UNIQUE (tx_hash, msg_index) ON CONFLICT FAIL);
  INSERT INTO sends VALUES(2,'63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc',310001,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'valid',0,NULL);
  INSERT INTO sends VALUES(8,'cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab',310007,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'valid',0,NULL);
  INSERT INTO sends VALUES(9,'0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89',310008,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'valid',0,NULL);
  INSERT INTO sends VALUES(24,'ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca',310023,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10000,'valid',0,NULL);
  -- Triggers and indices on  sends
  CREATE TRIGGER _sends_delete BEFORE DELETE ON sends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO sends(rowid,tx_index,tx_hash,block_index,source,destination,asset,quantity,status,msg_index,memo) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.destination)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.status)||','||quote(old.msg_index)||','||quote(old.memo)||')');
                              END;
  CREATE TRIGGER _sends_insert AFTER INSERT ON sends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM sends WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _sends_update AFTER UPDATE ON sends BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE sends SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',destination='||quote(old.destination)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',status='||quote(old.status)||',msg_index='||quote(old.msg_index)||',memo='||quote(old.memo)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX destination_idx ON sends (destination);
  CREATE INDEX memo_idx ON sends (memo);
  CREATE INDEX source_idx ON sends (source);
  
  -- Table  sweeps
  DROP TABLE IF EXISTS sweeps;
  CREATE TABLE sweeps(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        destination TEXT,
                        flags INTEGER,
                        status TEXT,
                        memo BLOB,
                        fee_paid INTEGER,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  sweeps
  CREATE TRIGGER _sweeps_delete BEFORE DELETE ON sweeps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO sweeps(rowid,tx_index,tx_hash,block_index,source,destination,flags,status,memo,fee_paid) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.destination)||','||quote(old.flags)||','||quote(old.status)||','||quote(old.memo)||','||quote(old.fee_paid)||')');
                              END;
  CREATE TRIGGER _sweeps_insert AFTER INSERT ON sweeps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM sweeps WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _sweeps_update AFTER UPDATE ON sweeps BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE sweeps SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',destination='||quote(old.destination)||',flags='||quote(old.flags)||',status='||quote(old.status)||',memo='||quote(old.memo)||',fee_paid='||quote(old.fee_paid)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  transactions
  DROP TABLE IF EXISTS transactions;
  CREATE TABLE transactions(
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        block_hash TEXT,
                        block_time INTEGER,
                        source TEXT,
                        destination TEXT,
                        btc_amount INTEGER,
                        fee INTEGER,
                        data BLOB,
                        supported BOOL DEFAULT 1,
                        FOREIGN KEY (block_index, block_hash) REFERENCES blocks(block_index, block_hash),
                        PRIMARY KEY (tx_index, tx_hash, block_index));
  INSERT INTO transactions VALUES(1,'5fde1c728d8d00aaa1b5f8dae963ceb4fd30c415eb0b8a982ba2d8d676fec0bb',310000,'505d8d82c4ced7daddef7ed0b05ba12ecc664176887b938ef56c6af276f3b30c',310000000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UUnoPartyXburnTestnetXXXXXXXXFEeN4',62000000,5625,X'',1);
  INSERT INTO transactions VALUES(2,'63242f35c724cd03163541785b69fbd620df9ebeb72706a0caeb5e19ce7680cc',310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'0000000000000000000000010000000002FAF080',1);
  INSERT INTO transactions VALUES(3,'82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e',310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,1000000,X'0000000A00000000000000000000000002FAF08000000000000000010000000005F5E100000A0000000000000000',1);
  INSERT INTO transactions VALUES(4,'371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1',310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000000A00000000000000010000000006422C4000000000000000000000000002FAF080000A00000000000DBBA0',1);
  INSERT INTO transactions VALUES(5,'f307fdf5e231e05f9e9ecf23e5fc8bfff87951b223575840690b3f8bb502ad0f',310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',50000000,9675,X'0000000B82E2A0085961F5672C7BCF81A04ABF78021D9B91C5F9E0D98421CE3CB083CD4E371A06E55FBB3661941DC2300754556A09B6BADC04AA182EE7D80842DD6CB9F1',1);
  INSERT INTO transactions VALUES(6,'ddd50ba93798b76cf1342fbed755b5aec4df77b99622d670ea70dceb21f8c975',310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'000000140000000000004767000000003B9ACA000100000000000000000000',1);
  INSERT INTO transactions VALUES(7,'b693ef32344d5663f9a8368f6bbb311cc06ebc19bfc2818455af2ca098ed8f06',310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000014000000000000476800000000000186A00000000000000000000006666F6F626172',1);
  INSERT INTO transactions VALUES(8,'cfdba3d6b7a8dafd12d45751395d3a2a99e2b36456d68db5e2080ce8118503ab',310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000000000000000000476700000000003D0900',1);
  INSERT INTO transactions VALUES(9,'0f649981bbe02942cc0e2f2e43cdb6e41d22c9275506792873b89b683e023f89',310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'000000000000000000004768000000000000020E',1);
  INSERT INTO transactions VALUES(10,'4eb273718f2e68efb37d467d5a5e67388274652f4ad83477d126bb8ef4088bc3',310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000032000000000000025800000000000047670000000000000001',1);
  INSERT INTO transactions VALUES(11,'2e7b84301a9d340c5b4fdc2b765b4e027112ad4f66a1c219163fb743625059c7',310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000032000000000000032000000000000047680000000000000001',1);
  INSERT INTO transactions VALUES(12,'fb70fe2fe539e5ed1950885c3385ecb01d27ccfd583c6dff94006b3a55866e72',310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB3300405900000000000005F5E0FF09556E69742054657374',1);
  INSERT INTO transactions VALUES(13,'44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b',310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000052BB33640000000002FAF08000000000017D7840000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(14,'08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12',310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000152BB336400000000017D78400000000002793D60000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(15,'3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68',310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000052BB33640000000008F0D1800000000014DC93800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(16,'75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572',310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000152BB33640000000014DC93800000000008F0D1800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(17,'674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644',310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000252BB33C8000000002CB417800000000026BE36803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(18,'4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9',310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000352BB33C80000000026BE3680000000002CB417803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(19,'3c120af6e8f350e4e55e319d699e7f715e5b049f94491c5706426ffe101e1452',310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB33324058F7256FFC115E004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(20,'f1b036ae3c9e9be338370b7be53f0210b830bd86ac2ddc7a757b80c2f7fb093f',310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB3365405915F3B645A1CB004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(21,'63199a0ec21c2541171b644e4e3876a81d997d238fec82b62baea7baaa33aaa3',310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB33C94000000000000000004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(22,'dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41',310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000000A00000000000047670000000002FAF08000000000000000010000000002FAF080000A0000000000000000',1);
  INSERT INTO transactions VALUES(23,'df080a76ceb263201901bc23c85c3e8dce4eca0e72c873131adaf2f46820e9f1',310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UUnoPartyXburnTestnetXXXXXXXXFEeN4',100000000,5625,X'',1);
  INSERT INTO transactions VALUES(24,'ff48aca435aafe8e5fec706d3dcb2e3e54710e797ef43d006206136761371bca',310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,'2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'0000000000000000000047680000000000002710',1);
  -- Triggers and indices on  transactions
  CREATE INDEX index_hash_index_idx ON transactions (tx_index, tx_hash, block_index);
  CREATE INDEX index_index_idx ON transactions (block_index, tx_index);
  CREATE INDEX tx_hash_idx ON transactions (tx_hash);
  CREATE INDEX tx_index_idx ON transactions (tx_index);
  
  -- Table  undolog
  DROP TABLE IF EXISTS undolog;
  CREATE TABLE undolog(
                          undo_index INTEGER PRIMARY KEY AUTOINCREMENT,
                          sql TEXT);
  INSERT INTO undolog VALUES(4,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=93000000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(5,'DELETE FROM debits WHERE rowid=1');
  INSERT INTO undolog VALUES(6,'DELETE FROM balances WHERE rowid=2');
  INSERT INTO undolog VALUES(7,'DELETE FROM credits WHERE rowid=2');
  INSERT INTO undolog VALUES(8,'DELETE FROM sends WHERE rowid=1');
  INSERT INTO undolog VALUES(9,'DELETE FROM orders WHERE rowid=1');
  INSERT INTO undolog VALUES(10,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92950000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(11,'DELETE FROM debits WHERE rowid=2');
  INSERT INTO undolog VALUES(12,'DELETE FROM orders WHERE rowid=2');
  INSERT INTO undolog VALUES(13,'UPDATE orders SET tx_index=3,tx_hash=''82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e'',block_index=310002,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',give_asset=''UNO'',give_quantity=50000000,give_remaining=50000000,get_asset=''XUP'',get_quantity=100000000,get_remaining=100000000,expiration=10,expire_index=310012,fee_required=0,fee_required_remaining=0,fee_provided=1000000,fee_provided_remaining=1000000,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(14,'UPDATE orders SET tx_index=4,tx_hash=''371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1'',block_index=310003,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',give_asset=''XUP'',give_quantity=105000000,give_remaining=105000000,get_asset=''UNO'',get_quantity=50000000,get_remaining=50000000,expiration=10,expire_index=310013,fee_required=900000,fee_required_remaining=900000,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=2');
  INSERT INTO undolog VALUES(15,'DELETE FROM order_matches WHERE rowid=1');
  INSERT INTO undolog VALUES(16,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92845000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(17,'DELETE FROM credits WHERE rowid=3');
  INSERT INTO undolog VALUES(18,'UPDATE order_matches SET id=''82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e_371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1'',tx0_index=3,tx0_hash=''82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e'',tx0_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=4,tx1_hash=''371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1'',tx1_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',forward_asset=''UNO'',forward_quantity=50000000,backward_asset=''XUP'',backward_quantity=100000000,tx0_block_index=310002,tx1_block_index=310003,block_index=310003,tx0_expiration=10,tx1_expiration=10,match_expire_index=310023,fee_paid=857142,status=''pending'' WHERE rowid=1');
  INSERT INTO undolog VALUES(19,'DELETE FROM btcpays WHERE rowid=5');
  INSERT INTO undolog VALUES(20,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92945000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(21,'DELETE FROM debits WHERE rowid=3');
  INSERT INTO undolog VALUES(22,'DELETE FROM assets WHERE rowid=3');
  INSERT INTO undolog VALUES(23,'DELETE FROM issuances WHERE rowid=1');
  INSERT INTO undolog VALUES(24,'DELETE FROM balances WHERE rowid=3');
  INSERT INTO undolog VALUES(25,'DELETE FROM credits WHERE rowid=4');
  INSERT INTO undolog VALUES(26,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92895000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(27,'DELETE FROM debits WHERE rowid=4');
  INSERT INTO undolog VALUES(28,'DELETE FROM assets WHERE rowid=4');
  INSERT INTO undolog VALUES(29,'DELETE FROM issuances WHERE rowid=2');
  INSERT INTO undolog VALUES(30,'DELETE FROM balances WHERE rowid=4');
  INSERT INTO undolog VALUES(31,'DELETE FROM credits WHERE rowid=5');
  INSERT INTO undolog VALUES(32,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBB'',quantity=1000000000 WHERE rowid=3');
  INSERT INTO undolog VALUES(33,'DELETE FROM debits WHERE rowid=5');
  INSERT INTO undolog VALUES(34,'DELETE FROM balances WHERE rowid=5');
  INSERT INTO undolog VALUES(35,'DELETE FROM credits WHERE rowid=6');
  INSERT INTO undolog VALUES(36,'DELETE FROM sends WHERE rowid=2');
  INSERT INTO undolog VALUES(37,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBC'',quantity=100000 WHERE rowid=4');
  INSERT INTO undolog VALUES(38,'DELETE FROM debits WHERE rowid=6');
  INSERT INTO undolog VALUES(39,'DELETE FROM balances WHERE rowid=6');
  INSERT INTO undolog VALUES(40,'DELETE FROM credits WHERE rowid=7');
  INSERT INTO undolog VALUES(41,'DELETE FROM sends WHERE rowid=3');
  INSERT INTO undolog VALUES(42,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92845000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(43,'DELETE FROM debits WHERE rowid=7');
  INSERT INTO undolog VALUES(44,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92844999976 WHERE rowid=1');
  INSERT INTO undolog VALUES(45,'DELETE FROM debits WHERE rowid=8');
  INSERT INTO undolog VALUES(46,'UPDATE balances SET address=''2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=50000000 WHERE rowid=2');
  INSERT INTO undolog VALUES(47,'DELETE FROM credits WHERE rowid=8');
  INSERT INTO undolog VALUES(48,'DELETE FROM dividends WHERE rowid=10');
  INSERT INTO undolog VALUES(49,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92844979976 WHERE rowid=1');
  INSERT INTO undolog VALUES(50,'DELETE FROM debits WHERE rowid=9');
  INSERT INTO undolog VALUES(51,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92844559176 WHERE rowid=1');
  INSERT INTO undolog VALUES(52,'DELETE FROM debits WHERE rowid=10');
  INSERT INTO undolog VALUES(53,'UPDATE balances SET address=''2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=50000024 WHERE rowid=2');
  INSERT INTO undolog VALUES(54,'DELETE FROM credits WHERE rowid=9');
  INSERT INTO undolog VALUES(55,'DELETE FROM dividends WHERE rowid=11');
  INSERT INTO undolog VALUES(56,'DELETE FROM broadcasts WHERE rowid=12');
  INSERT INTO undolog VALUES(57,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92844539176 WHERE rowid=1');
  INSERT INTO undolog VALUES(58,'DELETE FROM debits WHERE rowid=11');
  INSERT INTO undolog VALUES(59,'DELETE FROM bets WHERE rowid=1');
  INSERT INTO undolog VALUES(60,'UPDATE orders SET tx_index=3,tx_hash=''82e2a0085961f5672c7bcf81a04abf78021d9b91c5f9e0d98421ce3cb083cd4e'',block_index=310002,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',give_asset=''UNO'',give_quantity=50000000,give_remaining=0,get_asset=''XUP'',get_quantity=100000000,get_remaining=0,expiration=10,expire_index=310012,fee_required=0,fee_required_remaining=0,fee_provided=1000000,fee_provided_remaining=142858,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(61,'DELETE FROM order_expirations WHERE rowid=3');
  INSERT INTO undolog VALUES(62,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92794539176 WHERE rowid=1');
  INSERT INTO undolog VALUES(63,'DELETE FROM debits WHERE rowid=12');
  INSERT INTO undolog VALUES(64,'DELETE FROM bets WHERE rowid=2');
  INSERT INTO undolog VALUES(65,'UPDATE bets SET tx_index=13,tx_hash=''44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b'',block_index=310012,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=0,deadline=1388000100,wager_quantity=50000000,wager_remaining=50000000,counterwager_quantity=25000000,counterwager_remaining=25000000,target_value=0.0,leverage=15120,expiration=10,expire_index=310022,fee_fraction_int=99999999,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(66,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92769539176 WHERE rowid=1');
  INSERT INTO undolog VALUES(67,'DELETE FROM credits WHERE rowid=10');
  INSERT INTO undolog VALUES(68,'UPDATE bets SET tx_index=14,tx_hash=''08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12'',block_index=310013,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=1,deadline=1388000100,wager_quantity=25000000,wager_remaining=25000000,counterwager_quantity=41500000,counterwager_remaining=41500000,target_value=0.0,leverage=15120,expiration=10,expire_index=310023,fee_fraction_int=99999999,status=''open'' WHERE rowid=2');
  INSERT INTO undolog VALUES(69,'DELETE FROM bet_matches WHERE rowid=1');
  INSERT INTO undolog VALUES(70,'UPDATE orders SET tx_index=4,tx_hash=''371a06e55fbb3661941dc2300754556a09b6badc04aa182ee7d80842dd6cb9f1'',block_index=310003,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',give_asset=''XUP'',give_quantity=105000000,give_remaining=5000000,get_asset=''UNO'',get_quantity=50000000,get_remaining=0,expiration=10,expire_index=310013,fee_required=900000,fee_required_remaining=42858,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=2');
  INSERT INTO undolog VALUES(71,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92773789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(72,'DELETE FROM credits WHERE rowid=11');
  INSERT INTO undolog VALUES(73,'DELETE FROM order_expirations WHERE rowid=4');
  INSERT INTO undolog VALUES(74,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92778789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(75,'DELETE FROM debits WHERE rowid=13');
  INSERT INTO undolog VALUES(76,'DELETE FROM bets WHERE rowid=3');
  INSERT INTO undolog VALUES(77,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92628789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(78,'DELETE FROM debits WHERE rowid=14');
  INSERT INTO undolog VALUES(79,'DELETE FROM bets WHERE rowid=4');
  INSERT INTO undolog VALUES(80,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92278789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(81,'DELETE FROM credits WHERE rowid=12');
  INSERT INTO undolog VALUES(82,'UPDATE bets SET tx_index=15,tx_hash=''3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68'',block_index=310014,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=0,deadline=1388000100,wager_quantity=150000000,wager_remaining=150000000,counterwager_quantity=350000000,counterwager_remaining=350000000,target_value=0.0,leverage=5040,expiration=10,expire_index=310024,fee_fraction_int=99999999,status=''open'' WHERE rowid=3');
  INSERT INTO undolog VALUES(83,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92278789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(84,'DELETE FROM credits WHERE rowid=13');
  INSERT INTO undolog VALUES(85,'UPDATE bets SET tx_index=16,tx_hash=''75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572'',block_index=310015,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=1,deadline=1388000100,wager_quantity=350000000,wager_remaining=350000000,counterwager_quantity=150000000,counterwager_remaining=150000000,target_value=0.0,leverage=5040,expiration=10,expire_index=310025,fee_fraction_int=99999999,status=''open'' WHERE rowid=4');
  INSERT INTO undolog VALUES(86,'DELETE FROM bet_matches WHERE rowid=2');
  INSERT INTO undolog VALUES(87,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92278789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(88,'DELETE FROM debits WHERE rowid=15');
  INSERT INTO undolog VALUES(89,'DELETE FROM bets WHERE rowid=5');
  INSERT INTO undolog VALUES(90,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=91528789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(91,'DELETE FROM debits WHERE rowid=16');
  INSERT INTO undolog VALUES(92,'DELETE FROM bets WHERE rowid=6');
  INSERT INTO undolog VALUES(93,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=90878789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(94,'DELETE FROM credits WHERE rowid=14');
  INSERT INTO undolog VALUES(95,'UPDATE bets SET tx_index=17,tx_hash=''674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644'',block_index=310016,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=2,deadline=1388000200,wager_quantity=750000000,wager_remaining=750000000,counterwager_quantity=650000000,counterwager_remaining=650000000,target_value=1.0,leverage=5040,expiration=10,expire_index=310026,fee_fraction_int=99999999,status=''open'' WHERE rowid=5');
  INSERT INTO undolog VALUES(96,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=90878789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(97,'DELETE FROM credits WHERE rowid=15');
  INSERT INTO undolog VALUES(98,'UPDATE bets SET tx_index=18,tx_hash=''4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9'',block_index=310017,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=3,deadline=1388000200,wager_quantity=650000000,wager_remaining=650000000,counterwager_quantity=750000000,counterwager_remaining=750000000,target_value=1.0,leverage=5040,expiration=10,expire_index=310027,fee_fraction_int=99999999,status=''open'' WHERE rowid=6');
  INSERT INTO undolog VALUES(99,'DELETE FROM bet_matches WHERE rowid=3');
  INSERT INTO undolog VALUES(100,'DELETE FROM broadcasts WHERE rowid=19');
  INSERT INTO undolog VALUES(101,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=90878789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(102,'DELETE FROM credits WHERE rowid=16');
  INSERT INTO undolog VALUES(103,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=90937926676 WHERE rowid=1');
  INSERT INTO undolog VALUES(104,'DELETE FROM credits WHERE rowid=17');
  INSERT INTO undolog VALUES(105,'DELETE FROM bet_match_resolutions WHERE rowid=1');
  INSERT INTO undolog VALUES(106,'UPDATE bet_matches SET id=''44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b_08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12'',tx0_index=13,tx0_hash=''44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b'',tx0_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=14,tx1_hash=''08b5ed9f3262752165c46ce0d17c2c6604f5662144fecb1a5eabf645dd6bee12'',tx1_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',initial_value=100,deadline=1388000100,target_value=0.0,leverage=15120,forward_quantity=41500000,backward_quantity=20750000,tx0_block_index=310012,tx1_block_index=310013,block_index=310013,tx0_expiration=10,tx1_expiration=10,match_expire_index=310022,fee_fraction_int=99999999,status=''pending'' WHERE rowid=1');
  INSERT INTO undolog VALUES(107,'DELETE FROM broadcasts WHERE rowid=20');
  INSERT INTO undolog VALUES(108,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=90941039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(109,'DELETE FROM credits WHERE rowid=18');
  INSERT INTO undolog VALUES(110,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=91100339176 WHERE rowid=1');
  INSERT INTO undolog VALUES(111,'DELETE FROM credits WHERE rowid=19');
  INSERT INTO undolog VALUES(112,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=91416039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(113,'DELETE FROM credits WHERE rowid=20');
  INSERT INTO undolog VALUES(114,'DELETE FROM bet_match_resolutions WHERE rowid=2');
  INSERT INTO undolog VALUES(115,'UPDATE bet_matches SET id=''3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68_75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572'',tx0_index=15,tx0_hash=''3709deca4f216971ff70b564f18f8f439313cd38d73dbf20b903685fb89a5f68'',tx0_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=16,tx1_hash=''75bb331102e80cb98b1d849101442f59718f2d91609c19056f58771781793572'',tx1_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',initial_value=100,deadline=1388000100,target_value=0.0,leverage=5040,forward_quantity=150000000,backward_quantity=350000000,tx0_block_index=310014,tx1_block_index=310015,block_index=310015,tx0_expiration=10,tx1_expiration=10,match_expire_index=310024,fee_fraction_int=99999999,status=''pending'' WHERE rowid=2');
  INSERT INTO undolog VALUES(116,'DELETE FROM broadcasts WHERE rowid=21');
  INSERT INTO undolog VALUES(117,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=91441039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(118,'DELETE FROM credits WHERE rowid=21');
  INSERT INTO undolog VALUES(119,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92771039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(120,'DELETE FROM credits WHERE rowid=22');
  INSERT INTO undolog VALUES(121,'DELETE FROM bet_match_resolutions WHERE rowid=3');
  INSERT INTO undolog VALUES(122,'UPDATE bet_matches SET id=''674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644_4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9'',tx0_index=17,tx0_hash=''674c197ae30a86d1771b9e842194dd5a03d2a85a9f45f6148194cf44e4a54644'',tx0_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=18,tx1_hash=''4d1ba1b2843a69d9bb822abceff9b41c0d1727be97551546535421b7af2b71b9'',tx1_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=2,tx1_bet_type=3,feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',initial_value=100,deadline=1388000200,target_value=1.0,leverage=5040,forward_quantity=750000000,backward_quantity=650000000,tx0_block_index=310016,tx1_block_index=310017,block_index=310017,tx0_expiration=10,tx1_expiration=10,match_expire_index=310026,fee_fraction_int=99999999,status=''pending'' WHERE rowid=3');
  INSERT INTO undolog VALUES(123,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBB'',quantity=996000000 WHERE rowid=3');
  INSERT INTO undolog VALUES(124,'DELETE FROM debits WHERE rowid=17');
  INSERT INTO undolog VALUES(125,'DELETE FROM orders WHERE rowid=3');
  INSERT INTO undolog VALUES(126,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=92841039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(127,'DELETE FROM credits WHERE rowid=23');
  INSERT INTO undolog VALUES(128,'DELETE FROM burns WHERE rowid=23');
  INSERT INTO undolog VALUES(129,'UPDATE bets SET tx_index=13,tx_hash=''44e2c9f313771d1afb4d656430f41336418d041aa11ab4e1b5eb2cdc51f1832b'',block_index=310012,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',bet_type=0,deadline=1388000100,wager_quantity=50000000,wager_remaining=8500000,counterwager_quantity=25000000,counterwager_remaining=4250000,target_value=0.0,leverage=15120,expiration=10,expire_index=310022,fee_fraction_int=99999999,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(130,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''XUP'',quantity=149840926438 WHERE rowid=1');
  INSERT INTO undolog VALUES(131,'DELETE FROM credits WHERE rowid=24');
  INSERT INTO undolog VALUES(132,'DELETE FROM bet_expirations WHERE rowid=13');
  INSERT INTO undolog VALUES(133,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBC'',quantity=99474 WHERE rowid=4');
  INSERT INTO undolog VALUES(134,'DELETE FROM debits WHERE rowid=18');
  INSERT INTO undolog VALUES(135,'UPDATE balances SET address=''2_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBC'',quantity=526 WHERE rowid=6');
  INSERT INTO undolog VALUES(136,'DELETE FROM credits WHERE rowid=25');
  INSERT INTO undolog VALUES(137,'DELETE FROM sends WHERE rowid=4');
  INSERT INTO undolog VALUES(138,'UPDATE orders SET tx_index=22,tx_hash=''dbbfdae392b27be467139350049f225f6b87682284d1d46c58be7d03d74caf41'',block_index=310021,source=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',give_asset=''BBBB'',give_quantity=50000000,give_remaining=50000000,get_asset=''XUP'',get_quantity=50000000,get_remaining=50000000,expiration=10,expire_index=310031,fee_required=0,fee_required_remaining=0,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=3');
  INSERT INTO undolog VALUES(139,'UPDATE balances SET address=''2_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',asset=''BBBB'',quantity=946000000 WHERE rowid=3');
  INSERT INTO undolog VALUES(140,'DELETE FROM credits WHERE rowid=26');
  INSERT INTO undolog VALUES(141,'DELETE FROM order_expirations WHERE rowid=22');
  
  -- Table  undolog_block
  DROP TABLE IF EXISTS undolog_block;
  CREATE TABLE undolog_block(
                          block_index INTEGER PRIMARY KEY,
                          first_undo_index INTEGER);
  INSERT INTO undolog_block VALUES(310001,4);
  INSERT INTO undolog_block VALUES(310002,9);
  INSERT INTO undolog_block VALUES(310003,10);
  INSERT INTO undolog_block VALUES(310004,16);
  INSERT INTO undolog_block VALUES(310005,20);
  INSERT INTO undolog_block VALUES(310006,26);
  INSERT INTO undolog_block VALUES(310007,32);
  INSERT INTO undolog_block VALUES(310008,37);
  INSERT INTO undolog_block VALUES(310009,42);
  INSERT INTO undolog_block VALUES(310010,49);
  INSERT INTO undolog_block VALUES(310011,56);
  INSERT INTO undolog_block VALUES(310012,57);
  INSERT INTO undolog_block VALUES(310013,60);
  INSERT INTO undolog_block VALUES(310014,70);
  INSERT INTO undolog_block VALUES(310015,77);
  INSERT INTO undolog_block VALUES(310016,87);
  INSERT INTO undolog_block VALUES(310017,90);
  INSERT INTO undolog_block VALUES(310018,100);
  INSERT INTO undolog_block VALUES(310019,107);
  INSERT INTO undolog_block VALUES(310020,116);
  INSERT INTO undolog_block VALUES(310021,123);
  INSERT INTO undolog_block VALUES(310022,126);
  INSERT INTO undolog_block VALUES(310023,129);
  INSERT INTO undolog_block VALUES(310024,138);
  INSERT INTO undolog_block VALUES(310025,138);
  INSERT INTO undolog_block VALUES(310026,138);
  INSERT INTO undolog_block VALUES(310027,138);
  INSERT INTO undolog_block VALUES(310028,138);
  INSERT INTO undolog_block VALUES(310029,138);
  INSERT INTO undolog_block VALUES(310030,138);
  INSERT INTO undolog_block VALUES(310031,138);
  INSERT INTO undolog_block VALUES(310032,138);
  INSERT INTO undolog_block VALUES(310033,142);
  INSERT INTO undolog_block VALUES(310034,142);
  INSERT INTO undolog_block VALUES(310035,142);
  INSERT INTO undolog_block VALUES(310036,142);
  INSERT INTO undolog_block VALUES(310037,142);
  INSERT INTO undolog_block VALUES(310038,142);
  INSERT INTO undolog_block VALUES(310039,142);
  INSERT INTO undolog_block VALUES(310040,142);
  INSERT INTO undolog_block VALUES(310041,142);
  INSERT INTO undolog_block VALUES(310042,142);
  INSERT INTO undolog_block VALUES(310043,142);
  INSERT INTO undolog_block VALUES(310044,142);
  INSERT INTO undolog_block VALUES(310045,142);
  INSERT INTO undolog_block VALUES(310046,142);
  INSERT INTO undolog_block VALUES(310047,142);
  INSERT INTO undolog_block VALUES(310048,142);
  INSERT INTO undolog_block VALUES(310049,142);
  INSERT INTO undolog_block VALUES(310050,142);
  INSERT INTO undolog_block VALUES(310051,142);
  INSERT INTO undolog_block VALUES(310052,142);
  INSERT INTO undolog_block VALUES(310053,142);
  INSERT INTO undolog_block VALUES(310054,142);
  INSERT INTO undolog_block VALUES(310055,142);
  INSERT INTO undolog_block VALUES(310056,142);
  INSERT INTO undolog_block VALUES(310057,142);
  INSERT INTO undolog_block VALUES(310058,142);
  INSERT INTO undolog_block VALUES(310059,142);
  INSERT INTO undolog_block VALUES(310060,142);
  INSERT INTO undolog_block VALUES(310061,142);
  INSERT INTO undolog_block VALUES(310062,142);
  INSERT INTO undolog_block VALUES(310063,142);
  INSERT INTO undolog_block VALUES(310064,142);
  INSERT INTO undolog_block VALUES(310065,142);
  INSERT INTO undolog_block VALUES(310066,142);
  INSERT INTO undolog_block VALUES(310067,142);
  INSERT INTO undolog_block VALUES(310068,142);
  INSERT INTO undolog_block VALUES(310069,142);
  INSERT INTO undolog_block VALUES(310070,142);
  INSERT INTO undolog_block VALUES(310071,142);
  INSERT INTO undolog_block VALUES(310072,142);
  INSERT INTO undolog_block VALUES(310073,142);
  INSERT INTO undolog_block VALUES(310074,142);
  INSERT INTO undolog_block VALUES(310075,142);
  INSERT INTO undolog_block VALUES(310076,142);
  INSERT INTO undolog_block VALUES(310077,142);
  INSERT INTO undolog_block VALUES(310078,142);
  INSERT INTO undolog_block VALUES(310079,142);
  INSERT INTO undolog_block VALUES(310080,142);
  INSERT INTO undolog_block VALUES(310081,142);
  INSERT INTO undolog_block VALUES(310082,142);
  INSERT INTO undolog_block VALUES(310083,142);
  INSERT INTO undolog_block VALUES(310084,142);
  INSERT INTO undolog_block VALUES(310085,142);
  INSERT INTO undolog_block VALUES(310086,142);
  INSERT INTO undolog_block VALUES(310087,142);
  INSERT INTO undolog_block VALUES(310088,142);
  INSERT INTO undolog_block VALUES(310089,142);
  INSERT INTO undolog_block VALUES(310090,142);
  INSERT INTO undolog_block VALUES(310091,142);
  INSERT INTO undolog_block VALUES(310092,142);
  INSERT INTO undolog_block VALUES(310093,142);
  INSERT INTO undolog_block VALUES(310094,142);
  INSERT INTO undolog_block VALUES(310095,142);
  INSERT INTO undolog_block VALUES(310096,142);
  INSERT INTO undolog_block VALUES(310097,142);
  INSERT INTO undolog_block VALUES(310098,142);
  INSERT INTO undolog_block VALUES(310099,142);
  INSERT INTO undolog_block VALUES(310100,142);
  INSERT INTO undolog_block VALUES(310101,142);
  
  -- For primary key autoincrements the next id to use is stored in
  -- sqlite_sequence
  DELETE FROM main.sqlite_sequence WHERE name='undolog';
  INSERT INTO main.sqlite_sequence VALUES ('undolog', 141);
  
  COMMIT TRANSACTION;
  