<commit_before>create table if not exists user (
    user_id integer unique primary key autoincrement,
    username text not null,
    pw_hash text not null
);

create table if not exists cmdq (
    cmd_id integer unique primary key autoincrement,
    data text not null
);

create table if not exists io (
    io_id integer unique primary key autoincrement,
    type integer not null,
    bus integer not null,
    addr integer not null
);

create table if not exists interface (
    interface_id integer unique primary key autoincrement,
    type integer not null,
    io_id integer not null,
    slot integer not null,
    data text not null
);

create table if not exists log (
    log_id integer unique primary key autoincrement,
    error integer not null,
    alarm integer not null,
    message text not null,
    log_time integer not null
);

create table if not exists action (
    action_id integer unique primary key autoincrement,
    code_hash text not null,
    command text not null,
    reason text not null
);

create table if not exists indicator (
    indicator_id integer unique primary key autoincrement,
    interface_id integer not null,
    state integer not null
);

create table if not exists state (
    key text unique primary key,
    data text not null,
    state_time integer not null
);<commit_msg>allow state cols to be null<commit_after>create table if not exists user (
    user_id integer unique primary key autoincrement,
    username text not null,
    pw_hash text not null
);

create table if not exists cmdq (
    cmd_id integer unique primary key autoincrement,
    data text not null
);

create table if not exists io (
    io_id integer unique primary key autoincrement,
    type integer not null,
    bus integer not null,
    addr integer not null
);

create table if not exists interface (
    interface_id integer unique primary key autoincrement,
    type integer not null,
    io_id integer not null,
    slot integer not null,
    data text not null
);

create table if not exists log (
    log_id integer unique primary key autoincrement,
    error integer not null,
    alarm integer not null,
    message text not null,
    log_time integer not null
);

create table if not exists action (
    action_id integer unique primary key autoincrement,
    code_hash text not null,
    command text not null,
    reason text not null
);

create table if not exists indicator (
    indicator_id integer unique primary key autoincrement,
    interface_id integer not null,
    state integer not null
);

create table if not exists state (
    key text unique primary key,
    data text,
    state_time integer
);
{'fraction_non_alphanumeric': 0.03611738148984198, 'fraction_numerical': 0.0, 'mean_word_length': 3.180817610062893, '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': '7603206', 'n_tokens_mistral': 695, 'n_tokens_neox': 696, 'n_words': 359}