<commit_before>
CREATE TABLE IF NOT EXISTS search_count (id64 BIGINT UNSIGNED, ip VARCHAR(200));

CREATE TABLE IF NOT EXISTS profiles (id64 BIGINT UNSIGNED PRIMARY KEY,
                                     vanity TEXT,
                                     profile BLOB,
                                     timestamp INTEGER,
                                     bp_views INTEGER UNSIGNED NOT NULL DEFAULT 0);

CREATE TABLE IF NOT EXISTS items (id64 BIGINT UNSIGNED PRIMARY KEY,
                                  oid64 BIGINT UNSIGNED,
                                  owner BIGINT UNSIGNED,
                                  sid INTEGER UNSIGNED,
                                  level TINYINT UNSIGNED,
                                  untradeable BOOLEAN,
                                  token INTEGER UNSIGNED,
                                  quality TINYINT UNSIGNED,
                                  custom_name VARCHAR(40),
                                  custom_desc VARCHAR(80),
                                  style TINYINT UNSIGNED,
                                  quantity INTEGER UNSIGNED DEFAULT 1);

CREATE TABLE IF NOT EXISTS attributes (id64 BIGINT UNSIGNED PRIMARY KEY, attrs BLOB NOT NULL, contents BLOB);

CREATE TABLE IF NOT EXISTS backpacks (id64 BIGINT UNSIGNED, backpack BLOB, timestamp INTEGER UNSIGNED, INDEX (id64, timestamp));

CREATE TABLE IF NOT EXISTS sessions (session_id CHAR(128) UNIQUE NOT NULL, atime timestamp NOT NULL default current_timestamp, data TEXT);<commit_msg>Further optimize schema with NOT NULL<commit_after>
CREATE TABLE IF NOT EXISTS search_count (id64 BIGINT UNSIGNED NOT NULL, ip VARCHAR(200) NOT NULL);

CREATE TABLE IF NOT EXISTS profiles (id64 BIGINT UNSIGNED PRIMARY KEY,
                                     vanity TEXT,
                                     profile BLOB NOT NULL,
                                     timestamp INTEGER NOT NULL,
                                     bp_views INTEGER UNSIGNED NOT NULL DEFAULT 0);

CREATE TABLE IF NOT EXISTS items (id64 BIGINT UNSIGNED PRIMARY KEY,
                                  oid64 BIGINT UNSIGNED,
                                  owner BIGINT UNSIGNED NOT NULL,
                                  sid INTEGER UNSIGNED NOT NULL,
                                  level TINYINT UNSIGNED NOT NULL,
                                  untradeable BOOLEAN NOT NULL,
                                  token INTEGER UNSIGNED NOT NULL,
                                  quality TINYINT UNSIGNED NOT NULL,
                                  custom_name VARCHAR(40),
                                  custom_desc VARCHAR(80),
                                  style TINYINT UNSIGNED,
                                  quantity INTEGER UNSIGNED DEFAULT 1 NOT NULL);

CREATE TABLE IF NOT EXISTS attributes (id64 BIGINT UNSIGNED PRIMARY KEY, attrs BLOB NOT NULL, contents BLOB);

CREATE TABLE IF NOT EXISTS backpacks (id64 BIGINT UNSIGNED NOT NULL, backpack BLOB NOT NULL,
                                      timestamp INTEGER UNSIGNED NOT NULL, INDEX (id64, timestamp));

CREATE TABLE IF NOT EXISTS sessions (session_id CHAR(128) UNIQUE NOT NULL, atime timestamp NOT NULL default current_timestamp, data TEXT);
{'fraction_non_alphanumeric': 0.03407682775712516, 'fraction_numerical': 0.0161090458488228, 'mean_word_length': 1.3263688760806915, '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': 31, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3582645', 'n_tokens_mistral': 860, 'n_tokens_neox': 707, 'n_words': 296}