<commit_before>/*

desc user:
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(33) | YES  |     | NULL    |                |
| email | varchar(33) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

desc post:
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| post_id | int(11)      | NO   | PRI | NULL    | auto_increment |
| name    | varchar(100) | YES  |     | NULL    |                |
| user_id | int(11)      | YES  |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+

*/
create table user(
    id int primary key auto_increment, 
    name varchar(33), 
    email varchar(33)
); 

create table post(
    post_id int primary key auto_increment,
    name varchar(100), 
    user_id int
); 
<commit_msg>table type turn to :innodb<commit_after>/*

desc user:
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(33) | YES  |     | NULL    |                |
| email | varchar(33) | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

desc post:
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| post_id | int(11)      | NO   | PRI | NULL    | auto_increment |
| name    | varchar(100) | YES  |     | NULL    |                |
| user_id | int(11)      | YES  |     | NULL    |                |
+---------+--------------+------+-----+---------+----------------+

*/
create table user(
    id int primary key auto_increment, 
    name varchar(33), 
    email varchar(33)
); 

create table post(
    post_id int primary key auto_increment,
    name varchar(100), 
    user_id int
); 

ALTER TABLE user TYPE = innodb ;
ALTER TABLE post TYPE = innodb ;

{'fraction_non_alphanumeric': 0.39195775792038995, 'fraction_numerical': 0.016246953696181964, 'mean_word_length': 0.8057184750733137, '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': '2308762', 'n_tokens_mistral': 743, 'n_tokens_neox': 680, 'n_words': 152}