<commit_before>create database if not exists tieba;
use tieba;

create table if not exists user (
    user_id int not null auto_increment,
    user_name char(128) not null unique,
    tieba_name char(128) default '',
    admin_type enum('none', 'admin', 'little_admin', 'img_admin') default 'none',
    following_num smallint default 0,
    followed_num smallint default 0,
    primary key (user_id)
)default charset=utf8;<commit_msg>create: following and followed tables among users, user-managing-tieba table<commit_after>create database if not exists tieba;
use tieba;

create table if not exists user (
    id int not null auto_increment,
    name char(128) not null unique,
    admin_type enum('none', 'admin', 'little_admin', 'img_admin') default 'none',
    following_num smallint default 0,
    followed_num smallint default 0,
    primary key (id)
)default charset=utf8;

create table if not exists tieba (
    id int not null auto_increment,
    name char(128) not null unique,
    followed_num int default 0,
    admin_num smallint default 0,
    slogan char(128) default '',
    belong_dir char(128) default '',
    primary key (id)
)default charset=utf8;

create table if not exists user_follow_tieba (
    user_id int not null,
    tieba_id int not null,
    primary key (user_id, tieba_id)
)default charset=utf8;

create table if not exists user_manage_tieba (
    user_id int not null,
    tieba_id int not null,
    primary key (user_id, tieba_id)
)default charset=utf8;

create table if not exists user_follow_user (
    from_user_id int not null,
    to_user_id int not null,
    primary key (from_user_id, to_user_id)
)default charset=utf8;

create table if not exists user_followed_user (
    from_user_id int not null,
    to_user_id int not null,
    primary key (from_user_id, to_user_id)
)default charset=utf8;

{'fraction_non_alphanumeric': 0.0724400871459695, 'fraction_numerical': 0.016884531590413945, 'mean_word_length': 4.088642659279778, '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': '2682992', 'n_tokens_mistral': 611, 'n_tokens_neox': 583, 'n_words': 213}