<commit_before>-- jobs table
-- Stores job and machine Classad information about each HTCondor job
CREATE TABLE IF NOT EXISTS `jobs` (
    `id` INT(9) UNSIGNED AUTO_INCREMENT NOT NULL,
    `cluster` INT(9) NOT NULL,
    `process` INT(9) NOT NULL,
    `user` VARCHAR(30) NOT NULL,
    `group` VARCHAR(30) NOT NULL,
    `start_date` TIMESTAMP NOT NULL,
    `cpu` INT(4) NOT NULL,
    `cpu_unit` CHAR(5) DEFAULT "count",
    `memory` INT(6) NOT NULL,
    `memory_unit` CHAR(3) DEFAULT "MiB"
    `disk` INT(6) NOT NULL,
    `disk_unit` CHAR(3) DEFAULT "KiB",
    `host` VARCHAR(30) NOT NULL,
    `universe` VARCHAR(30) NOT NULL,
    `exe` VARCHAR(100) NOT NULL,
    `transfer` TINYINT(1) NOT NULL,
    PRIMARY KEY (id)
);
-- Create indexes
CREATE INDEX index_jobs ON jobs(cluster, process);
CREATE INDEX index_users ON jobs(user);<commit_msg>Fixed typo in schema<commit_after>-- jobs table
-- Stores job and machine Classad information about each HTCondor job
CREATE TABLE IF NOT EXISTS `jobs` (
    `id` INT(9) UNSIGNED AUTO_INCREMENT NOT NULL,
    `cluster` INT(9) NOT NULL,
    `process` INT(9) NOT NULL,
    `user` VARCHAR(30) NOT NULL,
    `group` VARCHAR(30) NOT NULL,
    `start_date` TIMESTAMP NOT NULL,
    `cpu` INT(4) NOT NULL,
    `cpu_unit` CHAR(5) DEFAULT "count",
    `memory` INT(6) NOT NULL,
    `memory_unit` CHAR(3) DEFAULT "MiB",
    `disk` INT(6) NOT NULL,
    `disk_unit` CHAR(3) DEFAULT "KiB",
    `host` VARCHAR(30) NOT NULL,
    `universe` VARCHAR(30) NOT NULL,
    `exe` VARCHAR(100) NOT NULL,
    `transfer` TINYINT(1) NOT NULL,
    PRIMARY KEY (id)
);
-- Create indexes
CREATE INDEX index_jobs ON jobs(cluster, process);
CREATE INDEX index_users ON jobs(user);
{'fraction_non_alphanumeric': 0.12648456057007126, 'fraction_numerical': 0.02494061757719715, 'mean_word_length': 3.6805555555555554, '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': '2544533', 'n_tokens_mistral': 641, 'n_tokens_neox': 592, 'n_words': 204}