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('1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',149849426438);
  INSERT INTO balances VALUES('1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50420824);
  INSERT INTO balances VALUES('1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',996000000);
  INSERT INTO balances VALUES('1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',89474);
  INSERT INTO balances VALUES('1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000);
  INSERT INTO balances VALUES('1_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,'19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9','1_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('19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84',1,310018,'0',0,59137500,NULL,NULL,3112500);
  INSERT INTO bet_match_resolutions VALUES('1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531',1,310019,'1',159300000,315700000,NULL,NULL,25000000);
  INSERT INTO bet_match_resolutions VALUES('e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9',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('19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84',13,'19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',14,'43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1,'1_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('1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531',15,'1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',16,'005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',100,1388000100,0.0,5040,150000000,350000000,310014,310015,310015,10,10,310024,99999999,'settled');
  INSERT INTO bet_matches VALUES('e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9',17,'e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',18,'dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',2,3,'1_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,'19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9',310012,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1388000100,50000000,8500000,25000000,4250000,0.0,15120,10,310022,99999999,'expired');
  INSERT INTO bets VALUES(14,'43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84',310013,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1,1388000100,25000000,4250000,41500000,0,0.0,15120,10,310023,99999999,'filled');
  INSERT INTO bets VALUES(15,'1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d',310014,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,1388000100,150000000,0,350000000,0,0.0,5040,10,310024,99999999,'filled');
  INSERT INTO bets VALUES(16,'005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531',310015,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1,1388000100,350000000,0,150000000,0,0.0,5040,10,310025,99999999,'filled');
  INSERT INTO bets VALUES(17,'e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da',310016,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',2,1388000200,750000000,0,650000000,0,1.0,5040,10,310026,99999999,'filled');
  INSERT INTO bets VALUES(18,'dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9',310017,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_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,'98ccdf7cd2fb29a8a01cbed5f133b70b6966c6c56354dad00baacedd0673c87e','faf6476a908c85f6e26ca5d182688d6da3f326296602d5ad3aa5979cb8bc110b','f5843c07fb03fd5db4cd4dd0737cab8e2b3bd423f58da0e098cff02044556568');
  INSERT INTO blocks VALUES(310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,NULL,NULL,'fd43dc5efe2ee796ef7d24f8d478a67aa58bf85f538ef4b9a49b983a315deb26','f26a699c16b97ebb94d1efb170f5d6c8f2eb7f142fc6b00f3110744306247167','0f6386a71df285439aff2091081a2e1fe1930f0991a86f30d7ebf1e5632da8ff');
  INSERT INTO blocks VALUES(310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,NULL,NULL,'dbae4fff32545b4f3c104fb5a051dcaeacecd27401c84c09f93923b8bc30eab5','83ad9694ba7355702d30ab146748ef62d432adfca276c4cef218094875ea56fa','3635fc938720f59e10712971ce6191d0126eb22354048d805439493db7e338e5');
  INSERT INTO blocks VALUES(310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,NULL,NULL,'fd0ae9793d9513540246b94ad116fc0531e8e07b2c014752e175a12e2a7a82d4','914c5104ba32dc170caa204ceef20539ebe6bbc1d91a3d9606bf021f0d450fd2','330405f6077d2946072001144134b8ccee5309df734ad5f45da267cf5c13919a');
  INSERT INTO blocks VALUES(310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,NULL,NULL,'bd894777a85b731155a0d6362766b4220c03db4f3e5fbf030d6c2529cb5f3537','9286144a2f996077cda776eb11193ef5dc3f5cf93c8ff29cf7d5b2f4add15605','0ca3109ff79f64cefd1ecd4f9192db21e68f66afedf87a499416c74fe44028a5');
  INSERT INTO blocks VALUES(310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,NULL,NULL,'264c98f1d460f78e52def545d25482fd76549a5309d04841bc27b335f06470a2','a6b97bbaec97bace0a2ae28e227f3d17c87b8a572401ec73363d00b6dae2c2fd','4494cf782435097ed12ae08eeea4e3e21dfbc6be7bd08a2b77385842f81d0068');
  INSERT INTO blocks VALUES(310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,NULL,NULL,'a1f2aa5a0b8d030c2fc4e1243c3173319ecf68d232262ea3dc8bfdd03a3f923a','6bd97be8a62908c88fe8e8b2f1c4f748e3500a2454579ff8b88d8d44a02eeb41','5db48af9f8819b9fb3baee15a9b937a27fa37a1a4c718fe8499db4742d93642d');
  INSERT INTO blocks VALUES(310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,NULL,NULL,'8709aa2d5064ea2b7ab51a887d21f5fddcb7046753cd883317b533ed121f8504','513d2bdf239850135f891e542115a36e055e00e9975aa996dec33dad8dbba8c7','54956316e50cfe4be9beff69409ad2edb1268ecb6396c8516abc35b876630495');
  INSERT INTO blocks VALUES(310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,NULL,NULL,'c1c516176fe38b69b31e3668b5ef20805bd90d3112c77f5652f838af8e7f604a','787d45e677db97608f3ad6953297ddafabccf9f6ff620cbb23ae19c7b15a5de6','c3801bf11d7632319e521568f8157de0b6381cfe46b2ae2f3bcfbecacb3d9d36');
  INSERT INTO blocks VALUES(310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,NULL,NULL,'ae8ee9e681f0ac96de96babc1c80e5188b3e0cb91074a0dfd8511ee7d0ae64c8','1ca498ac13747f3480fad17fd226dd2549b8ad1698ff46105d9104fe9500421d','3760b0f90c4366c0cfe27ea7531278badd7e8b8a47ae3cb011733f3eb15b30ec');
  INSERT INTO blocks VALUES(310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,NULL,NULL,'0451ffa5d7ffb0e588e58ac7eacf77f6b3e17f1d27c1039f03d7716b16fb234f','ecc216286ef67454c5fd287518bf057bcb4abe09b4146e9a7371f0eced984e00','20f0ef7726d7624d6a20316307ed1b6496aa28e3e7b2d979db9c0dc132b0d65e');
  INSERT INTO blocks VALUES(310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,NULL,NULL,'dfaae3f28c2f75e4bcc49034ff2a191b5a41b88035c5d266181617c8c65ad5d3','b62659ce7988b0d324a6f4ebd3c5f31ec07fe1362ded1fd6509892446b850072','ddb6e767dbdb465c6c506718bc5981f95e56dbe01387437ef7debd345abc6a7c');
  INSERT INTO blocks VALUES(310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,NULL,NULL,'c711e8cf2d9bbed01724a7b22cbd4900a4fd0a126bb7ecbd7c97ca15a6276553','e82579903ead26fa4564651d12b8ba6bfa6ea7b64a90975650b2eaa857d01992','e5963ffce3f9213c5ca6f288c6b4e7642537e48be1c54a8fbdef946130ff2405');
  INSERT INTO blocks VALUES(310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,NULL,NULL,'3dfa5822de8a4c674f1517b17e50d2ef63ccbb1fc4ae96fe5e1dc05cd353aa4b','7ce118322952fc58158fb3773245abd897eee30bc8c64524b01acb3eb4782677','d2ae2b9ce7de03cbd9be4f863167047d2bde2ecfaf70495608bc3bdf4794e759');
  INSERT INTO blocks VALUES(310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,NULL,NULL,'49fcaed957776bc62c9f1feac30dad8c0574596d312f9efee7a453e00bf64866','ff463f94f50daff01aa245dcd327c3da3840325f2916982cc9c57f0ae34af548','2fd0ed2b252af32d7336f30fcff43db31ecae8c798ae3a3c9ac68d6eba5fc097');
  INSERT INTO blocks VALUES(310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,NULL,NULL,'4e4abd3e8ab2658a7ac673e3a178ceac76fee41cf48bb6ed007d241c079979bf','67041390e6d3e576b99c4d457b847a0f16ee4eaaa12617f1dc8698d193d89094','4f3485223c95164865477d8180a8a5ba2a2a454a6301e1476413659e53056341');
  INSERT INTO blocks VALUES(310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,NULL,NULL,'17a28cca0777254af26544edfefcad8810e847e5d173fded9a7813719cf1162f','f6a0d431a83291a088c9c164c51f3f001eaf19a81863834f59f885605caa9260','741adcb7e47dfc3a3d6bbc1afa78abb2a03d24015c856ea94392ba013a2c4a8c');
  INSERT INTO blocks VALUES(310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,NULL,NULL,'1fb58120e9eb78908fda6265cad12b4a5770701e9a271bd5c4bc94059bd3bab5','71dda6919e8d17e053a0e0b2abde0d581d9c8f768bcccc8f7b1f13e79d66bb66','a2bef7f403bfea1d96f2c967bc208c84ac218bccdb5343d382684e6c732b831f');
  INSERT INTO blocks VALUES(310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,NULL,NULL,'304243c1b11644e04d325d7100e4c757c07b874f0349e60163a5a544e84e951f','7523472a8d1a0d991b2819f1c5e4575a5c4e2d3de88bf6082f50e394a947e7c9','7f85ec6434d221e90b7880dc0de8c381cca352e3aff7a99ee659ea17342aa52b');
  INSERT INTO blocks VALUES(310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,NULL,NULL,'fc9905ee4863b3cf29a3e558ee690a24ed978a4fd79c464bdde30a34cfff19fe','3ea51d4d4d2f52fb9b49b26e91c082a24f7a7ac5107b4ddc1f8ea7c4f2b9611d','41494a383d3c2aa5ddd3e65a7b2c52de0808d71e8cf9c2e904cbf9e6cd8c2d5a');
  INSERT INTO blocks VALUES(310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,NULL,NULL,'e433feac4a09ad727bd3764b10a568acf5c659745a695e9d7e8790514f6bc98e','8b4d76d52e57c92d5fca2a185cfd1f9d67c3ded62555e8755b729b2e82b87cd6','ca6c6cdd3d8ee785b668d4da93f0b0ffe049a3802f62bb9931ae7c37e07fb317');
  INSERT INTO blocks VALUES(310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,NULL,NULL,'622f92da40eae0b1b57218b32ad18daf7d79c9e0202fed4a288d75b8fdcd19d2','17b0e95e8e6e27289c510dd34f6985233ef7f0fe5c8a0d362565aeedd6e9999b','a19e6f965ecf2af6278fcc419913b07425926582244354fc9bd9853e90a4bfcf');
  INSERT INTO blocks VALUES(310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,NULL,NULL,'b7aa8d9ebc37d52d8dcce2cc17431d6edf5a183b73ac85bb3d91276592215cfd','b58dde2fa24be2e4a0cfb2c85fd8fee704c2a86d40ba2e79201842ad0a90791b','511285af5664c1e2aec3a583f485707309abb4fd6bad104be2a43ea979968509');
  INSERT INTO blocks VALUES(310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,NULL,NULL,'501c058860063ca599f3b946d465b3bbd84fd483a2a80527e456e3de32b48a19','9fbcd2b7667a9c48b40ea5d9e7e3fccdd910daa1c436de91a7596c331fca6105','188d3d587b947965e0efe7856c714b67f527b5344a4d0da2b31c10eb1b7d2a9a');
  INSERT INTO blocks VALUES(310024,'b03042b4e18a222b4c8d1e9e1970d93e6e2a2d41686d227ff8ecf0a839223dc5',310024000,NULL,NULL,'222986ec44fae1a6196d64dec24b79872970823f17bf0459d3b247bdef316675','db933e70448c060bb5d3bfb307fb05e2796680c6df47090360b8d6b7cf67ca12','46f78dd6e4798cc748cc095d91fb3810beb567f370f4d3bf911d233656f9aaee');
  INSERT INTO blocks VALUES(310025,'a872e560766832cc3b4f7f222228cb6db882ce3c54f6459f62c71d5cd6e90666',310025000,NULL,NULL,'bcd88006b9cb98445a74c656d424435e82eeaef95dd9c54e394b42808dc9cb8b','23374cf6cdc58adb36bea3ee8451321fb90ea77f4783a74dd28af8bd891df356','9df5257ad648a107cfebf467481ac3998ce8768bce2383be33ddc5730a7dd979');
  INSERT INTO blocks VALUES(310026,'6c96350f6f2f05810f19a689de235eff975338587194a36a70dfd0fcd490941a',310026000,NULL,NULL,'3de7bf2043ac2e68bc9eaf8d1c12195a4f2400bc78c8deed0d487af11edf401e','a0394bee7560c69883eb46b63b14908375fc613c46176840ed62f9cf57442573','968f0d6aef4fb6313f5aeba7172a658ff77c1d9c1a29f89b8d9b00e288d62baf');
  INSERT INTO blocks VALUES(310027,'d7acfac66df393c4482a14c189742c0571b89442eb7f817b34415a560445699e',310027000,NULL,NULL,'6c2a67783cf36e8987dc1805f87532ee1b94f79fb00952d8ee4cf3daaf655f85','8f08bbf6b0c64b09a4d6f1b73991e0f3b48309613bb006b6a0d5d78190350234','6de52a98d65f7137c6f416f965e5b36abb71e771d72e4f192f8348a090579222');
  INSERT INTO blocks VALUES(310028,'02409fcf8fa06dafcb7f11e38593181d9c42cc9d5e2ddc304d098f990bd9530b',310028000,NULL,NULL,'659c73390e2e7eccc07d690fb438181c604787208bc45f466e57721fa1e21a64','5827d4ab0174a8e79569d2b479d4d4d931166004aa833a36143f2a4be7b57d01','77d34d07c9352761db552ebbc35caf2798b7304b678177a50e47e63f7431d611');
  INSERT INTO blocks VALUES(310029,'3c739fa8b40c118d5547ea356ee8d10ee2898871907643ec02e5db9d00f03cc6',310029000,NULL,NULL,'87449e7ff7316e49012934d83c1f5b733cedf39680299a9582eb216e260e0c02','3cffa210af1a32ed7ee3f88ca8462389ba45359aa1207aab0980361e61b90fef','09af709f53afc6186e343acf3beb0e93729cd229d76b4454a26d586e52db941c');
  INSERT INTO blocks VALUES(310030,'d5071cddedf89765ee0fd58f209c1c7d669ba8ea66200a57587da8b189b9e4f5',310030000,NULL,NULL,'6c4a7f749d0308edf5c88b3ea4de3b1d497ba3bc06435594d77686318b744b0f','9f71252f81e53bba0c1746bc09035895707841f0f5260b498b10de2a7ffde64b','652c074104008752eb456cf9f6ebb0af68e4363b6f5fdd6e9be870894dcc3837');
  INSERT INTO blocks VALUES(310031,'0b02b10f41380fff27c543ea8891ecb845bf7a003ac5c87e15932aff3bfcf689',310031000,NULL,NULL,'ecc04b1b2c7803ca17dc2a32adebd0960de2c04c8dbfec9cd88771dd883c885a','4742011b2b042e35df72ff725207ead03f3fcdca89877cb2d29a2738456a6b39','1378ea730fddf2c25d82070c9a60564c9a672eec43ba876f601620165edf4d55');
  INSERT INTO blocks VALUES(310032,'66346be81e6ba04544f2ae643b76c2b7b1383f038fc2636e02e49dc7ec144074',310032000,NULL,NULL,'01e769c5b990db44a9e534bc6c759567eb4283e0ea252578dd525923c7fde02c','e0d760b1db71dc3eeb2ae5b95d10604f5a1cb6bc513d1b9498be0a9f4c7e2402','09008b0a8f1f7b0565052187ae8696e71565f1633df1452c44623cdb7351562a');
  INSERT INTO blocks VALUES(310033,'999c65df9661f73e8c01f1da1afda09ac16788b72834f0ff5ea3d1464afb4707',310033000,NULL,NULL,'2df6b8dca0ffa8d6d55997605188637c2b86300e4dd7ebe3f1f275690169fd46','bf7f6ac6ba5fee1dcdc7ebb30b65a1bfecd26d53c689c0001e01f66fa7c7e4f7','d67d428357afc13efe80aaa5adfcf854ad65e161af2caaea239241fc61c4f7f6');
  INSERT INTO blocks VALUES(310034,'f552edd2e0a648230f3668e72ddf0ddfb1e8ac0f4c190f91b89c1a8c2e357208',310034000,NULL,NULL,'7f0dc7c1527a7d11831d272f0295eacabcb96fa3599f5a716bd29ba1bb6b7577','116fa2e29b8c46272b9de2bd29469d0996f9156431f48c465aeeb8390ba612d6','0e3b33269583f3ea520000f33c22aefde00dd20e39e4d3a75795a7c844bf01b6');
  INSERT INTO blocks VALUES(310035,'a13cbb016f3044207a46967a4ba1c87dab411f78c55c1179f2336653c2726ae2',310035000,NULL,NULL,'5e0cdf1764ed94672c29144f9c1bd9c3e70784f17c9dd1c9e4ce703a99bb3599','73ac8f51cc2552bafdebcdc9745199c5e3e66d6e9b8a6a92db2e2be6532a40ac','0dd74d18c80374acd5e4b760a3e4bd0ceab64fb9b33ee22261628cdfd1c7702d');
  INSERT INTO blocks VALUES(310036,'158648a98f1e1bd1875584ce8449eb15a4e91a99a923bbb24c4210135cef0c76',310036000,NULL,NULL,'96da34a5a66b89aa3e8857b4a4edca51a56a0cbbfe600d8153077875624a153e','f0e0167580f1f1030de9762a87a83e0757d7d33c4884573395bed37aa7a4f729','bc123e0ebf45daad5b5090bafa2d2834737786c27fefd000ee89bdbe115f220c');
  INSERT INTO blocks VALUES(310037,'563acfd6d991ce256d5655de2e9429975c8dceeb221e76d5ec6e9e24a2c27c07',310037000,NULL,NULL,'d481358c19b4220aa9a3d135fd0651fada6df8d0f27b9ec954ac07950e876c0c','a5b01e8e2024b42cf1442c2bcc9bc1c434d3279fb285d7c679acc2bff0a96dcf','d273a1c3d9f91a2c16c32c408a378e22ee9d5b9cfdce76d573a79e92a92d2320');
  INSERT INTO blocks VALUES(310038,'b44b4cad12431c32df27940e18d51f63897c7472b70950d18454edfd640490b2',310038000,NULL,NULL,'4e9fcc454ee53b3617c792eb6577c2eefa6eee6aa4a2925538cb1976d48817c9','f1ceb0c1650024cb85e37b7b4f908986138fa976df14641026dba60fcaf1eb6e','2c685e6757a48ec1e03f71aa7334088ae08b240155df63bf2a8e36764a9d9333');
  INSERT INTO blocks VALUES(310039,'5fa1ae9c5e8a599247458987b006ad3a57f686df1f7cc240bf119e911b56c347',310039000,NULL,NULL,'795c5652d9679942a02060edfb497b072009695d9a72fb144fa3591dba65a2ce','e42fc2488d02b706742e68b901f67512344283247b06cf2f22dedc9f277208c7','f3e2ad6c5fd105f8f6c21ee3a0de1b1c61f220e516e269b89bf2cf6c679c3470');
  INSERT INTO blocks VALUES(310040,'7200ded406675453eadddfbb2d14c2a4526c7dc2b5de14bd48b29243df5e1aa3',310040000,NULL,NULL,'e569e6e8083818e594e92b3356833e8dd54fcfcf5ed25af0d09e36e24b9dd441','24cddac7a7f2de85a731d867a760012105a615815e9fea47699c41f1b2a98309','43767cdff8d7b1fc48823b3c6abf367903c4a7778736cc7b69a5095c32674026');
  INSERT INTO blocks VALUES(310041,'5db592ff9ba5fac1e030cf22d6c13b70d330ba397f415340086ee7357143b359',310041000,NULL,NULL,'2247fcc633175a91921d226f412e56822379c79ca799117c39ecaaca0a702192','08cf35151a639a552a1868d030b91f7287c463d74a1144f468fcbc3e0affe1df','65720a35ec9758bdf0423b37dc8b9230477495ae7f3b4f3ba525d0f5e91d514f');
  INSERT INTO blocks VALUES(310042,'826fd4701ef2824e9559b069517cd3cb990aff6a4690830f78fc845ab77fa3e4',310042000,NULL,NULL,'0246c3a2a70b33a038ccdb816f6b0922a50d08310f360cbd5db4df58e97fc4dd','58171ec1b64f6d95d94ebecf089874b106b1544422dbaee4200040e096af7248','8ce0047e19847a94995f4fe7a004f93715341a62904a0cbd82704fecc44c088d');
  INSERT INTO blocks VALUES(310043,'2254a12ada208f1dd57bc17547ecaf3c44720323c47bc7d4b1262477cb7f3c51',310043000,NULL,NULL,'cbe39e9d1a132cdc568f893bbc3d4f55d27bacf7af31f027ebea1b4bed9f0009','21090ddee12db3da4caa1c2a6c78b577fb4be82015005a9160edcf1b8c994192','e4212ff27b1898df4fcd54101f7c39b8ceb85cdd346eb98e41321b2d404e121b');
  INSERT INTO blocks VALUES(310044,'3346d24118d8af0b3c6bcc42f8b85792e7a2e7036ebf6e4c25f4f6723c78e46b',310044000,NULL,NULL,'1202b05e118f0940ce270d9002d010076115a0197d889fee2d971a77709899bc','d2262c8e4281eb175a12e456fd200c149fb3f9af4fda593c4b78b3a3ca666651','d6351cb9686f71ed50beb13bb1fdff729f75d1979b700cc4153b78246636e4fe');
  INSERT INTO blocks VALUES(310045,'7bba0ab243839e91ad1a45a762bf074011f8a9883074d68203c6d1b46fffde98',310045000,NULL,NULL,'0bc49f765419c0b5b4911cccf03b0d9959aabacda266480b98245de0c0d35fc5','9f4b90d44c9f404ae8e24cf85933007b22b0acc377f360637d507c3da8f8206c','2bbdc9601860b4f0d4b778ff46f2cae6d046c417850288cf1686d79e76879d0f');
  INSERT INTO blocks VALUES(310046,'47db6788c38f2d6d712764979e41346b55e78cbb4969e0ef5c4336faf18993a6',310046000,NULL,NULL,'e42bf9806d0ff3a0663756f7955b30735747d14fcb0915c89884baa12795163d','eaacd7db19d79eec28bc87ca8d6260ebdd28d279825ae31dd5b6212168bf79a9','a2b44fcf3ed2bfac6e1e555af46721af837ed7f8e725968db0e513a0ec59da8e');
  INSERT INTO blocks VALUES(310047,'a9ccabcc2a098a7d25e4ab8bda7c4e66807eefa42e29890dcd88149a10de7075',310047000,NULL,NULL,'b19b5e14741284b4ca06b736120e903363651460a6efb3ede1aca3a4f3c00df1','3299d3ec1b6294cb2024c87c6997fd56c90c70a1e9d784f00ecbbd45294bdd0e','71dfedd101bd18169ecfbe9d37108bcf89304c2ace724f43319e9d1fff93b8b3');
  INSERT INTO blocks VALUES(310048,'610bf3935a85b05a98556c55493c6de45bed4d7b3b6c8553a984718765796309',310048000,NULL,NULL,'e870de901ba86d65d0e2053251ffb32cc7dffb55fcc2efbc006a2b9137314a39','8a5d199d0d958fd903f752fa2a36678e961cd6f027913e16f2acf0c116e7c3cc','7a850412efe622dd0ba3612cc543a5afd363a36ead93b2cc65c586aa4c4a0a6e');
  INSERT INTO blocks VALUES(310049,'4ad2761923ad49ad2b283b640f1832522a2a5d6964486b21591b71df6b33be3c',310049000,NULL,NULL,'44cf354cdc8552ed37e5911340397d3531d0ba45100feae27377130d4ddef359','d6499b3b3b29d2a409635a4d953f8e93df6e9e61738e69111c414b57302d213f','2c5e8d0c3ec258cf1aa2a6660124f416a7bed6acba596a603e2e4cf1f43fc6d3');
  INSERT INTO blocks VALUES(310050,'8cfeb60a14a4cec6e9be13d699694d49007d82a31065a17890383e262071e348',310050000,NULL,NULL,'7d72f11f48ac99553e1b2c52a7ff5645fbe05728a10a002727b9270dbb32daed','6bb3b07573fdc7483e7a7c3494c55dab6b31bdb0ec24dcea3ff907a97c50d362','a2882b2950066a928beac81571c576a1ffef3cb3d04a4d1c57c28c03cb90f090');
  INSERT INTO blocks VALUES(310051,'b53c90385dd808306601350920c6af4beb717518493fd23b5c730eea078f33e6',310051000,NULL,NULL,'35a965dc90686fc4eb20450da81ca8db9125e25c2cdd7146fd61d98841d80c24','59ce15e92bb04cbdd95b690691f33ac0fd7a35138039016255282d4c7ef41c8b','accabbf7739efa8ade77afed985899a525f00c789ccb043a599d7056ddee8d56');
  INSERT INTO blocks VALUES(310052,'0acdacf4e4b6fca756479cb055191b367b1fa433aa558956f5f08fa5b7b394e2',310052000,NULL,NULL,'8604d503e7194ee1c8ebe1143019207b2aad163655107a3d23d018ef26cef550','c2ac33247bce88bff40fe4221b60e7b8e4aff7b64f26554c7a954d734be8c5ea','e345343baedc221dd9d8eb2f3a59f5966a903c58e76b14925717a7db82d54a9d');
  INSERT INTO blocks VALUES(310053,'68348f01b6dc49b2cb30fe92ac43e527aa90d859093d3bf7cd695c64d2ef744f',310053000,NULL,NULL,'ecdb64ffc44490eeb12199d2da5c1189c07f4102f5b91494cbe4ec68fe6bb6d4','391445eb2e112e8845244332b586b23ad0c9f11037336142eb317b51f6fee16b','f0f0735b81b25337b3d84a004ac04d1c9b4b05a5c8f214591c1e344ed81b7daa');
  INSERT INTO blocks VALUES(310054,'a8b5f253df293037e49b998675620d5477445c51d5ec66596e023282bb9cd305',310054000,NULL,NULL,'b96b0d51d6327284f5922b65e5d023afd2b2e44c9e11f435afbe2a71df4e6eb2','0d817401e9907d28a03bbd685dc10f70217dd6b9be21246c8c94930a7132329f','7f819515316fd9196df77318d069ae9ef0d746f17eb9a15b482eca1925f9dfa5');
  INSERT INTO blocks VALUES(310055,'4b069152e2dc82e96ed8a3c3547c162e8c3aceeb2a4ac07972f8321a535b9356',310055000,NULL,NULL,'c5be3fc23a9c41b7b78cc7df4ed13d1d35fdd7edab77c998cef5a5a5fe2a7d33','afc66bc7a19b647ffe0133b674a4306b86f22dd56edb4471c95cacd4edbe20ca','7b056a283ef6010f2a119141c34729712a09ea7186c5c64d191222701c9e6165');
  INSERT INTO blocks VALUES(310056,'7603eaed418971b745256742f9d2ba70b2c2b2f69f61de6cc70e61ce0336f9d3',310056000,NULL,NULL,'faa7cf6128f229fe3d408797c77ef2972eb28d16542b32ec87c5fd42d2495018','386ffd3667146cd26c3138903a980bfc455964904ce8e82f0224c7c15dfe7ac3','584ef3d7a363a8d390a181c2ab095ecf5769d46c334d7aab0f91bbec3e00d8aa');
  INSERT INTO blocks VALUES(310057,'4a5fdc84f2d66ecb6ee3e3646aad20751ce8694e64e348d3c8aab09d33a3e411',310057000,NULL,NULL,'135af680c59a3d707ff3e6b67fbbb0aaaf0a97724d36ba584087658ae8c0db19','e1d0391d21eca721f2c6f44a075f69b0d136c1807105dd057c9ba44d66ca75d8','f7bd8caa4432635ca406fe28d620e48d4b0afe9331c7081e9f87c350f9bf9e9c');
  INSERT INTO blocks VALUES(310058,'a6eef3089896f0cae0bfe9423392e45c48f4efe4310b14d8cfbdb1fea613635f',310058000,NULL,NULL,'496b559ef740feabe42d55356bc770bab7b927d79260c22848b7f47d51918f11','3b9e23dcd7439d71beeee8fc1dbcb1dc228d41da9cd8c4aa059a371a9448f811','1f6c2c6219077bf9df5c8cee460f630276a85f8da1d0f602f95bfde54353e0a5');
  INSERT INTO blocks VALUES(310059,'ab505de874c43f97c90be1c26a769e6c5cb140405c993b4a6cc7afc795f156a9',310059000,NULL,NULL,'608eb77e572aa596c9e14c6e4cb1dc1993bcbcfe735cf0453124c2801192ecc9','abb2bb8c78547f58e88dfba4b2fd4fa5d0c70f414c1222c850e7b746e3ac8a5b','864cd57e3f1eb01023930669257fef6b37570b0eaf2d6cdb87cb7fdffa6d2fc8');
  INSERT INTO blocks VALUES(310060,'974ad5fbef621e0a38eab811608dc9afaf10c8ecc85fed913075ba1a145e889b',310060000,NULL,NULL,'bc5c375d1237425486c9f46bd749fba20b5635bcaf3e2d9178b35ddfbb700f14','1478a0099c77e6991e35ab6fbdaed41f6812fd43ac7d2bbc83d8e6442559f304','ffe51f8636dc116089de2d0c54980677b39b3c86464b242df11659b09c212361');
  INSERT INTO blocks VALUES(310061,'35d267d21ad386e7b7632292af1c422b0310dde7ca49a82f9577525a29c138cf',310061000,NULL,NULL,'c6d48d72746c0e18fa0f1b0b16f663869be2c4684a9d98b634e691ea495f4d81','942c318b5e4c3ff92c33df7f25acb1dfec635b6552dff548fbb2fac75ed360ee','ee0404237c27fb1a2ac804b9e5165e98271635330d5336f3c9603f8f7ffc956d');
  INSERT INTO blocks VALUES(310062,'b31a0054145319ef9de8c1cb19df5bcf4dc8a1ece20053aa494e5d3a00a2852f',310062000,NULL,NULL,'8deffdb1602f1aa2d0d1956d2297ba30ac78901ea27eb223ad8bf7ca83b18110','b0dfbd59db113072f7692fb53a696ce539f07838c2f920b62d72d4379fe0d9a2','be2f8d85577f7f88b544db97edac8864e0a76cc0f521464bab0a9a12bcf08d67');
  INSERT INTO blocks VALUES(310063,'0cbcbcd5b7f2dc288e3a34eab3d4212463a5a56e886804fb4f9f1cf929eadebe',310063000,NULL,NULL,'34859861f240c6553ffbf63fff9bc884f231276ec6173964d5fc6641a6d79b16','26149d8a88bcc7cf6ea6d1d5b3629eeaf99fd8304f5755e82aad549a9e986fdc','4159d43acb4aded5687e9f81105884bf5d5783b3b083334741a214aa4d406b7e');
  INSERT INTO blocks VALUES(310064,'e2db8065a195e85cde9ddb868a17d39893a60fb2b1255aa5f0c88729de7cbf30',310064000,NULL,NULL,'fa185f9b97a1666ce3b966dc09b8a7870ba55896a54a54f54d3420708d5a8ae0','dfbb97c5c74e0cb4a79de6e8a0321f4e83217af17bbb1f304427871d637e28eb','dda985cdade4eb449a3f37a1a63f9502f337627c521c67677a775b63072bfac3');
  INSERT INTO blocks VALUES(310065,'8a7bc7a77c831ac4fd11b8a9d22d1b6a0661b07cef05c2e600c7fb683b861d2a',310065000,NULL,NULL,'9f75da9f944d59b1841d690b2994ead7fb0ee3d679ddbdb0b692e49238f66603','11a4debf5c39121329596bbebc7b3cd092220e62fad5c880757b403096a9b220','00d8454feae2726d875c1350713aa034130819b6f12dc495b1dc0458c6e4ee2d');
  INSERT INTO blocks VALUES(310066,'b6959be51eb084747d301f7ccaf9e75f2292c9404633b1532e3692659939430d',310066000,NULL,NULL,'4740587d203632d1b4061343436e25e12941f0f80be03c3ab390a1c08b842b59','e6b49b968947750d5dd81b1aa1e0a8de173caf04a34538d230c24b3e0af89459','15d3c1e3141a66b3b411199206474271dc24feed4cf19cc0a5887686aef759ed');
  INSERT INTO blocks VALUES(310067,'8b08eae98d7193c9c01863fac6effb9162bda010daeacf9e0347112f233b8577',310067000,NULL,NULL,'d6eecb0ca22f29b50e52cd5dec8f408250a7b1ddc61bfa9bf6cc6ef0a85a6ffc','6ec7fb40dfde6c070f454c8a18ad8b588a42d32ba1bfcda6c48f5e24da590c8a','bfa7e54de30770c2cbdb7a02c2784585d06e7356d1cba490ed4305d2b354d60d');
  INSERT INTO blocks VALUES(310068,'9280e7297ef6313341bc81787a36acfc9af58f83a415afff5e3154f126cf52b5',310068000,NULL,NULL,'1508605d4796eb2d8b0553b307827f570b5020f4cacf773926b6c8f2c1b003c8','155fe971815f4e9e10d27d65cfe569bf77c7ad88eaa133828ba3d2a9a390810d','e6d4e06b1735079cb2dd05b956c21ea85391f62cb1bfc1886cb9402191f74772');
  INSERT INTO blocks VALUES(310069,'486351f0655bf594ffaab1980cff17353b640b63e9c27239109addece189a6f7',310069000,NULL,NULL,'ea7afbe0817cfef5a5a940bf88b057d01d092182dd5d0c7fd156b6750fdf4cb2','e9e06033f3e983a6ea8c42f8c42e336ceadfaa05d55376027d3f902c9db32b0c','5a76669265580b4302fc0baa63a2ae174810b1d936d453c38904d1aa07960c31');
  INSERT INTO blocks VALUES(310070,'8739e99f4dee8bebf1332f37f49a125348b40b93b74fe35579dd52bfba4fa7e5',310070000,NULL,NULL,'f805d8bd0b724ffeb9e466367e8524bcbcf2c0fe0525b8ff2707af2013824a2c','30861c1756466031943619f3a3c937c513854924c8ff4722b3ab3ed3611109e9','9a741684a6ff1924925e7e6a9ab78277832ee3bcb6016091987d5e3e047fa0aa');
  INSERT INTO blocks VALUES(310071,'7a099aa1bba0ead577f1e44f35263a1f115ed6a868c98d4dd71609072ae7f80b',310071000,NULL,NULL,'305123423486d17e97e8370399b9079a35977465e4cf8c5b33d50bd7004b463b','6dfdaa3cea6523f38608c87f6f1dfab87ba208074761b62674669724083b4683','f434f74eed5fc1ba188fd773054d19cc57089d4a17a0e74b96cda7f0d4db737d');
  INSERT INTO blocks VALUES(310072,'7b17ecedc07552551b8129e068ae67cb176ca766ea3f6df74b597a94e3a7fc8a',310072000,NULL,NULL,'b04fcd2cf46165fa31626b476aa06f9ad8c8cd1d5aa1cfdc014e0d55fa7e0761','53e9133f8a9c6cb60ef1bcc852fe551599d309bcbd29e8aed4fd18a8b72c22e5','0c526b4a2b8096f18127a8b7b75d7449244af6b42be7be8de48e04e5562e8382');
  INSERT INTO blocks VALUES(310073,'ee0fe3cc9b3a48a2746b6090b63b442b97ea6055d48edcf4b2288396764c6943',310073000,NULL,NULL,'209f05567343042c8a9172138cc14e28a2e53f9addf16c7affa469fbea9728ae','2474222b38cb0beec52450d26b8a0521ecebc6886a85acb1d8b51e398b06b596','9692943b04bb25acf74819fcfd90d868b1e22c4bb424786ec7f1bdb5f66576cf');
  INSERT INTO blocks VALUES(310074,'ceab38dfde01f711a187601731ad575d67cfe0b7dbc61dcd4f15baaef72089fb',310074000,NULL,NULL,'fc18c0dcd6011c4147575f09bdc6e1eb0e6ae7d3144339859054df458651618a','5a99d067d1a6a5d5e33d832a792a6c263745501114d002088905418236346568','8f08ffb3d0ee7c5658ac7dcdff188dce6ff134a85f988ca542628229b5a38ba9');
  INSERT INTO blocks VALUES(310075,'ef547198c6e36d829f117cfd7077ccde45158e3c545152225fa24dba7a26847b',310075000,NULL,NULL,'f304dbebd02e4536b1754502e6f51e058ed309fdf95a2db8329dd7e5635824ad','dc2c8fcca1ab4ed77690d5ad72eaa2f345bc201f9c79fb5ab59455b444bbe9a2','9babb572a86e194022ead67d8e1fe2e274073bcbcc4d500ba462aa869e67672e');
  INSERT INTO blocks VALUES(310076,'3b0499c2e8e8f0252c7288d4ecf66efc426ca37aad3524424d14c8bc6f8b0d92',310076000,NULL,NULL,'f39c071315c869425bdbcf05ff84130a0860f5f47b4f851cea970f58a6edc9f8','0ac7bff9355b79f8e3ec5272504ba202d65ab9450e34d8c92229993c522c9691','91572b33ee58a78793eb4b686c3b4b6b866f9d4db4e367eb2124974a21b1a814');
  INSERT INTO blocks VALUES(310077,'d2adeefa9024ab3ff2822bc36acf19b6c647cea118cf15b86c6bc00c3322e7dd',310077000,NULL,NULL,'20624d783cd8e82044df58c05e6171a744505df43623d9c2a828c1331f505ca8','e17bb6ef0382d32f6ff93dc32a67bf560f55cf01fda842240774f18a25fc3472','1774aff1775bb01a303c562831b1ed543f5df86f4ac3a0f7feb198a5911acf27');
  INSERT INTO blocks VALUES(310078,'f6c17115ef0efe489c562bcda4615892b4d4b39db0c9791fe193d4922bd82cd6',310078000,NULL,NULL,'41ae6610121587bd8171a02da3c50645e8e6d3642aef2c560d46f12707506b66','f039b86ef220cb599e9556f12f51c42259802fa8ae172fb55e1730e75f148513','809541ce48cd8f3953346eca49980edc5fd5d089d2bb238c860c8483bf4b3ee7');
  INSERT INTO blocks VALUES(310079,'f2fbd2074d804e631db44cb0fb2e1db3fdc367e439c21ffc40d73104c4d7069c',310079000,NULL,NULL,'bbc2068f2a4b47c86198a5cb7242e26f385077126c7a3294eca6607485b1170b','9305177eb5f808653c880286437271c094ffb8f519e8c10f51fcc8fdd19ea732','ce124d884860c9b7248f320b435e54ba541b1e1715d38c0accd158d52058b5c5');
  INSERT INTO blocks VALUES(310080,'42943b914d9c367000a78b78a544cc4b84b1df838aadde33fe730964a89a3a6c',310080000,NULL,NULL,'fc4350d187ec74fa6dfbbca7f6c51849b78356f853c6c713d10ae4a39ee4f7e2','325e4cf30a62948dd50f054adbedd0443755006381a324f57ac14c8d27f7f011','957acea8f477a21225acf67d1876a2c6ad2da7c642e2544783f074cfb160eed2');
  INSERT INTO blocks VALUES(310081,'6554f9d307976249e7b7e260e08046b3b55d318f8b6af627fed5be3063f123c4',310081000,NULL,NULL,'3cadb90f0285d3e3bb107caa2165e88d855cfa057fcff1fccfb278a8f64c9b1c','7301e06a3aefc7f395698d2e9ce3e844b94865c84eca5293c8555585798a1c14','d49fbe45adb24ea86ac85fea2318f4091a9c26d596effd4a90596f47b8e9a58b');
  INSERT INTO blocks VALUES(310082,'4f1ef91b1dcd575f8ac2e66a67715500cbca154bd6f3b8148bb7015a6aa6c644',310082000,NULL,NULL,'f3390bff59484b5ce0d84f5034fc88f4d862334ef3c0d7addaa9be7f0e67006f','d80d7432dc26b3a8f935966757777d984c89844276e73e3c38c9dde1d4c6d991','fecb00c8aa26d1f1efb224ff2248e4a2c1da885819cfc2d971797ae30628702a');
  INSERT INTO blocks VALUES(310083,'9b1f6fd6ff9b0dc4e37603cfb0625f49067c775b99e12492afd85392d3c8d850',310083000,NULL,NULL,'0354bf318eaec5c79b4a7835c76c89f373ab0e413f9fe4ebdea442f57763a971','1f2ffc4bf75ff07c0bbe000af392fb69974069bdaec74b9e381ec8c18c67a5e8','e47c7f5896d23e75b18c5b7b3cd993924bc3bbcc7d3e047c2c183207c6273ac7');
  INSERT INTO blocks VALUES(310084,'1e0972523e80306441b9f4157f171716199f1428db2e818a7f7817ccdc8859e3',310084000,NULL,NULL,'e22b7a64e15ded24f6c54a5f627354dd2c3ed8175c2f4cd31aa5a6789d7b67e4','704bcae1bbeab09f7a04bb45ced511c9568d2fa36fb46e43793cd17e417f0cae','3b458c2ae798c5ad603d946c033d218b1cfd9caa0e4e6d72398ba6464d9f65d6');
  INSERT INTO blocks VALUES(310085,'c5b6e9581831e3bc5848cd7630c499bca26d9ece5156d36579bdb72d54817e34',310085000,NULL,NULL,'7b8a6f62709cf4d20820031f43d968ea46d73d8cee4ad40f414da60b9be4e676','fed501d12e79749110562556f61a520089ee62c48c3bd136c3f3a3e064cbd7b4','bd396755a5d8602cee181cccdda6c6f049f8e189b858d8f8bd5841170295624c');
  INSERT INTO blocks VALUES(310086,'080c1dc55a4ecf4824cf9840602498cfc35b5f84099f50b71b45cb63834c7a78',310086000,NULL,NULL,'ae82ee2f7f1e075937b5b8eef065f8643a7bef0428e00689ee773558905eef19','0d3a7183c84c14eac1d088ce03d5d62638a46240dfcd18bb19802ec2735d09f7','7924328176d4eb93ce13c0664d21c2a40b945c21853829b7bae2c132b2cfe09d');
  INSERT INTO blocks VALUES(310087,'4ec8cb1c38b22904e8087a034a6406b896eff4dd28e7620601c6bddf82e2738c',310087000,NULL,NULL,'ced371f1349e81cc2f179f064e4b9b202650a0f79e9b4513666ace29f0e8b3cb','65b03b0b4e86711db382923d510a8b8c374d7d91a265158bd76d028881f96be6','88602366635ef8561b8d00f71660643640e9e32ac8046977a3917de7c0baf3d2');
  INSERT INTO blocks VALUES(310088,'e945c815c433cbddd0bf8e66c5c23b51072483492acda98f5c2c201020a8c5b3',310088000,NULL,NULL,'6c343897092c5dfcd32ee96dc8b96f38fedd31fa58cf5757a3e15a254942cd59','d1a1d68d4bb45353d9416b5c9a381a46f470ff1ef4d7ed84a89ed930a34b0b90','12158802e3ca114cd21ee7660d4186bd9da9d4b9da3584d6de459d75eb8a0fdb');
  INSERT INTO blocks VALUES(310089,'0382437f895ef3e7e38bf025fd4f606fd44d4bbd6aea71dbdc4ed11a7cd46f33',310089000,NULL,NULL,'abc7afdaefa89bf58bc4c28401740657eca24c902ba551f55becb6a1c8992675','9daa29f3dade34ea52aaf665929c08ab4cfdad6146f5990af63ae5f65dc2d220','49bc3b48fb296a1cc4abefb0f976c731498871d3488b02d8fcf7ab1112d2ac59');
  INSERT INTO blocks VALUES(310090,'b756db71dc037b5a4582de354a3347371267d31ebda453e152f0a13bb2fae969',310090000,NULL,NULL,'4c8ca9b4eeae7adfec822b20665e7bd6fecb51d4f30cc2c826f18402d8401a9b','708e704befc57404cc9a8aff365f6c7a551f4e0ade5f4306afe7f5f61d2363c7','e93861961bbc6d2ef29a57c880cb7480bac835735fa4754cc136a33f9d771ad1');
  INSERT INTO blocks VALUES(310091,'734a9aa485f36399d5efb74f3b9c47f8b5f6fd68c9967f134b14cfe7e2d7583c',310091000,NULL,NULL,'fe7fd2b60c3216d79dfe4e6d38880f6d3b9fde747b619f2c477108825235663d','503741aa027d907eebb588de69f2e6e467e94e3b07725ff3743d53335a5cc9d7','11c10d805e442b6ebb4e210cec1c9c38279b5f3b58918fb0765140afa05cac92');
  INSERT INTO blocks VALUES(310092,'56386beb65f9228740d4ad43a1c575645f6daf59e0dd9f22551c59215b5e8c3d',310092000,NULL,NULL,'420b8ff3c159f7e89df2274682e7ef798a0c0233149365114bfd934c38806098','bf16ff697ef4e4b2f41a8c6eaeb5c022acb4514f5f141f7cdbe1263ba104193b','53fe650e241c4b4685f04ba614a9603e051ff82f7da278dd6a7230bb0ea98841');
  INSERT INTO blocks VALUES(310093,'a74a2425f2f4be24bb5f715173e6756649e1cbf1b064aeb1ef60e0b94b418ddc',310093000,NULL,NULL,'f4fac6a570b4f6332a628a3f8e27f5f081689fb4255363cff1cd8bd0244eecea','b7ef1f6c61cdf012c14d7bc8fb4b6f90390832bac973827396bb9f6b9dee9e72','a7ec18c66221f682cb57620fb668e94e63e64d968eb0623982fb6ea49a6673c5');
  INSERT INTO blocks VALUES(310094,'2a8f976f20c4e89ff01071915ac96ee35192d54df3a246bf61fd4a0cccfb5b23',310094000,NULL,NULL,'adea7b4cacc06ba1f7dc260f30039943936f5baeecf5a8a452d4cbcaa994a70d','0bffad5d3910aead7e1eb63ee327b9f1e203fa119ae9391d2290b08f7c0831cd','863d5376e6b17e6899a1b9334a8db0d8df0aedbd5d5125e65178ce37c1a54f91');
  INSERT INTO blocks VALUES(310095,'bed0fa40c9981223fb40b3be8124ca619edc9dd34d0c907369477ea92e5d2cd2',310095000,NULL,NULL,'a2290c6a24befab16b4d9ed768c3129d582edbafdf8a2326c7ed50397e5db674','fd0c7a177827bb5ebd0a3d0490e0ca1ddcc6823599212a44d948c0746ea52582','b356835b58287a7f6eedf3388c730ab000091753ea125d21d343b285f10b7086');
  INSERT INTO blocks VALUES(310096,'306aeec3db435fabffdf88c2f26ee83caa4c2426375a33daa2be041dbd27ea2f',310096000,NULL,NULL,'b3c321ea2fb119cbaacfb39f219be47cb346cdd40d895980afd34b4157a3b7ec','254fd4cfc2c3636fae0a1edbb355b5f07fb542e7a5885afecb7cd50c8b45c84b','f400d00019ebd19f97f57cbcef5ff643174a1c036aca4210cb205dd9231d7ae8');
  INSERT INTO blocks VALUES(310097,'13e8e16e67c7cdcc80d477491e554b43744f90e8e1a9728439a11fab42cefadf',310097000,NULL,NULL,'456a1bd4d6b30f24e798a9c1f975af109db030b0bca19db6b29788f938ce6c4d','ca6a989cd85b0f73757dae18386c5dff4847d165becb1f4cd04262ba1d847eb1','b22ef52d77c9572c5cf946302387b774a82e51038c1047169990131744bed7f8');
  INSERT INTO blocks VALUES(310098,'ca5bca4b5ec4fa6183e05176abe921cff884c4e20910fab55b603cef48dc3bca',310098000,NULL,NULL,'f48d6574488a24155420ae76aa7dcecfe73f6a262a2434a96eb2e93f6bbf02b6','a221e896c331a78d422602d354cfa9a85a73a5bb404af65cdec85ff7e3928983','e9bd7687474dbb570873554c0e6bbd216b9dc77837a322381c98808a76f5ed15');
  INSERT INTO blocks VALUES(310099,'3c4c2279cd7de0add5ec469648a845875495a7d54ebfb5b012dcc5a197b7992a',310099000,NULL,NULL,'e936debeb5d219215ba24e56ed34edb435131877c2947c0801824155fdc70c05','67e26c3ae5904cc0f8481a2f7d981a4ce03b2a9d0ab57bd28191441b15cb8e22','8b5ffc1a16f7821b17c4e22a45993fbde520a314cbb78b917917a466faf8d750');
  INSERT INTO blocks VALUES(310100,'96925c05b3c7c80c716f5bef68d161c71d044252c766ca0e3f17f255764242cb',310100000,NULL,NULL,'2b033a615b9eb693ed59daca9bc047f61a3519bec5c2b64f968cf717c75afe79','aa62bfa22a177fa198181fadb4fc3ae013946fd6462937f98962d4e048e62915','76312af13fbaca8329f7c7534d1101ba3b22e8e7360a221ebe42163c9092aa0e');
  INSERT INTO blocks VALUES(310101,'369472409995ca1a2ebecbad6bf9dab38c378ab1e67e1bdf13d4ce1346731cd6',310101000,NULL,NULL,'6a41dd11d8b611f6fde79e06a4f65d20fc15419f8336646130c02e9f7d87eff4','75e56fd76814a516f91939ef7d3ed0ab07039b01fe4eeb96d4b3ae2541d5f324','6c8ed4b19fa3dab6af57de0ddce468f87cbe8a7918bffbb870cb472bdb43ff75');
  -- 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,'3bd2702db834abf080054f2391e229d0ca8dc9d578256f23e744ad0e5997d4e8',310011,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000000,100.0,99999999,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(19,'6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09',310018,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000050,99.86166,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(20,'720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7',310019,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',1388000101,100.343,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(21,'6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c',310020,'1_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,'5a00de6476865f69b816639038b56d348e105a9ee9f7cfd741c42bc0841bec61',310004,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',50000000,'7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433','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,'9b6b1abb696d8d1b70c5beed046d7cddd23cd95b69ef18946cb18c5b56cfde30',310000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',62000000,93000000000,'valid');
  INSERT INTO burns VALUES(23,'c81cd36f1efabd22f1a00923714fd5a5f1ba07852ef1f0763223563e3f55dfda',310022,'1_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,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',93000000000,'burn','9b6b1abb696d8d1b70c5beed046d7cddd23cd95b69ef18946cb18c5b56cfde30');
  INSERT INTO credits VALUES(310001,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'send','896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6');
  INSERT INTO credits VALUES(310004,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',100000000,'btcpay','5a00de6476865f69b816639038b56d348e105a9ee9f7cfd741c42bc0841bec61');
  INSERT INTO credits VALUES(310005,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',1000000000,'issuance','59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d');
  INSERT INTO credits VALUES(310006,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',100000,'issuance','6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291');
  INSERT INTO credits VALUES(310007,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'send','c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595');
  INSERT INTO credits VALUES(310008,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'send','1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0');
  INSERT INTO credits VALUES(310009,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',24,'dividend','6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f');
  INSERT INTO credits VALUES(310010,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',420800,'dividend','462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087');
  INSERT INTO credits VALUES(310013,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',4250000,'filled','43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84');
  INSERT INTO credits VALUES(310014,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',5000000,'cancel order','e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433');
  INSERT INTO credits VALUES(310015,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531');
  INSERT INTO credits VALUES(310015,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531');
  INSERT INTO credits VALUES(310017,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9');
  INSERT INTO credits VALUES(310017,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',0,'filled','dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9');
  INSERT INTO credits VALUES(310018,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',59137500,'bet settled: liquidated for bear','6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09');
  INSERT INTO credits VALUES(310018,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',3112500,'feed fee','6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09');
  INSERT INTO credits VALUES(310019,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',159300000,'bet settled','720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7');
  INSERT INTO credits VALUES(310019,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',315700000,'bet settled','720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7');
  INSERT INTO credits VALUES(310019,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',25000000,'feed fee','720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7');
  INSERT INTO credits VALUES(310020,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',1330000000,'bet settled: for notequal','6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c');
  INSERT INTO credits VALUES(310020,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',70000000,'feed fee','6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c');
  INSERT INTO credits VALUES(310022,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',56999887262,'burn','c81cd36f1efabd22f1a00923714fd5a5f1ba07852ef1f0763223563e3f55dfda');
  INSERT INTO credits VALUES(310023,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',8500000,'recredit wager remaining','19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9');
  INSERT INTO credits VALUES(310023,'1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10000,'send','d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657');
  INSERT INTO credits VALUES(310032,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',50000000,'cancel order','9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3');
  -- 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,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'send','896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6');
  INSERT INTO debits VALUES(310003,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',105000000,'open order','e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433');
  INSERT INTO debits VALUES(310005,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'issuance fee','59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d');
  INSERT INTO debits VALUES(310006,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'issuance fee','6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291');
  INSERT INTO debits VALUES(310007,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'send','c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595');
  INSERT INTO debits VALUES(310008,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'send','1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0');
  INSERT INTO debits VALUES(310009,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',24,'dividend','6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f');
  INSERT INTO debits VALUES(310009,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',20000,'dividend fee','6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f');
  INSERT INTO debits VALUES(310010,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',420800,'dividend','462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087');
  INSERT INTO debits VALUES(310010,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',20000,'dividend fee','462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087');
  INSERT INTO debits VALUES(310012,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'bet','19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9');
  INSERT INTO debits VALUES(310013,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',25000000,'bet','43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84');
  INSERT INTO debits VALUES(310014,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',150000000,'bet','1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d');
  INSERT INTO debits VALUES(310015,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',350000000,'bet','005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531');
  INSERT INTO debits VALUES(310016,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',750000000,'bet','e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da');
  INSERT INTO debits VALUES(310017,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',650000000,'bet','dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9');
  INSERT INTO debits VALUES(310021,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',50000000,'open order','9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3');
  INSERT INTO debits VALUES(310023,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',10000,'send','d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657');
  -- 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,'6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f',310009,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB','XUP',600,20000,'valid');
  INSERT INTO dividends VALUES(11,'462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087',310010,'1_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,'59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d',0,310005,'BBBB',1000000000,1,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',0,0,0,0.0,'',50000000,0,'valid',NULL);
  INSERT INTO issuances VALUES(7,'6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291',0,310006,'BBBC',100000,0,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310000, "event": "9b6b1abb696d8d1b70c5beed046d7cddd23cd95b69ef18946cb18c5b56cfde30", "quantity": 93000000000}',0);
  INSERT INTO messages VALUES(1,310000,'insert','burns','{"block_index": 310000, "burned": 62000000, "earned": 93000000000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "9b6b1abb696d8d1b70c5beed046d7cddd23cd95b69ef18946cb18c5b56cfde30", "tx_index": 1}',0);
  INSERT INTO messages VALUES(2,310001,'insert','debits','{"action": "send", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310001, "event": "896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(3,310001,'insert','credits','{"action": "send", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310001, "event": "896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(4,310001,'insert','sends','{"asset": "XUP", "block_index": 310001, "destination": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 50000000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1", "tx_index": 3}',0);
  INSERT INTO messages VALUES(6,310003,'insert','debits','{"action": "open order", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310003, "event": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "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": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1"}',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": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433"}',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": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "match_expire_index": 310023, "status": "pending", "tx0_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_block_index": 310002, "tx0_expiration": 10, "tx0_hash": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1", "tx0_index": 3, "tx1_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_block_index": 310003, "tx1_expiration": 10, "tx1_hash": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "tx1_index": 4}',0);
  INSERT INTO messages VALUES(11,310004,'insert','credits','{"action": "btcpay", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310004, "event": "5a00de6476865f69b816639038b56d348e105a9ee9f7cfd741c42bc0841bec61", "quantity": 100000000}',0);
  INSERT INTO messages VALUES(12,310004,'update','order_matches','{"order_match_id": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "status": "completed"}',0);
  INSERT INTO messages VALUES(13,310004,'insert','btcpays','{"block_index": 310004, "btc_amount": 50000000, "destination": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "order_match_id": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "5a00de6476865f69b816639038b56d348e105a9ee9f7cfd741c42bc0841bec61", "tx_index": 5}',0);
  INSERT INTO messages VALUES(14,310005,'insert','debits','{"action": "issuance fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310005, "event": "59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "locked": false, "quantity": 1000000000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "transfer": false, "tx_hash": "59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d", "tx_index": 6}',0);
  INSERT INTO messages VALUES(16,310005,'insert','credits','{"action": "issuance", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310005, "event": "59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d", "quantity": 1000000000}',0);
  INSERT INTO messages VALUES(17,310006,'insert','debits','{"action": "issuance fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310006, "event": "6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "locked": false, "quantity": 100000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "transfer": false, "tx_hash": "6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291", "tx_index": 7}',0);
  INSERT INTO messages VALUES(19,310006,'insert','credits','{"action": "issuance", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310006, "event": "6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291", "quantity": 100000}',0);
  INSERT INTO messages VALUES(20,310007,'insert','debits','{"action": "send", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310007, "event": "c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(21,310007,'insert','credits','{"action": "send", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310007, "event": "c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(22,310007,'insert','sends','{"asset": "BBBB", "block_index": 310007, "destination": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 4000000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595", "tx_index": 8}',0);
  INSERT INTO messages VALUES(23,310008,'insert','debits','{"action": "send", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310008, "event": "1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0", "quantity": 526}',0);
  INSERT INTO messages VALUES(24,310008,'insert','credits','{"action": "send", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310008, "event": "1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0", "quantity": 526}',0);
  INSERT INTO messages VALUES(25,310008,'insert','sends','{"asset": "BBBC", "block_index": 310008, "destination": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 526, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0", "tx_index": 9}',0);
  INSERT INTO messages VALUES(26,310009,'insert','debits','{"action": "dividend", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f", "quantity": 24}',0);
  INSERT INTO messages VALUES(27,310009,'insert','debits','{"action": "dividend fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f", "quantity": 20000}',0);
  INSERT INTO messages VALUES(28,310009,'insert','credits','{"action": "dividend", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310009, "event": "6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f", "tx_index": 10}',0);
  INSERT INTO messages VALUES(30,310010,'insert','debits','{"action": "dividend", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087", "quantity": 420800}',0);
  INSERT INTO messages VALUES(31,310010,'insert','debits','{"action": "dividend fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087", "quantity": 20000}',0);
  INSERT INTO messages VALUES(32,310010,'insert','credits','{"action": "dividend", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310010, "event": "462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087", "tx_index": 11}',0);
  INSERT INTO messages VALUES(34,310011,'insert','broadcasts','{"block_index": 310011, "fee_fraction_int": 99999999, "locked": false, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000000, "tx_hash": "3bd2702db834abf080054f2391e229d0ca8dc9d578256f23e744ad0e5997d4e8", "tx_index": 12, "value": 100.0}',0);
  INSERT INTO messages VALUES(35,310012,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310012, "event": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 15120, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "tx_index": 13, "wager_quantity": 50000000, "wager_remaining": 50000000}',0);
  INSERT INTO messages VALUES(37,310013,'update','orders','{"status": "expired", "tx_hash": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1"}',0);
  INSERT INTO messages VALUES(38,310013,'insert','order_expirations','{"block_index": 310013, "order_hash": "7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1", "order_index": 3, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(39,310013,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310013, "event": "43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 15120, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "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": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "wager_remaining": 8500000}',0);
  INSERT INTO messages VALUES(42,310013,'insert','credits','{"action": "filled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310013, "event": "43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "quantity": 4250000}',0);
  INSERT INTO messages VALUES(43,310013,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 41500000, "id": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "initial_value": 100.0, "leverage": 15120, "match_expire_index": 310022, "status": "pending", "target_value": 0.0, "tx0_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 0, "tx0_block_index": 310012, "tx0_expiration": 10, "tx0_hash": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "tx0_index": 13, "tx1_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 1, "tx1_block_index": 310013, "tx1_expiration": 10, "tx1_hash": "43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "tx1_index": 14}',0);
  INSERT INTO messages VALUES(45,310014,'update','orders','{"status": "expired", "tx_hash": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433"}',0);
  INSERT INTO messages VALUES(46,310014,'insert','credits','{"action": "cancel order", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310014, "event": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "quantity": 5000000}',0);
  INSERT INTO messages VALUES(47,310014,'insert','order_expirations','{"block_index": 310014, "order_hash": "e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433", "order_index": 4, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(48,310014,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310014, "event": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d", "tx_index": 15, "wager_quantity": 150000000, "wager_remaining": 150000000}',0);
  INSERT INTO messages VALUES(50,310015,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 0.0, "tx_hash": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "tx_index": 16, "wager_quantity": 350000000, "wager_remaining": 350000000}',0);
  INSERT INTO messages VALUES(52,310015,'insert','credits','{"action": "filled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "quantity": 0}',0);
  INSERT INTO messages VALUES(53,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(54,310015,'insert','credits','{"action": "filled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310015, "event": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "quantity": 0}',0);
  INSERT INTO messages VALUES(55,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 150000000, "id": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310024, "status": "pending", "target_value": 0.0, "tx0_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 0, "tx0_block_index": 310014, "tx0_expiration": 10, "tx0_hash": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d", "tx0_index": 15, "tx1_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 1, "tx1_block_index": 310015, "tx1_expiration": 10, "tx1_hash": "005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "tx1_index": 16}',0);
  INSERT INTO messages VALUES(57,310016,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310016, "event": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 1.0, "tx_hash": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da", "tx_index": 17, "wager_quantity": 750000000, "wager_remaining": 750000000}',0);
  INSERT INTO messages VALUES(59,310017,'insert','debits','{"action": "bet", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "leverage": 5040, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "target_value": 1.0, "tx_hash": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "tx_index": 18, "wager_quantity": 650000000, "wager_remaining": 650000000}',0);
  INSERT INTO messages VALUES(61,310017,'insert','credits','{"action": "filled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "quantity": 0}',0);
  INSERT INTO messages VALUES(62,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(63,310017,'insert','credits','{"action": "filled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310017, "event": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "quantity": 0}',0);
  INSERT INTO messages VALUES(64,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "forward_quantity": 750000000, "id": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310026, "status": "pending", "target_value": 1.0, "tx0_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx0_bet_type": 2, "tx0_block_index": 310016, "tx0_expiration": 10, "tx0_hash": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da", "tx0_index": 17, "tx1_address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "tx1_bet_type": 3, "tx1_block_index": 310017, "tx1_expiration": 10, "tx1_hash": "dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "tx1_index": 18}',0);
  INSERT INTO messages VALUES(66,310018,'insert','broadcasts','{"block_index": 310018, "fee_fraction_int": 5000000, "locked": false, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000050, "tx_hash": "6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09", "tx_index": 19, "value": 99.86166}',0);
  INSERT INTO messages VALUES(67,310018,'insert','credits','{"action": "bet settled: liquidated for bear", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310018, "event": "6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09", "quantity": 59137500}',0);
  INSERT INTO messages VALUES(68,310018,'insert','credits','{"action": "feed fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310018, "event": "6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09", "quantity": 3112500}',0);
  INSERT INTO messages VALUES(69,310018,'insert','bet_match_resolutions','{"bear_credit": 59137500, "bet_match_id": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "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": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84", "status": "settled: liquidated for bear"}',0);
  INSERT INTO messages VALUES(71,310019,'insert','broadcasts','{"block_index": 310019, "fee_fraction_int": 5000000, "locked": false, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000101, "tx_hash": "720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7", "tx_index": 20, "value": 100.343}',0);
  INSERT INTO messages VALUES(72,310019,'insert','credits','{"action": "bet settled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7", "quantity": 159300000}',0);
  INSERT INTO messages VALUES(73,310019,'insert','credits','{"action": "bet settled", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7", "quantity": 315700000}',0);
  INSERT INTO messages VALUES(74,310019,'insert','credits','{"action": "feed fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310019, "event": "720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7", "quantity": 25000000}',0);
  INSERT INTO messages VALUES(75,310019,'insert','bet_match_resolutions','{"bear_credit": 315700000, "bet_match_id": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "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": "1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531", "status": "settled"}',0);
  INSERT INTO messages VALUES(77,310020,'insert','broadcasts','{"block_index": 310020, "fee_fraction_int": 5000000, "locked": false, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "text": "Unit Test", "timestamp": 1388000201, "tx_hash": "6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c", "tx_index": 21, "value": 2.0}',0);
  INSERT INTO messages VALUES(78,310020,'insert','credits','{"action": "bet settled: for notequal", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310020, "event": "6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c", "quantity": 1330000000}',0);
  INSERT INTO messages VALUES(79,310020,'insert','credits','{"action": "feed fee", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310020, "event": "6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c", "quantity": 70000000}',0);
  INSERT INTO messages VALUES(80,310020,'insert','bet_match_resolutions','{"bear_credit": null, "bet_match_id": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "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": "e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9", "status": "settled: for notequal"}',0);
  INSERT INTO messages VALUES(82,310021,'insert','debits','{"action": "open order", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310021, "event": "9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3", "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": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "open", "tx_hash": "9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3", "tx_index": 22}',0);
  INSERT INTO messages VALUES(84,310022,'insert','credits','{"action": "burn", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310022, "event": "c81cd36f1efabd22f1a00923714fd5a5f1ba07852ef1f0763223563e3f55dfda", "quantity": 56999887262}',0);
  INSERT INTO messages VALUES(85,310022,'insert','burns','{"block_index": 310022, "burned": 38000000, "earned": 56999887262, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "c81cd36f1efabd22f1a00923714fd5a5f1ba07852ef1f0763223563e3f55dfda", "tx_index": 23}',0);
  INSERT INTO messages VALUES(86,310023,'update','bets','{"status": "expired", "tx_hash": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9"}',0);
  INSERT INTO messages VALUES(87,310023,'insert','credits','{"action": "recredit wager remaining", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "XUP", "block_index": 310023, "event": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "quantity": 8500000}',0);
  INSERT INTO messages VALUES(88,310023,'insert','bet_expirations','{"bet_hash": "19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9", "bet_index": 13, "block_index": 310023, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2"}',0);
  INSERT INTO messages VALUES(89,310023,'insert','debits','{"action": "send", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310023, "event": "d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657", "quantity": 10000}',0);
  INSERT INTO messages VALUES(90,310023,'insert','credits','{"action": "send", "address": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBC", "block_index": 310023, "event": "d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657", "quantity": 10000}',0);
  INSERT INTO messages VALUES(91,310023,'insert','sends','{"asset": "BBBC", "block_index": 310023, "destination": "1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "quantity": 10000, "source": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "status": "valid", "tx_hash": "d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657", "tx_index": 24}',0);
  INSERT INTO messages VALUES(92,310032,'update','orders','{"status": "expired", "tx_hash": "9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3"}',0);
  INSERT INTO messages VALUES(93,310032,'insert','credits','{"action": "cancel order", "address": "1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2", "asset": "BBBB", "block_index": 310032, "event": "9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(94,310032,'insert','order_expirations','{"block_index": 310032, "order_hash": "9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3", "order_index": 22, "source": "1_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,'7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310013);
  INSERT INTO order_expirations VALUES(4,'e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',310014);
  INSERT INTO order_expirations VALUES(22,'9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3','1_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('7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433',3,'7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',4,'e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433','1_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,'7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1',310002,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UNO',50000000,0,'XUP',100000000,0,10,310012,0,0,1000000,142858,'expired');
  INSERT INTO orders VALUES(4,'e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433',310003,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',105000000,5000000,'UNO',50000000,0,10,310013,900000,42858,6800,6800,'expired');
  INSERT INTO orders VALUES(22,'9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3',310021,'1_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,'896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6',310001,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','XUP',50000000,'valid',0,NULL);
  INSERT INTO sends VALUES(8,'c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595',310007,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBB',4000000,'valid',0,NULL);
  INSERT INTO sends VALUES(9,'1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0',310008,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','BBBC',526,'valid',0,NULL);
  INSERT INTO sends VALUES(24,'d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657',310023,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_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,'9b6b1abb696d8d1b70c5beed046d7cddd23cd95b69ef18946cb18c5b56cfde30',310000,'505d8d82c4ced7daddef7ed0b05ba12ecc664176887b938ef56c6af276f3b30c',310000000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UUnoPartyXburnTestnetXXXXXXXXFEeN4',62000000,5625,X'',1);
  INSERT INTO transactions VALUES(2,'896436390e05977c173311d54cddacbb898bdbf1bb11bd4b7e4932004eb00df6',310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'0000000000000000000000010000000002FAF080',1);
  INSERT INTO transactions VALUES(3,'7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1',310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,1000000,X'0000000A00000000000000000000000002FAF08000000000000000010000000005F5E100000A0000000000000000',1);
  INSERT INTO transactions VALUES(4,'e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433',310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000000A00000000000000010000000006422C4000000000000000000000000002FAF080000A00000000000DBBA0',1);
  INSERT INTO transactions VALUES(5,'5a00de6476865f69b816639038b56d348e105a9ee9f7cfd741c42bc0841bec61',310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',50000000,9675,X'0000000B7A78DF734FD910FCF9170D4AF753C2CEDA92974684B929FF595E6063CA5A2CF1E75417825D1FE276BFB329960A3367C711DCB256AA2ED21DA0F79A58120E2433',1);
  INSERT INTO transactions VALUES(6,'59c87f1f8a28eece244652b6284b40681a2620bfae8b58c32f303e55f06be41d',310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'000000140000000000004767000000003B9ACA000100000000000000000000',1);
  INSERT INTO transactions VALUES(7,'6573e8856c4451ae0b0fa39453dc25be1050599a1473933b57b0c093d63e6291',310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000014000000000000476800000000000186A00000000000000000000006666F6F626172',1);
  INSERT INTO transactions VALUES(8,'c62b0567e929ffc2529da427a5b0df1968b53a0436a1d28aa76fce3705b6b595',310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000000000000000000476700000000003D0900',1);
  INSERT INTO transactions VALUES(9,'1935e06458e6ab179a84307d47dcd442e0b2e1c172c5fb929eafa3a57225d1b0',310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_UXJo7MANGsCfJM8LwRdkRsWWBxw6Tdshxt_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'000000000000000000004768000000000000020E',1);
  INSERT INTO transactions VALUES(10,'6034362e83be4663c7782fd2f4695d672656a7c78e89a475bb426ab75d8ebd4f',310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000032000000000000025800000000000047670000000000000001',1);
  INSERT INTO transactions VALUES(11,'462fcf127cd185723fd0027955f8749e9cfe6c20ebdfc997ff626ab2cae93087',310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'00000032000000000000032000000000000047680000000000000001',1);
  INSERT INTO transactions VALUES(12,'3bd2702db834abf080054f2391e229d0ca8dc9d578256f23e744ad0e5997d4e8',310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB3300405900000000000005F5E0FF09556E69742054657374',1);
  INSERT INTO transactions VALUES(13,'19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9',310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000052BB33640000000002FAF08000000000017D7840000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(14,'43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84',310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000152BB336400000000017D78400000000002793D60000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(15,'1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d',310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000052BB33640000000008F0D1800000000014DC93800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(16,'005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531',310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000152BB33640000000014DC93800000000008F0D1800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(17,'e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da',310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000252BB33C8000000002CB417800000000026BE36803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(18,'dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9',310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2',7800,7650,X'00000028000352BB33C80000000026BE3680000000002CB417803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(19,'6b37e7c729d923e82bd81ad87917384173f636edead62da66946e1363e652b09',310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB33324058F7256FFC115E004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(20,'720f72ac87f58f8763cccee598dbd4e39c2f27f7e37aed78bf532f3f176dcda7',310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB3365405915F3B645A1CB004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(21,'6e29568b84864b47c5e677a8a32b4e5527998f9bc3f6cb9aedece456e267cd3c',310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000001E52BB33C94000000000000000004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(22,'9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3',310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','',0,6800,X'0000000A00000000000047670000000002FAF08000000000000000010000000002FAF080000A0000000000000000',1);
  INSERT INTO transactions VALUES(23,'c81cd36f1efabd22f1a00923714fd5a5f1ba07852ef1f0763223563e3f55dfda',310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','UUnoPartyXburnTestnetXXXXXXXXFEeN4',100000000,14675,X'',1);
  INSERT INTO transactions VALUES(24,'d37210d41a23ada8baf982a85190a742f7de9901f585e99e30ed3c9694efb657',310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,'1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2','1_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=''1_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=''1_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=''7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1'',block_index=310002,source=''1_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=''e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433'',block_index=310003,source=''1_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=''1_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=''7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1_e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433'',tx0_index=3,tx0_hash=''7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1'',tx0_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=4,tx1_hash=''e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433'',tx1_address=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''1_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=''7a78df734fd910fcf9170d4af753c2ceda92974684b929ff595e6063ca5a2cf1'',block_index=310002,source=''1_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=''1_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=''19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9'',block_index=310012,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84'',block_index=310013,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''e75417825d1fe276bfb329960a3367c711dcb256aa2ed21da0f79a58120e2433'',block_index=310003,source=''1_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=''1_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=''1_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=''1_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=''1_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=''1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d'',block_index=310014,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531'',block_index=310015,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''1_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=''1_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=''e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da'',block_index=310016,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9'',block_index=310017,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''1_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=''19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9_43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84'',tx0_index=13,tx0_hash=''19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9'',tx0_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=14,tx1_hash=''43ee1168ce7525c84fbeee2e49ac0edc3daa3ee8c2edbbba326d566ab63d5e84'',tx1_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''1_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=''1_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=''1_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=''1_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=''1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d_005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531'',tx0_index=15,tx0_hash=''1cc9fa85ad3849ffa70d00b586b75fa07e2676cfa57d31460ec34eaabf82717d'',tx0_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=16,tx1_hash=''005f98de7188c26ee7e5ce182204ec7c795284be40c684ad71da1d7999820531'',tx1_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''1_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=''1_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=''1_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=''e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da_dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9'',tx0_index=17,tx0_hash=''e1f35692651c646ba75bbdf931aa9240e23711f221960865410a03dd400243da'',tx0_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx1_index=18,tx1_hash=''dac4afb8fd0b05fd03635f95edd43fb2c8caf5e648c87dad32272f565714d1b9'',tx1_address=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',tx0_bet_type=2,tx1_bet_type=3,feed_address=''1_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=''1_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=''1_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=''19f4bb0c6c99045ec307905d8e15ff885413cdee3525269b25f03971dd8019b9'',block_index=310012,source=''1_Ukn3L4dgG13R3dSdxLvAAJizeiaW7cyUFz_Ubq467qkiW2UvjD5Uhi23XKKyo7UcKAZTJ_2'',feed_address=''1_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=''1_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=''1_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=''1_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=''9611941b4e1ce19312e3cb19847439ec1c4efc614f017ad72ac232ebf54739b3'',block_index=310021,source=''1_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=''1_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;
  