<commit_before>
    create table HAccount (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        apiKey varchar(32) binary,
        enabled bit not null,
        passwordHash varchar(255) binary,
        username varchar(255) binary,
        primary key (id),
        unique (username)
    ) ENGINE=InnoDB;

    create table HAccountActivationKey (
        keyHash varchar(32) binary not null,
        accountId bigint not null,
        primary key (keyHash),
        unique (accountId)
    ) ENGINE=InnoDB;

    create table HAccountMembership (
        accountId bigint not null,
        memberOf integer not null,
        primary key (accountId, memberOf)
    ) ENGINE=InnoDB;

    create table HAccountPermission (
        permissionId integer not null auto_increment,
        action varchar(255) binary,
        discriminator varchar(255) binary,
        recipient varchar(255) binary,
        target varchar(255) binary,
        primary key (permissionId)
    ) ENGINE=InnoDB;

    create table HAccountResetPasswordKey (
        keyHash varchar(32) binary not null,
        accountId bigint not null,
        primary key (keyHash),
        unique (accountId)
    ) ENGINE=InnoDB;

    create table HAccountRole (
        id integer not null auto_increment,
        conditional bit not null,
        name varchar(255) binary,
        primary key (id)
    ) ENGINE=InnoDB;

    create table HAccountRoleGroup (
        roleId integer not null,
        memberOf integer not null,
        primary key (roleId, memberOf)
    ) ENGINE=InnoDB;

    create table HCommunity (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        description varchar(100) binary,
        homeContent longtext,
        name varchar(255) binary not null,
        ownerId bigint not null,
        primary key (id),
        unique (slug)
    ) ENGINE=InnoDB;

    create table HCommunity_Member (
        communityId bigint not null,
        personId bigint not null,
        primary key (personId, communityId)
    ) ENGINE=InnoDB;

    create table HCommunity_Officer (
        communityId bigint not null,
        personId bigint not null,
        primary key (personId, communityId)
    ) ENGINE=InnoDB;

    create table HDocument (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        contentType varchar(255) binary not null,
        docId varchar(255) binary not null,
        locale varchar(255) binary not null,
        name varchar(255) binary not null,
        obsolete bit not null,
        path varchar(255) binary not null,
        revision integer not null,
        last_modified_by_id bigint,
        poHeader_id bigint,
        project_iteration_id bigint not null,
        primary key (id),
        unique (docId, project_iteration_id)
    ) ENGINE=InnoDB;

    create table HDocumentHistory (
        id bigint not null auto_increment,
        contentType varchar(255) binary not null,
        docId varchar(255) binary not null,
        lastChanged datetime,
        locale varchar(255) binary not null,
        name varchar(255) binary,
        obsolete bit not null,
        path varchar(255) binary,
        revision integer,
        document_id bigint,
        last_modified_by_id bigint,
        primary key (id),
        unique (document_id, revision)
    ) ENGINE=InnoDB;

    create table HFliesLocale (
        id varchar(80) binary not null,
        icuLocaleId varchar(255) binary not null,
        parentId varchar(80) binary,
        primary key (id)
    ) ENGINE=InnoDB;

    create table HFliesLocale_Friends (
        localeId varchar(80) binary not null,
        friendId varchar(80) binary not null
    ) ENGINE=InnoDB;

    create table HPerson (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        email varchar(255) binary not null,
        name varchar(80) binary not null,
        accountId bigint,
        primary key (id),
        unique (email)
    ) ENGINE=InnoDB;

    create table HPoHeader (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        entries longtext,
        comment_id bigint,
        document_id bigint unique,
        primary key (id),
        unique (document_id)
    ) ENGINE=InnoDB;

    create table HPoTargetHeader (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        entries longtext,
        targetLanguage varchar(255) binary not null,
        comment_id bigint,
        document_id bigint,
        primary key (id),
        unique (document_id, targetLanguage)
    ) ENGINE=InnoDB;

    create table HPotEntryData (
        id bigint not null auto_increment,
        context varchar(255) binary,
        flags varchar(255) binary,
        refs varchar(255) binary,
        comment_id bigint,
        tf_id bigint unique,
        primary key (id),
        unique (tf_id)
    ) ENGINE=InnoDB;

    create table HProject (
        projecttype varchar(31) binary not null,
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        description varchar(100) binary,
        homeContent longtext,
        name varchar(80) binary,
        primary key (id),
        unique (slug)
    ) ENGINE=InnoDB;

    create table HProjectIteration (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        active bit not null,
        description varchar(255) binary,
        name varchar(20) binary,
        parentId bigint,
        project_id bigint not null,
        primary key (id),
        unique (slug, project_id)<commit_msg>updated mysql schema (HProject.name cannot be null)<commit_after>
    create table HAccount (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        apiKey varchar(32) binary,
        enabled bit not null,
        passwordHash varchar(255) binary,
        username varchar(255) binary,
        primary key (id),
        unique (username)
    ) ENGINE=InnoDB;

    create table HAccountActivationKey (
        keyHash varchar(32) binary not null,
        accountId bigint not null,
        primary key (keyHash),
        unique (accountId)
    ) ENGINE=InnoDB;

    create table HAccountMembership (
        accountId bigint not null,
        memberOf integer not null,
        primary key (accountId, memberOf)
    ) ENGINE=InnoDB;

    create table HAccountPermission (
        permissionId integer not null auto_increment,
        action varchar(255) binary,
        discriminator varchar(255) binary,
        recipient varchar(255) binary,
        target varchar(255) binary,
        primary key (permissionId)
    ) ENGINE=InnoDB;

    create table HAccountResetPasswordKey (
        keyHash varchar(32) binary not null,
        accountId bigint not null,
        primary key (keyHash),
        unique (accountId)
    ) ENGINE=InnoDB;

    create table HAccountRole (
        id integer not null auto_increment,
        conditional bit not null,
        name varchar(255) binary,
        primary key (id)
    ) ENGINE=InnoDB;

    create table HAccountRoleGroup (
        roleId integer not null,
        memberOf integer not null,
        primary key (roleId, memberOf)
    ) ENGINE=InnoDB;

    create table HCommunity (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        description varchar(100) binary,
        homeContent longtext,
        name varchar(255) binary not null,
        ownerId bigint not null,
        primary key (id),
        unique (slug)
    ) ENGINE=InnoDB;

    create table HCommunity_Member (
        communityId bigint not null,
        personId bigint not null,
        primary key (personId, communityId)
    ) ENGINE=InnoDB;

    create table HCommunity_Officer (
        communityId bigint not null,
        personId bigint not null,
        primary key (personId, communityId)
    ) ENGINE=InnoDB;

    create table HDocument (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        contentType varchar(255) binary not null,
        docId varchar(255) binary not null,
        locale varchar(255) binary not null,
        name varchar(255) binary not null,
        obsolete bit not null,
        path varchar(255) binary not null,
        revision integer not null,
        last_modified_by_id bigint,
        poHeader_id bigint,
        project_iteration_id bigint not null,
        primary key (id),
        unique (docId, project_iteration_id)
    ) ENGINE=InnoDB;

    create table HDocumentHistory (
        id bigint not null auto_increment,
        contentType varchar(255) binary not null,
        docId varchar(255) binary not null,
        lastChanged datetime,
        locale varchar(255) binary not null,
        name varchar(255) binary,
        obsolete bit not null,
        path varchar(255) binary,
        revision integer,
        document_id bigint,
        last_modified_by_id bigint,
        primary key (id),
        unique (document_id, revision)
    ) ENGINE=InnoDB;

    create table HFliesLocale (
        id varchar(80) binary not null,
        icuLocaleId varchar(255) binary not null,
        parentId varchar(80) binary,
        primary key (id)
    ) ENGINE=InnoDB;

    create table HFliesLocale_Friends (
        localeId varchar(80) binary not null,
        friendId varchar(80) binary not null
    ) ENGINE=InnoDB;

    create table HPerson (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        email varchar(255) binary not null,
        name varchar(80) binary not null,
        accountId bigint,
        primary key (id),
        unique (email)
    ) ENGINE=InnoDB;

    create table HPoHeader (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        entries longtext,
        comment_id bigint,
        document_id bigint unique,
        primary key (id),
        unique (document_id)
    ) ENGINE=InnoDB;

    create table HPoTargetHeader (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        entries longtext,
        targetLanguage varchar(255) binary not null,
        comment_id bigint,
        document_id bigint,
        primary key (id),
        unique (document_id, targetLanguage)
    ) ENGINE=InnoDB;

    create table HPotEntryData (
        id bigint not null auto_increment,
        context varchar(255) binary,
        flags varchar(255) binary,
        refs varchar(255) binary,
        comment_id bigint,
        tf_id bigint unique,
        primary key (id),
        unique (tf_id)
    ) ENGINE=InnoDB;

    create table HProject (
        projecttype varchar(31) binary not null,
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        description varchar(100) binary,
        homeContent longtext,
        name varchar(80) binary not null,
        primary key (id),
        unique (slug)
    ) ENGINE=InnoDB;

    create table HProjectIteration (
        id bigint not null auto_increment,
        creationDate datetime not null,
        lastChanged datetime not null,
        versionNum integer not null,
        slug varchar(40) binary not null,
        active bit not null,
        description varchar(255) binary,
        name varchar(20) binary,
        parentId bigint,
        project_id bigint not null,
        primary key (id),
        unique (slug, project_id)
{'fraction_non_alphanumeric': 0.05582807755197384, 'fraction_numerical': 0.016974227205481585, 'mean_word_length': 2.2368951612903225, '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': '1870357', 'n_tokens_mistral': 3704, 'n_tokens_neox': 3411, 'n_words': 1220}