<commit_before>CREATE TABLE job(
     id SERIAL PRIMARY KEY,
     description TEXT NOT NULL,
     user_name TEXT NOT NULL,
     calculation_mode TEXT NOT NULL,
     hazard_calculation_id INTEGER REFERENCES job (id) ON DELETE CASCADE,
     status TEXT NOT NULL DEFAULT 'created',
     is_running BOOL NOT NULL DEFAULT false,
     start_time TIMESTAMP NOT NULL DEFAULT timezone('UTC', now()),
     stop_time TIMESTAMP,
     relevant BOOL DEFAULT true,
     ds_calc_dir TEXT NOT NULL);
GRANT ALL ON job TO oq_job_init;
GRANT USAGE ON job_id_seq TO oq_job_init;


CREATE TABLE log(
     id SERIAL PRIMARY KEY,
     job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     timestamp TIMESTAMP NOT NULL,
     level TEXT NOT NULL,
     process TEXT NOT NULL,
     message TEXT NOT NULL);   
GRANT ALL ON log TO oq_job_init;
GRANT USAGE ON log_id_seq TO oq_job_init;


CREATE TABLE output(
     id SERIAL PRIMARY KEY,     
     oq_job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     display_name TEXT NOT NULL,
     last_update TIMESTAMP NOT NULL DEFAULT timezone('UTC', now()),
     ds_key TEXT NOT NULL);
GRANT ALL ON output TO oq_job_init;
GRANT USAGE ON output_id_seq TO oq_job_init;


CREATE TABLE performance(
     id SERIAL PRIMARY KEY,
     job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     operation TEXT NOT NULL,
     time_sec FLOAT NOT NULL,
     memory_mb FLOAT NOT NULL,
     counts INTEGER NOT NULL);

GRANT ALL ON performance TO oq_job_init;
GRANT USAGE ON performance_id_seq TO oq_job_init;
<commit_msg>Removed a blank lines<commit_after>CREATE TABLE job(
     id SERIAL PRIMARY KEY,
     description TEXT NOT NULL,
     user_name TEXT NOT NULL,
     calculation_mode TEXT NOT NULL,
     hazard_calculation_id INTEGER REFERENCES job (id) ON DELETE CASCADE,
     status TEXT NOT NULL DEFAULT 'created',
     is_running BOOL NOT NULL DEFAULT false,
     start_time TIMESTAMP NOT NULL DEFAULT timezone('UTC', now()),
     stop_time TIMESTAMP,
     relevant BOOL DEFAULT true,
     ds_calc_dir TEXT NOT NULL);
GRANT ALL ON job TO oq_job_init;
GRANT USAGE ON job_id_seq TO oq_job_init;


CREATE TABLE log(
     id SERIAL PRIMARY KEY,
     job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     timestamp TIMESTAMP NOT NULL,
     level TEXT NOT NULL,
     process TEXT NOT NULL,
     message TEXT NOT NULL);   
GRANT ALL ON log TO oq_job_init;
GRANT USAGE ON log_id_seq TO oq_job_init;


CREATE TABLE output(
     id SERIAL PRIMARY KEY,     
     oq_job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     display_name TEXT NOT NULL,
     last_update TIMESTAMP NOT NULL DEFAULT timezone('UTC', now()),
     ds_key TEXT NOT NULL);
GRANT ALL ON output TO oq_job_init;
GRANT USAGE ON output_id_seq TO oq_job_init;


CREATE TABLE performance(
     id SERIAL PRIMARY KEY,
     job_id INTEGER NOT NULL REFERENCES job (id) ON DELETE CASCADE,
     operation TEXT NOT NULL,
     time_sec FLOAT NOT NULL,
     memory_mb FLOAT NOT NULL,
     counts INTEGER NOT NULL);
GRANT ALL ON performance TO oq_job_init;
GRANT USAGE ON performance_id_seq TO oq_job_init;

{'fraction_non_alphanumeric': 0.04549823774431272, 'fraction_numerical': 0.0, 'mean_word_length': 3.3542538354253835, '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': '2138383', 'n_tokens_mistral': 1052, 'n_tokens_neox': 991, 'n_words': 407}