text: -- PRAGMA page_size=1024;
  -- PRAGMA encoding='UTF-8';
  -- PRAGMA auto_vacuum=NONE;
  -- PRAGMA max_page_count=1073741823;
  
  BEGIN TRANSACTION;
  
  -- 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','BTC',NULL,NULL);
  INSERT INTO assets VALUES('1','XCP',NULL,NULL);
  INSERT INTO assets VALUES('18279','BBBB',310005,NULL);
  INSERT INTO assets VALUES('18280','BBBC',310006,NULL);
  -- Triggers and indices on  assets
  CREATE TRIGGER _assets_delete BEFORE DELETE ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO assets(rowid,asset_id,asset_name,block_index,asset_longname) VALUES('||old.rowid||','||quote(old.asset_id)||','||quote(old.asset_name)||','||quote(old.block_index)||','||quote(old.asset_longname)||')');
                              END;
  CREATE TRIGGER _assets_insert AFTER INSERT ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM assets WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _assets_update AFTER UPDATE ON assets BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE assets SET asset_id='||quote(old.asset_id)||',asset_name='||quote(old.asset_name)||',block_index='||quote(old.block_index)||',asset_longname='||quote(old.asset_longname)||' WHERE rowid='||old.rowid);
                              END;
  CREATE UNIQUE INDEX asset_longname_idx ON assets(asset_longname);
  CREATE INDEX id_idx ON assets (asset_id);
  CREATE INDEX name_idx ON assets (asset_name);
  
  -- Table  balances
  DROP TABLE IF EXISTS balances;
  CREATE TABLE balances(
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',149849426438);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','XCP',50420824);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',996000000);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBC',89474);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBB',4000000);
  INSERT INTO balances VALUES('2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','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,'e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',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('e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468',1,310018,'0',0,59137500,NULL,NULL,3112500);
  INSERT INTO bet_match_resolutions VALUES('ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97',1,310019,'1',159300000,315700000,NULL,NULL,25000000);
  INSERT INTO bet_match_resolutions VALUES('4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3',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('e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468',13,'e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',14,'b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',0,1,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',100,1388000100,0.0,15120,41500000,20750000,310012,310013,310013,10,10,310022,5000000,'settled: liquidated for bear');
  INSERT INTO bet_matches VALUES('ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97',15,'ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',16,'5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',0,1,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',100,1388000100,0.0,5040,150000000,350000000,310014,310015,310015,10,10,310024,5000000,'settled');
  INSERT INTO bet_matches VALUES('4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3',17,'4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',18,'937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',2,3,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',100,1388000200,1.0,5040,750000000,650000000,310016,310017,310017,10,10,310026,5000000,'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,'e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b',310012,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',0,1388000100,50000000,8500000,25000000,4250000,0.0,15120,10,310022,5000000,'expired');
  INSERT INTO bets VALUES(14,'b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468',310013,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',1,1388000100,25000000,4250000,41500000,0,0.0,15120,10,310023,5000000,'filled');
  INSERT INTO bets VALUES(15,'ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e',310014,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',0,1388000100,150000000,0,350000000,0,0.0,5040,10,310024,5000000,'filled');
  INSERT INTO bets VALUES(16,'5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97',310015,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',1,1388000100,350000000,0,150000000,0,0.0,5040,10,310025,5000000,'filled');
  INSERT INTO bets VALUES(17,'4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731',310016,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',2,1388000200,750000000,0,650000000,0,1.0,5040,10,310026,5000000,'filled');
  INSERT INTO bets VALUES(18,'937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3',310017,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',3,1388000200,650000000,0,750000000,0,1.0,5040,10,310027,5000000,'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,'3e2cd73017159fdc874453f227e9d0dc4dabba6d10e03458f3399f1d340c4ad1','3e2cd73017159fdc874453f227e9d0dc4dabba6d10e03458f3399f1d340c4ad1','3e2cd73017159fdc874453f227e9d0dc4dabba6d10e03458f3399f1d340c4ad1');
  INSERT INTO blocks VALUES(310000,'505d8d82c4ced7daddef7ed0b05ba12ecc664176887b938ef56c6af276f3b30c',310000000,NULL,NULL,'39b79f4145926bd909c5857d6151edc2eb11c3ae13826cf7716b5eedd87d495d','5b8b430cb887c36a14f85b042e6ba64a17473f04d63e62ecbe80878d00e4138b','4279d81872908ca56a32f3ea3cc37e15439c5f581539073659b88f0f416d058e');
  INSERT INTO blocks VALUES(310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,NULL,NULL,'68a729f92c2048fda826cd8658041283a64bc9a0a7522387b6421cbf20b0928a','a9073fa1f709bc9b5562ef063de7d01ea8b9471be9a2db1631a7884d60739df3','4d20822ca4d9ea9da3f3d369f1557519eb2d0fdeacf5e0012e57612246e1f174');
  INSERT INTO blocks VALUES(310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,NULL,NULL,'d2d058837558bc9933ea6705eb796e7c528cf8d3a691df42a933e7c89547a7cd','a1a871c730646de7ebc37fcb67aadc3a2af2aa01b6ad992c89e2c837ac325b24','fcec1329b8caf5ad2e9afb767aa4cbd45fc8b88a7bc3614664f08433fab9ff02');
  INSERT INTO blocks VALUES(310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,NULL,NULL,'b6f87e8f4ab9fd9f56b5e34a90c308f20c65817638dd98e6ba824c6448aac751','7b65efbefd4dce6dcb5aca977736b2b875e52d035433b906302716436fbfe100','03468c2b323568224a40bd4ba0433547202baa094c253c0965498609827b48c7');
  INSERT INTO blocks VALUES(310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,NULL,NULL,'1e58339cab84b74f2b0f4e49f6baba6144a90fc6d4c7b2bd1e0597a55039e051','8b59ae1d17c92c33e80a28b59ff2c8919b442b9003f53eba76fc10dca41b1c0e','0f890deadff0d9f0d95e3fdd1f1aa2365458e7e9d700d00f8b6c5597055c2452');
  INSERT INTO blocks VALUES(310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,NULL,NULL,'600fadec854f57d9bfb6e1cafd9e48a60d909781f49057754e2e917659f1bb9b','4a586a25c22b2fe99da3e2c161dc1b84ad7a36bf30403963fb064faa407ca1de','dbb8e338899d725baa8ffeefb650a4ca400896bd76d28451f29ac02d8dc4fd71');
  INSERT INTO blocks VALUES(310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,NULL,NULL,'4777cc0c5071d1056cca0a4b2207208bd87bf9a1cc7eb3863882dc6079537b29','3c81cac8c269526f2d04b42fe36f172f9950b281ec8c8c098d2820c53266698e','10d82786d08caa4dc0356c56b9842e93594bfb84a96b7663fe2ae7db950b77e8');
  INSERT INTO blocks VALUES(310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,NULL,NULL,'6ddb9d3efb7ddde00cffddc7162530c5a22ebc8bb39f9af8b21041f1669e0f8f','1a9ab948599c6ed392255ecd7ab84cb12342c69be020e6671cd3fe31a9fb9dcb','fd84ec89e9403140bb381d8834ea602ff8c7492d757590fd358db77cbbe858d5');
  INSERT INTO blocks VALUES(310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,NULL,NULL,'180f20d8cefc94a83f2c1c13aaea969d4f630fa9487978e4c9ca5e5295809f0d','a0b2e39ad96c7dfe442b97a7d2dca6e15c3c20a2395ab316cc0a8cc9a2a5a79b','deef4986f33e091fb3276c62bbc3f0a6a3a83250467b858c54e9931e2b3788ab');
  INSERT INTO blocks VALUES(310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,NULL,NULL,'f6f8fe0b58a1c5e179b9cf81b50db078261f9d59b66537359549cfc429b84dad','aa526f6a95a5d5eec905d50898cbc7daeb01ddf64be27e2ff85efe82257cbff6','8739f940ce68048865f0d3caf52ef311f5a50024c59725890cabd7aa01596174');
  INSERT INTO blocks VALUES(310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,NULL,NULL,'12c0440830b00eba8c28881b2383c50b9c0bb14ab16bbf31b81bbbf00ab3b952','b8715896a171ed09fb3d614e1269bbd99016b920503f8551742b975d2628c602','735e11fb08c0d8189fcf9c598028c36e73ab18d32ade4dc2284e60fbf01d02b8');
  INSERT INTO blocks VALUES(310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,NULL,NULL,'3f95dc7efc7cdfe9278fd8abd368e650588aac0b79c91bc1db2b8df566c9fc25','c2304cc05e0c50897e99b1d37a76743ed21294a2c525e99b1f7715f3c45a009f','fd0d83f0970c3c0c2b828e394b46f2d1b8a5a34f3d2bd04449d7a1b806461c91');
  INSERT INTO blocks VALUES(310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,NULL,NULL,'113d53d0c7ab727b9c4ead21f5eedeaf4af840715b4173bdeae704a9a10476bf','691c1fa551eed857444fe2b5c92c454140581d8a6a4cfad0c93a16166d484f64','9d0ca937ce38a7a613bd40f710ed7ae073813da358ff1cde4d4369f0a7d406cd');
  INSERT INTO blocks VALUES(310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,NULL,NULL,'6746c6194128963ec5641c17c291f80e3eb08cac2696213bb5952c1bf9e74b6a','e5f52845fea2b86bda206d4d4298fe3d657340f783af29626cbed65ff4e327a1','1cb50b0e15c0ce5afd91554a7ecd7d277fc0da54cf40df2746aea28c26bd9bca');
  INSERT INTO blocks VALUES(310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,NULL,NULL,'00a65fadeb223d9ef2161949a6f2d4385173f416674beea84f9bd2564460f848','701649097e1ee83e841dde81b13a2cd1c64626d2d547a5d84134e2433ea4ff11','e918a62c83821d03190eec504ccb17b2ed0953ac550b8e9a7d3fcb9804e5bcea');
  INSERT INTO blocks VALUES(310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,NULL,NULL,'0ae156e1b1b7c97eddf4bda00c7a1a89db71dc8442b8a3d4b09a62157082d5e7','076204900ef4c0cf77e91aa98a24e7175af4755f351abf7040ab2adf2304d5c3','0cd01c7d5c8c125ef01d25e88bab7fa6511dfa9013ceab2aedec384f65eef430');
  INSERT INTO blocks VALUES(310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,NULL,NULL,'4f65ec5d10ada8359a5f489a5b723f55f392d11e9d2ae51cf2f26b5712435805','33d6c04420a4c928ebd57cc0b3d2e61056de15eb46ff27884e35da3948b2ddf2','8a6d73142282bad04d71b8e790f23ece8ef5f61a9e5f865e5bfb36912535cca2');
  INSERT INTO blocks VALUES(310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,NULL,NULL,'31e9ff15105c3eafba74cb604933ef43ddedffd87bc7e608f6e1eaf85d171bc8','9a041f7b839329f8d5b369b23aa59ce77be2ffdee98f2fd253b01c6a43250041','44ce28413f9e141277811042022cdf46af48ab87c5d767d4c15721f92867fd8c');
  INSERT INTO blocks VALUES(310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,NULL,NULL,'d7b57d9561b8622f16e91ae81d8ff9f58ec183528a921816ef9d0530f07a4b10','456ddfa69a958406467986557fd98bbcec75c624ec2d815c634deb91f9d5366a','0323637315c78648a034dbfd03bd9dd3bc48f81c8a7c27c63527d3276579bde1');
  INSERT INTO blocks VALUES(310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,NULL,NULL,'5233a503642f056f55747c829338d658cef239ac43b95e330613eb027611ade6','fab4a932e2f2d9430fbe08e5c9d7c2ac416a5f277fa1d1f2d114bfd6edf42d60','626914bdd147252a3f3b98f8afb16300c4b6ee0ce77bb2b92a8c54b9d3974d75');
  INSERT INTO blocks VALUES(310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,NULL,NULL,'3415d1b4d9bcc2ce315dc5c0210f97f6f1af3ce09bb35f011b1d6a4792e2f3f0','f5a947f3c638488ebe8ae849d030fd67829c7cd5465b8515a6a34431f447ebd7','7291e57e3ac4fb16b6e2b357452b31d6fb2fe4a973417dbec5fc5b7c39a10b28');
  INSERT INTO blocks VALUES(310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,NULL,NULL,'efa3368cd24af073f0078acc64dc536c42ca3ee3119ff5fbac6814b0bc9f672d','794bc78998add2a16766a6390f3d51e4cca8c0307dc120c0faeb65ba88e91eff','e64afe6389aec5a3a3cdad14e3a81687a13bc659ab1fb32f11ce186351f7e479');
  INSERT INTO blocks VALUES(310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,NULL,NULL,'2b944034dff0ffe86423daebf0820134df029f9cf77659b5aa71eb72db757052','dc83c77b985a8f2e38f6ba2088ee8730c4659b73271f727f6c1c093d8068b8c7','bf5f6c5fc6e0fbaa0cb7c20c6f80fec318fbc261aa01ad3cd74e45002edb9ed1');
  INSERT INTO blocks VALUES(310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,NULL,NULL,'870bb35ea7cbd7d762e4e670482bc964c4bf9bf03058396de4444c67bd3d2b35','95424787ffa7a3c48d57a97e5dc9ff2e9c55e32ddd35679b6e9903777d477219','f057bb5b7b6f6ca113a6df82237543db3cc1c032b9a3ca140750168b0a930044');
  INSERT INTO blocks VALUES(310024,'b03042b4e18a222b4c8d1e9e1970d93e6e2a2d41686d227ff8ecf0a839223dc5',310024000,NULL,NULL,'de39d15deb208de2558a86c338e411c48b79cfc55d78e8fcc2143104e5ade4d9','a61465b77e6d6b558059cf17d33de1bf9926787223118f0125a3c893252a39f0','98481b77f8b8367ad524612126a2c7a361aa968d1385965d086f51bf9dc32679');
  INSERT INTO blocks VALUES(310025,'a872e560766832cc3b4f7f222228cb6db882ce3c54f6459f62c71d5cd6e90666',310025000,NULL,NULL,'7ff50a5a1218050372b64cafa02fc5b59fa81ff5d1978d89b7809795cf7860ae','e98b0cfa80ec5068f2f74f373aa3c488957b71592527959f20703ed7166937fe','423dfaea58f5a4cbbbcc8d55c09aaeead04b063bd65c228bd1bb8d8c505610d0');
  INSERT INTO blocks VALUES(310026,'6c96350f6f2f05810f19a689de235eff975338587194a36a70dfd0fcd490941a',310026000,NULL,NULL,'a904a5a39cfdfb76f250c805a15dd75e1e3274d18b08d6c6efb0a967fd5437ab','d0608d00593151da5e82c4c0f70d571adecad46fd7b80c03e2527cb66f4cde02','2e706337ca550e3af20d3541bcd99dbb945a5ac3bc3196ae4b888b01c85a5383');
  INSERT INTO blocks VALUES(310027,'d7acfac66df393c4482a14c189742c0571b89442eb7f817b34415a560445699e',310027000,NULL,NULL,'16a0f16dec1741ff1451dd0d8e9e480b0d88c42b96ae0f9b7c69070005248b40','38d4a40881deec9fac9aa65316b45f999bcd4f07a493c442bbd65002a5bae51a','a223161e46dc73f02a220e70536174c65fff55898925faffc2c6bebf5639e471');
  INSERT INTO blocks VALUES(310028,'02409fcf8fa06dafcb7f11e38593181d9c42cc9d5e2ddc304d098f990bd9530b',310028000,NULL,NULL,'b93d647276d042dff82ec5ae29840d9275d3413fe95e3da0b500823241adf9d7','da6ab3d548584c6944dd1a63e251e0ee41e8a49c48b150e35c479e8a79d6f27e','d823b350c843bb5ea1ec90d221746e02ae60767adafd65643ffa9ae571d2c132');
  INSERT INTO blocks VALUES(310029,'3c739fa8b40c118d5547ea356ee8d10ee2898871907643ec02e5db9d00f03cc6',310029000,NULL,NULL,'fda27a7d53869c4b12513d29e574a720be51640201d59ba225c2b9d66c5c0a10','acc67a1a7f44bb5341bb91ca3f495421623c159ebb07dae05438320c4e296e17','bfb8da0ad85b22e8a8e4ac92f3382b7095db73a4478cf7a5bbbeb3b3c837ac55');
  INSERT INTO blocks VALUES(310030,'d5071cddedf89765ee0fd58f209c1c7d669ba8ea66200a57587da8b189b9e4f5',310030000,NULL,NULL,'38e1f7ce500607777eec93ab8ff3f87446b44c19f0fe78a75022fefe19472bfd','ee4e914f1c315ccb1c6647ae957889e9a29459b63266d0642e5f0fcfc286f2d6','8816630d1cf1592f1faa55d2a0967ef7214c3cacb33939025788bf6a27066e22');
  INSERT INTO blocks VALUES(310031,'0b02b10f41380fff27c543ea8891ecb845bf7a003ac5c87e15932aff3bfcf689',310031000,NULL,NULL,'4c15c5c363680025ccadfb683792db953c414065c181b45e08f364a058fdb91b','804c56ba9b978f21216b23707ff3352af5f0845c5ba8d995f9414b98bbbf4430','38e2a995359dbe3523ce52cac40cff7f09ebae77704244b095c420a5f78b9758');
  INSERT INTO blocks VALUES(310032,'66346be81e6ba04544f2ae643b76c2b7b1383f038fc2636e02e49dc7ec144074',310032000,NULL,NULL,'e5815fb91494a2b18476d063aa542b071f9e8ee9bdf3dc0658337fc1d1be710b','0bcac65109b9be13c10c14f16bf1e06b53e5cb0c45cc423b84463d41ab075dda','e9d6114103e92bb2a43fb4fded1e56654f56ed66f53fbe5cf133c785bfe8d7c4');
  INSERT INTO blocks VALUES(310033,'999c65df9661f73e8c01f1da1afda09ac16788b72834f0ff5ea3d1464afb4707',310033000,NULL,NULL,'3d79a4c046e7ce6f4f241ffa6b25ce8c109c0308ceb380f4d258c449948b0f4e','c97894f037ad4ee646065a13668a5cfacfa0964c5586db01a1fc52d813de4dd7','2b75ab7cfe637d5bdb8230092d2e0365556c1f2a1a809d9e5dd2fbeaf5660819');
  INSERT INTO blocks VALUES(310034,'f552edd2e0a648230f3668e72ddf0ddfb1e8ac0f4c190f91b89c1a8c2e357208',310034000,NULL,NULL,'70ef6147733622abe299d1d9ec62876fe8c2f202d1d6d4f4ede29b0b44e4bbaf','0a8664cf8ae3e2c9e0ed1621e7c31ce36798627c2f469865704eee3454648af1','e060b0f7909150f253cc66766df56eee3f6e44e932820cccc505c680022c329c');
  INSERT INTO blocks VALUES(310035,'a13cbb016f3044207a46967a4ba1c87dab411f78c55c1179f2336653c2726ae2',310035000,NULL,NULL,'7e66410507e91da2900c43aacbd7560b75eed93846ece03bb9f2826e46aaf77e','879f53c20775f8a603157903278e9fe53be902ed9b510a338134be0b02a4a95b','9f39bba186f591000ddd2fa5c082b835118bed9176706b9149224f8d4c079411');
  INSERT INTO blocks VALUES(310036,'158648a98f1e1bd1875584ce8449eb15a4e91a99a923bbb24c4210135cef0c76',310036000,NULL,NULL,'b1d4c84428ef796a2933d2b6e6a6b10261c9e8d45668047c77fa75035e38f070','d9ab6a598b46dc3030d6a2d3fb3937879f57de96f8adcf77a22a9d6c9a60d444','6987eef6ef82551582c09e90c8a92e54133c9abc0adcd587bebf488c5341070e');
  INSERT INTO blocks VALUES(310037,'563acfd6d991ce256d5655de2e9429975c8dceeb221e76d5ec6e9e24a2c27c07',310037000,NULL,NULL,'b2993e54516ce4b73248e35510f382eeb67a061209773d157681ad62d71df73c','a60b38474678bcf6832f7cfcc0214002979bf544375998b2cce78b4ebf01aaa1','e161f1f00196a4579d03b1aaab0693c2612da94236fe22fae3fefb251b48e379');
  INSERT INTO blocks VALUES(310038,'b44b4cad12431c32df27940e18d51f63897c7472b70950d18454edfd640490b2',310038000,NULL,NULL,'9d147041db8f980f0877aa35581919c778b56c4011509bfd0c139677fee3cc49','4e3ac6fa658167e0145539e7c84a23d9f16c7d52ee2e4aea0228cf86ede24c0c','2b89eb0e919cbdfc8a1c23e268088931d9a9f01cf89b5057e120bc7c7817d425');
  INSERT INTO blocks VALUES(310039,'5fa1ae9c5e8a599247458987b006ad3a57f686df1f7cc240bf119e911b56c347',310039000,NULL,NULL,'dd3a8515a9ddd8003e4f5a844c306c30603e2657f477641e7d5ad898ca6237a4','9b97f74c4653f2f6c18a7b7e718515b227221b5898836a5ae8e77bb67068013d','387a2a72b906f6b4ab8458b178773da112fa8b41f485bb8b36edf0a26a728caa');
  INSERT INTO blocks VALUES(310040,'7200ded406675453eadddfbb2d14c2a4526c7dc2b5de14bd48b29243df5e1aa3',310040000,NULL,NULL,'51a827528ec3fb74f3088e2fec385f280c45451605cd04ae897ae6594b81bd86','12ac3214467295a55b573a80eebc60aeb5f74cde74700baea0d3bd2b2a7aac97','595d5002a4c70f0e6e667ace98cb86181bb86e2a33b75369c35f1ef71f7f7489');
  INSERT INTO blocks VALUES(310041,'5db592ff9ba5fac1e030cf22d6c13b70d330ba397f415340086ee7357143b359',310041000,NULL,NULL,'9680c64f6d0e5a405202e94220133e512a9a16eaa672418e85a1ccfcff0595f9','f919cc7248e43c6234b9114da829943ab3d7178e243d0413d0464ff102e3e9de','d496d6554296f08fd3cf5c79ed969c86f7e87800858bd4c1645ee04e20822df6');
  INSERT INTO blocks VALUES(310042,'826fd4701ef2824e9559b069517cd3cb990aff6a4690830f78fc845ab77fa3e4',310042000,NULL,NULL,'0cd58ab560f96972ed10546dbe266c8b14bea91b8fc5f82ac763bfc2f4edbdc7','89d899dd8b99624d398351891fe9f6b00f4430f39e5c084c20b37a6b13a1187e','2979c2ceabb252460f1b5d0c9b0ef962f27be6669f50078dfa8714f72213145d');
  INSERT INTO blocks VALUES(310043,'2254a12ada208f1dd57bc17547ecaf3c44720323c47bc7d4b1262477cb7f3c51',310043000,NULL,NULL,'3b9c9b1ec9a921574fc50a26a49388eb3a9e0d7a50d69aed46e4390aee1c441d','5d8844cd9a2cc0effa61515996b2712401035baf125ac97979b050888d0357cc','559ff3d246b55daddb9d6aa10a746c2ada697379d6f6fc5d4dbd7cf98d18c1f8');
  INSERT INTO blocks VALUES(310044,'3346d24118d8af0b3c6bcc42f8b85792e7a2e7036ebf6e4c25f4f6723c78e46b',310044000,NULL,NULL,'183ed15045accf71eaed325e603eaca36817fad5a937b908ea73588e1fdb3d98','716ae9fed18e4e0ef88ee4be866d8d9d0dcd5a43977248bdd1a825fe73c4435d','fa64650a6eaa1acf279b2d238480a9744e98e68f82ba0877e3bd6e894087338e');
  INSERT INTO blocks VALUES(310045,'7bba0ab243839e91ad1a45a762bf074011f8a9883074d68203c6d1b46fffde98',310045000,NULL,NULL,'2671287f3bef2b248cd7064a798cc3d59b7d6b8c85fd7ca1a79493eff7d0c4a9','37621e3421607557ea4c6c7d59b78ae201b82afe5ce9475f29b50303ebc8768a','fb510c0c88b4749853ed3dd9f3d1588a52934d830c552e5d12db9bab70beb0fc');
  INSERT INTO blocks VALUES(310046,'47db6788c38f2d6d712764979e41346b55e78cbb4969e0ef5c4336faf18993a6',310046000,NULL,NULL,'59fd6d750ded38f887fb653851138a93b3c1e9f73b74654021a4cd2490314a50','0caae3bd9438c74934fcb567d4ae2b7912a4843fc1183bc5e3a270e3b2e3bcfd','b8b2e48687e2ca2419198becd27d70bad8573077fe7350b805c189d467402031');
  INSERT INTO blocks VALUES(310047,'a9ccabcc2a098a7d25e4ab8bda7c4e66807eefa42e29890dcd88149a10de7075',310047000,NULL,NULL,'d8f2e391bc667226b315019145e8b0bff552d41935705a897b1c05a1ea9f8efe','6bdecabb1bbdaec5c121d7e9352728b19915903d7f40bd0b33295c9d89e69b5c','e7e509fab04808bbf2ceada0711f4e918be15dea5a19bd5b0aff27cb9e5be48d');
  INSERT INTO blocks VALUES(310048,'610bf3935a85b05a98556c55493c6de45bed4d7b3b6c8553a984718765796309',310048000,NULL,NULL,'6abbda1b5bc7d1cd428cdf55362062077256071f9478999b6e630bcb0030fbd9','9b3cd63fab2f80796e88fc49bf5133ec2629770c3c4233c0b6a2ad816d07666b','c636307102533aec8f32ae51206b389638b72b504db13350ae3013cf255a8879');
  INSERT INTO blocks VALUES(310049,'4ad2761923ad49ad2b283b640f1832522a2a5d6964486b21591b71df6b33be3c',310049000,NULL,NULL,'4e3475a86997014275ee553dec76592411bc408b44c1bd2abe586c0ce9a709ad','252073b3c12d65dca55a3338105b1d3bb09dc47b00db893adf01ffdb400ab1e6','f7a7bb6ff7dada6c00dedaf6bcff248c13e742328a5daf53bd7e680578c0d86c');
  INSERT INTO blocks VALUES(310050,'8cfeb60a14a4cec6e9be13d699694d49007d82a31065a17890383e262071e348',310050000,NULL,NULL,'7e32a6427614c6cbef1f4cc389dd650e95a732992e21b298994d8347d7b5f549','a41de3760b5d6c812538c529a89682d26d4a00a26678e576d59933e9f05458d5','595f405c3a3acb7f66c715f893a6c0e99e62e219661b24d194a470c5c7b167b4');
  INSERT INTO blocks VALUES(310051,'b53c90385dd808306601350920c6af4beb717518493fd23b5c730eea078f33e6',310051000,NULL,NULL,'9b49f89c81c99d463599f76bee9400bdd0e29214c8ed39dc05ec09f4aa62c0f8','8296bf0ed6433459c9b21473be488f7732ec3a8f07f623446822e9768d896227','fbea61e937aa6f7643f2c4479a111e803e40376f555b10e737979ae1ad53ec34');
  INSERT INTO blocks VALUES(310052,'0acdacf4e4b6fca756479cb055191b367b1fa433aa558956f5f08fa5b7b394e2',310052000,NULL,NULL,'8b2580a773e68699868f0de5193e2027a25079b957c11062e490fea3a57e82a5','8c785501ce2579deaef9b23e2039f3e5dde1b856f8f152457986970a1a31db3c','eab5a3c27145b0b185bf83dc93466252f479e6d669b09c29edf62144136f98cd');
  INSERT INTO blocks VALUES(310053,'68348f01b6dc49b2cb30fe92ac43e527aa90d859093d3bf7cd695c64d2ef744f',310053000,NULL,NULL,'1a4ec64c0549b5363bae05dcaf7d0f3a780014c5d4957977ef23d81109a5a063','14c980c399a276b22ea24b6d07b06825c7a7b9d8352c6ed578c03bc65cc5d6e3','5bea4105a6589e70fe0041742382f6a50067f5f957338345076539c2ca4ce439');
  INSERT INTO blocks VALUES(310054,'a8b5f253df293037e49b998675620d5477445c51d5ec66596e023282bb9cd305',310054000,NULL,NULL,'d039a7fbdee2f8337b6a4d45df4f04a83a44b85e8e309de448648447cb53f656','3056fd2bcad56a52b1dfbc9e6847f2fdf516b7a28c59f90a41b267b065994aac','53b824c0fec703b74820bcbc39de3182d88c5818755180531e1ec6674cb62e02');
  INSERT INTO blocks VALUES(310055,'4b069152e2dc82e96ed8a3c3547c162e8c3aceeb2a4ac07972f8321a535b9356',310055000,NULL,NULL,'2687c143e3b499722a8b101571f19b193e6945fa1eecadb685b2107543c86754','b6034c0a351595a6be4a409470ff49c0c49a250d3ea5daca41c5e53a43e1cb8d','44fc218dbd191774ea03835e5f46fc6f9987986038fd2fd5e049e12c3b74132b');
  INSERT INTO blocks VALUES(310056,'7603eaed418971b745256742f9d2ba70b2c2b2f69f61de6cc70e61ce0336f9d3',310056000,NULL,NULL,'1784199852cf0e10ade8fdda033e78fd6942d239e03214a983cbe34fb90b91fb','712cec2da928c5dd3862ea0d21f236614246331abadb38d564d9ea35480acedd','f489b9650ef3f00316bb513b93126f4c12a3d69a01c7c421ca34a5a69bd69639');
  INSERT INTO blocks VALUES(310057,'4a5fdc84f2d66ecb6ee3e3646aad20751ce8694e64e348d3c8aab09d33a3e411',310057000,NULL,NULL,'a7c5ad019db2b1b602a4ecbebb313081d2f286dbd43604680d9afdfe0aefb3f9','5c565acc73f5ea071fbadef492d23ca367ddbdcb05b31e6642e2f26dbf96548f','00639ed196cbcd16cc1189ea5ab7fe841dc714dcab228e895f026dff46d04df8');
  INSERT INTO blocks VALUES(310058,'a6eef3089896f0cae0bfe9423392e45c48f4efe4310b14d8cfbdb1fea613635f',310058000,NULL,NULL,'87b9441dc5dabc0734a00d5b6d2c8e451da122a549d41c761bf0aac03a96d9ad','a0ae73025d31ede96801a389baf063e612864fda13c084faf36a8ac3c49996f9','d6b036d176191eb87a1a572f0a81d6cf03665ce4dc72c18b40def462d4a73af5');
  INSERT INTO blocks VALUES(310059,'ab505de874c43f97c90be1c26a769e6c5cb140405c993b4a6cc7afc795f156a9',310059000,NULL,NULL,'b3712b3a68fedfc8ba361f9ef9caf3747c7451baf3d5a2ecc1a1d81010c67300','990e6f31ed69cc5ca8c3b8a1d3f0c2a9c51ee0135e6badef18a577b517b9ec2d','685b8f9368729bac4c6493b1738e0a793f06fb8a02bc6afbb0002a1b1b30cc62');
  INSERT INTO blocks VALUES(310060,'974ad5fbef621e0a38eab811608dc9afaf10c8ecc85fed913075ba1a145e889b',310060000,NULL,NULL,'5d21025f2745c97a366c6b901f8edcf89bc0cb356a4c1a6db78d7331a743e5a2','87e2e215a370a0d84609b4b930f741ccdd655b92bba2189c6db986f374f07fbc','fc39852d8c8a09e27acf1222a591008000b9c99b00072aa524e630be44c2a076');
  INSERT INTO blocks VALUES(310061,'35d267d21ad386e7b7632292af1c422b0310dde7ca49a82f9577525a29c138cf',310061000,NULL,NULL,'556abd3319c938275dcbab8f9fe60fdf053765d08ba69d35d6fb2d555e34b2c5','a134f382d1f4a361325d16cef6fb98135b89c1cd27528950a57ffb2bd098c220','12d82977cc33d9ca41184855167d014edd784162bc42c3703b22eb6dece2f86a');
  INSERT INTO blocks VALUES(310062,'b31a0054145319ef9de8c1cb19df5bcf4dc8a1ece20053aa494e5d3a00a2852f',310062000,NULL,NULL,'771b283c29c46ca6636520543eac0b0214e79eed534950a6de66f269e309fc3f','72c2d355627ec5d374e4ab538333adb99bc1964493734fb39e741f78feebf527','2f75f1aa87b8465a6c8d705798724824ee6d310060768db27c61a1557234afea');
  INSERT INTO blocks VALUES(310063,'0cbcbcd5b7f2dc288e3a34eab3d4212463a5a56e886804fb4f9f1cf929eadebe',310063000,NULL,NULL,'4df634059f9583b3dc6fdce8822bbc4021f4656bc9bad46bdf9970ef6d03afd7','0909ddfa90069745e54b8b894c974150ca42a8e4aa6cd986aa431cc3f91e3a52','6e2ae93cd6cbcf1de4f1829108bd196bab0faa83abf06991377a5b2a152575bb');
  INSERT INTO blocks VALUES(310064,'e2db8065a195e85cde9ddb868a17d39893a60fb2b1255aa5f0c88729de7cbf30',310064000,NULL,NULL,'7c2d6edd0661d8a30b2cc8600731862b8b8706bef986ac8c76139ca04a410909','6caa53111e21e341b0049cb7159c8fab28a46a641ff108b8dd8f906df929692f','b2350ab4ec8ca8adc2171de806463fb79dee7a489c4d9164485cfddcc494bfc8');
  INSERT INTO blocks VALUES(310065,'8a7bc7a77c831ac4fd11b8a9d22d1b6a0661b07cef05c2e600c7fb683b861d2a',310065000,NULL,NULL,'def802fac90d930a29870ac833a5fed1b5763ec20c6f992a8ca941faac7bc8eb','53edcee8f8908768877cb2ce0547479aaf479f1dd699adef428c1bc88f97a2e4','5e343c2f54e270a82e4c05bf257b86d58f6921b6cfd615f83955ffb126ab21bc');
  INSERT INTO blocks VALUES(310066,'b6959be51eb084747d301f7ccaf9e75f2292c9404633b1532e3692659939430d',310066000,NULL,NULL,'d1ebfa6ad7ee960dea569e1017a0e863a83ca823a59e0e2a34629bd22ed007f4','e7143150df4a3352ce797e6c63f963517fa27d627f9881367d7a90f3dc873a92','2fca11cfc0bba25ac688c86420b3c264dab85fb08c0ebf6f11608f32c2ede409');
  INSERT INTO blocks VALUES(310067,'8b08eae98d7193c9c01863fac6effb9162bda010daeacf9e0347112f233b8577',310067000,NULL,NULL,'c7e088d7d21a4ed482f2358df49da1fd5a9b8aaa7c2181bb55b8acb2a45381af','65814a436d94b083ef39e568a5d2c9128a5b9ffed3e40ad758f1c924da3fca03','8022362253567ad0feae10248c5f9c629ed95a953edced60a4dabecdc95f1072');
  INSERT INTO blocks VALUES(310068,'9280e7297ef6313341bc81787a36acfc9af58f83a415afff5e3154f126cf52b5',310068000,NULL,NULL,'fdcf471a87289344e66a161507d8f2bfb926ec86d7e5b4765f5db7d2f60bafda','6e16eb3466c4156cf67efb31f9819e59bdf6e33414f1cf88cada55d0a1168813','9c285e39aa702767f65386d003e39701d9f7a566b48d5ee06eb99e15998c964f');
  INSERT INTO blocks VALUES(310069,'486351f0655bf594ffaab1980cff17353b640b63e9c27239109addece189a6f7',310069000,NULL,NULL,'ccbb954606ba0317f896260bdf9494eb9c5a596e3b23e63ce97f3a1f6f865fc3','e0b6133cd4145705183c0d7d01b7f82f6a3f19d11b9a3672707cedfba16591a7','d96782944f468e00cd431c7e1ab14ae820bee44f87190479840031db84001642');
  INSERT INTO blocks VALUES(310070,'8739e99f4dee8bebf1332f37f49a125348b40b93b74fe35579dd52bfba4fa7e5',310070000,NULL,NULL,'bcf51516cf580095599741dd1a7621bbf105eec9c9d53e76446957c907961273','596bbc5d49053e7c43c53b3cb1a449bccd6000b77178284665ff72dbe3857d3b','6096630535b6027eaecc6c51ce8464f485214fc3c799df90fa753240d1f4d49e');
  INSERT INTO blocks VALUES(310071,'7a099aa1bba0ead577f1e44f35263a1f115ed6a868c98d4dd71609072ae7f80b',310071000,NULL,NULL,'b782bb24e807d946be9406a774a52e6e5a895141271da2e5e21946ef95415b2a','e18381c26d72d8b0388b818ed1dad81c6f8cb47a56e5335a91d3cbaab6782c65','7aacd3076cf4bcb0def6658f8d58fe6bc008e29569d68215ddc5fc41d8740ccc');
  INSERT INTO blocks VALUES(310072,'7b17ecedc07552551b8129e068ae67cb176ca766ea3f6df74b597a94e3a7fc8a',310072000,NULL,NULL,'9bdbec3a89cb48ba6e9853f8818ea65858b55347afe9ca421f3d5aeae4beb693','4e65d45e9ed1441f708569a8a9e0cc717d6058bf8397aa0421cefba5b974fab9','dba5c46ab70879375f8b2aa9b20f491d2683a531dfa8ade86e0793d951949689');
  INSERT INTO blocks VALUES(310073,'ee0fe3cc9b3a48a2746b6090b63b442b97ea6055d48edcf4b2288396764c6943',310073000,NULL,NULL,'0d7c05a422392671112645c06fb5fbd57e3e4f004e0904f7c982f5c037e0e279','f8b658b8dcf58b4c5432a8703603b753e630de2fe27c21e82b6c044ce45cd8da','7595ce2afedf86654288f9e8bdc3d75c5ec9ca71696182600b2e6370a5d760f6');
  INSERT INTO blocks VALUES(310074,'ceab38dfde01f711a187601731ad575d67cfe0b7dbc61dcd4f15baaef72089fb',310074000,NULL,NULL,'b430f5af411f9e6e1876b85de90ad91376bb503c6641c63687b11c124c62a154','3f7a9ef682418a3804ab16a2bbe4555a9f5e926d3ee0b7c5c6926764951a5aee','3a266bd36f6bbd7163da9c090797947728396e77c9a0bfc025d222af7f1af95c');
  INSERT INTO blocks VALUES(310075,'ef547198c6e36d829f117cfd7077ccde45158e3c545152225fa24dba7a26847b',310075000,NULL,NULL,'ed0eeccf275215affe3e45ae7b85d45353c0333322746be99bf601e41706521d','dd0fa54da04dd05c4ac30251672d7dfa88f818d432cccabfbda9697669c62bde','0c04b5a539e86d6cd15955859fac38f2f330b0e25afcdfe2a6f1b5a9f579a056');
  INSERT INTO blocks VALUES(310076,'3b0499c2e8e8f0252c7288d4ecf66efc426ca37aad3524424d14c8bc6f8b0d92',310076000,NULL,NULL,'fa612fed0e1d8296164fa5fc6cbc4a293d6abd1071ebae9bbb08721a3caa3dda','9ab5916d9395a73fc832c5dfdfab0acfa5f723b8d4623fb4d9b4646ea0da6f47','9cd5eb5aecbab401deef8cab684c31eb52c7a3da16cbae6e19d31e27ebefb46a');
  INSERT INTO blocks VALUES(310077,'d2adeefa9024ab3ff2822bc36acf19b6c647cea118cf15b86c6bc00c3322e7dd',310077000,NULL,NULL,'bb45807ef8e10af3ef96ddc845224652fe4c6deb2d5641ddc5084c99996dec86','2ddc6608c5c1c59f8342e3eadcf1b1a8e150aad824c711df378e32c9da475cb6','e844c8e3ceb3dbd26088959b9f80258408d06f2fbaaecb582893ea7e6c12c661');
  INSERT INTO blocks VALUES(310078,'f6c17115ef0efe489c562bcda4615892b4d4b39db0c9791fe193d4922bd82cd6',310078000,NULL,NULL,'794e78d18b6b7c811e22e78ab265b049b5ddb484c814bb434f8ae7082a73b75f','89829007868423e322f4c8ea3bd50ba6795293f0cd6b3694950eb60d8cbd4d22','4bb87eea0a1f124c30e956995b9722cc3f443ea0b93e7ac97f895f51fae89156');
  INSERT INTO blocks VALUES(310079,'f2fbd2074d804e631db44cb0fb2e1db3fdc367e439c21ffc40d73104c4d7069c',310079000,NULL,NULL,'a766257d9979cf729367f9bd1072024d42d364ae72eca2082424fd1c579c59b0','90508b730129731261dcf8915941c559ba6b8bc1c192c2b844af78803b1dcf92','29257920f7ab83965c85a148231a530d93998db58b1cb4973757961d91266f8f');
  INSERT INTO blocks VALUES(310080,'42943b914d9c367000a78b78a544cc4b84b1df838aadde33fe730964a89a3a6c',310080000,NULL,NULL,'353ca156fc26a7c03687de91847196f31156379891ab61484aba0b4f13d42f17','a4ec9080b1a83938effcbf7d56a19e8810cb901cc4334c6a844dea75fd0a0791','ca5a3b1abe9d7ab642affea7ecefb432c45b23aaabf3049760deed34b2c9697c');
  INSERT INTO blocks VALUES(310081,'6554f9d307976249e7b7e260e08046b3b55d318f8b6af627fed5be3063f123c4',310081000,NULL,NULL,'de999b87c80e86c604e438805d71297f53c723c26f59569c53779f2981b054cb','fed9c7419afefff74e67701b2507ffd924f4f8f78c81e8163dc47b4ce3ca2a98','c0936628d7a5fc1c83e0a4b6f758539aae0945e22bc6d8ab6f24e975e1a1ceea');
  INSERT INTO blocks VALUES(310082,'4f1ef91b1dcd575f8ac2e66a67715500cbca154bd6f3b8148bb7015a6aa6c644',310082000,NULL,NULL,'0b099ab0dfdde4d72ab233821330aec039535096717a02b7920dc56cf88cd351','6838b203a6ae64c4487c89edd6b5beb0d8bab08f4e0913f1ae230af494865e93','acad53a92b72de6ea9df6b932e071ab9a4e5b7ff4d1fdedcddc6c5f0313da5ff');
  INSERT INTO blocks VALUES(310083,'9b1f6fd6ff9b0dc4e37603cfb0625f49067c775b99e12492afd85392d3c8d850',310083000,NULL,NULL,'7bb334623a65e2cb7d08eaf1ed601bd5b5e26bc11369dfbbd7457483dd297017','8f6125278e162f15a42d29d2da655be46307734569b6dfe5716b8b1d4335a2fb','c3d863985286000a5b948f0aad84122d35fca5132da5b8d4a8aaf75d4499255b');
  INSERT INTO blocks VALUES(310084,'1e0972523e80306441b9f4157f171716199f1428db2e818a7f7817ccdc8859e3',310084000,NULL,NULL,'e0acdf7e711b985e7288c8de95672814e9d4f5f84fd6394c2e5a2782ed9d251d','55646910dae771e0f494db4bae38e094ca1fb023f18f5ca4033b6f7cfa9d9c0a','2be0a0249d6fa13ddb1e5c8ffea01b28bcbd7a160accece6580e9d64d2c00781');
  INSERT INTO blocks VALUES(310085,'c5b6e9581831e3bc5848cd7630c499bca26d9ece5156d36579bdb72d54817e34',310085000,NULL,NULL,'22f947097dff52b59f0f6c87cc458120eaf2b6c3fed8ff89bfa0b74812559b78','090c0423f836272d3e27df5fff6ab4db6c6efd5a76bd07394d95aa6508822f77','078ba392008b9d2b0383818ad9a23c9961e600ac6d687e9cafcb85ff8ae68d9a');
  INSERT INTO blocks VALUES(310086,'080c1dc55a4ecf4824cf9840602498cfc35b5f84099f50b71b45cb63834c7a78',310086000,NULL,NULL,'6e0fe70238a56bc8a36cb4e5d070b8cade9e695e3596a0c51955e98bfa29cee6','f677c2fe2184f13906859e4a241bdc521570db0156d64c8c9c885fea5b0a3198','887b1535dac21cc89bf26965e68b8815c1c4dcf8f0a08c1e749c156025196d43');
  INSERT INTO blocks VALUES(310087,'4ec8cb1c38b22904e8087a034a6406b896eff4dd28e7620601c6bddf82e2738c',310087000,NULL,NULL,'febd7dbcba00c4520da180684fde938787a77bc4935f67df2cf7a8f04dad7f87','aca0b446e0e29af196e47412aa4581979f98c2a67b2f1ecdd8781621991ba153','ae36056cb0fd6c9466637c440f56bf436efda0520702115e63533e91f665039a');
  INSERT INTO blocks VALUES(310088,'e945c815c433cbddd0bf8e66c5c23b51072483492acda98f5c2c201020a8c5b3',310088000,NULL,NULL,'030cdbf54b162b5033995d09bead7a3163844d54d973b51171d6edbb9efe56b8','d10bdb9fa13c9e0b26b514c1ec8f0e633c7b3f1f59c800ff2d183c92a880aee0','aae078d6d3f078ccd70f42d1be1976c82ae19417a3742d58907787df2af89f91');
  INSERT INTO blocks VALUES(310089,'0382437f895ef3e7e38bf025fd4f606fd44d4bbd6aea71dbdc4ed11a7cd46f33',310089000,NULL,NULL,'8eaf723764f4bc41e87510e3d958bd72fef472b0f0ce587952fc87474d29d878','31e5868967dc017d333fb9cd3479ebde131d11d15de04e9edfdf31b564ae229a','2c8481bfd7ff6b14b87e2cedc7eef4a1ef4689aae505cb7d32265132234b3aca');
  INSERT INTO blocks VALUES(310090,'b756db71dc037b5a4582de354a3347371267d31ebda453e152f0a13bb2fae969',310090000,NULL,NULL,'242e624c8176a50052e2dce9731a593ce382170a06424df3d2e106a45a879e9b','96b621e16380510ceaedb3bd944dbb520420bacb70b51272efc0401619a0ce73','23a0db0ad728ee952dd0d3476fa2cec85c771b3e635540fe82e6940a1f6f1180');
  INSERT INTO blocks VALUES(310091,'734a9aa485f36399d5efb74f3b9c47f8b5f6fd68c9967f134b14cfe7e2d7583c',310091000,NULL,NULL,'79020e7a495d15969df8605aec245b845b0d6eb53bb0a8833f8895f985904cbc','f5ba3b54a8fe283bd14e3dfef1a0900a4d32096bd17c57da063301b5a4b45a22','cfae67e1d0110a97fc80c34bc154e8d52394cb139913a4a677a7601d2c1fc4d1');
  INSERT INTO blocks VALUES(310092,'56386beb65f9228740d4ad43a1c575645f6daf59e0dd9f22551c59215b5e8c3d',310092000,NULL,NULL,'3ad0f688ffa802b06a874c573d18a0f1e23e96ca4c00b02041d61bd16ab2c1a8','9402dd1c702bba9674b8fb7f5b9c27fe69d0b2f5534b62b52020ce538a1e9e5d','c12c8997255bca3ec31a696901620746d5cc4cb9b8bca582aa4abec94a923fcc');
  INSERT INTO blocks VALUES(310093,'a74a2425f2f4be24bb5f715173e6756649e1cbf1b064aeb1ef60e0b94b418ddc',310093000,NULL,NULL,'141d85e620bb5ce048346de9b6ac11cbb944743134ec2623bb569b741b0af6eb','1a0b508e325891cb8bf47bcea26d42ae478da567fb45e90a8431bcefe070dc11','5c59ef8ffb237faade66c65ccd3dc4681ba5a8f29e85743b0b253175b3c34406');
  INSERT INTO blocks VALUES(310094,'2a8f976f20c4e89ff01071915ac96ee35192d54df3a246bf61fd4a0cccfb5b23',310094000,NULL,NULL,'6d54d5d782559b3b75a13c6f1e05f7fb4ff0f77a1af7ad9a99d74287fd9777e1','9337046652cc54b632c50b477892eac5be627a88803ab96b9d83cca980a84ef0','813ea4f5f994a67c1e6b0104ec086d7c3ab9e09889a70dcc67dea1d691dee157');
  INSERT INTO blocks VALUES(310095,'bed0fa40c9981223fb40b3be8124ca619edc9dd34d0c907369477ea92e5d2cd2',310095000,NULL,NULL,'47c6415c35bd1ac511e84b59f0e94e8527454b95f38b13fc9d13a47919e4d405','3b714048ee61ae2d92ed6fa565ece62a88d78296d6b634252db8c0185bce39ee','78367f1867608de06e9c7a911ee451b07fbcc88993b462d61672f1eeba618550');
  INSERT INTO blocks VALUES(310096,'306aeec3db435fabffdf88c2f26ee83caa4c2426375a33daa2be041dbd27ea2f',310096000,NULL,NULL,'dc9b9a9d9a84751b92c8e4378300232a1e480e238a21ca8e9873025db6aa68b3','ec1d18e354b442b7753bc8dc878230cf0a6315d29375c25d38e992d959f3e142','927040fde1e8babed6445d48cf79a3fedbc9c5cb5c37d55ca474d8b98f805e1a');
  INSERT INTO blocks VALUES(310097,'13e8e16e67c7cdcc80d477491e554b43744f90e8e1a9728439a11fab42cefadf',310097000,NULL,NULL,'aea4d61b96cff7e532f800532f8957acef04ffd0be584844d589051073dd5654','e01ca2744628279e760020ada0481c7a52032877f4daef45f69731112a6e80a5','d86e60e59a298d8fa29c32b9756871d82cb8e3f535dfcf0cd77d889682f418b6');
  INSERT INTO blocks VALUES(310098,'ca5bca4b5ec4fa6183e05176abe921cff884c4e20910fab55b603cef48dc3bca',310098000,NULL,NULL,'c00ff4ad29d722beada65947efd068c9e6d9b2623c586836dd3a53f844d830f4','9df9de38050e094bb79a026b8be3a8b0c69dd909ae43b79d0a0757fdda0aec01','20485a0364ac2e9bd5149a00db7105b10ba0523e6c4208abad1d7a7c2d36d392');
  INSERT INTO blocks VALUES(310099,'3c4c2279cd7de0add5ec469648a845875495a7d54ebfb5b012dcc5a197b7992a',310099000,NULL,NULL,'2e8032f25e5213148b8775e98f8d0844ce813a40bf1c4875f77d2ca47fec26c8','a313851c73f7a9f4dbde3966e4124b83d202f645f13d6fcfbd66eb04d9f72a3b','b46a5b2a4d62771bf408a56c05206da498e148369d0336a44b107dadb210abed');
  INSERT INTO blocks VALUES(310100,'96925c05b3c7c80c716f5bef68d161c71d044252c766ca0e3f17f255764242cb',310100000,NULL,NULL,'55f680e918d026d73aaa5dcc7f915e6ca841d91d6dfc2a3c29cf56a144f9b20a','3510e89a1630a51d18d83f1c200fdf535b81077a9286b57837b3df0b3b552795','a976942fbe695f62136c69f508f328a2769e915a99cc5d0bca3688e9efdfb829');
  INSERT INTO blocks VALUES(310101,'369472409995ca1a2ebecbad6bf9dab38c378ab1e67e1bdf13d4ce1346731cd6',310101000,NULL,NULL,'fbd9def8d22343c87c4465cddf6b34f8118f4171176e5ae10c45c30d65164ca9','fec5971f0150bb127a2345bb4bf1f943978fa09df4ebc4ade0873c6cc51a8bf0','0c5fd0cdad2dcfd33cfe6450e0fbe0122301363cf7effa2e3f2d0f993fddf735');
  -- 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,'22b11bccbc5617c50f71668fccc6b1580067244171cff36dc3c3a0f1f5a6de44',310011,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',1388000000,100.0,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(19,'e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe',310018,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',1388000050,99.86166,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(20,'b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16',310019,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',1388000101,100.343,5000000,'Unit Test',0,'valid');
  INSERT INTO broadcasts VALUES(21,'e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9',310020,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',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,'e343d425bb15e33eef063c393a4b7fa30d59ba7c2b00f79a53dd415d3b065350',310004,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',50000000,'b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2','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,'0ab42cc7e6e4f5f79d7c196a7d592702b1a542e595146d7fc58f54d70e0ad31b',310000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',62000000,93000000000,'valid');
  INSERT INTO burns VALUES(23,'9ce2f63542be9fd6e1323d838f2e16caecd117156b867514937a7678341beb27',310022,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',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  contracts
  DROP TABLE IF EXISTS contracts;
  CREATE TABLE contracts(
                        contract_id TEXT PRIMARY KEY,
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        code BLOB,
                        nonce INTEGER,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  contracts
  CREATE TRIGGER _contracts_delete BEFORE DELETE ON contracts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO contracts(rowid,contract_id,tx_index,tx_hash,block_index,source,code,nonce) VALUES('||old.rowid||','||quote(old.contract_id)||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.code)||','||quote(old.nonce)||')');
                              END;
  CREATE TRIGGER _contracts_insert AFTER INSERT ON contracts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM contracts WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _contracts_update AFTER UPDATE ON contracts BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE contracts SET contract_id='||quote(old.contract_id)||',tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',code='||quote(old.code)||',nonce='||quote(old.nonce)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX contract_id_idx ON contracts(contract_id);
  
  -- Table  credits
  DROP TABLE IF EXISTS credits;
  CREATE TABLE credits(
                        block_index INTEGER,
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER,
                        calling_function TEXT,
                        event TEXT,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  INSERT INTO credits VALUES(310000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',93000000000,'burn','0ab42cc7e6e4f5f79d7c196a7d592702b1a542e595146d7fc58f54d70e0ad31b');
  INSERT INTO credits VALUES(310001,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','XCP',50000000,'send','627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c');
  INSERT INTO credits VALUES(310004,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',100000000,'btcpay','e343d425bb15e33eef063c393a4b7fa30d59ba7c2b00f79a53dd415d3b065350');
  INSERT INTO credits VALUES(310005,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',1000000000,'issuance','0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359');
  INSERT INTO credits VALUES(310006,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBC',100000,'issuance','70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246');
  INSERT INTO credits VALUES(310007,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBB',4000000,'send','5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f');
  INSERT INTO credits VALUES(310008,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBC',526,'send','2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f');
  INSERT INTO credits VALUES(310009,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','XCP',24,'dividend','64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131');
  INSERT INTO credits VALUES(310010,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','XCP',420800,'dividend','c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563');
  INSERT INTO credits VALUES(310013,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',4250000,'filled','b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468');
  INSERT INTO credits VALUES(310014,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',5000000,'cancel order','681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2');
  INSERT INTO credits VALUES(310015,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',0,'filled','5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97');
  INSERT INTO credits VALUES(310015,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',0,'filled','5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97');
  INSERT INTO credits VALUES(310017,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',0,'filled','937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3');
  INSERT INTO credits VALUES(310017,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',0,'filled','937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3');
  INSERT INTO credits VALUES(310018,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',59137500,'bet settled: liquidated for bear','e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe');
  INSERT INTO credits VALUES(310018,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',3112500,'feed fee','e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe');
  INSERT INTO credits VALUES(310019,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',159300000,'bet settled','b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16');
  INSERT INTO credits VALUES(310019,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',315700000,'bet settled','b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16');
  INSERT INTO credits VALUES(310019,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',25000000,'feed fee','b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16');
  INSERT INTO credits VALUES(310020,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',1330000000,'bet settled: for notequal','e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9');
  INSERT INTO credits VALUES(310020,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',70000000,'feed fee','e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9');
  INSERT INTO credits VALUES(310022,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',56999887262,'burn','9ce2f63542be9fd6e1323d838f2e16caecd117156b867514937a7678341beb27');
  INSERT INTO credits VALUES(310023,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',8500000,'recredit wager remaining','e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b');
  INSERT INTO credits VALUES(310023,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBC',10000,'send','2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25');
  INSERT INTO credits VALUES(310032,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',50000000,'cancel order','e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5');
  -- Triggers and indices on  credits
  CREATE TRIGGER _credits_delete BEFORE DELETE ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO credits(rowid,block_index,address,asset,quantity,calling_function,event) VALUES('||old.rowid||','||quote(old.block_index)||','||quote(old.address)||','||quote(old.asset)||','||quote(old.quantity)||','||quote(old.calling_function)||','||quote(old.event)||')');
                              END;
  CREATE TRIGGER _credits_insert AFTER INSERT ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM credits WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _credits_update AFTER UPDATE ON credits BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE credits SET block_index='||quote(old.block_index)||',address='||quote(old.address)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',calling_function='||quote(old.calling_function)||',event='||quote(old.event)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  debits
  DROP TABLE IF EXISTS debits;
  CREATE TABLE debits(
                        block_index INTEGER,
                        address TEXT,
                        asset TEXT,
                        quantity INTEGER,
                        action TEXT,
                        event TEXT,
                        FOREIGN KEY (block_index) REFERENCES blocks(block_index));
  INSERT INTO debits VALUES(310001,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',50000000,'send','627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c');
  INSERT INTO debits VALUES(310003,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',105000000,'open order','681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2');
  INSERT INTO debits VALUES(310005,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',50000000,'issuance fee','0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359');
  INSERT INTO debits VALUES(310006,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',50000000,'issuance fee','70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246');
  INSERT INTO debits VALUES(310007,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',4000000,'send','5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f');
  INSERT INTO debits VALUES(310008,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBC',526,'send','2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f');
  INSERT INTO debits VALUES(310009,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',24,'dividend','64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131');
  INSERT INTO debits VALUES(310009,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',20000,'dividend fee','64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131');
  INSERT INTO debits VALUES(310010,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',420800,'dividend','c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563');
  INSERT INTO debits VALUES(310010,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',20000,'dividend fee','c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563');
  INSERT INTO debits VALUES(310012,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',50000000,'bet','e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b');
  INSERT INTO debits VALUES(310013,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',25000000,'bet','b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468');
  INSERT INTO debits VALUES(310014,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',150000000,'bet','ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e');
  INSERT INTO debits VALUES(310015,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',350000000,'bet','5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97');
  INSERT INTO debits VALUES(310016,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',750000000,'bet','4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731');
  INSERT INTO debits VALUES(310017,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',650000000,'bet','937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3');
  INSERT INTO debits VALUES(310021,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',50000000,'open order','e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5');
  INSERT INTO debits VALUES(310023,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBC',10000,'send','2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25');
  -- 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  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,'64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131',310009,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB','XCP',600,20000,'valid');
  INSERT INTO dividends VALUES(11,'c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563',310010,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBC','XCP',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  executions
  DROP TABLE IF EXISTS executions;
  CREATE TABLE executions(
                        tx_index INTEGER UNIQUE,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        contract_id TEXT,
                        gas_price INTEGER,
                        gas_start INTEGER,
                        gas_cost INTEGER,
                        gas_remained INTEGER,
                        value INTEGER,
                        data BLOB,
                        output BLOB,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  -- Triggers and indices on  executions
  CREATE TRIGGER _executions_delete BEFORE DELETE ON executions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO executions(rowid,tx_index,tx_hash,block_index,source,contract_id,gas_price,gas_start,gas_cost,gas_remained,value,data,output,status) VALUES('||old.rowid||','||quote(old.tx_index)||','||quote(old.tx_hash)||','||quote(old.block_index)||','||quote(old.source)||','||quote(old.contract_id)||','||quote(old.gas_price)||','||quote(old.gas_start)||','||quote(old.gas_cost)||','||quote(old.gas_remained)||','||quote(old.value)||','||quote(old.data)||','||quote(old.output)||','||quote(old.status)||')');
                              END;
  CREATE TRIGGER _executions_insert AFTER INSERT ON executions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM executions WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _executions_update AFTER UPDATE ON executions BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE executions SET tx_index='||quote(old.tx_index)||',tx_hash='||quote(old.tx_hash)||',block_index='||quote(old.block_index)||',source='||quote(old.source)||',contract_id='||quote(old.contract_id)||',gas_price='||quote(old.gas_price)||',gas_start='||quote(old.gas_start)||',gas_cost='||quote(old.gas_cost)||',gas_remained='||quote(old.gas_remained)||',value='||quote(old.value)||',data='||quote(old.data)||',output='||quote(old.output)||',status='||quote(old.status)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  issuances
  DROP TABLE IF EXISTS issuances;
  CREATE TABLE issuances(
                        tx_index INTEGER PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        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,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO issuances VALUES(6,'0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359',310005,'BBBB',1000000000,1,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',0,0,0,0.0,'',50000000,0,'valid',NULL);
  INSERT INTO issuances VALUES(7,'70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246',310006,'BBBC',100000,0,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',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,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.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)||',block_index='||quote(old.block_index)||',asset='||quote(old.asset)||',quantity='||quote(old.quantity)||',divisible='||quote(old.divisible)||',source='||quote(old.source)||',issuer='||quote(old.issuer)||',transfer='||quote(old.transfer)||',callable='||quote(old.callable)||',call_date='||quote(old.call_date)||',call_price='||quote(old.call_price)||',description='||quote(old.description)||',fee_paid='||quote(old.fee_paid)||',locked='||quote(old.locked)||',status='||quote(old.status)||',asset_longname='||quote(old.asset_longname)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX valid_asset_idx ON issuances (asset, status);
  
  -- Table  mempool
  DROP TABLE IF EXISTS mempool;
  CREATE TABLE mempool(
                        tx_hash TEXT,
                        command TEXT,
                        category TEXT,
                        bindings TEXT,
                        timestamp INTEGER);
  
  -- Table  messages
  DROP TABLE IF EXISTS messages;
  CREATE TABLE messages(
                        message_index INTEGER PRIMARY KEY,
                        block_index INTEGER,
                        command TEXT,
                        category TEXT,
                        bindings TEXT,
                        timestamp INTEGER);
  INSERT INTO messages VALUES(0,310000,'insert','credits','{"action": "burn", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310000, "event": "0ab42cc7e6e4f5f79d7c196a7d592702b1a542e595146d7fc58f54d70e0ad31b", "quantity": 93000000000}',0);
  INSERT INTO messages VALUES(1,310000,'insert','burns','{"block_index": 310000, "burned": 62000000, "earned": 93000000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "0ab42cc7e6e4f5f79d7c196a7d592702b1a542e595146d7fc58f54d70e0ad31b", "tx_index": 1}',0);
  INSERT INTO messages VALUES(2,310001,'insert','debits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310001, "event": "627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(3,310001,'insert','credits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "XCP", "block_index": 310001, "event": "627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(4,310001,'insert','sends','{"asset": "XCP", "block_index": 310001, "destination": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "quantity": 50000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c", "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": "XCP", "get_quantity": 100000000, "get_remaining": 100000000, "give_asset": "BTC", "give_quantity": 50000000, "give_remaining": 50000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "tx_hash": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86", "tx_index": 3}',0);
  INSERT INTO messages VALUES(6,310003,'insert','debits','{"action": "open order", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310003, "event": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "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": "XCP", "give_quantity": 105000000, "give_remaining": 105000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "tx_hash": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "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": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86"}',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": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2"}',0);
  INSERT INTO messages VALUES(10,310003,'insert','order_matches','{"backward_asset": "XCP", "backward_quantity": 100000000, "block_index": 310003, "fee_paid": 857142, "forward_asset": "BTC", "forward_quantity": 50000000, "id": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "match_expire_index": 310023, "status": "pending", "tx0_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx0_block_index": 310002, "tx0_expiration": 10, "tx0_hash": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86", "tx0_index": 3, "tx1_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx1_block_index": 310003, "tx1_expiration": 10, "tx1_hash": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "tx1_index": 4}',0);
  INSERT INTO messages VALUES(11,310004,'insert','credits','{"action": "btcpay", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310004, "event": "e343d425bb15e33eef063c393a4b7fa30d59ba7c2b00f79a53dd415d3b065350", "quantity": 100000000}',0);
  INSERT INTO messages VALUES(12,310004,'update','order_matches','{"order_match_id": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "status": "completed"}',0);
  INSERT INTO messages VALUES(13,310004,'insert','btcpays','{"block_index": 310004, "btc_amount": 50000000, "destination": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "order_match_id": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "e343d425bb15e33eef063c393a4b7fa30d59ba7c2b00f79a53dd415d3b065350", "tx_index": 5}',0);
  INSERT INTO messages VALUES(14,310005,'insert','debits','{"action": "issuance fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310005, "event": "0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(15,310005,'insert','issuances','{"asset": "BBBB", "asset_longname": null, "block_index": 310005, "call_date": 0, "call_price": 0.0, "callable": false, "description": "", "divisible": true, "fee_paid": 50000000, "issuer": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "locked": false, "quantity": 1000000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "transfer": false, "tx_hash": "0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359", "tx_index": 6}',0);
  INSERT INTO messages VALUES(16,310005,'insert','credits','{"action": "issuance", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBB", "block_index": 310005, "event": "0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359", "quantity": 1000000000}',0);
  INSERT INTO messages VALUES(17,310006,'insert','debits','{"action": "issuance fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310006, "event": "70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(18,310006,'insert','issuances','{"asset": "BBBC", "asset_longname": null, "block_index": 310006, "call_date": 0, "call_price": 0.0, "callable": false, "description": "foobar", "divisible": false, "fee_paid": 50000000, "issuer": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "locked": false, "quantity": 100000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "transfer": false, "tx_hash": "70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246", "tx_index": 7}',0);
  INSERT INTO messages VALUES(19,310006,'insert','credits','{"action": "issuance", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBC", "block_index": 310006, "event": "70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246", "quantity": 100000}',0);
  INSERT INTO messages VALUES(20,310007,'insert','debits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBB", "block_index": 310007, "event": "5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(21,310007,'insert','credits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "BBBB", "block_index": 310007, "event": "5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f", "quantity": 4000000}',0);
  INSERT INTO messages VALUES(22,310007,'insert','sends','{"asset": "BBBB", "block_index": 310007, "destination": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "quantity": 4000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f", "tx_index": 8}',0);
  INSERT INTO messages VALUES(23,310008,'insert','debits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBC", "block_index": 310008, "event": "2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f", "quantity": 526}',0);
  INSERT INTO messages VALUES(24,310008,'insert','credits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "BBBC", "block_index": 310008, "event": "2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f", "quantity": 526}',0);
  INSERT INTO messages VALUES(25,310008,'insert','sends','{"asset": "BBBC", "block_index": 310008, "destination": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "quantity": 526, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f", "tx_index": 9}',0);
  INSERT INTO messages VALUES(26,310009,'insert','debits','{"action": "dividend", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310009, "event": "64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131", "quantity": 24}',0);
  INSERT INTO messages VALUES(27,310009,'insert','debits','{"action": "dividend fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310009, "event": "64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131", "quantity": 20000}',0);
  INSERT INTO messages VALUES(28,310009,'insert','credits','{"action": "dividend", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "XCP", "block_index": 310009, "event": "64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131", "quantity": 24}',0);
  INSERT INTO messages VALUES(29,310009,'insert','dividends','{"asset": "BBBB", "block_index": 310009, "dividend_asset": "XCP", "fee_paid": 20000, "quantity_per_unit": 600, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131", "tx_index": 10}',0);
  INSERT INTO messages VALUES(30,310010,'insert','debits','{"action": "dividend", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310010, "event": "c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563", "quantity": 420800}',0);
  INSERT INTO messages VALUES(31,310010,'insert','debits','{"action": "dividend fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310010, "event": "c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563", "quantity": 20000}',0);
  INSERT INTO messages VALUES(32,310010,'insert','credits','{"action": "dividend", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "XCP", "block_index": 310010, "event": "c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563", "quantity": 420800}',0);
  INSERT INTO messages VALUES(33,310010,'insert','dividends','{"asset": "BBBC", "block_index": 310010, "dividend_asset": "XCP", "fee_paid": 20000, "quantity_per_unit": 800, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563", "tx_index": 11}',0);
  INSERT INTO messages VALUES(34,310011,'insert','broadcasts','{"block_index": 310011, "fee_fraction_int": 5000000, "locked": false, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "text": "Unit Test", "timestamp": 1388000000, "tx_hash": "22b11bccbc5617c50f71668fccc6b1580067244171cff36dc3c3a0f1f5a6de44", "tx_index": 12, "value": 100.0}',0);
  INSERT INTO messages VALUES(35,310012,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310012, "event": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 15120, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 0.0, "tx_hash": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "tx_index": 13, "wager_quantity": 50000000, "wager_remaining": 50000000}',0);
  INSERT INTO messages VALUES(37,310013,'update','orders','{"status": "expired", "tx_hash": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86"}',0);
  INSERT INTO messages VALUES(38,310013,'insert','order_expirations','{"block_index": 310013, "order_hash": "b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86", "order_index": 3, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3"}',0);
  INSERT INTO messages VALUES(39,310013,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310013, "event": "b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 15120, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 0.0, "tx_hash": "b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "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": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "wager_remaining": 8500000}',0);
  INSERT INTO messages VALUES(42,310013,'insert','credits','{"action": "filled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310013, "event": "b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "quantity": 4250000}',0);
  INSERT INTO messages VALUES(43,310013,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "wager_remaining": 4250000}',0);
  INSERT INTO messages VALUES(44,310013,'insert','bet_matches','{"backward_quantity": 20750000, "block_index": 310013, "deadline": 1388000100, "fee_fraction_int": 5000000, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "forward_quantity": 41500000, "id": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "initial_value": 100.0, "leverage": 15120, "match_expire_index": 310022, "status": "pending", "target_value": 0.0, "tx0_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx0_bet_type": 0, "tx0_block_index": 310012, "tx0_expiration": 10, "tx0_hash": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "tx0_index": 13, "tx1_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx1_bet_type": 1, "tx1_block_index": 310013, "tx1_expiration": 10, "tx1_hash": "b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "tx1_index": 14}',0);
  INSERT INTO messages VALUES(45,310014,'update','orders','{"status": "expired", "tx_hash": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2"}',0);
  INSERT INTO messages VALUES(46,310014,'insert','credits','{"action": "cancel order", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310014, "event": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "quantity": 5000000}',0);
  INSERT INTO messages VALUES(47,310014,'insert','order_expirations','{"block_index": 310014, "order_hash": "681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2", "order_index": 4, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3"}',0);
  INSERT INTO messages VALUES(48,310014,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310014, "event": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 5040, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 0.0, "tx_hash": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e", "tx_index": 15, "wager_quantity": 150000000, "wager_remaining": 150000000}',0);
  INSERT INTO messages VALUES(50,310015,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310015, "event": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 5040, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 0.0, "tx_hash": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "tx_index": 16, "wager_quantity": 350000000, "wager_remaining": 350000000}',0);
  INSERT INTO messages VALUES(52,310015,'insert','credits','{"action": "filled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310015, "event": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "quantity": 0}',0);
  INSERT INTO messages VALUES(53,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(54,310015,'insert','credits','{"action": "filled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310015, "event": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "quantity": 0}',0);
  INSERT INTO messages VALUES(55,310015,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(56,310015,'insert','bet_matches','{"backward_quantity": 350000000, "block_index": 310015, "deadline": 1388000100, "fee_fraction_int": 5000000, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "forward_quantity": 150000000, "id": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310024, "status": "pending", "target_value": 0.0, "tx0_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx0_bet_type": 0, "tx0_block_index": 310014, "tx0_expiration": 10, "tx0_hash": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e", "tx0_index": 15, "tx1_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx1_bet_type": 1, "tx1_block_index": 310015, "tx1_expiration": 10, "tx1_hash": "5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "tx1_index": 16}',0);
  INSERT INTO messages VALUES(57,310016,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310016, "event": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 5040, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 1.0, "tx_hash": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731", "tx_index": 17, "wager_quantity": 750000000, "wager_remaining": 750000000}',0);
  INSERT INTO messages VALUES(59,310017,'insert','debits','{"action": "bet", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310017, "event": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "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": 5000000.0, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "leverage": 5040, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "target_value": 1.0, "tx_hash": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "tx_index": 18, "wager_quantity": 650000000, "wager_remaining": 650000000}',0);
  INSERT INTO messages VALUES(61,310017,'insert','credits','{"action": "filled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310017, "event": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "quantity": 0}',0);
  INSERT INTO messages VALUES(62,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(63,310017,'insert','credits','{"action": "filled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310017, "event": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "quantity": 0}',0);
  INSERT INTO messages VALUES(64,310017,'update','bets','{"counterwager_remaining": 0, "status": "filled", "tx_hash": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "wager_remaining": 0}',0);
  INSERT INTO messages VALUES(65,310017,'insert','bet_matches','{"backward_quantity": 650000000, "block_index": 310017, "deadline": 1388000200, "fee_fraction_int": 5000000, "feed_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "forward_quantity": 750000000, "id": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "initial_value": 100.0, "leverage": 5040, "match_expire_index": 310026, "status": "pending", "target_value": 1.0, "tx0_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx0_bet_type": 2, "tx0_block_index": 310016, "tx0_expiration": 10, "tx0_hash": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731", "tx0_index": 17, "tx1_address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "tx1_bet_type": 3, "tx1_block_index": 310017, "tx1_expiration": 10, "tx1_hash": "937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "tx1_index": 18}',0);
  INSERT INTO messages VALUES(66,310018,'insert','broadcasts','{"block_index": 310018, "fee_fraction_int": 5000000, "locked": false, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "text": "Unit Test", "timestamp": 1388000050, "tx_hash": "e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe", "tx_index": 19, "value": 99.86166}',0);
  INSERT INTO messages VALUES(67,310018,'insert','credits','{"action": "bet settled: liquidated for bear", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310018, "event": "e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe", "quantity": 59137500}',0);
  INSERT INTO messages VALUES(68,310018,'insert','credits','{"action": "feed fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310018, "event": "e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe", "quantity": 3112500}',0);
  INSERT INTO messages VALUES(69,310018,'insert','bet_match_resolutions','{"bear_credit": 59137500, "bet_match_id": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "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": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468", "status": "settled: liquidated for bear"}',0);
  INSERT INTO messages VALUES(71,310019,'insert','broadcasts','{"block_index": 310019, "fee_fraction_int": 5000000, "locked": false, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "text": "Unit Test", "timestamp": 1388000101, "tx_hash": "b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16", "tx_index": 20, "value": 100.343}',0);
  INSERT INTO messages VALUES(72,310019,'insert','credits','{"action": "bet settled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310019, "event": "b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16", "quantity": 159300000}',0);
  INSERT INTO messages VALUES(73,310019,'insert','credits','{"action": "bet settled", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310019, "event": "b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16", "quantity": 315700000}',0);
  INSERT INTO messages VALUES(74,310019,'insert','credits','{"action": "feed fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310019, "event": "b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16", "quantity": 25000000}',0);
  INSERT INTO messages VALUES(75,310019,'insert','bet_match_resolutions','{"bear_credit": 315700000, "bet_match_id": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "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": "ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97", "status": "settled"}',0);
  INSERT INTO messages VALUES(77,310020,'insert','broadcasts','{"block_index": 310020, "fee_fraction_int": 5000000, "locked": false, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "text": "Unit Test", "timestamp": 1388000201, "tx_hash": "e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9", "tx_index": 21, "value": 2.0}',0);
  INSERT INTO messages VALUES(78,310020,'insert','credits','{"action": "bet settled: for notequal", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310020, "event": "e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9", "quantity": 1330000000}',0);
  INSERT INTO messages VALUES(79,310020,'insert','credits','{"action": "feed fee", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310020, "event": "e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9", "quantity": 70000000}',0);
  INSERT INTO messages VALUES(80,310020,'insert','bet_match_resolutions','{"bear_credit": null, "bet_match_id": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "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": "4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3", "status": "settled: for notequal"}',0);
  INSERT INTO messages VALUES(82,310021,'insert','debits','{"action": "open order", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBB", "block_index": 310021, "event": "e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5", "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": "XCP", "get_quantity": 50000000, "get_remaining": 50000000, "give_asset": "BBBB", "give_quantity": 50000000, "give_remaining": 50000000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "open", "tx_hash": "e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5", "tx_index": 22}',0);
  INSERT INTO messages VALUES(84,310022,'insert','credits','{"action": "burn", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310022, "event": "9ce2f63542be9fd6e1323d838f2e16caecd117156b867514937a7678341beb27", "quantity": 56999887262}',0);
  INSERT INTO messages VALUES(85,310022,'insert','burns','{"block_index": 310022, "burned": 38000000, "earned": 56999887262, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "9ce2f63542be9fd6e1323d838f2e16caecd117156b867514937a7678341beb27", "tx_index": 23}',0);
  INSERT INTO messages VALUES(86,310023,'update','bets','{"status": "expired", "tx_hash": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b"}',0);
  INSERT INTO messages VALUES(87,310023,'insert','credits','{"action": "recredit wager remaining", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "XCP", "block_index": 310023, "event": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "quantity": 8500000}',0);
  INSERT INTO messages VALUES(88,310023,'insert','bet_expirations','{"bet_hash": "e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b", "bet_index": 13, "block_index": 310023, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3"}',0);
  INSERT INTO messages VALUES(89,310023,'insert','debits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBC", "block_index": 310023, "event": "2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25", "quantity": 10000}',0);
  INSERT INTO messages VALUES(90,310023,'insert','credits','{"action": "send", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "asset": "BBBC", "block_index": 310023, "event": "2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25", "quantity": 10000}',0);
  INSERT INTO messages VALUES(91,310023,'insert','sends','{"asset": "BBBC", "block_index": 310023, "destination": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3", "quantity": 10000, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "status": "valid", "tx_hash": "2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25", "tx_index": 24}',0);
  INSERT INTO messages VALUES(92,310032,'update','orders','{"status": "expired", "tx_hash": "e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5"}',0);
  INSERT INTO messages VALUES(93,310032,'insert','credits','{"action": "cancel order", "address": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3", "asset": "BBBB", "block_index": 310032, "event": "e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5", "quantity": 50000000}',0);
  INSERT INTO messages VALUES(94,310032,'insert','order_expirations','{"block_index": 310032, "order_hash": "e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5", "order_index": 22, "source": "2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3"}',0);
  -- Triggers and indices on  messages
  CREATE INDEX block_index_message_index_idx ON messages (block_index, message_index);
  
  -- Table  nonces
  DROP TABLE IF EXISTS nonces;
  CREATE TABLE nonces(
                        address TEXT PRIMARY KEY,
                        nonce INTEGER);
  -- Triggers and indices on  nonces
  CREATE TRIGGER _nonces_delete BEFORE DELETE ON nonces BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO nonces(rowid,address,nonce) VALUES('||old.rowid||','||quote(old.address)||','||quote(old.nonce)||')');
                              END;
  CREATE TRIGGER _nonces_insert AFTER INSERT ON nonces BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM nonces WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _nonces_update AFTER UPDATE ON nonces BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE nonces SET address='||quote(old.address)||',nonce='||quote(old.nonce)||' WHERE rowid='||old.rowid);
                              END;
  
  -- 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,'b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',310013);
  INSERT INTO order_expirations VALUES(4,'681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',310014);
  INSERT INTO order_expirations VALUES(22,'e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',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('b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2',3,'b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',4,'681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BTC',50000000,'XCP',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,'b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86',310002,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BTC',50000000,0,'XCP',100000000,0,10,310012,0,0,1000000,142858,'expired');
  INSERT INTO orders VALUES(4,'681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2',310003,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','XCP',105000000,5000000,'BTC',50000000,0,10,310013,900000,42858,6800,6800,'expired');
  INSERT INTO orders VALUES(22,'e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5',310021,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','BBBB',50000000,50000000,'XCP',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  postqueue
  DROP TABLE IF EXISTS postqueue;
  CREATE TABLE postqueue(
                        message BLOB);
  -- Triggers and indices on  postqueue
  CREATE TRIGGER _postqueue_delete BEFORE DELETE ON postqueue BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO postqueue(rowid,message) VALUES('||old.rowid||','||quote(old.message)||')');
                              END;
  CREATE TRIGGER _postqueue_insert AFTER INSERT ON postqueue BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM postqueue WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _postqueue_update AFTER UPDATE ON postqueue BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE postqueue SET message='||quote(old.message)||' WHERE rowid='||old.rowid);
                              END;
  
  -- 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 PRIMARY KEY,
                        tx_hash TEXT UNIQUE,
                        block_index INTEGER,
                        source TEXT,
                        destination TEXT,
                        asset TEXT,
                        quantity INTEGER,
                        status TEXT,
                        FOREIGN KEY (tx_index, tx_hash, block_index) REFERENCES transactions(tx_index, tx_hash, block_index));
  INSERT INTO sends VALUES(2,'627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c',310001,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','XCP',50000000,'valid');
  INSERT INTO sends VALUES(8,'5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f',310007,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBB',4000000,'valid');
  INSERT INTO sends VALUES(9,'2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f',310008,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBC',526,'valid');
  INSERT INTO sends VALUES(24,'2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25',310023,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3','BBBC',10000,'valid');
  -- 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) 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)||')');
                              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)||' WHERE rowid='||old.rowid);
                              END;
  CREATE INDEX destination_idx ON sends (destination);
  CREATE INDEX source_idx ON sends (source);
  
  -- Table  storage
  DROP TABLE IF EXISTS storage;
  CREATE TABLE storage(
                        contract_id TEXT,
                        key BLOB,
                        value BLOB,
                        FOREIGN KEY (contract_id) REFERENCES contracts(contract_id));
  -- Triggers and indices on  storage
  CREATE TRIGGER _storage_delete BEFORE DELETE ON storage BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO storage(rowid,contract_id,key,value) VALUES('||old.rowid||','||quote(old.contract_id)||','||quote(old.key)||','||quote(old.value)||')');
                              END;
  CREATE TRIGGER _storage_insert AFTER INSERT ON storage BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM storage WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _storage_update AFTER UPDATE ON storage BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE storage SET contract_id='||quote(old.contract_id)||',key='||quote(old.key)||',value='||quote(old.value)||' WHERE rowid='||old.rowid);
                              END;
  
  -- Table  suicides
  DROP TABLE IF EXISTS suicides;
  CREATE TABLE suicides(
                        contract_id TEXT PRIMARY KEY,
                        FOREIGN KEY (contract_id) REFERENCES contracts(contract_id));
  -- Triggers and indices on  suicides
  CREATE TRIGGER _suicides_delete BEFORE DELETE ON suicides BEGIN
                              INSERT INTO undolog VALUES(NULL, 'INSERT INTO suicides(rowid,contract_id) VALUES('||old.rowid||','||quote(old.contract_id)||')');
                              END;
  CREATE TRIGGER _suicides_insert AFTER INSERT ON suicides BEGIN
                              INSERT INTO undolog VALUES(NULL, 'DELETE FROM suicides WHERE rowid='||new.rowid);
                              END;
  CREATE TRIGGER _suicides_update AFTER UPDATE ON suicides BEGIN
                              INSERT INTO undolog VALUES(NULL, 'UPDATE suicides SET contract_id='||quote(old.contract_id)||' 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,'0ab42cc7e6e4f5f79d7c196a7d592702b1a542e595146d7fc58f54d70e0ad31b',310000,'505d8d82c4ced7daddef7ed0b05ba12ecc664176887b938ef56c6af276f3b30c',310000000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','mvCounterpartyXXXXXXXXXXXXXXW24Hef',62000000,5625,X'',1);
  INSERT INTO transactions VALUES(2,'627e9d8ae02c51cb1c92852ac6186d9e0d6949cee0cb1a220df0512cece39c1c',310001,'3c9f6a9c6cac46a9273bd3db39ad775acd5bc546378ec2fb0587e06e112cc78e',310001000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3',7800,7650,X'0000000000000000000000010000000002FAF080',1);
  INSERT INTO transactions VALUES(3,'b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86',310002,'fbb60f1144e1f7d4dc036a4a158a10ea6dea2ba6283a723342a49b8eb5cc9964',310002000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,1000000,X'0000000A00000000000000000000000002FAF08000000000000000010000000005F5E100000A0000000000000000',1);
  INSERT INTO transactions VALUES(4,'681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2',310003,'d50825dcb32bcf6f69994d616eba18de7718d3d859497e80751b2cb67e333e8a',310003000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000000A00000000000000010000000006422C4000000000000000000000000002FAF080000A00000000000DBBA0',1);
  INSERT INTO transactions VALUES(5,'e343d425bb15e33eef063c393a4b7fa30d59ba7c2b00f79a53dd415d3b065350',310004,'60cdc0ac0e3121ceaa2c3885f21f5789f49992ffef6e6ff99f7da80e36744615',310004000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',50000000,9675,X'0000000BB898ED7F73BA34981ADDE222BF27498F66F352254817B0F4D07156A62B387E86681CDD4607BB2436E664BDC109DF770FAA00E7BDC29713817AE2D954E6A476A2',1);
  INSERT INTO transactions VALUES(6,'0c71c7261f7abaf85bd1fa962c714a5456a07cfc189eca391f6bc07e83c90359',310005,'8005c2926b7ecc50376642bc661a49108b6dc62636463a5c492b123e2184cd9a',310005000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'000000140000000000004767000000003B9ACA000100000000000000000000',1);
  INSERT INTO transactions VALUES(7,'70cc5f10f0a806ef7638d2915fdf14fe274a63e5b192018a47c5ac5aabe65246',310006,'bdad69d1669eace68b9f246de113161099d4f83322e2acf402c42defef3af2bb',310006000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'00000014000000000000476800000000000186A00000000000000000000006666F6F626172',1);
  INSERT INTO transactions VALUES(8,'5db3bb5e51124ad64c8034edad9f8f3a2c201f53ec430f1861b91ccc8a61547f',310007,'10a642b96d60091d08234d17dfdecf3025eca41e4fc8e3bbe71a91c5a457cb4b',310007000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3',7800,7650,X'00000000000000000000476700000000003D0900',1);
  INSERT INTO transactions VALUES(9,'2a6c7b5d677ab434dcfa3573ddc9489d7e8d673ea314d0efcfd5a75eabeeb77f',310008,'47d0e3acbdc6916aeae95e987f9cfa16209b3df1e67bb38143b3422b32322c33',310008000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3',7800,7650,X'000000000000000000004768000000000000020E',1);
  INSERT INTO transactions VALUES(10,'64a8eed570a6c8b69188e16e2e85e5984278e3ea7c138c715ab64e4852df6131',310009,'4d474992b141620bf3753863db7ee5e8af26cadfbba27725911f44fa657bc1c0',310009000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'00000032000000000000025800000000000047670000000000000001',1);
  INSERT INTO transactions VALUES(11,'c6e54112879767827bb736c06fcb779c309e6408b4f0f958c75744524504f563',310010,'a58162dff81a32e6a29b075be759dbb9fa9b8b65303e69c78fb4d7b0acc37042',310010000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'00000032000000000000032000000000000047680000000000000001',1);
  INSERT INTO transactions VALUES(12,'22b11bccbc5617c50f71668fccc6b1580067244171cff36dc3c3a0f1f5a6de44',310011,'8042cc2ef293fd73d050f283fbd075c79dd4c49fdcca054dc0714fc3a50dc1bb',310011000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000001E52BB33004059000000000000004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(13,'e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b',310012,'cdba329019d93a67b31b79d05f76ce1b7791d430ea0d6c1c2168fe78d2f67677',310012000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000052BB33640000000002FAF08000000000017D7840000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(14,'b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468',310013,'0425e5e832e4286757dc0228cd505b8d572081007218abd3a0983a3bcd502a61',310013000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000152BB336400000000017D78400000000002793D60000000000000000000003B100000000A',1);
  INSERT INTO transactions VALUES(15,'ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e',310014,'85b28d413ebda2968ed82ae53643677338650151b997ed1e4656158005b9f65f',310014000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000052BB33640000000008F0D1800000000014DC93800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(16,'5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97',310015,'4cf77d688f18f0c68c077db882f62e49f31859dfa6144372457cd73b29223922',310015000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000152BB33640000000014DC93800000000008F0D1800000000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(17,'4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731',310016,'99dc7d2627efb4e5e618a53b9898b4ca39c70e98fe9bf39f68a6c980f5b64ef9',310016000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000252BB33C8000000002CB417800000000026BE36803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(18,'937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3',310017,'8a4fedfbf734b91a5c5761a7bcb3908ea57169777a7018148c51ff611970e4a3',310017000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3',7800,7650,X'00000028000352BB33C80000000026BE3680000000002CB417803FF0000000000000000013B00000000A',1);
  INSERT INTO transactions VALUES(19,'e8dfdf90027e161507f4712520243025a9b0b93e113af46f6dfeaf520e455ebe',310018,'35c06f9e3de39e4e56ceb1d1a22008f52361c50dd0d251c0acbe2e3c2dba8ed3',310018000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000001E52BB33324058F7256FFC115E004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(20,'b1f867dcabccc0b7f688546f34e58566a642ad3ee54bf6ebe89ce9aec2361a16',310019,'114affa0c4f34b1ebf8e2778c9477641f60b5b9e8a69052158041d4c41893294',310019000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000001E52BB3365405915F3B645A1CB004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(21,'e753d9ca07ebc7584b80ecedd7d8314ee19feb36f9b000eee4508de44b4f4bd9',310020,'d93c79920e4a42164af74ecb5c6b903ff6055cdc007376c74dfa692c8d85ebc9',310020000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000001E52BB33C94000000000000000004C4B4009556E69742054657374',1);
  INSERT INTO transactions VALUES(22,'e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5',310021,'7c2460bb32c5749c856486393239bf7a0ac789587ac71f32e7237910da8097f2',310021000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','',0,6800,X'0000000A00000000000047670000000002FAF08000000000000000010000000002FAF080000A0000000000000000',1);
  INSERT INTO transactions VALUES(23,'9ce2f63542be9fd6e1323d838f2e16caecd117156b867514937a7678341beb27',310022,'44435f9a99a0aa12a9bfabdc4cb8119f6ea6a6e1350d2d65445fb66a456db5fc',310022000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','mvCounterpartyXXXXXXXXXXXXXXW24Hef',100000000,5625,X'',1);
  INSERT INTO transactions VALUES(24,'2136aa1b0506614152226b07f3b64efcdd63c4e58cabea06f9c75c7a82c90c25',310023,'d8cf5bec1bbcab8ca4f495352afde3b6572b7e1d61b3976872ebb8e9d30ccb08',310023000,'2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3','2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3',7800,7650,X'0000000000000000000047680000000000002710',1);
  -- Triggers and indices on  transactions
  CREATE INDEX index_hash_index_idx ON transactions (tx_index, tx_hash, block_index);
  CREATE INDEX index_index_idx ON transactions (block_index, tx_index);
  CREATE INDEX tx_hash_idx ON transactions (tx_hash);
  CREATE INDEX tx_index_idx ON transactions (tx_index);
  
  -- Table  undolog
  DROP TABLE IF EXISTS undolog;
  CREATE TABLE undolog(
                          undo_index INTEGER PRIMARY KEY AUTOINCREMENT,
                          sql TEXT);
  INSERT INTO undolog VALUES(4,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=2');
  INSERT INTO undolog VALUES(9,'DELETE FROM orders WHERE rowid=1');
  INSERT INTO undolog VALUES(10,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86'',block_index=310002,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',give_asset=''BTC'',give_quantity=50000000,give_remaining=50000000,get_asset=''XCP'',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=''681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2'',block_index=310003,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',give_asset=''XCP'',give_quantity=105000000,give_remaining=105000000,get_asset=''BTC'',get_quantity=50000000,get_remaining=50000000,expiration=10,expire_index=310013,fee_required=900000,fee_required_remaining=900000,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=2');
  INSERT INTO undolog VALUES(15,'DELETE FROM order_matches WHERE rowid=1');
  INSERT INTO undolog VALUES(16,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86_681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2'',tx0_index=3,tx0_hash=''b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86'',tx0_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx1_index=4,tx1_hash=''681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2'',tx1_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',forward_asset=''BTC'',forward_quantity=50000000,backward_asset=''XCP'',backward_quantity=100000000,tx0_block_index=310002,tx1_block_index=310003,block_index=310003,tx0_expiration=10,tx1_expiration=10,match_expire_index=310023,fee_paid=857142,status=''pending'' WHERE rowid=1');
  INSERT INTO undolog VALUES(19,'DELETE FROM btcpays WHERE rowid=5');
  INSERT INTO undolog VALUES(20,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=6');
  INSERT INTO undolog VALUES(24,'DELETE FROM balances WHERE rowid=3');
  INSERT INTO undolog VALUES(25,'DELETE FROM credits WHERE rowid=4');
  INSERT INTO undolog VALUES(26,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=7');
  INSERT INTO undolog VALUES(30,'DELETE FROM balances WHERE rowid=4');
  INSERT INTO undolog VALUES(31,'DELETE FROM credits WHERE rowid=5');
  INSERT INTO undolog VALUES(32,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=8');
  INSERT INTO undolog VALUES(37,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=9');
  INSERT INTO undolog VALUES(42,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92845000000 WHERE rowid=1');
  INSERT INTO undolog VALUES(43,'DELETE FROM debits WHERE rowid=7');
  INSERT INTO undolog VALUES(44,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92844999976 WHERE rowid=1');
  INSERT INTO undolog VALUES(45,'DELETE FROM debits WHERE rowid=8');
  INSERT INTO undolog VALUES(46,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3'',asset=''XCP'',quantity=50000000 WHERE rowid=2');
  INSERT INTO undolog VALUES(47,'DELETE FROM credits WHERE rowid=8');
  INSERT INTO undolog VALUES(48,'DELETE FROM dividends WHERE rowid=10');
  INSERT INTO undolog VALUES(49,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92844979976 WHERE rowid=1');
  INSERT INTO undolog VALUES(50,'DELETE FROM debits WHERE rowid=9');
  INSERT INTO undolog VALUES(51,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92844559176 WHERE rowid=1');
  INSERT INTO undolog VALUES(52,'DELETE FROM debits WHERE rowid=10');
  INSERT INTO undolog VALUES(53,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3'',asset=''XCP'',quantity=50000024 WHERE rowid=2');
  INSERT INTO undolog VALUES(54,'DELETE FROM credits WHERE rowid=9');
  INSERT INTO undolog VALUES(55,'DELETE FROM dividends WHERE rowid=11');
  INSERT INTO undolog VALUES(56,'DELETE FROM broadcasts WHERE rowid=12');
  INSERT INTO undolog VALUES(57,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''b898ed7f73ba34981adde222bf27498f66f352254817b0f4d07156a62b387e86'',block_index=310002,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',give_asset=''BTC'',give_quantity=50000000,give_remaining=0,get_asset=''XCP'',get_quantity=100000000,get_remaining=0,expiration=10,expire_index=310012,fee_required=0,fee_required_remaining=0,fee_provided=1000000,fee_provided_remaining=142858,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(61,'DELETE FROM order_expirations WHERE rowid=3');
  INSERT INTO undolog VALUES(62,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b'',block_index=310012,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(66,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468'',block_index=310013,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,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=''681cdd4607bb2436e664bdc109df770faa00e7bdc29713817ae2d954e6a476a2'',block_index=310003,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',give_asset=''XCP'',give_quantity=105000000,give_remaining=5000000,get_asset=''BTC'',get_quantity=50000000,get_remaining=0,expiration=10,expire_index=310013,fee_required=900000,fee_required_remaining=42858,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=2');
  INSERT INTO undolog VALUES(71,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92773789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(72,'DELETE FROM credits WHERE rowid=11');
  INSERT INTO undolog VALUES(73,'DELETE FROM order_expirations WHERE rowid=4');
  INSERT INTO undolog VALUES(74,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92778789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(75,'DELETE FROM debits WHERE rowid=13');
  INSERT INTO undolog VALUES(76,'DELETE FROM bets WHERE rowid=3');
  INSERT INTO undolog VALUES(77,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92628789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(78,'DELETE FROM debits WHERE rowid=14');
  INSERT INTO undolog VALUES(79,'DELETE FROM bets WHERE rowid=4');
  INSERT INTO undolog VALUES(80,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e'',block_index=310014,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=3');
  INSERT INTO undolog VALUES(83,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97'',block_index=310015,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=4');
  INSERT INTO undolog VALUES(86,'DELETE FROM bet_matches WHERE rowid=2');
  INSERT INTO undolog VALUES(87,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=92278789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(88,'DELETE FROM debits WHERE rowid=15');
  INSERT INTO undolog VALUES(89,'DELETE FROM bets WHERE rowid=5');
  INSERT INTO undolog VALUES(90,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=91528789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(91,'DELETE FROM debits WHERE rowid=16');
  INSERT INTO undolog VALUES(92,'DELETE FROM bets WHERE rowid=6');
  INSERT INTO undolog VALUES(93,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731'',block_index=310016,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=5');
  INSERT INTO undolog VALUES(96,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3'',block_index=310017,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=6');
  INSERT INTO undolog VALUES(99,'DELETE FROM bet_matches WHERE rowid=3');
  INSERT INTO undolog VALUES(100,'DELETE FROM broadcasts WHERE rowid=19');
  INSERT INTO undolog VALUES(101,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=90878789176 WHERE rowid=1');
  INSERT INTO undolog VALUES(102,'DELETE FROM credits WHERE rowid=16');
  INSERT INTO undolog VALUES(103,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b_b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468'',tx0_index=13,tx0_hash=''e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b'',tx0_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx1_index=14,tx1_hash=''b5358a0a36b5be9ff6a7d374407e538dd4f76663a5a3bc03051a073b9fe70468'',tx1_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''pending'' WHERE rowid=1');
  INSERT INTO undolog VALUES(107,'DELETE FROM broadcasts WHERE rowid=20');
  INSERT INTO undolog VALUES(108,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=90941039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(109,'DELETE FROM credits WHERE rowid=18');
  INSERT INTO undolog VALUES(110,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=91100339176 WHERE rowid=1');
  INSERT INTO undolog VALUES(111,'DELETE FROM credits WHERE rowid=19');
  INSERT INTO undolog VALUES(112,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e_5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97'',tx0_index=15,tx0_hash=''ce19bf304fa79644cb600836b8c324d72951dfb9040cf56b7d86199b55161a5e'',tx0_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx1_index=16,tx1_hash=''5b10e4b2781970605ca39972a349d2e4c7d73257bb0258833c3997756d166d97'',tx1_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx0_bet_type=0,tx1_bet_type=1,feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''pending'' WHERE rowid=2');
  INSERT INTO undolog VALUES(116,'DELETE FROM broadcasts WHERE rowid=21');
  INSERT INTO undolog VALUES(117,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=91441039176 WHERE rowid=1');
  INSERT INTO undolog VALUES(118,'DELETE FROM credits WHERE rowid=21');
  INSERT INTO undolog VALUES(119,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731_937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3'',tx0_index=17,tx0_hash=''4aa27a3686ae9f569ed8f5e24e7a63e619771142fc15c95a1cccb9adaf904731'',tx0_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx1_index=18,tx1_hash=''937e116bb67ee578f3b90f1b9bb0e209ed688149344e7167ccd89ccaa0f09ea3'',tx1_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',tx0_bet_type=2,tx1_bet_type=3,feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''pending'' WHERE rowid=3');
  INSERT INTO undolog VALUES(123,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''BBBB'',quantity=996000000 WHERE rowid=3');
  INSERT INTO undolog VALUES(124,'DELETE FROM debits WHERE rowid=17');
  INSERT INTO undolog VALUES(125,'DELETE FROM orders WHERE rowid=3');
  INSERT INTO undolog VALUES(126,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',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=''e89634665e78a20c2c252491e05f6ac1799168331aa164103158d064c0a2294b'',block_index=310012,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',feed_address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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=5000000,status=''open'' WHERE rowid=1');
  INSERT INTO undolog VALUES(130,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''XCP'',quantity=149840926438 WHERE rowid=1');
  INSERT INTO undolog VALUES(131,'DELETE FROM credits WHERE rowid=24');
  INSERT INTO undolog VALUES(132,'DELETE FROM bet_expirations WHERE rowid=13');
  INSERT INTO undolog VALUES(133,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',asset=''BBBC'',quantity=99474 WHERE rowid=4');
  INSERT INTO undolog VALUES(134,'DELETE FROM debits WHERE rowid=18');
  INSERT INTO undolog VALUES(135,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mqPCfvqTfYctXMUfmniXeG2nyaN8w6tPmj_3'',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=24');
  INSERT INTO undolog VALUES(138,'UPDATE orders SET tx_index=22,tx_hash=''e098ae15731b482ab8194879ff9db73abdeb80bd4befb5a94400d02b8b5f28c5'',block_index=310021,source=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',give_asset=''BBBB'',give_quantity=50000000,give_remaining=50000000,get_asset=''XCP'',get_quantity=50000000,get_remaining=50000000,expiration=10,expire_index=310031,fee_required=0,fee_required_remaining=0,fee_provided=6800,fee_provided_remaining=6800,status=''open'' WHERE rowid=3');
  INSERT INTO undolog VALUES(139,'UPDATE balances SET address=''2_mn6q3dS2EnDUx3bmyWc6D4szJNVGtaR7zc_mnfAHmddVibnZNSkh8DvKaQoiEfNsxjXzH_mtQheFaSfWELRB2MyMBaiWjdDm6ux9Ezns_3'',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;
  