<commit_before>/* Keeps track of account/address relationships */
CREATE TABLE IF NOT EXISTS ADDRESSES 
( 
    ROWID INTEGER PRIMARY KEY NOT NULL, 
    ACCOUNT VARCHAR(10) NOT NULL,
    ADDRESS VARCHAR(40) 
);

/* Stores persistent key/value pairs */
CREATE TABLE IF NOT EXISTS KEYVALUES 
( 
    ROWID INTEGER PRIMARY KEY NOT NULL,
    KEY VARCHAR(10) NOT NULL,
    VALUE VARCHAR(50) 
);

/* Stores details of receipt transactions */
CREATE TABLE IF NOT EXISTS RECEIPTS 
(
    ROWID INTEGER PRIMARY KEY NOT NULL,
    FROM_ADDRESS VARCHAR(40) NOT NULL, 
    AMOUNT INTEGER, /* amounts are stored in uHYP to avoid rounding errors */
    FOR_POOL VARCHAR(10),
    TRANSACTION_TIME INTEGER  /* unix timestamp */
);

/* Stores a list of txids we have already processed so we don't process stuff 
 * twice */
CREATE TABLE IF NOT EXISTS TRANSACTIONS
(
    ROWID INTEGER PRIMARY KEY NOT NULL,
    TXID VARCHAR(80)
);<commit_msg>Add sequence table<commit_after>/* Keeps track of account/address relationships */
CREATE TABLE IF NOT EXISTS ADDRESSES 
( 
    ROWID INTEGER PRIMARY KEY NOT NULL, 
    ACCOUNT VARCHAR(10) NOT NULL,
    ADDRESS VARCHAR(40) 
);

/* Stores persistent key/value pairs */
CREATE TABLE IF NOT EXISTS KEYVALUES 
( 
    ROWID INTEGER PRIMARY KEY NOT NULL,
    KEY VARCHAR(10) NOT NULL,
    VALUE VARCHAR(50) 
);

/* Stores details of receipt transactions */
CREATE TABLE IF NOT EXISTS RECEIPTS 
(
    ROWID INTEGER PRIMARY KEY NOT NULL,
    FROM_ADDRESS VARCHAR(40) NOT NULL, 
    AMOUNT INTEGER, /* amounts are stored in uHYP to avoid rounding errors */
    FOR_POOL VARCHAR(10),
    TRANSACTION_TIME INTEGER  /* unix timestamp */
);

/* Stores a list of txids we have already processed so we don't process stuff 
 * twice */
CREATE TABLE IF NOT EXISTS TRANSACTIONS
(
    ROWID INTEGER PRIMARY KEY NOT NULL,
    TXID VARCHAR(80)
);

CREATE TABLE IF NOT EXISTS SEQUENCE 
(
    SEQ_NAME VARCHAR(50) PRIMARY KEY NOT NULL, 
    SEQ_COUNT INTEGER
);
{'fraction_non_alphanumeric': 0.07048008171603677, 'fraction_numerical': 0.015321756894790603, 'mean_word_length': 3.2960526315789473, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3222420', 'n_tokens_mistral': 682, 'n_tokens_neox': 569, 'n_words': 242}