<commit_before>-- Table structure for table: users
CREATE TABLE users ( 
   name TEXT PRIMARY KEY, 
   password TEXT, 
   email TEXT, 
   public_key TEXT
);
CREATE INDEX users_email_idx ON users(email);


-- Table structure for table: rego_otk
CREATE TABLE rego_otk ( 
   name TEXT REFERENCES users, 
   otk TEXT );
CREATE INDEX rego_otk_name_idx ON rego_otk(name);


-- Table structure for table: journals
CREATE TABLE journals ( 
   name TEXT, 
   version TEXT, 
   action TEXT, 
   submitted_date TIMESTAMP, <commit_msg>Fix keyid field.<commit_after>-- Table structure for table: users
CREATE TABLE users ( 
   name TEXT PRIMARY KEY, 
   password TEXT, 
   email TEXT, 
   gpg_keyid TEXT
);
CREATE INDEX users_email_idx ON users(email);


-- Table structure for table: rego_otk
CREATE TABLE rego_otk ( 
   name TEXT REFERENCES users, 
   otk TEXT );
CREATE INDEX rego_otk_name_idx ON rego_otk(name);


-- Table structure for table: journals
CREATE TABLE journals ( 
   name TEXT, 
   version TEXT, 
   action TEXT, 
   submitted_date TIMESTAMP, 
{'fraction_non_alphanumeric': 0.06393129770992366, 'fraction_numerical': 0.0, 'mean_word_length': 3.444915254237288, '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': '1157108', 'n_tokens_mistral': 353, 'n_tokens_neox': 324, 'n_words': 120}